tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 144998d1331245119-is-it-possible-to-merge-consistent-date-ranges-sample-attached-datemerging-sample
Sheet: Sheet1

Employee ID | Job Number | StartDate | EndDate |  | EmployeeID | JobNumber | StartDate | EndDate
1234 | 8603968 | 2011-05-30 00:00:00 | 2011-11-30 00:00:00 |  | 1234 | 8603968 | 2011-05-30 00:00:00 | 2012-12-31 00:00:00
1234 | 8603968 | 2011-12-01 00:00:00 | 2011-12-25 00:00:00 |  | 500 | 8603345 | 2008-11-05 00:00:00 | 2012-12-31 00:00:00
1234 | 8603968 | 2011-12-26 00:00:00 | 2012-02-19 00:00:00 |  | 640 | 8600460 | 2008-02-02 00:00:00 | 2012-12-31 00:00:00
1234 | 8603968 | 2012-02-20 00:00:00 | 2012-12-31 00:00:00 |  | 250 | 8601506 | 2011-04-04 00:00:00 | 2011-10-02 00:00:00
500 | 8603345 | 2008-11-05 00:00:00 | 2012-12-31 00:00:00 |  | 250 | 8609576 | 2011-10-03 00:00:00 | 2012-12-31 00:00:00
640 | 8600460 | 2008-02-02 00:00:00 | 2012-12-31 00:00:00 |  | 200 | 861586 | 2011-12-12 00:00:00 | 2012-12-31 00:00:00
250 | 8601506 | 2011-04-04 00:00:00 | 2011-10-02 00:00:00
250 | 8609576 | 2011-10-03 00:00:00 | 2012-12-31 00:00:00
200 | 861586 | 2011-12-12 00:00:00 | 2012-06-10 00:00:00
200 | 861586 | 2012-06-11 00:00:00 | 2012-12-31 00:00:00
Spreadsheet: kim_ward__20784__West Marketing List TopProducers 012901
Sheet: MKTR-Pipe-Other

Company | Type | Primary Gas  Contact | Phone | Address | City | State
NW Pipeline Transport | Pipeline |  | [PHONE] |  | Salt Lake City | UT
Transwestern Pipeline Company | Pipeline
[NAME], Salt Lake City, UT | Pipeline | [NAME] |  | [NAME] | Reno | NV
[NAME] | Marketer |  | [PHONE]
Cook Inlet Energy Corp. | Marketer |  | [PHONE] |  | Los Angeles | CA
Dynegy | Marketer |  | 5976 West Las Positas Boulevard, Suite 200 |  |  | CA
Engage Energy | Marketer |  | [PHONE] |  | Bellvue | WA
Boulder City | Tribal Utility |  | [PHONE] |  | Boulder City | NV
Lincoln Electric | Tribal Utility
Navajo Tribal Authority | Tribal Utility |  | [PHONE] |  | Ft. Defiance | AZ
Overton Power District No. 5 | Tribal Utility |  | 702- 397-2512 |  | Overton | NV
ABAG | undefined |  | [PHONE] |  | Oakland | CA
Asarco | undefined |  | [PHONE] |  | Tucson | AZ
Colorado Energy | undefined |  | [PHONE] |  | Boulder | CO
Commercial Energy of Montana | undefined |  | [PHONE] |  | Cut Bank | MT
Commision Federal De Electricidad | undefined |  | 0115265-58-15-04 | [NAME] 45360 | Calexico | CA
Commonwealth Energy | undefined |  | [PHONE] |  | [NAME] | CA
Constellation Energy | undefined |  | [PHONE]
Edison Source | undefined |  | [PHONE]
ESCO Corporation | undefined |  | [PHONE] |  | Portland | OR
Foras Energy, Inc. | undefined |  | 619/329-4460 |  | North Palm Springs | CA
Forest Energy Company | undefined |  | [PHONE] |  | Larkspur | CA
Golden Energy Services, Inc. | undefined |  | [PHONE] |  | Golden | CO
GWF Power | undefined |  | [PHONE] |  | Pittsburgh | CA
[NAME] | undefined |  | [PHONE] |  | Portland | OR
IGI Resources, Inc. | undefined |  | [PHONE] |  | Boise | ID
Keystone Energy | undefined |  | [PHONE] |  | Los Angeles | CA
Kings River Water | undefined |  | [PHONE]
Martinez Energy Partners | undefined |  | [PHONE] |  | Martinez | CA
Mercator Energy | undefined |  | [PHONE]
[NAME] | undefined
Mission Energy | undefined |  | [PHONE] |  | [NAME] | CA
New Energy Services | undefined |  | [PHONE] |  | Los Angeles | CA
New West Energy | undefined |  |  |  | San Diego | CA
O.L.S Energy Co. | undefined
Oxbow Power Corp Pacific Energy- | undefined |  | [PHONE] |  | Redding | CA
Oxbow Power Corp Pacific Energy- | undefined |  | [PHONE] |  | Reno | NV
Plains Electric Generation & Transmission Cooperative, Inc. | undefined |  | 505- 889-7400 |  | Albuquerque | NM
Plum Creek | undefined |  | [PHONE] |  | [NAME] | MT
Plumas-Sierra Rec | undefined |  | [PHONE] |  | [NAME] | CA
Sanger Energy | undefined
Sithe Energies | undefined
Sterling Natural Gas | undefined
Tosco Refining Company | undefined |  | [PHONE] |  | Rodeo | CA
UAE Energy Operations Corp | undefined |  | [PHONE] |  | San Ramon | CA
[NAME] | undefined |  | [PHONE] |  | Sacramento | CA
Spreadsheet: 733808d1621838979-index-formula-search-in-different-sheet-testalles3-ans2
Sheet: Afspraken

