tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 273351d1382688208-dynamic-matching-cell-in-table-and-returning-column-example
Sheet: 20131022

 | BIG | LARGE | TINY | CLOTHES | FROGS | BEAR | ICE | CREAM | TIE | ST | LT | HH | OP
 | 13848111259.82 | 7400715870.82 | 6447395389 | 1670250059 | 2720696652.82 | 641741454 | 330871326 | 2521967188 | 59056249 | 53900076 | 27641327 | 5805653935 | 16332993
A | 2382692951 | 636765561 | 1745927390 | 204951038 | 116251790 | 0 | 0 | 304940357 | 3861137 | 5927899 | 833340 | 1745927390 | 0
B | 2357114000 | 451574898 | 1905539102 | 0 | 306547765 | 180655073 | 53486812 | 79894931 | 2958634 | 7156711 | 1530045 | 1724884029 | 0
C | 1979435797 | 1108021796 | 871414001 | 179496636 | 314989114 | 25550729 | 36210275 | 562172064 | 5591573 | 8267867 | 1294267 | 845863272 | 0
D | 1360107089 | 674469943 | 685637146 | 306160693 | 203441841 | 13350803 | 5019633 | 154675982 | 3098643 | 945544 | 1127607 | 672286343 | 0
E | 1163437851.82 | 939059875.8199999 | 224377976 | 323061227 | 506315660.82 | 99930998 | 33762484 | 53187461 | 4708204 | 1325804 | 372186 | 124446978 | 16326849
F | 911604285 | 523609216 | 387995069 | 56202942 | 291585724 | 286496173 | 43641260 | 106633498 | 19468160 | 3473021 | 2604611 | 101498896 | 0
G | 823192695 | 808297690 | 14895005 | 267991057 | 235459603 | 0 | 54833198 | 238168353 | 3075981 | 8266207 | 497147 | 14895005 | 6144
H | 807715458 | 241452624 | 566262834 | 42951403 | 136772829 | 0 | 14840702 | 40745670 | 2060461 | 3007716 | 1073843 | 566262834 | 0
Spreadsheet: 287573d1388866330-planning-for-8-hour-a-day-without-weekends-book2
Sheet: Logic

Hours per Task | Start Time | Finishing Day | Finishing Hr | Finishing workday Hr | Finishing Time
1 | 2014-01-06 06:00:00
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Spreadsheet: 83933d1283964785-conditional-look-up-or-if-statement-active-cc-1
Sheet: Sheet3

Bills | Groceries | Gas | Misc | Big Purchase
 | Chase (WaMu) | Amazon | Citi Platinum | [NAME] | [NAME] | Citi Forward | Citi (Jillian) | 53rd | [NAME] ([NAME]) | [NAME] (Jillian) | Discover
2010
September | 64 | 124.93 |  | 11.8 |  | 4.21 | 48
 | 32.76 | 76.83 |  |  |  | 18.99
 |  | 54 |  |  |  | 7.52
 |  |  |  |  |  | 9.93
 |  |  |  |  |  | 15.32 | 97.75
October | 43.85 | 15.44 | 94 | 115 | 97 | 5.43 | 15.6
 | 19.99 | 21.94 | 41.9 | 31.9 | 49 | 22.78 | 234
 | 43.21 |  | 33.29 | 45.67 |  |  | 12
 | 32.91 |  |  | 29.05
November
December
2011
January
February
March
April
May
June
July
August
September
October
November
December
2012
January
February
March
April
May
Spreadsheet: 798596d1664566874-how-to-populate-names-from-2-matching-columns-of-numbers-populate-supv-names-2-
Sheet: Sheet 1

