tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 165341d1341185783-project-timeline-calculation-workday-calcs-for-cogic
Sheet: Plan

 | Table3
 | State | FY2010_SP | Cnty_Agcy | P_Sec_Inst | Contacts | [NAME] | Start | Finish | PLACEMENT
 | California | 2409.487604556806 | 58 | 70 |  |  | 2012-07-01 00:00:00
 | New York | 1788.824460552066 | 62 | 101
 | Texas | 1215.428490624481 | 254 | 60
 | Illinois | 1189.191343407895 | 100 | 49
 | Ohio | 1034.534305810557 | 88 | 52
 | Pennsylvania | 821.4270940853368 | 67 | 83
 | Florida | 793.3814105877623 | 67 | 30
 | North Carolina | 666.9240753706189 | 98 | 46
 | New Jersey | 614.6944819628037 | 21 | 27
 | Massachusetts | 611.2163809290954 | 14 | 56
 | Wisconsin | 563.2109672357537 | 72 | 29
 | Alabama | 541.815359554758 | 67 | 25
 | Louisiana | 541.12863199888 | 64 | 20
 | Georgia | 511.761790684774 | 159 | 36
 | Virginia | 491.8142053249891 | 136 | 40
 | Michigan | 487.8569663581036 | 83 | 36
 | Washington | 465.9488193119547 | 39 | 16
 | Maryland | 432.399270856357 | 23 | 23
 | Indiana | 403.7032272217629 | 92 | 42
 | Arizona | 374.109317530906 | 15 | 5
 | Minnesota | 371.129504765048 | 87 | 25
 | Mississippi | 366.7035803161941 | 82 | 15
 | Connecticut | 358.7975435739108 | 8 | 19
 | West Virginia | 354.9620868710744 | 55 | 17
 | Kentucky | 348.7425247458587 | 120 | 24
 | Missouri | 331.296430914615 | 114 | 15
 | Tennessee | 312.145893646529 | 95 | 34
 | Arkansas | 283.1521335552869 | 75 | 17
 | Colorado | 264.8473793475591 | 64 | 16
 | Oklahoma | 262.4666484496651 | 77 | 20
 | Iowa | 248.8896416118606 | 99 | 29
 | Oregon | 228.1122513673997 | 36 | 18
 | Kansas | 202.4469543453758 | 103 | 20
 | New Mexico | 202.1081708726665 | 33 | 9
 | South Carolina | 197.4019168919547 | 46 | 26
 | Alaska | 171.9302437702147 | 27 | 4
 | Hawaii | 171.8594537298531 | 5 | 5
 | Utah | 146.4173466883235 | 29 | 6
 | Nevada | 146.092768419409 | 17 | 3
 | Nebraska | 131.3181955874834 | 93 | 16
 | Delaware | 117.6701565096356 | 3 | 5
 | Maine | 104.3968447839554 | 16 | 14
 | Rhode Island | 86.43239372222516 | 5 | 8
 | Idaho | 85.67050242156533 | 44 | 9
 | Montana | 77.85876681692753 | 57 | 9
 | New Hampshire | 73.4864229696679 | 10 | 13
 | Wyoming | 66.81075940528135 | 23 | 1
 | Vermont | 65.03012962767303 | 14 | 14
 | North Dakota | 57.69276203594998 | 53 | 8
 | South Dakota | 49.27238827117637 |  | 11
 | Total
Spreadsheet: 4464c009-51cd-40a0-a569-2694ecea8549
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: [NAME] for 2010
Indicator | 2010
Chlorophyll a | 56.771
Aquatic Grasses | 47.43
[NAME] | 95.583
[NAME] | 60
Water Clarity | 9.634
Phytoplankton Index | 23.39
Water Quality Index | 53.996
Biotic Index | 43.60666667
Bay Health Index | 48.80133333
Spreadsheet: 866793d1713713748-auto-filter-rows-to-hide-columns-with-zero-0-value-excel-forum-sample-sheet
Sheet: PO Sheet

