tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 166430d1341584468-excel-2007-calculations-on-a-cell-containing-hours-and-minutes-timesheetexample
Sheet: Sheet1

Whatever National Bank
Contractor Monthly Time Report
Consultant: |  | [NAME] |  |  |  |  |  |  |  | Time Period (mm/yy):04/09
 |  | Date
 | 2009-04-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Start Time | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
End Time | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 |  |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00
Unbillable Time
Billable Time
Project #
 |  | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Start Time |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
End Time |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 |  |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00
Unbilliabe Time
Billiable Time
 |  |  |  |  |  |  |  |  |  |  |  | Total hours worked in month :
Project #
 |  | Date
Spreadsheet: 889136d1739865724-filter-formula-filter-for-several-criteria-array-in-another-array-extended-function-exampleproblem-filter_extended
Sheet: Sheet1

Cable name | Cable from | Cable to | Note
 |  |  |  |  |  | Search terms (if I know only parts of what I want to search) | Search terms (if I know only parts of what I want to search) |  |  | OriginA | DestinationA | test1
 | OriginA | DestinationA | test1 |  |  | (To filter by column A) | (To filter by column D) |  | OriginA-DestinationS | OriginA | DestinationS | test2
 | OriginA | DestinationS | test2 |  |  | OriginA* | test2 |  | OriginA-DestinationT | OriginA | DestinationT | test1
 | OriginA | DestinationT | test1
 | OriginB | DestinationB | test1
 | OriginC | DestinationC | test1
 | OriginD | DestinationD | test1
 | OriginE | DestinationE | test1
 | OriginF | DestinationF | test1 |  |  |  | How do I have to modify the formula in J2 to add a filter function for column D3:D25, allowing me to filter further down as per strings in H4 to H8?
 | OriginG | DestinationG | test2
 | OriginH | DestinationH | test3
 | OriginI | DestinationI | test4
 | OriginJ | DestinationJ | test4
 | OriginK | DestinationK | test4
 | OriginL | DestinationL | test4
 | OriginL | [NAME] | test4
 | OriginM | DestinationM | test4
 | OriginN | DestinationN | test4
 | OriginO | DestinationO | test5
 | [NAME] | DestinationP | test5
 | [NAME] | DestinationV | test5
 | [NAME] | DestinationW | test5
 | OriginQ | DestinationQ | test5
 | OriginR | DestinationR | test5
Spreadsheet: 678430d1589886772-generate-array-of-integers-example
Sheet: Formulas

15
Spreadsheet: barry_tycholiz__848__2002 Plan Worksheet CC107322
Sheet: Income Statement (2)

Income Statement - ($000s)
 |  |  | 2001 Forecast |  | 2002 Plan |  | [NAME]
Originations |  | $ |  | $ |  | $
Trading
FV-Investments
Accrual
Operating Expenses
Other
Total Margin |  | $ |  | $ |  | $
Capital Charge
Total Margin Net of Capital Charge |  | $ |  | $ |  | $
Compensation/Taxes and Benefits
Employee Expense
Travel/Entertainment
Consulting
Office
Controllable Infrastructure
System Development
Insurance
Analyst Associates (includes Comp, Taxes & Benefits and Allocation)
Other Expense
Outside Legal
Outside Tax
Depreciation & Amortization
Total Direct Expenses |  | $ |  | $ |  | $
Pre-Tax Income |  | $ |  | $ |  | $
Headcount
Executive |  |  | 1 |  | 1
Director |  |  | 1 |  | 2
Manager |  |  | 0
Analyst and Associates |  |  | 1
Support Departments
Total Headcount
2002 Plan (in thousands) |  |  | Team |  |  |  | ENA Total
Direct Expense (People + Office)/Headcount Ratio |  | $ |  |  |  | $
Productivity [NAME] |  | $ |  |  |  | $
ROCE
Spreadsheet: 4052f3c6-c29d-4832-b508-336a19985d00
Sheet: Electricity

 |  | [NAME] | 2696 | Ft2 |  |  |  |  |  |  | Existing |  | Proposed
 |  |  |  |  |  |  |  |  |  |  | Heat Loss Line |  | Heat Loss Line |  | 0.5 | Est. Savings
 |  | Average kW = | [kWh/Month] / ([Days] x 24 Hr/Day) |  |  |  |  |  |  |  | [NAME]. | Avg. kW | [NAME]. | Avg. kW
 |  |  |  |  |  |  |  |  |  |  | 27 | 7 | 27
 |  | Average Watts/Ft2 = | 1000 W/kW x [[NAME]. kW] / [Sq. Footage] |  |  |  |  |  |  |  | 63 | 1.7
