tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 711856d1609946613-repeat-a-row-multiple-times-sample-file
Sheet: Expected result

[NAME] | Name | UserId | Department | Role | Region | DBM Code | State | S Code | Dealership Location | Vertical
36972 | Deependra Kumar | 34883 | Aftermarket | ASM | WEST | 8401 | MAHARASHTRA | 1S3055 | Satara | Common
36973 | Deependra Kumar | 34884 | Aftermarket | ASM | WEST | 8402 | MAHARASHTRA | 1S3056 | Satara | HD
36974 | Deependra Kumar | 34885 | Aftermarket | ASM | WEST | 8403 | MAHARASHTRA | 1S3057 | Satara | HD PRO 6000
36975 | Deependra Kumar | 34886 | Aftermarket | ASM | WEST | 8404 | MAHARASHTRA | 1S3058 | Satara | LMD
36976 | Deependra Kumar | 34887 | Aftermarket | ASM | WEST | 8405 | MAHARASHTRA | 1S3059 | Satara | Parts
36977 | Deependra Kumar | 34888 | Aftermarket | ASM | WEST | 8406 | MAHARASHTRA | 1S3060 | Satara | Sub 5T
36971 | Deependra Kumar | 34882 | Aftermarket | ASM | WEST | 8401 | MAHARASHTRA | 1S3323 | Karad | BUS
36972 | Deependra Kumar | 34883 | Aftermarket | ASM | WEST | 8402 | MAHARASHTRA | 1S3324 | Karad | Common
36973 | Deependra Kumar | 34884 | Aftermarket | ASM | WEST | 8403 | MAHARASHTRA | 1S3325 | Karad | HD
36974 | Deependra Kumar | 34885 | Aftermarket | ASM | WEST | 8404 | MAHARASHTRA | 1S3326 | Karad | HD PRO 6000
36975 | Deependra Kumar | 34886 | Aftermarket | ASM | WEST | 8405 | MAHARASHTRA | 1S3327 | Karad | LMD
36976 | Deependra Kumar | 34887 | Aftermarket | ASM | WEST | 8406 | MAHARASHTRA | 1S3328 | Karad | Parts
36977 | Deependra Kumar | 34888 | Aftermarket | ASM | WEST | 8407 | MAHARASHTRA | 1S3329 | Karad | Sub 5T
37018 | [NAME] | 34940 | Aftermarket | CSM | WEST | 8400 | MAHARASHTRA | 1S3054 | Satara | BUS
37019 | [NAME] | 34941 | Aftermarket | CSM | WEST | 8401 | MAHARASHTRA | 1S3055 | Satara | Common
37020 | [NAME] | 34942 | Aftermarket | CSM | WEST | 8402 | MAHARASHTRA | 1S3056 | Satara | HD
37021 | [NAME] | 34943 | Aftermarket | CSM | WEST | 8403 | MAHARASHTRA | 1S3057 | Satara | HD PRO 6000
37022 | [NAME] | 34944 | Aftermarket | CSM | WEST | 8404 | MAHARASHTRA | 1S3058 | Satara | LMD
37023 | [NAME] | 34945 | Aftermarket | CSM | WEST | 8405 | MAHARASHTRA | 1S3059 | Satara | Parts
37024 | [NAME] | 34946 | Aftermarket | CSM | WEST | 8406 | MAHARASHTRA | 1S3060 | Satara | Sub 5T
37018 | [NAME] | 34940 | Aftermarket | CSM | WEST | 8401 | MAHARASHTRA | 1S3323 | Karad | BUS
37019 | [NAME] | 34941 | Aftermarket | CSM | WEST | 8402 | MAHARASHTRA | 1S3324 | Karad | Common
37020 | [NAME] | 34942 | Aftermarket | CSM | WEST | 8403 | MAHARASHTRA | 1S3325 | Karad | HD
37021 | [NAME] | 34943 | Aftermarket | CSM | WEST | 8404 | MAHARASHTRA | 1S3326 | Karad | HD PRO 6000
37022 | [NAME] | 34944 | Aftermarket | CSM | WEST | 8405 | MAHARASHTRA | 1S3327 | Karad | LMD
37023 | [NAME] | 34945 | Aftermarket | CSM | WEST | 8406 | MAHARASHTRA | 1S3328 | Karad | Parts
37024 | [NAME] | 34946 | Aftermarket | CSM | WEST | 8407 | MAHARASHTRA | 1S3329 | Karad | Sub 5T
Spreadsheet: 865166d1712225152-indirect-function-with-multiple-criteria-indirect-formula-with-multiple-criteria
Sheet: Summary (Day)

