tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838085d1690703479-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample-hd
Sheet: T10

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
10 | Fireboys | Player29 |  |  |  |  |  |  | Week 1
 |  | Player30 |  |  |  |  |  |  | Week 2
 |  | Player31 |  |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  |  | Week 9
 | [NAME] |  |  |  |  |  |  |  | Week 10
 |  | Player29 | 110 |  |  |  |  |  | Week 11
 |  | Player30 | 110 |  |  |  |  |  | Week 12
 |  | Player31 | 157 |  |  |  |  |  | Week 13
 |  |  |  |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  |  | Week 20
 |  |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  | Week 45
Spreadsheet: 837240d1689953434-calculating-percentage-values-in-a-subtotalled-table-sample-data-13-aligw
Sheet: Before

Company | Account | Limit | Occurences | Percentage of total Limit
Company 1 | AXMP1576 |  | 1 | 0.025
Company 1 | AXMP1415 |  | 18 | 0.45
Company 1 | AXMP1759 |  | 1 | 0.025
Company 1 | AXMP1782 |  | 2 | 0.05
Company 1 | AXMP1752 |  | 1 | 0.025
Company 1 | AXMP1975 |  | 1 | 0.025
Company 1 | AXMP1440 |  | 2 | 0.05
Company 1 | AXMP1832 |  | 1 | 0.025
Company 1 | AXMP1811 |  | 2 | 0.05
Company 1 | AXMP1412 |  | 3 | 0.075
Company 1 | AXMP1976 |  | 1 | 0.025
Company 1 | AXMP1458 |  | 2 | 0.05
Company 1 | AXMP1413 |  | 1 | 0.025
Company 1 | AXMP1593 |  | 4 | 0.1
 |  | 82000
Company 2 | AXMP1041 |  | 2 | 0.5
Company 2 | AXMP1176 |  | 2 | 0.5
 |  | 10000
Company 3 | AXMP1839 |  | 1 | 0.3333333333333333
Company 3 | AXMP1157 |  | 1 | 0.3333333333333333
Company 3 | AXMP1836 |  | 1 | 0.3333333333333333
 |  | 10000
Company 4 | AXMP1110 |  | 5 | 0.08928571428571429
Company 4 | AXMP1301 |  | 9 | 0.1607142857142857
Company 4 | AXMP1456 |  | 4 | 0.07142857142857142
Company 4 | AXMP1715 |  | 1 | 0.01785714285714286
Company 4 | AXMP1101 |  | 12 | 0.2142857142857143
Company 4 | AXMP1977 |  | 1 | 0.01785714285714286
Company 4 | AXMP1888 |  | 2 | 0.03571428571428571
Company 4 | AXMP1978 |  | 1 | 0.01785714285714286
Company 4 | AXMP1578 |  | 7 | 0.125
Company 4 | AXMP1205 |  | 1 | 0.01785714285714286
Company 4 | AXMP1372 |  | 1 | 0.01785714285714286
Company 4 | AXMP1979 |  | 1 | 0.01785714285714286
Company 4 | AXMP1859 |  | 2 | 0.03571428571428571
Company 4 | AXMP1980 |  | 1 | 0.01785714285714286
Company 4 | AXMP1981 |  | 1 | 0.01785714285714286
Company 4 | AXMP1748 |  | 1 | 0.01785714285714286
Company 4 | AXMP1982 |  | 1 | 0.01785714285714286
Company 4 | AXMP1849 |  | 2 | 0.03571428571428571
Company 4 | AXMP1983 |  | 1 | 0.01785714285714286
Company 4 | AXMP1771 |  | 1 | 0.01785714285714286
Company 4 | AXMP1340 |  | 1 | 0.01785714285714286
 |  | 43500
Spreadsheet: 100759d1299012295-excel-2007-adding-times-task
Sheet: Sheet2

Task | Activity | total time
1
2
3
4
5
6
7
8
Spreadsheet: 117981d1313325672-how-to-extract-info-from-one-column-based-on-anothers-data-copy-of-weekly-planner-generic-template
Sheet: Planner by Job

 |  | Monday | Tuesday | Wednesday | Thursday | Friday
Job
Job 3 | Job 3 | member tr |  |  |  | member tr
 | Job 3
 | Job 3
 | Job 3
