tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 146795d1332353441-excel-2007-weighted-grade-sheet-help-sample
Sheet: Reliability

Reliability Report
This report is based on the reliability of data for the preceding 3 months of data from the date below. Column labeled 'Month 1' indicates the most recent month, 'Month 3' indicates the oldest month.
December, 2011
The scores are based  on reliability regarding the following criteria:
4 = Data came in an HL7 format, was complete, and processed without problems.
3 =Data came in non-HL7 format, was complete, and processed without problems.
2 = Data changed in format by source, required work and upgrade by ICLOPS.
1 = Data required reprocessing by ICLOPS in order to load.
0 = Data is missing data elements and/or data fields changed.
Practice | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6
 | 4 | 4 | 4 | 4 | 4 | 4
 | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 53303d1253196334-if-function-fifa_night_2009-1-1-
Sheet: Group Stage

Butchers Arms FIFA 09 Tournament
 |  |  |  | Friday 25th September 2009
 | www.butchersarmsfc.co.uk
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gaz | [NAME] | [NAME] | Mark
 | Group 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gaz | 0 | 0 | 3 | 2
 |  | Mark |  | 2 | 1 |  | Gaz |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | -4 | 0 | 0 | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | -2 | 0 | 0 | 2
 | 7:30pm TV 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mark | -1 | 2 | -2 | 0
 |  | [NAME] |  | 3 | 2 |  | Gaz |  |  | Teams |  |  | P | W | D | L | F | A | [NAME] | Pts
 | 7:45pm TV 2 |  |  |  |  |  |  |  |  | Gaz |  |  | 0 | 0 | 0 | 0 | 7 | 5 | 2 | 0
 |  | Mark |  | 2 | 2 |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 0 | 0 | 0 | 2 | 5 | -3 | 0
 | 8:15pm TV 2
 |  | [NAME] |  | 0 | 0 |  | [NAME] |  |  | [NAME] |  |  | 0 | 0 | 0 | 0 | 5 | 4 | 1 | 0
 | 9:15pm TV 2 |  |  |  |  |  |  |  |  | Mark |  |  | 0 | 0 | 0 | 0 | 5 | 5 | 0 | 0
 |  | [NAME] |  | 2 | 1 |  | Mark
 | 9:30pm TV 2
 |  | [NAME] |  | 0 | 4 |  | Gaz
 | 9:45pm TV 2
 | Group 2
 |  | Wapp |  |  |  |  | Jordan
 | 7:30pm TV 1
 |  | [NAME] |  |  |  |  | Ginna |  |  | Teams |  |  | P | W | D | L | F | A | [NAME] | Pts
 | 7:45pm TV 1 |  |  |  |  |  |  |  |  | Ginna
 |  | Wapp |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Jordan
 | 8:15pm TV 1
 |  | Ginna |  |  |  |  | Jordan |  |  | [NAME]
 | 8:45pm TV 1 |  |  |  |  |  |  |  |  | Wapp
 |  | Jordan |  |  |  |  | [NAME]
 | 9:00pm TV 1
 |  | Wapp |  |  |  |  | Ginna
 | 9:15pm TV 1
 | Group 3
 |  | Noodle |  |  |  |  | Dale
 | 8:00pm TV 1
 |  | Daz |  |  |  |  | Gino |  |  | Teams |  |  | P | W | D | L | F | A | [NAME] | Pts
 | 8:00pm TV 2 |  |  |  |  |  |  |  |  | Dale
 |  | Noodle |  |  |  |  | Daz
 |  |  |  |  |  |  |  |  |  | Daz
 | 8:30pm TV 1
 |  | Dale |  |  |  |  | Gino |  |  | Gino
 | 8:30pm TV 2 |  |  |  |  |  |  |  |  | Noodle
 |  | Noodle |  |  |  |  | Gino
 | 8:45pm TV 2
 |  | Daz |  |  |  |  | Dale
 | 9:00pm TV 2