PO Date | PO by | Grade | Item | Size | PO Qty | UOM | RM Rate | [NAME] | Total Rate
2024-01-06 00:00:00 | KE | RM-B | Product-B | Size-12 | 100 | [NAME] | 214 | 200 | 414
2024-01-20 00:00:00 | MEC | RM-A | Product-A | Size-7 | 100 | [NAME] | 188 | 85 | 273
2024-02-02 00:00:00 | KE | RM-A | Product-B | Size-14 | 9 | [NAME] | 188 | 120 | 308
2024-02-02 00:00:00 | BE | RM-A | Product-B | Size-25 | 50 | [NAME] | 188 | 105 | 293
2024-02-07 00:00:00 | KE | RM-A | Product-B | Size-31 | 65 | [NAME] | 188 | 90 | 278
2024-02-22 00:00:00 | KE | RM-A | Product-A | Size-6 | 200 | [NAME] | 188 | 80 | 268
2024-02-23 00:00:00 | KE | RM-A | Product-B | Size-16 | 35 | [NAME] | 188 | 165 | 353
2024-03-08 00:00:00 | BE | RM-A | Product-B | Size-21 | 50 | [NAME] | 188 | 110 | 298
2024-03-15 00:00:00 | MEC | RM-A | Product-B | Size-15 | 25 | [NAME] | 188 | 120 | 308
2024-03-19 00:00:00 | MEC | RM-A | Product-A | Size-1 | 50 | [NAME] | 188 | 90 | 278
2024-03-19 00:00:00 | MEC | RM-A | Product-B | Size-20 | 50 | [NAME] | 188 | 110 | 298
2024-03-19 00:00:00 | BE | RM-A | Product-B | Size-26 | 100 | [NAME] | 188 | 105 | 293
2024-03-19 00:00:00 | BE | RM-A | Product-A | Size-3 | 100 | [NAME] | 188 | 80 | 268
2024-03-19 00:00:00 | BE | RM-A | Product-B | Size-33 | 50 | [NAME] | 188 | 90 | 278
2024-03-19 00:00:00 | MEC | RM-A | Product-A | Size-4 | 100 | [NAME] | 188 | 80 | 268
2024-03-21 00:00:00 | BE | RM-A | Product-A | Size-5 | 15 | [NAME] | 188 | 80 | 268
2024-03-28 00:00:00 | MEC | RM-A | Product-A | Size-11 | 200 | [NAME] | 188 | 70 | 258
2024-03-28 00:00:00 | KE | RM-A | Product-B | Size-13 | 200 | [NAME] | 188 | 120 | 308
2024-03-28 00:00:00 | KE | RM-A | Product-B | Size-19 | 200 | [NAME] | 188 | 110 | 298
2024-03-28 00:00:00 | KE | RM-A | Product-B | Size-27 | 100 | [NAME] | 188 | 110 | 298
2024-03-28 00:00:00 | KE | RM-A | Product-B | Size-29 | 100 | [NAME] | 188 | 100 | 288
2024-03-28 00:00:00 | KE | RM-A | Product-B | Size-30 | 400 | [NAME] | 188 | 80 | 268
2024-03-28 00:00:00 | KE | RM-A | Product-B | Size-32 | 500 | [NAME] | 188 | 75 | 263
2024-03-28 00:00:00 | KE | RM-A | Product-B | Size-34 | 100 | [NAME] | 188 | 150 | 338
2024-04-01 00:00:00 | KE | RM-A | Product-A | Size-8 | 30 | [NAME] | 188 | 80 | 268
2024-04-02 00:00:00 | BE | RM-A | Product-B | Size-24 | 150 | [NAME] | 188 | 105 | 293
2024-04-03 00:00:00 | KE | RM-B | Product-A | Size-10 | 20 | [NAME] | 214 | 80 | 294
2024-04-03 00:00:00 | KE | RM-A | Product-B | Size-18 | 15 | [NAME] | 188 | 110 | 298
2024-04-13 00:00:00 | MEC | RM-A | Product-B | Size-28 | 200 | [NAME] | 188 | 95 | 283
2024-04-16 00:00:00 | MEC | RM-A | Product-B | Size-23 | 15 | [NAME] | 188 | 105 | 293
2024-04-16 00:00:00 | KE | RM-B | Product-A | [NAME] | 500 | [NAME] | 208 | 90 | 298
2024-04-18 00:00:00 | MEC | RM-A | Product-A | Size-2 | 30 | [NAME] | 188 | 90 | 278
2024-04-21 00:00:00 | MEC | RM-A | Product-B | Size-17 | 15 | [NAME] | 188 | 110 | 298
2024-04-21 00:00:00 | MEC | RM-A | Product-B | Size-22 | 25 | [NAME] | 188 | 110 | 298
Spreadsheet: 169849d1343074502-draw-out-listings-in-table-1-based-on-specific-criteria-draw-out-info-based-on-category-selection
Sheet: Scenario #1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product #1 | Product #2 | Product #3 | Product #4 | Product #5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | C | C
 |  | Product ID |  | Product #1 |  | Product #2 |  | Supplier |  | Product #3 |  | Product #4 | Product #5 |  |  |  | Cost |  |  | Product ID | Product #1 | Product #2 | Product #3 | Product #4 | Product #5 | Supplier | Cost |  |  | [NAME] to extract [NAME] values
 |  | ABCCC |  | A |  | B |  | Company - X |  | C |  | C | C |  |  |  | 10 |  |  | ABCCC | A | B | C | C | C | Company - X | 10 |  |  | ABCCC
 |  | ABCCD |  | A |  | B |  | Company - X |  | C |  | C | D |  |  |  | 20 |  |  | ABCCC | A | B | C | C | C | Company - Y | 30 |  |  | ABCCD
 |  | ABCCE |  | A |  | B |  | Company - X |  | C |  | C | E |  |  |  | 30 |  |  | ABCCC |  |  |  |  |  |  |  |  |  | ABCCE
 |  | ABCCC |  | A |  | B |  | Company - Y |  | C |  | C | C |  |  |  | 30 |  |  | ABCCC
 |  | ABCCD |  | A |  | B |  | Company - Y |  | C |  | C | D |  |  |  | 20 |  |  | ABCCC
 |  | ABCCE |  | A |  | B |  | Company - Y |  | C |  | C | E |  |  |  | 10 |  |  | ABCCC
