tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 38680d1236817833-pull-data-from-two-other-worksheet-per-condition-auction-09-00
Sheet: Names

[NAME] | Last name | First Name | Address | City | State | Zip | Phone | Mobile | [NAME]
100 | [NAME] | [NAME] | 123 Main | Anytown | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
101 | Wilson | [NAME] | 456 Sterling | Anywhere | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
102 | Smith | [NAME] | 12545 Coumn st. | Here | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
103 | [NAME] | [NAME] | 124 Main | There | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
104 | [NAME] | [NAME] | 457 Sterling | Anytown | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
105 | [NAME] | [NAME] | 12546 Coumn st. | Anywhere | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
106 | Singer | [NAME] | 125 Main | Here | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
107 | Singer | [NAME] | 458 Sterling | There | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
108 | [NAME] | [NAME] | 12547 Coumn st. | Anytown | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
109 | [NAME] | [NAME] | 126 Main | Anywhere | IL | 61523 | [PHONE] | [PHONE] | [EMAIL]
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
Spreadsheet: matt_motley__26411__mieco cob 100701
Sheet: Sheet1

RED represents EPMI short positions.
 |  |  |  |  | PJM
Sum of Net Volume | product_cd
Month | POW-CINERGY | POW-Entergy | POW-MID-COL | POW-NP15 | POW-WESTERN | POW-WSCC-N | POW-WSCC-S | Grand Total
2001-10-01 00:00:00 | 136000 | 13600 | -33475 | 8000 | 68000 | 37125 | 0 | 229250
2001-11-01 00:00:00 | 168000 | 16800 | -44000 | 10000 | 84000 | 50000 | 0 | 284800
2001-12-01 00:00:00 | 160000 | 16000 | -45800 | 10000 | 80000 | 53000 | 0 | 273200
2002-01-01 00:00:00 | 0 |  | -20800 |  | 17600 | 67800 |  | 64600
2002-02-01 00:00:00 | 0 |  | -19200 |  | 16000 | 60000 |  | 56800
2002-03-01 00:00:00 | 50400 |  | -20800 |  | 0 | 67800 |  | 97400
2002-04-01 00:00:00 | 52800 |  | -20800 |  | 0 | 63425 |  | 95425
2002-05-01 00:00:00 | 0 |  | -20800 |  | -17600 | 67800 |  | 29400
2002-06-01 00:00:00 | 48000 | -16000 | -20000 |  | -16000 | 66000 |  | 62000
2002-07-01 00:00:00 | -17600 | -17600 | -20800 |  | -17600 | 67800 |  | -5800
2002-08-01 00:00:00 | -17600 | -17600 | -21600 |  | -17600 | 65400 |  | -9000
2002-09-01 00:00:00 | 128000 |  | -19200 |  | -16000 | 68400 |  | 161200
2002-10-01 00:00:00 | 73600 |  | -21600 |  | 0 | 65575 |  | 117575
2002-11-01 00:00:00 | 64000 |  | -20000 |  | 0 | 66000 |  | 110000
2002-12-01 00:00:00 | 67200 |  | -20000 |  | 0 | 70200 |  | 117400
2003-01-01 00:00:00 |  |  |  |  |  | 32800 |  | 32800
2003-02-01 00:00:00 |  |  |  |  |  | 28800 |  | 28800
2003-03-01 00:00:00 |  |  |  |  |  | 32800 |  | 32800
2003-04-01 00:00:00 |  |  |  |  |  | 30300 |  | 30300
2003-05-01 00:00:00 |  |  |  |  |  | 32800 |  | 32800
2003-06-01 00:00:00 |  | -16800 |  |  |  | 32000 |  | 15200
2003-07-01 00:00:00 |  | -17600 |  |  |  | 32800 |  | 15200
2003-08-01 00:00:00 |  | -16800 |  |  |  | 32800 |  | 16000
2003-09-01 00:00:00 |  |  |  |  |  | 32000 |  | 32000
2003-10-01 00:00:00 |  |  |  |  |  | 31300 |  | 31300
2003-11-01 00:00:00 |  |  |  |  |  | 33600 |  | 33600
2003-12-01 00:00:00 |  |  |  |  |  | 32800 |  | 32800
2004-06-01 00:00:00 |  | -17600 |  |  |  |  |  | -17600
2004-07-01 00:00:00 |  | -16800 |  |  |  |  |  | -16800
2004-08-01 00:00:00 |  | -17600 |  |  |  |  |  | -17600
Grand Total | 912800 | -108000 | -368875 | 28000 | 180800 | 1321125 | 0 | 1965850
Spreadsheet: 2332a5c9-d019-467a-8511-87390c8942d7
Sheet: Sheet1

