tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 853344d1703216776-retrieve-more-than-one-midrange-value-trash-tons-2022
Sheet: Nov 2022

 | Month | Zone | Total [NAME] |  | Zone | [NAME]
 | May | Zone 1 | 98.56 |  | Zone 01 | 685.28
 | June | Zone 1 | 105.6 |  | Zone 02 | 795.68
 | July | Zone 1 | 106.56 |  | Zone 03 | 819.3600000000001
 | August | Zone 1 | 109.76 |  | Zone 04 | 956.48
 | September | Zone 1 | 124 |  | Zone 05 | 861.28
 | October | Zone 1 | 140.8 |  | Zone 06 | 688.7064
 | May | Zone 2 | 169.6 |  | Zone 07 | 799.6583999999999
 | June | Zone 2 | 203.84 |  | Zone 08 | 823.4567999999999
 | July | Zone 2 | 96.32 |  | Zone 09 | 961.2623999999998
 | August | Zone 2 | 101.76 |  | Zone 10 | 582.4879999999999
 | September | Zone 2 | 108.64 |  | Zone 11 | 676.328
 | October | Zone 2 | 115.52 |  | Zone 12 | 696.456
 | May | Zone 3 | 142.4 |  | Zone 13 | 813.008
 | June | Zone 3 | 155.68
 | July | Zone 3 | 157.12
 | August | Zone 3 | 163.36
 | September | Zone 3 | 99.2
 | October | Zone 3 | 101.6
 | May | Zone 4 | 141.28
 | June | Zone 4 | 155.2
 | July | Zone 4 | 155.52
 | August | Zone 4 | 162.24
 | September | Zone 4 | 165.76
 | October | Zone 4 | 176.48
 | May | Zone 5 | 116.48
 | June | Zone 5 | 124
 | July | Zone 5 | 129.6
 | August | Zone 5 | 158.88
 | September | Zone 5 | 160.16
 | October | Zone 5 | 172.16
 | May | Zone 6 | 99.05279999999999
 | June |  | 106.128
 | July |  | 107.0928
 | August |  | 110.3088
 | September |  | 124.62
 | October |  | 141.504
 | May | Zone 7 | 170.448
 | June |  | 204.8592
 | July |  | 96.80159999999998
 | August |  | 102.2688
 | September |  | 109.1832
 | October |  | 116.0976
 | May | Zone 8 | 143.112
 | June | Zone 8 | 156.4584
 | July |  | 157.9056
 | August |  | 164.1768
 | September |  | 99.696
 | October |  | 102.108
 | May | Zone 9 | 141.9864
 | June |  | 155.976
 | July |  | 156.2976
 | August |  | 163.0512
 | September |  | 166.5888
 | October |  | 177.3624
 | May | Zone 10 | 83.776
 | June |  | 89.75999999999999
 | July |  | 90.576
 | August |  | 93.296
 | September |  | 105.4
 | October |  | 119.68
 | May | Zone 11 | 144.16
 | June |  | 173.264
 | July |  | 81.87199999999999
 | August |  | 86.496
 | September |  | 92.344
 | October |  | 98.192
 | May | Zone 12 | 121.04
 | June |  | 132.328
 | July |  | 133.552
 | August |  | 138.856
 | September |  | 84.32
 | October |  | 86.36
 | May | Zone 13 | 120.088
 | June |  | 131.92
 | July |  | 132.192
 | August |  | 137.904
 | September |  | 140.896
 | October |  | 150.008
Spreadsheet: kate_symes__18137__DJCHEAT
Sheet: fax

 | Electricity Price Index Report
 | Rep. [NAME]: | 2000-12-27 00:00:00
 | Flow Date: | 2000-12-28 00:00:00
 | From: | Enron Power Marketing Inc. - Kate Symes
 | Phone: | (800) 464-7486
 | Fax: | (503) 464-3740
 | To: | [NAME] or [NAME]
 | Phone: | (609) 520-4452 ([NAME])
 | Phone: | (609) 520-4663 (Earnest Onukogu)
 | Fax: | (609) 452-3531
 | COB
 | Designation | Type | Weighted Avg. Price | MWH Vol.
 | On [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | MID COLUMBIA
 | Designation | Type | Weighted Avg. Price | MWH Vol.
 | On [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | PALO VERDE
 | Designation | Type | Weighted Avg. Price | MWH Vol.
 | On [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | MEAD
 | Designation | Type | Weighted Avg. Price | MWH Vol.
 | On [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | NP-15
 | Designation | Type | Weighted Avg. Price | MWH Vol.
 | On [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | SP-15
 | Designation | Type | Weighted Avg. Price | MWH Vol.
 | On [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
 | [NAME] | Firm Trades Sales
 |  | Firm Trades Purchases
Spreadsheet: ed79c0ef-1a28-42c1-97f8-dc3b29effa5d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7556 | 47075 | Satu | Immonen | FIN | 161 | 00:20:03 | [NAME] | 00:32:04 | 00:01:15 | 00:18:17 | 1 | 01:12:36
7556 | 46345 | [NAME] | Marttinen | FIN | 162 | 00:19:45 | 00:00:54 | 00:33:04 | 00:00:56 | 00:19:21 | 2 | 01:14:06
7556 | 56991 | [NAME] | Ojala | FIN | 0 | 00:22:03 | [NAME] | 00:30:24 | 00:01:34 | 00:19:47 | 3 | 01:14:30
7556 | 21080 | Natalya | Sushkova | RUS | 163 | 00:22:35 | [NAME] | [NAME] | 00:01:23 | 00:25:15 | 4 | 01:23:37
Spreadsheet: 734838d1622539634-matching-name-to-location-book5
Sheet: HR

Person System | Created | [NAME] | Approved | Subject | Location | Seniority | Primary Team | Primary Segment Focus | Date of Birth | Start Date | Years in school | Years in past time
Ceasar | 2021-05-11 13:58:55 |  | True | Maths | Zambia |  |  | N/A |  |  | 0 | 0
Matiya | 2021-05-05 22:53:42 |  | True | Technical drawing | [NAME] |  |  |  |  |  | 0 | 21
Moomba | 2021-05-05 22:52:23 |  | True | accounts | Angola |  |  |  |  |  | 0 | 0
[NAME] | 2021-05-05 22:51:09 |  | True | IT | DRC |  |  |  |  |  | 0 | 0
[NAME] | 2021-05-05 22:34:30 |  | True | Art | SA |  |  |  |  |  | 0 | 0
Mwansa | 2021-05-05 22:29:03 |  | False | Geography | Namibia |  |  |  |  |  | 0 | 0
Spreadsheet: 753849d1635786697-automatic-cell-population-from-another-tab-resource-overview
Sheet: Data Sheet

 |  | Project Type | Start Date | Skill Type | wk 1 | wk 2 | wk 3 | wk 4 | wk 5 | wk 6 | wk 7 | wk 8 | wk 9 | wk 10 | wk 11 | wk 12
 |  | Project X | 2021-11-01 00:00:00 | Skill 1 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project X |  | Skill 2 |  |  | 15 | 15 | 15 | 15
 |  | Project X |  | Skill 3 |  |  | 15 | 30 | 30
 |  | Project X |  | Skill 4 |  |  |  | 7.5 | 7.5
 |  | Project Y | 2021-11-06 00:00:00 | Skill 1 | 7.5 | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Y |  | Skill 2 |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5
 |  | Project Y |  | Skill 3 |  |  |  | 7.5 | 15 | 15 | 15 | 15
 |  | Project Y |  | Skill 4 |  |  |  | 7.5 | 15 | 15
 |  | Project Z | 2021-11-10 00:00:00 | Skill 1 | 7.5 | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15 | 7.5 | 7.5
 |  | Project Z |  | Skill 2 |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Z |  | Skill 3 |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Z |  | Skill 4 |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
Spreadsheet: 740169d1626205965-how-to-auto-populate-information-from-one-tab-to-the-other-moveuniquevalues-1-
Sheet: Sheet3

ID | Client | Date of Meeting | Units | Meeting Type | Duration | Entered | Counselor
33899 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
38877 | [NAME] | Over the Phone |  |  | 30 mins |  | [NAME]
54773 | [NAME] | In Person |  |  | 45 mins |  | [NAME]
80147 | Sacha Baron [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
91024 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
49371 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
31930 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
93600 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
31883 | Smothers Brothers[B] | Over the Phone |  |  | 60 mins |  | [NAME]
53724 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
51599 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
95631 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
69745 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
89418 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
78101 | [NAME] | Over the Phone |  |  | 60 mins |  | Hugo Egon
91966 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
88341 | Amber Riley | Over the Phone |  |  | 60 mins |  | [NAME]
33848 | [NAME] | In Person |  |  | 30 mins |  | [NAME]
23739 | [NAME] | Over the Phone |  |  | 45 mins |  | [NAME]
43135 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
25826 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
80559 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
47064 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
84667 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
20382 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
50915 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
68065 | Cooper Manning | Over the Phone |  |  | 60 mins |  | [NAME]
67507 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
33733 | [NAME] | Over the Phone |  |  | 30 mins |  | [NAME]
39903 | [NAME] | In Person |  |  | 45 mins |  | [NAME]
36003 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
99670 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
25465 | [NAME] | Over the Phone |  |  | 60 mins |  | [NAME]
53132 | [NAME] | In Person |  |  | 60 mins |  | [NAME]
Spreadsheet: 708119d1607618926-calculate-commission-against-target-spreadsheet-income-planner
Sheet: Sheet1

Income Planner 2021 |  | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov
[NAME] (12) |  | 4 | 4 | 5 | 5 | 5 | 4 | 0 | 0 | 3 | 4 | 4 | 4
2021 Commison Income Goal ($100,000)
Avg Sale Price ($500,000)
[NAME] showings(3)/sale
Assuming a 3% Commision/Sale and a split of 50% = 0.015
Ave SP                    Ave Comm
$500,000 x 0.15 = $7,500
$100,000 / $7,500 = 13.33 (sales needed |  | round up > |  | 14 sales
 |  |  |  | x3 unique showings
 |  |  |  | 42 showings needed per year
Spreadsheet: 189935d1351459148-dynamic-column-reverse-column
Sheet: Sheet1

 |  |  |  |  |  |  | http://www.excelforum.com/excel-general/871952-dynamic-column.html
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 56
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 11
Spreadsheet: 9581b9a5-bcde-4681-a278-b9ffc7f5904d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261673 | 56302 | [NAME] | Ferrarin | ITA | 14 | 00:21:02 | 00:01:20 | 00:38:16 | [NAME] | 00:10:07 | 1 | 01:12:11
261673 | 41151 | [NAME] | Wersy | FRA | 10 | 00:20:10 | 00:01:13 | 00:45:00 | 00:01:32 | 00:10:07 | 2 | 01:18:01
261673 | 58444 | [NAME] | [NAME] | FRA | 9 | 00:21:27 | 00:01:06 | 00:48:18 | 00:01:22 | 00:10:30 | 3 | 01:22:41
261673 | 39810 | Cedric | [NAME] | FRA | 12 | 00:21:46 | 00:01:17 | 00:45:37 | 00:01:41 | 00:12:42 | 4 | [NAME]
261673 | 72660 | [NAME] | Chipot | FRA | 11 | 00:41:57 | 00:01:07 | 00:53:08 | 00:01:26 | 00:21:19 | 5 | 01:58:55
Spreadsheet: 147223d1332613417-trying-to-insert-in-front-of-numbers-atest1
Sheet: Sheet1

DELIVERY DATE | Route # | STOP   1 | STOP   2 | STOP   3 | STOP   4 | CUBE 1 | CUBE 2 | CUBE 3 | CUBE 4
SAT-C
2012-03-24 00:00:00 | 7611 | 321 | 409 |  |  | 1541 | 17
 | 7612 | 139 | 453 | 212 |  | 290 | 976 | 322
 | 7613 | 139 |  |  |  | 1548
 | 7614 | 447 | 212 |  |  | 1170 | 610
 | 7615 | 458 | 467 |  |  | 632 | 725
 | 7616 | 214 | 447 |  |  | 1388 | 447
SUN A-B
 |  | *26 | 182
 |  | 244 | 182
 |  | 348
 |  | 329 | 515 | 559
 |  | 227 | 228
 |  | 329
 |  | 518
 |  | *83
 |  | 341
SUN C-D
2012-03-25 00:00:00 |  | 217
2012-03-25 00:00:00 |  | 223
2012-03-25 00:00:00 |  | 462 | 457
2012-03-25 00:00:00 |  | 450
2012-03-25 00:00:00 |  | *149
2012-03-25 00:00:00 |  | 154
2012-03-25 00:00:00 |  | 446 | 445
2012-03-25 00:00:00 |  | 568
2012-03-25 00:00:00 |  | 452
MON A-B
2012-03-25 00:00:00 |  | 231 | 473
2012-03-25 00:00:00 |  | 473
2012-03-25 00:00:00 |  | 239 | *83
2012-03-25 00:00:00 |  | 224 | 228
2012-03-25 00:00:00 |  | 522 | 515 | 590
2012-03-25 00:00:00 |  | 522 | 518
2012-03-25 00:00:00 |  | 219
2012-03-25 00:00:00 |  | 341
[NAME]
2012-03-26 00:00:00 |  | 2375 | 409
2012-03-26 00:00:00 |  | 214 | 321 | 287
2012-03-26 00:00:00 |  | *149
TUE A-B
 |  | 329 | 559
 |  | *26
 |  | 348
 |  | 227
 |  | *83 | 228
TUE C-D
2012-03-27 00:00:00 |  | 217 | 223
 |  | *139 | 453
 |  | 447 | 212
 |  | 458 | 467
 |  | 462 | 457
 |  | 446 | 445
 |  | 568
 |  | 450
 |  | 452
WED A-B
2012-03-27 00:00:00 |  | 244 | 473
 |  | 244 | 182
 |  | 231 | 239
 |  | 224
 |  | *83
 |  | 522 | 515
 |  | 590 | 522
 |  | 518
 |  | 219
 |  | 341
 |  | 154
[NAME]
2012-03-28 00:00:00 |  | 2375 | 409 | 287
2012-03-28 00:00:00 |  | 321 | 214 | 287
2012-03-28 00:00:00 |  | *149
THUR A-B
2012-03-28 00:00:00 |  | *26
 |  | 348 | 223
 |  | 329 | 559
 |  | 227
 |  | 228
 |  | *83
 |  | 219
THUR C-D
2012-03-29 00:00:00 |  | 217 | 223
 |  | *139 | 453
 |  | 462 | 450
 |  | 467 | 212
 |  | 447 | 458
 |  | 446 | 452
 |  | 568 | 445
 |  | 457
FRI A-B
2012-03-29 00:00:00 |  | 244 | 473
 |  | 244
 |  | 348
 |  | 231 | 182
 |  | 239
 |  | 228 | 227
 |  | 224
 |  | 228
 |  | *83
 |  | 515 | 522
 |  | 518 | 590
 |  | 518
 |  | 341
FRI C-D
2012-03-30 00:00:00 |  | 2375 | 409 | 287
 |  | 287 | *149
 |  | 450
 |  | 154
 |  | 446 | 450
 |  | 568
 |  | 452
SAT A-B
2012-03-30 00:00:00 |  | *26 | 473
 |  | 224 | 227
 |  | 228
 |  | 559 | 329
 |  | 590 | 518
 |  | 515 | 522
 |  | 522 | *83
 |  | 219
 |  | 341
WTD total
MTD total
YTD total
Spreadsheet: 2ae1ce8d-4347-48ae-a7e1-518cccbb86a6
Sheet: Table 2.3

Monthly Statistical Bulletin
2.3 Wage price index
Quarter | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Wage price index (a) (b) – index
September
December
March
June
Annual average
Quarterly change (b) – per cent
September
December
March
June
Annual change (b) – per cent
September
December
March
June
Annual average
(a) Total hourly rate of pay excluding bonuses, all sectors. Index base: 2008–09 = 100.0.
(b) Quarterly figures are seasonally adjusted.
Source: ABS, Wage Price Index, Australia, Cat. no. 6345.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=&
Note: Prior to September quarter 2012, this publication was known as Labour Price Index. The catalogue number (6345.0) remains unchanged.
 |  |  |  |  |  |  |  | Update
Spreadsheet: 686861d1594836761-xlookup-boolean-fail-xlookup-example
Sheet: Master

Code | Level | Start date | End date
DD14DSD7 | L1
DD14DSD7 | L2
DD28DSD7 | L3
DD28DSD7 | [NAME]
DPD20005 | Higher
Spreadsheet: 60024d1260541727-creating-if-function-for-blank-cells-example
Sheet: Sheet1

Invoice Number | Invoice Date | Invoice Amount
 |  | Chk#1000 | BEST BUY
1000 | 2009-10-01 00:00:00 | 100
1001 | 2009-10-02 00:00:00 | 101
1002 | 2009-10-03 00:00:00 | 102
1003 | 2009-10-04 00:00:00 | 103
1004 | 2009-10-05 00:00:00 | 104
1005 | 2009-10-06 00:00:00 | 105
1006 | 2009-10-07 00:00:00 | 106
1007 | 2009-10-08 00:00:00 | 107
 |  | Chk# 1001 | CIRCUIT CITY
1000 | 2009-10-01 00:00:00 | 100
1001 | 2009-10-02 00:00:00 | 101
1002 | 2009-10-03 00:00:00 | 102
1003 | 2009-10-04 00:00:00 | 103
1004 | 2009-10-05 00:00:00 | 104
1005 | 2009-10-06 00:00:00 | 105
1006 | 2009-10-07 00:00:00 | 106
1007 | 2009-10-08 00:00:00 | 107
Spreadsheet: 438398d1451973239-need-help-with-date-in-text-format-book15
Sheet: date

 |  |  |  |  | Type | Date | Num | Memo | Name | Qty | Sales Price | Amount | Balance
 | Stock
 |  | 060 (SAFETY SUPPLIES)
 |  |  |  |  | Invoice | 2015-01-01 00:00:00 | 9018 |  |  | 1 |  |  |  |  | 2015-01-01 00:00:00
 |  |  |  |  | [NAME] | 2015-02-02 00:00:00 | 320 |  |  | 1
 |  |  |  |  | Invoice | 2015-02-02 00:00:00 | 9376 |  |  | 3
 |  |  |  |  | Invoice | 2015-04-04 00:00:00 | 9652 |  |  | 1
 |  |  |  |  | Invoice | 04 14 2015 | 9728 |  |  | 1
 |  |  |  |  | Invoice | 04 17 2015 | 9752 |  |  | 6
 |  |  |  |  | Invoice | 04 17 2015 | 9756 |  |  | 1
 |  |  |  |  | Invoice | 05 07 2015 | 9878 |  |  | 1
 |  |  |  |  | Invoice | 07 14 2015 | 10323 |  |  | 2
 |  |  |  |  | Invoice | 09 15 2015 | 10685 |  |  | 2
 |  |  |  |  | Invoice | 10 05 2015 | 10778 |  |  | 4
 |  | Total 060 (SAFETY SUPPLIES) |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] used
 | Total Stock |  |  |  |  |  |  |  |  |  |  |  |  |  | Min used
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Normal use
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Re-order quantity | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Re- order period | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Re- order level
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Minimum level
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum level
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average level
Spreadsheet: 178967d1346966366-sumifs-formula-sumifs-example-modified-by-tigeravatar-
Sheet: Sheet1

Criteria range 1 | Criteria range 2 | Sum range
North | 1 | 4
North | 2 | 14
North | 3 | 58
North | 4 | 116
North | 5 | 48
South | 1 | 4
South | 2 | 14
South | 3 | 58
South | 4 | 116
South | 5 | 48
North | 1 | 1
North | 2 | 1
North | 3 | 9
North | 4 | 31
North | 5 | 19
criteria1: | criteria2: |  |  | SUMIFS Value: |  | Value should show:
North | 1
North | 2
Spreadsheet: 793392d1661444189-looking-for-help-on-min-function-returning-wrong-value-firsttimeuploadtest-dates-converted-aligw
Sheet: Sheet1

ID | CreatedDateTime |  | LeadID | Earliest Date
00Q5G00000a2BUP | 2022-02-16 16:21:00 |  | 00Q5G00000a2BUP
00Q5G00000a2C5A | 2022-02-11 16:21:00 |  | 00Q5G00000a2C5A
00Q5G00000a2kHI | 2022-06-21 12:01:00 |  | 00Q5G00000a2kHI
00Q5G00000a2m5v | 2022-04-07 10:51:00 |  | 00Q5G00000a2m5v
00Q5G00000a2mdW | 2022-03-21 10:45:00 |  | 00Q5G00000a2mdW
00Q5G00000a2wTy | 2022-05-27 09:53:00 |  | 00Q5G00000a2wTy
00Q5G00000a3fag | 2022-04-01 12:03:00 |  | 00Q5G00000a3fag
00Q5G00000a3fag | 2022-04-01 12:03:00 |  | 00Q5G00000a3oVM
00Q5G00000a3fag | 2022-04-05 14:00:00 |  | 00Q5G00000a3oXI
00Q5G00000a3fag | 2022-04-07 10:38:00 |  | 00Q5G00000a3pci
00Q5G00000a3fag | 2022-04-07 10:39:00 |  | 00Q5G00000a3ppT
00Q5G00000a3fag | 2022-04-11 09:53:00 |  | 00Q5G00000a3qh8
00Q5G00000a3fag | 2022-04-12 13:01:00 |  | 00Q5G00000a3tVV
00Q5G00000a3fag | 2022-04-14 15:01:00 |  | 00Q5G00000a3twH
00Q5G00000a3fag | 2022-04-18 13:51:00 |  | 00Q5G00000a3uiw
00Q5G00000a3fag | 2022-04-26 16:38:00 |  | 00Q5G00000a41fC
00Q5G00000a3fag | 2022-04-26 16:40:00 |  | 00Q5G00000a4DVS
00Q5G00000a3fag | 2022-04-26 16:40:00 |  | 00Q5G00000a4Lbw
00Q5G00000a3fag | 2022-04-28 16:36:00 |  | 00Q5G00000a5HW9
Spreadsheet: 135200d1325865796-finding-total-quantities-in-multiple-lines-of-data-usage-extract-060112
Sheet: Sheet1

CODE | CLIENT NAME | PDT | DATE | QTY
AB0120 | ABBEVILLE INSTRUMENT CONTROL LTD | ZKZCSGP0 | 2001-09-01 00:00:00 | 2 | KZC
AB0120 | ABBEVILLE INSTRUMENT CONTROL LTD | ZKZCSGP0 | 2001-09-01 00:00:00 | 2 | KZC
AB0700 | A.B.S. REFRACTORIES LIMITED | ZLV8Z700 | 2000-10-01 00:00:00 | 16 | LV8
AB0700 | A.B.S. REFRACTORIES LIMITED | ZLV8Z700 | 2000-10-01 00:00:00 | 16 | LV8
AB0700 | A.B.S. REFRACTORIES LIMITED | [NAME] | 2001-04-01 00:00:00 | 10 | C34
AB0700 | A.B.S. REFRACTORIES LIMITED | [NAME] | 2001-04-01 00:00:00 | 10 | C34
AB0700 | A.B.S. REFRACTORIES LIMITED | [NAME] | 2001-06-01 00:00:00 | 10 | C34
AB0700 | A.B.S. REFRACTORIES LIMITED | [NAME] | 2001-06-01 00:00:00 | 10 | C34
AB0700 | A.B.S. REFRACTORIES LIMITED | [NAME] | 2001-09-01 00:00:00 | 10 | C3A
AB0700 | A.B.S. REFRACTORIES LIMITED | ZLV8Z7C0 | 2001-09-01 00:00:00 | 20 | LV8
AB0700 | A.B.S. REFRACTORIES LIMITED | [NAME] | 2001-09-01 00:00:00 | 10 | C3A
AB0700 | A.B.S. REFRACTORIES LIMITED | ZLV8Z7C0 | 2001-09-01 00:00:00 | 20 | LV8
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2001-05-01 00:00:00 | 5 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2001-05-01 00:00:00 | 5 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2001-07-01 00:00:00 | 5 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZMH7S100 | 2001-07-01 00:00:00 | 50 | MH7
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2001-07-01 00:00:00 | 5 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZMH7S100 | 2001-07-01 00:00:00 | 50 | MH7
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2001-08-01 00:00:00 | 1 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2001-08-01 00:00:00 | 1 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2001-09-01 00:00:00 | 11 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2001-09-01 00:00:00 | 11 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK7FA20 | 2001-12-01 00:00:00 | 4 | LK7
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK7FA20 | 2001-12-01 00:00:00 | 4 | LK7
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2002-04-01 00:00:00 | 6 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK7FA20 | 2002-04-01 00:00:00 | 5 | LK7
AE0600 | A.E. TURBINE COMPONENTS LTD., | [NAME] | 2002-04-01 00:00:00 | 3 | LLH
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK6FA20 | 2002-04-01 00:00:00 | 6 | LK6
AE0600 | A.E. TURBINE COMPONENTS LTD., | ZLK7FA20 | 2002-04-01 00:00:00 | 5 | LK7
Spreadsheet: 759611d1639620129-get-numbers-based-on-a-cell-and-between-2-numbers-horizontaly-sample-13-
Sheet: Sheet1

OR Number Recorded
OR Number Recorded (sorted)
Missing
Spreadsheet: 0ad63ae7-b2d0-405e-94bf-70d9c1f48630
Sheet: Sheet1

STATE  OF  HAWAII | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
EXCESS  STATE  PROPERTY
This form is to be used for property that has a remaining useful life but is no longer required by the custodial
agency and is available for transfer to other State department or agency.  The item(s) will be consolidated
into the SPO, Excess State Property List, which is listed on the SPO web page on the 20th of each month.
This list will be active for 30 days, if no takers, the custodial agency shall follow the sequence for disposal
of surplus state property. Please submit this form by the 15th to be included in that months' listing.
Submit to  INVENTORY  MGT.  OFFICE,  Kalanimoku Bldg. Rm 416, 1151 Punchbowl St.,
 |  | Honolulu, HI. 96810, or FAX 586-0570
DEPARTMENT: |  |  |  |  |  | DATE:
DIVISION / AGENCY:
CONTACT PERSON: |  |  |  |  |  | PHONE NO.:
QTY | [NAME]  OF  PROPERTY |  |  |  |  | ACQ | ACQ | ISLAND
 | ( NOUN / MAKE / MODEL / SERIAL NUMBER ) |  |  |  |  | DATE | COST
SPO Form-19 (Rev.11/09)
Spreadsheet: 741429d1627039155-formula-to-return-a-true-false-if-date-equals-or-before-set-date-chaar-example
Sheet: Sheet1

 | Quotable 6 months window | Quotable 12 months window | Quotable 18 months window
CED | Quotable 6 months window | Quotable 12 months window | Quotable 18 months window
2023-09-30 00:00:00
2026-09-30 00:00:00
2022-10-31 00:00:00
2022-10-31 00:00:00
2022-09-30 00:00:00
2021-07-04 00:00:00
2021-12-01 00:00:00
2022-06-20 00:00:00
2022-10-31 00:00:00
Spreadsheet: 148865d1333581979-how-to-lookup-and-combine-multiple-rows-different-colums-when-duplicate-values-exist-example
Sheet: Sheet1

Project Name | Project Function | Consultant | 2012-04-06 00:00:00
Y | PD | AS | Y | Y | Y | Y | Y
 | PM | SB | Y | Y | Y | Y | Y
 | SPC | DS | Y | Y | Y | Y | Y
X |  | CC | Y | Y | Y | Y | Y | Y | Y
 |  | KB | Y | Y | Y | Y | Y | Y | Y
 |  | SS | Y | Y | Y | Y | Y | Y | Y
Z |  | AS |  |  |  |  |  | Y | Y | Y | Y | Y | Y
 |  | SB |  |  |  |  |  | Y | Y | Y | Y | Y | Y
 |  | DS |  |  |  |  |  | Y | Y | Y | Y | Y | Y
 |  | CC |  |  |  |  |  |  |  | Y | Y | Y | Y
 |  | KB |  |  |  |  |  |  |  | Y | Y | Y | Y
 |  | SS |  |  |  |  |  |  |  | Y |  | Y | Y