Spreadsheet: 676758d1588956754-complex-timesheet-template-sample-timesheet-fish31-
Sheet: Sheet2

Date | Task | Time In | Break Start | Break End | Time Out | Total Hrs | Task A Hrs | Task A OT Hrs | Task B Hrs | Task B OT Hrs | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
2020-05-09 00:00:00 | Task A | 09:15:00 | 12:30:00
 | Task B |  |  | 13:00:00 | 18:00:00
 | Task A
 | Task B
 | Task A | 09:00:00 | 09:45:00
 | Task B
 | Task A
 | Task B | 09:08:00 | 12:30:00
 | Task A | 09:00:00 | 12:00:00 | 13:00:00 | 18:00:00
 | Task B |  |  | 18:00:00 | 19:00:00
 | Task A | 09:00:00 | 12:30:00 | 13:30:00 | 17:00:00
 | Task B |  |  | 17:00:00 | 18:00:00
 | Task A | 09:00:00 | 12:00:00 | 18:00:00 | 19:00:00
 | Task B |  |  | 13:00:00 | 18:00:00
 |  |  |  |  |  |  |  |  | 8 | 6
 |  |  |  |  |  |  | Time In : Break Start
 |  |  |  |  |  |  | Break End : Time Out
Spreadsheet: 747516d1631547885-maximum-number-od-conditional-rules-excel-sample
Sheet: Training 52-102

Name of Report: | 2021 EPIC SHIP VT SCHEDULE REPORT |  | M | Priority 1: Mandatory Trainings Overdue, to be completed immediately at the earliest
Company: | Epic Ship Management |  | M | Priority 2: Mandatory training, need to be completed at next most suitable opportunity after completing all Priority 1
Vessels included: |  |  | 2020-07-24 00:00:00 | Training Completed: Date of completion of the subject training
 |  |  | - | Training Not applicable to that specific rank
TrainingCode | Title
52 | Title 052
53 | Title 053
54 | Title 054
55 | Title 055
56 | Title 056
57 | Title 057
58 | Title 058
59 | Title 059
60 | Title 060
61 | Title 061
62 | Title 062
63 | Title 063
64 | Title 064
65 | Title 065
66 | Title 066
67 | Title 067
68 | Title 068
69 | Title 069
70 | Title 070
71 | Title 071
72 | Title 072
73 | Title 073
74 | Title 074
75 | Title 075
76 | Title 076
77 | Title 077
78 | Title 078
79 | Title 079
80 | Title 080
81 | Title 081
82 | Title 082
83 | Title 083
84 | Title 084
85 | Title 085
86 | Title 086
87 | Title 087
88 | Title 088
89 | Title 089
90 | Title 090
91 | Title 091
92 | Title 092
93 | Title 093
94 | Title 094
95 | Title 095
96 | Title 096
97 | Title 097
98 | Title 098
99 | Title 099
100 | Title 100
101 | Title 101
102 | Title 102
 | Total Trainings
 | Not Completed
 | Completed
 | % Completed
Spreadsheet: andy_zipper__145__ICE - Mar20 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-20-01 thru Mar-20-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - TCO - Apr01-Oct01 | Apr01-Oct01 | 0.248 | 0.248 | 0.248 | 0.248 | Mar-20-01 17:39 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for IF - TET M3 - Apr01 | Apr01 | 0.435 | 0.435 | 0.435 | 0.435 | Mar-20-01 14:42 GMT | 300000 | MMBtus
 | NG Fin BS, LD1 for IF - TET M3 - Apr01-Oct01 | Apr01-Oct01 | 0.44 | 0.44 | 0.44 | 0.44 | Mar-20-01 17:29 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for IF - Transco Z6 (NY) - Apr01 | Apr01 | 0.45 | 0.45 | 0.45 | 0.45 | Mar-20-01 14:46 GMT | 300000 | MMBtus
 | NG Fin BS, LD1 for NGI
 | NG Fin BS, LD1 for NGI - Chicago - Apr01-Oct01 | Apr01-Oct01 | 0.16 | 0.16 | 0.16 | 0.16 | Mar-20-01 20:09 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for NGI - Socal - Nov01-Mar02 | Nov01-Mar02 | 4.3 | 4.3 | 4.3 | 4.3 | Mar-20-01 14:18 GMT | 755000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 5.07 | 5.165 | 5.138 | 5.165 | Mar-20-01 16:44 GMT | 715000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 5.09 | 5.32 | 5.165 | 5.29 | Mar-20-01 19:14 GMT | 6750000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 5.11 | 5.22 | 5.144 | 5.22 | Mar-20-01 16:23 GMT | 1085000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.155 | 5.385 | 5.241 | 5.365 | Mar-20-01 19:58 GMT | 12840000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Nov01-Mar02 | Nov01-Mar02 | 5.275 | 5.298 | 5.288 | 5.288 | Mar-20-01 14:54 GMT | 3775000 | MMBtus