Jelentkezési lap | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Kerameikos-tanfolyam'
Jelentkezni szeretnék az alábbi tanfolyamra (a megfelelő aláhúzandó):
pecsételt díszítésű római edény (2013. október 19.)
domborművel díszített ókori urnák (2013. november 9.)
ókori kenőcsös edények és ampullák (2013. november 16.)
a formához vezető kétféle út - szobrászeti technikák I. (2013. november 23.)
a formához vezető kétféle út - szobrászeti technikák II. (2013. november 30.)
Név
Lakcím
Otthoni vagy mobil telefonszám
Telefonszám munkaidőben
A tanfolyamról a következő módon értesültem:
Dátum |  |  |  |  | Aláírás
Spreadsheet: michael_maggi__26462__NYMEXWEEKLY
Sheet: SC

Week Ending: | 2001-10-12 00:00:00
 | Futures Settlement Prices
 | BRENT CRUDE OIL |  |  |  |  | Contract Symbol:  SC
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-10-08 00:00:00 | 2001-10-09 00:00:00 | 2001-10-10 00:00:00 | 2001-10-11 00:00:00 | 2001-10-12 00:00:00 | Interest
 | 2001-11-01 00:00:00 | 21.83 | 21.87 | 22.07 | 22.58 | 21.62 | 1593
 | 2001-12-01 00:00:00 | 22.1 | 22.06 | 22.21 | 22.72 | 21.76 | 1039
 | 2002-01-01 00:00:00 | 22.33 | 22.25 | 22.4 | 22.84 | 21.96 | 184
 | 2002-02-01 00:00:00 | 22.31 | 22.24 | 22.38 | 22.8 | 21.94 | 60
 | Apr_02 | 22.21 | 22.16 | 22.28 | 22.69 | 21.8 | 10
 | 2001-05-02 00:00:00 | 22.16 | 22.12 | 22.23 | 22.64 | 21.74 | 70
 | Total Weekly Volume
 |  |  | 2407 |  | Total Open Interest |  | 4434
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Brent Crude Oil
 | 5 Day Hist. Vol. |  |  | N\A
 | 20 Day Hist. Vol. |  |  | N\A
 | Implied Volatility-Options
 |  |  |  | Brent Crude Oil
 | At the Money Call & Put
 |  |  |  | N\A
Spreadsheet: 258793d1376854846-adult-baseball-league-schedule-2013fall-schedule-1-
Sheet: sortable

