{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["version notes","Label Inputs","PHEV Calculator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"version notes","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Version No.","Release Date","Comments"]
[23,null,"Same calculations as version 22. \nExpanded data input range to allow up to 30 charge-depleting cycles. \nUpdated label inputs (fuel prices, ratings scales, etc.) for 2018 model year based on EPA guidance. Some text changes to improve clarity."]
[24,null,"Found an error in some of the calculations for multiple test sets. These calculations referenced the transition cycle for the first test set, instead of the current test set. This would only impact the unusual situation where the transition cycle differed across test sets. "]
[25,"2017-12-27","Fixed an error where the 5-cycle adjustment (0.7 or derived 5-cycle result) was incompletely propogated throughout the charge-depleting calculations. The impact on label values should be none to very minor, affecting only those vehicles that would have been able to use an adjustment for the transition cycle that differs from 0.7. This does not happen often. \nFixed an error in the calculation of the unadjusted highway electricity Kw-Hr/100 miles, where the calculation was referencing the charge-depleting fraction from the city schedule. This does not affect any label values, only values put on the web in the online spreadsheets. \nRevised the calculation of all-electric range. Previous versions summed the distances of all-electric cycles without attention to whether the first cycle was all-electric. Thus PHEVs with no all-electric range could have appeared to have an all-electric range. You should, of course, continue to override this estimate with the actual range recorded from the test, if available.\nImproved the ability to look at all-electric range and determine whether or not a PHEV is eligible for CAFE dual fuel vehicle calculations. \nCorrected an error in the Average New Vehicle 5-Year Fuel Cost for model year 2018. The correct value is $6,750, per EPA guidance CD-16-18. \nAdded label inputs - fuel prices, ratings scales, etc. - for the 2019 model year. From EPA guidance letter cd-17-18.\nAdded error-checking where CREE will not be calculated without both charge-depleting and charge-sustaining CREE data.\nFixed some cell references in Test Set #2 and #3 cost per mile calculations where formulae inadvertently referred to Test Set #1 test data."]
["26a","2019-05-31","Added some conditional formatting to visualize non-default values entered by users. For example, fuel density and heating value.\nCorrected the equation in cell F84, for Hwy2 Unadj FE - Alternative Fuel. There was a cell referencing error that could possible affect vehilces with multiple highway tests. This does not affect CAFE, GHG, or label values.\nAdded the capability to use Deterioration Factors (DF) for CREE values. Because City and HIghway values are submitted via a table in Verify, at this point a DF must be applied separately to each value, thus adjusting each value with a DF. The user may enter different City and Highway DFs. \nEquations were changed to perform rounding consistent with EV-CIS rounding.\nSuperfluous values were removed.\nDefault method for calculating Zn is now using Amp-hours, per the regulations. This is also designed into the EV-CIS calculations.\nCalculated intermediate values were rearranged to consolidate those values calculated specifically and solely from charge-depleting test data. Those values requiring charge-sustaining or other inputs are grouped separately. Similar metrics are now grouped together. \nIncreased the number of charge-depleting cycles accommodated by the calculator tp 35.\nExplanetory comments have been added to many of the inputs and calculated parameters. "]
["26b","2019-08-15","Changed release date of v26a above from \"TBD\" to May 31, 2019. \nAdded cell borders to charge-sustaining input section. \nAmended formulae for \"CD AC electricity consumption rate (Rcda), adjusted\" to round the kW-hr input to 4 decimal places; was previously rounded to 1 decimal. \nChanged cell F23 (combind CD electricity consumption) to be rounded to 4 decimal places. Was prevoiusly rounded to one decimal. \nCorrect an error in cells D23 and E23. Values need to be multiplied by 100. "]
[null,null,"Corrected cell references in cells D15 and E15. "]
[null,null,"Changed the rounding of label cit and highway Killowatt-hours per 100 miles to 3 decimal places. Previously was rounded to 4 decimals. "]
["26c","2019-10-10","Added 2020 model year label inputs. See guidance document CD-18-13, 12/17/2018. "]
[null,null,"Revised these version notes to reflect the current state of the calculator. "]
[null,null,"Removed values from the blank version of the template. "]
["26d","2020-01-08","Added 2021 model year label inputs. See guidance document CD-19-13 (Dec. 16, 2019). "]
["26e","2020-03-24","Changed fleet utility factor calculations such that each individual calculated FUF is not rounded. Continue to round the incremental fractional FUF (i.e., FUF(n) - FUF(n-1) ) to 3 decimals. This fix was applied both the 55/44 and 43/57 utility factors.\nThe Highway calculations in column BY were found to apply slightly different rounding than the UDDS calculations in column AX. The UDDS calculations are correct, and Highway calculations were fixed to match, rounding to a whole number after the calculation. "]
["26f","2021-03-22","Added 2022 model year label inputs. See EPA Guidance Letter CD-2020-20 (Dec. 28, 2020). Added the following comments:\n     - Added a comment in cells S10, S58, S106, AA10, AA58, AA106 \"Please enter a positive amp-hour value when current is flowing out of the battery and a negative amp-hour value when current is flowing into the battery.\"  This change is needed in order to help determine whether the cycle is CD or CS based on NEC 1% Tolerance (in columns BR and CS). \n     - Added a comment in cells T10, T58, T106, AB10, AB58, AB106 \"Ref. SAE J1711 (June 2010); Section 6.3.\"\n     - Revised terms in cells C53 to C117 to be more consistent with the terms used in EPA's EV-CIS (formerly Verify) database."]
[27,"2021-09-16","Fuel properties (CWF, Specific Gravity, Net Heating Value), HC-Total, and CO added to charge-depleting data tables.  Fuel economy and CREE are now calculated by PHEV calculator.  These values are now used in the remainder of the intermediate calculations.  Values of fuel economy and CREE entered by mfr are only included for comparison.  No support for Opt-CREE, there were no Opt-CREE GHG submissions by any manufacturer for 2020.\nTransition cycle is no longer calculated automatically.  Manufacturers are now required to enter it for each CD test.\nRecharge energy (AC kilowatt-hours) fields were changed from 3 decimal to 4 decimal to match calculations in EV-CIS.  This was a pre-existing field for electric only vehicles prior to PHEV implementation.  The rounding in all formulas prior to using these values was changed from ASTM(x,3) to ASTM(x,4).\nSupport for model years prior to 2017 has been removed.\n'Average Recharge Time of Test Vehicles' calculation for both CD_UDDS and CD_Hwy added.  Combined recharge time using a 55/45 weighting and a 50/50 weighting of those values has also been added.  These new calculations were requested by manufacturers.\nData validation and conditional formatting added for most/all input fields including main CD data input tables.  Incorrect values will be highlighted in orange.\nNew table added for entering CD and CS test numbers.  CS conditional formating  based on the number of EV-CIS test numbers entered.\nNew macro for importing data from an EV-CIS validated xml file (from Request Database Report).  Can also be used to compare calculator data to xml file data and highlight differences.  To run macro: select the 'blank calculator v27' tab and select one of the cells labeled 'Miles [3]' (one of the headers of largest input tables) and type: <Alt-t>,m,m.  Select the desired macro.  Main macro can also be ran by clicking the button included in the spreadsheet.  Additional macros included for clearing a single CD test or all user data.  \nCustom 'D5C' function added to perform Derived 5-cycle FE and CO2 calculations for gasoline vehicles (2017+ coefficients only).  New function can only be used in cells for charge-sustaining adjusted FE and adjusted CO2.  These cells are in the block labeled \"ENTER CHARGE-SUSTAINING TEST RESULTS HERE\".  See \"Sample EPA data\" tab for examples on this function.  No function available for modified or full 5-cycle labels.\nCREE DF calculations corrected to add the DF for each CD/CS combination rather than after all tests have been combined. \nFor questions specifically about the changes to the V27 release, contact Robert Peavyhouse at Peavyhouse.Robert@epa.gov."]
["27a","2022-01-12","Added 2023 model year label inputs. See EPA Guidance Letter CD-2022-01, January 3, 2022."]
["27b","2022-05-03","Added support for HD 2b/3, where calculations are based on CO2 instead of CREE.  When 2b/3 is selected for 'Vehicle Category', many calculations will be disabled, and others modified to use CO2 instead of CREE.  For example: Fuel economy calculations in columns Z and AL will be disabled, and CREE calculations in columns AA and AM will be set to their corresponding CO2 values.  When 2b/3 is selected all fuel economy, 5-cycle adjusted, and CAFE values will be set to N/A.  Cell formatting will be enforced to require the CREE inputs in columns N and O to be set equal to their corresponding CO2 values in the same columns.  "]
["27c","2023-03-01","Added 2024 model year label inputs. See EPA Guidance Letter CD-2022-16, December 26, 2022."]
["27d","2023-11-28","CD_Hwy fuel economy calculation for datasets 2 and 3 were using fuel properties for dataset 1."]
[28,"2024-09-10","Added 2025 model year label inputs.\nRemoved intermediate charge-depleting calculations already performed by the EV-CIS test module.  All test data including both charge-depleting and charge-sustaining tests are now imported directly from validated EV-CIS xml files.  Charge-sustaining derived 5-cycle, modified 5-cycle, and vehicle specific 5-cycle calculations are performed by macro.  When the macro asks to select a Charge-Depleting test, select ONE test.  When the macro asks to select Charge-Sustaining tests, select ALL of the corresponding tests.  For this reason, all Charge-Sustaining tests should be located within the same directory.\nValidated xml files can be exported from EV-CIS by using the \"Request Database Report\" option in the Test Information Module.\nAny questions about this PHEV Calculator should be directed to \"Peavyhouse.Robert@epa.gov\"."]

{"sheet":"Label Inputs","index":1,"n_rows":104,"n_cols":44,"rows_kept":104,"cut":false,"hidden":false,"merged":[[2,27,2,30],[2,12,2,15],[2,17,2,20],[1,1,1,20],[2,1,2,10],[2,22,2,25]]}
[]
[null,"LABEL INPUTS: FROM EPA GUIDANCE LETTERS APPLICABLE TO THE APPROPRIATE MODEL YEAR"]
[null,"Fuel Prices",null,null,null,null,null,null,null,null,null,null,"Average New Vehicle Fuel Economy",null,null,null,null,"Average New Vehicle 5-Year Fuel Cost",null,null,null,null,"MPG Rating",null,null,null,null,"GHG Rating"]
[null,"Model\nYear","Regular Unleaded","Mid-Grade Unleaded","Premium Unleaded","Diesel","E85","LPG","CNG","Electricity","Hydrogen",null,"Model\nYear","MPG",null,null,null,"Model\nYear","5-Year Cost",null,null,null,"Model Year","Min","Max","Rating",null,"Model Year","Min","Max","Rating",null,null,null,1,{"$f":"AI4+1","v":2},{"$f":"AJ4+1","v":3},4,5,6,7,8,9,10]
[null,2011,3,3.1,3.2,3.1,2.6,null,1.9,0.11,null,null,2011,"NA",null,null,null,2011,"NA",null,null,null,2016,0,13,1,null,2016,659,null,1,null,null,2016]
[null,2012,3.7,3.85,3.95,3.95,3.25,null,2.15,0.12,null,null,2012,"NA",null,null,null,2012,"NA",null,null,null,2016,14,15,2,null,2016,574,658,2,null,null,{"$f":"AH5+1","v":2017}]
[null,2013,3.55,3.65,3.8,3.8,3.1,null,2,0.12,null,null,2013,23,null,null,null,2013,11600,null,null,null,2016,16,17,3,null,2016,509,573,3,null,null,{"$f":"AH6+1","v":2018}]
[null,2014,3.5,3.6,3.75,3.85,3.1,null,2,0.12,null,null,2014,23,null,null,null,2014,11500,null,null,null,2016,18,20,4,null,2016,435,508,4,null,null,2019]
[null,2015,3.5,3.65,3.8,3.75,3.1,null,2,0.12,null,null,2015,24,null,null,null,2015,11000,null,null,null,2016,21,24,5,null,2016,364,434,5,null,null,2020]
[null,2016,3,3.15,3.3,3.35,2.6,null,1.55,0.13,null,null,2016,25,null,null,null,2016,9000,null,null,null,2016,25,27,6,null,2016,324,363,6,null,null,2021]
[null,2017,2.4500000000000002,2.65,2.8,2.75,2.0499999999999998,null,2.1,0.13,null,null,2017,26,null,null,null,2017,7000,null,null,null,2016,28,31,7,null,2016,283,323,7,null,null,2022]
[null,2018,2.4,2.6,2.8,2.65,1.95,null,2.1,0.13,null,null,2018,27,null,null,null,2018,6750,null,null,null,2016,32,37,8,null,2016,238,282,8,null,null,2023]
[null,2019,2.5499999999999998,2.8,3,2.85,2.15,null,2.1,0.13,null,null,2019,27,null,null,null,2019,7000,null,null,null,2016,38,45,9,null,2016,196,237,9,null,null,2024]
[null,2020,2.7,3,3.25,3.15,2.2999999999999998,null,2.1,0.13,null,null,2020,27,null,null,null,2020,7500,null,null,null,2016,46,99999,10,null,2016,0,195,10,null,null,2025]
[null,2021,2.7,3,3.25,3,2.25,null,2.15,0.13,null,null,2021,27,null,null,null,2021,7500,null,null,null,2017,0,14,1,null,2017,614,null,1,null,null,2026]
[null,2022,2.35,2.7,2.95,2.5499999999999998,1.95,null,2.15,0.13,null,null,2022,27,null,null,null,2022,6500,null,null,null,2017,15,16,2,null,2017,540,613,2,null,null,2027]
[null,2023,2.95,3.4,3.65,3.2,2.6,null,2.15,0.14000000000000001,null,null,2023,28,null,null,null,2023,8000,null,null,null,2017,17,18,3,null,2017,481,539,3,null,null,2028]
[null,2024,3.6,4.05,4.3,4.4000000000000004,3.15,null,2.2000000000000002,0.15,null,null,2024,28,null,null,null,2024,9750,null,null,null,2017,19,21,4,null,2017,414,480,4,null,null,2029]
[null,2025,3.5,4,4.25,4.0999999999999996,3.05,null,2.25,0.16,null,null,2025,28,null,null,null,2025,9500,null,null,null,2017,22,25,5,null,2017,350,413,5,null,null,2030]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,26,28,6,null,2017,313,349,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,29,32,7,null,2017,274,312,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,33,37,8,null,2017,238,273,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,38,43,9,null,2017,205,237,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,44,99999,10,null,2017,0,204,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,0,14,1,null,2018,614,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,15,16,2,null,2018,540,613,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,17,19,3,null,2018,457,539,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,20,22,4,null,2018,396,456,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,23,26,5,null,2018,336,395,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,27,29,6,null,2018,302,335,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,30,32,7,null,2018,274,301,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,33,37,8,null,2018,238,273,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,38,43,9,null,2018,205,237,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,44,99999,10,null,2018,0,204,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,0,14,1,null,2019,614,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,15,16,2,null,2019,540,613,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,17,19,3,null,2019,457,539,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,20,22,4,null,2019,396,456,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,23,26,5,null,2019,336,395,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,27,29,6,null,2019,302,335,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,30,32,7,null,2019,274,301,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,33,37,8,null,2019,238,273,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,38,43,9,null,2019,205,237,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,44,99999,10,null,2019,0,204,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,0,14,1,null,2020,614,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,15,16,2,null,2020,540,613,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,17,19,3,null,2020,457,539,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,20,22,4,null,2020,396,456,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,23,26,5,null,2020,336,395,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,27,29,6,null,2020,302,335,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,30,33,7,null,2020,266,301,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,34,38,8,null,2020,232,265,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,39,44,9,null,2020,201,231,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,45,99999,10,null,2020,0,200,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,0,14,1,null,2021,614,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,15,16,2,null,2021,540,613,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,17,19,3,null,2021,457,539,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,20,22,4,null,2021,396,456,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,23,26,5,null,2021,336,395,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,27,30,6,null,2021,292,335,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,31,35,7,null,2021,251,291,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,36,42,8,null,2021,210,250,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,43,52,9,null,2021,170,209,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,53,99999,10,null,2021,0,169,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,0,13,1,null,2022,659,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,14,15,2,null,2022,574,658,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,16,18,3,null,2022,481,573,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,19,21,4,null,2022,414,480,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,22,26,5,null,2022,336,413,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,27,30,6,null,2022,292,335,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,31,36,7,null,2022,244,291,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,37,44,8,null,2022,201,243,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,45,57,9,null,2022,156,200,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,58,99999,10,null,2022,0,155,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,0,13,1,null,2023,659,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,14,15,2,null,2023,574,658,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,16,17,3,null,2023,509,573,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,18,21,4,null,2023,414,508,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,22,27,5,null,2023,324,413,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,28,33,6,null,2023,266,323,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,34,40,7,null,2023,220,265,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,41,51,8,null,2023,174,219,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,52,71,9,null,2023,125,173,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,72,99999,10,null,2023,0,124,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,0,13,1,null,2024,659,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,14,15,2,null,2024,574,658,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,16,17,3,null,2024,509,573,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,18,21,4,null,2024,414,508,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,22,27,5,null,2024,324,413,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,28,33,6,null,2024,266,323,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,34,42,7,null,2024,210,265,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,43,58,8,null,2024,153,209,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,59,91,9,null,2024,98,152,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,92,99999,10,null,2024,0,97,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,0,13,1,null,2025,659,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,14,15,2,null,2025,574,658,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,16,17,3,null,2025,509,573,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,18,21,4,null,2025,414,508,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,22,27,5,null,2025,324,413,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,28,33,6,null,2025,266,323,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,34,44,7,null,2025,201,265,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,45,65,8,null,2025,137,200,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,66,120,9,null,2025,75,136,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,121,99999,10,null,2025,0,74,10]

{"sheet":"PHEV Calculator","index":2,"n_rows":146,"n_cols":26,"rows_kept":146,"cut":false,"hidden":false,"merged":[[0,1,1,6],[2,16,4,16],[86,14,86,15],[37,14,37,15],[6,13,7,16],[12,13,13,16],[3,14,3,15],[4,14,4,15],[28,13,28,16],[110,13,111,16],[104,13,105,16],[100,16,102,16],[51,16,53,16],[135,14,135,15],[55,13,56,16],[52,14,52,15],[53,14,53,15],[61,13,62,16],[101,14,101,15],[102,14,102,15],[77,13,77,16],[126,13,126,16]]}
[null,"PHEV Calculator Version 28"]
[]
[null,"CALCULATED CAFE, GHG, AND LABEL VALUES",null,null,null,null,null,null,"ENTER BASIC VEHICLE INFORMATION HERE",null,null,null,null,"Test Set #1",null,null,1,null,"INTERMEDIATE CALCULATIONS AND INPUTS","Test Set #1:",{"$f":"O4","v":0},null,"Results from Test Set #1:",{"$f":"O4","v":0}]
[null,null,"CAFE Values",null,null,null,null,null,"EV-CIS Model Type Information",null,null,null,null,"Test Set name (e.g., Eco, Power):",null,null,null,null,"Charge-Depleting (CD) Test Results",null,null,null,"CAFE Values"]
[null,"ü","A. PHEV meets dual fuel criteria:","City","Highway","Combined",null,null,"Model year:",null,null,null,null,"Production Volume (projected or actual):",null,null,null,null,"DRIVING DISTANCE VALUES","CD City","CD Hwy",null,"A. PHEV meets dual fuel criteria:","City","Highway","Combined"]
[null,"→"," 1. Default 50/50 Composite MPGe",{"$f":"IF($O$5+$O$54+$O$103=0,    ((X6<>0)+(X55<>0)+(X104<>0))/(IFERROR(1/X6,0)+IFERROR(1/X55,0)+IFERROR(1/X104,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/X6,0)+IFERROR($O$54/X55,0)+IFERROR($O$103/X104,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,    ((Y6<>0)+(Y55<>0)+(Y104<>0))/(IFERROR(1/Y6,0)+IFERROR(1/Y55,0)+IFERROR(1/Y104,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/Y6,0)+IFERROR($O$54/Y55,0)+IFERROR($O$103/Y104,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(1/(0.55/D6+0.45/E6),4)","v":{"$error":"#VALUE!"}},"←",null,"Manufacturer Code (3 Capital Alpha Char):",null,null,null,null,null,null,null,null,null,"CD driving distance (Rcda), unadjusted (miles) [3]",null,null,null," 1. Default 50/50 Composite MPGe [4]",{"$f":"IF(O46,   ASTM(1/(0.5/(($J$22)/(T11/T36))+0.5/O31),4),  0)","v":0},{"$f":"IF(P46,   ASTM(1/(0.5/(($J$22)/(U11/U36))+0.5/P31),4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X6),ISNUMBER(Y6)),   ASTM(1/(0.55/X6+0.45/Y6),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,"→"," 2. Optional Utility Factor Composite MPGe",{"$f":"IF($O$5+$O$54+$O$103=0,    ((X7<>0)+(X56<>0)+(X105<>0))/(IFERROR(1/X7,0)+IFERROR(1/X56,0)+IFERROR(1/X105,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/X7,0)+IFERROR($O$54/X56,0)+IFERROR($O$103/X1087,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,    ((Y7<>0)+(Y56<>0)+(Y105<>0))/(IFERROR(1/Y7,0)+IFERROR(1/Y56,0)+IFERROR(1/Y105,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/Y7,0)+IFERROR($O$54/Y56,0)+IFERROR($O$103/Y1087,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(1/(0.55/D7+0.45/E7),4)","v":{"$error":"#VALUE!"}},"←",null,"Model type index (Max 3 digits):",null,null,null,null,"IMPORT CHARGE-DEPLETING TEST XML DATA",null,null,null,null,"CD driving distance (Rcda), adjusted (miles) [3]",null,null,null," 2. Optional Utility Factor Composite MPGe [4]",{"$f":"IF(O46,   ASTM(1/(T39/(($J$22)/(T11/T36))+(1-T39)/O31), 4),   0)","v":0},{"$f":"IF(P46,   ASTM(1/(U39/(($J$22)/(U11/U36))+(1-U39)/P31), 4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X7),ISNUMBER(Y7)),   ASTM(1/(0.55/X7+0.45/Y7),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,"þ","B. PHEV does NOT meet dual fuel criteria:","City","Highway","Combined",null,null,"Data Submission Revision (start at 1)",null,null,null,null,null,null,null,null,null,"CD all-electric driving distance, unadjusted (miles) [3]",null,null,null,"B. PHEV does NOT meet dual fuel criteria:","City","Highway","Combined"]
[null,"→","  1. Utility Factor Composity MPGe",{"$f":"IF($O$5+$O$54+$O$103=0,    ((X9<>0)+(X58<>0)+(X107<>0))/(IFERROR(1/X9,0)+IFERROR(1/X58,0)+IFERROR(1/X107,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/X9,0)+IFERROR($O$559/X58,0)+IFERROR($O$103/X107,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,    ((Y9<>0)+(Y58<>0)+(Y107<>0))/(IFERROR(1/Y9,0)+IFERROR(1/Y58,0)+IFERROR(1/Y107,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/Y9,0)+IFERROR($O$559/Y58,0)+IFERROR($O$103/Y107,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(1/(0.55/D9+0.45/E9),4)","v":{"$error":"#VALUE!"}},"←",null,"Vehicle Information",null,null,null,null,null,"CD Procedure","Test Number ","Vehicle ID/Cfg",null,"CD All-Electric Range, adjusted (mi) [3]",null,null,null,"  1. Utility Factor Composite MPGe [4]",{"$f":"IF(O46,   ASTM(1/(T15+(1-T30)/O31),4),   0)","v":0},{"$f":"IF(P46,   ASTM(1/(U15+(1-U30)/P31),4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X9),ISNUMBER(Y9)),   ASTM(1/(0.55/X9+0.45/Y9),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,null,"Based on the all-electric range, is this PHEV a dual fuel vehicle for CAFE?",null,null,{"$f":"IF(OR($J$10=\"LT\",AND($J$10=\"PV\",D12>=7.5,E12>=10.2)),\"YES\",\"NO\")","v":"NO"},null,null,"Vehicle category:",null,null,null,null,"Charge-Depleting Test (Required):",null,null,null,null,"FUEL CONSUMPTION & ECONOMY VALUES","CD City","CD Hwy",null,"GHG Values","City","Highway","Combined"]
[null,null,"(City >= 7.5, and Highway >=10.2)","City","Highway","Combined",null,null,"Manufacturer name:",null,null,null,null,"Charge-Depleting Test (Required):",null,null,null,null,"CD AC electricity consumption (Rcdc), unadjusted (Watt-hours) [1]",null,null,null,"Composite CREE no DF, (g/mi) [1]",{"$f":"IF(O46,   ASTM(T27+(1-T30)*O33,1),   0)","v":0},{"$f":"IF(P46,   ASTM(U27+(1-U30)*P33,1),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X11),ISNUMBER(Y11)),   ASTM(0.55*X11+0.45*Y11,1),   NA())","v":0}]
[null,null,"All-Electric Range (miles, unadjusted)",{"$f":"IFERROR(ASTM( IF($O$5+$O$54+$O$103=0,SUM(IFERROR(T8,0),IFERROR(T57,0),IFERROR(T106,0)) / ((T8<>0)+(T57<>0)+(T106<>0)),($O$5*T8+$O$54*T57+$O$103*T106)/($O$5+$O$54+$O$103)),1),0)","v":0},{"$f":"IFERROR(ASTM( IF($O$5+$O$54+$O$103=0,SUM(IFERROR(U8,0),IFERROR(U57,0),IFERROR(U106,0)) / ((U8<>0)+(U57<>0)+(U106<>0)),($O$5*U8+$O$54*U57+$O$103*U106)/($O$5+$O$54+$O$103)),1),0)","v":0},{"$f":"0.55*D12+0.45*E12","v":0},null,null,"Model name:",null,null,null,null,null,null,null,null,null,"CD AC electricity consumption rate (Rcda), adjusted  (kW-hr/100mi) [3]",null,null,null,"Composite CREE w/DF, (g/mi) [1]",{"$f":"IF(O46,   IF($J$17=\"Additive\",ASTM((T27+(1-T30)*O33),0)+ASTM($J$18,0),IF($J$17=\"Multiplicative\",ASTM(ASTM((T27+(1-T30)*O33),0)*$J$18,0),\"Add/Mult?\")),   0)","v":0},{"$f":"IF(P46,   IF($J$17=\"Additive\",ASTM((U27+(1-U30)*P33),0)+ASTM($J$19,0),IF($J$17=\"Multiplicative\",ASTM(ASTM((U27+(1-U30)*P33),0)*$J$19,0),\"Add/Mult?\")),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X12),ISNUMBER(Y12)),   ASTM(0.55*X12+0.45*Y12,1),   NA())","v":0}]
[null,null,null,null,null,null,null,null,"Liquid fuel type:",null,null,null,null,"IMPORT CHARGE-SUSTAINING XML DATA",null,null,null,null,"CD test total DC energy consumed, unadjusted (Watt-hours) [1]",null,null,null,"Label Values (5-Cycle Adjusted)"]
[null,null,"GHG Values","City","Highway","Combined",null,null,"Additional descriptors as needed:",null,null,null,null,null,null,null,null,null,"CD Rcda total fuel consumption (Rcda), unadjusted (gal equiv) [4]",null,null,null,"Charge-Depleting",null,null,"Combined"]
[null,null,"Composite CREE, without DF (g/mi)",{"$f":"IF($O$5+$O$54+$O$103=0,ASTM( SUM(IFERROR(X11,0),IFERROR(X60,0),IFERROR(X109,0))/((X11<>0)+(X60<>0)+(X109<>0)),1),ASTM(($O$5*X11+$O$54*X60+$O$103*X109)/($O$5+$O$54+$O$103),1))","v":{"$error":"#VALUE!"}},{"$f":"IF($O$5+$O$54+$O$103=0,ASTM( SUM(IFERROR(Y11,0),IFERROR(Y60,0),IFERROR(Y109,0))/((Y11<>0)+(Y60<>0)+(Y109<>0)),1),ASTM(($O$5*Y11+$O$54*Y60+$O$103*Y109)/($O$5+$O$54+$O$103),1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(O33=0,P33=0,X11=0,Y11=0),\"ERROR\", IFERROR(ASTM(0.55*D15+0.45*E15,1),\"CREE ERROR\")  )","v":"ERROR"},null,null,"Fuel tank size (U.S. gallons):",null,null,null,null,null,"CS Procedure","Test Number","Vehicle ID/Cfg",null,"CD utilitized total fuel consumption rate (55/45 FUF, Rcdc), unadjusted (gal-equiv/mile) [6]",null,null,null,"CD range, adjusted (miles) [0]",null,null,{"$f":"IF(AND(O46,P46),   ASTM(0.55*T7+0.45*U7,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Composite CREE, with DF (g/mi)",{"$f":"IF(OR(AND(J17<>\"Additive\",J17<>\"Multiplicative\"),ISBLANK(J18)=TRUE),\"DF ERROR\",          ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(X12,0),IFERROR(X61,0),IFERROR(X110,0))/((X12<>0)+(X61<>0)+(X110<>0)),($O$5*X12+$O$54*X61+$O$103*X110)/($O$5+$O$54+$O$103)),1)          )","v":"DF ERROR"},{"$f":"IF(OR(AND(J17<>\"Additive\",J17<>\"Multiplicative\"),ISBLANK(J19)=TRUE),\"DF ERROR\",          ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(Y12,0),IFERROR(Y61,0),IFERROR(Y110,0))/((Y12<>0)+(Y61<>0)+(Y110<>0)),($O$5*Y12+$O$54*Y61+$O$103*Y110)/($O$5+$O$54+$O$103)),1)          )","v":"DF ERROR"},{"$f":"IF(OR(O33=0,P33=0,X12=0,Y12=0),\"ERROR\", IFERROR(ASTM(0.55*D16+0.45*E16,1),\"CREE ERROR\")  )","v":"ERROR"},null,null,"Deterioration Factors for GHG (CREE) Values (All 3 Required)",null,null,null,null,"Charge-Sustaining Test (Required): =====>",null,null,null,null,"CD utilitized total fuel consumption rate (43/57 FUF, Rcdc), adjusted (gal-equiv/mile) [6]",null,null,null,"CD All-Electric Range, adjusted (mi) [0]",null,null,{"$f":"IF(AND(O46,P46),   ASTM(0.55*T9+0.45*U9,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Label Values (5-Cycle Adjusted)",null,null,null,null,null,"Select DF type:",null,null,null,null,"Charge-Sustaining Test (Required): =====>",null,null,null,null,"CD utilitized total fuel consumption rate (MDIUF, Rcdc), adjusted (gal-equiv/mile) [6]",null,null,null,"Total Driving Range (Miles) [0]",null,null,{"$f":"IF(AND(O46,P46,ISNUMBER(Z15)),   ASTM((ASTM(0.55*T37+0.45*U37,0)+Z15)/10,0) *10,   NA())","v":{"$error":"#N/A"}}]
[null,null,"Charge-Depleting","City","Highway","Combined",null,null,"City DF:",null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD gasoline consumption (Rcda), unadjusted (gal) [1]",null,null,null,"CD Fuel Economy (MPGe) [0]",null,null,{"$f":"IF(AND(O46,P46),   ASTM(1/(0.55/T19+0.45/U19),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Charge-depleting Range (Miles)",{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(T7,0),IFERROR(T56,0),IFERROR(T105,0)) / ((T7<>0)+(T56<>0)+(T105<>0)),($O$5*T7+$O$54*T56+$O$103*T105)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(U7,0),IFERROR(U56,0),IFERROR(U105,0)) / ((U7<>0)+(U56<>0)+(U105<>0)),($O$5*U7+$O$54*U56+$O$103*U105)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(0.55*D19+0.45*E19,0)","v":{"$error":"#VALUE!"}},null,null,"Highway DF:",null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD fuel economy (Rcda), adjusted (MPGe) [4]",null,null,null,"CD Electricity Consumption  (kW-hr/100mi) [0]",null,null,{"$f":"IF(AND(O46,P46),   ASTM(0.55*T12+0.45*U12,0),   NA())","v":{"$error":"#N/A"}}]
[null,null," All-Electric Range (Miles)",{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(T9,0),IFERROR(T58,0),IFERROR(T107,0)) / ((T9<>0)+(T58<>0)+(T107<>0)),($O$5*T9+$O$54*T58+$O$103*T107)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(U9,0),IFERROR(U58,0),IFERROR(U107,0)) / ((U9<>0)+(U58<>0)+(U107<>0)),($O$5*U9+$O$54*U58+$O$103*U107)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(0.55*D20+0.45*E20,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD gasoline consumption rate (Rcda), adjusted (gal/100mi) [4]",null,null,null,"CD Gasoline Consumption (gal/100mi) [0]",null,null,{"$f":"IF(AND(O46,P46),   ASTM(0.55*T20+0.45*U20,1),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Total Driving Range (Miles)",null,null,{"$f":"ASTM((IF($O$5+$O$54+$O$103=0,SUM(IFERROR(( IFERROR((ASTM(0.55*T37+0.45*U37,0)+Z15),0)),0),IFERROR((IFERROR((ASTM(0.55*T86+0.45*U86,0)+Z64),0)),0),IFERROR(( IFERROR((ASTM(0.55*T135+0.45*U135,0)+Z113),0)),0)) / ((( IFERROR((ASTM(0.55*T37+0.45*U37,0)+Z15),0))<>0)+((IFERROR((ASTM(0.55*T86+0.45*U86,0)+Z64),0))<>0)+(( IFERROR((ASTM(0.55*T135+0.45*U135,0)+Z113),0))<>0)),($O$5*( IFERROR((ASTM(0.55*T37+0.45*U37,0)+Z15),0))+$O$54*(IFERROR((ASTM(0.55*T86+0.45*U86,0)+Z64),0))+$O$103*( IFERROR((ASTM(0.55*T135+0.45*U135,0)+Z113),0)))/($O$5+$O$54+$O$103)))/10,0)*10","v":{"$error":"#VALUE!"}},null,null,"Label Constants Based on Model Year and Fuel Type",null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD fuel economy (Rcda), unadjusted (MPGe) [4]",null,null,null,"Charge-Sustaining",null,null,"Combined"]
[null,null,"CD Fuel Economy (MPGe)",{"$f":"ASTM(IF($O$5+$O$54+$O$103=0, ((T19<>0)+(T68<>0)+(T117<>0))/(IFERROR(1/T19,0)+IFERROR(1/T68,0)+IFERROR(1/T117,0)), ($O$5+$O$54+$O$103) / (IFERROR($O$5/T19,0)+IFERROR($O$54/T68,0)+IFERROR($O$103/T117,0))  ),4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IF($O$5+$O$54+$O$103=0, ((U19<>0)+(U68<>0)+(U117<>0))/(IFERROR(1/U19,0)+IFERROR(1/U68,0)+IFERROR(1/U117,0)), ($O$5+$O$54+$O$103) / (IFERROR($O$5/U19,0)+IFERROR($O$54/U68,0)+IFERROR($O$103/U117,0))  ),4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(0.55*D22+0.45*E22,0)","v":{"$error":"#VALUE!"}},null,null,"Petroleum Equivalency Factor",{"$f":"_xlfn.IFS(ISBLANK($J$5),NA(),$J$5<=2026,82049,$J$5=2027,79989,$J$5=2028,50427,$J$5=2029,36820,$J$5>=2030,28996)","v":{"$error":"#N/A"}},null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD AC electricity consumption rate (Rcda), unadjusted  (kW-hr/100mi) [3]",null,null,null,"CS Fuel Economy (MPG) [0]",{"$f":"IF(O46,   ASTM(O32,4),   0)","v":0},{"$f":"IF(P46,   ASTM(P32,4),   0)","v":0},{"$f":"IF(AND(O46,P46),   ASTM(1/(0.55/X22+0.45/Y22),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"CD Electricity Consumption  (kW-hr/100mi)",{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(T12,0),IFERROR(T61,0),IFERROR(T110,0)) / ((T12<>0)+(T61<>0)+(T110<>0)),($O$5*T12+$O$54*T61+$O$103*T110)/($O$5+$O$54+$O$103)),4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(U12,0),IFERROR(U61,0),IFERROR(U110,0)) / ((U12<>0)+(U61<>0)+(U110<>0)),($O$5*U12+$O$54*U61+$O$103*U110)/($O$5+$O$54+$O$103)),4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(0.55*D23+0.45*E23,4)","v":{"$error":"#VALUE!"}},null,null,"Gasoline cost ($/gallon)",{"$f":"INDEX('Label Inputs'!C5:K19,MATCH(J5,'Label Inputs'!B5:B19,0),MATCH(J13,'Label Inputs'!C4:K4,0))","v":{"$error":"#N/A"}},null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"GHG EMISSIONS VALUES","CD City","CD Hwy",null,"CS Fuel Consumption (gal/100mi) [1]",{"$f":"IFERROR(ASTM(100/X22,1),0)","v":0},{"$f":"IFERROR(ASTM(100/Y22,1),0)","v":0},{"$f":"IF(ISNUMBER(Z22),   ASTM(100/Z22,1),   NA())","v":{"$error":"#N/A"}}]
[null,null,"CD Gasoline Consumption (gal/100mi)",{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(T20,0),IFERROR(T69,0),IFERROR(Y118,0)) / ((T12<>0)+(T61<>0)+(T110<>0)),      ($O$5*T20+$O$54*T69+$O$103*T118)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(U20,0),IFERROR(U69,0),IFERROR(Z118,0)) / ((U12<>0)+(U61<>0)+(U110<>0)),      ($O$5*U20+$O$54*U69+$O$103*U118)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(0.55*D24+0.45*E24,4)","v":{"$error":"#VALUE!"}},null,null,"Electricity cost ($/kW-hour)",{"$f":"INDEX('Label Inputs'!C5:K19,MATCH(J5,'Label Inputs'!B5:B19,0),MATCH(\"Electricity\",'Label Inputs'!C4:K4,0))","v":{"$error":"#N/A"}},null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD CO2 emissions rate (Rcda), unadjusted (g/mi) [1]",null,null,null,"Composite CD/CS",null,null,"Combined"]
[null,null,"Charge-Sustaining","City","Highway","Combined",null,null,"Average vehicle 5-year cost ($)",{"$f":"VLOOKUP(J5,'Label Inputs'!R4:S19,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD CO2 emissions rate (Rcda), adjusted (g/mi) [1]",null,null,null,"Annual Fuel Cost ($/year) [0]",null,null,{"$f":"IF(AND(O46,P46),   ASTM(15000*ASTM(0.55*T45+0.45*U45,3)/50,0)*50,   NA())","v":{"$error":"#N/A"}}]
[null,null,"CS Fuel Economy (MPG)",{"$f":"IF($O$5+$O$54+$O$103=0,    ((X22<>0)+(X71<>0)+(X120<>0))/(IFERROR(1/X22,0)+IFERROR(1/X71,0)+IFERROR(1/X120,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/X22,0)+IFERROR($O$54/X71,0)+IFERROR($O$103/X120,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,    ((Y22<>0)+(Y71<>0)+(Y120<>0))/(IFERROR(1/Y22,0)+IFERROR(1/Y71,0)+IFERROR(1/Y120,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/Y22,0)+IFERROR($O$54/Y71,0)+IFERROR($O$103/Y120,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(1/(0.55/D26+0.45/E26),0)","v":{"$error":"#VALUE!"}},null,null,"Average vehicle MPG",{"$f":"VLOOKUP(J5,'Label Inputs'!M4:N19,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD utilitized CO2 (MDIUF, Rcdc), adjusted (g/mi) [1]",null,null,null,"5-Year Fuel Savings Value ($/5 years) [0]",null,null,{"$f":"IF(AND(ISNUMBER($J$25),ISNUMBER(Z25)),   $J$25-5*Z25,   NA())","v":{"$error":"#N/A"}}]
[null,null,"CS Fuel Consumption (gal/100mi)",{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(X23,0),IFERROR(X72,0),IFERROR(X121,0)) / ((X23<>0)+(X72<>0)+(X121<>0)),      ($O$5*X23+$O$54*X72+$O$103*X121)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(Y23,0),IFERROR(Y72,0),IFERROR(Y121,0)) / ((Y23<>0)+(Y72<>0)+(Y121<>0)),      ($O$5*Y23+$O$54*Y72+$O$103*Y121)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(100/F26,1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD utilitized CREE (55/45 FUF, Rcdc), unadjusted (g/mi) [1]",null,null,null,"Composite CO2 (g/mi) [0]",null,null,{"$f":"IF(AND(O46,P46),   ASTM(0.55*T47+0.45*U47,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Composite CD/CS","City","Highway","Combined",null,null,"Dataset Summary",null,null,null,null,null,null,null,null,null,"CD utilitized CREE (43/57 FUF, Rcdc), adjusted (g/mi) [1]",null,null,null,"Composite Fuel Economy (MPG) [0]",null,null,{"$f":"IF(AND(O46,P46),   ASTM(1/(0.55/T48+0.45/U48),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Annual Fuel Cost ($/year)",null,null,{"$f":"ASTM((IF($O$5+$O$54+$O$103=0,SUM(IFERROR((IFERROR(15000*ASTM(0.55*T45+0.45*U45,3),0)),0),IFERROR((IFERROR(15000*ASTM(0.55*T94+0.45*U94,3),0)),0),IFERROR((IFERROR(15000*ASTM(0.55*T143+0.45*U143,3),0)),0)) / (((IFERROR(15000*ASTM(0.55*T45+0.45*U45,3),0))<>0)+((IFERROR(15000*ASTM(0.55*T94+0.45*U94,3),0))<>0)+((IFERROR(15000*ASTM(0.55*T143+0.45*U143,3),0))<>0)),($O$5*(IFERROR(15000*ASTM(0.55*T45+0.45*U45,3),0))+$O$54*(IFERROR(15000*ASTM(0.55*T94+0.45*U94,3),0))+$O$103*(IFERROR(15000*ASTM(0.55*T143+0.45*U143,3),0)))/($O$5+$O$54+$O$103)))/50,0)*50","v":{"$error":"#VALUE!"}},null,null,"Dataset #1 status:",{"$f":"IF(AND(ISBLANK(O5),ISBLANK(O10),ISBLANK(O11),ISBLANK(O16)),\"Blank\",   IF(ISBLANK(O10),\"Missing CD_UDDS\",IF(ISBLANK(O11),\"Missing CD_Hwy\",IF(OR(ISBLANK(T6),ISBLANK(U6)),\"Missing CD Calcs\",IF(ISBLANK(O16),\"Missing CS Tests\",IF(ISBLANK(O31),\"Missing CS Calcs\",\"Complete\"))))))","v":"Blank"},null,null,null,"MACRO CALCULATED CHARGE-SUSTAINING TEST RESULTS",null,null,null,null,"UTILITY FACTORS & OTHER METRICS","CD City","CD Hwy",null,"HOV Lane Values","City","Highway","Combined"]
[null,null,"5-Year Fuel Savings Value ($/5 years)",null,null,{"$f":"ABS($J$25-5*F29)","v":{"$error":"#N/A"}},null,null,"Dataset #2 status:",{"$f":"IF(AND(ISBLANK(O54),ISBLANK(O59),ISBLANK(O60),ISBLANK(O65)),\"Blank\",   IF(ISBLANK(O59),\"Missing CD_UDDS\",IF(ISBLANK(O60),\"Missing CD_Hwy\",IF(OR(ISBLANK(T55),ISBLANK(U55)),\"Missing CD Calcs\",IF(ISBLANK(O65),\"Missing CS Tests\",IF(ISBLANK(O80),\"Missing CS Calcs\",\"Complete\"))))))","v":"Blank"},null,null,null,null,"CS City","CS Highway","Calc Type",null,"CD 55/45 Fleet Utility Factor (FUF) for Rcdc [3]",null,null,null,"MDIUF based on unadjusted Rcda [3]",{"$f":"IFERROR(ASTM(mdiuf(T6),3),0)","v":0},{"$f":"IFERROR(ASTM(mdiuf(U6),3),0)","v":0}]
[null,null,"Composite CO2 (g/mi)",{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(T47,0),IFERROR(T96,0),IFERROR(T145,0)) / ((T47<>0)+(T96<>0)+(T145<>0)),($O$5*T47+$O$54*T96+$O$103*T145)/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(U47,0),IFERROR(U96,0),IFERROR(U145,0)) / ((U47<>0)+(U96<>0)+(U145<>0)),($O$5*U47+$O$54*U96+$O$103*U145)/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(0.55*D31+0.45*E31,0)","v":{"$error":"#VALUE!"}},null,null,"Dataset #3 status:",{"$f":"IF(AND(ISBLANK(O103),ISBLANK(O108),ISBLANK(O109),ISBLANK(O114)),\"Blank\",   IF(ISBLANK(O108),\"Missing CD_UDDS\",IF(ISBLANK(O109),\"Missing CD_Hwy\",IF(OR(ISBLANK(T104),ISBLANK(U104)),\"Missing CD Calcs\",IF(ISBLANK(O114),\"Missing CS Tests\",IF(ISBLANK(O129),\"Missing CS Calcs\",\"Complete\"))))))","v":"Blank"},null,null,null,"Fuel Economy, Unadjusted (MPG):",null,null,null,null,"CD 43/57 Fleet Utility Factor (FUF) [3]",null,null,null,"Composite CD/CS Fuel Economy (MPGe) [4]",{"$f":"IFERROR(ASTM(1/(X30/(T6/T14)+(1-X30)/O31),4),0)","v":0},{"$f":"IFERROR(ASTM(1/(Y30/(U6/U14)+(1-Y30)/P31),4),0)","v":0},{"$f":"IFERROR(ASTM(1/(0.55/X31+0.45/Y31),4),0)","v":0}]
[null,null,"Composite Fuel Economy (MPG)",{"$f":"IF($O$5+$O$54+$O$103=0,    ((T48<>0)+(T97<>0)+(T146<>0))/(IFERROR(1/T48,0)+IFERROR(1/T97,0)+IFERROR(1/T146,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/T48,0)+IFERROR($O$54/T97,0)+IFERROR($O$103/T146,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,    ((U48<>0)+(U97<>0)+(U146<>0))/(IFERROR(1/U48,0)+IFERROR(1/U97,0)+IFERROR(1/U146,0)),    ($O$5+$O$54+$O$103) / (IFERROR($O$5/U48,0)+IFERROR($O$54/U97,0)+IFERROR($O$103/U146,0))  )","v":{"$error":"#DIV/0!"}},{"$f":"ASTM(1/(0.55/D32+0.45/E32),0)","v":{"$error":"#VALUE!"}},null,null,"Dataset #1 Production Volume",{"$f":"VALUE(O5)","v":0},null,null,null,"Fuel Economy, 5-Cycle Adjusted (MPG):",null,null,null,null,"MDIUF based on adjusted Rcda [3]",null,null,null,"Trends Report Values","City","Highway"]
[null,null,"MPG Rating (on scale of 1-10)",null,null,{"$f":"INDEX('Label Inputs'!$W$5:$Z$104, MATCH(1,('Label Inputs'!$W$5:$W$104=$J$5)*('Label Inputs'!$Y$5:$Y$104>=$F$32),0),4)","v":{"$error":"#N/A"}},null,null,"Dataset #2 Production Volume",{"$f":"VALUE(O54)","v":0},null,null,null,"CREE (g/mi):",null,null,null,null,"MDIUF based on adjusted Rcdc [3]",null,null,null,"Fleet Utility Factor (43/57) [3]",{"$f":"IF(O46,   T31,   0)","v":0},{"$f":"IF(P46,   U31,   0)","v":0}]
[null,null,"GHG Rating (on scale of 1-10)",null,null,{"$f":"INDEX('Label Inputs'!$AB$5:$AE$104, MATCH(1,('Label Inputs'!$AB$5:$AB$104=$J$5)*('Label Inputs'!$AC$5:$AC$104<=$F$31),0),4)","v":{"$error":"#N/A"}},null,null,"Dataset #3 Production Volume",{"$f":"VALUE(O103)","v":0},null,null,null,"CO2, Unadjusted (g/mi):",null,null,null,null,"Intermediate Results Requiring Charge-Sustaining (CS) Test Results or Other Inputs",null,null,null,"Unadjusted Fuel Economy (MPG) [4]",{"$f":"IF(O46,   X9,   0)","v":0},{"$f":"IF(P46,  Y9,   0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2, 5-Cycle Adjusted (g/mi):",null,null,null,null,"DRIVING DISTANCE VALUES","CITY","HIGHWAY",null,"Unadjusted GHG (g/mi) [1]",{"$f":"IF(O46,   ASTM(X11,1),   0)","v":0},{"$f":"IF(P46,   ASTM(Y11,1),   0)","v":0}]
[null,"THE FOLLOWING VALUES ARE USED FOR OTHER EPA PUBLICATIONS OR PROGRAMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD Equivalent All-Electric Range (EAER), Unadjusted (mi) [3]",{"$f":"IF(O43,   ASTM(T6*((O34-T24)/O34),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P43,   ASTM(U6*((P34-U24)/P34),3),   NA())","v":{"$error":"#N/A"}},null,"Adjusted Fuel Economy (MPG) [4]",{"$f":"IF(O46,   ASTM(1/(T16+(1-X33)/O32),4),   0)","v":0},{"$f":"IF(P46,   ASTM(1/(U16+(1-Y33)/P32),4),   0)","v":0}]
[null,null,"Trends Report Values","City","Highway",null,null,null,null,null,null,null,null,null,"City","Highway",null,null,"Charge-sustaining driving range, adjusted (mi) [3]",{"$f":"IF(O43,   ASTM((ASTM($J$15,1)-T18)*ASTM(O32,4),3),   0)","v":0},{"$f":"IF(P43,   ASTM((ASTM($J$15,1)-U18)*ASTM(P32,4),3),   0)","v":0},null,"Adjusted GHG (g/mi) [1]",{"$f":"IF(O46,   ASTM(T28+(1-X33)*ASTM(O35,1),1),   0)","v":0},{"$f":"IF(P46,   ASTM(U28+(1-Y33)*ASTM(P35,1),1),   0)","v":0}]
[null,null,"Fleet Utility Factor (43/57)",{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(X33,0),IFERROR(X82,0),IFERROR(X131,0))/((X33<>0)+(X82<>0)+(X131<>0)),($O$5*X33+$O$54*X82+$O$103*X131)/($O$5+$O$54+$O$103)),4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(Y33,0),IFERROR(Y82,0),IFERROR(Y131,0))/((Y33<>0)+(Y82<>0)+(Y131<>0)),($O$5*Y33+$O$54*Y82+$O$103*Y131)/($O$5+$O$54+$O$103)),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"Data Validation Vehicle Info",{"$f":"IF(AND(ISNUMBER($J$5),$J$5<=2025,ISNUMBER($J$15),OR($J$17=\"Additive\",$J$17=\"Multiplicative\"),ISNUMBER($J$18),ISNUMBER($J$19),ISNUMBER($J$22),ISNUMBER($J$23),ISNUMBER($J$24),ISNUMBER($J$25),ISNUMBER($J$26)),TRUE,FALSE)","v":false},null,null,null,"UTILITY FACTORS & OTHER METRICS","CITY","HIGHWAY"]
[null,null,"Unadjusted Fuel Economy (MPG)",{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((X34<>0)+(X83<>0)+(X132<>0))/(IFERROR(1/X34,0)+IFERROR(1/X83,0)+IFERROR(1/X132,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/X34,0)+IFERROR($O$54/X83,0)+IFERROR($O$103/X132,0))),4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((Y34<>0)+(Y83<>0)+(Y132<>0))/(IFERROR(1/Y34,0)+IFERROR(1/Y83,0)+IFERROR(1/Y132,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/Y34,0)+IFERROR($O$54/Y83,0)+IFERROR($O$103/Y132,0))),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"Data Validation CS",{"$f":"IF(AND(ISBLANK(O16)=FALSE,ISBLANK(P16)=FALSE,ISBLANK(O17)=FALSE,ISBLANK(P17)=FALSE,ISNUMBER(O31),ISNUMBER(O32),ISNUMBER(O33),ISNUMBER(O34),ISNUMBER(O35)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISBLANK(O16)=FALSE,ISBLANK(P16)=FALSE,ISBLANK(O17)=FALSE,ISBLANK(P17)=FALSE,ISNUMBER(P31),ISNUMBER(P32),ISNUMBER(P33),ISNUMBER(P34),ISNUMBER(P35)),TRUE,FALSE)","v":false},null,null,"CD 55/45 Fleet Utility Factor (FUF) for EAER [3]",{"$f":"IF(O43,   ASTM(cityfuf(T36),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P43,   ASTM(highwayfuf(U36),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Unadjusted GHG (g/mi)",{"$f":"ASTM(IFERROR(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(X35,0),IFERROR(X84,0),IFERROR(X133,0))/((X35<>0)+(X84<>0)+(X133<>0)),($O$5*X35+$O$54*X84+$O$103*X133)/($O$5+$O$54+$O$103)),\"CREE data error\"),1)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IFERROR(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(Y35,0),IFERROR(Y84,0),IFERROR(Y133,0))/((Y35<>0)+(Y84<>0)+(Y133<>0)),($O$5*Y35+$O$54*Y84+$O$103*Y133)/($O$5+$O$54+$O$103)),\"CREE data error\"),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O38,O39),TRUE,FALSE)","v":false},{"$f":"IF(AND(O38,P39),TRUE,FALSE)","v":false},null,null,"FUEL COSTS: PROCESS FOR DERIVING A COMPOSITE CD/CS COST PER MILE","CITY","HIGHWAY"]
[null,null,"Adjusted Fuel Economy (MPG)",{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((X36<>0)+(X85<>0)+(X134<>0))/(IFERROR(1/X36,0)+IFERROR(1/X85,0)+IFERROR(1/X134,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/X36,0)+IFERROR($O$54/X85,0)+IFERROR($O$103/X134,0))),4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((Y36<>0)+(Y85<>0)+(Y134<>0))/(IFERROR(1/Y36,0)+IFERROR(1/Y85,0)+IFERROR(1/Y134,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/Y36,0)+IFERROR($O$54/Y85,0)+IFERROR($O$103/Y134,0))),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"CD cost per mile - electricity ($/mi) [3]",{"$f":"IF(O43,   ASTM($J$24*T12/100,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P43,   ASTM($J$24*U12/100,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Adjusted GHG (g/mi)",{"$f":"ASTM(IFERROR(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(X37,0),IFERROR(X86,0),IFERROR(X135,0))/((X37<>0)+(X86<>0)+(X135<>0)),($O$5*X37+$O$54*X86+$O$103*X135)/($O$5+$O$54+$O$103)),\"CREE data error\"),1)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IFERROR(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(Y37,0),IFERROR(Y86,0),IFERROR(Y135,0))/((Y37<>0)+(Y86<>0)+(Y135<>0)),($O$5*Y37+$O$54*Y86+$O$103*Y135)/($O$5+$O$54+$O$103)),\"CREE data error\"),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"Data Validation Intermediate CD",{"$f":"IF(AND(ISNUMBER(T6),ISNUMBER(T7),ISNUMBER(T8),ISNUMBER(T9),   ISNUMBER(T11),ISNUMBER(T12),ISNUMBER(T13),ISNUMBER(T14),ISNUMBER(T15),ISNUMBER(T16),ISNUMBER(T17),ISNUMBER(T18),ISNUMBER(T19),ISNUMBER(T20),ISNUMBER(T21),ISNUMBER(T22),   ISNUMBER(T24),ISNUMBER(T25),ISNUMBER(T26),ISNUMBER(T27),ISNUMBER(T28),   ISNUMBER(T30),ISNUMBER(T31),ISNUMBER(T32),ISNUMBER(T33)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISNUMBER(U6),ISNUMBER(U7),ISNUMBER(U8),ISNUMBER(U9),   ISNUMBER(U11),ISNUMBER(U12),ISNUMBER(U13),ISNUMBER(U14),ISNUMBER(U15),ISNUMBER(U16),ISNUMBER(U17),ISNUMBER(U18),ISNUMBER(U19),ISNUMBER(U20),ISNUMBER(U21),ISNUMBER(U22),   ISNUMBER(U24),ISNUMBER(U25),ISNUMBER(U26),ISNUMBER(U27),ISNUMBER(U28),   ISNUMBER(U30),ISNUMBER(U31),ISNUMBER(U32),ISNUMBER(U33)),TRUE,FALSE)","v":false},null,null,"CD cost per mile - gasoline ($/mi) [3]",{"$f":"IF(O43,   ASTM($J$23 *(T18/T7),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P43,   ASTM($J$23 *(U18/U7),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"HOV Lane Values","City","Highway","Combined",null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O40,O42),TRUE,FALSE)","v":false},{"$f":"IF(AND(P40,P42),TRUE,FALSE)","v":false},null,null,"CD total cost per mile ($/mi) [3]",{"$f":"IF(O43,   ASTM(T41+T42,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P43,   ASTM(U41+U42,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"MDIUF based on unadjusted Rcda",{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(X30,0),IFERROR(X79,0),IFERROR(X128,0))/((X30<>0)+(X79<>0)+(X128<>0)),($O$5*X30+$O$54*X79+$O$103*X128)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,SUM(IFERROR(Y30,0),IFERROR(Y79,0),IFERROR(Y128,0))/((Y30<>0)+(Y79<>0)+(Y128<>0)),($O$5*Y30+$O$54*Y79+$O$103*Y128)/($O$5+$O$54+$O$103))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"CS cost per mile ($/mi) [3]",{"$f":"IF(O43,   ASTM($J$23/ASTM(O32,4),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P43,   ASTM($J$23/ASTM(P32,4),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Composite CD/CS Fuel Economy (MPGe)",{"$f":"IF($O$5+$O$54+$O$103=0,((X31<>0)+(X80<>0)+(X129<>0))/(IFERROR(1/X31,0)+IFERROR(1/X80,0)+IFERROR(1/X129,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/X31,0)+IFERROR($O$54/X80,0)+IFERROR($O$103/X129,0)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($O$5+$O$54+$O$103=0,((Y31<>0)+(Y80<>0)+(Y129<>0))/(IFERROR(1/Y31,0)+IFERROR(1/Y80,0)+IFERROR(1/Y129,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/Y31,0)+IFERROR($O$54/Y80,0)+IFERROR($O$103/Y129,0)))","v":{"$error":"#DIV/0!"}},{"$f":"1/(0.55/D45+0.45/E45)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Data Validation Intermediate CS",{"$f":"IF(AND(ISNUMBER(T36),ISNUMBER(T37),   ISNUMBER(T39),   ISNUMBER(T41),ISNUMBER(T42),ISNUMBER(T43),ISNUMBER(T44),ISNUMBER(T45),   ISNUMBER(T47),ISNUMBER(T48)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISNUMBER(U36),ISNUMBER(U37),   ISNUMBER(U39),   ISNUMBER(U41),ISNUMBER(U42),ISNUMBER(U43),ISNUMBER(U44),ISNUMBER(U45),   ISNUMBER(U47),ISNUMBER(U48)),TRUE,FALSE)","v":false},null,null,"Composite CD/CS cost ($/mi) [3]",{"$f":"IF(O43,   ASTM(T32*T43+(1-T32)*T44,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P43,   ASTM(U32*U43+(1-U32)*U44,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Fueleconomy.gov Values",null,null,null,null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O43,O45),TRUE,FALSE)","v":false},{"$f":"IF(AND(P43,P45),TRUE,FALSE)","v":false},null,null,"COMPOSITE CD/CS FUEL ECONOMY AND CO2 VALUES, ADJUSTED","CITY","HIGHWAY"]
[null,null,"Charge-sustaining Efficiency",null,null,"MPG",null,null,null,null,null,null,null,null,null,null,null,null,"Composite CD/CS CO2, adjusted (g/mi) [1]",{"$f":"IF(O43,   ASTM(T26+(1-T33)*O35,1),   0)","v":0},{"$f":"IF(P43,   ASTM(U26+(1-U33)*P35,1),   0)","v":0}]
[null,null,"City Rounded Adjusted FE (Guide) - Conventional Fuel",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((O32<>0)+(O81<>0)+(O130<>0))/(IFERROR(1/O32,0)+IFERROR(1/O81,0)+IFERROR(1/O130,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/O32,0)+IFERROR($O$54/O81,0)+IFERROR($O$103/O130,0))),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Composite CD/CS Fuel Economy, adjusted (MPG) [4]",{"$f":"IF(O43,   ASTM(1/(T17+(1-T33)/O32),4),   0)","v":0},{"$f":"IF(P43,   ASTM(1/(U17+(1-U33)/P32),4),   0)","v":0}]
[null,null,"Hwy Rounded Adjusted FE (Guide) - Conventional Fuel",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((P32<>0)+(P81<>0)+(P130<>0))/(IFERROR(1/P32,0)+IFERROR(1/P81,0)+IFERROR(1/P130,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/P32,0)+IFERROR($O$54/P81,0)+IFERROR($O$103/P130,0))),0)","v":{"$error":"#VALUE!"}}]
[null,null,"Combined Rounded Adjusted  FE (Guide) - Conventional Fuel",null,null,{"$f":"ASTM(1/(0.55/(IF($O$5+$O$54+$O$103=0,((O32<>0)+(O81<>0)+(O130<>0))/(IFERROR(1/O32,0)+IFERROR(1/O81,0)+IFERROR(1/O130,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/O32,0)+IFERROR($O$54/O81,0)+IFERROR($O$103/O130,0))))+0.45/(IF($O$5+$O$54+$O$103=0,((P32<>0)+(P81<>0)+(P130<>0))/(IFERROR(1/P32,0)+IFERROR(1/P81,0)+IFERROR(1/P130,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/P32,0)+IFERROR($O$54/P81,0)+IFERROR($O$103/P130,0))))),0)","v":{"$error":"#VALUE!"}}]
[null,null,"City Unrounded Unadjusted FE - Conventional Fuel",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((O31<>0)+(O80<>0)+(O129<>0))/(IFERROR(1/O31,0)+IFERROR(1/O80,0)+IFERROR(1/O129,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/O31,0)+IFERROR($O$54/O80,0)+IFERROR($O$103/O129,0))),1)","v":{"$error":"#VALUE!"}}]
[null,null,"Hwy Unrounded Unadjusted  FE - Conventional Fuel",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((P31<>0)+(P80<>0)+(P129<>0))/(IFERROR(1/P31,0)+IFERROR(1/P80,0)+IFERROR(1/P129,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/P31,0)+IFERROR($O$54/P80,0)+IFERROR($O$103/P129,0))),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Test Set #2",null,null,2,null,"INTERMEDIATE CALCULATIONS AND INPUTS","Test Set #2:",{"$f":"O53","v":0},null,"Results from Test Set #1:",{"$f":"O53","v":0}]
[null,null,"Combined Unrounded Unadjusted  FE - Conventional Fuel",null,null,{"$f":"ASTM(1/(0.55/(IF($O$5+$O$54+$O$103=0,((O31<>0)+(O80<>0)+(O129<>0))/(IFERROR(1/O31,0)+IFERROR(1/O80,0)+IFERROR(1/O129,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/O31,0)+IFERROR($O$54/O80,0)+IFERROR($O$103/O129,0))))+0.45/(IF($O$5+$O$54+$O$103=0,((P31<>0)+(P80<>0)+(P129<>0))/(IFERROR(1/P31,0)+IFERROR(1/P80,0)+IFERROR(1/P129,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/P31,0)+IFERROR($O$54/P80,0)+IFERROR($O$103/P129,0))))),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Test Set name (e.g., Eco, Power):",null,null,null,null,"Charge-Depleting (CD) Test Results",null,null,null,"CAFE Values"]
[null,null,"City Unrounded Adjusted FE - Conventional Fuel",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((O32<>0)+(O81<>0)+(O130<>0))/(IFERROR(1/O32,0)+IFERROR(1/O81,0)+IFERROR(1/O130,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/O32,0)+IFERROR($O$54/O81,0)+IFERROR($O$103/O130,0))),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Production Volume (projected or actual):",null,null,null,null,"DRIVING DISTANCE VALUES","CD City","CD Hwy",null,"A. PHEV meets dual fuel criteria:","City","Highway","Combined"]
[null,null,"Hwy Unrounded Adjusted FE - Conventional Fuel",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,((P32<>0)+(P81<>0)+(P130<>0))/(IFERROR(1/P32,0)+IFERROR(1/P81,0)+IFERROR(1/P130,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/P32,0)+IFERROR($O$54/P81,0)+IFERROR($O$103/P130,0))),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD driving distance (Rcda), unadjusted (miles) [3]",null,null,null," 1. Default 50/50 Composite MPGe [4]",{"$f":"IF(O95,   ASTM(1/(0.5/(($J$22)/(T60/T85))+0.5/O80),4),   0)","v":0},{"$f":"IF(P95,   ASTM(1/(0.5/(($J$22)/(U60/U85))+0.5/P80),4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X55),ISNUMBER(Y55)),   ASTM(1/(0.55/X55+0.45/Y55),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,null,"Combined Unrounded Adjusted FE - Conventional Fuel",null,null,{"$f":"ASTM(1/(0.55/(IF($O$5+$O$54+$O$103=0,((O32<>0)+(O81<>0)+(O130<>0))/(IFERROR(1/O32,0)+IFERROR(1/O81,0)+IFERROR(1/O130,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/O32,0)+IFERROR($O$54/O81,0)+IFERROR($O$103/O130,0))))+0.45/(IF($O$5+$O$54+$O$103=0,((P32<>0)+(P81<>0)+(P130<>0))/(IFERROR(1/P32,0)+IFERROR(1/P81,0)+IFERROR(1/P130,0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/P32,0)+IFERROR($O$54/P81,0)+IFERROR($O$103/P130,0))))),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"IMPORT CHARGE-DEPLETING TEST XML DATA",null,null,null,null,"CD driving distance (Rcda), adjusted (miles) [3]",null,null,null," 2. Optional Utility Factor Composite MPGe [4]",{"$f":"IF(O95,   ASTM(1/(T88/(($J$22)/(T60/T85))+(1-T88)/O80), 4),   0)","v":0},{"$f":"IF(P95,   ASTM(1/(U88/(($J$22)/(U60/U85))+(1-U88)/P80), 4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X56),ISNUMBER(Y56)),   ASTM(1/(0.55/X56+0.45/Y56),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,null,"Charge-sustaining CO2",null,null,"g/mi",null,null,null,null,null,null,null,null,null,null,null,null,"CD all-electric driving distance, unadjusted (miles) [3]",null,null,null,"B. PHEV does NOT meet dual fuel criteria:","City","Highway","Combined"]
[null,null,"City CO2 Rounded Adjusted",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(O35+O84+O133)/((O35<>0)+(O84<>0)+(O133<>0)),(IFERROR($O$5*O35,0)+IFERROR($O$54*O84,0)+IFERROR($O$103*O133,0))/($O$5+$O$54+$O$103)),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"CD Procedure","Test Number ","Vehicle ID/Cfg",null,"CD All-Electric Range, adjusted (mi) [3]",null,null,null,"  1. Utility Factor Composite MPGe [4]",{"$f":"IF(O95,   ASTM(1/(T64+(1-T79)/O80),4),   0)","v":0},{"$f":"IF(P95,   ASTM(1/(U64+(1-U79)/P80),4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X58),ISNUMBER(Y58)),   ASTM(1/(0.55/X58+0.45/Y58),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,null,"Hwy CO2 Rounded Adjusted",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(P35+P84+P133)/((P35<>0)+(P84<>0)+(P133<>0)),(IFERROR($O$5*P35,0)+IFERROR($O$54*P84,0)+IFERROR($O$103*P133,0))/($O$5+$O$54+$O$103)),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Depleting Test (Required):",null,null,null,null,"FUEL CONSUMPTION & ECONOMY VALUES","CD City","CD Hwy",null,"GHG Values","City","Highway","Combined"]
[null,null,"Combined CO2 Rounded Adjusted",null,null,{"$f":"ASTM(0.55*(IF($O$5+$O$54+$O$103=0,(O35+O84+O133)/((O35<>0)+(O84<>0)+(O133<>0)),(IFERROR($O$5*O35,0)+IFERROR($O$54*O84,0)+IFERROR($O$103*O133,0))/($O$5+$O$54+$O$103)))+0.45*(IF($O$5+$O$54+$O$103=0,(P35+P84+P133)/((P35<>0)+(P84<>0)+(P133<>0)),(IFERROR($O$5*P35,0)+IFERROR($O$54*P84,0)+IFERROR($O$103*P133,0))/($O$5+$O$54+$O$103))),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Depleting Test (Required):",null,null,null,null,"CD AC electricity consumption (Rcdc), unadjusted (Watt-hours) [1]",null,null,null,"Composite CREE no DF, (g/mi) [1]",{"$f":"IF(O95,   ASTM(T76+(1-T79)*O82,1),   0)","v":0},{"$f":"IF(P95,   ASTM(U76+(1-U79)*P82,1),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X60),ISNUMBER(Y60)),   ASTM(0.55*X60+0.45*Y60,1),   NA())","v":0}]
[null,null,"*City CO2 Unrounded Unadjusted ",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(O34+O83+O132)/((O34<>0)+(O83<>0)+(O132<>0)),(IFERROR($O$5*O34,0)+IFERROR($O$54*O83,0)+IFERROR($O$103*O132,0))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD AC electricity consumption rate (Rcda), adjusted  (kW-hr/100mi) [3]",null,null,null,"Composite CREE w/DF, (g/mi) [1]",{"$f":"IF(O95,   IF($J$17=\"Additive\",ASTM((T76+(1-T79)*O82),0)+ASTM($J$18,0),IF($J$17=\"Multiplicative\",ASTM(ASTM((T76+(1-T79)*O82),0)*$J$18,0),\"Add/Mult?\")),   0)","v":0},{"$f":"IF(P95,   IF($J$17=\"Additive\",ASTM((U76+(1-U79)*P82),0)+ASTM($J$19,0),IF($J$17=\"Multiplicative\",ASTM(ASTM((U76+(1-U79)*P82),0)*$J$19,0),\"Add/Mult?\")),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X61),ISNUMBER(Y61)),   ASTM(0.55*X61+0.45*Y61,1),   NA())","v":0}]
[null,null,"*Hwy CO2 Unrounded Unadjusted ",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(P34+P83+P132)/((P34<>0)+(P83<>0)+(P132<>0)),(IFERROR($O$5*P34,0)+IFERROR($O$54*P83,0)+IFERROR($O$103*P132,0))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"IMPORT CHARGE-SUSTAINING XML DATA",null,null,null,null,"CD test total DC energy consumed, unadjusted (Watt-hours) [1]",null,null,null,"Label Values (5-Cycle Adjusted)"]
[null,null,"*Combined CO2 Unrounded Unadjusted ",null,null,{"$f":"ASTM(0.55*(IF($O$5+$O$54+$O$103=0,(O34+O83+O132)/((O34<>0)+(O83<>0)+(O132<>0)),(IFERROR($O$5*O34,0)+IFERROR($O$54*O83,0)+IFERROR($O$103*O132,0))/($O$5+$O$54+$O$103)))+0.45*(IF($O$5+$O$54+$O$103=0,(P34+P83+P132)/((P34<>0)+(P83<>0)+(P132<>0)),(IFERROR($O$5*P34,0)+IFERROR($O$54*P83,0)+IFERROR($O$103*P132,0))/($O$5+$O$54+$O$103))),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD Rcda total fuel consumption (Rcda), unadjusted (gal equiv) [4]",null,null,null,"Charge-Depleting",null,null,"Combined"]
[null,null,"*City CO2 Unrounded Adjusted ",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(O35+O84+O133)/((O35<>0)+(O84<>0)+(O133<>0)),(IFERROR($O$5*O35,0)+IFERROR($O$54*O84,0)+IFERROR($O$103*O133,0))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"CS Procedure","Test Number ","Vehicle ID/Cfg",null,"CD utilitized total fuel consumption rate (55/45 FUF, Rcdc), unadjusted (gal-equiv/mile) [6]",null,null,null,"CD range, adjusted (miles) [0]",null,null,{"$f":"IF(AND(O95,P95),   ASTM(0.55*T56+0.45*U56,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"*Hwy CO2 Unrounded Adjusted ",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(P35+P84+P133)/((P35<>0)+(P84<>0)+(P133<>0)),(IFERROR($O$5*P35,0)+IFERROR($O$54*P84,0)+IFERROR($O$103*P133,0))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Required): =====>",null,null,null,null,"CD utilitized total fuel consumption rate (43/57 FUF, Rcdc), adjusted (gal-equiv/mile) [6]",null,null,null,"CD All-Electric Range, adjusted (mi) [0]",null,null,{"$f":"IF(AND(O95,P95),   ASTM(0.55*T58+0.45*U58,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"*Combined CO2 Unrounded Adjusted ",null,null,{"$f":"ASTM(0.55*(IF($O$5+$O$54+$O$103=0,(O35+O84+O133)/((O35<>0)+(O84<>0)+(O133<>0)),(IFERROR($O$5*O35,0)+IFERROR($O$54*O84,0)+IFERROR($O$103*O133,0))/($O$5+$O$54+$O$103)))+0.45*(IF($O$5+$O$54+$O$103=0,(P35+P84+P133)/((P35<>0)+(P84<>0)+(P133<>0)),(IFERROR($O$5*P35,0)+IFERROR($O$54*P84,0)+IFERROR($O$103*P133,0))/($O$5+$O$54+$O$103))),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Required): =====>",null,null,null,null,"CD utilitized total fuel consumption rate (MDIUF, Rcdc), adjusted (gal-equiv/mile) [6]",null,null,null,"Total Driving Range (Miles) [0]",null,null,{"$f":"IF(AND(O95,P95,ISNUMBER(Z64)),   ASTM((ASTM(0.55*T86+0.45*U86,0)+Z64)/10,0) *10,   NA())","v":{"$error":"#N/A"}}]
[null,null,"Charge-sustaining Driving Range (Adjusted)",null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD gasoline consumption (Rcda), unadjusted (gal) [1]",null,null,null,"CD Fuel Economy (MPGe) [0]",null,null,{"$f":"IF(AND(O95,P95),   ASTM(1/(0.55/T68+0.45/U68),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"*Range1 - Model Type Driving Range - Conventional Fuel - City",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(T37,0),IFERROR(T86,0),IFERROR(T135,0))/((T37<>0)+(T86<>0)+(T135<>0)),($O$5*T37+$O$54*T86+$O$103*T135)/($O$5+$O$54+$O$103)),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD fuel economy (Rcda), adjusted (MPGe) [4]",null,null,null,"CD Electricity Consumption  (kW-hr/100mi) [0]",null,null,{"$f":"IF(AND(O95,P95),   ASTM(0.55*T61+0.45*U61,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"*Range1 - Model Type Driving Range - Conventional Fuel - Hwy",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(U37,0),IFERROR(U86,0),IFERROR(U135,0))/((U37<>0)+(U86<>0)+(U135<>0)),($O$5*U37+$O$54*U86+$O$103*U135)/($O$5+$O$54+$O$103)),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD gasoline consumption rate (Rcda), adjusted (gal/100mi) [4]",null,null,null,"CD Gasoline Consumption (gal/100mi) [0]",null,null,{"$f":"IF(AND(O95,P95),   ASTM(0.55*T69+0.45*U69,1),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Range1 - Model Type Driving Range - Conventional Fuel - Comb",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(IFERROR(ASTM(0.55*T37+0.45*U37,3),0),IFERROR(ASTM(0.55*T86+0.45*U86,3),0),IFERROR(ASTM(0.55*T135+0.45*U135,3),0)) / ((ASTM(0.55*T37+0.45*U37,3)<>0)+(ASTM(0.55*T86+0.45*U86,3)<>0)+(ASTM(0.55*T135+0.45*U135,3)<>0)),($O$5*ASTM(0.55*T37+0.45*U37,3)+$O$54*ASTM(0.55*T86+0.45*U86,3)+$O$103*ASTM(0.55*T135+0.45*U135,3))/($O$5+$O$54+$O$103)),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD fuel economy (Rcda), unadjusted (MPGe) [4]",null,null,null,"Charge-Sustaining",null,null,"Combined"]
[null,null,"Charge-depleting Efficiency",null,"kW-hr/100mi","MPGe",null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD AC electricity consumption rate (Rcda), unadjusted  (kW-hr/100mi) [3]",null,null,null,"CS Fuel Economy (MPG) [0]",{"$f":"IF(O95,   ASTM(O81,4),   0)","v":0},{"$f":"IF(P95,   ASTM(P81,4),   0)","v":0},{"$f":"IF(AND(O95,P95),   ASTM(1/(0.55/X71+0.45/Y71),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"City2 Rounded Adjusted FE (Guide) - Alt Fuel",null,{"$f":"ASTM($D$23,0)","v":{"$error":"#VALUE!"}},{"$f":"ASTM($D$22,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"GHG EMISSIONS VALUES","CD City","CD Hwy",null,"CS Fuel Consumption (gal/100mi) [1]",{"$f":"IFERROR(ASTM(100/X71,1),0)","v":0},{"$f":"IFERROR(ASTM(100/Y71,1),0)","v":0},{"$f":"IF(ISNUMBER(Z71),   ASTM(100/Z71,1),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Hwy2 Rounded Adjusted Fuel FE (Guide) - Alt Fuel",null,{"$f":"ASTM($E$23,0)","v":{"$error":"#VALUE!"}},{"$f":"ASTM($E$22,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD CO2 emissions rate (Rcda), unadjusted (g/mi) [1]",null,null,null,"Composite CD/CS",null,null,"Combined"]
[null,null,"Comb2 Rounded Adjusted Fuel FE (Guide) - Alt Fuel",null,{"$f":"$F$23","v":{"$error":"#VALUE!"}},{"$f":"$F$22","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD CO2 emissions rate (Rcda), adjusted (g/mi) [1]",null,null,null,"Annual Fuel Cost ($/year) [0]",null,null,{"$f":"IF(AND(O95,P95),   ASTM(15000*ASTM(0.55*T94+0.45*U94,3)/50,0)*50,   NA())","v":{"$error":"#N/A"}}]
[null,null,"City2 Unrounded Unadjusted FE - Alt Fuel",null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(T22,T71,T120)/(((T22)<>0)+((T71)<>0)+((T120)<>0)),($O$5*(T22)+$O$54*(T71)+$O$103*(T120))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(((T21)<>0)+((T70)<>0)+((T119)<>0))/(IFERROR(1/(T21),0)+IFERROR(1/(T70),0)+IFERROR(1/(T119),0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/(T21),0)+IFERROR($O$54/(T70),0)+IFERROR($O$103/(T119),0))),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD utilitized CO2 (MDIUF, Rcdc), adjusted (g/mi) [1]",null,null,null,"5-Year Fuel Savings Value ($/5 years) [0]",null,null,{"$f":"IF(AND(ISNUMBER($J$25),ISNUMBER(Z74)),   $J$25-5*Z74,   NA())","v":{"$error":"#N/A"}}]
[null,null,"Hwy2 Unrounded Unadjusted  FE - Alt Fuel",null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,SUM(U22,U71,U120)/(((U22)<>0)+((U71)<>0)+((U120)<>0)),($O$5*(U22)+$O$54*(U71)+$O$103*(U120))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(((U21)<>0)+((U70)<>0)+((U119)<>0))/(IFERROR(1/(U21),0)+IFERROR(1/(U70),0)+IFERROR(1/(U119),0)),($O$5+$O$54+$O$103)/(IFERROR($O$5/(U21),0)+IFERROR($O$54/(U70),0)+IFERROR($O$103/(U119),0))),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD utilitized CREE (55/45 FUF, Rcdc), unadjusted (g/mi) [1]",null,null,null,"Composite CO2 (g/mi) [0]",null,null,{"$f":"IF(AND(O95,P95),   ASTM(0.55*T96+0.45*U96,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Comb2 Unrounded Unadjusted FE - Alt Fuel",null,{"$f":"ASTM(0.55*E75+0.45*E76,4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(1/(0.55/F75+0.45/F76),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD utilitized CREE (43/57 FUF, Rcdc), adjusted (g/mi) [1]",null,null,null,"Composite Fuel Economy (MPG) [0]",null,null,{"$f":"IF(AND(O95,P95),   ASTM(1/(0.55/T97+0.45/U97),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,"City2 Unrounded Adjusted FE - Alt Fuel",null,{"$f":"ASTM($D$23,4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM($D$22,4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"MACRO CALCULATED CHARGE-SUSTAINING TEST RESULTS",null,null,null,null,"UTILITY FACTORS & OTHER METRICS","CD City","CD Hwy",null,"HOV Lane Values","City","Highway","Combined"]
[null,null,"Hwy2 Unrounded Adjusted FE - Alt Fuel",null,{"$f":"ASTM($E$23,4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM($E$22,4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"CS City","CS Highway","Calc Type",null,"CD 55/45 Fleet Utility Factor (FUF) for Rcdc [3]",null,null,null,"MDIUF based on unadjusted Rcda [3]",{"$f":"IFERROR(ASTM(mdiuf(T55),3),0)","v":0},{"$f":"IFERROR(ASTM(mdiuf(U55),3),0)","v":0}]
[null,null,"Cmb2 Unrounded Adjusted  FE - Alt Fuel",null,{"$f":"ASTM(0.55*D23+0.45*E23,4)","v":{"$error":"#VALUE!"}},{"$f":"ASTM(1/(0.55/D22+0.45/E22),4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Fuel Economy, Unadjusted (MPG):",null,null,null,null,"CD 43/57 Fleet Utility Factor (FUF) [3]",null,null,null,"Composite CD/CS Fuel Economy (MPGe) [4]",{"$f":"IFERROR(ASTM(1/(X79/(T55/T63)+(1-X79)/O80),4),0)","v":0},{"$f":"IFERROR(ASTM(1/(Y79/(U55/U63)+(1-Y79)/P80),4),0)","v":0},{"$f":"IFERROR(ASTM(1/(0.55/X80+0.45/Y80),4),0)","v":0}]
[null,null,"Charge-depleting CO2",null,null,"g/mi",null,null,null,null,null,null,null,"Fuel Economy, 5-Cycle Adjusted (MPG):",null,null,null,null,"MDIUF based on adjusted Rcda [3]",null,null,null,"Trends Report Values","City","Highway"]
[null,null,"City CO2 Rounded Adjusted",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(T25+T74+T123)/((T7<>0)+(T56<>0)+(T105<>0)),(IFERROR($O$5*T25,0)+IFERROR($O$54*T74,0)+IFERROR($O$103*T123,0))/($O$5+$O$54+$O$103)),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"CREE (g/mi):",null,null,null,null,"MDIUF based on adjusted Rcdc [3]",null,null,null,"Fleet Utility Factor (43/57) [3]",{"$f":"IF(O95,   T80,   0)","v":0},{"$f":"IF(P95,   U80,   0)","v":0}]
[null,null,"Hwy CO2 Rounded Adjusted",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(U25+U74+U123)/((U7<>0)+(U56<>0)+(U105<>0)),(IFERROR($O$5*U25,0)+IFERROR($O$54*U74,0)+IFERROR($O$103*U123,0))/($O$5+$O$54+$O$103)),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"CO2, Unadjusted (g/mi):",null,null,null,null,"Intermediate Results Requiring Charge-Sustaining (CS) Test Results or Other Inputs",null,null,null,"Unadjusted Fuel Economy (MPG) [4]",{"$f":"IF(O95,   X58,   0)","v":0},{"$f":"IF(P95,  Y58,   0)","v":0}]
[null,null,"Comb CO2 Rounded Adjusted",null,null,{"$f":"ASTM(0.55*(IF($O$5+$O$54+$O$103=0,(T25+T74+T123)/((T7<>0)+(T56<>0)+(T105<>0)),(IFERROR($O$5*T25,0)+IFERROR($O$54*T74,0)+IFERROR($O$103*T123,0))/($O$5+$O$54+$O$103)))+0.45*(IF($O$5+$O$54+$O$103=0,(U25+U74+U123)/((U7<>0)+(U56<>0)+(U105<>0)),(IFERROR($O$5*U25,0)+IFERROR($O$54*U74,0)+IFERROR($O$103*U123,0))/($O$5+$O$54+$O$103))),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"CO2, 5-Cycle Adjusted (g/mi):",null,null,null,null,"DRIVING DISTANCE VALUES","CITY","HIGHWAY",null,"Unadjusted GHG (g/mi) [1]",{"$f":"IF(O95,   ASTM(X60,1),   0)","v":0},{"$f":"IF(P95,   ASTM(Y60,1),   0)","v":0}]
[null,null,"*City CO2 Unrounded Unadjusted ",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(IFERROR(T24,0)+IFERROR(T73,0)+IFERROR(T122,0))/((T6<>0)+(T55<>0)+(T104<>0)),(IFERROR($O$5*T24,0)+IFERROR($O$54*T73,0)+IFERROR($O$103*T122,0))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD Equivalent All-Electric Range (EAER), Unadjusted (mi) [3]",{"$f":"IF(O92,   ASTM(T55*((O83-T73)/O83),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P92,   ASTM(U55*((P83-U73)/P83),3),   NA())","v":{"$error":"#N/A"}},null,"Adjusted Fuel Economy (MPG) [4]",{"$f":"IF(O95,   ASTM(1/(T65+(1-X82)/O81),4),   0)","v":0},{"$f":"IF(P95,   ASTM(1/(U65+(1-Y82)/P81),4),   0)","v":0}]
[null,null,"*Hwy CO2 Unrounded Unadjusted ",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(IFERROR(U24,0)+IFERROR(U73,0)+IFERROR(U122,0))/((U6<>0)+(U55<>0)+(U104<>0)),(IFERROR($O$5*U24,0)+IFERROR($O$54*U73,0)+IFERROR($O$103*U122,0))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"City","Highway",null,null,"Charge-sustaining driving range, adjusted (mi) [3]",{"$f":"IF(O92,   ASTM((ASTM($J$15,1)-T67)*ASTM(O81,4),3),   0)","v":0},{"$f":"IF(P92,   ASTM((ASTM($J$15,1)-U67)*ASTM(P81,4),3),   0)","v":0},null,"Adjusted GHG (g/mi) [1]",{"$f":"IF(O95,   ASTM(T77+(1-X82)*ASTM(O84,1),1),   0)","v":0},{"$f":"IF(P95,   ASTM(U77+(1-Y82)*ASTM(P84,1),1),   0)","v":0}]
[null,null,"*Comb CO2 Unrounded Unadjusted ",null,null,{"$f":"ASTM(0.55*(IF($O$5+$O$54+$O$103=0,(IFERROR(T24,0)+IFERROR(T73,0)+IFERROR(T122,0))/((T6<>0)+(T55<>0)+(T104<>0)),(IFERROR($O$5*T24,0)+IFERROR($O$54*T73,0)+IFERROR($O$103*T122,0))/($O$5+$O$54+$O$103)))+0.45*(IF($O$5+$O$54+$O$103=0,(IFERROR(U24,0)+IFERROR(U73,0)+IFERROR(U122,0))/((U6<>0)+(U55<>0)+(U104<>0)),(IFERROR($O$5*U24,0)+IFERROR($O$54*U73,0)+IFERROR($O$103*U122,0))/($O$5+$O$54+$O$103))),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Data Validation Vehicle Info",{"$f":"IF(AND(ISNUMBER($J$5),$J$5<=2025,ISNUMBER($J$15),OR($J$17=\"Additive\",$J$17=\"Multiplicative\"),ISNUMBER($J$18),ISNUMBER($J$19),ISNUMBER($J$22),ISNUMBER($J$23),ISNUMBER($J$24),ISNUMBER($J$25),ISNUMBER($J$26)),TRUE,FALSE)","v":false},null,null,null,"UTILITY FACTORS & OTHER METRICS","CITY","HIGHWAY"]
[null,null,"*City CO2 Unrounded Adjusted",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(T25+T74+T123)/((T7<>0)+(T56<>0)+(T105<>0)),(IFERROR($O$5*T25,0)+IFERROR($O$54*T74,0)+IFERROR($O$103*T123,0))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Data Validation CS",{"$f":"IF(AND(ISBLANK(O65)=FALSE,ISBLANK(P65)=FALSE,ISBLANK(O66)=FALSE,ISBLANK(P66)=FALSE,ISNUMBER(O80),ISNUMBER(O81),ISNUMBER(O82),ISNUMBER(O83),ISNUMBER(O84)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISBLANK(O65)=FALSE,ISBLANK(P65)=FALSE,ISBLANK(O66)=FALSE,ISBLANK(P66)=FALSE,ISNUMBER(P80),ISNUMBER(P81),ISNUMBER(P82),ISNUMBER(P83),ISNUMBER(P84)),TRUE,FALSE)","v":false},null,null,"CD 55/45 Fleet Utility Factor (FUF) for EAER [3]",{"$f":"IF(O92,   ASTM(cityfuf(T85),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P92,   ASTM(highwayfuf(U85),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"*Hwy CO2 Unrounded Adjusted",null,null,{"$f":"ASTM(IF($O$5+$O$54+$O$103=0,(U25+U74+U123)/((U7<>0)+(U56<>0)+(U105<>0)),(IFERROR($O$5*U25,0)+IFERROR($O$54*U74,0)+IFERROR($O$103*U123,0))/($O$5+$O$54+$O$103)),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O87,O88),TRUE,FALSE)","v":false},{"$f":"IF(AND(O87,P88),TRUE,FALSE)","v":false},null,null,"FUEL COSTS: PROCESS FOR DERIVING A COMPOSITE CD/CS COST PER MILE","CITY","HIGHWAY"]
[null,null,"*Combined CO2 Unrounded Adjusted",null,null,{"$f":"ASTM(0.55*(IF($O$5+$O$54+$O$103=0,(T25+T74+T123)/((T7<>0)+(T56<>0)+(T105<>0)),(IFERROR($O$5*T25,0)+IFERROR($O$54*T74,0)+IFERROR($O$103*T123,0))/($O$5+$O$54+$O$103)))+0.45*(IF($O$5+$O$54+$O$103=0,(U25+U74+U123)/((U7<>0)+(U56<>0)+(U105<>0)),(IFERROR($O$5*U25,0)+IFERROR($O$54*U74,0)+IFERROR($O$103*U123,0))/($O$5+$O$54+$O$103))),1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD cost per mile - electricity ($/mi) [3]",{"$f":"IF(O92,   ASTM($J$24*T61/100,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P92,   ASTM($J$24*U61/100,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Charge-depleting Driving Range (Adjusted)",null,null,"miles",null,null,null,null,null,null,null,"Data Validation Intermediate CD",{"$f":"IF(AND(ISNUMBER(T55),ISNUMBER(T56),ISNUMBER(T57),ISNUMBER(T58),   ISNUMBER(T60),ISNUMBER(T61),ISNUMBER(T62),ISNUMBER(T63),ISNUMBER(T64),ISNUMBER(T65),ISNUMBER(T66),ISNUMBER(T67),ISNUMBER(T68),ISNUMBER(T69),ISNUMBER(T70),ISNUMBER(T71),   ISNUMBER(T73),ISNUMBER(T74),ISNUMBER(T75),ISNUMBER(T76),ISNUMBER(T77),   ISNUMBER(T79),ISNUMBER(T80),ISNUMBER(T81),ISNUMBER(T82)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISNUMBER(U55),ISNUMBER(U56),ISNUMBER(U57),ISNUMBER(U58),   ISNUMBER(U60),ISNUMBER(U61),ISNUMBER(U62),ISNUMBER(U63),ISNUMBER(U64),ISNUMBER(U65),ISNUMBER(U66),ISNUMBER(U67),ISNUMBER(U68),ISNUMBER(U69),ISNUMBER(U70),ISNUMBER(U71),   ISNUMBER(U73),ISNUMBER(U74),ISNUMBER(U75),ISNUMBER(U76),ISNUMBER(U77),   ISNUMBER(U79),ISNUMBER(U80),ISNUMBER(U81),ISNUMBER(U82)),TRUE,FALSE)","v":false},null,null,"CD cost per mile - gasoline ($/mi) [3]",{"$f":"IF(O92,   ASTM($J$23 *(T67/T56),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P92,   ASTM($J$23 *(U67/U56),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"City Range on Electricity (miles)",null,null,{"$f":"ASTM(D19,2)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O89,O91),TRUE,FALSE)","v":false},{"$f":"IF(AND(P89,P91),TRUE,FALSE)","v":false},null,null,"CD total cost per mile ($/mi) [3]",{"$f":"IF(O92,   ASTM(T90+T91,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P92,   ASTM(U90+U91,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Hwy Range on Electricity (miles)",null,null,{"$f":"ASTM(E19,2)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CS cost per mile ($/mi) [3]",{"$f":"IF(O92,   ASTM($J$23/ASTM(O81,4),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P92,   ASTM($J$23/ASTM(P81,4),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"Combined Range on Electricity as shown on FE Label (miles)",null,null,{"$f":"F19","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Data Validation Intermediate CS",{"$f":"IF(AND(ISNUMBER(T85),ISNUMBER(T86),   ISNUMBER(T88),   ISNUMBER(T90),ISNUMBER(T91),ISNUMBER(T92),ISNUMBER(T93),ISNUMBER(T94),   ISNUMBER(T96),ISNUMBER(T97)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISNUMBER(U85),ISNUMBER(U86),   ISNUMBER(U88),   ISNUMBER(U90),ISNUMBER(U91),ISNUMBER(U92),ISNUMBER(U93),ISNUMBER(U94),   ISNUMBER(U96),ISNUMBER(U97)),TRUE,FALSE)","v":false},null,null,"Composite CD/CS cost ($/mi) [3]",{"$f":"IF(O92,   ASTM(T81*T92+(1-T81)*T93,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P92,   ASTM(U81*U92+(1-U81)*U93,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,"All-Electric Driving Range (Adjusted)",null,null,"miles",null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O92,O94),TRUE,FALSE)","v":false},{"$f":"IF(AND(P92,P94),TRUE,FALSE)","v":false},null,null,"COMPOSITE CD/CS FUEL ECONOMY AND CO2 VALUES, ADJUSTED","CITY","HIGHWAY"]
[null,null,"City All-Electric Range",null,null,{"$f":"ASTM(D20,2)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Composite CD/CS CO2, adjusted (g/mi) [1]",{"$f":"IF(O92,   ASTM(T75+(1-T82)*O84,1),   0)","v":0},{"$f":"IF(P92,   ASTM(U75+(1-U82)*P84,1),   0)","v":0}]
[null,null,"Hwy All-Electric Range",null,null,{"$f":"ASTM(E20,2)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Composite CD/CS Fuel Economy, adjusted (MPG) [4]",{"$f":"IF(O92,   ASTM(1/(T66+(1-T82)/O81),4),   0)","v":0},{"$f":"IF(P92,   ASTM(1/(U66+(1-U82)/P81),4),   0)","v":0}]
[null,null,"Combined All-Electric Range as shown on FE Label (miles)",null,null,{"$f":"F20","v":{"$error":"#VALUE!"}}]
[null,null,"Charge-depleting Utility Factors",null,null,"UF"]
[null,null,"City Utility Factor (MDIUF)",null,null,{"$f":"ASTM(mdiuf(D19),3)","v":{"$error":"#VALUE!"}}]
[null,null,"Hwy Utility Factor (MDIUF)",null,null,{"$f":"ASTM(mdiuf(E19),3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Test Set #3",null,null,3,null,"INTERMEDIATE CALCULATIONS AND INPUTS","Test Set #3:",{"$f":"O102","v":0},null,"Results from Test Set #1:",{"$f":"O102","v":0}]
[null,null,"Combined Utility Factor (MDIUF)",null,null,{"$f":"ASTM(mdiuf(0.55*D19+0.45*E19),3)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Test Set name (e.g., Eco, Power):",null,null,null,null,"Charge-Depleting (CD) Test Results",null,null,null,"CAFE Values"]
[null,null,"Composite Efficiency (Adjusted)",null,null,"MPGe",null,null,null,null,null,null,null,"Production Volume (projected or actual):",null,null,null,null,"DRIVING DISTANCE VALUES","CD City","CD Hwy",null,"A. PHEV meets dual fuel criteria:","City","Highway","Combined"]
[null,null,"City PHEV Composite MPGe",null,null,{"$f":"ASTM(D32,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD driving distance (Rcda), unadjusted (miles) [3]",null,null,null," 1. Default 50/50 Composite MPGe [4]",{"$f":"IF(O144,   ASTM(1/(0.5/(($J$22)/(T109/T134))+0.5/O129),4),   0)","v":0},{"$f":"IF(P144,   ASTM(1/(0.5/(($J$22)/(U109/U134))+0.5/P129),4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X104),ISNUMBER(Y104)),   ASTM(1/(0.55/X104+0.45/Y104),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,null,"Hwy PHEV Composite MPGe",null,null,{"$f":"ASTM(E32,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"IMPORT CHARGE-DEPLETING TEST XML DATA",null,null,null,null,"CD driving distance (Rcda), adjusted (miles) [3]",null,null,null," 2. Optional Utility Factor Composite MPGe [4]",{"$f":"IF(O144,   ASTM(1/(T137/(($J$22)/(T109/T134))+(1-T137)/O129), 4),   0)","v":0},{"$f":"IF(P144,   ASTM(1/(U137/(($J$22)/(U109/U134))+(1-U137)/P129), 4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X105),ISNUMBER(Y105)),   ASTM(1/(0.55/X105+0.45/Y105),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,null,"Combined PHEV Composite MPGe",null,null,{"$f":"F32","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD all-electric driving distance, unadjusted (miles) [3]",null,null,null,"B. PHEV does NOT meet dual fuel criteria:","City","Highway","Combined"]
[null,null,"Composite CO2 (Adjusted)",null,null,"g/mi",null,null,null,null,null,null,null,null,"CD Procedure","Test Number ","Vehicle ID/Cfg",null,"CD All-Electric Range, adjusted (mi) [3]",null,null,null,"  1. Utility Factor Composite MPGe [4]",{"$f":"IF(O144,   ASTM(1/(T113+(1-T128)/O129),4),   0)","v":0},{"$f":"IF(P144,   ASTM(1/(U113+(1-U128)/P129),4),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X107),ISNUMBER(Y107)),   ASTM(1/(0.55/X107+0.45/Y107),4),   NA())","v":{"$error":"#VALUE!"}}]
[null,null,"City CO2-PHEV Composite Rounded Adjusted CO2",null,null,{"$f":"ASTM(D31,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Depleting Test (Required):",null,null,null,null,"FUEL CONSUMPTION & ECONOMY VALUES","CD City","CD Hwy",null,"GHG Values","City","Highway","Combined"]
[null,null,"Hwy CO2-PHEV Composite Rounded Adjusted CO2",null,null,{"$f":"ASTM(E31,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Charge-Depleting Test (Required):",null,null,null,null,"CD AC electricity consumption (Rcdc), unadjusted (Watt-hours) [1]",null,null,null,"Composite CREE no DF, (g/mi) [1]",{"$f":"IF(O144,   ASTM(T125+(1-T128)*O131,1),   0)","v":0},{"$f":"IF(P144,   ASTM(U125+(1-U128)*P131,1),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X109),ISNUMBER(Y109)),   ASTM(0.55*X109+0.45*Y109,1),   NA())","v":0}]
[null,null,"CO2-PHEV Composite Rounded Adjusted CO2",null,null,{"$f":"F31","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD AC electricity consumption rate (Rcda), adjusted  (kW-hr/100mi) [3]",null,null,null,"Composite CREE w/DF, (g/mi) [1]",{"$f":"IF(O144,   IF($J$17=\"Additive\",ASTM((T125+(1-T128)*O131),0)+ASTM($J$18,0),IF($J$17=\"Multiplicative\",ASTM(ASTM((T125+(1-T128)*O131),0)*$J$18,0),\"Add/Mult?\")),   0)","v":0},{"$f":"IF(P144,   IF($J$17=\"Additive\",ASTM((U125+(1-U128)*P131),0)+ASTM($J$19,0),IF($J$17=\"Multiplicative\",ASTM(ASTM((U125+(1-U128)*P131),0)*$J$19,0),\"Add/Mult?\")),   0)","v":0},{"$f":"IF(AND(ISNUMBER(X110),ISNUMBER(Y110)),   ASTM(0.55*X110+0.45*Y110,1),   NA())","v":0}]
[null,null,"PHEV Total Driving Range (Adjusted)",null,null,"miles",null,null,null,null,null,null,null,"IMPORT CHARGE-SUSTAINING XML DATA",null,null,null,null,"CD test total DC energy consumed, unadjusted (Watt-hours) [1]",null,null,null,"Label Values (5-Cycle Adjusted)"]
[null,null,"PHEV Total Driving Range (Adjusted)",null,null,{"$f":"F21","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,"CD Rcda total fuel consumption (Rcda), unadjusted (gal equiv) [4]",null,null,null,"Charge-Depleting",null,null,"Combined"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CS Procedure","Test Number ","Vehicle ID/Cfg",null,"CD utilitized total fuel consumption rate (55/45 FUF, Rcdc), unadjusted (gal-equiv/mile) [6]",null,null,null,"CD range, adjusted (miles) [0]",null,null,{"$f":"IF(AND(O144,P144),   ASTM(0.55*T105+0.45*U105,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Required): =====>",null,null,null,null,"CD utilitized total fuel consumption rate (43/57 FUF, Rcdc), adjusted (gal-equiv/mile) [6]",null,null,null,"CD All-Electric Range, adjusted (mi) [0]",null,null,{"$f":"IF(AND(O144,P144),   ASTM(0.55*T107+0.45*U107,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Required): =====>",null,null,null,null,"CD utilitized total fuel consumption rate (MDIUF, Rcdc), adjusted (gal-equiv/mile) [6]",null,null,null,"Total Driving Range (Miles) [0]",null,null,{"$f":"IF(AND(O144,P144,ISNUMBER(Z113)),   ASTM((ASTM(0.55*T135+0.45*U135,0)+Z113)/10,0) *10,   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD gasoline consumption (Rcda), unadjusted (gal) [1]",null,null,null,"CD Fuel Economy (MPGe) [0]",null,null,{"$f":"IF(AND(O144,P144),   ASTM(1/(0.55/T117+0.45/U117),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD fuel economy (Rcda), adjusted (MPGe) [4]",null,null,null,"CD Electricity Consumption  (kW-hr/100mi) [0]",null,null,{"$f":"IF(AND(O144,P144),   ASTM(0.55*T110+0.45*U110,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD gasoline consumption rate (Rcda), adjusted (gal/100mi) [4]",null,null,null,"CD Gasoline Consumption (gal/100mi) [0]",null,null,{"$f":"IF(AND(O144,P144),   ASTM(0.55*T118+0.45*U118,1),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD fuel economy (Rcda), unadjusted (MPGe) [4]",null,null,null,"Charge-Sustaining",null,null,"Combined"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD AC electricity consumption rate (Rcda), unadjusted  (kW-hr/100mi) [3]",null,null,null,"CS Fuel Economy (MPG) [0]",{"$f":"IF(O144,   ASTM(O130,4),   0)","v":0},{"$f":"IF(P144,   ASTM(P130,4),   0)","v":0},{"$f":"IF(AND(O144,P144),   ASTM(1/(0.55/X120+0.45/Y120),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"GHG EMISSIONS VALUES","CD City","CD Hwy",null,"CS Fuel Consumption (gal/100mi) [1]",{"$f":"IFERROR(ASTM(100/X120,1),0)","v":0},{"$f":"IFERROR(ASTM(100/Y120,1),0)","v":0},{"$f":"IF(ISNUMBER(Z120),   ASTM(100/Z120,1),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD CO2 emissions rate (Rcda), unadjusted (g/mi) [1]",null,null,null,"Composite CD/CS",null,null,"Combined"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD CO2 emissions rate (Rcda), adjusted (g/mi) [1]",null,null,null,"Annual Fuel Cost ($/year) [0]",null,null,{"$f":"IF(AND(O144,P144),   ASTM(15000*ASTM(0.55*T143+0.45*U143,3)/50,0)*50,   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD utilitized CO2 (MDIUF, Rcdc), adjusted (g/mi) [1]",null,null,null,"5-Year Fuel Savings Value ($/5 years) [0]",null,null,{"$f":"IF(AND(ISNUMBER($J$25),ISNUMBER(Z123)),   $J$25-5*Z123,   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge-Sustaining Test (Optional):",null,null,null,null,"CD utilitized CREE (55/45 FUF, Rcdc), unadjusted (g/mi) [1]",null,null,null,"Composite CO2 (g/mi) [0]",null,null,{"$f":"IF(AND(O144,P144),   ASTM(0.55*T145+0.45*U145,0),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD utilitized CREE (43/57 FUF, Rcdc), adjusted (g/mi) [1]",null,null,null,"Composite Fuel Economy (MPG) [0]",null,null,{"$f":"IF(AND(O144,P144),   ASTM(1/(0.55/T146+0.45/U146),0),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MACRO CALCULATED CHARGE-SUSTAINING TEST RESULTS",null,null,null,null,"UTILITY FACTORS & OTHER METRICS","CD City","CD Hwy",null,"HOV Lane Values","City","Highway","Combined"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CS City","CS Highway","Calc Type",null,"CD 55/45 Fleet Utility Factor (FUF) for Rcdc [3]",null,null,null,"MDIUF based on unadjusted Rcda [3]",{"$f":"IFERROR(ASTM(mdiuf(T104),3),0)","v":0},{"$f":"IFERROR(ASTM(mdiuf(U104),3),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Economy, Unadjusted (MPG):",null,null,null,null,"CD 43/57 Fleet Utility Factor (FUF) [3]",null,null,null,"Composite CD/CS Fuel Economy (MPGe) [4]",{"$f":"IFERROR(ASTM(1/(X128/(T104/T112)+(1-X128)/O129),4),0)","v":0},{"$f":"IFERROR(ASTM(1/(Y128/(U104/U112)+(1-Y128)/P129),4),0)","v":0},{"$f":"IFERROR(ASTM(1/(0.55/X129+0.45/Y129),4),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Economy, 5-Cycle Adjusted (MPG):",null,null,null,null,"MDIUF based on adjusted Rcda [3]",null,null,null,"Trends Report Values","City","Highway"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CREE (g/mi):",null,null,null,null,"MDIUF based on adjusted Rcdc [3]",null,null,null,"Fleet Utility Factor (43/57) [3]",{"$f":"IF(O144,   T129,   0)","v":0},{"$f":"IF(P144,   U129,   0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2, Unadjusted (g/mi):",null,null,null,null,"Intermediate Results Requiring Charge-Sustaining (CS) Test Results or Other Inputs",null,null,null,"Unadjusted Fuel Economy (MPG) [4]",{"$f":"IF(O144,   X107,   0)","v":0},{"$f":"IF(P144,  Y107,   0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2, 5-Cycle Adjusted (g/mi):",null,null,null,null,"DRIVING DISTANCE VALUES","CITY","HIGHWAY",null,"Unadjusted GHG (g/mi) [1]",{"$f":"IF(O144,   ASTM(X109,1),   0)","v":0},{"$f":"IF(P144,   ASTM(Y109,1),   0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD Equivalent All-Electric Range (EAER), Unadjusted (mi) [3]",{"$f":"IF(O141,   ASTM(T104*((O132-T122)/O132),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P141,   ASTM(U104*((P132-U122)/P132),3),   NA())","v":{"$error":"#N/A"}},null,"Adjusted Fuel Economy (MPG) [4]",{"$f":"IF(O144,   ASTM(1/(T114+(1-X131)/O130),4),   0)","v":0},{"$f":"IF(P144,   ASTM(1/(U114+(1-Y131)/P130),4),   0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City","Highway",null,null,"Charge-sustaining driving range, adjusted (mi) [3]",{"$f":"IF(O141,   ASTM((ASTM($J$15,1)-T116)*ASTM(O130,4),3),   0)","v":0},{"$f":"IF(P141,   ASTM((ASTM($J$15,1)-U116)*ASTM(P130,4),3),   0)","v":0},null,"Adjusted GHG (g/mi) [1]",{"$f":"IF(O144,   ASTM(T126+(1-X131)*ASTM(O133,1),1),   0)","v":0},{"$f":"IF(P144,   ASTM(U126+(1-Y131)*ASTM(P133,1),1),   0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Validation Vehicle Info",{"$f":"IF(AND(ISNUMBER($J$5),$J$5<=2025,ISNUMBER($J$15),OR($J$17=\"Additive\",$J$17=\"Multiplicative\"),ISNUMBER($J$18),ISNUMBER($J$19),ISNUMBER($J$22),ISNUMBER($J$23),ISNUMBER($J$24),ISNUMBER($J$25),ISNUMBER($J$26)),TRUE,FALSE)","v":false},null,null,null,"UTILITY FACTORS & OTHER METRICS","CITY","HIGHWAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Validation CS",{"$f":"IF(AND(ISBLANK(O114)=FALSE,ISBLANK(P114)=FALSE,ISBLANK(O115)=FALSE,ISBLANK(P115)=FALSE,ISNUMBER(O129),ISNUMBER(O130),ISNUMBER(O131),ISNUMBER(O132),ISNUMBER(O133)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISBLANK(O114)=FALSE,ISBLANK(P114)=FALSE,ISBLANK(O115)=FALSE,ISBLANK(P115)=FALSE,ISNUMBER(P129),ISNUMBER(P130),ISNUMBER(P131),ISNUMBER(P132),ISNUMBER(P133)),TRUE,FALSE)","v":false},null,null,"CD 55/45 Fleet Utility Factor (FUF) for EAER [3]",{"$f":"IF(O141,   ASTM(cityfuf(T134),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P141,   ASTM(highwayfuf(U134),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O136,O137),TRUE,FALSE)","v":false},{"$f":"IF(AND(O136,P137),TRUE,FALSE)","v":false},null,null,"FUEL COSTS: PROCESS FOR DERIVING A COMPOSITE CD/CS COST PER MILE","CITY","HIGHWAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD cost per mile - electricity ($/mi) [3]",{"$f":"IF(O141,   ASTM($J$24*T110/100,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P141,   ASTM($J$24*U110/100,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Validation Intermediate CD",{"$f":"IF(AND(ISNUMBER(T104),ISNUMBER(T105),ISNUMBER(T106),ISNUMBER(T107),   ISNUMBER(T109),ISNUMBER(T110),ISNUMBER(T111),ISNUMBER(T112),ISNUMBER(T113),ISNUMBER(T114),ISNUMBER(T115),ISNUMBER(T116),ISNUMBER(T117),ISNUMBER(T118),ISNUMBER(T119),ISNUMBER(T120),   ISNUMBER(T122),ISNUMBER(T123),ISNUMBER(T124),ISNUMBER(T125),ISNUMBER(T126),   ISNUMBER(T128),ISNUMBER(T129),ISNUMBER(T130),ISNUMBER(T131)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISNUMBER(U104),ISNUMBER(U105),ISNUMBER(U106),ISNUMBER(U107),   ISNUMBER(U109),ISNUMBER(U110),ISNUMBER(U111),ISNUMBER(U112),ISNUMBER(U113),ISNUMBER(U114),ISNUMBER(U115),ISNUMBER(U116),ISNUMBER(U117),ISNUMBER(U118),ISNUMBER(U119),ISNUMBER(U120),   ISNUMBER(U122),ISNUMBER(U123),ISNUMBER(U124),ISNUMBER(U125),ISNUMBER(U126),   ISNUMBER(U128),ISNUMBER(U129),ISNUMBER(U130),ISNUMBER(U131)),TRUE,FALSE)","v":false},null,null,"CD cost per mile - gasoline ($/mi) [3]",{"$f":"IF(O141,   ASTM($J$23 *(T116/T105),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P141,   ASTM($J$23 *(U116/U105),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O138,O140),TRUE,FALSE)","v":false},{"$f":"IF(AND(P138,P140),TRUE,FALSE)","v":false},null,null,"CD total cost per mile ($/mi) [3]",{"$f":"IF(O141,   ASTM(T139+T140,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P141,   ASTM(U139+U140,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CS cost per mile ($/mi) [3]",{"$f":"IF(O141,   ASTM($J$23/ASTM(O130,4),3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P141,   ASTM($J$23/ASTM(P130,4),3),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Validation Intermediate CS",{"$f":"IF(AND(ISNUMBER(T134),ISNUMBER(T135),   ISNUMBER(T137),   ISNUMBER(T139),ISNUMBER(T140),ISNUMBER(T141),ISNUMBER(T142),ISNUMBER(T143),   ISNUMBER(T145),ISNUMBER(T146)),TRUE,FALSE)","v":false},{"$f":"IF(AND(ISNUMBER(U134),ISNUMBER(U135),   ISNUMBER(U137),   ISNUMBER(U139),ISNUMBER(U140),ISNUMBER(U141),ISNUMBER(U142),ISNUMBER(U143),   ISNUMBER(U145),ISNUMBER(U146)),TRUE,FALSE)","v":false},null,null,"Composite CD/CS cost ($/mi) [3]",{"$f":"IF(O141,   ASTM(T130*T141+(1-T130)*T142,3),   NA())","v":{"$error":"#N/A"}},{"$f":"IF(P141,   ASTM(U130*U141+(1-U130)*U142,3),   NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(cumulative)",{"$f":"IF(AND(O141,O143),TRUE,FALSE)","v":false},{"$f":"IF(AND(P141,P143),TRUE,FALSE)","v":false},null,null,"COMPOSITE CD/CS FUEL ECONOMY AND CO2 VALUES, ADJUSTED","CITY","HIGHWAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Composite CD/CS CO2, adjusted (g/mi) [1]",{"$f":"IF(O141,   ASTM(T124+(1-T131)*O133,1),   0)","v":0},{"$f":"IF(P141,   ASTM(U124+(1-U131)*P133,1),   0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Composite CD/CS Fuel Economy, adjusted (MPG) [4]",{"$f":"IF(O141,   ASTM(1/(T115+(1-T131)/O130),4),   0)","v":0},{"$f":"IF(P141,   ASTM(1/(U115+(1-U131)/P130),4),   0)","v":0}]