Job 4 | Job 4 | member bn |  |  |  | member ds
 | Job 4 | member vc
 | Job 4
 | Job 4
Job 5 | Job 5
 | Job 5
 | Job 5
 | Job 5
Job 6 | Job 6 | member tr | member ab
 | Job 6
 | Job 6
 | Job 6
Job 7 | Job 7 | member we
 | Job 7
 | Job 7
 | Job 7
Job 8 | Job 8 | member pz |  |  |  | member ab
 | Job 8
 | Job 8
 | Job 8
Job 11 | Job 11 | member bn |  | member ab
 | Job 11
 | Job 11
 | Job 11
Job 12 | Job 12 | member ds
 | Job 12 | member pz
 | Job 12
 | Job 12
Job 14 | Job 14 | member sd |  |  |  | member ad
 | Job 14
 | Job 14
 | Job 14
Job 21 | Job 21 | member ab |  |  | member ab
 | Job 21 | member ad
 | Job 21
 | Job 21
Job 31 | Job 31
 | Job 31
 | Job 31
 | Job 31
Job 33 | Job 33 | member ad
 | Job 33
 | Job 33
 | Job 33
Job 36 | Job 36 | member sd |  | member ad
 | Job 36
 | Job 36
 | Job 36
Job 43 | Job 43 | member gf
 | Job 43
 | Job 43
 | Job 43
Job 51 | Job 51 | member vc
 | Job 51
 | Job 51
 | Job 51
Job 55 | Job 55 | member ss
 | Job 55
 | Job 55
 | Job 55
Job 77 | Job 77 | member zx |  |  | member ad
 | Job 77
 | Job 77
 | Job 77
Spreadsheet: jeff_dasovich__14245__BF Good Exhibits
Sheet: Exhibit 2

Exhibit 2 | Yields and [NAME], 1975-1983
 |  |  |  | Average Gross Spreads Versus the 3-Month Treasury [NAME]
 |  | Average 3-Month |  | 3-month | Commercial | 3-Month
 |  | Treasury [NAME] |  | CDs | Paper | LIBOR |  | Covariance
1975 |  | 5.85 |  | 0.0076 | 0.0056 | 0.0136 |  |  |  | Commercial | LIBOR
1976 |  | 5.03 |  | 0.27 | 0.25 | 0.58 |  | 3 Month CD
1977 |  | 5.17 |  | 0.37 | 0.27 | 0.75 |  | Commercial
1978 |  | 7.12 |  | 0.92 | 0.61 | 1.48
1979 |  | 9.84 |  | 1.18 | 0.88 | 1.93
1980 |  | 11.25 |  | 1.72 | 1.12 | 2.81 |  | Correlation Coefficent
1981 |  | 13.99 |  | 1.92 | 1.17 | 2.83 |  |  |  | Commercial | LIBOR
1982 |  | 10.75 |  | 1.66 | 1.16 | 2.68 |  | 3 Month CD
Jan.,Feb. 1983(a) |  | 8 |  | 0.59 | 0.3 | 1.29 |  | Commercial
Standard Deviation
Spreadsheet: 14009f49-0c42-48f4-9730-0be4ffc3aa61
Sheet: Sheet1

PRESIDENTIAL PRIMARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
1996-02-20 00:00:00
[NAME]
 | Republican |  |  |  | Democratic |  |  |  | Libertarian
