{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["EV calcs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"EV calcs","index":0,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[43,7,43,8],[44,7,44,8]]}
[null,null,null,null,"Derived 5-cycle MPG Calculations For Electric Vehicles"]
[]
["Please Enter:",null,null,"(Uses 2017 and later model year derived 5-cycle coefficients from EPA Guidance letter CD-15-15, June 22, 2015)"]
["Model Year:",null,2021]
["Manufacturer Name:",null,"xxxxxxx",null,null,"Values in Yellow fill are used on FE Labels (window stickers)"]
["Model Name",null,"yyyyyyyy",null,null,null,null,null,null,null,null,"D. Good",null," December 17, 2019"]
["Test Date:",null,"xx/yy/2020"]
[]
["I.  Calculate Electric vehicle FE Label city, Hwy, Combined FE values using the 2017MY and later (derived 5-cycle) method and the 30% cap method:"]
[]
[null,"Enter unadjusted unrounded kW-hr/100mi Values (in red text blocks) as determined from SAE J1634:",null,null,null,null,null,null,null,null,"2017MY and later FE Label method (Derived 5-cycle)"]
[null,null,null,null,null,null,null,null,null,null,"Derived 5-cycle City","Derived 5-cycle Hwy","Adjusted Combined","Units"]
[null,null,null,"City","Highway","Combined"]
[null,null,null," (round mpg to 0.1mpg)","(round mpg to 0.1mpg)","Calculated unadjusted combined","Units"]
[null,null,null," "," ",null,null,null,null,"Calculate derived 5-cycle mpg:",{"$f":"astm((1/((B40)+(B41/D17))), 1)","v":95.1},{"$f":"astm((1/((B42)+(B43/E17))), 1)","v":80.8},{"$f":"astm((1/((0.55/K15)+(0.45/L15))), 1)","v":88.1},"mpg"]
[null,"Elect veh FE","unrounded kW-hr/100 mi",18.670500000000001,23.906300000000002,{"$f":"(0.55*D16+0.45*E16)","v":21.026610000000005},"kW-hr/100 mi",null,null,"convert back to kW-hr/100 mi:",{"$f":"astm((0.1*A48/K15), 1)","v":35.4},{"$f":"astm((0.1*A48/L15), 1)","v":41.7},{"$f":"ROUND((0.1*A48/M15), 1)","v":38.299999999999997},"kW-hr/100 mi Derived 5-cycle"]
[null,"Elect veh FE","converted to mpg",{"$f":"astm((A48/(10*D16)),1)","v":180.5},{"$f":"astm((A48/(10*E16)),1)","v":141},{"$f":"astm((1/((0.55/D17)+(0.45/E17))), 4)","v":160.2929},"mpg",null,null,"Percent adjustment mpg:",{"$f":"(D17-K15)/D17","v":0.47313019390581723},{"$f":"(E17-L15)/E17","v":0.42695035460992908},{"$f":"(F17-M15)/F17","v":0.45038114601457713},"percent"]
[null,null,null,null,null,null,null,null,null,"MPG w/ 30% Cap",{"$f":"0.7*D17","v":126.35},{"$f":"0.7*E17","v":98.699999999999989},{"$f":"0.7*F17","v":112.20502999999999},"MPGe with 30 % Cap"]
[null,null,null,null,null,null,null,null,null,"convert back to kW-hr/100 mi:",{"$f":"astm((0.1*A48/K18), 4)","v":26.675899999999999},{"$f":"astm((0.1*A48/L18), 4)","v":34.148899999999998},{"$f":"astm((0.1*A48/M18), 4)","v":30.038799999999998},"kW-hr/100 mi w/30 % Cap"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.55*K19+0.45*L19","v":30.03875}]
[null,null,null,null,null,null,null,null,null,"2021 Label Values:"]
[null,null,null,null,null,null,null,null,null,"Rounded MPG w/30% cap:",{"$f":"astm(K18,0)","v":126},99,112]
[null,null,null,null,null,null,null,null,null,"Rounded kW=hr/100 mi:",27,34,30]
[]
[]
["II.  Calculate Electric vehicle driving ranges using the unadjusted SAE J1634 method and the 2017MY and later (derived 5-cycle) method:"]
[]
[null,"Enter unadjusted City & Hwy Range Values in miles (in red text blocks) as determined from SAE J1634:"]
[]
[null,null,null,"City Range","Hwy Range","Combined Range","Rounded Range","Units",null,"Method:"]
["Calculate unadjusted driving range:",null,null,111.29300000000001,89.42,{"$f":"0.55*D31+0.45*E31","v":101.45015000000001},{"$f":"astm(F31,0)","v":101},"miles",null,"Unadjusted (SAE J1634)"]
["Calculate adjusted driving range (2017 method, No Cap):",null,null,{"$f":"D31*(1-K17)","v":58.63692132963989},{"$f":"E31*(1-L17)","v":51.242099290780139},{"$f":"F31*(1-M17)","v":55.75891517964925},{"$f":"astm(F32,0)","v":56},"miles",null,"2021 (derived 5-cycle, mpg-based, No Cap)"]
["Calculate adjusted driving range (2017 method, 30% Cap):",null,null,{"$f":"D31*(1-0.3)","v":77.905100000000004},{"$f":"E31*(1-0.3)","v":62.593999999999994},{"$f":"F31*(1-0.3)","v":71.015105000000005},{"$f":"astm(F33,0)","v":71},"miles",null,"2021 (derived 5-cycle, mpg-based, 30% Cap)"]
[]
[]
[]
[null,null,null,"III. Calculate Electric vehicle annual fuel cost and 5-year savings, per 40 CFR 600.311-12(e)"]
["2017 and later model year MPG Factors:"]
["ref. 40 CFR 600.210-08 and CD-15-15 (June 22, 2015)",null,null,null,"Enter Average 2021 5-year Fuel Cost:",null,null,7500]
["City Intercept:",4.091E-3,null,null,"Enter 2021 U.S. electricity costs:",null,null,0.13,"per kw-hr"]
["City Slope:",1.1600999999999999,null,null,"     (from CD-2019-13 for 2021 model year)"]
["Hwy Intercept:",3.1909999999999998E-3,null,"Calculate unrounded adjusted combined miles/kw-hr:",null,null,null,{"$f":"100/M19","v":3.3290277907239973},"mi/kw-hr",null,null,null,"2021 Label",null,"2021 Label"]
["Hwy Slope:",1.2945,null,null,null,null,null,null,null,null,null,null,"Rounded ",null,"5-year"]
[null,null,null,null,null,null,null,"Unrounded ",null,null,null,null,"Annual",null,"Amount"]
["Petroleum Equivalency Factor for FE Labels;",null,null,null,"Annual Miles","Cost","Units","Annual Fuel Cost*",null,"Method",null,null,"Fuel Cost",null,"You Save:"]
["ref. 40 CFR 600.002 \"Gasoline gallon equivalent\" definition",null,null,null,15000,{"$f":"H40","v":0.13},"per kw-hr",{"$f":"150*F46*M16","v":746.84999999999991},null,"  (current derived 5-cycle, mpg-based, No Cap)",null,null,{"$f":"astm(H46/50,0) *50","v":750},null,{"$f":"$H$39 - 5*M46","v":3750}]
[null,null,null,null,15000,{"$f":"H40","v":0.13},"per kw-hr",{"$f":"15000*F47/H42","v":585.75659999999993},null,"  (derived 5-cycle, mpg-based, 30% Cap)",null,null,{"$f":"astm(H47/50,0) *50","v":600},null,{"$f":"$H$39 - 5*M47","v":4500}]
[33705,"watt-hr/gallon"]
[null,null,null,null,null,null,"*Note: Annual fuel costs should be ASTM rounded to the nearest $50."]