tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 70417d1271175281-sort-array-depending-on-2nd-column-sort_example
Sheet: Folha1

NUMERO | COD | EXP
430 | 14/0430
431 | 14/0431
432 | 14/0432 | SIM
433 | 14/0433
434 | 14/0434 | SIM
435 | 14/0435
436 | 14/0436
437 | 14/0437
438 | 14/0438 | SIM
439 | 14/0439
440 | 14/0440
441 | 14/0441
442 | 14/0442
443 | 14/0443
444 | 14/0444
445 | 14/0445
446 | 14/0446
447 | 14/0447
448 | 14/0448 | SIM
449 | 14/0449 | SIM
450 | 13/0450 | SIM
451 | 15/0451
452 | 15/0452
453 | 15/0453 | SIM
454 | 15/0454
455 | 15/0455
456 | 15/0456
457 | 15/0457
458 | 15/0458
459 | 15/0459
460 | 15/0460
461 | 15/0461
462 | 15/0462
463 | 15/0463
464 | 15/0464
465 | 15/0465
466 | 15/0466
467 | 15/0467 | SIM
468 | 15/0468
505 | 14/0505 | SIM
508 | 14/0508
509 | 14/0509
510 | 15/0510
511 | 15/0511
525 | 13/0525 | SIM
526 | 13/0526 | SIM
527 | 13/0527 | SIM
528 | 14/0528 | SIM
529 | 14/0529 | SIM
530 | 13/0530 | SIM
531 | 13/0531 | SIM
532 | 13/0532 | SIM
543 | 14/0543
544 | 15/0544
546 | 14/0546
547 | 14/0547 | CANCEL
548 | 14/0548
549 | 14/0549 | SIM
550 | 14/0550 | SIM
551 | 14/0551
553 | 14/0553
554 | 14/0554
555 | 15/0555
556 | 15/0556 | CANCEL
557 | 14/0557
558 | 14/0558
560 | 15/0560
561 | 15/0561
564 | 14/0564 | SIM
565 | 14/0565
566 | 14/0566
568 | 13/0568 | SIM
569 | 14/0569
570 | 14/0570
571 | 13/0571 | SIM
572 | 14/0572 | SIM
573 | 13/0573 | SIM
574 | 13/0574 | SIM
575 | 13/0575 | SIM
576 | 14/0576 | SIM
578 | 14/0578 | SIM
579 | 14/0579 | SIM
580 | 14/0580 | SIM
581 | 14/0581 | SIM
582 | 14/0582 | SIM
583 | 14/0583 | SIM
584 | 14/0584
585 | 14/0585
586 | 14/0586
587 | 14/0587
594 | 14/0594 | SIM
595 | 14/0595 | SIM
596 | 14/0596 | SIM
599 | 14/0599 | SIM
600 | 14/0600 | SIM
601 | 14/0601 | SIM
607 | 14/0607 | SIM
608 | 14/0608 | SIM
609 | 14/0609 | SIM
Spreadsheet: daren_farmer__6581__Texas Weather
Sheet: Jan

JANUARY
 | - NORMAL - |  |  |  | ACTUAL & FORECAST |  |  |  | Cum. | Temp |  | - NORMAL - |  |  |  | ACTUAL & FORECAST |  |  |  | Cum. | Temp
