{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","General Info","Your Fleet Data","Vehicle sharing impact results","ROI & Scenario Analysis","How the formulas work","Change Management Costs","Impact Summary"],"not_rendered":{"images":14,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":35,"n_cols":3,"rows_kept":35}
{"$rows_empty":34}
[null,null,"admin@fleetforum.org"]

{"sheet":"General Info","index":1,"n_rows":23,"n_cols":5,"rows_kept":23}
[]
[]
[]
[null,"Question","Help Text","Example","Your Answer"]
[null,"Organisation Name","Enter the full name of your organisation","Example NGO","Example Organisation"]
[null,"Who is filling this in?","Enter your name","Jane Doe","Jane Doe"]
[null,"Date of Analysis","Today's date (e.g. 28 May 2025)","22 May 2025","22 May 2025"]
[null,"Period Covered","Specify the period this analysis is for (e.g. Jan 2025 – Dec 2025).","Jan 2025 – Dec 2025","Jan 2025 – Dec 2025"]
[null,"Currency","Currency used for cost inputs (€, $, etc.)","€","$"]
[null,"Petrol price per litre","Average cost per litre of petrol in your country",1.85,1.85]
[null,"Diesel price per litre","Average cost per litre of diesel in your country",1.5,1.5]
[null,"Electricity price per kWh (if using EVs)","Cost per kWh for electric vehicles (optional)",0.25,0.25]
[null,"CO₂ per litre (Diesel)","Default emission factor for diesel; only change if you have more accurate country-specific data.",2.68,2.68]
[null,"CO₂ per litre (Petrol)","Default emission factor for petrol; only change if you have more accurate country-specific data.",2.31,2.31]
[null,"CO₂ per kWh (Electricity)","Average CO₂ per kWh (optional)",0.475,0.475]
[null,{"$f":"\"One-time project cost (\" & $E$9 & \")\"","v":"One-time project cost ($)"},"(Optional) One-time investment required to join or enable the ride sharing scheme (e.g. booking system, software).",5000,500]
[null,{"$f":"\"Monthly cost of a driver (\" & $E$9& \")\"","v":"Monthly cost of a driver ($)"},"Monthly salary + overhead of 1 driver.",1000,1000]
[null,{"$f":"\"Monthly cost of a manager (\" & $E$9 & \")\"","v":"Monthly cost of a manager ($)"},"Monthly salary + overhead of a fleet or project manager (e.g. phone, laptop, per diem).",2500,1500]
[null,"Total number of drivers","Total number of drivers in your organisation, used to estimate driver-related savings.",15,15]
[null,"% time manager spends on this project","Percentage of time the manager will spend on this project. Example: 10 = ~4 hours/week based on a 40-hour work week.",15,{"v":0.05,"d":"5%"}]
[null,{"$f":"\"Monthly HR/support costs (\" & $E$9 & \")\"","v":"Monthly HR/support costs ($)"},"(Optional) Monthly cost of administrative, HR, or logistics support for the scheme.",800,800]
[null,"% of transport demand to be shared","What percentage of your current transport demand do you expect to shift to ride sharing?",10,{"v":0.2,"d":"20%"}]
[null,"% of shared trips using your vehicles","What percentage of shared trips will be completed using your organisation’s own vehicles (vs. external vehicles)?",40,{"v":0.5,"d":"50%"}]

