tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713884d1610992826-date-falls-between-a-range-and-equals-to-another-value-until-match-book21
Sheet: Sheet1

table 1 |  |  |  |  |  |  | table 2
Code | Valid From | Valid To | AMOUNT |  |  |  | Region | Code | Billing Dt | AMOUNT
T35 | 2020-03-20 00:00:00 | 2020-04-16 00:00:00 | 65 |  |  |  | 22 | T36 | 2020-04-24 00:00:00 | ?
T35 | 2020-04-17 00:00:00 | 2020-04-26 00:00:00 | 10 |  |  |  | 22 | T36 | 2020-04-30 00:00:00 | ?
T36 | 2020-05-20 00:00:00 | 2020-04-25 00:00:00 | 10 |  |  |  | 22 | T36 | 2020-05-24 00:00:00 | ?
T37 | 2020-03-20 00:00:00 | 2020-04-16 00:00:00 | 65 |  |  |  | 22 | T37 | 2020-04-24 00:00:00 | ?
T38 | 2020-04-17 00:00:00 | 2020-04-25 00:00:00 | 10 |  |  |  | 22 | T37 | 2020-04-30 00:00:00 | ?
T39 | 2020-05-17 00:00:00 | 2020-04-25 00:00:00 | 10 |  |  |  | 22 | T37 | 2020-05-24 00:00:00 | ?
T40 | 2020-03-20 00:00:00 | 2020-04-16 00:00:00 | 65 |  |  |  | 22 | T38 | 2020-04-24 00:00:00 | ?
T41 | 2020-04-17 00:00:00 | 2020-04-25 00:00:00 | 10 |  |  |  | 22 | T38 | 2020-04-30 00:00:00 | ?
T42 | 2020-03-20 00:00:00 | 2020-04-16 00:00:00 | 65 |  |  |  | 22 | T38 | 2020-05-24 00:00:00 | ?
T43 | 2020-04-17 00:00:00 | 2020-04-25 00:00:00 | 10
T44 | 2020-05-20 00:00:00 | 2020-04-16 00:00:00 | 65 |  |  |  | COUNTY CODE SHOULD BE EQUEL AND BILLING DATE FALLS  OR BETWEEN DATES
Spreadsheet: 330801d1404856185-summing-tiles-and-summing-tile-decors-07-07-tile-sum-decor-sum_ron_v1a
Sheet: Sheet1

 | REF | [NAME] | CAT | 1 | 2 | 3 | 4 | 5 | 6
 | 100.004.85 |  | TILE |  |  | 17 | 0.9 | -0.9
 | 100.004.86 |  | TILE | 20 | 5 |  | 19.9 | -0.9 | 15
 | 100.004.87 |  | TILE | 28.46 |  |  | 11.9 | -0.9 | 67
 | 100.004.88 |  | DECOR | 16 | 1 | -1 | 19 |  | 9
 | 100.004.89 |  | TILE | 55 | 121.18 | 199.46 | 16 | -3 | 211
 | 100.005.02 |  | TILE | 19 | 41 | 22 | 3 | 27
 | 100.005.03 |  | TILE | 8 | 46 | 2.13 | 139 | 14 | 1
 | 100.005.04 |  | DECOR |  | 40
 | 100.005.05 |  | DECOR |  |  | 59
 | 100.005.06 |  | DECOR | 1 | 103
 |  |  | TILE | 130.46 | 213.18 | 240.59 | 190.7 | 35.3 | 294
 | Notes: |  | DECOR | 17 | 144 | 58 | 19 | 0 | 9
 | [NAME] on e12 to drag right to sum [NAME] only not decors
 | [NAME] on e13 to drag right to sum DECOR only not tiles
Spreadsheet: 54543d1254521279-help-with-formula-vlookup-relating-cells-related-products
Sheet: Sheet1