Reports To Position Number | [NAME]
91101432 |  |  |  |  |  | Supv | PN
91101432 |  |  |  |  |  | Name 1 | 91101432
91223809 |  |  |  |  |  | Name 2 | 91246286
91185406 |  |  |  |  |  | Name 3 | 91420842
91242009 |  |  |  |  |  | Name 4 | 91185406
91209340 |  |  |  |  |  | Name 5 | 91337928
91251099 |  |  |  |  |  | Name 6 | 91339470
91246322 |  |  |  |  |  | Name 7 | 91264092
91223809 |  |  |  |  |  | Name 8 | 91350599
91248925 |  |  |  |  |  | Name 9 | 91244038
91244038 |  |  |  |  |  | Name 10 | 91209340
91382277 |  |  |  |  |  | Name 11 | 91247077
91246322 |  |  |  |  |  | Name 12 | 91226527
91223809 |  |  |  |  |  | Name 13 | 91223809
91330416 |  |  |  |  |  | Name 14 | 91242009
91187573 |  |  |  |  |  | Name 15 | 91251099
91224368 |  |  |  |  |  | Name 16 | 91246322
91184881 |  |  |  |  |  | Name 17 | 91248925
91228950 |  |  |  |  |  | Name 18 | 91382277
91223809 |  |  |  |  |  | Name 19 | 91330416
91223809 |  |  |  |  |  | Name 20 | 91187573
91613009 |  |  |  |  |  | Name 21 | 91224368
91246286 |  |  |  |  |  | Name 22 | 91184881
91420842 |  |  |  |  |  | Name 23 | 91228950
91185406 |  |  |  |  |  | Name 24 | 91613009
91337928 |  |  |  |  |  | Name 25 | 91158235
91339470 |  |  |  |  |  | Name 26 | 91318814
91264092 |  |  |  |  |  | Name 27 | 91232261
91350599 |  |  |  |  |  | Name 28 | 91144732
91244038 |  |  |  |  |  | Name 29 | 91183151
91209340 |  |  |  |  |  | Name 30 | 91097827
91247077 |  |  |  |  |  | Name 31 | 91386647
91226527 |  |  |  |  |  | Name 32 | 91246105
91223809
91185406
91242009
91209340
91251099
91246322
91223809
91248925
91244038
91382277
91246322
91223809
91330416
91187573
91224368
91184881
91228950
91223809
91223809
91613009
91158235
91318814
91247077
91247077
91232261
91248925
91247077
91228950
91330416
91247077
91144732
91144732
91246322
91382277
91246322
91228950
91183151
91097827
91264092
91386647
91330416
91228950
91228950
91246105
91224368
91101432
Spreadsheet: 170710d1343373091-formula-profit-sharing-help-needed-profits
Sheet: Sheet1

 |  | Profit | Cumulative | Investor | Me |  | Profit
 | Jan | 1000 | 1000 | 500 | 500 |  | Paid Out
 | Feb | -1000 | -1000 | 0 | 0 |  | Balance
 | Mar | 500 | -500 | 0 | 0 |  | Share
 | Apr | 2000 | 1500 | 750 | 750
 | May | -1000 | -1000 | 0 | 0
 | Jun
 | Jul
 | Aug
 | Sep
 | Oct
 | Nov
 | Dec
Spreadsheet: 455795d1460495314-vlookup-to-return-non-duplicate-values-example1
Sheet: AC Roster

 | Roster |  |  |  |  | Roster
 | Name | Tech ID | Job
Associates | [NAME] |  | Tasker |  |  | Unload |  |  |  |  | Putaway
 | [NAME] |  | Spoc |  |  | [NAME] |  | [NAME] |  |  | [NAME] |  | [NAME]
 | [NAME] |  | Tasker |  |  | [NAME] |  | [NAME]
 | [NAME] |  | Truck
 | [NAME] |  | Out
 | [NAME] |  | 1/4 Pallets
 | [NAME] |  | [NAME] | w/ Labor share |  | [NAME] |  |  |  |  | IP Pick
 | [NAME] |  | Full Units |  |  | [NAME] |  | [NAME] |  |  | [NAME]
 | [NAME] |  | Inventory | Load |  | [NAME] |  | [NAME]
 | [NAME] |  | Load |  |  | [NAME] |  | [NAME]
 | [NAME] |  | Out |  |  | [NAME] |  | P Maxwell |  |  | Full UL
 | [NAME] |  | Out |  |  |  |  | [NAME] |  |  | [NAME] |  | Will Lemons
 | [NAME] |  | Out
 | [NAME] |  | Putaway
 | [NAME] |  | Damage
 | [NAME] |  | Putaway
 | [NAME] |  | Replen |  |  | Replen |  |  |  |  | Wrap
 | [NAME] |  | Tristate | Unload |  | [NAME] |  | [NAME] |  |  | [NAME] |  | [NAME]
 | [NAME] |  | Unload | 1/4 Pallets |  |  |  |  |  |  | [NAME]
 | [NAME] |  | w/ Labor Share
 | [NAME] |  | Wrap
Temps | [NAME] |  | Audit
 | [NAME] |  | 1/4 Pallets |  |  |  |  |  | Load
 | [NAME] |  | [NAME] |  |  |  |  |  | [NAME]
 | [NAME] |  | [NAME] |  |  |  |  |  | [NAME]
 | [NAME] |  | [NAME]
 | [NAME] |  | [NAME]
 | [NAME] |  | [NAME]
 | Shawnda Womack |  | [NAME] | Scales
 | [NAME] |  | [NAME] | [NAME] |  |  |  | Totals
 | [NAME] |  | Full Units | Putaway |  |  |  | Unload |  |  | Putaway
 | Will Lemons |  | Full Units | Putaway |  |  |  | [NAME] |  |  | Full UL
 | [NAME] |  | Inventory |  |  |  |  | Replen |  |  | Wrap
 | [NAME] |  | Load |  |  |  |  | Load
 | [NAME] |  | Out
 | [NAME] |  | Out
 | [NAME] |  | Out
 | [NAME] |  | Out
 | [NAME] |  | Replen
 | [NAME] |  | Unload
 | [NAME] |  | Wrap | [NAME]
 | [NAME] |  | Wrap
 | Tiara |  | [NAME]
 | Maxwell |  | [NAME]
 | Justin |  | [NAME]
 | [NAME] |  | [NAME]
 | Lookup
 | Name | Tech ID
 | [NAME] | BN4139
 | [NAME] | CLV003
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Lloyd Fisher
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Taurian Linder
Spreadsheet: 690805d1597305509-extract-id-to-dob-and-age-for-year-2000-and-above-dob_from_id_card
Sheet: Sheet1

ID Card Number | DOB | AGE |  | DOB | AGE |  | Zbor > | AGE |  |  | Maybe if min age is say 5? | DOB | AGE
[PHONE] | 2005-04-03 00:00:00 | 15 |  | 2005-04-03 00:00:00 | 15 |  |  | 15 | 1 |  |  | 2005-04-03 00:00:00 | 15
[PHONE] | 2009-08-02 00:00:00 | 11 |  | 2009-08-02 00:00:00 | 11 |  |  | 11 | 1 |  |  | 2009-08-02 00:00:00 | 11
[PHONE] | 1998-08-02 00:00:00 | 22 |  | 1998-08-02 00:00:00 | 22 |  |  | 22 | 1 |  |  | 1998-08-02 00:00:00 | 22
[PHONE] | 2012-01-03 00:00:00 | 8 |  | 2012-01-03 00:00:00 | 8 |  |  | 8 | 1 |  |  | 2012-01-03 00:00:00 | 8
[PHONE] | 2012-01-06 00:00:00 | 8 |  | 2012-01-06 00:00:00 | 8 |  |  | 8 | 1 |  |  | 2012-01-06 00:00:00 | 8
[PHONE] | 2006-01-06 00:00:00 | 14 |  | 2006-01-06 00:00:00 | 14 |  |  | 14 | 1 |  |  | 2006-01-06 00:00:00 | 14
[PHONE] | 2007-08-02 00:00:00 | 13 |  | 2007-08-02 00:00:00 | 13 |  |  | 13 | 1 |  |  | 2007-08-02 00:00:00 | 13
[PHONE] | 2006-08-02 00:00:00 | 14 |  | 2006-08-02 00:00:00 | 14 |  |  | 14 | 1 |  |  | 2006-08-02 00:00:00 | 14
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5206

5206 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 3bc2fab9-d0b9-44d7-bd91-f08995bc3c9e
Sheet: Sheet1

MONTHLY TIME REPORT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
GRADUATE ASSISTANTS & GRADUATE STUDENT WORKERS
(REMINDER: ULM POLICY IS THAT GA'S CAN WORK A MAXIMUM OF 20 HOURS A WEEK)
NAME: |  |  |  |  |  |  |  |  |  | DEPT:
CWID: |  |  |  |  |  |  |  |  |  | PAY PERIOD: |  |  | SEPT 14 - OCT 11, 2013
[NAME] REPORT:
 | Sep 14 | Sep 15 | Sep 16 | Sep 17 | Sep 18 | Sep 19 | Sep 20 | Sep 21 | Sep 22 | Sep 23 | Sep 24 | Sep 25 | Sep 26 | Sep 27
 | Sep 28 | Sep 29 | Sep 30 | Oct 1 | Oct 2 | Oct 3 | Oct 4 | Oct 5 | Oct 6 | Oct 7 | Oct 8 | Oct 9 | Oct 10 | Oct 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | H
I CERTIFY THAT I HAVE WORKED MY NORMAL EMPLOYMENT SCHEDULE EXCEPT AS REFLECTED ABOVE.
GRADUATE ASSISTANT:
APPROVED BY:
SUPERVISOR |  |  |  |  |  |  |  |  | GRADUATE COORDINATOR
SUPERVISOR (IF APPLICABLE)
INSTRUCTIONS FOR COMPLETING TIME REPORT
1 | Please enter name, CWID, department, and the pay period to which the report applies.
2 | Entries should be made to the dates only if the GA/GWS did not complete their normal work schedule
 | and a pay adjustment is required.
3 | Time reports are due in the Payroll Office by 5:00 p.m. on Monday, October 14, 2013.
 | The paydate is Thursday, October 31, 2013.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev. [NAME]
Spreadsheet: 704253d1605464169-changing-a-single-point-of-data-into-a-row-of-data-merging-identical-items-into-total-index-small-if-kalamari-
Sheet: Component stock check

Full part | PP or MP | PREFIX | Cmpt number | Suffix | Combined Count | Total Components | No of pallets | Components per pallet | Part pallets1 | Part pallets2 | Part [NAME] | Part pallets4 | Part pallets5 | Arrived | Expires | [NAME] | Comments | Time counted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Do not delete | Last count dated 10/11
 | Mp | [NAME] | 222222 | XC | 3 pallet/s of 340 & one pallet of 21 | Total cmpts = 1041 | 3 | 340 | 21 |  |  |  |  | 2020-05-18 00:00:00 |  | Bay 2 |  | 09:22:00
 | Mp | WE23 | 343434 | XC | 9 pallet/s of 165 | Total cmpts = 1485 | 9 | 165 |  |  |  |  |  | 2020-05-20 00:00:00 |  | Bay 5 |  | 09:57:00
 | Mp | QW23 | 343421 | CR | 3 pallet/s of 200 & one pallet of 34 | Total cmpts = 634 | 3 | 200 | 34 |  |  |  |  | 2020-06-01 00:00:00 |  | Bay 17 |  | 14:00:00
 | PP | P8P4 | 343422 | DR | 5 pallet/s of 266 | Total cmpts = 1330 | 5 | 266 |  |  |  |  |  |  | 2021-09-09 00:00:00 | Room 4 |  | 13:15:00
 | Mp | [NAME] | 222222 | XC | 1 pallet/s of 300 & one pallet of 56 | Total cmpts = 356 | 1 | 300 | 56 |  |  |  |  |  | 2021-02-16 00:00:00 | Room 7 |  | 13:18:00
Usual stock check is 100+ rows of parts, some are duplicate parts in several locations.
Spreadsheet: 101773d1299813190-draft-day-registration-help-team-draft
Sheet: Rank Order Check

Team | A | B | C | D | E | F | G | H
Messages |  |  |  |  |  |  |  |  |  | Lowest rank picked below player
1
 | For each square, an error occurs if the partner has not been selected and another player has been picked with a lower rank than the partner
 | partner is missing from team
 | AND
 | player has been picked with lower rank than partner
Spreadsheet: 804481d1668098416-extract-data-from-12-different-sheets-into-one-single-column-without-vba-and-powerquerry-test
Sheet: Mar

Style No. | Unit Price
[NAME] | 178.6
[NAME] | 178.6
WTB181720 | 134.2
WTB181720 | 134.2
WTE181112 | 33.85
[NAME] | 158.7
[NAME] | 158.7
WTB281657 | 18.75
WTB281657 | 18.75
WTB281642 | 28.25
Spreadsheet: 286acf50-a178-47ae-88ad-3cb90b3c241f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 12. LEASE FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Transport equipment ; |  |  | Original | A2413515K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Construction and earthmoving equipment ; |  |  | Original | A2413516L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Agricultural machinery and equipment ; |  |  | Original | A2413517R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Manufacturing equipment ; |  |  | Original | A2413518T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Electronic data processing equipment ; |  |  | Original | A2413519V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Office machines ; |  |  | Original | A2413520C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Shop and office furniture, fittings and equipment ; |  |  | Original | A2413521F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Other goods ; |  |  | Original | A2413522J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413523K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 0a92ab73-af8a-4a35-80ea-4ff4b645c3f7
Sheet: Sheet1

No. | Gene name | BAC ID | tag | Tagging primer forward (5'-3') | Tagging primer reverse (5'-3')
1 | KIAA0415 | RP23-384O15 | LAP | TGCGCACGGTCAGCCGGCTGGTGGAGAAGGAGGCTGGCCTCCTGCCAGGTGATTATGATATTCCAACTACTG | CTGCCCAGGCTCTCACGCTGTAGCTACTGTTCAGGTGGTGACTGTCCCTTTCAGAAGAACTCGTCAAGAAG
2 | KIAA0415 | RP11-160E17 | NFLAP | TGCAGCTCCTGGAGTTTCCGAGGTTCGTGCGCGTCTGGTGGCGGCGGCGTGATGGTGTCCAAGGGCGAGGAACTG | AGCTCCCCCGTACCTGGCCTGGTGGAGCAAACTCTCCGCTCCTGCCGAGAAGGCCCTGGGCAGGTCGTCGGTCAG
3 | SPG11 | RP11-264B5 | LAP | [NAME] | TCTGTCAGAATCTGCTAACAGTACAAGAAAACAGACACCTATGAAATCATTCAGAAGAACTCGTCAAGAAG
4 | SPG15 | RP23-406G4 | LAP | GGCTTCTGACAAGCCACTCTCGAGGTGCCCATGGCTCAGGCTCCAGGAAGGATTATGATATTCCAACTACTG | CCTGTCGCCATAGTTCCCAGGCTATGGTTTCCAGGTTCTGCAGCCCAGGGTCAGAAGAACTCGTCAAGAAG
6 | DKFZp761E198 | RP11-58D3 | LAP | CCGTGCTGCCCCTGGCGGGGGACTACCTCCGTGGGCTGGCGGCTGCTGTCGATTATGATATTCCAACTACTG | CTTGGCCCCCACAAGGGCCACAGTCCTGCCCCCACCTGGTCTCCCGGGGCTCAGAAGAACTCGTCAAGAAG
Spreadsheet: 768582d1645034851-help-with-this-test-buy-random_test_v3_1
Sheet: Random

A# | A.Name | Stock | Location 1 | Location 2 | Location 3 | Location 4 | Location 5
Spreadsheet: 714676d1611326805-calculating-number-totals-by-week-with-split-of-days-example-help-sumproduct
Sheet: Sheet1

 |  | Week 1 | Week 1 | Week 1 | Week 1 | Week 1 | Week 1 | Week 1 | Week 2 | Week 2 | Week 2 | Week 2 | Week 2 | Week 2 | Week 2 | Week 3 | Week 3 | Week 3 | Week 3 | Week 3 | Week 3 | Week 3
 |  | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-23 00:00:00 | 2021-01-24 00:00:00 | 2021-01-25 00:00:00 | 2021-01-26 00:00:00 | 2021-01-27 00:00:00 | 2021-01-28 00:00:00 | 2021-01-29 00:00:00 | 2021-01-30 00:00:00 | 2021-01-31 00:00:00 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00
 | 1 | 8 | 8 |  |  |  |  |  |  |  | 8 |  | 8 |  |  | 8
 | 2 |  | 8 | 8 | 8 |  |  |  | 8 | 8 | 8 |  |  |  |  | 8 | 8
 | 3 |  |  |  | 8 |  |  |  | 8 |  |  |  |  |  |  |  | 8
 | 4 |  |  |  |  |  |  |  | 8
 | 5 |  | 8 | 8 | 8 | 8 |  |  | 8 |  |  |  | 8
 |  | Week 1 | Week 2 | Week 3
 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 723412d1615669839-conditional-formatting-and-color-cells-with-formula-testname-6
Sheet: Blad1

Project | Datum | Nr Vlist | [NAME] | Tropco's | Vertrek | Tijd | Aankomst | Aantal | [NAME] | Wie D | Inkoop NL | Inkoop D | [NAME] | Verkoop D
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | 2 | Loheide | 22:00:00 | de lutte | 1 |  | nl | 3.5 | 260 | 4 | 263 |  | Uren inkoop |  |  | Km inkoop
5154 |  |  |  |  |  |  |  |  |  | nl | 3.5 | 265 | 4 | 271 |  | Uren verkoop |  |  | Km verkoop
5154 |  |  |  |  |  |  |  |  |  | nl | 3.5 | 261 | 4 | 267 |  | Verschil uren |  |  | [NAME] km
5155 | 2021-03-19 00:00:00 | 20401250 | 19NLD105 | 2 | de lutte | 23:00:00 | ostenholz | 1 |  | nl | 4 | 269 |  | 271
5155 |  |  |  |  |  |  |  |  |  | nl | 4 | 264 | 4.5 | 268 |  | Inkoop NL |  |  | Inkoop D
5156 | 2021-03-20 00:00:00 | 20102500 | 20NLD108 | 2 | darp | 21:00:00 | ostenholz | 2 | [NAME] | nl | 4.5 | 268 | 5 | 271 |  | [NAME] |  |  | Verkoop D
5156 |  |  |  |  |  |  |  |  | rens | nl | 4 | 267 | 4.5 | 270 |  | [NAME] |  |  | Verschil D
5156 |  |  |  |  |  |  |  |  | rene | nl | 4.5 | 263 |  | 265
5157 | 2021-03-21 00:00:00 | 20100025 | 21NLD209 | 2 | stroe | 20:00:00 | ostenholz | 2 | rene | ast | 4.5 | 294 | 4.75 | 300 |  | Proj NL ink |  |  | Totaal inkoop
5157 |  |  |  |  |  |  |  |  | hilco | ast | 4.25 | 268 | 4.5 | 275 |  | [NAME] ver |  |  | Totaal verkoop
5157 |  |  |  |  |  |  |  |  | willem | ast | 4 | 287 | 4.25 | 291 |  | Proj KM ink |  |  | Totaal verschil
5157 |  |  |  |  |  |  |  |  | ernst | ast | 4.25 | 258 | 4.5 | 264 |  | [NAME] ver
5157 |  |  |  |  |  |  |  |  | wilfried | ics | 4.5 | 267 | 4.75 | 270
5157 |  |  |  |  |  |  |  |  | nl | ics | 5 | 279 | 5.25 | 281 |  | Project verschil NL |  |  |  | Project verschil KM
5157 |  |  |  |  |  |  |  |  | nl | ics | 5.5 | 281 | 5.75 |  |  | Totaal uren NL |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal Verkoop NL |  |  | Totaal verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zoek project | Aantal beg | Inkoop NL | Inkoop D | [NAME] | Verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5157
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Klant | aantal beg
Spreadsheet: 453829d1459457769-formula-if-cell-3-is-blank-have-cell-1-calculate-if-cell-3-filled-have-cell-2-calculate-example_testing
Sheet: Sheet1

 | Days in Shop
 | MARK | NUMBER | Program? | Scheduled | [NAME] | COMMENTS | PID# | uncompleted | completed | Notification
1 | TILX | 270247 |  | 2016-02-10 00:00:00 | 2016-02-04 00:00:00 | [NAME] | 2411C |  |  | 2016-04-01 00:00:00
2 | TILX | 195917 |  |  | 2016-02-09 00:00:00 | [NAME] | 2726A |  |  | 2016-04-01 00:00:00
3 | TILX | 270275 |  |  | 2016-02-11 00:00:00 | [NAME] | 2411C |  |  | 2016-04-08 00:00:00
Spreadsheet: 100557d1298908877-sumifs-on-multiple-work-sheets-2011-master-order-worksheet
Sheet: Oct

Order # | PO # | Terms | Customer | Style | Description | Color | Size | Total Units | Start Ship | Cost | Total Dollars | NOTES
 |  |  |  | 3010 | M KENTON | CHE | 8 | 1 |  | 50
 |  |  |  | 3010 | M KENTON | CHE | 9 | 2 |  | 50
 |  |  |  | 3010 | M KENTON | CHE | 10 | 1 |  | 50
 |  |  |  | 3010 | M KENTON | CHE | 11 | 1 |  | 50
 |  |  |  | 3010 | M KENTON | CHE | 12 | 1 |  | 50
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 5 | 0 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 6 | 0 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 7 | 2 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 8 | 1 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 9 | 1 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 10 | 1 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 5 | 1 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 6 | 2 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 7 | 2 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 8 | 1 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 9 | 1 |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 10 | 0 |  | 70
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 5 | 0 |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 6 | 2 |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 7 | 1 |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 8 | 1 |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 9 | 0 |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 10 | 0 |  | 60
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 5 | 1 |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 6 | 2 |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 7 | 2 |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 8 | 1 |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 9 | 0 |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 10 | 0 |  | 100
 |  |  |  | 5614 | W COZY II | CHE | 5 | 1 |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 6 | 1 |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 7 | 2 |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 8 | 2 |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 9 | 1 |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 10 | 0 |  | 45
 |  |  |  | 1891 | W GREENFIELD | CHE | 6 | 1 |  | 110
 |  |  |  | 1891 | W GREENFIELD | CHE | 7 | 2 |  | 110
 |  |  |  | 1891 | W GREENFIELD | CHE | 8 | 1 |  | 110
 |  |  |  | 1891 | W GREENFIELD | CHE | 9 | 0 |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 5 | 0 |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 6 | 1 |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 7 | 2 |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 8 | 2 |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 9 | 1 |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 10 | 1 |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 5 | 0 |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 6 | 1 |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 7 | 2 |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 8 | 2 |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 9 | 1 |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 10 | 1 |  | 110