Spreadsheet: 631589d1562738187-distance-between-coordinates-shown-in-a-sorted-list-pq-distances-aligw
Sheet: Data

Location ID | Coordinate X | Coordinate Y | Helper
PG343 | 646860 | 248249
PL122 | 646860 | 248249
[NAME] | 647150 | 249980
KO420 | 665069 | 259111
OL942 | 656550 | 256150
PY492 | 643443 | 237911
PT940 | 643443 | 237911
HY675 | 655820 | 257720
[NAME] | 656260 | 249240
KH387 | 648322 | 246675
UB482 | 655642 | 247923
HF029 | 653510 | 246900
RH392 | 653510 | 246900
LN392 | 671310 | 243990
ES492 | 650560 | 236088
NJ111 | 656622 | 232628
LK392 | 656622 | 232628
KL329 | 635070 | 236500
GF329 | 635070 | 236500
DF392 | 633251 | 239845
DR029 | 638611 | 263271
SD932 | 637023 | 261981
WE942 | 637023 | 261981
DE902 | 668849 | 245006
[NAME] | 665580 | 258800
RH992 | 665580 | 258800
LR012 | 645850 | 249150
[NAME] | 665470 | 258450
OR654 | 668855 | 245017
ZH257 ??
Spreadsheet: 99137d1297870374-picking-up-numbers-if-certain-criteria-is-met-forum-sample-19c
Sheet: NUM SORT

 | 0 |  |  | 0