Merrimack County | Regular | Absentee | Total |  | Regular | Absentee | Total |  | Regular | Absentee | Total
Allenstown | 639 | 22 | 661 |  | 469 | 8 | 477 |  | 1 | 0 | 1
Andover | 386 | 23 | 409 |  | 179 | 2 | 181 |  | 6 | 0 | 6
[NAME] | 555 | 17 | 572 |  | 232 | 10 | 242 |  | 7 | 0 | 7
Bow | 1888 | 68 | 1956 |  | 553 | 11 | 564 |  | 11 | 0 | 11
Bradford | 380 | 26 | 406 |  | 118 | 5 | 123 |  | 4 | 0 | 4
Canterbury | 481 | 17 | 498 |  | 231 | 3 | 234 |  | 5 | 0 | 5
Chichester | 428 | 17 | 445 |  | 167 | 6 | 173 |  | 3 | 0 | 3
Concord Ward 1 | 619 | 17 | 636 |  | 285 | 1 | 286 |  | 7 | 0 | 7
Concord Ward 2 | 617 | 16 | 633 |  | 296 | 11 | 307 |  | 4 | 0 | 4
Concord Ward 3 | 478 | 41 | 519 |  | 329 | 10 | 339 |  | 5 | 0 | 5
Concord Ward 4 | 716 | 29 | 745 |  | 529 | 20 | 549 |  | 5 | 0 | 5
Concord Ward 5 | 954 | 92 | 1046 |  | 541 | 31 | 572 |  | 1 | 0 | 1
Concord Ward 6 | 477 | 18 | 495 |  | 349 | 14 | 363 |  | 4 | 0 | 4
Concord Ward 7 | 851 | 36 | 887 |  | 472 | 22 | 494 |  | 1 | 0 | 1
Concord Ward 8 | 520 | 31 | 551 |  | 276 | 12 | 288 |  | 5 | 0 | 5
Concord Ward 9 | 643 | 35 | 678 |  | 289 | 31 | 320 |  | 2 | 0 | 2
Concord Ward 10 | 1015 | 55 | 1070 |  | 478 | 20 | 498 |  | 2 | 0 | 2
Danbury | 206 | 11 | 217 |  | 79 | 5 | 84 |  | 3 | 0 | 3
Dunbarton | 509 | 11 | 520 |  | 153 | 0 | 153 |  | 3 | 0 | 3
[NAME] | 801 | 27 | 828 |  | 250 | 3 | 253 |  | 7 | 0 | 7
[NAME] | 402 | 11 | 413 |  | 187 | 2 | 189 |  | 1 | 0 | 1
[NAME] | 300 | 18 | 318 |  | 156 | 5 | 161 |  | 4 | 1 | 5
[NAME] | 391 | 32 | 423 |  | 170 | 10 | 180 |  | 2 | 0 | 2
Henniker | 786 | 25 | 811 |  | 348 | 8 | 356 |  | 9 | 0 | 9
Hill | 173 | 2 | 175 |  | 70 | 0 | 70 |  | 1 | 0 | 1
[NAME] | 2094 | 102 | 2196 |  | 715 | 24 | 739 |  | 7 | 0 | 7
[NAME] | 1378 | 83 | 1461 |  | 557 | 26 | 583 |  | 12 | 0 | 12
Loudon | 919 | 16 | 935 |  | 219 | 3 | 222 |  | 11 | 0 | 11
Newbury | 416 | 22 | 438 |  | 92 | 8 | 100 |  | 2 | 1 | 3
New London | 1106 | 216 | 1322 |  | 252 | 19 | 271 |  | 4 | 0 | 4
Northfield | 675 | 25 | 700 |  | 289 | 13 | 302 |  | 2 | 0 | 2
Pembroke | 1294 | 44 | 1338 |  | 519 | 21 | 540 |  | 11 | 0 | 11
Pittsfield | 634 | 29 | 663 |  | 235 | 6 | 241 |  | 7 | 0 | 7
Salisbury | 274 | 7 | 281 |  | 85 | 1 | 86 |  | 1 | 0 | 1
Sutton | 354 | 18 | 372 |  | 122 | 3 | 125 |  | 2 | 0 | 2
Warner | 672 | 37 | 709 |  | 225 | 11 | 236 |  | 1 | 0 | 1
[NAME] | 354 | 15 | 369 |  | 123 | 1 | 124 |  | 4 | 0 | 4
Wilmot | 250 | 12 | 262 |  | 97 | 2 | 99 |  | 3 | 0 | 3
Totals | 25635 | 1323 | 26958 |  | 10736 | 388 | 11124 |  | 170 | 2 | 172
Spreadsheet: 22364d1211182514-comparing-user-defined-cell-to-other-cells-using-vlookup-t1l
Sheet: Tabelle1

 | Desc. | DN | Øda | FN | Ød | E | C | F | D | - | Weight
 |  |  | [NAME] | KN | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 105 N/mm | Kg
 | A | 15 |  |  |  |  |  |  |  |  | 0.3
 | B | 25 |  |  |  |  |  |  |  |  | 0.4
 | C | 50 |  |  |  |  |  |  |  |  | 0.8
 | D | 80 |  |  |  |  |  |  |  |  | 1
 | E | 100 |  |  |  |  |  |  |  |  | 2.1
 | F | 125 |  |  |  |  |  |  |  |  | 2.1
 | G | 150 |  |  |  |  |  |  |  |  | 2.6
 | H | 200 |  |  |  |  |  |  |  |  | 3.7
 | I | 250 |  |  |  |  |  |  |  |  | 10.3
 | J | 300 |  |  |  |  |  |  |  |  | 13.2
 | K | 350 |  |  |  |  |  |  |  |  | 15.8
 | L | 400 |  |  |  |  |  |  |  |  | 19.3
 | M | 450 |  |  |  |  |  |  |  |  | 25.5
 | N | 500 |  |  |  |  |  |  |  |  | 38.7
 | O | 550 |  |  |  |  |  |  |  |  | 52.6
 | P | 600 |  |  |  |  |  |  |  |  | 56.3
 | R | 700 |  |  |  |  |  |  |  |  | 100
 | S | 800 |  |  |  |  |  |  |  |  | 143
 | T | 900 |  |  |  |  |  |  |  |  | 215
 | U | 1000 |  |  |  |  |  |  |  |  | 260
 |  | Choosed |  |  |  |  | Pieces |  | Weight
 |  | T1-L |  |  |  |  |  |  | 0
Spreadsheet: 47063d1245958931-auto-populate-multiple-cells-based-on-a-list-selection-golf1
Sheet: Sheet1

Course | Pebble Beach
 | Par | Handicap
Hole 1 | 3 | 1
Hole 2 | 3 | 2
Hole 3 | 2 | 1
Hole 4 | 3 | 1
Hole 5 | 3 | 2
Hole 6 | 2 | 1
Hole 7 | 3 | 1
Hole 8 | 3 | 2
Hole 9 | 2 | 1
Spreadsheet: 271528d1381963604-can-i-get-vlookup-to-change-which-sheet-it-is-working-from-pay-increase-v3
Sheet: 692

7.5 | 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
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
Spreadsheet: 840415d1692715978-attach-a-new-tab-or-worksheet-by-company-name-excel-example
Sheet: Sheet1

Agency Name | Agent Name | Purchase Date | Travel Date | Order # | Refund Order # | Amount | Commission | Passenger Name | Agent Phone | Agent E-mail | address | Zip Code | City | State | Country
Company A | [NAME] | 03/31/2023 10:25 AM | 08/26/2023 | 826582544265806848 |  | $39.00 | $3.90 | [NAME] | [PHONE] | [EMAIL] | [NAME] | 14221 | Williamsville | NY | US
Company A | [NAME] | 05/13/2023 11:43 AM | 08/19/2023 | 842185007333123072 |  | $27.00 | $2.70 | [NAME] | [PHONE] | [EMAIL] | [NAME] | 14221 | Williamsville | NY | US
Company A | [NAME] | 03/31/2023 10:25 AM | 08/19/2023 | 826582544265806848 |  | $44.08 | $3.90 | Todd Packer | [PHONE] | [EMAIL] | [NAME] | 14221 | Williamsville | NY | US
Company A | [NAME] | 05/13/2023 11:39 AM | 08/12/2023 | 842183896169743360 |  | $47.46 | $4.20 | Todd Packer | [PHONE] | [EMAIL] | [NAME] | 14221 | Williamsville | NY | US
Company B | [NAME] | 03/01/2023 04:32 PM | 08/26/2023 | 815818044524758016 |  | $63.00 | $6.30 | [NAME] | [PHONE] | [EMAIL] | 105 Nope Lane | 18519 | Scranton | PA | United States of America
Company B | [NAME] | 03/01/2023 04:32 PM | 08/19/2023 | 815818044524758016 |  | $71.20 | $6.30 | [NAME] | [PHONE] | [EMAIL] | 106 Nope Lane | 18519 | Scranton | PA | United States of America
Company C | Pam Beesly | 06/22/2023 11:42 AM | 08/04/2023 | 856679874234945664 |  | $30.00 | $3.00 | [NAME] | [PHONE] | [EMAIL] | PO BOX 46284910 | 92799 | Santa Ana | CA | United States
Company D | [NAME] | 02/20/2023 02:17 PM | 08/17/2023 | 812522836219405312 |  | $63.00 | $6.30 | [NAME] | [PHONE] | [EMAIL] | 110 Fake It Street | 33545 | Wesley Chapel | FL | US
Company D | [NAME] | 02/20/2023 02:17 PM | 08/10/2023 | 812522836219405312 |  | $71.20 | $6.30 | [NAME] | [PHONE] | [EMAIL] | 111 Fake It Street | 33545 | Wesley Chapel | FL | US
Spreadsheet: 693380d1598949680-really-need-help-with-sum-going-insane-over-this-book1-index-and-frequency
Sheet: Sheet1

 | B | c |  |  |  |  | CARACALA |  |  |  |  | BEBO021999
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2488
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2489
 | 1005 | 2491
 | 1005 | 2491
 | 1005 | 2491
 | 1005 | 188
 | 1005 | 188
 | 1005 | 190
 | 1005 | 190
 | 1005 | 190
 | 1005 | 190
 | 1016 | 1395
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 2488
 | 1016 | 796
