tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867195d1714057110-normalise-data-example
Sheet: Sheet1

Date | user 1 | user 2 | user 3 | user 4 | user 5 | user 6 | user 7
2024-01-01 00:00:00 | 58 | 183 | 424 | 97 | 237 | 19 | 1327
2024-01-02 00:00:00 | 108 | 174 | 453 | 105 | 216 | 30 | 1494
2024-01-03 00:00:00 | 119 | 288 | 522 | 104 | 278 | 22 | 1617
2024-01-04 00:00:00 | 436 | 803 | 1440 | 444 | 1220 | 164 | 3295
2024-01-05 00:00:00 | 93 | 191 | 480 | 132 | 281 | 44 | 1383
2024-01-06 00:00:00 | 67 | 171 | 410 | 59 | 273 | 58 | 1228
2024-01-07 00:00:00 | 49 | 237 | 431 | 44 | 306 | 59 | 1235
2024-01-08 00:00:00 | 69 | 174 | 445 | 28 | 233 | 51 | 1098
2024-01-09 00:00:00 | 53 | 107 | 412 | 28 | 157 | 46 | 1300
2024-01-10 00:00:00 | 56 | 146 | 355 | 25 | 139 | 42 | 1305
2024-01-11 00:00:00 | 55 | 242 | 410 | 40 | 139 | 44 | 1409
2024-01-12 00:00:00 | 66 | 195 | 369 | 33 | 170 | 56 | 1341
2024-01-13 00:00:00 | 59 | 186 | 379 | 24 | 183 | 30 | 1295
2024-01-14 00:00:00 | 56 | 168 | 390 | 39 | 198 | 42 | 1437
2024-01-15 00:00:00 | 53 | 253 | 424 | 27 | 165 | 49 | 1473
2024-01-16 00:00:00 | 47 | 166 | 404 | 47 | 189 | 46 | 1436
2024-01-17 00:00:00 | 56 | 180 | 427 | 31 | 184 | 40 | 1437
2024-01-18 00:00:00 | 65 | 140 | 395 | 22 | 189 | 48 | 1351
2024-01-19 00:00:00 | 71 | 141 | 382 | 38 | 182 | 38 | 1383
2024-01-20 00:00:00 | 73 | 113 | 387 | 26 | 171 | 39 | 1193
2024-01-21 00:00:00 | 70 | 146 | 374 | 107 | 158 | 38 | 1367
2024-01-22 00:00:00 | 59 | 151 | 413 | 92 | 232 | 42 | 1140
2024-01-23 00:00:00 | 79 | 177 | 389 | 98 | 231 | 64 | 1387
2024-01-24 00:00:00 | 55 | 153 | 356 | 87 | 206 | 46 | 1321
2024-01-25 00:00:00 | 55 | 166 | 357 | 102 | 194 | 63 | 1406
2024-01-26 00:00:00 | 93 | 151 | 373 | 78 | 191 | 49 | 1415
2024-01-27 00:00:00 | 61 | 132 | 337 | 50 | 177 | 38 | 1477
2024-01-28 00:00:00 | 66 | 126 | 375 | 42 | 178 | 35 | 1386
2024-01-29 00:00:00 | 71 | 150 | 336 | 62 | 168 | 46 | 1140
2024-01-30 00:00:00 | 44 | 161 | 314 | 38 | 166 | 43 | 1221
2024-01-31 00:00:00 | 47 | 112 | 316 | 35 | 122 | 34 | 1224
Spreadsheet: 328514d1403926952-how-to-link-drop-down-list-to-table-table-with-drop-down
Sheet: Sheet1

Select Month | (dropdown link to below table) |  |  |  | January
 | E.q | if i choose dropdown list it will link to the table and can be updated directly
