{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Revision List","CoverLetter","Summary","CFR Constants","Fleet std calculation","Fleet ave calculation","Adv Tech std calcs","Adv Tech Fleet ave calcs","HFC Emissions","ADCO2 Calcs"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":9,"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":"Revision List","index":0,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,0,3,4]]}
[]
["ABC HD 2b/3 Truck Company - 2022 CAFC/GHG Model Year Report"]
[]
["Revision List"]
[]
[]
["Revision Date",null,"Spread sheet name",null,"Description of Revision"]

{"sheet":"CoverLetter","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":2,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,4,25,5],[26,4,26,5],[0,0,0,13],[1,0,1,13],[22,4,22,5],[23,4,23,5],[24,4,24,5]]}
["Purpose and Scope of this Guidance Document   "]
["         This document was prepared by EPA's Office of Transportation and Air Quality (OTAQ).  It is intended to aid regulated parties in reporting fleet average Greenhouse Gas (GHG), Corporate Average Fuel Consumption (CAFC) values and calculating AB&T fleet average credits for heavy-duty class 2b and 3 vehicles, ref. 40 CFR 86.1819-14 and 49 CFR 535.5(a), 535.6(a), 535.7.  It contains EPA's recommended format for manufacturers to report to EPA their end-of-year GHG and CAFC calculations, credits and other information with respect to the implementation of the Phase 2 Greenhouse Gas Emissions and Fuel Efficiency Standards for Heavy-Duty Class 2b and 3 Pickup Trucks and Vans, ref. 81 FR 73478, October 25, 2016, including any subsequent revisions to those requirements. The use of this document is purely optional.\n       This document does not in any way alter or waive the requirements in EPA regulations.  Although the calculations and formulas provided in this document are intended to assist manufacturers in the implementation of EPA regulations, this document does not establish or change the legal rights or obligations of manufacturers or others in complying with EPA regulations, including 40 CFR 86.1865-12. If an error or other discrepancy is found in this document, including the calculation formulas, please contact your EPA certification team member.  The regulations take precedence."]
[]
[null,"Example Final Model Year HD 2b/3 Pickup & Van CAFC/GHG Credit Summary Report"]
[null,"Manufacturer: ____ABC HD 2b/3 Truck Company______"]
[null,"CO2 Credit Summary:"]
[null,"Fleet","Model Year","Target CO2 Standard (g/mile)","Manufacturer CO2 \n(g/mile)","U.S. Production Volume\n(units)","2021-2027MY Advanced Technology Credit Multiplier","CO2 150K Credit (Deficit) \n(Mg)","CO2 Credits Required for N2O Compliance \n(Mg)","CO2 Credits Required for CH4 Compliance \n(Mg)","CO2 Innovative Technology Credits \n(Mg)","Total CO2 Credits \n(Mg)","Date Credits Were Earned","Comments"]
[null,"Conventional",2022,{"$f":"'Fleet std calculation'!D12","v":470},{"$f":"'Fleet ave calculation'!D9","v":456},{"$f":"'Fleet std calculation'!C12","v":79920},1,{"$f":"ASTM((D8-E8)*F8*G8*150000/1000000,0)","v":167832},{"$f":"'Fleet ave calculation'!AE14","v":0},{"$f":"'Fleet ave calculation'!AF14","v":0},{"$f":"'Fleet ave calculation'!AH14","v":0},{"$f":"SUM(H8:K8)","v":167832},"2022-12-31"]
[null,"Advanced Technology -EV",2022,{"$f":"'Adv Tech std calcs'!E12","v":431},{"$f":"'Adv Tech Fleet ave calcs'!E9","v":0},{"$f":"'Adv Tech std calcs'!D12","v":46944},{"$f":"IF(C9>2027,1,4.5)","v":4.5},{"$f":"ASTM((D9-E9)*F9*G9*150000/1000000,0)","v":13657183},{"$f":"'Adv Tech Fleet ave calcs'!AG16","v":0},{"$f":"'Adv Tech Fleet ave calcs'!AH16","v":0},{"$f":"'Adv Tech Fleet ave calcs'!AJ16","v":0},{"$f":"SUM(H9:K9)","v":13657183},"2022-12-31"]
[null,"Advanced Technology - PHEV",2022,{"$f":"'Adv Tech std calcs'!E13","v":483},{"$f":"'Adv Tech Fleet ave calcs'!E10","v":51},{"$f":"'Adv Tech std calcs'!D13","v":29432},{"$f":"IF(C10>2027,1,3.5)","v":3.5},{"$f":"ASTM((D10-E10)*F10*G10*150000/1000000,0)","v":6675178},{"$f":"'Adv Tech Fleet ave calcs'!AG17","v":0},{"$f":"'Adv Tech Fleet ave calcs'!AH17","v":0},{"$f":"'Adv Tech Fleet ave calcs'!AJ17","v":0},{"$f":"SUM(H10:K10)","v":6675178},"2022-12-31"]
[null,"Advanced Technology - FCV",2022,{"$f":"'Adv Tech std calcs'!E14","v":496},{"$f":"'Adv Tech Fleet ave calcs'!E11","v":0},{"$f":"'Adv Tech std calcs'!D14","v":2072},{"$f":"IF(C11>2027,1,5.5)","v":5.5},{"$f":"ASTM((D11-E11)*F11*G11*150000/1000000,0)","v":847862},{"$f":"'Adv Tech Fleet ave calcs'!AG18","v":0},{"$f":"'Adv Tech Fleet ave calcs'!AH18","v":0},{"$f":"'Adv Tech Fleet ave calcs'!AJ18","v":0},{"$f":"SUM(H11:K11)","v":847862},"2022-12-31"]
[null,null,null,null,null,null,null,null,null,null,"Grand Total CO2 Credits for the Model Year:  ",{"$f":"SUM(L8:L11)","v":21348055},"2022-12-31"]
[]
[null,"Fuel Consumption (FC) Credit Summary:"]
[null,"Fleet","Model Year","Target FC Standard (gal/100 mile)","Manufacturer FC\n(gal/100 mile)","U.S. Production Volume\n(units)","2021-2027MY Advanced Technology Credit Multiplier","FC 150K Credit (Deficit) \n(gal)","FC Innovative Technology Credits \n(gal)","Total FC Credits \n(gal)","Date Credits Were Earned","Comments"]
[null,"Conventional",2022,{"$f":"'Fleet std calculation'!E12","v":5.2679999999999998},{"$f":"'Fleet ave calculation'!E9","v":5.1159999999999997},{"$f":"'Fleet std calculation'!C12","v":79920},1,{"$f":"ASTM((D16-E16)*F16*G16/100*150000,0)","v":18221760},{"$f":"'Fleet ave calculation'!AJ14","v":0},{"$f":"SUM(H16:I16)","v":18221760},"2022-12-31"]
[null,"Advanced Technology -EV",2022,{"$f":"'Adv Tech std calcs'!F12","v":4.2290000000000001},{"$f":"'Adv Tech Fleet ave calcs'!F9","v":0},{"$f":"'Adv Tech std calcs'!D12","v":46944},{"$f":"IF(C17>2027,1,4.5)","v":4.5},{"$f":"ASTM((D17-E17)*F17*G17/100*150000,0)","v":1340051688},{"$f":"'Adv Tech Fleet ave calcs'!AL16","v":0},{"$f":"SUM(H17:I17)","v":1340051688},"2022-12-31"]
[null,"Advanced Technology - PHEV",2022,{"$f":"'Adv Tech std calcs'!F13","v":5.4349999999999996},{"$f":"'Adv Tech Fleet ave calcs'!F10","v":0.57399999999999995},{"$f":"'Adv Tech std calcs'!D13","v":29432},{"$f":"IF(C18>2027,1,3.5)","v":3.5},{"$f":"ASTM((D18-E18)*F18*G18/100*150000,0)","v":751111998},{"$f":"'Adv Tech Fleet ave calcs'!AL17","v":0},{"$f":"SUM(H18:I18)","v":751111998},"2022-12-31"]
[null,"Advanced Technology - FCV",2022,{"$f":"'Adv Tech std calcs'!F14","v":4.8680000000000003},{"$f":"'Adv Tech Fleet ave calcs'!F11","v":0},{"$f":"'Adv Tech std calcs'!D14","v":2072},{"$f":"IF(C19>2027,1,5.5)","v":5.5},{"$f":"ASTM((D19-E19)*F19*G19/100*150000,0)","v":83213592},{"$f":"'Adv Tech Fleet ave calcs'!AL18","v":0},{"$f":"SUM(H19:I19)","v":83213592},"2022-12-31"]
[null,null,null,null,"Total:  ",{"$f":"SUM(F16:F19)","v":158368},null,null,"Grand Total FC Credits for the Model Year: ",{"$f":"SUM(J16:J19)","v":2192599038},"2022-12-31"]
[]
[null,"Minimum data requirements:"]
[null,"Fleet","Number of subconfig-urations","Number of \nactual vehicles tested","Rate of production volume by configuratilon represented by test data (%) --- [Must be > 90% per 40 CFR 86.1819-14(d)(9)(iii)]"]
[null,"Conventional",{"$f":"'Fleet ave calculation'!F9","v":17},{"$f":"'Fleet ave calculation'!G9","v":13},{"$f":"'Fleet ave calculation'!H9","v":1}]
[null,"Advanced Technology -EV",{"$f":"'Adv Tech Fleet ave calcs'!G9","v":3},{"$f":"'Adv Tech Fleet ave calcs'!H9","v":0},{"$f":"'Adv Tech Fleet ave calcs'!I9","v":1}]
[null,"Advanced Technology - PHEV",{"$f":"'Adv Tech Fleet ave calcs'!G10","v":4},{"$f":"'Adv Tech Fleet ave calcs'!H10","v":1},{"$f":"'Adv Tech Fleet ave calcs'!I10","v":1}]
[null,"Advanced Technology - FCV",{"$f":"'Adv Tech Fleet ave calcs'!G11","v":6},{"$f":"'Adv Tech Fleet ave calcs'!H11","v":0},{"$f":"'Adv Tech Fleet ave calcs'!I11","v":1}]

