Spreadsheet: 672756d1586987130-formula-required-for-calculating-mileage-total-to-cost-percentages-zeszyt4-tested-version-private-and-car-hire-colums-trial
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 Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Car Hire Mileage | Running Total | Cost
 |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private Mileage | Running Total | Cost |  |  |  |  |  |  | Daily Private 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 |  |  |  |  |  |  | Daily Business Mileage | Running Total | Cost
1 | 0 |  |  |  |  |  | 0 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500
2 | 0 |  |  |  |  |  | 0 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500
3 | 0 |  |  |  |  |  | 0 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500
4 | 0 |  |  |  |  |  | 0 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500
5 | 0 |  |  |  |  |  | 0 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500
6 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
7 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
8 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
9 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
10 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
11 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
12 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
13 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
14 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
15 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
16 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
17 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
18 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
19 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
20 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
21 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
22 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 2000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
23 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
24 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
25 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
26 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
27 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
28 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
29 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
30 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
31 | 10 |  |  |  |  |  | 1000 |  |  | 10 | 0 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  | 0 | 0 | 0
Total