tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 22dfc1cb-173a-460e-81b4-407cd79d46a4
Sheet: Sheet1

SULLIVAN COUNTY OFFICES - Democratic | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2010-09-14 00:00:00 | Sheriff |  | Attorney |  | Treasurer
 | Prozzo, r | [NAME] | [NAME], r | Other | [NAME] | [NAME]
Acworth | 7 | 1 | 3 | 0 | 1 | 0
Charlestown | 17 | 4 | 7 | 0 | 24 | 7
Claremont Ward 1 | 42 | 3 | 6 | 4 | 2 | 4
Claremont Ward 2 | 53 | 4 | 17 | 3 | 4 | 4
Claremont Ward 3 | 45 | 4 | 10 | 0 | 3 | 2
Cornish | 4 | 3 | 2 | 2 | 36 | 3
Croydon | 2 | 0 | 1 | 0 | 0 | 0
Goshen | 4 | 4 | 3 | 1 | 1 | 0
Grantham | 2 | 3 | 3 | 1 | 25 | 6
Langdon | 3 | 0 | 3 | 0 | 5 | 1
Lempster | 4 | 3 | 2 | 1 | 1 | 2
Newport | 14 | 5 | 9 | 3 | 43 | 12
Plainfield | 0 | 4 | 1 | 1 | 2 | 2
Springfield | 3 | 0 | 3 | 1 | 0 | 1
Sunapee | 4 | 3 | 2 | 4 | 27 | 9
Unity | 14 | 4 | 7 | 2 | 1 | 2
Washington | 1 | 0 | 1 | 0 | 0 | 0
TOTALS | 219 | 45 | 80 | 23 | 175 | 55
 | Reg. Of Deeds |  |  |  | Reg. Of Probate
 | King, r | [NAME] |  |  | [NAME], r | [NAME]
Acworth | 2 | 1 |  |  | 2 | 0
Charlestown | 0 | 1 |  |  | 1 | 0
Claremont Ward 1 | 0 | 2 |  |  | 2 | 3
Claremont Ward 2 | 6 | 2 |  |  | 4 | 1
Claremont Ward 3 | 5 | 1 |  |  | 0 | 1
Cornish | 1 | 2 |  |  | 1 | 1
Croydon | 2 | 0 |  |  | 2 | 0
Goshen | 0 | 0 |  |  | 0 | 0
Grantham | 2 | 2 |  |  | 2 | 1
Langdon | 1 | 0 |  |  | 1 | 0
Lempster | 2 | 1 |  |  | 1 | 0
Newport | 4 | 6 |  |  | 4 | 3
Plainfield | 0 | 2 |  |  | 0 | 2
Springfield | 1 | 1 |  |  | 1 | 0
Sunapee | 0 | 4 |  |  | 1 | 2
Unity | 4 | 2 |  |  | 0 | 1
Washington | 1 | 0 |  |  | 1 | 0
TOTALS | 31 | 27 |  |  | 23 | 15
SULLIVAN COUNTY OFFICES - Democratic
 | COUNTY COMMISSIONERS
 | District No. 2 |  |  |  | Dist. 3
 | [NAME], r | [NAME] |  |  | Bell, d | [NAME], d | Callum, r
Acworth | - | - |  |  | 10 | 30 | -
Charlestown | 2 | 1 |  |  | 75 | 93 | -
Claremont Ward 1 | 1 | 3 |  |  | 63 | 71 | -
Claremont Ward 2 | 2 | 1 |  |  | 91 | 101 | -
Claremont Ward 3 | - | 2 |  |  | 59 | 90 | -
Cornish | - | 2 |  |  | 64 | 58 | -
Croydon | - | - |  |  | 17 | 15 | -
Goshen | - | - |  |  | 21 | 21 | -
Grantham | - | 3 |  |  | 89 | 115 | -
Langdon | - | 1 |  |  | 11 | 13 | -
Lempster | 1 | - |  |  | 12 | 21 | -
Newport | 3 | 4 |  |  | 107 | 96 | -
Plainfield | - | 3 |  |  | 67 | 68 | -
Springfield | 2 | - |  |  | 30 | 38 | 1
Sunapee | - | - |  |  | 82 | 65 | -
Unity | 2 | 3 |  |  | 29 | 54 | 1
Washington | 1 | - |  |  | 21 | 22 | -
TOTALS | 14 | 23 |  |  | 848 | 971 | 2
Spreadsheet: bill_williams_iii__1378__EOL 5-16
Sheet: EOL Deals