{"sheet":"CFR Constants","index":3,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,1,1,2],[1,3,1,4],[0,1,0,4]]}
[null,"Table 3 of § 86.1819-14"]
[null,"CO2 Constants",null,"FC Constants"]
[null,"A","B","C","D"]
["2021_Spark Ignition",4.2900000000000001E-2,331,4.8270000000000002E-4,3.7250000000000001]
["2022_Spark Ignition",4.1799999999999997E-2,322,4.7029999999999999E-4,3.6230000000000002]
["2023_Spark Ignition",4.0800000000000003E-2,314,4.5909999999999999E-4,3.5329999999999999]
["2024_Spark Ignition",3.9800000000000002E-2,306,4.4779999999999999E-4,3.4430000000000001]
["2025_Spark Ignition",3.8800000000000001E-2,299,4.3659999999999999E-4,3.3639999999999999]
["2026_Spark Ignition",3.78E-2,291,4.2529999999999998E-4,3.274]
["2027_Spark Ignition",3.6900000000000002E-2,284,4.1520000000000001E-4,3.1960000000000002]
["2028_Spark Ignition",{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2029_Spark Ignition",{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2030_Spark Ignition",{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2031_Spark Ignition",{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2032_Spark Ignition",{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2021_Compression Ignition",4.0599999999999997E-2,312,3.9879999999999999E-4,3.0649999999999999]
["2022_Compression Ignition",3.95E-2,304,3.88E-4,2.9860000000000002]
["2023_Compression Ignition",3.8600000000000002E-2,297,3.792E-4,2.9169999999999998]
["2024_Compression Ignition",3.7600000000000001E-2,289,3.6939999999999998E-4,2.839]
["2025_Compression Ignition",3.6700000000000003E-2,282,3.6049999999999998E-4,2.77]
["2026_Compression Ignition",3.5700000000000003E-2,275,3.5070000000000001E-4,2.7010000000000001]
["2027_Compression Ignition",3.4799999999999998E-2,268,3.4180000000000001E-4,2.633]
["2028_Compression Ignition",{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2029_Compression Ignition",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2030_Compression Ignition",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2031_Compression Ignition",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2032_Compression Ignition",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2021_EV/FCV-only",4.0599999999999997E-2,312,3.9879999999999999E-4,3.0649999999999999]
["2022_EV/FCV-only",3.95E-2,304,3.88E-4,2.9860000000000002]
["2023_EV/FCV-only",3.8600000000000002E-2,297,3.792E-4,2.9169999999999998]
["2024_EV/FCV-only",3.7600000000000001E-2,289,3.6939999999999998E-4,2.839]
["2025_EV/FCV-only",3.6700000000000003E-2,282,3.6049999999999998E-4,2.77]
["2026_EV/FCV-only",3.5700000000000003E-2,275,3.5070000000000001E-4,2.7010000000000001]
["2027_EV/FCV-only",3.4799999999999998E-2,268,3.4180000000000001E-4,2.633]
["2028_EV/FCV-only",{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2029_EV/FCV-only",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2030_EV/FCV-only",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2031_EV/FCV-only",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["2032_EV/FCV-only",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Fleet std calculation","index":4,"n_rows":43,"n_cols":31,"rows_kept":43,"cut":false,"hidden":false,"merged":[[13,1,13,9],[14,21,15,21],[14,1,15,1],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,10,15,10],[0,1,0,30],[1,8,1,27],[14,11,15,11],[14,25,15,25],[14,18,15,18],[14,8,15,8],[14,9,15,9],[14,22,15,22],[14,27,15,27],[14,26,15,26],[14,19,15,19],[14,16,15,16],[14,17,15,17],[13,30,15,30],[13,12,13,24],[13,25,13,27]]}
[null,"Purpose and Scope of this Guidance Document   "]
[null,null,null,null,null,null,null,null,"         This document was prepared by EPA's Office of Transportation and Air Quality (OTAQ).  It is intended to aid regulated parties in reporting fleet average Greenhouse Gas (GHG), Corporate Average Fuel Consumption (CAFC) values and calculating AB&T fleet average credits for heavy-duty class 2b and 3 vehicles, ref. 40 CFR 86.1819-14 and 49 CFR 535.5(a), 535.6(a), 535.7.  It contains EPA's recommended format for manufacturers to report to EPA their end-of-year GHG and CAFC calculations, credits and other information with respect to the implementation of the Phase 2 Greenhouse Gas Emissions and Fuel Efficiency Standards for Heavy-Duty Class 2b and 3 Pickup Trucks and Vans, ref. 81 FR 73478, October 25, 2016, including any subsequent revisions to those requirements. The use of this document is purely optional.\n       This document does not in any way alter or waive the requirements in EPA regulations.  Although the calculations and formulas provided in this document are intended to assist manufacturers in the implementation of EPA regulations, this document does not establish or change the legal rights or obligations of manufacturers or others in complying with EPA regulations, including 40 CFR 86.1865-12. If an error or other discrepancy is found in this document, including the calculation formulas, please contact your EPA certification team member.  The regulations take precedence."]
[]
[null,"Final HD Class 2b/3 CAFC/GHG Model Year Report  - CO2 and FC Fleet Average Standards Calculations"]
[null,"Manufacturer: ","ABC HD 2b/3 Truck Co."]
[null,"Model Year: ",2022,{"$f":"IF(C6='Fleet ave calculation'!C6,\"\",\"ERROR--Model Year of Conventional vehicle Fleet Standard calculation tab doesn't match the Model Year of the Conventional Vehicle Fleet Average Calculation tab;\")","v":""}]
[null,"Report: ","HD 2b/3 Conventional Fleet Final Model Year Report"]
[null,"EPA Phase 2 GHG Standards: ","ref. 40 CFR 86.1819-14(a)(2) or 86.1819-14(k)(4)(iii) Table 3;"]
[null,"NHTSA Phase 2 FC Standards: ","ref. 49 CFR 535.5(a)(2)(ii) Table 6"]
[]
[null,null,"AA. Total production volume","CC.  Fleet target CO2\n(gpm)","FF. Fleet target FC\n(gal/100 mile)"]
[null,null,{"$f":"IF($C$6>2023, SUM(Z17:AA17), SUM(Z17:AB17))","v":79920},{"$f":"ASTM(AC17/C12,0)","v":470},{"$f":"ASTM(AD17/C12,3)","v":5.2679999999999998},{"$f":"IF(C12='Fleet ave calculation'!C9,\"\",\"ERROR--Total production volume of Fleet std calculation tab doesn't match the Total production volume of the Fleet ave Calculation tab;\")","v":""}]
[]
[null,"Vehicle & Subconfiguration Information",null,null,null,null,null,null,null,null,null,null,"CO2 and FC Target Standard Information",null,null,null,null,null,null,null,null,null,null,null,null,"Production Volumes",null,null,null,null,"AE. \nComments"]
[null,"B.\nTruck Line Name & Description","C.\nTest Group","D.\nEngine Code","E.\nBase\nlevel","F.\nConfig.\nGroup","G.\nSub-\nconfig. Group Name","H.\n2 or 4 Wheel Drive","I.\nEngine","J.\nTrans Class","K.\nFinal Drive Ratio","L.\nRoad Load HP","M.\nGVWR","N.\nCurb Weight","O.\nGCWR","P.\nETW\n\n(ALVW)","Q. \nWork Factor","R.\nSpark Ignition or Compression Ignition ","S. \nA Target Coef","T. \nB Target Coef","U. \nCO2 Target Standard","V.\nC Target Coef","W.\nD Target Coef","X.\nConversion Factor","Y.\nFC Target Standard","Z.\nProduction volume  under Production volume  under 40 CFR 86.1819-14(a)","AA. \nProduction volume under 40 CFR 86.1819-14(j)\n\n(incomplete & sister vehicles)","AB. \nLoose Engine production volume under 86.1819-14(k)(8)\n\n(cannot be used after 2023MY)","AC.\nVol x Target CO2 Standard","AD.\n Vol x Target FC Standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,"lbs.","lbs.","lbs.","lbs.",null,null,null,null,"gpm",null,null,"gCO2/gal","gal/100 miles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z18:Z42)","v":79920},{"$f":"SUM(AA18:AA42)","v":0},{"$f":"IF($C$6>2023,0,SUM(AB18:AB42))","v":0},{"$f":"SUM(AC18:AC42)","v":37531472},{"$f":"SUM(AD18:AD42)","v":421013.09600000002}]
[null,"1500 Cargo VAN Trim Level A","NXXXD02.5XXX","AA5",1,1,1,"2wd","2.5L","L6",3.3570000000000002,22.4,8750,5836,13400,7500,{"$f":"ASTM(0.75*(M18-N18+IF(H18=\"4wd\",500, 0))+0.25*(O18-M18),0)","v":3348},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R18),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R18),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S18),ISERROR(Q18),ISERROR(T18)),1/0,ASTM(S18*Q18+T18,0))","v":462},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R18),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R18),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},{"$f":"IF(R18=\"\",\"\",IF(R18=\"Spark Ignition\",8887,10180))","v":8887},{"$f":"IF(OR(ISERROR(V18),ISERROR(Q18),ISERROR(W18)),1/0,ASTM(V18*Q18+W18,3))","v":5.1980000000000004},18736,0,0,{"$f":"IF(R18=\"\",\"\",IF($C$6>2023, SUM(Z18:AA18)*U18,SUM(Z18:AB18)*U18))","v":8656032},{"$f":"IF(R18=\"\",\"\",IF($C$6>2023, SUM(Z18:AA18)*Y18,SUM(Z18:AB18)*Y18))","v":97389.728000000003}]
[null,"2500 Cargo VAN Trim Level  A",null,null,null,null,null,"2wd","2.5L","L6",3.3570000000000002,22.4,9100,5832,13400,7500,{"$f":"ASTM(0.75*(M19-N19+IF(H19=\"4wd\",500, 0))+0.25*(O19-M19),0)","v":3526},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R19),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R19),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S19),ISERROR(Q19),ISERROR(T19)),1/0,ASTM(S19*Q19+T19,0))","v":469},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R19),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R19),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V19),ISERROR(Q19),ISERROR(W19)),1/0,ASTM(V19*Q19+W19,3))","v":5.2809999999999997},7928,0,0,{"$f":"IF(R19=\"\",\"\",IF($C$6>2023, SUM(Z19:AA19)*U19,SUM(Z19:AB19)*U19))","v":3718232},{"$f":"IF(R19=\"\",\"\",IF($C$6>2023, SUM(Z19:AA19)*Y19,SUM(Z19:AB19)*Y19))","v":41867.767999999996}]
[null,"2500 Cargo VAN Trim Level B",null,null,null,null,null,"2wd","2.5L","L6",3.3570000000000002,22.4,9100,5992,13400,7500,{"$f":"ASTM(0.75*(M20-N20+IF(H20=\"4wd\",500, 0))+0.25*(O20-M20),0)","v":3406},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R20),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R20),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S20),ISERROR(Q20),ISERROR(T20)),1/0,ASTM(S20*Q20+T20,0))","v":464},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R20),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R20),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V20),ISERROR(Q20),ISERROR(W20)),1/0,ASTM(V20*Q20+W20,3))","v":5.2249999999999996},1800,0,0,835200,9405]
[null,"2500 Cargo VAN Trim Level A (Hi roof)",null,null,null,null,2,"2wd","2.5L","L6",3.3570000000000002,24,9100,{"$f":"2*P21-M21","v":5900},13400,7500,{"$f":"ASTM(0.75*(M21-N21+IF(H21=\"4wd\",500, 0))+0.25*(O21-M21),0)","v":3475},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R21),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R21),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S21),ISERROR(Q21),ISERROR(T21)),1/0,ASTM(S21*Q21+T21,0))","v":467},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R21),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R21),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V21),ISERROR(Q21),ISERROR(W21)),1/0,ASTM(V21*Q21+W21,3))","v":5.2569999999999997},13872,0,0,6478224,72925.103999999992,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Cargo VAN Trim Level B (Hi roof)",null,null,null,null,null,"2wd","2.5L","L6",3.3570000000000002,24,9100,{"$f":"2*P22-M22","v":5900},13400,7500,{"$f":"ASTM(0.75*(M22-N22+IF(H22=\"4wd\",500, 0))+0.25*(O22-M22),0)","v":3475},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R22),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R22),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S22),ISERROR(Q22),ISERROR(T22)),1/0,ASTM(S22*Q22+T22,0))","v":467},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R22),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R22),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V22),ISERROR(Q22),ISERROR(W22)),1/0,ASTM(V22*Q22+W22,3))","v":5.2569999999999997},944,0,0,440848,4962.6079999999993,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"3500 Passenger VAN Trim Level A",null,null,null,null,3,"2wd","2.5L","L6",3.3570000000000002,22.9,9520,{"$f":"2*P23-M23","v":6480},13400,8000,{"$f":"ASTM(0.75*(M23-N23+IF(H23=\"4wd\",500, 0))+0.25*(O23-M23),0)","v":3250},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R23),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R23),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S23),ISERROR(Q23),ISERROR(T23)),1/0,ASTM(S23*Q23+T23,0))","v":458},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R23),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R23),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V23),ISERROR(Q23),ISERROR(W23)),1/0,ASTM(V23*Q23+W23,3))","v":5.1509999999999998},3664,0,0,1678112,18873.263999999999,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Cargo VAN Trim Level A (Hi roof)","NXXXD03.6YYY","AA6",2,2,4,"2wd","3.6L","L8",3.3570000000000002,22.4,9100,{"$f":"2*P24-M24","v":5900},16000,7500,{"$f":"ASTM(0.75*(M24-N24+IF(H24=\"4wd\",500, 0))+0.25*(O24-M24),0)","v":4125},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R24),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R24),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S24),ISERROR(Q24),ISERROR(T24)),1/0,ASTM(S24*Q24+T24,0))","v":494},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R24),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R24),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V24),ISERROR(Q24),ISERROR(W24)),1/0,ASTM(V24*Q24+W24,3))","v":5.5629999999999997},1656,0,0,818064,9212.3279999999995,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Cargo VAN Trim Level A (Hi roof)",null,null,null,null,5,"2wd","3.6L","L8",3.3570000000000002,24,9100,{"$f":"2*P25-M25","v":5900},16000,7500,{"$f":"ASTM(0.75*(M25-N25+IF(H25=\"4wd\",500, 0))+0.25*(O25-M25),0)","v":4125},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R25),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R25),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S25),ISERROR(Q25),ISERROR(T25)),1/0,ASTM(S25*Q25+T25,0))","v":494},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R25),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R25),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V25),ISERROR(Q25),ISERROR(W25)),1/0,ASTM(V25*Q25+W25,3))","v":5.5629999999999997},1424,0,0,703456,7921.7119999999995,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"3500 Passenger VAN Trim Level B",null,null,null,null,6,"2wd","3.6L","L8",3.3570000000000002,22.9,9480,7209,16000,8500,{"$f":"ASTM(0.75*(M26-N26+IF(H26=\"4wd\",500, 0))+0.25*(O26-M26),0)","v":3333},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R26),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R26),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S26),ISERROR(Q26),ISERROR(T26)),1/0,ASTM(S26*Q26+T26,0))","v":461},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R26),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R26),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V26),ISERROR(Q26),ISERROR(W26)),1/0,ASTM(V26*Q26+W26,3))","v":5.1909999999999998},16752,0,0,7722672,86959.631999999998]
[null,"3500 Cargo VAN Trim Level A",null,null,null,null,null,"2wd","3.6L","L8",3.3570000000000002,22.9,9900,6878,16000,8500,{"$f":"ASTM(0.75*(M27-N27+IF(H27=\"4wd\",500, 0))+0.25*(O27-M27),0)","v":3792},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R27),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R27),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S27),ISERROR(Q27),ISERROR(T27)),1/0,ASTM(S27*Q27+T27,0))","v":481},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R27),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R27),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V27),ISERROR(Q27),ISERROR(W27)),1/0,ASTM(V27*Q27+W27,3))","v":5.4059999999999997},824,0,0,396344,4454.5439999999999]
[null,"3500 Cargo VAN Trim Level B",null,null,null,null,null,"2wd","3.6L","L8",3.3570000000000002,22.9,9900,6975,16000,8500,{"$f":"ASTM(0.75*(M28-N28+IF(H28=\"4wd\",500, 0))+0.25*(O28-M28),0)","v":3719},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R28),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R28),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S28),ISERROR(Q28),ISERROR(T28)),1/0,ASTM(S28*Q28+T28,0))","v":477},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R28),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R28),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V28),ISERROR(Q28),ISERROR(W28)),1/0,ASTM(V28*Q28+W28,3))","v":5.3719999999999999},3032,0,0,1446264,16287.904]
[null,"3500 Cargo VAN Trim Level A (Hi roof)",null,null,null,null,7,"2wd","3.6L","L8",3.3570000000000002,24.5,9900,{"$f":"2*P29-M29","v":6100},16000,8000,{"$f":"ASTM(0.75*(M29-N29+IF(H29=\"4wd\",500, 0))+0.25*(O29-M29),0)","v":4375},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R29),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R29),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S29),ISERROR(Q29),ISERROR(T29)),1/0,ASTM(S29*Q29+T29,0))","v":505},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R29),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R29),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V29),ISERROR(Q29),ISERROR(W29)),1/0,ASTM(V29*Q29+W29,3))","v":5.681},1088,0,0,549440,6180.9279999999999,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"3500 Cargo VAN Trim Level B  (Hi roof)",null,null,null,null,null,"2wd","3.6L","L8",3.3570000000000002,24.5,9900,{"$f":"2*P30-M30","v":6100},16000,8000,{"$f":"ASTM(0.75*(M30-N30+IF(H30=\"4wd\",500, 0))+0.25*(O30-M30),0)","v":4375},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R30),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R30),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S30),ISERROR(Q30),ISERROR(T30)),1/0,ASTM(S30*Q30+T30,0))","v":505},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R30),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R30),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V30),ISERROR(Q30),ISERROR(W30)),1/0,ASTM(V30*Q30+W30,3))","v":5.681},4656,0,0,2351280,26450.736000000001,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level A    Short Cab",null,"AA2",null,3,8,"2wd","3.6L","L8",3.3570000000000002,"21.2",8600,5743,17700,7000,{"$f":"ASTM(0.75*(M31-N31+IF(H31=\"4wd\",500, 0))+0.25*(O31-M31),0)","v":4418},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R31),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R31),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S31),ISERROR(Q31),ISERROR(T31)),1/0,ASTM(S31*Q31+T31,0))","v":507},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R31),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R31),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V31),ISERROR(Q31),ISERROR(W31)),1/0,ASTM(V31*Q31+W31,3))","v":5.7009999999999996},272,0,0,137904,1550.6719999999998]
[null,"2500 Pickup-Trim Level A   4-door Cab",null,null,null,null,9,"2wd","3.6L","L8",3.3570000000000002,"20.7",8600,{"$f":"2*P32-M32","v":6400},17700,7500,{"$f":"ASTM(0.75*(M32-N32+IF(H32=\"4wd\",500, 0))+0.25*(O32-M32),0)","v":3925},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R32),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R32),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S32),ISERROR(Q32),ISERROR(T32)),1/0,ASTM(S32*Q32+T32,0))","v":486},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R32),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R32),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V32),ISERROR(Q32),ISERROR(W32)),1/0,ASTM(V32*Q32+W32,3))","v":5.4690000000000003},104,0,0,50544,568.77600000000007,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level C  4-door (20\" Tire)",null,null,null,null,10,"2wd","3.6L","L8",3.3570000000000002,"21.3",8600,6426,16900,7500,{"$f":"ASTM(0.75*(M33-N33+IF(H33=\"4wd\",500, 0))+0.25*(O33-M33),0)","v":3706},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R33),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R33),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S33),ISERROR(Q33),ISERROR(T33)),1/0,ASTM(S33*Q33+T33,0))","v":477},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R33),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R33),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V33),ISERROR(Q33),ISERROR(W33)),1/0,ASTM(V33*Q33+W33,3))","v":5.3659999999999997},16,0,0,7632,85.855999999999995]
[null,"2500 Pickup-Trim Level B  4-door (20\" Tire)",null,null,null,null,null,"2wd","3.6L","L8",3.3570000000000002,"21.3",8600,6408,16900,7500,{"$f":"ASTM(0.75*(M34-N34+IF(H34=\"4wd\",500, 0))+0.25*(O34-M34),0)","v":3719},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R34),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R34),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S34),ISERROR(Q34),ISERROR(T34)),1/0,ASTM(S34*Q34+T34,0))","v":477},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R34),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R34),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V34),ISERROR(Q34),ISERROR(W34)),1/0,ASTM(V34*Q34+W34,3))","v":5.3719999999999999},120,0,0,57240,644.64]
[null,"2500 Pickup-Trim Level A  Extended Cab",null,null,null,null,null,"2wd","3.6L","L8",3.3570000000000002,21.3,8600,5940,17700,7500,{"$f":"ASTM(0.75*(M35-N35+IF(H35=\"4wd\",500, 0))+0.25*(O35-M35),0)","v":4270},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R35),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R35),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S35),ISERROR(Q35),ISERROR(T35)),1/0,ASTM(S35*Q35+T35,0))","v":500},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R35),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R35),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V35),ISERROR(Q35),ISERROR(W35)),1/0,ASTM(V35*Q35+W35,3))","v":5.6310000000000002},272,0,0,136000,1531.6320000000001,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level D   Extended Cab",null,null,null,null,11,"4wd","3.6L","L8",3.3570000000000002,"23.9",8800,{"$f":"2*P36-M36","v":6200},17700,7500,{"$f":"ASTM(0.75*(M36-N36+IF(H36=\"4wd\",500, 0))+0.25*(O36-M36),0)","v":4550},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R36),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R36),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(S36),ISERROR(Q36),ISERROR(T36)),1/0,ASTM(S36*Q36+T36,0))","v":512},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R36),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R36),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(V36),ISERROR(Q36),ISERROR(W36)),1/0,ASTM(V36*Q36+W36,3))","v":5.7629999999999999},688,0,0,352256,3964.944,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level A Extended Cab","NXXXD04.0ZZZ","AA-10",3,"4*",12,"2wd","4.0L-Turbo","L6",3.9159999999999999,23.5,8800,6200,19450,7500,{"$f":"ASTM(0.75*(M37-N37+IF(H37=\"4wd\",500, 0))+0.25*(O37-M37),0)","v":4612},"Compression Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R37),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R37),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(S37),ISERROR(Q37),ISERROR(T37)),1/0,ASTM(S37*Q37+T37,0))","v":486},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R37),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R37),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(V37),ISERROR(Q37),ISERROR(W37)),1/0,ASTM(V37*Q37+W37,3))","v":4.7750000000000004},80,0,0,38880,382,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level A   Short Cab",null,null,null,null,13,"2wd","4.0L-Turbo","L6",3.9159999999999999,23.9,8800,6200,19450,7500,{"$f":"ASTM(0.75*(M38-N38+IF(H38=\"4wd\",500, 0))+0.25*(O38-M38),0)","v":4612},"Compression Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R38),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R38),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(S38),ISERROR(Q38),ISERROR(T38)),1/0,ASTM(S38*Q38+T38,0))","v":486},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R38),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R38),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(V38),ISERROR(Q38),ISERROR(W38)),1/0,ASTM(V38*Q38+W38,3))","v":4.7750000000000004},8,0,0,3888,38.200000000000003,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level A   4-door Cab",null,null,null,null,14,"2wd","4.0L-Turbo","L6",3.9159999999999999,22.9,8800,7200,19450,8000,{"$f":"ASTM(0.75*(M39-N39+IF(H39=\"4wd\",500, 0))+0.25*(O39-M39),0)","v":3862},"Compression Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R39),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R39),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(S39),ISERROR(Q39),ISERROR(T39)),1/0,ASTM(S39*Q39+T39,0))","v":457},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R39),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R39),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(V39),ISERROR(Q39),ISERROR(W39)),1/0,ASTM(V39*Q39+W39,3))","v":4.484},32,0,0,14624,143.488,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level B    4-door Cab",null,null,null,null,15,"2wd","4.0L-Turbo","L6",3.9159999999999999,23.6,8800,7200,19450,8000,{"$f":"ASTM(0.75*(M40-N40+IF(H40=\"4wd\",500, 0))+0.25*(O40-M40),0)","v":3862},"Compression Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R40),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R40),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(S40),ISERROR(Q40),ISERROR(T40)),1/0,ASTM(S40*Q40+T40,0))","v":457},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R40),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R40),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(V40),ISERROR(Q40),ISERROR(W40)),1/0,ASTM(V40*Q40+W40,3))","v":4.484},16,0,0,7312,71.744,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level B  Extended Cab",null,null,null,null,16,"2wd","4.0L-Turbo","L6",3.9159999999999999,24,8800,7200,19450,8000,{"$f":"ASTM(0.75*(M41-N41+IF(H41=\"4wd\",500, 0))+0.25*(O41-M41),0)","v":3862},"Compression Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R41),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R41),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(S41),ISERROR(Q41),ISERROR(T41)),1/0,ASTM(S41*Q41+T41,0))","v":457},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R41),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R41),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(V41),ISERROR(Q41),ISERROR(W41)),1/0,ASTM(V41*Q41+W41,3))","v":4.484},8,0,0,3656,35.872,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"2500 Pickup-Trim Level A   4-door Cab",null,"AA-20",null,null,17,"4wd","4.0L-Turbo","L6",3.9159999999999999,24.4,8990,7010,19450,8000,{"$f":"ASTM(0.75*(M42-N42+IF(H42=\"4wd\",500, 0))+0.25*(O42-M42),0)","v":4475},"Compression Ignition",{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R42),'CFR Constants'!$A$4:$E$27,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R42),'CFR Constants'!$A$4:$E$27,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(S42),ISERROR(Q42),ISERROR(T42)),1/0,ASTM(S42*Q42+T42,0))","v":481},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R42),'CFR Constants'!$A$4:$E$27,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($C$6,\"_\",$R42),'CFR Constants'!$A$4:$E$27,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(V42),ISERROR(Q42),ISERROR(W42)),1/0,ASTM(V42*Q42+W42,3))","v":4.7220000000000004},1928,0,0,927368,9104.0160000000014,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,null,null,"* Configuration number is combined because actual engine and ECM  is one specification in spite of  two engine codes."]