January |  | When i choose February from Dropdown list, colomn a4:b22 will be replace by february data and we can update the data from it
1 | 100
2 | 100 | How can i do that?
3 | 100
4 | 100
5 | 100
6 | 200
7 | 100
8 | 300
9 | 100
10 | 400
11 | 100
12 | 100
13 | 100
14 | 100
15 | 100
16 | 100
17 | 100
18 | 100
February
1 | 100
2 | 100
3 | 100
4 | 100
5 | 100
6 | 200
7 | 100
8 | 300
9 | 100
10 | 400
11 | 100
12 | 100
13 | 100
14 | 100
15 | 100
16 | 100
17 | 100
18 | 100
Spreadsheet: 143899d1330620807-grabbing-data-from-multiple-pages-and-having-it-on-one-total-excel-tab-goldriskslide
Sheet: Vega

Vega matrix of portfolio 'GOLD'
calculated 09:49 01 Mar 2012
GC
GC Apr Future:1717.30
vega in USD
v \ p | p:-25% | p:-13% | p:-3.9% | p:-1.3% | p:+0% | p:+1.3% | p:+3.9% | p:+13% | p:+25%
v:-25pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
v:-13pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
v:-3.9pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
v:-1.3pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
v:+0pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
v:+1.3pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
v:+3.9pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
v:+13pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
v:+25pts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GLD
GLD Spot:166.77
vega in USD
v \ p | p:-25% | p:-13% | p:-3.9% | p:-1.3% | p:+0% | p:+1.3% | p:+3.9% | p:+13% | p:+25%
v:-25pts | 0 | 233 | 0 | 0 | 2 | -598 | 0 | -8 | 0
v:-13pts | 0 | 4392 | -3053 | 1357 | -167 | -10295 | -5607 | -3117 | -38
v:-3.9pts | 1193 | 5408 | -2880 | -6602 | -9791 | -13044 | -16679 | -12957 | -1554
v:-1.3pts | 1737 | 5295 | -3702 | -8354 | -11476 | -14484 | -18917 | -15177 | -2624
v:+0pts | 1987 | 5233 | -4168 | -9178 | -12278 | -15260 | -19820 | -16243 | -3029
v:+1.3pts | 2219 | 5120 | -4742 | -9980 | -13045 | -15983 | -20678 | -17113 | -3659
v:+3.9pts | 2629 | 4719 | -6099 | -11523 | -14524 | -17351 | -22036 | -18604 | -4846
v:+13pts | 3490 | 2412 | -10688 | -16058 | -18663 | -21096 | -24875 | -22196 | -8960
v:+25pts | 3377 | -1771 | -15580 | -19992 | -21983 | -23773 | -26468 | -24757 | -13576
OG
GC Apr Future:1717.30, GC Jun Future:1720.05
vega in USD
v \ p | p:-25% | p:-13% | p:-3.9% | p:-1.3% | p:+0% | p:+1.3% | p:+3.9% | p:+13% | p:+25%
v:-25pts | 0 | 478 | -4093 | 895 | 1398 | -676 | 0 | 0 | -2068
v:-13pts | -235 | 2902 | -8278 | -3043 | 23635 | 28122 | 15516 | 7296 | -1206
v:-3.9pts | -3130 | 4017 | -7390 | 11129 | 21669 | 29315 | 32847 | 16647 | 1882
v:-1.3pts | -3381 | 3531 | -1772 | 13866 | 22443 | 28994 | 33739 | 19594 | 3478
v:+0pts | -3457 | 3333 | 828 | 15168 | 22970 | 29003 | 33987 | 20920 | 4374
v:+1.3pts | -3516 | 3224 | 3248 | 16427 | 23503 | 29099 | 34154 | 22168 | 5294
v:+3.9pts | -3498 | 3291 | 7506 | 18778 | 24624 | 29501 | 34388 | 24415 | 7230
v:+13pts | -2540 | 6150 | 17829 | 24865 | 28370 | 31313 | 34981 | 29566 | 13800
v:+25pts | 375 | 12000 | 24939 | 29418 | 31444 | 33201 | 35597 | 32959 | 20683
Spreadsheet: 743665d1628667963-last-3-game-results-in-a-league-last-3-game-results-in-a-league
Sheet: Sheet1

 | League Results |  |  |  |  |  |  | League Table
 | # | Date | Home Team | Away Team | Home Team | Away Team |  | # | Team | Last 3 Games |  |  | P | W | D | L | F | A | [NAME] | Pts
 | 1 | 2021-01-01 00:00:00 | Team H | Team E | 1 | 0 |  | 1 | Team A | D | W | L
 | 2 |  | Team C | Team G | 0 | 1 |  | 2 | Team B | W | L | W
 | 3 |  | Team E | Team C | 2 | 5 |  | 3 | Team C | W | L | -
 | 4 |  | Team A | Team D | 0 | 2 |  | 4 | Team D | D | D | L
 | 5 |  | Team I | Team J | 1 | 3 |  | 5 | Team E
 | 6 |  | Team H | Team G | 1 | 2 |  | 6 | Team F
 | 7 |  | Team J | Team B | 2 | 5 |  | 7 | Team G
 | 8 |  | Team A | Team H | 4 | 0 |  | 8 | Team H
 | 9 |  | Team F | Team D | 7 | 2 |  | 9 | Team I
 | 10 |  | Team G | Team D | 2 | 2 |  | 10 | Team J
 | 11 |  | Team A | Team E | 3 | 3 |  |  | Total
 | 12 |  | Team B | Team F | 0 | 1
 | 13 |  | Team E | Team G | 2 | 0
 | 14 |  | Team I | Team H | 2 | 0
 | 15 |  | Team F | Team E | 3 | 4
 | 16 |  | Team B | Team I | 1 | 0
 | 17 |  | Team J | Team D | 1 | 1
 | 18 |  | Team C | Team J
 | 19 |  | Team D | Team B
 | 20 |  | Team I | Team E
 | 21 |  | Team A | Team C
 | 22 |  | Team D | Team I
 | 23 |  | Team I | Team F
 | 24 |  | Team G | Team A
 | 25 |  | Team H | Team C
 | 26 |  | Team I | Team A
 | 27 |  | Team B | Team G
 | 28 |  | Team D | Team C
 | 29 |  | Team H | Team D
 | 30 |  | Team E | Team J
 | 31 |  | Team C | Team B
 | 32 |  | Team F | Team H
 | 33 |  | Team I | Team C
 | 34 |  | Team H | Team B
 | 35 |  | Team A | Team F
 | 36 |  | Team A | Team J
 | 37 |  | Team E | Team D
 | 38 |  | Team I | Team G
 | 39 |  | Team B | Team E
 | 40 |  | Team J | Team H
 | 41 |  | Team B | Team A
 | 42 |  | Team J | Team F
 | 43 |  | Team A | Team I
 | 44 |  | Team G | Team B
 | 45 |  | Team C | Team D
 | 46 |  | Team H | Team I
 | 47 |  | Team E | Team F
 | 48 |  | Team C | Team A
 | 49 |  | Team I | Team B
 | 50 |  | Team D | Team J
 | 51 |  | Team B | Team D
 | 52 |  | Team J | Team C
 | 53 |  | Team E | Team I
 | 54 |  | Team G | Team J
 | 55 |  | Team E | Team A
 | 56 |  | Team D | Team G
 | 57 |  | Team F | Team B
 | 58 |  | Team G | Team E
 | 59 |  | Team J | Team I
 | 60 |  | Team D | Team A
 | 61 |  | Team F | Team I
 | 62 |  | Team C | Team H
 | 63 |  | Team A | Team G
 | 64 |  | Team J | Team E
 | 65 |  | Team I | Team D
 | 66 |  | Team F | Team C
 | 67 |  | Team B | Team J
 | 68 |  | Team G | Team H
 | 69 |  | Team D | Team F
 | 70 |  | Team H | Team A
 | 71 |  | Team G | Team C
 | 72 |  | Team C | Team E
 | 73 |  | Team F | Team J
 | 74 |  | Team B | Team H
 | 75 |  | Team E | Team B
 | 76 |  | Team H | Team J
 | 77 |  | Team G | Team F
 | 78 |  | Team J | Team A
 | 79 |  | Team D | Team E
 | 80 |  | Team E | Team H
 | 81 |  | Team F | Team G
 | 82 |  | Team H | Team F
 | 83 |  | Team C | Team I
 | 84 |  | Team A | Team B
 | 85 |  | Team G | Team I
 | 86 |  | Team C | Team F
 | 87 |  | Team F | Team A
 | 88 |  | Team B | Team C
 | 89 |  | Team D | Team H
 | 90 |  | Team J | Team G