EOL Deals | From: 5/1/2001   To: 5/16/2001 |  |  | EnPower Deals | From: 5/1/2001   To: 5/16/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals |  |  |  |  |  |  |  | External Code | External Name | External ID
EPMI Long Term California | 1495600 | 75 |  | EPMI Long Term California | 1797775 | 44
EPMI Long Term Northwest | 1120400 | 60 |  | EPMI Long Term Northwest | 10006716 | 170
EPMI Long Term Southwest | 1968675 | 128 |  | EPMI Long Term Southwest | 5754700 | 121
EPMI Short Term California | 800736 | 770 |  | EPMI Short Term California | 1013426 | 394
EPMI Short Term Northwest | 233096 | 410 |  | EPMI Short Term Northwest | 302392 | 181
EPMI Short Term Southwest | 784504 | 707 |  | EPMI Short Term Southwest | 1407480 | 390
Grand Total | 6403011 | 2150 |  | Grand Total | 20282489 | 1300
EOL Deals | From: 5/16/2001   To: 5/16/2001 |  |  | EnPower Deals | From: 5/16/2001   To: 5/16/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 318000 | 20 |  | EPMI Long Term California | 215800 | 5
EPMI Long Term Northwest | 163600 | 8 |  | EPMI Long Term Northwest | 365600 | 8
EPMI Long Term Southwest | 223000 | 19 |  | EPMI Long Term Southwest | 184800 | 10
EPMI Short Term California | 71800 | 60 |  | EPMI Short Term California | 59584 | 28
EPMI Short Term Northwest | 16600 | 41 |  | EPMI Short Term Northwest | 31000 | 20
EPMI Short Term Southwest | 70600 | 77 |  | EPMI Short Term Southwest | 200000 | 46
Grand Total | 863600 | 225 |  | Grand Total
ICE [NAME] | From: 5/16/2001   To: 5/16/2001
Delivery Point | Total MWH | EPMI MWH | Price
Mid-Columbia (Next Day) | 400 | 400 | 185
Mid-Columbia (Jun-01) | 10400 | 0 | 300
[NAME] (Next Day) | 1600 | 0 | 146.25
[NAME] (Bal. Month) | 4400 | 0 | 231
[NAME] (Q3-01) | 30400 | 0 | 325
SP-15 (Next Day) | 1600 | 0 | 149.5
SP-15 (Bal. Month) | 4400 | 0 | 220
NP-15 ([NAME]) | 7600 | 0 | 130
SP-15 (Next Day Off Peak) | 800 | 0 | 46.25
Grand Total | 61600 | 400
Spreadsheet: 102523d1300450758-incremental-numbering-at-variable-intervals-of-rows-incremental-numbering-test
Sheet: Sheet1