TOTAL | NUM | ACTIVITY
0 | 000 | 4 |  | 070
 |  |  |  | 061
1 | 010 | 4 |  | 052
 |  |  |  | 304
2 | 002 | 7 |  | 080
2 | 011 | 4 |  | 017
 |  |  |  | 260
3 | 300 | 2 |  | 053
3 | 201 | 4 |  | 440
 |  |  |  | 090
4 | 400 | 5 |  | 018
4 | 103 | 10 |  | 207
4 | 202 | 7 |  | 603
 |  |  |  | 054
5 | 005 | 0 |  | 190
5 | 041 | 4 |  | 820
5 | 302 | 4 |  | 703
 |  |  |  | 640
6 | 600 | 7 |  | 055
6 | 051 | 1 |  | 092
6 | 420 | 5 |  | 083
6 | 033 | 6 |  | 704
 |  |  |  | 605
7 | 070 | 4 |  | 039
7 | 061 | 8 |  | 480
7 | 052 | 9 |  | 057
7 | 304 | 7 |  | 409
 |  |  |  | 580
8 | 080 | 5 |  | 706
8 | 017 | 9 |  | 950
8 | 260 | 12 |  | 086
8 | 053 | 7 |  | 077
8 | 440 | 4 |  | 609
 |  |  |  | 708
9 | 090 | 3 |  | 709
9 | 018 | 4 |  | 808
9 | 207 | 10 |  | 809
9 | 603 | 10 |  | 990
9 | 054 | 11
10 | 190 | 8
10 | 820 | 12
10 | 703 | 7
10 | 640 | 9
10 | 055 | 4
11 | 092 | 7
11 | 083 | 11
11 | 704 | 5
11 | 605 | 10
12 | 039 | 7
12 | 480 | 12
12 | 057 | 8
12 | 066 | 0
13 | 409 | 6
13 | 580 | 8
13 | 706 | 7
14 | 950 | 9
14 | 086 | 9
14 | 077 | 5
15 | 609 | 7
15 | 708 | 4
16 | 709 | 10
16 | 808 | 7
17 | 809 | 12
18 | 990 | 6
Spreadsheet: 138224d1327577497-help-with-extracting-data-from-table-sample
Sheet: table

Hide Row
 |  | data 1 | data 2 | data 3
 | 1 | text 1 | 2012-01-01 00:00:00 | 12
 | 2 | text 2 | 2012-01-01 00:00:00 | 14
 | 3 | text 3 | 2012-01-03 00:00:00 | 12
 | 4 | text 4 | 2012-01-20 00:00:00 | 13
 | 2 | text 5 | 2012-02-03 00:00:00 | 16
 | 4 | text 6 | 2012-02-05 00:00:00 | 28
 | 3 | text 7 | 2012-02-16 00:00:00 | 10
 | 1 | text 8 | 2012-02-16 00:00:00 | 2
 | 1 | text 9 | 2012-03-03 00:00:00 | 25
 | 5 | text 10 | 2012-03-10 00:00:00 | 22
 | 6 | text 11 | 2012-03-15 00:00:00 | 10
 | 5 | text 12 | 2012-03-16 00:00:00 | 13
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Dartmouth, NS