02222-01 | 02222-02, 02222-03, 02222-04, , , , , , , , , , , | 02222-02 | 02222-03 | 02222-04 |  |  |  |  |  |  |  |  |  |  |  | 02222
02222-02 | 02222-01, 02222-03, 02222-04, , , , , , , , , , , | 02222-01 | 02222-03 | 02222-04 |  |  |  |  |  |  |  |  |  |  |  | 02222
02222-03 | 02222-01, 02222-02, 02222-04, , , , , , , , , , , | 02222-01 | 02222-02 | 02222-04 |  |  |  |  |  |  |  |  |  |  |  | 02222
02222-04 | 02222-01, 02222-02, 02222-03, , , , , , , , , , , | 02222-01 | 02222-02 | 02222-03 |  |  |  |  |  |  |  |  |  |  |  | 02222
02223-01 | 02223-02, 02223-03, , , , , , , , , , , , | 02223-02 | 02223-03 |  |  |  |  |  |  |  |  |  |  |  |  | 02223
02223-02 | 02223-01, 02223-03, , , , , , , , , , , , | 02223-01 | 02223-03 |  |  |  |  |  |  |  |  |  |  |  |  | 02223
02223-03 | 02223-01, 02223-02, , , , , , , , , , , , | 02223-01 | 02223-02 |  |  |  |  |  |  |  |  |  |  |  |  | 02223
02224-01 | 02224-02, , , , , , , , , , , , , | 02224-02 |  |  |  |  |  |  |  |  |  |  |  |  |  | 02224
02224-02 | 02224-01, , , , , , , , , , , , , | 02224-01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 02224
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 151521d1334950642-what-formula-can-i-use-to-count-number-of-items-by-date-and-another-criterion-example
Sheet: Sheet1

 | January | February
A
B
C
D
ITEM | DATE
A | 2012-01-27 01:30:00
D | 2012-02-01 05:31:00
D | 2012-01-02 21:19:00
C | 2012-01-14 04:00:00
D | 2012-02-20 03:12:00
B | 2012-01-11 15:28:00
B | 2012-01-19 06:50:00
A | 2012-02-22 18:30:00
Spreadsheet: 793346d1661424796-rank-a-table-in-finishing-position-ullesthorpe-sat-texas-aligw
Sheet:  Master

 |  | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
1 | PLAYER | PAR
1 |  | S/I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROSS | SCORE | POST
1 | [NAME], [NAME] [NAME] | 16.2 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
1 | [NAME], [NAME] [NAME] | 14.4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
0 | [NAME], [NAME] [NAME] | 11.7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
0 | [NAME], [NAME] | 10.8 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
1 | [NAME], Tony Grout & Stuart Wills | 11.2 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
1 | [NAME], Kevin Leech & Scott Loom | 9.8 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
1 | [NAME], Daniel Moss & Richard Smith | 8.7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
1 | [NAME], [NAME] [NAME] | 11.3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
0 | [NAME], Glenn Lewis & Andy McGillivray | 9.9 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Spreadsheet: 217044d1361975817-formula-for-a-continuously-changing-array-barcode-testing
Sheet: Sheet1

1 |  | 123480
 |  | 123481
 |  | 123482
 |  | 123483
 |  | 123483
 |  | 123484
 |  | 123485
 |  | 123503
 |  | 123487
 |  | 123488
 |  | 123488
 |  | 123489
 |  | 123490
 |  | 123490
 |  | 123491
 |  | 123492
 |  | 123498
 |  | 123499
 |  | 123499
 |  | 123502
 |  | 123503
 |  | 123480
Spreadsheet: 884915d1734274543-searching-values-within-a-numeric-range-matching-criteria-searching-values-within-a-numeric-range-matching-criteria-1-
Sheet: List1