Require formula to do incremental numbering in column A
1 | Invoice | 1090075 | 2009-07-30 00:00:00 | 2781.8
1 | Payment |  | 2009-07-30 00:00:00 | -2164.43
1 | Payment |  | 2009-07-30 00:00:00 | 617.37
1 | Payment |  | 2009-07-30 00:00:00 | 1547.06
1 | Payment |  | 2009-07-30 00:00:00 | -2781.8
2 | Invoice | 1090076 | 2009-07-30 00:00:00 | 477.94
2 | Payment |  | 2009-08-06 00:00:00 | -477.94
3 | Invoice | 1090230 | 2009-07-30 00:00:00 | 50.05
3 | Payment |  | 2009-08-06 00:00:00 | -50.05
4 | Invoice | 98685 | 2009-08-24 00:00:00 | -156.22
4 | Payment |  | 2009-09-02 00:00:00 | 156.22
5 | Invoice | 98686 | 2009-08-24 00:00:00 | -14.06
5 | Payment |  | 2009-09-02 00:00:00 | 14.06
6 | Invoice | 1090760 | 2009-08-03 00:00:00 | 1221.58
6 | Payment |  | 2009-08-06 00:00:00 | -854.64
6 | Payment |  | 2009-08-07 00:00:00 | -366.94
7 | Invoice | 1090933 | 2009-08-04 00:00:00 | 469.96
7 | Payment |  | 2009-08-07 00:00:00 | -469.96
8 | Invoice | 1091015 | 2009-08-05 00:00:00 | 2197.55
8 | Payment |  | 2009-08-07 00:00:00 | -1713.1
8 | Payment |  | 2009-08-10 00:00:00 | -484.45
9 | Invoice | 1091016 | 2009-08-05 00:00:00 | 701.01
9 | Payment |  | 2009-08-10 00:00:00 | -295.55
9 | Payment |  | 2009-08-13 00:00:00 | -405.46
Spreadsheet: 847078d1698166532-multiple-conditional-formatting-rules-applied-to-same-cell-geotech-major-project-schedule-2
Sheet: High-Level Overview

 |  |  |  | cells E8 - K8 are formatted - see rule in Conditional Formattting
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Display Week
 |  |  |  | September |  |  |  |  |  |  | September |  |  |  |  |  |  | September |  |  |  |  |  |  | September |  |  |  |  |  |  | October
 |  |  |  | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 |  |  | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 |  |  |  | 1900-01-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  | [NAME] | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa
 | [NAME] |  | R-38
 |  |  | R-42
 | Track Auger |  | R-35
 |  |  | R-39
 | Dual Rotary |  | R-54
 |  |  | R-68
 | [NAME] |  | R-41
 |  |  | R-43
 |  |  | R-46
 |  |  | R-53
 | Sonic LS 250 |  | R-45
 |  |  | R-49
Spreadsheet: kevin_hyatt__19692__Copper Eagle
Sheet: Sheet1

Copper Eagle Gas Storage
 | Monthly Fee
Storage Capacity MMBtu | 3200000
Rate (MMBtu/Month) | 0.3
Deliverability Volume
Rate (MMBtu/Month) | 0.7
Total Monthly Fee
Annual Fee
Injection Fee (12 cycles/yr) @ $.015
Withdrawal Fee @ $.015
Monthly Inj/WD fee
Annual Fee
Total Annual Storage Cost
Spreadsheet: kam_keiser__17854__quotesheet
Sheet: 12-10 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-10 13:08:15.770000 | Jan '02 | Natsource | Permian | Jan - Mar '02 | 10,000/d | -.16 @ -.145
2001-12-10 13:08:15.770000 | Jan '02 | Natsource | Waha | Jan - Mar '02 | 10,000/d | -.13 @
2001-12-10 13:08:15.770000 | Jan '02 | Natsource | HSC | Jan - Mar '02 | 10,000/d | -.0175 @ -.015
2001-12-10 13:08:15.770000 | Jan '02 | Natsource | HSC | Ap - Oct '02 | 10,000/d | +.03 @ .0325
2001-12-10 13:08:15.770000 | Jan '02 | Natsource | Waha | Ap - Oct '02 | 10,000/d | -.1125 @ -.105
2001-12-10 12:59:38.510000 | Jan '02 | APB | Permian | Jan - Mar '02 | 10,000/d | -.155 @ -.145
2001-12-10 12:59:38.510000 | Jan '02 | APB | Waha | Jan - Mar '02 | 10,000/d | -.1325 @ -.125
2001-12-10 12:59:38.510000 | Jan '02 | APB | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.015
2001-12-10 12:59:38.510000 | Jan '02 | APB | HSC | Cal '02 | 10,000/d | +.005 @ .0075
 | Jan '02 | Prebon | Permian | Jan - Mar '02 | 10,000/d | -.155 @ -.145
 | Jan '02 | Prebon | Waha | Jan - Mar '02 | 10,000/d | -.14 @ -.13
 | Jan '02 | Prebon | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.0175
 | Jan '02 | Prebon | HSC | Ap - Oct '02 | 10,000/d | +.03 @ .0325
 | Jan '02 | Prebon | HSC | Cal '03-06 | 10,000/d | 0 @ .005
 | Jan '02 | Prebon | Permian | Cal '03 | 10,000/d | -.13 @ -.12
 | Jan '02 | Prebon | Permian | Cal '04 | 10,000/d | -.11 @ -.10
