tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward |  | 10187-01 | 9089-01 | 10522
 | Measured | Scheduled | Measured | Scheduled |  |  | Del | recpt
1 | -5234 | -5000 |  | -21274 |  | -20950 | -6
2 | -5328 | -5000 |  | -21274 |  | -21285 | -6
3 |  |  |  | -11843 |  | -12124 | -106
4 |  |  |  | -23304 |  | -3519 | -19999 | 1
5 |  |  |  | -14046 |  | 0 | -14568
6 |  |  |  | -14442 |  | 0 | -10070 | 4
7 |  |  |  | -14046 |  | -11018 | 0
8 |  |  |  | -40692 |  | -27027 | -1 | 3239
9 |  |  |  | -15474 |  |  | 0
10 |  |  |  | -15473 |  |  | -28
11 |  |  |  | -25367 |  |  | -25154 | 1
12 |  |  |  | -5474 |  |  | -8
13 |  |  |  | -5474 |  | -2931 | -11554
14 |  |  |  | -5474 |  | -2931
15 |  |  |  | -33250 |  | -14542 | -19966
16 |  |  |  | -15561 |  |  | -15603
17 |  |  |  | -37474 |  | -35137
18 |  |  |  | -19629 |  | -19715
19 |  |  |  | 5659 |  | -161
20 |  |  |  | -14341 |  | -7781
21 |  |  |  | -14341 |  | -14775
22
23
24
25
26
27
28
29
30
31
index
2001-12-31 00:00:00 |  |  |  |  | 417969.39
2002-01-21 00:00:00
CBS Volume
 |  |  | 5124
Spreadsheet: 291850d1390419002-scenario-testing-and-stepped-table-excel
Sheet: Sheet1

 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 | Scenario 1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.3 | 0.1
 | Scenario 2 | 0.4 | 0.5 | 0.6 | 0.7 | 0.4 | 0.4
Spreadsheet: 46959d1245870396-combine-several-spreadsheets-into-one-vendor-documents-register-p01-20090622
Sheet: AEG

No. | P.O. No. | Submitted Date | Tansmittal No. | [NAME]) | Vendor Document No. | Document Title | Latest  Version | Vendor | Status | Comments (Y,N) | Transmittal Returned By Eng.Dept | Status | Date | Transmittal Returned by Company | Status | Date | Remarks
1 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-ED-AEG-00001 |  | Document list | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
2 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-EB-AEG-00002 |  | BOM of 110V DC Charger | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
3 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-EB-AEG-00003 |  | BOM of 110V DC Distribution Board1 | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
4 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-EB-AEG-00004 |  | BOM of 110V DC Distribution Board2 | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
5 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-EB-AEG-00005 |  | BOM of 110V DC Distribution Board3 | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
6 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-FU-AEG-00006 |  | Schematic Diagram of 110V DC Charger | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
7 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-FU-AEG-00007 |  | Schematic diagram of 110V DC Distribution Board 1 | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
8 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-FU-AEG-00008 |  | Schematic diagram of 110V DC Distribution Board 2 | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
9 | 3435-510-PO-0076A | 2008-12-17 00:00:00 | WIP-PCU-ENG-TN-0310 | 3435-510-E-FU-AEG-00009 |  | Schematic diagram of 110V DC Distribution Board 3 | P00 | AEG | A | Y | WIP-PCU-ENG-TN-0310 Comments | B | 2008-12-19 00:00:00
10 | 3435-510-PO-0076A | 2008-12-25 00:00:00 | WIP-PCU-ENG-TN-0322 | 3435-510-E-ED-AEG-00001 |  | Document list | P01 | AEG | A | Y | WIP-PCU-ENG-TN-0322 Comments | A | 2009-12-31 00:00:00
Spreadsheet: 9c5dc4a8-79b5-4310-9bfc-9b5a83d4478a
Sheet: Table 1.1

Monthly Statistical Bulletin
1.1 Employment
Month | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 20012–13
Number employed (a) – '000
July
August
September
October
November
December
January
February
March
April
May
June
Annual average
Annual change (a) – per cent
July
August
September
October
November
December
January
February
March
April
May
June
Annual average
(a) Monthly figures are seasonally adjusted. |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0
Spreadsheet: 715667d1611823230-minimum-dates-excel-help
Sheet: Sheet1

 |  |  |  |  | Training