Spreadsheet: 543247d1508295929-loookup-on-multiple-date-range-and-multiple-lines-example_budgetactual_1
Sheet: SheetA

Location | Start Date | End Date | Budget Amount
Tokyo | 2017-01-01 00:00:00 | 2017-05-15 00:00:00 | 131
Tokyo | 2017-05-16 00:00:00 | 2017-09-15 00:00:00 | 203
Tokyo | 2017-09-16 00:00:00 | 2017-12-31 00:00:00 | 300
Australia | 2017-01-01 00:00:00 | 2017-05-14 00:00:00 | 131
Australia | 2017-05-15 00:00:00 | 2017-09-14 00:00:00 | 251
Australia | 2017-09-15 00:00:00 | 2017-12-31 00:00:00 | 131
Canada | 2017-01-01 00:00:00 | 2017-12-31 00:00:00 | 191
Mexico | 2017-01-01 00:00:00 | 2017-05-15 00:00:00 | 101
Mexico | 2017-05-16 00:00:00 | 2017-09-15 00:00:00 | 203
Mexico | 2017-09-16 00:00:00 | 2017-12-31 00:00:00 | 101
Alaska | 2017-01-01 00:00:00 | 2017-04-30 00:00:00 | 143
Alaska | 2017-05-01 00:00:00 | 2017-05-31 00:00:00 | 184
Alaska | 2017-06-01 00:00:00 | 2017-09-30 00:00:00 | 204
Alaska | 2017-10-01 00:00:00 | 2017-12-31 00:00:00 | 143
Brazil | 2017-01-01 00:00:00 | 2017-12-31 00:00:00 | 191
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6274 | 6163 |  |  | 1156 | 1178 | 2098 | 1619
2 | 6245 | 6163 |  |  | 1038 | 1178 | 2024 | 1619
3 | 6272 | 6163 |  |  | 1004 | 1178 | 1965 | 1619
4 | 6068 | 6163 |  |  | 1008 | 1178 | 2150 | 1619
5 | 5977 | 6163 |  |  | 571 | 1178 | 1663 | 1619
6 | 6200 | 6163 |  |  | 695 | 1178 | 1911 | 1619
7 | 6546 | 6163 |  |  | 743 | 1178 | 2009 | 1619
8 | 6547 | 6163 |  |  | 923 | 1178 | 1207 | 1619
9 | 6522 | 6163 |  |  | 848 | 1178 | 2085 | 1619
10 | 6446 | 6163 |  |  | 686 | 1178 | 2052 | 1619
11 | 6297 | 6163 |  |  | 238 | 1178 | 1968 | 1619
12 |  |  |  |  | 875 | 1178 | 1999 | 1619
13 |  |  |  |  | 843 | 1178 | 1962 | 1619
14 |  |  |  |  | 1056 | 1178 | 1914 | 1619
15 |  |  |  |  | 805 | 1178 | 1974 | 1619
16 |  |  |  |  | 823 | 1178 | 1941 | 1619
17 |  |  |  |  | 1000 | 1178 | 1910 | 1619
18 |  |  |  |  | 414 | 1178 | 1874 | 1619
19 |  |  |  |  | 1033 | 1178 | 1826 | 1619
20 |  |  |  |  | 1265 | 1178 | 1784 | 1619
21 |  |  | 1 |  | 1242 | 1178 | 1393 | 1619
22 |  |  |  |  | 1325 | 1178 | 1384 | 1619
23 |  |  |  |  | 1263 | 1178 | 1388 | 1619
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  |  |  |  |  | 362097.29
2001-06-23 00:00:00
Spreadsheet: 684021d1593100475-automated-creation-of-a-two-unique-lists-from-a-source-sheet-companyandworker
Sheet: Worker

