tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 701879d1603978509-filter-the-data-by-the-given-date-from-a-table-ef1411_filter-tasks
Sheet: Source

Exam Dates / 9. Classes | time
 |  | COURSES | Teachers | Exam room | class | Teachers | Exam room | class
21 Ekim 2020 Çarşamba | 13:30:00 | Course-1 | Name1 | 9A | 9A | Name7 | 10A | 9A
22 Ekim 2020 Perşembe | 13:30:00 | Course-2 | [NAME] | 9A | 9A | Name7 | 10A | 9A
23 Ekim 2020 Cuma | 13:30:00 | Course-3 | Name3 | 9A | 9A | Name8 | 10A | 9A
26 [NAME] 2020 Pazartesi | 13:30:00 | Course-4 | Name4 | 9A | 9A | Name7 | 10A | 9A
27 Ekim 2020 Salı | 13:30:00 | Course-5 | Name5 | 9A | 9A | Name4 | 10A | 9A
28 Ekim 2020 Çarşamba | 12:00:00 | Course-6 | Name6 | 9A | 9A | [NAME] | 10A | 9A
30 Ekim 2020 Cuma | 13:30:00 | Course-7 | Name3 | 9A | 9A | Name8 | 10A | 9A
2 Kasım 2020 Pazartesi | 13:30:00 | Course-8 | Name4 | 9A | 9A | Name7 | 10A | 9A
3 Kasım 2020 Salı | 13:30:00 | Course-9 | Name5 | 9A | 9A | Name4 | 10A | 9A
4 Kasım 2020 Çarşamba | 13:30:00 | Course-10 | Name1 | 9A | 9A | Name7 | 10A | 9A
5 Kasım 2020 Perşembe | 13:30:00 | Course-11 | [NAME] | 9A | 9A | Name7 | 10A | 9A
6 Kasım 2020 Cuma | 13:30:00 | Course-12 | Name3 | 9A | 9A | Name8 | 10A | 9A
9 Kasım 2020 Pazartesi | 13:30:00 | Course-13 | Name4 | 9A | 9A | Name7 | 10A | 9A
Exam Dates / 10. Classes | time
 |  | COURSES | Teachers | Exam room | class | Teachers | Exam room | class
21 Ekim 2020 Çarşamba | 12:00:00 | Course-1 | Name7 | 10A | 10A | Name14 | 11A | 10A
23 Ekim 2020 Cuma | 12:00:00 | Course-2 | Name9 | 10A | 10A | Name18 | 11A | 10A
26 [NAME] 2020 Pazartesi | 12:00:00 | Course-3 | Name4 | 10A | 10A | Name7 | 11A | 10A
27 Ekim 2020 Salı | 12:00:00 | Course-4 | Name11 | 10A | 10A | Name15 | 11A | 10A
28 Ekim 2020 Çarşamba | 12:00:00 | Course-5 | Name12 | 10A | 10A | [NAME] | 11A | 10A
30 Ekim 2020 Cuma | 12:00:00 | Course-6 | Name9 | 10A | 10A | Name18 | 11A | 10A
2 Kasım 2020 Pazartesi | 12:00:00 | Course-7 | Name10 | 10A | 10A | Name3 | 11A | 10A
3 Kasım 2020 Salı | 12:00:00 | Course-8 | Name11 | 10A | 10A | Name15 | 11A | 10A
4 Kasım 2020 Çarşamba | 12:00:00 | Course-9 | Name7 | 10A | 10A | Name14 | 11A | 10A
5 Kasım 2020 Perşembe | 12:00:00 | Course-10 | Name13 | 10A | 10A | Name17 | 11A | 10A
6 Kasım 2020 Cuma | 12:00:00 | Course-11 | Name9 | 10A | 10A | Name18 | 11A | 10A
9 Kasım 2020 Pazartesi | 12:00:00 | Course-12 | Name10 | 10A | 10A | Name3 | 11A | 10A
Spreadsheet: 273744d1382896036-cell-s-to-be-populated-from-various-results-of-drop-down-sample-exercise
Sheet: Usage

 | PERIOD | ON PEAK | OFF PEAK | Total Monthly
[NAME] | SEP | 290.45 | 165.68
 | OCT | 371.46 | 259
 | NOV | 284.46 | 253.93
 | DEC | 422.05 | 277.25
Julie | SEP | 496.33 | 393.84
 | OCT | 789 | 573.76
 | NOV | 621.89 | 433.32
 | DEC | 672.95 | 491.95
Spreadsheet: 110341d1307032855-excel-2007-macro-to-or-s-to-exsisting-cells-on-dif-pages-example-for-belayasila-v2
Sheet: Subtract

Item | Qty -
Item 1 | 2
Item 2 | 0
Item 3 | 0
Item 4 | 0
Item 5 | 0
Item 6 | 0
Item 7 | 0
Item 8 | 0
Item 9 | 0
Item 10 | 9
Spreadsheet: 156087d1337177875-excel-2007-need-to-create-batting-order-depending-on-stats-and-cant-have-a-player-twice-in-line-up-softball-stats-monday-night
Sheet: Game 3

 | Game # | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Total
 | Date | 2012-06-04 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JBC |  |  |  |  |  |  |  | 0 | 0 | 0
 | Location | Jamestown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | 0 | 0 | 0
 | Opponent | [NAME]
 | Result | Loss
# | Name | G | AB | H | 1B | 2B | 3B | HR | BB | ROE | SAC | R | RBI | BA | OBP | SLG | OPS
1 | Scott |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
2 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
3 | Jared |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
4 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
5 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
6 | Joel |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
7 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
8 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
9 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
10 | Kris |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
11 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
 | MAX
Spreadsheet: 188066d1350668242-get-data-from-another-workbook-to-a-summary-workbook-copy-of-data-for-intercompany-workings-tiernan
Sheet: tidsavgr ks intern gjeld des 

Celsa Armeringsstål AS
DOK :_______________________ | 3515348 | Rev. DOK:  3053532 |  | 2012
Tidsavgrensing, konserintern leverandørgjeld der faktura ikke var godkjent pr 31.12.2011
[NAME] nr | CSS AB | 1057172
 |  | EUR |  | Dok nr
 | 2011-12-20 00:00:00 | 1975.21 | 147038 | 3496797
 | 2011-12-21 00:00:00 | 1975.21 | 149856
Debet konto | 6293220000 |  | EUR | Kredit konto | 5100064000
DOK :_______________________ | 3515349 | Rev. DOK:3053534 |  | 2012
 |  | SEK
 | 2011-12-21 00:00:00 | 20985.17 | 149857
 | 2011-12-22 00:00:00 | 3313 | 150157
Debet konto | 6293220000 |  | SEK | Kredit konto | 5100064000
DOK :_______________________ | 3515350 | Rev. DOK:______________________
[NAME]  nr | CN AS | 1057170
 |  | EUR
30001038 | 2011-11-11 00:00:00 | 1821 |  | Viderefakt /semiar kursdeltagelse
Debet konto | 6273000000 |  | EUR | Kredit konto | 5100064000
30001039 | 2011-11-11 00:00:00 | 15337.83 | 143762 | Viderebel prosjektkostn
30001040 | 2011-11-11 00:00:00 | 19538 |  | Viderebel prosjektkostn
30001187 | 2011-12-30 00:00:00 | 20437.82 |  | Viderebel prosjektkostn
Debet konto | 4803000000 |  | EUR | Kredit konto | 5100064000
DOK :_______________________ | 3515351 | Rev. DOK 3053540
[NAME]  nr | CSS AS | 1057173
 |  | NOK
 |  | 5000 | 147219 | Utlegg for frakt
Debet konto | 624900000 |  | NOK | Kredit konto | 5100064000
DOK :_______________________ | 3515409 | Rev. DOK: 3053543
3001228 | 2011-12-31 00:00:00 | 14437.9 |  | Viderebel prosjektkostn
Debet konto | 4803000000 |  | EUR | Kredit konto | 5100064000
alt dette er reversert
Spreadsheet: 680168d1590830013-if-not-double-in-a-series-count-s
Sheet: Sheet1

formula which count singles |  |  |  |  |  |  |  |  |  | 2 |  |  | 2 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  |  | 2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 2 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 2 |  |  | 2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  |  | 2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  |  | 2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  |  | 2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 2 |  |  | 1 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 2 |  |  | 2 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 2 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 1 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 2 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  | 2
Spreadsheet: 11b39099-b68e-4daf-ba33-ca3d12ff28e7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
District Name: |  |  | School:
 | 1 = Completed required components |  |  | Work
 | with or without accomidations. |  |  | Values and | Compare | Compare | Course
Student | 2 = Completed alternate components | Student |  | Beliefs | Careers | Colleges | Plan | Reflection
Unique | according to IEP | Portfolio |  | Inventory | Side by | Side by | Revision | Statement
Identifier | See instructions tab--lower left | Complete |  | Completed | Side | Side | Completed | Completed
(10 digit #) | (1 or 2) | (Y) | (N) | (Y or N) | (Y or N) | (Y or N) | (Y or N) | (Y or N)
Spreadsheet: 122372d1316772627-sum-by-month-week-etc-to-date-in-a-log-summary
Sheet: Data

 | What | When | How Many
 | Falories | 2011-09-23 00:00:00 | 2
 | Fat | 2011-09-23 00:00:00 | 3
 | Diet | 2011-09-23 00:00:00 | 4
 | Falories | 2011-09-22 00:00:00 | 2
 | Fat | 2011-09-22 00:00:00 | 4
 | Diet | 2011-09-21 00:00:00 | 6
 | Falories | 2011-09-19 00:00:00 | 3
 | Fat | 2011-09-17 00:00:00 | 7
 | Diet | 2011-09-15 00:00:00 | 9
 | Falories | 2011-09-13 00:00:00 | 3
 | Fat | 2011-09-11 00:00:00 | 4
 | Diet | 2011-09-09 00:00:00 | 1
Spreadsheet: 854255d1704202085-adding-blank-columns-demo-data
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11cl | 12 | 13 | 14 | 15 | 16 | 17S | 18P
 | 1 | 75 | The  American Insurance Company Limited. (409024794) |  |  |  |  |  |  | 300000 |  |  |  |  |  | 52000 | 41 | < This whole row is to be extracted as there is a number in B6  even though Q6 & R6 is  <100000
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland (300700851) |  |  |  |  |  |  | 40000.4 |  |  |  |  |  | 30000 | 25 | < This whole row is not to be extracted as there is no number in B7 and Q7 & R7 is <100000
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd (300494201) |  |  |  |  |  |  |  |  |  |  |  |  |  | 325.3 | < This whole row is to be extracted as there is a number in B8  even though Q8 & R8 is blank or zero or  <100000
 | 7 | 9 | [NAME] ([NAME] (200010449 (Main)) |  |  |  |  |  |  | 600000 |  |  |  |  |  | 45500 | 4000 | < This whole row is to be extracted as there is a number in B9  even though Q9 & R9 is blank or zero or  <100000
 | x | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < This whole row is not to be extracted as there is no number and contains 'x'
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd (900049782) |  |  |  |  |  |  | 20000 |  |  |  |  |  | 900 | 11000 | < This whole row is to be extracted as there is a number in B11  even though Q11 & R11 is blank or zero or  <100000
 | 145 |  | Jenite Licohetic (606916857) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < This whole row is not to be extracted as there is no number or is blank or zero in K12, Q12 & R12  even though B12 contains number or is not blank
 |  |  | [NAME].Ltd. (609747221) |  |  |  |  |  |  | 5000 |  |  |  |  |  | 80900 | 105300 | < Only R13 data is to be extracted whereas Q13 is <100000 and K13 not be taken as there is no number in B13
 |  |  | Asimbia Pokiol |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < This whole row is not to be extracted as there is no number or is blank or zero in Q13,R13
 |  |  | Agraj Foods Pvt.Ltd,Kathmandu (304463444) |  |  |  |  |  |  |  |  |  |  |  |  | 354000 | 75430.4 | < Only Q15 data is to be extracted whereas R13 is <100000 and K13 not be taken as there is no number in B15
 |  |  | Aarti Soap & Chemical Industries Pvt Ltd,Birkune (300020639) | 4286.39 | 0 | 0 | 4286.39 |  |  |  | #N/A | << NO MES >> | #N/A | SAM |  | 0 | 0 | < This whole row is not to be extracted as there is no number or is blank or zero in Q16,R16 and K16 cannot be extracted as there is no data in B16
 |  |  | Aashis Plastic Traders (600443562) |  |  |  |  |  |  |  | #N/A | << NO MES >> | #N/A | SAM |  | 0 | 0 | < This whole row is not to be extracted as there is no number or is blank or zero in Q17,R17
 |  |  | Alive Pharmaceutical Pvt. Ltd.,Nrt (300270330) | 12453.5 | 0 | 12453.5 | 0 |  |  |  | #N/A | << NO MES >> | #N/A | SAM |  | 46005 | 98430.6 | < This whole row is not to be extracted as there Q18,R18 is <100000
 |  |  | Nirvana Plastic Corp (606493462) |  |  |  |  |  |  | 150000 |  |  |  |  |  |  | 190000 | < Only R19 data is to be extracted  R19 is >100000 and K19 not be taken as there is no number in B19
Spreadsheet: 2004f53a-8f9a-4de7-b4e4-91c4db757755
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3695 | 10766 | Derek | Wilson | BAR
3695 | 17573 | Mario | [NAME] | CRC
Spreadsheet: 525465d1498741930-conditional-formatting-cell-greater-green-less-than-red-prior-cell-officedon-test
Sheet: Sheet1

Revenue 000's | 2017-06-01 00:00:00 | 2017-06-02 00:00:00 | 2017-06-03 00:00:00 | 2017-06-04 00:00:00 | 2017-06-05 00:00:00 | 2017-06-06 00:00:00 | 2017-06-07 00:00:00 | 2017-06-08 00:00:00 | 2017-06-09 00:00:00 | 2017-06-10 00:00:00 | 2017-06-11 00:00:00
Location
Boston | 1000 | 1100 | 1175 | 1200 | 1300 | 1250 | 1200 | 1175 | 1100 | 1099 | 1250
Dallas | 1100 | 1175 | 1200 | 1300 | 1250 | 1225 | 1200 | 1175 | 1150 | 1250 | 1275
Denver | 900 | 875 | 925 | 1100 | 1175 | 1200 | 1175 | 1150 | 1125 | 1190 | 1200
Las Vegas | 2500 | 2600 | 2650 | 2700 | 2725 | 2650 | 2625 | 2600 | 2550 | 2700 | 2750
Los Angeles | 3000 | 3100 | 3090 | 3050 | 3040 | 3100 | 3150 | 3200 | 3300 | 3400 | 2800
Miami | 2750 | 2950 | 3000 | 3125 | 3175 | 3100 | 3080 | 3065 | 3010 | 3100 | 3200
Minneapolis | 2000 | 3000 | 3500 | 3000 | 2900 | 2800 | 2700 | 2900 | 3000 | 3100 | 3200
New York | 8000 | 9000 | 8500 | 8000 | 7500 | 8000 | 8500 | 9000 | 9500 | 9600 | 9700
Portland | 800 | 880 | 890 | 900 | 925 | 500 | 450 | 600 | 900 | 1100 | 1200
Spreadsheet: 158052d1337962525-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf-final-week-7-issue
Sheet: The Masters

 |  | WEEK 1 THE MASTERS
 |  | Total Earnings |  |  |  | Rankings Through Week 2 | Total
[NAME] |  |  |  | YTD
Scott, [NAME]
Mahan, [NAME]
Senden, [NAME]
Fowler, [NAME]
Stanley, [NAME]
Pettersson, [NAME]
Wagner, [NAME]
McDowell, Graeme
Oosthuizen, Louis
 | Total
[NAME]
[NAME], [NAME]
Mahan, [NAME]
[NAME], Fredrick
[NAME], [NAME]
[NAME], Sergio
McNeil, George
Wagner, [NAME]
McDowell, Graeme
Poulter, [NAME]
Oosthuizen, Louis
 | Total
[NAME]
Day, [NAME]
Woodland, [NAME]
Fowler, [NAME]
[NAME], [NAME]
Furyk, [NAME]
O'Hair, Sean
Wagner, [NAME]
Immelman, Trevor
Goosen, Retief
Harrington, [NAME]
 | Total
[NAME]
[NAME], [NAME]
Bradley, Keegan
Van Pelt, Bo
Moore, [NAME]
Furyk, [NAME]
Overton, [NAME]
Adams, Blake
Haas, [NAME]
Teater, [NAME]
[NAME], [NAME]
 | Total
[NAME]
[NAME], [NAME]
[NAME], [NAME]
Na, [NAME]
Crane, [NAME]
Pettersson, [NAME]
Furyk, [NAME]
Wagner, [NAME]
McDowell, Graeme
Chalmers, Greg
Oosthuizen, Louis
 | Total
[NAME]
Choi, [NAME]
[NAME], [NAME]
Van Pelt, Bo
Ogilvy, Geoff
Furyk, [NAME]
[NAME], Jerry
Gay, Brian
Imada, Ryuji
Slocum, Heath
Harrington, [NAME]
 | Total
[NAME]
Watney, Nick
[NAME], [NAME]
Fowler, [NAME]
Moore, [NAME]
Furyk, [NAME]
Allenby, [NAME]
Barnes, Ricky
Wagner, [NAME]
Slocum, Heath
Mayfair, [NAME]
 | Total
[NAME] #2
Mahan, [NAME]
Watney, Nick
Fowler, [NAME]
Points, [NAME]
Furyk, [NAME]
Stanley, [NAME]
Els, [NAME]
Wagner, [NAME]
Poulter, [NAME]
Oosthuizen, Louis
 | Total
[NAME] #1
[NAME], [NAME]
[NAME], [NAME]
Fowler, [NAME]
[NAME], [NAME]
Furyk, [NAME]
[NAME], Sergio
Els, [NAME]
McDowell, Graeme
Cink, [NAME]
Slocum, Heath
 | Total
[NAME]
Simpson, Webb
Kuchar, [NAME]
Van Pelt, Bo
[NAME], [NAME]
Stanley, [NAME]
Furyk, [NAME]
McDowell, Graeme
De Jonge, [NAME]
Harrington, [NAME]
[NAME], [NAME]
 | Total
Spreadsheet: 54745d1254819654-dependent-combobox-issue-fixad-combobox
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Opt 1 |  |  | Opt 1 | Opt 2 | Opt 3 | Opt 4 | Opt 5 | Opt 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Opt 2 |  |  | Opt 1:1 | Opt 2:1 | Opt 3:1 | Opt 4:1 | Opt 5:1 | Opt 6:1
 |  |  |  |  |  |  |  |  |  |  |  |  | Opt 3 |  |  | Opt 1:2 | Opt 2:2 | Opt 3:2 | Opt 4:2 | Opt 5:2 | Opt 6:2
 |  |  |  |  |  |  |  |  |  |  |  |  | Opt 4 |  |  | Opt 1:3 | Opt 2:3 | Opt 3:3 | Opt 4:3 | Opt 5:3 | Opt 6:3
 |  |  |  |  |  |  |  |  |  |  |  |  | Opt 5 |  |  | Opt 1:4 | Opt 2:4 | Opt 3:4 | Opt 4:4 | Opt 5:4 | Opt 6:4
 |  |  |  |  |  |  |  |  |  |  |  |  | Opt 6 |  |  |  | Opt 2:5 | Opt 3:5 | Opt 4:5 | Opt 5:5 | Opt 6:5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opt 3:6 | Opt 4:6 | Opt 5:6 | Opt 6:6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opt 4:7 | Opt 5:7 | Opt 6:7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opt 5:8 | Opt 6:8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opt 6:9
 |  |  | 6 | 9
 |  |  | Opt 6
 |  |  |  |  |  |  |  | Opt 6:9
 |  | "=OFFSET(Sheet1!$P$1;1;Sheet1!$D$11;COUNTA(OFFSET(Sheet1!$P:$P;;Sheet1!$D$11;;))-1)"
 |  |  | 6
 |  | "=OFFSET(Sheet1!$P$1;1;Sheet1!$D$23;COUNTA(OFFSET(Sheet1!$P:$P;;Sheet1!$D$23;;))-1)"
Spreadsheet: 98460d1297351633-alternative-to-hlookup-to-deliver-correct-zone-from-zip-code-washington-2
Sheet: Sheet1

 |  |  | I would like to input the number 59 in a cell and get the output of Zone 1
 |  |  |  |  |  |  |  |  |  |  | Input | 59
 |  |  |  |  |  |  |  |  |  |  | Output | Zone 1
 |  |  | 59 | 8 | 2 | 75 | 27 | 10
 |  |  |  | 62 | 57 | 91 | 51 | 14
 |  |  |  | 80 | 60 | 92 | 76 | 28
 |  |  |  |  |  | 93 | 77 | 45
 |  |  |  |  |  | 94 | 78 | 52
 |  |  |  |  |  | 95 |  | 54
 |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  | 89
 |  |  | ZONE 1 | ZONE 2 | ZONE 3 | ZONE 4 | ZONE 5 | ZONE 6
Spreadsheet: 811278d1672391038-data-collation-formula-test-4
Sheet: Individual Analysis

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | Group
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-2018 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-2019 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-2020 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-2021 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-2022 | 5
 |  | Name | Name 1 |  | Year | Group | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8 |  | 2022-2023
 |  |  |  |  | 2017-2018 | 1
 |  |  |  |  | 2018-2019 | 2
 |  |  |  |  | 2019-2020 | 3
 |  |  |  |  | 2020-2021 | 4
 |  |  |  |  | 2021-2022 | 5
 |  |  |  |  | 2022-2023 | 5
Spreadsheet: 796580d1663362657-sample-data-for-date-and-time-based-on-specific-person-sample-file-etaf3
Sheet: Sheet2

Time | Date | Salesperson |  |  |  |  |  | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-16 00:00:00 | 2020-08-17 00:00:00 |  |  |  | Sum of Time | Column Labels
00:38:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | 2020-08-10 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-16 00:00:00 | 2020-08-17 00:00:00 | (blank) | Grand Total
00:20:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  |  | Nick |  |  |  |  |  |  |  |  |  | [NAME] |  | 0:10:00 |  |  |  |  |  | 0:10:00
00:18:00 | 2020-08-12 00:00:00 | Nick |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 0:23:00 |  |  |  | 0:23:00
00:09:59.962000 | 2020-08-12 00:00:00 | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 0:58:00 |  |  |  |  |  |  | 0:58:00
00:33:59.990000 | 2020-08-13 00:00:00 | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Nick |  | 0:18:00 |  |  |  | 0:56:00 |  | 1:14:00
00:22:59.981000 | 2020-08-14 00:00:00 | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | 0:49:00 |  |  | 0:49:00
00:49:00.019000 | 2020-08-16 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 0:34:00 |  |  |  |  | 0:34:00
00:56:00.010000 | 2020-08-17 00:00:00 | Nick |  |  |  |  |  |  |  |  |  |  |  |  |  | (blank) |  |  |  |  |  |  | 0:00:00 | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 0:58:00 | 0:28:00 | 0:34:00 | 0:23:00 | 0:49:00 | 0:56:00 | 0:00:00 | 4:08:00
 |  |  |  |  |  | For instance on 8/10/20 mike ahs 0:38 and 0:20 hours. I need that to total to 0.58 hour and search the rest of my sales people for time on that day and then total there time  My end result will scroll a month's worth of time and check everyday for time from all my sales people then list them row A through what ever and shows the days across in each column. If I can get the formula to search properly I think I can get the summary sheet figured out.  in my example to get the value in A15 I got this far =SUMIFS($A$3:$A$10, $B$3:$B$10,G3, $C$3:$C$10, $C$3) but I can not figure out how to get it to check the next name listed for the same date and then move to 8/11
Spreadsheet: 836945d1689751847-how-can-i-make-2-copies-of-an-excel-workbook-that-updates-stock-list-revision-work
Sheet: CABLE LOCKS

BOX | PRODUCT | SIZE (MM) | PK SZ | QUANTITY LEFT ON SHELF | QUANTITY LEFT IN OVERFLOW | TOTAL QUANTITY LEFT | MIN STOCK | MIN ORDER | SUPPLIER | ON ORDER | EXPECTED | COMMENTS / PO | COST per -10 | [NAME]
BOX 1 | LM10C | 4.0-6.5 | EA | 4 |  |  | 25 |  | HELLERMAN TYTON
BOX 2 | T10 | 15.5 - 22 | 10 | 1 |  |  | 20 |  | HELLERMAN TYTON
BOX 3 | B10 | 4.8 - 9 | 10 | 3 |  |  | 50 |  | HELLERMAN TYTON | 20
BOX 4 | L10C | 5.5 - 9.5 | EA | 12 |  |  | 25 |  | HELLERMAN TYTON
BOX 5 | [NAME] | 8 - 14 | 10 | 2 |  |  | 10 |  | HELLERMAN TYTON
BOX 6 | B10 O'FLOW | 4.8 - 9 | 10 | 3 | N/A |  |  |  |  |  |  | OVERFLOW BOXES
BOX 7 | [NAME] | 9.0-12.5 | EA | 13 |  |  | 25 |  | HELLERMAN TYTON
BOX 8 | B30 | 13-16.5 | 10 | 0 |  |  | 10 |  | HELLERMAN TYTON
BOX 9 | S40 | 12 - 16 | 10 | 4 |  |  | 10 |  | HELLERMAN TYTON
BOX 10 | R40 | 3.8 - 5.2 | 10 | 8 |  |  | 15 |  | HELLERMAN TYTON
BOX 10A | R40 O'FLOW | 3.8 - 5.2 | 10 | 8 |  |  |  |  |  |  |  | OVERFLOW BOXES
BOX 11 | R70 | 6 - 8.5 | 10 | 9 |  |  | 15 |  | HELLERMAN TYTON
BOX 12 | R50 | 5.2 - 8 | 10 | 4 |  |  | 15 |  | HELLERMAN TYTON
BOX 12A | R50 OVERFLOW | 5.2 - 8 | 10 | 4 | N/A |  |  |  | HELLERMAN TYTON |  |  | OVERFLOW BOXES
BOX 13 | [NAME] | 9-12.5 | EA | 5 |  |  | 20 |  | HELLERMAN TYTON
BOX 14 | S15M5 | 6.8-7.2 | EA | 5 | N/A |  | 20 |  | HELLERMAN TYTON
BOX 15 | L30C | 12-15 | EA | 2 |  |  | 20 |  | HELLERMAN TYTON
BOX 16 | LM30C OVERFLOW | 9-12.5 | EA | 10 | N/A |  | N/A |  | HELLERMAN TYTON |  |  | OVERFLOW BOXES
BOX 17 | S20 | 8 - 12 | 10 | 4 |  |  | 10 |  | HELLERMAN TYTON
BOX 18 | S10 | 5 - 8.5 | 10 | 4 |  |  | 10 |  | HELLERMAN TYTON
BOX 19 | [NAME] | 5.5 - 9.5 |  | 19 | N/A |  |  |  | HELLERMAN TYTON |  |  | OVERFLOW BOXES
BOX 20 | [NAME] |  |  | 30 | N/A |  |  |  | HELLERMAN TYTON |  |  | OVERFLOW BOXES
BOX 21 | [NAME] | [NAME] |  | 30 | N/A |  |  |  | HELLERMAN TYTON |  |  | OVERFLOW BOXES
FLOOR | [NAME] OVERFLOW |  |  | 30 |  |  |  |  |  |  |  | OVERFLOW BOXES
FLOOR | T10 O'FLOW |  |  | 40 |  |  |  |  |  |  |  | OVERFLOW BOXES
FLOOR | LM10C O'FLOW | 4.0-6.5 |  | 80 | N/A |  |  |  | HELLERMAN TYTON |  |  | OVERFLOW BOXES
FLOOR | LM30C O'FLOW |  |  | 10 |  |  |  |  |  |  |  | OVERFLOW BOXES
FLOOR | L20C O'FLOW | 9-12.5 |  |  | N/A |  |  |  | HELLERMAN TYTON |  |  | OVERFLOW BOXES
TNL | B10 |  |  | 51 | N/A |  |  |  | HELLERMAN TYTON | CABLELOK OVERFLOW STOCK IN TUNNEL STORE |  | TUNNEL STORE
TNL | [NAME] |  |  | 16 | N/A |  |  |  | HELLERMAN TYTON |  |  | TUNNEL STORE
TNL | B30 |  |  | 23 | N/A |  |  |  | HELLERMAN TYTON |  |  | TUNNEL STORE
TNL | S10 |  |  | 54 | N/A |  |  |  | HELLERMAN TYTON |  |  | TUNNEL STORE
TNL | S20 |  |  | 30 | N/A |  |  |  | HELLERMAN TYTON |  |  | TUNNEL STORE
TNL | S40 |  |  | 20 | N/A |  |  |  | HELLERMAN TYTON |  |  | TUNNEL STORE
TNL | R40 |  |  | 30 | N/A |  |  |  | HELLERMAN TYTON |  |  | TUNNEL STORE
TNL | R50 |  |  | 40 | N/A |  |  |  | HELLERMAN TYTON |  |  | TUNNEL STORE
TNL | R70 |  |  | 21 | N/A |  |  |  | HELLERMAN TYTON |  |  | TUNNEL STORE
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL STOCK VALUE