tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kam_keiser__17854__quotesheet
Sheet: 12-18 afternoon

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
2001-12-18 13:07:33.070000 | Jan '02 | Natsource | Permian | Jan - Mar '02 | 10,000/d | -.1675 @ -.16
2001-12-18 13:07:33.070000 | Jan '02 | Natsource | Permian | Jan '02 | 10,000/d | -.155 @ -.145
2001-12-18 13:07:33.060000 | Jan '02 | Natsource | HSC | Jan '02 | 10,000/d | -.015 @ -.01
2001-12-18 13:07:33.060000 | Jan '02 | Natsource | HSC | Ap - Oct '02 | 10,000/d | .0275 @ .03
2001-12-18 13:07:33.060000 | Jan '02 | Natsource | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.015
2001-12-18 13:07:33.060000 | Jan '02 | Natsource | Waha | Ap - Oct '02 | 10,000/d | -.1175 @ -.1125
2001-12-18 13:07:33.060000 | Jan '02 | Natsource | Permian | Ap - Oct '02 | 10,000/d | -.165 @ -.16
2001-12-18 13:10:13.150000 | Jan '02 | APB | Permian | Jan - Mar '02 | 10,000/d | -.17 @ -.16
2001-12-18 13:10:13.150000 | Jan '02 | APB | Waha | Jan - Mar '02 | 10,000/d | -.1275 @ -.1175
2001-12-18 13:10:13.150000 | Jan '02 | APB | HSC | Jan - Mar '02 | 10,000/d | -.0175 @ -.0125
2001-12-18 13:10:13.150000 | Jan '02 | APB | HSC | Jan '02 | 10,000/d | -.015 @ -.01
2001-12-18 13:10:13.150000 | Jan '02 | APB | Waha | Ap - Oct '02 | 10,000/d | -.1175 @ -.11
2001-12-18 13:10:13.150000 | Jan '02 | APB | Permian | Ap - Oct '02 | 10,000/d | -.165 @ -.16
2001-12-18 13:10:13.150000 | Jan '02 | APB | HSC | Ap - Oct '02 | 10,000/d | .0275 @ .0325
2001-12-18 13:10:13.150000 | Jan '02 | APB | Waha | Jan '02 | 10,000/d | -.11 @ -.10
2001-12-18 13:10:13.150000 | Jan '02 | APB | Permian | Jan '02 | 10,000/d | -.15 @ -.14
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | Permian | Jan - Mar '02 | 10,000/d | -.1675 @ -.1625
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | Permian | Jan '02 | 10,000/d | -.155 @ -.15
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | Waha | Jan - Mar '02 | 10,000/d | -.125 @ -.12
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | Waha | Jan '02 | 10,000/d | -.115 @ -.11
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | HSC | Jan '02 | 10,000/d | -.0125 @ -.01
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | HSC | Ap - Oct '02 | 10,000/d | +.03 @ .0325
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | HSC | Nov '02 - Mar '03 | 10,000/d | -.0375 @ -.0325
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | HSC | Cal '03-06 | 10,000/d | 0 @ .005
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | Permian | Ap - Oct '02 | 10,000/d | -.165 @ -.16
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | Permian | Nov '02 - Mar '03 | 10,000/d | -.16 @ -.15
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | Waha | Ap - Oct '02 | 10,000/d | -.115 @ -.11
2001-12-18 13:10:23.040000 | Jan '02 | Prebon | HSC | Cal '02 | 10,000/d | +.0025 @ +.0075
Spreadsheet: c7e71f92-7418-4c10-bb82-5b6738e0f4af
Sheet: Sheet1