WEEK | WORKER | Total Salary
25 | Worker 1 | 250
25 | Worker 2 | 80
25 | Worker 3 | 40
26 | Worker 3 | 110
26 | Worker 1 | 80
27 | Worker 3 | 70
27 | Worker 2 | 80
Spreadsheet: chris_germany__2107__VNG NOV-trpt2
Sheet: Sheet1

VNG Transport Scenerios
2000-11-01 00:00:00
 |  | [NAME] | comm | s/c | fuel% | [NAME] | TRCO trans cost | Total TRCO Cost | TCO Cost |  | Total Cost
Transco to TCO (Emporia)
1 to 5 |  |  | 0.0274 | 0.0119 | 4.69
2 to 5 |  |  | 0.0254 | 0.0119 | 4.34
3 to 5 |  | 4.54 | 0.0228 | 0.0119 | 3.88
GSS (3) to 5 |  |  |  |  | 3.88
 |  |  |  |  |  |  | Gulf Trans |  | TCO Cost |  | Total Cost
Gulf to TCO (Leach)
On - ML |  | 4.45 | 0.0366 | 0.0022 | 0.603
ML - Leach |  |  | 0.0192 | 0.0022 | 2.82
 |  |  |  |  |  |  | TENN trans cost | Total TENN Cost | TCO Cost |  | Total Cost
Tenn to TCO (Cobb)
0 to 3 |  | 4.34 | 0.05 | 0.0022 | 5.88
1 to 3 |  | 4.33 | 0.05 | 0.0022 | 4.99
 |  |  |  |  |  |  | TENN trans cost | Total TENN Cost | CNG Cost |  | Total Cost
Tenn to CNG (CW & SW)
0 to 3 |  | 4.34 | 0.05 | 0.0022 | 5.88
1 to 3 |  | 4.37 | 0.05 | 0.0022 | 4.99
 |  |  |  |  |  |  | TCO trans cost | Total TCO Cost
TCO to VNG
 |  | 4.655 | 0.0133 | 0.0094 | 2.184
 |  |  |  |  |  |  | CNG trans cost | Total CNG cost
CNG to VNG
 |  | 4.68 | 0.0951 | 0.0022 | 2.28
Spreadsheet: 46253d1245158343-nested-if-functions-drug-half-life-calc
Sheet: Sheet2

Day | Days | "X"value | Dose | Concentration (formula)
Monday | 1 | x | 400
Tuesday | 2
Wednesday | 3 | x | 400
Thursday | 4
Friday | 5 | x | 400
Saturday | 6
Sunday | 7 | x | 400
Monday | 8
Tuesday | 9 | x | 400
Wednesday | 10
Thursday | 11 | x | 400
Friday | 12
Saturday | 13 | x | 400
Sunday | 14
Monday | 15 | x | 400
Tuesday | 16
Wednesday | 17 | x | 400
Thursday | 18
Friday | 19 | x | 400
Saturday | 20
Sunday | 21 | x | 400
Monday | 22
Tuesday | 23 | x | 400
Wednesday | 24
Thursday | 25 | x | 400
Friday | 26
Saturday | 27 | x | 400
Sunday | 28
Monday | 29 | x | 400
Tuesday | 30
Wednesday | 31 | x | 400
Thursday | 32
Friday | 33 |  |  | 187.5
Saturday | 34
Sunday | 35 |  |  | 175
Monday | 36
Tuesday | 37 |  |  | 162.5
Wednesday | 38
Thursday | 39 |  |  | 150
Friday | 40
Saturday | 41 |  |  | 137.5
Sunday | 42
Monday | 43 |  |  | 125
Tuesday | 44
Wednesday | 45 |  |  | 112.5
Thursday | 46
Friday | 47 |  |  | 100
Saturday | 48
Sunday | 49 |  |  | 87.5
Monday | 50
Tuesday | 51 |  |  | 75
Wednesday | 52
Thursday | 53 |  |  | 62.5
Friday | 54
Saturday | 55 |  |  | 50
Sunday | 56
Monday | 57 |  |  | 37.5
Tuesday | 58
Wednesday | 59 |  |  | 25
Thursday | 60
Friday | 61 |  |  | 12.5
Spreadsheet: 76936d1277390290-combine-multiple-payments-to-same-vendor-example-7-
Sheet: list

