Spreadsheet: 184154d1349167005-help-required-to-work-out-calculation-please-drivereportscreen01
Sheet: Wednesday

 |  |  |  |  | Drivers Report Card - No:…03…/
 |  | AdBlue:
 |  | Fuel:
 |  | Run Number |  |  |  | Date: |  |  |  |  |  |  |  |  | Week:
 |  | Temp: | 0° C | Weather: |  | Start Time Issued |  |  | Plan: |  |  | Out: |  | In: |  |  |  |  | Vehicle Issued
 | Wednesday |  |  |  |  | Start Time Actual |  |  |  |  |  | Vehicle |  |  |  |  |  |  | Vehicle Condition |  |  |  |  |  |  |  |  |  | Same | +35° C | 1 |  |  | ( | ) | Excellent | 12'4"
 |  |  |  |  |  | Arrived In Yard |  |  | Length: |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | Distance |  |  |  | Different | +34° C | 2 |  |  |  |  | Good | 13' 6"
 |  | Co-ord: |  |  |  | Finish Time Actual |  |  | Duty: |  |  | Depart Time: |  |  |  |  |  |  | Finish Mileage |  |  |  |  |  |  |  |  |  | Altered | +33° C | 3 |  |  |  |  | Average | 13' 7"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brought Forward | +32° C | 4 |  |  |  |  | Bad | 13' 8"
 |  | Trl Height |  | Start Point | Pallets | Leicester |  | Customer | Book | Mileage |  |  |  | Time Arrive |  |  |  |  | Time Depart |  |  |  | Notes |  |  |  |  |  | Time Altered | +31° C | 5 |  |  |  |  |  | 13' 10"
 |  |  |  | Leg 1 |  |  |  |  |  |  |  |  |  |  |  | ( |  | ) |  | ( |  | ) | Load |  |  |  |  |  |  | +30° C | 6 |  |  |  |  |  | 13' 11"
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | ( |  | ) |  | ( |  | ) | Load |  |  |  |  |  |  | +29° C | 7 |  |  |  |  |  | 14' 0"
 |  |  |  | Leg 3 |  |  |  |  |  |  |  |  |  |  |  | ( |  | ) |  | ( |  | ) | Load |  |  |  |  |  |  | +28° C | 8 |  |  |  |  |  | 14' 1"
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | ( |  | ) |  | ( |  | ) | Load |  |  |  |  |  |  | +27° C | 9 |  |  |  |  |  | 14' 2"
 |  |  |  | Leg 5 |  |  |  |  |  |  |  |  |  |  |  | ( |  | ) |  | ( |  | ) | Load |  |  |  |  |  |  | +26° C | 10 |  |  |  |  |  | 14' 3"
 |  |  |  | Leg 6 |  |  |  |  |  |  |  |  |  |  |  | ( |  | ) |  | ( |  | ) | Load |  |  |  |  |  |  | +25° C | 11 |  |  |  |  |  | 14' 4"
 |  |  |  | Leg 7 |  |  |  |  |  |  |  |  |  |  |  | ( |  | ) |  | ( |  | ) | Load |  |  |  |  |  |  | +24° C | 12 |  |  |  |  |  | 14' 5"
 |  | Finish Point |  |  |  | Leicester |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +23° C | 13 |  |  |  |  |  | 14' 6"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +22° C | 14 |  |  |  |  |  | 14' 7"
 |  | Drop 1 Plt Delivered |  |  |  |  | Drop 1 Plt Collected |  | One Way/ |  |  |  |  | PCV Issued |  |  |  |  |  |  | Number: |  |  |  |  |  |  |  | Customer | +21° C | 15 |  |  |  |  |  | 14' 8"
 |  | Drop 2 Plt Delivered |  |  |  |  | Drop 2 Plt Collected |  | One Way/ |  |  |  |  | PCV Issued |  |  |  |  |  |  | Number: |  |  |  |  |  |  |  | Depot | +20° C | 16 |  |  |  |  |  | 14' 9"
 |  | Drop 3 Plt Delivered |  |  |  |  | Drop 3 Plt Collected |  | One Way/ |  |  |  |  | PCV Issued |  |  |  |  |  |  | Number: |  |  |  |  |  |  |  |  | +19° C | 17 |  |  |  |  |  | 14' 10"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +18° C | 18 |  |  |  |  |  | 14' 11"
 |  | Start Point |  |  | Leicester |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays In Yard |  |  |  |  |  |  |  |  |  | Yes | +17° C | 19 |  |  |  |  |  | 15' 0"
 |  | Leg 1 - Route |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays En Route |  |  |  |  |  |  |  |  |  | No | +16° C | 20 |  |  |  |  |  | 15' 1"
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays En Route |  |  |  |  |  |  |  |  |  |  | +15° C | 21 |  |  |  |  |  | 15' 2"
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays En Route |  |  |  |  |  |  |  |  |  |  | +14° C | 22 |  |  |  |  |  | 15' 3"
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays En Route |  |  |  |  |  |  |  |  |  | Phone In | +13° C | 23 |  |  |  |  |  | 15' 4"
 |  | Leg 5 - Route |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays En Route |  |  |  |  |  |  |  |  |  | Issued | +12° C | 24 |  |  |  |  |  | 15' 5"
 |  | Leg 6 - Route |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays En Route |  |  |  |  |  |  |  |  |  | Text | +11° C | 25 |  |  |  |  |  | 15' 6"
 |  | Leg 7 - Route |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays En Route |  |  |  |  |  |  |  |  |  | Rest Day | +10° C | 26 |  |  |  |  |  | 15' 7"
 |  | Finish Point |  |  | Leicester |  |  |  |  |  |  |  |  |  |  |  |  |  | Delays In Yard |  |  |  |  |  |  |  |  |  | Holiday | + 9° C | 27 |  |  |  |  |  | 15' 8"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P.Off | +8° C | 28 |  |  |  |  |  | 15' 9"
 |  | Weekly Rest |  |  |  | Hrs | 6 Hr Rule |  |  |  |  |  |  |  |  |  |  |  | Hours Worked |  |  |  |  |  |  |  |  | 04:30:00 |  | +7° C | 29 |  |  |  |  |  | 15' 10"
 |  | Daily Rest |  |  |  | Hrs | 4.5 Hr Rule |  |  |  |  |  |  |  | ( |  |  | ) |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 30 |  |  |  |  |  | 15' 11"
 |  | Start Daily Rest @ |  |  |  |  | 12 Hr Rule |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | +5° C | 31 |  |  |  |  |  | 16' 0"
 |  | Start Time |  |  |  |  | 9 Hr Rule |  |  |  |  |  |  |  | ( |  |  | ) |  |  |  |  |  |  |  |  |  |  | 00:15:00 | +4° C | 32
 |  |  |  |  |  |  | 1st: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | +3° C | 33
 |  |  |  |  |  |  | 2nd: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:45:00 | +2° C | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:00:00 | +1° C | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0° C | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1° C | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2° C | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3° C | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -4° C | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5° C | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -6° C | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -7° C | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8° C | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - 9° C | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10° C | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -11° C | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -12° C | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -13° C | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -14° C | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -15° C | 51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53