game# | week # | Visitors | Home | Field |  | game# | week # | Visitors | Home | Field
1 | 1 | KEYS | BYE |  |  | 1 | 1 | KEYS | BYE |  |  |  | Red Wings LBU
2 | 1 | SENATORS | MUDCATS | CCC |  | 2 | 1 | SENATORS | MUDCATS | CCC |  |  | [NAME]
3 | 1 | TIGERS | REDWINGS | LBU |  | 3 | 1 | TIGERS | REDWINGS | LBU |  |  | Mud Cats CCC
4 | 1 | BAYSOX | SEADOGS | GHS |  | 4 | 1 | BAYSOX | SEADOGS | GHS |  |  | [NAME]
5 | 1 | KEYS | SENATORS | [NAME] |  | 5 | 1 | KEYS | SENATORS | [NAME] |  |  | Senators DP
6 | 2 | MUDCATS | BYE |  |  | 6 | 2 | MUDCATS | BYE |  |  |  | Sea Dogs GHS
7 | 2 | SEADOGS | REDWINGS | LBU |  | 7 | 2 | SEADOGS | REDWINGS | LBU |  |  | Tigers GHS
8 | 2 | KEYS | TIGERS | GHS |  | 8 | 2 | KEYS | TIGERS | GHS
9 | 2 | BAYSOX | SENATORS | DP |  | 9 | 2 | BAYSOX | SENATORS | DP
10 | 2 | MUDCATS | REDWINGS | [NAME] |  | 10 | 2 | MUDCATS | REDWINGS | [NAME]
11 | 2 | SEADOGS | BAYSOX | [NAME] |  | 11 | 2 | SEADOGS | BAYSOX | [NAME] |  | HC | Sea Dogs,Tigers,
12 | 3 | BAYSOX | BYE |  |  | 12 | 3 | BAYSOX | BYE
13 | 3 | SENATORS | KEYS | CCC |  | 13 | 3 | SENATORS | KEYS | CCC |  | CC | Senators, [NAME], Red Wings , Mud Cats.
14 | 3 | REDWINGS | MUDCATS | CCC |  | 14 | 3 | REDWINGS | MUDCATS | CCC |  |  | baysox
15 | 3 | TIGERS | SEADOGS | GHS |  | 15 | 3 | TIGERS | SEADOGS | GHS
16 | 3 | MUDCATS | SENATORS | [NAME] |  | 16 | 3 | MUDCATS | SENATORS | [NAME]
17 | 3 | REDWINGS | TIGERS | [NAME] |  | 17 | 3 | REDWINGS | TIGERS | [NAME]
18 | 4 | TIGERS | BAYSOX | LBU |  | 18 | 4 | TIGERS | BAYSOX | LBU
19 | 4 | SENATORS | BYE |  |  | 19 | 4 | SENATORS | BYE
20 | 4 | REDWINGS | KEYS | CCC |  | 20 | 4 | REDWINGS | KEYS | CCC
21 | 4 | MUDCATS | SEADOGS | GHS |  | 21 | 4 | MUDCATS | SEADOGS | GHS
22 | 4 | SENATORS | BAYSOX | [NAME] |  | 22 | 4 | SENATORS | BAYSOX | [NAME]
23 | 4 | TIGERS | KEYS | [NAME] |  | 23 | 4 | TIGERS | KEYS | [NAME]
24 | 5 | BAYSOX | MUDCATS | CCC |  | 24 | 5 | BAYSOX | MUDCATS | CCC
25 | 5 | BYE | TIGERS |  |  | 25 | 5 | BYE | TIGERS
26 | 5 | KEYS | SEADOGS | GHS |  | 26 | 5 | KEYS | SEADOGS | GHS
27 | 5 | SENATORS | REDWINGS | LBU |  | 27 | 5 | SENATORS | REDWINGS | LBU
28 | 5 | BAYSOX | KEYS | [NAME] |  | 28 | 5 | BAYSOX | KEYS | [NAME]
29 | 5 | REDWINGS | SEADOGS | [NAME] |  | 29 | 5 | REDWINGS | SEADOGS | [NAME]
30 | 6 | BYE | SEADOGS | GHS |  | 30 | 6 | BYE | SEADOGS
31 | 6 | MUDCATS | KEYS | CCC |  | 31 | 6 | MUDCATS | KEYS | CCC
32 | 6 | REDWINGS | BAYSOX | LBU |  | 32 | 6 | REDWINGS | BAYSOX | LBU
33 | 6 | TIGERS | SENATORS | DP |  | 33 | 6 | TIGERS | SENATORS | DP
34 | 6 | SEADOGS | TIGERS | [NAME] |  | 34 | 6 | SEADOGS | TIGERS | [NAME]
35 | 6 | TBD | MUDCATS | [NAME] |  | 35 | 6 | TBD | MUDCATS | [NAME]
36 | 7 | BAYSOX | KEYS | CCC |  | 36 | 7 | BAYSOX | KEYS | CCC
37 | 7 | BYE | REDWINGS |  |  | 37 | 7 | BYE | REDWINGS
38 | 7 | TIGERS | MUDCATS | CCC |  | 38 | 7 | TIGERS | MUDCATS | CCC
39 | 7 | SENATORS | SEADOGS | GHS |  | 39 | 7 | SENATORS | SEADOGS | GHS
Spreadsheet: 827892d1683107928-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-o-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-0
Sheet: bsalv vs josephteh

