tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0148904f-f972-4acc-9d7e-b676829fbe39
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6457.0 International Trade Price Indexes, Australia
 | Tables 10 and 11. Export Price Index by Balance of Payments classification of exports, Index Numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  Rural goods total ; |  |  | Original | A2295687L | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Meat and meat preparations ; |  |  | Original | A2295693J | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Cereal grains and cereal preparations ; |  |  | Original | A2295696R | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Wool and sheepskins ; |  |  | Original | A2295699W | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Other rural ; |  |  | Original | A2295702X | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Non-rural goods total (excluding non-monetary gold) ; |  |  | Original | A2295690A | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Metal ores and minerals ; |  |  | Original | A2295705F | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  [NAME], coke and briquettes ; |  |  | Original | A2295708L | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Other minerals ; |  |  | Original | A2295711A | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  [NAME] (excluding non-monetary gold) ; |  |  | Original | A2295714J | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Machinery ; |  |  | Original | A2295717R | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Transport equipment ; |  |  | Original | A2295720C | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Other manufactures ; |  |  | Original | A2295723K | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Other non-rural ; |  |  | Original | A2295726T | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Non-monetary gold ; |  |  | Original | A2295681X | 1989-09-01 00:00:00 | 2011-03-01 00:00:00 | 87 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 545918d1509723032-formula-for-computing-frequency-of-programs-across-years-copy-of-sample_set_2-darko_giac-
Sheet: Raw

Year | Program
2011 | ABCD
2010 | ABCD
2015 | ABCD
2012 | ABCD
2017 | ABCD.ADM
2016 | ABCD.ADM
2014 | ABCD.ADM
2015 | ABCD.ADM
2012 | ABCD.ADM
2013 | ABCD.ADM
2016 | ABCD.HLTH
2014 | ABCD.HLTH
2015 | ABCD.HLTH
2012 | ABCD.HLTH
2013 | ABCD.HLTH
2010 | IMG.DIPLOMA
2011 | IMG.DIPLOMA
2016 | IMG.DIPLOMA
2014 | IMG.DIPLOMA
2015 | IMG.DIPLOMA
2012 | IMG.DIPLOMA
2013 | IMG.DIPLOMA
2017 | IMG.DIPLOMA
Spreadsheet: 157142d1337629976-to-copy-data-from-specific-selcted-col-to-another-col-book1
Sheet: Sheet1

 |  |  |  | 2012-05-21 00:00:00
 |  |  |  | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-25 00:00:00 | 2012-05-26 00:00:00 | 2012-05-27 00:00:00 | 2012-05-28 00:00:00
 |  |  |  | 18 | 36 | 4 | 26 | 42 | 78 | 93 | 17
 |  |  |  | 18 | 72 | 89 | 65 | 99 | 13 | 99 | 60
 |  |  |  | 99 | 6 | 55 | 17 | 6 | 89 | 59 | 29
 |  |  |  | 92 | 65 | 68 | 73 | 13 | 9 | 52 | 5
 |  |  |  | 100 | 4 | 62 | 38 | 65 | 16 | 91 | 99
 |  |  |  | 44 | 81 | 79 | 42 | 10 | 23 | 26 | 66
 |  |  |  | 98 | 40 | 72 | 91 | 43 | 12 | 70 | 94
 |  |  |  | 66 | 87 | 81 | 59 | 51 | 10 | 55 | 35
 |  |  |  | 3 | 81 | 44 | 43 | 5 | 93 | 25 | 4
 |  |  |  | 74 | 28 | 74 | 12 | 38 | 42 | 25 | 67
 |  |  |  | 85 | 78 | 84 | 33 | 38 | 49 | 87 | 75
 |  |  |  | 10 | 92 | 95 | 10 | 29 | 32 | 27 | 86
 |  |  |  | 61 | 11 | 9 | 5 | 3 | 64 | 72 | 18
 |  |  |  | 72 | 89 | 19 | 57 | 84 | 97 | 64 | 13
 |  |  |  | 53 | 84 | 20 | 30 | 93 | 30 | 22 | 86
 |  |  |  | 84 | 61 | 30 | 15 | 90 | 78 | 79 | 75
 |  |  |  | 65 | 49 | 27 | 79 | 33 | 24 | 55 | 8