Amherst, NS | 118
[NAME], NS | 119
Antigonish, NS | 128
Atholville, NB | 349
[NAME], NS | 158
[NAME], NS | 160
Bathurst, NB | 280
Berwick, NS | 73
[NAME], NS | 55
Bridgetown, NS | 105
Bridgewater, NS | 69
Canso, NS | 195
Cape Tormentine, NB | 154
Caraquet, NB | 305
Charlesville, NS | 175
Charlottetown, PE | 197
Chatham, NB | 232
[NAME], NS | 168
[NAME], NB | 332
Debert, NS | 62
Digby, NS | 138
East River, NS | 41
Edmundston, NB | 431
Elmsdale, NS | 23
Florenceville, NB | 349
Fredericton, NB | 267
[NAME], NB | 392
Greenwood, NS | 87
Halfway River, NS | 127
Hantsport, NS | 44
Hartland, NB | 340
Kemptown, NS | 70
Kentville, NS | 64
Lakeside, NS | 13
Lameque, NB | 311
Liverpool, NS | 96
Lockeport, NS | 132
Lower West Pubnico, NS | 176
Lunenburg, NS | 66
Meteghan, NS | 173
Middleton, NS | 91
Mill Village, NS | 88
[NAME], NB | 162
Montague, PE | 226
Mulgrave, NS | 162
[NAME], PE | 242
Nackawic, NB | 301
New Germany, NS | 82
New Glasgow, NS | 92
New Minas, NS | 59
North Sydney, NS | 248
[NAME], NB | 256
Oxford, NS | 98
Parrsboro, NS | 110
Port Bickerton, NS | 175
Port Hawkesbury, NS | 163
Pubnico, NS | 171
Pugwash, NS | 103
Robichaud, NB | 169
Sackville, NB | 128
[NAME], NB | 250
Saulnierville, NS | 168
Scoudouc, NB | 159
Shag Harbour, NS | 167
[NAME], NB | 166
Shelburne, NS | 136
Shippagan, NB | 305
[NAME], NS | 32
Springhill, NS | 107
Stellarton, NS | 93
Summerside, PE | 181
Sussex, NB | 206
Sydport-Term, NS | 259
Tracadie, NB | 283
Truro, NS | 54
Tusket, NS | 193
Valley Station, NS | 62
Waterville, NS | 69
Wedgeport, NS | 207
Westport, NS | 181
Weymouth, NS | 156
Whycocomagh, NS | 187
Windsor, NS | 36
Woods Harbour, NS | 171
Woodstock, NB | 325
Yarmouth, NS | 199
Spreadsheet: john_arnold__15183__~0035224
Sheet: Sheet1

Asian Option Indicative Quotes
As of:
- Call option on the average gas price from Feb through Aug each year (gas daily daily)
- [NAME] based on 180,000 mmbtu's/inch on 17.5 inches (42.5 minus 25) |  |  |  |  |  |  |  |  |  |  | total mmbtu's/year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas Premium | Gas = rainfallStrike
 | 2001 |  |  |  | 2002 |  |  |  | 2003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.22 | 5.3
Strike | $/mmbtu |  |  | Strike | $/mmbtu |  |  | Strike | $/mmbtu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.19 | 4.675
5.375 | 0.32 |  |  | 4.375 | 0.355 |  |  | 4.275 | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.16 | 4.2
5.39375 |  |  |  | 4.39375 |  |  |  | 4.29375
5.4125 |  |  |  | 4.4125 |  |  |  | 4.3125
5.43125 |  |  |  | 4.43125 |  |  |  | 4.33125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2547501152745164 | 5.3
5.45 | 0.305 |  |  | 4.45 | 0.34 |  |  | 4.35 | 0.235 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2593541578472541 | 4.6
5.46875 |  |  |  | 4.46875 |  |  |  | 4.36875 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2374725186402585 | 4.125
5.4875 |  |  |  | 4.4875 |  |  |  | 4.3875
5.50625 |  |  |  | 4.50625 |  |  |  | 4.40625
5.525 | 0.29 |  |  | 4.525 | 0.325 |  |  | 4.425 | 0.225
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Griffith | Difference
Spreadsheet: 699106d1602408335-complex-depreciation-formula-wdv-and-slm-depreciation-query
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | DD-MM-YYYY | Accumulation Date | Current Date
 |  |  |  |  |  |  |  |  |  |  |  | 2019-03-31 00:00:00 | 2020-03-31 00:00:00