Spreadsheet: 852727d1702662056-sumifs-with-multiple-criteria-with-dates-example-spreadsheet
Sheet: Ind

Phase | Project Number | Funding Source | Funds | ACC Code | Project Description | Planned Package Submission Date | Acq Plan ID | Actual Package Submission Date | Original Planned Month of Obligation | [NAME] of Obligation | FY24 Approved Budget | CLI | TDA  Amount Requested | Amount Obligated | Date Obligated
Construct | 1234 | Base | 0598B1 | NP/3 | Build chicken coop | TBD | 36C000 | TBD | 2023-11-01 00:00:00 |  | 180000 |  | 125000 | 125000 | 2023-10-25 00:00:00
Design | 1235 | MF | 0598B1 | NP/4 | Design storage warehouse | TBD | 36C001 | TBD | 2023-12-01 00:00:00 |  | 900000 |  | 620000 | 620000 | 2023-11-27 00:00:00
Construct | 1236 | Base | 0598B1 | NP/5 | Garage | TBD | 36C002 | TBD | 2024-02-01 00:00:00 |  | 625000 |  | 469230 | 469230 | 2024-02-15 00:00:00
Construct | 1237 | Minor | 0598B1 | NP/6 | Parking Garage Gates | TBD | 36C003 | TBD | 2023-12-01 00:00:00 | 2024-02-01 00:00:00 | 1650000 |  | 1650000 | 1650000 | 2024-03-01 00:00:00
Design | 1238 | Base | 0598B1 | NP/7 | Electrical Distribution System | TBD | 36C004 | TBD | 2023-12-01 00:00:00 | 2024-02-01 00:00:00 | 600000 |  | 689000 | 689000 | 2024-06-04 00:00:00
Design | 1239 | Base | 0598B1 | NP/8 | Replace Lighting | TBD | 36C005 | TBD | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2100000 |  | 2100000 | 2100000 | 2024-02-27 00:00:00
Construct | 1240 | Base | 0598B1 | NP/9 | Exterior Staircase | TBD | 36C006 | TBD | 2023-12-01 00:00:00 | 2024-03-01 00:00:00 | 350000 |  | 350000 | 350000 | 2024-04-04 00:00:00
Construct | 1241 | Base/FY19 | 0598B1 | NP/10 | Renovate Chicken Clinic | TBD | 36C007 | TBD | 2024-02-01 00:00:00 | 2024-05-01 00:00:00 | 15871883 |  | 15871883 | 15871883 | 2024-05-01 00:00:00
Construct | 1242 | Base | 0598B1 | NP/11 | Play room for chickens | TBD | 36C008 | TBD | 2024-06-01 00:00:00 |  | 1500000 |  | 1500000 | 1500000 | 2024-09-04 00:00:00
Spreadsheet: 480771d1474047457-sorting-letters-before-numbers-book4
Sheet: Sheet1 (2)

