{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Current MY Credit Calc","Field Descriptions","Summary","Phase-In"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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":"Current MY Credit Calc","index":0,"n_rows":77,"n_cols":35,"rows_kept":77,"cut":false,"hidden":false,"merged":[[41,0,42,0],[41,1,41,2],[41,3,41,4],[41,5,41,8]],"flags":["formulas_cached_only"]}
["Snowmobile ABT template - DRAFT"]
[]
[]
[]
[]
[null,null,null,"Phase 1","If Unique design, Production should be at or below 600 and FELs for HC and CO should be at or below 270 g/kW-hr and 560 g/kW-hr, respectively (Section 1051.630)"]
[null,null,null,"Phase 2 ERC","Y"]
[{"$nulls":4},"N","UL (kW-hr) = UL(km) x maximum test power (kW) / 30 km/hr",{"$nulls":19},1,2]
[{"$nulls":25},"HC","CO",null,"HC","CO"]
["Engine Family Name or Test Group","Model Name","Test Engine Power","Phase","Unique Design? (Y/N)","Useful Life (kW-hr)","U.S. Production  ","HC FEL (g/kW-hr)","CO FEL (g/kW-hr)","Messages",{"$nulls":15},"UD and Prod Volume Violation","UD and Prod Volume Violation",null,"Prod * UL * FEL (numer -HC)","Prod * UL * FEL (numer -CO)","Prod * UL (denom)","Phase 1","Phase 2",null,"Default Value"]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0,null,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[{"$nulls":9},"",{"$nulls":15},0,0,null,0,0,0,0,0]
[]
["Data Element","Phase 1",null,"Early Reduction Credits: Phase 2"]
[null,"HC (g/kW-hr)","CO (g/kW-hr)","HC (g/kW-hr)","CO (g/kW-hr)"]
["Standard",100,275,75,275]
["Emission Level ",0,0,0,0]
["Credit Balance",0,0,0,0]
{"$rows_empty":19}
[null,"Raw Calculations"]
[null,"Phase 1 HC","Phase 1 CO","Phase 2 HC","Phase 2 CO"]
["Emission Level"]
[null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Credits"]
[null,0,0,0,0]
[]
[]
[]
[]
[null,"Violation Messages"]
[null,1," *  WARNING:  If Unique design, Production should be at or below 600 and FELs for HC and CO should be at or below 270 g/kW-hr and 560 g/kW-hr, respectively."]

{"sheet":"Field Descriptions","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Field ","Description","OMB Control No: 2060-0338"]
["Engine Family Name or Test Group","Enter the 12-character engine family name or test group name.  ","Expiration Date: XX-XX-XXXX"]
["Model Name","Enter the applicable model name (optional)."]
["Test Engine Power","Enter the test engine power rating for the engine family name.  Note that this value does not affect credit calculations."]
["Phase","Select the phase that applies.  If the engine family is subject to the current standards, select Phase 1.  If Phase 1 credits will be accrued in the current model year, you may elect to designate certain engine families as Phase 2 Early Reduction Credits (ERCs).  Phase 1 and 2 CO credits are maintained as separate balances in the Current MY worksheet but are combined in the Summary sheet since the standards are consistent."]
["Unique Design? (Y/N)","If the snowmobiles in the associated engine family are considered \"unique design\", select \"Y\" from the dropdown list.  Otherwise, select \"N\" (see Section 1051.630).  "]
["Useful Life (kW-hr)","Enter the useful life (UL) of the engine family (or subset) in terms of kW-hr.  If UL is in kilometers, you may convert to kW-hr using the following equation:  UL (kW-hr) = UL (km) x maximum test power (kW) / 30 km/hr.  Note that the rule specifies minimum useful life as 8,000 km."]
["U.S. Production  ","Enter number of engines/vehicles manufactured for U.S. production."]
["HC FEL (g/kW-hr)","Enter the established HC family emission limit (FEL) for the engine family (or subset) in terms of g/kW-hr.  "]
["CO FEL (g/kW-hr)","Enter the established CO family emission limit (FEL) for the engine family (or subset) in terms of g/kW-hr.  "]
[]
["EPA Form No.: 5900-132"]

{"sheet":"Summary","index":2,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,1,18,5],[1,1,2,2],[13,1,13,2],[16,1,16,5],[1,3,1,4]],"flags":["formulas_cached_only"]}
[]
[null,"Credits",null,"HC (g/kW-hr)",null,"CO (g/kW-hr)"]
[null,null,null,"Phase 1","Phase 2 (ERCs)","Phase 1 and Phase 2 (ERCs)"]
[null,"Current Credit Balances "]
[null,null,"Current MY Credits 1",0,0,0]
[null,null,"Credits acquired via trading "]
[null,null,"Credits banked from prior model years"]
[null,"Application of Traded or Banked Credits to Current MY Balance"]
[null,null,"Apply credits acquired via trading"]
[null,null,"Apply banked credits"]
[null,"Credit Balances after Application of Traded or Banked Credits"]
[null,null,"Credits acquired via trading",0,null,0]
[null,null,"Banked Credits",0,null,0]
[null,"Total Credit Balance 2",null,0,0,0]
[null,null,"Total Banked Credits",0,0,0]
[]
[null,"1 Includes credits/deficits associated with the standards in Table 1 of Section 1051.103.  Note that since the same standard applies to CO Phase 1 and Phase 2, the credit totals from the 'Current MY Credit Calc' worksheet are combined in the CO column of this worksheet."]
[]
[null,"2 This balance should be at or above zero.  The 'Total Banked Credits' reflects the sum of the preceding two rows: the 'Banked Credits' (adjusted based on the number of credits applied to the current MY credits balance) and the 'Total Credit Balance.'"]

{"sheet":"Phase-In","index":3,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[35,0,35,1],[36,0,36,1],[37,0,37,1],[43,0,43,2]],"flags":["formulas_cached_only"]}
[null,"Y"]
[null,"N"]
[]
["Engine Family Name or Test Group","Participating in ABT? (Y/N)","U.S. Production  ",{"$nulls":9},"Y","N"]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
["Total Production in ABT",null,0]
["Total Production not in ABT",null,0]
["Total Production ",null,0]
[]
[]
[null,"Phase-In %",{"$error":"#DIV/0!"}]
[]
[]
["Note:  Providing the data and information necessary to calculate phase-in percentages is optional."]