{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Credit Calculations-Current MY","Averaging and Summary","Field Descriptions"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":2,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Credit Calculations-Current MY","index":0,"n_rows":87,"n_cols":63,"rows_kept":87,"cut":false,"hidden":false,"merged":[[81,1,81,6],[82,1,82,6],[30,15,30,18],[78,1,78,6],[80,1,80,6],[75,1,75,6],[68,1,69,6],[74,1,74,6],[73,1,73,6],[68,10,68,12],[72,1,72,6],[71,1,71,6],[70,1,70,6],[68,7,68,9],[68,13,68,16],[17,33,17,39],[29,39,29,41],[17,23,17,24],[29,28,29,30],[17,25,17,28],[17,30,17,32],[33,15,33,18],[34,15,34,18],[35,15,35,18],[36,15,36,18],[37,15,37,18],[19,1,19,18],[20,1,20,18],[21,1,21,18],[23,1,23,18],[31,15,31,18],[32,15,32,18],[38,15,38,18],[39,15,39,18],[40,15,40,18],[41,15,41,18],[53,15,53,18],[42,15,42,18],[43,15,43,18],[44,15,44,18],[45,15,45,18],[46,15,46,18],[47,15,47,18],[55,15,55,18],[56,15,56,18],[57,15,57,18],[58,15,58,18],[59,15,59,18],[48,15,48,18],[49,15,49,18],[50,15,50,18],[51,15,51,18],[52,15,52,18],[24,1,24,18],[60,15,60,18],[61,15,61,18],[85,9,85,16],[86,9,90,16],[62,15,62,18],[63,15,63,18],[64,15,64,18],[65,15,65,18],[54,15,54,18]],"flags":["formulas_cached_only"]}
[]
[null,"HIDDEN FIELDS"]
[null,"NOx+NMHC",{"$nulls":4},"Averaging Sets:",null,"PM ",null,null,null,"Useful Life"]
[null,0.1,"discount if FEL >",{"$nulls":5},0.1,"g/bhp-hr for Truck Engines",null,null,110000]
[null,1.9,"g/bhp-hr NMHC+NOx",null,null,"TRIGGER","PM - Urban Bus",null,0.05,"g/bhp-hr for Urban Buses",null,null,185000]
[null,2.4,"g/bhp-hr NMHC+NOx",null,null,"standard","PM - Other",{"$nulls":5},435000]
[null,"2007 & LATER:",{"$nulls":5},"NOx",{"$nulls":4},290000,"(pre-2004 value.  Used by DDX e.g.)"]
[null,"NOx Standard:",0.2,"g/bhp-hr",null,null,null,"NMHC+NOx"]
[null,"PM Standard:",0.01,"g/bhp-hr",null,null,null,"NMHC+NOx+Alt"]
[null,"Voluntary NOx:",0.1,"g/bhp-hr","creates offsets if pre-2007",null,null,"Y"]
[{"$nulls":7},"N"]
[]
[null,"OR (Alternative Standard)",{"$nulls":6},"FEL Caps"]
[null,2.5,"g/bhp-hr NMHC+NOx",null,null,"with a ","Light",2.4,4.5,"g/bhp-hr ","NMHC+NOx"]
[null,0.5,"g/bhp-hr NMHC limit",null,null,null,"Medium",2.5,0.25,"g/bhp-hr","PM"]
[{"$nulls":6},"Heavy",null,0.02,"g/bhp-hr","PM ","2007 and later"]
[{"$nulls":8},2,"g/bhp-hr","NOx","2007 through 2009"]
[null,435000,"miles minimum useful life",{"$nulls":5},0.5,"g/bhp-hr","NOx","2010 and later",{"$nulls":39},"NOX+NMHC percent:",null,""]
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Transportation and Air Quality"]
[]
[null,"Manufacturer Averaging, Banking, and Trading Report for Heavy Duty Highway Diesel Engines"]
[null,"Last Revision: August 2010    Version Number 2.3"]
[]
[null,"Current Model Year Credit Calculations"]
[]
[{"$nulls":51},"Phase-in percent:",null,"",{"$nulls":5},"The FEL cap for one or more parameters has been exceeded."]
[null,"MODEL YEAR:",{"$nulls":6},"Heavy Duty Highway Diesel Engines ABT Template (Credit Calculations) - Version 2.1",{"$nulls":14},"ALL OF THIS WILL BE HIDDEN!",{"$nulls":8},"NOx",null,null,"NMHC+NOx",null,null,"PM"]
[null,"Engine Family","Service Class","Offsets Used? (Y/N)","PM Averaging Set","Certified to NOx, NMHC+NOx, or NMHC+NOx Alternate Standard?","NOx or NMHC+NOx FEL","PM FEL","Production Volume (units)","Conversion Factor","Applicable Standard (NOx or NMHC+NOx)","Applicable Standard (PM)","Useful Life (miles)","NOx or NMHC+NOx Averaging Credit Balance","PM Averaging Credit Balance","Messages",{"$nulls":4},"NOx Fields Complete","PM Fields Complete","Offsets Used",null,"Light","Med","Heavy","Urban Bus","Light","Med","Heavy",null,"Light","Med","Heavy","Light","Med","Heavy","Urban Bus","Light","Med","Heavy",null,"NOX deficit?","> trigger","< trigger","PM deficit?","> trigger","< trigger",null,"Certified to NOx","Certified to NOx+NMHC","Certified to NOx+NMHC+Alt","NOx + NMHC Cert Production","Offsets Used","MY 2007","MY 2008-9","MY 2010+","High FEL NMHC","High FEL NOx 07-09","High FEL NOx 2010+","High PM FEL","Error Message Flag"]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},1,"","","","","","",{"$nulls":4},0,0,0,null,0,0,0,0,0,0,0,null,"","","","","","","","","","",null,"","","","","","",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[{"$nulls":7},"NOx",null,null,"NMHC+NOx",null,null,"PM"]
[{"$nulls":7},"Light","Medium","Heavy","Light","Medium","Heavy","Urban Bus","Light","Medium","Heavy"]
[null,"Current MY Deficit",{"$nulls":8},0,0,0,0,0,0,0]
[null,"Current MY Credits available for Averaging"]
[null,"     (NMHC+NOx FEL > trigger:  10% discount applied before banking or trading.)",{"$nulls":8},0,0,0,0,0,0,0]
[null,"     (NMHC+NOx FEL < trigger:  No discount applied before banking or trading.)",{"$nulls":8},0,0,0,0,0,0,0]
[null,"     TOTAL CREDITS AVAILABLE FOR AVERAGING",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"PHASE-IN PERCENT (% Engines Certified to NOx and PM Standards for 2007+)",{"$nulls":5},"","NOTE:  this percentage must exceed 50% for MY 2007, 2008 and 2009"]
[]
[null,"OFFSETS ACCRUED PRIOR TO 2007"]
[null,"OFFSETS USED (MY 2007 through 2009 only)",{"$nulls":5},0]
[null,"TOTAL OFFSETS",{"$nulls":5},0]
[]
[]
[{"$nulls":9},"Paperwork Reduction Act Notice"]
[{"$nulls":9},"The public reporting and recordkeeping burden for this collection of information is estimated to average 43 hours per response.  Send comments on the Agency's need for this information, the accuracy of the provided burden estimates, and any suggested methods for minimizing respondent burden, including through the use of automated collection techniques to the Director, Collection Strategies Division, U.S. Environmental Protection Agency (2822T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460.  Include the OMB control number in any correspondence.  Do not send the completed form to this address."]

