Spreadsheet: 542546d1507907367-please-critique-my-spreadsheet-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: #06. 17 March 2017 

Paychecks Dated 17 March 2017 |  | A | check | B | C | D | E |  | F |  | G | Total Job Hours | Total Hours-Per Job |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [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 | 11A | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | Total Hours | Total Hours
# |  |  |  |  |  | Week #1 | Week #2 |  | Week #1 |  | Week #2 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 2017-02-27 00:00:00 | 2017-02-27 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-03-01 00:00:00 | 2017-03-01 00:00:00 | 2017-03-01 00:00:00 | 2017-03-02 00:00:00 | 2017-03-02 00:00:00 | 2017-03-03 00:00:00 | 2017-03-03 00:00:00 | 2017-03-04 00:00:00 | 2017-03-06 00:00:00 | 2017-03-06 00:00:00 | 2017-03-06 00:00:00 | 2017-03-07 00:00:00 | 2017-03-07 00:00:00 | 2017-03-08 00:00:00 | 2017-03-08 00:00:00 | 2017-03-09 00:00:00 | 2017-03-10 00:00:00 | 2017-03-10 00:00:00 | Week #1 | Week #2 | Total Hours
Job |  |  |  |  |  |  |  | > | 40 | > | 40
1 | customer #1 name |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  | x |  |  |  | x |  |  | x | x |  | x |  | x | x | x
2 | customer #2 name |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  | x | x
3 | customer #3 name |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  | x |  | x
4 | customer #4 name |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x |  | x
5 | customer #5 name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | x
6 | customer #6 name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
7 | Shop,  Non-Billable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  | x |  |  |  |  |  |  | x |  | x
Employee
1 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5 | 0 | 8.5 |  | 0 |  | 8.25 | 0 | 0 | 8 | 9 |  | 3 | 0 | 9 | 0 | 7 | 0 |  |  | 0
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5 | 0 |  | 8.5
 | Hours-Regular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Hours-Overtime |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 9 |  |  |  |  | 5 |  |  | 0 | 0 |  | 0
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.5 | 10 |  | 0
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 7 |  | 5.5 |  |  |  |  |  |  |  |  |  |  | 0
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.25 | 10.75 |  | 8.5
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 4 |  |  |  | 0
 | Hours-Regular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Hours-Overtime |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
 | Subtotal-A
 | subtotal-B+C |  |  |  |  | check |  |  |  |  |  |  | check
 | Subtotal-Hours Per Job
 | Subtotal-detail
 | Subtotal-detail
 | Total Hours  less Hours Regular & Overtime: must equal zero.
 | Regular Hours: all must equal zero.
 | Overtime Hours: all must equal zero.
 | Total Hours Per Job less Total Job Hours Regular & Overtime: must equal zero.
 | Total Hours less Total Job Hours: must equal zero.
 | Weighted-Average
 |  |  |  |  |  |  |  |  |  |  |  |  | less: shop
 |  |  |  |  |  |  |  |  |  |  |  |  | hours without shop
 |  |  |  |  |  |  |  |  |  |  |  |  | check
Sales |  | 0
 | n/a | 0
Employee-Office/Overhead |  | regular | overtime | total
Sales/Officer Salary |  | total
 | [NAME] | 0 |  | 0
Employee-Office/Overhead |  | regular | overtime | total
8 | Juro | 65
 |  | 0
 |  | Regular | Overtime | Total
 | Cost of Goods Sold
 | Overhead
 | Total
 |  | regular | Overtime | Total
 | grand total hours
 | check