Products | Cost | bsalv | [NAME]
Product A
Product B
Product C
Product D
Product E
Product F
Total of shipping cost | Quantity of product | Shipping cost for each product | extra
 | 6
Spreadsheet: 275504d1383554265-how-to-vlookup-with-multiple-criteria-mambaout626
Sheet: Sheet1

Order ID #(DUPLICATE) | Order Amount | Unique | Less than 50K | B/W 10K & 50K
235611 | 1625
240425 | 11572.72
242686 | 4290 |  |  |  | ** Since Order ID 242686 subotal more than $50000, I want Column D4 to D13 to be blank
242686 | 12285
242686 | 14742
242686 | 5733
242686 | 257.4
242686 | 384.8
242686 | 6054.75
242686 | 6054.75
242686 | 8073
242686 | 11466
242709 | 35400 |  |  |  | ** Order ID 242709 have two same ID, hence I wanna return a vlaue of "1" at column D14 & D15
242709 | 5400 |  | 1 | 1 | Return value "1". Since subtotal less than $50000
242894 | 228
244543 | 6531.47 |  |  |  |  | *If OrderID subtotal less than $50000, return value of ALL OrderID = "1"
244543 | 6116.86 |  | 1
244563 | 13062.94
Spreadsheet: 689547d1596498781-populate-cells-at-a-defined-pattern-cell-spacing-example
Sheet: Sheet1

 | Count | Level
 | 1 | 10
 | 2 | 9
 | 3 | 8
 | 4 | 7
 | 5 | 6
 | 6 | 5
 | 7 | 4
 | 8 | 3
 | 9 | 2
 | 10 | 1
 | 11 | G
 | 12 | LG
 | 13 | B1
 | 14 | B2
 | 15 | B3
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 715569d1611767943-extract-national-data-point-when-national-value-is-available-in-all-9-regions-national-regional-example
Sheet: Data sample

Product | Product number | Amount | Percentage | Term | National/ Regional | Region
V | V1 |  | 0.019 | 66 | National | A
V | V1 |  | 0.019 | 66 | National | B
V | V1 |  | 0.019 | 66 | National | C
V | V1 |  | 0.019 | 66 | National | D
V | V1 |  | 0.019 | 66 | National | E
V | V1 |  | 0.019 | 66 | National | F
V | V1 |  | 0.019 | 66 | National | G
V | V1 |  | 0.019 | 66 | National | H
V | V1 |  | 0.019 | 66 | National | I
V | V1 | 1000 |  |  | National
V | V2 | 1000 |  |  | Regional | A
V | V2 | 1000 |  |  | National
Spreadsheet: 788589d1658563868-need-formula-to-filter-student-information-based-on-a-condition-of-getting-subject-mark-le-formal-table-2-
Sheet: P1