{"sheet":"Fleet ave calculation","index":5,"n_rows":33,"n_cols":44,"rows_kept":33,"cut":false,"hidden":false,"merged":[[24,16,25,16],[24,1,25,1],[24,22,25,22],[24,20,25,20],[24,15,25,15],[24,14,25,14],[24,13,25,13],[24,12,25,12],[24,11,25,11],[24,19,25,19],[24,18,25,18],[24,6,25,6],[24,17,25,17],[24,7,25,7],[24,21,25,21],[24,36,25,36],[24,34,25,34],[24,32,25,32],[24,24,25,24],[24,23,25,23],[11,38,11,39],[10,42,12,42],[10,43,12,43],[11,1,12,1],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[11,17,12,17],[11,18,12,18],[11,21,12,21],[11,34,11,35],[11,11,12,11],[11,13,12,13],[11,15,12,15],[11,16,12,16],[0,1,0,43],[1,12,1,29],[10,34,10,35],[11,40,11,41],[11,23,12,23],[11,24,12,24],[11,25,12,25],[11,32,11,33],[11,9,12,9],[11,10,12,10],[10,1,10,9],[10,15,10,18],[10,28,10,29],[10,30,10,33],[10,19,10,27],[10,36,10,41]]}
[null,"Purpose and Scope of this Guidance Document   "]
[null,null,null,null,null,null,null,null,null,null,null,null,"This document was prepared by EPA's Office of Transportation and Air Quality (OTAQ).  It is intended to aid regulated parties in reporting fleet average Greenhouse Gas (GHG), Corporate Average Fuel Consumption (CAFC) values and calculating AB&T fleet average credits for heavy-duty class 2b and 3 vehicles, ref. 40 CFR 86.1819-14 and 49 CFR 535.5(a), 535.6(a), 535.7.  It contains EPA's recommended format for manufacturers to report to EPA their end-of-year GHG and CAFC calculations, credits and other information with respect to the implementation of the Phase 2 Greenhouse Gas Emissions and Fuel Efficiency Standards for Heavy-Duty Class 2b and 3 Pickup Trucks and Vans, ref. 81 FR 73478, October 25, 2016, including any subsequent revisions to those requirements. The use of this document is purely optional.\n       This document does not in any way alter or waive the requirements in EPA regulations.  Although the calculations and formulas provided in this document are intended to assist manufacturers in the implementation of EPA regulations, this document does not establish or change the legal rights or obligations of manufacturers or others in complying with EPA regulations, including 40 CFR 86.1865-12. If an error or other discrepancy is found in this document, including the calculation formulas, please contact your EPA certification team member.  The regulations take precedence."]
[]
[null,"Final HD Class 2b/3 CAFC/GHG Model Year Report  - CO2 and FC Fleet Average Performance Calculations"]
[null,"Manufacturer","ABC HD 2b/3 Truck Co"]
[null,"Model Year ",2022,{"$f":"IF(C6='Fleet std calculation'!C6,\"\",\"ERROR--Model Year of Conventional vehicle Fleet Standard calculation tab doesn't match the Model Year of the Conventional Vehicle Fleet Average Calculation tab;\")","v":""}]
[]
[null,null,"AA. Total production volume","BB. Fleet average CO2 (gpm)","EE. Fleet average FC \n(gal/100 mile)","Number of Subconfigurations","Number of vehicles\nActually tested","Rate of production volume represented by test data\n(%)"]
[null,null,{"$f":"IF($C$6>2023, SUM(P14:Q14), SUM(P14:R14))","v":79920},{"$f":"ASTM(Z14/C9,0)","v":456},{"$f":"ASTM(AD14/C9,3)","v":5.1159999999999997},{"$f":" COUNT(G15:G302)","v":17},{"$f":"AK32","v":13},1,{"$f":"IF(C9='Fleet std calculation'!C12,\"\",\"ERROR--Total production volume of Fleet std calculation tab doesn't match the Total production volume of the Fleet ave Calculation tab;\")","v":""}]
[]
[null,"Subconfiguration Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Production Volumes",null,null,null,"GHG Compliance Level+T9 (see instructions)",null,null,null,null,null,null,null,null,"FC Compliance Level",null,"GHG Credits",null,null,null,"FC Credits",null,"Test information",null,null,null,null,null,"AM.\nIn-use CO2 standard","AN. \nComments"]
[null,"B.\nTruck Line Name and Description","C.\nTest Group","D.\nEngine Code","E.\nBase\nlevel\n(test group/ transmission type)","F.\nConfig.\nGroup","G.\nSub-\nconfig. Group Name","H.\n2 or 4 Wheel Drive","I.\nEngine","J.\nTrans Class","K.\nFinal Drive Ratio","L.\nRoad Load HP","M.\nETW\n\n(ALVW)","N.\nSpark Ignition or Compression Ignition","O.\nConversion Factor","P.\nProduction volume  under 40 CFR 86.1819-14(a)","Q. \nProduction volume under 40 CFR 86.1819-14(j)\n\n(incomplete & sister vehicles)","R. \nLoose Engine production volume under 40 CFR 86.1819-14(k)(8)\n\n(cannot be used after 2023MY)","S.\nSales fraction\nin DVC (config)\n","T. \nRLC (subconfig)\nCO2 emis-sions","U.\nDVC (config)\nCO2\nemis-sions","V.\nSales fraction\nin BL","W.\nBase Level\nCO2\nemssions","X. \nCO2 Value based on ADC?","Y. \nIf ADC derived, Test vehicle ID and Conf. that is source of CO2base","Z. \nVol x CO2 ","AA. \nN2O FEL","AB. \nCH4 FEL","AC.\nBase Level\nFuel Consumption \n(FC)","AD.\nVol x FC","AE.\n  CO2 Credits required for 150K N2O compliance","AF.  \nCO2 Credits req'd for 150K CH4 compliance \n(Using Global Warming Potential = 34)","AG.\nOff Cycle (Innovative Technology)\n150K CO2 credits\n\n[Prior EPA approval required]",null,"AH.\nInnovative and Off Cycle \n150K FC credits",null,"AI.\nNo. of RLCs\ncovered by\natual test","AJ.\nTest Vehicle ID/Config.","AK.\nTest Number",null,"AL.\nTest Result (CO2)\n\n(Round to nearest whole number)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"lbs.",null,"grams CO2/gal ",null,null,null,null,"gpm","gpm",null,"gpm",null,null,null,"gpm","gpm","gal/100-mile",null,"megagrams","megagrams","gpm","megagrams","gal/100 mile","gallons",null,null,"CITY","HWY","CITY","HWY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P15:P32)","v":79920},{"$f":"SUM(Q15:Q32)","v":0},{"$f":"IF($C$6>2023,0,SUM(R15:R32))","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Z15:Z32)","v":36448002.400000006},null,null,null,{"$f":"SUM(AD15:AD32)","v":408846.90399999998},{"$f":"SUM(AE15:AE32)","v":0},{"$f":"SUM(AF15:AF32)","v":0},null,{"$f":"SUM(AH15:AH32)","v":0},null,{"$f":"SUM(AJ15:AJ32)","v":0}]
[null,"1500 Cargo VAN - Trim Level A\n2500 Cargo VAN - Trim Level A, B","NXXXD02.5XXX\n","AA5",1,1,1,"2wd","2.5L","L6",3.3570000000000002,22.4,7500,"Spark Ignition",{"$f":"IF(N15=\"\",\"\",IF(N15=\"Spark Ignition\",8887,10180))","v":8887},28464,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P15:Q15)/SUM($P$15:$Q$17),SUM(P15:R15)/SUM($P$15:$R$17)),4)","v":0.60629999999999995},{"$f":"ASTM(AO15*0.55+AP15*0.45,1)","v":447.9},{"$f":"ASTM(SUMPRODUCT(S15:S17,T15:T17),1)","v":450.7},1,{"$f":"ASTM(U15,1)","v":450.7},"No","NA",{"$f":"(IF($C$6>2023,SUM(P15:Q17)*W15,SUM(P15:R17)*W15))","v":21157660.800000001},0.05,0.05,{"$f":"ASTM(W15/O15*100,3)","v":5.0709999999999997},{"$f":"(IF($C$6>2023,SUM(P15:Q17)*AC15,SUM(P15:R17)*AC15))","v":238053.02399999998},{"$f":"ASTM(IF(AA15>0.05,-1*(AA15-0.05)*298*SUM(Q15:S17)*150000/1000000,0),0)","v":0},{"$f":"ASTM(IF(AB15>0.05,-1*(AB15-0.05)*34*SUM(Q15:S17)*150000/1000000,0),0)","v":0},0,{"$f":"IF(AG15=\"\",0,  ASTM(AG15*SUM(P15:Q15)*150000/1000000,0))","v":0},{"$f":"IF(AG15=\"\",0,AG15/O15*100)","v":0},{"$f":" ASTM(AG15/O15,4)*150000*SUM(P15:R15)","v":0},1,"E350/02","NXXX1004909X","NXXX1004909X",546,328,{"$f":"ASTM(T15*1.1,0)","v":493}]
[null,"2500 Cargo VAN  - Trim Level A, B (Hi roof)",null,null,null,null,2,"2wd","2.5L","L6",3.3570000000000002,24,7500,"Spark Ignition",8887,14816,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P16:Q16)/SUM($P$15:$Q$17),SUM(P16:R16)/SUM($P$15:$R$17)),4)","v":0.31559999999999999},{"$f":"ASTM(AO16*0.55+AP16*0.45,1)","v":454.4},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG16=\"\",0,  ASTM(AG16*SUM(P16:Q16)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG16/O16,4)*150000*SUM(P16:Q16)","v":0},2,"E350/03","NXXX1004908X","NXXX1004908X",553,334,{"$f":"ASTM(T16*1.1,0)","v":500}]
[null,"3500 Passenger VAN - Trim Level A",null,null,null,null,3,"2wd","2.5L","L6",3.3570000000000002,22.9,8000,"Spark Ignition",8887,3664,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P17:Q17)/SUM($P$15:$Q$17),SUM(P17:R17)/SUM($P$15:$R$17)),4)","v":7.8100000000000003E-2},{"$f":"ASTM(AO17*0.55+AP17*0.45,1)","v":456.9},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG17=\"\",0,  ASTM(AG17*SUM(P17:Q17)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG17/O17,4)*150000*SUM(P17:Q17)","v":0},3,"E350/01","NXXX9100366X","NXXX9100366X",564,326,{"$f":"ASTM(T17*1.1,0)","v":503}]
[null,"2500 Cargo VAN - Trim Level A","NXXXD03.6YYY","AA6",2,2,4,"2wd","3.6L","L8",3.3570000000000002,22.4,7500,"Spark Ignition",8887,1656,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P18:Q18)/SUM($P$18:$Q$21),SUM(P18:R18)/SUM($P$18:$R$21)),4)","v":5.6300000000000003E-2},{"$f":"ASTM(AO18*0.55+AP18*0.45,1)","v":450.2},{"$f":"ASTM(SUMPRODUCT(S18:S21,T18:T21),1)","v":466.8},{"$f":"ASTM(IF($C$6>2023,SUM(P18:Q21)/SUM($P$18:$Q$26),SUM(P18:R21)/SUM($P$18:$R$26)),4)","v":0.95240000000000002},{"$f":"ASTM(U18*V18+U22*V22,1)","v":466.1},"No","NA",{"$f":"(IF($C$6>2023,SUM(P18:Q26)*W18,SUM(P18:R26)*W18))","v":14404354.4},0.05,0.05,{"$f":"ASTM(W18/O18*100,3)","v":5.2450000000000001},{"$f":"(IF($C$6>2023,SUM(P18:Q26)*AC18,SUM(P18:R26)*AC18))","v":162091.48000000001},{"$f":"ASTM(IF(AA18>0.05,-1*(AA18-0.05)*298*SUM(P18:R22)*150000/1000000,0),0)","v":0},{"$f":"ASTM(IF(AB18>0.05,-1*(AB18-0.05)*34*SUM(P18:R22)*150000/1000000,0),0)","v":0},0,{"$f":"IF(AG18=\"\",0,  ASTM(AG18*SUM(P18:Q18)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG18/O18,4)*150000*SUM(P18:Q18)","v":0},4,"B237/05","MXXX1004494X","MXXX1004495X",547,332,{"$f":"ASTM(T18*1.1,0)","v":495}]
[null,"2500 Cargo VAN - Trim Level A (Hi roof)",null,null,null,null,5,"2wd","3.6L","L8",3.3570000000000002,24,7500,"Spark Ignition",8887,1424,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P19:Q19)/SUM($P$18:$Q$21),SUM(P19:R19)/SUM($P$18:$R$21)),4)","v":4.8399999999999999E-2},{"$f":"ASTM(AO19*0.55+AP19*0.45,1)","v":454.1},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG19=\"\",0,  ASTM(AG19*SUM(P19:Q19)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG19/O19,4)*150000*SUM(P19:Q19)","v":0},5,"B237/04","MXXX1004494X","MXXX1004494X",545,343,{"$f":"ASTM(T19*1.1,0)","v":500}]
[null,"3500 Passenger VAN - Trim Level B\n3500 Cargo VAN - Trim Level A, B",null,null,null,null,6,"2wd","3.6L","L8",3.3570000000000002,22.9,8500,"Spark Ignition",8887,20608,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P20:Q20)/SUM($P$18:$Q$21),SUM(P20:R20)/SUM($P$18:$R$21)),4)","v":0.70020000000000004},{"$f":"ASTM(AO20*0.55+AP20*0.45,1)","v":468.7},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG20=\"\",0,  ASTM(AG20*SUM(P20:Q20)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG20/O20,4)*150000*SUM(P20:Q20)","v":0},6,"B237/03","MXXX1004494X","MXXX1004494X",574,340,{"$f":"ASTM(T20*1.1,0)","v":516}]
[null,"3500 Cargo VAN - Trim Level A, B  (Hi roof)",null,null,null,null,7,"2wd","3.6L","L8",3.3570000000000002,24.5,8000,"Spark Ignition",8887,5744,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P21:Q21)/SUM($P$18:$Q$21),SUM(P21:R21)/SUM($P$18:$R$21)),4)","v":0.19520000000000001},{"$f":"ASTM(AO21*0.55+AP21*0.45,1)","v":467.8},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG21=\"\",0,  ASTM(AG21*SUM(P21:Q21)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG21/O21,4)*150000*SUM(P21:Q21)","v":0},7,"B237/02","MXXX1004495X","MXXX1004495X",569,344,{"$f":"ASTM(T21*1.1,0)","v":515}]
[null,"2500 Pickup-Trim Level A  Short Cab",null,"AA2",null,3,8,"2wd","3.6L","L8",3.3570000000000002,21.2,7000,"Spark Ignition",8887,272,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P22:Q22)/SUM($P$22:$Q$26),SUM(P22:R22)/SUM($P$22:$R$26)),4)","v":0.18479999999999999},{"$f":"'ADCO2 Calcs'!AJ9","v":420},{"$f":"ASTM(SUMPRODUCT(S22:S26,T22:T26),1)","v":451.7},{"$f":"ASTM(IF($C$6>2023,SUM(P22:Q25)/SUM($P$18:$Q$26),SUM(P22:R25)/SUM($P$18:$R$26)),4)","v":4.7600000000000003E-2},null,"Yes","B022/00",null,null,null,null,null,null,null,0,{"$f":"IF(AG22=\"\",0,  ASTM(AG22*SUM(P22:Q22)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG22/O22,4)*150000*SUM(P22:Q22)","v":0},"ADC",null,null,null,null,null,{"$f":"ASTM(T22*1.1,0)","v":462}]
[null,"2500 Pickup-Trim Level A  4-door Cab",null,null,null,null,9,"2wd","3.6L","L8",3.3570000000000002,20.7,7500,"Spark Ignition",8887,104,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P23:Q23)/SUM($P$22:$Q$26),SUM(P23:R23)/SUM($P$22:$R$26)),4)","v":7.0699999999999999E-2},{"$f":"'ADCO2 Calcs'!AJ10","v":432},null,null,null,"Yes","B022/00",null,null,null,null,null,null,null,0,{"$f":"IF(AG23=\"\",0,  ASTM(AG23*SUM(P23:Q23)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG23/O23,4)*150000*SUM(P23:Q23)","v":0},"ADC",null,null,null,null,null,{"$f":"ASTM(T23*1.1,0)","v":475}]
[null,"2500 Pickup-Trim Level B, C  4-door  (20\" Tire)",null,null,null,null,10,"2wd","3.6L","L8",3.3570000000000002,21.3,7500,"Spark Ignition",8887,408,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P24:Q24)/SUM($P$22:$Q$26),SUM(P24:R24)/SUM($P$22:$R$26)),4)","v":0.2772},{"$f":"ASTM(AO24*0.55+AP24*0.45,1)","v":438.8},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG24=\"\",0,  ASTM(AG24*SUM(P24:Q24)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG24/O24,4)*150000*SUM(P24:Q24)","v":0},8,"B022/00","LXXX1003945X","LXXX1003945X",549,304,{"$f":"ASTM(T24*1.1,0)","v":483}]
[null,"2500 Pickup-Trim Level D Extended Cab",null,null,null,null,11,"4wd","3.6L","L8",3.3570000000000002,"23.9","7500","Spark Ignition",8887,688,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P25:Q25)/SUM($P$22:$Q$26),SUM(P25:R25)/SUM($P$22:$R$26)),4)","v":0.46739999999999998},{"$f":"ASTM((0.55*ASTM(0.5*AO25+0.5*AO26,1)+0.45*AP25),1)","v":474.8},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG25=\"\",0,  ASTM(AG25*SUM(P25:Q25)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG25/O25,4)*150000*SUM(P25:Q25)","v":0},9,"B020/02","LXXX1003941X","LXXX1003941X",575,345,{"$f":"ASTM(T25*1.1,0)","v":522}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG26=\"\",0,  ASTM(AG26*SUM(P26:Q26)*150000/1000000,0))","v":0},null,null,null,null,"LXXX1003944X",null,587]
[null,"2500 Pickup-Trim Level A  Extended Cab","NXXXD04.0ZZZ","AA-10",3,"4*",12,"2wd","4.0L-Turbo","L6",3.9159999999999999,23.5,7500,"Compression Ignition",{"$f":"IF(N27=\"\",\"\",IF(N27=\"Spark Ignition\",8887,10180))","v":10180},80,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P27:Q27)/SUM($P$27:$Q$32),SUM(P27:R27)/SUM($P$27:$R$32)),4)","v":3.8600000000000002E-2},{"$f":"ASTM(AO27*0.55+AP27*0.45,1)","v":430},{"$f":"ASTM(SUMPRODUCT(S27:S32,T27:T32),1)","v":427.6},1,{"$f":"ASTM(U27,1)","v":427.6},"No","NA",{"$f":"(IF($C$6>2023,SUM(P27:Q32)*W27,SUM(P27:R32)*W27))","v":885987.20000000007},0.05,0.05,{"$f":"ASTM(W27/O27*100,3)","v":4.2},{"$f":"(IF($C$6>2023,SUM(P27:Q32)*AC27,SUM(P27:R32)*AC27))","v":8702.4},{"$f":"ASTM(IF(AA27>0.05,-1*(AA27-0.05)*298*SUM(P27:R30)*150000/1000000,0),0)","v":0},{"$f":"ASTM(IF(AB27>0.05,-1*(AB27-0.05)*35*SUM(P27:R30)*150000/1000000,0),0)","v":0},0,{"$f":"IF(AG27=\"\",0,  ASTM(AG27*SUM(P27:Q27)*150000/1000000,0))","v":0},{"$f":"IF(AG27=\"\",0,AG27/O27*100)","v":0},{"$f":" ASTM(AG27/O27,4)*150000*SUM(P27:Q27)","v":0},10,"G57/02","LXXX1004581X","LXXX1004581X",542,293,{"$f":"ASTM(T27*1.1,0)","v":473}]
[null,"2500 Pickup-Trim Level A  Short Cab",null,null,null,null,13,"2wd","4.0L-Turbo","L6",3.9159999999999999,23.9,7500,"Compression Ignition",10180,8,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P28:Q28)/SUM($P$27:$Q$32),SUM(P28:R28)/SUM($P$27:$R$32)),4)","v":3.8999999999999998E-3},{"$f":"'ADCO2 Calcs'!AJ11","v":418},null,null,null,"Yes","G12/00",null,null,null,null,null,null,null,0,{"$f":"IF(AG28=\"\",0,  ASTM(AG28*SUM(P28:Q28)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG28/O28,4)*150000*SUM(P28:Q28)","v":0},"ADC",null,null,null,null,null,{"$f":"ASTM(T28*1.1,0)","v":460}]
[null,"2500 Pickup-Trim Level A 4-door Cab",null,null,null,null,14,"2wd","4.0L-Turbo","L6",3.9159999999999999,22.9,8000,"Compression Ignition",10180,32,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P29:Q29)/SUM($P$27:$Q$32),SUM(P29:R29)/SUM($P$27:$R$32)),4)","v":1.54E-2},{"$f":"ASTM(AO29*0.55+AP29*0.45,1)","v":427.2},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG29=\"\",0,  ASTM(AG29*SUM(P29:Q29)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG29/O29,4)*150000*SUM(P29:Q29)","v":0},11,"G12/00","LXXX1004580X","LXXX1004580X",537,293,{"$f":"ASTM(T29*1.1,0)","v":470}]
[null,"2500 Pickup-Trim Level B 4-door Cab",null,null,null,null,15,"2wd","4.0L-Turbo","L6",3.9159999999999999,23.6,8000,"Compression Ignition",10180,16,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P30:Q30)/SUM($P$27:$Q$32),SUM(P30:R30)/SUM($P$27:$R$32)),4)","v":7.7000000000000002E-3},{"$f":"ASTM(AO30*0.55+AP30*0.45,1)","v":434},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG30=\"\",0,  ASTM(AG30*SUM(P30:Q30)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG30/O30,4)*150000*SUM(P30:Q30)","v":0},12,"G57/03","LXXX1004581X","LXXX1004581X",546,297,{"$f":"ASTM(T30*1.1,0)","v":477}]
[null,"2500 Pickup-Trim Level B  Extended Cab",null,null,null,null,16,"2wd","4.0L-Turbo","L6",3.9159999999999999,24,8000,"Compression Ignition",10180,8,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P31:Q31)/SUM($P$27:$Q$32),SUM(P31:R31)/SUM($P$27:$R$32)),4)","v":3.8999999999999998E-3},{"$f":"'ADCO2 Calcs'!AJ12","v":437},null,null,null,"Yes","G57/03",null,null,null,null,null,null,null,0,{"$f":"IF(AG31=\"\",0,  ASTM(AG31*SUM(P31:Q31)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG31/O31,4)*150000*SUM(P31:Q31)","v":0},"ADC",null,null,null,null,null,{"$f":"ASTM(T31*1.1,0)","v":481}]
[null,"2500 Pickup-Trim Level B  4-door Cab",null,"AA-20",null,null,17,"4wd","4.0L-Turbo","L6",3.9159999999999999,24.4,8000,"Compression Ignition",10180,1928,0,0,{"$f":"ASTM(IF($C$6>2023,SUM(P32:Q32)/SUM($P$27:$Q$32),SUM(P32:R32)/SUM($P$27:$R$32)),4)","v":0.93049999999999999},{"$f":"ASTM(AO32*0.55+AP32*0.45,1)","v":427.5},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AG32=\"\",0,  ASTM(AG32*SUM(P32:Q32)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AG32/O32,4)*150000*SUM(P32:Q32)","v":0},13,"G12/01","LXXX1004580X","LXXX1004580X",531,301,{"$f":"ASTM(T32*1.1,0)","v":470}]
[null,null,null,"* Configuration number is combined because actual engine and ECM  is one specification in spite of  two engine codes."]

{"sheet":"Adv Tech std calcs","index":6,"n_rows":44,"n_cols":33,"rows_kept":44,"cut":false,"hidden":false,"merged":[[16,29,17,29],[16,2,17,2],[16,12,17,12],[16,13,17,13],[16,18,17,18],[16,19,17,19],[16,21,17,21],[16,20,17,20],[16,10,17,10],[0,1,0,32],[1,6,1,27],[15,32,17,32],[16,1,17,1],[16,6,17,6],[16,7,17,7],[16,8,17,8],[16,27,17,27],[16,11,17,11],[16,9,17,9],[15,1,15,10],[15,14,15,26],[16,23,17,23],[16,24,17,24],[15,27,15,29],[16,28,17,28]]}
[null,"Purpose and Scope of this Guidance Document   "]
[null,null,null,null,null,null,"This document was prepared by EPA's Office of Transportation and Air Quality (OTAQ).  It is intended to aid regulated parties in reporting fleet average Greenhouse Gas (GHG), Corporate Average Fuel Consumption (CAFC) values and calculating AB&T fleet average credits for heavy-duty class 2b and 3 vehicles, ref. 40 CFR 86.1819-14 and 49 CFR 535.5(a), 535.6(a), 535.7.  It contains EPA's recommended format for manufacturers to report to EPA their end-of-year GHG and CAFC calculations, credits and other information with respect to the implementation of the Phase 2 Greenhouse Gas Emissions and Fuel Efficiency Standards for Heavy-Duty Class 2b and 3 Pickup Trucks and Vans, ref. 81 FR 73478, October 25, 2016, including any subsequent revisions to those requirements. The use of this document is purely optional.\n       This document does not in any way alter or waive the requirements in EPA regulations.  Although the calculations and formulas provided in this document are intended to assist manufacturers in the implementation of EPA regulations, this document does not establish or change the legal rights or obligations of manufacturers or others in complying with EPA regulations, including 40 CFR 86.1865-12. If an error or other discrepancy is found in this document, including the calculation formulas, please contact your EPA certification team member.  The regulations take precedence."]
[]
[null,"Final HD Class 2b/3 CAFC/GHG Model Year Report  - CO2 and FC Fleet Average Standards Calculations for Advanced Technology Vehicles (EVs, PHEVs, Fuel Cell Vehicles)"]
[null,null,"Manufacturer: ","ABC HD 2b/3 Truck Co."]
[null,null,"Model Year: ",2022,{"$f":"IF(D6='Adv Tech Fleet ave calcs'!D6,\"\",\"ERROR--Model Year of Advanced Technology Standard calculation tab doesn't match the Model Year of the Advanced Technology Vehicle Fleet ave Calculation tab;\")","v":""}]
[null,null,"Report: ","HD 2b/3 Conventional Fleet Final Model Year Report"]
[null,null,"EPA Phase 2 GHG Standards: ","ref. 40 CFR 86.1819-14(a)(2) or 86.1819-14(k)(4)(iii) Table 3;"]
[null,null,"NHTSA Phase 2 FC Standards: ","ref. 49 CFR 535.5(a)(2)(ii) Table 6"]
[]
[null,null,null,"AA. Total production volume","CC.  Fleet target CO2\n(gpm)","FF. Fleet target FC\n(gal/100 mile)"]
[null,null,"Electric Vehicles:   ",{"$f":"IF($D$6>2023, SUM(AB19:AC19), SUM(AB19:AC19))","v":46944},{"$f":"ASTM(AE19/D12,0)","v":431},{"$f":"ASTM(AF19/D12,3)","v":4.2290000000000001},{"$f":"IF(D12='Adv Tech Fleet ave calcs'!D9,\"\",\"ERROR--Total EV production volume of the Advanced Technology Fleet std calculation tab doesn't match the Total EV production volume of the Advanced Technology Fleet ave Calculation tab;\")","v":""}]
[null,null,"PHEVs:  ",{"$f":"IF($D$6>2023, SUM(AB20:AC20), SUM(AB20:AC20))","v":29432},{"$f":"ASTM(AE20/D13,0)","v":483},{"$f":"ASTM(AF20/D13,3)","v":5.4349999999999996},{"$f":"IF(D13='Adv Tech Fleet ave calcs'!D10,\"\",\"ERROR--Total PHEV production volume of the Advanced Technology Fleet std calculation tab doesn't match the Total PHEV production volume of the Advanced Technology Fleet ave Calculation tab;\")","v":""}]
[null,null,"Fuel Cell Vehicles:  ",{"$f":"IF($D$6>2023, SUM(AB21:AC21), SUM(AB21:AC21))","v":2072},{"$f":"ASTM(AE21/D14,0)","v":496},{"$f":"ASTM(AF21/D14,3)","v":4.8680000000000003},{"$f":"IF(D14='Adv Tech Fleet ave calcs'!D11,\"\",\"ERROR--Total FCV production volume of the Advanced Technology Fleet std calculation tab doesn't match the Total FCV production volume of the Advanced Technology Fleet ave Calculation tab;\")","v":""}]
[]
[null,"Vehicle & Subconfiguration Information",null,null,null,null,null,null,null,null,null,null,null,null,"CO2 and FC Target Standard Information",null,null,null,null,null,null,null,null,null,null,null,null,"Production Volumes",null,null,null,null,"AG. \nComments"]
[null,"                               B.\nType of Advanced Technology Vehicle:\n\n  Electric Vehicle (EV),\n  Plug-In Hybrid Eectric Vehicle (PHEV) or\n  Fuel Cell Vehicle (FCV)","C.\nTruck Line Name & Description","D.\nTest Group","E.\nEngine Code","F.\nBase\nlevel","G.\nConfig.\nGroup","H.\nSub-\nconfig. Group Name","I.\n2 or 4 Wheel Drive","J.\nEngine","K.\nTrans Class","L.\nFinal Drive Ratio (front axle)","M. \nFinal Drive Ratio (rear axle)","N.\nRoad Load HP","O.\nGVWR","P.\nCurb Weight","Q.\nGCWR","R.\nETW\n\n(ALVW)","S. \nWork Factor","T.\nEngine:\n\nSpark Ignition, Compression Ignition or  Electric Vehicle/Fuel Cell Vehicle","U. \nA Target Coef","V. \nB Target Coef","W. \nCO2 Target Standard","X.\nC Target Coef","Y.\nD Target Coef","Z.\nConversion Factor","AA.\nFC Target Standard","AB.\nProduction volume  under Production volume  under 40 CFR 86.1819-14(a)","AC. \nProduction volume under 40 CFR 86.1819-14(j)\n\n(incomplete & sister vehicles)","AD. \nLoose Engine production volume under 86.1819-14(k)(8)\n(must be zero for this Advanced Technology Vehicle template)","AE.\nVol x Target CO2 Standard","AF.\n Vol x Target FC Standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lbs.","lbs.","lbs.","lbs.",null,null,null,null,"gpm",null,null,"gCO2/gal","gal/100 miles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVs:  ",{"$f":"SUM(AB22:AB27)","v":46944},{"$f":"SUM(AC22:AC27)","v":0},{"$f":"IF($D$6>2023,0, SUM(AD22:AD27))","v":0},{"$f":"SUM(AE22:AE27)","v":20213144},{"$f":"SUM(AF22:AF27)","v":198518.35199999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHEVs:  ",{"$f":"SUM(AB28:AB34)","v":29432},{"$f":"SUM(AC28:AC34)","v":0},{"$f":"IF($D$6>2023,0, SUM(AD28:AD34))","v":0},{"$f":"SUM(AE28:AE34)","v":14222696},{"$f":"SUM(AF28:AF34)","v":159976.09599999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FCVs:  ",{"$f":"SUM(AB35:AB40)","v":2072},{"$f":"SUM(AC35:AC40)","v":0},{"$f":"IF($D$6>2023,0, SUM(AD35:AD40))","v":0},{"$f":"SUM(AE35:AE40)","v":1026752},{"$f":"SUM(AF35:AF40)","v":10085.544}]
[null,"EV","3500 Electric Pickup Trim Level A","NXXXD00.0XXX","XX-1",1,1,1,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.6,10550,9175,18050,10000,{"$f":"ASTM(0.75*(O22-P22+IF(I22=\"4wd\",500, 0))+0.25*(Q22-O22),0)","v":3281},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T22),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T22),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U22),ISERROR(S22),ISERROR(V22)),1/0,ASTM(U22*S22+V22,0))","v":434},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T22),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T22),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},{"$f":"IF(T22=\"\",\"\",IF(T22=\"Spark Ignition\",8887,10180))","v":10180},{"$f":"IF(OR(ISERROR(X22),ISERROR(S22),ISERROR(Y22)),1/0,ASTM(X22*S22+Y22,3))","v":4.2590000000000003},18736,0,0,{"$f":"IF(T22=\"\",\"\",SUM(AB22:AC22)*W22)","v":8131424},{"$f":"IF(T22=\"\",\"\",SUM(AB22:AC22)*AA22)","v":79796.624000000011}]
[null,"EV","3500 Electric Pickup Trim Level B",null,null,null,null,null,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.6,10550,9650,18050,10000,{"$f":"ASTM(0.75*(O23-P23+IF(I23=\"4wd\",500, 0))+0.25*(Q23-O23),0)","v":2925},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T23),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T23),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U23),ISERROR(S23),ISERROR(V23)),1/0,ASTM(U23*S23+V23,0))","v":420},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T23),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T23),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X23),ISERROR(S23),ISERROR(Y23)),1/0,ASTM(X23*S23+Y23,3))","v":4.1210000000000004},7928,0,0,{"$f":"IF(T23=\"\",\"\",SUM(AB23:AC23)*W23)","v":3329760},{"$f":"IF(T23=\"\",\"\",SUM(AB23:AC23)*AA23)","v":32671.288000000004}]
[null,"EV","3500  Electric Pickup Trim Level C",null,null,null,null,null,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.6,10550,9400,18050,10000,{"$f":"ASTM(0.75*(O24-P24+IF(I24=\"4wd\",500, 0))+0.25*(Q24-O24),0)","v":3112},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T24),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T24),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U24),ISERROR(S24),ISERROR(V24)),1/0,ASTM(U24*S24+V24,0))","v":427},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T24),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T24),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X24),ISERROR(S24),ISERROR(Y24)),1/0,ASTM(X24*S24+Y24,3))","v":4.1929999999999996},1800,0,0,768600,7547.4]
[null,"EV","3500  Electric SUV  Trim Level A",null,null,null,null,2,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.1,10400,9063,17900,9500,{"$f":"ASTM(0.75*(O25-P25+IF(I25=\"4wd\",500, 0))+0.25*(Q25-O25),0)","v":3253},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T25),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T25),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U25),ISERROR(S25),ISERROR(V25)),1/0,ASTM(U25*S25+V25,0))","v":432},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T25),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T25),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X25),ISERROR(S25),ISERROR(Y25)),1/0,ASTM(X25*S25+Y25,3))","v":4.2480000000000002},13872,0,0,5992704,58928.256000000001]
[null,"EV","3500  Electric SUV  Trim Level B",null,null,null,null,null,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.1,10400,9063,17900,9500,{"$f":"ASTM(0.75*(O26-P26+IF(I26=\"4wd\",500, 0))+0.25*(Q26-O26),0)","v":3253},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T26),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T26),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U26),ISERROR(S26),ISERROR(V26)),1/0,ASTM(U26*S26+V26,0))","v":432},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T26),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T26),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X26),ISERROR(S26),ISERROR(Y26)),1/0,ASTM(X26*S26+Y26,3))","v":4.2480000000000002},944,0,0,407808,4010.1120000000001]
[null,"EV","3500  Electric SUV  Trim Level C",null,null,null,null,3,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.1,10400,9063,17900,9500,{"$f":"ASTM(0.75*(O27-P27+IF(I27=\"4wd\",500, 0))+0.25*(Q27-O27),0)","v":3253},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T27),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T27),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U27),ISERROR(S27),ISERROR(V27)),1/0,ASTM(U27*S27+V27,0))","v":432},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T27),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T27),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X27),ISERROR(S27),ISERROR(Y27)),1/0,ASTM(X27*S27+Y27,3))","v":4.2480000000000002},3664,0,0,1582848,15564.672]
[null,"PHEV","3500  SUV  Trim Level A (PHEV)","NXXXD02.0YYY","YY-1",2,2,4,"2wd","2.0L","Auto (S8)",2.91,"NA",26.4,10100,{"$f":"2*R28-O28","v":6900},16000,8500,{"$f":"ASTM(0.75*(O28-P28+IF(I28=\"4wd\",500, 0))+0.25*(Q28-O28),0)","v":3875},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T28),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T28),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(U28),ISERROR(S28),ISERROR(V28)),1/0,ASTM(U28*S28+V28,0))","v":484},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T28),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T28),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":3.6230000000000002},{"$f":"IF(T28=\"\",\"\",IF(T28=\"Spark Ignition\",8887,10180))","v":8887},{"$f":"IF(OR(ISERROR(X28),ISERROR(S28),ISERROR(Y28)),1/0,ASTM(X28*S28+Y28,3))","v":5.4450000000000003},1656,0,0,801504,9016.92,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"PHEV","3500 SUV  Trim Level B (PHEV)",null,null,null,null,5,"2wd","2.0L","Auto (S8)",2.91,"NA",28,10100,{"$f":"2*R29-O29","v":6900},16000,8500,{"$f":"ASTM(0.75*(O29-P29+IF(I29=\"4wd\",500, 0))+0.25*(Q29-O29),0)","v":3875},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T29),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T29),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(U29),ISERROR(S29),ISERROR(V29)),1/0,ASTM(U29*S29+V29,0))","v":484},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T29),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T29),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(X29),ISERROR(S29),ISERROR(Y29)),1/0,ASTM(X29*S29+Y29,3))","v":5.4450000000000003},1424,0,0,689216,7753.68,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"PHEV","3500 SUV  Trim Level C (PHEV)",null,null,null,null,6,"2wd","2.0L","Auto (S8)",2.91,"NA",29.9,11400,7809,16000,9500,{"$f":"ASTM(0.75*(O30-P30+IF(I30=\"4wd\",500, 0))+0.25*(Q30-O30),0)","v":3843},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T30),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T30),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(U30),ISERROR(S30),ISERROR(V30)),1/0,ASTM(U30*S30+V30,0))","v":483},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T30),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T30),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(X30),ISERROR(S30),ISERROR(Y30)),1/0,ASTM(X30*S30+Y30,3))","v":5.43},16752,0,0,8091216,90963.36]
[null,"PHEV","3500 SUV  Trim Level D (PHEV)",null,null,null,null,null,"2wd","2.0L","Auto (S8)",2.91,"NA",28.9,10900,7878,16000,9500,{"$f":"ASTM(0.75*(O31-P31+IF(I31=\"4wd\",500, 0))+0.25*(Q31-O31),0)","v":3542},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T31),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T31),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(U31),ISERROR(S31),ISERROR(V31)),1/0,ASTM(U31*S31+V31,0))","v":470},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T31),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T31),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(X31),ISERROR(S31),ISERROR(Y31)),1/0,ASTM(X31*S31+Y31,3))","v":5.2889999999999997},824,0,0,387280,4358.1359999999995]
[null,"PHEV","3500 SUV  Trim Level E (PHEV)",null,null,null,null,null,"2wd","2.0L","Auto (S8)",2.91,"NA",29.9,10900,7975,16000,9500,{"$f":"ASTM(0.75*(O32-P32+IF(I32=\"4wd\",500, 0))+0.25*(Q32-O32),0)","v":3469},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T32),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T32),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(U32),ISERROR(S32),ISERROR(V32)),1/0,ASTM(U32*S32+V32,0))","v":467},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T32),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T32),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(X32),ISERROR(S32),ISERROR(Y32)),1/0,ASTM(X32*S32+Y32,3))","v":5.2539999999999996},3032,0,0,1415944,15930.127999999999]
[null,"PHEV","3500 SUV  Trim Level F (PHEV)",null,null,null,null,7,"2wd","2.0L","Auto (S8)",2.91,"NA",28.5,10900,{"$f":"2*R33-O33","v":7100},16000,9000,{"$f":"ASTM(0.75*(O33-P33+IF(I33=\"4wd\",500, 0))+0.25*(Q33-O33),0)","v":4125},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T33),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T33),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(U33),ISERROR(S33),ISERROR(V33)),1/0,ASTM(U33*S33+V33,0))","v":494},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T33),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T33),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(X33),ISERROR(S33),ISERROR(Y33)),1/0,ASTM(X33*S33+Y33,3))","v":5.5629999999999997},1088,0,0,537472,6052.5439999999999,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"PHEV","3500 SUV  Trim Level G (PHEV)",null,null,null,null,null,"2wd","2.0L","Auto (S8)",2.91,"NA",28.5,10900,7100,16000,9000,{"$f":"ASTM(0.75*(O34-P34+IF(I34=\"4wd\",500, 0))+0.25*(Q34-O34),0)","v":4125},"Spark Ignition",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T34),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":4.1799999999999997E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T34),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":322},{"$f":"IF(OR(ISERROR(U34),ISERROR(S34),ISERROR(V34)),1/0,ASTM(U34*S34+V34,0))","v":494},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T34),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":4.7029999999999999E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T34),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":3.6230000000000002},8887,{"$f":"IF(OR(ISERROR(X34),ISERROR(S34),ISERROR(Y34)),1/0,ASTM(X34*S34+Y34,3))","v":5.5629999999999997},4656,0,0,2300064,25901.327999999998,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"FCV","2500 Pickup-Trim Level A Ext. Cab (FCV)","NXXXD00.0ZZZ","ZZ-1",3,3,12,"2wd","0.0L","Auto(A1)","NA",3.4780000000000002,25.5,9100,5900,19450,7500,{"$f":"ASTM(0.75*(O35-P35+IF(I35=\"4wd\",500, 0))+0.25*(Q35-O35),0)","v":4988},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T35),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T35),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U35),ISERROR(S35),ISERROR(V35)),1/0,ASTM(U35*S35+V35,0))","v":501},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T35),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T35),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X35),ISERROR(S35),ISERROR(Y35)),1/0,ASTM(X35*S35+Y35,3))","v":4.9210000000000003},80,0,0,40080,393.68,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"FCV","2500 Pickup-Trim Level A  Short Cab (FCV)",null,null,null,null,13,"2wd","0.0L","Auto(A1)","NA",3.4780000000000002,25.9,9100,5900,19450,7500,{"$f":"ASTM(0.75*(O36-P36+IF(I36=\"4wd\",500, 0))+0.25*(Q36-O36),0)","v":4988},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T36),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T36),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U36),ISERROR(S36),ISERROR(V36)),1/0,ASTM(U36*S36+V36,0))","v":501},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T36),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T36),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X36),ISERROR(S36),ISERROR(Y36)),1/0,ASTM(X36*S36+Y36,3))","v":4.9210000000000003},8,0,0,4008,39.368000000000002,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"FCV","2500 Pickup-Trim Level A 4-door Cab (FCV)",null,null,null,null,14,"2wd","0.0L","Auto(A1)","NA",3.4780000000000002,24.9,9100,6900,19450,8000,{"$f":"ASTM(0.75*(O37-P37+IF(I37=\"4wd\",500, 0))+0.25*(Q37-O37),0)","v":4238},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T37),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T37),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U37),ISERROR(S37),ISERROR(V37)),1/0,ASTM(U37*S37+V37,0))","v":471},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T37),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T37),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X37),ISERROR(S37),ISERROR(Y37)),1/0,ASTM(X37*S37+Y37,3))","v":4.63},32,0,0,15072,148.16,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"FCV","2500 Pickup-Trim Level B  4-door Cab (FCV)",null,null,null,null,15,"2wd","0.0L","Auto(A1)","NA",3.4780000000000002,25.6,9100,6900,19450,8000,{"$f":"ASTM(0.75*(O38-P38+IF(I38=\"4wd\",500, 0))+0.25*(Q38-O38),0)","v":4238},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T38),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T38),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U38),ISERROR(S38),ISERROR(V38)),1/0,ASTM(U38*S38+V38,0))","v":471},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T38),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T38),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X38),ISERROR(S38),ISERROR(Y38)),1/0,ASTM(X38*S38+Y38,3))","v":4.63},16,0,0,7536,74.08,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"FCV","2500 Pickup-Trim Level B  Ext. Cab (FCV)",null,null,null,null,16,"2wd","0.0L","Auto(A1)","NA",3.4780000000000002,26,9100,6900,19450,8000,{"$f":"ASTM(0.75*(O39-P39+IF(I39=\"4wd\",500, 0))+0.25*(Q39-O39),0)","v":4238},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T39),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T39),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U39),ISERROR(S39),ISERROR(V39)),1/0,ASTM(U39*S39+V39,0))","v":471},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T39),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T39),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X39),ISERROR(S39),ISERROR(Y39)),1/0,ASTM(X39*S39+Y39,3))","v":4.63},8,0,0,3768,37.04,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[null,"FCV","2500 Pickup-Trim Level A 4-door Cab (FCV)",null,null,null,null,17,"4wd","0.0L","Auto(A1)","NA",3.4780000000000002,26.4,9300,6700,19450,8000,{"$f":"ASTM(0.75*(O40-P40+IF(I40=\"4wd\",500, 0))+0.25*(Q40-O40),0)","v":4862},"EV/FCV-only",{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T40),'CFR Constants'!$A$4:$E$39,2,FALSE)","v":3.95E-2},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T40),'CFR Constants'!$A$4:$E$39,3,FALSE)","v":304},{"$f":"IF(OR(ISERROR(U40),ISERROR(S40),ISERROR(V40)),1/0,ASTM(U40*S40+V40,0))","v":496},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T40),'CFR Constants'!$A$4:$E$39,4,FALSE)","v":3.88E-4},{"$f":"VLOOKUP(CONCATENATE($D$6,\"_\",$T40),'CFR Constants'!$A$4:$E$39,5,FALSE)","v":2.9860000000000002},10180,{"$f":"IF(OR(ISERROR(X40),ISERROR(S40),ISERROR(Y40)),1/0,ASTM(X40*S40+Y40,3))","v":4.8719999999999999},1928,0,0,956288,9393.2160000000003,"Grouped subconfigs & calc'd curb wt = (2 x ETW - GVWR) per 40 CFR 86.1819-14(a)(4)(i);"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All ETWs look OK (based on curb wt & GVWR)"]

{"sheet":"Adv Tech Fleet ave calcs","index":7,"n_rows":31,"n_cols":46,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,26,14,26],[13,11,14,11],[13,20,14,20],[12,45,14,45],[13,34,13,35],[13,36,13,37],[13,40,13,41],[13,42,13,43],[13,27,14,27],[13,17,14,17],[13,18,14,18],[13,19,14,19],[13,25,14,25],[0,1,0,45],[1,14,1,31],[12,2,12,10],[12,17,12,20],[12,21,12,29],[12,30,12,31],[12,32,12,35],[12,36,12,37],[12,38,12,43],[12,44,14,44],[13,10,14,10],[13,12,14,12],[13,13,14,13],[13,15,14,15],[13,2,14,2],[13,1,14,1]]}
[null,"Purpose and Scope of this Guidance Document   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This document was prepared by EPA's Office of Transportation and Air Quality (OTAQ).  It is intended to aid regulated parties in reporting fleet average Greenhouse Gas (GHG), Corporate Average Fuel Consumption (CAFC) values and calculating AB&T fleet average credits for heavy-duty class 2b and 3 vehicles, ref. 40 CFR 86.1819-14 and 49 CFR 535.5(a), 535.6(a), 535.7.  It contains EPA's recommended format for manufacturers to report to EPA their end-of-year GHG and CAFC calculations, credits and other information with respect to the implementation of the Phase 2 Greenhouse Gas Emissions and Fuel Efficiency Standards for Heavy-Duty Class 2b and 3 Pickup Trucks and Vans, ref. 81 FR 73478, October 25, 2016, including any subsequent revisions to those requirements. The use of this document is purely optional.\n       This document does not in any way alter or waive the requirements in EPA regulations.  Although the calculations and formulas provided in this document are intended to assist manufacturers in the implementation of EPA regulations, this document does not establish or change the legal rights or obligations of manufacturers or others in complying with EPA regulations, including 40 CFR 86.1865-12. If an error or other discrepancy is found in this document, including the calculation formulas, please contact your EPA certification team member.  The regulations take precedence."]
[]
[null,null,"Final HD Class 2b/3 CAFC/GHG Model Year Report  - CO2 and FC Fleet Average Performance Calculations for Advanced Technology Vehicles (EVs, PHEVs, Fuel Cell Vehicles)"]
[null,null,"Manufacturer","ABC HD 2b/3 Truck Co"]
[null,null,"Model Year ",2022,{"$f":"IF(D6='Adv Tech std calcs'!D6,\"\",\"ERROR--Model Year of Advanced Technology Standard calculation tab doesn't match the Model Year of the Advanced Technology Vehicle Fleet ave Calculation tab;\")","v":""}]
[]
[null,null,null,"AA. Total production volume","BB. Fleet average CO2 (gpm)","EE. Fleet average FC \n(gal/100 mile)","Number of Subconfigurations","Number of vehicles\nActually tested","Rate of production volume represented by test data\n(%)"]
[null,null,"EVs:  ",{"$f":"SUM(R16:S16)","v":46944},{"$f":"ASTM(AB16/D9,0)","v":0},{"$f":"ASTM(AF16/D9,3)","v":0},{"$f":" COUNT(H19:H21)","v":3},0,1,{"$f":"IF(D9='Adv Tech std calcs'!D12,\"\",\"ERROR--Total EV production volume of the Advanced Technology Fleet std calculation tab doesn't match the Total EV production volume of the Advanced Technology Fleet ave Calculation tab;\")","v":""}]
[null,null,"PHEVs:  ",{"$f":"SUM(R17:S17)","v":29432},{"$f":"ASTM(AB17/D10,0)","v":51},{"$f":"ASTM(AF17/D10,3)","v":0.57399999999999995},{"$f":" COUNT(H22:H25)","v":4},1,1,{"$f":"IF(D10='Adv Tech std calcs'!D13,\"\",\"ERROR--Total PHEV production volume of the Advanced Technology Fleet std calculation tab doesn't match the Total PHEV production volume of the Advanced Technology Fleet ave Calculation tab;\")","v":""}]
[null,null,"FCVs:  ",{"$f":"SUM(R18:S18)","v":2072},{"$f":"ASTM(AB18/D11,0)","v":0},{"$f":"ASTM(AF18/D11,3)","v":0},{"$f":" COUNT(H26:H31)","v":6},0,1,{"$f":"IF(D11='Adv Tech std calcs'!D14,\"\",\"ERROR--Total FCV production volume of the Advanced Technology Fleet std calculation tab doesn't match the Total FCV production volume of the Advanced Technology Fleet ave Calculation tab;\")","v":""}]
[]
[null,null,"Subconfiguration Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Production Volumes",null,null,null,"GHG Compliance Level+T9 (see instructions)",null,null,null,null,null,null,null,null,"FC Compliance Level",null,"GHG Credits",null,null,null,"FC Credits",null,"Test information",null,null,null,null,null,"AO.\nIn-use CO2 standard","AP. \nComments"]
[null,"                            B.\nType of Advanced Technology Vehicle:\n\n  Electric Vehicle (EV),\n  Plug-In Hybrid Eectric Vehicle (PHEV) or\n  Fuel Cell Vehicle (FCV)","C.\nTruck Line Name and Description","D.\nTest Group","E.\nEngine Code","F.\nBase\nlevel\n(test group/ transmission type)","G.\nConfig.\nGroup","H.\nSub-\nconfig. Group Name","I.\n2 or 4 Wheel Drive","J.\nEngine","K.\nTrans Class","L.\nFinal Drive Ratio (front axle)","M. \nFinal Drive Ratio (rear axle)","N.\nRoad Load HP","O.\nETW\n\n(ALVW)","P.\nEngine:\n\nSpark Ignition, Compression Ignition or  Electric Vehicle/Fuel Cell Vehicle","Q.\nConversion Factor","R.\nProduction volume  under 40 CFR 86.1819-14(a)","S. \nProduction volume under 40 CFR 86.1819-14(j)\n\n(incomplete & sister vehicles)","T. \nLoose Engine production volume under 86.1819-14(k)(8)\n\n(must be zero for this Advanced Technology Vehicle template)","U.\nSales fraction\nin DVC (config)","V. \nRLC (subconfig)\nCO2 emissions","W.\nDVC (config)\nCO2\nemissions","X.\nSales fraction\nin Base Level","Y.\nBase Level\nCO2\nemissions","Z. \nCO2 Value based on ADC?","AA. \nIf ADC derived, Test vehicle ID and Conf. that is source of CO2base","AB. \nVol x CO2 ","AC. \nN2O FEL","AD. \nCH4 FEL","AE.\nBL\nFuel Consumption","AF.\nVol x FC","AG.\n  CO2 Credits required for 150K N2O compliance","AH.  \nCO2 Credits req'd for 150K CH4 compliance \n(Formula uses Global Warming Potential = 34)","AI.\nOff Cycle (Innovative Technology)\n150K CO2 credits\n\n[Prior EPA approval required]",null,"AJ.\nInnovative and Off Cycle \n150K FC credits",null,"AK.\nNo. of RLC\nsubconfigs covered by\nactual test","AL.\nTest Vehicle ID/Config.","AM.\nTest Number",null,"AN.\nTest Result (CO2)\n[For PHEVs, enter the composite city/hwy 150K CO2 values from the EPA HD 2b/3 PHEV Calculator; rounded to nearest 0.1 gpm]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lbs.",null,"gCO2/gal",null,null,null,null,"gpm","gpm",null,"gpm",null,null,null,"gpm","gpm","gal/100-mile",null,"megagrams","megagrams","gpm","megagrams","gal/100 mile","gallons",null,null,"CITY","HWY","CITY","HWY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVs:  ",{"$f":"SUM(R19:R21)","v":46944},{"$f":"SUM(S19:S21)","v":0},{"$f":"SUM(T19:T21)","v":0},null,null,null,null,null,null,"EVs:  ",{"$f":"SUM(AB19:AB21)","v":0},null,null,null,{"$f":"SUM(AF19:AF21)","v":0},{"$f":"SUM(AG19:AG21)","v":0},{"$f":"SUM(AH19:AH21)","v":0},null,{"$f":"SUM(AJ19:AJ21)","v":0},null,{"$f":"SUM(AL19:AL21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHEVs:  ",{"$f":"SUM(R22:R25)","v":29432},{"$f":"SUM(S22:S25)","v":0},{"$f":"SUM(T22:T25)","v":0},null,null,null,null,null,null,"PHEVs:  ",{"$f":"SUM(AB22:AB25)","v":1501032},null,null,null,{"$f":"SUM(AF22:AF25)","v":16893.967999999997},{"$f":"SUM(AG22:AG25)","v":0},{"$f":"SUM(AH22:AH25)","v":0},null,{"$f":"SUM(AJ22:AJ25)","v":0},null,{"$f":"SUM(AL22:AL25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FCVs:  ",{"$f":"SUM(R26:R31)","v":2072},{"$f":"SUM(S26:S31)","v":0},{"$f":"SUM(T26:T31)","v":0},null,null,null,null,null,null,"FCVs:  ",{"$f":"SUM(AB26:AB31)","v":0},null,null,null,{"$f":"SUM(AF26:AF31)","v":0},{"$f":"SUM(AG26:AG31)","v":0},{"$f":"SUM(AH26:AH31)","v":0},null,{"$f":"SUM(AJ26:AJ31)","v":0},null,{"$f":"SUM(AL26:AL31)","v":0}]
[null,"EV","3500 Electric Pickup Trim Level A, B & C","NXXXD00.0XXX","XX-1",1,1,1,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.6,10000,"EV/FCV-only",{"$f":"IF(P19=\"\",\"\",IF(P19=\"Spark Ignition\",8887,10180))","v":10180},28464,0,0,{"$f":"ASTM(SUM(R19:S19)/SUM($R$19:$S$21),4)","v":0.60629999999999995},{"$f":"ASTM(AQ19*0.55+AR19*0.45,1)","v":0},{"$f":"ASTM(SUMPRODUCT(U19:U21,V19:V21),1)","v":0},1,{"$f":"W19","v":0},"No","NA",{"$f":"SUM(R19:T21)*Y19","v":0},0.05,0.05,{"$f":"ASTM(Y19/Q19*100,3)","v":0},{"$f":"SUM(R19:S21)*AE19","v":0},{"$f":"ASTM(IF(AC19>0.05,-1*(AC19-0.05)*298*SUM(R19:S21)*150000/1000000,0),0)","v":0},{"$f":"ASTM(IF(AD19>0.05,-1*(AD19-0.05)*34*SUM(R19:S21)*150000/1000000,0),0)","v":0},0,{"$f":"IF(AI19=\"\",0,  ASTM(AI19*SUM(R19:S19)*150000/1000000,0))","v":0},{"$f":"IF(AI19=\"\",0,AI19/Q19*100)","v":0},{"$f":" ASTM(AI19/Q19,4)*150000*SUM(R19:S19)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V19*1.1,0)","v":0},"Testing not req'd for EVs; ref 49 CFR 535.6(a)(3)(iii); "]
[null,"EV","3500  Electric SUV  Trim Levels A & B",null,null,null,null,2,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.1,9500,"EV/FCV-only",10180,14816,0,0,{"$f":"ASTM(SUM(R20:S20)/SUM($R$19:$S$21),4)","v":0.31559999999999999},{"$f":"ASTM(AQ20*0.55+AR20*0.45,1)","v":0},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI20=\"\",0,  ASTM(AI20*SUM(R20:S20)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI20/Q20,4)*150000*SUM(R20:S20)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V20*1.1,0)","v":0},"Testing not req'd for EVs; ref 49 CFR 535.6(a)(3)(iii); "]
[null,"EV","3500  Electric SUV  Trim Levels C",null,null,null,null,3,"4wd","0.0L","Auto(CVT)",13.26,10.49,28.1,9500,"EV/FCV-only",10180,3664,0,0,{"$f":"ASTM(SUM(R21:S21)/SUM($R$19:$S$21),4)","v":7.8100000000000003E-2},{"$f":"ASTM(AQ21*0.55+AR21*0.45,1)","v":0},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI21=\"\",0,  ASTM(AI21*SUM(R21:S21)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI21/Q21,4)*150000*SUM(R21:S21)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V21*1.1,0)","v":0},"Testing not req'd for EVs; ref 49 CFR 535.6(a)(3)(iii); "]
[null,"PHEV","3500  SUV  Trim Level A (PHEV)","NXXXD02.0YYY","YY-1",2,2,4,"2wd","2.0L","Auto (S8)",2.91,"NA",26.4,8500,"Spark Ignition",8887,1656,0,0,{"$f":"ASTM(SUM(R22:S22)/SUM($R$22:$S$25),4)","v":5.6300000000000003E-2},{"$f":"ASTM(AQ22*0.55+AR22*0.45,1)","v":51},{"$f":"ASTM(SUMPRODUCT(U22:U25,V22:V25),1)","v":51},{"$f":"ASTM(SUM(R22:R25)/SUM($R$22:$R$25),4)","v":1},{"$f":"W22","v":51},"No","NA",{"$f":"SUM(R22:S25)*Y22","v":1501032},0.05,0.05,{"$f":"ASTM(Y22/Q22*100,3)","v":0.57399999999999995},{"$f":"SUM(R22:S25)*AE22","v":16893.967999999997},{"$f":"ASTM(IF(AC22>0.05,-1*(AC22-0.05)*298*SUM(R22:S25)*150000/1000000,0),0)","v":0},{"$f":"ASTM(IF(AD22>0.05,-1*(AD22-0.05)*34*SUM(R22:S25)*150000/1000000,0),0)","v":0},0,{"$f":"IF(AI22=\"\",0,  ASTM(AI22*SUM(R22:S22)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI22/Q22,4)*150000*SUM(R22:S22)","v":0},4,"Not Applicable","NA","NA",22,86.5,{"$f":"ASTM(V22*1.1,0)","v":56},"Data substitution from worst case test vehicle"]
[null,"PHEV","3500 SUV  Trim Level B (PHEV)",null,null,null,null,5,"2wd","2.0L","Auto (S8)",2.91,"NA",28,8500,"Spark Ignition",8887,1424,0,0,{"$f":"ASTM(SUM(R23:S23)/SUM($R$22:$S$25),4)","v":4.8399999999999999E-2},{"$f":"ASTM(AQ23*0.55+AR23*0.45,1)","v":51},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI23=\"\",0,  ASTM(AI23*SUM(R23:S23)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI23/Q23,4)*150000*SUM(R23:S23)","v":0},5,"Not Applicable","NA","NA",22,86.5,{"$f":"ASTM(V23*1.1,0)","v":56},"Data substitution from worst case test vehicle"]
[null,"PHEV","3500 SUV  Trim Level C, D, E (PHEV)",null,null,null,null,6,"2wd","2.0L","Auto (S8)",2.91,"NA",29.9,9500,"Spark Ignition",8887,20608,0,0,{"$f":"ASTM(SUM(R24:S24)/SUM($R$22:$S$25),4)","v":0.70020000000000004},{"$f":"ASTM(AQ24*0.55+AR24*0.45,1)","v":51},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI24=\"\",0,  ASTM(AI24*SUM(R24:S24)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI24/Q24,4)*150000*SUM(R24:S24)","v":0},6,"B299/03","MXXXX0040829; \nMXXXX0040830;","MXXXX0040831; \nMXXXX0040832; ",22,86.5,{"$f":"ASTM(V24*1.1,0)","v":56},"Tested worst case PHEV vehicle; City, Hwy composite CO2 values from HD 2b-3 PHEV Calculator"]
[null,"PHEV","3500 SUV  Trim Level F, G  (PHEV)",null,null,null,null,7,"2wd","2.0L","Auto (S8)",2.91,"NA",28.5,9000,"Spark Ignition",8887,5744,0,0,{"$f":"ASTM(SUM(R25:S25)/SUM($R$22:$S$25),4)","v":0.19520000000000001},{"$f":"ASTM(AQ25*0.55+AR25*0.45,1)","v":51},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI25=\"\",0,  ASTM(AI25*SUM(R25:S25)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI25/Q25,4)*150000*SUM(R25:S25)","v":0},7,"Not Applicable","NA","NA",22,86.5,{"$f":"ASTM(V25*1.1,0)","v":56},"Data substitution from worst case test vehicle"]
[null,"FCV","2500 Pickup-Trim Level A Ext. Cab (FCV)","NXXXD00.0ZZZ","ZZ-1",3,3,12,"2wd","0.0L","Auto(A1)","NA",3.3570000000000002,25.5,7500,"EV/FCV-only",{"$f":"IF(P26=\"\",\"\",IF(P26=\"Spark Ignition\",8887,10180))","v":10180},80,0,0,{"$f":"ASTM(SUM(R26:S26)/SUM($R$26:$S$31),4)","v":3.8600000000000002E-2},{"$f":"ASTM(AQ26*0.55+AR26*0.45,1)","v":0},{"$f":"ASTM(SUMPRODUCT(U26:U31,V26:V31),1)","v":0},1,{"$f":"W26","v":0},"No","NA",{"$f":"SUM(R26:S31)*Y26","v":0},0.05,0.05,{"$f":"ASTM(Y26/Q26*100,3)","v":0},{"$f":"SUM(R26:S31)*AE26","v":0},{"$f":"ASTM(IF(AC26>0.05,-1*(AC26-0.05)*298*SUM(R26:S29)*150000/1000000,0),0)","v":0},{"$f":"ASTM(IF(AD26>0.05,-1*(AD26-0.05)*34*SUM(R26:S29)*150000/1000000,0),0)","v":0},0,{"$f":"IF(AI26=\"\",0,  ASTM(AI26*SUM(R26:S26)*150000/1000000,0))","v":0},{"$f":"IF(AI26=\"\",0,AI26/Q26*100)","v":0},{"$f":" ASTM(AI26/Q26,4)*150000*SUM(R26:S26)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V26*1.1,0)","v":0},"Testing not req'd for FCVs; ref 49 CFR 535.6(a)(3)(iii); "]
[null,"FCV","2500 Pickup-Trim Level A  Short Cab (FCV)",null,null,null,null,13,"2wd","0.0L","Auto(A1)","NA",3.3570000000000002,25.9,7500,"EV/FCV-only",10180,8,0,0,{"$f":"ASTM(SUM(R27:S27)/SUM($R$26:$S$31),4)","v":3.8999999999999998E-3},{"$f":"ASTM(AQ27*0.55+AR27*0.45,1)","v":0},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI27=\"\",0,  ASTM(AI27*SUM(R27:S27)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI27/Q27,4)*150000*SUM(R27:S27)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V27*1.1,0)","v":0},"Testing not req'd for FCVs; ref 49 CFR 535.6(a)(3)(iii); "]
[null,"FCV","2500 Pickup-Trim Level A 4-door Cab (FCV)",null,null,null,null,14,"2wd","0.0L","Auto(A1)","NA",3.3570000000000002,24.9,8000,"EV/FCV-only",10180,32,0,0,{"$f":"ASTM(SUM(R28:S28)/SUM($R$26:$S$31),4)","v":1.54E-2},{"$f":"ASTM(AQ28*0.55+AR28*0.45,1)","v":0},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI28=\"\",0,  ASTM(AI28*SUM(R28:S28)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI28/Q28,4)*150000*SUM(R28:S28)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V28*1.1,0)","v":0},"Testing not req'd for FCVs; ref 49 CFR 535.6(a)(3)(iii); "]
[null,"FCV","2500 Pickup-Trim Level B  4-door Cab (FCV)",null,null,null,null,15,"2wd","0.0L","Auto(A1)","NA",3.3570000000000002,25.6,8000,"EV/FCV-only",10180,16,0,0,{"$f":"ASTM(SUM(R29:S29)/SUM($R$26:$S$31),4)","v":7.7000000000000002E-3},{"$f":"ASTM(AQ29*0.55+AR29*0.45,1)","v":0},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI29=\"\",0,  ASTM(AI29*SUM(R29:S29)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI29/Q29,4)*150000*SUM(R29:S29)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V29*1.1,0)","v":0},"Testing not req'd for FCVs; ref 49 CFR 535.6(a)(3)(iii); "]
[null,"FCV","2500 Pickup-Trim Level B  Ext. Cab (FCV)",null,null,null,null,16,"2wd","0.0L","Auto(A1)","NA",3.3570000000000002,26,8000,"EV/FCV-only",10180,8,0,0,{"$f":"ASTM(SUM(R30:S30)/SUM($R$26:$S$31),4)","v":3.8999999999999998E-3},{"$f":"ASTM(AQ30*0.55+AR30*0.45,1)","v":0},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI30=\"\",0,  ASTM(AI30*SUM(R30:S30)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI30/Q30,4)*150000*SUM(R30:S30)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V30*1.1,0)","v":0},"Testing not req'd for FCVs; ref 49 CFR 535.6(a)(3)(iii); "]
[null,"FCV","2500 Pickup-Trim Level A 4-door Cab (FCV)",null,null,null,null,17,"4wd","0.0L","Auto(A1)","NA",3.3570000000000002,26.4,8000,"EV/FCV-only",10180,1928,0,0,{"$f":"ASTM(SUM(R31:S31)/SUM($R$26:$S$31),4)","v":0.93049999999999999},{"$f":"ASTM(AQ31*0.55+AR31*0.45,1)","v":0},null,null,null,"No","NA",null,null,null,null,null,null,null,0,{"$f":"IF(AI31=\"\",0,  ASTM(AI31*SUM(R31:S31)*150000/1000000,0))","v":0},0,{"$f":" ASTM(AI31/Q31,4)*150000*SUM(R31:S31)","v":0},"NA","Not Applicable","NA","NA",0,0,{"$f":"ASTM(V31*1.1,0)","v":0},"Testing not req'd for FCVs; ref 49 CFR 535.6(a)(3)(iii); "]

{"sheet":"HFC Emissions","index":8,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[11,5,12,5],[11,6,12,6],[14,5,15,5],[14,6,15,6],[14,7,15,7],[11,7,12,7],[11,9,12,9],[11,10,12,10],[4,8,6,8],[11,11,12,11],[14,11,15,11],[14,9,15,9],[14,10,15,10],[14,8,15,8],[11,8,12,8],[0,1,0,11],[1,1,1,15],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,9,9],[9,10,9,11]]}
[null,"Purpose and Scope of this Guidance Document   "]
[null,"This document was prepared by EPA's Office of Transportation and Air Quality (OTAQ).  It is intended to aid regulated parties in reporting fleet average Greenhouse Gas (GHG), Corporate Average Fuel Consumption (CAFC) values and calculating AB&T fleet average credits for heavy-duty class 2b and 3 vehicles, ref. 40 CFR 86.1819-14 and 49 CFR 535.5(a), 535.6(a), 535.7.  It contains EPA's recommended format for manufacturers to report to EPA their end-of-year GHG and CAFC calculations, credits and other information with respect to the implementation of the Phase 2 Greenhouse Gas Emissions and Fuel Efficiency Standards for Heavy-Duty Class 2b and 3 Pickup Trucks and Vans, ref. 81 FR 73478, October 25, 2016, including any subsequent revisions to those requirements. The use of this document is purely optional.\n       This document does not in any way alter or waive the requirements in EPA regulations.  Although the calculations and formulas provided in this document are intended to assist manufacturers in the implementation of EPA regulations, this document does not establish or change the legal rights or obligations of manufacturers or others in complying with EPA regulations, including 40 CFR 86.1865-12. If an error or other discrepancy is found in this document, including the calculation formulas, please contact your EPA certification team member.  The regulations take precedence."]
[]
[null,"  End-Model Year Report HFC LEAKAGE SCORE TABLE (Heavy-Duty Class 2b/3 Vehicles including EVs, PHEVs, and Fuel Cell Vehicles)"]
[null,"Manufacturer","ABC HD 2b/3 Truck Co.",null,null,null,null,null,"Total Production Volume"]
[null,"Model Year ",2022]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I12:I22)","v":158368}]
[]
[null,"TEST GROUP\n NAME","ENGINE CODE","DIVISION\nNAME","CARLINE","A/C System Information",null,null,null,null,"A/C Leakage Rate"]
[null,null,null,null,null,"A/C system\nnumber","Refrigerant","Refrigerant GWP, \nif other than\nR134a","Production\nVolume","Refrigerant\nCapacity (g)","Total System\nHFC\nEmission Rate (g/year)","Total System\nHFC\nPercent Leakage (%/year)"]
[null,"NXXXD02.5XXX","AA5","ABC Truck Co.","1500 Cargo VAN",1," R134a","n.a",43280,850,11.2,{"$f":"ASTM(K12/J12,4)","v":1.32E-2}]
[null,"NXXXD02.5XXX","AA5","ABC Truck Co.","2500 Cargo VAN"]
[null,"NXXXD02.5XXX","AA5","ABC Truck Co.","3500 Passenger VAN",2," R134a","n.a",3664,1200,13,{"$f":"ASTM(K14/J14,4)","v":1.0800000000000001E-2}]
[null,"NXXXD03.6YYY","AA6","ABC Truck Co.","2500 Cargo VAN",3," R134a","n.a",12680,850,12.7,{"$f":"ASTM(K15/J15,4)","v":1.49E-2}]
[null,"NXXXD03.6YYY","AA6","ABC Truck Co.","3500 Cargo VAN"]
[null,"NXXXD03.6YYY","AA6","ABC Truck Co.","3500 Passenger VAN",4," R134a","n.a",16752,1200,16.2,{"$f":"ASTM(K17/J17,4)","v":1.35E-2}]
[null,"NXXXD03.6YYY","AA2","ABC Truck Co.","2500 Pickup 2WD/4WD",5," R134a","n.a",1472,800,11.7,{"$f":"ASTM(K18/J18,4)","v":1.46E-2}]
[null,"NXXXD04.0ZZZ","AA-10, AA-20","ABC Truck Co.","2500 Pickup 2WD/4WD",6," R134a","n.a",2072,800,11.8,{"$f":"ASTM(K19/J19,4)","v":1.4800000000000001E-2}]
[null,"NXXXD00.0XXX","XX-1","ABC Truck Co.","3500 Electric Pickup/SUV",7,"R1234-YF",4,46944,680,9.1,{"$f":"ASTM(K20/J20,4)","v":1.34E-2}]
[null,"NXXXD02.0YYY","YY-1","ABC Truck Co.","3500  SUV   (PHEV)",8,"R1234-YF",4,29432,600,8,{"$f":"ASTM(K21/J21,4)","v":1.3299999999999999E-2}]
[null,"NXXXD00.0ZZZ","ZZ-1","ABC Truck Co.","2500 Pickup (Fuel Cell Veh)",9,"R1234-YF",4,2072,800,11.2,{"$f":"ASTM(K22/J22,4)","v":1.4E-2}]
[]
[null,"Compliance Statement (Select \"Yes\" or \"No\" in cell B20):"]
[null,"[Yes]","     Each A/C System complies with HFC Leakage Standard of  < 11.0 grams/year or < 1.50% per year (whichever is greater), Ref. 40 CFR 86.1819-14(h) ; "]

{"sheet":"ADCO2 Calcs","index":9,"n_rows":12,"n_cols":36,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,20,5,21],[5,22,5,24],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,15,6,15],[5,16,6,16],[0,1,0,35],[1,10,1,23],[4,2,4,10],[4,14,4,16],[4,19,4,29],[4,35,6,35],[5,1,7,1],[5,2,6,2],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8]]}
[null,"Purpose and Scope of this Guidance Document   "]
[null,null,null,null,null,null,null,null,null,null,"This document was prepared by EPA's Office of Transportation and Air Quality (OTAQ).  It is intended to aid regulated parties in reporting fleet average Greenhouse Gas (GHG), Corporate Average Fuel Consumption (CAFC) values and calculating AB&T fleet average credits for heavy-duty class 2b and 3 vehicles, ref. 40 CFR 86.1819-14 and 49 CFR 535.5(a), 535.6(a), 535.7.  It contains EPA's recommended format for manufacturers to report to EPA their end-of-year GHG and CAFC calculations, credits and other information with respect to the implementation of the Phase 2 Greenhouse Gas Emissions and Fuel Efficiency Standards for Heavy-Duty Class 2b and 3 Pickup Trucks and Vans, ref. 81 FR 73478, October 25, 2016, including any subsequent revisions to those requirements. The use of this document is purely optional.\n       This document does not in any way alter or waive the requirements in EPA regulations.  Although the calculations and formulas provided in this document are intended to assist manufacturers in the implementation of EPA regulations, this document does not establish or change the legal rights or obligations of manufacturers or others in complying with EPA regulations, including 40 CFR 86.1865-12. If an error or other discrepancy is found in this document, including the calculation formulas, please contact your EPA certification team member.  The regulations take precedence."]
[]
[null,"2018MY HD  GHG ADCO2 Calculation sheet"]
[null,null,"Subconfiguration Information",null,null,null,null,null,null,null,null,null,null,null,"GHG Compliance Level+T9 (see instructions)",null,null,null,null,"ADCO2 Baseline test vehicle",null,null,null,null,null,null,null,null,null,null,"New vehicle ",null,null,null,null,"Calculation\nresults\n\nADCO2"]
[null,"Spread sheets\n\"Fleet ave calculation\"\nCell no.\nADO2","A1.\nTruck Line Name and Description","Test Group","Engine Code","Base\nlevel\n(test group/ transmission type)","Config.\nGroup","A2.\nSub-\nconfig. Group Name","B.\n2 or 4 Wheel Drive","C.\nEngine","D.\nTrans Class","E.\nFinal Drive Ratio","F.\nRoad Load HP","J.\nETW","W. \nRLC\nCO2 emissions","X. \nCO2 Value based on ADC?","Y. \nIf ADC derived, Test vehicle ID and Conf. that is source of CO2base","No. of RLC\ncovered by\natual test",null,"Test Vehicle ID/Config.","Test Number",null,"Test Result (CO2)",null,null,"F0","F1","F2","If","ETW","F0","F1","F2","If","ETW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"lbs.","gpm",null,null,null,null,null,"CITY","HWY","CITY","HWY","COMB."]
[]
[null,"T20","2500 Pickup-Trim Level A  Short Cab","NXXXD03.6YYY","AA2",2,3,8,"2wd","3.6L","L8",3.3570000000000002,21.2,7000,439,"Yes","B022/00","ADC",null,"B022/00","LXXX10039452","LXXX10039453",549,304,{"$f":"ASTM(0.55*W9+0.45*X9,1)","v":438.8},63.3,0.26769999999999999,3.3480000000000003E-2,3.3570000000000002,7500,58.21,0.25,3.5209999999999998E-2,3.3570000000000002,7000,{"$f":"ASTM(Y9+2.18*(AE9-Z9)+37.4*(AF9-AA9)+2257*(AG9-AB9)+189*(AH9-AC9)+0.0222*(AI9-AD9),0)","v":420}]
[null,"T21","2500 Pickup-Trim Level A  4-door Cab",null,null,null,null,9,"2wd","3.6L","L8",3.3570000000000002,20.7,7500,439,"Yes","B022/00","ADC",null,"B022/00","LXXX10039452","LXXX10039453",549,304,{"$f":"ASTM(0.55*W10+0.45*X10,1)","v":438.8},63.3,0.26769999999999999,3.3480000000000003E-2,3.3570000000000002,7500,61.32,0.25929999999999997,3.2419999999999997E-2,3.3570000000000002,7500,{"$f":"ASTM(Y10+2.18*(AE10-Z10)+37.4*(AF10-AA10)+2257*(AG10-AB10)+189*(AH10-AC10)+0.0222*(AI10-AD10),0)","v":432}]
[null,"T26","2500 Pickup-Trim Level A  Short Cab","NXXXD04.0ZZZ","AA-10",3,4,13,"2wd","4.0L-Turbo","L6",3.9159999999999999,23.9,7500,427,"Yes","G12/00","ADC",null,"G12/00","LXXX10045801","LXXX10045802",537,293,{"$f":"ASTM(0.55*W11+0.45*X11,1)","v":427.2},74.05,0.30159999999999998,3.3149999999999999E-2,3.9159999999999999,8000,70.959999999999994,0.37280000000000002,3.5869999999999999E-2,3.9159999999999999,7500,{"$f":"ASTM(Y11+2.18*(AE11-Z11)+37.4*(AF11-AA11)+2257*(AG11-AB11)+189*(AH11-AC11)+0.0222*(AI11-AD11),0)","v":418}]
[null,"T29","2500 Pickup-Trim Level B  Extended Cab",null,null,null,null,16,"2wd","4.0L-Turbo","L6",3.9159999999999999,24,8000,434,"Yes","G57/03","ADC",null,"G57/03","LXXX10045815","LXXX10045816",546,297,{"$f":"ASTM(0.55*W12+0.45*X12,1)","v":434},74.33,0.37759999999999999,3.3489999999999999E-2,3.9159999999999999,8000,74.33,0.37759999999999999,3.4770000000000002E-2,3.9159999999999999,8000,{"$f":"ASTM(Y12+2.18*(AE12-Z12)+37.4*(AF12-AA12)+2257*(AG12-AB12)+189*(AH12-AC12)+0.0222*(AI12-AD12),0)","v":437}]