Category | Date of Purchase | Cost of  Purchase | Salvage  Value | Useful Life of Asset (Years) | End Date of Asset | Method | Rate | Date of Sale | Sale  Value | Gain/(Loss)  on sale of assets | Date till Cumilation has been Done | Cumulative  Depreciation Opening Balance if any
Vehicles | 2018-01-01 00:00:00 | 100000 | 5000 | 3 |  | [NAME]
Vehicles | 2018-01-01 00:00:00 | 100000 | 5000 | 3 |  | WDV
 |  |  |  |  |  |  |  |  |  |  | Cumulative
 |  |  |  |  |  |  | WDV | 100000 |  | Year-1
 |  |  |  |  |  |  | WDV |  |  | Year-2 |  | Incorrect Value in Formula Above
 |  |  |  |  |  |  | WDV |  |  | Year-3
 |  |  |  |  |  | [NAME] | WDV |  |  | Year-4
 |  |  |  |  |  |  | [NAME] | 100000 |  | Year-1
 |  |  |  |  |  |  | [NAME] | 100000 |  | Year-2
 |  |  |  |  |  |  | [NAME] | 100000 |  | Year-3
 |  |  |  |  |  | [NAME] | [NAME] | 100000 |  | Year-4
Spreadsheet: 741071d1626794703-how-to-allocate-costs-to-fiscal-periods-that-dont-correspond-with-end-of-months-example
Sheet: Sheet1

Contract Amount | Start Date | End Date | # of Days | DailyAmt | Before Period 1 | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6 | Period 7 | Period 8 | Period 9 | Period 10 | Period 11 | Period 12 | Period 13 | After Period 13
91651.4 | 04/22/2021 | 05/13/2021 | 22 | 4165.972727272727 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27846 | 04/23/2021 | 05/13/2021 | 21 | 1326 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
136555.18 | 04/29/2021 | 05/13/2021 | 15 | 9103.678666666667 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22394.47 | 05/06/2021 | 05/13/2021 | 8 | 2799.30875 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10600 | 05/07/2021 | 05/13/2021 | 7 | 1514.285714285714 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Period 1 | 2021-01-03 00:00:00 | 2021-01-30 00:00:00
Period 2 | 2021-01-31 00:00:00 | 2021-02-27 00:00:00
Period 3 | 2021-02-28 00:00:00 | 2021-03-27 00:00:00
Period 4 | 2021-03-28 00:00:00 | 2021-04-24 00:00:00
Period 5 | 2021-04-25 00:00:00 | 2021-05-22 00:00:00
Period 6 | 2021-05-23 00:00:00 | 2021-06-19 00:00:00
Period 7 | 2021-06-20 00:00:00 | 2021-07-17 00:00:00
Period 8 | 2021-07-18 00:00:00 | 2021-08-14 00:00:00
Period 9 | 2021-08-15 00:00:00 | 2021-09-11 00:00:00
Period 10 | 2021-09-12 00:00:00 | 2021-10-09 00:00:00
Period 11 | 2021-10-10 00:00:00 | 2021-11-06 00:00:00
Period 12 | 2021-11-07 00:00:00 | 2021-12-04 00:00:00
Period 13 | 2021-12-05 00:00:00 | 2022-01-01 00:00:00
Spreadsheet: 720378d1614127309-how-to-assign-a-number-for-item-tracking-flight-weekday
Sheet: Data

Flight: | 10
Day: | Weekday
 | Flight # | Start | End | Duration |  |  |  | Weekday |  |  | Saturday |  |  | Sunday
 |  | 03:50:00 | 10:22:00 |  |  |  |  | 0:00:00 | 1 |  | 00:00:00 | 5 |  | 00:00:00 | 7
 |  | 04:20:00 | 10:52:00 |  |  |  |  | 0:00:00 | 2 |  | 12:00:00 | 6 |  | 12:00:00 | 8
 |  | 04:50:00 | 13:42:00 |  |  |  |  | 12:00:00 | 3 |  | Extra | 9 |  | Extra | 9
 |  | 05:05:00 | 12:02:00 |  |  |  |  | 12:00:00 | 4
 |  | 05:20:00 | 13:52:00
 |  | 05:35:00 | 14:09:00
 |  | 05:50:00 | 12:22:00
 |  | 06:10:00 | 15:26:00
 |  | 06:20:00 | 15:05:00
 |  | 06:40:00 | 15:47:00
 |  | 07:00:00 | 16:19:00
 |  | 07:40:00 | 16:40:00
 |  | 09:50:00 | 14:51:00
 |  | 10:10:00 | 19:13:00
 |  | 10:40:00 | 19:48:00
 |  | 11:00:00 | 15:33:00
