Spreadsheet: 862127d1709895062-i-need-to-make-the-summary-page-more-user-friendly-to-make-it-look-better-analysis-090324
Sheet: CDS Timesheet

 | Employee name | Lookup | Area | Area |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Missing | Total hours | Total Basic Hours | Total OT Hours | Basic Charge Rate | OT Charge Rate | Basic Charge | OT Charge | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH | 40 |  |  | PH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peeler | 38.5 |  |  | Peeler
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grader | 40 |  |  | Grader
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GraderFL | 42.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHFL | 42.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peeler
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grader
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GraderFL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHFL
 | Peeler 38.5hrs basic |  |  | Hygiene op 40hrs
 | rest 40 hrs basic
 | Forklift/Machine 42.5hrs |  | Agreed to Comparison
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CDS |  | Difference
 | wc311223 - 060124 |  |  |  |  |  | Basic Hrs | [NAME] | Total Hrs | Basic Rate | OT Rate | Basic £ | OT £ | Total £ | Pen B rate | Pen OT rate | Pen £ |  | Basic Hrs | [NAME] | Basic Hrs | [NAME]
 |  |  | PeelerNight Shift | PeelerNight Shift |  |  |  |  |  | 17.85 |  |  |  |  | 0.36 | 0.55
 |  |  | PeelerDay Shift | PeelerDay Shift |  |  |  |  |  | 16.01 |  |  |  |  | 0.3 | 0.45
 |  |  | GraderDay Shift | GraderDay Shift |  |  |  |  |  | 15.37 |  |  |  |  | 0.26 | 0.45
 |  |  | GraderDay ShiftNIR | GraderDay ShiftNIR |  |  |  |  |  | 15.37 |  |  |  |  | 0.26 | 0.45
 |  |  | GraderDay ShiftForklift | GraderDay ShiftForklift |  |  |  |  |  | 16.53 |  |  |  |  | 0.26 | 0.45
 |  |  | GraderDay ShiftQC | GraderDay ShiftQC |  |  |  |  |  | 16.97 |  |  |  |  | 0.26 | 0.45
 |  |  | GraderNight ShiftNight | GraderNight ShiftNight |  |  |  |  |  |  |  |  |  |  | 0.26 | 0.45
 |  |  | GraderNight ShiftQC | GraderNight ShiftQC |  |  |  |  |  |  |  |  |  |  | 0.26 | 0.45
 |  |  | GraderNight Shiftforklift | GraderNight Shiftforklift |  |  |  |  |  |  |  |  |  |  | 0.26 | 0.45
 |  |  | PackhouseDay ShiftForklift | PackhouseDay ShiftForklift |  |  |  |  |  | 16.53 | 21.98 |  |  |  | 0.26 | 0.45
 |  |  | PackhouseNight ShiftMachine | PackhouseNight ShiftMachine |  |  |  |  |  | 16.53 | 21.98 |  |  |  | 0.26 | 0.45
 |  |  | PackhouseDay ShiftDispatch | PackhouseDay ShiftDispatch |  |  |  |  |  | 17.56 |  |  |  |  | 0.26 | 0.45
 |  |  | PackhouseNight Shift | PackhouseNight Shift |  |  |  |  |  |  |  |  |  |  | 0.26 | 0.45
 |  |  | PackhouseDay Shift | PackhouseDay Shift |  |  |  |  |  |  |  |  |  |  | 0.26 | 0.45
 |  |  | CLIPPER | CLIPPER |  |  |  |  |  | 0.44 | 0.44
 |  |  | Night Shift Premium | Night Shift Premium |  |  |  |  |  | 1 | 1 |  |  |  | 0.26 | 0.45
 |  |  | Totals
 |  |  | check
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoice
 | Clipping
 | Total
 | Night Shift Premium
 | Total
 |  |  | Check > 60 |  |  |  |  |  |  |  |  | Inductions