tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 25573d1216928285-how-can-i-make-a-chart-to-display-entered-data-in-a-field-examplehelppivot
Sheet: Data

Month | Fruit | Amount
January | Apples | 2
January | Oranges | 3
January | Bananas | 5
January | Pears | 1
February | Apples | 3
February | Oranges | 3
February | Bananas | 4
February | Pears | 2
March | Apples | 4
March | Oranges | 3
March | Bananas | 6
March | Pears | 3
April | Apples | 5
April | Oranges | 3
April | Bananas | 2
April | Pears | 2
May | Apples | 6
May | Oranges | 3
May | Bananas | 4
May | Pears | 1
June | Apples | 7
June | Oranges | 3
June | Bananas | 3
June | Pears | 1
July | Apples | 8
July | Oranges | 3
July | Bananas | 5
July | Pears | 2
August | Apples | 9
August | Oranges | 3
August | Bananas | 4
August | Pears | 3
September | Apples | 10
September | Oranges | 3
September | Bananas | 6
September | Pears | 2
October | Apples | 11
October | Oranges | 3
October | Bananas | 2
October | Pears | 1
November | Apples | 12
November | Oranges | 3
November | Bananas | 4
November | Pears | 2
December | Apples | 13
December | Oranges | 3
December | Bananas | 3
December | Pears | 4
Spreadsheet: fa12a77d-0d86-4361-9668-f6657b467566
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
T3 | Test | T3 | T3 (Triiodothyronine), Total, Serum | T3 (Triiodothyronine), Total, S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube: Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | > or =1 year: 80-190 ng/dL | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 84480 |  |  |  |  | Rochester
T3 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
T3 | Result | T3 | T3 (Triiodothyronine), Total, S | T3 (Triiodothyronine), Total, S | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 3053-6
Spreadsheet: 882090d1730365482-unique-alternative-book1-4-
Sheet: Sheet1

 | SOURCE |  |  | SOURCE
 | Cat |  |  | Cat
 | Dog |  |  | Dog
 | Cat |  |  | Fish
 | Rat |  |  | Rat
 | Rat
 | Dog
 | Cat
 | Dog
 | Rat
 | Cat
 | Fish
 | Fish
 | Fish
 | Cat
 | Dog
 | Rat
Spreadsheet: 80435d1280657275-automatic-updating-something-like-this-maybev2
Sheet: Battalion Perstat

Battalion PERSTAT |  |  |  |  | PM FWD HQ
Last Name | First Name | Position | ORG | Location | Status
[NAME] | [NAME] | [NAME] | [NAME] | PM FWD HQ | Duty
Barnes | [NAME] | JLI | LOG Assistant [NAME] | PM FWD HQ | Duty
Carrillo | [NAME] | JLI | Material Handler | PM FWD HQ | Duty
[NAME] | [NAME] | JLI | [NAME] | PM FWD HQ | LWOP
[NAME] | Carnell | JLI | Operations Tech | PM FWD HQ | Duty
Alford | [NAME] | RRAD | Sustainment Mechanic | Balad | Duty
[NAME] | Timothy | BAE | FSR | Balad | TDY
Andrus | [NAME] | [NAME] | FSR | Balad | Duty
Batalon | [NAME] | RRAD | Sustainment Mechanic | Balad | Duty
[NAME] | [NAME] | RRAD | Regional [NAME] | Balad | Duty
Heyward | [NAME] | RRAD | Sustainment Mechanic | Balad | R&R
Spreadsheet: 834295d1687615188-count-if-sum-returning-error-2023-master-data-test
Sheet: RawData