73.22 | 73.24 | 73.26 | 73.28 | 73.3 | 73.32 | 73.34 | 73.36 | 73.38 | 73.4 | 73.42 | 73.44 | 73.46 | 73.4799999999999 | 73.4999999999999 | 73.5199999999999 | 73.5399999999999 | 73.5599999999999 | 73.5799999999999 | 73.5999999999999
 |  |  |  |  |  |  |  |  | 73.4
 |  |  |  |  |  | 73.34 |  |  |  |  |  | 73.46
 |  |  |  | 73.3 |  |  |  |  | 73.4 |  |  |  |  | 73.4999999999999
Finding the values |  |  |  |  |  | Step 1 | Step 2 |  |  | Step 3 |  |  | Step 4 |  |  | Combined Steps
1 maximally distributed number
2 maximally distributed numbers |  |  |  |  |  |  |  | 2 |  |  | 13 |  |  | 73.46 |  |  | 73.46
3 maximally distributed numbers |  |  |  |  |  |  |  | 2 | 3 |  | 10 | 15 |  | 73.4 | 73.4999999999999 |  | 73.4 | 73.4999999999999
Finding the position in the numeric range
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | 1 | #N/A | #N/A | #N/A | #N/A | #N/A | 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | 1 | #N/A | #N/A | #N/A | #N/A | 2 | #N/A | #N/A | #N/A | #N/A | 3 | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 866143d1713094637-average-total-cost-on-a-tiered-pricing-table-cost-1-
Sheet: Sheet1

Quantity | 13000
Tier | Quantity Range | Cost per Unit | Total Cost
Tier 1 | 1 - 5,999 | 10.5
[NAME] | 6,000 - 7,999 | 10
Tier 3 | 8,000 - 9,999 | 9.5
[NAME] | 10,000 - 12,499 | 9
Tier 5 | 12,500 - 14,999 | 8.5
Tier 6 | 15,000 - 19,999 | 8
Tier 7 | 20,000 or above | 7.5
 |  | Average cost
Spreadsheet: 682765d1592321218-data-validation-with-an-extra-entry-for-all-in-the-list-gl3-1-
Sheet: Invoices

Customer | Factory | Short Code | Invoice No | Inv Date | Qty | Total | Transport | Inv Total | Commission | Terms | Due | Actual Date | Comm Inv No | Comm Inv Date | Comm Paid | Sale Year
A123 | ABC |  | 1 | 2018-01-01 00:00:00 |  |  | 0 |  |  | 30
A123 | ABC |  | 2 | 2019-01-02 00:00:00 |  |  | 0 |  |  | 30
C789 | ABC |  | 3 | 2018-01-03 00:00:00 |  |  | 0 |  |  | 30
C789 | DEF |  | 4 | 2019-01-04 00:00:00 |  |  | 129 |  |  | 30
C789 | ABC |  | 5 | 2020-01-05 00:00:00 |  |  | 45 |  |  | 30
B456 | GHI |  | 6 | 2017-01-06 00:00:00 |  |  | 0 |  |  | 30
B456 | GHI |  | 7 | 2018-01-07 00:00:00 |  |  | 0 |  |  | 30
B456 | ABC |  | 8 | 2019-01-08 00:00:00 |  |  | 0 |  |  | 30
B456 | DEF |  | 9 | 2020-01-09 00:00:00 |  |  | 0 |  |  | 30
Spreadsheet: 111720d1308053228-excel-2007-pivottables-from-spreadsheet-with-multiple-columns-excel-forum-test-sheet
Sheet: Sheet1