{"sheet":"Your Fleet Data","index":2,"n_rows":37,"n_cols":54,"rows_kept":37,"merged":[[27,5,27,10],[27,11,27,14],[27,18,27,26],[27,27,27,35],[27,36,27,44],[27,45,27,53]]}
{"$rows_empty":26}
[{"$nulls":15},"Helper columns, not for users "]
[{"$nulls":5},"All amounts should be entered per vehicle, per month",{"$nulls":5},"Owned Vehicles",{"$nulls":6},"10% Scenario",{"$nulls":8},"25% Scenario",{"$nulls":8},"50% Scenario",{"$nulls":8},"User Scenario"]
[null,"Vehicle Type","Fuel Type","Ownership","Number of vehicles","Avg monthly KM per vehicle","Fuel cons. (l/100km)","Electric cons. (kWh/100km)","Monthly Lease/Rent ","Monthly Insurance ","Avg monthly maintenance","Purchase Price\n","Purchase Year","Useful Life (years)","Estimated Residual Value","Monthly depreciation","Monthly fuel/energy cost per vehicle","Monthly total cost per vehicle","Monthly KM reduced (10%)","Fuel/Energy costs saved (10%)","Maintenance cost saved (10%)","Fuel saved (10%)","Energy saved (10%)","CO2 Saved (10%)","Deprecation saved (10%)","Lease/rent saved (10%)","Insurance saved (10%)","Monthly KM reduced (25%)","Fuel/Energy costs saved (25%)","Maintenance cost saved (25%)","Fuel Saved (25%)","Energy Saved (25%)","CO2 Saved (25%)","Deprecation saved (25%)","Lease/rent saved (25%)","Insurance saved (25%)","Monthly KM reduced (50%)","Fuel/Energy costs saved (50%)","Maintenance cost saved (50%)","Fuel Saved (50%)","Energy Saved (50%)","CO2 Saved (50%)","Deprecation saved (50%)","Lease/rent saved (50%)","Insurance saved (50%)","Monthly KM Reduced (User %)","Fuel Saved (User %)","Energy Saved (User %)","Fuel/Energy Cost Saved (User %)","CO2 Saved (User %)","Maintenance costs saved (user %)","Deprecation saved (user %)","Lease/rent saved (user%)","Insurance saved (User%)"]
[null,"Light vehicle (Sedan/City vehicle)","Petrol","Rented",5,2000,9,null,250,75,120,{"$nulls":4},{"$f":"IF(D30=\"Owned\",(L30-O30)/N30/12,\"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$11),\nIF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$10),\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Electric cons. (kWh/100km)]]*('General Info'!$E$12),\n\"\")))","v":{"v":333,"d":"333.00"}},{"$f":"IF(Table1[[#This Row],[Ownership]]=\"Owned\",Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly depreciation]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]],Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly Lease/Rent ]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]])","v":{"v":778,"d":"778.00"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.1)*(1-'General Info'!$E$23)","v":500},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":83.25},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.1*(1-'General Info'!$E$23)","v":{"v":6,"d":"6.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":45,"d":"45.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy saved (10%)]] * 'General Info'!$E$15,\n\"\")))","v":103.95},{"$f":"IF(D30=\"Owned\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D30=\"Rented\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":75,"d":"75.00"}},{"$f":"'ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":4.5,"d":"4.50"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.25)*(1-'General Info'!$E$23)","v":{"v":1250,"d":"1,250"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":208.125,"d":"208.13"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.25*(1-'General Info'!$E$23)","v":{"v":15,"d":"15.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":112.5,"d":"112.50"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (25%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":259.875,"d":"259.88"}},{"$f":"IF(D30=\"Owned\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D30=\"Rented\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":187.5,"d":"187.50"}},{"$f":"'ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Monthly Insurance ]]","v":11.25},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.5)*(1-'General Info'!$E$23)","v":{"v":2500,"d":"2,500"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":416.25},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.5*(1-'General Info'!$E$23)","v":{"v":30,"d":"30.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":225,"d":"225.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (50%)]] * 'General Info'!$E$15,\n\"\")))","v":519.75},{"$f":"IF(D30=\"Owned\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D30=\"Rented\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":375,"d":"375.00"}},{"$f":"'ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":22.5,"d":"22.50"}},{"$f":"Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] * ('General Info'!$E$22) * (1 - 'General Info'!$E$23)","v":1000},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":90},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$10,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$11,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$12,\n\"\")))","v":166.5},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$15,\n\"\")))","v":207.9},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*'General Info'!$E$22*(1-'General Info'!$E$23)","v":{"v":12,"d":"12.00"}},{"$f":"IF(D30=\"Owned\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D30=\"Rented\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":150},{"$f":"'ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Monthly Insurance ]]","v":9}]
[null,"4x4/SUV","Diesel","Owned",8,1800,11,null,null,120,180,40000,2020,8,8000,{"v":333.3333333333333,"d":"333.33"},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$11),\nIF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$10),\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Electric cons. (kWh/100km)]]*('General Info'!$E$12),\n\"\")))","v":{"v":297,"d":"297.00"}},{"$f":"IF(Table1[[#This Row],[Ownership]]=\"Owned\",Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly depreciation]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]],Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly Lease/Rent ]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]])","v":{"v":930.3333333333333,"d":"930.33"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.1)*(1-'General Info'!$E$23)","v":720},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":118.80000000000001,"d":"118.80"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.1*(1-'General Info'!$E$23)","v":{"v":9,"d":"9.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":79.2,"d":"79.20"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy saved (10%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":212.25600000000003,"d":"212.26"}},{"$f":"IF(D31=\"Owned\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":159.99999999999997,"d":"160.00"}},{"$f":"IF(D31=\"Rented\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":7.199999999999999,"d":"7.20"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.25)*(1-'General Info'!$E$23)","v":{"v":1800,"d":"1,800"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":297,"d":"297.00"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.25*(1-'General Info'!$E$23)","v":{"v":22.5,"d":"22.50"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":198,"d":"198.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (25%)]] * 'General Info'!$E$15,\n\"\")))","v":530.64},{"$f":"IF(D31=\"Owned\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":399.99999999999994,"d":"400.00"}},{"$f":"IF(D31=\"Rented\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":18,"d":"18.00"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.5)*(1-'General Info'!$E$23)","v":{"v":3600,"d":"3,600"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":594,"d":"594.00"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.5*(1-'General Info'!$E$23)","v":{"v":45,"d":"45.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":396,"d":"396.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (50%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":1061.28,"d":"1,061.28"}},{"$f":"IF(D31=\"Owned\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":799.9999999999999,"d":"800.00"}},{"$f":"IF(D31=\"Rented\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":36,"d":"36.00"}},{"$f":"Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] * ('General Info'!$E$22) * (1 - 'General Info'!$E$23)","v":1440},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":158.4},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$10,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$11,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$12,\n\"\")))","v":237.60000000000002},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$15,\n\"\")))","v":424.51200000000006},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*'General Info'!$E$22*(1-'General Info'!$E$23)","v":{"v":18,"d":"18.00"}},{"$f":"IF(D31=\"Owned\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":319.99999999999994},{"$f":"IF(D31=\"Rented\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Monthly Insurance ]]","v":14.399999999999999}]
[null,"Minibus","Diesel","Rented",3,1400,14,null,350,90,200,{"$nulls":4},"",{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$11),\nIF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$10),\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Electric cons. (kWh/100km)]]*('General Info'!$E$12),\n\"\")))","v":{"v":294,"d":"294.00"}},{"$f":"IF(Table1[[#This Row],[Ownership]]=\"Owned\",Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly depreciation]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]],Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly Lease/Rent ]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]])","v":{"v":934,"d":"934.00"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.1)*(1-'General Info'!$E$23)","v":210},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":44.1,"d":"44.10"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.1*(1-'General Info'!$E$23)","v":{"v":10,"d":"10.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":29.400000000000002,"d":"29.40"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy saved (10%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":78.79200000000002,"d":"78.79"}},{"$f":"IF(D32=\"Owned\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D32=\"Rented\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":63,"d":"63.00"}},{"$f":"'ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":5.3999999999999995,"d":"5.40"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.25)*(1-'General Info'!$E$23)","v":525},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":110.25},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.25*(1-'General Info'!$E$23)","v":{"v":25,"d":"25.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":73.5,"d":"73.50"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (25%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":196.98000000000002,"d":"196.98"}},{"$f":"IF(D32=\"Owned\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D32=\"Rented\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":157.49999999999997,"d":"157.50"}},{"$f":"'ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":13.5,"d":"13.50"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.5)*(1-'General Info'!$E$23)","v":{"v":1050,"d":"1,050"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":220.5,"d":"220.50"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.5*(1-'General Info'!$E$23)","v":{"v":50,"d":"50.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":147,"d":"147.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (50%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":393.96000000000004,"d":"393.96"}},{"$f":"IF(D32=\"Owned\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D32=\"Rented\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":314.99999999999994,"d":"315.00"}},{"$f":"'ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":27,"d":"27.00"}},{"$f":"Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] * ('General Info'!$E$22) * (1 - 'General Info'!$E$23)","v":420},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":58.800000000000004},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$10,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$11,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$12,\n\"\")))","v":88.2},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$15,\n\"\")))","v":157.58400000000003},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*'General Info'!$E$22*(1-'General Info'!$E$23)","v":{"v":20,"d":"20.00"}},{"$f":"IF(D32=\"Owned\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D32=\"Rented\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":126},{"$f":"'ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Monthly Insurance ]]","v":10.799999999999999}]
[null,"Light vehicle (Sedan/City vehicle)","Petrol","Owned",7,1200,7,null,null,70,110,18000,2021,7,3000,{"v":178.57142857142856,"d":"178.57"},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$11),\nIF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$10),\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Electric cons. (kWh/100km)]]*('General Info'!$E$12),\n\"\")))","v":{"v":155.4,"d":"155.40"}},{"$f":"IF(Table1[[#This Row],[Ownership]]=\"Owned\",Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly depreciation]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]],Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly Lease/Rent ]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]])","v":{"v":513.9714285714285,"d":"513.97"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.1)*(1-'General Info'!$E$23)","v":420},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":54.39000000000001,"d":"54.39"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.1*(1-'General Info'!$E$23)","v":{"v":5.5,"d":"5.50"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":29.400000000000002,"d":"29.40"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy saved (10%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":67.914,"d":"67.91"}},{"$f":"IF(D33=\"Owned\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":74.99999999999999,"d":"75.00"}},{"$f":"IF(D33=\"Rented\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":4.2,"d":"4.20"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.25)*(1-'General Info'!$E$23)","v":{"v":1050,"d":"1,050"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":135.975,"d":"135.98"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.25*(1-'General Info'!$E$23)","v":13.75},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":73.5,"d":"73.50"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (25%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":169.785,"d":"169.79"}},{"$f":"IF(D33=\"Owned\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":187.5,"d":"187.50"}},{"$f":"IF(D33=\"Rented\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":10.5,"d":"10.50"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.5)*(1-'General Info'!$E$23)","v":{"v":2100,"d":"2,100"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":271.95},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.5*(1-'General Info'!$E$23)","v":{"v":27.5,"d":"27.50"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":147,"d":"147.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (50%)]] * 'General Info'!$E$15,\n\"\")))","v":339.57},{"$f":"IF(D33=\"Owned\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":375,"d":"375.00"}},{"$f":"IF(D33=\"Rented\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":21,"d":"21.00"}},{"$f":"Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] * ('General Info'!$E$22) * (1 - 'General Info'!$E$23)","v":840},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":58.800000000000004},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$10,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$11,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$12,\n\"\")))","v":108.78000000000002},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$15,\n\"\")))","v":135.828},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*'General Info'!$E$22*(1-'General Info'!$E$23)","v":{"v":11,"d":"11.00"}},{"$f":"IF(D33=\"Owned\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":149.99999999999997},{"$f":"IF(D33=\"Rented\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Monthly Insurance ]]","v":8.4}]
[null,"Minibus","Diesel","Owned",5,1000,10,null,null,95,150,25000,2019,6,4000,{"v":291.6666666666667,"d":"291.67"},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$11),\nIF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$10),\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Electric cons. (kWh/100km)]]*('General Info'!$E$12),\n\"\")))","v":{"v":150,"d":"150.00"}},{"$f":"IF(Table1[[#This Row],[Ownership]]=\"Owned\",Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly depreciation]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]],Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly Lease/Rent ]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]])","v":{"v":686.6666666666667,"d":"686.67"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.1)*(1-'General Info'!$E$23)","v":250},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":37.5,"d":"37.50"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.1*(1-'General Info'!$E$23)","v":{"v":7.5,"d":"7.50"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":25,"d":"25.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy saved (10%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":67,"d":"67.00"}},{"$f":"IF(D34=\"Owned\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":87.5,"d":"87.50"}},{"$f":"IF(D34=\"Rented\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":5.7,"d":"5.70"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.25)*(1-'General Info'!$E$23)","v":625},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":93.75},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.25*(1-'General Info'!$E$23)","v":18.75},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":62.5,"d":"62.50"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (25%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":167.5,"d":"167.50"}},{"$f":"IF(D34=\"Owned\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":218.75},{"$f":"IF(D34=\"Rented\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Monthly Insurance ]]","v":14.25},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.5)*(1-'General Info'!$E$23)","v":{"v":1250,"d":"1,250"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":187.5,"d":"187.50"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.5*(1-'General Info'!$E$23)","v":{"v":37.5,"d":"37.50"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":125,"d":"125.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (50%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":335,"d":"335.00"}},{"$f":"IF(D34=\"Owned\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":437.5,"d":"437.50"}},{"$f":"IF(D34=\"Rented\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":28.5,"d":"28.50"}},{"$f":"Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] * ('General Info'!$E$22) * (1 - 'General Info'!$E$23)","v":500},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":50},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$10,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$11,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$12,\n\"\")))","v":75},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$15,\n\"\")))","v":134},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*'General Info'!$E$22*(1-'General Info'!$E$23)","v":{"v":15,"d":"15.00"}},{"$f":"IF(D34=\"Owned\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":175},{"$f":"IF(D34=\"Rented\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Monthly Insurance ]]","v":11.4}]
[null,"Light vehicle (Sedan/City vehicle)","Electric","Owned",6,800,null,17,null,60,100,28000,2022,10,5000,{"v":191.66666666666666,"d":"191.67"},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$11),\nIF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$10),\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Electric cons. (kWh/100km)]]*('General Info'!$E$12),\n\"\")))","v":{"v":34,"d":"34.00"}},{"$f":"IF(Table1[[#This Row],[Ownership]]=\"Owned\",Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly depreciation]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]],Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly Lease/Rent ]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]])","v":{"v":385.66666666666663,"d":"385.67"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.1)*(1-'General Info'!$E$23)","v":240},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":10.200000000000001,"d":"10.20"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.1*(1-'General Info'!$E$23)","v":{"v":5,"d":"5.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":{"v":40.800000000000004,"d":"40.80"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy saved (10%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":19.380000000000003,"d":"19.38"}},{"$f":"IF(D35=\"Owned\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":69,"d":"69.00"}},{"$f":"IF(D35=\"Rented\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":3.5999999999999996,"d":"3.60"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.25)*(1-'General Info'!$E$23)","v":600},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":25.500000000000004,"d":"25.50"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.25*(1-'General Info'!$E$23)","v":{"v":12.5,"d":"12.50"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":{"v":102.00000000000001,"d":"102.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (25%)]] * 'General Info'!$E$15,\n\"\")))","v":48.45},{"$f":"IF(D35=\"Owned\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":172.49999999999997,"d":"172.50"}},{"$f":"IF(D35=\"Rented\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":9,"d":"9.00"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.5)*(1-'General Info'!$E$23)","v":{"v":1200,"d":"1,200"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":51.00000000000001,"d":"51.00"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.5*(1-'General Info'!$E$23)","v":{"v":25,"d":"25.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":{"v":204.00000000000003,"d":"204.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (50%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":96.9,"d":"96.90"}},{"$f":"IF(D35=\"Owned\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":{"v":344.99999999999994,"d":"345.00"}},{"$f":"IF(D35=\"Rented\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":18,"d":"18.00"}},{"$f":"Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] * ('General Info'!$E$22) * (1 - 'General Info'!$E$23)","v":480},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":81.60000000000001},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$10,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$11,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$12,\n\"\")))","v":20.400000000000002},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$15,\n\"\")))","v":38.760000000000005},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*'General Info'!$E$22*(1-'General Info'!$E$23)","v":{"v":10,"d":"10.00"}},{"$f":"IF(D35=\"Owned\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":138},{"$f":"IF(D35=\"Rented\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Monthly Insurance ]]","v":7.199999999999999}]
[null,"4x4/SUV","Petrol","Rented",2,1600,10,null,300,85,135,{"$nulls":4},"",{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$11),\nIF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$10),\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Electric cons. (kWh/100km)]]*('General Info'!$E$12),\n\"\")))","v":{"v":296,"d":"296.00"}},{"$f":"IF(Table1[[#This Row],[Ownership]]=\"Owned\",Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly depreciation]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]],Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly Lease/Rent ]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]])","v":{"v":816,"d":"816.00"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.1)*(1-'General Info'!$E$23)","v":160},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":29.6,"d":"29.60"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.1*(1-'General Info'!$E$23)","v":6.75},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":16,"d":"16.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy saved (10%)]] * 'General Info'!$E$15,\n\"\")))","v":36.96},{"$f":"IF(D36=\"Owned\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D36=\"Rented\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":36,"d":"36.00"}},{"$f":"'ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":5.1,"d":"5.10"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.25)*(1-'General Info'!$E$23)","v":400},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":74,"d":"74.00"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.25*(1-'General Info'!$E$23)","v":{"v":16.875,"d":"16.88"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":40,"d":"40.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (25%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":92.4,"d":"92.40"}},{"$f":"IF(D36=\"Owned\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D36=\"Rented\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":90,"d":"90.00"}},{"$f":"'ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Monthly Insurance ]]","v":12.75},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.5)*(1-'General Info'!$E$23)","v":800},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":148,"d":"148.00"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.5*(1-'General Info'!$E$23)","v":33.75},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":{"v":80,"d":"80.00"}},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (50%)]] * 'General Info'!$E$15,\n\"\")))","v":{"v":184.8,"d":"184.80"}},{"$f":"IF(D36=\"Owned\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D36=\"Rented\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":{"v":180,"d":"180.00"}},{"$f":"'ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":25.5,"d":"25.50"}},{"$f":"Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] * ('General Info'!$E$22) * (1 - 'General Info'!$E$23)","v":320},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":32},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$10,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$11,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$12,\n\"\")))","v":59.2},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$15,\n\"\")))","v":73.92},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*'General Info'!$E$22*(1-'General Info'!$E$23)","v":{"v":13.5,"d":"13.50"}},{"$f":"IF(D36=\"Owned\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D36=\"Rented\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":72},{"$f":"'ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Monthly Insurance ]]","v":10.2}]
[null,"4x4/SUV",{"$nulls":13},{"$f":"IF(D37=\"Owned\",(L37-O37)/N37/12,\"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$11),\nIF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Fuel cons. (l/100km)]]*('General Info'!$E$10),\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Avg monthly KM per vehicle]]/100)*Table1[[#This Row],[Electric cons. (kWh/100km)]]*('General Info'!$E$12),\n\"\")))","v":""},{"$f":"IF(Table1[[#This Row],[Ownership]]=\"Owned\",Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly depreciation]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]],Table1[[#This Row],[Monthly Insurance ]]+Table1[[#This Row],[Avg monthly maintenance]]+Table1[[#This Row],[Monthly Lease/Rent ]]+Table1[[#This Row],[Monthly fuel/energy cost per vehicle]])","v":{"$error":"#VALUE!"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.1)*(1-'General Info'!$E$23)","v":0},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":0,"d":"0.00"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.1*(1-'General Info'!$E$23)","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (10%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel saved (10%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy saved (10%)]] * 'General Info'!$E$15,\n\"\")))","v":""},{"$f":"IF(D37=\"Owned\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D37=\"Rented\",('ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$C$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":0,"d":"0.00"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.25)*(1-'General Info'!$E$23)","v":0},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":0,"d":"0.00"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.25*(1-'General Info'!$E$23)","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (25%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (25%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (25%)]] * 'General Info'!$E$15,\n\"\")))","v":""},{"$f":"IF(D37=\"Owned\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D37=\"Rented\",('ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$D$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":0,"d":"0.00"}},{"$f":"(Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] *0.5)*(1-'General Info'!$E$23)","v":0},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n    (Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100)) *\n      IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","v":{"v":0,"d":"0.00"}},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*0.5*(1-'General Info'!$E$23)","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Monthly KM reduced (50%)]] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (50%)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (50%)]] * 'General Info'!$E$15,\n\"\")))","v":""},{"$f":"IF(D37=\"Owned\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D37=\"Rented\",('ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$E$4*Table1[[#This Row],[Monthly Insurance ]]","v":{"v":0,"d":"0.00"}},{"$f":"Table1[[#This Row],[Number of vehicles]] * Table1[[#This Row],[Avg monthly KM per vehicle]] * ('General Info'!$E$22) * (1 - 'General Info'!$E$23)","v":0},{"$f":"IF(OR(Table1[[#This Row],[Fuel Type]]=\"Petrol\", Table1[[#This Row],[Fuel Type]]=\"Diesel\"),\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Fuel cons. (l/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[ [#This Row],[Monthly KM Reduced (User %)] ] * (Table1[[#This Row],[Electric cons. (kWh/100km)]] / 100),\n   \"\")","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$10,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$11,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$12,\n\"\")))","v":""},{"$f":"IF(Table1[[#This Row],[Fuel Type]]=\"Petrol\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$14,\nIF(Table1[[#This Row],[Fuel Type]]=\"Diesel\",\n   Table1[[#This Row],[Fuel Saved (User %)]] * 'General Info'!$E$13,\nIF(Table1[[#This Row],[Fuel Type]]=\"Electric\",\n   Table1[[#This Row],[Energy Saved (User %)]] * 'General Info'!$E$15,\n\"\")))","v":""},{"$f":"Table1[[#This Row],[Avg monthly maintenance]]*'General Info'!$E$22*(1-'General Info'!$E$23)","v":{"v":0,"d":"0.00"}},{"$f":"IF(D37=\"Owned\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly depreciation]],\"\")","v":""},{"$f":"IF(D37=\"Rented\",('ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Number of vehicles]])*Table1[[#This Row],[Monthly Lease/Rent ]],\"\")","v":""},{"$f":"'ROI & Scenario Analysis'!$B$4*Table1[[#This Row],[Monthly Insurance ]]","v":0}]

