Spreadsheet: 540366d1506659587-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: #16. 04 August 2017

Paychecks Dated 04 August 2017 |  | A | check | B | C | D | E |  | F |  | G | Total Job Hours | Total Hours-Per Job |  |  |  |  |  | [NAME]-first week |  |  |  |  |  |  |  | [NAME]-second week
 |  | Total Hours | Total Hours | Regular Hours | Overtime Hours | Total Hours | Total Hours |  | Overtime Hours |  | Overtime Hours |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
# |  |  |  |  |  | Week #1 | Week #2 |  | Week #1 |  | Week #2 |  | 1 | 2 | 3 | 4 | 5 | 6 | 2017-07-17 00:00:00 | 2017-07-18 00:00:00 | 2017-07-19 00:00:00 | 2017-07-20 00:00:00 | 2017-07-20 00:00:00 | 2017-07-21 00:00:00 | 2017-07-21 00:00:00 | 2017-07-22 00:00:00 | 2017-07-24 00:00:00 | 2017-07-25 00:00:00 | 2017-07-26 00:00:00 | 2017-07-26 00:00:00 | 2017-07-27 00:00:00 | 2017-07-28 00:00:00
Job |  |  |  |  |  |  |  | > | 40 | > | 40
1 | customer #1 name |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | X | X |  | X
2 | customer #2 name |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  | X |  |  |  | X
3 | customer #3 name |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  | X
4 | customer #4 name |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  | X
5 | customer #5 name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  | X
6 | customer #6 name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | X |  |  |  |  | X |  |  |  | X | X |  | X | X
Employee
1 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 9.25 |  | 8.75
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.25
 | name of employee #1
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.25
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.25 |  |  |  | 7.5 | 2.5 |  | 7 | 9
 | Hours-Regular
 | Hours-Overtime
2 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5 | 7.5 |  | 7.75
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.25 |  |  |  | 6.75
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.75
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 2.5 |  | 7 | 9
 | Hours-Regular
 | Hours-Overtime
 | Subtotal-A
 | subtotal-B+C |  |  |  |  | check |  |  |  |  |  |  | check
 | Subtotal-Hours Per Job
 | Subtotal-detail |  |  |  |  |  |  |  |  |  |  |  | less: shop
 |  |  |  |  |  |  |  |  |  |  |  |  | hours without shop
 | Weighted-Average
Sales
 | n/a
Employee-Office/Overhead |  | regular | overtime | total
Sales/Officer Salary |  | total
 | [NAME] | 0 |  | 0
Employee-Office/Overhead |  | regular | overtime | total
5 | Juro | 79
6 | Amber | 22
 |  | Regular | Overtime | Total
 | Cost of Goods Sold
 | Overhead
 | Total