Item | Long Descr | Qty On Hand | Ave Cost | Comments | [NAME] | [NAME] | [NAME]
1 | Soccer Ball | 10 | 35 | LOCATED IN HOU | HOU
2 | Football | 5 | 40 | LOCATED IN HOU | HOU
3 | Basketball | 8 | 40 | LOCATED IN DALLAS |  |  | DAL
4 | Baseball | 6 | 5 | LOCATED IN AUSTIN,Dallas |  | AUS | DAL
5 | [NAME] | 4 | 100 | LOCATED IN HOU, Dallas | HOU |  | DAL
6 | Gloves | 5 | 80 | LOCATED IN Austin |  | AUS
7 | Helmets | 0 | 25 | LOCATED IN HOU, Austin, Dallas | HOU | AUS | DAL
8 | Jerseys | 0 | 60 | LOCATED IN HOU, Austin, Dallas | HOU | AUS | DAL
9 | Cleats | 1 | 60 | LOCATED IN HOU, Austin, Dallas | HOU | AUS | DAL
10 | Socks | 25 | 3 | LOCATED IN Dallas |  |  | DAL
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 1022646 | 979632
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 908950 | 983011 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 1143073 | 1115305 |  | 2001-11-03 00:00:00
500293 | 498294 | 607950
500302 |  | 10867
500303 | 24905 | 332238
500305 | 1681419 | 1406635
500307 | 102987 | 68454
500313 |  | 2751
500314
500655 | 3210
500657 |  | 207838
INDEX
2001-10-31 00:00:00 |  |  | -217596.84
2001-11-30 00:00:00
CBS Volume
 |  |  | -93574
Spreadsheet: 859101d1707553932-using-conditional-formatting-with-cut-paste-book1-17-
Sheet: Sheet1

 | EXCEL HELP FORUM EXAMPLE |  |  |  |  |  |  |  |  |  |  |  |  |  | CURRENT FORMATTING ISSUE WHEN CUT/PASTED
 | Title |  |  |  |  |  | Title |  |  |  |  |  |  |  | Title |  |  |  |  |  | Title
 | Sub | Sub | Sub |  |  |  | Sub | Sub | Sub |  |  |  |  |  | Sub | Sub | Sub |  |  |  | Sub | Sub | Sub
 | Category | Category | Category | Category | Category |  | Category | Category | Category | Category | Category |  |  |  | Category | Category | Category | Category | Category |  | Category | Category | Category | Category | Category
 |  | test | test | test | test |  | test | test | test | test | test |  |  |  | test | test | test | test | test |  | test | test | test | test | test
 | test2 | test2 |  |  |  |  | test2 | test2 |  |  |  |  |  |  | test2 | test2 |  |  |  |  | test2 | test2
 | test3 | test3 |  |  |  |  | test3 | test3 |  |  |  |  |  |  |  |  |  |  |  |  | test3 | test3
 | test4 | test4 |  |  |  |  | test4 | test4 |  |  |  |  |  |  | test4 | test4 |  |  |  |  | test4 | test4
 | test5 | test5 |  |  |  |  | test5 | test5 |  |  |  |  |  |  | test5 | test5 |  |  |  |  | test5 | test5
 | 0
 | 0
 | 0
 | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test3 | test3
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test5
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test4 | test4
 | 0
 | 0
 | 0
 | 0
 |  | data val
 |  | test
 |  | test2
 |  | test3
 |  | test4
 |  | test5
Spreadsheet: 10db463c-f3ed-473b-966e-4f6e6252eb7a
Sheet: Sheet1

2013 Hunter Education Income and Expense | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
HEI                                     , Instructor #                     .
Date | Item | Income | Expense | Balance
 | Beginning balance | 0 | 0 | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | TOTAL | 0 | 0 | 0
Spreadsheet: 847027d1698138499-new-invoice-allocation-register-test-invoice-allocation-register
Sheet: JN23-004

PO | PO Description | PO status | PO Value  (ex GST) | 2023-08-31 00:00:00 |  |  |  | PO Balance
 |  |  |  | 1638138
 |  |  |  | 4017
 |  |  |  | APPROVED
3880 | JN23/004 Termination advice (Quote 9/8/2023) | Open | 4825 | 4017
 |  |  | BALANCE/CHECK
Back to Register
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 334710 | 339430 | 67545 | 70147 | 44382 | 44890 | 165424 | 152641
2 | 234782 | 259819 | 87870 | 67797 | 30709 | 34191 | 121870 | 130584
3 | 326583 | 336985 | 74701 | 67075 | 39819 | 31890 | 165343 | 168246
4 | 339550 | 338460 | 42482 | 48418 | 41469 | 31612 | 144642 | 153213
5 | 349246 | 334305 | 50756 | 54026 | 67157 | 54143 | 142121 | 168899
6 | 337262 | 324264 | 36102 | 53490 | 64150 | 53026 | 153231 | 155563
7 | 332993 | 303628 | 42736 | 42944 | 50435 | 50798 | 105619 | 124843
8 | 307104 | 325011 | 63040 | 42549 | 50873 | 50798 | 146689 | 153033
9 | 306848 | 324109 | 64681 | 50949 | 49838 | 50798 | 159074 | 150892
10 | 308723 | 312337 | 67005 | 53977 | 47323 | 51076 | 150287 | 152804
11 | 300617 | 316052 | 72069 | 52123 | 53004 | 51076 | 154997 | 159282
12 | 229737 | 240639 | 61485 | 53645 | 51578 | 51076 | 164079 | 157654
13 | 298122 | 301530 | 52306 | 48956 | 51386 | 50891 | 168284 | 161725
14 | 303241 | 324918 | 70360 | 45341 | 52022 | 50757 | 129217 | 127195
15 | 309412 | 327404 | 60359 | 42184 | 57465 | 50798 | 135971 | 138781
16 | 308877 | 318301 | 62910 | 41422 | 55375 | 50798 | 134046 | 149549
17 | 317284 | 340943 | 62937 | 38620 | 50174 | 50798 | 141836 | 140558
18 | 312528 | 339472 | 62912 | 38326 | 50172 | 48298 | 169625 | 177464
19 | 320085 | 336417 | 10161 | 15730 | 49108 | 50798 | 148519 | 132519
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  |  |  |  |  | -44467
2001-02-19 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: michelle_lokay__26667__Astra
Sheet: March'01 GDAs

 |  | 2001-03-01 00:00:00
 |  | TW/Astra 50,000 MMBtu/d East Capacity Block
 |  | Fee Calculations
 |  | Gas Daily Midpoint |  |  |  |  | Spread to TW
 |  |  |  |  | Adj | TW | Per less Cmdty
 |  |  |  | TW | TW | Cmdty | Cost,  $/mmbtu |  | Delivered Vol, mmbtu |  |  | Calculated Total Theoretical Profit, $ |  |  | Profit Share
 | Day | PGE | SCG | Per | Per | Cst | PGE | SCG | PGE | SCG | Total | PGE | SCG | Total | Astra 70% | TW 30%
 | 1 | 8.15 | 12.955 | 5.19 |  | 0.0246 |  |  | 10000 | 323
 |  | 9.87 | 23.95 | 5.28 |  | 0.0246 |  |  | 2637 | 0
 |  | 9.7 | 27.79 | 5.045 |  | 0.0246 |  |  | 4075 | 0
 |  | 9.7 | 27.79 | 5.045 |  | 0.0246 |  |  | 1542 | 0
 |  | 9.7 | 27.79 | 5.045 |  | 0.0246 |  |  | 26767 | 0
 |  | 9.9 | 31.31 | 5.36 |  | 0.0246 |  |  | 8492 | 11452
 |  | 9.575 | 25.265 | 5.185 |  | 0.0246 |  |  | 9409 | 0
 |  | 9.395 | 14.28 | 5.115 |  | 0.0246 |  |  | 12317 | 0
 |  | 8.905 | 12.825 | 5.135 |  | 0.0246 |  |  | 15963 | 0
 |  | 8.39 | 12.505 | 5 |  | 0.0246 |  |  | 15263 | 0
 |  | 8.39 | 12.505 | 5 |  | 0.0246 |  |  | 12026 | 0
 |  | 8.39 | 12.505 | 5 |  | 0.0246 |  |  | 17210 | 0
 |  | 8.225 | 11.565 | 4.845 |  | 0.0246 |  |  | 12393 | 0
 |  | 8.31 | 10.92 | 5 |  | 0.0246 |  |  | 8008 | 82
 |  | 8.04 | 9.535 | 4.885 |  | 0.0246 |  |  | 0 | 532
 |  | 9.185 | 9.41 | 4.765 |  | 0.0246 |  |  | 0 | 2050
 |  | 8.925 | 9.025 | 4.835 |  | 0.0246 |  |  | 0 | 66
 |  | 8.925 | 9.025 | 4.835 |  | 0.0246 |  |  | 0 | 1299
 |  | 8.925 | 9.025 | 4.835 |  | 0.0246 |  |  | 0 | 1219
 |  | 7.2 | 9.945 | 4.975 |  | 0.0246 |  |  | 0 | 885
 |  | 5.71 | 11.035 | 4.9 |  | 0.0246 |  |  | 0 | 923
 |  | 5.905 | 11.605 | 4.97 |  | 0.0246 |  |  | 0 | 1773
 |  | 5.97 | 10.995 | 4.85 |  | 0.0246 |  |  | 0 | 1323
 |  | 8.145 | 11.13 | 4.97 |  | 0.0246 |  |  | 0 | 2484
 |  | 8.145 | 11.13 | 4.97 |  | 0.0246 |  |  | 0 | 3156
 |  | 8.145 | 11.13 | 4.97 |  | 0.0246 |  |  | 0 | 2286
 |  | 8.715 | 10.25 | 5.02 |  | 0.0246 |  |  | 0 | 1750
 |  | 8.675 | 10.78 | 5.195 |  | 0.0246 |  |  | 0 | 2130
 |  | 9.69 | 13.585 | 5.375 |  | 0.0246 |  |  |  | 2823
 |  | 9.95 | 14.015 | 5.185 |  | 0.0246 |  |  |  | 1729
 |  | 9.95 | 14.25 | 5.115 |  | 0.0246 |  |  |  | 1126
 |  | Commodity Costs |  |  |  |  |  | Reservation Charges |  |  |  |  |  | Summary
 |  | Delivered Volume, mmbtu |  |  |  |  |  | Contracted Vol, mmbtu/d |  |  | 50000 |  |  | TW Profit Share, $
 |  | [NAME], $/mmbtu |  |  | 0.0246 |  |  | Days in month |  |  | 31 |  |  | Reservation Charge, $
 |  | Total [NAME], $ |  |  |  |  |  | Resv Charge, $/mmbtu |  |  | 0.0325 |  |  | Commodity Costs, $
 |  |  |  |  |  |  |  | [NAME], $ |  |  |  |  |  | Total Amt due TW, $
 |  |  | Notes: "Adj TW Per" is the fuel adjusted price = (TW Per) / 0.95