1020 |  | 11:50:00 | 21:02:00
 |  | 12:04:00 | 16:47:00
 |  | 12:11:00 | 19:06:00
 |  | 12:32:00 | 19:27:00
 |  | 12:46:00 | 23:52:00
 |  | 13:14:00 | 1900-01-01 00:07:00
 |  | 13:28:00 | 22:16:00
 |  | 13:35:00 | 18:21:00
 |  | 13:42:00 | 18:35:00
 |  | 13:56:00 | 22:40:00
 |  | 14:38:00 | 1900-01-01 01:02:00
 |  | 14:52:00 | 23:37:00
 |  | 14:59:00 | 21:46:00
 |  | 15:20:00 | 20:02:00
 |  | 15:34:00 | 20:14:00
 |  | 15:55:00 | 1900-01-01 00:22:00
 |  | 16:09:00 | 20:38:00
 |  | 16:30:00 | 19:03:00
1048 |  | 16:37:00 | 23:07:00
 |  | 16:58:00 | 1900-01-01 01:32:00
Spreadsheet: 77172d1277704739-rank-based-on-two-criteria-test
Sheet: Test

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Team A | Runs | Wickets | Overs | Total Overs | [NAME] | Runs/Over | [NAME] |  | Team B | Runs | Wickets | Overs | Total Overs | [NAME] | Runs/Over | [NAME] |  | B F |  | RF | RA |  | B A |  |  | Balls For | Balls Against | Overs For | Overs Against |  | Winner | [NAME] | Draw 1 | Draw 2 |  | C | Team
 | A | 200 |  | 25 | 25 |  |  |  |  | C | 201 |  | 19.1 |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  |  | Group A | Group A | P | W | D | L | Runs F | Overs F | Runs A | Overs A | [NAME] | RR-A | Points | NRR |  | Teams | P | W | D | L | Points | NRR
 | A | 151 |  | 15 | 15 |  |  |  |  | D | 150 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  |  |  | A1 | A |  |  |  |  |  |  |  |  |  |  |  |  |  | A
 | B | 160 |  | 25 | 25 |  |  |  |  | A | 161 |  | 23.5 |  |  |  |  |  |  |  | 160 | 161 |  |  |  | D |  |  |  |  |  |  |  |  |  |  | A2 | C |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 | C | 220 |  | 25 | 25 |  |  |  |  | D | 222 |  | 23.1 |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  |  | A3 | D |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 | C | 191 | 10 | 24.4 | 25 |  |  |  |  | B | 206 |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A4 | B |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 | D | 205 |  | 23 | 25 |  |  |  |  | B | 203 |  | 25
 | A | A
 | B | B
 | C | C
 | D | D
Spreadsheet: 736490d1623679986-not-sure-if-i-need-a-vlookup-or-conditional-formatting-847d001sample
Sheet: Sheet1

IN |  |  | OUT
[NAME] # | Count of Movement type |  | [NAME] # | Count of Movement type
200228248 | 1 |  | 200228248 | 1
200228945 | 2 |  | 200228945 | 4
200230100 | 1 |  | 200230100 | 1
200230263 | 4 |  | 200230263 | 4
200230609 | 24 |  | 200230609 | 24
200230758 | 1 |  | 200230758 | 1
200249315 | 2 |  | 200249315 | 2
200249333 | 1 |  | 200249333 | 1
200249354 | 1 |  | 200249357 | 3
200249357 | 3 |  | 200249376 | 2
200249376 | 2 |  | 200249379 | 3
200249379 | 3 |  | 200249569 | 9
200249569 | 9
200249570 | 3
Spreadsheet: 838302d1690902144-display-message-if-overdue-example-days-calculation-tms
Sheet: Sheet1