Spreadsheet: 681854d1591790704-separate-mobile-number-in-another-cell-separatemobi
Sheet: Sheet1

CODE | NAME & ADDRESS | NEED MOBILE NUMBER |  |  | OFFICE ADDRESS | NEED MOBILE NUMBER
37021/9 | [NAME],PANAGADI ROAD,,MOOVENDAR SCHOOL(NEAR),SIVAGANGAI,0,[PHONE] |  | [NAME] | 4 | OWNER OF TATA AC, OMNI CAR,FARMER,,0, 0 |  |  |  |  | 1
37021/9 | MRSAMAYAMUTHU V,7/B LAJAPATHI RAY STREET,,SIVAGANGAI,,630561, 0 |  | [NAME] | 2 | [NAME],SIVAGANGAI,0, 0,[PHONE] |  |  |  |  | 1
37021/9 | MRRAVICHANDRAN N,ALLOOR,,BANGADI(PO),NATTARASANKOTTAI,SIVAGANGAI,0, 0 |  | MRRAVICHANDRAN N | 2 | CONDUCTOR,,TNSTC,DEVAKOTTAI,0, 0 |  |  |  |  | 1
37021/10 | MRSUTHAKARAN S,38C SURABHI APARTMENTS,,NEW DANIEL,[NAME] |  | MRSUTHAKARAN S | 4 | CHIT LIEN,53019/31,,0, 0 |  |  |  |  | 1
Spreadsheet: 822808d1679546973-formula-to-automatically-calculate-a-value-in-decimal-format-from-a-range-book1
Sheet: Sheet1

Look Up Value |  |  | Value | Range
99.25 |  |  | 100 | 50
 |  |  | 99 | 49
Return Value |  |  | 98 | 48
 |  |  | 97 | 47
 |  |  | 96 | 46
 |  |  | 95 | 45
 |  |  | 94 | 44
 |  |  | 93 | 43
 |  |  | 92 | 42
 |  |  | 91 | 41
 |  |  | 90 | 40
Spreadsheet: 113614d1309453485-lookup-function-search-2-columns-pull-date-from-3rd-vlookupexample-duplicate-data
Sheet: Table

digital | 2011-01-01 00:00:00 |  | 1
digital | 2011-02-01 00:00:00 |  | 2
magazine | 2011-01-01 00:00:00 |  | 3
magazine | 2011-02-01 00:00:00 |  | 4
magazine | 2011-03-01 00:00:00 |  | 5
magazine | 2011-03-01 00:00:00 |  | 7
Spreadsheet: 492036d1480793621-need-help-with-excel-rules-example-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Price | Code
 |  |  |  |  |  |  |  |  |  | 20 | 22222
 |  |  |  |  |  |  |  |  |  | 20 | 22222
 |  |  |  |  |  |  |  |  |  | 20 | 22222
 |  |  |  |  |  |  |  |  |  | 20 | 22222
 |  |  |  |  |  |  |  |  |  | 20 | 22222
 |  |  |  |  |  |  |  |  |  | 20 | 22222
 |  |  |  |  |  |  |  |  |  | 20 | 22222
 |  |  |  |  |  |  |  |  |  | 10 | 12345
 |  |  |  |  |  |  |  |  |  | 10 | 12345
 |  |  |  |  |  |  |  |  |  | 8 | 65432
 |  |  |  |  |  |  |  |  |  | 45 | 77788
 |  |  |  |  |  |  |  |  |  | 59 | 99999
 |  |  |  |  |  |  |  |  |  | 25 | 77777
 |  |  |  |  |  |  |  |  |  | 25 | 77777
 |  |  |  |  |  |  |  |  |  | 22 | 77777
 |  |  |  |  |  |  |  |  |  | 44 | 65892
 |  |  |  |  |  |  |  |  |  | 44 | 65892
 |  |  |  |  |  |  |  |  |  | 13 | 11111
 |  |  |  |  |  |  |  |  |  | 30 | 33333
 |  |  |  |  |  |  |  |  |  | 54 | 44444
 |  |  |  |  |  |  |  |  |  | 54 | 44444
 |  |  |  |  |  |  |  |  |  | 50 | 44444
 |  |  |  |  |  |  |  |  |  | 11 | 55544
 |  |  |  |  |  |  |  |  |  | 11 | 55544
 |  |  |  |  |  |  |  |  |  | 18 | 88448
 |  |  |  |  |  |  |  |  |  | 20 | 88448
 |  |  |  |  |  |  |  |  |  | 20 | 88448
 |  |  |  |  |  |  |  |  |  | 12 | 88448