Name | Price
Spreadsheet: 166723d1341755219-return-value-in-x-if-date-in-y-falls-between-two-dates-help-pivot-group-by-month-simple-table
Sheet: Sheet1

Count | Date | Amount |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1 | 2012-01-20 00:00:00 | 250 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 2012-02-03 00:00:00 | 30 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 2012-03-04 00:00:00 | 200 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 2012-04-05 00:00:00 | 388 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 2012-05-06 00:00:00 | 486 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 2012-06-07 00:00:00 | 295 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 2012-08-03 00:00:00 | 359 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 2012-09-04 00:00:00 | 486 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 2012-10-08 00:00:00 | 1035 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 2012-11-08 00:00:00 | 912 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Sum of Amount
 |  |  |  | Date | Total | << This is [NAME] that is grouped by month.  Right click
 |  |  |  | Jan | 250
 |  |  |  | Feb | 30
 |  |  |  | Mar | 200
 |  |  |  | Apr | 388
 |  |  |  | May | 486
 |  |  |  | Jun | 295
 |  |  |  | Aug | 359
 |  |  |  | Sep | 486
 |  |  |  | Oct | 1035
 |  |  |  | Nov | 912
 |  |  |  | Grand Total | 4441
Spreadsheet: 871395d1717771827-trying-to-populate-a-row-from-merged-cells-with-a-helper-column-testing-heirarchy
Sheet: Example Result

Department | Tier 1 | [NAME] | Tier 3 | [NAME] | Tier 5
Payspace |  |  |  | Payroll Engineering
Software Development
R&D
Global Payroll Engineering |  |  |  |  | Global Payroll Engineering
Spreadsheet: 473968d1470546835-optimizing-a-cutting-list-for-least-waste-solver_cutting
Sheet: Solver_model

 |  |  |  | Cutting aluminium lists for doors
 |  |  | cut lenght | cut lenght | cut lenght | cut lenght | cut lenght | cut lenght |  | Required
