tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 542805d1508118672-linking-and-colouring-pivit-data-zenith-sales-ytd-simple-2017-
Sheet: Pivot

Year | 2017
Month | (Multiple Items)
Week | (Multiple Items)
 | Column Labels
 | Microsoft |  | Nokia |  | UberEats |  | Square POS |  | Epsilon |  | Sabre |  | Solana |  | Total Sales | Total change
Row Labels | Sales | change | Sales | change | Sales | change | Sales | change | Sales | change | Sales | change | Sales | change
2017-09-17 00:00:00 | 312 | 1 | 30.96 | 1 | 290.67 | 1 | 6719.54 | 1 | 325.5 | 1 | 656.21 | 1 | 373.51 | 1 | 8708.390000000001 | 1
2017-09-24 00:00:00 | 391.5 | 1.254807692307692 | 62.92 | 2.032299741602067 | 185.3 | 0.6374926893040217 | 8252.27 | 1.228100435446474 | 350.5 | 1.076804915514593 | 973.43 | 1.483412322274881 | 551.29 | 1.475971192203689 | 10767.21 | 1.23641798311743
2017-10-01 00:00:00 | 366.4 | 0.9358876117496806 | 30.96 | 0.4920534011443102 | 250.74 | 1.353157042633567 | 6233.5 | 0.7553679169489121 | 367 | 1.047075606276747 |  |  |  |  | 7248.6 | 0.6732106088763943
2017-10-08 00:00:00 | 540 | 1.473799126637555 | 15.98 | 0.5161498708010336 | 138.38 | 0.5518864162080243 | 6697 | 1.074356300633673 |  |  |  |  |  |  | 7391.36 | 1.019694837623817
Grand Total | 1609.9 |  | 140.82 |  | 865.09 |  | 27902.31 |  | 1043 |  | 1629.64 |  | 924.8 |  | 34115.56
Spreadsheet: steven_p_south__39351__Offer Sheets
Sheet: Year 2-5

Wild Goose Storage Inc. |  |  | January 26, 2001 Open Season |  |  |  | Offer Sheet
Term | commencing at | 2002-04-01 00:00:00 | and ending on | 2003-03-31 00:00:00 |  | Fill out one offer sheet for each year
Inventory Capacity : |  | 1000000 | Dth. |  |  | [NAME] is 2:00 MST, Friday January 26, 2001
 | Maximum | Injection | Injection | Inventory | Inventory | Maximum Daily | Withdrawal | Withdrawal | Monthly
 | Daily Injection | Demand | Demand | Demand | Demand | Withdrawal | Demand | Demand | Storage Demand
Month | Quantity | Rate | Charge (A) | Rate | Charge (B) | Quantity | Rate | Charge (C) | Charge
 |  |  |  |  |  |  |  |  | (A)+(B)+(C)
 | Dth/day/month | $US/Dth/day/month | $US/month | $US/Dth/month | $US/month | Dth/day/month | $US/Dth/day/month | $US/month | $US/month
Rack Rate: |  | 3 |  | 0.03 |  |  | 2
April | 0 | 0 |  | 0 |  | 0 | 0 |  |  |  | Rack Rate
May | 0 | 0 |  |  |  | 0 | 0
June | 0 | 0 |  |  |  | 0 | 0
July | 0 | 0 |  |  |  | 0 | 0
August | 0 | 0 |  |  |  | 0 | 0
September | 0 | 0 |  |  |  | 0 | 0
October | 0 | 0 |  |  |  | 0 | 0
November | 0 | 0 |  |  |  | 0 | 0
December | 0 | 0 |  |  |  | 0 | 0
January | 0 | 0 |  |  |  | 0 | 0
February | 0 | 0 |  |  |  | 0 | 0
March | 0 | 0 |  |  |  | 0 | 0
 |  |  |  |  | Total Storage Demand Charge (US$)
 |  |  |  |  | Rack Rate
Injection Commodity Rate: |  |  | 0.02 | $US/Dth | 0.02 | $US/Dth |  |  | of Rack Rate
Withdrawal Commodity Rate: |  |  | 0.02 | $US/Dth | 0.02 | $US/Dth
This offer is open for acceptance by Wild Goose Storage Inc. until 2:00 pm MST, Friday February 2, 2001.
 |  |  |  |  |  | Fax Offer Sheets to: [PHONE]
 |  |  |  |  |  | Attention: [NAME]
Company Name
Per:
 |  |  |  |  |  |  |  | 3900, 421 - 7th Avenue S.W.
 |  |  |  |  |  |  |  | Calgary, Alberta
 |  |  |  |  |  |  |  | Canada
Name: |  |  |  |  |  |  |  | T2P 4K9
Title:
Spreadsheet: 789100d1658907333-return-a-value-when-searching-for-a-text-string-within-a-cell-example-49-aligw
Sheet: EXPECTED

Item Number | Supplier Price(this is the cost price) | AliGW
7P29022NVLM12 | 50
7WFBP29022 | 50
7WFBP29022 : 7WFBP29022BKFL12 | 50
7WFBP29022 : 7WFBP29022BKLI10 | 50
7WFBP29022 : 7WFBP29022BKLI12 | 50
7WFBP29022 : 7WFBP29022BKLI14 | 50
7WFBP29022 : 7WFBP29022BKLI16 | 50
7WFBP29022 : 7WFBP29022BKLI8 | 50
7WFBP29022 : 7WFBP29022GYOR10 | 50
7WFBP29022 : 7WFBP29022GYOR12 | 50
7WFBP29022 : 7WFBP29022GYOR14 | 50
7ZP29022 | 50
7ZP305LS | 40
7ZP305LS : 7ZP305LSBK12 | 40
7ZP305LS : 7ZP305LSBK14 | 40
7ZP305LS : 7ZP305LSBK16 | 40
7WF14015 | 100
7WF14015 : 7WF14015NV10 | 100
7WF14015 : 7WF14015NV14 | 100
7WF14015 : 7WF14015NV18 | 100
7WF14015 : 7WF14015NV22 | 100
7WFBCL955LL | 10
7WFBCL955LL : 7WFBCL955LLBK10 | 10
7WFBCL955LL : 7WFBCL955LLBK12 | 10
7WFBCL955LL : 7WFBCL955LLBK14 | 10
7WFBCL955LL : 7WFBCL955LLBK16 | 10
Spreadsheet: 189569d1351236486-using-max-values-from-one-sheet-and-v-lookup-sample-formula
Sheet: Source

Yes | NA | Score 1 | Score 2 | Score 3
Emp ID | Name
001 | Word | 120 | 20 | 10
002 | Word | 140 | 45 | 11
002 | Excel | 2 | 35 | 13
001 | Excel | 80 | 45 | 16
Spreadsheet: 485731d1477033448-how-to-copy-3-columns-data-into-one-on-another-sheet-unpivot-using-power-query
Sheet: Data

# | DriverName | Number_of_Trips | BusNumber | BusType | School Name1 | School Name2 | School Name3
1 | Mark |  | B0026858 | Large |  | AlJood
2 | [NAME] |  | [NAME] | Large |  | [NAME] | Sariya
3 | [NAME] |  | B0009429 | Large | Sosan | AlJood
4 | [NAME] |  | B0021162 | Large | Taqwa |  | [NAME]
5 | Symonds |  | B0015512 | Small | Sosan
Spreadsheet: fce2d43e-1f34-4995-a8f9-0de0dfe7660c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6911 | 6001 | Sarka | [NAME] | CZE | 32 | 00:27:33 | 00:00:28 | 00:33:41 | 00:00:48 | 00:32:41 | 1 | 01:35:14
6911 | 15499 | Monika | Kadlecova | SVK | 31 | 00:32:10 | 00:00:29 | [NAME] | 00:00:41 | 00:39:01 | 2 | 01:45:16
6911 | 30335 | Tereza | Durdiakova | SVK | 34 | 00:28:49 | [NAME] | 00:41:38 | 00:01:26 | 00:36:43 | 3 | 01:49:21
6911 | 6010 | Kristina | Lapinova | SVK | 35 | 00:28:47 | 00:00:41 | [NAME] | 00:01:14 | 00:45:42 | 4 | 01:52:20
6911 | 28356 | [NAME] | Liparova | SVK | 36 | 00:33:10 | 00:00:38 | 00:37:47 | 00:01:55 | 00:50:08 | 5 | 02:03:42
6911 | 46293 | [NAME] | Kovacova | SVK | 0 | 00:32:09 | [NAME] | [NAME] | 00:01:22 | 00:49:58 | 6 | [NAME]
Spreadsheet: darrell_schoolcraft__7445__imball0202
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531 | -118118 | -48068
60667 | -5 | -149783
60749 | 8853 | 11822
61206
61334 | -79928
62960
INDEX
2002-01-31 00:00:00 |  |  | 10533
2002-02-04 00:00:00
CBS Volume
2001-12-31 00:00:00 |  |  | 3422
Spreadsheet: 842817d1694794601-looking-for-a-formula-to-exclude-rows-from-a-filtered-table-workqueue-template-copy
Sheet: RA Research

