tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__1970__ENA-Reliant Prepay
Sheet: Summary

ENA Prepays to Reliant
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 |  |  | Prepayment
 |  | Date | (Purchases) | Comments
 | Wed | 2002-02-06 00:00:00 | 22500
 | Fri | 2002-02-08 00:00:00 | 20000
 | Thu | 2002-02-14 00:00:00 | 26000
 | Thu | 2002-02-21 00:00:00 | 10000
 | Thu | 2002-02-28 00:00:00 | 19000
 |  | Total Prepays Feb 2002
 |  | Feb 2002 Swing Purchases
 |  | Cash Balance on 2/28/02
 | Wed | 2002-03-06 00:00:00 | 42000
 | Thu | 2002-03-14 00:00:00 | 25000
 | Thu |  | 30000 | 3/22/02 9:00AM  verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 40000 | To be applied to Prepayment for FGT and TRKL swing activity.  3/29/02  2:45 PM verfied payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 701760 | To be applied to Apr 2002 Baseload Purchase on Trunkline.  3/29/02 2:45 PM verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 989700 | To be applied to Apr 2002 Baseload Purchase on Florida.  3/29/02 2:45 PM verified payment with [NAME].
 |  | Total Prepays Mar 2002
 |  | Mar 2002 Swing Purchases
 |  | Cash Balance on 3/31/02
 | Thu | 2002-04-04 00:00:00 | 37000 | 4/8/02 1:45 PM verified payment with [NAME]
 | Fri |  | 22000 | 4/15/02 10:00 AM  verified payment with [NAME].
 | Fri | 2002-04-19 00:00:00 | 17000 | 4/23/02  9:15 AM verified payment with [NAME].
 | Mon | 2002-04-29 00:00:00 | 45000 | 4/30/02  8:20 AM verified payment with [NAME].
 | Tue | 2002-04-30 00:00:00 | 683835.2 | To be applied to May 2002 Baseload Purchase on Trunkline.
 | Tue | 2002-04-30 00:00:00 | 1365767 | To be applied to May 2002 Baseload Purchase on Florida.
 |  | Total Prepays Apr 2002
 |  | Apr 2002 Baseload Purchase on Trunkline |  | Sitara #1202698
 |  | Apr 2002 Baseload Purchase on Florida |  | Sitara #1203148
 |  | Apr 2002 Swing Purchases |  | Sitara #1203186
 |  | Total Apr 2002 Purchases
 |  | Cash Balance on 4/30/02
 | Thu | 2002-05-02 00:00:00
 | Thu
 | Thu
 | Thu
 | Tue
 |  | Total Prepays May 2002
 |  | May 2002 Baseload Purchase on Trunkline |  | Sitara #1206391
 |  | May 2002 Baseload Purchase on Florida |  | Sitara #1206815
 |  | May 2002 Swing Purchases |  | Sitara #1203186
 |  | Total May 2002 Purchases
 |  | Current Cash Balance
Notes: | 4/9/02  2:30 PM - Per [NAME] at Reliant - purchase formula for the March 1st is using [NAME] instead of GD + $.06.  Fixed formula in spreadsheet, total impact to cash balance is ($120.00)
Spreadsheet: 270980d1381773435-how-to-make-a-formula-function-look-at-the-most-recently-inputted-cells-football-analysis
Sheet: Premiership Resuts

Premiership | Arsenal |  | [NAME] |  | Cardiff |  | Chelsea |  | Crystal Palace |  | Everton |  | Fulham |  | Hull |  | Liverpool |  | Man City |  | Man Utd |  | Newcastle |  | [NAME] |  | Southampton |  | Stoke |  | Sunderland |  | Swansea |  | Tottenham |  | West Brom |  | West Ham
Arsenal |  |  | 1 | 3 |  |  |  |  |  |  |  |  | 3 | 1
[NAME] | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1
Cardiff |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2
Chelsea |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0
Crystal Palace |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  |  |  |  | 0 | 1
Everton |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2
Fulham | 1 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0
Hull |  |  |  |  |  |  | 0 | 2
Liverpool |  |  | 1 | 0 |  |  |  |  | 3 | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  |  | 0 | 1 | 1 | 0 |  |  | 2 | 2
Man City |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0
Man Utd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1
Newcastle |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 4
[NAME] |  |  |  |  |  |  |  |  |  |  | 2 | 2
Southampton |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 | 0
Stoke |  |  |  |  |  |  |  |  | 2 | 1 |  |  |  |  |  |  | 0 | 1
Sunderland |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
Swansea |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4
Tottenham |  |  |  |  |  |  |  |  | 1 | 0
West Brom |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1
West Ham |  |  |  |  | 2 | 0
Spreadsheet: 731489d1620367522-bulk-hyperlink-permit-register-adjusted
Sheet: READY TO LODGE