Spreadsheet: 870383d1716908731-modifying-table-to-be-more-dynamic-book2-2-1-
Sheet: lepingud

Number | Name | [NAME] | Üürilepingu kood | Code | Kinnistu aadress | Kinnistu piirkond | Client | Kap.komp | 2024 | 2025 | 2026 | 2027 | 2028 | Rem.komp | 2024 | 2025 | 2026 | 2027 | 2028
5 | Name5 |  |  | SEEMNE200 |  |  | Client1 |  |  | 4000 | 4000 | 4000 | 4000 |  |  | 5000 | 5000 | 5000 | 5000
6 | Name6 |  |  | PURAVIKU4 |  |  | Client2 |  | 4000 | 4000 | 4000 | 4000 | 4000 |  | 5000 | 5000 | 5000 | 5000 | 5000
Spreadsheet: 161546d1339545686-count-based-on-multiple-criteria-challenging-equation-product-workbook
Sheet: Product Calandar

PRODUCT CALANDER
Location | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00
Location 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 0
Location 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Location 3 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Location 4 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Location 5 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Location 6 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Location 7 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Location 8 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Location 9 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Location 10 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 273947d1382971324-comparing-two-columns-of-data-example-1_cbrow236
Sheet: Sheet1

Voucher Code | Value |  | Row Labels | Sum of Val | Posted or Not Posted
BL1/13 | 61.52 |  | "6000067,MK 2013-4" | 206.31
MK3013-1 | 32.76 |  | "6000067,MK2013-1" | 32.76
BL 2/13 | 176.9 |  | "6001429,BL 1/13" | 55.17
BL 3/13 | 477.64 |  | "6001429,BL 11/13" | 109.46
BL 4/13 | 293.39 |  | "6001429,BL 2/13" | 174.26
BL 5/13 | 362.71 |  | "6001429,BL 3/13" | 413.6600000000001
BL 6/13 | 48.51 |  | "6001429,BL 41/12" | 179.05
BLE 8/13 | 388.48 |  | "6001429,BL 42/12" | 10.72
BL 9/13 | 26.72 |  | "6001429,BL 42/13" | 2
BL 11/13 | 111.75 |  | "6001429,BL 42/14" | 6.34
MK 2013-4 | 211.2 |  | "6001429,BL 42/15" | 185
0 | 0 |  | "6001429,BL 42/16" | 10.8
0 | 0
0 | 0
0 | 0
0
0 | 0
0 | 0
Spreadsheet: 92096d1291755439-display-only-blank-cells-test-2
Sheet: Sheet1

Ticket # | Duplicate | Contact Made | When
1111112 | Yes
1111113 | No | Yes | 2010-12-06 00:00:00
1111114 | No
1111115 | Yes
1111116 | No
1111117 | No | Yes | 2010-12-01 00:00:00
111118 | No | Yes | 2010-12-03 00:00:00
1111119 | Yes
1111112 | Yes
1111113 | No | Yes | 2010-12-06 00:00:00
1111114 | No
1111115 | Yes
1111116 | No
1111117 | No | Yes | 2010-12-01 00:00:00
111118 | No | Yes | 2010-12-03 00:00:00
1111119 | Yes
1111112 | Yes
1111113 | No | Yes | 2010-12-06 00:00:00
1111114 | No
1111115 | Yes
1111116 | No
1111117 | No | Yes | 2010-12-01 00:00:00
111118 | No | Yes | 2010-12-03 00:00:00
1111119 | Yes
Spreadsheet: 736546d1623723258-solved-find-most-recent-valid-cell-and-return-its-value-example
Sheet: Grades 3 & 4

Date | Unit No. | No. Lessons | Unit Title | Pages | Notes
2021-04-22 00:00:00 |  |  | Introduction
2021-04-29 00:00:00 |  |  |  |  | Cancelled
2021-05-06 00:00:00 |  |  | Hello! | 2-3
2021-05-13 00:00:00
2021-05-20 00:00:00 |  |  | Hello! | 4-5
2021-05-27 00:00:00 |  |  | How are you? | 6-7
2021-06-03 00:00:00 |  |  | How are you? | 8-9
2021-06-10 00:00:00 |  |  | How many? | 10-11
2021-06-17 00:00:00 |  |  | How many? | 11-12
2021-06-24 00:00:00 |  |  | How many? | 12-13
2021-07-01 00:00:00 |  |  | How many? | 14-15
2021-07-08 00:00:00 |  |  | I like blue. | 15-16
2021-07-15 00:00:00 |  |  | I like blue. | 16-17
2021-09-02 00:00:00 |  |  | I like blue. | 18-19
2021-09-09 00:00:00 |  |  | I like blue. | 18-19
2021-09-16 00:00:00 |  |  | I like blue. | 20-21
2021-09-23 00:00:00 |  |  |  |  | Cancelled
2021-09-30 00:00:00 |  |  | What do you like? | 20-21
2021-10-07 00:00:00 |  |  | What do you like? | 22-23
Spreadsheet: 647255d1572350945-printing-specific-names-from-a-list-based-on-availability-yes-no-rugby-spreadsheet
Sheet: Details - Availability

 | Name | Preferred Position | Preferred Number & Alternatives |  |  | Injuries | Availability
 |  |  |  |  |  |  | 30th October | 6th November | 13th November | 27th November | 4th December | 11th December | 22nd January | 29th January | 12th February | 26th February
 |  |  |  |  |  |  | [NAME] 3 | UCL Men's 2 | Imperial Men's 4 | King's College Men's 3 | Reading Men's 4 | Reading Men's 4 | [NAME] 3 | [NAME] 3 | Imperial Men's 4 | King's College Men's 3
 | [NAME] | Prop | 1 | 3 |  | Old Back Injury | Yes
 | [NAME] | Prop or Blindside Flanker | 1 | 3 | 6 | N/A | No
 | [NAME] | Second Row | 4 | 5 |  | N/A | Yes
 | [NAME] | Second Row | 4 | 5 |  | N/A | Yes
 | [NAME] | Flanker | 6 | 7 |  | N/A | No
 | [NAME] | Scrum Half | 9 | 10 |  | Cracked Ribs | Yes
 | [NAME] | Scrum Half | 9 |  |  | Recovering Knee Injury | No
 | [NAME] | Scrum Half | 9
 | Te-Kori Moore | Fly Half (Anywhere in Back Row) | 10 | 12 | 13
 | [NAME] | Winger | 11 | 14 |  |  | Yes
 | Dotun Ademola | Winger | 11 | 14
 | [NAME] | Winger | 11 | 14 |  | N/A | Yes
 | [NAME] | Wing or Full Back | 11 | 14 | 15 | N/A | Yes
 | [NAME] | Centres (Anywhere in Back Row) | 12 | 13 |  | N/A | Yes
 | [NAME] | Centres (Anywhere in Back Row) | 12 | 13 |  | Current Knee Injury | Yes
 | [NAME] (Puppit) | Centres | 12 | 13 |  | Old Ankle Injury | Yes
 | [NAME] | Centres (Anywhere in Back Row) | 12 | 13 |  |  | Yes
 | [NAME] | Centres | 13 | 12 |  | N/A | Yes
 | [NAME] | Full Back | 15
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Tyler Aveline
 | [NAME]
 | [NAME]
 | Amilca Roomaney
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 109634d1306434540-similar-function-to-row-for-multiple-row-numbers-in-the-same-cell-without-vba-spreadsheet-sample
Sheet: Sheet1