- DATE - | High | Low | AVG | HDD | High | Low | AVG | HDD | HDD | Range |  | High | Low | Avg | HDD | High | Low | AVG | HDD | HDD | Range |  | HOUSTON INTERCONTINENTAL (IAH) |  |  |  | HOUSTON HOBBY (HOU)
2000-01-01 00:00:00 | 62 | 40 |  |  |  |  |  |  |  |  | 1
2000-01-02 00:00:00 | 61.5 | 40 |  |  |  |  |  |  |  |  | 2
2000-01-03 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 3
2000-01-04 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 4
2000-01-05 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 5
2000-01-06 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 6
2000-01-07 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 7
2000-01-08 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 8
2000-01-09 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 9
2000-01-10 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 10
2000-01-11 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 11
2000-01-12 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 12
2000-01-13 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 13
2000-01-14 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 14
2000-01-15 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 15
2000-01-16 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 16
2000-01-17 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 17
2000-01-18 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 18
2000-01-19 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 19
2000-01-20 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 20
2000-01-21 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 21
2000-01-22 00:00:00 | 61 | 40 |  |  |  |  |  |  |  |  | 22
2000-01-23 00:00:00 | 62 | 40 |  |  |  |  |  |  |  |  | 23
2000-01-24 00:00:00 | 62 | 40 |  |  |  |  |  |  |  |  | 24
2000-01-25 00:00:00 | 62 | 40 |  |  |  |  |  |  |  |  | 25
2000-01-26 00:00:00 | 62 | 40 |  |  |  |  |  |  |  |  | 26
2000-01-27 00:00:00 | 63 | 40 |  |  |  |  |  |  |  |  | 27
2000-01-28 00:00:00 | 63 | 40 |  |  |  |  |  |  |  |  | 28
2000-01-29 00:00:00 | 63 | 40 |  |  |  |  |  |  |  |  | 29
2000-01-30 00:00:00 | 63 | 40 |  |  |  |  |  |  |  |  | 30
2000-01-31 00:00:00 | 63 | 40 |  |  |  |  |  |  |  |  | 31
Spreadsheet: eric_saibi__9962__110901R
Sheet: Gerald Gentleman 02

Owner Name |  | Nebraska Public Power
Station Name |  | [NAME]
Unit Name |  | [NAME] 02
NERC Region |  | MAPP
State |  | NE
Fuel Type |  | Coal
Capacity |  | 681 MW
Start Date |  | 2001-11-06 00:00:00
End Date |  | 2001-11-08 00:00:00
Prv. Start Date |  | 2001-11-06 00:00:00
Prv. End Date |  | 2001-11-10 00:00:00
Comments |  | Unit had a boiler problem
SIC |  | 4911
Plant ID |  | 1014369
Unit ID |  | 11008639
Outage ID |  | 18833
Spreadsheet: 128162d1320832459-how-to-make-the-source-for-a-list-made-in-data-validation-conditional-on-another-cell-help
Sheet: Sheet1

 | table 1
 |  | Vælg fra liste:
 | År | 2012 |  | aar_list | =Sheet2!$C$3:$C$12
 | Måned | April |  | dag_list | =Sheet2!$G$3:$G$33
 |  |  |  | maaned_list | =Sheet2!$D$3:$D$14
 | table 2 |  |  | Table2Day | =OFFSET(dag_list,0,0,DAY(DATE(Sheet1!$C$10,MATCH(Sheet1!$C$11,maaned_list,0)+1,0)),1)
 |  | Start |  | Table2Month | =IF(Sheet1!$C$10=Sheet1!$C$5,OFFSET(maaned_list,MATCH(Sheet1!$C$6,maaned_list,0)-1,0,13-MATCH(Sheet1!$C$6,maaned_list,0),1),OFFSET(maaned_list,0,0,MATCH(Sheet1!$C$6,maaned_list,0)-1,1))
 | År | 2013 |  | Table2Year | =IF(MATCH(Sheet1!$C$6,maaned_list,0)=1,Sheet1!$C$5,OFFSET(aar_list,MATCH(Sheet1!$C$5,aar_list,0)-1,0,2,1))
 | Måned | February |  | Table3Days | =IF(Sheet1!$C$17=Sheet1!$C$11,OFFSET(dag_list,Sheet1!$C$12-1,0,DAY(DATE(Sheet1!$C$10,MATCH(Sheet1!$C$11,maaned_list,0)+1,0))-Sheet1!$C$12+1,1),OFFSET(dag_list,0,0,DAY(DATE(Sheet1!$C$16,MATCH(Sheet1!$C$17,maaned_list,0)+1,0)),1))
 | Dag | 4 |  | Table3Month | =IF(Sheet1!$C$10=Sheet1!$C$5,IF(Sheet1!$C$16=Sheet1!$C$10,OFFSET(maaned_list,MATCH(Sheet1!$C$11,maaned_list,0)-1,0,13-MATCH(Sheet1!$C$11,maaned_list,0),1),OFFSET(maaned_list,0,0,MATCH(Sheet1!$C$6,maaned_list,0)-1,1)),OFFSET(maaned_list,MATCH(Sheet1!$C$11,maaned_list,0)-1,0,MATCH(Sheet1!$C$6,maaned_list,0)-1,1))
 |  |  |  | Table3Year | =IF(Sheet1!$C$10=Sheet1!$C$5,Table2Year,Sheet1!$C$10)
 | table 3
 |  | Slut
 | År | 2013
 | Måned | February
 | Dag