ABC Job Number | Address | Description | Client | Permit  Number | BP | OP
Spreadsheet: 159763d1338836632-seperating-data-from-multiple-excel-sheets-schoolcontacts
Sheet: Contacts

School | Location | Program | Last Name | First Name | [NAME]
[NAME] |  | HIV/AIDS Resource Contact
[NAME] |  | HIV/AIDS Resource Contact
[NAME] |  | Sexual Minority Contact
[NAME] |  | Sexual Minority Contact
WJ [NAME] |  | HIV/AIDS Resource Contact
WJ [NAME] |  | HIV/AIDS Resource Contact
WJ [NAME] |  | Sexual Minority Contact
WJ [NAME] |  | Sexual Minority Contact
Calusa Elementary School |  | HIV/AIDS Resource Contact
Calusa Elementary School |  | HIV/AIDS Resource Contact
Calusa Elementary School |  | Sexual Minority Contact
Calusa Elementary School |  | Sexual Minority Contact
Spreadsheet: 274782d1383218903-find-and-return-the-value-of-a-cell-based-on-other-cells-in-the-same-row-id-search
Sheet: Raw Data

ID | Location Code | %Days
12320 | -126693 | 85.9
12321 | -121117 | 7.9
12322 | -126373 | 49.9
12323 | -116376 | 11.4
12326 | -114612 | 0
12327 | -132871 | 64.3
12329 | -132871 | 62.4
12334 | 101151 | 15.4
12336 | -132871 | 6.4
12338 | -109968 | 9.2
12339 | -126306 | 30.6
12341 | -132871 | 1.7
12346 | -111592 | 19.2
12347 | -116092 | 80.5
12348 | -121733 | 22.3
12356 | -114960 | 49.3
12357 | -114729 | 2.5
12359 | 900039905 | 0.4
12361 | -121193 | 6.7
12363 | 900040190 | 17.1
12364 | -111742 | 77.6
12365 | -117387 | 77
12366 | 900040191 | 2.2
12367 | -132871 | 43.8
12369 | -132871 | 41.1
12371 | -132871 | 3.8
12372 | -114852 | 10.5
12375 | -120157 | 52
12377 | -118729 | 15.8
12378 | -132871 | 29.7
12379 | -120171 | 31.9
12380 | -132871 | 0
12381 | -120410 | 0.4
12382 | -126693 | 85.2
12383 | -126693 | 73.4
12435 | -120171 | 30.2
12452 | 900040322 | 20.1
12453 | -132871 | 51.6
12458 | -117543 | 71.3
12461 | -117269 | 0
12465 | -132871 | 49.9
12469 | -125476 | 7.4
12472 | -114852 | 4.4
12473 | -120171 | 26.6
12478 | -132871 | 0
12479 | -117543 | 83.1
12481 | -122250 | 0.5
12484 | -132871 | 28.3
12486 | -121871 | 3.8
12494 | -132871 | 0.6
12502 | -126693 | 1
12505 | -119608 | 13.9
12510 | -126373 | 62.4
12514 | -126373 | 51.6
12519 | -112269 | 0
12532 | -126693 | 85.9
12535 | -117543 | 2.7
12536 | -117543 | 60.6
12539 | -122902 | 80.9
12554 | -118280 | 0.1
12559 | -123036 | 14
12563 | -132871 | 4.8
12564 | -124331 | 33.3
12566 | -132871 | 80.3
12567 | -114765 | 14.9
12570 | -132871 | 24.8
12571 | -126750 | 83.1
12574 | -120984 | 62.3
12576 | -118923 | 0.6
12577 | -120157 | 22
12578 | -115252 | 2.5
12579 | 900040072 | 28.7
12582 | -123662 | 83.4
12589 | -132871 | 3.2
12590 | -121733 | 13.4
12592 | -132871 | 13.7
12625 | -120405 | 23.1
12632 | -126320 | 1
12635 | -121032 | 21.4
12667 | -132871 | 44.7
12674 | -122108 | 10.2
12676 | -116092 | 1.3
12678 | -115252 | 0.8
12680 | -116604 | 1.4
12682 | -120762 | 0.9
12684 | -132871 | 0.4
12686 | -122276 | 14.3
12691 | -132871 | 0.1
12700 | -110765 | 16.7
12705 | -119798 | 14.7
12710 | -116922 | 55.5
12712 | 900040072 | 0.1
12715 | -120171 | 0.8
12716 | -126373 | 64.3
12720 | -132871 | 44.2
12722 | -113156 | 11.7
12723 | -126549 | 1.6
12724 | -126373 | 5.4
12727 | -126693 | 76.7
Spreadsheet: 165202d1341086028-i-need-to-look-up-the-current-date-and-return-a-value-based-on-specific-criteria-sum-by-date-account-and-type
Sheet: Sheet2

FROM
INVOICE - Transfer to Make
DATE
Type | Fee
FROM
Account Name | Amount
Account 1
Account 2
Account 3 |  |  | (to return value -68376.77)
Account 4 |  |  | (to return value -20984.1)
Account 5 |  |  | (to return value -277.89)
Account 6 |  |  | (to return value -65642.23)
Account 7 |  |  | (to return value -884.14)
Account 8 |  |  | (to return value -10321.78)
Account 9
Account 10 |  |  | (to return value-207.51)
TO
Account Name | Amount
Account 2
Spreadsheet: larry_campbell__20978__PCB Graphs
Sheet: 10.84A

Sample location |  |  | Date collected |  |  | PCB result (ppm)
PGE Mile pt. |  |  | 1998-10-30 00:00:00 |  |  | 0 | Sherwood
10.84 A side |  |  | 1999-01-08 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-01-29 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-02-05 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-02-12 00:00:00 |  |  | 1 | Sherwood
 |  |  | 1999-02-19 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-02-26 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-03-04 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-03-11 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-03-18 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-03-25 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-04-01 00:00:00 |  |  | 3 | Sherwood
 |  |  | 1999-04-09 00:00:00 |  |  | 5 | Sherwood
 |  |  | 1999-04-15 00:00:00 |  |  | 4 | Sherwood
 |  |  | 1999-04-22 00:00:00 |  |  | 3 | Sherwood
 |  |  | 1999-04-29 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-05-07 00:00:00 |  |  | 4 | Sherwood
 |  |  | 1999-05-13 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-05-20 00:00:00 |  |  | 7 | Sherwood
 |  |  | 1999-05-28 00:00:00 |  |  | 7 | Sherwood
 |  |  | 1999-06-03 00:00:00 |  |  | 6 | Sherwood
 |  |  | 1999-06-08 00:00:00 |  |  | 8 | Sherwood
 |  |  | 1999-06-10 00:00:00 |  |  | 8 | Sherwood
 |  |  | 1999-06-17 00:00:00 |  |  | 6 | Sherwood
 |  |  | 1999-07-04 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-07-08 00:00:00 |  |  | 1 | Sherwood
 |  |  | 1999-07-15 00:00:00 |  |  | 4 | Sherwood
 |  |  | 1999-07-22 00:00:00 |  |  | 4 | Sherwood
 |  |  | 1999-07-29 00:00:00 |  |  | 6 | Sherwood
 |  |  | 1999-08-05 00:00:00 |  |  | 6 | Sherwood
 |  |  | 1999-08-12 00:00:00 |  |  | 3 | Sherwood
 |  |  | 1999-08-19 00:00:00 |  |  | 4 | Sherwood
 |  |  | 1999-08-26 00:00:00 |  |  | 7 | Sherwood
 |  |  | 1999-09-02 00:00:00 |  |  | 2 | Sherwood
 |  |  | 1999-09-16 00:00:00 |  |  | 4 | Sherwood
 |  |  | 1999-09-23 00:00:00 |  |  | 5 | Sherwood
 |  |  | 1999-09-30 00:00:00 |  |  | 4 | Sherwood
 |  |  | 1999-10-06 00:00:00 |  |  | 9 | Sherwood
 |  |  | 1999-10-27 00:00:00 |  |  | 19 | Sherwood
 |  |  | 1999-11-03 00:00:00 |  |  | 16 | Sherwood
 |  |  | 1999-11-18 00:00:00 |  |  | 22 | Sherwood
 |  |  | 1999-11-24 00:00:00 |  |  | 13 | Sherwood
 |  |  | 1999-12-01 00:00:00 |  |  | 11 | Sherwood
 |  |  | 1999-12-08 00:00:00 |  |  | 13 | Sherwood
 |  |  | 1999-12-14 00:00:00 |  |  | 9 | Sherwood
 |  |  | 1999-12-29 00:00:00 |  |  | 16 | Sherwood
 |  |  | 2000-01-05 00:00:00 |  |  | 9 | Sherwood
 |  |  | 2000-01-19 00:00:00 |  |  | 8 | Sherwood
 |  |  | 2000-03-01 00:00:00 |  |  | 21 | Sherwood
 |  |  | 2000-03-22 00:00:00 |  |  | 13 | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 21 | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 16 | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 23 | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 24 | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 21 | Sherwood
 |  |  | 2000-07-26 00:00:00 |  |  | 20 | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 18 | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 18 | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 16 | Sherwood
 |  |  | 2000-11-08 00:00:00 |  |  | 15 | Sherwood
Spreadsheet: 39017d1237234073-need-to-match-id-s-solved-make-it-match
Sheet: Sheet1

ID# | old info 1 | old info 2 |  |  |  | ID# | new info 1 | new info 2 | new info 3
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 14
4 |  |  |  |  |  | 33
5 |  |  |  |  |  | 41
6 |  |  |  |  |  | 56
7 |  |  |  |  |  | 97
8 |  |  |  |  |  | 55
9 |  |  |  |  |  | 15
10 |  |  |  |  |  | 16
11 |  |  |  |  |  | 17
12 |  |  |  |  |  | 18
13 |  |  |  |  |  | 19
14 |  |  |  |  |  | 20
15 |  |  |  |  |  | 31
16 |  |  |  |  |  | 32
17 |  |  |  |  |  | 35
18 |  |  |  |  |  | 36
19 |  |  |  |  |  | 98
20 |  |  |  |  |  | 95
21 |  |  |  |  |  | 94
23 |  |  |  |  |  | 91
99 |  |  |  |  |  | 55
98 |  |  |  |  |  | 3
Spreadsheet: ef9db404-f405-4c9b-b4f5-08e7715837be
Sheet: Sheet2

Aquia District Commissioner Roster
POSITION | NAME | TELEPHONE | E-MAIL ADDRESS | UNITS
 |  | NUMBER
DC | [NAME] | (H) [PHONE] | (H) [EMAIL] | T1889, T1717, T/P63
 |  | (C) [PHONE] | (W) [EMAIL]
ADC | [NAME] | (H) [PHONE]   (M) [PHONE] | [EMAIL] | T907, T1221, C1221
UC | [NAME] | (H) [PHONE] (C) [PHONE] | (H) [EMAIL] | P197, S212
 |  |  | (W) [EMAIL]
UC | [NAME] | (H) [PHONE] | (H) [EMAIL] | C840
UC | Vacant |  |  | P845
UC | [NAME] | (540) 720-9656 | (H) [EMAIL] | P/T/C142
ADC | [NAME] | H (540) 752-5190  B (703) 661-4528 | [EMAIL] | P317
UC | [NAME] | (H) [PHONE] | [EMAIL] | T845
 |  | (C) [PHONE]
UC | [NAME] | (H) [PHONE] | [EMAIL] | T121, T176, P176, P1425
UC | Vacant |  |  | C84
UC | Vacant |  |  | P/T199
UC | [NAME] | (W) [PHONE] | [EMAIL] | P907, T244, T1425
 |  | (H) [PHONE]
UC | [NAME] | (H) [PHONE] | [EMAIL] | P/T218
 |  | (C) [PHONE]
ADC | [NAME] | (H) (540) 286-6489 | [EMAIL] | P/T1410
 |  | (C ) [PHONE]
 | Vacant |  |  | P458
UC | [NAME] | (H) (540) 286-6498 (W) [PHONE] | [EMAIL] | T317
UC | [NAME] | (H) [PHONE] | [EMAIL] | T840, P242
UC | [NAME] | (H) [PHONE] | [EMAIL] | P578, P579, C1717
 |  | (W) [PHONE]
 |  | (M) [PHONE]
UC | [NAME] | (H) [PHONE] | (W) [EMAIL] | [NAME]
 |  | (W) [PHONE] | (H) [EMAIL]
UC | Vacant |  |  | P/T/C850
ADC new units | [NAME] | (H) [PHONE] | [EMAIL] | C1904
 |  | (W) [PHONE]
UC | [NAME] | (H) [PHONE] | [EMAIL] | T26, P26
 |  | (W) [PHONE]
UC | [NAME] | (H) [PHONE] | (H) [EMAIL] | T516, P213
 |  | (W) [PHONE] | (W) [EMAIL]
UC | [NAME] | (H) [PHONE] | [EMAIL] | C598
ADC LDS Units | [NAME] | (H) [PHONE] (C) [PHONE] | [EMAIL] | P/Te/C940/
UC LDS | [NAME] | (H) [PHONE] | [EMAIL] | P1940
UC LDS | [NAME] | (H) [PHONE] | [EMAIL] | T/Te1940
UC LDS | [NAME] | H (540) 370-4509 | [EMAIL] | T940
UC LDS | [NAME] | H (540) 654-5164 | [EMAIL] | Te/C1945
 |  | B (703) 632-5320
UC LDS | [NAME] | H (540) 372-7779 | [EMAIL] | T/Te/C94
 |  | W (202) 621-1174
UC LDS | [NAME] | [PHONE] | [EMAIL] | P1945
ADC LDS Units | [NAME] | (H) [PHONE] | [EMAIL] | P/T2940
UC LDS | [NAME] | (H) [PHONE] | [EMAIL] | P94
UC LDS | [NAME] | (H) [PHONE] (C) [PHONE] | [EMAIL] | T1945
UC LDS | [NAME] | (540) 288-3830 | [EMAIL] | P/T/Te/C949
Spreadsheet: 709823d1608569778-im-trying-to-compile-data-using-vlookup-but-i-need-to-pull-multiple-strings-of-text-pt-tooling-by-features
Sheet: Sheet1

[NAME] | Pressure Test Tooling | Drawing Availability | Part Feature
2804107SK02 | -06 FEMALE STOP, FEMALE 1 HOLE # 17 | NOT AVAILABLE | NOT AVAILABLE
23X0485 | -06 MALE STOP, -10 MALE FEED & ASSIST & Q.C STOP, FEMALE 1 HOLE # 4 | NOT AVAILABLE | NOT AVAILABLE
4060542 | -10 MALE FEED & ASSIST, FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
394586 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
394850 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
394904 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
447489 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
611842 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
4028838 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
4082647 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
5402431 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
1B0695 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
51G384 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
ST1921-06 | FEMALE 1 HOLE # 1 | NOT AVAILABLE | NOT AVAILABLE
54T167 | FEMALE 1 HOLE # 1 & #  24, Q.C. STOP | NOT AVAILABLE | NOT AVAILABLE
762258 | FEMALE 1 HOLE # 1 / -06 FEMALE FEED IF OVER 1000 PSI | NOT AVAILABLE | NOT AVAILABLE
ST1589-06 | FEMALE 1 HOLE # 1 / -06 FEMALE FEED IF OVER 400 PSI | NOT AVAILABLE | NOT AVAILABLE
ST1855-06 | FEMALE 1 HOLE # 1& / 0R # 24, Q.C. STOP | NOT AVAILABLE | NOT AVAILABLE
4082278 | FEMALE 1 HOLE # 1, # 4, # 24 & Q.C. STOP | NOT AVAILABLE | NOT AVAILABLE
Spreadsheet: benjamin_rogers__1171__Gleason - 501F & 501FD
Sheet: Depreciation

Depreciation and Property Taxes
 |  |  | 1
US FEDERAL TAX DEPRECIATION & AMORTIZATION
 | Years
Plant and Equipment - MACRS | 15
Start-up Costs - SL | 5
Debt Iss & Loan Fees - SL
Tax Depr - Plant and Equipment
Amort - Start-up Costs
Amort - Debt Iss & Loan Fees
EI O&M Mobilization | 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
Total Annual Depr & Amort
STATE TAX DEPRECIATION & AMORTIZATION
 | Years
Plant and Equipment - MACRS
Start-up Costs - SL | 5
Debt Iss & Loan Fees - SL
Tax Depr - Plant and Equipment
Amort - Start-up Costs
Amort - Debt Iss & Loan Fees
EI O&M Mobilization |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Annual Depr & Amort
BOOK DEPRECIATION & AMORTIZATION
 | Years | Residual | 1
Plant and Equipment - SL | 30
Start-up Costs - SL | 5
Debt Iss & Loan Fees - SL
Book Depr - Plant and Equipment
Amort - Start-up Costs
Amort - Debt Iss & Loan Fees
EI O&M Mobilization |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Beginning Book Value
Ending Book Value of Assets
PROPERTY TAX CALCULATION | Years |  | 1
Assessable Value of Hard Assets |  |  | 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
Annual Depreciated Assessable Value
Annual State Tax (with abatement)
Annual County Tax (with abatement)
Annual City Tax (no city taxes) |  | 200
Total Property Tax (with Abatement)
15 Year MACRS Table
Half-Year Convention
Year | Depr. %
1 | 0.05
2 | 0.095
3 | 0.0855
4 | 0.077
5 | 0.0693
6 | 0.0623
7 | 0.059
8 | 0.0591
9 | 0.059
10 | 0.0591
11 | 0.059
12 | 0.0591
13 | 0.059
14 | 0.0591
15 | 0.059
16 | 0.0295
20 Year MACRS Table
Half-Year Convention
Year | Depr. %
1 | 0.0375
2 | 0.07219
3 | 0.06677
4 | 0.06177
5 | 0.05713
6 | 0.05285
7 | 0.04888
8 | 0.04522
9 | 0.04462
10 | 0.04461
11 | 0.04462
12 | 0.04461
13 | 0.04462
14 | 0.04461
15 | 0.04462
16 | 0.04461
17 | 0.04462
18 | 0.04461
19 | 0.04462
20 | 0.04461
21 | 0.0225
Spreadsheet: 453259d1459248822-distributing-a-set-of-codes-to-various-cells-codes-distribution-to-cells
Sheet: Sheet3

AUDIT SCHEDULE
Sl.  No. | Site | Code | 2016-04-01 00:00:00 |  |  |  | 2016-05-01 00:00:00 |  |  |  | 2016-06-01 00:00:00 |  |  |  | 2016-07-01 00:00:00 |  |  |  | 2016-08-01 00:00:00 |  |  |  | 2016-09-01 00:00:00 |  |  |  | 2016-10-01 00:00:00 |  |  |  | 2016-11-01 00:00:00 |  |  |  | 2016-12-01 00:00:00 |  |  |  | 2017-01-01 00:00:00 |  |  |  | 2017-02-01 00:00:00 |  |  |  | 2017-03-01 00:00:00 |  |  |  | 2017-04-01 00:00:00
 |  |  | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4
1 |  |  | AB | BC | CE | DH | EL | GL | AC | BD | CF | DI | FG | HI | AD | BE | CG | DJ | FH | HJ | AE | BF | CH | DK | FI | HK | AF | BG | CI | DL | FJ | HL | AG | BH | CJ | EF | FK | IJ | AH | BI | CK | EG | FL | IK | AI | BJ | CL | EH | GH | IL | AJ | BK | DE | EI
2 |  |  | GI | JK | AK | BL | DF | EJ | GJ | JL | AL | CD | DG | EK | GK | KL | AB
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
 | Auditor Code | Auditor Name |  |  |  |  |  |  |  | Combinations (Codes)
 | A |  |  |  |  |  |  |  |  | AB | BC | CE | DH | EL | GL | AC | BD | CF | DI | FG | HI | AD | BE | CG | DJ | FH | HJ | AE | BF | CH | DK | FI | HK | AF | BG | CI | DL | FJ | HL | AG | BH | CJ | EF | FK | IJ | AH | BI | CK | EG | FL | IK | AI | BJ | CL | EH | GH | IL | AJ | BK | DE | EI
 | B |  |  |  |  |  |  |  |  | GI | JK | AK | BL | DF | EJ | GJ | JL | AL | CD | DG | EK | GK | KL
 | C
 | D
 | E
 | F
 | G
 | H
 | I
 | J
 | K
 | L
Spreadsheet: 484236d1476185149-updating-holiday-planner-for-this-year-proposed-holiday-planner-based-on-2015-16
Sheet: SEP

 |  | Days
1
 |  | Entitlement | Taken | Remaining
 |  |  |  |  | 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
 |  |  |  |  | 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
 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 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
Entering '1' in the relevant row/column represents 0.5 of a day
Spreadsheet: 866259d1713219745-combining-duplicated-based-off-data-in-another-column-test-data-set
Sheet: Sheet1

Start Date | Slices by Ordering Department or Submitter | Name |  |  | Start Date | Slices by Ordering Department or Submitter | Name
1/28/2024 | AHMG DEN PC 7000 E HAMPDEN | [NAME] |  |  | 1/28/2024 | AHMG DEN PC 7000 E HAMPDEN | [NAME]
1/28/2024 | AHMG DEN PC 7000 E HAMPDEN | [NAME] |  |  | 1/28/2024 | AHMG GRV PC 5351 S ROSLYN ST 200 | [NAME]
1/28/2024 | AHMG GRV PC 5351 S ROSLYN ST 200 | [NAME] |  |  | 1/29/2024 | AHMG DEN PC 7000 E HAMPDEN | Derek
1/28/2024 | AHMG GRV PC 5351 S ROSLYN ST 200 | [NAME] |  |  | 1/29/2024 | AHMG LAH PC 9670 W COAL MINE | Derek
1/29/2024 | AHMG DEN PC 7000 E HAMPDEN | Derek |  |  | 1/29/2024 | AHMG DEN PC 2490 W 26TH | Amanda
1/29/2024 | AHMG DEN PC 7000 E HAMPDEN | Derek
1/29/2024 | AHMG LAH PC 9670 W COAL MINE | Derek
1/29/2024 | AHMG LAH PC 9670 W COAL MINE | Derek
1/29/2024 | AHMG DEN PC 2490 W 26TH | Amanda
1/29/2024 | AHMG DEN PC 2490 W 26TH | Amanda
Spreadsheet: darrell_schoolcraft__7809__imbalsumm0108
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -55850 | -55438
2 | -43999 | -43938
3 | -29392 | -29570
4 | -59280 | -59683
5 | -59827 | -59683
6 | -58120 | -57497
7 | -52462 | -52789
8 | -94542 | -93200
9 | -59632 | -58938
10 | -88592 | -88150
11 | -53451 | -52903
12 | -52850 | -52903
13 | -52893 | -52903
14 | -59252 | -59157
15 | -47665 | -47738
16 | -43304 | -43210
17 | -81707 | -81915
18 | -42631 | -42144
19 | -43653 | -41943
20 | -43713 | -42140
21 | -36219 | -35934
22 | -87894 | -87282
23 | -50383 | -50285
24 | -65432 | -65738
25 | -88880 | -88719
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  | 34979
 | 2001-08-25 00:00:00
CBS Dollars
 |  |  | -287550.35