Spreadsheet: 030e5525-ce19-44a1-a40f-a603eeb309a4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Title |  | Name |  | Month |  | Vendor |  | Amount |  | Description
City Manger |  | [NAME]
Mayor |  | [NAME]
City Councilors |  | [NAME]
 |  | Alonzo Clayton
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Municipal Judge |  | [NAME] |  | 2013-08-01 00:00:00 |  |  |  | $148.74 Mileage Reimbursement |  | New Mexico Municipal League Conference, Taos, NM
 |  |  |  | 2013-09-01 00:00:00 |  |  |  | $54.39 Mileage Reimbursement |  | New Mexico Municipal League Meeting, Santa Fe, NM
Spreadsheet: 862900d1710474869-dynamic-lookup-that-omits-blank-rows-in-the-results-geddbconundrum
Sheet: Data1

[NAME] | ü |  | ü |  | ü
[NAME] |  |  | ü |  | ü
Fred
Barney | ü |  |  |  | ü
[NAME] | ü
Barney |  | ü
[NAME]
Fred |  | ü | ü | ü | ü
Fred
[NAME] |  |  | ü | ü | ü |  | ü
Barney |  |  | ü | ü
Spreadsheet: 723c28e5-dc1a-4061-a4a7-f95b95523486
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5816 | 8122 | Lynda | Lemon | CAN | 0 | 00:52:03 | [NAME] | 01:46:36 | 00:01:44 | 00:25:13 | 1 | 03:07:21
5816 | 12462 | [NAME] | Bould | NZL | 0 | 00:55:00 | 00:01:38 | 01:45:03 | 00:01:51 | 00:33:13 | 2 | 03:16:48
5816 | 12569 | Barb | Morgan | USA | 0 | 01:01:05 | 00:01:17 | 01:54:28 | 00:01:27 | 00:32:54 | 3 | 03:31:13
5816 | 16778 | [NAME] | Law | GBR | 0 | 00:57:18 | 00:02:07 | 02:03:40 | [NAME] | 00:30:07 | 4 | 03:36:07
5816 | 12576 | Virginia | Poyner | USA | 0 | 01:12:52 | 00:02:21 | 01:54:35 | 00:03:44 | [NAME] | 5 | 03:56:25
5816 | 24361 | [NAME] | Askey | GBR | 0 | [NAME] | 00:02:01 | [NAME] | [NAME] | 00:35:48 | 6 | 04:08:32
Spreadsheet: 774330d1648397396-5-year-moving-average-that-restarts-at-every-new-category-test-sheet-fig-7-copy-3-
Sheet: Sheet1