Votre recherche :  [NAME] : ZONARAS IOHANNES Œuvre : OPERA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Ville | [NAME] | Cote | Folios | Siècle | Date | Commentaire | Incipit | Desinit | Copiste | [NAME] | Révision | Source
IASI | Coll. C. Erbiceanu | 147 | p. 253--303
LEIDEN | [NAME] der Rijksuniversiteit | Voss. [NAME]. 07
[NAME] OROS | [NAME] | 0282 (Lambros 3816) | 113v |  |  | Excerptum : Notitia de templo in Cyzico | Ο ΜΕΝ ΕΝ ΚΥΖΙΚΩΙ ΠΕΡΙΒΟΗΤΟΣ ΝΑΟΣ | ΚΑΤΑ ΤΟΝ ΙΣΤΟΡΙΟΓΡΑΦΟΝ ΚΥΡ ΙΩΑΝΝΗΝ ΤΟΝ ΖΩΝΑΡΑΝ |  |  | P
WIEN | [NAME] | hist. gr. 016 |  |  |  |  |  |  |  | MATTHIAS CORVINVS (1443-1490)WIEN, UniversitätsibliothekJOHANNES FABER (FABRI), EPISC. WIEN (1478-1541)
[NAME] OROS | [NAME] | 002 (Lambros 0129) | Item 3 | 9 | 900
VENEZIA | [NAME] | gr. app. II. 116 (coll. 0961) | 001-2v | 13 |  | Textus superior : QUAESTIONES ; cf. [NAME]. gr. app. XI. 24, [NAME] ; cf. [NAME], I palinsesti greci, Diptycha II (1980-81), pp. 179-181 | ΟΥΤΩΣ ΠΙΣΤΕΥΟΜΕΝ ΤΗΝ ΜΑΚΑΡΙΑΝ ΚΑΙ ΥΠΕΡΑΓΙΟΝ... ΤΡΙΑΔΑ |  |  |  |  | R(III)2393
VATICANO | [NAME] | [NAME]. gr. 0375 | 207v-208* | 14
SANKT-PETERBURG | Rossijskaja Nacional'naja biblioteka (RNB) | Gr. 116 (Granstrem 522 ; CCAG XII 14) | 205v-207v* | 14 | 1318
[NAME] OROS | [NAME] | 308 | 287-293v* | 14
OXFORD | Bodleian Library | Barocci 025 | 233--243* | 14
VATICANO | [NAME] | [NAME]. gr. 0578 | 110v-111v | 14
MILANO | [NAME] | L 108 sup. ([NAME] 494) | 098--99 | 15
[NAME] OROS | [NAME] | 073 (Lambros 1107) | Item 3 | 15
OXFORD | Bodleian Library | Barocci 149 | 001--4v* | 15
[NAME] OROS | [NAME] | 999 |  | 16
PATMOS | Monê tou [NAME] tou Theologou | 286 |  | 16
ATHENA | [NAME] tês Hellados (EBE) | Metochion tou panagiou Taphou 520 | 011--93* | 16
WIEN | [NAME] | hist. gr. 024 | 033v-42 | 16
ESCORIAL (EL) | Real Biblioteca | Rho. I. 08 (Revilla 008) | [NAME] | 16 |  |  | ΟΤΙ ΔΕΙ ΤΟΝ ΔΕΧΟΜΕΝΟΝ ΤΗΝ ΕΞΟΜΟΛΟΓΗΣΙΝ
SINAI | Monê tês Hagias Aikaterinês | gr. 1787 | 317v-322 | 16-17 |  | QUAESTIONES ET RESPONSIONES 3 | ΟΙΔΑΜΕΝ ΟΥΝ ΑΓΑΠΗΤΟΙ | ΑΝΕΣΤΗΣΑΝ ΠΕΖΕΙΝ |  |  | T
VATICANO | [NAME] | [NAME]. gr. 1199 |  | 16-17 |  |  |  |  | [NAME] (RGK I 179, II 238, III 299)
[NAME] OROS | [NAME] | 558 | 001--1260* | 17
[NAME] OROS | Monê Megistês Lauras | Ω 022 (Eustratiades 1832) | 127-128 | 17 |  | Fragmentum |  |  |  |  | T
[NAME] OROS | [NAME] | 079 (Lambros 1592) | Item 5 | 17
PATMOS | Monê tou [NAME] tou Theologou | 339 | Item 2 | 18
[NAME] OROS | Monê Ibêrôn | 0493 (Lambros 4613) | 078--159* | 18
JERUSALEM | Patriarchikê bibliothêkê | [NAME] 098 |  | 18
[NAME] OROS | [NAME] | 093 (Lambros 795) |  | 18
SOFIJA | Narodna Biblioteka sb. sb. Kiril i Metodij | gr. 057 | 021--173 | 18
[NAME] OROS | Monê Ibêrôn | 0291 (Lambros 4411) | 001--298* | 18
[NAME] OROS | [NAME] | 259 (Lambros 2272) |  | 18
Spreadsheet: 71842d1272549316-updating-range-book2
Sheet: Sheet1