Spreadsheet: 749908d1633092961-multiple-conditions-based-on-blanks-non-blanks-and-dates-test5
Sheet: Sheet1

Today
 |  |  |  |  |  |  | Fault Code | Date/Time Logged | Date/Time Completed | Deadline - manually added.  Time not specifically needed…just needs to be before the end of the date stated | Response Time (Hours) | Day in Which Call was Completed | Completed Within SLA? | Expected Result | Explanation
 |  |  |  |  |  |  | NF01 | 2021-09-30 08:50:00 | 2021-10-01 08:49:00 | 2021-10-01 23:59:00 |  |  |  | Yes | Should be YES because it's been closed before the end of the working day following the date in column I
 |  |  |  |  |  |  | NF01 | 2021-09-30 08:53:00 |  | 2021-10-01 23:59:00 |  |  |  |  | Should be blank because it hasn't been completed yet, and could still be completed within the deadline
 |  |  |  |  |  |  | NF01 | 2021-09-28 08:56:00 |  | 2021-09-29 23:59:00 |  |  |  | No | Should be NO because it hasn't been completed yet and we have surpassed the deadlije to complete by the end of the following working day
 |  |  |  |  |  |  | NF01 | 2021-09-30 08:54:00 |  | 2021-10-01 23:59:00 |  |  |  |  | Should be blank because it hasn't been completed yet, and could still be completed within the deadline
 |  |  |  |  |  |  | NF01 | 2021-09-30 09:07:00 | 2021-09-30 11:07:00 | 2021-10-01 23:59:00 |  |  |  | Yes | Should be YES bgecause it was completed before the end of the following working day
 |  |  |  |  |  |  | NF01 | 2021-09-30 09:07:00 |  | 2021-10-01 23:59:00 |  |  |  |  | Should be blank because it hasn't been completed yet, and could still be completed within the deadline
Spreadsheet: 155195d1336712854-excel-2007-using-if-and-row-copy-of-example-2
Sheet: Specific List