[NAME] |  |  |  |  |  |  |  |  |  |  | Intercept
Electricity Bill Information |  |  | Calculated Values |  |  |  |  |  |  |  | Slope
From Date | To Date | kWh /Month | Days | Average Temp | Average kW | Avg. Watts /Ft2 | Month | Year | kWh /Month |  | [NAME] (kW) | Proposed Ductless HP Heat Line (kW) | Predicted Monthly Savings (kWh) | LINEST Function
2010-04-10 | 2010-05-11 | 2794 |  |  |  |  |  |  | 1750
2010-05-12 | 2010-06-09 | 1938 |  |  |  |  |  |  | 2225
2010-06-10 | 2010-07-14 | 2096 |  |  |  |  |  |  | 2025
2010-07-15 | 2010-08-09 | 2381 |  |  |  |  |  |  | 1750
2010-08-10 | 2010-09-09 | 2072 |  |  |  |  |  |  | 2225
2010-09-10 | 2010-10-11 | 1722 |  |  |  |  |  |  | 2025
2010-10-12 | 2010-11-08 | 2706 |  |  |  |  |  |  | 2125
2010-11-09 | 2010-12-09 | 5266 |  |  |  |  |  |  | 2325
2010-12-10 | 2011-01-10 | 6076 |  |  |  |  |  |  | 2675
2011-01-11 | 2011-02-08 | 4980 |  |  |  |  |  |  | 4725
2011-02-09 | 2011-03-10 | 4977 |  |  |  |  |  |  | 5400
2011-03-11 | 2011-04-11 | 3990 |  |  |  |  |  |  | 4250
2011-04-12 | 2011-05-09 | 3026 |  |  |  |  |  |  | 4425
2011-05-10 | 2011-06-08 | 1786 |  |  |  |  |  |  | 3475
2011-06-09 | 2011-07-13 | 1547 |  |  |  |  |  |  | 2475
2011-07-14 | 2011-08-09 | 1284 |  |  |  |  |  |  | 1750
2011-08-10 | 2011-09-09 | 1584 |  |  |  |  |  |  | 2175
2011-09-10 | 2011-10-10 | 1935 |  |  |  |  |  |  | 1825
2011-10-11 | 2011-11-08 | 3310 |  |  |  |  |  |  | 2200
2011-11-09 | 2011-12-08 | 5337 |  |  |  |  |  |  | 2050
2011-12-09 | 2012-01-10 | 6645 |  |  |  |  |  |  | 2100
2012-01-11 | 2012-02-09 | 5664 |  |  |  |  |  |  | 2650
2012-02-10 | 2012-03-13 | 5153 |  |  |  |  |  |  | 4125
2012-03-14 | 2012-04-10 | 3467 |  |  |  |  |  |  | 3825
40869 | 40933
 | A | B | C | D
 |  | -17.05532020824618 | 6.934234067677417 | 70.63968329333053
 | 3.374170798013016 | -17.05532020824618 | 6.934234067677417 | 70.63968329333053
 | 3.374170798013016 | -17.05532020824618 | 6.934234067677417 | 70.63968329333053
 | 3.374170798013016 | -17.05532020824618 | 6.934234067677417 | 70.63968329333053
 | 3.374170798013016 | -17.05532020824618 | 6.934234067677417 | 70.63968329333053
Spreadsheet: 731569d1620413700-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: PPT

S.N. | Particulars | Bought  Units | Unit or PPT Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | Populous @ KuCoin - Purchase | 9.54639772 | 0.00688867 |  | -0.06582748 | 9221.1 | 2018-02-03 00:00:00 | 2018-02-03 00:00:00
2 | Fees for transferring 9.54639772 PPT from Kucoin to Binance | -0.1 |  |  |  |  | 2018-03-05 00:00:00
3 | Populous @ KuCoin - Sale |  | 0.0018525 |  | 0.01747011 | 11627.57 | 2018-03-05 00:00:00
4
5
6
7
8
9
10
 | Populous in Ledger Nano S | 0
 | Populous in Binance | 0.006594
 | Populous in KuCoin | 0
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 736629d1623768770-working-out-days-between-between-dates-date-picker-without-vb-feedback-and-change-form-2
Sheet: Form1

ID | Start time | Completion time | Reason for Change | Days open | Date Closed
18 | 2021-06-10 16:05:32 | 2021-06-10 16:06:49 | incorrect BOM |  | 2021-06-15 00:00:00
19 | 2021-06-15 09:12:03 | 2021-06-15 09:21:32 | Quality Concern
20 | 2021-06-15 09:23:20 | 2021-06-15 09:26:30 | Missing SOP
21 | 2021-06-15 09:45:30 | 2021-06-15 09:52:01 | Incorrect or missing Images
22 | 2021-06-15 09:54:31 | 2021-06-15 09:55:15 | Incorrect or missing Instructions
23 | 2021-06-15 09:55:30 | 2021-06-15 10:07:34 | Incorrect or missing Instructions
24 | 2021-06-15 10:09:13 | 2021-06-15 10:23:02 | Incorrect or missing Instructions
25 | 2021-06-15 10:23:16 | 2021-06-15 10:37:48 | Incorrect or missing Instructions
26 | 2021-06-15 10:37:53 | 2021-06-15 10:51:33 | Incorrect or missing Instructions
Spreadsheet: 71817d1272531400-countif-countif
Sheet: Sheet1

Company Name | Name | I Want This answer
IJM (India) Infrastructure Ltd | Mr [NAME] | 1
SVS  Wires Pvt Ltd | Mr [NAME] | 1
SVS  Wires Pvt Ltd | Mr [NAME] | 2
SVS  Wires Pvt Ltd | Mr [NAME] | 3
MPR Refractories Ltd | Mr [NAME] | 1
Fleming Laboratories Ltd | Mr [NAME] | 1
Yashoda Hospital | Mr [NAME] | 1
Yashoda Hospital | Mr [NAME] | 2
Versant Technologies Pvt Ltd (CBizOne India) | Mr [NAME] | 1
Bodhtree Consulting Ltd | Mr [NAME] | 1
Deccan Chronicle Holdings Ltd | Mr [NAME] | 1
Learnsmart India Pvt Ltd(24*7guru.com) | Mr [NAME] | 1
Pressmart Media Ltd | Mr [NAME] | 1
Brainstorm Technologies | Mr [NAME] | 1
Yaaganti Seeds Pvt Ltd | Mr [NAME] | 1
Yaaganti Seeds Pvt Ltd | Mr [NAME] | 2
Yaaganti Seeds Pvt Ltd | Mr [NAME] | 3
Yaaganti Seeds Pvt Ltd | Mr [NAME] | 4
Sri Vajra Granites Ltd (SVGL) | Mr [NAME] | 1
Sri Vajra Granites Ltd (SVGL) | Mr [NAME] | 2
Sri Vajra Granites Ltd (SVGL) | Mr [NAME] | 3
Filatex Fashions Ltd | Mr [NAME] | 1
Filatex Fashions Ltd | Mr [NAME] | 2
Praxis I-Technologies Pvt Ltd | Mr [NAME] | 1
Praxis I-Technologies Pvt Ltd | Mr [NAME] | 2
Praxis I-Technologies Pvt Ltd | Mr [NAME] | 3
Ultimate Hospitality Services Pvt Ltd | Mr [NAME] | 1
Ultimate Hospitality Services Pvt Ltd | Mr [NAME] | 2
Spreadsheet: d048f1ea-579e-4c14-a449-4fd81cbd7a81
Sheet: Sheet1

WHITEFISH BULLDOGS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | NORTHWESTERN MONTANA 'A' BASKETBALL | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
@ COLUMBIA FALLS | US | THEM |  | SUBMIT ASAP (PREFERABLY BY FOLLOWING MONDAY)
SCORE: | 22 | 50
2010-02-12 00:00:00 | L |  |  | mailto:[EMAIL]
PLAYER | PLAY | 3PT MAD | 3PT ATM | 3PT % | 2PT MAD | 2PT ATM | 2PT % | TOT FG | TOT FG % | FTM | FTA | FT % | TOT PTS | O REB | D REB | TOT RB | BLK | CHRG | STEAL | TOVR | ASST | FOUL
[NAME] | 1 | 1 | 3 | 0.3333333333333333 | 0 | 6 | 0 | 1 | 0.1111111111111111 | 0 | 0 |  | 3 | 0 | 1 | 1 |  |  | 1 | 2 | 1 | 3
[NAME] | 1 |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
[NAME] | 1 | 0 | 1 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 1 |  |  |  | 3 |  | 1
[NAME] | 1 | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 | 1 | 1 |  |  |  | 1
Heather Bailey12 | 1 | 0 | 0 |  | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 2 | 3 |  |  | 1 | 3 | 1 | 4
Olivia Curtiss12 | 1 | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 3 | 6 | 0.5 | 3 | 3 | 3 | 6 | 1 |  | 1 | 2 |  | 4
Amanda Foley11 | 1 | 0 | 0 |  | 2 | 3 | 0.6666666666666666 | 2 | 0.6666666666666666 | 0 | 0 |  | 4 | 2 | 1 | 3 |  |  | 1 | 1 |  | 0
Jessica Poe11 | 1 | 0 | 1 | 0 | 1 | 2 | 0.5 | 1 | 0.3333333333333333 | 0 | 0 |  | 2 | 1 | 2 | 3 |  |  | 1 | 1 | 1 | 2
[NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
Ashley O'Dell11 | 1 | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 | 1 | 1 |  |  | 1 | 2 | 1 | 2
[NAME] | 1 | 0 | 4 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 |  | 0 | 1 | 1 | 2 |  |  | 1 | 2 |  | 1
Brooke Silliker10 | 1 | 0 | 4 | 0 | 2 | 3 | 0.6666666666666666 | 2 | 0.2857142857142857 | 1 | 2 | 0.5 | 5 | 2 | 2 | 4 |  |  | 1 | 3 | 1 | 1
Simone Craft09 | 1 | 0 | 5 | 0 | 1 | 2 | 0.5 | 1 | 0.1428571428571428 | 1 | 2 | 0.5 | 3 | 1 | 1 | 2 |  |  | 1 | 3 | 1 | 0
[NAME] | 1 |  |  |  | 1 | 3 | 0.3333333333333333 | 1 | 0.3333333333333333 |  |  |  | 2 | 2 | 5 | 7 |  |  |  | 2 | 1
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
TOTALS | 1 | 1 | 19 | 0.05263157894736842 | 7 | 27 | 0.2592592592592592 | 8 | 0.1739130434782609 | 5 | 13 | 0.3846153846153846 | 22 | 13 | 21 | 34 | 1 | 0 | 9 | 25 | 7 | 18
Spreadsheet: 870790d1717232503-sumifs-substitute-2d_spill_1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Women
Country X | Bolly
Country X | Pumpkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 984
Country X | Chicken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9582
Country X | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 654
Country X | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50263
Country X | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.136
Country X | Tumbaktu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country X | Rhodoendron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
Country X | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3310
Country X | Pure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3575
Country X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country X Total | Total XXXXX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Bolly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Pumpkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Chicken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Tumbaktu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Rhodoendron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y | Pure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Country Y Total | Total XXXXX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 269431d1381158207-countif-and-adding-a-value-to-a-cell-on-criteria-met-0a222
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | This is the original and only counts the actual number of 10 accumulated hours, not over the number
 |  |  |  |  |  |  |  |  | over 10 add 7.5 |  |  |  |  |  | over 10 add 7.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | expected result 15
 |  |  | OUT |  |  | IN | 07:00:00 | OUT | 17:01:00 |  | IN | 07:00:00 | OUT | 17:01:00 |  | IN | 17:00:00 | OUT | 21:00:00 |  | IN | 12:00:00 | OUT | 21:30:00 |  | IN | 17:00:00 | OUT | 22:00:00 |  | IN | 13:00:00 | OUT | 16:00:00
 |  |  |  |  |  |  |  |  | over 10 add 7.5 |  |  |  |  |  | over 10 add 7.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | expected result 15
 |  |  | OUT |  |  | IN | 07:00:00 | OUT | 17:01:00 |  | IN | 07:00:00 | OUT | 17:01:00 |  | IN | 17:00:00 | OUT | 21:00:00 |  | IN | 12:00:00 | OUT | 21:30:00 |  | IN | 17:00:00 | OUT | 22:00:00 |  | IN | 13:00:00 | OUT | 16:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The goal is to add 7.5 each time the number in f8, k8, p8, u8, [NAME], ae8, and aj8 is over 10 hours
Spreadsheet: 220344d1363124873-index-match-play
Sheet: Summary

old tites and order |  |  |  |  |  | Total Mins | Ave Tasks / Pack | Ave Packs / Person | Ave Tasks / Person | Ave Packs / Person / Hour | Ave Tasks / Person / Hour | Total [NAME] | Processing / Labelling time |  | Total Jobs | Total Packs | Tasks Tasks | Total People | Total no of Hours |  | Total Mins | Ave Tasks / Pack | Ave Packs / Person | Ave Tasks / Person | Ave Packs / Person / Hour | Ave Tasks / Person / Hour | Total [NAME] | Processing / Labelling time | Total Jobs | Total Packs | Tasks Tasks | Total People | Total no of Hours
Assembly Room 1 | Range
 | Total Jobs | Total Packs | Total Tasks | Total [NAME] | Ave KPI | Total People | Total no of Hours | Total Mins | Ave Tasks / Pack | Ave Packs / Person | Ave Tasks / Person | Ave Packs / Person / Hour | Ave Tasks / Person / Hour | Processing / Labelling time | Total Jobs | Total Packs | Tasks Tasks | Total People | Total no of Hours | Totoal days
Wkly/Mntly Data
Daily Tot Data
Room | 1
 | Values
Row Labels | Total jobs | tot packs | Sum of Total Tasks | Sum of Total [NAME] | Average of KPI | Total People | Total no of Hours | Total Mins | Ave Tasks / Pack | Ave Packs / Person | Ave Tasks / Person | Ave Packs / Person / Hour | Ave Tasks / Person / Hour | Processing / Labelling time
2013-02-12 00:00:00 | 1 | 200 | 2410 | 122 | 19.75409836065574 |  |  |  |  |  |  |  |  |  |  | VLOOKUP(A11, peopleHours,2,FALSE)
2013-02-15 00:00:00 | 1 | 40 | 890 | 22 | 40.45454545454545
2013-02-18 00:00:00 | 1 | 50 | 510 | 36 | 14.16666666666667 |  |  |  |  |  |  |  |  |  |  | VLOOKUP(LEFT(N1,3),VLOOKUP(A1,TableKey,2,FALSE),2,TRUE)
2013-02-19 00:00:00 | 3 | 1004 | 36004 | 7 | 11994.66666666667
2013-02-21 00:00:00 | 1 | 50 | 510 | 36 | 14.16666666666667
2013-02-23 00:00:00 | 2 | 114 | 696 | 25 | 17.83333333333333
2013-02-24 00:00:00 | 1 | 21 | 199 | 3 | 66.33333333333333
2013-02-25 00:00:00 | 1 | 111 | 454 | 336 | 1.351190476190476
Spreadsheet: 869900d1716454372-athletic-spread-sheet-formulas-athletics-spreadsheet-jt-aligw
Sheet: Age Champ

 |  |  | AGE CHAMPS
 |  |  | STUDENT NAME | POINTS | HOUSE
AGE GROUP | GENDER
[NAME] | Boy | Winner
 |  | [NAME] Up
[NAME] | GIRL | Winner
9YRS | BOY
9YRS | GIRL | [NAME] Up
10YRS | BOY
10YRS | GIRL | Winner
11YRS | BOY
11YRS | GIRL | [NAME] Up
12YRS | BOY
12YRS | GIRL | Winner
 |  | [NAME] Up
Spreadsheet: 693093d1598756408-iferror-with-index-match-need-to-return-numeric-empty-cell-not-text-empty-cell-sample12345abc12
Sheet: Sheet1

Material | Data | Data 1
Silk
 |  |  |  |  |  | Silk | 4
 |  |  |  |  |  | [NAME] | 2
 |  |  |  |  |  | Cotton | 10
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 39085 | 35000
2 | 38663 | 35000
3 | 38140 | 35000
4 | 37343 | 35000
5 | 26604 | 35000
6 | 39621 | 35000
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 100916
2002-03-06 00:00:00
CBS Volume
 |  |  | 93375
Spreadsheet: 92741d1292299260-recognizing-input-patterns-from-sheet-to-sheet-with-linked-cells-numbers-example
Sheet: Data Input

 | Store 1 |  | Store 2 |  | Store 3
 | Gross | 1 | Gross | 19 | Gross | 37
 | Net | 2 | Net | 20 | Net | 38
 | Late Night | 3 | Late Night | 21 | Late Night | 39
 | Hours Allowed | 4 | Hours Allowed | 22 | Hours Allowed | 40
 | Adj. | 5 | Adj. | 23 | Adj. | 41
 | [NAME] | 0.06 | [NAME] | 0.24 | [NAME] | 0.42
 | Food % Act | 0.07 | Food % Act | 0.25 | Food % Act | 0.43
 | Late Night Hrs. | 8 | Late Night Hrs. | 26 | Late Night Hrs. | 44
 | Regular Hrs. | 9 | Regular Hrs. | 27 | Regular Hrs. | 45
 | +/- LY | 0.08 | +/- LY | 0.28 | +/- LY | 0.46
 | Maint $ | 11 | Maint $ | 29 | Maint $ | 47
 | Supply $ | 12 | Supply $ | 30 | Supply $ | 48
 | Cash +/- | 13 | Cash +/- | 31 | Cash +/- | 49
 | TLT | 14 | TLT | 32 | TLT | 50
 | N/H | 15 | N/H | 33 | N/H | 51
 | [NAME]. | 16 | [NAME]. | 34 | [NAME]. | 52
 | [NAME] | 17 | [NAME] | 35 | [NAME] | 53
 | Gr. Profit | 18 | Gr. Profit | 36 | Gr. Profit | 54
Spreadsheet: 1f8f7292-f106-4d24-a314-f7cdca6acd35
Sheet: Sheet1

Unnamed: 0 | BALLOTS CAST/SUMMARY BY COUNTIES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
2008-01-08 00:00:00 | Republican |  |  |  | Democratic
 | Regular | Absentee | Total |  | Regular | Absentee | Total
Belknap | 12202 | 915 | 13117 |  | 11893 | 719 | 12612
Carroll | 9797 | 855 | 10652 |  | 10092 | 798 | 10890
Cheshire | 11404 | 543 | 11947 |  | 18082 | 1142 | 19224
Coos | 4681 | 269 | 4950 |  | 7089 | 391 | 7480
[NAME] | 13802 | 823 | 14625 |  | 20205 | 1639 | 21844
Hillsborough | 70276 | 2815 | 73091 |  | 77385 | 3887 | 81272
Merrimack | 26959 | 1410 | 28369 |  | 33265 | 1735 | 35000
Rockingham | 57101 | 2777 | 59878 |  | 60260 | 2969 | 63229
[NAME] | 16619 | 753 | 17372 |  | 25858 | 1513 | 27371
[NAME] | 6705 | 333 | 7038 |  | 9255 | 495 | 9750
TOTALS | 229546 | 11493 | 241039 |  | 273384 | 15288 | 288672
*updated March 18, 2008
Spreadsheet: 98440d1297339410-unable-to-return-duplicate-value-example
Sheet: EX

OPN |  | CMD | FG
S29JL032H60TFI020H | 1 | -226 | 1191
S29JL032H60TFI020H | 2 | #N/A | 1191
S29JL032H70TFI010H | 1 | -17924 | 17588
S29JL032H70TFI020 | 2 | #N/A | 632
S29JL032H70TFI020 | 2 | #N/A | 632
S29JL032H70TFI020H | 1 | -12977 | 413
S29JL032H70TFI210H | 1 | -41220 | 10323
S29JL032H70TFI220 | 1 | #N/A | 37
S29JL032H70TFI320H | 1 | -2500 | 2515
S29JL032H70TFI410H | 1 | -100 | 919
S29JL032H70TFI410H | 2 | #N/A | 919
S29JL032H70TFI420 | 2 | #N/A | 71
S29JL032H70TFI420 | 2 | #N/A | 71
S29JL032H70TFI420H | 1 | -5202 | 0
S29JL032H70TFIG10H | 1 | -22000 | 16717
Spreadsheet: 127700d1320493226-adding-values-when-mulitple-criteria-countifs-or-sumproduct
Sheet: Sheet2

Company | Not Contracted | In Class
Spreadsheet: 886023d1735971906-pull-number-from-column-with-other-text-wildecoyote1966-sats-1-tms
Sheet: Sheet1

1d ago
+ 2 sats |  |  |  |  | 2 | 2 | 2 |  | Sats
1d ago
+ 4 sats |  |  |  |  | 4 | 4 | 4
1d ago
+ 4 sats |  |  |  |  | 4 | 4 | 4
2d ago
- 385 sats' |  |  |  |  | -385 | -385 | -385
2d ago
+ 4 sats |  |  |  |  | 4 | 4 | 4
2d ago
+ 4 sats |  |  |  |  | 4 | 4 | 4
2d ago
+ 15 sats |  |  |  |  | 15 | 15 | 15
 |  |  | =IFERROR(--TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1),LEN(A1))),"")
 |  |  |  | =IFERROR(SUBSTITUTE(SUBSTITUTE(A1," sats",""),"'","")+0,"")
 |  |  |  |  | =IFERROR(0+LEFT(A1:[NAME]:A14)-1),"")
 |  |  |  |  |  | =IFERROR(--SUBSTITUTE(TEXTBEFORE(A1:A14," sats")," ",""),"")
 |  |  |  |  |  |  | =IFERROR(--TRIM(TEXTBEFORE(A1:A14," sats")),"")