Date | Start Time | End Time | Channel 1 | Channel 2 | Channel 3 | Channel 4 | Channel 5 | Channel 6 | Channel 7 | Channel 8 | Channel 9 | Channel 10
2010-02-01 00:00:00 | 06:00:00 | 06:15:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-02-01 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-02-01 00:00:00 |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0 | 0.1 | 0.2 | 0.2 | 0.1 |  | Date | Channel | Program Name | Start Time | End Time | Average Rating |  |  |  |  |  |  | channel 1 | 1
2010-02-01 00:00:00 |  |  | 0.2 | 0.2 | 0.1 | 0.2 | 0.2 | 0.1 | 0.2 | 0.1 | 0.1 | 0.1 |  | 2010-02-01 00:00:00 | channel 1 | aa | 07:50:00 | 08:50:00 |  | =(2+6+5)/3 |  |  |  |  |  | channel 2 | 2
2010-02-01 00:00:00 |  |  | 0.2 | 0.1 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0.1 | 0.1 |  | 2010-02-01 00:00:00 | channel 9 | bb | 06:30:00 | 08:30:00 |  |  |  |  |  |  |  | channel 3 | 3
2010-02-01 00:00:00 |  |  | 2.5 | 0.1 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0.1 | 0.3 |  | 2010-02-01 00:00:00 | channel 8 | cc | 08:30:00 | 09:10:00 |  |  |  |  |  |  |  | channel 4 | 4
2010-02-01 00:00:00 |  |  | 2 | 0.1 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0.1 | 0.2 |  | 2010-02-01 00:00:00 | channel 2 | dd | 06:00:00 | 09:00:00 |  |  |  |  |  |  |  | channel 5 | 5
2010-02-01 00:00:00 |  |  | 3 | 4 | 0.2 | 4 | 0.2 | 0.2 | 4 | 0.2 | 0.2 | 0.2 |  | 2010-02-01 00:00:00 | channel 3 | ee | 07:05:00 | 08:15:00 |  |  |  |  |  |  |  | channel 6 | 6
2010-02-01 00:00:00 |  |  | 2 | 0.1 | 0.1 | 0.1 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  | 2010-02-01 00:00:00 | channel 10 | ff | 07:15:00 | 08:03:00 |  |  |  |  |  |  |  | channel 7 | 7
2010-02-01 00:00:00 |  |  | 6 | 2 | 7 | 2 | 0.1 | 3 | 0.1 | 0.1 | 0.1 | 0.1 |  | 2010-02-01 00:00:00 | channel 6 | gg | 09:10:00 | 09:15:00 |  |  |  |  |  |  |  | channel 8 | 8
2010-02-01 00:00:00 |  |  | 5 | 1 | 5 | 3 | 3 | 3 | 4 | 5 | 4 | 1 |  | 2010-02-01 00:00:00 | channel 7 | hh | 07:52:00 | 08:32:00 |  |  |  |  |  |  |  | channel 9 | 9
2010-02-01 00:00:00 |  |  | 4 | 3 | 5 | 3 | 5 | 2 | 4 | 2 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | channel 10 | 10
2010-02-01 00:00:00 |  |  | 4 | 2 | 6 | 3 | 5 | 4 | 3 | 7 | 2 | 2
Spreadsheet: 144210d1330793251-excel-2007-sort-duplicates-to-individual-columns-sort-duplicates
Sheet: DV-IDENTITY-0

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAAAAF67b0Y=
Spreadsheet: 76759d1277246055-index-and-match-with-range-lookups-book12
Sheet: Sheet1

