tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 834746d1688048686-textsplit-on-multiple-columns-to-array-textsplit-multiple-colums
Sheet: Feuil1

ignore |  |  |  |  |  |  |  | EXPECTED RESULT, SPILLING ARRAY
list1 | list2 | list3 |  |  | list2 | list3 |  | list1 | list2 | list3
a,b,c | j,z | w,x,c,v |  | a,b,c | j,z | w,x,c,v |  | a | j | w
 |  |  |  |  |  |  |  | b | z | x
 |  |  |  |  |  |  |  | c |  | c
 |  |  |  |  |  |  |  |  |  | v
 |  |  |  |  |  |  |  |  | list2 | list3
 |  |  |  |  |  |  |  | a | j | w
 |  |  |  |  |  |  |  | b | z | x
 |  |  |  |  |  |  |  | c |  | c
 |  |  |  |  |  |  |  |  |  | v
Spreadsheet: 732902d1621302891-regular-ot-double-ot-and-over-40-hours-ot-sample-2-
Sheet: Sheet1

Date | Punch In | Punch Out | Daily Hours |  | Daily Regular Hours | Daily OT | Daily DOT |  |  |  |  | Weekly Hours | Daily OT Hours | OT > 40 Hours | Weekly Regular OT Hours | Paid OT Hours | Weekly Unpaid  OT Hours | Daily  Double OT Hours | OT Hours  > 12  (2x Regular Hourly Rate) | [NAME] | OT  Rate | Double  OT Rate | Daily OT Owed | Daily Double OT Owed | Total  OT Owed
2017-05-08 00:00:00 | 05:54:00 | 18:02:00
2017-05-09 00:00:00 | 05:55:00 | 18:01:00
2017-05-10 00:00:00
2017-05-11 00:00:00
2017-05-12 00:00:00 | 07:59:00 | 18:00:00
2017-05-13 00:00:00 | 05:52:00 | 18:00:00 |  |  |  |  |  |  |  |  |  |  | 6.25
2017-05-14 00:00:00 | 05:51:00 | 18:00:00 |  |  |  |  |  |  |  |  |  |  | 12 |  |  | 6 |  |  |  | 13.99
Spreadsheet: 99895d1298425102-tracking-income-and-invoices-for-projects-multiple-search-results-test-project-trackingvera
Sheet: 2010 Overview

 | 2010-2011 ROW FINANCIAL OVERVIEW |  |  |  |  |  |  |  |  |  |  |  |  | Todays Date |  | 2011-02-22 18:34:09
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Time |  | 2011-02-22 18:34:09
 | Profit to Date
 | 21319.21 |  |  | JUL | AUG | SEP | 1st QTR | OCT | NOV | DEC | 2nd QTR | JAN | FEB | MAR | 3rd QTR | APR | MAY | JUN | 4th QTR
 |  |  |  | -190.58 | -53.9 | -94.27000000000001 | -338.75 | -71.64999999999999 | 3511.43 | -23.87 | 3415.91 | 18242.05 | 0 | 0 | 18242.05 | 0 | 0 | 0 | 0
 |  | % of total |  | -0.008939355632783766 | -0.002528236271419063 | -0.004421833642053341 | -0.01588942554625617 | -0.00336081871701625 | 0.1647073226446946 | -0.001119647491628442 | 0.1602268564360499 | 0.8556625691102062 | 0 | 0 | 0.8556625691102062 | 0 | 0 | 0 | 0
 |  | TOTAL |  | JUL | AUG | SEP | 1st QTR | OCT | NOV | DEC | 2nd QTR | JAN | FEB | MAR | 3rd QTR | APR | MAY | JUN | 4th QTR
 | Income: | 29665.91 |  | 0 | 0 | 0 | 0 | 0 | 3835.91 | 0 | 3835.91 | 25830 | 0 | 0 | 25830 | 0 | 0 | 0 | 0
 |  | % of total |  | 0 | 0 | 0 | 0 | 0 | 0.1293036350477703 | 0 | 0.1293036350477703 | 0.8706963649522297 | 0 | 0 | 0.8706963649522297 | 0 | 0 | 0 | 0
 | Expenses: | 8346.7
 |  | TOTAL |  | JUL | AUG | SEP | 1st QTR | OCT | NOV | DEC | 2nd QTR | JAN | FEB | MAR | 3rd QTR | APR | MAY | JUN | 4th QTR
 | MAC | 7846.45 |  | 0 | 0 | 0 | 0 | 0 | 258.5 | 0 | 258.5 | 7587.95 | 0 | 0 | 7587.95 | 0 | 0 | 0 | 0
 | GN | 121.46 |  | 0 | 0 | 0 | 0 | 60.87 | 60.59 | 0 | 121.46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | HF | 378.79 |  | 190.58 | 53.9 | 94.27000000000001 | 338.75 | 10.78 | 5.39 | 23.87 | 40.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BM | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Totals |  | 190.58 | 53.9 | 94.27000000000001 | 338.75 | 71.64999999999999 | 324.48 | 23.87 | 420.0000000000001 | 7587.95 | 0 | 0 | 7587.95 | 0 | 0 | 0 | 0
 |  | % of total |  | 0.02283297590664574 | 0.006457641942324511 | 0.0112942839685145 | 0.04058490181748475 | 0.008584230893646589 | 0.03887524410845004 | 0.002859812860172283 | 0.05031928786226892 | 0.9090958103202462 | 0 | 0 | 0.9090958103202462 | 0 | 0 | 0 | 0
 |  |  |  | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN
 |  | Income |  | 0 | 0 | 0 | 0 | 3835.91 | 0 | 25830 | 0 | 0 | 0 | 0 | 0
 |  | Expenses |  | 190.58 | 53.9 | 94.27000000000001 | 71.64999999999999 | 324.48 | 23.87 | 7587.95 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 175930d1345669943-matching-two-variables-with-output-to-a-matrix-matrixexampleerror