Spreadsheet: 105504d1302820227-how-to-work-out-a-time-formula-to-ignore-certain-information-dmnortheastmonth
Sheet: Lookup

TimeFrame | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2 | TF1 | TF2
00:00:00
00:15:00
00:30:00
00:45:00
01:00:00
01:15:00
01:30:00
01:45:00
02:00:00
02:15:00
02:30:00
02:45:00
03:00:00
03:15:00
03:30:00
03:45:00
04:00:00
04:15:00
04:30:00
04:45:00
05:00:00
05:15:00
05:30:00
05:45:00
06:00:00
06:15:00
06:30:00
06:45:00
07:00:00
07:15:00
07:30:00
07:45:00
08:00:00
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
23:15:00
23:30:00
23:45:00
Spreadsheet: 34279d1231436884-multiple-groups-in-excel-2002-uploadable-example-without-sorted-weeks-in-product-range-
Sheet: ProductRange2

 | Foxtrot | Golf | Hotel | India | [NAME] | Daily/Weekly Total | Monthly Total
12/01 | 34 | 7 | 1 | 9 | 10 | 61
12/02 | 10 | 2 | 4 | 13 | 18 | 47
12/03 | 12 | 6 | 3 | 23 | 26 | 70
12/04 | 14 | 22 | 21 | 2 | 34 | 93
12/05 | 16 | 27 | 5 | 25 | 42 | 115
12/06 | 18 | 32 | 6 | 2 | 78 | 136
12/07 | 20 | 37 | 7 | 33 | 58 | 155
12/08 | 24 | 47 | 9 | 41 | 74 | 195
12/09 | 43 | 52 | 10 | 45 | 567 | 717
12/10 | 2 | 3 | 456 | 49 | 90 | 600
12/11 | 3 | 4 | 8 | 9 | 98 | 122
12/12 | 32 | 3 | 4 | 57 | 106 | 202
12/13 | 34 | 2 | 14 | 61 | 114 | 225
12/14 | 36 | 77 | 15 | 65 | 122 | 315
12/15 | 40 | 87 | 17 | 73 | 138 | 355
12/16 | 42 | 92 | 18 | 77 | 146 | 375
12/17 | 44 | 67 | 19 | 81 | 154 | 365
12/18 | 46 | 102 | 20 | 97 | 162 | 427
12/19 | 48 | 107 | 21 | 89 | 170 | 435
12/20 | 50 | 112 | 22 | 5 | 76 | 265
12/21 | 52 | 117 | 23 | 97 | 186 | 475
12/22 | 56 | 127 | 25 | 105 | 202 | 515
12/23 | 58 | 132 | 26 | 6 | 7 | 229
12/24 | 60 | 137 | 4 | 45 | 4 | 250
12/25 | 62 | 142 | 3 | 117 | 226 | 550
12/26 | 64 | 147 | 4 | 34 | 234 | 483
12/27 | 66 | 152 | 30 | 5 | 242 | 495
12/28 | 68 | 157 | 31 | 129 | 250 | 635
12/29 | 72 | 167 | 33 | 137 | 266 | 675
12/30 | 74 | 172 | 7 | 6 | 8 | 267
12/31 | 76 | 177 | 35 | 145 | 282 | 715
2008-12 | 1276 | 2515 | 901 | 1682 | 4190 |  | 10564
01/01 | 80 | 187 | 37 | 153 | 298 | 755
01/02 | 82 | 192 | 123 | 2 | 3 | 402
01/03 | 84 | 197 | 23 | 161 | 656 | 1121
01/04 | 86 | 202 | 40 | 165 | 322 | 815
2009-01 | 332 | 778 | 223 | 481 | 1279 |  | 3093
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 5

 | December 20 | December 27 | January 3 | January 10 | January 17