X | Lv1 | Lv2
SU003-05810
SU003-05811
85315-06140
85315-06220
85315-0R030
85315-47060
85315-47140
85315-52440
85315-60390
85315-AA040
88710-04171
88710-0C090
Spreadsheet: 688605d1595866029-need-to-calculate-max-in-range-with-2-criteria-and-return-the-result-of-a-different-column-sample_hd_2
Sheet: Service Transactions

Date | Mileage | Description | Cost | Code | Reg
2020-01-01 00:00:00 | 55000 | 42.3 | 45.684 | FUE | AB12CDE
2020-01-02 00:00:00 | 55015 | Parts ABC | 33.5 | PAR | AB12CDE
2020-01-03 00:00:00 | 55217 | Parts DEF | 168.7 | PAR | AB12CDE |  | Needed a formula base on the following criteria
2020-01-04 00:00:00 | 24380 | 22.3 | 24.084 | FUE | XY98XYZ |  | and return the description of the highest mileage FUE code within range
2020-01-05 00:00:00 | 55220 | Parts DEF | 55 | PAR | AB12CDE
2020-01-06 00:00:00 | 55224 | 18.8 | 20.304 | FUE | AB12CDE |  | Reg: | AB12CDE | <- User input
2020-01-07 00:00:00 | 24390 | 40 | 43.2 | FUE | XY98XYZ |  | from: | 2020-01-10 00:00:00 | <- User input
2020-01-08 00:00:00 | 54280 | 55.3 | 59.724 | FUE | AB12CDE |  | to: | 2020-01-16 00:00:00 | <- User input
2020-01-09 00:00:00 | 24387 | Parts DEF | 18 | PAR | XY98XYZ
2020-01-10 00:00:00 | 24400 | 42 | 45.36 | FUE | XY98XYZ |  | Result should be |  | 30.1
2020-01-11 00:00:00 | 24400 | Parts DEF | 27.5 | PAR | XY98XYZ
2020-01-12 00:00:00 | 24429 | 21.2 | 22.896 | FUE | XY98XYZ
2020-01-13 00:00:00 | 54320 | Parts DEF | 158.2 | PAR | AB12CDE
2020-01-14 00:00:00 | 54320 | Parts DEF | 155.89 | PAR | AB12CDE
2020-01-15 00:00:00 | 54380 | 30.1 | 32.508 | FUE | AB12CDE
2020-01-16 00:00:00 | 24720 | 28.5 | 30.78 | FUE | XY98XYZ
2020-01-17 00:00:00 | 24720 | Parts DEF | 85.34 | PAR | XY98XYZ
2020-01-18 00:00:00 | 54490 | 18.9 | 20.412 | FUE | AB12CDE
2020-01-19 00:00:00 | 54520 | 42.5 | 45.90000000000001 | FUE | AB12CDE
2020-01-20 00:00:00 | 54660 | 52.1 | 56.26800000000001 | FUE | AB12CDE
2020-01-21 00:00:00 | 24800 | Parts DEF | 84.2 | PAR | XY98XYZ
2020-01-22 00:00:00 | 24925 | 12.4 | 13.392 | FUE | XY98XYZ
2020-01-23 00:00:00 | 54700 | 17.8 | 19.224 | FUE | AB12CDE
2020-01-24 00:00:00 | 54900 | 19.2 | 20.736 | FUE | AB12CDE
2020-01-25 00:00:00 | 24980 | Parts DEF | 125 | PAR | XY98XYZ
2020-01-26 00:00:00 | 54980 | 22.3 | 24.084 | FUE | AB12CDE
2020-01-27 00:00:00 | 54985 | Parts DEF | 22.2 | PAR | AB12CDE
Spreadsheet: 728206d1618360591-nth-non-blank-cell-value-smaller-than-non-blank-values
Sheet: Data

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 2 | 17 | 18 | 19
15 | 210 | 12 | 4 | 8 | 14 | 2 | 8 | 9 | 10 | 2 | 12 | 13 | 14 | 5 | 4 | 3 | 18 | 19
1st non blank with value smaller than 10 |  |  |  |  |  |  |  |  | ?
2nd non blank smaller than 10 |  |  |  |  |  |  |  |  | ?
1st non blank smaller than 20 |  |  |  |  |  |  |  |  | ?
1st non blank between 15 and 20? |  |  |  |  |  |  |  |  | ?
Spreadsheet: 772973d1647538810-extract-and-return-a-min-date-and-max-dates-extract-and-return-a-min-date-and-max-dates
Sheet: Sheet1

 |  |  |  |  |  |  | Expected Results