Country | Year | Calorie intake | 5 year moving average + first 5 years use the 5th value | How can I replicate column D with a formula?
Afghanistan | 1961 | 2069.31 | 2004.174
Afghanistan | 1962 | 2012.73 | 2004.174
Afghanistan | 1963 | 1861.62 | 2004.174
Afghanistan | 1964 | 2037.57 | 2004.174
Afghanistan | 1965 | 2039.64 | 2004.174 | 2004.174
Afghanistan | 1966 | 1888.53 | 1968.018 | 1968.018
Afghanistan | 1967 | 2049.99 | 1975.47 | 1975.47
Afghanistan | 1968 | 2013.42 | 2005.83 | 2005.83
Afghanistan | 1969 | 2025.15 | 2003.346 | 2003.346
Afghanistan | 1970 | 1748.46 | 1945.11 | 1945.11
Afghanistan | 1971 | 1733.28 | 1914.06 | 1914.06
Albania | 1963 | 1487.64 | 1545.048
Albania | 1964 | 1566.3 | 1545.048
Albania | 1965 | 1555.26 | 1545.048
Albania | 1966 | 1555.26 | 1545.048
Albania | 1967 | 1560.78 | 1545.048 | 1545.048
Albania | 1968 | 1616.67 | 1570.854 | 1570.854
Albania | 1969 | 1658.76 | 1589.346 | 1589.346
Albania | 1970 | 1666.35 | 1611.564 | 1611.564
Albania | 1971 | 1628.4 | 1626.192 | 1626.192
Algeria | 1965 | 1097.79 | 1134.36
Algeria | 1966 | 1083.99 | 1134.36
Algeria | 1967 | 1136.43 | 1134.36
Algeria | 1968 | 1177.14 | 1134.36
Algeria | 1969 | 1176.45 | 1134.36 | 1134.36
Algeria | 1970 | 1155.75 | 1145.952 | 1145.952
Algeria | 1971 | 1186.8 | 1166.514 | 1166.514
Angola | 1961 | 1240.62 | 1270.842
Angola | 1962 | 1255.11 | 1270.842
Angola | 1963 | 1278.57 | 1270.842
Angola | 1964 | 1284.78 | 1270.842
Angola | 1965 | 1295.13 | 1270.842 | 1270.842
Angola | 1966 | 1304.1 | 1283.538 | 1283.538
Angola | 1967 | 1325.49 | 1297.614 | 1297.614
Angola | 1968 | 1280.64 | 1298.028 | 1298.028
Angola | 1969 | 1342.74 | 1309.62 | 1309.62
Angola | 1970 | 1355.85 | 1321.764 | 1321.764
Spreadsheet: darrell_schoolcraft__7306__imball0201
Sheet: Plains

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1
2
3
4
5
6
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
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 107948.28
2001-12-31 00:00:00
CBS Volume
 |  |  | 36315
Spreadsheet: darrell_schoolcraft__7529__Outweeknng0222
Sheet: Sheet1

NNG WEEKLY OUTAGE REPORT
NORTHERN NATURAL GAS
 | Location | Date | Scope | Comments
NNG | Garner | 12/04/01 to 04/30/02 | Refrigerant compressor is being shipped to York International for repairs. | Est. Flow affect - Not able to to liquifey and gas during this outage. The tank is about 80% full going into January.
NNG | Waterloo   Unit 6 | 02/11/02 to 02/27/02 | Packing and compressor rings. | Flow affect = 0 mmcfd.
NNG | Bushton  31 | 02/27/02 to 02/29/02 | Replace a section of the exhaust header. (We will try and wait until north flows drop off). | Flow affect = 0 mmcfd.
NNG | Burdett | 02/27/02 to 02/27/02 | Replace valve. 4 to 5 hrs | Flow affect = 0 mmcfd.
NNG | [NAME] 3 | 03/11/02 to 04/05/02 | [NAME] | Flow affect = 3 mmcfd.
NNG | Canadian  1&3 | 03/12/02 to 03/12/02 | Relief valve testing.  8 hrs. | Flow affect = 3 mmcfd.
NNG | Northrup 1&2 | 03/19/02 to 03/19/02 | Relief valve testing.  8 hrs. | Flow affect = 15 mmcfd.
NNG | [NAME] | 03/18/02 to 03/18/02 | Relief valve testing.  8 hrs. | Flow affect = 7 mmcfd.
NNG | Plains Turbine | 03/19/02 to 03/20/02 | Annual ESD   32 hrs. (We will see if EL Paso can work with us during this outage). | Flow affect = 100 mmcfd.
Spreadsheet: 156295d1337256599-how-to-copy-data-from-master-list-sheet-to-another-sheet-based-on-category-ifjsss-round-2-data
Sheet: Master

 | Master List