{"sheet":"Averaging and Summary","index":1,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,1,5,12],[49,3,49,10],[50,3,54,10],[11,3,11,12],[12,6,12,8],[12,9,12,12],[12,3,12,5],[6,1,6,12]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Transportation and Air Quality"]
[]
[null,"Manufacturer Averaging, Banking, and Trading Report for Heavy Duty Highway Diesel Engines"]
[null,"Last Revision: August 2010    Version Number: 2.3"]
[]
[null,"Summary of Heavy Duty Highway Diesel Credit Balances"]
[]
[]
[null,"Model Year:","Manufacturer:","Averaging Set"]
[null,null,null,"NOx",null,null,"NMHC+NOx",null,null,"PM"]
[null,null,null,"Light","Medium","Heavy","Light","Medium","Heavy","Urban Bus","Light","Medium","Heavy"]
[null,"Deficit:"]
[null,null,"Current MY Deficit",null,null,null,0,0,0,0,0,0,0]
[null,"Credit Balances before Averaging:"]
[null,null,"Current MY NOx credits ",0,0,0]
[null,null,"Carryover credits banked from prior model years"]
[null,null,"Current MY credits acquired via trading activity"]
[null,null,"Current MY Credits (FEL > trigger:  10% discount before banking or trading.)",null,null,null,0,0,0,0,0,0,0]
[null,null,"Current MY Credits (FEL < trigger:  No discount.)",null,null,null,0,0,0,0,0,0,0]
[null,"Credit Usage and Averaging:"]
[null,null,"Apply credits acquired via trade"]
[null,null,"Apply carryover credits"]
[null,null,"Apply current MY credits (FEL > trigger)"]
[null,null,"Apply current MY credits (FEL < trigger)"]
[null,null,"Apply NMHC+NOx credits to NOx Balance"]
[null,null,"Credits applied to NOx Balance (w/ 20% discount)",0,0,0]
[null,"Credit Summary after Averaging:"]
[null,null,"Current MY Deficit  ",null,null,null,0,0,0,0,0,0,0]
[null,null,"Carryover credit balance",0,0,0,0,0,0,0,0,0,0]
[null,null,"Credits acquired via trading activity",0,0,0,0,0,0,0,0,0,0]
[null,null,"     Current MY credit bal.  (FEL > trigger)",null,null,null,0,0,0,0,0,0,0]
[null,null,"     Discount Amount  (10%)",null,null,null,0,0,0,0,0,0,0]
[null,null,"Current MY credit bal. (FEL > trigger) after discount",null,null,null,0,0,0,0,0,0,0]
[null,null,"Current MY credit bal.  (FEL < trigger)",null,null,null,0,0,0,0,0,0,0]
[null,null,"Current MY Credits for Banking/Trading",0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Credit Balance after Averaging",0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,"***  Please make sure you have Automatic Calculations turned ON.   [Tools -->  Options  --> Calculation tab.   Select the 'Automatic' radio button]"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Paperwork Reduction Act Notice"]
[null,null,null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 43 hours per response.  Send comments on the Agency's need for this information, the accuracy of the provided burden estimates, and any suggested methods for minimizing respondent burden, including through the use of automated collection techniques to the Director, Collection Strategies Division, U.S. Environmental Protection Agency (2822T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460.  Include the OMB control number in any correspondence.  Do not send the completed form to this address."]
{"$rows_empty":17}
[{"$nulls":6},"HIDDEN"]
[]
[{"$nulls":6},0,0,0,0,0,0,0]

{"sheet":"Field Descriptions","index":2,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,1,31,2],[32,1,36,2],[5,0,5,3],[1,1,1,2],[2,1,2,2],[3,1,3,2],[6,0,6,3]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Transportation and Air Quality"]
[]
["Manufacturer Averaging, Banking, and Trading Report for Heavy Duty Highway Diesel Engines"]
["Last Revision: August 2010    Version Number: 2.3"]
[]
[null,"Field Descriptions for Credit Calculations- Current MY"]
[]
[]
[null,"FIELDS (for Credit Calculation - Current MY)","NOTES"]
[null,"Engine Family","Enter the 12-character engine family name or test group name.  "]
[null,"Service Class","Enter the primary intended service class for the associated engine family.  Available options are Light, Medium, and Heavy."]
[null,"Offsets Used? (Y/N)","Select Y or N to indicate whether the engine family is using Offsets generated in previous model years.  A selection of \"Y\" precludes participation in the ABT program and as such, credits will not be calculated."]
[null,"PM Averaging Set","Enter the PM Averaging set - 'PM - Urban Bus' or 'PM - Other'."]
[null,"Certified to NOx, NMHC+NOx, or NMHC+NOx Alternate Standard?","Indicate whether the engine family has been certified to the NOx standards for 2007 and later HDEs or the NMHC+NOx standards by selecting from the drop-down menu."]
[null,"NOx or NMHC+NOx FEL","Enter the applicable standard for NOx or NMHC+NOx for the engine family.  The NMHC+NOx standard for \"Phase-out\" engines must either be 2.4 or 2.5 g/bhp-hr.  If the latter is chosen, the NMHC component must be no more than 0.5 g/bhp-hr.  "]
[null,"PM FEL","Enter the NMHC+NOx FEL for the engine family."]
[null,"Production Volume (units)","Enter the PM FEL for the engine family."]
[null,"Conversion Factor","Enter the number of engines produced for U.S. sales within the associated engine family during the model year.  "]
[null,"Applicable Standard (NOx or NMHC+NOx)","Enter the transient cycle conversion factor in bhp-hr/mile or MJ/mile for the associated engine family.  "]
[null,"Applicable Standard (PM)","This is a determined value based on the PM Averaging Set."]
[null,"Useful Life (miles)","The useful life for the engine family is determined based upon the Service Class entered.  The options are 110, 185, and 435 for the Light, Medium, and Heavy service classes respectively."]
[null,"NOx or NMHC+NOx Averaging Credit Balance","This is a calculated value based on the applicable NOx or NMHC+NOx standard, the entered FEL, conversion factor, useful life, and production volume.  If the parameter is NMHC+NOx (i.e., phase-out engines), then the credit balance reflects the required 10% discount that is applied if the NMHC+NOx FEL is greater than the 1.90 g/bhp-hr cut-off point."]
[null,"PM Averaging Credit Balance","This is a calculated value based on the applicable PM standard, the entered FEL, conversion factor, useful life, and production volume.  If the engine family is certified to the NMHC+NOx standard (i.e., phase-out engines), then this PM credit balance also reflects the required 10% discount that is applied to both the NMHC+NOx and PM credit balances if the NMHC+NOx FEL is greater than the 1.90 g/bhp-hr cut-off point."]
[null,{"$error":"#N/A"}]
[]
[]
[]
[]
[null,"Paperwork Reduction Act Notice"]
[null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 43 hours per response.  Send comments on the Agency's need for this information, the accuracy of the provided burden estimates, and any suggested methods for minimizing respondent burden, including through the use of automated collection techniques to the Director, Collection Strategies Division, U.S. Environmental Protection Agency (2822T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460.  Include the OMB control number in any correspondence.  Do not send the completed form to this address."]