klant | datum | [NAME] OD68TV | naar | kosten rdw | af onthef | af beg | aangevraagd | [NAME] | afmeting
wd | 2021-04-05 00:00:00 | altforst |  | 246 | 289 | 225 | nee | nee |  | 1
wd | 2021-04-19 00:00:00 | cadzand |  | 277 |  |  | ja | ja
klooster | 2021-04-21 00:00:00 | deventer |  | 237 | 300 | 750 | nee | nee |  | dit is voorgesteld 16 uur aan begeleiding
klooster |  | christiaan |  | 253 | 300 | 700 | nee | nee |  | 15 uur aan begeleiding
klooster |  | sportstraat |  | 253 | 300 | 500 | nee | nee |  | 11 uur aan begeleding [NAME] stuk
hoogland | 2021-04-21 00:00:00 | [NAME] | [NAME] | 205 | 230 |  | ja | ja
wd |  | [NAME] 22 alkmaar | dalmhorsterweg 1a, Giethmen | 221 | 246 | 200 | ja | nee
wd | 2021-04-22 00:00:00 | berkhout | almere | 246 |  | 200 | ja | ja |  | 1 begeleider 2 x minimum
wd | 2021-05-02 00:00:00 | moergestel |  | 189 | 214 |  | nee | nee |  | 1x minimumtarief
wd | 2021-05-02 00:00:00 | europoort | harderwijk | 173 |  | 200 | ja | ja |  | 2x minimum
wd | 2021-05-04 00:00:00 | de hork 17 cuijk | heideweg 4, molenschot | 205 | 230 | 200 | nee | nee | 12.90x4.25x430o.a.
hoogland | 2021-05-05 00:00:00 | 5 jaar belgie |  | 300 |  |  | nee | nee
wd | 2021-05-08 00:00:00 | eurovignet |  |  |  | 132 | ja | ja
wd | 2021-05-16 00:00:00 | eck en wiel | lekku | 461 | 500 | 360 | nee | nee | 400x455 hoog | 2x begeleider 8 uur binnendoor
hoogland | 2021-05-19 00:00:00 | [NAME] |  | 155 |  |  | ja | ja
hoogland | 2021-05-19 00:00:00 | [NAME] |  | 155 |  |  | ja | ja
hoogland | 2021-05-19 00:00:00 | [NAME] |  | 155 |  |  | ja | ja
hoogland | 2021-05-19 00:00:00 | [NAME] |  | 155 |  |  | ja | ja
Spreadsheet: 736901d1623937533-hi-all-how-can-i-use-multiple-arguments-in-the-if-formula-new-customer-setup-request-responses-1-
Sheet: Form responses 1

Country |  |  |  |  |  |  |  | Other
Germany |  |  | Germany
Great Britain |  |  |  | Great Britain
Poland |  |  |  |  | Poland
Switzerland |  |  |  |  |  | Switzerland
Belgium |  | Belgium
Other
Wakanda
Spreadsheet: 688613d1595867458-update-formula-in-a-different-sheet-while-adding-rows-test
Sheet: Sheet2

tot |  | [NAME] |  | how many positive
Spreadsheet: 45698d1244532670-find-value-matching-multiple-text-criteria-and-max-date-findmaxdate
Sheet: Soluction

Date | Category | Currnecy | Exchag Rate
2009-03-01 00:00:00 | A | USD | 1
2009-06-01 00:00:00 | A | EUR | 9
2009-06-01 00:00:00 | A | USD | 2
2009-08-01 00:00:00 | A | USD | 25
2009-05-01 00:00:00 | A | EUR | 2
 | 25
 |  | [NAME]
A | USD | 25
A | EUR | 9
Spreadsheet: 35442d1233048690-countifs-setting-multiple-criteria-exccelforumhelp
Sheet: Sheet1

1-10 | 11-20 | 21-30 | 31-40 | 41-49 |  | 1-10 | 11-20 | 21-30 | 31-40 | 41-49 |  | Frequency
1 | 2 | 0 | 1 | 2 |  | 6
1 | 1 | 0 | 2 | 2 |  |  | 6
1 | 1 | 2 | 1 | 1 |  |  |  | 6
1 | 2 | 2 | 0 | 1 |  |  |  |  | 6
3 | 1 | 1 | 1 | 0 |  |  |  |  |  | 6
0 | 2 | 0 | 2 | 2 |  | 5 | 1
2 | 2 | 0 | 0 | 2 |  | 5 |  | 1
0 | 2 | 1 | 1 | 2 |  | 5 |  |  | 1
1 | 1 | 2 | 0 | 2 |  | 5 |  |  |  | 1
2 | 1 | 3 | 0 | 0 |  | 1 | 5
2 | 1 | 1 | 1 | 1 |  |  | 5 | 1
1 | 2 | 2 | 1 | 0 |  |  | 5 |  | 1
 |  |  |  |  |  |  | 5 |  |  | 1
 |  |  |  |  |  | 1 |  | 5
 |  |  |  |  |  |  | 1 | 5
 |  |  |  |  |  |  |  | 5 | 1
 |  |  |  |  |  |  |  | 5 |  | 1
 |  |  |  |  |  | 1 |  |  | 5
 |  |  |  |  |  |  | 1 |  | 5
 |  |  |  |  |  |  |  | 1 | 5
 |  |  |  |  |  |  |  |  | 5 | 1
 |  |  |  |  |  | 1 |  |  |  | 5
 |  |  |  |  |  |  | 1 |  |  | 5
 |  |  |  |  |  |  |  | 1 |  | 5
 |  |  |  |  |  |  |  |  | 1 | 5
 |  |  |  |  |  | 4 | 2
 |  |  |  |  |  | 4 |  | 2
 |  |  |  |  |  | 4 |  |  | 2
 |  |  |  |  |  | 4 |  |  |  | 2
 |  |  |  |  |  | 2 | 4
 |  |  |  |  |  |  | 4 | 2
 |  |  |  |  |  |  | 4 |  | 2
 |  |  |  |  |  |  | 4 |  |  | 2
 |  |  |  |  |  | 2 |  | 4
 |  |  |  |  |  |  | 2 | 4
 |  |  |  |  |  |  |  | 4 | 2
 |  |  |  |  |  |  |  | 4 |  | 2
 |  |  |  |  |  | 2 |  |  | 4
 |  |  |  |  |  |  | 2 |  | 4
 |  |  |  |  |  |  |  | 2 | 4
 |  |  |  |  |  |  |  |  | 4 | 2
 |  |  |  |  |  | 2 |  |  |  | 4
 |  |  |  |  |  |  | 2 |  |  | 4
 |  |  |  |  |  |  |  | 2 |  | 4
 |  |  |  |  |  |  |  |  | 2 | 4
 |  |  |  |  |  | 4 | 1 | 1
Spreadsheet: 166830d1341830188-formula-to-evaluate-performance-vs-targets-excel-forum
Sheet: Sheet3

 |  |  | Product Portfolio |  | 118
 |  |  |  | % Required | Target | Actual | DTG | % Achieved
 |  |  | Product A | 0.25 |  | 0
 |  |  | Product B | 1 |  | 0
 |  |  | Product C | 0.5 |  | 0
Spreadsheet: 202831d1356743005-combining-multiple-rows-into-one-row-sample-document-2
Sheet: Original Data

last 4 of SSN | Full Name | school_code | term_begin | term_end | School Rep Name | [NAME]
1111 | [NAME] | 00104600 | 082012 | 082016 | school rep | [EMAIL]
2222 | [NAME] | 00104600 | 082012 | 082016 | school rep | [EMAIL]
3333 | justin justin | 00104600 | 082012 | 082014 | school rep | [EMAIL]
4444 | [NAME] | 00104600 | 082012 | 082016 | school rep | [EMAIL]
5555 | [NAME] | 00104600 | 082012 | 082016 | school rep | [EMAIL]
6666 | [NAME] | 00252600 | 082012 | 082016 | school rep | [EMAIL]
7777 | [NAME] | 00252600 | 082012 | 082016 | school rep | [EMAIL]
8888 | [NAME] | 00652500 | 082012 | 082014 | school rep | [EMAIL]
9999 | molly moly | 00652500 | 082012 | 082016 | school rep | [EMAIL]
Spreadsheet: 38517d1236687293-choose-ytd-and-month-figures-test
Sheet: P&L Analysis

Profit & Loss Account
 |  |  |  |  |  | Year to date |  |  | Full Year
 |  | Nominal lookup | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Budget | Forecast
Income
Sales
Parts
Labour
MOT
Sundries
Direct Costs
Parts
MOT
Consumables
Waste removal
Customer petrol
Carriage
Indirect Costs
Salaries
General Management
Finance
Depreciation
Profit/(Loss)
Profit Analysis |  |  |  |  | GP |  |  | GP
Parts
MOT
Sundries
Labour
Notes & Commentary
Commentary based on budget version 19jan09
Spreadsheet: 789626d1659251086-vlookup-and-conditional-formatting-for-multiple-values-staff-attendance-holiday-planner-cf-staff-leave-record-forum-help-aligw
Sheet: Holidays

Holiday | Date
一月一日 | 2022-01-01 00:00:00
農曆年初一 | 2022-02-01 00:00:00
農曆年初二 | 2022-02-02 00:00:00
農曆年初三 | 2022-02-03 00:00:00
清明節 | 2022-04-05 00:00:00
耶穌受難節 | 2022-04-15 00:00:00
耶穌受難節翌日 | 2022-04-16 00:00:00
復活節星期一 | 2022-04-18 00:00:00
勞動節翌日 | 2022-05-02 00:00:00
佛誕翌日 | 2022-05-09 00:00:00
端午節 | 2022-06-03 00:00:00
香港特別行政區成立紀念日 | 2022-07-01 00:00:00
中秋節後第二日 | 2022-09-12 00:00:00
國慶日 | 2022-10-01 00:00:00
重陽節 | 2022-10-04 00:00:00
聖誕節後第一個周日 | 2022-12-26 00:00:00
聖誕節後第二個周日 | 2022-12-27 00:00:00
一月一日翌日 | 2023-01-02 00:00:00
農曆年初二 | 2023-01-23 00:00:00
農曆年初三 | 2023-01-24 00:00:00
農曆年初四 | 2023-01-25 00:00:00
清明節 | 2023-04-05 00:00:00
耶穌受難節 | 2023-04-07 00:00:00
耶穌受難節翌日 | 2023-04-08 00:00:00
復活節星期一 | 2023-04-10 00:00:00
勞動節 | 2023-05-01 00:00:00
佛誕 | 2023-05-26 00:00:00
端午節 | 2023-06-22 00:00:00
香港特別行政區成立紀念日 | 2023-07-01 00:00:00
中秋節翌日 | 2023-09-30 00:00:00
國慶日翌日 | 2023-10-02 00:00:00
重陽節 | 2023-10-23 00:00:00
聖誕節 | 2023-12-25 00:00:00
聖誕節後第一個周日 | 2023-12-26 00:00:00
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  | 1110 | 1243 | 1812 | 1669
2 |  |  |  |  | 1157 | 1277 | 1766 | 1699
3 |  |  |  |  | 1153 | 1277 | 1747 | 1699
4 |  |  |  |  | 1126 | 1277 | 1721 | 1699
5 |  |  |  |  | 1126 | 1277 | 1704 | 1699
6 |  |  |  |  | 1125 | 1277 | 1686 | 1699
7 |  |  |  |  | 1115 | 1277 | 1674 | 1699
8 |  |  |  |  | 1105 | 1277 | 1660 | 1699
9 |  |  |  |  | 1078 | 1277 | 1649 | 1699
10 |  |  |  |  | 1079 | 1277 | 1620 | 1699
11 |  |  |  |  | 998 | 1277 | 1605 | 1699
12 |  |  |  |  | 1134 | 639 | 851 | 1699
13 |  |  |  |  | 1072 | 1277 | 1554 | 1699
14 |  |  |  |  | 1064 | 1277 | 1078 | 1699
15 |  |  |  |  | 1054 | 1277 | 1027 | 1699
16 |  |  |  |  | 912 | 1277 | 1 | 1699
17 |  |  |  |  | 1057 | 1277 |  | 1699
18 |  |  |  |  | 1095 | 1277 |  | 1699
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  |  |  |  |  | 348785.29
2001-07-18 00:00:00
Spreadsheet: 61884d1262793446-finding-subtotal-row-when-it-changes-subtotal-example
Sheet: Result

A | B | Customer # | Customer Name | Customer Type | Sales person | Invoice# | Col H | Col I | Col J | Col K | Col L | Col M | Col N | Col O | Col P | Col Q | Col R | Col S | Col T | Col U | Col V | Col W | Col X | Col Y | Col Z | Col AA | Col AB
1 | 2 | 123 | Customer 1 | A | 111 | 1111111 | 9 | 1210 | 1036650 | 1 | 1 | A | 0 | 1 | 1490 | 0.4221503 | 1400 |  |  | CD | 9 | 226
1 | 2 | 456 | Customer 2 | A | 111 | 1111112 | 9 | 1210 | 1036650 | 1 | 10 | B | 41.5 | 2 | 1490 | 0.4221503 | 1465 |  |  | CD | 9 | 226
 |  |  |  |  | 111 Total |  |  |  |  |  |  |  |  |  | 2980 |  | 2865 |  |  |  |  |  | 0.45 | 1639 | 1226 | 0.25 | 306.5
2 | 3 | 789 | Customer 3 | A | 222 | 1111113 | 9 | 1214 | 1043485 | 0 | 6 | C | 118 | 1 | 118 | 0.5710435 | 50.62 |  |  | CD | 9 | 415
2 | 3 | 789 | Customer 3 | A | 222 | 1111114 | 9 | 1229 | 1093668 | 0 | 128 | D | 1333 | 1 | 1333 | 0.4669069 | 710.61 |  |  | CD | 9 | 1229
2 | 3 | 789 | Customer 3 | A | 222 | 1111115 | 9 | 1229 | 1093668 | 0 | 188 | E | 2739 | 1 | 2739 | 0.4669069 | 1460.14 |  |  | CD | 9 | 1229
2 | 3 | 654 | Customer 4 | A | 222 | 1111116 | 9 | 1229 | 1093668 | 0 | 189 | F | 1379 | 1 | 1379 | 0.4669069 | 735.14 |  |  | CD | 9 | 1229
2 | 3 | 654 | Customer 4 | A | 222 | 1111117 | 9 | 1229 | 1093668 | 0 | 190 | G | 2091 | 1 | 2091 | 0.4669069 | 1114.7 |  |  | CD | 9 | 1229
2 | 3 | 654 | Customer 4 | A | 222 | 1111118 | 9 | 1229 | 1093668 | 0 | 191 | H | 110 | 1 | 110 | 0.4669069 | 58.64 |  |  | CD | 9 | 1229
2 | 4 | 987 | Customer 5 | A | 222 | 1111119 | 9 | 1229 | 1093668 | 0 | 192 | I | 1024 | 1 | 1024 | 0.4669069 | 545.89 |  |  | CD | 9 | 1229
 |  |  |  |  | 222 Total |  |  |  |  |  |  |  |  |  | 8794 |  | 4675.740000000001 |  |  |  |  |  | 0.489 | 4493.734 | 182.0060000000003 | 0.25 | 45.50150000000008
2 | 4 | 543 | Customer 6 | A | 333 | 1111120 | 9 | 1201 | 1086452 | 0 | 1 | J | 776.25 | 1 | 1333 | 0 | 1100 |  |  | CD | 9 | 1030
2 | 4 | 543 | Customer 6 | A | 333 | 1111121 | 9 | 1216 | 1092573 | 0 | 1 | K | 776.25 | -1 | 2739 | 0 | 2300 |  |  | CD | 9 | 1216
 |  |  |  |  | 333 Total |  |  |  |  |  |  |  |  |  | 4072 |  | 3400 |  |  |  |  |  | 0.473 | 2145.944 | 1254.056 | 0.25 | 313.5139999999999
1 | 5 | 876 | Customer 7 | A | 444 | 1111122 | 9 | 1222 | 1093218 | 0 | 1 | L | 1766 | -1 | 1379 | 0 | 1250 |  |  | CD | 9 | 1222
1 | 5 | 678 | Customer 8 | A | 444 | 1111123 | 9 | 1222 | 1093218 | 0 | 2 | M | 1766 | 1 | 2091 | 0.9999999 | 1820 |  |  | CD | 9 | 1222
 |  |  |  |  | 444 Total |  |  |  |  |  |  |  |  |  | 3470 |  | 3070 |  |  |  |  |  | 0.45 | 1908.5 | 1161.5 | 0.25 | 290.375
 |  |  |  |  | Grand Total |  |  |  |  |  |  |  |  |  | 19316 |  | 14010.74
Spreadsheet: 68841d1269378559-index-match-with-multiple-conditions-database-test
Sheet: Event Index

 | Event | Cost
 | Frpo Party | 100
 | Florida | 3400
 | Golf - Summer | 850
 | Golf - Spring | 850
 | Golf - Fall | 850
 | Hockey Outing | 950
 | Hockey Tickets | 450
 | Spa Day | 420
 | [NAME] | 85
 | Dinner | 350
 | Client Rating
 | Response | Amount
 | A+ | 275
 | A | 150
 | B | 125
 | C | 32
 | D | 16
 | E | 0
Spreadsheet: 240050d1370162956-populate-table-based-on-drop-down-selection-excel_filter
Sheet: Sheet2

customer | date | number
a | 2000-01-01 00:00:00 | 1
a | 2000-01-02 00:00:00 | 5
b | 2000-01-03 00:00:00 | 2
d | 2000-01-04 00:00:00 | 4
e | 2000-01-05 00:00:00 | 2
f | 2000-01-06 00:00:00 | 2
f | 2000-01-07 00:00:00 | 4
a | 2000-01-08 00:00:00 | 2
b | 2000-01-09 00:00:00 | 8
g | 2000-01-09 00:00:00 | 11
h | 2000-01-09 00:00:00 | 1
Spreadsheet: 691870d1597927789-fetching-value-from-another-sheet-for-next-9-months-if-the-month-changes-testing-d1
Sheet: Main

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for data validation in G3
 |  |  |  |  | Month | 2021-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  | TYPE 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  | A | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  | B |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00
 |  |  |  |  | C |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00
 |  |  |  |  | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00
 |  |  |  |  | E | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00
 |  |  |  |  | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00
 |  |  |  |  | TYPE 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  | X | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  | Y |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  | 2021-09-01 00:00:00
 |  |  |  |  | Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  | If I select G3 as November , [NAME] and G14 Should become November , and next 9 month should be december , jan, feb and so on |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  | and values should be referenced for these months from REFERENCE sheet in their respective months
Spreadsheet: chris_germany__2916__1999_2000 Winter Oil Orders
Sheet: FEBRUARY 2000

Gordonsville Energy LP   (L.S. #2 FUEL OIL ORDERS)
2000-02-01 00:00:00 |  |  | Cost per Gal. Deliv. Excluding VA tax |  |  | Cost per Gal. Deliv. Excluding VA tax | Updated 2/23/2000 |  | Cost per Gal. Deliv. Excluding VA tax
DATE | BP AMOCO                       ORDERS | Order number |  | [NAME]ORDERS | Order number |  | MARATHON/ [NAME]ORDERS | Order number
 |  |  |  |  |  |  | 75000 | [NAME]
TOTAL ORDERED
DRIVE TO MAINTAIN 4.5 MILLION GALLON INVENTORY
? | LAST "STRAPPED" vs [NAME] LEVEL                                (as reference only… available monthly) |  |  | ?,??0,000 Strapped               ?,???,000 Indicator
2000-02-16 00:00:00 | TANK LEVEL READING @ 10:AM                  as reported by Plant control room |  |  | 3268000
 | TOTAL ORDERED THRU (during) FEBRUARY
2000-01-31 00:00:00 | TOTAL 'OUTSTANDING'  FROM JANUARY |  |  |  | (CALC. FROM JAN. SHEET)
 | Possible Over Delivery
FEB TOTAL | DELIVERED IN FEB. 00                                       per Plant off-load meters |  |  | -545621 | (Deliveries should be shown as negatives to properly calculate the projected level)
 | DELIVERED YESTERDAY, THRU 12:MID                              per Plant Control Room
 | DELIVERED 12:AM - 10:AM                                 as reported by Plant Control Room |  |  | 0
PROJECTED TANK LEVEL (at completion)
NOTE:
Spreadsheet: 28938d1223522081-formula-question-ifs-weekly-sheets
Sheet: Sheet33

 |  | Game | Game | Game | Totals
 |  | 789 | 879 | 789
 |  | W | W |  |  | Games Won-(2pts/game) |  | 4
 |  |  |  |  |  | Points for Totals (3pts)
 |  |  |  |  |  | Total Points
 |  | Game | Game | Game | Totals
 |  | 788 | 799 | 877
 |  |  |  | W | W | Games Won-(*2pts/game) |  | 2
 |  |  |  |  |  | Points for Totals (3pts) |  | 3
 |  |  |  |  |  | Total Points
Spreadsheet: 46356d1245249821-how-to-have-data-automaticly-transfered-from-sheet-1-to-sheet-2-when-its-labeled-iv-leads
Sheet: Sheet1

Name | [NAME] | Phone # | Zone | Disp. | Date | Conf.
Chauvion Moore | 678 | 1234567 | EST | WN
Tanya | 701 | 1234567 | CEN | AM
[NAME] | 801 | 1234567 | MTN | UA
[NAME] | 801 | 1234567 | MTN | UA
[NAME] | 704 | 1234567 | EST | WN
Tiffany | 713 | 1234567 | CEN | UA
[NAME] | 718 | 1234567 | EST | NQ
[NAME] | 718 | 1234567 | EST | UA
[NAME] | 732 | 1234567 | EST | UA
YOLANDA VELEZ | 732 | 1234567 | EST | UA
[NAME] | 740 | 1234567 | EST | NQ
Shelly | 970 | 1234567 | MTN | WN
[NAME] | 770 | 1234567 | EST | UA
[NAME] | 772 | 1234567 | EST | UA
[NAME] | 780 | 1234567 | EST | UA
[NAME] | 780 | 1234567 | EST | NQ
[NAME] | 780 | 1234567 | EST | UA
Estella | 800 | 1234567
[NAME] | 702 | 1234567 | PAC | UA
[NAME] | 702 | 5558899 | PAC | IV | 2009-06-11 00:00:00 | Y
[NAME] | 806 | 1234567 | CEN | UA
RonK | 808 | 1234567 | HAW | WN
guy | 808 | 1234567 | HAW | WN
irene | 813 | 1234567 | EST | NQ
[NAME] | 813 | 1234567 | EST | UA
Paulette | 815 | 1234567 | CEN | NQ
Sarai | 828 | 1234567 | EST | IV | 2009-06-17 00:00:00 | N
angelina | 760 | 1234567 | PAC | NQ
[NAME] | 859 | 1234567 | EST | UA
[NAME] | 864 | 1234567 | EST | WN
Ruddy | 876 | 1234567
[NAME] | 877 | 1234567
[NAME] | 902 | 1234567 | ATL | NS | 2009-06-11 00:00:00 | Y
Lance | 903 | 1234567 | CEN | UA
mary | 903 | 1234567 | CEN | WN
[NAME] | 903 | 1234567 | CEN | UA
[NAME] | 905 | 1234567 | EST | NQ
[NAME] | 905 | 1234567 | EST | UA
[NAME] | 908 | 1234567 | EST | AM
[NAME] | 858 | 1234567 | PAC | UA
[NAME] | 912 | 1234567 | EST | UA
[NAME] | 916 | 1234567 | CEN | NQ
constant | 917 | 1234567 | EST
kamakoty [NAME] | 917 | 1234567 | EST | NQ
SAM | 918 | 1234567 | CEN | UA
Janice | 919 | 1234567 | EST | UA
[NAME] | 920 | 1234567 | CEN | WN
Harold | 936 | 1234567 | CEN | NS | 2009-06-11 00:00:00 | Y
latorshia | 936 | 1234567 | CEN | UA
Laramie | 940 | 1234567 | CEN | UA
georgg | 951 | 1234567
Eldon | 951 | 1234567
Siua | 909 | 1234567 | PAC | UA
Spreadsheet: 728460d1618478081-formula-for-match-report-01
Sheet: WK02

Week 02
KPI |  |  | Delivery Performance
Service Type |  |  | TA |  |  | AM |  |  | A |  |  | B-D |  |  | Total Performance
Depot Number | Region | On [NAME] | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | % | Due | Suc. | %
Overall | N/A | N
001 - Depot 01 | H | Y | 20 | 19 |  | 32 | 32 |  | 300 | 284 |  | 116 | 111
002 - Depot 02 | H | Y | 15 | 15 |  | 31 | 31 |  | 298 | 297 |  | 120 | 119
003 - Depot 03 | M | Y | 20 | 9 |  | 34 | 26 |  | 287 | 242 |  | 141 | 131
004 - Depot 04 | P | Y | 12 | 6 |  | 46 | 36 |  | 307 | 254 |  | 143 | 110
005 - Depot 05 | H | Y | 11 | 8 |  | 26 | 25 |  | 271 | 266 |  | 136 | 135
006 - Depot 06 | P | N | 10 | 9 |  | 49 | 47 |  | 402 | 387 |  | 152 | 150
007 - Depot 07 | H | Y | 10 | 7 |  | 19 | 17 |  | 148 | 133 |  | 78 | 66
008 - Depot 08 | M | Y | 8 | 5 |  | 19 | 16 |  | 207 | 196 |  | 77 | 76
009 - Depot 09 | M | N | 10 | 8 |  | 21 | 21 |  | 159 | 158 |  | 66 | 65
010 - Depot 10 | M | N | 17 | 15 |  | 54 | 50 |  | 401 | 389 |  | 212 | 209
Spreadsheet: 683513d1592804274-adding-indirect-function-to-an-existing-if-statement-sample-file_indirect-lookup
Sheet: TeamDraft

 | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn |  | [NAME] | flexB | flex | Pick | [NAME] | Pos | Player | posn