ID | COURSE | Section | Title | Enrollment |  | COURSE |  | ID | COURSE | Section | Title | Enrollment
9989 | PSYC-1001 | 1 | Psychology | 10 |  | PSYC-1001 |  | 8222 | PSYC-1001 | 2 | Psychology | 0
8878 | PSYC-8001 | 1 | Foundations | 22 |  | PSYC-8001 |  | 8227 | PSYC-1001 | 3 | Psychology | 0
6214 | COUN-6001 | 1 | Foundations of Coun | 11 |  | COUN-6001 |  | 4231 | PSYC-1001 | 4 | Psychology | 0
 |  |  |  |  |  |  |  | 3342 | PSYC-1001 | 5 | Psychology | 0
 |  |  |  |  |  |  |  | 2221 | PSYC-8001 | 2 | Foundations | 0
 |  |  |  |  |  |  |  | 4249 | PSYC-8001 | 3 | Foundations | 0
 |  |  |  |  |  |  |  | 4443 | PSYC-8001 | 4 | Foundations | 0
 |  |  |  |  |  |  |  | 4566 | PSYC-8001 | 5 | Foundations | 0
 |  |  |  |  |  |  |  | 5565 | PSYC-8001 | 6 | Foundations | 0
 |  |  |  |  |  |  |  | 5511 | COUN-6001 | 2 | Foundations of Coun | 0
 |  |  |  |  |  |  |  | 4221 | COUN-6001 | 3 | Foundations of Coun | 0
 |  |  |  |  |  |  |  | 4452 | COUN-6001 | 4 | Foundations of Coun | 0
 |  |  |  |  |  |  |  | 4423 | COUN-6001 | 5 | Foundations of Coun | 0
 |  |  |  |  |  |  |  | 6556 | COUN-6001 | 6 | Foundations of Coun | 0
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 108 | 441
2 | 136 | 441
3 | 78 | 441
4 | 84 | 441
5 | 81 | 441
6 | 78 | 441
7 | 49 | 441
8 | 35 | 441
9 | 35 | 441
10 | 1124 | 441
11 | 1826 | 88
12 | 309 | 88
13 | 726 | 88
14 | 1551 | 88
15 | 1261 | 88
16 | 386 | 88
17 | 33 | 88
18 | 56 | 88
19 | 86 | 88
20 | 3 | 88
21 | 536 | 88
22 | 648 | 88
23 | 639 | 88
24 | 355 | 88
25 | 37 | 88
26 | 5 | 88
27 | 309 | 88
28 | 517 | 88
29
30
31
2001-12-31 00:00:00 |  |  | 161292.49
2002-01-28 00:00:00
CBS Volume
 |  |  | 33971
Spreadsheet: 115366d1311007274-question-abotu-if-function-sample-index-match-2-columns
Sheet: Sheet1

Date | Performance | Code
2011-09-01 00:00:00 | Live
2011-12-01 00:00:00 | Staged
Spreadsheet: 29375d74-3dfd-4168-b361-4df2cb467d3a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Public Works
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 3090 |  | 897228 |  | B |  | 89004649 |  | 520000 |  | Inc
 |  | 3090 |  | 897228 |  | B |  | 89004650 |  | 520000 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 1040000
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 3090 |  | 897228 |  | 611060 |  | 89004649 |  | 520000 |  | Inc
 |  | 3090 |  | 897228 |  | 611060 |  | 89004650 |  | 520000 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 1040000
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET |  | 1040000
 |  | Appropriate grant revenue for signal projects.
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: a5e24688-dca5-4a28-8338-744c31043772
Sheet: Sheet1