Sheet: Matrix

 |  | Sub Department
 |  | Payroll | Tax | Contracts | HIPAA
Department | HR | 0 | 0 | 0 | 0
 | Regulatory | 0 | 0 | 0 | 0
 | Legal | 0 | 0 | 0 | 0
 | Finance | 0 | 0 | 0 | 0
Spreadsheet: 739811d1625970391-pulling-data-from-multiple-sheets-as-summary-power-query-to-combine-tables-kyber-
Sheet: Tab 1

Insurance | ID | Client Name | Meeting | # CNS | 60+ min? | Agent | CNS if [NAME] from Other Sess | Notes
Insurance 1 | 91966 | [NAME] | In Person | 1 |  | [NAME]
Insurance 2 | 88341 | Amber Riley
Insurance 3 | 33848 | [NAME]
Insurance 1 | 23739 | [NAME]
Insurance 2 | 43135 | [NAME]
Insurance 3 | 25826 | [NAME]
Insurance 1 | 80559 | [NAME]
Insurance 2 | 47064 | [NAME]
Insurance 3 | 84667 | [NAME]
Insurance 1 | 20382 | [NAME]
Insurance 2 | 50915 | [NAME]
Insurance 3 | 68065 | Cooper Manning
Insurance 1 | 67507 | [NAME]
Insurance 2 | 33733 | [NAME]
Insurance 3 | 39903 | [NAME]
Insurance 1 | 36003 | [NAME]
Insurance 2 | 99670 | [NAME]
Insurance 3 | 25465 | [NAME]
Insurance 1 | 53132 | [NAME]
Insurance 2 | 28902 | Eddie Izzard
Insurance 3 | 26732 | Eli Manning
Insurance 1 | 23030 | [NAME]
Insurance 2 | 75022 | [NAME]
Insurance 3 | 97961 | [NAME]
Insurance 1 | 64035 | [NAME]
Insurance 2 | 94388 | [NAME]
Insurance 3 | 31467 | [NAME]
Insurance 1 | 25339 | [NAME]
Insurance 2 | 36788 | [NAME]
Insurance 3 | 17279 | [NAME]
Insurance 1 | 50337 | [NAME]
Insurance 2 | 66334 | [NAME]
Insurance 3 | 62503 | [NAME]
Insurance 1 | 87608 | [NAME]
Insurance 2 | 64761 | [NAME]
Insurance 3 | 99567 | [NAME]
Insurance 1 | 80934 | [NAME]
Insurance 2 | 65131 | [NAME]
Insurance 3 | 24935 | [NAME]
Insurance 1 | 55156 | [NAME]
Insurance 2 | 40011 | [NAME]
Insurance 3 | 96790 | [NAME]
Insurance 1 | 71048 | [NAME]
Insurance 2 | 52278 | [NAME]
Insurance 3 | 46668 | [NAME]
Insurance 1 | 34486 | [NAME]
Insurance 2 | 84325 | [NAME]
Insurance 3 | 28777 | [NAME]
Insurance 1 | 72276 | [NAME]
Insurance 2 | 71450 | [NAME]
Insurance 3 | 86623 | [NAME]
Insurance 1 | 32805 | [NAME]
Insurance 2 | 64061 | Mitch Albom
Insurance 3 | 25334 | [NAME]
Insurance 1 | 33059 | Neve Campbell
Insurance 2 | 29584 | [NAME]
Insurance 3 | 65246 | [NAME]
Insurance 1 | 47991 | [NAME]
Insurance 2 | 20114 | [NAME]
Insurance 3 | 89474 | [NAME]
Insurance 1 | 94616 | [NAME]
Insurance 2 | 13337 | [NAME]
Insurance 3 | 33899 | [NAME]
Insurance 1 | 38877 | [NAME]
Insurance 2 | 54773 | [NAME]
Insurance 3 | 80147 | Sacha Baron [NAME]
Insurance 1 | 91024 | [NAME]
Insurance 2 | 49371 | [NAME]
Insurance 3 | 31930 | [NAME]
Insurance 1 | 93600 | [NAME]
Insurance 2 | 31883 | Smothers Brothers[B]
Insurance 3 | 53724 | [NAME]
Insurance 1 | 51599 | [NAME]
Insurance 2 | 95631 | [NAME]
Insurance 3 | 69745 | [NAME]
Insurance 1 | 89418 | [NAME]
Insurance 2 | 78101 | [NAME]
Spreadsheet: 507452d1489682097-calculating-federal-holidays-gs-timesheet
Sheet: Valuable Links

 |  | Valuable Links For GS Employees
 | [NAME]
 | Sick Leave Calculator |  |  | http://www.federalretirement.net/sickleave.htm
 | Career Planning
 | Career planning guidance for federal employees |  |  |  |  |  | http://fedcareerinfo.com
 | Federal employee's Retirement Planning Guidance |  |  |  |  |  | http://federalretirement.net
 | Retirement Planning
 | How to be Emotionally and Physically Prepared When You Retire |  |  |  |  |  |  |  | http://federalretirement.net/Site/images/report_physical_emotional_enduser.pdf
 | How to be Financially Prepared When You Retire |  |  |  |  |  |  |  | http://federalretirement.net/Site/images/report_financial_enduser.pdf
 | Master [NAME] (Important contact numbers and information) |  |  |  |  |  |  |  | http://federalretirement.net/Site/images/ContactList10_2010.pdf
 | Evaluating Your Annuity |  |  |  |  |  |  |  | http://federalretirement.net/annuity.htm
 | Are You Eligible to Retire |  |  |  |  |  |  |  | http://federalretirement.net/eligibility.htm
 | Annual Pay Scale Information
 | GS pay scale by year, state, & city |  |  |  |  | https://www.federalpay.org/