2024-04-02 00:00:00 | Total
Description | Shear | Details | Beam Weld | Total
Manpower on Board | 60 | 20 | 54
Manpower Attended | 43 | 11 | 41
Absent % | 0.2833333333333333 | 0.45 | 0.2407407407407407
Output | 71 | 27 | 60
Net Man Hrs / MT | 4.542253521126761 | 3.055555555555555 | 5.125
Requirement:
Need formula using INDIRECT function to get data from Worksheets w.r.t. Heading name (Row:2). Other criterias are: to get data on the basis on [NAME] (A1), Text in B1 and Description (Row: A:A)
Note: Will be adding sheets and columns and will ensure Sheet Names and Headings are same.
Spreadsheet: 841594d1693767167-formula-to-calculate-percentage-emmarky
Sheet: Sheet1

Question | Response
A1 | Yes |  |  |  |  | A1,A3,B1,B3,C1,C2,C4,D2,D4
A2 | yes
A3 | yes
A4 | no
B1 | no
B2 | n/a
B3 | yes
B4 | no
C1 | n/a
C2 | yes
[NAME] | no
C4 | n/a
D1 | yes
D2 | no
D3 | n/a
D4 | yes
Total percentage
Spreadsheet: 85367d1285376100-to-sum-up-the-datas-of-a-particulars-in-a-column-book1
Sheet: Sheet1

 | Particulars | Summary |  |  | 2010-04-01 00:00:00 |  |  | 2010-05-01 00:00:00 |  |  | 2010-06-01 00:00:00 |  |  | 2010-07-01 00:00:00 |  |  | 2010-08-01 00:00:00
 |  | Plant-1 | Plant-2 | Plant-3 | Plant-1 | Plant-2 | Plant-3 | Plant-1 | Plant-2 | Plant-3 | Plant-1 | Plant-2 | Plant-3 | Plant-1 | Plant-2 | Plant-3 | Plant-1 | Plant-2 | Plant-3
 | HSD |  |  |  | 2653 | 3212 | 6548 | 5269 | 9658 | 5287 | 1257 | 8598 | 52 | 1257 | 524 | 5698 | 123 | 548 | 6987
 | FO |  |  |  | 1254 | 2514 | 1256 | 5874 | 25698 | 5247 | 168 | 9258 | 5247 | 5214 | 5987 | 2568 | 1458 | 25698 | 2514
 | LDO |  |  |  | 1256 | 8975 | 2569 | 5874 | 2514 | 1937 | 1970 | 1973 | 1998 | 2002 | 1941 | 1936 | 1964 | 1936 | 1990
 | Total
Spreadsheet: b505803c-d2c8-48ad-89d3-dd3c9ff9c0c0
Sheet: Table 1.7

Monthly Statistical Bulletin
1.7 Industrial disputes
Quarter | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Working days lost – '000
September
December
March
June
Annual
Working days lost per '000 employees
September
December
March
June
Source: ABS, Industrial disputes, Cat. no. 6321.0.55.001 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6321.0.55.001&viewtitle=Industrial%20Disputes,%20Australia~Dec%202007~Latest~13/03/2008&&tabname=Past%20Future%20Issues&prodno=6321.0.55.001&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6321.0.55.001&viewtitle=Industrial%20Disputes,%20Australia~Dec%202007~Latest~13/03/2008&&tabname=Past%20Future%20Issues&prodno=6321.0.55.001&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6321.0.55.001&viewtitle=Industrial%20Disputes,%20Australia~Dec%202007~Latest~13/03/2008&&tabname=Past%20Future%20Issues&prodno=6321.0.55.001&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6321.0.55.001&viewtitle=Industrial%20Disputes,%20Australia~Dec%202007~Latest~13/03/2008&&tabname=Past%20Future%20Issues&prodno=6321.0.55.001&issue=Dec%202007&num=&view=& |  |  |  | Update:
Spreadsheet: 864465d1711629804-rank-order-by-up-to-4-progressive-criteria-golf-countback
Sheet: Sheet1

 | GM | FB | MB | TP | SB | FM
