Spreadsheet: 114025d1309893577-pivot-table-copied-worksheets-still-referring-to-original-worksheet-timesheets-2011_6_26
Sheet: BLANK (2)

[NAME] Payroll Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This adds total hours of each type of code
 |  |  |  |  |  |  |  |  | PAY CODES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE | HOURS | CODE
 |  |  |  |  |  |  |  |  | Department |  | Type of Pay |  |  |  |  |  | Employee Signature: |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | C
Employee: |  |  |  |  |  |  |  |  | (C)omm Svc |  | (O)vertime |  | (F)oreman |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | R
Period beginning: |  |  | 2011-06-26 00:00:00 |  |  |  |  |  | (R)esi Svc |  | (E)mergency |  | (W)arranty |  |  |  | Supervisor Signature: |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | I
 |  |  |  |  |  |  |  |  | (I)nstall |  | (H)oliday |  | (P)rev. Wage |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | W
 |  |  |  |  |  |  |  |  | (W)indows |  | (L)inac |  | (A)ANMP |  |  |  |  | Date: |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | P
Sample: |  | Job |  |  |  |  |  |  | (P)arts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | CO
 |  | Start | Stop | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | CE |  |  | Sum of HOURS | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | CH |  |  | Row Labels |  | C | CE | CH | CL | CO | CW | I | IE | IF | IO | IP | IW | P | PA | PE | PH | PO | R | RE | RH | RO | RW | W | WA | WE | WF | WO | WP | WW | (blank) | Grand Total
SUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | CL |  |  | 2000-01-01 00:00:00 |  | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | CW |  |  | 2011-07-01 00:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
MON |  | Service |  |  |  | Service |  |  |  | Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | RO |  |  | 2011-07-02 00:00:00 | 0:00:00 |  |  |  |  |  |  |  |  | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 7:00:00 |  |  |  |  |  |  | 21:00:00
 |  | 05:00:00 | 13:30:00 | C |  | 13:30:00 | 16:00:00 | C | O | 18:00:00 | 19:30:00 | C | E |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | RE |  |  | (blank)
TUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | RH |  |  | 2011-06-26 00:00:00 | 0:00:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | RW |  |  | 2011-06-27 00:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
WED |  | Service |  |  |  | Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | IO |  |  | 2011-06-28 00:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
 |  | 05:00:00 | 13:30:00 | R |  | 05:00:00 | 13:30:00 | R | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | IE |  |  | 2011-06-29 00:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
THU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | IF |  |  | 2011-06-30 00:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | IW |  |  | Grand Total | 0:00:00 | 7:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 7:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 7:00:00 | 0:00:00 | 7:00:00 | 7:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 1 day, 11:00:00
FRI |  | Service |  |  |  | Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | IP
 |  | 05:00:00 | 13:30:00 | W |  | 05:00:00 | 13:30:00 | W | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | WO
SAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | WE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | WF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | WW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | WP
 |  |  | Standard |  | Overtime |  | Emergency |  | Holiday |  | Linac |  | [NAME] |  | Prev. Wage |  | Warranty |  | AANMP |  | TOTAL |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | WA
 | Commercial Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | PO
 | Residential Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | PE
 | Install |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | PA
 | Windows |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 0 | PH
 | Parts