{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Fleet Budget Template","Fuel needed"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Fleet Budget Template","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"merged":[[1,2,1,6],[2,2,2,6],[7,1,7,6],[8,8,18,8],[9,1,13,1],[14,1,18,1],[19,8,21,8],[22,8,23,8],[24,8,26,8]]}
[]
[]
[]
[]
[]
[null,"Country:"]
[]
[null,"Annual Fleet Budget",{"$nulls":6},"Guidance Notes"]
[null,"Fuel","Vehicle type","Avg. litres per 100 km","Total expected kms","Fuel cost per litre","Total Amount USD",null,"Use historical averages (or benchmarks) for the fuel consumption per vehicle type. If price fluctuates, consider average of previous 12 months (for petrol and diesel). "]
[null,"Petrol ","Sedan",{"$nulls":3},{"$f":"(E10/D10)*F10","v":{"$error":"#DIV/0!"}}]
[null,null,"SUV/4x4/Pick-up",{"$nulls":3},{"$f":"(E11/D11)*F11","v":{"$error":"#DIV/0!"}}]
[null,null,"Van/Mini-bus",{"$nulls":3},{"$error":"#DIV/0!"}]
[null,null,"Armoured Vehicles",{"$nulls":3},{"$error":"#DIV/0!"}]
[null,null,"Trucks",{"$nulls":3},{"$error":"#DIV/0!"}]
[null,"Diesel","Sedan",{"$nulls":3},{"$error":"#DIV/0!"}]
[null,null,"SUV/4x4/Pick-up",{"$nulls":3},{"$f":"(E16/D16)*F16","v":{"$error":"#DIV/0!"}}]
[null,null,"Van/Mini-bus",{"$nulls":3},{"$error":"#DIV/0!"}]
[null,null,"Armoured Vehicles",{"$nulls":3},{"$error":"#DIV/0!"}]
[null,null,"Trucks",{"$nulls":3},{"$error":"#DIV/0!"}]
[null,"Maintenance","Vehicle type","Service costs (A+B+C)","Total expected kms","# Service rounds",null,null,"Calculate costs of full round of ABC services (A mini + B filter + A mini + C complete). Based on the expected kms, the number of service rounds can be estimated (dividing the kms by 20000)"]
[null,null,"Petrol vehicles",null,{"$f":"SUM(E10:E14)","v":0},{"$f":"E21/20000","v":0},{"$f":"D21*F21","v":0}]
[null,null,"Diesel vehicles",null,{"$f":"SUM(E15:E19)","v":0},{"$f":"E22/20000","v":0},{"$f":"D22*F22","v":0}]
[null,"Repair",null,null,"Previous Year Costs","Reduction",null,null,"Use repair costs from past year. Reduceby 5 % (as repair should be avoided)"]
[null,null,"Costs ",null,null,{"v":0.05,"d":"5%"},{"$f":"E24*(1-F24)","v":0}]
[null,"Training",{"$nulls":6},"Calculate the costs of the training, either per training or per trainee"]
[null,null,"Training",{"$nulls":3},{"$f":"'Fleet Budget Template'!$D26*'Fleet Budget Template'!$F26","v":0}]
[null,null,"Trainee",{"$nulls":3},{"$f":"'Fleet Budget Template'!$D27*'Fleet Budget Template'!$F27","v":0}]
[null,"Vehicle replacement","Vehicle type",null,"# vehicles to be ordered","Cost per unit"]
[null,null,"Sedan",{"$nulls":3},{"$f":"E29*'Fleet Budget Template'!$F29","v":0}]
[null,null,"SUV/4x4/Pick-up",{"$nulls":3},{"$f":"E30*'Fleet Budget Template'!$F30","v":0}]
[null,null,"Van/Mini-bus",{"$nulls":3},{"$f":"E31*'Fleet Budget Template'!$F31","v":0}]
[null,null,"Armoured Vehicles",{"$nulls":3},{"$f":"E32*'Fleet Budget Template'!$F32","v":0}]
[null,null,"Trucks",{"$nulls":3},{"$f":"E33*'Fleet Budget Template'!$F33","v":0}]
[null,"Total",{"$nulls":4},{"$f":"SUM(G10:G33)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Fuel needed","index":1,"n_rows":15,"n_cols":4,"rows_kept":15}
["Type","Target fuel consumption per 100 km","Total expected kilometers ","Expected liters needed"]
["Sedan",10,{"v":200000,"d":"200,000"},{"$f":"C2/B2","v":{"v":20000,"d":"20,000"}}]
["4x4",14,{"v":100000,"d":"100,000"},{"$f":"C3/B3","v":{"v":7142.857142857143,"d":"7,143"}}]
["AV",17,{"v":50000,"d":"50,000"},{"$f":"C4/B4","v":{"v":2941.176470588235,"d":"2,941"}}]
[]
["Total Petrol",null,{"$f":"SUM(C2:C4)","v":{"v":350000,"d":"350,000"}},{"$f":"SUM(D2:D4)","v":{"v":30084.03361344538,"d":"30,084"}}]
[]
[]
[]
["Type","Target fuel consumption per 100 km","Total expected kilometers ","Expected liters needed"]
["Sedan",10,{"v":200000,"d":"200,000"},{"$f":"C11/B11","v":{"v":20000,"d":"20,000"}}]
["4x4",14,{"v":100000,"d":"100,000"},{"$f":"C12/B12","v":{"v":7142.857142857143,"d":"7,143"}}]
["AV",17,{"v":50000,"d":"50,000"},{"$f":"C13/B13","v":{"v":2941.176470588235,"d":"2,941"}}]
[]
["Total Diesel",null,{"$f":"SUM(C11:C13)","v":{"v":350000,"d":"350,000"}},{"$f":"SUM(D11:D13)","v":{"v":30084.03361344538,"d":"30,084"}}]