Name | LVL | Raw Score 1 | Final Score 1 | Raw Score 2 | Final Score 2
[NAME] | [NAME] | 0.7 |  | 21
[NAME] | LVL2 | 0.81 |  | 22
[NAME] | LVL2 | 0.9 |  | 18
[NAME] | [NAME] | 0.7333 |  | 17
[NAME] | LVL2 | 0.721 |  | 16.2
[NAME] 6 | LVL3 | 0.75 |  | 13.5
[NAME] | LVL3 | 0.731 |  | 14.8
[NAME] | [NAME] | 0.67 |  | 15.88
Raw Score 1 |  |  |  | Raw Score 2
[NAME] |  |  |  | [NAME]
1 | 0 | 0.6899 |  | 3 | 0 | 19
1.5 | 0.69 | 0.7099 |  | 1 | 19.01 | 1000
2 | 0.71 | 0.7299
2.5 | 0.73 | 0.7499
3 | 0.75 | 1
LVL2 |  |  |  | LVL2
1 | 0 | 0.6999 |  | 3 | 0 | 18.5
1.5 | 0.7 | 0.7199 |  | 1 | 18.81 | 1000
2 | 0.72 | 0.7399
2.5 | 0.74 | 0.7599
3 | 0.76 | 1
LVL3 |  |  |  | LVL3
1 | 0 | 0.7299 |  | 3 | 0 | 18.4
1.5 | 0.73 | 0.7499 |  | 1 | 18.41 | 1000
2 | 0.75 | 0.7699
2.5 | 0.77 | 0.7899
3 | 0.7999 | 1
Spreadsheet: 833299d1686890980-finding-top-5-with-multiple-criteria-and-solving-for-duplicate-results-results-test-ans
Sheet: Sheet1

 |  | Example 1 |  |  |  |  |  |  |  |  |  |  | Example 2
 |  | State | Store | Day 1 |  | Top 5 Restaurants |  |  |  |  |  |  | State | Store | Day 1 |  | Top 5 Restaurants
 |  | CA | [NAME] 1 | 487 |  | CA | 1 |  |  |  |  |  | CA | [NAME] 1 | 487 |  | CA | 1
 |  | CA | [NAME] 2 | 790 |  |  | 2 |  |  |  |  |  | CA | [NAME] 2 | 790 |  |  | 2
 |  | CA | [NAME] 3 | 734 |  |  | 3 |  |  |  |  |  | CA | [NAME] 3 | 734 |  |  | 3
 |  | CA | [NAME] 4 | 790 |  |  | 4 |  |  |  |  |  | CA | [NAME] 4 | 790 |  |  | 4
 |  | CA | [NAME] 5 | 471 |  |  | 5 |  |  |  |  |  | CA | [NAME] 5 | 471 |  |  | 5
 |  | CA | [NAME] 6 | 856 |  | NV | 1 |  |  |  |  |  | CA | [NAME] 6 | 856
 |  | CA | [NAME] 7 | 457 |  |  | 2 |  |  |  |  |  | CA | [NAME] 7 | 457
 |  | CA | [NAME] 8 | 276 |  |  | 3 |  |  |  |  |  | CA | [NAME] 8 | 276
 |  | CA | [NAME] 9 | 407 |  |  | 4 |  |  |  |  |  | CA | [NAME] 9 | 407
 |  | CA | [NAME] 10 | 302 |  |  | 5 |  |  |  |  |  | CA | [NAME] 10 | 302
 |  | NV | [NAME] 1 | 790 |  | TX | 1
 |  | NV | [NAME] 2 | 790 |  |  | 2
 |  | NV | [NAME] 3 | 301 |  |  | 3
 |  | NV | [NAME] 4 | 507 |  |  | 4
 |  | NV | [NAME] 5 | 815 |  |  | 5
 |  | NV | [NAME] 6 | 815 |  | HI | 1 |  |  |  |  |  | cells E15 and E16 are changed to show the working when there is duplication inin different state and different stores.
 |  | NV | [NAME] 7 | 277 |  |  | 2
 |  | NV | [NAME] 8 | 360 |  |  | 3
 |  | NV | [NAME] 9 | 204 |  |  | 4
 |  | NV | [NAME] 10 | 523 |  |  | 5
 |  | TX | [NAME] 1 | 699 |  | FL | 1
 |  | TX | [NAME] 2 | 377 |  |  | 2
 |  | TX | [NAME] 3 | 482 |  |  | 3
 |  | TX | [NAME] 4 | 960 |  |  | 4
 |  | TX | [NAME] 5 | 247 |  |  | 5
 |  | TX | [NAME] 6 | 721
 |  | TX | [NAME] 7 | 534
 |  | TX | [NAME] 8 | 960
 |  | TX | [NAME] 9 | 366
 |  | TX | [NAME] 10 | 284
 |  | HI | HI Store 1 | 691
 |  | HI | HI Store 2 | 313
 |  | HI | HI Store 3 | 568
 |  | HI | HI Store 4 | 180
 |  | HI | HI Store 5 | 446
 |  | HI | HI Store 6 | 407
 |  | HI | HI Store 7 | 714
 |  | HI | HI Store 8 | 828
 |  | HI | HI Store 9 | 531
 |  | HI | HI Store 10 | 300
 |  | FL | FL Store 1 | 640
 |  | FL | FL Store 2 | 176
 |  | FL | FL Store 3 | 471
 |  | FL | FL Store 4 | 337
 |  | FL | FL Store 5 | 115
 |  | FL | FL Store 6 | 241
 |  | FL | FL Store 7 | 797
 |  | FL | FL Store 8 | 819
 |  | FL | FL Store 9 | 470
 |  | FL | FL Store 10 | 244
