tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 221112d1363369709-inches-and-feet-extract-feet-and-inches
Sheet: Sheet1

Your text | 1st Value | 2nd Value |  | 1st text | 2nd text |  |  |  |  | 1st inches | 2nd inches
150' x 20' (W x H) |  |  |  |  |  |  |  |  |  |  |  |  | 150' x 20' (W x H)
8'x6' (W x H) |  |  |  |  |  |  |  |  |  |  |  |  | 8'x6' (W x H)
17'6" x 12'2" (W x H) |  |  |  |  |  |  |  |  |  |  |  |  | 17'6" x 12'2" (W x H)
17'6" x 12' (W x H) |  |  |  |  |  |  |  |  |  |  |  |  | 17'6" x 12' (W x H)
17' x 12'2" (W x H) |  |  |  |  |  |  |  |  |  |  |  |  | 17' x 12'2" (W x H)
 |  |  |  |  | Ignore the grey area, its where I was testing stuff
150' x 20' or 8'x6' or 17'6" x 12'2"
Spreadsheet: 267044d1379921030-excel-column-and-row-comparison-excel-help-ans
Sheet: Help

EXISTING |  |  | DESIGN |  |  | DESIGN |  |  | POINTS
DISTANCE | LEVEL |  | DISTANCE | LEVEL |  | DISTANCE | LEVEL |  | DISTANCE | LEVEL
0 | 2429 |  |  |  |  |  |  |  | 43.3 | 2456
10 | 2428 |  |  |  |  |  |  |  | 129.3 | 2285
20 | 2364 |  |  |  |  |  |  |  | 253.9 | 2190
30 | 2423 |  |  |  |  |  |  |  | 363.9 | 2227
40 | 2422 |  | 43.3 | 2456 |  | 43.3 | 2456 |  | 363.9 | 2227 |  | [NAME] are in D & E Columns.
50 | 2407
60 | 2389
70 | 2393
80 | 2329
90 | 2288
100 | 2268
110 | 2239
120 | 2218
130 | 2185 |  | 129.3 | 2285 |  | 129.3 | 2285
140 | 2205
150 | 2197
160 | 2176
170 | 2180
180 | 2198
190 | 2212
200 | 2221
210 | 2219
220 | 2160
230 | 2134
240 | 2108
250 | 2095 |  | 253.9 | 2190 |  | 253.9 | 2190
260 | 2084
270 | 2071
280 | 2065
290 | 2056
300 | 2050
310 | 2205
320 | 2205
330 | 2197
340 | 2176
350 | 2205
360 | 2197 |  | 363.9 | 2227
Spreadsheet: 8b02cc58-31f1-4db5-82c0-b7bb6f2482bb
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40417389 | 2014-03-08 18:34:39 | ALLIES | 1 | 4 | 0 | 1537890 | bertverwaal | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
Spreadsheet: 691728d1597846867-countif-number-of-1s-between-2-dates-countif-between-2-dates
Sheet: Sheet1

 | Date Range |  |  |  | "1" is Breach
 | End | 2020-07-31 00:00:00 |  |  | "0" is no breach
 | Start | 2020-07-01 00:00:00
 |  |  |  |  |  | AAA | BBB | CCC | DDD
 |  | Person | Number of breaches (Number of "1s") |  | Dashboard / Liquidity Date | [NAME] | [NAME] | [NAME] | [NAME]
 | AAA | [NAME] |  |  | 2020-07-01 00:00:00 | 0 | 0 | 0 | 0
 | BBB | [NAME] |  |  | 2020-07-02 00:00:00 | 1 | 0 | 0 | 0
 | CCC | [NAME] |  |  | 2020-07-03 00:00:00 | 0 | 1 | 0 | 0
 | DDD | [NAME] |  |  | 2020-07-06 00:00:00 | 0 | 0 | 0 | 1
 |  |  |  |  | 2020-07-07 00:00:00 | 1 | 0 | 0 | 0
 |  |  |  |  | 2020-07-08 00:00:00 | 0 | 1 | 0 | 0
 |  |  |  |  | 2020-07-09 00:00:00 | 0 | 0 | 1 | 0
 |  |  |  |  | 2020-07-10 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-13 00:00:00 | 0 | 0 | 1 | 0
 |  |  |  |  | 2020-07-14 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-15 00:00:00 | 0 | 1 | 0 | 1
 |  |  |  |  | 2020-07-16 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-17 00:00:00 | 0 | 1 | 0 | 0
 |  |  |  |  | 2020-07-20 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-21 00:00:00 | 1 | 0 | 0 | 0
 |  |  |  |  | 2020-07-22 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-23 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-24 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-27 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-28 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-29 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-07-30 00:00:00 | 0 | 0 | 0 | 1
 |  |  |  |  | 2020-07-31 00:00:00 | 1 | 0 | 0 | 0
 |  |  |  |  | 2020-08-03 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-04 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-05 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-06 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-07 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-10 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-11 00:00:00 | 1 | 1 | 0 | 0
 |  |  |  |  | 2020-08-12 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-13 00:00:00 | 1 | 0 | 0 | 0
 |  |  |  |  | 2020-08-14 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-17 00:00:00 | 1 | 0 | 1 | 0
 |  |  |  |  | 2020-08-18 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  | 2020-08-19 00:00:00 | 1 | 0 | 0 | 0
Spreadsheet: 295618d1391754991-filter-multiple-columns-of-a-survey-data-as-per-defined-categories-example-v3
Sheet: Sheet1

 | High Rich | HH Income $150K+
 | High Rich Travelers | HH Income $150k+, atleast 2 airline trips in last 12 months
 | Married | HH Income $150k+, atleast 2 airline trips in last 12 months, Married
 | Unmarried | HH Income $150k+, atleast 2 airline trips in last 12 months, Not Married
 | High Rich Non Frequent Travelers | HH Income $150k+, less than 2 airline trips in last 12 months
 | With kids | HH Income $150k+, less than 2 airline trips in last 12 months, having household children
 | without kids | HH Income $150k+, less than 2 airline trips in last 12 months, Not having household children
 | Married | HH Income $150k+, less than 2 airline trips in last 12 months, Not having household children, Married
 | Not Married | HH Income $150k+, less than 2 airline trips in last 12 months, Not having household children, Not married
 | Rich | HH Income $100K - $150K
 | Rich Frequent Travelers | HH Income $100k - $150k, atleast 2 airline trips in last 12 months
 | Married | HH Income $100k - $150k, atleast 2 airline trips in last 12 months, Maried
 | Unmarried | HH Income $100k - $150k, atleast 2 airline trips in last 12 months, Not Married
 | Rich Non Frequent Travelers | HH Income $100k - $150k, less than 2  airline trips in last 12 months
 | With kids | HH Income $100k - $150k, less than 2 airline trips in last 12 months, having household children
 | without kids | HH Income $100k - $150k, less than 2 airline trips in last 12 months, not having household children
 | Married | HH Income $100k - $150k, less than 2 airline trips in last 12 months, not having household children, Married
 | Not Married | HH Income $100k - $150k, less than 2 airline trips in last 12 months, not having household children, Not married
 | Middle | HH Income $50K - $100K
 | middle Families with kids in the HH | HH Income $50k - $100k, Having kids in HH
 | middle Couples without kids in the HH (excluding retirees) | HH Income $50k - $100k, Married, Not having household kids, Age <59 years (excluding retirees)
 | middle Retirees | HH Income $50k - $100k, Age 59+, Retired (excluding families)
 | College Going Youth | HH Income $50k - $100k, Age 18-24, Student  (excluding families, couples)
 | Youth Workers (Not College Educated) | HH Income $50k - $100k, Age 21-29, Single, Full time/Part time Employed, Not college educated  (excluding families,couples)
 | middle Remaining | Remaining Respondents having HH income $50k - $100k
 | Youth | Age 21-34, Single, Full time Employed, college educated
Spreadsheet: 866370d1713299713-summary-page-that-pulls-information-from-different-columns-into-a-two-primary-columns-registration-help-
Sheet: Registration

Team | Name #1 | Email #1 | Name #2 | Email #2
No | [NAME] | [EMAIL] | [NAME] | [EMAIL]
Yes | [NAME] | [EMAIL] | Jennifer Z | [EMAIL]
Yes | Megan L | [EMAIL] | [NAME] | [EMAIL]
No | [NAME] | [EMAIL] | [NAME] | [EMAIL]
Spreadsheet: 166232d1341504276-splitting-up-expanding-range-of-numbers-to-list-explained
Sheet: Sheet1

apple | 496 | 1 | 7 | Cat | 7 | 1 |  | apple | 496 | 1 | Cat
apple | 576 | 5 | 9 | Dog | 5 | 8 |  | apple | 496 | 2 | Cat
bannana | 834 | 2 | 8 | Bird | 7 | 13 |  | apple | 496 | 3 | Cat
fred | 123 | 7 | 11 | cow | 5 | 20 |  | apple | 496 | 4 | Cat
 |  |  |  |  |  |  |  | apple | 496 | 5 | Cat
 |  | result of splitting old col c with - as delimiter |  |  |  |  |  | apple | 496 | 6 | Cat
 |  |  |  |  |  |  |  | apple | 496 | 7 | Cat
 |  |  |  |  |  |  |  | apple | 576 | 5 | Dog
 |  |  |  |  | number of items |  |  | apple | 576 | 6 | Dog
 |  |  |  |  | start 1 finish 7 |  |  | apple | 576 | 7 | Dog
 |  |  |  |  | is 7 items or |  |  | apple | 576 | 8 | Dog
 |  |  |  |  | (7-1)+1 |  |  | apple | 576 | 9 | Dog
 |  |  |  |  |  |  |  | bannana | 834 | 2 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 3 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 4 | Bird
 |  |  |  |  |  |  |  | bannana | 834 | 5 | Bird
 |  |  |  |  |  | this gives the bounderies for the look up |  | bannana | 834 | 6 | Bird
 |  |  |  |  |  | ,[NAME],ROW($A$1:$A$100) |  | bannana | 834 | 7 | Bird
 |  |  |  | row(a1)=1 |  | [NAME]………..100}) |  | bannana | 834 | 8 | Bird
 |  |  |  | and as dragged down goes |  |  |  | fred | 123 | 7 | cow
 |  |  |  | to row(a2) =2 |  | note the use rows(a1:a10) creates a series 1,2,3,4,5,6,7,8,9,10 |  | fred | 123 | 8 | cow
 |  |  |  |  |  | a1:a100=1 to 100 |  | fred | 123 | 9 | cow
 |  |  |  | so for rows 1 to 7 the lookup finds the highest number lessthan or equal to |  |  |  | fred | 123 | 10 | cow
 |  |  |  | [NAME]………..100}) |  |  | returns 1 | fred | 123 | 11 | cow
 |  |  |  | lookup(2,{1,8,13,20},{1,2,3,4,5,6,7,8………..100}) |  |  | returns 1
 |  |  |  | [NAME]………..100}) |  |  | returns 1
 |  |  |  | [NAME]………..100}) |  |  | returns 1
 |  |  |  | lookup(5,{1,8,13,20},{1,2,3,4,5,6,7,8………..100}) |  |  | returns 1
 |  |  |  | lookup(7,{1,8,13,20},{1,2,3,4,5,6,7,8………..100}) |  |  | returns 1
 |  |  |  | lookup(7,{1,8,13,20},{1,2,3,4,5,6,7,8………..100}) |  |  | returns 1
 |  |  |  | then we get to row(a8)=8
 |  |  |  | lookup(8,{1,8,13,20},{1,2,3,4,5,6,7,8………..100}) |  |  | returns 2
 |  |  |  | so those numbers ar used to return from the index(A:A,0)
 |  |  |  |  | is cell  A1 | so it repeats whats in cell a1 7 times untill it changes to
 |  |  |  |  | ie  cell  A2