ROUND 1 | 36 | 36 | 40 | 40 | 38 | 29
LAST 9 | 18 | 19 | 20 | 20 | 17 | 17
LAST 6 | 5 | 5 | 4 | 7 | 6 | 9
LAST 3 | 4 | 5 | 6 | 5 | 4 | 6
LAST 1 | 3 | 2 | 2 | 1 | 3 | 4
Rank position
Rank position
Rank position
Spreadsheet: 89242d1288982583-conditional-linked-formatting-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Score
67.3 | 74.38222222222217 | 81.4644444444444 | 88.54666666666662 | 95.62888888888885 | 102.7111111111111 | 109.7933333333333 | 116.8755555555555 | 123.9577777777778 | 131.04
10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  | Score
67.3 | 74.38222222222217 | 81.4644444444444 | 88.54666666666662 | 95.62888888888885 | 102.7111111111111 | 109.7933333333333 | 116.8755555555555 | 123.9577777777778 | 131.04
10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: MG ROAD NEW

MG ROAD NEW |  |  |  |  |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN |  |  |  | LODIAN
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 200 AH Battery |  | 2
Spreadsheet: 872721d1719091845-sumproduct-sum-date-range-down-to-second-transactions-sample-time-tests
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  | SHOULD BE: |  |  |  |  |  |  | B4
FRIDAY |  |  |  |  |  |  |  |  |  |  |  | 6 | 488.64 |  |  |  |  | Not exactly decimal parts of Table1[Unit Date]
START TIME | END TIME |  |  |  |  |  |  |  |  |  |  | TRANSACTIONS | AMOUNT |  |  |  | Table1[Unit Date] | MOD(Table1[Unit Date];1) | B4-MOD(Table1[Unit Date];1)
00:00:00 | 00:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For 3.5.24 12:59:59 AM MOD(Table1[Unit Date];1) is less than value in B4
01:00:00 | 01:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45415.00111111111 | 0.001111111108912155
02:00:00 | 02:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45415.00113425926 | 0.00113425926247146
03:00:00 | 03:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45415.00181712963 | 0.001817129632399883
04:00:00 | 04:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45415.00194444445 | 0.001944444447872229
05:00:00 | 05:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45415.00194444445 | 0.001944444447872229
06:00:00 | 06:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45415.00208333333 | 0.002083333332848269
07:00:00 | 07:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45415.00247685185 | 0.002476851848769002
08:00:00 | 08:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45415.00320601852 | 0.003206018518540077
09:00:00 | 09:59:59
10:00:00 | 10:59:59
11:00:00 | 11:59:59
12:00:00 | 12:59:59
13:00:00 | 13:59:59
14:00:00 | 14:59:59
15:00:00 | 15:59:59
16:00:00 | 16:59:59
17:00:00 | 17:59:59
18:00:00 | 18:59:59
19:00:00 | 19:59:59
20:00:00 | 20:59:59
21:00:00 | 21:59:59
22:00:00 | 22:59:59
23:00:00 | 23:59:59
Spreadsheet: 33499d1229951530-logical-if-yesno
Sheet: Sheet1

Customer | Payment Status | Q1 | Q2 | Q3 | Q4
AA | Q | Yes | Yes | Yes | Yes
BB | H | Yes | Yes | No | No
CC | Y | Yes | No | No | No
Spreadsheet: 97545d1296682860-tracking-income-and-invoices-for-projects-multiple-search-results-test-project-tracking
Sheet: Aug 2010

 | Income and Expense Report
 |  | 2010-08-01 00:00:00
 |  | -53.9 | LOSS
 | Date | Payment Type | Reference / Debtor No. | Supplier Invoice Number | Income  ($) | Purchasing Property | Total Invoice Costs ($) | MAC | GN | HF | BM | Comments
 |  |  |  |  | 0 | -53.9 | 53.9 | 0 | 0 | 53.9 | 0
 | 2010-08-01 00:00:00 | Invoice Only | fA235292 | 40594 |  | [NAME] | 53.9 |  |  | 53.9
 |  |  |  |  |  |  | 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
 |  | PIF-ROW
 |  | Initial Instal'
 |  | Instalment
 |  | Final Instal'
 |  | Invoice Only
 |  | Other