Date | ID | Type |  | Period | ID | Type | Min Date | [NAME]
2019-11-01 00:00:00 | DXB-38665V | ghgh |  | [NAME] | DXB-38665V | ghgh
2019-11-01 00:00:00 | 92801 | abcd |  | [NAME] | 92801 | abcd
2019-11-03 00:00:00 | ESH88 | efgh |  | [NAME] | ESH88 | efgh
2019-11-04 00:00:00 | EGR75 | ijkl |  | [NAME] | EGR75 | ijkl
2019-11-05 00:00:00 | 27660 | abcd |  | [NAME] | 27660 | abcd
2019-11-06 00:00:00 | 74756 | [NAME] |  | [NAME] | 74756 | [NAME]
2019-11-10 00:00:00 | DXB-38665V | ghgh |  | Dec-2019 | DXB-38665V | ghgh
2019-11-15 00:00:00 | 92801 | abcd |  | Dec-2019 | 92801 | abcd
2019-11-16 00:00:00 | ESH88 | efgh |  | Dec-2019 | ESH88 | efgh
2019-11-17 00:00:00 | EGR75 | ijkl |  | Dec-2019 | EGR75 | ijkl
2019-12-01 00:00:00 | DXB-38665V | ghgh |  | Dec-2019 | 27660 | abcd
2019-12-01 00:00:00 | 92801 | abcd |  | Dec-2019 | 74756 | [NAME]
2019-12-03 00:00:00 | ESH88 | efgh
2019-12-04 00:00:00 | EGR75 | ijkl
2019-12-05 00:00:00 | 27660 | abcd
2019-12-06 00:00:00 | 74756 | [NAME]
2019-12-10 00:00:00 | DXB-38665V | ghgh
2019-12-15 00:00:00 | 92801 | abcd
2019-12-16 00:00:00 | ESH88 | efgh
2019-12-17 00:00:00 | EGR75 | ijkl
Spreadsheet: 870249d1716798144-sumproduct-formula-not-giving-any-results-excel-help-with-formulas-2-
Sheet: Results2

