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

 | Employee name | Lookup | 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 |  | [NAME]
 | rest 40 hrs basic
 | Forklift 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.37 |  |  |  |  | 0.36 | 0.55
 |  |  | PeelerDay Shift | PeelerDay Shift |  |  |  |  |  | 14.68 |  |  |  |  | 0.3 | 0.45
 |  |  | GraderDay Shift | GraderDay Shift |  |  |  |  |  | 14.1 |  |  |  |  | 0.26 | 0.45
 |  |  | GraderDay ShiftNIR | GraderDay ShiftNIR |  |  |  |  |  | 14.1 |  |  |  |  | 0.26 | 0.45
 |  |  | GraderDay ShiftForklift | GraderDay ShiftForklift |  |  |  |  |  | 15.16 |  |  |  |  | 0.31 | 0.47
 |  |  | GraderDay ShiftQC | GraderDay ShiftQC |  |  |  |  |  | 15.51 |  |  |  |  | 0.29 | 0.47
 |  |  | GraderNight ShiftNight | GraderNight ShiftNight
 |  |  | GraderNight ShiftQC | GraderNight ShiftQC
 |  |  | GraderNight Shiftforklift | GraderNight Shiftforklift
 |  |  | PackhouseDay ShiftForklift | PackhouseDay ShiftForklift |  |  |  |  |  | 15.16 | 20.1628 |  |  |  | 0.31 | 0.47
 |  |  | PackhouseDay ShiftMachine | PackhouseDay ShiftMachine |  |  |  |  |  | 15.16 | 20.1628 |  |  |  | 0.31 | 0.47
 |  |  | PackhouseDay ShiftDispatch | PackhouseDay ShiftDispatch |  |  |  |  |  | 16.09 |  |  |  |  | 0.35 | 0.53
 |  |  | PackhouseNight Shift | PackhouseNight Shift |  |  |  |  |  | 14.1 | 18.753 |  |  |  | 0.36 | 0.47
 |  |  | PackhouseDay Shift | PackhouseDay Shift |  |  |  |  |  | 14.1 | 18.753 |  |  |  | 0.26 | 0.45
 |  |  | CLIPPER | CLIPPER
 |  |  | Night Shift Premium | Night Shift Premium |  |  |  |  |  | 1.33 | 1.33
 |  |  | Totals
 |  |  | check
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoice
 | Night Shift Premium
 | Total
 |  |  | Check > 60 |  |  |  |  |  |  |  |  | Inductions
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.1