{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Calculator","Ineligible Vehicles for EVM","Data","Results","PHEV_Calcs","Passenger EV Fuel Efficiency"],"not_rendered":{"charts":5,"images":103,"macros":1,"external_links":0,"defined_names":31,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Electric Vehicle Savings Calculator"]
[]
[]
["Welcome to the Electric Vehicle Savings Calculator"]
[]
["This calculator provides a resource to estimate the cost saving and greenhouse gas (GHG) emission reduction potential of purchasing an electric vehicle (EV) "]
["in place of a traditional internal combustion engine (ICE) vehicle within the Province of Alberta. The calculator's financial analysis includes estimated values for "]
["incentives available through the",null,null,"Electric Vehicles for Municipalities (EVM) program.",null,null,null,null,null,null,"Other rebates may be entered into the \"Additional Rebates\" field such as "]
["the Government of Canada's Zero-emission Vehicle Incentive Program."]
[]
["Instructions for Use"]
[]
["In the \"Calculator\" tab, please enter information about your vehicle usage into all green entry fields at the top and then select your vehicle preferences."]
["The vehicle stats will populate automatically. Once complete, click the \"Click Here to Compute the Savings\" button (top right-hand corner) to compute a cost and "]
["GHG comparision of the vehicles. Review your results below. "]
[]
["If your desired ICE vehicle is not found in the list, use the \"Other Vehicle\" option at the bottom of the list and enter the vehicle information in the green entry fields below."]
["Click the \"Reset\" button to start over."]
[]
["Important Notes and Assumptions"]
[]
["This calculator is designed with Alberta's electrical infrastructure in mind with a grid factor of 0.57 tCO2e/MWh. This factor applies to emissions associated with"]
["charging an EV. All vehicles listed in the calculator (both EV and ICE) are 2022 models unless otherwise stated. New vehicle models will be added periodically as they"]
["become available for purchase. It should be noted that all costs and GHG emissions presented in the calculator are best guess, high-level, conservative estimates based"]
["on limited usage information. Results may vary depending on user operation of the vehicle, distance travelled, frequency of use, the rebates available at the time of "]
["purchase,and changes to electricity and gas prices over time. The fuel costs and GHG emissions for Plug-in Hybrid Electric Vehicles (PHEVs) are calculated based on "]
["utility factors and vehicle data from Natural Resoures Canada (NRCan). These values are highly conservative and may vary significantly depending on user behaviour,"]
["frequency of use, and distance travelled.  All ICE Vehicles in this calculator are gasoline-powered."]
["For more information about electric vehicles, see",null,null,null,null,null,"the Electric Vehicle Knowledge Guide."]
[]
["Sources of Information"]
[]
["Data regarding vehicle efficiency (both kWh/100km and L/100km), EV range, annual fuel costs, and other vehicle specification data was compiled from"]
["NRCan's 2022 Fuel Consumption Guide. "]
["Maintenance cost data (as well as the vehicle pictures) were gathered using the ",null,null,null,null,null,null,null,null,"Edmunds.com Cost of Ownership Calculator",null,null,null,null,"and averaged on a per year basis."]
["Where vehicle data was not available, maintenance costs were estimated using $0.031/mile for Battery Electric Vehicles (BEVs), $0.030/mile for Plug-in Hybrid Electric"]
["Vehicles (PHEVs), $0.061/mile for all ICE vehicles."]
["(Source: Evs Ownership Costs - 2020 Consumer Report)"]
[]
["Disclaimer"]
[]
["This savings calculator is purely a guide and not a guarantee of actual savings. Savings will vary with the use of each vehicle. The Municipal Climate Change Action and Alberta "]
["Municipalities have no claims towards the accuracy of the results of this tool. Actual GHG emission and fuel cost savings will vary depending on factors "]
["such as road and weather conditions, driving behaviours, use of regenerative braking, charging multiple times per day, vehicle maintenance, and lithium-ion battery age."]
[]
["About the Municipal Climate Change Action Centre"]
[]
["Since 2009, the Municipal Climate Change Action Centre has been empowering Alberta’s municipalities to be leaders in climate change action through energy efficiency "]
["and renewable energy projects. The Municipal Climate Change Action Centre provides funding, technical assistance, and education to help Alberta municipalities reduce"]
["GHG emissions through energy efficiency and renewable energy solutions. All Alberta municipalities are inspired to take action to reduce greenhouse gas emissions "]
["and build climate resilient communities. ",null,null,null,null,"Visit our website for more information."]

{"sheet":"Calculator","index":1,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
["STEP 1. \nEnter Usage Data:"]
["Annual Distance Driven (km):",20000,"km per year"]
["Approx. # of Km Driven in Gas-Mode (for PHEVs only):",8400,"km per year"]
["Price of Fuel:",1.5,"per Litre"]
["Electricity Rate:",0.15,"per kWh"]
["Lifetime Use of New Vehicle:",10,"years"]
["Additional Rebate Value:",0]
[]
[null,"Electric Vehicle",null,null,"Internal Combustion Engine Vehicle"]
[]
["STEP 2. \nChoose Your Electric Vehicle:","<SELECT THIS CELL AND THEN \nCHOOSE VEHICLE FROM DROPDOWN LIST>",null,"STEP 3. \nChoose Your ICE Vehicle:","<SELECT THIS CELL AND THEN \nCHOOSE VEHICLE FROM DROPDOWN LIST>"]
[]
["Type of Vehicle:",{"$f":"VLOOKUP(B12, Data!$A$2:$I$37,2,FALSE)","v":{"$error":"#N/A"}},null,"Type of Vehicle:",{"$f":"VLOOKUP(E12, Data!$P$2:$T$72,2,FALSE)","v":{"$error":"#N/A"}}]
["Purchase Price:",{"$f":"VLOOKUP(B12, Data!$A$2:$I$37,3,FALSE)","v":{"$error":"#N/A"}},null,"Purchase Price:",{"$f":"VLOOKUP(E12, Data!$P$2:$T$72,3,FALSE)","v":{"$error":"#N/A"}}]
["Electricity Consumption:",{"$f":"VLOOKUP(B12, Data!$A$2:$I$37,4,FALSE)","v":{"$error":"#N/A"}},"kWh per 100 km","Gas Consumption:",{"$f":"VLOOKUP(E12, Data!$P$2:$T$72,4,FALSE)","v":{"$error":"#N/A"}},"L per 100 km (combined City and Hwy)"]
["Gas Consumption:",{"$f":"VLOOKUP(B12, Data!$A$2:$I$37,7,FALSE)","v":{"$error":"#N/A"}},"L per 100 km (PHEVs only)"]
["EVM Rebate:",{"$f":"VLOOKUP(B12, Data!$A$2:$I$37,8,FALSE)","v":{"$error":"#N/A"}},null,"Other Vehicle:"," "]
["Electric Range:",{"$f":"VLOOKUP(B12, Data!$A$2:$I$37,9,FALSE)","v":{"$error":"#N/A"}},"km","Purchase Price:"," "]
["Battery Capacity",{"$f":"VLOOKUP(B12, Data!$A$2:$I$37,5,FALSE)","v":{"$error":"#N/A"}},"kWh","Litres Consumed per 100 km:"," ","L per 100 km (combined City and Hwy)"]
[]
["Review Your Results:","Fuel Costs/year ($CAD)","Maintenace Costs/year ($CAD)","GHG Emissions (tCO2e/year)","Purchase Price After Rebates ($CAD)"]
["Electric \nVehicle",0,0,0,0,null,null,null,null,null,"<CHOOSE FROM LIST>"]
["Internal Combustion Engine Vehicle",0,0,0,0,null,null,null,null,null,"<CHOOSE FROM LIST>"]
[null,null,null,null,0,"<--Difference in Purchase Prices",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Savings/Year:","Fuel Costs/year ($CAD)","Maintenace Costs/year ($CAD)","GHG Emissions (tCO2e/year)"]
[null,0,0,0]
[]
["Lifetime Savings:","Fuel Costs ($CAD)","Maintenace Costs ($CAD)","GHG Emissions (tCO2e)"]
[null,0,0,0,"(Click here to discover what this GHG value means in everyday terms)"]
[]
["Total Lifetime Fuel and Maintenance Savings:",0]
["Total Lifetime Savings (including Purchase Prices):",0]

{"sheet":"Ineligible Vehicles for EVM","index":2,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["The following vehicle makes are ineligible for EVM program rebates and do not appear in the calculator list:"]
[]
["Acura"]
["Alfa Romeo"]
["Aston Martin"]
["Audi"]
["Bentley"]
["BMW"]
["Bugatti"]
["Buick"]
["Cadillac"]
["Fiat"]
["Genesis"]
["Infiniti"]
["Jaguar"]
["Lamborghini"]
["Land Rover"]
["Lexus"]
["Lincoln"]
["Maserati"]
["Mercedes-Benz"]
["Porsche"]
["Rolls-Royce"]
["Tesla"]
["Volvo"]

{"sheet":"Data","index":3,"n_rows":72,"n_cols":23,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
["Electric Vehicles","Type","Purchase Price","kWh/100km","Battery Capacity (kWh)","CO2 (g/km)","L/100km","EVM Rebate","Electric Range (km)"," Annual Maintenance Costs ","PHEV Annual GHGs (tCO2e) ","PHEV Annual Fuel Costs ","Pictures",null,null,"ICE Vehicles","Type","Purchase Price","L/100km","CO2 (g/km)"," Annual Maintenance Costs","Pictures"]
["<CHOOSE FROM LIST>","--","--","--","--","--","--","--","--",null,null,null,null,{"$f":"A2","v":"<CHOOSE FROM LIST>"},null,"<CHOOSE FROM LIST>","--","--","--","--",null,null,"<CHOOSE FROM LIST>"]
["CHEVROLET VOLT (2019)","PHEV",41381,19.899999999999999,18.399999999999999,32,5.6,{"$f":"IF(E3<15,7000,14000)","v":14000},85,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M12","v":2.2850766399999998},{"$f":"PHEV_Calcs!N12","v":655},null,"CHEVROLET VOLT (2019)",null,"CHEVROLET COLORADO","Pickup Truck",27948,10.9,257,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P3","v":"CHEVROLET COLORADO"}]
["CHRYSLER PACIFICA HYBRID","PHEV",50234,25.8,16,74,8,{"$f":"IF(E4<15,7000,14000)","v":14000},51,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M13","v":3.0865958399999998},{"$f":"PHEV_Calcs!N13","v":1094},null,"CHRYSLER PACIFICA HYBRID",null,"CHEVROLET CRUZE (2019)","Compact Sedan",21000,7.3,172,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P4","v":"CHEVROLET CRUZE (2019)"}]
["FORD ESCAPE PLUG-IN","PHEV",41199,20.2,14.4,48,5.8,7000,60,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M14","v":2.3636788399999999},{"$f":"PHEV_Calcs!N14","v":795},null,"FORD ESCAPE PLUG-IN",null,"CHEVROLET EQUINOX","Sport Utility Vehicle",27198,8.4,198,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"CHEVROLET EQUINOX"]
["FORD FUSION PHEV (2020)","PHEV",50692,20.5,9,61,5.6,7000,42,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M15","v":2.4137428999999999},{"$f":"PHEV_Calcs!N15","v":957},null,"FORD FUSION PHEV (2020)",null,"CHEVROLET IMPALA (2020)","Full Size Sedan",35914,10.9,255,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"CHEVROLET IMPALA (2020)"]
["HONDA CLARITY PLUG-IN (2021)","PHEV",44505,19,17,36,5.6,14000,77,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M16","v":2.231026},{"$f":"PHEV_Calcs!N16","v":746},null,"HONDA CLARITY PLUG-IN (2021)",null,"CHEVROLET MALIBU","Mid-Size Sedan",25248,7.5,175,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"CHEVROLET MALIBU"]
["HYUNDAI IONIQ PLUG-IN","PHEV",44999,17.399999999999999,8.9,46,4.5,7000,47,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M17","v":2.0005084799999997},{"$f":"PHEV_Calcs!N17","v":684},null,"HYUNDAI IONIQ PLUG-IN",null,"CHEVROLET SILVERADO","Pickup Truck",30998,13.8,325,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"CHEVROLET SILVERADO"]
["HYUNDAI SONATA PLUG-IN (2019)","PHEV",43600,20.9,9.8000000000000007,62,6,7000,45,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M18","v":2.4498526799999998},{"$f":"PHEV_Calcs!N18","v":836},null,"HYUNDAI SONATA PLUG-IN (2019)",null,"CHEVROLET SPARK ","Sub-Compact Sedan",9998,7,165,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"CHEVROLET SPARK "]
["HYUNDAI SANTA FE PLUG-IN","PHEV",36353.699999999997,27.5,13.8,69,7.2,{"$f":"IF(E10<15,7000,14000)","v":7000},50,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M19","v":3.1689486000000002},{"$f":"PHEV_Calcs!N19","v":1081},null,"HYUNDAI SANTA FE PLUG-IN",null,"CHEVROLET SUBURBAN","Sport Utility Vehicle",59398,13.2,309,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P10","v":"CHEVROLET SUBURBAN"}]
["HYUNDAI TUCSON PLUG-IN","PHEV",41051,25.9,13.8,62,6.7,7000,53,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M20","v":2.9753744000000002},{"$f":"PHEV_Calcs!N20","v":994},null,"HYUNDAI TUCSON PLUG-IN",null,"CHEVROLET TAHOE","Sport Utility Vehicle",56398,13.2,309,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"CHEVROLET TAHOE"]
["GRAND CHEROKEE 4XE","PHEV",75195,36,17,110,10,14000,42,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M21","v":4.2166416},{"$f":"PHEV_Calcs!N21","v":1516},null,"GRAND CHEROKEE 4XE"]
["WRANGLER 4XE","PHEV",55114,42.2,17,143,11.7,14000,35,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M22","v":4.9502870400000001},{"$f":"PHEV_Calcs!N22","v":1814},null,"WRANGLER 4XE"]
["KIA NIRO PLUG-IN","PHEV",34595,19.7,8.9,56,5.0999999999999996,7000,42,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M23","v":2.2662909},{"$f":"PHEV_Calcs!N23","v":783},null,"KIA NIRO PLUG-IN",null,"CHRYSLER PACIFICA","Minivan",34560,10.6,249,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"CHRYSLER PACIFICA"]
["KIA OPTIMA PLUG-IN (2020)","PHEV",43995,20.7,9.8000000000000007,60,5.7,7000,45,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M24","v":2.4383026799999996},{"$f":"PHEV_Calcs!N24","v":947},null,"KIA OPTIMA PLUG-IN (2020)",null,"CHRYSLER GRAND CARAVAN","Minivan",36339,10.6,249,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"CHRYSLER GRAND CARAVAN"]
["KIA SORENTO PLUG-IN","PHEV",46405,26.4,14,65,6.9,7000,51,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M25","v":3.0387974399999997},{"$f":"PHEV_Calcs!N25","v":1019},null,"KIA SORENTO PLUG-IN",null,"FORD ESCAPE","Sport Utility Vehicle",27799,9.1,213,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"FORD ESCAPE"]
["MINI COOPER SE COUNTRYMAN ALL4","PHEV",44590,28.4,8,109,8,7000,29,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M26","v":3.3847864799999998},{"$f":"PHEV_Calcs!N26","v":1367},null,"MINI COOPER SE COUNTRYMAN ALL4",null,"FORD F-150","Pickup Truck",33429,11.7,274,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"FORD F-150"]
["MITSUBISHI OUTLANDER (PHEV)","PHEV",44198,28.2,13.8,103,9.1,7000,39,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M27","v":3.4575999999999998},{"$f":"PHEV_Calcs!N27","v":1318},null,"MITSUBISHI OUTLANDER (PHEV)",null,"FORD FIESTA (2019)","Sub-Compact Sedan",15800,7.6,178,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"FORD FIESTA (2019)"]
["SUBARU CROSSTREK HYBRID","PHEV",42595,23.5,8.8000000000000007,94,6.7,7000,27,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M28","v":2.7932505000000001},{"$f":"PHEV_Calcs!N28","v":1075},null,"SUBARU CROSSTREK HYBRID",null,"FORD FLEX (2020)","Sport Utility Vehicle",29649,12.7,298,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"FORD FLEX (2020)"]
["TOYOTA PRIUS PRIME","PHEV",33550,15.8,8.8000000000000007,49,4.3,7000,40,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M29","v":1.8414927200000002},{"$f":"PHEV_Calcs!N29","v":660},null,"TOYOTA PRIUS PRIME",null,"FORD FUSION (2020)","Mid-Size Sedan",28789,8.6999999999999993,203,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"FORD FUSION (2020)"]
["TOYOTA RAV4 PRIME","PHEV",44990,22.3,18.100000000000001,44,6,{"$f":"IF(E21<15,7000,14000)","v":14000},68,{"$f":"0.03*Calculator!$B$3*1.27","v":762},{"$f":"PHEV_Calcs!M30","v":2.5737809999999994},{"$f":"PHEV_Calcs!N30","v":833},null,"TOYOTA RAV4 PRIME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORD FUSION HYBRID (2020)","Mid-Size Sedan",29400,5.6,131,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P22","v":"FORD FUSION HYBRID (2020)"}]
["CHEVROLET BOLT EV","BEV",38198,17.5,66,0,0,{"$f":"IF(E23<15,7000,14000)","v":14000},417,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,{"$f":"A23","v":"CHEVROLET BOLT EV"},null,"FORD TRANSIT CONNECT","Special Purpose Van",30835,9.3000000000000007,217,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"FORD TRANSIT CONNECT"]
["CHEVROLET BOLT EUV","BEV",40198,18.3,65,0,0,{"$f":"IF(E24<15,7000,14000)","v":14000},397,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"CHEVROLET BOLT EUV",null,"GMC CANYON","Pickup Truck",28648,10.8,271,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"GMC CANYON"]
["F-150 LIGHTING STANDARD RANGE","BEV",68000,30.6,98,0,0,{"$f":"IF(E25<15,7000,14000)","v":14000},370,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"F-150 LIGHTING STANDARD RANGE",null,"GMC SIERRA","Pickup Truck",32498,13.8,325,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P25","v":"GMC SIERRA"}]
["HONDA CLARITY (2019)","BEV",42771,18.5,25.5,0,0,{"$f":"IF(E26<15,7000,14000)","v":14000},143,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"HONDA CLARITY (2019)",null,"GMC YUKON","Sport Utility Vehicle",58548,13.2,309,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"GMC YUKON"]
["HYUNDAI IONIQ ELECTRIC","BEV",41599,15.8,38.299999999999997,0,0,14000,354,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"HYUNDAI IONIQ ELECTRIC",null,"HONDA ACCORD","Full Size Sedan",34685,7.2,168,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HONDA ACCORD"]
["HYUNDAI KONA ELECTRIC","BEV",46445,17.399999999999999,64,0,0,14000,415,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"HYUNDAI KONA ELECTRIC",null,"HONDA ACCORD (HYBRID)","Full Size Sedan",37920,5,117,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HONDA ACCORD (HYBRID)"]
["KIA EV6 STANDARD RANGE","BEV",44995,18,58,0,0,14000,373,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"KIA EV6 STANDARD RANGE",null,"HONDA CR-V","Sport Utility Vehicle",32255,7.7,180,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HONDA CR-V"]
["KIA NIRO EV (2020)","BEV",44995,18.600000000000001,64,0,0,14000,385,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"KIA NIRO EV (2020)",null,"HONDA CIVIC SEDAN","Mid-Size Sedan",25215,7.1,165,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HONDA CIVIC SEDAN"]
["KIA SOUL EV","BEV",42995,18.600000000000001,39.200000000000003,0,0,14000,248,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"KIA SOUL EV",null,"HONDA FIT (2020)","Small Station Wagon",18075,6.5,151,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HONDA FIT (2020)"]
["MAZDA MX-30","BEV",42150,22.8,35.5,0,0,14000,161,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"MAZDA MX-30",null,"HONDA HR-V","Crossover Sedan",27185,7.8,181,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HONDA HR-V"]
["NISSAN LEAF","BEV",44298,18.899999999999999,40,0,0,14000,240,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"NISSAN LEAF",null,"HONDA ODYSSEY","Minivan",45090,10.6,248,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HONDA ODYSSEY"]
["NISSAN LEAF S PLUS","BEV",40098,19.5,62,0,0,14000,363,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"NISSAN LEAF S PLUS",null,"HONDA RIDGELINE","Pickup Truck",46640,11.5,271,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HONDA RIDGELINE"]
["NISSAN LEAF SV/SL PLUS","BEV",46098,20,62,0,0,14000,349,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"NISSAN LEAF SV/SL PLUS",null,"HYUNDAI ACCENT (2020)","Compact Sedan",14949,6.7,160,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HYUNDAI ACCENT (2020)"]
["VOLKSWAGEN e-GOLF (2020)","BEV",37900,18.600000000000001,35.799999999999997,0,0,14000,198,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"VOLKSWAGEN e-GOLF (2020)",null,"HYUNDAI ELANTRA","Mid-Size Sedan",17889,7.6,179,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HYUNDAI ELANTRA"]
["VOLKSWAGEN ID.4","BEV",44995,22,82,0,0,{"$f":"IF(E37<15,7000,14000)","v":14000},394,{"$f":"0.031*Calculator!$B$3*1.27","v":787.4},null,null,null,"VOLKSWAGEN ID.4",null,"HYUNDAI IONIQ","Full Size Sedan",25649,4.2,99,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HYUNDAI IONIQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HYUNDAI SONATA","Full Size Sedan",27149,7.7,182,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HYUNDAI SONATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HYUNDAI SONATA HYBRID","Mid-Size Sedan",40199,5,117,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HYUNDAI SONATA HYBRID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HYUNDAI VELOSTER N","Compact Sedan",37799,10.5,248,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HYUNDAI VELOSTER N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HYUNDAI VENUE",null,25549,7.5,176,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"HYUNDAI VENUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JEEP CHEROKEE","Sport Utility Vehicle",31117,9.1,214,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"JEEP CHEROKEE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIA FORTE","Mid-Size Sedan",17895,7.8,184,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"KIA FORTE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIA NIRO","Small Station Wagon",26845,4.5999999999999996,110,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"KIA NIRO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIA K5 (OPTIMA)","Full Size Sedan",29595,8.6999999999999993,207,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"KIA K5 (OPTIMA)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIA RIO","Compact Sedan",17295,6.7,159,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"KIA RIO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIA SEDONA (2021)","Minivan",32295,11.5,272,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"KIA SEDONA (2021)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIA SORENTO","Sport Utility Vehicle",33995,9.9,233,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"KIA SORENTO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIA SOUL","Small Station Wagon",21195,7.9,187,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"KIA SOUL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAZDA CX-3","Compact Sedan",21450,7.7,179,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"MAZDA CX-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAZDA CX-5","Sport Utility Vehicle",28600,8.8000000000000007,206,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"MAZDA CX-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAZDA3","Compact Sedan",20600,7.6,178,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"MAZDA3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITSUBISHI MIRAGE","Compact Sedan",13858,6.2,143,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"MITSUBISHI MIRAGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITSUBISHI OUTLANDER (2020)","Sport Utility Vehicle",29998,10.6,246,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"MITSUBISHI OUTLANDER (2020)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITSUBISHI RVR","Sport Utility Vehicle",23198,8.8000000000000007,206,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P55","v":"MITSUBISHI RVR"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NISSAN ALTIMA","Mid-Size Sedan",29498,7.9,187,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P56","v":"NISSAN ALTIMA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NISSAN MAXIMA","Mid-Size Sedan",41440,9.9,233,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"NISSAN MAXIMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NISSAN PATHFINDER (2020)","Sport Utility Vehicle",36698,10.199999999999999,240,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"NISSAN PATHFINDER (2020)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NISSAN ROGUE","Sport Utility Vehicle",28798,8.1,189,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"NISSAN ROGUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NISSAN SENTRA","Mid-Size Sedan",19198,7.1,167,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"NISSAN SENTRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOYOTA 4RUNNER","Sport Utility Vehicle",46200,13.8,321,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"TOYOTA 4RUNNER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOYOTA CAMRY","Mid-Size Sedan",27250,9,210,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"TOYOTA CAMRY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOYOTA COROLLA","Mid-Size Sedan",19350,7.1,165,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"TOYOTA COROLLA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOYOTA HIGHLANDER","Sport Utility Vehicle",40450,10.3,240,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"TOYOTA HIGHLANDER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOYOTA PRIUS","Mid-Size Sedan",28850,4.5,106,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"TOYOTA PRIUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOYOTA RAV4","Sport Utility Vehicle",28590,7.9,184,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"TOYOTA RAV4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOYOTA SIENNA ","Minivan",39990,6.5,153,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"TOYOTA SIENNA "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOYOTA TUNDRA ","Pickup Truck",47010,15.9,371,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,"TOYOTA TUNDRA "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VOLKSWAGEN GOLF","Compact Sedan",22995,7.5,174,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P69","v":"VOLKSWAGEN GOLF"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VOLKSWAGEN JETTA","Compact Sedan",21595,7.1,165,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P70","v":"VOLKSWAGEN JETTA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VOLKSWAGEN PASSAT","Mid-Size Sedan",27145,8.3000000000000007,195,{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P71","v":"VOLKSWAGEN PASSAT"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--OTHER VEHICLE (fill out info below)--","-","-","-","-",{"$f":"0.061*1.27*Calculator!$B$3","v":1549.3999999999999},null,{"$f":"P72","v":"--OTHER VEHICLE (fill out info below)--"}]

{"sheet":"Results","index":4,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Chart Preparation - Cost Analysis"]
[null,"Results:",null,null,null,"Results:",null,null,null,null,null,"Year"]
[null,"GHG Emissions:",{"$f":"IFERROR(IF(Calculator!B14 = \"PHEV\",VLOOKUP(Calculator!B12, Data!$A$2:$L$100,11,FALSE),(Calculator!B3*(Calculator!B16/100) * 0.00057)),0)","v":0},"tCO2e per year",null,"GHG Emissions:",{"$f":"IFERROR(IF(Calculator!$E$12 = \"--OTHER VEHICLE (fill out info below)--\",Calculator!B3 * (Calculator!E20/100) * 0.0023,Calculator!B3 * (Calculator!E16/100) * 0.0023),0)","v":0},"tCO2e per year",null,null,"From:",1,{"$f":"INDEX($A$28:$A$57,MATCH($L$3,$A$28:$A$57,0)):INDEX($A$28:$A$57,MATCH(Calculator!$B$7,$A$28:$A$57,0))","v":{"$error":"#VALUE!"}}]
[null,"Cost to refuel:",{"$f":"IFERROR(IF(Calculator!B14=\"PHEV\",VLOOKUP(Calculator!B12, Data!$A$2:$L$100,12,FALSE),(Calculator!B6*(Calculator!B16/100) *Calculator!B3)),0)","v":0},"per year",null,"Cost to refuel:",{"$f":"IFERROR(IF(Calculator!$E$12 = \"--OTHER VEHICLE (fill out info below)--\", Calculator!B5 * (Calculator!E20/100) * Calculator!B3,Calculator!B5 * (Calculator!E16/100) * Calculator!B3),0)","v":0},"per year",null,null,"To:",null,{"$f":"INDEX($B$28:$B$57,MATCH($L$3,$A$28:$A$57,0)):INDEX($B$28:$B$57,MATCH(Calculator!$B$7,$A$28:$A$57,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX($C$28:$C$57,MATCH($L$3,$A$28:$A$57,0)):INDEX($C$28:$C$57,MATCH(Calculator!$B$7,$A$28:$A$57,0))","v":{"$error":"#VALUE!"}}]
[null,"Maintenance Costs: ",{"$f":"IFERROR(VLOOKUP(Calculator!B12, Data!$A$2:$L$100,10,FALSE),0)","v":0},"per year",null,"Maintenance Costs: ",{"$f":"IFERROR(VLOOKUP(Calculator!E12, Data!$P$2:$U$100,6,FALSE),0)","v":0},"per year",null,null,null,null,{"$f":"INDEX($D$28:$D$57,MATCH($L$3,$A$28:$A$57,0)):INDEX($D$28:$D$57,MATCH(Calculator!$B$7,$A$28:$A$57,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX($E$28:$E$57,MATCH($L$3,$A$28:$A$57,0)):INDEX($E$28:$E$57,MATCH(Calculator!$B$7,$A$28:$A$57,0))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Purchase Price:",{"$f":"IFERROR(IF(Calculator!$E$12 = \"--OTHER VEHICLE (fill out info below)--\",Calculator!E19,Calculator!E15),0)","v":0}]
[null,null,null,"Overall Fuel Cost Savings:",{"$f":"G4-C4","v":0},"per year"]
[null,null,null,null,null,null,null,null,null,null,"EV:",{"$f":"Calculator!$B$12","v":"<SELECT THIS CELL AND THEN \nCHOOSE VEHICLE FROM DROPDOWN LIST>"}]
[null,null,null,"GHG Savings:",{"$f":" G3 - C3","v":0},"tCO2e per year",null,null,null,null,"ICEV:",{"$f":"IF(Calculator!E12 = \"--OTHER VEHICLE (fill out info below)--\", Calculator!E18,Calculator!E12)","v":"<SELECT THIS CELL AND THEN \nCHOOSE VEHICLE FROM DROPDOWN LIST>"}]
[]
[null,null,null,"Maintenance Savings:",{"$f":"IFERROR(G5 - C5,0)","v":0},"per year"]
[]
[null,null,null,"Purchase Price for EV:",{"$f":"IFERROR(Calculator!B15,0)","v":0}]
[null,null,null,"Purchase Price After All Rebates:",{"$f":"IFERROR(IF(Calculator!K26 = TRUE, E13 - Calculator!B8,E13 - Calculator!B18 - Calculator!B8),0)","v":0}]
[null,null,null,"Capital Cost Difference Between EV and ICEV:",{"$f":"IFERROR(G6 - E14,0)","v":0}]
[]
[null,null,null,"Total Lifetime Fuel Cost Savings:",{"$f":"E7 * Calculator!$B$7","v":0}]
[null,null,null,"Total Lifetime GHG Savings:",{"$f":"E9*Calculator!$B$7","v":0},"tCO2e"]
[null,null,null,"Total Lifetime Maintenance Savings:",{"$f":"E11*Calculator!$B$7","v":0}]
[]
[null,null,null,"Total Lifetime Fuel and Maintenance Cost Savings:",{"$f":"SUM(E17:E19)","v":0}]
[null,null,null,"Total Lifetime Cost Savings (inculding Capital Cost Difference):",{"$f":"SUM(E17:E19) + E15","v":0}]
[]
[]
[null,"Lifetime Use of New Vehicle:",{"$f":"Calculator!$B$7","v":10}]
[]
["Year","EV Lifetime Costs","ICE Vehicle Lifetime Costs","EV GHG Lifetime Emissions","ICE GHG Lifetime Emissions"]
[1,{"$f":"Calculator!$E$23 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"Calculator!$E$24 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"Calculator!$D$23","v":0},{"$f":"Calculator!$D$24","v":0}]
[2,{"$f":"B28 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C28 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D28+ Calculator!$D$23","v":0},{"$f":"E28 + Calculator!$D$24","v":0}]
[3,{"$f":"B29 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C29 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D29+ Calculator!$D$23","v":0},{"$f":"E29 + Calculator!$D$24","v":0}]
[4,{"$f":"B30 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C30 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D30+ Calculator!$D$23","v":0},{"$f":"E30 + Calculator!$D$24","v":0}]
[5,{"$f":"B31 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C31 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D31+ Calculator!$D$23","v":0},{"$f":"E31 + Calculator!$D$24","v":0}]
[6,{"$f":"B32 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C32 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D32+ Calculator!$D$23","v":0},{"$f":"E32 + Calculator!$D$24","v":0}]
[7,{"$f":"B33 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C33 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D33+ Calculator!$D$23","v":0},{"$f":"E33 + Calculator!$D$24","v":0}]
[8,{"$f":"B34 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C34 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D34+ Calculator!$D$23","v":0},{"$f":"E34 + Calculator!$D$24","v":0}]
[9,{"$f":"B35 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C35 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D35+ Calculator!$D$23","v":0},{"$f":"E35 + Calculator!$D$24","v":0}]
[10,{"$f":"B36 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C36 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D36+ Calculator!$D$23","v":0},{"$f":"E36 + Calculator!$D$24","v":0}]
[11,{"$f":"B37 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C37 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D37+ Calculator!$D$23","v":0},{"$f":"E37 + Calculator!$D$24","v":0}]
[12,{"$f":"B38 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C38 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D38+ Calculator!$D$23","v":0},{"$f":"E38 + Calculator!$D$24","v":0}]
[13,{"$f":"B39 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C39 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D39+ Calculator!$D$23","v":0},{"$f":"E39 + Calculator!$D$24","v":0}]
[14,{"$f":"B40 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C40 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D40+ Calculator!$D$23","v":0},{"$f":"E40 + Calculator!$D$24","v":0}]
[15,{"$f":"B41 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C41 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D41+ Calculator!$D$23","v":0},{"$f":"E41 + Calculator!$D$24","v":0}]
[16,{"$f":"B42 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C42 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D42+ Calculator!$D$23","v":0},{"$f":"E42 + Calculator!$D$24","v":0}]
[17,{"$f":"B43 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C43 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D43+ Calculator!$D$23","v":0},{"$f":"E43 + Calculator!$D$24","v":0}]
[18,{"$f":"B44 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C44 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D44+ Calculator!$D$23","v":0},{"$f":"E44 + Calculator!$D$24","v":0}]
[19,{"$f":"B45 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C45 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D45+ Calculator!$D$23","v":0},{"$f":"E45 + Calculator!$D$24","v":0}]
[20,{"$f":"B46 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C46 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D46+ Calculator!$D$23","v":0},{"$f":"E46 + Calculator!$D$24","v":0}]
[21,{"$f":"B47 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C47 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D47+ Calculator!$D$23","v":0},{"$f":"E47 + Calculator!$D$24","v":0}]
[22,{"$f":"B48 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C48 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D48+ Calculator!$D$23","v":0},{"$f":"E48 + Calculator!$D$24","v":0}]
[23,{"$f":"B49 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C49 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D49+ Calculator!$D$23","v":0},{"$f":"E49 + Calculator!$D$24","v":0}]
[24,{"$f":"B50 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C50 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D50+ Calculator!$D$23","v":0},{"$f":"E50 + Calculator!$D$24","v":0}]
[25,{"$f":"B51 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C51 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D51+ Calculator!$D$23","v":0},{"$f":"E51 + Calculator!$D$24","v":0}]
[26,{"$f":"B52 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C52 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D52+ Calculator!$D$23","v":0},{"$f":"E52 + Calculator!$D$24","v":0}]
[27,{"$f":"B53 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C53 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D53+ Calculator!$D$23","v":0},{"$f":"E53 + Calculator!$D$24","v":0}]
[28,{"$f":"B54 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C54 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D54+ Calculator!$D$23","v":0},{"$f":"E54 + Calculator!$D$24","v":0}]
[29,{"$f":"B55 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C55 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D55+ Calculator!$D$23","v":0},{"$f":"E55 + Calculator!$D$24","v":0}]
[30,{"$f":"B56 + Calculator!$B$23 + Calculator!$C$23","v":0},{"$f":"C56 + Calculator!$B$24 + Calculator!$C$24","v":0},{"$f":"D56+ Calculator!$D$23","v":0},{"$f":"E56 + Calculator!$D$24","v":0}]

{"sheet":"PHEV_Calcs","index":5,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[[9,1,9,3],[9,4,9,5]]}
[]
["Solve equation: $749 = Electric fuel cost x X + (Gasoline fuel cost x (1-X))"]
["X = (Annual fuel cost - Gasoline fuel cost) ÷ (Electric fuel cost - Gasoline fuel cost)"]
[]
["Kilometres per year",{"$f":"Calculator!B3","v":20000}]
["Electricity ($/kWh)",{"$f":"Calculator!B6","v":0.15}]
["Regular gasoline ($/L)",{"$f":"Calculator!B5","v":1.5}]
["Premium gasoline ($/L)",1.1000000000000001]
[]
[null,"Electric mode",null,null,"Gasoline-only",null,"Composite annual","Approx","Annual electricity","Annual gasoline","Electricity","Gasoline","Annual GHGs","Adjusted Composite annual"]
["Electric Vehicle","kWh/100 km","L/100 km","Annual fuel cost","Comb L/100 km","Annual fuel cost","fuel cost","utility factor (X)","use (kWh)","use (L)","cost","cost"," Emitted (tCO2e)","fuel cost"]
["CHEVROLET VOLT",{"$f":"Data!D3","v":19.899999999999999},0,{"$f":"ROUND((B12*$B$5/100*$B$6)+(C12*$B$5/100*$B$7),2)","v":597},5.6,{"$f":"ROUND(E12*$B$5/100*$B$7,2)","v":1680},655,{"$f":"ROUND((G12-F12)/(D12-F12),4)","v":0.94640000000000002},{"$f":"B12*$B$5/100*H12","v":3766.672},{"$f":"((E12*$B$5/100*(1-H12)))","v":60.031999999999982},{"$f":"ROUND(I12*$B$6,0)","v":565},{"$f":"ROUND(J12*$B$7,0)","v":90},{"$f":"(I12*0.00057) + (J12*0.0023)","v":2.2850766399999998},{"$f":"K12 + L12","v":655}]
["CHRYSLER PACIFICA HYBRID",{"$f":"Data!D4","v":25.8},0,{"$f":"ROUND((B13*$B$5/100*$B$6)+(C13*$B$5/100*$B$7),2)","v":774},8,{"$f":"ROUND(E13*$B$5/100*$B$7,2)","v":2400},1094,{"$f":"ROUND((G13-F13)/(D13-F13),4)","v":0.80320000000000003},{"$f":"B13*$B$5/100*H13","v":4144.5119999999997},{"$f":"((E13*$B$5/100*(1-H13)))","v":314.87999999999994},{"$f":"ROUND(I13*$B$6,0)","v":622},{"$f":"ROUND(J13*$B$7,0)","v":472},{"$f":"(I13*0.00057) + (J13*0.0023)","v":3.0865958399999998},{"$f":"K13 + L13","v":1094}]
["FORD ESCAPE PLUG-IN",{"$f":"Data!D5","v":20.2},0,606,5.8,{"$f":"ROUND(E14*$B$5/100*$B$7,2)","v":1740},795,{"$f":"ROUND((G14-F14)/(D14-F14),4)","v":0.83330000000000004},3366.5320000000002,193.37199999999996,505,290,2.3636788399999999,795]
["FORD FUSION ENERGI",{"$f":"Data!D6","v":20.5},0,615,5.6,{"$f":"ROUND(E15*$B$5/100*$B$7,2)","v":1680},957,0.67889999999999995,{"$f":"B15*$B$5/100*H15","v":2783.49},359.63200000000006,418,539,2.4137428999999999,957]
["HONDA CLARITY PLUG-IN",{"$f":"Data!D7","v":19},0,570,5.6,1680,746,0.84140000000000004,3197.32,177.63199999999995,480,266,2.231026,746]
["HYUNDAI IONIQ PLUG-IN",{"$f":"Data!D8","v":17.399999999999999},0,522,4.5,1350,684,0.80430000000000001,2798.9639999999999,176.13,420,264,2.0005084799999997,684]
["HYUNDAI SONATA PLUG-IN",{"$f":"Data!D9","v":20.9},0,627,6,{"$f":"ROUND(E18*$B$5/100*$B$7,2)","v":1800},836,0.82179999999999997,3435.1239999999998,213.84000000000003,515,321,2.4498526799999998,836]
["HYUNDAI SANTA FE PLUG-IN",{"$f":"Data!D10","v":27.5},0,{"$f":"ROUND((B19*$B$5/100*$B$6)+(C19*$B$5/100*$B$7),2)","v":825},7.2,{"$f":"ROUND(E19*$B$5/100*$B$7,2)","v":2160},1081,0.80820000000000003,4445.1000000000004,276.19199999999995,667,414,3.1689486000000002,1081]
["HYUNDAI TUCSON PLUG-IN",{"$f":"Data!D11","v":25.9},0,{"$f":"ROUND((B20*$B$5/100*$B$6)+(C20*$B$5/100*$B$7),2)","v":777},6.7,{"$f":"ROUND(E20*$B$5/100*$B$7,2)","v":2010},994,0.82399999999999995,4268.32,235.84000000000006,640,354,2.9753744000000002,994]
["GRAND CHEROKEE 4XE",{"$f":"Data!D12","v":36},0,{"$f":"ROUND((B21*$B$5/100*$B$6)+(C21*$B$5/100*$B$7),2)","v":1080},10,{"$f":"ROUND(E21*$B$5/100*$B$7,2)","v":3000},1516,0.77290000000000003,5564.88,454.19999999999993,835,681,4.2166416,1516]
["WRANGLER 4XE ",{"$f":"Data!D13","v":42.2},0,{"$f":"ROUND((B22*$B$5/100*$B$6)+(C22*$B$5/100*$B$7),2)","v":1266},11.7,{"$f":"ROUND(E22*$B$5/100*$B$7,2)","v":3510},1814,0.75580000000000003,6378.9520000000002,571.42799999999988,957,857,4.9502870400000001,1814]
["KIA NIRO PLUG-IN",{"$f":"Data!D14","v":19.7},0,{"$f":"ROUND((B23*$B$5/100*$B$6)+(C23*$B$5/100*$B$7),2)","v":591},5.0999999999999996,1530,783,0.79549999999999998,{"$f":"B23*$B$5/100*H23","v":3134.27},208.59,470,313,{"$f":"(I23*0.00057) + (J23*0.0023)","v":2.2662909},783]
["KIA OPTIMA PLUG-IN",{"$f":"Data!D15","v":20.7},0,621,5.7,1710,947,0.7006,2900.4839999999999,341.31599999999997,435,512,2.4383026799999996,{"$f":"K24 + L24","v":947}]
["KIA SORENTO PLUG-IN",{"$f":"Data!D16","v":26.4},0,792,6.9,{"$f":"ROUND(E25*$B$5/100*$B$7,2)","v":2070},1019,0.82240000000000002,4342.2719999999999,245.08799999999997,651,368,3.0387974399999997,{"$f":"K25 + L25","v":1019}]
["MINI COOPER S E COUNTRYMAN ALL4",{"$f":"Data!D17","v":28.4},0,852,8,2400,1367,0.6673,{"$f":"B26*$B$5/100*H26","v":3790.2640000000001},532.31999999999994,{"$f":"ROUND(I26*$B$6,0)","v":569},798,3.3847864799999998,1367]
["MITSUBISHI OUTLANDER (PHEV)",{"$f":"Data!D18","v":28.2},0,846,9.1,2730,1317,0.75,4230,455,635,683,3.4575999999999998,1318]
["SUBARU CROSSTREK HYBRID",{"$f":"Data!D19","v":23.5},0,705,6.7,2010,1075,0.71650000000000003,3367.55,379.89,505,570,2.7932505000000001,1075]
["TOYOTA PRIUS PRIME",{"$f":"Data!D20","v":15.8},0,474,4.3,1290,660,0.77210000000000001,{"$f":"B29*$B$5/100*H29","v":2439.8360000000002},195.994,{"$f":"ROUND(I29*$B$6,0)","v":366},{"$f":"ROUND(J29*$B$7,0)","v":294},1.8414927200000002,{"$f":"K29 + L29","v":660}]
["TOYOTA RAV4 PRIME",{"$f":"Data!D21","v":22.3},0,669,6,1800,833,0.85499999999999998,{"$f":"B30*$B$5/100*H30","v":3813.2999999999997},{"$f":"((E30*$B$5/100*(1-H30)))","v":174.00000000000003},{"$f":"ROUND(I30*$B$6,0)","v":572},{"$f":"ROUND(J30*$B$7,0)","v":261},{"$f":"(I30*0.00057) + (J30*0.0023)","v":2.5737809999999994},{"$f":"K30 + L30","v":833}]
[]
["NOTE: Utility factor (x) assumes few trips are >100 kms. As such, the factor was calculated by taking the PHEV electric range and dividing by 100. This assumes that out of 100kms, x=% vehicle is driven in electric mode and 1-x = % vehicle is driven in gas mode."]

{"sheet":"Passenger EV Fuel Efficiency","index":6,"n_rows":93,"n_cols":23,"rows_kept":93,"cut":false,"hidden":true,"merged":[[77,12,77,20],[78,12,79,12],[78,13,79,13],[78,15,79,15],[78,16,79,16],[78,17,79,17],[78,18,79,18],[78,19,79,19],[78,20,79,20],[74,12,74,20],[75,12,76,12],[75,13,76,13],[75,15,76,15],[75,16,76,16],[75,17,76,17],[75,18,76,18],[75,19,76,19],[75,20,76,20],[69,20,70,20],[71,12,71,20],[72,12,73,12],[72,13,73,13],[72,15,73,15],[72,16,73,16],[72,17,73,17],[72,18,73,18],[72,19,73,19],[72,20,73,20],[69,13,70,13],[69,15,70,15],[69,16,70,16],[69,17,70,17],[69,18,70,18],[69,19,70,19],[69,0,70,0],[69,3,70,3],[69,4,70,4],[69,5,70,5],[69,6,70,6],[69,12,70,12],[66,16,67,16],[66,17,67,17],[66,18,67,18],[66,19,67,19],[66,20,67,20],[68,0,68,8],[68,12,68,20],[65,0,65,8],[65,12,65,20],[66,0,67,0],[66,3,67,3],[66,4,67,4],[66,5,67,5],[66,6,67,6],[66,12,67,12],[66,13,67,13],[66,15,67,15],[63,15,64,15],[63,16,64,16],[63,17,64,17],[63,18,64,18],[63,19,64,19],[63,20,64,20],[60,20,61,20],[62,0,62,8],[62,12,62,20],[63,0,64,0],[63,3,64,3],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,12,64,12],[63,13,64,13],[60,13,61,13],[60,15,61,15],[60,16,61,16],[60,17,61,17],[60,18,61,18],[60,19,61,19],[60,0,61,0],[60,3,61,3],[60,4,61,4],[60,5,61,5],[60,6,61,6],[60,12,61,12],[57,16,58,16],[57,17,58,17],[57,18,58,18],[57,19,58,19],[57,20,58,20],[59,0,59,8],[59,12,59,20],[56,0,56,8],[56,12,56,20],[57,0,58,0],[57,3,58,3],[57,4,58,4],[57,5,58,5],[57,6,58,6],[57,12,58,12],[57,13,58,13],[57,15,58,15],[54,15,55,15],[54,16,55,16],[54,17,55,17],[54,18,55,18],[54,19,55,19],[54,20,55,20],[51,20,52,20],[53,0,53,8],[53,12,53,20],[54,0,55,0],[54,3,55,3],[54,4,55,4],[54,5,55,5],[54,6,55,6],[54,12,55,12],[54,13,55,13],[51,13,52,13],[51,15,52,15],[51,16,52,16],[51,17,52,17],[51,18,52,18],[51,19,52,19],[51,0,52,0],[51,3,52,3],[51,4,52,4],[51,5,52,5],[51,6,52,6],[51,12,52,12],[48,16,49,16],[48,17,49,17],[48,18,49,18],[48,19,49,19],[48,20,49,20],[50,0,50,8],[50,12,50,20],[47,0,47,8],[47,12,47,20],[48,0,49,0],[48,3,49,3],[48,4,49,4],[48,5,49,5],[48,6,49,6],[48,12,49,12],[48,13,49,13],[48,15,49,15],[45,15,46,15],[45,16,46,16],[45,17,46,17],[45,18,46,18],[45,19,46,19],[45,20,46,20],[42,20,43,20],[44,0,44,8],[44,12,44,20],[45,0,46,0],[45,3,46,3],[45,4,46,4],[45,5,46,5],[45,6,46,6],[45,12,46,12],[45,13,46,13],[42,13,43,13],[42,15,43,15],[42,16,43,16],[42,17,43,17],[42,18,43,18],[42,19,43,19],[42,0,43,0],[42,3,43,3],[42,4,43,4],[42,5,43,5],[42,6,43,6],[42,12,43,12],[39,16,40,16],[39,17,40,17],[39,18,40,18],[39,19,40,19],[39,20,40,20],[41,0,41,8],[41,12,41,20],[38,0,38,8],[38,12,38,20],[39,0,40,0],[39,3,40,3],[39,4,40,4],[39,5,40,5],[39,6,40,6],[39,12,40,12],[39,13,40,13],[39,15,40,15],[36,15,37,15],[36,16,37,16],[36,17,37,17],[36,18,37,18],[36,19,37,19],[36,20,37,20],[33,20,34,20],[35,0,35,8],[35,12,35,20],[36,0,37,0],[36,3,37,3],[36,4,37,4],[36,5,37,5],[36,6,37,6],[36,12,37,12],[36,13,37,13],[33,13,34,13],[33,15,34,15],[33,16,34,16],[33,17,34,17],[33,18,34,18],[33,19,34,19],[33,0,34,0],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[33,12,34,12],[30,16,31,16],[30,17,31,17],[30,18,31,18],[30,19,31,19],[30,20,31,20],[32,0,32,8],[32,12,32,20],[29,0,29,8],[29,12,29,20],[30,0,31,0],[30,3,31,3],[30,4,31,4],[30,5,31,5],[30,6,31,6],[30,12,31,12],[30,13,31,13],[30,15,31,15],[26,0,26,8],[27,0,28,0],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,28,6],[24,15,25,15],[24,16,25,16],[24,17,25,17],[24,18,25,18],[24,19,25,19],[24,20,25,20],[21,20,22,20],[23,0,23,8],[23,12,23,20],[24,0,25,0],[24,3,25,3],[24,4,25,4],[24,5,25,5],[24,6,25,6],[24,12,25,12],[24,13,25,13],[21,13,22,13],[21,15,22,15],[21,16,22,16],[21,17,22,17],[21,18,22,18],[21,19,22,19],[21,0,22,0],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,12,22,12],[18,16,19,16],[18,17,19,17],[18,18,19,18],[18,19,19,19],[18,20,19,20],[20,0,20,8],[20,12,20,20],[17,0,17,8],[17,12,17,20],[18,0,19,0],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,12,19,12],[18,13,19,13],[18,15,19,15],[14,0,14,8],[15,0,16,0],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[11,0,11,8],[12,0,13,0],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[9,19,10,19],[9,20,10,20],[6,20,7,20],[8,0,8,8],[8,12,8,20],[9,0,10,0],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,12,10,12],[9,13,10,13],[6,13,7,13],[6,15,7,15],[6,16,7,16],[6,17,7,17],[6,18,7,18],[6,19,7,19],[6,4,7,4],[6,6,7,6],[6,12,7,12],[3,12,4,12],[3,13,4,13],[3,15,4,15],[3,16,4,16],[3,17,4,17],[12,13,13,13],[3,18,4,18],[9,15,10,15],[9,16,10,16],[9,17,10,17],[9,18,10,18],[12,12,13,12],[12,19,13,19],[15,12,16,12],[15,13,16,13],[15,19,16,19],[15,20,16,20],[27,19,28,19],[27,20,28,20],[0,3,0,8],[0,16,0,17],[0,18,0,20],[2,0,2,8],[2,12,2,20],[3,0,4,0],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,19,4,19],[3,20,4,20],[5,0,5,8],[5,12,5,20],[6,0,7,0],[6,3,7,3],[6,5,7,5]]}
["Plug-in hybrid electric vehicles",null,null,"Understanding the table\n",null,null,null,null,null,null,null,null,"Battery-electric vehicles",null,null,null,"Up to date as of:",null,"2019-02-25"]
["Make ModelSpecificationsFootnote1","Fuel\ntype","Combined Le/100 km\nCity/Hwy/Comb L/100 km","$/yr","CO2\n(g/km)","CO2\nrating","Smog\nrating","Range\n(km)","Recharge\ntime (h)","Price ($ USD)","Price ($ CAD)",null,"Make ModelSpecifications2","Fuel\ntype","City/Hwy/Comb kWh/100 km\nCity/Hwy/Comb Le/100 km","$/yr","CO2\n(g/km)","CO2\nrating","Smog\nrating","Range\n(km)","Recharge\ntime (h)","Price ($ USD)","Price ($ CAD)"]
["BMW 530e",null,null,null,null,null,null,null,null,null,null,null,"BMW i3 (120 Ah)"]
["C, 83 kW, 2.0 L,\n4 cyl, AS8","B/Z*","3.3 (28.5 kWh/100 km + 0.0 L/100 km)",1464,120,10,7,26,2,null,null,null,"S, 125 kW, A1","B","16.8 / 20.6 / 18.5",481,0,10,10,246,7,44450,57987]
[null,"Z","8.6 / 7.7 / 8.2",null,null,null,null,560,"-",null,null,null,null,null,"1.9 / 2.3 / 2.1"]
["BMW 530e xDRIVE",null,null,null,null,null,null,null,null,null,null,null,"BMW i3s (120 Ah)"]
["C, 83 kW, 2.0 L,\n4 cyl, AS8","B/Z*","3.5 (30.2 kWh/100 km + 0.0 L/100 km)",1511,124,10,7,24,2,53400,69663,null,"S, 125 kW, A1","B","16.8 / 20.6 / 18.5",481,0,10,10,246,7]
[null,"Z","8.8 / 7.7 / 8.3",null,null,null,null,554,"-",null,null,null,null,null,"1.9 / 2.3 / 2.1"]
["BMW 740e xDRIVE",null,null,null,null,null,null,null,null,null,null,null,"CHEVROLET BOLT EV"]
["L, 83 kW, 2.0 L,\n4 cyl, AS8","B/Z*","3.6 (32.1 kWh/100 km + 0.0 L/100 km)",1616,133,9,3,23,3,null,null,null,"WS, 150 kW, A1","B","16.4 / 19.0 / 17.6",458,0,10,10,383,9.3000000000000007,36620,47773]
[null,"Z","9.5 / 8.0 / 8.8",null,null,null,null,525,"-",null,null,null,null,null,"1.8 / 2.1 / 2.0"]
["BMW i3 REx (120 Ah)",null,null,null,null,null,null,null,null,null,null,null,"FIAT 500e"]
["S, 125 kW, 0.6 L,\n2 cyl, A1","B/Z*","2.4 (19.9 kWh/100 km)",644,14,10,7,203,7,48300,63010,null,"S, 24 kW, A1","B","121/103/ 112",null,null,null,null,135,null,32995,43044]
[null,"Z","7.8 / 7.5 / 7.7",null,null,null,null,116,"-"]
["BMW i3s REx",null,null,null,null,null,null,null,null,null,null,null,"HONDA CLARITY"]
["S, 135 kW, 0.6 L,\n2 cyl, A1","B/Z*","2.4 (19.9 kWh/100 km)",644,14,10,7,203,7,48300,63010,null,"120 kW","B","16.5 / 20 / 18.5",null,null,null,null,143,3.5,199,260]
[null,"Z","7.8 / 7.5 / 7.7",null,null,null,null,116,"-",null,null,null,null,null,"1.9 / 2.3 / 2.1",null,null,null,null,null,null,"(Lease Only)","(Lease Only)"]
["BMW i8 COUPE",null,null,null,null,null,null,null,null,null,null,null,"HYUNDAI IONIQ ELECTRIC"]
["S, 105 kW, 1.5 L,\n3 cyl, AS6","B/Z*","3.4 (30.6 kWh/100 km + 0.0 L/100 km)",1512,118,10,3,29,3,147500,192421,null,"M, 88 kW, A1","B","13.7 / 17.4 / 15.5",403,0,10,10,200,4,30315,39547]
[null,"Z","9.2 / 8.0 / 8.7",null,null,null,null,488,"-",null,null,null,null,null,"1.6 / 1.9 / 1.7"]
["BMW i8 ROADSTER",null,null,null,null,null,null,null,null,null,null,null,"HYUNDAI KONA ELECTRIC"]
["S, 105 kW, 1.5 L,\n3 cyl, AS6","B/Z*","3.4 (30.6 kWh/100 km + 0.0 L/100 km)",1512,118,10,3,29,3,null,null,null,"US, 150 kW, A1","B","16.2 / 19.3 / 17.4",452,0,10,10,415,9,36950,48203]
[null,"Z","9.2 / 8.0 / 8.7",null,null,null,null,488,"-",null,null,null,null,null,"1.8 / 2.2 / 2.0"]
["CHEVROLET VOLT",null,null,null,null,null,null,null,null,null,null,null,"JAGUAR I-PACE"]
["C, 111 kW, 1.5 L,\n4 cyl, AV","B","2.2 (19.9 kWh/100 km)",655,32,10,3,85,4.5,33520,43729,null,"US, 294 kW, A1","B","26.2 / 29.1 / 27.5",715,0,10,10,377,13,69500,90666]
[null,"X","5.5 / 5.6 / 5.6",null,null,null,null,591,"-",null,null,null,null,null,"2.9 / 3.3 / 3.1"]
["CHRYSLER PACIFICA HYBRID",null,null,null,null,null,null,null,null,null,null,null,"KIA NIRO"]
["V, 89 kW, 3.6 L,\n6 cyl, AV","B/X*","2.9 (25.8 kWh/100 km + 0.0 L/100 km)",1043,74,10,7,51,2,39995,52175,null,"170 kW",null,"17.5 / 20.5 / 19",null,null,null,null,385,9.5,38500,50225]
[null,"X","8.0 / 7.9 / 8.0",null,null,null,null,784,"-",null,null,null,null,null,"1.9 / 2.3 / 2.1"]
["FORD FUSION ENERGI",null,null,null,null,null,null,null,null,null,null,null,"KIA SOUL EV"]
["M, 68 kW, 2.0 L,\n4 cyl, AV","B/X*","2.3 (20.5 kWh/100 km + 0.0 L/100 km)",812,61,10,7,42,2.6,34595,45131,null,"WS, 81 kW, A1","B","16.8 / 22.4 / 19.3",502,0,10,10,179,5,33950,44289]
[null,"X","5.5 / 5.8 / 5.6",null,null,null,null,940,"-",null,null,null,null,null,"1.9 / 2.5 / 2.2"]
["HONDA CLARITY PLUG-IN",null,null,null,null,null,null,null,null,null,null,null,"NISSAN LEAF (40 kWh)"]
["M, 135 kW, 1.5 L,\n4 cyl, AV","B/X*","2.1 (19.0 kWh/100 km + 0.0 L/100 km)",669,36,10,8,77,2.5,33400,43572,null,"M, 110 kW, A1","B","16.8 / 21.0 / 18.7",486,0,10,10,243,8,29990,39123]
[null,"X","5.3 / 5.9 / 5.6",null,null,null,null,475,"-",null,null,null,null,null,"1.9 / 2.4 / 2.1"]
["HYUNDAI IONIQ ELECTRIC PLUS",null,null,null,null,null,null,null,null,null,null,null,"NISSAN LEAF S PLUS"]
["M, 32 kW, 1.6 L,\n4 cyl, AM6","B/X*","2.0 (17.7 kWh/100 km + 0.0\nL/100 km)",655,46,10,7,47,2.2999999999999998,25350,33070,null,"M, 160 kW, A1","B","17.8 / 21.5 / 19.5",507,0,10,10,363,11,36550,47681]
[null,"X","4.4 / 4.6 / 4.5",null,null,null,null,961,"-",null,null,null,null,null,"2.0 / 2.4 / 2.2"]
["HYUNDAI SONATA PLUG-IN",null,null,null,null,null,null,null,null,null,null,null,"NISSAN LEAF SV/SL PLUS"]
["M, 50 kW, 2.0 L,\n4 cyl, AM6","B/X*","2.4 (20.9 kWh/100 km + 0.0\nL/100 km)",836,62,10,7,45,2.7,33400,43572,null,"M, 160 kW, A1","B","18.7 / 22.1 / 20.0",520,0,10,10,349,11,37095,48392]
[null,"X","6.3 / 5.6 / 6.0",null,null,null,null,925,"-",null,null,null,null,null,"2.1 / 2.5 / 2.2"]
["KARMA REVERO",null,null,null,null,null,null,null,null,null,null,null,"SMART FORTWO ELECTRIC DRIVE CABRIOLET"]
["S, 300 kW, 2.0 L,\n4 cyl, A1","B","3.9 (34.7 kWh/100 km)",1526,94,10,1,60,3.75,130000,169592,null,"T, 60 kW, A1","B","18.7 / 23.1 / 20.7",538,0,10,10,92,3]
[null,"Z","11.8 / 11.2 / 11.5",null,null,null,null,328,"-",null,null,null,null,null,"2.1 / 2.6 / 2.3"]
["KIA NIRO PLUG-IN",null,null,null,null,null,null,null,null,null,null,null,"SMART FORTWO ELECTRIC DRIVE COUPE"]
["M, 32 kW,1.6 L,\n4 cyl, AM6","B/X*","2.2 (19.7 kWh/100 km + 0.0 L/100 km)",753,56,10,7,42,2.25,28500,37180,null,"T, 60 kW, A1","B","16.9 / 22.3 / 19.3",502,0,10,10,93,3,23900,31179]
[null,"X","4.9 / 5.3 / 5.1",null,null,null,null,853,"-",null,null,null,null,null,"1.9 / 2.5 / 2.2"]
["KIA OPTIMA PLUG-IN",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL 3 Mid Range"]
["M, 50 kW, 2.0 L,\n4 cyl, AM6","B/X*","2.3 (20.3 kWh/100 km + 0.0 L/100 km)",816,60,10,7,47,2.7,35390,46168,null,"M, 202 kW, A1","B","16.4 / 17.9 / 17.1",445,0,10,10,425,10,35000,45659]
[null,"X","6.2 / 5.5 / 5.9",null,null,null,null,937,"-",null,null,null,null,null,"1.8 / 2.0 / 1.9"]
["MERCEDES-BENZ GLC 350e 4MATIC",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL 3 Long Range"]
["US, 85 kW, 2.0 L,\n4 cyl, AS7","B/Z*","4.2 (36.5 kWh/100 km + 0.0 L/100 km)",1765,146,9,7,21,1.9,50650,66075,null,"M, 202 kW, A1","B","15.3 / 17.0 / 16.1",419,0,10,10,499,10]
[null,"Z","9.8 / 8.6 / 9.3",null,null,null,null,541,"-",null,null,null,null,null,"1.7 / 1.9 / 1.8"]
["MINI COOPER S E COUNTRYMAN ALL4",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL 3 Long Range AWD"]
["M, 65 kW, 1.5 L,\n3 cyl, AS6","B/Z*","3.6 (31.4 kWh/100 km + 0.0 L/100 km)",1623,139,9,3,19,3,36900,48138,null,"M, 335 kW, A1","B","17.4 / 18.7 / 18.0",468,0,10,10,499,10]
[null,"Z","8.4 / 8.8 / 8.6",null,null,null,null,420,"-",null,null,null,null,null,"2.0 / 2.1 / 2.0"]
["MITSUBISHI OUTLANDER PHEV AWD",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL 3 Long Range AWD Performance"]
["US, 60 kW, 2.0 L,\n4 cyl, A1","B/X*","3.2 (27.7 kWh/100 km + 0.0 L/100 km)",1316,108,10,7,35,3.5,34595,45131,null,"M, 358 kW, A1","B","17.4 / 18.7 / 18.0",468,0,10,10,499,10]
[null,"X","9.4 / 9.0 / 9.2",null,null,null,null,463,"-",null,null,null,null,null,"2.0 / 2.1 / 2.0"]
["TOYOTA PRIUS PRIME",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL S 75D"]
["M, 71 kW, 1.8 L,\n4 cyl, AV","B/X*","1.8 (15.8 kWh/100 km + 0.0 L/100 km)",635,49,10,7,40,2,27350,35679,null,"L,368 kW, A1","B","20.7 / 20.5 / 20.6",536,0,10,10,417,12,78000,101755]
[null,"X","4.3 / 4.4 / 4.3",null,null,null,null,995,"-",null,null,null,null,null,"2.3 / 2.3 / 2.3"]
["VOLVO S90 T8 AWD",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL S 100D"]
["M, 65 kW, 2.0 L,\n4 cyl, AS8","B/Z*","3.2 (27.7 kWh/100 km + 0.0 L/100 km)",1338,100,10,7,34,3,63900,83361,null,"L, 386 kW, A1","B","20.7 / 20.5 / 20.6",536,0,10,10,539,12]
[null,"Z","8.9 / 7.1 / 8.1",null,null,null,null,753,"-",null,null,null,null,null,"2.3 / 2.3 / 2.3"]
["VOLVO XC60 T8 AWD",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL S P100D"]
["US, 65 kW, 2.0 L,\n4 cyl, AS8","B/Z*","3.8 (34.0 kWh/100 km + 0.0 L/100 km)",1613,128,9,7,27,3,55300,72142,null,"L, 568 kW, A1","B","22.6 / 20.0 / 21.5",559,0,10,10,507,12]
[null,"Z","9.5 / 8.5 / 9.0",null,null,null,null,779,"-",null,null,null,null,null,"2.5 / 2.3 / 2.4"]
["VOLVO XC90 T8 AWD",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL X 75D"]
["UL, 65 kW, 2.0 L,\n4 cyl, AS8","B/Z*","3.9 (34.4 kWh/100 km + 0.0 L/100 km)",1658,132,9,7,27,3,67000,87405,null,"UL, 386 kW, A1","B","23.0 / 21.9 / 22.5",585,0,10,10,383,12,83000,108278]
[null,"Z","9.8 / 8.7 / 9.3",null,null,null,null,756,"-",null,null,null,null,null,"2.6 / 2.5 / 2.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL X 100D"]
["2019 PHEV Options:",null,null,null,null,null,null,null,null,null,null,null,"UL, 386 kW, A1","B","24.3 / 23.7 / 24.0",624,0,10,10,475,12]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.7 / 2.7 / 2.7"]
["Number of Manufacturers:",null,null,null,null,null,null,null,null,null,null,null,"TESLA MODEL X P100D"]
[13,null,null,null,null,null,null,null,null,null,null,null,"UL, 568 kW, A1","B","25.4 / 23.6 / 24.6",640,0,10,10,465,12]
["Likely Eligible for EVM:",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.8 / 2.7 / 2.8"]
[11,null,null,null,null,null,null,null,null,null,null,null,"VOLKSWAGEN e-GOLF"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C, 100 kW, A1","B","16.8 / 18.6 / 17.4",452,0,10,10,201,5.3,31895,41609]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.9 / 2.1 / 2.0"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2019 BEV Options:"]
[null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number of Manufacturers:"]
[null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"Likely Eligible for EVM:"]
[null,null,null,null,null,null,null,null,null,null,null,null,11]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source for vehicle pricing: https://pluginamerica.org/wp-content/uploads/2019/06/EV-Guide-2019-June-4-pages.pdf"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"22 passenger vehicle models currently eligible"]