tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 471909d1469278171-student-info-need-help-test
Sheet: Sheet1

Class | Status | Eng | Urd | Math | Isl | PS | GS | Com | AMD | AGR
6Th Red | Pass | 9 | 14 | 27 | 28 | 16 | 1 | 12 | 3 | 26
6Th Red | Fail | 27 | 18 | 9 | 9 | 20 | 34 | 23 | 31 | 8
6Th Red | n.a | 1 | 4 | 1 | 0 | 1 | 2 | 2 | 3 | 3
6Th Green | Pass | 10 | 39 | 17 | 13 | 26 | 0 | 30 | 0 | 6
6Th Green | Fail | 31 | 1 | 24 | 27 | 14 | 40 | 12 | 38 | 30
6Th Green | n.a | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 5 | 7
6TH White | Pass | 16 | 24 | 22 | 30 | 23 | 5 | 12 | 33 | 32
6TH White | Fail | 17 | 10 | 10 | 4 | 9 | 28 | 21 | 0 | 0
6TH White | n.a | 3 | 2 | 4 | 2 | 4 | 3 | 3 | 3 | 4
7Th Red | Pass | 11 | 24 | 11 | 19 | 25 | 6 | 21 | 9 | 32
7Th Red | Fail | 25 | 11 | 23 | 10 | 9 | 28 | 12 | 24 | 1
7Th Red | n.a | 1 | 2 | 3 | 8 | 3 | 3 | 4 | 4 | 4
7Th Green | Pass | 14 | 33 | 15 | 29 | 33 | 7 | 13 | 10 | 25
7Th Green | Fail | 30 | 11 | 29 | 10 | 11 | 34 | 31 | 35 | 20
7Th Green | n.a | 2 | 2 | 2 | 7 | 2 | 5 | 1 | 1 | 1
7Th White | Pass | 27 | 0 | 10 | 27 | 20 | 6 | 26 | 12 | 21
7Th White | Fail | 1 | 0 | 18 | 1 | 9 | 22 | 2 | 15 | 5
7Th White | n.a | 3 | 31 | 3 | 3 | 2 | 3 | 2 | 4 | 5
Spreadsheet: chris_stokley__3921__0401 PGES Final
Sheet: Top

 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 4
 | Date Range | Use | Current |  |  |  |  |  |  |  |  | 51
 | Start Date: | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 |  |  |  |  |  |  |  |  | 54
 | End Date: | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 |  |  |  |  |  |  |  |  | 101
 | [NAME]: | False | False |  |  |  |  |  |  |  |  | 102
 |  |  |  |  |  |  |  |  |  |  |  | 103
 | Parameters | Pull1 | Pull2 | Pull3 |  |  |  |  |  |  |  | 111
 | Trans Type: | M |  |  |  |  |  |  |  |  |  | 112
 | Ledger Date: | 2001-07-01 00:00:00 |  |  |  |  |  |  |  |  |  | 114
 | Multiplier: |  |  |  |  |  |  |  |  |  |  | 115
 |  |  |  |  |  |  |  |  |  |  |  | 116
 | Settlement Entity: | ISO |  |  |  |  |  |  |  |  |  | 151
 | Customer: | PGES |  |  |  |  |  |  |  |  |  | 152
 | Auto Clear: | True |  |  |  |  |  |  |  |  |  | 153
 | Oracle DB: | ODBC;DSN=pwrprodn_ded;DBQ=pwrprodn_ded;UID[NAME]=mbennet_pc |  |  |  |  |  |  |  |  |  | 202
 | Database: | r:\enpowercaps\settle\isoandpx\settle.mdb |  |  |  |  |  |  |  |  |  | 203
 | Charge | False |  |  |  |  |  |  |  |  |  | 203
 | [NAME] | False |  |  |  |  |  |  |  |  |  | 252
 |  |  |  |  |  |  |  |  |  |  |  | 253
 |  |  |  |  |  |  |  |  |  |  |  | 256
 |  |  |  |  |  |  |  |  |  |  |  | 301
 |  |  |  |  |  |  |  |  |  |  |  | 303
 |  |  |  |  |  |  |  |  |  |  |  | 304
 |  |  |  |  |  |  |  |  |  |  |  | 351
 |  |  |  |  |  |  |  |  |  |  |  | 352
 |  |  |  |  |  |  |  |  |  |  |  | 401
 |  |  |  |  |  |  |  |  |  |  |  | 402
 |  |  |  |  |  |  |  |  |  |  |  | 403
 |  |  |  |  |  |  |  |  |  |  |  | 404
 |  |  |  |  |  |  |  |  |  |  |  | 405
 |  |  |  |  |  |  |  |  |  |  |  | 406
 |  |  |  |  |  |  |  |  |  |  |  | 487
 |  |  |  |  |  |  |  |  |  |  |  | 452
 |  |  |  |  |  |  |  |  |  |  |  | 521
 |  |  |  |  |  |  |  |  |  |  |  | 522
 |  |  |  |  |  |  |  |  |  |  |  | 523
 |  |  |  |  |  |  |  |  |  |  |  | 999
 |  |  |  |  |  |  |  |  |  |  |  | 1010
 |  |  |  |  |  |  |  |  |  |  |  | 1101
 |  |  |  |  |  |  |  |  |  |  |  | 1302
 |  |  |  |  |  |  |  |  |  |  |  | 1303
 |  |  |  |  |  |  |  |  |  |  |  | 1353
 |  |  |  |  |  |  |  |  |  |  |  | False
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 2

Fixtures | Week 2 |  |  | 19th August |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] |  | - |  | Southampton |  | 5 | 5 | 2 | 2 | 2 | 2 | 5 | 5 | 2 | 5 | 5 | 5 | 2 | 5 | 5 | 2 | 2 | 2 | 2 | 2
Stoke City |  | - |  | Manchester City |  | 0 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2
Burnley |  | - |  | Liverpool |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Swansea City |  | - |  | Hull City |  | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0
Tottenham |  | - |  | Crystal Palace |  | 0 | 2 | 5 | 2 | 5 | 2 | 0 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Watford |  | - |  | Chelsea |  | 5 | 5 | 2 | 2 | 5 | 5 | 0 | 2 | 2 | 2 | 2 | 5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
West Brom |  | - |  | Everton |  | 5 | 0 | 0 | 5 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 2
Leicester City |  | - |  | Arsenal |  | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0
Sunderland |  | - |  | Middlesbrough |  | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0
West Ham |  | - |  | Bournemouth |  | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 0 | 2 | 5 | 2 | 2 | 2 | 2 | 2 | 0
Home Team | Score |  |  | Away Team | Weekly Total
[NAME] | 2 | - | 0 | Southampton |  | 2-0 | 2-0 | 2-1 | 3-0 | 3-1 | 2-1 | 2-0 | 2-0 | 2-1 | 2-0 | 2-0 | 2-0 | 3-0 | 2-0 | 2-0 | 2-1 | 2-1 | 3-1 | 3-0 | 3-0
Stoke City | 1 | - | 4 | Manchester City |  | 1-1 | 1-2 | 1-3 | 0-2 | 1-2 | 1-1 | 2-3 | 1-2 | 1-3 | 1-2 | 0-3 | 1-3 | 1-3 | 0-2 | 1-2 | 1-3 | 1-1 | 0-2 | 0-2 | 1-3
Burnley | 2 | - | 0 | Liverpool |  | 0-2 | 1-3 | 0-3 | 1-4 | 2-2 | 1-3 | 1-4 | 0-1 | 2-1 | 0-3 | 1-2 | 1-2 | 1-1 | 1-2 | 0-3 | 0-2 | 1-2 | 1-3 | 0-2 | 0-2
Swansea City | 0 | - | 2 | Hull City |  | 1-0 | 1-0 | 1-0 | 2-0 | 1-0 | 1-1 | 0-1 | 2-1 | 2-2 | 2-0 | 1-0 | 1-1 | 2-0 | 1-0 | 1-0 | 1-1 | 1-0 | 1-2 | 0-1 | 1-1
Tottenham | 1 | - | 0 | Crystal Palace |  | 1-1 | 2-1 | 1-0 | 3-1 | 1-0 | 2-1 | 1-1 | 2-0 | 3-2 | 2-1 | 1-1 | 2-1 | 2-1 | 2-1 | 2-1 | 2-1 | 2-0 | 2-0 | 2-1 | 2-0
Watford | 1 | - | 2 | Chelsea |  | 1-2 | 1-2 | 0-2 | 1-3 | 1-2 | 1-2 | 1-1 | 0-1 | 1-3 | 0-2 | 0-3 | 1-2 | 1-3 | 0-1 | 1-3 | 0-3 | 0-1 | 0-2 | 0-3 | 0-2
West Brom | 1 | - | 2 | Everton |  | 0-2 | 1-1 | 1-1 | 1-2 | 1-1 | 0-0 | 0-1 | 1-1 | 0-2 | 2-2 | 2-2 | 1-1 | 2-1 | 0-0 | 0-0 | 1-2 | 1-1 | 1-2 | 1-1 | 0-1
Leicester City | 0 | - | 0 | Arsenal |  | 1-3 | 3-4 | 2-2 | 2-2 | 2-1 | 2-2 | 1-2 | 1-2 | 2-4 | 0-1 | 1-2 | 1-2 | 3-1 | 1-1 | 1-1 | 2-3 | 1-2 | 0-2 | 1-2 | 1-2
Sunderland | 1 | - | 2 | Middlesbrough |  | 1-1 | 1-0 | 1-1 | 2-1 | 1-1 | 1-1 | 1-2 | 1-0 | 2-2 | 2-0 | 2-0 | 1-1 | 2-2 | 2-1 | 0-0 | 1-0 | 1-1 | 1-1 | 0-1 | 1-0
West Ham | 1 | - | 0 | Bournemouth |  | 2-1 | 2-0 | 2-1 | 3-1 | 2-1 | 2-1 | 2-2 | 2-1 | 2-1 | 3-1 | 2-1 | 1-1 | 2-1 | 1-0 | 2-1 | 2-1 | 2-1 | 2-0 | 2-1 | 1-1
Spreadsheet: 854692d1704468392-process-data-from-spilling-array-return-spilling-array-2-columns-collect-split2-spill
Sheet: Feuil1

 |  |  |  |  |  | directory | file | label |  | directories | expected_result