[PLAN NAME] Enrollment |  |  |  |  |  | TRC | 016 | 085 | 138 | 154 | 155 | 305
ID | Beneficiary ID | Last Name | First Name | DOB | Contract Num | State Code | County Code | TRC | TRC Short Name | File Name
 | RAND0M1D-085/154/305 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH6328.DTRRD.D230901
26 | RAND0M1D-085/154/306 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 154 | OUT OF AREA | EFTO.RH6328.DTRRD.D230901
27 | RAND0M1D-085/154/307 | JONES | MIKE | 19630226 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH6328.DTRRD.D230901
57 | TH1515ANMB1-305 | DUCK | [NAME] | 19510915 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230902
87 | B3N3F1C1@RY-085/154/305 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH6328.DTRRD.D230907
88 | B3N3F1C1@RY-085/154/306 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 154 | OUT OF AREA | EFTO.RH6328.DTRRD.D230907
89 | B3N3F1C1@RY-085/154/307 | [NAME] | MICKEY | 19500205 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH6328.DTRRD.D230907
107 | RUNN1NG0UT-305 | [NAME] | MINNIE | 19560804 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230907
161 | 2M0R3EXMPL5-085/305 | JACOB | [NAME] | 19701008 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH2171.DTRRD.D230912
163 | 2M0R3EXMPL5-085/305 | JACOB | [NAME] | 19701008 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230912
164 | [NAME] | WOMAN | WONDER | 19551108 | CONTRACT | SC | 0CC | 085 | NEW SCC | EFTO.RH2171.DTRRD.D230912
166 | [NAME] | WOMAN | WONDER | 19551108 | CONTRACT | SC | 0CC | 305 | ZIP CD CHANGE | EFTO.RH2171.DTRRD.D230912
Spreadsheet: 67104d1267719987-search-and-display-multiple-values-across-multiple-columns-schedule-of-meetings-beta
Sheet: Week Schedule

Current Week Schedule
[NAME]
 | Week 1 of March 2010
 | Issue Date: | 2010-03-04 00:00:00
2010-03-01 00:00:00 | Time | Item/Notes | Location |  | Number Of Meetings
 |  |  |  |  | 0
2010-03-02 00:00:00 | Time | Item/Notes | Location |  | Number Of Meetings
 |  |  |  |  | 0
2010-03-03 00:00:00 | Time | Item/Notes | Location |  | Number Of Meetings
 |  |  |  |  | 0
2010-03-04 00:00:00 | Time | Item/Notes | Location |  | Number Of Meetings
 | 17:00 - 18:30 | Design Team Meeting | Somewhere |  | 3
 | 16:00 - 17:00 | Pre-Design Team Meeting | Somewhere
 | 13:00 - 15:00 | BIW Training Session | Somewhere
2010-03-05 00:00:00 | Time | Item/Notes | Location |  | Number Of Meetings
 |  |  |  |  | 0
Spreadsheet: 454986d1460052656-team-composition-maker-for-game-ferdyhar
Sheet: Skill

Character | FerdyHar | Dark | Fairdal | Dreadparadox | ForTheHorde | BEST | 2nd | 3rd | 4th | 5th |  | RANK | FerdyHar | Dark | Fairdal | Dreadparadox | ForTheHorde
[NAME] | 4 | 1 | 3 | 2 | 1 |  |  |  |  |  |  | 1
Anub'arak | 3 | 4 | 2 | 3 | 2 |  |  |  |  |  |  | 2
Artanis | 3 | 5 | 3 | 4 | 4 |  |  |  |  |  |  | 3
[NAME] | 3 | 3 | 4 | 3 | 1 |  |  |  |  |  |  | 4
Azmodan | 4 | 1 | 1 | 4 | 1 |  |  |  |  |  |  | 5
Brightwing | 5 | 1 | 3 | 2 | 1 |  |  |  |  |  |  | 6
[NAME] | 4 | 4 | 2 | 3 | 1 |  |  |  |  |  |  | 7
Cho | 2 | 3 | 3 | 4 | 3 |  |  |  |  |  |  | 8
Gall | 4 | 3 | 1 | 5 | 4 |  |  |  |  |  |  | 9
Dehaka | 1 | 5 | 1 | 3 | 1 |  |  |  |  |  |  | 10
Diablo | 4 | 5 | 2 | 5 | 3
E.T.C. | 4 | 5 | 4 | 4 | 3
Falstad | 5 | 2 | 4 | 3 | 1
Gazlowe | 2 | 3 | 3 | 3 | 2
Greymane | 3 | 4 | 2 | 5 | 4
Illidan | 4 | 4 | 4 | 5 | 3
Jaina | 4 | 5 | 3 | 4 | 4
[NAME] | 3 | 5 | 2 | 3 | 2
Kael'thas | 3 | 3 | 1 | 5 | 3
Kerrigan | 3 | 4 | 2 | 3 | 4
Kharazim | 5 | 1 | 3 | 2 | 5
Leoric | 3 | 4 | 4 | 4 | 1
[NAME] | 4 | 1 | 3 | 4 | 5
[NAME] | 5 | 3 | 2 | 4 | 3
Lt. Moralis | 5 | 3 | 3 | 2 | 5
Lunara | 3 | 5 | 4 | 1 | 1
Malfurion | 5 | 1 | 2 | 2 | 5
Muradin | 4 | 3 | 3 | 4 | 3
[NAME] | 2 | 1 | 5 | 4 | 1
Nazeebo | 2 | 1 | 4 | 3 | 1
Nova | 3 | 3 | 2 | 2 | 3
Raynor | 2 | 3 | 3 | 5 | 5
Rehgar | 4 | 3 | 4 | 3 | 5
[NAME] | 1 | 3 | 3 | 3 | 1
Sgt. Hammer | 1 | 4 | 4 | 4 | 3
Sonya | 3 | 5 | 3 | 3 | 3
Stitches | 3 | 4 | 3 | 4 | 1
Sylvanas | 3 | 4 | 4 | 4 | 3
Tassadar | 4 | 4 | 2 | 4 | 3
The Butcher | 4 | 3 | 3 | 4 | 3
The Lost Vikings | 2 | 1 | 4 | 1 | 1
Thrall | 5 | 4 | 4 | 5 | 3
Tychus | 3 | 1 | 2 | 5 | 4
[NAME] | 4 | 3 | 3 | 3 | 1
Tyrande | 3 | 4 | 3 | 2 | 4
Uther | 5 | 1 | 2 | 4 | 4
Valla | 4 | 3 | 3 | 4 | 4
[NAME] | 3 | 4 | 3 | 5 | 1
Zagara | 5 | 4 | 3 | 3 | 5
Zeratul | 4 | 4 | 4 | 3 | 1
Spreadsheet: lacher25
Sheet: Training and Consulting

 |  |  |  |  | http://www.lacher.com
 |  | Sample [NAME] and Applications
 |  |  |  | Free downloads at: | www.lacher.com
 |  | Excel Tutorials
 |  |  | In workbook format with examples, practice ideas and short video demonstrations
 |  |  | Each tutorial covers Excel skills needed for specific applications:
 |  |  |  | Budgeting
 |  |  |  | Sales Reporting
 |  |  |  | Data Analysis
 |  |  |  | Reporting
 |  |  |  | Financial Statement Presentation
 |  |  |  | Charting
 |  |  |  | Pivot Tables
 |  |  |  | Purchase tutorials: | www.lacher.com
 |  | Custom Application Development Via the Internet
 |  |  | Excel, Access, [NAME], Word, Visual Basic
 |  |  |  | Add nationally recognized Excel, Access and MS Office Experts to your team --  with strong business
 |  |  |  | management backgrounds who are also nationally recognized MS Office consultants and authors.
 |  |  |  | Pay only for the help you need. To have the same level of expertise at your site, you would need to pay large fees for
 |  |  |  | recruiting -- or a consultant's travel expenses and daily rate. With On Line Consulting via the Internet, you can receive expert
 |  |  |  | attention in small chunks of time, as needed.
 |  |  |  | Receiving efficient help via the Internet means fewer phone calls and meetings. You can work with the MS Office Expert on your
 |  |  |  | schedule, corresponding via E-Mail at any time and from any location.
 |  |  |  | More information: | [EMAIL]
Spreadsheet: 80807d1280989545-use-of-if-function-for-more-than-7-times-in-one-formulae-lookuptable-datavalidation
Sheet: Sheet1

 | [NAME]
Data
R1
R2 | 1
R3 | 2 |  |  |  | Yellow section is named Status
R4 | 3 |  |  |  | Green section is named [NAME]
R5 | 4 |  |  |  | each section needs to be the same length
R6 | 5
R7 | 6 |  |  |  | Then a standard LOOKUP formula will work because your Status list is sorted
R8 | 5 |  |  |  | Data Validation list added to cell A2.
R9 | 3
R10 | 5
R11 | 6
R12 | 3
 | 5
Spreadsheet: 39402d1237557244-producing-automatic-reports-with-2-variables-example-44
Sheet: Inbound Recodring

 | Today |  |  | 2009-03-20 13:46:38
 | Marketing Conversion Cummulative YTD
 |  |  |  |  | Outcome
 | Source Code | Inbound |  | Outcome 1 |  | Outcome 2 |  | Outcome 3 |  | Outcome 4 |  | Outcome 5 |  | Outcome 6 |  | Outcome 7 |  | Outcome 8 |  | Outcome 9 |  | Outcome 10
 |  | % | No | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | %
Spreadsheet: 740174d1626207481-how-to-auto-populate-information-from-one-tab-to-the-other-moveuniquevalues-1-
Sheet: Sheet7

Result |  | Cl Seen | # of Self Pay | # of Units | Rate | Total | Need to Follow Up
 |  |  |  |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  |  |  |  | [NAME] | 6
 |  |  |  |  |  |  |  |  |  | [NAME] | 7
 |  |  |  |  |  |  |  |  |  | [NAME] | 8
 |  |  |  |  |  |  |  |  |  | Amber Riley | 9
 |  |  |  |  |  |  |  |  |  | [NAME] | 10
 |  |  |  |  |  |  |  |  |  | [NAME] | 0.01
Spreadsheet: a9d33871-e130-450d-b481-2ec3102b4533
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
40986800 | 2014-04-14 15:14:39 | AXIS | 1 | 7 | 4 | 21590 | Greenheart22 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
40987007 | 2014-04-14 15:31:08 | ALLIES | 0 | 4 | 7 | 569334 | Breakmate | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40987130 | 2014-04-14 15:45:06 | AXIS | 1 | 7 | 4 | 569334 | Breakmate | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
41004520 | 2014-04-15 19:45:58 | ALLIES | 0 | 1 | 6 | 1348201 | ironkastel | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
41004905 | 2014-04-15 20:35:58 | AXIS | 1 | 6 | 5 | 1348201 | ironkastel | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: East - Orig

 | East Gas - Orig
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 567600 | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 116920 | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 30000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 225000 | Total
ENAOUTSV | Outside Services |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 20000
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 5000 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | 0 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 20000 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 5652 | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 139678d1328377664-please-help-me-with-this-chart-not-sure-where-to-start-machine-problem
Sheet: Pivot Data

 | Daily Problems |  |  |  |  |  |  | Weekly Problems |  |  |  |  |  |  | Montly Problems
 |  | Values |  |  |  |  |  |  | Values |  |  |  |  |  |  | Values
 | Row Labels | Die problem | Material problem | Conveyor problem | Glued pin problem | Weighing problem |  | Row Labels | Sum of Die problem | Sum of material problem | Sum of conveyor problem | Sum of glued pin problem | Sum of weighing problem |  | Row Labels | Sum of Die problem | Sum of material problem | conveyor problem | Sum of glued pin problem | Sum of weighing problem
 | 2012 | 25 | 60 | 88 | 15 | 17 |  | 2012 | 67 | 85 | 210 | 98 | 50 |  | 2012 | 67 | 85 | 210 | 98 | 50
 | 1 |  | 12 |  |  |  |  | 1 | 6 | 12 | 2 | 35 | 7 |  | Feb | 67 | 85 | 210 | 98 | 50
 | 2012-02-01 00:00:00 |  | 12 |  |  |  |  | 5 | 6 | 12 | 2 | 35 | 7 |  | 1 | 6 | 12 | 2 | 35 | 7
 | 2012-02-02 00:00:00 |  |  |  |  |  |  | 2 | 1 |  | 78 | 45 | 4 |  | 2 | 1 |  | 78 | 45 | 4
 | 2 | 1 |  | 78 |  |  |  | 5 | 1 |  | 78 | 45 | 4 |  | 3 | 24 | 24 | 10 | 3 | 9
 | 2012-02-01 00:00:00 |  |  |  |  |  |  | 3 | 24 | 24 | 10 | 3 | 9 |  | 4 |  | 1 |  | 5 | 8
 | 2012-02-02 00:00:00 | 1 |  | 78 |  |  |  | 5 | 24 | 24 | 10 | 3 | 9 |  | 5 | 15 | 3 | 86 | 10
 | 3 | 24 |  | 10 |  | 9 |  | 4 |  | 1 |  | 5 | 8 |  | 6 | 21 | 45 | 34 |  | 22
 | 2012-02-01 00:00:00 | 24 |  | 10 |  |  |  | 5 |  | 1 |  | 5 | 8 |  | Grand Total | 67 | 85 | 210 | 98 | 50
 | 2012-02-02 00:00:00 |  |  |  |  | 9 |  | 5 | 15 | 3 | 86 | 10
 | 4 |  |  |  | 5 | 8 |  | 5 | 15 | 3 | 86 | 10
 | 2012-02-01 00:00:00 |  |  |  |  | 8 |  | 6 | 21 | 45 | 34 |  | 22
 | 2012-02-02 00:00:00 |  |  |  | 5 |  |  | 5 | 21 | 45 | 34 |  | 22
 | 5 |  | 3 |  | 10 |  |  | Grand Total | 67 | 85 | 210 | 98 | 50
 | 2012-02-01 00:00:00 |  |  |  | 10
 | 2012-02-02 00:00:00 |  | 3
 | 6 |  | 45
 | 2012-02-01 00:00:00 |  | 45
 | 2012-02-02 00:00:00
 | Grand Total | 25 | 60 | 88 | 15 | 17