Week Commencing | Contract | Contract % | Days Worked | Days Lost | Daily Average m3 | Reasons for Days Lost | Reasons for Days Lost | Contract Profit | Profit per Machine | Daily Average Profit | Contract Notes
2024-05-20 00:00:00 |  | 0.4128719700658893 |  |  | 0 | N/A | N/A | 0 | 0 | 0
Week Number |  | 0.2685192032446584 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
21 |  | -0.0240430185085006 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5621419179755577 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.4986884850326427 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | -3.188679245283019 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | -0.907337315301817 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.4610992148465382 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.2984562607204116 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5339903123434107 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.533648738653455 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5055384901796519 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5652835314996856 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.6893036611629576 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5522838807097018 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.5104021049172628 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | -0.3474453888652783 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | 0.4396701303217971 |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  | #[NAME]! |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Spreadsheet: ea74da7b-b83a-4627-b316-55bfbdc86466
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2322 | 10289 | Julia | Lucke | GER | 0 | 00:21:52 | [NAME] | 00:26:30 | 00:02:44 | 00:25:23 | 1 | 01:27:21
2322 | 7616 | [NAME] | Springman | GBR | 0 | 00:25:15 | 00:00:20 | 00:28:02 | 00:01:53 | 00:36:00 | 2 | 01:31:35
2322 | 10258 | Claudia | [NAME] | ITA | 0 | 00:27:56 | 00:00:32 | 00:28:15 | 00:01:43 | 00:40:04 | 3 | [NAME]
2322 | 10253 | [NAME] | Ferrari | ITA | 0 | 00:26:27 | 00:00:46 | 00:29:10 | 00:01:39 | 00:49:40 | 4 | 01:47:45
Spreadsheet: 94183d1294067777-formula-for-sport-rankings-wrestlingleage
Sheet: 140

Weight | Ranking | First Name | Last Name | School | Section | Grade
140 | 1 | [NAME] | [NAME] | Oakdale | SJ | 12
140 | 2 | [NAME] | Martinez | Lemoore | CS | 10 | reno 1
140 | 3 | Blake | [NAME] | Gilroy | CC | 11 | reno 3
140 | 4 | Nick | Cano | [NAME] | CC | 12 | 2010 CIF 3
140 | 5 | Adam | Hendrickson | Healdsburg | NC | 11 | 2010 CIF 7
140 | 6 | [NAME] | Abono | De La Salle | NC | 11 | reno 5
140 | 7 | [NAME] | [NAME] | Pitman | SJ | 12 | 2010 CIF 8
140 | 8 | Timmy | Box | Bakersfield | CS | 12
140 | 9 | [NAME] | [NAME] | Sultana | SS | 12
140 | 10 | Nick | [NAME] | Paradise | NS | 12 | zink 1
Spreadsheet: 173617d1344617703-autopopulate-table-in-sheet-1-when-entries-are-put-into-sheet-2-3-4-etc-autofill-table-on-another-sheet
Sheet: Master

 | Key | AA | AB | AC | AD | AE |  | Master [NAME]
 | Sheet A | 1 | 2 | 9 | no | ZA |  | The blue cells would contain a formula that autopopulates these cells when info is put in the appropriate sheets.
 | Sheet A | 1 | 3 | 9 | no | ZA |  | Approximately 20 columns worth of data would need to autofill.  I merely listed 6.
 | Sheet A | 1 | 4 | 9 | no | ZA
 | Sheet A | 1 | 2 | 9 | no | ZB |  | Sheet - Template
 | Sheet A | 1 | 3 | 9 | no | ZB |  | This is the sheet I copy and would Rename as Sheet - C (when needed) and fill with new data.
 | Sheet A | 1 | 4 | 9 | no | ZB
 | Sheet A | 1 | 2 | 9 | no | ZC |  | Sheet  - A
 | Sheet A | 1 | 3 | 9 | no | ZC |  | Twelve lines were filled in, and autopopulated in the master sheet once a YES was placed in "column L"
 | Sheet A | 1 | 4 | 9 | no | ZC
 | Sheet A | 1 | 2 | 9 | no | ZD
 | Sheet A | 1 | 3 | 9 | no | ZD
 | Sheet A | 1 | 4 | 9 | no | ZD
 | Sheet B | 1 | 25 | 9 | no | ZA
 | Sheet B | 1 | 35 | 9 | no | ZA
 | Sheet B | 1 | 45 | 9 | no | ZA
 | Sheet B | 1 | 55 | 9 | no | ZA
 | Sheet B | 1 | 65 | 9 | no | ZA
 | Sheet B | 1 | 75 | 9 | no | ZA
 | Sheet B | 1 | 25 | 9 | no | ZB
 | Sheet B | 1 | 35 | 9 | no | ZB
 | Sheet B | 1 | 45 | 9 | no | ZB
 | Sheet B | 1 | 55 | 9 | no | ZB
 | Sheet B | 1 | 65 | 9 | no | ZB
 | Sheet B | 1 | 75 | 9 | no | ZB
 | Sheet B | 1 | 25 | 9 | no | ZC
 | Sheet B | 1 | 35 | 9 | no | ZC
 | Sheet B | 1 | 45 | 9 | no | ZC
 | Sheet B | 1 | 55 | 9 | no | ZC
 | Sheet B | 1 | 65 | 9 | no | ZC
 | Sheet B | 1 | 75 | 9 | no | ZC
Spreadsheet: 172211d1344026706-adding-reminders-tigeravatar-example-for-psilver1
Sheet: Bag 5

Item | Expiration Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bag 5
Item 01 | 2012-08-12 00:00:00
Item 02 | 2012-08-08 00:00:00
Item 03 | 2012-08-14 00:00:00
Item 04 | 2012-08-07 00:00:00
Item 05 | 2012-08-07 00:00:00
Item 06 | 2012-08-10 00:00:00
Item 07 | 2012-08-11 00:00:00
Item 08 | 2012-08-11 00:00:00
Item 09 | 2012-08-15 00:00:00
Item 10 | 2012-08-04 00:00:00
Item 11 | 2012-08-15 00:00:00
Item 12 | 2012-08-04 00:00:00
Item 13 | 2012-08-10 00:00:00
Item 14 | 2012-08-15 00:00:00
Item 15 | 2012-08-07 00:00:00
Item 16 | 2012-08-10 00:00:00
Item 17 | 2012-08-17 00:00:00
Item 18 | 2012-08-12 00:00:00
Item 19 | 2012-08-05 00:00:00
Item 20 | 2012-08-08 00:00:00
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B21

Local 21
Nom: | FMD Transport* | [NAME]
Numéro de téléphone: | [PHONE] | [NAME]
[NAME]: | 40
Paiement dû le: | 2013-02-26 00:00:00
[NAME]: | 15
Réservé: | réservé
Prix: | 80
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 867010d1713916885-if-function-to-check-if-x-date-is-before-y-date-not-working-if-test
Sheet: Test

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount | Balance
[NAME] | Invoice Number | Invoice Amount | Start Date | End Date | Months | Monthly Amortization | Total Amortized to Date | Remaining Balance
 |  | 2500 | 2023-01-26 00:00:00 | 2024-03-31 00:00:00
 |  | 2500 | 2023-01-26 00:00:00 | 2024-03-31 00:00:00
 |  | 1216 | 2023-02-01 00:00:00 | 2025-01-30 00:00:00
 |  | 3769.33 | 2023-02-01 00:00:00 | 2025-01-30 00:00:00
 |  | 22627.5 | 2023-06-01 00:00:00 | 2024-05-31 00:00:00
 |  | 25321.25 | 2023-06-01 00:00:00 | 2024-05-31 00:00:00
 |  | 1060.12 | 2023-07-01 00:00:00 | 2028-06-01 00:00:00
 |  | 23420 | 2023-08-01 00:00:00 | 2024-07-31 00:00:00
 |  | 799 | 2023-08-01 00:00:00 | 2024-07-31 00:00:00
 |  | 13110 | 2023-10-01 00:00:00 | 2024-03-31 00:00:00
 |  | 4555.62 | 2023-10-02 00:00:00 | 2024-11-30 00:00:00
 |  | 18390 | 2023-11-30 00:00:00 | 2024-11-30 00:00:00
 |  | 11500 | 2023-12-01 00:00:00 | 2024-07-30 00:00:00
 |  | 2079.27 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00
 |  | 2079.27 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00
 |  | 18713.46 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00
 |  | 10000 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
 |  | 30000 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
 |  | 5000 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00
 |  | 15000 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
 |  | 25000 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
 |  | 400000 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
 |  | 6876.71 | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 | 4
 |  | 12848.27 | 2024-01-08 00:00:00 | 2024-04-07 00:00:00
 |  | 295244.56 | 2024-01-11 00:00:00 | 2024-10-01 00:00:00
 |  | 3199 | 2024-01-23 00:00:00 | 2025-01-23 00:00:00
 |  | 4985.34 | 2024-01-31 00:00:00 | 2025-01-30 00:00:00
 |  | 38587.25 | 2024-02-01 00:00:00 | 2024-04-30 00:00:00
 |  | 19533.44 | 2024-03-01 00:00:00 | 2024-05-31 00:00:00
 |  | 10000 | 2024-03-30 00:00:00 | 2024-06-29 00:00:00
 |  | 6000 | 2024-06-01 00:00:00 | 2024-06-30 00:00:00
 |  | 4975 | 2024-07-01 00:00:00 | 2024-07-15 00:00:00
 |  | 2500 | 2024-12-01 00:00:00 | 2024-12-01 00:00:00
 |  | 150000 | 2025-02-17 00:00:00 | 2025-02-17 00:00:00 | 1
 |  | 8770 | 2025-02-17 00:00:00 | 2025-02-17 00:00:00 | 1
 |  | 99293 | 2026-02-01 00:00:00 | 2/29/2026 | 1