Call Date | Call Completed | SKU available on entry? : Reese's Sku 1 47g | SKU available on exit? : Reese's Sku 1 47g | SKU available on entry? : Sku 2 40g | SKU available on exit? : Sku 2 40g | SKU available on entry? : Sku 3 42g | SKU available on exit? : Sku 3 42g | SKU available on entry? : [NAME]g | SKU available on exit? : [NAME]g | SKU available on entry? : Sku 5 bag | SKU available on exit? : Sku 5 bag | SKU available on entry? : [NAME] PMP | SKU available on exit? : [NAME] PMP | SKU available on entry? : Sku 7 £1 PMP | SKU available on exit? : Sku 7 £1 PMP | SKU available on entry? : Sku 8 68g | SKU available on exit? : Sku 8 68g | Sku 1 Entry | [NAME] | [NAME] | Sku 2 Entry | [NAME] | Hershey Distribution Gain | Sku 3 Entry | [NAME] | Sku 3 Distribution Gain | Sku 4 Entry | [NAME] | [NAME] Gain | Sku 5 bag Entry | [NAME] | Sku 5 Distribution Gain | [NAME] | Sku 6Exit | Sku 6Distribution Gain | Sku 7 Entry | [NAME] | Sku 7 Distribution Gain | sku 8 Entry | [NAME] 8 Exit | [NAME] 8 Distribution Gain | No. Of Gained points | Unique Distribution point | one Entry | two Entry | three Entry | four Entry | five Entry | Six Entry | seven Entry | eight Entry | No of Yes on entry
2023-06-19 08:11:10 | Yes | No | No | No | No | No | No | No | No | No | No | No | No | No | No
2023-06-19 08:26:28 | Yes | No | No | No | Yes | No | Yes | No | No | No | No | No | No | No | No
2023-06-19 08:42:58 | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | Yes | Yes | No | Yes
Spreadsheet: 776425d1649734272-index-formula-looking-up-dynamic-columns-order-list-sample
Sheet: Orders

Truck Number | Booking ID | Timeslot | Delivery Number | Shipment Number | [NAME] | Destination Name | Pallet Count | Pallet Module | Pallet Space | Dead Weight (Tonne) | Pickup Date | Pickup Time | Destination State | PO Number | Customer Notes
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 | Sample | 06:00:00 | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 | Sample | 10:00:00 | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 | Sample | 14:30:00 | [PHONE]
Spreadsheet: 377540d1424043646-adding-up-seperate-commodities-within-list-excel-help
Sheet: Summary

 |  | TEAM | Venue | W | D | L | F | A | Total
 |  | [NAME] Reserves | A
 |  |  | Team & Competition
 |  | Competition
 |  | Northants League | H
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: X662 GBF

 |  |  |  |  | X662 GBF
Registration number : | X662 GBF |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  |  | 12 Months + 1 Week | 2001-10-01 00:00:00 | 1530
Specification : | 6 x 2 A (3 Axle) |  | 2001-09-28 00:00:00 | 12 Months | 2002-10-01 00:00:00 | 750
Type : | FTG85 CF 380 |  | 2002-09-30 00:00:00 | 12 Months | 2003-10-01 00:00:00 | 750
1st Registered : | 22.09.00 |  | 2003-09-30 00:00:00 | 12 Months | 2004-10-01 00:00:00 | 700
Engine : | DAF XF280M |  | 2004-09-30 00:00:00 | 12 Months | 2005-10-01 00:00:00 | 700
[NAME] : | 44,000kg |  | 2005-09-30 00:00:00 | 12 Months | 2006-10-01 00:00:00 | 700
 |  |  | 2006-09-29 00:00:00 | 12 Months | 2007-10-01 00:00:00 | 700
 |  |  | 2007-09-30 00:00:00 | 12 Months | 2008-10-01 00:00:00 | 700
 |  |  | 2008-09-29 00:00:00 | 12 Months | 2009-10-01 00:00:00 | 700
Back To Index |  |  | 2009-09-30 00:00:00 | 12 Months | 2010-10-01 00:00:00 | 700
 |  |  | Licence Surrendered 26/2/2010
 |  |  | 2010-02-26 00:00:00 | 12 Months | 2011-03-01 00:00:00 | 165
 |  |  | Licence Surrendered 28/5/2010
 |  |  | 2010-06-30 00:00:00 | 12 Months | 2011-07-01 00:00:00 | 700
 |  |  | 2011-07-01 00:00:00 | 12 Months | 2012-07-01 00:00:00 | 700
Spreadsheet: danny_mccarty__4661__XTRANSCO - Economics
Sheet: Basic Calculations