Stock lenght | 5800 |  | 4000 | 3500 | 2560 | 2000 | 1500 | 1200 | waste/stock | No stock | tot waste
 |  | Cut 1 |  |  |  |  |  |  |  | 5
 |  | Cut 2 |  |  |  |  |  |  |  | 0
 |  | Cut 3 |  |  |  |  |  |  |  | 10
 |  | Cut 4 |  |  |  |  |  |  |  | 0
 |  | Cut 5 |  |  |  |  |  |  |  | 0
 |  | Cut 6 |  |  |  |  |  |  |  | 0
 |  | Cut 7 |  |  |  |  |  |  |  | 3
 |  | Cut 8 |  |  |  |  |  |  |  | 0
 |  | Cut 9 |  |  |  |  |  |  |  | 0
 |  | Cut 10 |  |  |  |  |  |  |  | 0
 |  | Cut 11 |  |  |  |  |  |  |  | 0
 |  | Cut 12 |  |  |  |  |  |  |  | 0
 |  | Cut 13 |  |  |  |  |  |  |  | 0
 |  | Cut 14 |  |  |  |  |  |  |  | 0
 |  | Cut 15 |  |  |  |  |  |  |  | 0
 |  | Cut 16 |  |  |  |  |  |  |  | 0
 |  | Cut 17 |  |  |  |  |  |  |  | 0
 | Solver | Production
 | List of | demands | 5 | 10 | 3 | 4 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Objct func
 |  | Total number of aluminium stock lenghts: |  |  |  |  | Lenghts
 |  | Sum of waste after cutting required lenghts: |  |  |  |  | [NAME]
 |  | As this solver setup is based on different combinations  of cuth length to minimize wastage the solver prodution and the listed demand
 |  | may wary quite a bite so the result should be analyzed and  modified to set up a cutting pattern to meet demand and maximize
 |  | production of usable lenghts for futher delivery. See a proposed brakedown of solver result in rows 37 to 45.
 |  |  |  |  |  |  |  |  |  | Required
 |  |  | 4000 | 3500 | 2560 | 2000 | 1500 | 1200 | waste/stock | No stock | Tot waste
 |  | Cut 1 mod |  |  |  |  |  |  |  | 1 | 300 * 1
 |  |  |  |  |  |  |  |  |  | 4 | 1800 * 4 |  | Usable waste?
 |  | Cut 3 mod |  |  |  |  |  |  |  | 1 | 300 * 1
 |  |  |  |  |  |  |  |  |  | 9 | 2300 * 9 |  | Usable waste?
 |  | Cut 7 mod |  |  |  |  |  |  |  | 1 | 1240 * 1 |  | Usable waste?
 |  |  |  |  |  |  |  |  |  | 2 | 40 * 2
 |  | Produced
 |  | Demand | 5 | 10 | 3 | 4 | 1 | 2
Spreadsheet: 696363d1600776238-duplicate-data-in-rows-grouped-with-adjacent-data-transposed-into-column-200922-bins-rows-indexed-matching-into-columns
Sheet: Sheet1

 |  |  |  |  | [NAME]
Product | BIN | Bins Location | [NAME] |  | Product | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME]
0,5/BLK | 1B | Cape Town Warehouse | Yes |  | 0,5/BLK | 1B | Cape Town Warehouse | Yes | 1G | Cape Town Warehouse | No | 2B | [NAME] | Yes | 2G | [NAME] | No | 3A | [NAME] | Yes | 4A | [NAME] | Yes
0,5/BLK | 1G | Cape Town Warehouse | No |  | 0,5/BLU | 1B | Cape Town Warehouse | Yes | 1G | Cape Town Warehouse | No | 2B | [NAME] | Yes | 2G | [NAME] | No | 3A | [NAME] | Yes | 4A | [NAME] | Yes
0,5/BLK | 2B | [NAME] | Yes |  | 0,5/RED | 1B | Cape Town Warehouse | Yes | 1G | Cape Town Warehouse | No | 2B | [NAME] | Yes | 2G | [NAME] | No | 3A | [NAME] | Yes | 4A | [NAME] | Yes
0,5/BLK | 2G | [NAME] | No
0,5/BLK | 3A | [NAME] | Yes
0,5/BLK | 4A | [NAME] | Yes
0,5/BLU | 1B | Cape Town Warehouse | Yes
0,5/BLU | 1G | Cape Town Warehouse | No
0,5/BLU | 2B | [NAME] | Yes
0,5/BLU | 2G | [NAME] | No
0,5/BLU | 3A | [NAME] | Yes
0,5/BLU | 4A | [NAME] | Yes
0,5/RED | 1B | Cape Town Warehouse | Yes
0,5/RED | 1G | Cape Town Warehouse | No
0,5/RED | 2B | [NAME] | Yes
0,5/RED | 2G | [NAME] | No
0,5/RED | 3A | [NAME] | Yes
0,5/RED | 4A | [NAME] | Yes
Spreadsheet: 81fcb5b6-8343-448a-be35-3019baa5a455
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
C1ES | Test | C1ES | [NAME] (C1ES) Inhibitor Antigen, Serum | C1 Esterase Inhibitor Antigen, S | Nephelometry | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Fasting preferred but not required. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK-note to lab Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 19-37 mg/dL | Monday through Saturday; Continuously until 3 p.m. | 1 day | 2 days | 1 | 83520 |  |  |  |  | Rochester
C1ES | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
C1ES | Result | C1ES | C1 Esterase Inhibitor Antigen, S | C1 Esterase Inhibitor Antigen, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 4477-6
Spreadsheet: 118259d1313576080-excel-formula-help-for-timesheets-copy-of-timesheet-template
Sheet: Sheet1

