Spreadsheet: 672385d1586858052-formula-required-for-calculating-mileage-total-to-cost-percentages-bg0612-excel-sheet-query
Sheet: Mileage (Flat Rate)

 | Mileage Total (< 10,000 = 0.45 ppm / > 10,000 = 0.25 ppm)
 | April (06+) |  |  |  |  |  |  | May |  |  |  |  |  |  | June |  |  |  |  |  |  | July |  |  |  |  |  |  | August |  |  |  |  |  |  | September |  |  |  |  |  |  | October |  |  |  |  |  |  | November |  |  |  |  |  |  | December |  |  |  |  |  |  | January |  |  |  |  |  |  | February |  |  |  |  |  |  | March |  |  |  |  |  |  | April
LV15 ZDP    (65,380) | Daily Hire Car Mileage | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost |  |  |  |  |  | Car Hire | Cost
 |  |  | Daily Private Mileage | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost |  |  |  |  |  | Private | Cost
 |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost |  |  |  |  | Daily Business Mileage | Running Total | Cost
1 |  |  |  |  | 5000 |  |  |  |  |  |  | 5000
2 |  |  |  |  | 3000 |  |  |  |  |  |  | 3000
3 |  |  |  |  | 2000 |  |  |  |  |  |  | 2000
4 |  |  |  |  | 200 |  |  |  |  |  |  | 200
5 |  |  |  |  | 100 |  |  |  |  |  |  | 100
6 |  |  |  |  | 100 |  |  |  |  |  |  | 100
7 |  |  |  |  | 100 |  |  |  |  |  |  | 100
8 |  |  |  |  | 100 |  |  |  |  |  |  | 100
9 |  |  |  |  | 100 |  |  |  |  |  |  | 100
10 |  |  |  |  | 100 |  |  |  |  |  |  | 100
11 |  |  |  |  | 100 |  |  |  |  |  |  | 100
12 |  |  |  |  | 100 |  |  |  |  |  |  | 100
13 |  |  |  |  | 100 |  |  |  |  |  |  | 100
14 |  |  |  |  | 500 |  |  |  |  |  |  | 100
15 |  |  |  |  | 5000 |  |  |  |  |  |  | 5000
16 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
17 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
18 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
19 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
20 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
21 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
22 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
23 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
24 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
25 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
26 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
27 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
28 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
29 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
30 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
31 |  |  |  |  | 100 | 0 | 0 |  |  |  |  | 100 | 0
Total |  |  |  |  |  |  | 0