{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["EV calcs","EV calcs voluntarily lowered"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"EV calcs","index":0,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[[45,7,45,8],[46,7,46,8],[13,3,13,5],[14,10,14,12]]}
[null,null,null,null,"FE Label MPG Calculations For Electric Vehicles"]
[]
["Please Enter:",null,null,"(Uses 2017 and later model year derived 5-cycle coefficients (for reference calculations only) from EPA Guidance letter CD-15-15, June 22, 2015)"]
["Model Year:",null,2024]
["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,"T. Rojeck",null,"February 27, 2023"]
["Test Date:",null,"xx/yy/2023"]
[null,null,null,null,null,null,null,null,null,null,"   Enter the EPA approved 5-cycle Adjustment Factor per SAE J1634 (July 2017): ",0.72004000000000001,"<-------- (round to  5 decimal places); "]
[null,null,null,null,null,null,null,null,null,null,"(Enter 0.70 if not using the SAE J1634 5-cycle method)                    ",null,"(Orange background = too many decimal places)"]
[]
["I.  Calculate Electric vehicle FE Label city, Hwy, Combined FE values using the SAE J1634  5-cycle Adjustment Factor or the 0.7 Adjustment Factor:"]
[]
[null,"Enter unadjusted kW-hr/100mi Values (in red text blocks) rounded to 5 decimal places as determined from SAE J1634:"]
[null,null,null,"-----Unadjusted Values-----"]
[null,null,null,"City","Highway","Combined",null,null,null,null,"-----Adjusted Values-----"]
[null,null,null," (round mpg to 0.1mpg)","(round mpg to 0.1mpg)","Calculated unadjusted combined","Units",null,null,null,"City","Hwy","Combined","Units"]
[null,null,null," "," ",null,null,null,null,"Calculate derived 5-cycle mpg:  ",{"$f":"astm((1/((B42)+(B43/D19))), 1)","v":95.1},{"$f":"astm((1/((B44)+(B45/E19))), 1)","v":80.8},{"$f":"astm((1/((0.55/K17)+(0.45/L17))), 1)","v":88.1},"mpg","for EPA (reference only)"]
[null,"Elect veh FE","unadjusted kW-hr/100 mi*",18.670500000000001,23.906300000000002,{"$f":"(0.55*D18+0.45*E18)","v":21.026610000000005},"kW-hr/100 mi",null,null,"convert back to kW-hr/100 mi:  ",{"$f":"astm((0.1*A50/K17), 1)","v":35.4},{"$f":"astm((0.1*A50/L17), 1)","v":41.7},{"$f":"ROUND((0.1*A50/M17), 1)","v":38.299999999999997},"kW-hr/100 mi - Derived 5-cycle (EPA--for reference only)"]
[null,"Elect veh FE","converted to mpg",{"$f":"astm((A50/(10*D18)),1)","v":180.5},{"$f":"astm((A50/(10*E18)),1)","v":141},{"$f":"astm((1/((0.55/D19)+(0.45/E19))), 4)","v":160.2929},"mpg",null,null,"Percent adjustment mpg:  ",{"$f":"(D19-K17)/D19","v":0.47313019390581723},{"$f":"(E19-L17)/E19","v":0.42695035460992908},{"$f":"(F19-M17)/F19","v":0.45038114601457713},"percent","for EPA (reference only)"]
[null,null,"*Round Input kW-hr/100 mi values to 5 decimal places",null,null,null,null,null,null,"MPG w/SAE J1634 (5-cycle) or 0.7 Adjustment Factor: ",{"$f":"L8*D19","v":129.96722},{"$f":"L8*E19","v":101.52564},{"$f":"L8*F19","v":115.417299716},"MPGe (5-cycle method)"]
[null,null,"(Orange background = too many decimal places)",null,null,null,null,null,null,"convert back to kW-hr/100 mi:  ",{"$f":"astm((0.1*A50/K20), 4)","v":25.933499999999999},{"$f":"astm((0.1*A50/L20), 4)","v":33.198500000000003},{"$f":"astm((0.1*A50/M20), 4)","v":29.2027},"kW-hr/100 mi (5-cycle method)"]
[]
[null,null,null,null,null,null,null,null,null,"2024MY Label Values:"]
[null,null,null,null,null,null,null,null,null,"Rounded MPG Using SAE J1634 (5-cycle) or 0.7 Adjustment Factor:  ",{"$f":"astm(K20,0)","v":130},102,115]
[null,null,null,null,null,null,null,null,null,"Rounded kW-hr/100 mi Using SAE J1634 (5-cycle) or 0.7 Adjustment Factor:  ",26,33,29]
[]
[]
["II.  Calculate the adjusted electric vehicle driving ranges using the SAE J1634  5-cycle Adjustment Factor or the 0.7 Adjustment Factor:"]
[]
[null,"Enter unadjusted City & Hwy Range Values in miles (in red text blocks) rounded to 3 decimal places as determined from SAE J1634:"]
[]
[null,null,null,"City Range","Hwy Range","Combined Range","Rounded Range","Units",null,"Method:"]
["Calculate unadjusted combined driving range*:",null,null,311.29300000000001,289.42,{"$f":"0.55*D33+0.45*E33","v":301.45015000000001},{"$f":"astm(F33,0)","v":301},"miles",null,"Unadjusted (SAE J1634)"]
["Calculate adjusted driving range (2017 D5C method, No Cap):",null,null,{"$f":"D33*(1-K19)","v":164.01088254847645},{"$f":"E33*(1-L19)","v":165.85202836879432},{"$f":"F33*(1-M19)","v":165.68268597673384},{"$f":"astm(F34,0)","v":166},"miles",null,"Adjusted driving range (derived 5-cycle method, No Cap) calculated for reference only"]
["Calculate adjusted driving range (5-cycle or 0.7 Adj Factor):",null,null,{"$f":"D33*L8","v":224.14341172000002},{"$f":"E33*L8","v":208.39397680000002},{"$f":"F33*L8","v":217.05616600600001},{"$f":"astm(F35,0)","v":217},"miles",null,"(Adjusted driving range using 5-cycle or 0.7 Adjustment Factor)"]
[null,null,"*Round input city and hwy range values to 3 decimal places"]
[null,null,"(Orange background = too many decimal places)"]
[]
[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,null,null,"Enter Average 2024MY 5-year Fuel Cost: ",9750,null,"(Whole number)"]
["City Intercept:",4.091E-3,null,null,null,null,"Enter 2024MY U.S. average electricity cost: ",0.15,"per kw-hr","(2 decimal places)"]
["City Slope:",1.1600999999999999,null,null,"     (from CD-2022-16 for 2024 model year)"]
["Hwy Intercept:",3.1909999999999998E-3,null,"Calculate unrounded adjusted combined miles/kw-hr:",null,null,null,{"$f":"100/M21","v":3.4243408999852751},"mi/kw-hr",null,null,null,"2024 Label",null,"2024 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":"H42","v":0.15},"per kw-hr",{"$f":"150*F48*M18","v":861.74999999999989},null,"  (current derived 5-cycle, mpg-based, No Cap)",null,null,{"$f":"astm(H48/50,0) *50","v":850},null,{"$f":"$H$41 - 5*M48","v":5500}]
[null,null,null,null,15000,{"$f":"H42","v":0.15},"per kw-hr",{"$f":"15000*F49/H44","v":657.06074999999998},null," (Using SAE J1634 5-cycle or 0.7 Adjustment Factor)",null,null,{"$f":"astm(H49/50,0) *50","v":650},null,{"$f":"$H$41 - 5*M49","v":6500}]
[33705,"watt-hr/gallon"]
[null,null,null,null,null,null,"*Note: Annual fuel costs should be ASTM rounded to the nearest $50.",null,null,null,null,"**Note:  These values are used on the window stickers.  "]
[null,null,null,null,null,null,null,null,null,null,null,"(They may be different from the www.fueleconomy.gov values, "]
[null,null,null,null,null,null,null,null,null,null,null,"because www.fueleconomy.gov uses a floating fuel cost)."]

{"sheet":"EV calcs voluntarily lowered","index":1,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[48,7,48,8],[49,7,49,8],[13,3,13,5],[14,10,14,12]]}
[null,null,"FE Label MPG Calculations For Electric Vehicles (with Voluntarily lowered/increased values)"]
[]
["Please Enter:",null,null,"(Uses 2017 and later model year derived 5-cycle coefficients (for reference calculations only) from EPA Guidance letter CD-15-15, June 22, 2015)"]
["Model Year:",null,2024]
["Manufacturer Name:",null,"xxxxxxx",null,null,"Values in Yellow fill are normally used on FE Labels (window stickers)"]
["Model Name",null,"yyyyyyyy",null,null,"      Values in Blue fill are voluntarily decreased/increased values",null,null,null,null,null,"T. Rojeck",null,"February 27, 2023"]
["Test Date:",null,"xx/yy/2023"]
[null,null,null,null,null,null,null,null,null,null,"   Enter the EPA approved 5-cycle Adjustment Factor per SAE J1634 (July 2017): ",0.72004000000000001,"<-------- (round to  5 decimal places); "]
[null,null,null,null,null,null,null,null,null,null,"(Enter 0.70 if not using the SAE J1634 5-cycle method)                    ",null,"(Orange background = too many decimal places)"]
[]
["I.  Calculate Electric vehicle FE Label city, Hwy, Combined FE values using the SAE J1634  5-cycle Adjustment Factor or the 0.7 Adjustment Factor:"]
[]
[null,"Enter unadjusted kW-hr/100mi Values (in red text blocks) rounded to 5 decimal places as determined from SAE J1634:"]
[null,null,null,"-----Unadjusted Values-----"]
[null,null,null,"City","Highway","Combined",null,null,null,null,"-----Adjusted Values-----"]
[null,null,null," (round mpg to 0.1mpg)","(round mpg to 0.1mpg)","Calculated unadjusted combined","Units",null,null,null,"City","Hwy","Combined","Units"]
[null,null,null," "," ",null,null,null,null,"Calculate derived 5-cycle mpg: ",{"$f":"astm((1/((B45)+(B46/D19))), 1)","v":95.1},{"$f":"astm((1/((B47)+(B48/E19))), 1)","v":80.8},{"$f":"astm((1/((0.55/K17)+(0.45/L17))), 1)","v":88.1},"mpg","for EPA (reference only)"]
[null,"Elect veh FE","unrounded kW-hr/100 mi*",18.670500000000001,23.906300000000002,{"$f":"(0.55*D18+0.45*E18)","v":21.026610000000005},"kW-hr/100 mi",null,null,"convert back to kW-hr/100 mi: ",{"$f":"astm((0.1*A53/K17), 1)","v":35.4},{"$f":"astm((0.1*A53/L17), 1)","v":41.7},{"$f":"ROUND((0.1*A53/M17), 1)","v":38.299999999999997},"kW-hr/100 mi - Derived 5-cycle (EPA--for reference only)"]
[null,"Elect veh FE","converted to mpg",{"$f":"astm((A53/(10*D18)),1)","v":180.5},{"$f":"astm((A53/(10*E18)),1)","v":141},{"$f":"astm((1/((0.55/D19)+(0.45/E19))), 4)","v":160.2929},"mpg",null,null,"Percent adjustment (D5C) mpg: ",{"$f":"(D19-K17)/D19","v":0.47313019390581723},{"$f":"(E19-L17)/E19","v":0.42695035460992908},{"$f":"(F19-M17)/F19","v":0.45038114601457713},"percent","for EPA (reference only)"]
[null,null,"*Round to Input kW-hr/100 mi values to 5 decimal places",null,null,null,null,null,null,"MPG w/SAE J1634 (5-cycle) or 0.7 Adjustment Factor: ",{"$f":"L8*D19","v":129.96722},{"$f":"L8*E19","v":101.52564},{"$f":"L8*F19","v":115.417299716},"MPG (5-cycle method)"]
[null,null,"(Orange background = too many decimal places)",null,null,null,null,null,null,"convert back to kW-hr/100 mi: ",{"$f":"astm((0.1*A53/K20), 4)","v":25.933499999999999},{"$f":"astm((0.1*$A$53/$L$20), 4)","v":33.198500000000003},{"$f":"astm((0.1*$A$53/$M$20), 4)","v":29.2027},"kW-hr/100 mi (5-cycle method)"]
[]
[null,null,null,null,null,null,null,null,null,"2024MY Label Values:"]
[null,null,null,null,null,null,null,null,null,"Rounded MPG Using SAE J1634 (5-cycle) or 0.7 Adjustment Factor:  ",{"$f":"astm(K20,0)","v":130},102,{"$f":"astm(M20,0)","v":115}]
[null,null,null,null,null,null,null,null,null,"Rounded kW-hr/100 mi Using SAE J1634 (5-cycle) or 0.7 Adjustment Factor:  ",26,33,29]
[null,null,null,null,null,null,null,null,null,"Voluntarily Reduced MPG values shown on Label ------------------------->  ",{"$f":"IF(M26=\"\",\"\",astm(L8*D19*M26/M20,0))","v":113},{"$f":"IF(M26=\"\",\"\",astm(L8*E19*M26/M20,0))","v":88},100,"<-------- Enter only voluntarily reduced combined MPG (or leave blank); "]
[null,null,null,null,null,null,null,null,null,"Voluntarily Increased kW-hr/100 mi values ------------------------->  ",{"$f":"IF(M26=\"\",\"\",astm((A53*0.1)/astm((L8*D19*M26/M20),4),0))","v":30},{"$f":"IF(M26=\"\",\"\",astm((A53*0.1)/astm((L8*E19*M26/M20),4),0))","v":38},{"$f":"IF(M26=\"\",\"\",astm((A53*0.1)/astm((L8*F19*M26/M20),4),0))","v":34},"                  (other values are automatically calculated)"]
[]
[]
["II.  Calculate the adjusted electric vehicle driving ranges using the SAE J1634  5-cycle Adjustment Factor or the 0.7 Adjustment Factor:"]
[]
[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 combined driving range*:",null,null,311.29300000000001,289.42,{"$f":"0.55*D35+0.45*E35","v":301.45015000000001},{"$f":"astm(F35,0)","v":301},"miles",null,"Unadjusted (SAE J1634)"]
["Calculate adjusted driving range (2017 D5C method, No Cap):",null,null,{"$f":"D35*(1-K19)","v":164.01088254847645},{"$f":"E35*(1-L19)","v":165.85202836879432},{"$f":"F35*(1-M19)","v":165.68268597673384},{"$f":"astm(F36,0)","v":166},"miles",null,"Adjusted driving range (derived 5-cycle method, No Cap) calculated for reference only"]
["Calculate adjusted driving range (5-cycle or 0.7 Adj Factor):",null,null,{"$f":"D35*L8","v":224.14341172000002},{"$f":"E35*L8","v":208.39397680000002},{"$f":"F35*L8","v":217.05616600600001},{"$f":"astm(F37,0)","v":217},"miles",null,"(Adjusted driving range using 5-cycle or 0.7 Adjustment Factor)"]
[null,null,null,{"$f":"D37*F38/F37","v":206.53033345646037},{"$f":"E37*F38/F37","v":192.01848133099287},{"$f":"G38","v":200},200,"miles ","<------------------------Enter Voluntary Reduced (Combined) Range Value shown on label"]
[null,null,"*Round input city and hwy range values to 3 decimal places"]
[null,null,"(Orange background = too many decimal places)"]
[]
[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,null,null,"Enter Average 2024MY 5-year Fuel Cost: ",9750,null,"(Whole number)"]
["City Intercept:",4.091E-3,null,null,null,null,"Enter 2024MY U.S. average electricity cost: ",0.15,"per kw-hr","(2 decimal places)"]
["City Slope:",1.1600999999999999,null,null,"     (from CD-2022-16 for 2024 model year)"]
["Hwy Intercept:",3.1909999999999998E-3,null,"Calculate unrounded adjusted combined miles/kw-hr:",null,null,null,{"$f":"IF(M26=\"\", 100/M21,100/ M27)","v":2.9411764705882355},"mi/kw-hr",null,null,null,"2024 Label",null,"2024 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":"H45","v":0.15},"per kw-hr",{"$f":"150*F51*M18","v":861.74999999999989},null," Derived 5-cycle method, No Cap (for reference only)",null,null,{"$f":"astm(H51/50,0) *50","v":850},null,{"$f":"$H$44 - 5*M51","v":5500}]
[null,null,null,null,15000,{"$f":"H45","v":0.15},"per kw-hr",{"$f":"15000*F52/H47","v":765},null," (Using SAE J1634 5-cycle or 0.7 Adjustment Factor)",null,null,{"$f":"astm(H52/50,0) *50","v":750},null,{"$f":"$H$44 - 5*M52","v":6000}]
[33705,"watt-hr/gallon"]
[null,null,null,null,null,null,"*Note: Annual fuel costs should be ASTM rounded to the nearest $50.",null,null,null,null,"**Note:  These values are used on the window stickers.  "]
[null,null,null,null,null,null,null,null,null,null,null,"(They may be different from the www.fueleconomy.gov values, "]
[null,null,null,null,null,null,null,null,null,null,null,"because www.fueleconomy.gov uses a floating fuel cost)."]