Total Interest Rate* | 4308898 | 434081 | 1104491 | 4806086 | 3871832
Cleared** | 3714719 | 276623 | 761398 | 3593783 | 2274152
Uncleared | 594179 | 157458 | 343093 | 1212303 | 1597680
Total Cross-Currency | 101439 | 8483 | 34943 | 172195 | 320231
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 101439 | 8483 | 34943 | 172195 | 320231
Total Credit | 317845 | 38074 | 146697 | 351972
Cleared | 189128 | 22885 | 61657 | 186083 | 199417.5
Uncleared | 128718 | 15189 | 85040 | 165889 | 126002.8
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 4728182 | 480638 | 1286131 | 5330253 | 4692534
Weekly total, swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects the notional value of the creation of only one of the two swaps that results from the clearing process. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 735581d1623081149-overlapping-dates-date
Sheet: Foglio2

 |  |  |  |  | Dal | Al
 |  |  | room 101 |  | 2021-06-04 00:00:00 | 2021-06-06 00:00:00
 |  |  | room 102 |  | 2021-06-08 00:00:00 | 2021-06-10 00:00:00
 |  |  | room 101 |  | 2021-06-07 00:00:00 | 2021-06-12 00:00:00
 |  |  | room 102 |  | 2021-06-09 00:00:00 | 2021-06-15 00:00:00
 |  |  | room 102 |  | 2021-06-02 00:00:00 | 2021-06-09 00:00:00
Spreadsheet: 156652d1337369736-calculating-sums-referring-to-adjacent-cells-multiple-sums
Sheet: Sheet1

aa | 2 | 4 | 8 | 14
aa | 4 | 0 | 6 | 10
aa | 3 | 3 | 9 | 15
aa | 4 | 9 | 0 | 13
aa | 2 | 5 | 5 | 12
ab | 4 | 0 | 6 | 10
ab | 3 | 3 | 9 | 15
ab | 4 | 9 | 0 | 13
ac | 3 | 3 | 9 | 15
ac | 4 | 9 | 0 | 13
ac | 13 | 1 | 1 | 15
ac | 4 | 8 | 8 | 20
ad | 4 | 9 | 0 | 13
ba | 12 | 0 | 4 | 16
ba | 2 | 5 | 5 | 12
ba | 13 | 1 | 1 | 15
ba | 14 | 3 | 3 | 20
ba | 7 | 7 | 0 | 14
bb | 7 | 7 | 0 | 14
bb | 4 | 8 | 8 | 20
ca | 13 | 1 | 1 | 15
ca | 4 | 6 | 5 | 15
ca | 1 | 3 | 0 | 4
ca | 4 | 8 | 8 | 20
ca | 9 | 6 | 3 | 18
cb | 1 | 3 | 0 | 4
cc | 9 | 6 | 3 | 18
da | 14 | 3 | 3 | 20
da | 9 | 6 | 3 | 18
db | 9 | 6 | 3 | 18
dd | 14 | 3 | 3 | 20
Spreadsheet: 145960d1331831523-index-and-match-formula-example-index
Sheet: Summary for Slides

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.4mm | e.g. 149
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.4mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.8mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.14mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.4mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.4mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.8mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.1mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.28mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.4mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.8mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.3mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.5mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.4mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.8mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.1mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.5mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.3mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.5mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.8mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21.52mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 68468d1269005485-sum-with-conditions-sample-take-off-sheet
Sheet: Takeoff 1

Hospital Phase 1
Water Main |  |  |  |  |  |  | Hydrants |  |  |  |  |  | Connection
Line | Size | Length | Replacement | Main Valves | Air Release | [NAME] | Hydrant | Fire | [NAME] | [NAME] | Replacement | ISO Valve | Connection Size | Length | Replacement | Gate Valve | [NAME]
A | 6 | 600.9 | DI |  |  |  | 1 | Y | 6 | 7 | DI | N | 3 | 0 | DI |  | 1
 |  |  |  |  |  |  | 2 | N | 1.5 | 4.4 | DI | Y | 1.25 | 0 | DI |  | 1
B | 6 | 1772.5 | DI |  |  |  | 3 | Y | 6 | 9 | DI | N | 2.5 | 146 | CI |  | 1
 |  |  |  |  |  |  | 4 | Y | 6 | 10 | DI | N | 4 | 69 | DI |  | 1
 |  |  |  |  |  |  | 5 | N | 1.5 | 8 | CU | N | 2 | 70 | CU |  | 1
 |  |  |  |  |  |  | 6 | Y | 6 | 8 | DI | N
 |  |  |  |  |  |  | 7 | Y | 6 | 14 | DI | Y
C | 4 | 146 | DI |  |  |  |  |  |  |  |  |  | 4 | 6 | DI |  | 1
 | 6 | 141.8 | DI |  |  |  |  |  |  |  |  |  | 2 | 0 | PVC |  | 1
D | 6 | 522.8 | DI |  |  |  | 8 | Y | 6 | 16.2 | DI | N
E | 6 | 10 | CI | 1 |  |  | 9 | Y | 6 | 2.5 | CI | N
 | 6 | 200.5 | AC
F | 8 | 185.7 | AC | Y
G | 8 | 189.4 | AC
I | 12 | 95.2 | DI
 | 12 | 138.1 | AC | 1
 | 12 | 610.5 | DI | 1 |  |  | 10 | Y | 12 | 2.8 | DI | N | 1.5 | 5.5 | CU |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 6 | DI | 1
Spreadsheet: 876940d1723648268-conditional-formatting-blocks-of-dates-example
Sheet: Schedule

 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-13 00:00:00 | 2024-01-14 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00 | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00
Testing 1
Testing 2
Testing 3
Testing 4
Testing 5
Testing 6
Spreadsheet: 715631d1611803053-formula-to-offset-address-shown-in-another-cell-or-to-the-formula-that-calculates-it-county104sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | more centered near the top of the screen.
 |  | The formula in A72 calculates last line of the last section used.   However, when I hyperlink to the row and column of the calculated cell, it puts the cursor at the bottom right.  Therefore I want to offset it by 30 rows up and 10 rows to the left so that the cell shown in A72
Scenario List |  |  | Evaluation Record |  |  | 1 | Scenario |  | 1
D9_MISC |  | SCENARIO REVIEW NO 1
 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  | AA1 | Evaluation Record |  |  |  | Scenario
D9_MISC |  | SCENARIO REVIEW NO 2
 | YYYYYYYYYYYYYYYYYYYYYYYYYYYY |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  | AA2 | Evaluation Record |  |  |  | Scenario
D9_MISC |  | SCENARIO REVIEW NO 3
 | ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  | AA3 | Evaluation Record |  |  |  | Scenario
 |  |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  |  | Evaluation Record |  |  |  | Scenario
 |  |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  |  | Evaluation Record |  |  |  | Scenario
Spreadsheet: 879848d1727428454-merging-of-2-tables-test-forum
Sheet: Sheet1

 |  |  | place 1 | place 2 | place 3 | place 4 | place 5 | place 6 | place 7 | place 8 | place 9 | place 10 | place 11 | place 12 | place 13 | place 14 | place 15 | place 16
 |  | supplier 1 | 2 | 3 | 3 | 1 | 3 | 2 | 2 | 1 | 2 | 2 | 1 | 2 | 2 | 2 | 3 | 2
 |  | supplier 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0
 |  | supplier 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 2
 |  | supplier 4 | 3 | 3 | 3 | 0 | 1 | 1 | 3 | 0 | 0 | 2 | 0 | 1 | 3 | 2 | 3 | 0
 |  | supplier 5 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1
 |  | supplier 6 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  | supplier 7 | 1 | 1 | 1 | 2 | 1 | 0 | 1 | 2 | 3 | 1 | 1 | 0 | 3 | 4 | 1 | 1
 |  | supplier 8 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | supplier 9 | 3 | 0 | 2 | 3 | 2 | 1 | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 0 | 0
 |  | supplier 10 | 1 | 0 | 1 | 3 | 2 | 1 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 0
 |  | supplier 11 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0
 |  | supplier 12 | 2 | 6 | 1 | 4 | 6 | 1 | 4 | 1 | 2 | 1 | 1 | 1 | 3 | 2 | 2 | 1
 |  | supplier 13 | 2 | 6 | 1 | 4 | 6 | 1 | 4 | 1 | 2 | 1 | 1 | 1 | 3 | 2 | 2 | 1
 |  | supplier 14 | 2 | 6 | 1 | 4 | 6 | 1 | 4 | 1 | 2 | 1 | 1 | 1 | 3 | 2 | 2 | 1
 |  | place 1 | supplier 1
 |  | place 2 | supplier 1
 |  | place 3 | supplier 1
 |  | place 4 | supplier 1
 |  | place 5 | supplier 1
 |  | place 6 | supplier 1
 |  | place 7 | supplier 1
 |  | place 8 | supplier 1
 |  | place 9 | supplier 1
 |  | place 10 | supplier 1
 |  | place 11 | supplier 1
 |  | place 12 | supplier 1
 |  | place 13 | supplier 1
 |  | place 14 | supplier 1
 |  | place 15 | supplier 1
 |  | place 16 | supplier 1
 |  | place 1 | supplier 2
 |  | place 4 | supplier 2
 |  | place 9 | supplier 2
 |  | place | supplier 2
 |  | place 14 | supplier 2
Spreadsheet: 738889d1625317953-if-condition-not-working-as-expected-help-if_condition_open_closed
Sheet: Sheet1

TKT | Status 1 | Status 2 | Old Result | Expected Result
246 | Closed | Cancelled |  | Cancelled
247 | Cancelled | Cancelled |  | Cancelled
249 | Closed | Closed |  | Closed
250 | Open | Open |  | Open
251 |  | Cancelled |  | Cancelled
252 | Open | Closed |  | Closed
253 | Cancelled | Open |  | Open
254 | Open | Cancelled |  | Cancelled
255 | Closed | Open |  | Open
256 | Open |  |  | Open
257 | Closed |  |  | Closed
257 |  | Open |  | Open
Spreadsheet: 329073d1404194857-find-the-last-occurrence-of-a-value-in-multiple-columns-or-a-matrix-hymntrack-jacc
Sheet: Hymn Frequentness

Hymn # |  | Times Sung | [NAME] | Hymn # |  | Times Sung | [NAME] | Hymn # |  | Times Sung | [NAME] | Hymn # |  | Times Sung | [NAME] | Hymn # |  | Times Sung | [NAME]
1 |  |  |  | 71 |  |  |  | 141 |  |  |  | 211 |  |  |  | 281
Spreadsheet: 774911d1648722390-textjoin-several-dates-and-get-them-displayed-as-dates-example
Sheet: ZORD

Material | Valid from | Valid to | Vendor | Agreement
ABC1 | 2022-03-02 00:00:00 | 2025-12-31 00:00:00 | 200000001 | 460000001
ABC1 | 2021-01-01 00:00:00 | 2024-12-31 00:00:00 | 200000002 | 460000002
ABC1 | 2022-01-07 00:00:00 | 2023-12-31 00:00:00 | 200000000 | 460000000
[NAME] | 2021-01-01 00:00:00 | 2022-12-31 00:00:00 | 200000003 | 460000003
ABC3 | 2021-10-01 00:00:00 | 2024-12-01 00:00:00 | 200000004 | 460000004
[NAME] | 2021-10-01 00:00:00 | 2024-12-31 00:00:00 | 200000005 | 460000005
ABC3 | 2021-10-01 00:00:00 | 2024-12-31 00:00:00 | 200000006 | 460000006
[NAME] | 2021-06-28 00:00:00 | 2022-12-31 00:00:00 | 200000007 | 460000007
ABC5 | 2020-01-01 00:00:00 | 2022-12-31 00:00:00 | 200000008 | 460000008
ABC6 | 2020-01-01 00:00:00 | 2022-12-31 00:00:00 | 200000009 | 460000009
ABC7 | 2020-01-01 00:00:00 | 2022-12-31 00:00:00 | 200000010 | 460000010
ABC8 | 2020-01-01 00:00:00 | 2022-12-31 00:00:00 | 200000011 | 460000011
ABC9 | 2020-01-01 00:00:00 | 2022-12-31 00:00:00 | 200000012 | 460000012
ABC10 | 2021-01-01 00:00:00 | 2023-12-31 00:00:00 | 200000013 | 460000013
Spreadsheet: 691109d1597478740-repetitive-cell-in-vlookup-2020-08-15-oeldere-manik68-691105d1597477651-repetitive-cell-in-vlookup-mani-copy
Sheet: Sheet1

Table 1
PR | PO QNY | PO | value
10074943 | 30 | [PHONE]
10074943 | 20 | [PHONE]
10102331 | 50 | [PHONE]
10102331 | 40 | [PHONE]
10102331 | 60 | [PHONE]
 | Table 2
 | PO | PO QNY | value
 | [PHONE] | 40 | 0.068
 | [PHONE] | 50 | 0.024
 | [PHONE] | 20 | 5
 | [PHONE] | 30 | 0
 | [PHONE] | 60 | 0
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Nov 21

Enter 1st of Month Here -> | 2021-11-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: 889863d1740836507-conditional-formatting-based-on-cross-reference-cond_formatting
Sheet: DataElements

DATA ELEMENT (DE) | EVALUATION
Alpha | Certainty to Obtain Data
Bravo | Unlikely
[NAME] | Likely
Delta | Unlikely
Echo | Unknown
[NAME] | Likely
Golf | Will Not Obtain Data
Hotel | Likely
India | Highly Unlikely
[NAME] | Unknown
Kilo | Highly Likely
Lima | Likely
[NAME] | Certainty to Obtain Data
November | Likely
Spreadsheet: 705232d1605953523-sum-consecutive-dates-consecutive-occurrences-v2
Sheet: Sheet1

User | Date | Quantity | Total Option 1
[NAME] | 2020-02-01 00:00:00 | 1 | 1
[NAME] | 2020-02-02 00:00:00 | 0.5 | 1.5
[NAME] | 2020-02-08 00:00:00 | 1 | 1
[NAME] | 2020-02-09 00:00:00 | 1 | 2
[NAME] | 2020-02-10 00:00:00 | 1 | 3
[NAME] | 2020-02-11 00:00:00 | 1 | 4
[NAME] | 2020-02-12 00:00:00 | 1 | 5
[NAME] | 2020-02-13 00:00:00 | 1 | 6
[NAME] | 2020-02-14 00:00:00 | 1 | 7
[NAME] | 2020-02-15 00:00:00 | 1 | 8
[NAME] | 2020-02-16 00:00:00 | 1 | 9
[NAME] | 2020-02-17 00:00:00 | 1 | 10
[NAME] | 2020-02-18 00:00:00 | 1 | 1
[NAME] | 2020-04-01 00:00:00 | 0.5 | 0.5
[NAME] | 2020-04-02 00:00:00 | 1 | 1.5
[NAME] | 2020-04-03 00:00:00 | 1 | 2.5
[NAME] | 2020-04-17 00:00:00 | 0.5 | 0.5
[NAME] | 2020-04-18 00:00:00 | 0.5 | 1
[NAME] | 2020-04-18 00:00:00 | 1 | 1
[NAME] | 2020-04-19 00:00:00 | 0.5 | 1.5
[NAME] | 2020-04-19 00:00:00 | 0.5 | 2
[NAME] | 2020-04-20 00:00:00 | 1 | 3
[NAME] | 2020-05-01 00:00:00 | 0.5 | 0.5
[NAME] | 2020-05-01 00:00:00 | 0.5 | 1
[NAME] | 2020-05-02 00:00:00 | 1 | 2
[NAME] | 2020-10-01 00:00:00 | 1 | 1
[NAME] | 2020-10-02 00:00:00 | 0.5 | 1.5
[NAME] | 2020-10-02 00:00:00 | 0.5 | 2