Spreadsheet: 7ccd293b-4a80-4c77-b577-de2fd9f8edab
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5024 | 30806 | Terence | Mitchell | RSA | 0 | 00:23:26 | 00:00:00 | 01:09:48 | 00:00:00 | 00:35:26 | 1 | 02:08:40
5024 | 31418 | [NAME] | [NAME] | RSA | 0 | 00:20:21 | 00:00:00 | 01:11:02 | 00:00:00 | 00:37:55 | 2 | 02:09:19
5024 | 30443 | [NAME] | Young | RSA | 0 | 00:21:40 | 00:00:00 | 01:13:14 | 00:00:00 | 00:39:48 | 3 | 02:14:44
5024 | 30836 | [NAME] | Moriarty | RSA | 0 | 00:30:44 | 00:00:00 | 01:18:54 | 00:00:00 | 01:04:50 | 4 | 02:54:29
5024 | 30483 | [NAME] | [NAME] | NZL | 0 | 00:19:07 | 00:00:00 | 01:07:07 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 123077d1317320462-excel-2007-counting-results-based-on-2-values-error-log-example
Sheet: Sheet1

Non-Auto-Authorisation Report |  | Week Ending
 |  | 2010-02-14 00:00:00
Type | Code
Advertsing requiring copy of publication. | AD
Comparison outside tolerance. | CT
Haulage requires authorisation by general manager. | HG
SML costs incorrect. | SC
Claim not present or incorrect. | CM
Items not booked in. | IB
Repairs requiring authorisation by general manager. | RG
Requires authorisation by financial director and/or MD. | RF
Requires authorisation by general manager. | GM
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Aug 22

Enter 1st of Month Here -> | 2022-08-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun