tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 190605d1351714162-inventory-run-out-calculator-need-help-with-final-step-run-out-calculation
Sheet: Sheet1

Supplier Number | [NAME] |  | Part Number | Part Description |  |  | Legend
1000 | ABC Company |  | 1234567890 | TMNT Legos |  |  |  | Enter Information
 |  |  |  |  |  |  |  | Automatically calculated, do not touch
Supplier |  |  |  | Customer Demand
Input | 250 |  |  | Start Date and Time | 2012-10-31 08:00:00
Supplier OEE% | 0.8 |  |  | Running Hours | 24
Throughput | 190
Run-Out Time
Date | [NAME] (-) | Use per hour | [NAME] (+) | Difference | On-Hand
2012-10-30 08:00:00 |  |  |  |  | 1000
2012-10-31 08:00:00 | 368 | 15.33333333333333 | 190 | -178 | 822
2012-11-01 08:00:00 | 383 | 15.95833333333333 | 190 | -193 | 629
2012-11-02 08:00:00 | 374 | 15.58333333333333 | 190 | -184 | 445
2012-11-03 08:00:00 | 145 | 6.041666666666667 | 190 | 45 | 490
2012-11-04 08:00:00 | 0 | 0 | 190 | 190 | 680
2012-11-05 08:00:00 | 323 | 13.45833333333333 | 190 | -133 | 547
2012-11-06 08:00:00 | 360 | 15 | 190 | -170 | 377
2012-11-07 08:00:00 | 345 | 14.375 | 190 | -155 | 222
2012-11-08 08:00:00 | 335 | 13.95833333333333 | 190 | -145 | 77
2012-11-09 08:00:00 | 362 | 15.08333333333333 | 190 | -172 | -95
2012-11-10 08:00:00 | 153 | 6.375 | 190 | 37 | -58
2012-11-11 08:00:00 | 0 | 0 | 190 | 190 | 132
2012-11-12 08:00:00 | 260 | 10.83333333333333 | 190 | -70 | 62
2012-11-13 08:00:00 | 335 | 13.95833333333333 | 190 | -145 | -83
2012-11-14 08:00:00 | 269 | 11.20833333333333 | 190 | -79 | -162
2012-11-15 08:00:00 | 308 | 12.83333333333333 | 190 | -118 | -280
2012-11-16 08:00:00 | 343 | 14.29166666666667 | 190 | -153 | -433
2012-11-17 08:00:00 | 146 | 6.083333333333333 | 190 | 44 | -389
2012-11-18 08:00:00 | 0 | 0 | 190 | 190 | -199
2012-11-19 08:00:00 | 245 | 10.20833333333333 | 190 | -55 | -254
2012-11-20 08:00:00 | 320 | 13.33333333333333 | 190 | -130 | -384
2012-11-21 08:00:00 | 380 | 15.83333333333333 | 190 | -190 | -574
2012-11-22 08:00:00 | 155 | 6.458333333333333 | 190 | 35 | -539
2012-11-23 08:00:00 | 0 | 0 | 190 | 190 | -349
2012-11-24 08:00:00 | 0 | 0 | 190 | 190 | -159
2012-11-25 08:00:00 | 0 | 0 | 190 | 190 | 31
2012-11-26 08:00:00 | 283 | 11.79166666666667 | 190 | -93 | -62
2012-11-27 08:00:00 | 372 | 15.5 | 190 | -182 | -244
2012-11-28 08:00:00 | 385 | 16.04166666666667 | 190 | -195 | -439
2012-11-29 08:00:00 | 390 | 16.25 | 190 | -200 | -639
2012-11-30 08:00:00 | 387 | 16.125 | 190 | -197 | -836
2012-12-01 08:00:00 | 409 | 17.04166666666667 | 190 | -219 | -1055
Spreadsheet: 34402d1231643313-multiple-condition-vlookup-copy-of-book1
Sheet: data2

s87544 | int | 588.6
45rrt5y6 | int | 577.6 | s87544int | s87544int | 1
jgjg74h4jd | pydn | #N/A
u3hhff7 | int | 2223
[NAME] | pydn | #N/A
[NAME] | int | 318554
fjnvfnfu8 | pydn | #N/A
fvihcwyw | int | 121543
ghmlmho | int | 187944
wtwsvwr | int | 1941648
wfeyegdb | pydn | #N/A
sdysfw5 | int | 2
sdubgcua | int | 5
uwecdysv | pydn | 6996
Spreadsheet: 804514d1668110617-index-match-and-offset-statement
Sheet: Statement

 |  | COMPANY
ACCOUNT # : |  |  |  | P.O. # : 701826071-
INVOICE # :  990 |  | DATE OF SALE : 221003 |  | # : 460
TRANSACTION # : 0 |  |  |  | REGISTER # :
S.K.U | [NAME] | QUANTITY   UNIT |  | PRICE | EXT. PRICE
12 | Product 1 | 5 | EA | 3.78 | 18.9
13 | Product 2 | 1 | PK | 16.13 | 16.13
14 | Product 3 | 1 | PC | 9.29 | 9.29
SUB $44.32 |  | TAX $2.66 |  | TOTAL INVOICE | 46.98
 |  |  |  | CREDITS TOTAL | 0
 |  |  |  | BALANCE DUE | 46.98
 |  | COMPANY
ACCOUNT # : |  |  |  | P.O. # : 701826071-
INVOICE # :  991 |  | DATE OF SALE : 221003 |  | # : 460
TRANSACTION # : 0 |  |  |  | REGISTER # :
S.K.U | [NAME] | QUANTITY   UNIT |  | PRICE | EXT. PRICE
15 | Product 4 | 2 | EA | 22.78 | 45.56
SUB $45.56 |  | TAX $2.73 |  | TOTAL INVOICE | 48.29
 |  |  |  | CREDITS TOTAL | 0
 |  |  |  | BALANCE DUE | 48.29
 |  | COMPANY
ACCOUNT # : |  |  |  | P.O. # : 702121594-
INVOICE # :  992 |  | DATE OF SALE : 221003 |  | # : 1923
TRANSACTION # : 0 |  |  |  | REGISTER # :
S.K.U | [NAME] | QUANTITY   UNIT |  | PRICE | EXT. PRICE
16 | Product 5 | 1 | EA | 2.84 | 2.84
SUB $2.84 |  | TAX $0.17 |  | TOTAL INVOICE | 3.01
 |  |  |  | CREDITS TOTAL | 0
 |  |  |  | BALANCE DUE | 3.01
 |  | COMPANY
ACCOUNT # : |  |  |  | P.O. # : 701950190-
INVOICE # :  993 |  | DATE OF SALE : 221003 |  | # : 1923
TRANSACTION # : 0 |  |  |  | REGISTER # :
S.K.U | [NAME] | QUANTITY   UNIT |  | PRICE | EXT. PRICE
17 | Product 6 | 1 | EA | 12.24 | 12.24
SUB $12.24 |  | TAX $0.73 |  | TOTAL INVOICE | 12.97
 |  |  |  | CREDITS TOTAL | 0
 |  |  |  | BALANCE DUE | 12.97
 |  | COMPANY
ACCOUNT # : |  |  |  | P.O. # : 702057636-
INVOICE # :  994 |  | DATE OF SALE : 221003 |  | # : 1923
TRANSACTION # : 0 |  |  |  | REGISTER # :
S.K.U | [NAME] | QUANTITY   UNIT |  | PRICE | EXT. PRICE
18 | Product 7 | 1 | EA | 47.49 | 47.49
SUB $47.49 |  | TAX $2.85 |  | TOTAL INVOICE | 50.34
 |  |  |  | CREDITS TOTAL | 0
 |  |  |  | BALANCE DUE | 50.34
Spreadsheet: 87405d1287252107-show-all-information-with-a-certain-value-voorbeeld-r
Sheet: Opel #092

Project: | Opel | #082
Supplier | Contactperson | E-mail | System
Sony
Spreadsheet: 700391d1603183310-summary-creation-from-source-data-skills-by-day-lates-v3
Sheet: List of Workers

Date | 2020-11-20 00:00:00
S. No. | Decant | E.Receive | Prep | Coral 1 | Coral 2 | Coral 3 | WaterSpider | PumpTruck | Instructors | Stow | Problem solve | Cubi Scan | Pack | Receive | Pick | Other 1 | Other 2 | Other 3
 | user | user | user | user | user | user | user | user | user | user | user | user | user | user | user | user | user | user
1
Spreadsheet: 137796d1327386952-help-with-vlookups-on-non-sorted-data-example
Sheet: Sheet1

ID | Species | Tank | Notes | Stage | W1 | [NAME] | W3 | W4 | W5
SP1 | X | 4 | All D | 1-2
SP2 | I | 3 | All H 1LN | 1-2
SP3 | I | 2 |  | 1-2 | 1
SP4 | X | 2 | >50% H 1st H = 11 | 1-2 | 3 | 2
SP5 | C | 3 | All H All LN Final now T1 | 1-2 | 7 | 5
SP6 | I | 3 | All LN 4 Unfert Final | 1-2 | 10 | 15
SP7 | I | 7 | 1st H LN | 1-2 | 8
SP8 | I | 7 | LN | 1-2 | 9
SP9 | I | 7 | LN Sandy | 1-2 | 4 | 11
SP10 | C | 3 | 20LN Final 1st H = 15 | 2-3 | 18
SP11 | C | 7 | All LN 1st H = 6 | 2-3 | 13 | 14 | 6 | 16 | 17
SP12 | X | 7 | LN 1st H = 6 | 2-3 | 12 | 19 | 20 | 21 | 22
Spreadsheet: 60244d1260822220-inserting-text-into-spreadsheet-book4
Sheet: Sheet2

 |  | Tgt # | lon (w)
 |  | 1 | [NAME]
 |  | 2 | [NAME]
 |  | 3 | [NAME]
 |  | 4 | [NAME]39.476'
 |  | 5 | [NAME]
 |  | 6 | [NAME]39.450'
 |  | 7 | [NAME]
 |  | 8 | [NAME]
 |  | 9 | [NAME]42.288'
Spreadsheet: a60557c7-4962-4a78-91ef-8df27f534155
Sheet: Sheet1

Securities | % of Assets
Veresen Inc. | 3.44%
BCE Inc. | 2.99%
Capital Power Corp | 2.95%
Emera Inc. | 2.67%
Enbridge Income Fund Hld | 2.61%
National Bank of Canada | 2.60%
Northland Power Inc | 2.58%
Crescent Point Energy Crp | 2.53%
Fortis Inc. | 2.50%
Great-West Life Company | 2.43%
Shaw Communicatn Cl B Nvs | 2.37%
Rogers Communications Inc | 2.34%
Canadian Oil Sands Ltd | 2.34%
Cdn Imperial Bk of Commrc | 2.33%
Bank of Montreal | 2.33%
Keyera Corp | 2.27%
Power Financial Corp. | 2.23%
Inter Pipeline Ltd. | 2.22%
TransCanada Corp. | 2.21%
Potash Corp of Saskatchwn | 2.19%
Royal Bank of Canada | 2.19%
Thomson Reuters Corp | 2.18%
Power Corporation Canada | 2.17%
Freehold Royalties Ltd | 2.13%
Sun Life Financial Inc. | 2.12%
Pembina Pipeline Inc | 2.11%
IGM Financial Inc. | 2.09%
TELUS Corp. | 2.04%
Bank of Nova Scotia | 2.04%
Baytex Energy Corp. | 2.00%
Transcontinental Inc Cl A | 1.95%
Toronto-Dominion Bank | 1.93%
[NAME] Cl B Nvs | 1.75%
ARC Resources Ltd | 1.72%
Genworth MI Canada Inc | 1.72%
Cineplex Inc. | 1.70%
BROOKFIELD PROPERTY PTNER | 1.59%
Wajax Corporation | 1.58%
Enbridge Inc. | 1.53%
Vermilion Energy Inc. | 1.47%
AGF Management Ltd Cl B | 1.44%
CI Financial Corp | 1.42%
Mullen Group Ltd. | 1.37%
Dorel Industries Inc Cl B | 1.34%
Husky Energy Inc. | 1.32%
First Capital Realty Inc | 1.24%
Aimia Inc. | 1.06%
Teck Resources Ltd Cl B | 0.84%
Ensign Energy Srvcs Inc | 0.84%
Canexus Corporation | 0.53%
Cash | 0.45%
Total Holdings in Portfolio | 51
Spreadsheet: 686415d1594609953-avoiding-deleting-information-as-the-year-begins-avoiding-delete-information
Sheet: Sheet1

ZW$ |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | 2019 |  |  | Month | January
Sales Journal
Date | Customer Code | Name | Vat Number | Invoice | Amount | Vat % | [NAME] | Amount incl [NAME] | Payment Terms |  | 1919-01-01 00:00:00 | 1919-02-01 00:00:00 | 1919-03-01 00:00:00 | 1919-04-01 00:00:00 | 1919-05-01 00:00:00 | 1919-06-01 00:00:00 | 1919-07-01 00:00:00 | 1919-08-01 00:00:00 | 1919-09-01 00:00:00 | 1919-10-01 00:00:00 | 1919-11-01 00:00:00 | 2020-12-01 00:00:00 | Year to date
1919-01-01 00:00:00 | C001 |  |  | 2020-0001 | 10000 | 0.15 |  |  | 20
1919-01-02 00:00:00 | C002 |  |  | 2020-0002 | 20000 |  |  |  | 30
1919-02-03 00:00:00 | C005 |  |  | 2020-0003 | 30000
1919-02-04 00:00:00 | C010 |  |  | 2020-0004 | 40000 |  |  |  |  |  | Question 1: |  | I want click  at Q3 to show the report for 2020 and at U3 to show the relevant month, at the report is for 2019
1919-03-05 00:00:00 | C001 |  |  | 2020-0005 | 5000
1919-06-06 00:00:00 | C002 |  |  | 2020-0006 | 10000 |  |  |  | 20
1919-04-07 00:00:00 | C005 |  |  | 2020-0007 | 15000 |  |  |  |  |  | Question 2: |  | Requesting for formula which will detect that the invoice number is already used in the sales Journal.
1919-05-08 00:00:00 | C010 |  |  | 2020-0008 | 20000 |  |  |  |  |  |  |  | and is it possible to have formula for incrementing invoice number?
1919-06-01 00:00:00 | C001 |  |  | 2020-0009 | 2000
1919-07-02 00:00:00 | C002 |  |  | 2020-0010 | 4000 |  |  |  | 10 |  |  | INVOICE
1919-08-03 00:00:00 | C005 |  |  | 2020-0011 | 6000
1919-09-04 00:00:00 | C010 |  |  | 2020-0012 | 8000 |  |  |  |  |  |  | Name of Company |  |  |  |  | Date
1919-10-05 00:00:00 | C001 |  |  | 2020-0013 | 1000 |  |  |  |  |  |  | Address
1919-11-06 00:00:00 | C002 |  |  | 2020-0014 | 2000 |  |  |  |  |  |  | Telephone |  |  |  |  | Invoice Number |  | 394
1919-12-07 00:00:00 | C005 |  |  | 2020-0015 | 3000
1920-01-08 00:00:00 | C010 |  |  | 2020-0016 | 4000
2020-01-01 00:00:00 | C001 |  |  | 2020-0001 | 80000 | 0.15 |  |  | 20 |  |  | Product Code |  | Product |  | Qnty | Unity Price |  | Total
2020-01-02 00:00:00 | C002 |  |  | 2020-0002 | 10000 |  |  |  | 30 |  |  | A-001 |  | Bread |  | 20 | 1
2020-02-03 00:00:00 | C005 |  |  | 2020-0003 | 30000 |  |  |  |  |  |  | S-020 |  | Sugar |  | 10 | 1.5
2020-02-04 00:00:00 | C010 |  |  | 2020-0004 | 40000
2020-03-05 00:00:00 | C001 |  |  | 2020-0005 | 5000 |  |  |  |  |  |  | Total
2020-06-06 00:00:00 | C002 |  |  | 2020-0006 | 10000 |  |  |  | 20
Spreadsheet: chris_germany__2123__JanCohCHOICE-ENA
Sheet: Jan 1

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-01 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1481 |  | Storage/Pool |  | 67694 |  |  |  |  |  | 5 | 1 | *
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 2 | *
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 9979 |  | Storage/Pool |  | 67694 |  |  |  |  |  | 6 | 3 | * |  |  | 15
 |  |  |  |  |  |  |  |  | 7000 |  | [NAME] |  | 68918 | 0 |  |  |  |  | 9 | 4 | * |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | * |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2956 |  | Storage/Pool |  | 67694 |  |  |  |  |  | 6 | 6 | * |  |  | 22
 |  |  |  |  |  |  |  |  | 2400 |  | [NAME] |  | 68915 | 0 |  |  |  |  | 7 | 7 | * |  |  | 15
 |  |  |  |  |  |  |  |  | 500 |  | [NAME] |  | 69148 | 0 |  |  |  |  | 9 | 8 | * |  |  | 14
 |  |  |  |  |  |  |  |  | 1600 |  | [NAME] |  | 69693 | 0 |  |  |  |  | 8 | 9 | * |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 15 | * |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 17730 |  | Storage/Pool |  | 67694 |  |  |  |  |  | 8 | 35 | * |  |  | 17
 |  |  |  |  |  |  |  |  | 85 |  | [NAME] |  | 68917 | 0 |  |  |  |  | 9 | 39 | * |  |  | 17
 |  |  |  |  |  |  |  |  | 1000 |  | [NAME] |  | 69149 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 3423 |  | Storage/Pool |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 2506 |  | Storage/Pool |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | [NAME] |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 20571 |  | Storage/Pool |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4321 |  | Storage/Pool |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4769 |  | Storage/Pool |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5625 |  | Storage/Pool |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 3192 |  | Storage/Pool |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | A06 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | A06 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 57 |  | Storage/Pool |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | A06 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C9

Local 9
Nom:
Numéro de téléphone:
[NAME]:
Paiement dû le:
[NAME]:
Réservé:
Prix:
Payé: | NON
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 742988d1628157258-return-value-of-the-columns-based-upon-highest-value-in-another-example
Sheet: Sheet1

ID | Item | Value |  | Example Results required: | Item | ID | Value
1 | A1 | 300 |  |  | A1 | 2 | 350
2 | A1 | 350 |  |  | A2 | 3 | 250
1 | A2 | 125 |  |  | A5 | 1 | 175
2 | A3 | 500 |  |  | A6 | 4 | 750
2 | A4 | 1000
3 | A4 | 250
4 | A4 | 200
1 | A5 | 175
2 | A6 | 200
3 | A2 | 250
1 | A3 | 1000
4 | A5 | 150
4 | A6 | 750
Spreadsheet: 64734d1265578064-offset-lookup-book1
Sheet: Sheet1

Problem - find last inspection date
PropertyID | Property Address | Insp Date
122 | 1, Alpha Street | 2010-02-03 00:00:00
 |  | 2010-01-30 00:00:00
 |  | 2010-01-23 00:00:00
 |  | 2010-01-16 00:00:00
 |  | 2010-01-09 00:00:00
PropertyID | Property Address | Insp Date
126 | 6, [NAME] | 2010-02-03 00:00:00
 |  | 2010-01-30 00:00:00
 |  | 2010-01-29 00:00:00
PropertyID | Property Address | Insp Date
8 | 1/234 Michale Street | 2010-01-16 00:00:00
 |  | 2010-01-22 00:00:00
 |  | 2010-02-06 00:00:00
Spreadsheet: 703549d1605041548-extract-rows-from-table-that-match-criteria-in-one-column-team-book-example
Sheet: Ushers

 | Name | [NAME] | Phone | Team
Spreadsheet: 174789d1345193706-conditional-formatting-highlight-the-most-similar-number-example
Sheet: Sheet1

 | The problem |  |  |  |  |  |  | The Solution (hopefully)
 | 1.2 | <--- This is the number I want to compare to the ones in B6:B9 |  |  |  |  |  | 1.2
 | 1 | Compare the number in B4 to the numbers in B6:B9 |  |  |  |  |  | 1 | 1.0 is highlighted as this is the closest number in I6:I9 to I4
 | 2 |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  | 3 | I just need the formula that finds the most similar number
 | 4 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | Another example
 |  |  |  |  |  |  |  | 3.9
 |  |  |  |  |  |  |  | 1 | I19 is now highlights as 4.0 is the nearest number to 3.9 (in I14)
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
Spreadsheet: 726932d1617613283-match-codes-from-file-master-code-list-with-added-weeks
Sheet: Wk12 before Sweep saving

 | 580824 SPM | WASH
 | 555933 1SPM | WASH
 | 555470 8SPM | WASH
 | 589329 CB | WASH
 | 589625 CBEU | WASH
 | 579420 1CB | WASH
 | 554490 1CB | WASH
 | 513143 1CB | WASH
 | 579302 1CB | WASH
 | 871245 4CBGB | WASH
 | 513648 3CB | WASH
 | 555648 CB | WASH
 | 050001 345280651 | WASH
 | 589841 CB | WASH
 | 589045 CB | WASH
 | 555149 CBSF | WASH
 | 565543 [NAME] | WASH
 | 522631 SPMK | WASH
 | 555933 2SPM | WASH
 | 575483 2SPM | WASH
 | 510404 SPM | WASH
 | 589105 SPM | WASH
 | 588196 1CB | WASH
 | 579201 SPM | WASH
 | 589709 CB | WASH
 | 589177 CB | WASH
 | 589907 10CB | WASH
 | 554380 CB | WASH
 | 581311 CB | WASH
 | 588906 2CB | WASH
 | 589580 CB | WASH
 | 534199 69SPM | WASH
 | 589404 CB | WASH
 | 589911 4CB | WASH
 | 589911 CB | WASH
 | 510241 CB | WASH
Spreadsheet: 4606877a-0cee-4fa8-99e4-44c645afcf01
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8015 | 29676 | [NAME] | [NAME] | USA | 5850 | 00:00:00 | 00:00:00 | 00:31:05 | 00:04:56 | 00:32:49 | 1 | 01:08:52
8015 | 64609 | Valma | [NAME] | AUS | 5852 | 00:00:00 | 00:00:00 | [NAME] | 00:03:47 | 00:38:59 | 2 | 01:11:25
8015 | 8163 | Peggy | Mcdowell-Cramer | USA | 5851 | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 28246573-79c0-4819-a527-71ed27e55db4
Sheet: Sheet1

2011 - 2012 Tech Centers That Work Site Coordinators
 | Contact Person | Title | Address | City | Zip | Phone | E-mail
State TCTW Coordinator | Dr. [NAME] | Coordinator | 1500 West 7th | Stillwater | 74074 | [PHONE] | [EMAIL]
Asst. State TCTW Coordinator | [NAME] | Coordinator | 1500 West 7th | Stillwater | 74074 | [PHONE] | [EMAIL]
[NAME] | Wade Walling | Asst. Supt. | PO Box 190 | Ft. Cobb | 73038-0190 | [PHONE] | [EMAIL]
Central Tech | [NAME] | Asst. Supt. | 3 CT Circle | Drumright | 74030-9613 | [PHONE] | [EMAIL]
[NAME] | [NAME] | Lead Instructor | [NAME] 60 | Omega | 73764-9720 | [PHONE] | [EMAIL]
Eastern OK County | [NAME] | Dir., FT Programs | 4601 [NAME] | Choctaw | 73020-9017 | [PHONE] | [EMAIL]
[NAME] | [NAME] | Asst. Supt. | One [NAME]. | Shawnee | 74804 | [PHONE] | [EMAIL]
[NAME] | Dr. [NAME] | Asst. Supt. | 1312 [NAME] | Stillwater | 74074-1899 | [PHONE] | [EMAIL]
Metro Tech | [NAME] | Chief Learning Officer | 1900 Springlake Drive | Oklahoma City | 73111-5238 | [PHONE] | [EMAIL]
Mid America TC | [NAME] | Asst. Supt. | P.O. Box H | Wayne | 73095-0210 | [PHONE] | [EMAIL]
Mid-Del | [NAME] | Principal | 1621 [NAME] | Midwest City | 73110-4825 | [PHONE] | [EMAIL]
Moore-Norman Tech | [NAME] | Executive Director | PO Box 4701 | [NAME] | 73070-4701 | [PHONE] | [EMAIL]
[NAME] | [NAME] | [NAME]. | [NAME] | Ponca City | 74601-1110 | [PHONE] | [EMAIL]
Red River TC | [NAME] | Principal | PO Box 1807 | [NAME] | 73534-1807 | [PHONE] | [EMAIL]
Southern TC | [NAME] | Asst. Supt. | 2610 [NAME] | Ardmore | 73401-2100 | [PHONE] | [EMAIL]
Tri-County Tech | [NAME] | Director of Instruction | 6101 S.E. Nowata Rd. | Bartlesville | 74006-6029 | [PHONE] | [EMAIL]
[NAME] | [NAME] | [NAME]. | [NAME] | Tulsa | 74147-7200 | [PHONE] | [EMAIL]
[NAME] Tech | [NAME] | Student Svcs. Dir. | 7892 Highway 9 | Wetumka | 74883-6155 | [PHONE] | [EMAIL]
Spreadsheet: 90598d1290372908-generating-multi-ple-worksheets-from-a-single-master-worksheet-attn2010
Sheet: JD

BP
Spreadsheet: 194243d1353085452-returning-all-possible-values-from-table-lookup-all-possible-values
Sheet: Sheet1

 |  | White | 1.1 |  |  |  |  | White | Blue | Green
 |  | Blue | 1.1 |  |  |  | 1
 |  | Green | 1.1 |  |  |  | 2
 |  | White | 1.2 |  |  |  | 3
 |  | Blue | 1.2 |  |  |  | 4
 |  | Green | 1.2 |  |  |  | 5
 |  | White | 1.3 |  |  |  | 6
 |  | White | 1.3 |  |  |  | 7
 |  | Blue | 1.3 |  |  |  | 8
 |  | Green | 1.3 |  |  |  | 9
 |  | White | 1.4 |  |  |  | 10
 |  | White | 1.4 |  |  |  | 11
 |  | White | 1.5
 |  | White | 1.55
 |  | White | 1.55
 |  | White | 1.55
 |  | White | 1.55
 |  | White | 1.23
 |  | White | 1.3
 |  | White | 1.2
 |  | White | 1.6
Spreadsheet: 134134d1325033906-merging-row-data-based-on-duplicate-email-address-sample-data2
Sheet: Sheet1

Organization | Job Title | First Name | Last Name | [NAME] | 2011-01-25 00:00:00 | Attended | 2011-02-17 00:00:00 | Attended | 2011-03-29 00:00:00 | Attended | 2011-04-12 00:00:00 | Attended | 2011-04-26 00:00:00 | Attended
Alpha Company, Inc. | Employee Relations Consultant | Cathy | Maribell | [EMAIL] | X | Yes
Alpha Company | Employee Relations Consultant | Cathy | Maribell | [EMAIL] |  |  | X | Yes
Alpha Company | Employee Relations Consultant | Cathy | Maribell | [EMAIL] |  |  |  |  | X | No
Alpha Company | Employee Relations Consultant | Cathy | Maribell | [EMAIL] |  |  |  |  |  |  | X | No
Alpha Company, Inc. | ER Consultant | Cathy | Maribell | [EMAIL] |  |  |  |  |  |  |  |  | X | Yes
Siri | Sr HR Manager | [NAME] | Warry | [EMAIL] |  |  |  |  |  |  | X | No
Siri | Sr HR Manager | [NAME] | Warry | [EMAIL] |  |  |  |  |  |  |  |  | X | Yes
Fly Free | Paralegal | Catrina | [NAME] | [EMAIL] | X | Yes
Fly Free Inc. | Paralegal | Catrina | [NAME] | [EMAIL] |  |  | X | No
Fly Free | [NAME] | Catrina | [NAME] | [EMAIL] |  |  |  |  | X | No
Fly Free | Paralegal | Catrina | [NAME] | [EMAIL] |  |  |  |  |  |  | X | No
Pluto Nash, Inc. | Human Resources Manager | [NAME] | Kurity | [EMAIL] |  |  | X | Yes
Variable Information Service | HR Compensation Analyst | [NAME] | Bender | [EMAIL] | X | No
VIS | HR Compensation Analyst | [NAME] | Bender | [EMAIL] |  |  | X | Yes
VIS | HR Compensation Analyst | [NAME] | Bender | [EMAIL] |  |  |  |  | X | Yes
Desired Result:
Alpha Company, Inc. | Employee Relations Consultant | Cathy | Maribell | [EMAIL] | X | Yes | X | Yes | X | No | X | No | X | Yes
Siri | Sr HR Manager | [NAME] | Warry | [EMAIL] |  |  |  |  |  |  | X | No | X | Yes
Fly Free | Paralegal | Catrina | [NAME] | [EMAIL] | X | Yes | X | No | X | No | X | No
Pluto Nash, Inc. | Human Resources Manager | [NAME] | Kurity | [EMAIL] |  |  | X | Yes
Variable Information Service | HR Compensation Analyst | [NAME] | Bender | [EMAIL] | X | No | X | Yes | X | Yes
Spreadsheet: 449212d1457055359-breaks-lunch-counter-copy-of-breakscounterv2
Sheet: Sheet1

Interval | Break | Lunch
00:00:00
00:30:00
01:00:00
01:30:00
02:00:00
02:30:00
03:00:00
03:30:00
04:00:00
04:30:00
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
23:30:00
1900-01-01 00:00:00
1900-01-01 00:30:00
1900-01-01 01:00:00
1900-01-01 01:30:00
1900-01-01 02:00:00
1900-01-01 02:30:00
1900-01-01 03:00:00
1900-01-01 03:30:00
1900-01-01 04:00:00
1900-01-01 04:30:00
1900-01-01 05:00:00
1900-01-01 05:30:00
1900-01-01 06:00:00
1900-01-01 06:30:00
1900-01-01 07:00:00
1900-01-01 07:30:00
1900-01-01 08:00:00
1900-01-01 08:30:00
1900-01-01 09:00:00
1900-01-01 09:30:00
1900-01-01 10:00:00
1900-01-01 10:30:00
1900-01-01 11:00:00
1900-01-01 11:30:00
1900-01-01 12:00:00
Spreadsheet: 797134d1663728996-insert-graphs-that-automatically-update-based-on-variables-book1
Sheet: 2

 |  |  | reference level |  |  |  | 18.71
 |  | # | level | diff | Min | [NAME] |  | # | level | diff | Min | [NAME]
 |  | 1 | -6.79 |  | 24 | 29 |  | 1 | -7.11 |  | 24 | 29
 |  | 2 | -6.22 |  | 23.3 | 28.3 |  | 2 | -6.31 |  | 23.3 | 28.3
 |  | 3 | -4.73 |  | 21.5 | 26.5 |  | 3 | -4.71 |  | 21.5 | 26.5
 |  | 4 | -1.14 |  | 19 | 24 |  | 4 | -1.83 |  | 19 | 24
 |  | 5 | 0.25 |  | 17 | 22 |  | 5 | -0.64 |  | 17 | 22
 |  | 6 | 1.75 |  | 15 | 20 |  | 6 | 2.06 |  | 15 | 20
 |  | 7 | 2.64 |  | 14 | 19 |  | 7 | 2.85 |  | 14 | 19
 |  | 8 | 3.14 |  | 13 | 18 |  | 8 | 3.35 |  | 13 | 18
 |  | 9 | 3.54 |  | 13 | 18 |  | 9 | 3.55 |  | 13 | 18
 |  | 10 | 2.85 |  | 14 | 19 |  | 10 | 2.95 |  | 14 | 19
 |  | 11 | 1.35 |  | 15 | 20 |  | 11 | 1.56 |  | 15 | 20
 |  | 12 | 0.54 |  | 17 | 22 |  | 12 | -0.43 |  | 17 | 22
 |  | 13 | -1.84 |  | 19 | 24 |  | 13 | -2.43 |  | 19 | 24
 |  | 14 | -3.82 |  | 21.5 | 26.5 |  | 14 | -3.2 |  | 21.5 | 26.5
 |  | 15 | -6.81 |  | 23.3 | 28.3 |  | 15 | -6.91 |  | 23.3 | 28.3
 |  | 16 | -7.21 |  | 24 | 29 |  | 16 | -7.81 |  | 24 | 29
 |  | Group 1 |  |  |  |  |  | Group 2