{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["Current MY Credit Calc-EXHAUST","Max Power Calc","Current MY Credit Calc-EVAP","Field Descriptions","Credit Summary","Allowances-EVAP"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":1,"defined_names":7,"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-EXHAUST","index":0,"n_rows":194,"n_cols":56,"rows_kept":194,"cut":false,"hidden":false,"merged":[[6,0,6,15],[2,54,2,55],[2,0,2,15],[3,0,3,15],[66,1,66,5],[109,1,112,1],[67,4,67,5],[67,2,67,3],[64,1,64,13],[67,1,68,1],[10,26,10,31],[10,55,13,55],[10,54,13,54],[10,40,10,47],[10,32,10,37],[1,0,1,15],[78,2,78,7],[11,2,11,3],[10,20,10,25],[68,14,71,14],[5,0,5,15]],"flags":["formulas_cached_only"]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Manufacturer Averaging, Banking, and Trading Report for Marine Spark Ignition Engines"]
["Last Revision: August 2010    Version Number: 2.1"]
[]
["Exhaust Emission Credits",{"$nulls":13},"Submission Date:                           "]
[]
[null,"MODEL YEAR:",{"$nulls":18},"HCNOX",{"$nulls":5},"CO",{"$nulls":5},"fel cap checks",{"$nulls":7},"Standards",{"$nulls":13},"Engine Family Info Match","warning message"]
[null,"MANUFACTURER:",null,null,"Small Volume?:"]
[]
[null,"Engine Family Name","Pollutant","Maximum Power (kW)*","Engine Type","Production Volume","FEL (g/kW-hr)","Jet Boat Engine Using Credits from Identical OB/PWC Engine?","Name of Associated OB/PWC Engine Family","Useful Life (hours)","Load Factor","Early Credit Multiplier","Standard (g/kW-hr)","Credit Balance (kg)","Messages",null,null,null,"Early?","entered all values?","OB/PWC positive","OB/PWC negative","SD/I early","SD/I  std positive","SD/I  std negative","SD/I jet","OB/PWC positive","OB/PWC negative","SD/I early","SD/I  std positive","SD/I  std negative","SD/I jet",1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,"blank?","1 to 4","5 to 8",null,"high-performance SD/I?","Early  OB/PWC?"]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[{"$nulls":11},"","","","",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,null,0,0,0,""]
[null,"*Maximum power can be calculated using the Max Power Calc worksheet."]
[{"$nulls":22},3,3]
[null,"SUMMARY OF CURRENT MODEL YEAR EXHAUST CREDITS (kg)",{"$nulls":17},4,4]
[null,null,"HC+NOx ",null,"CO ",{"$nulls":9},"Paperwork Reduction Act Notice",{"$nulls":4},5,5]
[null,null,"OB/PWC","SD/I","OB/PWC","SD/I",{"$nulls":8},"The public reporting and recordkeeping burden for this collection of information is estimated to average 17 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 5900-92 to this address.",{"$nulls":4},6,6]
[null,"EARLY CREDITS:",null,0,null,0,{"$nulls":13},7,7]
[null,"STANDARD CREDITS:",0,0,0,0,{"$nulls":13},8,8]
[null,"JETBOAT CREDITS:",null,0,null,0,{"$nulls":13},9,9]
[]
[]
[]
[]
[]
[]
[null,"Calculating Credits: ","Credits = (STD - FEL) x (Volume) x (Power) x (Useful Life) x (Load Factor) x 10-3",{"$nulls":19},"B",11]
[null,"Small Vol. Multipliers (If Engine Type = \"SD/I - Sm Volume\"):",{"$nulls":20},"D",13]
[null,"2.0 for 2008",{"$nulls":20},"E",14]
[null,"1.5 for 2009",{"$nulls":20},"F",15]
[null,"1.25 for 2010",{"$nulls":20},"G",16]
[null,"Calculating Applicable Standard: ","IF: Engine Type = \"Outboard/Personal Watercraft\" AND Parameter = \"HC+NOx\" AND Max Power (kW) = 4.3 kW or below, THEN Standard in g/kW-hr = 30 g/kW-hr",{"$nulls":19},"H",17]
[null,"STARTING 2010","IF: Engine Type = \"Outboard/Personal Watercraft\" AND Parameter = \"HC+NOx\" AND Max Power (kW) = above 4.3 kW, THEN Standard in g/kW-hr = 2.1 + (0.09 X (151 + 557/P 0.9))",{"$nulls":19},"J",18]
[null,"P = Max Power","IF: Engine Type = \"Outboard/Personal Watercraft\" AND Parameter = \"CO\" AND Max Power (kW) = 40 kW or below, THEN Standard in g/kW-hr = (500 - 5.0 X P)",{"$nulls":19},"K",19]
[null,null,"IF: Engine Type = \"Outboard/Personal Watercraft\" AND Parameter = \"CO\" AND Max Power (kW) = above 40 kW, THEN Standard in g/kW-hr = 300 ",{"$nulls":19},"L",20]
[{"$nulls":22},"M",21]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\" or \"Sterndrive/Inboard-Jet Boat\" AND Parameter = \"CO\", THEN Standard in g/kW-hr = 75.0",{"$nulls":19},"N",22]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\" or \"Sterndrive/Inboard-Jet Boat\" AND Parameter = \"HC+NOx\", THEN Standard in g/kW-hr = 5.0",{"$nulls":19},"P",23]
[]
[null,"STARTING 2011 (Sm Volume)","IF: Engine Type = \"Sterndrive/Inboard - Sm. Volume\" or \"Sterndrive/Inboard-Jet Boat-Sm. Volume\" AND Parameter = \"CO\", THEN Standard in g/kW-hr = 75.0"]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard - Sm. Volume\" or \"Sterndrive/Inboard-Jet Boat-Sm. Volume\" AND Parameter = \"HC+NOx\", THEN Standard in g/kW-hr = 5.0"]
[]
[]
[null,"IF EARLY CREDITS: ","IF: Engine Type = \"Sterndrive/Inboard\" AND Parameter = \"CO\", THEN Standard in g/kW-hr = 150.0",{"$nulls":6},"FEL Caps are the "]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\" AND Parameter = \"HC+NOx\", THEN Standard in g/kW-hr = 16.0",{"$nulls":6},"same as STD for "]
[{"$nulls":9},"Early Credits. This"]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard - Sm. Volume\" AND Parameter = \"CO\", THEN Standard in g/kW-hr = 150.0",{"$nulls":6},"just precludes"]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard - Sm. Volume\" AND Parameter = \"HC+NOx\", THEN Standard in g/kW-hr = 16.0",{"$nulls":6},"any deficit."]
[]
[]
[null,"FEL CAPS","IF: Engine Type = \"Outboard/Personal Watercraft\" AND Parameter = \"HC+NOx\" AND Max Power (kW) = 4.3 kW or below, THEN FEL CAP in g/kW-hr = 81.0 g/kW-hr"]
[null,null,"IF: Engine Type = \"Outboard/Personal Watercraft\" AND Parameter = \"HC+NOx\" AND Max Power (kW) = above 4.3 kW, THEN FEL CAP in g/kW-hr = 6.0 + 0.25 X (151 + 557/P 0.9))"]
[null,null,"IF: Engine Type = \"Outboard/Personal Watercraft\" AND Parameter = \"CO\" AND Max Power (kW) = 40 kW or below, THEN FEL CAP in g/kW-hr = (650 - 5.0 X P)"]
[null,null,"IF: Engine Type = \"Outboard/Personal Watercraft\" AND Parameter = \"CO\" AND Max Power (kW) = above 40 kW, THEN FEL CAP in g/kW-hr = 450 "]
[]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\" or \"Sterndrive/Inboard-Small Volume\" AND Parameter = \"CO\", THEN FEL CAP in g/kW-hr = 150",{"$nulls":10},7]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\" or \"Sterndrive/Inboard-Small Volume\" AND Parameter = \"HC+NOx\", THEN FEL CAP in g/kW-hr = 16",{"$nulls":10},8]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\" AND Jet Boat Engine? = \"Y\" AND Parameter = \"HC+NOx\" AND Max Power (kW) = 4.3 kW or below, THEN FEL CAP in g/kW-hr = 30 g/kW-hr",{"$nulls":19},"R",24]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\" AND Jet Boat Engine? = \"Y\"  AND Parameter = \"HC+NOx\" AND Max Power (kW) = above 4.3 kW, THEN FEL CAP in g/kW-hr = 2.1 + (0.09 X (151 + 557/P 0.9))"]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\"  AND Jet Boat Engine? = \"Y\" AND Parameter = \"CO\" AND Max Power (kW) = 40 kW or below, THEN FEL CAP in g/kW-hr = (500 - 5.0 X P)"]
[null,null,"IF: Engine Type = \"Sterndrive/Inboard\"  AND Jet Boat Engine? = \"Y\" AND Parameter = \"CO\" AND Max Power (kW) = above 40 kW, THEN FEL CAP in g/kW-hr = 300 ",{"$nulls":19},"S",25]
[{"$nulls":22},"T",26]
[{"$nulls":22},"V",27]
[]
[{"$nulls":4},"Outboard/Personal Watercraft"]
[null,null,"HC+NOx",null,"Sterndrive/Inboard",null,null,"Yes",350]
[null,null,"CO",{"$nulls":4},"No",480]
[]
[]
[null,"ERROR MESSAGES"]
[null,"Error Message: For early credits, the FEL may not exceed the applicable standard. (See 40 CFR 1045.145(b)(3) and (4))"]
[null,"Error Message:  OB/PWC engine families cannot accrue credits associated with jet boat engines."]
[null,"Error Message:  FEL Cap has been exceeded."]
[null,"Warning: The FEL you have entered is allowed only for 4-stroke SD/I engines without test data. (See 40 CFR 1045.145(c))"]
[null,"Warning: The FEL you have entered is allowed only for stand-up PWCs. (See 40 CFR 1045.145(f)) "]
[null,"Error: Engine family information in this row is inconsistent with previous record (Maximum Power, Engine Type, or Production Vol.)"]
[null,"Error Message:  First digit in engine family name does not match model year."]
[null,"Error Message: High Performance SD/I engines cannot participate in the ABT program. (See 40 CFR 1045.105(b))"]
[null,"Error Message: OB/PWC engine families cannot accrue credits prior to the 2010 model year."]
[]
[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]
{"$rows_empty":11}
[{"$nulls":6},"2011-01-31"]