State Senator - DEM (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/20/2013 12:48:43 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | write-in | TOTALS
1A | 37 | 0 | 37
1B | 71 | 0 | 71
2A | 41 | 0 | 41
2B | 39 | 0 | 39
Nedrose | 48 | 0 | 48
[NAME] | 39 | 0 | 39
[NAME] | 30 | 0 | 30
TOTAL | 305 | 0 | 305
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 550294d1512206957-comparing-3-values-example-20-
Sheet: Sheet1

 | [NAME] | 122 |  | [NAME] | 144 |  | [NAME] | 199
 | [NAME] | 190 |  | [NAME] | 200 |  | [NAME] | 120
 | [NAME] | 187 |  | [NAME] | 160 |  | [NAME] | 162
 | [NAME] | 100 |  | [NAME] | 100 |  | [NAME] | 100
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
Spreadsheet: 142562d1329913894-offset-match-vlookup-backwards-offsetmatch-example
Sheet: Sheet1

adCenter Campaign | adCenter Ad Group | Campaign | Ad Group | Keyword | Match Type | Bid | Keyword Param 1 | Status | Campaign | Ad Group
[NAME] | Trousers |  |  |  |  |  |  |  |  | Shirts
Womens | Skirts |  |  |  |  |  |  |  |  | Trousers
Childrens | Shirts |  |  |  |  |  |  |  |  | Skirts
Spreadsheet: 889110d1739816195-rank-top-x-values-in-target-table-based-on-multiple-criteria-excel-rank-example
Sheet: Sheet1

SOURCE TABLE
ID | Criteria1 | Criteria12 | Criteria2 | Criteria3 | Value
1234 | A1 |  | P1 | SegA | 1000
2341 | A1 |  | P3 | SegA | 25 | <== should appear in target table based on criteria 1-3
3411 | A3 |  | P4 | SegB | 75
1155 | A1 |  | P3 | SegA | 250 | <== should appear in target table based on criteria 1-3
2367 | A4 |  | P1 | SegB | 400
7891 | A1 |  | P1 | SegC | 33
Criteria | Value
Criteria1: | A1
Criteria2: | P3
Criteria3: | SegA
Column1 | Column2 |  | <== preferably dynamic, so could also be 5 or 10
Top | 3
TARGET/RESULT TABLE (the header of the table will be there and column names "ID" and "Value" are same as in source table)
ID | Value
1155 | 250 |  | <== value ranked from high to low
2341 | 25
n/a | n/a |  | <== since there are only 2 matches in source table, this 3rd preferably shows "n/a"
ID | Value
2341 | 25
1155 | 250
Spreadsheet: 48cb95f2-b06a-4d64-b619-d30d0a80eb17
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: June 19, 2013 (11:52 am)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 229371
Q1-2004 | 229175
Q2-2004 | 233474
Q3-2004 | 235336
Q4-2004 | 238105
Q1-2005 | 241837
Q2-2005 | 244380
Q3-2005 | 247183
Q4-2005 | 247443
Q1-2006 | 250954
Q2-2006 | 254990
Q3-2006 | 258328
Q4-2006 | 262731
Q1-2007 | 263776
Q2-2007 | 266272
Q3-2007 | 270025
Q4-2007 | 272054
Q1-2008 | 276013
Q2-2008 | 278199
Q3-2008 | 280692
Q4-2008 | 273583
Q1-2009 | 267567
Q2-2009 | 267416
Q3-2009 | 268461
Q4-2009 | 271132
Q1-2010 | 273221
Q2-2010 | 275247
Q3-2010 | 279408
Q4-2010 | 281844
Q1-2011 | 284136
Q2-2011 | 290132
Q3-2011 | 292370
Q4-2011 | 293684
Q1-2012 | 296657
Q2-2012 | 298058
Q3-2012 | 300019
Q4-2012 | 309146
Q1-2013 | 309286
Q2-2013 | X
Q3-2013 | X
Q4-2013 | X
Spreadsheet: 880467d1728268650-dynamic-lookup-with-multiple-criteria-npt-example
Sheet: NPT

 | Q-L-D |  |  |  | Q-D-L |  |  |  | L-D-Q |  |  |  | L-Q-D |  |  |  | D-L-Q |  |  |  | D-Q-L |  |  | Q-L-D
 | Men | Ladies |  |  | Men | Ladies |  |  | Men | Ladies |  |  | Men | Ladies |  |  | Men | Ladies |  |  | Men | Ladies
Q1 | 1 |  |  | Q1 | 1 |  |  | L1 | 1 |  |  | L1 | 1 |  |  | D1 | 1 |  |  | D1 | 1 |  |  | NPT's (Men)
Q2 |  | 2 |  | Q2 |  | 2 |  | L2 |  | 2 |  | L2 |  | 2 |  | D2 |  | 2 |  | D2 |  | 2 |  | NPT [NAME]
[NAME] | 3 |  |  | [NAME] | 3 |  |  | Lake 3 | 3 |  |  | Lake 3 | 3 |  |  | D3 | 3 |  |  | D3 | 3 |  |  | NPT Quarry 7
Q4 |  | 4 |  | Q4 |  | 4 |  | [NAME] |  | 4 |  | [NAME] |  | 4 |  | [NAME] |  | 4 |  | [NAME] |  | 4 |  | NPT Lake 8
Q5 | 5 |  |  | Q5 | 5 |  |  | L5 | 5 |  |  | L5 | 5 |  |  | D5 | 5 |  |  | D5 | 5 |  |  | NPT Dune 7
Q6 |  | 6 |  | Q6 |  | 6 |  | L6 |  | 6 |  | L6 |  | 6 |  | D6 |  | 6 |  | D6 |  | 6 |  | NPT's (Ladies)
[NAME] | 7 |  |  | [NAME] | 7 |  |  | L7 | 7 |  |  | L7 | 7 |  |  | [NAME] | 7 |  |  | [NAME] | 7 |  |  | NPT Lake 3
Q8 |  | 8 |  | Q8 |  | 8 |  | Lake 8 |  | 8 |  | Lake 8 |  | 8 |  | D8 |  | 8 |  | D8 |  | 8 |  | NPT Dune 4
Q9 | 9 |  |  | Q9 | 9 |  |  | L9 | 9 |  |  | L9 | 9 |  |  | D9 | 9 |  |  | D9 | 9
L1 |  | 10 |  | D1 |  | 10 |  | D1 |  | 10 |  | Q1 |  | 10 |  | L1 |  | 10 |  | Q1 |  | 10
L2 | 11 |  |  | D2 | 11 |  |  | D2 | 11 |  |  | Q2 | 11 |  |  | L2 | 11 |  |  | Q2 | 11
Lake 3 |  | 12 |  | D3 |  | 12 |  | D3 |  | 12 |  | [NAME] |  | 12 |  | Lake 3 |  | 12 |  | [NAME] |  | 12
[NAME] | 13 |  |  | [NAME] | 13 |  |  | [NAME] | 13 |  |  | Q4 | 13 |  |  | [NAME] | 13 |  |  | Q4 | 13
L5 |  | 14 |  | D5 |  | 14 |  | D5 |  | 14 |  | Q5 |  | 14 |  | L5 |  | 14 |  | Q5 |  | 14
L6 | 15 |  |  | D6 | 15 |  |  | D6 | 15 |  |  | Q6 | 15 |  |  | L6 | 15 |  |  | Q6 | 15
L7 |  | 16 |  | [NAME] |  | 16 |  | [NAME] |  | 16 |  | [NAME] |  | 16 |  | L7 |  | 16 |  | [NAME] |  | 16
Lake 8 | 17 |  |  | D8 | 17 |  |  | D8 | 17 |  |  | Q8 | 17 |  |  | Lake 8 | 17 |  |  | Q8 | 17
L9 |  | 18 |  | D9 |  | 18 |  | D9 |  | 18 |  | Q9 |  | 18 |  | L9 |  | 18 |  | Q9 |  | 18
D1 | 19 |  |  | L1 | 19 |  |  | Q1 | 19 |  |  | D1 | 19 |  |  | Q1 | 19 |  |  | L1 | 19
D2 |  | 20 |  | L2 |  | 20 |  | Q2 |  | 20 |  | D2 |  | 20 |  | Q2 |  | 20 |  | L2 |  | 20
D3 | 21 |  |  | Lake 3 | 21 |  |  | [NAME] | 21 |  |  | D3 | 21 |  |  | [NAME] | 21 |  |  | Lake 3 | 21
[NAME] |  | 22 |  | [NAME] |  | 22 |  | Q4 |  | 22 |  | [NAME] |  | 22 |  | Q4 |  | 22 |  | [NAME] |  | 22
D5 | 23 |  |  | L5 | 23 |  |  | Q5 | 23 |  |  | D5 | 23 |  |  | Q5 | 23 |  |  | L5 | 23
D6 |  | 24 |  | L6 |  | 24 |  | Q6 |  | 24 |  | D6 |  | 24 |  | Q6 |  | 24 |  | L6 |  | 24
[NAME] | 25 |  |  | L7 | 25 |  |  | [NAME] | 25 |  |  | [NAME] | 25 |  |  | [NAME] | 25 |  |  | L7 | 25
D8 |  | 26 |  | Lake 8 |  | 26 |  | Q8 |  | 26 |  | D8 |  | 26 |  | Q8 |  | 26 |  | Lake 8 |  | 26
D9 | 27 |  |  | L9 | 27 |  |  | Q9 | 27 |  |  | D9 | 27 |  |  | Q9 | 27 |  |  | L9 | 27