Preliminary Planning | Predecessor Row # | Deliverable Description
 |  | Preliminary Planning deliverable 1
Predecessor  is row 2  ----> |  | Preliminary Planning deliverable 2
 |  | Preliminary Planning deliverable 3
 |  | Preliminary Planning deliverable 4
 |  | Preliminary Planning deliverable 5
Network & Data Transport Exploration
 |  | Network & Data Transport Exploration Deliverable 1
 |  | Network & Data Transport Exploration Deliverable 2
 | 9,10 | Network & Data Transport Exploration Deliverable 3
Project Kickoff Planning Meeting | 3,9
 |  | Project Kickoff Planning Meeting Deliverable 1
 |  | Project Kickoff Planning Meeting Deliverable 2
 |  | Project Kickoff Planning Meeting Deliverable 3
 |  | Project Kickoff Planning Meeting Deliverable 4
Predecessors are in rows 14,5,16,17 ---> | 14,15,16,17 | Project Kickoff Planning Meeting Deliverable 5
 |  | Project Kickoff Planning Meeting Deliverable 6
 |  | Project Kickoff Planning Meeting Deliverable 7
 | 19,20 | Project Kickoff Planning Meeting Deliverable 8
 | 21 | Project Kickoff Planning Meeting Deliverable 9
 | 21 | Project Kickoff Planning Meeting Deliverable 10
 |  | Project Kickoff Planning Meeting Deliverable 11
 |  | Project Kickoff Planning Meeting Deliverable 12
 |  | Project Kickoff Planning Meeting Deliverable 13