Spreadsheet: 91e31083-81e6-4d64-8445-5847f23c2c12
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6371 | 43347 | [NAME] | Fruehwirth | AUT | 53 | 00:12:17 | 00:00:33 | [NAME] | 00:00:43 | 00:05:21 | 1 | 00:58:44
6371 | 51612 | Rafael | Botello Jimenez | ESP | 52 | [NAME] | 00:00:56 | 00:41:46 | 00:01:58 | 00:05:29 | 2 | 01:02:13
6371 | 40702 | Alain | Fuertes | ESP | 51 | 00:13:20 | 00:01:46 | 00:43:02 | [NAME] | 00:06:07 | 3 | 01:06:12
6371 | 49381 | Norberto | [NAME] | ESP | 54 | 00:16:30 | 00:01:45 | 00:48:34 | 00:01:58 | 00:07:33 | 4 | 01:16:19
Spreadsheet: 131262d1322838981-daily-summary-sheet-that-autopopulates-each-day-vlookupyesterday
Sheet: Data

 | Position 1 |  |  | Position 2 |  |  | Position 3 |  |  | Total
2011-10-01 00:00:00 | [NAME] | 100 |  | Lorenzo | 200 |  | [NAME] | 150 |  |  |  | You should do a Dynamic Named Range on this table
2011-10-02 00:00:00 | [NAME] | 101 |  | [NAME] | 201 |  | [NAME] | 151 |  |  |  | and use that name in the formula on Daily Summay sheet.
2011-10-03 00:00:00 | [NAME] | 102 |  | Garry | 202 |  | Lance | 152
2011-10-04 00:00:00 | [NAME] | 103 |  | Martin | 203 |  | [NAME] | 153
2011-10-05 00:00:00 | [NAME] | 104 |  | Lorenzo | 204 |  | [NAME] | 154
2011-10-06 00:00:00 | [NAME] | 105 |  | [NAME] | 205 |  | [NAME] | 155
2011-10-07 00:00:00 | [NAME] | 106 |  | Garry | 206 |  | Lance | 156
2011-10-08 00:00:00 | [NAME] | 107 |  | Martin | 207 |  | [NAME] | 157
2011-10-09 00:00:00 | [NAME] | 108 |  | Lorenzo | 208 |  | [NAME] | 158
2011-10-10 00:00:00 | [NAME] | 109 |  | [NAME] | 209 |  | [NAME] | 159
2011-10-11 00:00:00 | [NAME] | 110 |  | Garry | 210 |  | Lance | 160
2011-10-12 00:00:00 | [NAME] | 111 |  | Martin | 211 |  | [NAME] | 161
2011-10-13 00:00:00 | [NAME] | 112 |  | Lorenzo | 212 |  | [NAME] | 162
Spreadsheet: 81371d1281568598-get-info-from-one-row-into-another-based-on-a-cell-datavalidationandindexmatch
Sheet: config