{"sheet":"Vehicle sharing impact results","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"ROI & Scenario Analysis","index":4,"n_rows":46,"n_cols":7,"rows_kept":46,"merged":[[2,6,14,6]]}
[]
[]
[null,{"$f":"\"Your chosen scenario (\" & TEXT('General Info'!E22, \"0%\") & \")\"","v":"Your chosen scenario (20%)"},{"v":0.1,"d":"10%"},{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,{"$f":"'Impact Summary'!C3","v":"Based on the ride sharing analysis, the fleet size of Example Organisation could be reduced by 12% (4 vehicles removed).This means fewer vehicles are needed to meet the same transport demand, helping the organisation to work more efficiently and sustainably.\n\nThis change would lead to a reduction of approximately 5000 kilometers traveled each month, saving around 358 – 448 litres litres of fuel per month and reducing CO2 emissions by 938 – 1173 kg kg per month. These reductions directly contribute to lower environmental impact and support sustainability goals.\n\nThe estimated total cost savings in the first year would range between $ 9.290 – $ 11.613, while net savings after accounting for all costs would be $ 13.691. The initial investment to start the vehicle sharing scheme could be recovered within 1 month(s).\n\nThese calculations are based on a transport demand sharing rate of 20%, meaning nearly a third of trips could be completed using shared vehicles instead of individual ones."}]
["Estimated Fleet Reduction",{"$f":"'General Info'!$E$22*0.6","v":{"v":0.12,"d":"12%"}},{"$f":"C3*0.6","v":{"v":0.06,"d":"6%"}},{"$f":"D3*0.6","v":{"v":0.15,"d":"15%"}},{"v":0.3,"d":"30%"}]
["Current Nr of vehicles",{"$f":"SUM(Table1[Number of vehicles])","v":36},{"$f":"SUM(Table1[Number of vehicles])","v":36},{"$f":"SUM(Table1[Number of vehicles])","v":36},{"$f":"SUM(Table1[Number of vehicles])","v":36}]
["Vehicles Reduced",{"$f":"B5*B4","v":{"v":4.32,"d":"4"}},{"$f":"C5*C4","v":{"v":2.16,"d":"2"}},{"v":5.3999999999999995,"d":"5"},{"v":10.799999999999999,"d":"11"}]
["Km Reduced (monthly)",{"$f":"SUM(Table1[Monthly KM Reduced (User %)])","v":{"v":5000,"d":"5,000"}},{"$f":"SUM(Table1[Monthly KM reduced (10%)])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(Table1[Monthly KM reduced (25%)])","v":{"v":6250,"d":"6,250"}},{"$f":"SUM(Table1[Monthly KM reduced (50%)])","v":{"v":12500,"d":"12,500"}}]
["Fuel saved in litres (monthly)",{"$f":"TEXT(SUM(Table1[Fuel Saved (User %)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[Fuel Saved (User %)]), \"0\") & \" litres\"","v":"358 – 448 litres"},{"$f":"TEXT(SUM(Table1[Fuel saved (10%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[Fuel saved (10%)]), \"0\") & \" litres\"","v":"179 – 224 litres"},{"$f":"TEXT(SUM(Table1[Fuel Saved (25%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[Fuel Saved (25%)]), \"0\") & \" litres\"","v":"448 – 560 litres"},{"$f":"TEXT(SUM(Table1[Fuel Saved (50%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[Fuel Saved (50%)]), \"0\") & \" litres\"","v":"896 – 1120 litres"}]
["Energy saved (monthly)",{"$f":"TEXT(SUM(Table1[Energy Saved (User %)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[Energy Saved (User %)]), \"0\") & \" kWh\"","v":"65 – 82 kWh"},{"$f":"TEXT(SUM(Table1[Energy saved (10%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[Energy saved (10%)]), \"0\") & \" kWh\"","v":"33 – 41 kWh"},{"$f":"TEXT(SUM(Table1[Energy Saved (25%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[Energy Saved (25%)]), \"0\") & \" kWh\"","v":"82 – 102 kWh"},{"$f":"TEXT(SUM(Table1[Energy Saved (50%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[Energy Saved (50%)]), \"0\") & \" kWh\"","v":"163 – 204 kWh"}]
["CO₂ Saved (monthly)",{"$f":"TEXT(SUM(Table1[CO2 Saved (User %)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[CO2 Saved (User %)]), \"0\") & \" kg\"","v":"938 – 1173 kg"},{"$f":"TEXT(SUM(Table1[CO2 Saved (10%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[CO2 Saved (10%)]), \"0\") & \" kg\"","v":"469 – 586 kg"},{"$f":"TEXT(SUM(Table1[CO2 Saved (25%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[CO2 Saved (25%)]), \"0\") & \" kg\"","v":"1173 – 1466 kg"},{"$f":"TEXT(SUM(Table1[CO2 Saved (50%)])*0.8, \"0\") & \" – \" & TEXT(SUM(Table1[CO2 Saved (50%)]), \"0\") & \" kg\"","v":"2345 – 2931 kg"}]
["Variable Cost Savings (monthly)",{"$f":"'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy Cost Saved (User %)]) + SUM(Table1[Maintenance costs saved (user %)]))*0.8, \"#.##0\") & \" – \" & 'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy Cost Saved (User %)]) + SUM(Table1[Maintenance costs saved (user %)])), \"#.##0\")","v":"$ 684 – $ 855"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (10%)]) + SUM(Table1[Maintenance cost saved (10%)]))*0.8, \"#.##0\") & \" – \" & 'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (10%)]) + SUM(Table1[Maintenance cost saved (10%)])), \"#.##0\")","v":"$ 342 – $ 428"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (25%)]) + SUM(Table1[Maintenance cost saved (25%)]))*0.8, \"#.##0\") & \" – \" & 'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (25%)]) + SUM(Table1[Maintenance cost saved (25%)])), \"#.##0\")","v":"$ 855 – $ 1.069"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (50%)]) + SUM(Table1[Maintenance cost saved (50%)]))*0.8, \"#.##0\") & \" – \" & 'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (50%)]) + SUM(Table1[Maintenance cost saved (50%)])), \"#.##0\")","v":"$ 1.710 – $ 2.138"}]
["Fixed Cost Savings (motnhly)",{"$f":"'General Info'!$E$9 & \" \" &\nTEXT((SUM(Table1[Monthly depreciation]) * B6 +\n      SUM(Table1[Monthly Lease/Rent ]) * B6 +\n      SUM(Table1[[Monthly Insurance ]]) * B6) * 0.8, \"#.##0\") &\n\" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT((SUM(Table1[Monthly depreciation]) * B6 +\n      SUM(Table1[Monthly Lease/Rent ]) * B6 +\n      SUM(Table1[[Monthly Insurance ]]) * B6), \"#.##0\")","v":"$ 8.606 – $ 10.758"},{"$f":"'General Info'!$E$9 & \" \" &\nTEXT((SUM(Table1[Monthly depreciation]) * C6 +\n      SUM(Table1[Monthly Lease/Rent ]) * C6 +\n      SUM(Table1[[Monthly Insurance ]]) * C6) * 0.8, \"#.##0\") &\n\" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT((SUM(Table1[Monthly depreciation]) * C6 +\n      SUM(Table1[Monthly Lease/Rent ]) * C6 +\n      SUM(Table1[[Monthly Insurance ]]) * C6), \"#.##0\")","v":"$ 4.303 – $ 5.379"},{"$f":"'General Info'!$E$9 & \" \" &\nTEXT((SUM(Table1[Monthly depreciation]) * D6 +\n      SUM(Table1[Monthly Lease/Rent ]) * D6 +\n      SUM(Table1[[Monthly Insurance ]]) * D6) * 0.8, \"#.##0\") &\n\" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT((SUM(Table1[Monthly depreciation]) * D6 +\n      SUM(Table1[Monthly Lease/Rent ]) * D6 +\n      SUM(Table1[[Monthly Insurance ]]) * D6), \"#.##0\")","v":"$ 10.758 – $ 13.447"},{"$f":"'General Info'!$E$9 & \" \" &\nTEXT((SUM(Table1[Monthly depreciation]) * E6 +\n      SUM(Table1[Monthly Lease/Rent ]) * E6 +\n      SUM(Table1[[Monthly Insurance ]]) * E6) * 0.8, \"#.##0\") &\n\" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT((SUM(Table1[Monthly depreciation]) * E6 +\n      SUM(Table1[Monthly Lease/Rent ]) * E6 +\n      SUM(Table1[[Monthly Insurance ]]) * E6), \"#.##0\")","v":"$ 21.516 – $ 26.895"}]
["Total Cost Savings (monthly)",{"$f":"'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Monthly depreciation]) * B6\n  + SUM(Table1[Monthly Lease/Rent ]) * B6\n  + SUM(Table1[[Monthly Insurance ]]) * B6\n) * 0.8, \"#.##0\"\n)\n& \" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Monthly depreciation]) * B6\n  + SUM(Table1[Monthly Lease/Rent ]) * B6\n  + SUM(Table1[[Monthly Insurance ]]) * B6\n), \"#.##0\"\n)","v":"$ 9.290 – $ 11.613"},{"$f":"'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy costs saved (10%)])\n  + SUM(Table1[Maintenance cost saved (10%)])\n  + SUM(Table1[Monthly depreciation]) * C6\n  + SUM(Table1[Monthly Lease/Rent ]) * C6\n  + SUM(Table1[[Monthly Insurance ]]) * C6\n) * 0.8, \"#.##0\"\n)\n& \" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy costs saved (10%)])\n  + SUM(Table1[Maintenance cost saved (10%)])\n  + SUM(Table1[Monthly depreciation]) * C6\n  + SUM(Table1[Monthly Lease/Rent ]) * C6\n  + SUM(Table1[[Monthly Insurance ]]) * C6\n), \"#.##0\"\n)","v":"$ 4.645 – $ 5.807"},{"$f":"'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy costs saved (25%)])\n  + SUM(Table1[Maintenance cost saved (25%)])\n  + SUM(Table1[Monthly depreciation]) * D6\n  + SUM(Table1[Monthly Lease/Rent ]) * D6\n  + SUM(Table1[[Monthly Insurance ]]) * D6\n) * 0.8, \"#.##0\"\n)\n& \" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy costs saved (25%)])\n  + SUM(Table1[Maintenance cost saved (25%)])\n  + SUM(Table1[Monthly depreciation]) * D6\n  + SUM(Table1[Monthly Lease/Rent ]) * D6\n  + SUM(Table1[[Monthly Insurance ]]) * D6\n), \"#.##0\"\n)","v":"$ 11.613 – $ 14.516"},{"$f":"'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy costs saved (50%)])\n  + SUM(Table1[Maintenance cost saved (50%)])\n  + SUM(Table1[Monthly depreciation]) * E6\n  + SUM(Table1[Monthly Lease/Rent ]) * E6\n  + SUM(Table1[[Monthly Insurance ]]) * E6\n) * 0.8, \"#.##0\"\n)\n& \" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy costs saved (50%)])\n  + SUM(Table1[Maintenance cost saved (50%)])\n  + SUM(Table1[Monthly depreciation]) * E6\n  + SUM(Table1[Monthly Lease/Rent ]) * E6\n  + SUM(Table1[[Monthly Insurance ]]) * E6\n), \"#.##0\"\n)","v":"$ 23.226 – $ 29.033"}]
["One-Time Investment",{"$f":"'General Info'!$E$9 & \" \" & 'General Info'!$E$16","v":"$ 500"},{"$f":"'General Info'!$E$9 & \" \" & 'General Info'!$E$16","v":"$ 500"},{"$f":"'General Info'!$E$9 & \" \" & 'General Info'!$E$16","v":"$ 500"},{"$f":"'General Info'!$E$9 & \" \" & 'General Info'!$E$16","v":"$ 500"}]
["Monthly Recurring Costs",{"$f":" 'General Info'!E9 & \" \" & TEXT('General Info'!E21+('General Info'!E18*'General Info'!E20), \"#.##0\")","v":"$ 875"},{"$f":" 'General Info'!E9 & \" \" & TEXT('General Info'!E21+('General Info'!E18*'General Info'!E20), \"#.##0\")","v":"$ 875"},{"$f":" 'General Info'!E9 & \" \" & TEXT('General Info'!E21+('General Info'!E18*'General Info'!E20), \"#.##0\")","v":"$ 875"},{"$f":" 'General Info'!E9 & \" \" & TEXT('General Info'!E21+('General Info'!E18*'General Info'!E20), \"#.##0\")","v":"$ 875"}]
["MonthlyNetSavings ",{"$f":"'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy Cost Saved (User %)])\n   + SUM(Table1[Maintenance costs saved (user %)]))\n   - B46, \"#.##0\")","v":"$ -20"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (10%)])\n   + SUM(Table1[Maintenance cost saved (10%)]))\n   - B46, \"#.##0\")","v":"$ -447"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (25%)])\n   + SUM(Table1[Maintenance cost saved (25%)]))\n   - B46, \"#.##0\")","v":"$ 194"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy costs saved (50%)])\n   + SUM(Table1[Maintenance cost saved (50%)]))\n   - B46, \"#.##0\")","v":"$ 1.263"}]
["Net Savings (Year 1)",{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Deprecation saved (user %)])\n  + SUM(Table1[Lease/rent saved (user%)])\n  + SUM(Table1[Insurance saved (User%)])\n) * 12\n - (B46*12)\n -B45, \"#.##0\")","v":"$ 13.691"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (10%)]) +\n     SUM(Table1[Maintenance cost saved (10%)]) +\n     SUM(Table1[Deprecation saved (10%)]) +\n     SUM(Table1[Lease/rent saved (10%)]) +\n     SUM(Table1[Insurance saved (10%)])\n    ) * 12\n    - (B46 * 12)\n    - B45\n), \"#.##0\")","v":"$ 1.345"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (25%)]) +\n     SUM(Table1[Maintenance cost saved (25%)]) +\n     SUM(Table1[Deprecation saved (25%)]) +\n     SUM(Table1[Lease/rent saved (25%)]) +\n     SUM(Table1[Insurance saved (25%)])\n    ) * 12\n    - (B46 * 12)\n    - B45\n), \"#.##0\")","v":"$ 19.864"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (50%)]) +\n     SUM(Table1[Maintenance cost saved (50%)]) +\n     SUM(Table1[Deprecation saved (50%)]) +\n     SUM(Table1[Lease/rent saved (50%)]) +\n     SUM(Table1[Insurance saved (50%)])\n    ) * 12\n    - (B46 * 12)\n    - B45\n), \"#.##0\")","v":"$ 50.727"}]
["Net Savings Year 2 ( Cumulative)",{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Deprecation saved (user %)])\n  + SUM(Table1[Lease/rent saved (user%)])\n  + SUM(Table1[Insurance saved (User%)])\n) * 24\n - (B46*24)\n -B45, \"#.##0\")","v":"$ 27.882"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (10%)]) +\n     SUM(Table1[Maintenance cost saved (10%)]) +\n     SUM(Table1[Deprecation saved (10%)]) +\n     SUM(Table1[Lease/rent saved (10%)]) +\n     SUM(Table1[Insurance saved (10%)])\n    ) * 24\n    - (B46 * 24)\n    - B45\n), \"#.##0\")","v":"$ 3.191"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (25%)]) +\n     SUM(Table1[Maintenance cost saved (25%)]) +\n     SUM(Table1[Deprecation saved (25%)]) +\n     SUM(Table1[Lease/rent saved (25%)]) +\n     SUM(Table1[Insurance saved (25%)])\n    ) * 24\n    - (B46 * 24)\n    - B45\n), \"#.##0\")","v":"$ 40.227"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (50%)]) +\n     SUM(Table1[Maintenance cost saved (50%)]) +\n     SUM(Table1[Deprecation saved (50%)]) +\n     SUM(Table1[Lease/rent saved (50%)]) +\n     SUM(Table1[Insurance saved (50%)])\n    ) * 24\n    - (B46 * 24)\n    - B45\n), \"#.##0\")","v":"$ 101.955"}]
["Net Savings Year 3 (Cumulative)",{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Deprecation saved (user %)])\n  + SUM(Table1[Lease/rent saved (user%)])\n  + SUM(Table1[Insurance saved (User%)])\n) * 36\n - (B46*36)\n -B45, \"#.##0\")","v":"$ 42.073"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (10%)]) +\n     SUM(Table1[Maintenance cost saved (10%)]) +\n     SUM(Table1[Deprecation saved (10%)]) +\n     SUM(Table1[Lease/rent saved (10%)]) +\n     SUM(Table1[Insurance saved (10%)])\n    ) * 36\n    - (B46 * 36)\n    - B45\n), \"#.##0\")","v":"$ 5.036"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (25%)]) +\n     SUM(Table1[Maintenance cost saved (25%)]) +\n     SUM(Table1[Deprecation saved (25%)]) +\n     SUM(Table1[Lease/rent saved (25%)]) +\n     SUM(Table1[Insurance saved (25%)])\n    ) * 36\n    - (B46 * 36)\n    - B45\n), \"#.##0\")","v":"$ 60.591"},{"$f":"'General Info'!$E$9 & \" \" & TEXT((\n    (SUM(Table1[Fuel/Energy costs saved (50%)]) +\n     SUM(Table1[Maintenance cost saved (50%)]) +\n     SUM(Table1[Deprecation saved (50%)]) +\n     SUM(Table1[Lease/rent saved (50%)]) +\n     SUM(Table1[Insurance saved (50%)])\n    ) * 36\n    - (B46 * 36)\n    - B45\n), \"#.##0\")","v":"$ 153.182"}]
["Net Savings - WITHOUT reducing vehicles (Year 1)",{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n    + SUM(Table1[Maintenance costs saved (user %)])) * 12\n    - (B46 * 12)\n    - B45,\n\"#.##0\")","v":"$ -738"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (10%)])\n    + SUM(Table1[Maintenance cost saved (10%)])) * 12\n    - (B46 * 12)\n    - B45,\n\"#.##0\")","v":"$ -5.869"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (25%)])\n    + SUM(Table1[Maintenance cost saved (25%)])) * 12\n    - (B46 * 12)\n    - B45,\n\"#.##0\")","v":"$ 1.828"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (50%)])\n    + SUM(Table1[Maintenance cost saved (50%)])) * 12\n    - (B46 * 12)\n    - B45,\n\"#.##0\")","v":"$ 14.655"}]
["Net Savings - WITHOUT reducing vehicles (Year 2)",{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n    + SUM(Table1[Maintenance costs saved (user %)])) * 24\n    - (B46 * 24)\n    - B45,\n\"#.##0\")","v":"$ -976"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (10%)])\n    + SUM(Table1[Maintenance cost saved (10%)])) * 24\n    - (B46 * 24)\n    - B45,\n\"#.##0\")","v":"$ -11.238"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (25%)])\n    + SUM(Table1[Maintenance cost saved (25%)])) * 24\n    - (B46 * 24)\n    - B45,\n\"#.##0\")","v":"$ 4.155"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (50%)])\n    + SUM(Table1[Maintenance cost saved (50%)])) * 24\n    - (B46 * 24)\n    - B45,\n\"#.##0\")","v":"$ 29.811"}]
["Net Savings - WITHOUT reducing vehicles (Year 3)",{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n    + SUM(Table1[Maintenance costs saved (user %)])) * 36\n    - (B46 * 36)\n    - B45,\n\"#.##0\")","v":"$ -1.214"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (10%)])\n    + SUM(Table1[Maintenance cost saved (10%)])) * 36\n    - (B46 * 36)\n    - B45,\n\"#.##0\")","v":"$ -16.607"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (25%)])\n    + SUM(Table1[Maintenance cost saved (25%)])) * 36\n    - (B46 * 36)\n    - B45,\n\"#.##0\")","v":"$ 6.483"},{"$f":"'General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy costs saved (50%)])\n    + SUM(Table1[Maintenance cost saved (50%)])) * 36\n    - (B46 * 36)\n    - B45,\n\"#.##0\")","v":"$ 44.966"}]
["Payback/ROI (months)",{"$f":"IF(\n    (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n    + SUM(Table1[Maintenance costs saved (user %)])\n    + SUM(Table1[Deprecation saved (user %)])\n    + SUM(Table1[Lease/rent saved (user%)])\n    + SUM(Table1[Insurance saved (User%)])\n    - B46) > 0,\n    ROUNDUP(\n        B45 /\n        (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n        + SUM(Table1[Maintenance costs saved (user %)])\n        + SUM(Table1[Deprecation saved (user %)])\n        + SUM(Table1[Lease/rent saved (user%)])\n        + SUM(Table1[Insurance saved (User%)])\n        - B46),\n    0),\n    \"No payback\"\n)","v":1},{"$f":"IF(\n    (SUM(Table1[Fuel/Energy costs saved (10%)])\n    + SUM(Table1[Maintenance cost saved (10%)])\n    + SUM(Table1[Deprecation saved (10%)])\n    + SUM(Table1[Lease/rent saved (10%)])\n    + SUM(Table1[Insurance saved (10%)])\n    - B46) > 0,\n    ROUNDUP(\n        B45 /\n        (SUM(Table1[Fuel/Energy costs saved (10%)])\n        + SUM(Table1[Maintenance cost saved (10%)])\n        + SUM(Table1[Deprecation saved (10%)])\n        + SUM(Table1[Lease/rent saved (10%)])\n        + SUM(Table1[Insurance saved (10%)])\n        - B46),\n    0),\n    \"No payback\"\n)","v":4},{"$f":"IF(\n    (SUM(Table1[Fuel/Energy costs saved (25%)])\n    + SUM(Table1[Maintenance cost saved (25%)])\n    + SUM(Table1[Deprecation saved (25%)])\n    + SUM(Table1[Lease/rent saved (25%)])\n    + SUM(Table1[Insurance saved (25%)])\n    - B46) > 0,\n    ROUNDUP(\n        B45 /\n        (SUM(Table1[Fuel/Energy costs saved (25%)])\n        + SUM(Table1[Maintenance cost saved (25%)])\n        + SUM(Table1[Deprecation saved (25%)])\n        + SUM(Table1[Lease/rent saved (25%)])\n        + SUM(Table1[Insurance saved (25%)])\n        - B46),\n    0),\n    \"No payback\"\n)","v":1},{"$f":"IF(\n    (SUM(Table1[Fuel/Energy costs saved (50%)])\n    + SUM(Table1[Maintenance cost saved (50%)])\n    + SUM(Table1[Deprecation saved (50%)])\n    + SUM(Table1[Lease/rent saved (50%)])\n    + SUM(Table1[Insurance saved (50%)])\n    - B46) > 0,\n    ROUNDUP(\n        B45 /\n        (SUM(Table1[Fuel/Energy costs saved (50%)])\n        + SUM(Table1[Maintenance cost saved (50%)])\n        + SUM(Table1[Deprecation saved (50%)])\n        + SUM(Table1[Lease/rent saved (50%)])\n        + SUM(Table1[Insurance saved (50%)])\n        - B46),\n    0),\n    \"No payback\"\n)","v":1}]
{"$rows_empty":21}
[null,{"$f":"'General Info'!E16","v":500},"B14"]
[null,{"$f":" 'General Info'!E21 + ('General Info'!E18 * 'General Info'!E20)","v":875},"B15"]