Spreadsheet: 816734d1675796423-nested-if-with-vlookup-based-on-a-yes-no-selection-test-for-vlookup-mr-excel-etaf-2
Sheet: new dining

 |  |  | [NAME] | [NAME] | Yes
 |  | Mr | Jones | [NAME] | Yes
 |  | Mr | Smith | [NAME] | Yes
 |  | Ms | Ward | [NAME] | Yes
 |  | Mrs | White | [NAME] | Yes
Spreadsheet: 882474d1730873488-detect-employee-actual-entry-data-and-exit-date-sample-data
Sheet: Sheet1

Employee Name | Entry Date | Exit Date | Entry Date2 | Exit Date |  | Actual Entry Date | Actualy Exit Date | Check | Check
A |  |  |  |  |  | 2021-06-01 00:00:00
A | 2021-10-01 00:00:00 | 2021-11-30 00:00:00 |  |  |  | 2021-06-01 00:00:00
A | 2021-06-01 00:00:00 | 2021-09-30 00:00:00 |  |  |  | 2021-06-01 00:00:00
A | 2020-01-01 00:00:00 | 2020-01-10 00:00:00 |  |  |  | 2020-01-01 00:00:00 | 2020-01-10 00:00:00
B | 2022-10-01 00:00:00 |  |  |  |  | 2021-03-01 00:00:00
B | 2021-10-15 00:00:00 | 2022-09-30 00:00:00 |  |  |  | 2021-03-01 00:00:00
B | 2021-03-01 00:00:00 | 2021-10-14 00:00:00 |  |  |  | 2021-03-01 00:00:00
C | 2024-08-01 00:00:00 | 2027-07-31 00:00:00 |  |  |  | 2024-08-01 00:00:00 | 2027-07-31 00:00:00
D | 2022-05-23 00:00:00 | 2023-04-30 00:00:00 |  |  |  | 2020-12-01 00:00:00 | 2023-04-30 00:00:00
D | 2020-12-01 00:00:00 | 2022-05-22 00:00:00 |  |  |  | 2020-12-01 00:00:00 | 2023-04-30 00:00:00
E |  |  |  |  |  | 2023-10-01 00:00:00
E | 2023-10-01 00:00:00 | 2023-11-10 00:00:00 |  |  |  | 2023-10-01 00:00:00
E | 2020-12-01 00:00:00 | 2022-05-31 00:00:00 |  |  |  | 2020-12-01 00:00:00 | 2022-05-31 00:00:00
Spreadsheet: 840730d1692942508-formula-to-create-list-based-on-filter-test-97-aligw
Sheet: Participant Costing

Client | [NAME]
 | Programs | Times |  | Hours | Apportion | Transport | [NAME]
Program |  | Monday 12:00 to 15:00
 | Craft | Monday 14:30 to 15:30
 | Bowling | Tuesday 09:00 to 12:00
Total
 |  |  | Group Activities - Standard - Weekday Daytime
 |  |  | Centre Capital Cost
 |  |  | Transport
 |  |  | Transport kms
 |  |  | [NAME]
 |  |  | Weekly Cost of Programs
Spreadsheet: 83896d1283934972-excel-2007-table-summary-sample
Sheet: Table