AB | AB48 | AB48-L | AB,AC,AD |  |  |  | AB48 | AB48-L |  |  | AB48,AB130,AC54,AD66,AD68 | AB48-L,AB130-L,AC54-L,AD66-L,AD68-L
AB | AB130 | AB130-L | AB |  |  | AB | AB130 | AB130-L |  | AB | AB48,AB130 | AB48-L,AB130-L,AC54-L,AD66-L,AD68-L
AC | AC54 | AC54-L | BA |  |  | AC | AC54 | AC54-L |  | BA
AD | AD66 | AD66-L | CA |  |  | AD | AD66 | AD66-L |  | CA | CA12 | [NAME]
AD | AD68 | AD68-L | CA,AB |  |  | AD | AD68 | AD68-L |  | CA,AB | CA12,AB48,AB130 | CA12-L,AB48-L,AB130-L
CA | CA12 | [NAME] |  |  |  | CA | CA12 | [NAME]
 |  |  | EF |  |  |  |  |  |  | EF
 |  |  |  |  |  |  |  |  |  |  |  | AB48-L,AB130-L,AC54-L,AD66-L,AD68-L
 |  |  |  |  |  |  |  |  |  |  | AB48,AB130 | AB48-L,AB130-L
 |  |  |  |  |  |  |  |  |  |  | CA12 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | CA12,AB48,AB130 | CA12-L,AB48-L,AB130-L
Spreadsheet: 870420d1716934060-barclays-premier-league-best-11-for-2024-toty-23-24-premier-league-alif
Sheet: Team of the Year 23-24 (Salah)

 |  |  |  |  |  | Team of the Year 2023 - 2024
 |  |  |  |  |  |  |  |  | GK | Club
 |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  |  |  | 3 | Ederson
 |  |  |  |  |  |  |  | 4 | [NAME]
 |  |  |  |  |  |  |  | 5 | [NAME]
 |  |  | RB | Club |  | RCB | Club |  |  |  |  | LCB | Club |  | LB | Club
 |  | 1 | [NAME] |  | 1 | [NAME] |  |  |  |  | 1 | [NAME] |  | 1 | [NAME]
 |  | 2 | [NAME] |  | 2 | [NAME] |  |  |  |  | 2 | [NAME] |  | 2 | Destiny [NAME]
 |  | 3 | [NAME] |  | 3 | [NAME] |  |  |  |  | 3 | [NAME] |  | 3 | [NAME]
 |  | 4 | Trent [NAME] |  | 4 | [NAME] |  |  |  |  | 4 | [NAME] |  | 4 | [NAME]
 |  | 5 | [NAME] |  | 5 |  |  |  |  |  | 5 | [NAME] |  | 5 | [NAME]
 |  |  |  |  |  |  |  |  | CM | Club
 |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  | 2 | Moisés Caicedo
 |  |  |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  |  |  | 4 | [NAME]
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  | CM | Club |  |  |  |  | CM | Club
 |  |  |  |  | 1 | [NAME] |  |  |  |  | 1 | Rodri
 |  |  |  |  | 2 | [NAME] |  |  |  |  | 2 | [NAME]
 |  |  |  |  | 3 | [NAME] |  |  |  |  | 3 | [NAME]
 |  |  |  |  | 4 | [NAME] |  |  |  |  | 4 | [NAME]
 |  |  |  |  | 5 | Jorginho |  |  |  |  | 5 | [NAME]
 |  |  | RW | Club |  |  |  |  |  |  |  |  |  |  | LW | Club
 |  | 1 | [NAME] |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  | 2 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2 | [NAME]
 |  | 3 | [NAME] |  |  |  |  |  |  |  |  |  |  | 3 | [NAME]
 |  | 4 | Heung-min Son |  |  |  |  |  |  |  |  |  |  | 4 | Alejandro Garnacho
 |  | 5 | [NAME] |  |  |  |  |  |  |  |  |  |  | 5 | [NAME]
 |  |  |  |  |  |  |  |  | ST | Club
 |  |  |  |  |  |  |  | 1 | Erling Haaland
 |  |  |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  |  |  | 4 | [NAME]
 |  | Signing of the season |  |  |  |  |  | 5 | [NAME]
 |  |  | Player | Club
 |  | 1 | [NAME]
 |  | 2 | [NAME]
 |  | 3 | [NAME]
 |  | 4 | [NAME] |  |  | Make sure PLAYERS you have selected have transferred to their teams this season please!!!
 |  | 5 | Moisés Caicedo
 |  | Worst Signing of the season
 |  |  | Player | Club
 |  | 1 | [NAME]
 |  | 2 | [NAME]
 |  | 3 | Mason Mount
 |  | 4 | Rasmus Højlund
 |  | 5
 |  | Best player of the season
 |  |  | Player | Club
 |  | 1 | [NAME]
 |  | 2 | [NAME]
 |  | 3 | [NAME] |  |  | Can be any PLAYER
 |  | 4 | Rodri
 |  | 5 | [NAME]
 |  | Worst player of the season
 |  |  | Player | Club
 |  | 1 | [NAME]
 |  | 2 | Mason Mount
 |  | 3 | Antony
 |  | 4 | [NAME]
 |  | 5 | Casemiro
Spreadsheet: 82183d1282206302-find-entry-in-corresponding-sheet-and-return-related-value-tag-rubgy
Sheet: Deduction

 | No | Team | Deduction
Spreadsheet: 721813d1614873667-find-top-5-with-criteria-and-sum-error-sample-1-
Sheet: Sheet2

Name | Workflow | Completed Cases |  |  |  |  | name | 1 | 2 | 3 | 4 | 5
[NAME] | workflow a | 56 |  |  |  |  | [NAME]
[NAME] | workflow a | 500 |  |  |  |  | [NAME]
[NAME] | workflow a | 5 |  |  |  |  | [NAME]
[NAME] | workflow a | 78 |  |  |  |  | [NAME]
[NAME] | workflow a | 21
[NAME] | workflow b | 200
[NAME] | workflow b | 34
[NAME] | workflow b | 55
[NAME] | workflow c | 100
[NAME] | workflow c | 22
[NAME] | workflow d | 5000
Spreadsheet: 793302d1661407024-using-iferror-to-sort-data-into-groups-not-working-grouping-test-aligw
Sheet: Batching

No. per group | 30
A | B | C | D | E | F
Spreadsheet: 41123d1239647098-converting-score-sheet-to-lookup-formula-determine-rating-2
Sheet: Sheet1

Below is the original scoring table from our paper-based source:
Age | Excellent | Good | Average | Fair | Low
20-29 | > 35 | 29-35 | 22-28 | 17-21 | < 17
30-39 | > 29 | 22-29 | 17-21 | 12-16 | < 12
40-49 | > 21 | 17-21 | 13-16 | 10-12 | < 10
50-59 | > 20 | 13-20 | 10-12 | 7-9 | < 7
60-69 | > 17 | 11-17 | 8-10 | 5-7 | < 5
If I have a person that is 42 years old who scores a 19, I need to know how to lookup the correct rating, which should be 'Good'.
Below is how I started to modify the original table above for Excel's lookup functions:
Age | Low | Fair | Average | Good | Excellent
20 | 0 | 17 | 22 | 29 | 35
30 | 0 | 12 | 17 | 22 | 29
40 | 0 | 10 | 13 | 17 | 21
50 | 0 | 7 | 10 | 13 | 20
60 | 0 | 5 | 8 | 11 | 17
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 1

 | Oct 12 | Oct 19 | Oct 26 | Nov 2 | Nov 9
Total Interest Rates* | 373396666 | 375131742 | 378058202 | 378031410 | 379472036
Cleared** | 167697942 | 169837013 | 170219666 | 170130169 | 171935796
Uncleared | 205698724 | 205294729 | 207838536 | 207901241 | 207536240
Total Cross-Currency | 16291895 | 16394010 | 16352798 | 16595767 | 16458308
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 16291895 | 16394010 | 16352798 | 16595767 | 16458308
Total Credit | 22384539 | 22374187 | 22294244 | 22340286 | 22316141
Cleared | 2784376 | 2713605 | 2664166 | 2665509 | 2700012
Uncleared | 19600164 | 19660582 | 19630077 | 19674777 | 19616129
Total Equities | N/A | N/A | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Commodities | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 415164100 | 416990939 | 419796244 | 420058463 | 421337485
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 810845d1672122995-formula-to-get-the-values-before-last-value-from-a-list-sample-11-
Sheet: Data

Item Code | Item Description | FREE_QUANTITY | PR No. | PR Date | Code | A | Request Qty | UOM
MEC/BK/06 |  | 500 | 22/0832 | 23/11/22 | 113605 |  | 100 | PIECE
MEC/BK/07 |  | 37 | 22/0833 | 23/11/22 | 113605 |  | 100 | PIECE
MEC/BK/08 |  | 1791 | 22/0834 | 23/11/22 | 113605 |  | 200 | PIECE
MEC/BK/09 |  | 594 | 22/0835 | 23/11/22 | 113605 |  | 100 | PIECE
MEC/BK/137 |  | 996 | 22/0836 | 23/11/22 | 113605 |  | 100 | PIECE
MEC/BK/50 |  | 1400 | 22/0838 | 23/11/22 | 113605 |  | 350 | PIECE
MEC/BK/15 |  | 893 | 22/0837 | 23/11/22 | 113605 |  | 100 | PIECE
MEC/BK/50 |  | 1400 | 22/0838 | 23/11/22 | 113605 |  | 400 | PIECE
NEW/MEC/BK/081 |  | 20 | 22/0839 | 23/11/22 | 113605 |  | 100 | PIECE
NEW/MEC/BK/112 |  | 0 | 22/0840 | 23/11/22 | 113605 |  | 10 | PIECE
NEW/MEC/BK/113 |  | 0 | 22/0841 | 23/11/22 | 113605 |  | 2 | PIECE
NEW/MEC/BK/114 |  | 0 | 22/0842 | 23/11/22 | 113605 |  | 10 | PIECE
MEC/BK/50 |  | 1400 | 22/0843 | 23/11/22 | 113605 |  | 500 | PIECE
Spreadsheet: 37580d1235622526-complex-if-condition-complex-status
Sheet: Sheet1

T | 655 | 2005 | 2366 |  |  | 2
T | 656 | 2005 | 2366 |  |  | 2
T | 656 | 2005 | 2366 |  |  | 2
W | 659 | 2005 | 2367 |  |  | #N/A
W | 659 | 2008 | 2369 |  |  | 0.25
W | 659 | 2006 | 2370 |  |  | 0.25
F | 659 | 2005 | 2370 |  |  | 0.25
W | 660 | 2005 | 2370 |  |  | 0.25
W | 660 | 2008 | 2371 |  |  | 0.25
W | 660 | 2006 | 2371 |  |  | 0.25
T | 660 | 2005 | 2371 |  |  | 0.25
W | 661 | 2005 | 2372 |  |  | 0.5
W | 661 | 2007 | 2372 |  |  | 0.5
Spreadsheet: 887462d1737694285-due-dates-formula-for-month-end-close-calendar-month-end-close-due-dates-012325
Sheet: Copy

Revenue Month End Closing Schedule
 | Day - Quarter | Day | Due Date | Frequency
 | 15th | -15 |  | Monthly |  |  | Day 1 of Feb Close
 | 15th | -15 |  | Monthly |  |  | Day 2 of Feb Close
 | 20th | -20 |  | Monthly |  |  | Day 3 of Feb Close
 | D -10 to -5 | -10 |  | Monthly |  |  | Day 4 of Feb Close
 | D -10 to -5 | -5 |  | Monthly
 | D -10 to -5 | -10 |  | Quarterly |  |  | 2/1/25 is a Saturday so needs to be excluded
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly |  |  | For Quarterly items we need to only use the working days of the Quarter excluding Saturday, Sundays and Holidays.
 | D-1 | -1 |  | Monthly |  |  | March close schedule is on the third tab
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Quarterly
 | D1 | 1 |  | Monthly
 | D1 | 1 |  | Monthly
 | D1 | 1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | 1 |  | Quarterly
 | D 1 | 1 |  | Quarterly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D2 | 2 |  | Monthly
 | D2 | 2 |  | Monthly
 | D2 | 2 |  | Quarterly
 | D2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 2 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Quarterly
 | D3/D4 | 4 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 - D9 | 6 |  | Quarterly
 | D6 - D9 | 6 |  | Quarterly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 9 |  | Monthly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 8 |  | Monthly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 8 |  | Monthly
 | D 6 | 6 |  | Quarterly
 | D6 - D9 | 8 |  | Quarterly
 | D 6 | 6 |  | Quarterly
 | D 6 | 6 |  | Quarterly
 | D 8 | 8 |  | Quarterly
 | D10 | 10 |  | Quarterly
 | D10 | 10 |  | Quarterly
 | D11 | 11 |  | Monthly
 | D20+ | 20 |  | Quarterly
 | D20+ | 20 |  | Quarterly
 | D20+ | 20 |  | Quarterly
Spreadsheet: 696872d1601020700-sumproduct-with-indirect-mainsheet
Sheet: 9.II

Particulars | 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 | FY-20 | 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 | FY-21
Production Qty | 200
Production Cost
Material Cost
Fuel Cost
Power Cost | 40
Spreadsheet: b47a3226-8c3a-47d2-bb76-7a8c3a58fe9b
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
AMLPC | Test | AMLPC | Amylase, Pancreatic Cyst | Amylase, Pancreatic Cyst | Substrate Kinetic |  |  |  | 1 | mL | Collection Container/Tube: Body fluid container Submission Container/Tube: Plastic vial [NAME]: 1 mL | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; Varies | Same day/1 day | 3 days | 1 | 82150 |  |  |  |  | Rochester
AMLPC | [NAME] | PCF | Pancreatic Cyst Fluid |  |  |  | Frozen | 30 days
AMLPC | Result | AMYPC | Amylase, Pancreatic Cyst | Amylase, Pancreatic Cyst | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | In Process
AMLPC | Result | SITE6 | Site | Site | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39111-0 | Body site:[NAME]:Pt:^Patient:Nom:
Spreadsheet: 72202d1272909681-column-numbers-for-vlookup-vlookup-question
Sheet: After

Vlookup | Region | Data1 | [NAME] | Data2 | Value | Data3
Data2 | East | Data1 |  | Data2 | 1 | Data3
 | West | Data1 |  | Data2 | 2 | Data3
 | North | Data1 |  | Data2 | 3 | Data3
 | South | Data1 |  | Data2 | 4 | Data3
Spreadsheet: 730139d1619558600-calculate-total-hours-scheduled-each-hours-of-the-day-calculate-total-hours-scheduled-each-hours-of-the-day
Sheet: counting (2)

 |  | 00:00:00
22:30:00 | 07:00:00
22:30:00 | 07:00:00
22:30:00 | 07:00:00
22:30:00 | 07:00:00
22:30:00 | 07:00:00
19:00:00 | 03:30:00
19:00:00 | 03:30:00
19:00:00 | 03:30:00
19:00:00 | 03:30:00
02:30:00 | 11:00:00
02:30:00 | 11:00:00
02:30:00 | 11:00:00
23:00:00 | 04:30:00
23:00:00 | 04:30:00
23:00:00 | 04:30:00
20:00:00 | 04:30:00
20:00:00 | 04:30:00
20:00:00 | 04:30:00
22:00:00 | 06:30:00
22:00:00 | 06:30:00
Spreadsheet: 03213dd3-91f8-4471-afd7-9ec9461fbf57
Sheet: Sheet1

SCHEDULE OF FY15 BIWEEKLY PAY PERIODS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Revised 11/15/11 for Automated Time & Leave System
Employees must have all time entered in Employee Self Service by the Monday following the end date of the pay period.
Supervisors must have biweekly employees' time approved in Manager Self Service by the Tuesday following the end date of the pay period.
Biweekly Schedule
Begin Date | End Date | Due Date in ESS | Pay  Date
Column1 | Column2 | Column3 | Column4
2014-07-13 00:00:00 | 2014-07-26 00:00:00 | 2014-07-28 00:00:00 | 2014-08-08 00:00:00
2014-07-27 00:00:00 | 2014-08-09 00:00:00 | 2014-08-11 00:00:00 | 2014-08-22 00:00:00
2014-08-10 00:00:00 | 2014-08-23 00:00:00 | 2014-08-25 00:00:00 | 2014-09-05 00:00:00
2014-08-24 00:00:00 | 2014-09-06 00:00:00 | 2014-09-08 00:00:00 | 2014-09-19 00:00:00
2014-09-07 00:00:00 | 2014-09-20 00:00:00 | 2014-09-22 00:00:00 | 2014-10-03 00:00:00
2014-09-21 00:00:00 | 2014-10-04 00:00:00 | 2014-10-06 00:00:00 | 2014-10-17 00:00:00
2014-10-05 00:00:00 | 2014-10-18 00:00:00 | 2014-10-20 00:00:00 | 2014-10-31 00:00:00
2014-10-19 00:00:00 | 2014-11-01 00:00:00 | 2014-11-03 00:00:00 | 2014-11-14 00:00:00
2014-11-02 00:00:00 | 2014-11-15 00:00:00 | 2014-11-17 00:00:00 | 2014-11-26 00:00:00
2014-11-16 00:00:00 | 2014-11-29 00:00:00 | 2014-12-01 00:00:00 | 2014-12-12 00:00:00
2014-11-30 00:00:00 | 2014-12-13 00:00:00 | 2014-12-15 00:00:00 | 2014-12-26 00:00:00
2014-12-14 00:00:00 | 2014-12-27 00:00:00 | 2014-12-29 00:00:00 | 2015-01-09 00:00:00
2014-12-28 00:00:00 | 2015-01-10 00:00:00 | 2015-01-12 00:00:00 | 2015-01-23 00:00:00
2015-01-11 00:00:00 | 2015-01-24 00:00:00 | 2015-01-26 00:00:00 | 2015-02-06 00:00:00
2015-01-25 00:00:00 | 2015-02-07 00:00:00 | 2015-02-09 00:00:00 | 2015-02-20 00:00:00
2015-02-08 00:00:00 | 2015-02-21 00:00:00 | 2015-02-23 00:00:00 | 2015-03-06 00:00:00
2015-02-22 00:00:00 | 2015-03-07 00:00:00 | 2015-03-09 00:00:00 | 2015-03-20 00:00:00
2015-03-08 00:00:00 | 2015-03-21 00:00:00 | 2015-03-23 00:00:00 | 2015-04-03 00:00:00
2015-03-22 00:00:00 | 2015-04-04 00:00:00 | 2015-04-06 00:00:00 | 2015-04-17 00:00:00
2015-04-05 00:00:00 | 2015-04-18 00:00:00 | 2015-04-20 00:00:00 | 2015-05-01 00:00:00
2015-04-19 00:00:00 | 2015-05-02 00:00:00 | 2015-05-04 00:00:00 | 2015-05-15 00:00:00
2015-05-03 00:00:00 | 2015-05-16 00:00:00 | 2015-05-18 00:00:00 | 2015-05-29 00:00:00
2015-05-17 00:00:00 | 2015-05-30 00:00:00 | 2015-06-01 00:00:00 | 2015-06-12 00:00:00
2015-05-31 00:00:00 | 2015-06-13 00:00:00 | 2015-06-15 00:00:00 | 2015-06-26 00:00:00
2015-06-14 00:00:00 | 2015-06-27 00:00:00 | 2015-06-29 00:00:00 | 2015-07-10 00:00:00
2015-06-28 00:00:00 | 2015-07-11 00:00:00 | 2015-07-13 00:00:00 | 2015-07-24 00:00:00
Spreadsheet: daren_farmer__5956__EI330Breveff061200
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/12/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-12 00:00:00 | EI 330 B | 623 | 0 |  |  | 363
1st of month DBQ = 363/d
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.