tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 788623d1658583055-pull-data-from-one-tab-to-another-automatically-by-criteria-sample
Sheet: B

Style | BBB |  |  |  | The first AAA,BBB,CCC (assumed as a style name) here
Material No. | Material Description | Qty |  |  | I need formula for that (just I write style name in B1 manualy
 | BBB-Size-126 |  |  |  | [NAME] automaticaly get here in Sheet B all the materials & descriptions of that style from the [NAME] sheet
140 | BBB-Size-200
150 | BBB-Size-S
160 | BBB-Size-M
170 | BBB-Size-2A
180 | BBB-Size-25
Spreadsheet: 78300d1278680096-if-function-on-multiple-levels-needed-test-kalkulation
Sheet: Test - Kalkulation

 | €/$ | 1.2267 | Fixation prescious metals & copper
 | Weight [tonnes] | 75
 | Unze - Gewicht | 0.0311034768
 | Parameters | LME | LME |  | Initial | Refining
 |  | Dollar | Euro | Recovery | deduction | charge
 |  | [$/Oz][$/to] | [€/Oz][€/to] |  | [g/t][kg/t] | [€/kg]
 | Copper |  | 5299
 | Gold | 1195 |  | 0.95 | 8
 | Silver | 17.85
 | Palladium | 450
 | Platin | 1525
 | Tin | 0
 | Total
 | Material value | Content | Accountable | Value | Value / to
 |  |  | Accountable | [€/batch] | [€/batch]
 | Copper [g/kg]
 | Gold [mg/kg] | 150
 | Silver [mg/kg]
 | Palladium [mg/kg]
 | Tin [g/kg]
 | Total material value  [€/ton]
 |  | Payable | 0.95
 |  | Interval g/DMT | >200
 |  | Payable | 0.96
 |  | Interval g/DMT | >500
 |  | Payable | 0.97
 |  | Min. deduction g/DMT | 8
Spreadsheet: 811602d1672681762-implicit-interest-rate-formula-calculation-interest-rate-working
Sheet: lease

Asset cost |  | 64732.83
Payment schedule:
36x £2,476.68 + VAT
Final payment | 647.33
Interest
Implicit interest rate
Date | B/fwd | Interest | Payment | C/fwd
2023-01-01 00:00:00 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -2476.68
 |  |  | -647.33
Spreadsheet: 745675d1630094008-filtered-lookup-with-multi-column-data-return-draftexcelforumhelpnewweeklyphecreadings
Sheet: Pivot_EC

Crop | (All) | Dynamic Chart Title
Zone | (All)
EC
Row Labels | Average of Adjusted EC (mS) | Average of Target EC LOW | Average of Target EC Range
1 | 0.9527647619047618 | #N/A | #N/A
2 | 0.7675243902439025 | #N/A | #N/A
3 | 0.9216746031746031 | #N/A | #N/A
4 | 0.9356720000000003 | #N/A | #N/A
Spreadsheet: randall_gay__31452__32614_2
Sheet: Summery - Base Load

 |  |  | Recommended Spare Parts
 |  |  | Enron Puerto Suarez/IPS-91209
 |  |  | MS 7001 EA, DLN1-25, Gas Fuel
 | FIRED | INSPECT
YEAR | HOURS | HOURS | INSPECTION / PARTS | SETS | UNIT PRICE | SUB-TOTAL
0 |  |  | Combustion Inspection Capitals | 1
 |  |  | Operational Spares | 1
 |  |  | Controls | 1
 |  |  | Generator Consumables | 1
 |  |  | Generator Maintenance | 1
 |  |  | Excitation | 1
1 | 8000 | 8000 | Combustion Inspection Consumables | 1
2 | 16000 | 16000 | Combustion Inspection Consumables | 1
3 | 24000 | 24000 | Combustion Inspection Consumables | 1
 |  |  | Hot Gas Path Inspection | 1
4 | 32000 | 32000 | Combustion Inspection Consumables | 1
5 | 40000 | 40000 | Combustion Inspection Consumables | 1
6 | 48000 | 48000 | Combustion Inspection Consumables | 1
 |  |  | Hot Gas Path Inspection | 1
 |  |  | Turbine Capitals | 1
 |  |  | Major Inspection | 1
 |  |  | Generator Capitals | 1
 |  |  | TOTAL:
Assumptions:
[NAME]:
Spreadsheet: 268829d1380838611-moving-average-across-variable-range-example
Sheet: Sheet1

Depth | ALPHA
44.38 | 23
44.43 | 83
44.73 | 83
45.09 | 31
46.88 | 50
46.99 | 82
47.12 | 82
47.24 | 73
47.28 | 78
47.4 | 83
47.59 | 22
52.78 | 80
52.94 | 80
53.17 | 61
53.24 | 70
53.65 | 61
53.72 | 78
54 | 23
54.1 | 34
54.33 | 21
54.57 | 80
54.81 | 80
54.88 | 20
54.96 | 55
55.28 | 35
55.63 | 23
Spreadsheet: 690111d1596878811-elapsed-workday-minutes-between-2-date-timestamps-sample2
Sheet: Sheet1

UniqueID | EntryTime | Response Date | Working Minutes |  | M-F From day 2 to day before last | S From day 2 to day before last | entry day | response day
17028499623 | 2020-03-02 17:59:32 | 2020-03-02 18:05:42
55198359414 | 2020-03-03 07:11:04 | 2020-03-03 07:11:18
64936242032 | 2020-03-03 08:39:06 | 2020-03-03 08:54:12
80850295561 | 2020-03-03 15:32:39 | 2020-03-03 15:32:52
866741611 | 2020-03-16 15:45:24 | 2020-03-17 06:11:24
76570045712 | 2020-04-22 13:17:12 | 2020-03-30 14:07:19
12391889300 | 2020-04-19 14:36:44 | 2020-05-19 06:54:18
 | 2020-04-19 14:36:44 | 2020-05-19 06:54:18
 | 2020-07-03 14:16:21 | 2020-07-06 09:20:23
 | 2020-07-03 14:16:21 | 2020-07-18 09:20:00
 | 2020-07-01 14:16:21 | 2020-07-21 09:20:00
 | 2020-07-11 08:45:00 | 2020-07-21 09:20:00
 | 2020-07-04 08:45:00 | 2020-07-21 09:20:00
Holidays
2020-07-04 00:00:00
2020-07-16 00:00:00
2020-11-01 00:00:00
2020-12-25 00:00:00
2020-12-26 00:00:00
 |  | Our schedule is M-F 8:30am-5:30pm, Saturdays 8:30am-1:30pm We don't work Sundays or holidays.
Spreadsheet: 488856d1478871728-scoresheet-help-ranking-game
Sheet: Sample Entries Matrix

Participant | ENTRIES |  |  |  |  |  |  |  |  |  | Exact Rank Score | ±1 Deviation Score | ±2 Deviation Score | Total
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Red | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Blue | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Yellow | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Green | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Orange | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 64154d1265036701-finding-the-last-date-with-data-find-last-day
Sheet: Sheet1

Date | Weekday | Hour | Locational Marginal Price |  |  |  |  |  |  | Date | NG Price
2007-01-01 00:00:00 | 2 | 1 | 32.06 |  |  |  |  |  |  | 2006-12-26 00:00:00 | 6.2255
2007-01-01 00:00:00 | 2 | 2 | 35.12 |  |  |  |  |  |  | 2006-12-27 00:00:00 | 6.1304
2007-01-01 00:00:00 | 2 | 3 | 36.52 |  |  |  |  |  |  | 2006-12-28 00:00:00 | 6.1771
2007-01-01 00:00:00 | 2 | 4 | 37.61 |  |  |  |  |  |  | 2006-12-29 00:00:00 | 6.0374
2007-01-01 00:00:00 | 2 | 5 | 39.75 |  |  |  |  |  |  | 2007-01-02 00:00:00 | 5.9336
2007-01-01 00:00:00 | 2 | 6 | 43.1 |  |  |  |  |  |  | 2007-01-03 00:00:00 | 6.069
2007-01-01 00:00:00 | 2 | 7 | 43.49 |  |  |  |  |  |  | 2007-01-04 00:00:00 | 6.1794
2007-01-01 00:00:00 | 2 | 8 | 43.99 |  |  |  |  |  |  | 2007-01-05 00:00:00 | 6.0271
2007-01-01 00:00:00 | 2 | 9 | 45.37
2007-01-01 00:00:00 | 2 | 10 | 45.95
2007-01-01 00:00:00 | 2 | 11 | 46.11
2007-01-01 00:00:00 | 2 | 12 | 46.21
2007-01-01 00:00:00 | 2 | 13 | 46.44
2007-01-01 00:00:00 | 2 | 14 | 46.74
2007-01-01 00:00:00 | 2 | 15 | 48.21
2007-01-01 00:00:00 | 2 | 16 | 48.23
2007-01-01 00:00:00 | 2 | 17 | 48.49
2007-01-01 00:00:00 | 2 | 18 | 50.87
2007-01-01 00:00:00 | 2 | 19 | 56.04
2007-01-01 00:00:00 | 2 | 20 | 56.06
2007-01-01 00:00:00 | 2 | 21 | 59.99
2007-01-01 00:00:00 | 2 | 22 | 63.92
2007-01-01 00:00:00 | 2 | 23 | 67.69
2007-01-02 00:00:00 | 3 | 24 | 30.51
2007-01-02 00:00:00 | 3 | 1 | 31.05
2007-01-02 00:00:00 | 3 | 2 | 32.08
2007-01-02 00:00:00 | 3 | 3 | 34.97
2007-01-02 00:00:00 | 3 | 4 | 38.75
2007-01-02 00:00:00 | 3 | 5 | 40.91
2007-01-02 00:00:00 | 3 | 6 | 45.26
2007-01-02 00:00:00 | 3 | 7 | 49.31
2007-01-02 00:00:00 | 3 | 8 | 49.39
2007-01-02 00:00:00 | 3 | 9 | 52.71
2007-01-02 00:00:00 | 3 | 10 | 53
2007-01-02 00:00:00 | 3 | 11 | 55
2007-01-02 00:00:00 | 3 | 12 | 55.82
2007-01-02 00:00:00 | 3 | 13 | 56.71
2007-01-02 00:00:00 | 3 | 14 | 59.28
2007-01-02 00:00:00 | 3 | 15 | 59.92
2007-01-02 00:00:00 | 3 | 16 | 59.95
2007-01-02 00:00:00 | 3 | 17 | 59.97
2007-01-02 00:00:00 | 3 | 18 | 60.26
2007-01-02 00:00:00 | 3 | 19 | 61.32
Spreadsheet: 816758d1675818674-populate-another-sheet-if-the-conditions-are-met-auto-populate
Sheet: Returned

 |  |  |  |  |  |  |  |  | START | END/STOP
Unit | NAME | Requesting Unit | Name of Accounts | Classification of Transactions (Simple, Complex, Highly Technical) | No. of Collateral/s | Location | Appraised Value | Date of Receipt of Complete Documents from Requesting Unit (Month-Date-Year) | Date of Inspection (Month-Date-Year) | Accounts Processed | Number of Working Days (WD) Processed* | Number of incidence   beyond TAT | Remarks
 |  |  |  |  |  |  |  |  |  | Date of Return of Accounts for appraisal to requesting unit if applicable (Month-Date-Year)
REGION | ISABELLE | ABC | NOTES | COMPLEX | 15 | AUSTRALIA | 27300000 | 2023-01-03 00:00:00 | 2023-01-20 00:00:00 | 2023-01-26 00:00:00 | 4 |  | RETURNED
 |  | Sub total
 |  | GRAND TOTAL
Spreadsheet: sally_beck__33753__NA GAS AND POWER-REGION BREAKOUT 08-23-00 EM
Sheet: NORTH AMERICAN GAS CHARTS

ENRON - North American Gas
AVERAGE EOL AND NON-EOL TRANSACTIONS PER DAY
REGION BREAKOUT
As of August 23, 2000
 |  | AVERAGE DEALS PER DAY
MONTH | DAYS | EOL | NON-EOL | TOTAL
1999-11-01 00:00:00 | 2 | 53 | 619 | 672
1999-12-01 00:00:00 | 21 | 225 | 599 | 824
2000-01-01 00:00:00 | 20 | 492 | 636 | 1128
2000-02-01 00:00:00 | 20 | 777 | 640 | 1417
2000-03-01 00:00:00 | 23 | 1039 | 606 | 1645
2000-04-01 00:00:00 | 19 | 1079 | 635 | 1713
2000-05-01 00:00:00 | 22 | 1582 | 729 | 2311
2000-06-01 00:00:00 | 22 | 1952 | 667 | 2619
2000-07-01 00:00:00 | 19 | 1845 | 689 | 2535
2000-08-01 00:00:00 | 17 | 1858 | 600 | 2458
TOTAL AVERAGE | 185 | 1184 | 645 | 1829
REGION BREAKOUT (Region breakout based on deal locations and pub code)
Spreadsheet: 162998d1340137597-updating-problem-with-worksheet-test-book
Sheet: Pivot Table

Personnel Type | Estimated Deployment in Days | Number of This Personnel Typed Needed for Deployment | Estimated Work Hours Per Day | Personnel Cost Based on GS Schedule | Benefit Cost Per Employee | Per Diem Cost Per Employee | Total Per Diem Cost All Employees This Personnel Type | Employee Unit Cost Per Worked Hour | Employee Unit Cost Per Worked Day | Total Cost per Work Day This Personnel Type | Total Estimated Straight Time Cost This Personnel Type | Total Estimated Overtime Cost This Personnel Type | Total Estimated Cost This Personnel Type
Spreadsheet: 888544d1739065268-update-needed-to-formula-to-only-show-data-for-month-sample-sheet-holger5
Sheet: YTD Survey Data

Exclude Survey "Yes or No" | Notes from CM Review | [NAME] or Replaced | Roof Decision Correct? | Estimator | Manager Estimator | Claim # | Cat Code | [NAME] | Sub Peril | [NAME] | Zip Code | County | City | Survey Month Completed | CSAT Answer | Call back requested | Comments
No |  | N/A | N/A | [NAME] | Raymi [NAME] |  | 2472CO | Wind | [NAME] | MD | 21222-1114 | BALTIMORE | BALTIMORE | 2025-01-01 00:00:00 | Somewhat satisfied | No |  |  |  | Yes |  | Replaced
No |  | N/A | N/A | [NAME] | [NAME] |  | 2477AL | Wind | Hurricane | GA | 31798-4011 | [NAME] | WRAY | 2025-01-01 00:00:00 | Extremely satisfied | No |  |  |  | No | Not Handled by Rep | Repaired
No |  | N/A | N/A | [NAME] | [NAME] |  | 2477AL | Wind | Hurricane | GA | 31023-5613 | DODGE | EASTMAN | 2025-01-01 00:00:00 | Extremely satisfied | No |  |  |  | N/A | Proper [NAME], but insured not happy with settlement | N/A
No |  | Repaired | Yes | [NAME] | [NAME] |  | 2484AL | Wind | Tropical Storm | MS | 39047-4514 | RANKIN | BRANDON | 2025-01-01 00:00:00 | Extremely dissatisfied | Yes, from a manager |  |  |  |  | Result of DA handling
No |  | Repaired | Yes | [NAME] | [NAME] |  | ASIGEN | Wind | [NAME] | OH | 44089 | ERIE | VERMILION | 2025-01-01 00:00:00 | Extremely satisfied | No |  |  |  |  | Result of Supplement handling
No |  | Repaired | Yes | [NAME] | Raymi [NAME] |  | 2484AL | Wind | [NAME] | TX | 77357-2643 | MONTGOMERY | NEW CANEY | 2025-01-01 00:00:00 | Somewhat dissatisfied | No
No | ITEL repair report used | Repaired | Yes | [NAME] | [NAME] |  | 2484AL | Wind | [NAME] | MS | 39044-2938 | SIMPSON | BRAXTON | 2025-01-01 00:00:00 | Somewhat dissatisfied | Yes, from my representative
No |  | N/A | N/A | [NAME] | [NAME] |  | ASIGEN | Water | Flood | OH | 44450-9703 | TRUMBULL | NORTH BLOOMFIELD | 2025-01-01 00:00:00 | Somewhat satisfied | No
No |  | N/A | N/A | [NAME] | [NAME] |  | ASIGEN | Water | Water Backup Overflow | OH | 44067-3048 | SUMMIT | NORTHFIELD | 2025-01-01 00:00:00 | Extremely satisfied | No
Yes | Not Handled by Rep | N/A | N/A | [NAME] | [NAME] |  |  | Water | Water Backup Sewer | OH | 44425-3106 | TRUMBULL | HUBBARD | 2025-01-01 00:00:00 | Somewhat dissatisfied | No
Yes | Not Handled by Rep | N/A | N/A | [NAME] | Raymi [NAME] |  | 2484AL | Wind | Tornado | TX | 77357-2644 | MONTGOMERY | NEW CANEY | 2025-02-01 00:00:00 | Extremely dissatisfied | No
No |  | Repaired | Yes | [NAME] | Raymi [NAME] |  | 2484AL | Wind | Tornado | TX | 77357-2644 | MONTGOMERY | NEW CANEY | 2025-02-01 00:00:00 | Extremely dissatisfied | No
No |  | Repaired | Yes | Ricardo Herrera | Raymi [NAME] |  | 2478FL | Wind | Hurricane | FL | 33884-1331 | POLK | Winter Haven | 2025-02-01 00:00:00 | Extremely dissatisfied | Yes, from a manager
Spreadsheet: a8f19151-6208-4674-a7cf-b0e8c67315a7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BTROP | Test | BTROP | Blomia tropicalis, IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BTROP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BTROP | Result | BTROP | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10921-5
Spreadsheet: 860608d1708632792-calculate-averages-in-different-columns-based-experiment-dpsh-averages
Sheet: Sheet1

Depth of measurment | DPSH-22+564 | DPSH-32+846 |  |  | ID | top of layer | bottom of layer | Average blows
 | Blows | Blows |  |  | PD-22+564 | 0 | 0.2
0 | 0 | 0 |  |  | PD-22+564 | 0.2 | 0.5
0.2 | 40 | 21 |  |  | PD-22+564 | 0.5 | 1
0.4 | 28 | 33 |  |  | PD-22+564 | 1 | 5
0.6 | 45 | 17 |  |  | PD-32+846 | 0 | 0.4
0.8 | 22 | 39 |  |  | PD-32+846 | 0.4 | 1
1 | 24 | 6 |  |  | PD-32+846 | 1 | 2.3
1.2 | 15 | 3 |  |  | PD-32+846 | 2.3 | 5
1.4 | 30 | 40
1.6 | 30 | 30
1.8 | 36 | 32
2 | 33 | 21
2.2 | 4 | 28
2.4 | 3 | 50
2.6 | 4 | 36
2.8 | 20 | 17
3 | 27 | 9
3.2 | 50 | 31
3.4 | 4 | 20
3.6 | 33 | 18
3.8 | 42 | 5
4 | 30 | 44
4.2 | 33 | 35
4.4 | 9 | 39
4.6 | 14 | 23
4.8 | 47 | 31
5 | 12 | 6
Spreadsheet: 856974d1706103679-how-to-create-a-distinct-count-of-unique-numbers-when-multiple-numbers-are-combined-unique_counts
Sheet: Sheet1

 |  |  |  |  | Organization Matching Trial IDs
Golden ID | Organization Total Matching T ID | Organization ID | Organization Matching T IDs
DD123 | 6 | 73328 | 176786; 261308; 282879; 284709; 342659; 389024 |  | 176786 | 261308 | 282879 | 284709 | 342659 | 389024
DD123 | 1 | 182062 | 282879 |  | 282879
DD123 | 1 | 178508 | 296218 |  | 296218
DD123 | 1 | 153709 | 166541 |  | 166541
DD123 | 1 | 122573 | 166541 |  | 166541
DD104 | 6 | 87107 | 291420; 322838; 333564; 365466; 401791; 427740 |  | 291420 | 322838 | 333564 | 365466 | 401791 | 427740
DD104 | 2 | 81546 | 358229; 360137 |  | 358229 | 360137
DD104 | 2 | 235739 | 282879; 291420 |  | 282879 | 291420
Spreadsheet: 02465666-1275-4ab9-a4cf-6167dee3ddb0
Sheet: Funding Source codes

n/a | n/a | SFY 2014 STATE CODE SHEET
SFY 2014 STATE EDRS-UFARS codes crosswalk | n/a | n/a
n/a | n/a | n/a
UFARS Finance Dimensions (FIN) to EDRS Funding Source Codes (FSC) | n/a | n/a
UFARS FIN | EDRS FSC | [NAME]
740 | A | Program Aid - Regular School Year
740 | C | Alternative Delivery of Specialized Instructional Services - Regulat School Year
741 | c | Part C Infants and Toddlers Birth-2
740 | E | Program Aid - Extended School Year (July-August 2013 and June 2014)
372 | i | Third Party Revenue/Expenditures Extended School Year
372 | j | Third Party Revenue/Expenditures Regular School Year
740 | M | Court Placement (Non-Minnesota Resident) (ENTERED BY MDE)
740 | N | Alternative Delivery of Specialized Instructional Services - Extended School Year
740 | P | Out-of State Tuition (Minnesota Residents with IEP's) (ENTERED BY MDE)
799 | R | Local Collaborative Time Study (LCTS)
756 | U | Full State Payment - Pupils with IEP's (ENTERED BY MDE)
761 | X | Full State Payment - Pupils without IEP's (ENTERED BY MDE)
end of worksheet
Spreadsheet: 88e66214-10ae-4b0b-b039-79a28608242e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6404 | 28242 | Hanne | Tr&#248;nnes | NOR | 22 | 00:33:11 | [NAME] | 00:58:45 | 00:01:17 | 00:27:37 | 1 | 02:01:43
6404 | 10237 | [NAME] | Mustad | NOR | 23 | 00:32:22 | 00:00:56 | 01:01:24 | 00:01:46 | 00:28:10 | 2 | 02:04:41
6404 | 45895 | Frida | Bustad | NOR | 25 | 00:40:22 | 00:01:06 | 01:22:04 | 00:01:26 | 00:32:39 | 3 | 02:37:37
6404 | 39351 | Marthe | Trønnes | NOR | 24 | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 727986d1618239985-need-help-with-a-vlookup-formula-hcp-recoil-ett-template-afi-april-9-2021
Sheet: Instructions

Instructions:
*** Daily Costs must be submitted to SharePoint site by 10am next day, days & nights. |  |  |  |  |  |  |  |  |  |  |  |  |  | Labour
File Naming Convention: |  |  |  |  |  |  |  |  |  |  |  |  |  | Equipment
[Vendor Name]-[Date]-[Shift]-[PO#]-[$$ amt]-Recoil-ETT |  |  |  |  |  |  |  |  | ST |  |  |  |  | Material
 |  |  |  |  |  |  |  |  | OT |  |  |  |  | LOA
 |  |  |  |  |  |  |  |  | DT |  |  |  |  | Meals
 |  |  | Not mandatory; enter if available |  |  | Worker Name; or Desc of non-labor entry | Trade, Role Desc, Equip Desc, Other Desc. | # hrs worked or;  Total Cost - Rate will equal 1.00 | If non-time entry, use ST |  |  |  |  | Can be any of above | [NAME]; $1.00 if total cost is entered in "QTY" column. |  | Days or Nights | Number on security gate badge.  Leave blank if N/A.
 |  |  | Invoice | Work_Date | Site | Description | Class | QTY | ST_OT | PO | PO Item# | PMO | Contractor | LEMT | Rate | Total_Cost | Shift | Badge
 |  |  |  | 2020-08-27 00:00:00 | Recoil H125 | Last Name, First Name | Superintendent | 8.5 | ST | 4700000000 |  |  | Company1 | Labour | 1 |  | Days | 12345
 |  |  |  | 2020-08-27 00:00:00 | Recoil H128 | Last Name, First Name | Superintendent | 4.5 | OT | 4700000000 |  |  | Company1 | Labour | 1.5 |  | Days | 12345
 |  |  |  | 2020-08-27 00:00:00 | Recoil H128 | Last Name, First Name | Superintendent | 100 | ST | 4700000000 |  |  | Company1 | LOA | 1 |  | Days | 12345
 |  |  |  | 2020-08-27 00:00:00 | Recoil H125 | Van | 8 Passenger | 50 | ST | 4700000000 |  |  | Company1 | Equipment | 1 |  | Days | 12345
 |  |  |  | 2020-08-27 00:00:00 | Recoil H128 | Last Name, First Name | QA Lead | 8.5 | ST | 4700000000 |  |  | Company1 | Labour | 1 |  | Days | 12345
 |  |  |  | 2020-08-27 00:00:00 | Recoil H128 | Last Name, First Name | QA Lead | 4.5 | OT | 4700000000 |  |  | Company1 | Labour | 1.5 |  | Days | 12345
 |  |  |  | 2020-08-27 00:00:00 | Recoil H128 | Last Name, First Name | Labourer | 8 | ST | 4700000000 |  |  | Company1 | Labour | 1 |  | Days | 12345
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0105

01/05/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 1 | 3 | 15 |  |  |  |  | 131 | 1.5 | reporting/board | 6.25 | 20.96
 | Dustin | 8 | 35 | 13 |  |  |  |  | 225 | 2 | trending/capmgmt | 6.75 | 33.33333333333334
 | Sharron | 15 | 1 | 23 |  |  |  |  | 217 |  |  | 9.75 | 22.25641025641026
 | Roxy | 5 | 2 | 12 |  |  |  |  | 112 |  |  | 8.5 | 13.17647058823529
 | [NAME] |  |  |  |  | 6 | 11 | 1 | 108 |  |  | 7.5 | 14.4
 | Ana |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] | 16 | 19 | 13 |  |  |  |  | 193 | 0.5 | CISS | 9.25 | 20.86486486486486
 | Petra |  |  |  |  |  | 8 | 2 | 80 | 3.5 | Prob/checklst/jobaid | 6.25 | 12.8
 | Regina |  |  |  |  |  | 12 |  | 96 | 0.5 | [NAME] | 6.75 | 14.22222222222222
 | Noy |  |  |  |  |  | 6 | 9 | 120 | 2 | Job Shadow | 7.5 | 16
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] | 19 | 19 |  |  |  |  |  | 95 |  |  | 4 | 23.75
 | Michelle |  |  |  |  |  |  |  | 0 |  | SME | 0.01 | 0
 | Keisha |  | 33 | 4 |  |  |  |  | 131 |  |  | 10 | 13.1
 | [NAME] |  | 45 | 2 |  |  |  |  | 151 |  |  | 10 | 15.1
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 206.863301265066
 | TASK VOLUME: | 64 | 157 | 82 | 0 | 6 | 37 | 12 | 1659 | 10 |  | 92.53 | 17.92932022046904
 | Pts Earned: | 128 | 471 | 656 | 0 | 12 | 296 | 96
 |  |  |  |  |  |  |  | Average PTS | 110.6013333333333 |  | Total Task Volume |  | 358
 | MID-DAY PPH  18.54