Spreadsheet: 1ad6f877-cb39-4b78-ae15-7a17379a3181
Sheet: Sheet1

2008 FCS Survey Areas of Interest
Family Financial Management
Please match each topic with your comfort level
 | Not | Want to | Feel | Teach/
 | Interested | learn more | Competent | Mentor
2008 FCS Survey Questions
Strengthen Money Management Skills to Build Financial Security
Choose Consumer Goods and Services Wisely by Making Informed Decisions
Take Action Steps to Build Financial Assets and Reduce Debt
Organize and Maintain Household Records
Obtain, Monitor and Use Credit Wisely
Make Informed Decisions About Insurance, Medicare, or Prescription Drug Plans
Make Informed Decisions About Savings, Investments, and Retirement
Make Informed Tax Decisions
Make Informed Decisions About Estate Planning
Become aware of expansion of gambling in Kansas
Not on FCS Survey List but Agents Have Expressed Interest
What to Do When You Lose Your Job/Managing in Economic Crisis
For 3 Academic Credit Hours or 45 Continuting Education Units (CEUs)
Financial Behavior Assessment and Consulting
How to Motivate Clients to Achieve Financial Security
How Multicultural Diversity Impacts Financial Security
Other
a.
b.
c.
d.
e.
Spreadsheet: 142402d1329824728-processing-data-from-multiple-sheets-and-making-report-sample-file
Sheet: Sheet1

Quantity | Product/Item Code. | Description. | Unit Price. | Extended. | Remarks.
15 | MH-CL0505 | [NAME]. Sizes: [NAME], XL/5, 2XL/5 . | 5.85
8 | MH-CL0200 | Suede Coat. Sizes: M/2, [NAME], [NAME], 2XL/2 . | 35
50 | MH-B2001 | Leather Frog Color: Black | 2.2
2 | MH-A0811 | Chest Protection With Thai Pad | 80
3 | MH-A0900 | Shield | 22
5 | MH-A0906 | Gorget | 12
4 | MH-A0804 | Shoulder | 14
50 | MH-C0721 | [NAME] | 0.45
50 | MH-C0627 | [NAME] | 0.3
400 | MH-C0664 | Button | 0.2
200 | MH-C0616 | [NAME] | 0.2
30 | MH-C0795 | [NAME]
40 | MH-C0612 | [NAME] | 0.3
 |  | Freight: |  | 325
 |  | G.Total:
CTNS # | Item # | Packing List
 |  | Description
1 | MH-CL0505 | 15 Pcs. [NAME]. Sizes: [NAME], XL/5, 2XL/5 . | Received | 2011-04-11 00:00:00
2 | MH-A0811 | 2 Set. Chest Protection With Shin Guard | Received | 2011-04-11 00:00:00
3 | MH-CL0200 | 8 Pcs. Suede Coat. Sizes: M/2, [NAME], [NAME], 2XL/2 . | Received | 2011-04-11 00:00:00
4 | MH-A0900 | 3 Pcs. [NAME] | Received | 2011-04-11 00:00:00
 | MH-A0804 | 4 Pair. Shoulder
 | MH-A0906 | 5 Pcs. Gorget
 | MH-B2001 | 50 Pcs. Leather Frog Color: Black
 | MH-C0721 | 50 Pcs. [NAME]
 | MH-C0627 | 50 Pcs. [NAME]
 | MH-C0664 | 400 Pcs. Button
 | MH-C0795 | 30 Pcs. [NAME]
 | MH-C0612 | 40 Pcs. [NAME]
 | MH-C0616 | 200 Pcs. [NAME]
Spreadsheet: 767394d1644439921-conditional-formatting-based-on-date-gannt-chart
Sheet: Sheet1

 |  |  | Budgeted Goals
