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

Six Numbers for Sue |  |  |  |  |  |  |  |  |  | Basic Hrs | [NAME] | Total Hrs |  |  | Basic £ | OT £ | Total £
 |  | [NAME] | GRADER | GOLDWOOD | Totals |  |  | ProcessingIndirect | PeelerNight Shift
 |  | PH | Grader | Peeler |  |  |  | ProcessingDirect | PeelerDay Shift
Agency Hours (Std) |  |  |  |  |  |  |  | GraderIndirect | GraderDay Shift
Agency Cost (STANDARD) |  |  |  |  |  |  |  | GraderIndirect | GraderDay ShiftNIR
Agency hours (OT) |  |  |  |  |  |  |  | GraderIndirect | GraderDay ShiftForklift
Agency cost (OVERTIME) |  |  |  |  |  |  |  | QCIndirect | GraderDay ShiftQC
Total Agency Hours |  |  |  |  |  |  |  | GraderIndirect | GraderNight ShiftNight
Total Agency Cost |  |  |  |  |  |  |  | GraderIndirect | GraderNight ShiftQC
Inductions |  |  |  |  |  |  |  | GraderIndirect | GraderNight Shiftforklift
 |  |  |  |  |  |  |  | PrepackDirect | PackhouseDay ShiftForklift
 |  |  |  |  |  |  |  | PrepackIndirect | PackhouseNight ShiftMachine
 |  |  |  |  |  |  |  | DispatchIndirect | PackhouseDay ShiftDispatch
 |  |  |  |  |  |  |  | PrepackDirect | PackhouseNight Shift
 |  |  |  |  |  |  |  | PrepackDirect | PackhouseDay Shift
 |  |  |  |  |  |  |  | PrepackDirect | CLIPPER
 |  |  |  |  |  |  |  | PrepackIndirect | Night Shift Premium
 |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  | check
 |  |  |  |  |  |  |  | GraderIndirect
 |  |  |  |  |  |  |  | PrepackDirect
 |  |  |  |  |  |  |  | PrepackIndirect
 |  |  |  |  |  |  |  | DispatchIndirect
 |  |  |  |  |  |  |  | QCIndirect
 |  |  |  |  |  |  |  |  | Peeling Difference
 |  |  |  |  |  |  |  | ProcessingIndirect
 |  |  |  |  |  |  |  | ProcessingDirect
Dept |  |  |  |  | Basic Hrs | [NAME] | Total Hrs | Basic Rate | OT Rate | Basic £ | OT £ | Total £ | Pen B rate | Pen OT rate | Pen £
CLIPPER |  | CLIPPER |  |  | 40 | 52.25333333319753 | 92.25333333319753 | 0.44 | 0.44 | 17.6 | 22.99146666660691 | 40.59146666660692 |  |  | 0
CLIPPER |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0
CLIPPER |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0
CLIPPER Total
GraderDay Shift |  | GraderDay Shift |  |  | 548.9086666652191 | 53.17666666651144 | 602.0853333317306 | 15.37 | 20.4421 | 8436.726206644418 | 1087.042737663494 | 9523.768944307913 | 0.26 | 0.45 | 166.6457533328871
GraderDay Shift |  |  |  |  | 58.81699999955762 | 0 | 58.81699999955762 | 14.1 | 18.753 | 829.3196999937625 | 0 | 829.3196999937625 | 0.26 | 0.45 | 15.29241999988498
GraderDay Shift |  |  |  |  | 80 | 13.32033333357005 | 93.32033333357005 | 13.99 | 18.61 | 1119.2 | 247.8914033377386 | 1367.091403337739 | 0.26 | 0.45 | 26.79415000010652
GraderDay Shift Total
GraderDay ShiftForklift |  | GraderDay ShiftForklift |  |  | 0 | 0 | 0 | 16.53 | 21.9849 | 0 | 0 | 0 | 0.31 | 0.47 | 0
GraderDay ShiftForklift |  |  |  |  | 0 | 0 | 0 | 15.16 | 20.1628 | 0 | 0 | 0 | 0.31 | 0.47 | 0
GraderDay ShiftForklift |  |  |  |  | 42.5 | 8.452000000244475 | 50.95200000024447 | 15.05 | 20.01 | 639.625 | 169.124520004892 | 808.749520004892 | 0.31 | 0.47 | 17.1474400001149
GraderDay ShiftForklift Total
GraderDay ShiftNIR |  | GraderDay ShiftNIR |  |  | 244.4233333328716 | 6.941999999895224 | 251.3653333327668 | 15.37 | 20.4421 | 3756.786633326236 | 141.9090581978581 | 3898.695691524094 | 0.26 | 0.45 | 66.67396666649947
GraderDay ShiftNIR |  |  |  |  | 0 | 0 | 0 | 14.1 | 18.753 | 0 | 0 | 0 | 0.26 | 0.45 | 0
GraderDay ShiftNIR |  |  |  |  | 0 | 0 | 0 | 13.99 | 18.61 | 0 | 0 | 0 | 0.26 | 0.45 | 0
GraderDay ShiftNIR Total
GraderDay ShiftQC |  | GraderDay ShiftQC |  |  | 0 | 0 | 0 | 16.97 | 22.5701 | 0 | 0 | 0 | 0.29 | 0.47 | 0
GraderDay ShiftQC |  |  |  |  | 0 | 0 | 0 | 15.51 | 20.6283 | 0 | 0 | 0 | 0.29 | 0.47 | 0
GraderDay ShiftQC |  |  |  |  | 0 | 0 | 0 | 15.39 | 20.4687 | 0 | 0 | 0 | 0.29 | 0.47 | 0
GraderDay ShiftQC Total
GraderNight Shiftforklift |  | GraderNight Shiftforklift |  |  | 0 | 0 | 0 | 16.53 | 21.9849 | 0 | 0 | 0 | 0.31 | 0.47 | 0
GraderNight Shiftforklift |  |  |  |  | 42.5 | 0.8359999997671679 | 43.33599999976717 | 15.16 | 20.1628 | 644.3 | 16.85610079530545 | 661.1561007953054 | 0.31 | 0.47 | 13.56791999989057
GraderNight Shiftforklift Total
GraderNight ShiftNight |  | GraderNight ShiftNight |  |  | 212.9723333332907 | 13.30799999941792 | 226.2803333327086 | 15.37 | 20.4421 | 3273.384763332677 | 272.0434667881011 | 3545.428230120778 | 0.26 | 0.45 | 61.36140666639364
GraderNight ShiftNight |  |  |  |  | 113.5009999998254 | 18.85566666689562 | 132.356666666721 | 14.1 | 18.753 | 1600.364099997538 | 353.6003170042935 | 1953.964417001831 | 0.26 | 0.45 | 37.99531000005763
GraderNight ShiftNight Total
GraderNight ShiftQC |  | GraderNight ShiftQC |  |  | 29.57 | 13.58266666641831 | 43.15266666641831 | 16.97 | 22.5701 | 501.8029 | 306.562144927728 | 808.3650449277279 | 0.29 | 0.47 | 14.95915333321661
GraderNight ShiftQC |  |  |  |  | 0 | 0 | 0 | 15.51 | 20.6283 | 0 | 0 | 0 | 0.29 | 0.47 | 0
GraderNight ShiftQC Total
Night Shift Premium |  | Night Shift Premium |  |  | 712.0186666666627 | 476.9973333326621 | 1189.015999999325 | 1 | 1 | 712.0186666666627 | 476.9973333326621 | 1189.015999999325 | 0.26 | 0.45 | 399.7736533330303
Night Shift Premium |  | Night Shift Premium |  |  | 320 | 239.2490000000233 | 559.2490000000233 | 1 | 1 | 320 | 239.2490000000233 | 559.2490000000233 |  |  | 0
Night Shift Premium Total
PackhouseDay Shift |  | PackhouseDay Shift |  |  | 1108.99966666735 | 132.5570000010477 | 1241.556666668398 | 15.37 | 20.4421 | 17045.32487667716 | 2709.743449721418 | 19755.06832639858 | 0.26 | 0.45 | 347.9905633339825
PackhouseDay Shift |  |  |  |  | 184.573333333279 | 14.40600000002328 | 198.9793333333023 | 14.1 | 18.753 | 2602.483999999235 | 270.1557180004367 | 2872.639717999671 | 0.26 | 0.45 | 54.47176666666303
PackhouseDay Shift |  |  |  |  | 0 | 0 | 0 | 13.99 | 18.61 | 0 | 0 | 0 | 0.26 | 0.45 | 0
PackhouseDay Shift Total
PackhouseDay ShiftDispatch |  | PackhouseDay ShiftDispatch |  |  | 0 | 0 | 0 | 17.56 | 23.3548 | 0 | 0 | 0 | 0.35 | 0.53 | 0
PackhouseDay ShiftDispatch |  |  |  |  | 0 | 0 | 0 | 16.09 | 21.3997 | 0 | 0 | 0 | 0.35 | 0.53 | 0
PackhouseDay ShiftDispatch |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0.35 | 0.53 | 0
PackhouseDay ShiftDispatch Total
PackhouseDay ShiftForklift |  | PackhouseDay ShiftForklift |  |  | 0 | 0 | 0 | 16.53 | 21.98 | 0 | 0 | 0 | 0.31 | 0.47 | 0
PackhouseDay ShiftForklift |  |  |  |  | 0 | 0 | 0 | 15.16 | 20.1628 | 0 | 0 | 0 | 0.31 | 0.47 | 0
PackhouseDay ShiftForklift |  |  |  |  | 0 | 0 | 0 | 15.05 | 20.01 | 0 | 0 | 0 | 0.31 | 0.47 | 0
PackhouseDay ShiftForklift Total
PackhouseDay ShiftMachine |  |  |  |  | 0 | 0 | 0 | 15.16 | 20.1628 | 0 | 0 | 0 | 0.31 | 0.47 | 0
PackhouseDay ShiftMachine |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0.31 | 0.47 | 0
PackhouseDay ShiftMachine Total
PackhouseNight Shift |  | PackhouseNight Shift |  |  | 187.3729999999534 | 21.18933333352348 | 208.5623333334769 | 15.37 | 20.4421 | 2879.923009999284 | 433.1544709372203 | 3313.077480936504 | 0.36 | 0.47 | 77.41326666673926
PackhouseNight Shift |  |  |  |  | 101.103666667012 | 2.452666666523086 | 103.5563333335351 | 14.1 | 18.753 | 1425.56170000487 | 45.99485799730743 | 1471.556558002177 | 0.36 | 0.47 | 37.55007333339019
PackhouseNight Shift |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0.36 | 0.47 | 0
PackhouseNight Shift Total
PackhouseNight ShiftMachine |  | PackhouseNight ShiftMachine |  |  | 42.5 | 0.002666666627860081 | 42.50266666662786 | 16.53 | 21.98 | 702.5250000000001 | 0.05861333248036459 | 702.5836133324805 | 0.31 | 0.47 | 13.1762533333151
PackhouseNight ShiftMachine Total
PeelerDay Shift |  | PeelerDay Shift |  |  | 79.88633333345363 | 14.6 | 94.48633333345363 | 16.01 | 21.2933 | 1278.980196668593 | 310.88218 | 1589.862376668593 | 0.3 | 0.45 | 30.53590000003609
PeelerDay Shift |  |  |  |  | 38.5 | 3.518000000034924 | 42.01800000003492 | 14.68 | 19.5244 | 565.18 | 68.68683920068187 | 633.8668392006819 | 0.3 | 0.45 | 13.13310000001571
PeelerDay Shift |  |  |  |  | 0 | 0 | 0 | 14.57 | 19.3781 | 0 | 0 | 0 | 0.3 | 0.45 | 0
PeelerDay Shift Total
PeelerNight Shift |  | PeelerNight Shift |  |  | 58.81733333327901 | 2.134666666732635 | 60.95200000001164 | 17.85 | 23.7405 | 1049.889399999031 | 50.67805400156612 | 1100.567454000597 | 0.36 | 0.55 | 22.34830666668339
PeelerNight Shift |  |  |  |  | 0 | 0 | 0 | 16.37 | 21.7721 | 0 | 0 | 0 | 0.36 | 0.55 | 0
PeelerNight Shift |  |  |  |  | 0 | 0 | 0 | 16.25 | 21.6125 | 0 | 0 | 0 | 0.36 | 0.55 | 0
PeelerNight Shift Total
Grand Total
 |  |  |  |  |  | Current Week |  | Prior Week | Difference
WORKSHOPDispatchPackhouseDay Shift | Workshop | Dispatch |  | Day | Forklift
[NAME] | CDS | Grader |  | Day | [NAME]
CDSOldGraderDay Shift | CDS | Grader | OLD | Day | [NAME]
CDSNIRGraderDay Shift | CDS | Grader | NIR | Day | [NAME]
CDSNIRFLGraderDay Shift | CDS | Grader | NIR | Day | Forklift
CDSQCGraderNight Shift | CDS | Grader |  | Night | QC
MS AGRINIRFLGraderDay Shift | [NAME] | Grader |  | Day | Forklift
MS AGRIGraderDay Shift | [NAME] | Grader |  | Day | [NAME]
MS AgriOLDGraderDay Shift | [NAME] | Grader | OLD | Day | [NAME]
Ms AgriNightGraderNight Shift | [NAME] | Grader |  | Night | [NAME]
Staffing NetworkGraderDay Shift | Staff [NAME] | Grader |  | Day | [NAME]
CDSBackyardGraderDay Shift | Staff [NAME] | Grader | Backyard | Day | [NAME]
CDSNIRLLGraderDay Shift | Staff [NAME] | Grader | NIR | Day | [NAME]
[NAME] | CDS | Grader |  | Day | Forklift
FOXNIRFLGraderDay Shift | FOX | Grader |  | Day | Forklift
CDSPeelerNight Shift | CDS | GWM |  | Night | Hygeine
MS AgriPeelerDay Shift | [NAME] | GWM |  | Day | [NAME]
CDSPeelerDay Shift | Staff [NAME] | GWM |  | Day | [NAME]
CDSPackhouseDay Shift | CDS | PH |  | Day | [NAME]
MS [NAME] Shift | [NAME] | PH |  | Day | [NAME]
MS AGRIPackhouseNight Shift | [NAME] | PH |  | Night | [NAME]
STAFFING NETWORKPackhouseDay Shift | Staff [NAME] | PH |  | Day | [NAME]
STAFFNG NETWORKPackhouseDay Shift | Staff [NAME] | PH |  | Day | [NAME]
WORKSHOPPackhouseDay Shift | Workshop | PH |  | Day | [NAME]
MS AgriForkliftPackhouseDay Shift | [NAME] | PH |  | Day | Forklift
 |  |  |  |  | Total