Spreadsheet: craig_dean__4363__1-13act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2 |  |  |  |  |  |  |  | 1.96
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 93985d1293749295-finding-duplicates-in-multiple-columns-forum-sample-5
Sheet: Sheet1

016 |  | 025 |  | 213
620 |  | 035 |  | 025
036 |  | 045 |  | 620
621 |  | 315 |  | 332
064 |  | 055 |  | 027
613 |  | 145 |  | 234
641 |  | 253 |  | 621
263 |  | 452 |  | 802
651 |  | 507 |  | 217
246 |  | 651 |  | 253
076 |  | 255 |  | 218
265 |  | 345 |  | 263
346 |  | 085 |  | 452
068 |  | 571 |  | 129
167 |  | 265 |  | 228
653 |  | 355 |  | 327
446 |  | 095 |  | 246
096 |  | 158 |  | 255
267 |  | 275 |  | 823
465 |  | 653 |  | 274
691 |  | 545 |  | 265
862 |  | 591 |  | 329
673 |  | 258 |  | 842
556 |  | 735 |  | 275
836 |  | 465 |  | 249
467 |  | 952 |  | 258
396 |  | 538 |  | 267
486 |  | 574 |  | 952
675 |  | 556 |  | 862
694 |  | 935 |  | 772
658 |  | 548 |  | 287
596 |  | 755 |  | 279
866 |  | 549 |  | 892
696 |  | 585
687 |  | 675
967 |  | 559
868 |  | 658
698 |  | 757
699 |  | 596
 |  | 578
 |  | 957
 |  | 598
Spreadsheet: kate_symes__18385__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
 | 2000-12-17 00:00:00 |  | 196.67 | 1200 | 175.71 | 280 | 136.93 | 985 | 113.5 | 500 |  | 177.12 | 2664
 | 2000-12-16 00:00:00 |  | 233.65 | 12880 | 192.27 | 2704 | 130.23 | 922 | 120.83 | 60
 | 2000-12-15 00:00:00 |  | 238.8 | 13024 | 192.27 | 2704 | 180.19 | 1670 | 128.18 | 706
 | 2000-12-14 00:00:00 |  | 334.66 | 15184 | 213.55 | 2480 | 200 | 150 | 174.54 | 271
 | 2000-12-13 00:00:00 |  | 495.62 | 14992 | 223.93 | 4504 | 276 | 3139 | 184.69 | 2161
 | 2000-12-12 00:00:00 |  | 330 | 9200 | 211.98 | 2688 | 347.7 | 2622 | 193.04 | 1826
 | 2000-12-11 00:00:00 |  | 414.56 | 9200 | 213.96 | 2480 | 204.38 | 2263 | 187.04 | 1280
 | 2000-12-10 00:00:00 |  | 254.96 | 2160 | 217.63 | 2280 | 180.88 | 1906 | 161.34 | 780 |  | 172.02 | 600
 | 2000-12-09 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 189.51 | 1364 | 138.71 | 403
 | 2000-12-08 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 290.86 | 1368 | 205.28 | 799
 | 2000-12-07 00:00:00 |  | 262.73 | 15808 | 174.55 | 2816 | 241.93 | 1455 | 118.5 | 865
 | 2000-12-06 00:00:00 |  | 250.5 | 23472 | 154.65 | 3232 | 283.47 | 2363 | 157.27 | 595
 | 2000-12-05 00:00:00 |  | 227.52 | 24992 | 101.29 | 3072 | 232.74 | 2743 | 129.08 | 673
 | 2000-12-04 00:00:00 |  | 190.1 | 29792 | 122.57 | 3880 | 162.07 | 2138 | 113.27 | 707
 | 2000-12-03 00:00:00 |  | 131.13 | 1600 | 119.17 | 600 | 107.99 | 2405 | 107.67 | 1422 |  | 122.75 | 11040
 | 2000-12-02 00:00:00 |  | 137.08 | 30464 | 72.7 | 2560 | 118.37 | 1436 | 90.96 | 1103
 | 2000-12-01 00:00:00 |  | 137.11 | 30144 | 72.7 | 2560 | 118.32 | 2042 | 90.99 | 855
 | 2000-11-30 00:00:00 |  | 171.25 | 27456 | 82.58 | 2392 | 129.11 | 2102 | 91.19 | 576
 | 2000-11-29 00:00:00 |  | 172.05 | 26336 | 87.15 | 3328 | 109.18 | 1495 | 95.66 | 607
 | 2000-11-28 00:00:00 |  | 129.76 | 22496 | 80.75 | 2568 | 119.59 | 2075 | 96.18 | 1478
 | 2000-11-27 00:00:00 |  | 152.95 | 26240 | 92.28 | 1800 | 121.75 | 2397 | 79.26 | 1760
 | 2000-11-26 00:00:00 |  | 140 | 0 | 87.5 | 0 | 98.61 | 2369 | 70.02 | 968 |  | 92.77 | 6600
 | 2000-11-25 00:00:00 |  | 137.48 | 10000 | 99.63 | 4976 | 83.59 | 2587 | 68.23 | 1090
 | 2000-11-24 00:00:00 |  | 137.48 | 10000 | 99.63 | 4976 | 69.95 | 878 | 67.18 | 200
 | 2000-11-23 00:00:00 |  | 140 | 0 | 101.5 | 0 | 53.94 | 1224 | 62.32 | 1120 |  | 98.83 | 7200
 | 2000-11-22 00:00:00 |  | 179.8 | 24480 | 100.93 | 1976 | 102.91 | 2259 | 75.58 | 900
Spreadsheet: 42722d1241295621-solved-ignore-text-but-calculate-numbers-in-cells-jacks-20gardening-1-
Sheet: Sheet1

JACKS GARDENING                                                                                  PO BOX 1234                                                                                                                    ANYWHERE, WORLD |  |  | INVOICE # | 22009
 |  |  | SERVICE MONTH | YEAR
 |  |  | NOTE
[NAME]                                                                                          122333 S. ATKINS                                                                                           ANYWHERE, WORLD
QTY | [NAME] |  | UNIT PRICE | TOTAL
1 | DRINK | liter | 50 | 50
4 | LABOR | per hour | 50000 | 200000
2 | FOOD | piece | 100 | 200
6 | WALKING | meter | 2000 | 12000
3 | LABOR | per hour | 50000 | 150000
 |  |  | SUBTOTAL | 150000
 |  |  | TAX
 |  |  | TOTAL
1
2
3
4
5
6
7
8
9 | LABOR (per hour)                                                             $50.00
10
 |  |  | JANUARY | 2009
 |  |  | FEBRUARY | 2010
 |  |  | [NAME] | 2011
 |  |  | APRIL | 2012
 |  |  | MAY | 2013
 |  |  | [NAME] | 2014
 |  |  | JULY | 2015
 |  |  | AUGUST | 2016
THANK YOU |  |  | SEPTEMBER | 2017
THANK YOU FOR YOUR PAYMENT |  |  | OCTOBER | 2018
HAVE A GREAT HOLIDAY |  |  | NOVEMBER | 2019
PLEASE PAY PROMPTLY |  |  | DECEMBER | 2020
TO AVOID SERVICE INTERUPTION,                                                                          PLEASE PAY PROMPTLY
Spreadsheet: 127729d1320509564-sort-by-id-and-find-most-frequent-ones-new-microsoft-excel-arbeitsblatt
Sheet: Tabelle1

User | timestamp | Thread | Text
1 | 18:00:00 | 3 | Hallo
2 | 19:00:00 | 3 | Hallo
1 | 20:00:00 | 3 | Hallo
3 | 21:00:00 | 4 | Hallo
1 | 22:00:00 | 4 | Hallo
1 | 23:00:00 | 4 | Hallo
2 | 1900-01-01 00:00:00 | 5 | Hallo
1 | 1900-01-01 01:00:00 | 3 | Hallo
2 | 1900-01-01 02:00:00 | 4 | Hallo
Summe wenn 1
Summe wenn 2
Summe wenn 3
Summe wenn 4
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -151076 | -150326
2 | -186416 | -184781
3 | -210011 | -208808
4 | -245094 | -241726
5 | -236194 | -235157
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 24925
2001-08-05 00:00:00
CBS Dollars
 |  |  | -156014
Spreadsheet: 488502d1478695237-vlookup-does-not-work-book2
Sheet: Sheet2

ACCOUNT_NO | Type
2
4
4
4
8
11
12
12
14
Spreadsheet: 815554d1675030843-help-with-formula-to-combine-rows-of-data-onto-one-row-formula-help-1-
Sheet: Sheet1

Fruit | Week 1 | Week 2 | Week 3 | Week 4 |  |  |  |  |  | Fruit | Week 1 | Week 2 | Week 3 | Week 4
Apple | 5 |  |  |  |  |  |  |  |  | Apple | 5 | 5 | 5
Orange | 5 |  |  |  |  |  | [NAME] to |  |  | Orange | 5 |  | 6 | 3
[NAME] |  | 6 |  | 6 |  |  |  |  |  | [NAME] |  | 6 | 2 | 6
Apple |  | 5
Orange |  |  | 6 |  |  |  |  |  |  |  | Week 1 | Week 2 | Week 3 | Week 4
Apple |  |  | 5 |  |  |  |  |  |  | Apple | 5 | 5 | 5 | 0
[NAME] |  |  | 2 |  |  |  |  |  |  | Orange | 5 | 0 | 6 | 3
Orange |  |  |  | 3 |  |  |  |  |  | [NAME] | 0 | 6 | 2 | 6
Spreadsheet: 94123d1293989175-search-for-string-in-worksheet-s-and-return-results-in-sequential-order-sample-workbook-mahju
Sheet: Summary

 | Count of Dummy
 | Status | Department | Name | ID | Hire Date | Total
 | Active | Engineering | [NAME] | 906.2394028637782 | 2001-05-13 00:00:00
 |  |  | [NAME] | 321.8163963434762 | 1997-07-18 00:00:00
 |  |  | Roxie Sarles | 973.4626260948285 | 2006-05-30 00:00:00
 |  | Facilties | [NAME] | 58.88855863405411 | 2001-05-13 00:00:00
 |  |  | [NAME] | 943.6884675896359 | 1997-07-18 00:00:00
 |  |  | [NAME] | 732.5559100162666 | 2006-05-30 00:00:00
 |  | HR | [NAME] | 780.6069371775324 | 2001-05-13 00:00:00
 |  |  | [NAME] | 155.4330631863325 | 2006-05-30 00:00:00
 |  |  | [NAME] | 335.5980033769903 | 1997-07-18 00:00:00
 | Count of Dummy
 | Status | Name | ID | Hire Date | Total
 | Active | [NAME] | 58.88855863405411 | 2001-05-13 00:00:00
 |  | [NAME] | 906.2394028637782 | 2001-05-13 00:00:00
 |  | [NAME] | 943.6884675896359 | 1997-07-18 00:00:00
 |  | [NAME] | 780.6069371775324 | 2001-05-13 00:00:00
 |  | [NAME] | 155.4330631863325 | 2006-05-30 00:00:00
 |  | [NAME] | 321.8163963434762 | 1997-07-18 00:00:00
 |  | Roxie Sarles | 973.4626260948285 | 2006-05-30 00:00:00
 |  | [NAME] | 335.5980033769903 | 1997-07-18 00:00:00
 |  | [NAME] | 732.5559100162666 | 2006-05-30 00:00:00
 | Active Total
Spreadsheet: 588306d1535555712-sumif-with-condition-example-sumifs
Sheet: Tab 1

Acct | Type | Cost
ABC123 | Truck | 100
ABC123 | Car | 150
ABC123 | Trucks - Toyota | 200
ABC123 | SUV | 250
ABC123 | SEDANS | 300
DEF456 | Truck | 200
DEF456 | Car | 150
DEF456 | Trucks - Toyota | 350
DEF456 | SUV | 250
DEF456 | SEDANS | 300
Spreadsheet: 64808d1265647391-reverse-vlookup-how-reverse-vlookup
Sheet: Sheet1

the | 12 | word | bangladesh
quick | 58 | excel | usa
[NAME] | 64 | power | uk
fox | 95 | point | china
[NAME] | 23 | access | india
over | 58 | publisher | brazil
the | 655 | outlook | japan
 |  |  |  |  | usa | quick
I want to use function in G10 so that if f10=usa then G10=quick, if f10=china then G10=fox
That’s mean [NAME] in column D and return value of corresponding row from column A
Spreadsheet: 86227d1286246717-automatically-updating-multiple-sheets-to-a-master-sheet-welshgirl-finance-sheet-test
Sheet: Project C

Project C
Date | [NAME] | Invoice Number | Cheque No. | Paying In Slip No. | £              Inc | £                      Exp | £        Balance
2010-08-07 00:00:00 | c | 1 | 3 | 5 | 500 | 100 | 400
2010-08-08 00:00:00 | c | 1 | 3 | 6 | 500 | 100 | 800
1900-03-28 00:00:00 | 88 | 88 | 88 | 88 | 88 | 88 | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  |  |  | 800
 |  |  |  |  | 1088 | 288 | 1600
Spreadsheet: 760459d1640217098-how-to-fix-time-calculation-sample
Sheet: Sheet1

 |  | Time in | Time Out | Duration |  |  |  |  |  | Total
 | 10 | 08:33:00 | 19:14:00
 | 9 | 20:13:00 | 23:13:00
 | 8 | 00:00:00 | 00:08:00
 | 7 | 20:46:00 | 23:59:00
 | 6 | 20:06:00 | 23:21:00
 | 5 | 22:32:00 | 23:52:00
 | 4 | 10:16:00 | 13:39:00
 | 3 | 00:00:00 | 00:00:00
 | 2 | 18:00:00 | 23:59:00
 | 1 | 13:12:00 | 22:12:00