2011-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Price/hr | 12 |  |  | Start Time | Rate
Date | Start |  | Finish |  | Hours | SINGLE | Hours | Tea money | O/T 1.5 | Hours | O/T 2.0 | TOTAL $ | [NAME] | Tea | 3 |  |  | 07:30:00 | 13
2011-06-20 00:00:00 | 07:45:00 |  | 21:30:00 |  | 8 | 104 | 2 | 3 | 39 | 3.750000000000001 | 97.50000000000003 | 243.5 | 13 |  |  |  |  | 08:00:00 | 14
2011-06-21 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  | 08:30:00 | 15
2011-06-22 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  | 09:00:00 | 16
2011-06-23 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  | 09:30:00 | 17
2011-06-24 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-25 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-26 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-27 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-28 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-29 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-06-30 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-07-01 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-07-02 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
2011-07-03 00:00:00 |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | sub total | 0
 |  |  |  |  |  |  |  |  |  |  | total | 0
A1 enter date range and populate A3:A16
B3 specific start times and notes from drop downs (which I can do)
D3 range of finish times from drop downs ( also can do)
F1 calculate hours worked from selected times in B3 and [NAME], but F3 = 8 hours only. I would like to spread hours greater than 8 over H3 and K3, eg single hours = 8, o/t 1.5 upto and including 2 hours and anthing beyond 10 hours = o/t 2.0
I3 tea money is paid after 9 hours work, eg 8 hours in F3 and 1 hour in H3
Then all that’s left is to enter hourly wage into G3, J3, L3 and tea money amount in I3, then total all relevent cells for totals.
 |  |  |  |  |  | 08:30:00 | 8.5
Spreadsheet: 828121d1683230963-vlookup-to-show-different-sub-categories-in-the-same-category-s666-pq-vlookup-to-show-different-sub-categories-in-the-same-category
Sheet: Sheet1

Column 1 | Column 2 | Column 3 |  | Notes | Column 1 | Column 2 | Column 3 | Column 4
1 | [NAME], [NAME] | Type |  | Column 4 needs to show Business 1 | 1 | [NAME], [NAME] | Type | Business 1
1 | [NAME], [NAME] | Type |  | Column 4 needs to show Business 2 | 1 | [NAME], [NAME] | Type | Business 2
1 | [NAME], [NAME] | Type |  | Column 4 needs to show Business 3 | 1 | [NAME], [NAME] | Type | Business 3
1 | [NAME], [NAME] | Type |  | Column 4 needs to show Business 4 | 1 | [NAME], [NAME] | Type | Business 4
1 | [NAME], [NAME] | Type |  | Column 4 needs to show Business 5 | 1 | [NAME], [NAME] | Type | Business 5
1 | [NAME], [NAME] | Type |  | Column 4 needs to show Business 6 | 1 | [NAME], [NAME] | Type | Business 6
Spreadsheet: 26155d1218071549-make-a-list-that-accepts-values-not-in-the-list-mileagelog
Sheet: Mileage Computation Log

Mileage Computation
Date | Start | To | Miles1 | To | Miles2 | To | Miles3 | Purpose | Start | Driven | Total
 |  |  | 0 |  | 0 |  | 0 |  | 135000 | 0 | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0
 |  |  | 0 |  | 0 |  |  |  |  | 0