Spreadsheet: 542546d1507907367-please-critique-my-spreadsheet-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: Lookup Tables

 |  |  |  |  | A |  | B | C |  |  |  |  | G?
 | Month |  |  | Paychecks Dated | Total Hours | Check Total Hours | Regular Hours | Overtime Hours | Wk 1 Total | Wk 2 Total | Wk 1 OT | Wk 2 OT |  |  |  | Month | Year
 | January | 1 | 9 | 2017-09-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017
 | Feburary | 2 | 9 | 2017-09-01 00:00:00
 | March | 3 | 8 | 2017-08-18 00:00:00
 | April | 4 | 8 | 2017-08-04 00:00:00
 | May | 5 | 7 | 2017-07-21 00:00:00
 | June | 6 | 7 | 2017-07-07 00:00:00
 | July | 7
 | August | 8
 | September | 9
 | October | 10
 | November | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First | Second
 | December | 12
 |  |  |  |  |  | Employee | OT? | Cost Center | External |  | Internal |  | Summary Categories
 |  |  |  |  |  | name of employee #1 | 1 | Cost of Goods Sold | customer #1 name |  | Meeting | meeting = shop | Cost of Goods Sold |  | OT? | Period | Worker | Total Hours | Regular | Overtime
Day | Week | Pay Week | Pay Period | Pay Month | Pay Year | name of employee #2 | 1 | Cost of Goods Sold | customer #2 name |  | Employee-Office/Overhead |  | Overhead |  | 1 | Week 1 | name of employee #1
2016-12-19 00:00:00 |  | Week 1 |  |  |  | name of employee #3 | 1 | Cost of Goods Sold | customer #3 name |  |  |  | Total |  | 1 | Week 1 | name of employee #2
 |  | Week 1 |  |  |  | Juro | 0 | Overhead | customer #4 name |  |  |  |  |  | 1 | Week 1 | name of employee #3
 |  | Week 1 |  |  |  |  |  |  | customer #5 name |  |  |  |  |  | 1 | Week 2 | name of employee #1
 |  | Week 1 |  |  |  |  |  |  | customer #6 name |  |  |  |  |  | 1 | Week 2 | name of employee #2
 |  | Week 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Week 2 | name of employee #3
 |  | Week 1 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Week 1 | Juro
 |  | Week 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Week 1 | name of employee #1
 |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Week 1 | name of employee #2
 |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Week 1 | name of employee #3
 |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Week 2 | name of employee #1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Week 2 | name of employee #2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Week 2 | name of employee #3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Week 1 | Juro
 |  | Week 1
 |  | Week 1
 |  | Week 1
 |  | Week 2
 |  | Week 2
 |  | Week 2
 |  | Week 2
 |  | Week 2
 |  | Week 2
 |  | Week 2
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-04 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-08-18 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-01 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00
 |  |  | 2017-09-15 00:00:00