MAIN CONCEPTS |  | Maximum | Average | Minimum
FUEL SAVINGS TRUCK
Average days trucks spent on the road | Days / Year | 305 |  | 241
Average hours driven per day | Hours / Day
Mandatory Idling ratio to hours driven | Idling : Hours
Average idling time | Hours
Average hours inside truck | %
Average hours inside truck | Hours | 8 |  | 6
Cost of diesel | $ / Gallon | 1.3 |  | 1.2
Diesel consumption while idling | Gallons / Hour | 1 |  | 0.65
Net idling cost of fuel | $ / Hour
Net idling cost of fuel | $ / Day
Net idling cost of fuel | $ / Year |  |  |  |  |  | `
FUEL SAVINGS TRUCK
Class 8 trucks w/sleepers and reefers @ Mkt share | Days / Year | 0.3 |  | 0.3
Cost of diesel | $ / Gallon
Diesel consumption while idling | Gallons / Hour | 0.5 |  | 0.5
Net idling cost of fuel | $ / Hour
Net idling cost of fuel | $ / Day
Net idling cost of fuel | $ / Year
WEAR & TEAR
[NAME] equivalent wear & tear per hour of net idling | Miles / Hour | 7
Net cost per idling mile | $ / Mile | 0.1 |  | 0.075
Net wear & tear cost | $ / Hour
Net wear & tear cost | $ / Day
Net idling cost of wear & tear | $ / Year
TOTAL AVERAGE SAVINGS OR OPPORTUNITY COST FROM IDLING
Total net anti-idling direct savings | $ / Hour
Total net anti-idling direct savings | $ / Day
Total net anti-idling direct savings | $ / Year
Spreadsheet: 469139d1467796658-count-cells-containing-yes-if-another-cell-says-yes-test
Sheet: Client Details

 |  |  |  |  |  | Type |  |  | Reasons for attending
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  |  |  |  |  | Yes |  |  | Yes | Yes | Yes |  | 3
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes |  |  |  | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes |  |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes | Yes
 |  |  |  |  |  | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  | Yes | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes
 |  |  |  |  |  | Yes | Yes |  |  | Yes | Yes | Yes
 |  |  |  |  |  | No |  |  |  | Yes | Yes
 | 1 | 16
 | 2 | 31
 | 3 | 31
 | 4 | 8
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 4835 | 5511 | 5 | 6 | 825 | 581 | 1458 | 895
2 | 5871 | 5511 | 20 | 6 | 860 | 581 | 1510 | 895
3 | 5772 | 5511 | 9 | 6 | 927 | 581 | 1471 | 895
4 | 5788 | 5511 | 29 | 6 | 944 | 581 | 1445 | 895
5 | 5337 | 5511 | 3 | 6 | 925 | 581 | 1425 | 895
6 | 5250 | 6011 | 142 | 6 | 913 | 581 | 1797 | 895
7 | 5202 | 6011 | 41 | 6 | 915 | 581 | 1586 | 895
8 | 5313 | 6011 | 1 | 6 | 912 | 581 | 1516 | 895
9 | 5045 | 6011 | 1 | 6 | 911 | 581 | 1472 | 895
10 | 5435 | 6011 | 1 | 6 | 861 | 581 | 1437 | 895
11 | 5574 | 6011 |  | 6 | 929 | 581 | 1452 | 895
12 | 5251 | 6011 |  | 6 | 942 | 581 | 1480 | 895
13 | 5369 | 6011 |  | 6 | 659 | 581 | 1401 | 895
14 | 5384 | 6011 |  | 6 | 987 | 581 | 1701 | 895
15 | 5372 | 6011 |  | 6 | 850 | 581 | 1457 | 895
16 | 5268 | 6011 |  | 6 | 918 | 581 | 1341 | 895
17 | 5258 | 6011 |  | 6 | 420 | 581 | 1428 | 895
18 | 5501 | 6011 |  | 6 | 988 | 581 | 1330 | 895
19 | 5670 | 6011 |  | 6 | 1026 | 581 | 1661 | 895
20 | 5708 | 6011 |  | 6 | 1020 | 581 | 1535 | 895
21 | 5756 | 6011 |  | 6 | 751 | 581 |  | 895
22 | 5775 | 6011 |  | 6 | 416 | 581 | 747 | 895
23 | 5726 | 6011 |  | 6 | 1054 | 581 | 1961 | 895
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | 341278
2002-02-23 00:00:00
CBS Volume
 |  |  | 135419
Spreadsheet: 148759d1333549557-calculating-points-and-divisions-of-students-scores-in-excel-edward
Sheet: Sheet1

S/N | NAMES | CIVICS |  | HISTORY |  | BIOLOGY |  | KISWAHILI |  | CHEMISTRY |  | BASIC MATHS |  | GEOGRAPHY |  | PHYSICS |  | ENGLISH |  | POINTS | DIVISION
1 | HAJI | 53 |  | 63 |  | 76 |  | 42 |  | 75 |  | 85 |  | 63 |  | 63 |  | 84
 | ALLY | 73 |  | 73 |  | 81 |  | 14 |  | 32 |  | 52 |  | 36 |  | 84 |  | 36
 | [NAME] | 64 |  | 76 |  | 86 |  | 57 |  | 68 |  | 76 |  | 54 |  | 65 |  | 77
 | ANNA | 32 |  | 65 |  | 24 |  | 52 |  | 62 |  | 62 |  | 61 |  | 73 |  | 62
 | HAMISI | 63 |  | 43 |  | 52 |  | 71 |  | 73 |  | 83 |  | 93 |  | 62 |  | 62
 | HUSNA | 9 |  | 7 |  | 5 |  | 13 |  | 16 |  | 72 |  | 72 |  | 61 |  | 5
 | KIBAKI | 30 |  | 35 |  | 27 |  | 38 |  | 27 |  | 38 |  | 29 |  | 21 |  | 23
 | GYIAN | 36 |  | 37 |  | 38 |  | 36 |  | 38 |  | 25 |  | 73 |  | 27 |  | 38
 | PRISCA | 53 |  | 61 |  | 35 |  | 35 |  | 14 |  | 26 |  | 24 |  | 25 |  | 61
 | [NAME] | 35 |  | 62 |  | 73 |  | 17 |  | 62 |  | 71 |  | 81 |  | 27 |  | 25
 | EDWARD | 92 |  | 87 |  | 92 |  | 72 |  | 83 |  | 82 |  | 63 |  | 36 |  | 73
 | AGNESS | 27 |  | 83 |  | 62 |  | 81 |  | 72 |  | 73 |  | 73 |  | 72 |  | 73
 | SALA | 37 |  | 73 |  | 81 |  | 82 |  | 61 |  | 73 |  | 36 |  | 36 |  | 36
 | [NAME] | 27 |  | 72 |  | 27 |  | 36 |  | 36 |  | 47 |  | 37 |  | 46 |  | 46
 | MASOYA | 38 |  | 18 |  | 26 |  | 46 |  | 47 |  | 46 |  | 46 |  | 47 |  | 47
 | AMOS | 76 |  | 76 |  | 86 |  | 86 |  | 86 |  | 88 |  | 86 |  | 68 |  | 86
Spreadsheet: 32616d1228811674-knock-out-draw-draw128
Sheet: SinglesDraw (2)

SINGLES
No. | ENTRANT | 128 | 64
1 | [NAME]
2 | Shane Clarke |  | 1
3 | C.Brownlie |  | 2
4 | [NAME]
5 | [NAME]
6 | [NAME] |  | 3
7 | [NAME] |  | 4
8 | [NAME]
9 | [NAME]
10 | [NAME] |  | 5
11 | [NAME] |  | 6
12 | [NAME]
13 | A.Moran
14 | Shane Garvey |  | 7
15 | [NAME] |  | 8
16 | [NAME]
17 | Brad Ingram
18 | [NAME] |  | 9
19 | [NAME] |  | 10
20 | [NAME]
21 | [NAME]
22 | [NAME] |  | 11
23 | [NAME] |  | 12
24 | Trent Whittingham
25 | [NAME]
26 | [NAME] |  | 13
27 | [NAME] |  | 14
28 | [NAME]
29 | Shane Allard
30 | [NAME] |  | 15
31 | [NAME] |  | 16
32 | [NAME]
33 | [NAME]
34 | [NAME] |  | 17
35 | [NAME] |  | 18
36 | [NAME]
37 | [NAME]
38 | [NAME] |  | 19
39 | [NAME] |  | 20
40 | [NAME]
41 | [NAME]
42 | [NAME] |  | 21
43 | I.Robson |  | 22
44 | B.Barker
45 | L.Tobias
46 | J.Webster |  | 23
47 | W.Hewitt |  | 24
48 | M.Sargeant
49 | J.Bailey
50 | P.Hale |  | 25
51 | P.Sweeny |  | 26
52 | R.Johnson
53 | D.Walters
54 | S.Knowles |  | 27
55 | B.Hazelgrove |  | 28
56 | G.Clough
57 | A.Pirie
58 | A.Rodgers |  | 29
59 | M.Blackmore |  | 30
60 | R.Hammond
61 | P.C.Hancox
62 | G.Lorenzetti |  | 31
63 | R.Baker |  | 32
64 | [NAME]
65 | S.Anger
66 | W.Hamilton |  | 33
67 | J.Curtis |  | 34
68 | W.Toomey
69 | B.Osborne
70 | [NAME] |  | 35
71 | [NAME] |  | 36
72 | Trent McMillan
73 | [NAME]
74 | [NAME] |  | 37
75 | [NAME] |  | 38
76 | [NAME]
77 | [NAME]
78 | [NAME] |  | 39
79 | [NAME] |  | 40
80 | [NAME]
81 | [NAME]
82 | [NAME] |  | 41
83 | [NAME] |  | 42
84 | [NAME]
85 | [NAME]
86 |  |  | 43
87 |  |  | 44
88
89
90 |  |  | 45
91 |  |  | 46
92
93
94 |  |  | 47
95 |  |  | 48
96
97
98 |  |  | 49
99 |  |  | 50
100
101
102 |  |  | 51
103 |  |  | 52
104
105
106 |  |  | 53
107 |  |  | 54
108
109
110 |  |  | 55
111 |  |  | 56
112
113
114 |  |  | 57
115 |  |  | 58
116
117
118 |  |  | 59
119 |  |  | 60
120
121
122 |  |  | 61
123 |  |  | 62
124
125
126 |  |  | 63
127 |  |  | 64
128
Spreadsheet: 831738d1685859851-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-individual
Sheet: DOM

Example | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | Calculation method used for reference | Remarks
1 | DOM | 2022-07-11 00:00:00 |  | 60 |  | 2 |  | (15*E2)/30 | 15 is the rate as per date and load criteria in sheet BB
2 | DOM | 2022-08-11 00:00:00 |  | 55 |  | 4.5 |  | (45*E3)/30 | 45 is the rate as per date and load criteria in sheet BB
Spreadsheet: 857354d1706373547-looking-for-a-formula-to-show-weekdays-based-on-start-and-end-of-weekday-selected-weekday_sample-1-
Sheet: HERE

 | Start of weekday | Monday
 | End of weekday | Saturday
 | Start of weekday | End of weekday
 | Weekday
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 193109d1352730730-how-to-get-sum-values-of-dropbox-if-not-sum-return-a-statement-testing
Sheet: Team 5

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QB |  | 1 |  |  |  |  |  | QB | RB | FB | WR | TE | T | G | C | DE | DT | OLB | MLB | CB | FS | SS | P/K
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RB |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FB |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WR |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TE |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OC |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DE |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DT |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OLB |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MLB |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CB |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FS |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SS |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PK |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quarter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Semi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | World Bl
RT--1 |  |  |  |  | FS--2
RT--1 |  |  |  |  | FS-3
RT--3 |  |  |  |  | SS--1
 |  |  |  |  | SS--2
 |  |  |  |  | SS--3
Spreadsheet: 753905d1635812957-cell-value-from-multiple-sheets-to-be-presented-in-master-sheet-michaelger-new-microsoft-excel-worksheet-2-
Sheet: 07112021

Country | A | B
Poland | [NAME] | Mark
U.K. | [NAME] | [NAME]
Italy | [NAME] | Ire
France | [NAME] | Lucas
Germany | [NAME] | [NAME]
Greece | [NAME] | Ire
Spain | Martin | [NAME]
Spreadsheet: john_forney__15504__200107
Sheet: Totals

 |  | Monthly Total by Desk |  |  | Static Sch Fees by Counterparty
 | ERCOT-ASSET |  |  | Reliant Energy HL&P
 | TECO-SVCE |  |  | Texas New Mexico Power
 | Hourly ERCOT |  |  | [NAME]
 | ST ERCOT |  |  | [NAME]
 | Hourly SE |  |  | Static Scheduling Fees Total
 | Hourly MW
 | TECO-BRAZOS SINK
 |  |  |  |  | Unplanned Losses by Counterparty
 |  |  |  | American Electric Power Services Corp
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Bryan Texas Utilities
 |  |  |  | City of Denton Municipal Utilities
 |  |  |  | City of Garland
 |  |  |  | City Public Services
 |  |  |  | Farmer's Electric Cooperative
 |  |  |  | Grayson-Collin Electric Cooperative
 |  |  |  | Greenville Electric Utiliy System
 |  |  |  | Lower Colorado River Authority
 |  |  |  | Magic Valley Electric Cooperative
 |  |  |  | Public Utilities Board of Brownsville
 |  |  |  | Reliant Energy HL&P
 |  |  |  | Rio Grande Electric Cooperative
 |  |  |  | South Texas Electric Cooperative
 |  |  |  | Southwest Electric Service Company
 |  |  |  | Texas Municipal Power
 |  |  |  | Texas New Mexico Power
 |  |  |  | Tex-La Electric Cooperative
 |  |  |  | TXU Electric Services
 |  |  |  | Total by Counterparty
 | Grand Total by Desk |  |  | Grand Total of Static Sch Fees and Unplanned Losses |  | Difference
 | American Electric Power Services Corp | CPLC
 | [NAME] | AENX
 | [NAME] | BEPCTMPP
 | Bryan Texas Utilities | BRYN
 | City of Denton Municipal Utilities | CODX
 | City of Garland | COGX
 | City Public Services | CPST
 | Farmer's Electric Cooperative | FECX
 | Grayson-Collin Electric Cooperative | GCEC
 | Greenville Electric Utiliy System | GEUS
 | Lower Colorado River Authority | LCRA
 | Magic Valley Electric Cooperative | MVEC
 | Public Utilities Board of Brownsville | PUBX
 | Reliant Energy HL&P | REIT
 | Rio Grande Electric Cooperative | RGEC
 | South Texas Electric Cooperative | STEC
 | Southwest Electric Service Company | SESC
 | Texas Municipal Power | TMPA
 | Texas New Mexico Power | TNMP
 | Tex-La Electric Cooperative | TXLA
 | TXU Electric Services | TUET
 | American Electric Power Services Corp | WTUC
 | American Electric Power Services Corp | CPLC
 | [NAME] | AENX
 | [NAME] | BEPCTMPP
 | Bryan Texas Utilities | BRYN
 | City of Denton Municipal Utilities | CODX
 | City of Garland | COGX
 | City Public Services | CPST
 | Farmer's Electric Cooperative | FECX
 | Grayson-Collin Electric Cooperative | GCEC
 | Grrenville Electric Utiliy System | GEUS
 | Lower Colorado River Authority | LCRA
 | Magic Valley Electric Cooperative | MVEC
 | Public Utilities Board of Brownsville | PUBX
 | Reliant Energy HL&P | REIT
 | Rio Grande Elerctic Cooperative | RGEC
 | South Texas Electric Cooperative | STEC
 | South Texas Electric Cooperative | SMEC
 | South Texas Electric Cooperative | MECX
 | Southwest Electric Service Company | SESC
 | Texas Municipal Power | TMPA
 | Texas New Mexico Power | TNMP
 | Tex-La Electric Cooperative | TXLA
 | TXU Electric Services | TUET
 | TXU Electric Services | TNMPTUET
 | TXU Electric Services | COCS
 | TXU Electric Services | TVEC
Spreadsheet: 491033d1480272840-time-formula-to-calculate-employees-working-working_hrs
Sheet: Sheet1

Start Date | Start time | End Date | End Time | Dur. (Hrs)
2016-11-16 00:00:00 | 23:00:00 | 2016-11-17 00:00:00 | 08:00:00
2016-11-17 00:00:00 | 17:00:00 | 2016-11-17 00:00:00 | 21:00:00
2016-11-17 00:00:00 | 19:25:00 | 2016-11-18 00:00:00 | 02:23:00
2016-11-18 00:00:00 | 08:00:00 | 2016-11-18 00:00:00 | 14:00:00
2016-11-17 00:00:00 | 15:15:00 | 2016-11-17 00:00:00 | 17:18:00
2016-11-18 00:00:00 | 05:00:00 | 2016-11-19 00:00:00 | 02:00:00
2016-11-18 00:00:00 | 07:15:00 | 2016-11-19 00:00:00 | 07:33:00