BILL | NAME | QTY
A | [NAME] | 10
A | Mark2 | 20
A | [NAME] | 30
A | Mark4 | 40
A | Mark5 | 50
B | [NAME] | 60
B | Mark2 | 70
B | [NAME] | 80
B | Mark4 | 90
B | Mark5 | 100
C | [NAME] | 110
C | Mark2 | 120
C | [NAME] | 130
C | Mark4 | 140
C | Mark5 | 150
Spreadsheet: 224186d1364480252-remove-the-absent-students-from-the-list-of-failing-students-list-of-faling-students
Sheet: Marks

Group 4
SN | Student's Name | Student No. | Status | Mark | Grade
1 | Student 1 | 13144 | Present | 65
2 | Student 2 | 13145 | Present | 80
3 | Student 3 | 13146 | Present | 77
4 | Student 4 | 13147 | Present | 72
5 | Student 5 | 13148 | Present | 68
6 | Student 6 | 13149 | Present | 63
7 | Student 7 | 13150 | Absent | 0
8 | Student 8 | 13151 | Present | 60
9 | Student 9 | 13152 | Absent | 0
10 | Student 10 | 13153 | Present | 65
11 | Student 11 | 13154 | Present | 77
12 | Student 12 | 13155 | Present | 63
13 | Student 13 | 13156 | Present | 76
14 | Student 14 | 13157 | Absent | 0
15 | Student 15 | 13158 | Present | 79
16 | Student 16 | 13159 | Present | 78
17 | Student 17 | 13160 | Present | 87
18 | Student 18 | 13161 | Present | 71
19 | Student 19 | 13162 | Present | 61
20 | Student 20 | 13163 | Present | 53
21 | Student 21 | 13164 | Present | 60
22 | Student 22 | 13165 | Present | 88
23 | Student 23 | 13166 | Present | 63
24 | Student 24 | 13167 | Present | 50
25 | Student 25 | 13168 | Present | 65
26 | Student 26 | 13169 | Present | 58
27 | Student 27 | 13170 | Present | 91
28 | Student 28 | 13171 | Present | 70
29 | Student 29 | 13172 | Present | 73
30 | Student 30 | 13173 | Absent | 0
31 | Student 31 | 13174 | Present | 60
32 | Student 32 | 13175 | Present | 63
33 | Student 33 | 13176 | Present | 78
34 | Student 34 | 13177 | Present | 67
35 | Student 35 | 13178 | Present | 78
36 | Student 36 | 13179 | Present | 89
37 | Student 37 | 13180 | Present | 79
38 | Student 38 | 13181 | Present | 55
39 | Student 39 | 13182 | Present | 73
40 | Student 40 | 13183 | Present | 33
41 | Student 41 | 13184 | Present | 67
42 | Student 42 | 13185 | Present | 76
43 | Student 43 | 13186 | Present | 88
44 | Student 44 | 13187 | Present | 56
45 | Student 45 | 13188 | Present | 70
46 | Student 46 | 13189 | Absent | 0
47 | Student 47 | 13190 | Present | 62
48 | Student 48 | 13191 | Present | 63
49 | Student 49 | 13192 | Present | 78
Spreadsheet: 774998d1648756242-calculating-loan-repayments-loan-repayments
Sheet: Sheet1

Loan amount | 100000 |  |  | Principal | Interest | Additional Payments | Total (E+F+G) | Remaining Balance
Interest Rate | 0.02 |  | 2022-04-22 00:00:00
 |  |  | 2022-05-22 00:00:00
 |  |  | 2022-06-22 00:00:00
 |  |  | 2022-07-22 00:00:00
 |  |  | 2022-08-22 00:00:00
 |  |  | 2022-09-22 00:00:00
 |  |  | 2022-10-22 00:00:00
 |  |  | 2022-11-22 00:00:00
 |  |  | 2022-12-22 00:00:00
 |  |  | 2023-01-22 00:00:00
 |  |  | 2023-02-22 00:00:00
 |  |  | 2023-03-22 00:00:00
 |  |  | 2023-04-22 00:00:00
 |  |  | 2023-05-22 00:00:00
 |  |  | 2023-06-22 00:00:00
 |  |  | 2023-07-22 00:00:00
 |  |  | 2023-08-22 00:00:00
 |  |  | 2023-09-22 00:00:00
 |  |  | 2023-10-22 00:00:00
 |  |  | 2023-11-22 00:00:00
 |  |  | 2023-12-22 00:00:00
 |  |  | 2024-01-22 00:00:00
 |  |  | 2024-02-22 00:00:00
 |  |  | 2024-03-22 00:00:00
 |  |  | 2024-04-22 00:00:00
 |  |  | 2024-05-22 00:00:00
 |  |  | 2024-06-22 00:00:00
 |  |  | 2024-07-22 00:00:00
 |  |  | 2024-08-22 00:00:00
 |  |  | 2024-09-22 00:00:00
 |  |  | 2024-10-22 00:00:00
 |  |  | 2024-11-22 00:00:00
 |  |  | 2024-12-22 00:00:00
 |  |  | 2025-01-22 00:00:00
 |  |  | 2025-02-22 00:00:00
 |  |  | 2025-03-22 00:00:00
 |  |  | 2025-04-22 00:00:00
 |  |  | 2025-05-22 00:00:00
 |  |  | 2025-06-22 00:00:00
 |  |  | 2025-07-22 00:00:00
 |  |  | 2025-08-22 00:00:00
 |  |  | 2025-09-22 00:00:00
 |  |  | 2025-10-22 00:00:00
 |  |  | 2025-11-22 00:00:00
 |  |  | 2025-12-22 00:00:00
 |  |  | 2026-01-22 00:00:00
 |  |  | 2026-02-22 00:00:00
 |  |  | 2026-03-22 00:00:00
 |  |  | 2026-04-22 00:00:00
 |  |  | 2026-05-22 00:00:00
Spreadsheet: 58616d1258852761-dates-in-a-pivot-table-attendance
Sheet: Attendance

name | date from | date to | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 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 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
[NAME] | 2009-07-21 00:00:00 | 2009-07-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
anne | 2009-05-22 00:00:00 | 2009-05-30 00:00:00 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2009-06-12 00:00:00 | 2009-08-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 19 | 31 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2009-04-12 00:00:00 | 2009-05-02 00:00:00 | 0 | 0 | 0 | 19 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
mary | 2009-04-11 00:00:00 | 2009-04-21 00:00:00 | 0 | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2009-07-26 00:00:00 | 2009-08-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 825915d1681640136-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-newsample_ceepeebee-aligw
Sheet: Scenario 2 - not working

Week Date | 2023-05-04 00:00:00
Name | Team | Starting Weight | Starting Height | Starting BMI | Concurrent Week Losses | Hat-Trick | 2023-04-06 00:00:00
 |  |  |  |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
Stephan | White | 129 | 180 |  | 0 |  | 128 | 128 | 126 | 125 | 125
Stephan has lost weight 3 times in total since beginning, but has not lost weight this week compared to previous week - staying the same. This should NOT be a hat-trick as he was awarded that last week by hitting his 3rd total loss.
Spreadsheet: 772266d1647137069-multiple-rank-tiebreakers-with-blanks-audit-book-woorking-test
Sheet: PM Optionals

 |  |  |  | Interview |  |  |  |  |  |  |  |  | Talent |  |  |  |  |  | On Stage Question
 |  |  |  | Judge 1 |  |  | Judge 2 |  |  | Judge 3 |  |  | Judge 1 |  | Judge 2 |  | Judge 3 |  | Judge 1 |  |  | Judge 2 |  |  | Judge 3
Contestant Number | [NAME] | Group | Division | Ease of Answer | Presentation of Answers | Confidence | Ease of Answer | Presentation of Answers | Confidence | Ease of Answer | Presentation of Answers | Confidence | Projection | Overall Entertainment Value | Projection | Overall Entertainment Value | Projection | Overall Entertainment Value | Ease of Answer | Poise | Confidence | Ease of Answer | Poise | Confidence | Ease of Answer | Poise | Confidence | Total Interview | Interview Tie Breaker 1 | Interview Tie Breaker 2 | Total Talent | Talent [NAME] | Total OSQ | OSQ Tie Breaker 1 | OSQ Tie Breaker 2 | Interview Rank | Talent Rank | OSQ Rank
Spreadsheet: 36873d1234847038-excel-2007-how-do-i-reference-a-min-value-in-another-spreadsheet-discrete-measures
Sheet: SLw-rtoH

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS