Spreadsheet: 87217d1287065126-using-conditional-format-to-autoshade-a-calendar-based-on-a-series-or-date-ranges-dummy
Sheet: Jan 2010

2010-01-01 00:00:00 |  |  |  |  | Date INPUT
FLEET DATA |  |  |  |  | ENTRY DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS MONTHS DISTANCE DATA |  |  |  |  | FUEL DATA |  |  | NOTES
PERMANENT DETAILS FOR 'CLAIM ELIGIBLE' VEHICLES |  |  |  |  | FIRST LOGSHEET RECEIVED |  |  |  | SECOND LOGSHEET RECEIVED |  |  |  | THIRD LOGSHEET RECEIVED |  |  |  | [NAME] RECEIVED |  |  |  | FIFTH LOGSHEET RECEIVED |  |  |  | CALCULATED AUTOMATICALLY BASED ON LOGSHEET ENTRIES |  |  |  |  | FUEL DETAILS |  |  | ANY [NAME] NOTES
Vehicle | Vehicle | Main | Vehicle | Type | First  DATE | Last  DATE | Total DISTANCE | Of Which INELIGIBLE | First  DATE | Last  DATE | Total DISTANCE | Of Which INELIGIBLE | First  DATE | Last  DATE | Total DISTANCE | Of Which INELIGIBLE | First  DATE | Last  DATE | Total DISTANCE | Of Which INELIGIBLE | First  DATE | Last  DATE | Total DISTANCE | Of Which INELIGIBLE | Distance Travelled | of which are | Recorded in | Distance Travelled | Converted if miles | Litres | Litres | Litres | [NAME]
FLEET | DPT | DRIVER | REG | FUEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL DISTANCE | INELIGIBLE | MILES/KM | TOTAL ELIGIBLE | TOTAL IN KM | FUEL DRAWN | REPLACEMENT | TOTAL DRAWN | COMMENTS
GROUP 1
A001 | x | Mr A | [NAME] | Diesel | 2010-01-18 00:00:00 | 2010-01-22 00:00:00 | 675 | 34 | 2010-01-04 00:00:00 | 2010-01-09 00:00:00 | 578 | 49 | 2010-01-26 00:00:00 | 2010-01-26 00:00:00 | 42 | 2 | 2010-01-12 00:00:00 | 2010-01-14 00:00:00 | 64 | 7 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 |  |  | 1359 | 92 | miles | 1267 | 2039.87 | 104 | 0 | 104
A002 | x | Mr B | [NAME] | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
B001 | x | Mr C | [NAME] | Diesel | 2010-01-29 00:00:00 | 2010-01-29 00:00:00 | 34 | 6 | 2010-01-01 00:00:00 | 2010-01-23 00:00:00 | 2467 | 231 | 2010-01-26 00:00:00 | 2010-01-27 00:00:00 | 33 | 4 |  |  |  |  |  |  |  |  | 2534 | 241 | miles | 2293 | 3691.73 | 245 | 0 | 245
B002 | x | Mr D | [NAME] | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
B003 | x | Mr E | [NAME] | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
B004 | x | Mr F | [NAME] | Diesel | 2010-01-01 00:00:00 | 2010-01-31 00:00:00 | 3200 | 180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3200 | 180 | miles | 3020 | 4862.200000000001
B005 | x | Mr G | [NAME] | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
A003 | x | etc | [NAME] | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
B006 | x | etc | [NAME] | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
C001 | x | etc | [NAME] | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
GROUP 2
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | Km | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
 |  |  |  | Diesel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | miles | 0 | 0
MONTHS TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7093 | 513 |  | 6580 | 10593.8 | 349 | 0 | 349
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
 |  |  |  | Diesel
MONTHS TOTAL
 | Type 1
 | Type 2
 | Type 3
 | Spare