{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Instructions","Current MY Credit Calc","Current MY Credit Calc-MANUAL","Field Descriptions","Power Rating Calc","Proration Factors","Credit Summary"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":1,"defined_names":8,"comments":4,"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":"Instructions","index":0,"n_rows":129,"n_cols":2,"rows_kept":129,"cut":false,"hidden":false,"merged":[[129,15,129,16],[130,15,130,16],[6,0,6,16],[1,0,1,16],[2,0,2,16],[3,0,3,16],[5,0,5,16],[128,1,132,13],[127,1,127,13],[127,15,127,16],[128,15,128,16]],"flags":["formulas_cached_only"]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Air and Radiation, Office of Transportation and Air Quality"]
[]
["Manufacturer Averaging, Banking, and Trading Report for Locomotives"]
["Last Revision: August 2012  Version Number: 2.2"]
[]
["Manufacturer Data Submission Template -- INSTRUCTIONS "]
{"$rows_empty":118}
[null,"Paperwork Reduction Act Notice"]
[null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 30 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":"Current MY Credit Calc","index":1,"n_rows":196,"n_cols":58,"rows_kept":196,"cut":false,"hidden":false,"merged":[[6,1,6,16],[67,14,67,15],[68,14,70,15],[72,14,76,14],[11,22,13,22],[11,50,11,54],[11,20,13,20],[11,24,11,26],[66,20,67,20],[66,21,67,21],[66,22,67,22],[66,23,66,24],[11,55,13,55],[11,56,13,56],[11,57,13,57],[11,27,11,28],[11,32,13,32],[11,29,13,29],[11,48,11,49],[11,46,11,47],[11,31,13,31],[102,1,107,1],[11,19,13,19],[11,33,13,33],[67,1,67,8],[11,21,13,21],[80,1,80,9],[89,2,90,2],[102,2,103,2],[104,2,105,2],[106,2,107,2],[11,2,11,3],[68,1,69,1],[87,2,88,2],[97,1,100,1],[97,2,98,2],[99,2,100,2],[92,2,93,2],[94,2,95,2],[92,1,95,1],[87,1,90,1],[68,4,68,5],[68,6,68,7],[68,2,68,3],[68,8,69,8],[82,1,85,1],[82,2,83,2],[84,2,85,2],[2,54,2,55],[1,1,1,16],[2,1,2,16],[3,1,3,16],[5,1,5,16],[66,25,66,26],[11,30,13,30],[11,34,11,45],[11,23,13,23],[10,2,10,3]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Air and Radiation, Office of Transportation and Air Quality"]
[]
[null,"Manufacturer Averaging, Banking, and Trading Report for Locomotives"]
[null,"Last Revision: August 2012  Version Number: 2.2"]
[]
[null,"Current MY Emission Credits",{"$nulls":10},"Submission Date:"]
[]
[null,"MODEL YEAR:"]
[null,"Manufacturer:",{"$nulls":17},"Error?","Entered all values?","Model Year and Tier  Check (Tier 3 and 4)","Model Year and Tier  Check (Tier 2)","Category","Standards",null,null,"FEL Cap*",null,"FEL exceeds cap?","Eng.Fam Info Match","Notes","Notes(2)","Notes Final","Credit Summary Calculation",{"$nulls":11},"Tier 4: All loc.",null,"Nox Credits: Fresh. Man",null,"Part 1033 engine families using credits",{"$nulls":4},"Error 1","Error 2","Error Final"]
[]
[null,"Engine Family ","Applicable 40 CFR Part","Remanufactured? (Yes/No)","Age","Pollutant","Tier","Engine Class Type","Power Rating (hp)1","Useful Life (MW-hrs)","Production","FEL       (g/bhp-hr)","Proration Factor (Fp)2","Standard (g/bhp-hr)","Credit Balance (Mg)","Messages","Comments",{"$nulls":7},"Alternate Standards","Part 1033"," Part 92","Part 1033","Part 92",{"$nulls":5},0,1,2,3,4,"Part 92","Part 1033","line haul","switch","PM","NOx ","HC+NOx ","# Using Credits","Production","# Using Nox Credits","Total Nox Production","Credit Balance","Using","Generating","Matching Array Pos","Error?"]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,null,null,"",{"$nulls":8},"","","","",null,null,null,0,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,"1 See Power Rating Calc tab",{"$nulls":25},"* 0 means no FEL cap"]
[null,"2 See Proration Factors tab.  The proration factor is 1.00 for all locomotives that meet the definition of freshly manufactured."]
[{"$nulls":20},"Tier","Parameter","Engine Class","Part 1033",null,"Part 92"]
[null,"SUMMARY OF CURRENT MODEL YEAR CREDITS (Mg)",{"$nulls":7},"Messages",{"$nulls":4},"Paperwork Reduction Act Notice",{"$nulls":8},"Std ","FEL Cap","Std","FEL Cap"]
[null,"TIER","NOx Credits",null,"NOx+HC Credits (Tier 4)",null,"PM Credits",null,"% Using Credits* ","",{"$nulls":4},"The public reporting and recordkeeping burden for this collection of information is estimated to average 30 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.",{"$nulls":4},"Tier 0NOxLine-Haul","Tier 0","NOx","Line-Haul",8,null,9.5]
[null,null,"Line-Haul","Switch","Line-Haul","Switch","Line-Haul","Switch",{"$nulls":11},"Tier 0NOxSwitch","Tier 0","NOx","Switch",11.8,null,14]
[null,"Tier 0 Part 92",0,0,null,null,0,0,{"$nulls":11},"Tier 0PMLine-Haul","Tier 0","PM","Line-Haul",0.22,null,0.32]
[null,"Tier 0 Part 1033",0,0,null,null,0,0,{"$nulls":11},"Tier 0PMSwitch","Tier 0","PM","Switch",0.26,null,0.44]
[null,"Tier 1 Part 92",0,0,null,null,0,0,null,"",{"$nulls":4},"OMB No. 2060-0392\nApproval Expires on\n3/31/2023\nEPA Form 5900-274\n",{"$nulls":4},"Tier 0HC+NOxLine-Haul","Tier 0","HC+NOx","Line-Haul"]
[null,"Tier 1 Part 1033",0,0,null,null,0,0,{"$nulls":11},"Tier 0HC+NOxSwitch","Tier 0","HC+NOx","Switch"]
[null,"Tier 2 Part 92",0,0,null,null,0,0,"NA",{"$nulls":10},""]
[null,"Tier 2 Part 1033",0,0,null,null,0,0,{"$nulls":11},"Tier 1NOxLine-Haul","Tier 1","NOx","Line-Haul",7.4,8,7.4,9.5]
[null,"Tier 3 Part 1033",0,0,null,null,0,0,{"$nulls":11},"Tier 1NOxSwitch","Tier 1","NOx","Switch",11,11.8,11,14]
[null,"Tier 4 Part 1033",0,0,0,0,0,0,"NA",{"$nulls":10},"Tier 1PMLine-Haul","Tier 1","PM","Line-Haul",0.22,0.22,0.32,0.6]
[{"$nulls":8},"*May not exceed 50%.",{"$nulls":10},"Tier 1PMSwitch","Tier 1","PM","Switch",0.26,0.26,0.44,0.72]
[{"$nulls":19},"Tier 1HC+NOxLine-Haul","Tier 1","HC+NOx","Line-Haul"]
[null,"SUMMARY OF 40 CFR PARTS 92 AND 1033 STANDARDS AND FEL CAPS",{"$nulls":17},"Tier 1HC+NOxSwitch","Tier 1","HC+NOx","Switch"]
[null,"If Tier is:","And Pollutant is:","And Engine Class is:","Then Part 1033 Year of Original Manufacture is:","Then Part 1033 Std (g/bhp-hr) is:","Part 1033 FEL cap","Then Part 92 Year of Original Manufacture is:","Then Part 92 Std (g/bhp-hr) is:1","Part 92 FEL cap",{"$nulls":9},""]
[null,"Tier 02","NOx","Line-Haul","1973-1992",8,null,"before 2001",9.5,{"$nulls":10},"Tier 2NOxLine-Haul","Tier 2","NOx","Line-Haul",5.5,7.4,5.5,7.4]
[null,null,null,"Switch","1973-2001",11.8,null,"before 2001",14,{"$nulls":10},"Tier 2NOxSwitch","Tier 2","NOx","Switch",8.1,11,8.1,11]
[null,null,"PM","Line-Haul","1973-1992",0.22,null,"before 2001",0.32,{"$nulls":10},"Tier 2PMLine-Haul","Tier 2","PM","Line-Haul",0.1,0.22,0.2,0.45]
[null,null,null,"Switch","1973-2001",0.26,null,"before 2001",0.44,{"$nulls":10},"Tier 2PMSwitch","Tier 2","PM","Switch",0.13,0.26,0.24,0.54]
[{"$nulls":19},"Tier 2HC+NOxLine-Haul","Tier 2","HC+NOx","Line-Haul"]
[null,"Tier 12","NOx","Line-Haul","1993-2004",7.4,8,"2002-2004",7.4,9.5,{"$nulls":9},"Tier 2HC+NOxSwitch","Tier 2","HC+NOx","Switch"]
[null,null,null,"Switch","2002-2004",11,11.8,"2002-2004",11,14,{"$nulls":9},""]
[null,null,"PM","Line-Haul","1993-2004",0.22,0.22,"2002-2004",0.32,0.6,{"$nulls":9},"Tier 3NOxLine-Haul","Tier 3","NOx","Line-Haul",5.5,5.5]
[null,null,null,"Switch","2002-2004",0.26,0.26,"2002-2004",0.44,0.72,{"$nulls":9},"Tier 3NOxSwitch","Tier 3","NOx","Switch",5,8.1]
[{"$nulls":19},"Tier 3PMLine-Haul","Tier 3","PM","Line-Haul",0.1,0.1]
[null,"Tier 22","NOx","Line-Haul","2005-2011",5.5,7.4,"2005 or later",5.5,7.4,{"$nulls":9},"Tier 3PMSwitch","Tier 3","PM","Switch",0.1,0.13]
[null,null,null,"Switch","2005-2010",8.1,11,"2005 or later",8.1,11,{"$nulls":9},"Tier 3HC+NOxLine-Haul","Tier 3","HC+NOx","Line-Haul"]
[null,null,"PM","Line-Haul","2005-2011",0.1,0.22,"2005 or later",0.2,0.45,{"$nulls":9},"Tier 3HC+NOxSwitch","Tier 3","HC+NOx","Switch"]
[null,null,null,"Switch","2005-2010",0.13,0.26,"2005 or later",0.24,0.54,{"$nulls":9},""]
[{"$nulls":19},"Tier 4NOxLine-Haul","Tier 4","NOx","Line-Haul",1.3,5.5]
[null,"Tier 3","NOx","Line-Haul","2012-2014",5.5,5.5,{"$nulls":12},"Tier 4NOxSwitch","Tier 4","NOx","Switch",1.3,5]
[null,null,null,"Switch","2011-2014",5,8.1,{"$nulls":12},"Tier 4PMLine-Haul","Tier 4","PM","Line-Haul",0.03,0.1]
[null,null,"PM","Line-Haul","2012-2014",0.1,0.1,{"$nulls":12},"Tier 4PMSwitch","Tier 4","PM","Switch",0.03,0.1]
[null,null,null,"Switch","2011-2014",0.1,0.13,{"$nulls":12},"Tier 4HC+NOxLine-Haul","Tier 4","HC+NOx","Line-Haul",1.4]
[{"$nulls":19},"Tier 4HC+NOxSwitch","Tier 4","HC+NOx","Switch",1.4]
[null,"Tier 4","NOx","Line-Haul","2015 or later",1.3,5.5]
[null,null,null,"Switch","2015 or later",1.3,5]
[null,null,"PM","Line-Haul","2015 or later",0.03,0.1]
[null,null,null,"Switch","2015 or later",0.03,0.1]
[null,null,"Alternate HC+Nox","Line-Haul","2015 or later",1.4]
[null,null,null,"Switch","2015 or later",1.4]
[]
[null,"1 §92.305(a)(2)(i) ABT standards: Std=0.43 g/kW-hr for Tier 0 and Tier 1 PM line-haul credits; Std=0.59 g/kW-hr for Tier 0 and Tier 1 PM switch credits (.7457*(g/kW-hr) = (g/bhp-hr))"]
[null,"2 §1033.102(a) and (b): Part 1033 Tier 0 and 1 standards apply for new locomotives beginning 1-1-10.  Part 1033 Tier 2 standards apply for new locomotives beginning 1-1-13.  Tier 0, 1, and 2 Part 92 "]
[null,"  standards apply for earlier model years unless the locomotive is remanufactured.  According to §1033.150(a), for the 2009 MY, remanufacturers may remanufacture Tier 0, 1, and 2 locomotives   "]
[null,"   to Part 92  standards only if no remanufacture system has been certified to meet the Part 1033 standards.  After 2009, this provision applies only to Tier 2 remanufactured locomotives.  "]
[null,"3 Tier 3 and 4 standards apply for the model years specified in the table."]
[]
[]
[null,"CREDITS = (Std - FEL) x (1.341) x (UL) x (Production) x (Fp) x (10 -3)"]
[null,"Notes:"]
[null,"Tier 0 through 2 Line-Haul must also meet Switch stds."]
[null,"Tier 1 and 2 Switch must also meet Line-Haul stds."]
[null,"Tier 3 Line-Haul must also meet Tier 2 Switch stds"]
[]
[null,"Part 92","Yes","NOx","Tier 0"]
[null,"Part 1033","No","PM","Tier 1"]
[null,null,null,"HC+NOx","Tier 2"]
[{"$nulls":4},"Tier 3","Line-Haul"]
[{"$nulls":4},"Tier 4","Switch"]
[null,"MESSAGES:"]
[null,"Error: Proration factor should equal 1.0 if locomotive is freshly manufactured (Remanufactured? = No).(40 CFR 1033.705(d))"]
[null,"Error:  NOx+HC available only for Part 1033 Tier 4 (40 CFR 1033.101(j))"]
[null,"Error:  FEL Cap has been exceeded.  See Summary table below for guidance."]
[null,"Error:  Engine family information in this row is inconsistent with previous record (e.g. Maximum Power, Applicable 40 CFR Part, Production Vol.)"]
[null,"Error:  First digit in engine family name does not match model year. (invalid error message)"]
[null,"Error: Cannot generate Tier 3 or 4 credits for Part 92."]
[null,"Error: Part 1033 engine families that use emission credits for one or more pollutants may not generate positive emission credits for another pollutant. (1033.701(e))"]
[null,"Warning: The Model Year, Tier, and Applicable CFR Part do not match up.  See \"Summary of 40 CFR Part 92 and 1033 Standards and FEL Caps\" Table below for guidance."]
[null,"Note: Part 1033 Tier 3 Line-Haul locomotives must also meet Tier 2 Switch standards. (40 CFR 1033.101(a))"]
[null,"Note: Part 1033 Tier 2 Line-Haul locomotives must also meet Tier 2 Switch standards. (40 CFR 1033.101(a))"]
[null,"Note: Part 1033 Tier 1 Line-Haul locomotives must also meet Tier 1 Switch standards. (40 CFR 1033.101(a))"]
[null,"Note: Part 1033 Tier 0 Line-Haul locomotives must also meet Tier 0 Switch standards. (40 CFR 1033.101(a))"]
[null,"Note: Part 1033 Tier 2 Switch locomotives must also meet Tier 1 Line-Haul standards. (40 CFR 1033.101(b))"]
[null,"Note: Part 1033 Tier 1 Switch locomotives must also meet Tier 2 Line-Haul Standards. (40 CFR 1033.101(b))"]
[null,"Note: Part 92 Switch locomotives must also meet Line-Haul standards. (40 CFR 92.8(a))"]
[null,"Note: Part 92 Line-Haul locomotives must also meet Switch standards. (40 CFR 92.8(a))"]
[null,"The number of Tier 4 locomotives that can be certified using credits in any year may not exceed 50% of the total number of Tier 4 locomotives produced by a manufacturer for U.S. directed sales. (40 CFR 1033.740(d)) "]
[null,"For Part 92 Tier 2 freshly manufactured locomotives, manufacturers may use NOx credits only for engine families that are projected to represent ≤ 50% of their total projected annual production of freshly manufactured locomotives. (40 CFR 92.304(j)(2))"]
[null,"",null,"",false,1]
[null,null,null,"",false,1]
[null,null,null,"",false,1]
[null,null,null,"",false,1]
[null,null,null,"",false,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]

{"sheet":"Current MY Credit Calc-MANUAL","index":2,"n_rows":203,"n_cols":55,"rows_kept":203,"cut":false,"hidden":false,"merged":[[6,1,6,15],[81,8,84,9],[80,11,80,15],[81,11,85,15],[10,2,10,3],[11,2,11,3],[2,53,2,54],[11,54,13,54],[67,1,67,8],[68,2,68,3],[68,4,68,5],[1,1,1,15],[2,1,2,15],[3,1,3,15],[5,1,5,15],[11,52,13,52],[11,53,13,53],[11,17,13,17],[11,18,13,18],[11,19,13,19],[11,43,11,44],[104,1,107,1],[104,2,105,2],[106,2,107,2],[68,9,71,14],[72,9,74,14],[68,1,69,1],[109,1,114,1],[109,2,110,2],[111,2,112,2],[113,2,114,2],[94,1,97,1],[94,2,95,2],[96,2,97,2],[99,1,102,1],[99,2,100,2],[101,2,102,2],[11,28,13,28],[87,1,87,9],[89,1,92,1],[89,2,90,2],[91,2,92,2],[11,31,11,42],[68,6,68,7],[68,8,69,8],[66,18,67,18],[66,19,67,19],[66,20,67,20],[66,21,66,22],[11,45,11,46],[11,30,13,30],[66,23,66,24],[11,29,13,29],[11,47,11,51],[11,20,13,20],[11,21,11,23],[11,24,11,25],[11,26,13,26],[11,27,13,27]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Air and Radiation, Office of Transportation and Air Quality"]
[]
[null,"Manufacturer Averaging, Banking, and Trading Report for Locomotives"]
[null,"Last Revision: August 2012  Version Number: 2.2"]
[]
[null,"Current MY Emission Credits - Manual",{"$nulls":10},"Submission Date:",null,""]
[]
[null,"MODEL YEAR:","",""]
[null,"Manufacturer:","","",{"$nulls":13},"Entered all values?","Model Year and Tier  Check (Tier 3 and 4)","Model Year and Tier  Check (Tier 2)","Category","Standards",null,null,"FEL Cap*",null,"FEL exceeds cap?","Eng.Fam Info Match","Notes","Notes(2)","Notes Final","Credit Summary Calculation",{"$nulls":11},"Tier 4: All loc.",null,"Nox Credits: Fresh. Man",null,"Part 1033 engine families using credits",{"$nulls":4},"Error 1","Error 2","Error Final"]
[]
[null,"Engine Family ","Applicable 40 CFR Part","Remanufactured? (Yes/No)","Age ","Pollutant","Tier","Engine Class Type","Power Rating (hp)1","Useful Life (MW-hrs)","Production","FEL       (g/bhp-hr)","Proration Factor (Fp)2","Standard (g/bhp-hr)","Credit Balance (Mg)","Comments",{"$nulls":5},"Alternate Standards","Part 1033"," Part 92","Part 1033","Part 92",{"$nulls":5},0,1,2,3,4,"Part 92","Part 1033","line haul","switch","PM","NOx ","HC+NOx ","# Using Credits","Production","# Using Nox Credits","Total Nox Production","Credit Balance","Using","Generating","Matching Array Pos","Error?"]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[{"$nulls":14},"",null,null,0,0,0,"","","","","","","",0,"","","",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","",0,"","","",""]
[null,"1 See Power Rating Calc tab",{"$nulls":23},"* 0 means no FEL cap"]
[null,"2 See Proration Factors tab.  The proration factor is 1.00 for all locomotives that meet the definition of freshly manufactured."]
[{"$nulls":18},"Tier","Parameter","Engine Class","Part 1033",null,"Part 92"]
[null,"SUMMARY OF CURRENT MODEL YEAR CREDITS (Mg)",{"$nulls":7},"Messages",{"$nulls":11},"Std ","FEL Cap","Std","FEL Cap"]
[null,"TIER","NOx Credits",null,"NOx+HC Credits (Tier 4)",null,"PM Credits",null,"% Using Credits* ","",{"$nulls":7},"Tier 0NOxLine-Haul","Tier 0","NOx","Line-Haul",8,null,9.5]
[null,null,"Line-Haul","Switch","Line-Haul","Switch","Line-Haul","Switch",{"$nulls":9},"Tier 0NOxSwitch","Tier 0","NOx","Switch",11.8,null,14]
[null,"Tier 0 Part 92",0,0,null,null,0,0,{"$nulls":9},"Tier 0PMLine-Haul","Tier 0","PM","Line-Haul",0.22,null,0.32]
[null,"Tier 0 Part 1033",0,0,null,null,0,0,{"$nulls":9},"Tier 0PMSwitch","Tier 0","PM","Switch",0.26,null,0.44]
[null,"Tier 1 Part 92",0,0,null,null,0,0,null,"",{"$nulls":7},"Tier 0HC+NOxLine-Haul","Tier 0","HC+NOx","Line-Haul"]
[null,"Tier 1 Part 1033",0,0,null,null,0,0,{"$nulls":9},"Tier 0HC+NOxSwitch","Tier 0","HC+NOx","Switch"]
[null,"Tier 2 Part 92",0,0,null,null,0,0,"NA",{"$nulls":8},""]
[null,"Tier 2 Part 1033",0,0,null,null,0,0,{"$nulls":9},"Tier 1NOxLine-Haul","Tier 1","NOx","Line-Haul",7.4,8,7.4,9.5]
[null,"Tier 3 Part 1033",0,0,null,null,0,0,{"$nulls":9},"Tier 1NOxSwitch","Tier 1","NOx","Switch",11,11.8,11,14]
[null,"Tier 4 Part 1033",0,0,0,0,0,0,"NA",{"$nulls":8},"Tier 1PMLine-Haul","Tier 1","PM","Line-Haul",0.22,0.22,0.32,0.6]
[{"$nulls":8},"*May not exceed 50%.",{"$nulls":8},"Tier 1PMSwitch","Tier 1","PM","Switch",0.26,0.26,0.44,0.72]
[]
[{"$nulls":11},"Paperwork Reduction Act Notice"]
[{"$nulls":8},"OMB No. 2060-0392\nApproval Expires on\n3/31/2023\nEPA Form 5900-274\n",null,null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 30 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."]
[]
[]
[{"$nulls":17},"Tier 1HC+NOxLine-Haul","Tier 1","HC+NOx","Line-Haul"]
[]
[]
[null,"SUMMARY OF 40 CFR PARTS 92 AND 1033 STANDARDS AND FEL CAPS",{"$nulls":15},"Tier 1HC+NOxSwitch","Tier 1","HC+NOx","Switch"]
[null,"If Tier is:","And Pollutant is:","And Engine Class is:","Then Part 1033 Year of Original Manufacture is:","Then Part 1033 Std (g/bhp-hr) is:","Part 1033 FEL cap","Then Part 92 Year of Original Manufacture is:","Then Part 92 Std (g/bhp-hr) is:1","Part 92 FEL cap",{"$nulls":7},""]
[null,"Tier 02","NOx","Line-Haul","1973-1992",8,null,"before 2001",9.5,{"$nulls":8},"Tier 2NOxLine-Haul","Tier 2","NOx","Line-Haul",5.5,7.4,5.5,7.4]
[null,null,null,"Switch","1973-2001",11.8,null,"before 2001",14,{"$nulls":8},"Tier 2NOxSwitch","Tier 2","NOx","Switch",8.1,11,8.1,11]
[null,null,"PM","Line-Haul","1973-1992",0.22,null,"before 2001",0.32,{"$nulls":8},"Tier 2PMLine-Haul","Tier 2","PM","Line-Haul",0.1,0.22,0.2,0.45]
[null,null,null,"Switch","1973-2001",0.26,null,"before 2001",0.44,{"$nulls":8},"Tier 2PMSwitch","Tier 2","PM","Switch",0.13,0.26,0.24,0.54]
[{"$nulls":17},"Tier 2HC+NOxLine-Haul","Tier 2","HC+NOx","Line-Haul"]
[null,"Tier 12","NOx","Line-Haul","1993-2004",7.4,8,"2002-2004",7.4,9.5,{"$nulls":7},"Tier 2HC+NOxSwitch","Tier 2","HC+NOx","Switch"]
[null,null,null,"Switch","2002-2004",11,11.8,"2002-2004",11,14,{"$nulls":7},""]
[null,null,"PM","Line-Haul","1993-2004",0.22,0.22,"2002-2004",0.32,0.6,{"$nulls":7},"Tier 3NOxLine-Haul","Tier 3","NOx","Line-Haul",5.5,5.5]
[null,null,null,"Switch","2002-2004",0.26,0.26,"2002-2004",0.44,0.72,{"$nulls":7},"Tier 3NOxSwitch","Tier 3","NOx","Switch",5,8.1]
[{"$nulls":17},"Tier 3PMLine-Haul","Tier 3","PM","Line-Haul",0.1,0.1]
[null,"Tier 22","NOx","Line-Haul","2005-2011",5.5,7.4,"2005 or later",5.5,7.4,{"$nulls":7},"Tier 3PMSwitch","Tier 3","PM","Switch",0.1,0.13]
[null,null,null,"Switch","2005-2010",8.1,11,"2005 or later",8.1,11,{"$nulls":7},"Tier 3HC+NOxLine-Haul","Tier 3","HC+NOx","Line-Haul"]
[null,null,"PM","Line-Haul","2005-2011",0.1,0.22,"2005 or later",0.2,0.45,{"$nulls":7},"Tier 3HC+NOxSwitch","Tier 3","HC+NOx","Switch"]
[null,null,null,"Switch","2005-2010",0.13,0.26,"2005 or later",0.24,0.54,{"$nulls":7},""]
[{"$nulls":17},"Tier 4NOxLine-Haul","Tier 4","NOx","Line-Haul",1.3,5.5]
[null,"Tier 3","NOx","Line-Haul","2012-2014",5.5,5.5,{"$nulls":10},"Tier 4NOxSwitch","Tier 4","NOx","Switch",1.3,5]
[null,null,null,"Switch","2011-2014",5,8.1,{"$nulls":10},"Tier 4PMLine-Haul","Tier 4","PM","Line-Haul",0.03,0.1]
[null,null,"PM","Line-Haul","2012-2014",0.1,0.1,{"$nulls":10},"Tier 4PMSwitch","Tier 4","PM","Switch",0.03,0.1]
[null,null,null,"Switch","2011-2014",0.1,0.13,{"$nulls":10},"Tier 4HC+NOxLine-Haul","Tier 4","HC+NOx","Line-Haul",1.4]
[{"$nulls":17},"Tier 4HC+NOxSwitch","Tier 4","HC+NOx","Switch",1.4]
[null,"Tier 4","NOx","Line-Haul","2015 or later",1.3,5.5]
[null,null,null,"Switch","2015 or later",1.3,5]
[null,null,"PM","Line-Haul","2015 or later",0.03,0.1]
[null,null,null,"Switch","2015 or later",0.03,0.1]
[null,null,"Alternate HC+Nox","Line-Haul","2015 or later",1.4]
[null,null,null,"Switch","2015 or later",1.4]
[]
[null,"1 §92.305(a)(2)(i) ABT standards: Std=0.43 g/kW-hr for Tier 0 and Tier 1 PM line-haul credits; Std=0.59 g/kW-hr for Tier 0 and Tier 1 PM switch credits (.7457*(g/kW-hr) = (g/bhp-hr))"]
[null,"2 §1033.102(a) and (b): Part 1033 Tier 0 and 1 standards apply for new locomotives beginning 1-1-10.  Part 1033 Tier 2 standards apply for new locomotives beginning 1-1-13.  Tier 0, 1, and 2 Part 92 "]
[null,"  standards apply for earlier model years unless the locomotive is remanufactured.  According to §1033.150(a), for the 2009 MY, remanufacturers may remanufacture Tier 0, 1, and 2 locomotives   "]
[null,"   to Part 92  standards only if no remanufacture system has been certified to meet the Part 1033 standards.  After 2009, this provision applies only to Tier 2 remanufactured locomotives.  "]
[null,"3 Tier 3 and 4 standards apply for the model years specified in the table."]
[]
[]
[null,"CREDITS = (Std - FEL) x (1.341) x (UL) x (Production) x (Fp) x (10 -3)"]
[null,"Notes:"]
[null,"Tier 0 through 2 Line-Haul must also meet Switch stds."]
[null,"Tier 1 and 2 Switch must also meet Line-Haul stds."]
[null,"Tier 3 Line-Haul must also meet Tier 2 Switch stds"]
[]
[null,"Part 92","Yes","NOx","Tier 0"]
[null,"Part 1033","No","PM","Tier 1"]
[null,null,null,"HC+NOx","Tier 2"]
[{"$nulls":4},"Tier 3","Line-Haul"]
[{"$nulls":4},"Tier 4","Switch"]
[null,"MESSAGES:"]
[null,"Error: Proration factor should equal 1.0 if locomotive is freshly manufactured (Remanufactured? = No).(40 CFR 1033.705(d))"]
[null,"Error:  NOx+HC available only for Part 1033 Tier 4 (40 CFR 1033.101(j))"]
[null,"Error:  FEL Cap has been exceeded.  See Summary table below for guidance."]
[null,"Error:  Engine family information in this row is inconsistent with previous record (e.g. Maximum Power, Applicable 40 CFR Part, Production Vol.)"]
[null,"Error:  First digit in engine family name does not match model year. (invalid error message)"]
[null,"Error: Cannot generate Tier 3 or 4 credits for Part 92."]
[null,"Error: Part 1033 engine families that use emission credits for one or more pollutants may not generate positive emission credits for another pollutant. (1033.701(e))"]
[null,"Warning: The Model Year, Tier, and Applicable CFR Part do not match up.  See \"Summary of 40 CFR Part 92 and 1033 Standards and FEL Caps\" Table below for guidance."]
[null,"Note: Part 1033 Tier 3 Line-Haul locomotives must also meet Tier 2 Switch standards. (40 CFR 1033.101(a))"]
[null,"Note: Part 1033 Tier 2 Line-Haul locomotives must also meet Tier 2 Switch standards. (40 CFR 1033.101(a))"]
[null,"Note: Part 1033 Tier 1 Line-Haul locomotives must also meet Tier 1 Switch standards. (40 CFR 1033.101(a))"]
[null,"Note: Part 1033 Tier 0 Line-Haul locomotives must also meet Tier 0 Switch standards. (40 CFR 1033.101(a))"]
[null,"Note: Part 1033 Tier 2 Switch locomotives must also meet Tier 1 Line-Haul standards. (40 CFR 1033.101(b))"]
[null,"Note: Part 1033 Tier 1 Switch locomotives must also meet Tier 2 Line-Haul Standards. (40 CFR 1033.101(b))"]
[null,"Note: Part 92 Switch locomotives must also meet Line-Haul standards. (40 CFR 92.8(a))"]
[null,"Note: Part 92 Line-Haul locomotives must also meet Switch standards. (40 CFR 92.8(a))"]
[null,"The number of Tier 4 locomotives that can be certified using credits in any year may not exceed 50% of the total number of Tier 4 locomotives produced by a manufacturer for U.S. directed sales. (40 CFR 1033.740(d)) "]
[null,"For Part 92 Tier 2 freshly manufactured locomotives, manufacturers may use NOx credits only for engine families that are projected to represent ≤ 50% of their total projected annual production of freshly manufactured locomotives. (40 CFR 92.304(j)(2))"]
[null,"",null,"",false,1]
[null,null,null,"",false,1]
[null,null,null,"",false,1]
[null,null,null,"",false,1]
[null,null,null,"",false,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]
[null,null,null,"",null,1]

{"sheet":"Field Descriptions","index":3,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,3,30,4],[31,3,36,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[5,1,5,4],[6,1,6,4]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Air and Radiation, Office of Transportation and Air Quality"]
[]
[null,"Manufacturer Averaging, Banking, and Trading Report for Locomotives"]
[null,"Last Revision: August 2012  Version Number: 2.2"]
[]
[null,"Field Descriptions for Current MY Credit Calc Worksheet"]
[]
[null,null,"Field","Description"]
[null,null,"Engine Family ","Enter the 12-character engine family name or test group name.  "]
[null,null,"Applicable 40 CFR Part","Select whether the engine family is certified under 40 CFR Part 92 or Part 1033."]
[null,null,"Remanufactured? (Y/N) ","This field will be automatically populated with \"Y\" or \"N\" if the Industry Sector Code (i.e., the fifth character within the engine family name) is \"K\" or \"G\", respectively.   Note that with respect to the NOx standard, the percentage of freshly manufactured engine families (on a production basis) that are using credits (i.e., with a NOx FEL greater than the standard) cannot exceed 50 percent in 2007 and later."]
[null,null,"Age","Age is the number of years from the date of original manufacture to the date the remanufacture is completed (rounded to the next higher year).  Note that for replacement or repower engines, the proration factor should be determined based on the age of the locomotive chassis, not the age of the engine."]
[null,null,"Pollutant","Select the applicable Pollutant (NOx, HC+NOx, or PM) from the drop-down menu."]
[null,null,"Tier ","Select the applicable Tier of standards (Tier 0, 1, 2, 3 or 4) from the drop-down menu."]
[null,null,"Engine Class Type","Select the type of cycle-weighted standards that apply to the engine family (or the subset participating in ABT for which credits are being calculated).  Please select either Line-haul cycle or Switch cycle from the drop-down menu."]
[null,null,"Power Rating (hp)","Enter the sales-weighted average horsepower of the engine family (or subset of the engine family for which credits are being calculated).  This value is necessary for credit calculations if useful life is listed in miles and can be calculated using the Power Rating Calc worksheet.  See 40 CFR §92.305(b) and §1033.705(c)."]
[null,null,"Useful Life (MW-hrs)","Enter the sales-weighted average useful life in MW-hrs, based on the sales-weighted average horsepower (hp) of the engine family (or subset of the engine family for which credits are being calculated).  If useful life is in miles or years, convert to MW-hrs.  See the methods for conversion at 40 CFR §92.305(b) and §1033.705(c)."]
[null,null,"Production","Enter the number of locomotives or locomotive engines participating in the ABT program within the given engine family during the calendar year (or the number of locomotives or locomotive engines in the subset of the engine family for which credits are being calculated)."]
[null,null,"FEL (g/bhp-hr)","Enter the applicable family emission limit (FEL) for the engine family (or subset participating in ABT) in grams per brake horsepower-hour (g/bhp-hr).  The number of significant digits for the FEL should be consistent with the standard."]
[null,null,"Proration Factor (Fp)","This field will be automatically calculated based on the Applicable 40 CFR Part, Engine Class Type and Age.  This is an estimate of the fraction of a locomotive's service life that remains as a function of age.  See Proration Factors worksheet for complete list of relevant factors for both line haul and switch engines.  The proration factor is 1.00 for all locomotives that meet the definition of freshly manufactured."]
[null,null,"Standard (g/kW-hr)","This is a predetermined value based on the Tier and engine type."]
[null,null,"Credit Balance","This is a calculated value based on the preceding data.  Credits for each engine family are calculated as follows:  Credits = (Standard - FEL) x (Useful Life in MW-hrs) x (Production) x (Proration Factor) x (10-3 kW-Mg/MW-g)"]
[null,null,"Messages","If a row of data contains an error, the Messages column will display an error message.  Otherwise, if applicable, the column will indicate which additional standards the engine family must meet."]
[null,null,"Comments","This field may be used to enter in any additional information regarding special circumstances or characteristics associated with the engine family name or credit calculations.  This field is for informational purposes only and would not affect credit calculations or compliance determinations.  The information entered may be used to distinguish between multiple entries for a split engine family, identify issues that EPA should be aware of as the data are evaluated, or track characteristics of the engine family name for internal purposes (e.g., identifying configurations, sub-configurations, model names/numbers, etc.)."]
[]
[]
[]
[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 30 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":"Power Rating Calc","index":4,"n_rows":81,"n_cols":8,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,5,0,7],[8,0,8,7],[9,0,9,7],[5,1,5,7],[4,5,4,7],[3,1,3,7],[2,1,2,7],[79,3,79,6],[80,3,85,6],[10,1,11,6],[6,0,6,7],[7,0,7,7],[1,1,1,7]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Air and Radiation, Office of Transportation and Air Quality"]
[]
[null,"Manufacturer Averaging, Banking, and Trading Report for Locomotives"]
["Last Revision: August 2012  Version Number: 2.2"]
[]
["Calculation of Production-Weighted Average Power for Locomotive Engines"]
[]
[null,"*The Average Power value corresponding to the final configurantion for a particular engine family is the power value used in the emission credit calculation (Current MY Credit Calc worksheet)"]
[]
[]
[null,"Engine Family Name","Configuration ","Maximum Power Rating (kW)","Production Volume","Cum. Production Volume","Average Power (kW)*","Average Power (hp)*"]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[]
[]
[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 30 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":"Proration Factors","index":5,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,1,6,8],[60,4,60,7],[61,4,66,7],[10,7,10,8],[33,4,33,5],[51,1,51,5],[48,1,50,5],[52,1,53,5],[10,1,10,2],[10,4,10,5],[1,1,1,8],[2,1,2,8],[3,1,3,8],[5,1,5,8],[54,1,56,5],[11,7,11,8],[53,7,53,8],[11,1,11,2],[45,1,45,2],[11,4,11,5]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Air and Radiation, Office of Transportation and Air Quality"]
[]
[null,"Manufacturer Averaging, Banking, and Trading Report for Locomotives"]
[null,"Last Revision: August 2012  Version Number: 2.2"]
[]
[null,null,"Proration Factors for Locomotive Engines Certified under 40 CFR Part 92 or 1033"]
[]
[null,"Part 92 Switch and Line-Haul",null,null,"Part 1033 Line-Haul",null,null,"Part 1033 Switch"]
[null,"Table D305-1 to §92.305 - Proration Factors (Fp)",null,null,"Table 1 to §1033.705 - Proration Factors (Fp)",null,null,"Table 2 to §1033.705 - Proration Factors (Fp)"]
[null,"Age 1","Proration Factor",null,"Age 1","Proration Factor",null,"Age 1","Proration Factor"]
[null,1,0.964,null,1,0.96,null,1,0.98]
[null,2,0.929,null,2,0.92,null,2,0.96]
[null,3,0.893,null,3,0.88,null,3,0.94]
[null,4,0.857,null,4,0.84,null,4,0.92]
[null,5,0.821,null,5,0.81,null,5,0.9]
[null,6,0.786,null,6,0.77,null,6,0.88]
[null,7,0.75,null,7,0.73,null,7,0.86]
[null,8,0.714,null,8,0.69,null,8,0.84]
[null,9,0.679,null,9,0.65,null,9,0.82]
[null,10,0.643,null,10,0.61,null,10,0.8]
[null,11,0.607,null,11,0.57,null,11,0.78]
[null,12,0.571,null,12,0.54,null,12,0.76]
[null,13,0.548,null,13,0.5,null,13,0.74]
[null,14,0.524,null,14,0.47,null,14,0.72]
[null,15,0.5,null,15,0.43,null,15,0.7]
[null,16,0.476,null,16,0.4,null,16,0.68]
[null,17,0.452,null,17,0.36,null,17,0.66]
[null,18,0.429,null,18,0.33,null,18,0.64]
[null,19,0.405,null,19,0.3,null,19,0.62]
[null,20,0.381,null,"20 +",0.27,null,20,0.6]
[null,21,0.357,{"$nulls":4},21,0.58]
[null,22,0.333,{"$nulls":4},22,0.56]
[null,23,0.31,{"$nulls":4},23,0.54]
[null,24,0.286,{"$nulls":4},24,0.52]
[null,25,0.268,{"$nulls":4},25,0.5]
[null,26,0.25,{"$nulls":4},26,0.48]
[null,27,0.232,{"$nulls":4},27,0.46]
[null,28,0.214,{"$nulls":4},28,0.44]
[null,29,0.196,{"$nulls":4},29,0.42]
[null,30,0.179,{"$nulls":4},30,0.4]
[null,31,0.161,{"$nulls":4},31,0.38]
[null,"32 +",0.143,{"$nulls":4},32,0.36]
[{"$nulls":7},33,0.34]
[{"$nulls":7},34,0.32]
[null,"NOTES:",{"$nulls":5},35,0.3]
[null,"1. Age is the number of years from the date of original manufacture to the date the remanufacture is completed (rounded to the next higher year).  Note that for replacement or repower engines, the proration factor should be determined based on the age of the locomotive chassis, not the age of the engine.",{"$nulls":5},36,0.28]
[{"$nulls":7},37,0.26]
[{"$nulls":7},38,0.24]
[null,"2. The proration factor is 1.00 for all locomotives that meet the definition of freshly manufactured.",{"$nulls":5},39,0.22]
[null,"3. The minimum proration factor for remanufactured locomotives that meet the definition of refurbished but not freshly manufactured is 0.60.",{"$nulls":5},"40 +",0.2]
[]
[null,"4. For Part 1033 line haul locomotives more than 20 years old, use the proration factor for 20 year old locomotives.  For Part 1033 switch locomotives more than 40 years old, use the proration factor for 40 year old locomotives.  For Part 92 locomotives more than 32 years old, use the proration factor for 32 year old locomotives."]
[]
[]
[]
[]
[]
[{"$nulls":4},"Paperwork Reduction Act Notice"]
[{"$nulls":4},"The public reporting and recordkeeping burden for this collection of information is estimated to average 30 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":"Credit Summary","index":6,"n_rows":92,"n_cols":170,"rows_kept":92,"cut":false,"hidden":false,"merged":[[27,1,31,1],[14,1,14,2],[16,1,16,12],[1,1,1,21],[2,1,2,21],[3,1,3,21],[5,1,5,21],[14,19,14,21],[13,14,13,21],[6,1,6,21],[12,33,15,33],[12,34,15,34],[12,30,15,30],[12,31,15,31],[12,32,15,32],[11,25,11,32],[12,25,15,25],[12,26,15,26],[12,27,15,27],[12,28,15,28],[12,29,15,29],[11,24,15,24],[10,2,10,4],[11,2,11,4],[13,22,15,22],[14,5,14,6],[14,3,14,4],[13,1,13,2],[14,15,14,18],[14,7,14,8],[82,21,82,22],[83,21,83,22],[84,21,84,22],[14,14,15,14],[78,21,78,22],[79,21,79,22],[80,21,80,22],[81,21,81,22],[83,18,90,18],[79,18,82,18],[89,21,89,22],[90,21,90,22],[13,3,13,8],[13,9,13,12],[14,9,14,10],[14,11,14,12],[85,21,85,22],[86,21,86,22],[87,21,87,22],[88,21,88,22],[78,18,78,20],[37,1,37,12],[53,1,57,1],[38,1,42,1],[43,1,47,1],[48,1,52,1],[63,14,68,20],[62,14,62,20],[14,126,14,128],[14,129,14,131],[14,106,14,110],[32,1,36,1],[17,1,21,1],[22,1,26,1],[14,46,14,50],[14,41,14,45],[14,71,14,73],[14,52,14,56],[12,158,12,169],[13,158,13,163],[11,106,11,137],[12,106,12,125],[13,106,13,115],[13,116,13,125],[12,126,12,137],[13,126,13,131],[14,121,14,125],[11,138,11,169],[13,148,13,157],[14,138,14,142],[14,143,14,147],[14,148,14,152],[14,153,14,157],[12,138,12,157],[13,138,13,147],[13,164,13,169],[14,158,14,160],[14,161,14,163],[14,164,14,166],[14,167,14,169],[13,132,13,137],[14,132,14,134],[14,135,14,137],[14,111,14,115],[14,116,14,120],[14,97,14,99],[14,100,14,102],[14,94,14,96],[14,103,14,105],[14,62,14,64],[14,65,14,67],[13,68,13,73],[13,51,13,61],[14,89,14,93],[14,74,14,78],[14,79,14,83],[14,84,14,88],[14,57,14,61],[11,74,11,105],[12,94,12,105],[13,94,13,99],[13,100,13,105],[13,84,13,93],[13,74,13,83],[12,74,12,93],[11,40,11,73],[12,62,12,73],[11,35,11,38],[12,35,15,35],[12,36,15,36],[15,1,15,2],[12,40,12,61],[14,68,14,70],[13,40,13,50],[13,62,13,67]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency"]
[null,"Office of Air and Radiation, Office of Transportation and Air Quality"]
[]
[null,"Manufacturer Averaging, Banking, and Trading Report for Locomotives"]
[null,"Last Revision: August 2012  Version Number: 2.2"]
[]
[null,"Credit Summary for the Part 92 and 1033 Locomotive ABT Programs"]
[]
[null,"MODEL YEAR:",""]
[null,"Manufacturer:","",{"$nulls":21},"Errors?","ERRORS",{"$nulls":9},"Single/ Dual cycle",null,null,null,"CREDIT TYPE","Current MY",{"$nulls":33},"Banked",{"$nulls":31},"Traded",{"$nulls":31},"Transferred"]
[{"$nulls":25},"PM applied to HC+Nox","Part 92 used for wrong cycle","Line-haul used by Tier 3/4 switch","Pollutant Nox-PM","Pollutant PM-Nox","1033 Credits used for 92","Line haul ","Switch Tier 1,2","Error Msg 1","Error Msg 2","Dual Cycle From","Dual Credits used for Single",null,null,"40 CFR PART","Part 1033",{"$nulls":21},"Part 92",{"$nulls":11},"Part 1033",{"$nulls":19},"Part 92",{"$nulls":11},"Part 1033",{"$nulls":19},"Part 92",{"$nulls":11},"Part 1033",{"$nulls":19},"Part 92"]
[null,null,null,"Part 1033",{"$nulls":5},"Part 92",{"$nulls":4},"Credit Usage and Averaging ",{"$nulls":7},"Messages",{"$nulls":16},"CYCLE","Switch",{"$nulls":10},"Line-Haul",{"$nulls":10},"Switch",{"$nulls":5},"Line-Haul",{"$nulls":5},"Switch",{"$nulls":9},"Line-Haul",{"$nulls":9},"Switch",{"$nulls":5},"Line-Haul",{"$nulls":5},"Switch",{"$nulls":9},"Line-Haul",{"$nulls":9},"Switch",{"$nulls":5},"Line-Haul",{"$nulls":5},"Switch",{"$nulls":9},"Line-Haul",{"$nulls":9},"Switch",{"$nulls":5},"Line-Haul"]
[null,null,null,"NOx",null,"NOx+HC",null,"PM",null,"NOx",null,"PM",null,null,"# Credits","FROM:",null,null,null,"TO (Current MY Balance):",{"$nulls":19},"POLLUTANT","HC+NOx","PM",{"$nulls":4},"NOx",{"$nulls":4},"HC+NOx","PM",{"$nulls":4},"NOx",{"$nulls":4},"PM",null,null,"NOx",null,null,"PM",null,null,"NOx",null,null,"PM",{"$nulls":4},"NOx",{"$nulls":4},"PM",{"$nulls":4},"NOx",{"$nulls":4},"PM",null,null,"NOx",null,null,"PM",null,null,"NOx",null,null,"PM",{"$nulls":4},"NOx",{"$nulls":4},"PM",{"$nulls":4},"NOx",{"$nulls":4},"PM",null,null,"NOx",null,null,"PM",null,null,"NOx",null,null,"PM",{"$nulls":4},"NOx",{"$nulls":4},"PM",{"$nulls":4},"NOx",{"$nulls":4},"PM",null,null,"NOx",null,null,"PM",null,null,"NOx"]
[null,null,null,"Line-Haul","Switch","Line-Haul","Switch","Line-Haul","Switch","Line-Haul","Switch","Line-Haul","Switch",null,null,"CFR Part","Averaging Set","Credit Type","Tier","CFR Part","Averaging Set","Tier",{"$nulls":17},"TIER",4,0,1,2,3,4,0,1,2,3,4,4,0,1,2,3,4,0,1,2,3,4,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,3,4,0,1,2,3,4,0,1,2,3,4,0,1,2,3,4,0,1,2,0,1,2,0,1,null,0,1,2,0,1,2,3,4,0,1,2,3,4,0,1,2,3,4,0,1,2,3,4,0,1,2,0,1,2,0,1,2,0,1,2,0,1,2,3,4,0,1,2,3,4,0,1,2,3,4,0,1,2,3,4,0,1,2,0,1,2,0,1,2,0,1,2]
[null,"Credit Balances before Averaging:",{"$nulls":20},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Current MY","Tier 0 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 1 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 2",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 3",0,0,null,null,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 4",0,0,0,0,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Banked","Tier 0 ",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 1 ",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 2",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 3",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 4",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Traded","Tier 0 ",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 1 ",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 2",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 3",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 4",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Transferred","Tier 0 ",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 1 ",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 2",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 3",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 4",{"$nulls":19},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Credit Balances after Averaging:",{"$nulls":20},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Current MY","Tier 0 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 1 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 2",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 3",0,0,null,null,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 4",0,0,0,0,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Banked","Tier 0 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 1 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 2",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 3",0,0,null,null,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 4",0,0,null,null,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Traded","Tier 0 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 1 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 2",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 3",0,0,null,null,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 4",0,0,null,null,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Transferred","Tier 0 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 1 ",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 2",0,0,null,null,0,0,0,0,0,0,{"$nulls":9},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 3",0,0,null,null,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tier 4",0,0,null,null,0,0,{"$nulls":13},"",null,0,0,0,0,0,0,0,0,0,"","",1,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"NOTES"]
[null,""]
[null,""]
[{"$nulls":14},"Paperwork Reduction Act Notice"]
[{"$nulls":14},"The public reporting and recordkeeping burden for this collection of information is estimated to average 30 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."]
[]
[]
[]
[]
[]
[]
[{"$nulls":15},"Part 1033","Line-Haul-NOx","Banked","Tier 0",null,"Line-Haul-NOx","Tier 0",{"$nulls":17},"IF: Ave Set and Tier are the same in the FROM and TO columns AND the 'Credit Type' in FROM is 'Current MY'"]
[{"$nulls":15},"Part 92","Switch-NOx","Traded","Tier 1",null,"Switch-NOx","Tier 1",{"$nulls":17},"IF: the # Credits entered exceed the credit balance for the corresponding averaging set."]
[{"$nulls":16},"Line-Haul-PM","Current MY","Tier 2",null,"Line-Haul-PM","Tier 2",{"$nulls":17},"IF: Line-Haul NOx or Switch-NOx in the 'Averaging Set' FROM column, AND either Line-Haul-PM or Switch-PM is selected in the 'Averaging Set' TO column (OR… vice versa)"]
[{"$nulls":16},"Switch-PM","Transferred","Tier 3",null,"Switch-PM","Tier 3",{"$nulls":17},"IF: 'Averaging Set' FROM is Line-Haul-Nox or Line-Haul-PM, AND 'Averaging Set' TO is Switch-Nox or Switch-PM, AND Tier in \"TO\" column = Tier 3 OR Tier 4"]
[{"$nulls":18},"Tier 4",null,"Line-Haul-HC+NOx","Tier 4"]
[{"$nulls":20},"Switch-HC+NOx"]
[]
[]
[{"$nulls":18},"Avg. Set",null,null,"Can be applied to:"]
[{"$nulls":18},"Single",null,"Line-Haul Tier 4","Part 1033 Line-Haul"]
[{"$nulls":20},"Switch Tier 0","Part 1033 Switch/ Line-Haul"]
[null,"All credit balances after averaging should not be negative.",{"$nulls":18},"Switch Tier 3","Part 1033 Switch/ Line-Haul"]
[null,"Using dual cycle credits for single cycle locomotives requires that the single cycle locomotive generate an equal number of negative credits for the other cycle (40 CFR 1033.740(c)) ",{"$nulls":18},"Switch Tier 4","Part 1033 Switch/ Line-Haul"]
[null,"Error: Credits generated by any line-haul locomotive may not be used by Tier 3 or later switch locomotives (1033.740(c))",{"$nulls":16},"Dual",null,"Line-Haul Tier 0","Part 1033 Line-Haul: Corr. Tier 0 Switch can be used for 1033 Switch"]
[null,"Error: Part 92 Credits can be used only for compliance within the same cycle.(40 CFR 92.304(i))",{"$nulls":18},"Line-Haul Tier 1","Part 1033 Line-Haul"]
[null,"Error: PM credits cannot be applied to a HC+NOx credit balance(40 CFR 1033.101(j))",{"$nulls":18},"Line-Haul Tier 2","Part 1033 Line-Haul"]
[null,"Error: Part 1033 Credits cannot be used for Part 92 compliance.",{"$nulls":18},"Line-Haul Tier 3","Part 1033 Line-Haul: Corr. Tier 2 Switch can be used for Part 1033 Switch"]
[null,"Error: NOx credits cannot be applied to a PM credit balance.",{"$nulls":18},"Switch Tier 1","Part 1033 Switch "]
[null,"Error: PM credits cannot be applied to a NOx credit balance.",{"$nulls":18},"Switch Tier 2","Part 1033 Switch"]
[null,"Error: Line-haul credits may only be used to show compliance with line-haul standards.  ",{"$nulls":18},"92 Line-Haul","92 Line-Haul or 1033 Line-Haul"]
[null,"Error: Tier 1 and Tier 2 switch locomotives may only be used to show compliance with switch cycle standards. (40 CFR 1033.740(c)(2)) ",{"$nulls":18},"92 Switch","92 Switch or 1033 Switch"]
[{"$nulls":18},"*If using Dual credits for Single, then single credits must be generated for both pollutants"]