Start Date | End Date | Cost
2022-01-02 00:00:00 | 2022-03-01 00:00:00
2022-01-12 00:00:00 | 2022-01-14 00:00:00
2022-03-01 00:00:00 | 2022-06-30 00:00:00
2021-04-01 00:00:00 | 2022-05-01 00:00:00
Spreadsheet: 805157d1668552716-ref-error-example
Sheet: First Schedule

 |  | PO |  |  |  | Place holder
PRIORITY | PRIORITY |  |  |  |  | Place holder |  |  |  | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder
 |  |  | Part | LENGTH | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder
 |  |  | Part 1 | 10
 |  |  | Part 4 | 40
 |  |  | Part 3 | 15
 |  |  | Part 2 | 20
 |  |  | Part 6 | 35
 |  |  | Part 5 | 25
 |  |  | Part 8 | 38
 |  |  |  |  |  |  |  |  |  |  | Need data from other sheet above
Spreadsheet: 758377d1638835258-return-latest-date-for-billing-billing-formule-
Sheet: Sheet1

INSPECTION DATE | INSPECTION VALID TILL | INSPECTION LOCATION | BUSINESS PARTNER NAME | EQUIPMENT MODEL | EQUIPMENT NUMBER | LICENSE NUMBER | STATUS | CAT | BILLING
2021-06-23 00:00:00 | 2021-07-20 00:00:00 | PITBOX | LALA | BUS | POO174 | 8566CB | PASSED | 3 | YES
2021-07-17 00:00:00 | 2021-08-14 00:00:00 | PITBOX | LALA | BUS | POO174 | 8566CB | FAILED | 3 | YES
2021-07-18 00:00:00 | 2021-08-15 00:00:00 | PITBOX | LALA | BUS | POO174 | 8566CB | PASSED | 3 | NO
2021-08-14 00:00:00 | 2021-09-11 00:00:00 | AA AUTO SERVICE | LALA | BUS | POO174 | 8566CB | PASSED | 3 | YES
2021-11-18 00:00:00 | 2022-02-10 00:00:00 | NV ATHENA | FERNANDES | D-MAX | POO1233 | 0179KV | PASSED | 2 | YES
2021-11-18 00:00:00 | 2022-02-10 00:00:00 | NV ATHENA | FERNANDES | AMAROK | POO1234 | 3071JV | PASSED | 2 | YES
2021-11-18 00:00:00 | 2022-02-10 00:00:00 | NV ATHENA | MAJOR DRILLING | D-MAX | POO1235 | 0771KV | PASSED | 2 | YES
2021-11-19 00:00:00 | 2022-02-11 00:00:00 | NV ATHENA | TRAVERCO | [NAME] | POO1236 | 2244HV | PASSED | 2 | YES
2021-11-19 00:00:00 | 2022-02-11 00:00:00 | NV ATHENA | VMS | CARAVAN | POO1237 | 8251CB | PASSED | 4 | YES
2021-11-22 00:00:00 | 2021-12-19 00:00:00 | NV ATHENA | ZAYED | ROSA | POO1238 | 7306CB | PASSED | 3 | YES
2021-11-22 00:00:00 | 2021-12-19 00:00:00 | NV ATHENA | ZAYED | ROSA | [NAME] | 8067CB | PASSED | 3 | YES
2021-11-24 00:00:00 | 2022-02-16 00:00:00 | NV ATHENA | MAJOR DRILLING | RANGER | POO1240 | 7789JV | PASSED | 2 | YES
Spreadsheet: 799867d1665377922-cashflow-weekend-and-public-holiday-work-around-daily-cash-flow-sample
Sheet: Full Days

 |  |  | Actual |  | Observed
 |  | Descrip | Odate | Oday | Date | Day
 |  |  | 2022-12-01 00:00:00
 |  |  |  |  |  |  | Observed Date should be 28/12/22 Public holiday Falls on Weekend
 |  |  |  |  |  |  | Observed Date should be 3/1/23    Public holiday Falls on Weekend
Spreadsheet: 118353d1313617252-average-help-me-
Sheet: AUG 2011

 | MONTHLY INVOICES 2011