Second Attempt Students
Stage | Student Name | Semester | Subject | Grades
Spreadsheet: 8b933596-abe9-4f7a-920d-7c3824f88c4f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
URRP | Test | URRP | Ureaplasma species, Molecular Detection, PCR | Ureaplasma PCR | Real-Time Polymerase Chain Reaction (PCR) Using LightCycler and Fluorescent Resonance Energy Transfer (FRET) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  |  |  | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] source is required.   Submit only 1 of the following specimens:   Specimen Type: Vaginal Container/Tube: Preferred: Dacron or rayon swab with aluminum or plastic shaft (does not need to be in transport media) Acceptable: Swab in transport media: M5 (Supply T484), [NAME], or universal transport media [NAME]: 1 swab Collection Instructions: Collect specimen by swabbing back and forth over mucosa surface to maximize recovery of cells.   [NAME] Cervix, urethra, urogenital Container/Tube: Preferred: Dacron or rayon swab with aluminum or plastic shaft (does not need to be in transport media) Acceptable: Swab in transport media: M5 (Supply T484), [NAME], or universal transport media [NAME]: 1 swab Collection Instructions: Collect specimen by inserting swab 1 to 3 cm and rotating 360 degrees.   [NAME], amniotic, prostatic secretion, semen, reproductive drainage/fluid, lower respiratory Container/Tube: Preferred: Sterile container Acceptable: Specimen in 3 mL of transport media: M5 (Supply T484), [NAME], or universal transport media [NAME]: 1-2 mL    Specimen Type: [NAME], kidney stones Container/Tube: Sterile container [NAME]: 10 mL   Specimen Type: Tissue Sources: Placenta, products of conception, genitourinary Container/Tube: Sterile container [NAME]: 5 mm Collection Instructions: Submit only fresh tissue. | [NAME], [NAME], Pr | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Wooden shaft, cotton swab | Not applicable | Monday through Friday | 3 days | 4 days | 1 | 87798 |  |  |  |  | Rochester
URRP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
URRP | Order Question | SRC80 | [NAME] |  | Plain Text
URRP | Result | SRC80 | Specimen source | Specimen source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
URRP | Result | 35128 | Ureaplasma urealyticum PCR | Ureaplasma urealyticum PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51988-4
URRP | Result | 35129 | Ureaplasma parvum PCR | Ureaplasma parvum PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69933-0
Spreadsheet: 727016d1617653066-extract-talk-time-to-mobile-phones-mobile-call-analysis-and-report
Sheet: Call Report

Caller Number | Extension | Total Talk Time to Mobile Numbers
200 | Reception (RIK)
201 | Reception (KGN)
202 | Attendance Officer
204 | SMS Adminstrator (STJ)
206 | Accounts Manager (DAT)
207 | Payroll Manager (RUY)
209 | The Hub
211 | Nurse (HAN)
212 | Counsellor (BMO)
216 | Boardroom
217 | SLT Room
218 | Reception Room
219 | HOH 1
220 | HOH 2
221 | HOH3/Tui Room
222 | [NAME] (KIN)
240 | Groundsman (HIK)
249 | SLT Cordless
250 | [NAME]'s PA (HFT)
251 | [NAME])
252 | Deputy [NAME] (THP)
253 | Deputy [NAME] (MGY)
254 | Deputy [NAME] (AUS)
257 | Visual Art
261 | ESOL
263 | Food Technology
265 | Wharenui
267 | Māori Student Mentor (HWR)
269 | Music
270 | Property Manager (ROF)
271 | Performing Arts
274 | Gymnasium
275 | Science
276 | SEU1
277 | Library
280 | ICT (RUJ)
281 | ICT (DEV)
282 | SEU (SUA)
283 | Technology
285 | SLC 1
289 | Social Science
290 | Science
291 | Mathematics
292 | English
293 | Career Education 1
294 | Career Education 2
295 | SLC 2
296 | International Student Manager ([NAME])
299 | Absentees
310 | Career Education Reception (MLT)
315 | Gateway (HAS)
316 | Career LOL (BUR)
326 | [NAME] (EDS)
340 | Languages
350 | International Student Director (FCA)
361 | Horticulture/Agriculture
470 | Sports Co-ordinator (HOB)
2102093500 | [NAME] (EDS)
2102061500 | Groundsman (HIK)
210375500 | Gateway (HAS)
210384500 | Deputy [NAME] (MGY)
210574500 | ICT (DEV)
212764500 | [NAME] (KIN)
21743500 | International Student Manager ([NAME])
21874500 | Property Manager (ROF)
21930500 | International Student Director (FCA)
275226500 | Sports Co-ordinator (HOB)
275331500 | ICT (RUJ)
275739500 | Deputy [NAME] (THP)
275739500 | Deputy [NAME] (AUS)
276015500 | Counsellor (BMO)
21837500 | Principal (LDL)
Spreadsheet: 113033d1308958920-attempting-to-create-a-formula-code-to-have-excel-automatically-move-a-column-over-scratchers-form_after
Sheet: Sheet1

LOTTERY SALES |  |  |  |  | This is the after, note that the before's C Column "Today" is now in the B Column "Previous Day", and the date
 |  |  |  |  | at the bottom has gone up one day. This is to allow me, or my coworkers, to enter the next day's sales