Name | Date Started | Date Completed | Date Reviewed | Date Resat | 101 | 102 | 103 | 104 | 105 | 106 | Earliest Date
Fred | 2020-01-23 00:00:00 | 2020-01-24 00:00:00 | 2020-01-25 00:00:00 | 2020-01-26 00:00:00 | 1 |  |  |  |  | 1
Jan |  |  |  |  |  | 1 |  |  |  | 1
[NAME] | 2019-05-24 00:00:00 | 2019-05-25 00:00:00 | 2019-05-26 00:00:00 | 2019-05-27 00:00:00 | 1 |  | 1 |  | 1 | 1
Ian | 2020-02-01 00:00:00 |  |  |  | 1 |  | 1 |  | 1 | 1
[NAME] | 2//2/19 |  |  |  |  |  |  | 1
[NAME] | 2020-04-26 00:00:00
[NAME]
 |  | If columns F:K have a 1 in them, what is the earliest date in columns B:E without counting any of the blanks
Spreadsheet: 738918d1625338696-calculation-results-on-a-cell-calcolo
Sheet: Foglio2

CT |  | T1 | T2 | T3 | T4
1 |  | 10 | 6 | 56 | 20
1 |  | 21 | 56 | 35 | 10
2 |  | 80 | 6 | 56 | 78
2 |  | 33 | 45 | 60 | 90
1 |  | 100 | 257 | 34 | 566
Spreadsheet: 799995d1665424886-date-formula-to-show-on-time-and-late-with-exceptions-help_etaf
Sheet: Sheet1

TAFQAR Date | Mfg | Mfg docs to QA | TAFQAR STATUS MFG
2022-10-03 00:00:00 | 2022-09-16 00:00:00 | 2022-10-03 00:00:00 |  |  |  |  | The date in in cell [NAME] has to be 5 days before the date in A2 to be considered "On Time", but if there are no dates in the B column then the D column should show "On Time".
2022-10-03 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-04 00:00:00
 |  | 2022-10-01 00:00:00
Spreadsheet: 805721d1668861510-depreciation-and-re-investment-formulas-depreciation-and-reinvestment-ans
Sheet: Sheet1

 |  |  |  |  | Initial investment |  |  |  |  | Re-investment 1 |  |  |  | Re-investment 2
Asset | Useful life (years) | Investment / Depreciation | Single Investment Total | Investment Total | Yr1 | Yr2 | Yr3 | Yr4 | Yr5 | Yr6 | Yr7 | Yr8 | Yr9 | Yr10 | Yr11 | Yr12 | Yr13 | Yr14 | Yr15
A |  | Investment Total | 7000 |  | 1000 | 1000 | 5000 |  |  | 3000 | 4000 |  |  | 2000 | 1000 | 1000 | 3000
A |  | Depreciation Investment Yr1
A |  | Depreciation Investment Yr2
A |  | Depreciation Investment Yr3
A |  | Depreciation Investment Yr4
A | 3 | Depreciation Total | -7000
 |  | Check |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automate these cells without having to have helper rows in rows (4-7)
 |  |  |  | FORMULA
Spreadsheet: 685822d1594214206-finding-value-by-date-date-range-example2
Sheet: Price list

[NAME] | vendor | name | Product | cost date | cost
 | 123 | [NAME] | cheese | 2018-12-12 00:00:00 | 24
 | 123 | [NAME] | cheese | 2019-01-23 00:00:00 | 30
 | 123 | [NAME] | cheese | 2019-05-25 00:00:00 | 35
 | 124 | [NAME] | wood | 2018-11-18 00:00:00 | 34
 | 124 | [NAME] | wood | 2019-09-23 00:00:00 | 17
 | 124 | [NAME] | wood | 2020-01-01 00:00:00 | 54
 | 123 | [NAME] | wood | 2018-05-05 00:00:00 | 67
 | 123 | [NAME] | wood | 2019-10-10 00:00:00 | 567
 | 127 | [NAME] | wood | 2015-01-01 00:00:00 | 234
 | 127 | [NAME] | wood | 2019-09-08 00:00:00 | 123
 | 127 | [NAME] | wood | 2018-04-12 00:00:00 | 987
 | 127 | [NAME] | beans | 2017-04-16 00:00:00 | 456
 | 127 | [NAME] | beans | 2019-12-12 00:00:00 | 345
 | 127 | [NAME] | beans | 2018-04-06 00:00:00 | 35
 | 123 | [NAME] | beans | 2019-10-13 00:00:00 | 567
 | 123 | [NAME] | beans | 2018-05-17 00:00:00 | 678
 | 123 | [NAME] | beans | 2017-05-17 00:00:00 | 678
 | 124 | [NAME] | beans | 2019-12-25 00:00:00 | 345
 | 124 | [NAME] | beans | 2018-09-18 00:00:00 | 567
 | 125 | [NAME] | cheese | 2018-12-12 00:00:00 | 345
 | 126 | [NAME] | cheese | 2019-01-23 00:00:00 | 567
 | 127 | [NAME] | cheese | 2019-05-25 00:00:00 | 876
Spreadsheet: 886969d1737050476-index-match-headaches-test-index-match
Sheet: California

CA ID | Vineyard | Varietal | Type | Date Produced | Manager | Status | Cal Specific 1 | Cal Specific 2
[NAME] | Rutherford | Rose | French | 2023-03-07 02:23:02 | Adam | Completed | [NAME] | Winter
CAI101325 | Jordan | Chardonnay | French | 2023-03-07 02:23:02 | Mark | Overdue | [NAME] | Winter
CAI101326 | Paradeux | Pinot Noir | American | 2023-03-07 02:23:02 | Julie | Completed | Steel | Fall
CAI101327 | 3 Rivers | [NAME] | German | 2023-03-07 02:23:02 | [NAME] | Completed | Whiskey [NAME] | Summer
Spreadsheet: darrell_schoolcraft__7271__saledoc02_27aTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-02-26 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/27/02 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.29
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/27/2002 | 2002-02-27 00:00:00 | 20000 |  | 20000 |  | 20000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 20000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 465565d1465757221-pivot-table-help-book45-amended-v2
Sheet: New Pivot

Region | (All)
Customer | (All)
Row Labels | RED KPI 2 | Count of KPI3
[NAME] | 0 | 3
[NAME] T | 21 | 4
[NAME] A | 17 | 7
Laurne L | 9 | 3
[NAME] O | 7 | 8
[NAME] | 6 | 8
Ricky R | 11 | 6
Sundeep T | 7 | 1
Grand Total | 78 | 40
Spreadsheet: 479574d1473430928-man-hours-automatic-updating-lines-book1-28-
Sheet: Folha1

GOODS IN |  |  |  |  |  |  | GOODS OUT |  |  |  |  |  |  |  | Total Staff
job | time in | time out | unloading time | staff needed | tot man hours |  | job | time in | time out | unloading time | staff needed | tot man hours |  |  | 7
unloading | 07:00:00 | 09:30:00 |  | 4 |  |  | Customer delivery | 07:00:00 | 09:30:00 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIME AM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB | 07:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Goods in Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Goods out Staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total staff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remain Staff
Spreadsheet: 266859d1379788340-help-with-sumif-forumula-lakewestassessment
Sheet: Section 1

 | Instructor:  Jones
Student Number | Major | Classification | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10
1 | ECON | Freshman | a | c | d | d | a | b | c | c | e | a
2 | FIN | Senior | a | c | d | b | a | d | c | c | d | a
3 | MIS | Sophomore | a | c | d | b | a | b | c | c | e | a
4 | MRKT | Junior | a | d | d | b | d | b | a | a | e | a
5 | MNGT | Sophomore | a | c | c | e | a | b | c | c | b | b
6 | ACCT | Freshman | a | c | d | d | a | c | c | c | e | a
7 | ACCT | Sophomore | a | c | d | d | a | b | c | c | d | c
8 | ACCT | Sophomore | a | c | d | d | a | b | c | c | e | a
9 | MIS | Junior | a | c | e | b | a | b | c | c | e | a
10 | MIS | Sophomore | a | c | c | b | a | b | c | c | e | d
11 | MIS | Sophomore | a | b | d | b | a | b | c | c | a | a
12 | MIS | Senior | a | c | d | b | a | b | c | c | d | a
13 | MIS | Sophomore | a | c | d | b | c | b | c | d | e | e
14 | FIN | Sophomore | e | c | e | b | a | b | c | c | e | a
15 | FIN | Sophomore | a | c | c | e | a | b | c | c | e | a
16 | FIN | Freshman | a | b | d | b | b | b | c | c | e | b
17 | ECON | Junior | a | c | d | b | a | c | c | c | d | b
18 | MRKT | Sophomore | d | c | a | b | a | b | c | c | d | a
19 | MRKT | Junior | a | c | e | c | b | b | c | c | e | a
20 | ECON | Sophomore | a | c | c | e | a | b | c | c | e | a
Spreadsheet: daren_farmer__5802__MayActivityDriver
Sheet: Data

 | 2723 |  | Please Select RC
 |  |  | 40
Activity | Driver | Business Unit | Data
Automated Price Loads | Curve Code/ Rate Handle | AUSTRALIA - GLOBAL DATABASES
 |  | BRIDGELINE - GLOBAL DATABASES
 |  | CENTRAL GAS - GLOBAL DATABASES
 |  | EAST GAS - GLOBAL DATABASES
 |  | EAST POWER - GLOBAL DATABASES
 |  | EQUITY - GLOBAL DATABASES
 |  | LIQUIDS - GLOBAL DATABASES
 |  | PULP & PAPER - GLOBAL DATABASES
 |  | RATE & CURRENCY TRADING - GLOBAL DATABASES
 |  | TEXAS GAS - GLOBAL DATABASES
 |  | WEATHER - GLOBAL DATABASES
 |  | WEST GAS - GLOBAL DATABASES
 |  | WEST POWER - GLOBAL DATABASES
Data Requests | Days Outstanding | AUSTRALIA - GLOBAL DATABASES
 |  | BRIDGELINE - GLOBAL DATABASES
 |  | CENTRAL GAS - GLOBAL DATABASES
 |  | EAST GAS - GLOBAL DATABASES
 |  | EAST POWER - GLOBAL DATABASES
 |  | EQUITY - GLOBAL DATABASES
 |  | LIQUIDS - GLOBAL DATABASES
 |  | PULP & PAPER - GLOBAL DATABASES
 |  | RATE & CURRENCY TRADING - GLOBAL DATABASES
 |  | TEXAS GAS - GLOBAL DATABASES
 |  | WEATHER - GLOBAL DATABASES
 |  | WEST GAS - GLOBAL DATABASES
 |  | WEST POWER - GLOBAL DATABASES
Locational Rates | Indices | EAST POWER - GLOBAL DATABASES
 |  | WEST POWER - GLOBAL DATABASES
Rate Corrections | Manual Curves | BRIDGELINE - GLOBAL DATABASES
 |  | BUG - GLOBAL DATABASES
 |  | CANADA - GLOBAL DATABASES
 |  | CITRUS - GLOBAL DATABASES
 |  | EAST GAS - GLOBAL DATABASES
 |  | EAST POWER - GLOBAL DATABASES
 |  | TEXAS GAS - GLOBAL DATABASES
 |  | WEST POWER - GLOBAL DATABASES
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: RefWorks

RefWorks (CSA)
2004-2005
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total | 2004-2005 Price | Cost per unit
New Users | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | 4 |  | 8058 | N/A
Repeat Users | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | 8 |  | 8058 | N/A
Total Monthly Users | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | 12 |  | 8058 | N/A
Total Sessions per month | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | 77 |  | 8058 | N/A
Average Sessions Per User | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | 6.42 |  | 8058 | N/A
Total Subscriber References added | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | 73 |  | 8058 | N/A
Average References added per user | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | Not avail. | 6.08 |  | 8058 | N/A
Spreadsheet: 679377d1590376244-deferred-revenue-various-billing-cycle-test-ml
Sheet: Sheet1

Customer | Invoice Date | Start Date | End Date | Amount | Preodic value | Term | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00
A | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-30 00:00:00 | 10000 |  | 1
B | 2019-02-01 00:00:00 | 2019-02-01 00:00:00 | 2020-05-30 00:00:00 | 15000 |  | 1
C | 2019-05-01 00:00:00 | 2019-05-01 00:00:00 | 2020-06-30 00:00:00 | 350000 |  | 3
D | 2019-05-01 00:00:00 | 2019-05-01 00:00:00 | 2020-12-31 00:00:00 | 50000 |  | 3
Spreadsheet: 194692d1353298667-dependent-dropboxes-which-can-select-multiple-entries-retest
Sheet: List

country | A-comodity | B-comodity |  | USA | Canada | NZ | Africa
Canada | canine semen | bovine embryo |  | aa | qq | 11 | a1
USA | equine semen | canine embryo |  | aabb | qqww | 1122 | a1a2
NZ | bovine semen | bovine embryo |  | [NAME] | qqwwee | 112233 | a1a2a3
Africa |  |  |  | aabbccdd | qqwweerr | 11223344 | a1a2a3a4
Spreadsheet: 68368d1268905467-count-hours-for-given-period-10dayhours
Sheet: Sheet1

2010-03-18 00:00:00 | 5
2010-03-19 00:00:00
2010-03-20 00:00:00
2010-03-21 00:00:00
2010-03-22 00:00:00
2010-03-23 00:00:00 | 5
2010-03-24 00:00:00
2010-03-25 00:00:00
2010-03-26 00:00:00
2010-03-27 00:00:00
2010-03-28 00:00:00 | 5
2010-03-29 00:00:00
2010-03-30 00:00:00
2010-03-31 00:00:00 | 5 | anchor date
2010-04-01 00:00:00
2010-04-02 00:00:00
2010-04-03 00:00:00 | 5
2010-04-04 00:00:00
2010-04-05 00:00:00
2010-04-06 00:00:00
2010-04-07 00:00:00
2010-04-08 00:00:00
2010-04-09 00:00:00
2010-04-10 00:00:00
2010-04-11 00:00:00
2010-04-12 00:00:00
Spreadsheet: 65200b4b-14c9-4e3f-a58b-cf827e11fee2
Sheet: Sheet1

PAY PERIOD ENDING DATE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | INDIANA UNIVERSITY OF PENNSYLVANIA | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
IF ADJUSTMENT, PAY PERIOD ENDING DATE |  |  |  |  |  |  |  |  |  |  |  |  | TIME AND ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  | PART TIME SCUPA
EMPLOYEE NAME |  |  |  |  |  |  |  |  | EMPLOYEE ID NUMBER |  |  |  |  | BU# |  | TIMEKEEPER'S # |  |  |  | STATUS: |  | PERM |  | TEMP |  | WAGE
 |  |  | LAST |  |  | FIRST |  | MI
 | REGULAR SCHEDULED WORK HOURS |  | O  V  E R  T  I  M  E |  |  |  |  |  |  |  | OVERTIME CALL |  | OT      STANDBY      .25 | OT HALFTIME |  |  | P    A    I    D        L    E   A    V    E    S |  |  |  |  |  |  | UNPAID    LEAVES | COMMENTS
DATE | START | END | START | END | START | END | REG. [NAME] | OT      1.0 | OT      1.5 | OT      2.0 | OT      1.0 | OT      1.5 |  | OT          .5 | OT HOLIDAY .5 | OT      HOLIDAY 1.5 | A | S | SF                    SB | P | CL | H
REVISED 3/06 |  |  | TIME AND ATTENDANCE CODES |  |  |  | Reg Hours | 210 | 215 | 220 | 235 | 240 | 255 | 200 | 205 | 230 | 300 | 310 | 312 314 | 320 | 330 | 350
 |  |  |  |  | TOTALS
FOR PAYROLL USE ONLY
Input Date |  |  |  | Pay Date |  |  |  | Initials |  |  |  |  | Supervisor's Signature and Date |  |  |  |  |  |  | Employee Signature and Date
Please document stand-by hours, if applicable
 |  |  |  |  |  |  |  |  |  |  |  |  | Pre-Authorized
Spreadsheet: 59930d1260456692-multiple-sheet-sum-question-sum-example
Sheet: 2001

 | January | February | March | April | May | June | July | August | September | October | November | December
Employee 1
Employee 2 |  |  | 72
Employee 3
Employee 4
Employee 5
Employee 6
Employee 7 |  |  |  |  |  |  |  |  |  | 66
Employee 8
Employee 9
Employee 10 |  |  |  |  |  |  | 67
Spreadsheet: 760503d1640254969-calculating-elaspsed-time-between-two-time-cells-in-different-time-zones-flights2021_final
Sheet: 2021_11

 |  |  |  |  |  |  |  |  | Totals |  |  |  |  |  |  | Daily total
Date | Day | Aircraft | RegNo | Flight No | SDT | ADT | SAT | AAT | From | City | TO | City2 | Country | SFT | AFT | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10
2021-11-29 00:00:00 | Mon | 737-8AS | EI-EGD | FR7541 |  | 08:07:00 |  | 09:30:00
2021-11-29 00:00:00 | Mon | 737-8AS | EI-EGD | FR7540 |  | 10:24:00 |  | 11:32:00
2021-11-29 00:00:00 | Mon | 737-8AS | EI-EGD | FR8384 |  | 12:41:00 |  | 14:51:00
2021-11-29 00:00:00 | Mon | 737-8AS | EI-EGD | FR8385 |  | 15:43:00 |  | 17:59:00
2012-11-30 00:00:00 | Fri | 737-8AS | EI-DHZ | FR2834 |  | 14:01:00 |  | 15:49:00
2012-11-30 00:00:00 | Fri | 737-8AS | EI-DHZ | FR2835 |  | 16:37:00 |  | 18:06:00
2012-11-30 00:00:00 | Fri | 737-8AS | EI-DHZ | FR6985 |  | 19:20:00 |  | 20:41:00
2012-11-30 00:00:00 | Fri | 737-8AS | EI-DHZ | FR6986 |  | 22:13:00 |  | 23:38:00
Spreadsheet: 823836d1680164962-before-and-after-tp-location-crossings-tp-location
Sheet: Sheet1

TP LIST |  |  | CROSSINGS |  |  | CROSSINGS BEFORE AND AFTER TP REQUIRED ACCORDING TO CHAINAGE
TP's | Chainage |  | Type of  Crossing | Chainage |  | BEFORE TP | Chainage | AFTER TP | Chainage
TP0 | 0 |  | Pipeline | 263.89 |  | TP7 |  | TP8
TP1 | 4.49 |  | Drain | 265.88 |  | TP7 |  | TP8
TP2 | 7.75 |  | NH | 293.2 |  | TP7 |  | TP8
TP3 | 11.22 |  | Drain | 312.82 |  | TP7 |  | TP8
TP4 | 13.73 |  | BG | 498.36 |  | TP18 |  | TP19
TP5 | 16.05 |  | BT Road | 506.76 |  | TP18 |  | TP19
TP6 | 25.9
TP7 | 258.38
TP8 | 359.9
TP9 | 364.65
TP10 | 369.01
TP11 | 371.98
TP12 | 376.65
TP13 | 389.22
TP14 | 429.69
TP15 | 445.03
TP16 | 456.73
TP17 | 467.54
TP18 | 473.85
TP19 | 516.22
TP20 | 677.55
Spreadsheet: 00de5501-ecbe-4ae4-982c-600db18d3173
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Access Authorization Form
Employee to be granted access (one form per person):
Name (Printed): |  |  |  |  |  |  | This employee is authorized to access all the departmental records held at the University of Idaho Records Center.
V-Number: |  |  |  |  |  |  | University of Idaho
Phone Number: |  |  |  |  |  |  | Records Management Office
Signature: |  |  |  |  |  |  | Student Union Building, Room 53
 |  |  |  |  |  |  | Moscow, Idaho 83844-4247
 |  |  |  |  |  |  | Phone (208) 885-2580
Access Start Date*:
*Upon removal of access, such as employee resignation, please E-mail [EMAIL]
Full Department Name:
Authorizing Person (Department Chair/Head or Appointed Records Coordinator)
Name (Printed):
Signature:
Office Use Only
Access End Date:
End Notes:
Spreadsheet: 99222d1297936541-conditional-formatting-help-conditional-formatting-help
Sheet: Sheet1

 |  |  |  | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00
 |  |  |  | 690.6979382058819 | 686.0588252749538 | 697.7362695855678 | 694.4971875138019 | 711.795577800736 | 721.4633745420812
 |  |  |  | 29.3 | 28.1 | 25.874 | 25.1367703559815 | 24.82493362655967 | 26.6299426532557
 |  |  |  | 1258 | 1292 | 1443 | 1308.15 | 1483.9 | 1760.35
 |  |  |  | 1305 | 1387 | 1486 | 1377 | 1562 | 1853
 |  |  |  | 42.93515358361775 | 45.97864768683274 | 55.77027131483342 | 52.04129176000984 | 59.77458076312465 | 66.10416037770868
 |  |  |  | 1754.910424945835 | 1709.734206531183 | 1669.837064620808 | 1496.4725786395 | 1285.4725786395 | 1110.199851366773
 |  |  |  | 2733 | 3194 | 3113
 |  |  |  | 93.27645051194538 | 113.6654804270463 | 120.3138285537605 | 0 | 0 | 0