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

 | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHFL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peeler
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grader
 | Peeler 38.5hrs basic |  |  | Hygiene op 40hrs
 | rest 40 hrs basic
 | Forklift/Machine 42.5hrs |  | Agreed to Comparison
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CDS |  | Difference
 |  |  |  |  |  |  | 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 |  |  |  |  |  | 16.65 | 22.14 |  |  |  | 0.36 | 0.55
 |  |  | PeelerDay Shift | PeelerDay Shift |  |  |  |  |  | 15.13 | 20.12 |  |  |  | 0.3 | 0.45
 |  |  | GraderDay Shift | GraderDay Shift |  |  |  |  |  | 14.24 | 18.94 |  |  |  | 0.26 | 0.45
 |  |  | GraderDay ShiftNIR | GraderDay ShiftNIR |  |  |  |  |  | 14.24 | 18.94 |  |  |  | 0.26 | 0.45
 |  |  | GraderDay ShiftForklift | GraderDay ShiftForklift |  |  |  |  |  | 15.37 | 20.44 |  |  |  | 0.31 | 0.47
 |  |  | GraderDay ShiftQC | GraderDay ShiftQC |  |  |  |  |  | 15.73 | 20.92 |  |  |  | 0.29 | 0.47
 |  |  | GraderNight ShiftNight | GraderNight ShiftNight |  |  |  |  |  | 15.46 | 20.56
 |  |  | GraderNight ShiftQC | GraderNight ShiftQC |  |  |  |  |  | 15.73 | 20.92
 |  |  | GraderNight Shiftforklift | GraderNight Shiftforklift |  |  |  |  |  | 15.37 | 20.44
 |  |  | PackhouseDay ShiftForklift | PackhouseDay ShiftForklift |  |  |  |  |  | 15.37 | 20.44 |  |  |  | 0.31 | 0.47
 |  |  | PackhouseNight ShiftMachine | PackhouseNight ShiftMachine |  |  |  |  |  | 15.37 | 20.44 |  |  |  | 0.31 | 0.47
 |  |  | PackhouseDay ShiftDispatch | PackhouseDay ShiftDispatch |  |  |  |  |  | 16.36 | 21.76 |  |  |  | 0.35 | 0.53
 |  |  | PackhouseNight Shift | PackhouseNight Shift |  |  |  |  |  | 14.24 | 18.94 |  |  |  | 0.36 | 0.47
 |  |  | PackhouseDay Shift | PackhouseDay Shift |  |  |  |  |  | 14.24 | 18.94 |  |  |  | 0.26 | 0.45
 |  |  | CLIPPER | CLIPPER
 |  |  | Night Shift Premium | Night Shift Premium |  |  |  |  |  |  |  |  |  |  | 0.26 | 0.45
 |  |  | Totals
 |  |  | check
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoice
 | Clipping
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Total
 | Night Shift Premium
 | Total
 |  |  | Check > 60 |  |  |  |  |  |  |  |  | Inductions