Req. | Added to Q | º | Date [NAME] | Day | [NAME] Received | Day | Chaser (1) Needed? | Date [NAME] | Day | Chaser (2) Needed? | Date Call Made | Day
2023-04-27 00:00:00 | 2023-05-12 00:00:00 |  | 2023-05-12 00:00:00 |  | 2023-05-15 00:00:00 |  |  |  |  |  |  |  |  | Network Days | Sumple sub
2023-04-21 00:00:00 | 2023-05-12 00:00:00 |  | 2023-05-12 00:00:00
2023-04-24 00:00:00 | 2023-05-12 00:00:00 |  | 2023-05-12 00:00:00 |  | 2023-05-31 00:00:00
2023-05-11 00:00:00 | 2023-05-12 00:00:00 |  | 2023-05-15 00:00:00 |  | 2023-05-16 00:00:00
2023-04-25 00:00:00 | 2023-04-25 00:00:00 |  | 2023-05-15 00:00:00 |  | 2023-05-15 00:00:00
2023-04-25 00:00:00 | 2023-05-03 00:00:00 |  | 2023-05-15 00:00:00 |  | 2023-05-17 00:00:00
2023-04-28 00:00:00 | 2023-04-28 00:00:00 |  | 2023-05-15 00:00:00 |  | 2023-05-15 00:00:00
Spreadsheet: 783438d1654811536-match-with-lookup-test4
Sheet: Data

 |  |  |  |  | 2007 |  |  |  | 2008 |  |  |  | 2009
 |  |  |  |  | Adjusted of usage change | Adjusted for Inflation | Percent of Total 2007 |  | Adjusted of usage change | Adjusted for Inflation | Percent of Total 2007 |  | Adjusted of usage change | Adjusted for Inflation | Percent of Total 2007
 |  |  |  |  | 2656481712.5 | 2786775815.541668 | 0.3152783368665035 |  | 2656481712.5 | 2786775815.541668 | 0.3152783368665035 |  | 2656481712.5 | 2786775815.541668 | 0.3152783368665035
 |  |  |  |  |  | 2408300697.6 | 0.2724600358519277 |  |  | 2408300697.6 | 0.2724600358519277 |  |  | 2408300697.6 | 0.2724600358519277
 |  |  |  |  |  | 1803970560 | 0.2040899144958261 |  |  | 1803970560 | 0.2040899144958261 |  |  | 1803970560 | 0.2040899144958261
 |  |  |  |  |  | 1082382336 | 0.1224539486974956 |  |  | 1082382336 | 0.1224539486974956 |  |  | 1082382336 | 0.1224539486974956
 |  |  |  |  |  | 496091904 | 0.05612472648635217 |  |  | 496091904 | 0.05612472648635217 |  |  | 496091904 | 0.05612472648635217
 |  |  |  |  |  | 261575731.2 | 0.02959303760189478 |  |  | 261575731.2 | 0.02959303760189478 |  |  | 261575731.2 | 0.02959303760189478
 | Total Expenses |  |  |  |  | 8839097044.34167 |  |  |  | 100000000 |  |  |  | 11000055156
 |  |  |  |  |  | 0.003479277777778052 |  |  |  | 0.003479277777778052 |  |  |  | 0.003479277777778052
 |  |  |  |  | 33 |  |  |  | 33 |  |  |  | 33
 |  |  |  |  | -0.08333333333333333 |  |  |  | -0.08333333333333333 |  |  |  | -0.08333333333333333
 |  |  |  |  | 2.937333333333334 |  |  |  | 2.937333333333334 |  |  |  | 2.937333333333334
 |  |  |  |  | 0.04904761904761936 |  |  |  | 0.04904761904761936 |  |  |  | 0.04904761904761936
 |  |  |  |  | 0.024 |  |  |  | 0.024 |  |  |  | 0.024