DAY | DATE | MONTH | DAY | WEEK
Monday | 2011-08-01 00:00:00 | 11222.36 | 11282.36
Tuesday | 2011-08-02 00:00:00 | 54212.28
Wednesday | 2011-08-03 00:00:00 | 70206.82
Thursday | 2011-08-04 00:00:00 | 127953.21
Friday | 2011-08-05 00:00:00 | 143670.21
Saturday | 2011-08-06 00:00:00 | 143670.21
Sunday | 2011-08-07 00:00:00 | 143670.21
Monday | 2011-08-08 00:00:00 | 151131.86
Tuesday | 2011-08-09 00:00:00 | 174123.22
Wednesday | 2011-08-10 00:00:00 | 223220.14
Thursday | 2011-08-11 00:00:00 | 261780.75
Friday | 2011-08-12 00:00:00 | 292987.83
Saturday | 2011-08-13 00:00:00 | 293427.83
Sunday | 2011-08-14 00:00:00 | 295107.83
Monday | 2011-08-15 00:00:00 | 0
Tuesday | 2011-08-16 00:00:00 | 0
Wednesday | 2011-08-17 00:00:00 | 0
Thursday | 2011-08-18 00:00:00 | 0
Friday | 2011-08-19 00:00:00 | 0
Saturday | 2011-08-20 00:00:00 | 0
Sunday | 2011-08-21 00:00:00 | 0
Monday | 2011-08-22 00:00:00 | 0
Tuesday | 2011-08-23 00:00:00 | 0
Wednesday | 2011-08-24 00:00:00 | 0
Thursday | 2011-08-25 00:00:00 | 0
Friday | 2011-08-26 00:00:00 | 0
Saturday | 2011-08-27 00:00:00 | 0
Sunday | 2011-08-28 00:00:00 | 0
Monday | 2011-08-29 00:00:00 | 0
Tuesday | 2011-08-30 00:00:00 | 0
Wednesday | 2011-08-31 00:00:00 | 0
Spreadsheet: 877292d1724079080-count-available-employees-in-employee-break-schedule-based-on-color-copy-of-breaks
Sheet: Master Break Schedule

 | 0700 | 0730 | 0800 | 0830 | 0900 | 0930 | 1000 | 1030 | 1100 | 1130 | 1200 | 1230 | 1300 | 1330 | 1400 | 1430 | 1500 | 1530 | 1600 | 1630 | 1700 | 1730 | 1800 | 1830 | 1900 | 1930 | 2000 | 2030 | 2100 | 2130 | 2200 | 2230 | 2300 | 2330 | 0000 | 0030 | 100 | 130 | 200 | 230 | 300 | 330 | 400 | 0500 | 0600 | 0700
Supervisor
Day 12 - 1
Day 12 - 2
Day 12 - 3
Day 12 - 4
Day 12 - 5
Day 12 - 6
Day 12 - 7
Day 12 - 8
Day 12 - 9
Day 24 - 1
Day 24 - 2
Day 24 - 3
Day 24 - 4
Day 24 - 5
Day 24 - 6
Day 24 - 7
Day 24 - 8
Day 24 - 9
Day 24 - 10
Night 12 - 1
Night 12 - 2
Night 12 - 3
Night 12 - 4
Night 12 - 5
Night 12 - 6
Night 12 - 7
OD (12 HR)
ON (12 HR)
FCD TOTALS | 7 | 7 | 7 | 7 | 7 | 7 | 6 | 6 | 6 | 6 | 6 | 5 | 6 | 6 | 6 | 6 | 8 | 8 | 9 | 9 | 9 | 9 | 5 | 5 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
FCS TOTALS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | sleep (1800-0100 or 0100-0700) |  |  |  |  |  |  |  |  |  |  |  | COMM PLAN
 |  |  | floor coverage |  |  |  |  |  |  |  |  |  |  |  | FIRE OC  VFIRE 22 & VFIRE 24 CDF A/G1 T16  AIR TACTICS 6   PROS VICTOR: HMT 135.575 SOLAR VICTOR: 130.200
 |  |  | break
 |  |  | 12-hour shifts - off duty hours
 | OD12 |  | 0900-2100 shift schedule
 | ON12 |  | 1300-0100 shift schedule