{"sheet":"How the formulas work","index":5,"n_rows":41,"n_cols":4,"rows_kept":41,"merged":[[1,1,1,3],[7,1,7,3],[19,1,19,3]]}
[]
[null,"Per vehicle monthly calculations"]
[null,"Field","Formula","Explanation"]
[null,"Monthly depreciation","IF([@Ownership]=\"Owned\"; ([@[Purchase Price]] - [@[Residual Value]]) / [@[Useful Life (years)]] / 12; \"\")","This formula calculates how much value an owned vehicle loses per month over its useful life. It only applies to owned vehicles and ensures that depreciation is not calculated for rented ones."]
[null,"Monthly fuel/energy cost per vehicle","IF([@Fuel Type]=\"Diesel\";\n    ([@[Avg monthly KM per vehicle]] / 100) * [@[Fuel cons. (l/100km)]] * 'General Info'!Diesel price per litre;\nIF([@Fuel Type]=\"Petrol\";\n    ([@[Avg monthly KM per vehicle]] / 100) * [@[Fuel cons. (l/100km)]] * 'General Info'!Petrol price per litre;\nIF([@Fuel Type]=\"Electric\";\n    ([@[Avg monthly KM per vehicle]] / 100) * [@[Electric cons. (kWh/100km)]] * 'General Info'!Electricity price per kWh;\n\"\")))","This formula calculates the monthly energy cost per vehicle by taking the average number of kilometres driven per vehicle each month, dividing it by 100 to align with the consumption unit (litres or kWh per 100 km), and then multiplying this by the vehicle’s specific fuel or energy consumption. The result is then multiplied by the applicable fuel or electricity price from the General Info sheet, depending on whether the vehicle uses diesel, petrol, or electricity."]
[null,"Monthly total cost per vehicle","IF([@Ownership]=\"Owned\";[@[Monthly Insurance ]]+[@[Avg monthly maintenance]]+[@[Monthly depreciation]]+[@[Monthly fuel/energy cost per vehicle]];[@[Monthly Insurance ]]+[@[Avg monthly maintenance]]+[@[Monthly Lease/Rent ]]+[@[Monthly fuel/energy cost per vehicle]])","This formula calculates the total monthly cost per vehicle by first checking whether the vehicle is owned or rented. If the vehicle is owned, the total cost includes monthly insurance, average monthly maintenance, monthly depreciation, and the monthly fuel or energy cost. If the vehicle is rented, the formula instead includes monthly insurance, average monthly maintenance, monthly lease or rent, and the monthly fuel or energy cost. This ensures that only the relevant cost components are included based on the vehicle's ownership status."]
[]
[null,"Per vehicle monthly scenario calculations"]
[null,"Field","Formula","Explanation"]
[null,"Monthly KM reduced (10%, 25%, 50%)","([@[Number of vehicles]] * [@[Avg monthly KM per vehicle]] * X)*(1 - 'General Info'!$E$23)X  0.10 for 10%, 0.25 for 25%, and 0.50 for 50%","This formula estimates the reduction in kilometres driven by your fleet when a percentage (10%, 25%, or 50%) of your transport demand shifts to a ride sharing scheme. It multiplies the number of vehicles by the average kilometres driven per vehicle and applies the chosen shift percentage (X). It then adjusts this based on the percentage of shared trips not using your own vehicles, a value specified in the General Info sheet, to reflect only the reduction attributable to external sharing."]
[null,"Fuel/Energy costs saved (10%, 25%, 50%)","IF([@[Fuel Type]]=\"Electric\",\n   ([@[Monthly KM reduced (X%)]] * ([@[Electric cons. (kWh/100km)]] / 100)) * 'General Info'!$E$12,\n   ([@[Monthly KM reduced (X%)]] * ([@[Fuel cons. (l/100km)]] / 100)) *\n      IF([@[Fuel Type]]=\"Petrol\", 'General Info'!$E$10, 'General Info'!$E$11)\n)","This formula calculates the amount of fuel or energy cost saved when 10%, 25%, or 50% of your transport demand shifts away from your fleet. The calculation structure is identical for each scenario, only the percentage (X) changes, impacting the reduced distance and subsequent savings."]
[null,"Maintenance cost saved (10%, 25%, 50%)","[@[Avg monthly maintenance]] * X * (1 - 'General Info'!$E$23)","This formula estimates the monthly maintenance cost savings per vehicle when 10% of transport demand shifts away from your fleet. It takes 10% of the average monthly maintenance cost per vehicle and adjusts it based on the percentage of shared trips not using your own vehicles. The adjustment factor comes from the General Info sheet under “% of shared trips using your vehicles.” This ensures that only the share of avoided maintenance costs due to reduced usage of your own fleet is included in the calculation."]
[null,"Fuel saved (10%, 25%, 50%)","IF(OR([@[Fuel Type]]\"Petrol\"; [@[Fuel Type]]\"Diesel\"); [@[Monthly KM reduced (X%)]] * ([@[Fuel cons. (l/100km)]] / 100); \"\")","This formula calculates the number of litres of fuel saved per vehicle when a percentage (10%, 25%, or 50%) of transport demand shifts to a ride sharing scheme. It applies only to vehicles that use petrol or diesel. It multiplies the monthly kilometres reduced (X%) by the vehicle’s fuel consumption per 100 km. If the vehicle is electric, the formula returns a blank. This helps quantify the environmental impact of reduced usage of internal combustion engine vehicles."]
[null,"Energy saved (10%, 25%, 50%)","IF([@[Fuel Type]]\"Electric\"; [@[Monthly KM reduced (X%)]] * ([@[Electric cons. (kWh/100km)]] / 100); \"\")","This formula calculates the number of kilowatt-hours (kWh) of electricity saved per electric vehicle when a percentage (10%, 25%, or 50%) of transport demand is shifted away. It multiplies the monthly kilometres reduced by the vehicle’s electric consumption per 100 km. The formula applies only to electric vehicles and returns a blank for petrol or diesel, ensuring accurate energy savings are captured."]
[null,"CO₂ saved (10%, 25%, 50%)","IF([@[Fuel Type]]=\"Petrol\";\n   [@[Fuel saved (X%)]] * 'General Info'!$E$14;\nIF([@[Fuel Type]]=\"Diesel\";\n   [@[Fuel saved (X%)]] * 'General Info'!$E$13;\nIF([@[Fuel Type]]=\"Electric\";\n   [@[Energy saved (X%)]] * 'General Info'!$E$15;\n\"\")))","This formula calculates the number of kilowatt-hours (kWh) of electricity saved per electric vehicle when a percentage (10%, 25%, or 50%) of transport demand is shifted away. It multiplies the monthly kilometres reduced by the vehicle’s electric consumption per 100 km. The formula applies only to electric vehicles and returns a blank for petrol or diesel, ensuring accurate energy savings are captured."]
[null,"Depreciation saved (10%, 25%, 50%)","IF(Ownership=\"Owned\";('ROI & Scenario Analysis'!$C$4*[@[Number of vehicles]])*[@[Monthly depreciation]];\"\")","This formula estimates the depreciation costs that can be saved if your fleet size is reduced due to a shift in transport demand. It applies only to vehicles marked as “Owned.” The number of vehicles is multiplied by the estimated fleet reduction percentage from the 'ROI & Scenario Analysis' sheet (e.g. 6% for 10%, 15% for 25%, 30% for 50%), then by the monthly depreciation. These percentages are based on Fleet Forum’s assumptions drawn from experience with organisations implementing ride sharing."]
[null,"Lease/Rent saved (10%, 25%, 50%)","IF(Ownership=\"Rented\";('ROI & Scenario Analysis'!$C$4*[@[Number of vehicles]])*[@[Monthly Lease/Rent ]];\"\")","This formula estimates the lease or rent cost savings if your fleet size is reduced due to a shift in transport demand. It applies only to vehicles marked as “Rented.” The calculation multiplies the number of rented vehicles by the fleet reduction percentage (from the 'ROI & Scenario Analysis' sheet) and then by the monthly lease or rent cost. Fleet reduction rates used (6%, 15%, 30%) are assumptions from Fleet Forum’s experience with ride sharing schemes."]
[null,"Insurance saved (10%, 25%, 50%)","ROI & Scenario Analysis'!$C$4 * [@[Monthly Insurance ]]","This formula calculates the insurance cost savings from reducing fleet size under different transport demand shift scenarios. It multiplies the estimated fleet reduction (from the 'ROI & Scenario Analysis' sheet) by the monthly insurance cost per vehicle. This applies to both owned and rented vehicles. The reduction rates used are based on Fleet Forum’s insights: 6% for 10%, 15% for 25%, and 30% for 50% shift scenarios."]
[]
[null,"Ride sharing scenario savings"]
[null,"Field","Formula","Explanation"]
[null,"Estimated Fleet Reduction","% transport demand shift to rise ahring *60%","This formula estimates the percentage reduction in your fleet size that can be achieved based on the percentage of your transport demand expected to be shifted to ride sharing. The input comes from the \"General Info\" sheet (cell E22), where users specify the share of their transport demand they expect to shift , Or the static columns of 10, 25 and 50%. This input is then multiplied by 0.6 — a factor based on Fleet Forum’s experience indicating that, on average, a 10% shift in demand results in approximately a 6% reduction in fleet size. This assumption helps translate transport demand shifts into practical implications for vehicle fleet planning."]
[null,"Current Nr of vehicles","SUM(Table1[Number of vehicles])","This formula calculates the total number of vehicles currently in your fleet by summing all values in the column Number of vehicles from the main data table (named Table1). Each row in this column represents the number of vehicles of a specific type or category. By adding them together, you get a comprehensive count of all vehicles across your fleet. This total serves as a reference point for determining potential fleet reductions and cost savings in the ROI and scenario analysis."]
[null,"Vehicles Reduced","Current Number of Vehicles * Estimated Fleet Reduction Percentage","This formula calculates how many vehicles can potentially be removed from your fleet as a result of shifting a portion of your transport demand to ride sharing. It multiplies the current number of vehicles (B5) by the estimated fleet reduction percentage (B4), which is based on the percentage of transport demand shared (input in the General Info sheet). This gives an estimate of how many vehicles are no longer needed if the shared mobility scenario is implemented."]
[null,"Km Reduced (monthly)","SUM(Table1[Monthly KM Reduced (X %)])","This formula calculates the total number of kilometres that will no longer be driven by your fleet each month when a portion of your transport demand shifts to ride sharing. It sums the values from the column Monthly KM Reduced (X %) in your main data table (Table1), where X represents the selected shift percentage (e.g., 10%, 25%, or 50%). These values already factor in both the shift percentage and the share of trips not conducted with your own vehicles, based on information provided in the General Info sheet. The result reflects the total monthly driving distance avoided by your fleet under the selected scenario."]
[null,"Fuel saved in litres (monthly)","TEXT(SUM(Table1[Fuel saved (X%)])*0,8; \"0\") & \" – \" & TEXT(SUM(Table1[Fuel saved (X%)]); \"0\") & \" litres\"","This formula calculates a range for the estimated total monthly fuel savings in litres across all petrol and diesel vehicles. It sums the values from the “Fuel saved” column in the fleet data table, which is based on the percentage of transport demand shifted to ride sharing. To reflect potential variation in actual savings, the total is multiplied by 0.8 to create a conservative lower estimate, while the full total is shown as the upper estimate. The result is displayed as a range (e.g., “240 – 300 litres”), helping users interpret the savings as an estimate rather than a fixed outcome. All numbers are rounded to whole litres for readability."]
[null,"Energy saved (monthly)","TEXT(SUM(Table1[Energy Saved (User %)])*0,8; \"0\") & \" – \" & TEXT(SUM(Table1[Energy Saved (User %)]); \"0\") & \" kWh\"","This formula calculates the estimated monthly energy savings (in kilowatt-hours) resulting from a shift in transport demand to ride sharing. It sums all values from the Energy Saved (X %) column in your main data table (Table1), where X represents the selected shift percentage (such as 10%, 25%, or 50%). The result is displayed as a range: the lower bound assumes that 80% of the calculated savings are realised, while the upper bound reflects the full potential savings. The final output is presented as a text string with the suffix \"kWh\" to clearly indicate the unit of measurement."]
[null,"CO₂ Saved (monthly)","TEXT(SUM(Table1[CO2 Saved (User %)])*0,8; \"0\") & \" – \" & TEXT(SUM(Table1[CO2 Saved (User %)]); \"0\") & \" kg\"","This formula calculates the estimated monthly reduction in CO₂ emissions (in kilograms) resulting from a portion of transport demand being shifted to ride sharing. It adds up the values from the CO₂ Saved (X %) column in your main data table (Table1), where X represents the selected demand shift percentage. The result is displayed as a range: the lower bound reflects a conservative estimate assuming 80% of the potential CO₂ savings are realised, while the upper bound represents the full possible savings. The result is shown as a formatted text string with \"kg\" to clearly indicate the unit."]
[null,"Variable Cost Savings","General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy Cost Saved (User %)]) + SUM(Table1[Maintenance costs saved (user %)]))*0,8; \"#.##0\") & \" – \" & 'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy Cost Saved (User %)]) + SUM(Table1[Maintenance costs saved (user %)])); \"#.##0\")","This formula calculates the estimated monthly savings on variable costs, specifically fuel/energy and maintenance. It adds the total savings from the Fuel/Energy Cost Saved (User %) and Maintenance Costs Saved (User %) columns. The result is displayed as a range: a conservative lower estimate (80% of calculated savings) and a full savings estimate."]
[null,"Fixed Cost Savings","General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Monthly depreciation]) * B6 + SUM(Table1[Monthly Lease/Rent ]) * B6 + SUM(Table1[[Monthly Insurance ]]) * B6) * 0,8; \"#.##0\") & \" – \" & 'General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Monthly depreciation]) * B6 + SUM(Table1[Monthly Lease/Rent ]) * B6 + SUM(Table1[[Monthly Insurance ]]) * B6); \"#.##0\")","This formula estimates the monthly savings on fixed costs: depreciation, lease or rent, and insurance. Each per-vehicle monthly cost is multiplied by the number of vehicles that can be reduced, based on the estimated fleet reduction. The result is presented as a range (80% to 100% of calculated savings)."]
[null,"Total Cost Savings","General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Monthly depreciation]) * B6\n  + SUM(Table1[Monthly Lease/Rent ]) * B6\n  + SUM(Table1[[Monthly Insurance ]]) * B6\n) * 0,8; \"#.##0\"\n)\n& \" – \" &\n'General Info'!$E$9 & \" \" &\nTEXT(\n(\n  SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Monthly depreciation]) * B6\n  + SUM(Table1[Monthly Lease/Rent ]) * B6\n  + SUM(Table1[[Monthly Insurance ]]) * B6\n); \"#.##0\"\n)","This formula calculates the total monthly cost savings by summing both variable and fixed savings. It includes:\n    Fuel/Energy and Maintenance savings\n    Depreciation, Lease/Rent, and Insurance savings, based on vehicles reduced\n\nThe total is displayed as a range (80% to 100%) to reflect variability in real-world savings."]
[null,"One-Time Investment","General Info'!$E$9 & \" \" & 'General Info'!$E$16","Displays the estimated one-time investment required to implement the ride sharing project. The value is pulled from the General Info sheet (cell E16) and serves as a fixed input for ROI calculations."]
[null,"Monthly Recurring Costs"," 'General Info'!E9 & \" \" & TEXT('General Info'!E21+('General Info'!E18*'General Info'!E20); \"#.##0\")","Calculates the ongoing monthly costs for running the ride sharing initiative. It includes HR/support costs and the proportional time cost of the manager overseeing the project (based on % input in the General Info sheet)."]
[null,"MonthlyNetSavings ","General Info'!$E$9 & \" \" & TEXT((SUM(Table1[Fuel/Energy Cost Saved (User %)])\n   + SUM(Table1[Maintenance costs saved (user %)]))\n   - B46; \"#.##0\")","Calculates how much the organisation saves each month after deducting recurring costs. It takes total variable cost savings (fuel/energy + maintenance) and subtracts monthly recurring project costs."]
[null,"Net Savings (Year 1)","General Info'!$E$9 & \" \" & TEXT((\n    SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Depreciation saved (user %)])\n  + SUM(Table1[Lease/rent saved (user%)])\n  + SUM(Table1[Insurance saved (User%)])\n) * 12\n - (B46*12)\n -B45; \"#.##0\")","This formula calculates the net financial benefit of the ride sharing initiative during the first year. It works by:\n    1.Summing all monthly cost savings, including:\n        - Fuel/Energy\n        - Maintenance\n        - Depreciation\n        - Lease/Rent\n        - Insurance\n\n    2.Multiplying the total monthly savings by 12 to get the annual savings.\n    3. Subtracting the one-time investment cost (from the General Info sheet).\n    4.Subtracting annualised recurring costs, which include:\n        - Monthly HR/support costs\n        - A portion of the manager’s monthly salary, based on their time spent on the project\n        These are summed in cell B46, and multiplied by 12 to reflect a full year of ongoing costs.\n\nThe result represents the total net savings your organisation can expect in the first year of implementing the ride sharing initiative, after accounting for both upfront and operational costs."]
[null,"Net Savings Year 2 ( Cumulative)","General Info'!$E$9 & \" \" & TEXT((\n    SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Depreciation saved (user %)])\n  + SUM(Table1[Lease/rent saved (user%)])\n  + SUM(Table1[Insurance saved (User%)])\n) * 24\n - (B46*24)\n -B45; \"#.##0\")","Same calculation structure as Year 1, but extended over 24 months instead of 12.\nIt includes:\n    24 months of cost savings\n    24 months of recurring project costs\n    The one-time investment is still only subtracted once"]
[null,"Net Savings Year 3 (Cumulative)","General Info'!$E$9 & \" \" & TEXT((\n    SUM(Table1[Fuel/Energy Cost Saved (User %)])\n  + SUM(Table1[Maintenance costs saved (user %)])\n  + SUM(Table1[Depreciation saved (user %)])\n  + SUM(Table1[Lease/rent saved (user%)])\n  + SUM(Table1[Insurance saved (User%)])\n) * 36\n - (B46*36)\n -B45; \"#.##0\")","Same calculation structure as Year 1, but extended over 36 months instead of 12.\nIt includes:\n    36 months of cost savings\n    36 months of recurring project costs\n    The one-time investment is still only subtracted once"]
[null,"Net Savings - WITHOUT reducing vehicles (Year 1)","General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n    + SUM(Table1[Maintenance costs saved (user %)])) * 12\n    - (B46 * 12)\n    - B45;\n\"#.##0\")","This formula calculates the net savings over the first year assuming that the number of vehicles in your fleet remains unchanged — in other words, it estimates the financial benefit of reduced usage without reducing the fleet size.\n\nIt starts by summing the monthly fuel/energy and maintenance cost savings from the main data table (Table1) and multiplies the total by 12 to reflect the full year. These are the only savings considered here because fixed costs such as depreciation, lease/rent, and insurance are not impacted if the fleet size stays the same.\n\nFrom this annual savings amount, it subtracts the monthly recurring project costs (stored in cell B46, which includes HR/support and management time from the General Info sheet), multiplied by 12 to cover the full year.\n\nIt also subtracts the one-time project investment (stored in B45, equal to 'General Info'!E16).\n\nThe result shows the realistic financial impact of implementing the ride sharing initiative without scaling down the fleet. The output is formatted as a currency using the symbol specified in 'General Info'!E9."]
[null,"Net Savings - WITHOUT reducing vehicles (Year 2)","General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n    + SUM(Table1[Maintenance costs saved (user %)])) * 24\n    - (B46 * 24)\n    - B45;\n\"#.##0\")","This formula calculates the cumulative net financial benefit over two years when the fleet size remains unchanged. It sums the monthly savings on fuel/energy and maintenance costs from the main data table (Table1) and multiplies the result by 24 to represent two years of savings. These are the only savings considered because fixed costs (depreciation, lease, insurance) remain unaffected if the number of vehicles does not change. From this total, the formula subtracts the recurring project costs (cell B46), multiplied by 24 months, and the one-time investment cost (cell B45, from 'General Info'!E16). The resulting figure reflects the total cost savings from improved operational efficiency without reducing the size of the fleet, formatted using the currency symbol defined in 'General Info'!E9."]
[null,"Net Savings - WITHOUT reducing vehicles (Year 3)","General Info'!$E$9 & \" \" & TEXT(\n    (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n    + SUM(Table1[Maintenance costs saved (user %)])) * 36\n    - (B46 * 36)\n    - B45;\n\"#.##0\")","This formula estimates the total net savings over a three-year period, assuming the organisation does not reduce the size of its vehicle fleet. It calculates the total of monthly fuel/energy and maintenance savings from Table1, multiplies by 36 months to represent three years, and then subtracts the monthly recurring project costs (cell B46) over the same period. Additionally, it subtracts the one-time investment cost (cell B45). Fixed cost savings are excluded, as the fleet size remains constant. The final output provides a clear picture of the long-term savings achievable through behavioural and operational changes alone, expressed in the currency pulled from 'General Info'!E9."]
[null,"Payback/ROI (months)","IF(\n    (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n    + SUM(Table1[Maintenance costs saved (user %)])\n    + SUM(Table1[Depreciation saved (user %)])\n    + SUM(Table1[Lease/rent saved (user%)])\n    + SUM(Table1[Insurance saved (User%)])\n    - B46) > 0;\n    ROUNDUP(\n        B45 /\n        (SUM(Table1[Fuel/Energy Cost Saved (User %)])\n        + SUM(Table1[Maintenance costs saved (user %)])\n        + SUM(Table1[Depreciation saved (user %)])\n        + SUM(Table1[Lease/rent saved (user%)])\n        + SUM(Table1[Insurance saved (User%)])\n        - B46);\n    0);\n    \"No payback\"\n)","This formula calculates the number of months required to recover the initial one-time investment based on the monthly net savings generated from the project. It first sums all monthly savings from the main data table (Table1), including fuel/energy savings, maintenance cost savings, depreciation savings (for owned vehicles), lease/rent savings (for rented vehicles), and insurance savings. It then subtracts the monthly recurring project costs (B46, which combines HR/support costs and manager time from the General Info sheet). If the resulting monthly savings are greater than zero, the formula divides the one-time project cost (B45) by these net monthly savings to determine how many months it will take to break even. The result is rounded up to the nearest whole month. If the monthly savings do not exceed the recurring costs, the formula returns \"No payback\", indicating that the investment cannot be recovered under the current assumptions."]

{"sheet":"Change Management Costs","index":6,"n_rows":31,"n_cols":6,"rows_kept":31,"hidden":true,"merged":[[0,2,0,4],[5,0,7,0],[5,1,7,1],[5,2,7,2],[5,3,7,3],[5,5,7,5],[12,0,16,0],[12,1,16,1],[12,2,16,2],[12,3,16,3],[12,4,16,4],[17,0,19,0],[17,1,19,1],[17,2,19,2],[17,3,19,3],[17,4,19,4],[20,0,24,0],[20,1,24,1],[20,2,24,2],[20,3,24,3],[20,4,24,4],[25,0,27,0],[25,1,27,1],[25,2,27,2],[25,3,27,3],[25,4,27,4],[28,0,30,0],[28,1,30,1],[28,2,30,2],[28,3,30,3],[28,4,30,4]]}
[null,null,"Social investment required for kick-off phase"]
[]
[{"$nulls":3},"CHANGE MANAGEMENT COSTS"]
[]
[]
[{"$nulls":3},"Organisation change readiness (at country level)","1-Prone to change/ agile"]
[{"$nulls":4},"2-Medium"]
[{"$nulls":4},"3-Conservative"]
[{"$nulls":3},"Kick-off phase duration assumption:","3-6 months ?"]
[]
[]
[{"$nulls":4},"% FTE (full time equivalent)","Assumed tasks"]
[{"$nulls":3},"Logistics coordinator",15,"Participation in project meetings,"]
[{"$nulls":5},"Provision of inputs/ data,"]
[{"$nulls":5},"Review of current fleet management tactics/ strategy (running a right sizing exercise…),"]
[{"$nulls":5},"Modification of job descriptions of logisticians to embed new responsibilities"]
[{"$nulls":5},"Modifications os manuals, guidances, policies to embed sharing practices"]
[{"$nulls":3},"Logistics officer",30,"Being trained to new taks, ride-sharing related"]
[{"$nulls":5},"Engage with drivers, sensitize team about project modalities"]
[{"$nulls":5},"Engagement with other participating agencies log officer to coordinate"]
[{"$nulls":3},"Finance / HR",null,"Participation in project meetings"]
[{"$nulls":5},"Processing reimbursment requests received/ emitted,"]
[{"$nulls":5},"Tracking payments and reception,"]
[{"$nulls":5},"Doing the maths around what costs to cut to render savngs real…,"]
[{"$nulls":5},"Modification of job descriptions?"]
[{"$nulls":3},"Country director",null,"Availability to be presented the project"]
[{"$nulls":5},"Mobilisation of team in Senior Management Team meetings"]
[{"$nulls":5},"Sensitization sessions/ decisions making towards staff"]
[{"$nulls":3},"Security Focal Points",null,"Availability to be presented the project"]
[{"$nulls":5},"Identify risks and opportunties for safety and security management"]
[{"$nulls":5},"Propose solutions, contribute to making the project happen"]

{"sheet":"Impact Summary","index":7,"n_rows":10,"n_cols":3,"rows_kept":10,"hidden":true,"merged":[[2,2,9,2]]}
[]
["Metric","Result"]
["Fleet reduction %",{"$f":"'ROI & Scenario Analysis'!B4","v":{"v":0.12,"d":"12%"}},{"$f":"\"Based on the ride sharing analysis, the fleet size of \"&'General Info'!E5&\" could be reduced by \"&TEXT(B3,\"0%\")&\" (\"&ROUND(B4,0)&\" vehicles removed).\"\n&\"This means fewer vehicles are needed to meet the same transport demand, helping the organisation to work more efficiently and sustainably.\"&CHAR(10)&CHAR(10)\n&\"This change would lead to a reduction of approximately \"&B5&\" kilometers traveled each month, saving around \"&B6&\" litres of fuel per month and reducing CO2 emissions by \"&B7&\" kg per month. These reductions directly contribute to lower environmental impact and support sustainability goals.\"&CHAR(10)&CHAR(10)\n&\"The estimated total cost savings in the first year would range between \"&B8&\", while net savings after accounting for all costs would be \"&B9&\". The initial investment to start the vehicle sharing scheme could be recovered within \"&B10&\" month(s).\"&CHAR(10)&CHAR(10)\n&\"These calculations are based on a transport demand sharing rate of \"&TEXT('General Info'!E22,\"0%\")&\", meaning nearly a third of trips could be completed using shared vehicles instead of individual ones.\"","v":"Based on the ride sharing analysis, the fleet size of Example Organisation could be reduced by 12% (4 vehicles removed).This means fewer vehicles are needed to meet the same transport demand, helping the organisation to work more efficiently and sustainably.\n\nThis change would lead to a reduction of approximately 5000 kilometers traveled each month, saving around 358 – 448 litres litres of fuel per month and reducing CO2 emissions by 938 – 1173 kg kg per month. These reductions directly contribute to lower environmental impact and support sustainability goals.\n\nThe estimated total cost savings in the first year would range between $ 9.290 – $ 11.613, while net savings after accounting for all costs would be $ 13.691. The initial investment to start the vehicle sharing scheme could be recovered within 1 month(s).\n\nThese calculations are based on a transport demand sharing rate of 20%, meaning nearly a third of trips could be completed using shared vehicles instead of individual ones."}]
["Vehicles reduced",{"$f":"'ROI & Scenario Analysis'!B6","v":{"v":4.32,"d":"4"}}]
["Monthly km reduced",{"$f":"'ROI & Scenario Analysis'!B7","v":5000}]
["Fuel savings (litres)",{"$f":"'ROI & Scenario Analysis'!B8","v":"358 – 448 litres"}]
["CO2 saved (kg)",{"$f":"'ROI & Scenario Analysis'!B10","v":"938 – 1173 kg"}]
["Total cost savings (€)",{"$f":"'ROI & Scenario Analysis'!B13","v":"$ 9.290 – $ 11.613"}]
["Net savings (€)",{"$f":"'ROI & Scenario Analysis'!B17","v":"$ 13.691"}]
["Payback period (months)",{"$f":"'ROI & Scenario Analysis'!B23","v":1}]