BOX | PREVIOUS DAY | TODAY | # [NAME] | $ [NAME]
1 | 34 |  | #N/A | #N/A
2 | 13 |  | #N/A | #N/A
3 | 215 |  | #N/A | #N/A
4 | 116 |  | #N/A | #N/A
5 | 50 |  | #N/A | #N/A
6 | 54 |  | #N/A | #N/A
7 | 19 |  | #N/A | #N/A
8 | 56 |  | #N/A | #N/A
9 | 17 |  | #N/A | #N/A
10 | 39 |  | #N/A | #N/A
11 | 77 |  | #N/A | #N/A
12 | 95 |  | #N/A | #N/A
13 | 78 |  | #N/A | #N/A
14 | 17 |  | #N/A | #N/A
15 | 20 |  | #N/A | #N/A
16 | 16 |  | #N/A | #N/A
 |  | Scratcher Sales = |  | #N/A
 |  | Lottery Sales = |  | 340
 |  | Actual Sales = |  | #N/A
 |  | Report Sales = |  | 450
 |  | Over/Short = |  | #N/A
Closing Date | 2011-06-24 00:00:00
Spreadsheet: 18814f37-b7fb-4457-94c2-48335365c33d
Sheet: Sheet1

Bib | Firstname | Lastname | City | State | TeamName | Age | Gender | AgeGroup | [NAME] | [NAME] | Lap2 | Finish | AG Place | OverAll | Order | Masters | Penalty
62 | Sara | Fahey | Cedar Rapids | IA |  | 21 | F | F20-24 | -- | 00:36:53.020000 | 00:37:58.630000 | 01:14:51.650000 | -- | 1 | 13
76 | [NAME] | Aronow | Urbandale | IA |  | 25 | F | F25-29 | -- | 00:38:10 | 00:40:43.100000 | 01:18:53.100000 | -- | 2 | 14
119 | [NAME] | [NAME] | Des Moines | IA |  | 45 | F | F45-49 | -- | 00:38:24.490000 | 00:40:42.110000 | 01:19:06.600000 | -- | 3 | 16
79 | Richelle | Lowery | Johnston | IA |  | 42 | F | F40-44 | -- | 00:39:31.250000 | 00:41:34.300000 | 01:21:05.550000 | 1 | 4 | 17
107 | [NAME] | [NAME] | Des Moines | IA |  | 43 | F | F40-44 | -- | 00:39:25.980000 | 00:42:02.290000 | 01:21:28.270000 | 2 | 5 | 20
96 | Becky | [NAME] | Iowa City | IA |  | 39 | F | F35-39 | -- | 00:40:27.930000 | 00:43:40.580000 | 01:24:08.510000 | 1 | 6 | 27
78 | [NAME] | Scholz | Des Moines | IA |  | 46 | F | F45-49 | -- | 00:43:53.890000 | 00:43:51.790000 | 01:27:45.680000 | 1 | 7 | 32
90 | [NAME] | Merkle | West Des Moines | IA |  | 40 | F | F40-44 | -- | 00:43:22.470000 | 00:46:02.790000 | 01:29:25.260000 | 3 | 8 | 34
110 | [NAME] | Merfeld | Des Moines | IA |  | 37 | F | F35-39 | -- | 00:42:40.680000 | 00:47:48.780000 | 01:30:29.460000 | 2 | 9 | 37
71 | Rachelle | Little | Cedar Rapids | IA | Triathlon Racers of Iowa | 32 | F | F30-34 | -- | 00:44:00.630000 | 00:47:12.270000 | 01:31:12.900000 | 1 | 10 | 39
69 | [NAME] | Cox | Cambridge | IA | Triathlon Racers of Iowa | 53 | F | F50-54 | -- | 00:51:26.320000 | 00:54:39.030000 | 01:46:05.350000 | 1 | 11 | 52
63 | [NAME] | Place Fencl | Ames | IA | Team Vardo | 34 | F | F30-34 | -- | 00:56:40.870000 | 00:54:49.010000 | 01:51:29.880000 | 2 | 12 | 55
89 | sandy | leiferman | panora | IA | Triathlon Racers of Iowa | 41 | F | F40-44 | -- | 00:55:34.320000 | 00:58:26.870000 | 01:54:01.190000 | 4 | 13 | 58
94 | [NAME] | bricker | [NAME] | IA |  | 55 | F | F55-59 | -- | 00:54:25.550000 | 01:03:36.920000 | 01:58:02.470000 | 1 | 14 | 59
Spreadsheet: 270737d1381614054-change-date-formula-to-number-0a1_f
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-20 00:00:00
 |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY
 |  | 2013-10-20 00:00:00 |  | 2013-10-21 00:00:00 |  | 2013-10-22 00:00:00 |  | 2013-10-23 00:00:00 |  | 2013-10-24 00:00:00 |  | 2013-10-25 00:00:00 |  | 2013-10-26 00:00:00
 | NORMAL | START | 08:00:00 | START | 07:00:00 | START | 07:00:00 | START | 07:00:00 | START | 07:00:00 | START | 19:00:00 | START | 08:00:00
 | HOURS | FINISH | 16:30:00 | FINISH | 19:00:00 | FINISH | 20:00:00 | FINISH | 17:00:00 | FINISH | 17:00:00 | FINISH | 07:00:00 | FINISH | 16:30:00
 | NIGHT | START | 21:00:00 | START |  | START |  | START |  | START |  | START |  | START
 | SHIFT HOURS | FINISH | 23:00:00 | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH
 | CALL OUT | START |  | START |  | START |  | START |  | START |  | START |  | START
 | HOURS | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH
 | OFFSITE | START |  | START |  | START |  | START |  | START |  | START |  | START
 | HOURS | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH
 | TRAINING | START |  | START |  | START |  | START |  | START |  | START |  | START
 | HOURS | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH
 | SICKNESS | START |  | START |  | START |  | START |  | START |  | START |  | START
 | HOURS | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH |  | FINISH
Spreadsheet: 711907d1609962019-returning-a-row-number-from-an-array-sample
Sheet: Sheet1

row | 18 | 19 | 20 | 21 | 22 | 23 |  | Age | value | row
1 | 6 | 8 | 9 | 11 | 10 | 9 |  | 19 | 10 | 3
2 | 7 | 9 | 10 | 12 | 11 | 10 |  | 22 | 10 | 1
3 | 8 | 10 | 11 | 13 | 12 | 11
4 | 9 | 11 | 12 | 14 | 13 | 12
Spreadsheet: 845346d1696882020-duplicate-spelling-excel-dataset-1_cities
Sheet: city list

City
London
Oldbury
Bracknell, London, City of
Henley on Thames
[NAME]
Brentford
Bradford
Bracknell
Colchester
Newbury
Staines
Borehamwood
[NAME]
[NAME]
[NAME]
Bourne End
WOLVERHAMPTON
Isleworth
[NAME]
London
BANBURY
London
London
Bristol
Bradford
West Yorshire
London
Swindon
Godalming
London
Reading
Barnsbury
[NAME],
Belfast
DURSLEY
Banbury
Denbighshire
[NAME]
Stoke-on-Trent
[NAME]
Norfolk
Oxford
Gloucestershire
BOLTON
London
[NAME]
Kent
Cumbria
Hinckley
Cheltenham
Cambridge
Bradford
Leeds
Maidstone
London
[NAME]
FRAMLIMGHAM
STANSTED
CROWTHORNE
Exeter
Shrewsbury
Golborne
Kintore
[NAME]
Derby
[NAME]
[NAME]
Clacton-on-Sea
London
Antrim
[NAME]
Sheffield
London
[NAME]
Cambridge
Liverpool
Ipswich
FAREHAM
Northfleet
London
Hoddesdon
BLACKPOOL
[NAME]
LONDON
Abingdon
Birmingham
Limpsfield
Belfast
Ballynahinch
Leominster
North Shields
London
Belfast
[NAME], Segensworth North
Warwick
Belfast
[NAME]
Waterbeach
Blackford
Towcester
[NAME]
london
[NAME]
Dewsbury
NEWPORT
Huddersfield
[NAME]
Crawley
Northampton
Aylesford
Stonehouse
COLWYN BAY
Kingston
BARNSLEY
Otterbourne
Dunstable
London
BIRMINGHAM
[NAME]
Hook
[NAME]
BALSHAM
Bromborough
[NAME]
FAREHAM
Woolwich
London
Carshalton
Hants
Swindon
[NAME]
London
[NAME]
Histon
Plymouth
Wiltshire
NA
[NAME]
Guernsey
Mansfield
Swansea
Bedford
Dovercourt
Aberystwyth
ST HELIER
CHELTENHAM
Holywood
Peterborough
Tyne & Wear
[NAME]
DERBYSHIRE
Somerset
Egham
[NAME]
WALSALL
[NAME]
Bedfont
Tamworth
SUFFOLK
Southampton
Bilston
LONDON
Bath
London
CHESHIRE
London
London
Wolverhampton
STOCKPORT
Barton-Upon-Humber
WIGAN
Clitheroe
Rushden
Wakefield
London
Lancaster
[NAME]
Llansamlet
London
[NAME]
Pencoed
London
Howden
Antrim
[NAME]
Ballasalla
Hull
Coton
[NAME]
OMAGH
[NAME]
London
Cardiff
South Molton
glasgow
West Yorkshire
Northants
Pool
Coventry
BURSLEM
Exeter
HULME
Luton
Bradford upon [NAME]
Blakeney
Spennymoor
Bromsgrove
[NAME]
London
Telford
Aberdeen
BLANDFORD
[NAME]
[NAME]
Bracknell
High Wycombe
London
CARDIFF
Market Harborough
Lisburn
Aylesbury
[NAME]
Egham
Coleraine
Newport
Totnes
Dorchester
Birmingham
HODDESDON
Belfast
ADDLESTONE
London
London
Stokenchurch
LOCHGILPHEAD
[NAME]
CAMBRIDGE
Huddersfield
Henley on Thames
[NAME], Bristol
London
[NAME]
Belfast
Bristol
Hertfordshire.
TELFORD
Cafdiff
Mid Glamorgan
[NAME]
Burford
Harlow
London
[NAME]
[NAME]
Mexborough
Dorset
PETERBOROUGH
Prescot
Uxbridge
Southampton
Alford
Stirlingshire
Aberdeen
Essex
Mold
Wolverhampton
[NAME]
Beverley
London
London
STAFFORSHIRE
Plymouth, [NAME]
London
Pinner
Antrim
Sheffield
[NAME]
Lisburn
Edinburgh
Irthlingborough
Abingdon
Harrogate
London
Sheffield
Worcester
Ascot
Oxford
Ince
Buckfastleigh
HERTFORD
[NAME]
Cirencester
York
Barnstaple
[NAME]
Martock
[NAME]
Spreadsheet: 838286d1690894945-format-a-table-using-formulas-only-sample
Sheet: Аркуш1

As is:
 | Name | Name | Some data
 | Google | Google Inc | 12
 | Google | Google Inc | 10
 | Google | Google Inc | 23
 | Microsoft | Microsoft Inc | 21
 | Microsoft | Microsoft Inc | 42
 | Apple | Apple Inc | 12
To be:
 | Google | Google Inc | 12
 | Google | Google Inc | 10
 | Google | Google Inc | 23
 | Total
 | Microsoft | Microsoft Inc | 21
 | Microsoft | Microsoft Inc | 42
 | Total
 | Apple | Apple Inc | 12
 | Total
 | Grand Total
Spreadsheet: 865627d1712669334-choosecols-and-filter-test2_abs
Sheet: Formula

 |  | [NAME] | 0 | 39096.17
 | Bimal Chiya Packaging Udhyog | Simal Kiya Packaging Udhyog | 307875.76 | 469251.64
 | 301501891 | Dimal Food Product,ahari | 593120.65 | 593120.65
 | Mainik [NAME] | Mainik [NAME] | 54 | 0
 | 608620093 | Elanta Health Care And Hyginene Products | 2173.68 | -82173.68
 | 0 | [NAME]. Ltd. | -12 | -12