Spreadsheet: 119943d1314879400-inserting-rows-across-sheets-komet12_testing
Sheet: INTERVIEW

 |  | Last Name | First Name | Occp | Dept | Team | Shift | GMIN | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Spreadsheet: 38370d1236537402-calulating-average-fleet-age-excel-forum-post
Sheet: Sheet1

 | 2009 | 2010 | 2011
Year Model | Quantity | Quantity | Quantity
1997 | 24 | 6 | 0
1998 | 85 | 81 | 66
1999 | 77 | 67 | 57
2001 | 187 | 187 | 103
2003 | 80 | 79 | 44
2004 | 26 | 26 | 25
2005 | 241 | 241 | 216
Average Fleet Age By Year???
Spreadsheet: darrell_schoolcraft__7873__011018Da
Sheet: LegalSizeRegionLoc

ETS Planned And Unplanned Outages - May 1, 2001 Through May 31, 2002
Dakota Region Only - Sorted By Region/Location
The information provided is tentative and may be changed without further notice.  Northern Natural Gas, [NAME] and Florida Gas Transmission are not responsible for any reliance on this information.
Data Extracted October 18, 2001 |  |  |  |  |  |  |  |  |  |  |  | Est. Flow | Est. Vol. |  |  | Act. | Act. | Act. | Act.
No. | ID# | Region | Location | Units | Title | EstStart | EstComp | Duration | Line | Proj. Mgr | W.O. # | Affected | Affected | DescOfWork | DescOfWork2 | Start | Compl. | [NAME]. | Throughput | P/U | Pub | Ver
 |  |  |  |  |  |  |  |  |  |  |  | (Mmcfd) |  |  |  |  |  | mmcf/d | Affect
1 | 16073 | DAK | SO SIOUX | WAYNE CREEK | [NAME] | 2001-10-08 08:00:00 | 2001-10-25 16:00:00 | 17.3 | NEB57001 | 453 | C.014559 | 0 | 0 | Replace and lower approximately 900 feet of the 4" [NAME] at the Logan Creek crossing. |  |  |  | 0 |  | P | N | N
2 | 16074 | DAK | SO SIOUX | AKRON BL | AKRON BL | 2001-10-29 08:00:00 | 2001-11-08 16:00:00 | 10.3 | IAB72901 | 453 | C.014588 | 0 | 0 | Replace and lower approximately 60 ft of the 3" and 600' of the 6" Akron BL at the Big Sioux River Crossing MP 6.99. Affects IAB72901 & SDB94401 |  |  |  | 0 |  | P | N | N
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 5-3T

 | Section 5: Fuel Consumption
 | Table 5-3Trend:  Vehicle Inventory by Fuel Type by Year
 | Fuel Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Gasoline | 411870 | 399471 | 378685 | 364653 | 348566
 | Diesel | 83794 | 84693 | 85301 | 84589 | 83603
 | Gasoline Hybrid | 5582 | 10694 | 15531 | 15834 | 15892
 | Diesel Hybrid | 53 | 63 | 138 | 290 | 220
 | Gasoline LGHG | 0 | 0 | 1431 | 2187 | 1145
 | Diesel LGHG | 0 | 0 | 69 | 202 | 21
 | Gasoline Plug-in Hybrid | 0 | 0 | 9 | 167 | 509
 | CNG | 6486 | 5671 | 5144 | 1710 | 1519
 | E-85 | 143652 | 158300 | 169448 | 176271 | 180188
 | Electric | 57 | 3100 | 3941 | 3979 | 3848
 | Hydrogen | 4 | 5 | 7 | 4 | 5
 | LNG | 20 | 7 | 0 | 0 | 2
 | LPG | 185 | 150 | 154 | 175 | 230
 | Grand Total | 651703 | 662154 | 659858 | 650061 | 635748
 | Note: Pursuant to guidance from the Environmental Protection Agency pertaining to §141 of the Energy Independence and Security Act (EISA), beginning in 2011 petroleum fueled vehicles meeting EPA's definition of low greenhouse gas (LGHG) vehicles may be considered alternative fuel vehicles (AFVs) when acquired for use in locations where alternative fuel is not available. Therefore, although these vehicles consume petroleum, agencies may consider them alternative fuel vehicles in the limited circumstances described.