No | RIDER | TEAM | CRAFT | CRAFT TYPE | CATEGORY
 |  |  |  |  | Pro Am Open | Pro Am Stock | Ladies Open | Veterans | You can hide this columns J to M
1 | [NAME] | Club [NAME] (CTM) | ML 20 | SeaDoo | Yes |  |  | Yes |  |  |  |  | 6
2 | [NAME] | Waklan Racing Team | WL 2 | SeaDoo | Yes |  |  |  |  |  |  |  | 7
3 | [NAME] | Fishbone Racing Team | 9 | SeaDoo |  |  |  |  |  |  |  |  | 8
4 | [NAME] | X1 Racing Team | 314 | SeaDoo |  | Yes |  |  |  |  |  |  | 9
5 | [NAME] | WL Racing Team | WL 1 | SeaDoo | Yes | Yes |  | Yes |  |  |  |  | 10
6 | [NAME] | Fishbone Racing Team | 29 | SeaDoo |  | Yes |  |  |  |  |  |  | 11
7 | [NAME] | [NAME] | 6 | SeaDoo |  | Yes |  |  |  |  |  |  | 12
8 | [NAME] | Meganrata Racing Team | ML 3 | SeaDoo | Yes | Yes |  |  |  |  |  |  | 13
9 | Elgernon [NAME] | [NAME] | 811 | SeaDoo | Yes | Yes |  | Yes |  |  |  |  | 14
10 | [NAME] | Huat Motor Sports | 88 | SeaDoo | Yes |  |  |  |  |  |  |  | 15
11 | [NAME] | Meganrata Racing Team | 5 | SeaDoo |  |  |  |  |  |  |  |  | 16
12 | [NAME] | Yamaha Racing Team | 16 | Yamaha |  |  |  |  |  |  |  |  | 17
13 | [NAME] | Team LT-Kawasaki | 89 | SeaDoo | Yes | Yes |  |  |  |  |  |  | 18
14 | [NAME] | [NAME] | ML 61 | SeaDoo | Yes |  |  | Yes |  |  |  |  | 19
15 | [NAME] | Club Racing Team (CTM) | 25 | SeaDoo |  | Yes |  |  |  |  |  |  | 20
16 | [NAME] [NAME] | [NAME] | 318 | Kawasaki | Yes | Yes |  | Yes |  |  |  |  | 21
17 | [NAME] | Team LT-Kawasaki | 17 | Kawasaki |  |  |  | Yes |  |  |  |  | 22
18 | [NAME] | Huat Motor Sports | 8 | SeaDoo |  |  |  | Yes |  |  |  |  | 23
19 | [NAME] | Meganrata Racing Team | 7 | SeaDoo | Yes | Yes |  | Yes |  |  |  |  | 24
20 | [NAME] | X1 Racing Team | ML 7 | Kawasaki | Yes | Yes |  |  |  |  |  |  | 25
21 | [NAME] | [NAME] | 29 | SeaDoo |  | Yes |  |  |  |  |  |  | 26
22 | Ika [NAME] | Club [NAME] (CTM) | 373 | Yamaha |  |  | Yes |  |  |  |  |  | 27
23 | [NAME] | Team LT-Kawasaki | 17 | Kawasaki |  |  | Yes |  |  |  |  |  | 28
24 | [NAME] | Club [NAME] (CTM) | 37 | Yamaha |  |  | Yes |  |  |  |  |  | 29
25 | [NAME] binti [NAME] | Team LT-Kawasaki | 89 | Kawasaki |  |  | Yes |  |  |  |  |  | 30
Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 05-07

ES3/C&S WHOLESALE LOAD TRACKING
STOP 1 WILL ALWAYS BE ORIGIN - LEAVE SECTION BLANK FOR ANY NON-APPLICALBE STOP, ON ANY GIVE LOAD
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 32802 |  | Hammond
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21886 |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 93024 |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
Spreadsheet: 797239d1663772245-convert-hours-to-years-months-weeks-days-and-hours-jomili-about-time
Sheet: Sheet1

 | Leave Balances as of 9/6/2022 | Annual Leave | [NAME] | FLSA Overtime | Regular Comptime | Holiday Comptime | [NAME]
 | Current | 301.75 | 1831.75 | 0 | 0 | 0 | 0
 | Pending Approval | 1 | 0.25 | 0 | 0 | 0 | 0
 | Available | 300.75 | 1831.5 | 0 | 0 | 0 | 0
 | Leave Balances as of 8/1/2022 | Annual Leave | [NAME] | FLSA Overtime | Regular Comptime | Holiday Comptime | [NAME]
 | Current | 311.75 | 1823.75 | 0 | 0 | 0 | 0
 | Pending Approval | 25 | 0 | 0 | 0 | 0 | 0
 | Available | 286.75 | 1823.75 | 0 | 0 | 0 | 0
 | Differences | Annual Leave | [NAME] | FLSA Overtime | Regular Comptime | Holiday Comptime | [NAME]
 | Current | -10 | 8 | 0 | 0 | 0 | 0
 | Pending Approval | -24 | 0.25 | 0 | 0 | 0 | 0
 | Additional Available | 14 | 7.75 | 0 | 0 | 0 | 0
 |  | Total Hours | 8 hr Days
 | Current Available balance total |  |  |  |  |  | 266 workdays 4.25 hours
 |  | Years | Months | Weeks | Days | Hours
 | Total in Time Units
 | Leftover hours per calculation
 |  | Hours per month
 |  | Hours per week | 40
 |  | Hours per Day | 8
 |  | Alternative Calculations
Spreadsheet: 207995d1358638241-tough-database-example
Sheet: Sheet1

Motor # | Curr Eq#/Loc | Date In | RPM | Hp | Frame | 1st Equip | 1st Conn | 1st Disc | Days | 1st OH | 1st OH Code | 2nd Equip | 2nd Conn | 2nd Disc | Days | 2nd OH | 2nd OH Code | 3rd Equip | 3rd Conn | [NAME] | 3rd OH | 3rd OH Code
A0001 | 6241 | 2011-07-03 00:00:00 | 710 | 800 | 8409S | 6241 | 2003-01-15 00:00:00 | 2006-01-20 00:00:00 |  | 2006-01-24 00:00:00 | 1 | 6241 | 2007-02-26 00:00:00 | 2009-05-11 00:00:00 |  | 2009-05-16 00:00:00 | 1 | 6241 | 2011-07-03 00:00:00
A0002 | C & H grd flr | 2009-03-10 00:00:00 | 1730 | 10 | 215T | 6432 | 2004-05-06 00:00:00 | 2007-09-02 00:00:00
A0007 | C & H grd flr | 2011-11-09 00:00:00 | 1780 | 200 | 444/5T | 6653 | 2008-02-24 00:00:00 | 2009-06-08 00:00:00 |  | 2006-11-01 00:00:00 | 1
A0008 | 7750 | 2008-02-24 00:00:00 | 1190 | 60 | 4041 | 7750 | 2008-02-24 00:00:00
A0014 | C & H grd flr | 2011-07-09 00:00:00 | 710 | 800 | 8409S | 6241 | 2006-01-20 00:00:00 | 2007-02-26 00:00:00 |  | 2007-03-05 00:00:00 | 2 | 6241 | 2009-05-11 00:00:00 | 2011-07-03 00:00:00 |  | 2011-07-09 00:00:00 | 1
[NAME] | 6104 | 2012-06-16 00:00:00 | 1770 | 150 | 445TC | 6104 | 2012-06-16 00:00:00
A0017 | C & H grd flr | 2011-08-10 00:00:00 | 1160 | 1.5 | 18272 | 6103 | 2007-04-05 00:00:00 | 2011-06-09 00:00:00 |  | 2011-06-15 00:00:00 | 1
A0018 | 7831 | 2012-11-13 00:00:00 | 1675 | 10 | 184C | 7831 | 2012-11-13 00:00:00
A0024 | 6501A | 2012-07-13 00:00:00 | 1800 | 75 | 365T | 6501A | 2012-07-13 00:00:00
A0025 | 7474 | 2011-06-20 00:00:00 | 3600 | 3 | 184T | 7474 | 2011-06-20 00:00:00
A0028 | 6836 | 2009-10-23 00:00:00 | 1755 | 20 | 256T | 6834 | 2006-09-01 00:00:00 | 2009-03-28 00:00:00 |  | 2009-04-05 00:00:00 | 2 | 6836 | 2009-10-23 00:00:00
Spreadsheet: 540366d1506659587-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: September 2017 Summary

September 2017 Summary |  | Total Job Hours | Total Hours-Per Job
#
Job |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
1 |  |  | x
2 |  |  |  | x
3 |  |  |  |  | x
4 |  |  |  |  |  | x
5 |  |  |  |  |  |  | x
6 |  |  |  |  |  |  |  | x
7 |  |  |  |  |  |  |  |  | x
 | less shop hours
 | Hours less Shop
1 |  |  | x
2
3 |  |  |  |  | x
11
12
13
14
 | less shop hours
 | Hours less Shop
Hours without Shop
Shop Hours-Total
Totals
%
Vehicles
 | Fuel
 | Repairs & Maintenance
 | Total Overhead
 | % of month | 0.333
Spreadsheet: 191313d1352061298-problem-collating-some-info-results-test
Sheet: Sheet1

Name | T1 | S1 | R1 | P1 | T2 | S2 | R2 | P2 | T3 | S3 | R3 | P3 | T4 | [NAME] | R4 | P4 | T5 | S5 | R5 | P5 | ETC… up to 30
1 |  | A | X | OFF
2 |  |  |  |  |  | H | X | ON
3 |  | B | Y | ON |  | I | X | OFF |  |  |  |  |  |  |  |  |  | H | X | ON
4 |  |  |  |  |  | J | X | ON |  |  |  |  |  |  |  |  |  | I | X | OFF
5 |  |  |  |  |  | K | X | ON |  |  |  |  |  | H | X | ON |  | J | X | ON
6 |  | C | Z | OFF |  | L | X | OFF |  |  |  |  |  | I | X | OFF |  | K | X | ON
7 |  |  |  |  |  |  |  |  |  | H | Z | ON |  | J | X | ON |  | L | X | OFF
8 |  | D | X | ON |  |  |  |  |  | I | Z | OFF |  | K | X | ON |  | M | X | OFF | P3 | I | Z | M | X
9 |  | E | Y | ON |  |  |  |  |  | J | Z | ON |  | L | X | OFF |  | N | X | ON
10 |  | F | Z | OFF |  |  |  |  |  | K | Z | OFF |  | T | Y | OFF |  | O | X | OFF | P1 | E | Y | P3 | K | Z | P4 | T | Y | P5 | O | X
11 |  | G | Z | ON |  |  |  |  |  | L | Z | OFF |  |  |  |  |  | P | X | ON
12 |  |  |  |  |  |  |  |  |  | M | Z | ON |  |  |  |  |  | Q | X | ON
13 |  |  |  |  |  |  |  |  |  | N | Z | ON |  |  |  |  |  | R | Z | OFF
14 |  |  |  |  |  |  |  |  |  | O | Z | OFF |  |  |  |  |  | S | Y | ON
15 |  |  |  |  |  | M | Y | ON |  | P | Z | ON |  | M | Y | ON |  | T | X | OFF
16 |  |  |  |  |  | N | Y | ON |  | Q | Z | ON |  | N | Z | ON
17 |  |  |  |  |  | O | Y | OFF |  | R | Z | OFF |  | O | Z | OFF
18 |  |  |  |  |  | P | Y | ON |  | S | Z | ON |  | P | Y | ON
19 |  |  |  |  |  |  |  |  |  | T | Z | OFF
Spreadsheet: 227237d1365637792-delete-mass-pictures-and-check-boxes-in-a-column-coupon-work_automated
Sheet: FredMeyer

Product | Description | Price | Valid | Qty | Remove All |  |  |  | Suptv-Date | Suptv-Item | [NAME]
Best Foods Mayonnaise | Select Varieties, 30 oz | 2 for $5 | 4/7/13 - 4/13/13 |  | [NAME]
Country [NAME] or Buns | Select Varieties, 16-24 oz Bread, 8 ct Buns or 22.5 oz Vita-Bee Bread | 4 for $5 | 4/7/13 - 4/13/13 |  | [NAME]
Coca-Cola, Pepsi or 7UP | Select Varieties, 12 pk, 12 oz Cans | 3 for $12 | 4/7/13 - 4/13/13 |  | [NAME]
Crest Toothpaste | Select Varieties, 8.2 oz | 2 for $4 | 4/7/13 - 4/13/13 |  | [NAME]
Kellogg's Cereal | or Nature Valley Granola Bars, 5-12 ct, [NAME], 12 oz, [NAME] or Fruit Loops, 12.2 oz, Corn Pops, 12.5 oz, Cocoa Krispies, 16.5 oz, Frosted Flakes, 17 oz, Raisin Bran Crunch, 18.2 oz or [NAME], 20 oz | 2 for $5 | 4/7/13 - 4/13/13 |  | [NAME]
Spreadsheet: 7c197883-1279-45c6-8201-8dc2e0107524
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: | 49 | 73
2011-01-14 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 | 1 | 1 | 1 | 2 | 0.5 |  | 1 | 0 | 5 | 1 | 1 | 2 |  |  | 1 | 3 | 5 | 1
[NAME] | 1 | 3 | 9 | 0.3333333333333333 | 3 | 3 | 1 | 6 | 0.5 |  |  |  | 15 | 1 | 1 | 2 |  | 1 |  | 2 | 2 | 1
[NAME] | 1 |  |  |  |  | 1 | 0 | 0 | 0 |  |  |  | 0 |  |  | 0 |  |  |  | 1 | 1 | 1
EJ Havens10 | 1 |  | 1 | 0 |  |  |  | 0 | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 1
[NAME] | 1 |  | 1 | 0 | 2 | 2 | 1 | 2 | 0.6666666666666666 |  |  |  | 4 | 1 |  | 1 |  |  | 2 | 1 | 1 | 1
[NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
Gage Vasquez12 | 1 | 1 | 6 | 0.1666666666666667 | 4 | 10 | 0.4 | 5 | 0.3125 | 2 | 4 | 0.5 | 13 | 5 | 5 | 10 | 2 |  | 2 | 3 | 1 | 2
[NAME] | 1 | 3 | 6 | 0.5 |  | 2 | 0 | 3 | 0.375 |  |  |  | 9 | 1 | 2 | 3 |  |  | 1 | 1 | 3 | 4
[NAME] | 1 |  |  |  | 1 | 5 | 0.2 | 1 | 0.2 | 1 | 2 | 0.5 | 3 |  |  | 0 |  |  | 2 | 2 | 4 | 5
Hugh Ramlow10 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
[NAME] | 1 |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 1 |  | 1
Art Doom10 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
[NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
Brady Harwood10 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
[NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  | 0
TOTALS | 1 | 8 | 26 | 0.3076923076923077 | 11 | 24 | 0.4583333333333333 | 19 | 0.38 | 3 | 7 | 0.4285714285714285 | 49 | 10 | 9 | 19 | 2 | 1 | 8 | 13 | 17 | 16