{"sheet":"Max Power Calc","index":1,"n_rows":80,"n_cols":7,"rows_kept":80,"cut":false,"hidden":false,"merged":[[4,0,4,7],[5,0,5,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[6,0,6,7],[7,0,7,7],[10,1,11,6],[79,2,82,6],[78,2,78,6],[8,0,8,7]],"flags":["formulas_cached_only"]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Manufacturer Averaging, Banking, and Trading Report for Marine Spark Ignition Engines"]
["Last Revision: August 2010    Version Number: 2.1"]
[]
["Calculation of Production-Weighted Maximum Power "]
[]
[null,"The Average Power value corresponding to the final configuration for a particular engine family is the maximum power value used in the exhaust emission credit calculation (Current MY Credit Calc-EXHAUST worksheet)"]
[]
[]
[null,"Engine Family Name","Configuration ","Maximum Power Rating (kW)","Production Volume","Cum. Production Volume","Average Power (kW)"]
[{"$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,"Paperwork Reduction Act Notice"]
[null,null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 17 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 5900-92 to this address."]

{"sheet":"Current MY Credit Calc-EVAP","index":2,"n_rows":149,"n_cols":27,"rows_kept":149,"cut":false,"hidden":false,"merged":[[1,0,1,13],[72,11,74,11],[70,1,70,2],[11,2,11,4],[5,0,5,13],[3,0,3,13],[2,0,2,13],[6,0,6,13]],"flags":["formulas_cached_only"]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Manufacturer Averaging, Banking, and Trading Report for Marine Spark Ignition Engines"]
["Last Revision: August 2010    Version Number: 2.1"]
[]
["Evaporative Emission Credits",{"$nulls":10},"Submission Date:                                         "]
[]
[null,"MODEL YEAR:",""]
[null,"MANUFACTURER:",""]
[]
[null,"Emission Family Name of Vessel","Permeation Family Name for Fuel Tank","Tank Category*","Production Volume","Total Area (m2)","FEL (g/m2/day)**","Test Temperature","Adjustment Factor","Standard (g/m2/day)","Credit Balance (kg)","Message(s)",{"$nulls":5},"all fields",1,2,3,4,5,"PWC","other","positive","negative"]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"","","","",{"$nulls":5},0,0,0,0,0,0,0,0,0,0]
[null,"* Evaporative emission credits may not be earned for portable fuel tanks."]
[null,"** If Standard and FEL are based on testing at 28°C, an FEL below 5.0g/m2/day must be based on emissions measurements.  If FEL is at or above 5.0g/m2/day, then the FEL must either be based on emission measurements for all such families, or the FEL must be an assigned value of 10.4g/m2/day for all such families."]
[null,"** If Standard and FEL are based on testing at 40°C, an FEL below 8.3g/m2/day must be based on emissions measurements.  If FEL is at or above 8.3g/m2/day, then the FEL must either be based on emission measurements for all such families, or the FEL must be an assigned value of 17.3g/m2/day for all such families."]
[]
[null,"CREDIT TOTALS- EVAPORATIVE EMISSIONS"]
[null,"TANK CATEGORY","CREDIT TOTALS (kg)",{"$nulls":8},"Paperwork Reduction Act Notice"]
[null,"Personal Watercraft Fuel Tanks",0,{"$nulls":8},"The public reporting and recordkeeping burden for this collection of information is estimated to average 17 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 5900-92 to this address."]
[null,"Other Installed Fuel Tanks",0]
[null,"All Marine Vessel Fuel Tanks",0]
[]
[]
[]
[]
[]
[null,"Error Message:  First digit in engine family name does not match model year"]
[null,"Error Message:  FEL Cap has been exceeded."]
[null,"Error: You cannot earn ABT credits for the Current MY.  See Allowances-EVAP worksheet for early allowances. (40 CFR 1045.145(d)) "]
[]
[]
[{"$nulls":6},"If 28° C, then:",1,1.5]
[null,null,"Personal Watercraft Fuel Tank",null,null,null,"If 40° C, then:",0.6,2.5,null,null,"If MY = 2014 or after, AND 'Equipment Type' = 'Personal Watercraft Fuel Tanks', AND 'Test Temperature' = 28, AND FEL > 5.0"]
[null,null,"Other Installed Fuel Tank",null,null,null,28,null,null,"Credits = (STD - FEL) x (Total Area) x (5) x (Adjustment Factor) x (365) x 10-3",null,"If MY = 2015 or after, AND 'Equipment Type' = 'Other Fuel Tanks', AND 'Test Temperature' = 28, AND FEL > 5.0"]
[{"$nulls":6},40,{"$nulls":4},"If MY = 2014 or after, AND 'Equipment Type' = 'Personal Watercraft Fuel Tanks', AND 'Test Temperature' = 40, AND FEL > 8.3"]
[{"$nulls":11},"If MY = 2015 or after, AND 'Equipment Type' = 'Other Fuel Tanks', AND 'Test Temperature' = 40, AND FEL > 8.3"]
[]
[null,"Display message for 'FEL Cap has been exceeded' for the following circumstances only:"]
[null,"If MY = 2014 or after, AND 'Equipment Type' = 'Personal Watercraft Fuel Tanks', AND 'Test Temperature' = 28, AND FEL > 5.0"]
[null,"If MY = 2015 or after, AND 'Equipment Type' = 'Other Fuel Tanks', AND 'Test Temperature' = 28, AND FEL > 5.0"]
[null,"If MY = 2014 or after, AND 'Equipment Type' = 'Personal Watercraft Fuel Tanks', AND 'Test Temperature' = 40, AND FEL > 8.3"]
[null,"If MY = 2015 or after, AND 'Equipment Type' = 'Other Fuel Tanks', AND 'Test Temperature' = 40, AND FEL > 8.3"]
[null,null,null,false,null,1]
[null,"","",false,null,1]
[null,null,"",false,null,1]
[null,null,"",false,null,1]
[null,null,"",false,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]
[null,null,"",null,null,1]
[null,null,"",null,null,1]
[null,null,"",null,null,1]
[null,null,""]

{"sheet":"Field Descriptions","index":3,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,2,31,3],[32,2,32,3],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[10,1,11,1],[10,2,10,3],[6,0,6,4]],"flags":["formulas_cached_only"]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Manufacturer Averaging, Banking, and Trading Report for Marine Spark Ignition Engines"]
["Last Revision: August 2010    Version Number: 2.1"]
[]
["Field Descriptions (Exhaust and Evaporative Current MY Credit Calculations)"]
[]
[null,"FIELD","DESCRIPTION"]
[null,null,"EXHAUST","EVAP"]
[null,"Engine Family Name/ Emission Family Name of Vessel","Enter the 12-character emission family name for the engine.","Enter the 12-character emission family name for the vessel."]
[null,"Pollutant","Select the applicable pollutant (HC+NOx or CO) from the drop-down menu.  The engine family name will have separate line items for each pollutant.","NA"]
[null,"Permeation Family Name for Fuel Tank","NA","Enter the permeation family name for the fuel tank for which your evaporative emission ABT credits are being generated or used."]
[null,"Maximum Power (kW)","Enter the maximum modal power in kW for the emission data test engine over the certification test cycle.  The maximum power shall be determined as directed in 40 CFR 1045.140(d) and can be calculated using the Maximum Power Calculation spreadsheet.","NA"]
[null,"Engine Type","Select one of the following two options:  1) Outboard/Personal Watercraft or 2) Sterndrive/Inboard.  Note that for Small Volume manufacturers (i.e., if “Yes” is selected in the Small Volume field above the data entry cells), the resulting credit totals for all SD/I engine families will be displayed below the data entry cells as “SD/I – Small Volume” and the corresponding values in the “Standard” column will reflect the provisions for delayed compliance under 40 CFR 1045.145(a).","NA"]
[null,"Tank Category","NA","Select one of the following two options: 1) Personal Watercraft Fuel Tank; 2) Other Installed Fuel Tank."]
[null,"Production Volume","Enter the production volume of the engine family.","Enter the production volume of the engine family."]
[null,"Total Area (m2)","NA","Enter the combined internal surface area of all fuel tanks in the family, in m2."]
[null,"FEL (g/kW-hr)","Enter the applicable Family Emission Limit for the engine family in g/kW-hr. (OB/PWC- 40 CFR 1045.103; SD/I- 40 CFR 1045.104; SD/I-Jet Boat- 40 CFR 1045.701(d); Special Provisions- 40 CFR 1045.145(b),(c), and (f)).   ","Enter the applicable Family Emission Limit for the emission family in g/m2/day. (40 CFR 1045.112(b))"]
[null,"Jet Boat Engine Using Credits from Identical OB/PWC Engine? (Yes/No)","Select \"Yes\" or \"No\" to indicate whether the jet boat engine family is the same as a certified OB/PWC engine family.  Note that Jet Boat Engines are subject to SD/I engine standards.  A manufacturer may use exhaust ABT credits from OB/PWC engines subject to the provisions in 40 CFR 1045.701(d).","NA"]
[null,"Name of Associated OB/PWC Engine Family ","For engine families with Jet Boat Engine Using Credits from Identical OB/PWC Engine? equal to \"Yes,\" enter the name of the associated OB/PWC engine family.  Note that the Jet Boat engine must be the same model as an OB/PWC engine model, but have sales less than the equivalent OB/PWC family.","NA"]
[null,"Useful Life (hours)","Select the useful life in hours (350 for OB/PWC or 480 for SD/I).  A manufacturer may input a different useful life for exhaust emissions only if it has received approval from EPA for a longer useful life under 40 CFR 1045.103 or 1045.105.  ","The useful life is 5 years for personal watercraft and 10 years for all other vessels and for portable marine fuel tanks (40 CFR 1045.112).  This value is not displayed in the 'Current MY Credit Calc-EVAP' worksheet, but is included in the credit calculation."]
[null,"Load Factor","This should be 0.207 in most cases.  A manufacturer may input a different load factor only if it has received approval from EPA for a Special Test Procedure approved under 40 CFR 1065.10(c)(2).","NA"]
[null,"Test Temperature","NA","Select either 28°C or 40°C to indicate relevant test temperature."]
[null,"Adjustment Factor","NA","This field will be automatically populated based on the Test Temperature selection.  The Adjustment Factor will be 1.0 if the fuel tank testing was performed at 28° C, or 0.60 if the fuel tank testing was performed at 40° C."]
[null,"Early Credit Multiplier","This field will be automatically populated.  A value of 2.0, 1.5, or 1.25 will be entered for SD/I engine families certified by Small Volume Manufacturers in model year 2008, 2009, and 2010, respectively. 40 CFR 1045.145(b)(5)","NA"]
[null,"Standard (g/kW-hr)","This field will be automatically populated with the applicable HC+NOx or CO standard in g/kW-hr based on the entries for Pollutant, Maximum Power, and Engine Type. ","This field will be automatically populated with the applicable evaporative standard in g/m2/day:  1.5 if the fuel tank testing was performed at 28° C, or 2.5 if the fuel tank testing was performed at 40° C."]
[null,"Credit Balance (kg)","This field will reflect the total credit balance (in kilograms) for all engine families by averaging set.","This field will reflect the total credit balance (in kilograms) for all marine vessels."]
[]
[null,null,"Paperwork Reduction Act Notice"]
[null,null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 17 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 (2060-0321) in any correspondence.  Do not send the completed Form 5900-92 to this address."]

{"sheet":"Credit Summary","index":4,"n_rows":53,"n_cols":25,"rows_kept":53,"cut":false,"hidden":false,"merged":[[26,1,27,1],[34,1,35,1],[17,1,19,1],[24,1,24,7],[28,1,29,1],[31,1,33,1],[22,1,23,1],[30,1,30,7],[20,1,21,1],[47,1,48,7],[36,1,37,1],[39,1,39,7],[40,1,40,2],[42,1,42,2],[41,1,41,2],[43,1,43,2],[13,18,13,19],[13,20,13,23],[14,18,15,19],[14,20,14,21],[14,22,14,23],[22,18,23,18],[14,24,15,24],[16,18,16,24],[17,18,19,18],[20,18,21,18],[51,6,51,13],[52,6,55,13],[16,1,16,7],[14,7,15,7],[13,1,15,2],[15,8,15,13],[1,1,1,14],[2,1,2,14],[3,1,3,14],[5,1,5,14],[13,3,13,6],[14,3,14,4],[14,5,14,6],[6,1,6,14]],"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 Marine Spark Ignition Engines"]
[null,"Last Revision: August 2010    Version Number: 2.1"]
[]
["Credit Summary for the Part 1045 Marine SI ABT Programs"]
[]
[null,"MODEL YEAR:",""]
[null,"MANUFACTURER:","",{"$nulls":15},"HIDDEN FIELDS"]
[]
[null,null,null,"EXHAUST",null,null,null,"EVAPORATIVE",{"$nulls":12},"EXHAUST",null,null,null,"EVAPORATIVE"]
[null,null,null,"HC+NOx Credits (kg)",null,"CO Credits (kg)",null,"Permeation Emission Credits (kg)",{"$nulls":12},"HC+NOx Credits (kg)",null,"CO Credits (kg)",null,"Permeation Emission Credits (kg)"]
[null,null,null,"Outboard and Personal Watercraft (OB/PWC)","Sterndrive/Inboard (SD/I)","Outboard and Personal Watercraft (OB/PWC)***","Sterndrive/Inboard (SD/I)",null,"MESSAGES",{"$nulls":11},"Outboard and Personal Watercraft (OB/PWC)","Sterndrive/Inboard (SD/I)","Outboard and Personal Watercraft (OB/PWC)***","Sterndrive/Inboard (SD/I)"]
[null,"Credit Balances before Averaging:",{"$nulls":16},"Credit Balances after Averaging:"]
[null,"Current MY","Early Part 1045 Credits",null,0,null,0,{"$nulls":11},"Current MY","Early Part 1045 Credits",null,0,null,0]
[null,null,"Standard Part 1045 Credits ",0,0,0,0,0,{"$nulls":11},"Standard Part 1045 Credits",0,0,0,0,0]
[null,null,"Jet Boat Engine Credits using OB/PWC Credits",null,0,null,0,{"$nulls":12},"Jet Boat SD/I Credits***",null,0,null,0]
[null,"Banked","Early Part 1045 Credits*",{"$nulls":15},"Banked","Early Part 1045 Credits",null,0,null,0]
[null,null,"Standard Part 1045 Credits",{"$nulls":16},"Standard Part 1045 Credits",0,0,null,0,0]
[null,"Traded","Early Part 1045 Credits ",{"$nulls":15},"Traded","Early Part 1045 Credits ",null,0,null,0]
[null,null,"Standard Part 1045 Credits",{"$nulls":16},"Standard Part 1045 Credits ",0,0,null,0,0]
[null,"Credits Applied to Current MY Balance:"]
[null,"Current MY","Apply OB/PWC Credits to Jet Boat SD/I Engines**",{"$nulls":15},"Error Message: Credit Balances after Averaging should be positive."]
[null,"Banked","Apply Early Part 1045 Credits",{"$nulls":15},"Sterndrive/Inboard (SD/I)"]
[null,null,"Apply Standard Part 1045 Credits",{"$nulls":15},"Sterndrive/Inboard (SD/I) - Small Volume Manufacturer"]
[null,"Traded","Apply Early Part 1045 Credits "]
[null,null,"Apply Standard Part 1045 Credits "]
[null,"Credit Balances after Averaging:"]
[null,"Current MY","Early Part 1045 Credits",null,0,null,0,null,""]
[null,null,"Standard Part 1045 Credits",0,0,0,0,0,""]
[null,null,"Jet Boat SD/I Credits***",null,0,null,0,null,""]
[null,"Banked","Early Part 1045 Credits",null,0,null,0,null,""]
[null,null,"Standard Part 1045 Credits",0,0,null,0,0,""]
[null,"Traded","Early Part 1045 Credits ",null,0,null,0]
[null,null,"Standard Part 1045 Credits ",0,0,null,0,0]
[]
[null,"SUMMARY:"]
[null,"Standard Part 1045 Credits",null,0,0,0,0,0]
[null,"Banked/ Traded Standard Part 1045 Credits",null,0,0,null,0,0]
[null,"Early Part 1045 Credits",null,null,0,null,0]
[null,"Jet Boat SD/I Credits",null,null,0,null,0]
[]
[null,"NOTES:"]
[null,"* Early Part 1045 Banked Credits must be used before the 2013 model year, except for small volume manufacturers who must use them before model year 2014."]
[null,"** Jet boat engines subject to SD/I standards and using credits from OB/PWC engines must: 1) be certified to an FEL that is at or below the Part 1045 standards for OB/PWC engines; 2) be the same model as an OB/PWC engine model, but have sales less than the equivalent OB/PWC family; and 3) only use credits from the manufacturer's same model year OB/PWC engines.  "]
[]
[null,"*** Jet boat engine credits and CO credits for OB/PWC engine families may not be banked or traded.  As such, any credits in these categories that are left unused after averaging, will not carry forward to the following MY."]
[]
[{"$nulls":6},"Paperwork Reduction Act Notice"]
[{"$nulls":6},"The public reporting and recordkeeping burden for this collection of information is estimated to average 17 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 5900-92 to this address."]

{"sheet":"Allowances-EVAP","index":5,"n_rows":135,"n_cols":23,"rows_kept":135,"cut":false,"hidden":false,"merged":[[6,0,6,13],[11,2,11,3],[66,1,66,5],[5,0,5,13],[3,0,3,13],[2,0,2,13],[58,5,58,6],[50,5,50,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[46,5,46,6],[55,5,55,6],[1,0,1,13],[68,6,68,9],[70,6,70,9],[51,5,51,6],[52,5,52,6],[63,5,63,6],[64,5,64,6],[56,5,56,6],[57,5,57,6],[27,5,27,6],[13,17,13,19],[62,5,62,6],[53,5,53,6],[54,5,54,6],[47,5,47,6],[48,5,48,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[24,5,24,6],[13,20,13,22],[49,5,49,6],[42,5,42,6],[28,5,28,6],[29,5,29,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[22,5,22,6],[23,5,23,6],[20,5,20,6],[21,5,21,6],[25,5,25,6],[26,5,26,6],[33,5,33,6],[38,5,38,6],[39,5,39,6],[13,8,13,12],[16,5,16,6],[17,5,17,6],[18,5,18,6],[14,5,14,6],[13,1,13,6],[15,5,15,6],[69,6,69,9],[66,11,66,12],[67,11,70,12],[67,6,67,8],[19,5,19,6],[40,5,40,6],[41,5,41,6],[30,5,30,6],[31,5,31,6],[32,5,32,6]],"flags":["formulas_cached_only"]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Manufacturer Averaging, Banking, and Trading Report for Marine Spark Ignition Engines"]
["Last Revision: August 2010    Version Number: 2.1"]
[]
["Early Evaporative Allowances for Fuel Tanks Used on Marine SI Engines and Vessels (40 CFR 1045.145(d))",{"$nulls":11},"Submission Date:"]
[]
[null,"MODEL YEAR:",""]
[null,"MANUFACTURER:",""]
[]
[null,"ALLOWANCES ACCRUED ",{"$nulls":6},"ALLOWANCES USED",{"$nulls":8},"Credits Accrued",null,null,"Credits Used"]
[null,"Emission Family Name of Vessel","Tank Category","Permeation Family Name for Fuel Tank","Number of Allowances Accrued (Production Vol)","Messages",null,null,"Emission Family Name of Vessel","Tank Category","Permeation Family Name for Fuel Tank","Number of Allowances Used (Production Vol)","Messages",{"$nulls":4},"PWC","Other","Portable","PWC","Other","Portable"]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[{"$nulls":5},"",{"$nulls":6},"",{"$nulls":4},0,0,0,0,0,0]
[]
[null,"ALLOWANCES SUMMARY",{"$nulls":9},"Paperwork Reduction Act Notice"]
[null,"Averaging Set","Allowances Accrued (current Model Year)","Allowances Used (current Model Year)","Allowances Available from Previous Model Yrs","TOTAL","Messages",{"$nulls":4},"The public reporting and recordkeeping burden for this collection of information is estimated to average 17 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 5900-92 to this address."]
[null,"PWC Tank",0,0,null,0,""]
[null,"Other Installed Tank",0,0,null,0,""]
[null,"Portable Tank",0,0,null,0,""]
[]
[]
[]
[]
[null,"Error Message: You have exceeded the number of allowances you are able to use for this Averaging Set."]
[null,"Error Message: You cannot earn Evap Allowances for the current model year."]
[null,"Error Message: You cannot use Evap Allowances for the current model year."]
[null,"Error Message:  Number of allowances accrued must be positive."]
[null,"Error Message: Number of allowances used must be positive."]
[null,"Error Message:  First digit in engine family name does not match model year."]
[null,null,null,"PWC Tank"]
[null,null,null,"Other Installed Tank"]
[null,null,null,"Portable Tank"]
[null,"current my","accrued my","accrued error","used my ","used error"]
[null,"","",1,"",1]
[null,null,"",1,"",1]
[null,false,"",1,"",1]
[null,false,"",1,"",1]
[null,false,"",1,"",1]
[null,false,"",1,"",1]
[null,false,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]
[null,null,"",1,"",1]