Time
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
Ringer
Spreadsheet: 119716d1314684189-help-would-be-greatly-appreciated-room-rates2
Sheet: Sheet1

Annupuri Lodge
Guest Name
Phone Number
[NAME]
Additional Guests
Number of Pax
Room Type
Room Rate
 | Room rates
Rooms | Room Type | Rate
A | Bunk/ Dorm Room | 5500
B | King Room for 1 Pax | 16800
C | King Room for 2 Pax | 8400
D | Down Stairs Dorm | 4500
E | Down Stairs Dry Room | 7000
F | Children | 7400
Spreadsheet: 129294d1321539406-match-with-a-parametric-table-array-that-links-to-different-files-01-alky
Sheet: Rese Tecniche

Cariche | Descrizione | [NAME] | Effettivo | Target | Eff-Tgt | Effettivo %p | Target %p | Eff-Tgt %p
sample
sample2
Produzioni | Descrizione | [NAME] | Effettivo | Target | Eff-Tgt | Effettivo %p | Target %p | Eff-Tgt %p
sample
sample2
sample
sample2
Spreadsheet: 675934d1588573131-excel-formula-counting-time-of-late-excel-test-2
Sheet: summary

Summary
 |  |  |  |  |  |  |  | input 1st date
ID | name | site | total late | time of late > 30 minutes | other1 | other2 |  | 2020-03-26 00:00:00
S123
S456
Spreadsheet: 716468d1612222777-match-2-sets-of-columns-and-send-any-unmatched-values-to-the-bottom-lists
Sheet: Sheet1

List 1 |  |  | List 2 |  |  | Desired Outcome
Araujo | [NAME] |  | Araujo | [NAME] |  | Araujo | [NAME]
[NAME] | Sleyde |  | [NAME] | Sleyde |  | [NAME] | Sleyde
Baglow | [NAME] |  | Baglow | [NAME] |  | Baglow | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME] |  | [NAME] | [NAME]
Ballard | [NAME] |  | Ballard | [NAME] |  | Ballard | [NAME]
[NAME] | [NAME] |  | [NAME] | [NAME] |  | [NAME] | [NAME]
Canever | Samantha |  | [NAME] | [NAME] |  | Canever | Samantha
Cheeseman-Meyer | Hanna |  | Canever | Samantha |  | Cheeseman-Meyer | Hanna
Custer | [NAME] |  | Cheeseman-Meyer | Hanna |  | Custer | [NAME]
[NAME] | [NAME] |  | Custer | [NAME] |  | [NAME] | [NAME]
Edwards | [NAME] |  | [NAME] | [NAME] |  | Edwards | [NAME]
[NAME] | Alexandra |  | Edwards | [NAME] |  | [NAME] | Alexandra
Lund | [NAME] |  | [NAME] | Alexandra |  | Lund | [NAME]
Martin | [NAME] |  | Lund | [NAME] |  | Martin | [NAME]
Martins | Victoria |  | Mantle | [NAME] |  | Martins | Victoria
Matos | Aline |  | Martin | [NAME] |  | Matos | Aline
Nacif | [NAME] |  | Martins | Victoria |  | Nacif | [NAME]
Nobrega | Nayara |  | Matos | Aline |  | Nobrega | Nayara
Paixao | Lucas |  | Mogul | Jeremy |  | Paixao | Lucas
[NAME] | [NAME] |  | Nacif | [NAME] |  | [NAME] | [NAME]
Silva | Cleo |  | Nobrega | Nayara |  | Silva | Cleo
Silva | Cristian |  | Paixao | Lucas |  | Silva | Cristian
Silva | Ione |  | [NAME] | [NAME] |  | Silva | Ione
Theiriaque | Preston |  | Silva | Cleo |  | Theiriaque | Preston
 |  |  | Silva | Cristian |  | [NAME] | [NAME]
 |  |  | Silva | Ione |  | Mantle | [NAME]
 |  |  | Theiriaque | Preston |  | Mogul | Jeremy