{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Federal Standards","Engine 1","Engine 2","Engine 3","Engine 4","Engine 5","Potential Emissions","Actual Emissions","Permits & Requirements","Engine Emission Factors","Data Validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":33,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,4],[30,5,30,14],[19,2,19,14],[22,1,22,14],[14,2,14,14],[15,2,15,14],[16,2,16,14],[17,2,17,14],[23,1,23,14],[24,1,24,14],[25,2,25,3],[25,5,25,8],[25,10,25,14],[26,2,26,3],[26,4,26,14],[28,4,28,13],[18,2,18,14],[5,1,5,14],[13,1,13,14],[0,1,4,5],[6,1,6,14],[8,1,8,14],[9,1,9,14],[10,1,10,14],[7,1,7,14],[0,6,1,14]]}
[null,null,null,null,null,null,"Internal combustion engines\nair emissions calculator   "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p-sbap5-25  •  9/3/19"]
[]
[null,"Instructions"]
[null,"1) Start with the Federal Standards tab to identify if a federal rule applies to your engine."]
[null,"2) Use the blue tabs across the bottom to enter information for your engines. Use only one blue tab per engine."]
[null,"3) The green tabs total potential and actual emissions from the information entered on the blue tabs."]
[null,"4) The yellow 'Permits & Requirements' tab will help you decide which permit to apply for. "]
[null,"5) Later, you can use the blue tabs to calculate your actual emissions for the air emission inventory, which is due annually if you have an air permit. "]
[]
[]
[null,"Color key"]
[null,"Blue","Enter information for your facility in the blue boxes."]
[null,"Orange","Orange boxes are filled with standard values. You may change them if you have test results that provide specific data for your site."]
[null,"White","Do not change the values or formulas in white boxes. White boxes contain intermediate calculations for determining emissions.  "]
[null,"Green","Your emission totals are in green boxes. These are automatically calculated based on information entered in the blue boxes."]
[null,"Yellow","Permit and insignificant activity thresholds"]
[null,"Blue text","Important tips"]
[]
[]
[null,"Assistance"]
[null,"This calculator was created by the Minnesota Pollution Control Agency's (MPCA) Business Assistance program."]
[null,"We provide free, confidential, environmental assistance to small businesses. For more information:"]
[null,"Call:","651/282-6143",null,"Email:","smallbizhelp.pca@state.mn.us"]
[null,null,"800/657-3938"]
[]
[null,"Online at the MPCA website at: ",null,null,"https://www.pca.state.mn.us/smallbizhelp"]
[]
[null,"More information on boiler requirements at: ",null,null,null,"https://www.pca.state.mn.us/regulations/stationary-engines-or-generators"]

{"sheet":"Federal Standards","index":1,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[54,1,54,14],[45,1,45,14],[13,1,13,14],[22,1,22,14],[23,1,23,12],[24,1,24,12],[25,9,25,12],[27,2,27,12],[28,2,28,12],[23,13,23,14],[14,1,14,12],[15,1,15,12],[16,2,16,7],[17,2,17,8],[17,9,17,12],[16,9,16,12],[11,1,11,14],[14,13,14,14],[53,13,53,14],[49,2,50,14],[51,2,51,14],[52,1,52,14],[53,1,53,7],[53,8,53,9],[53,10,53,12],[49,1,50,1],[12,1,12,14],[46,1,47,14],[48,2,48,14],[18,1,18,12],[19,2,19,12],[21,1,21,12],[44,1,44,14],[0,1,0,14],[25,2,25,7],[20,2,20,12],[26,1,26,12],[31,1,31,12],[24,13,27,14],[2,1,2,14],[1,1,1,14],[3,8,5,14],[6,2,6,13],[6,14,10,14],[7,1,8,1],[7,2,8,13],[9,1,10,1],[9,2,10,13],[3,1,5,6],[40,9,42,14],[37,9,38,14],[32,1,32,14],[40,2,41,7],[42,2,42,7],[33,1,36,7],[37,2,38,7],[33,8,35,14],[30,1,30,7],[30,8,30,12],[28,13,29,14],[15,13,18,14],[19,13,20,14],[39,2,39,7],[39,9,39,14]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"U.S. EPA standards for reciprocating internal combustion engines (RICE)"]
[null,"Applicability is determined separately for each engine. Each of your engines and any other air pollutant sources will need to be evaluated."]
[null,"New source performance standards (NSPS) require new emission sources to be less polluting than older sources.",null,null,null,null,null,null,"National emission standards for hazardous air pollutants (NESHAP) prevent or reduce emissions that have health impacts."]
[]
[]
[null,"▪ ","Each NSPS or NESHAP describes specific equipment, processes, or industries. "]
[null,"▪ ","Multiple federal standards may apply to your business. It is possible that if you make a change at your business, a federal standard that did not previously apply now will, or the one you are already following may have additional requirements."]
[]
[null,"▪ ","Federal standards can determine whether you need a permit and what requirements you must follow. You may have to follow federal standard requirements in addition to state permit requirements. Below are some of the common federal standards that affect engines."]
[]
[]
[]
[null,"New source performance standards (NSPS)"]
[null,"Does one of the federal NSPS for engines apply to any of your engines?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"The two most common NSPSs for engines are:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$15=\"Yes\",\"You must follow NSPS requirements. Continue to the question below.\",IF($N$15=\"No\",\"Continue to the next question below.\",IF($N$15=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,"1)","Standards of Performance for Compression Ignition Engines",null,null,null,null,null,"Full Text:","40 CFR 60, subp. IIII"]
[null,"2)","Standards of Performance for Spark Ignition Engines ",null,null,null,null,null,null,"40 CFR 60, subp. JJJJ"]
[]
[null,null,"To help understand if this rule applies, use the Regulation Navigation Tool provided by EPA for NSPS IIII and JJJJ. ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$15=\"Yes\",\"Continue to the next question\",IF($N$15=\"No\",\"\",IF($N$15=\"Choose Y/N\",\" \")))","v":" "}]
[null,null,"https://www3.epa.gov/ttn/atw/ice/quiz.html"]
[]
[null,"National emission standard for hazardous air pollutants (NESHAP)"]
[null,"Does the federal NESHAP for engines apply?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"The most common NESHAP for engines is for:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$24=\"Yes\",\"Follow NESHAP requirements. Assess emissions for permit thresholds.\",IF($N$24=\"No\",\"Continue to the information below.\",IF($N$24=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,null,"Stationary Reciprocating Internal Combustion Engines",null,null,null,null,null,"Full Text:","40 CFR 63, subp. ZZZZ"]
[]
[null,null,"To help understand if this rule applies, use the Regulation Navigation Tool provided by EPA for NESHAP ZZZZ. "]
[null,null,"https://www3.epa.gov/airtoxics/rice/output/quiz.html",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$24=\"Yes\",\"Continue to the information below.\",IF($N$24=\"No\",\"\",IF($N$24=\"Choose Y/N\",\" \")))","v":" "}]
[]
[null,"See additional details at: ",null,null,null,null,null,null,"https://www.pca.state.mn.us/air/engines"]
[]
[null,"Other NSPS or NESHAPs"]
[null,"Even if the NSPS for spark or compression ignition engines does not apply to you, there are others which may apply to your facility. For example, there are performance standards for nonmetallic mineral processors, hospital waste incinerators, and sewage treatment plants.",null,null,null,null,null,null,"Even if the NESHAP for reciprocating internal combustion engines does not apply to you, there are others that might such as those for coating operations, metal fabrication and finishing, or asphalt processing. "]
[]
[]
[]
[null,null,"A list of NSPSs is found on the MPCA website at the end of the following document:",null,null,null,null,null,null,"A list of NESHAPs is found on the MPCA website at the end of the following document:"]
[]
[null,null,"https://www.pca.state.mn.us/sites/default/files/aq-f1-gi09d.doc",null,null,null,null,null,null,"https://www.pca.state.mn.us/sites/default/files/aq-f3-rp07.pdf"]
[null,null,"If an NSPS applies, except as provided in Minn. R. 7007.0300, you need a permit.",null,null,null,null,null,null,"If a NESHAP applies, assess the facility-wide potential air emissions to see if a permit is required. Otherwise, comply with the NESHAP. "]
[]
[null,null,"Sources not required to obtain a permit: Minn. R. 7007.0300"]
[]
[]
[null,"Construction, modification, or reconstruction"]
[null,"If your business does an activity which is considered construction, modification, or reconstruction, as defined below or within the standard, the activity may cause an NSPS or NESHAP to apply to you or create the need for a permit amendment. "]
[]
[null,"▪ ","Construction includes fabricating, erecting, or installing an engine"]
[null,"▪ ","Modification is a physical change or change in operations at an existing facility that increases the amount of an air pollutant or results in the emission of a new air pollutant."]
[]
[null,"▪ ","Reconstruction is the replacement of components at an existing facility that exceeds 50% of the cost required to build a new facility."]
[]
[null,"The full definitions of construction and modification are available at:",null,null,null,null,null,null,"40 CFR § 60.2",null,"and reconstruction at: ",null,null,"40 CFR § 60.15"]

{"sheet":"Engine 1","index":2,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[61,5,61,6],[4,1,4,3],[5,1,5,3],[6,1,6,3],[10,1,10,3],[7,1,7,3],[4,4,4,5],[2,1,2,8],[61,1,61,4],[14,3,15,3],[14,4,15,4],[16,10,17,10],[10,5,10,8],[6,5,6,8],[14,10,15,10],[14,7,15,7],[14,8,15,8],[14,1,15,1],[14,2,15,2],[14,5,15,5],[14,6,15,6],[4,6,4,7],[9,1,9,3],[9,5,9,8],[5,5,5,8],[59,5,60,8],[8,1,8,3],[8,5,8,8],[32,6,32,8],[59,1,59,4],[60,1,60,4],[11,1,11,8],[12,1,12,8],[7,5,7,8]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"Air emissions from internal combustion engines"]
[null,"Reciprocating internal combustion engine (RICE)"]
[]
[null,"Engine and fuel type",null,null,"Choose one",null,"Facility identifier for engine",null,"Engine 1"]
[null,"Engine use",null,null,"Choose one","If emergency engine is used for peak-shaving or contracted for >15 hr/yr, choose 'Routine.'"]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(OR(E5=rd,E5=rg),\"Rated mechanical output\",IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),\"Rated fuel input\",\" \")))","v":" "},null,null,0,{"$f":"IF(B7=\" \",\" \",IF(B7=\"Rated mechanical output\",'Data Validation'!A23,IF(B7=\"Rated fuel input\",'Data Validation'!A24)))","v":" "}]
[null,"Choose one to calculate actual emissions",null,null,0,{"$f":"IF(B8='Data Validation'!B32,\" \",IF(B8='Data Validation'!B33,'Data Validation'!B38,IF(AND(B8='Data Validation'!B34,OR(E5=tng,OR(E5=ngl,OR(E5=ngr,OR(E5=ng2l))))),'Data Validation'!B39,IF(AND(B8='Data Validation'!B34,OR(E5=rd,OR(E5=rg))),'Data Validation'!B40,\" \"))))","v":" "}]
[null,{"$f":"IF(F7=\" \",\" \",IF(F7='Data Validation'!A23,'Data Validation'!A28,IF(F7='Data Validation'!A24,'Data Validation'!A29)))","v":" "},null,null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,'Engine Emission Factors'!F48,IF(E5=rg,'Engine Emission Factors'!F49,IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),'Engine Emission Factors'!G47,\" \"))))","v":" "},{"$f":"IF(B9=\" \",\" \",IF(B9='Data Validation'!A28,\"(Btu/HP-hr)\",IF(B9='Data Validation'!A29,\"Btu/scf\")))","v":" "}]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"Heat value of fuel\",IF(E5=rg,\"Heat value of fuel\",\" \")))","v":" "},null,"Heat value of fuel",{"$f":"IF(E5=rd,'Engine Emission Factors'!H48,IF(E5=rg,'Engine Emission Factors'!H49,\" \"))","v":" "},{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"(Btu/gal)\",IF(E5=rg,\"(Btu/gal)\",\" \")))","v":" "}]
[null,"Sulfur content of the fuel",null,null,{"$f":"IF(AND(E5=rd,E7>=600),\"0.0015\",IF(E5=tng,\"0.00065\",\"NA\"))","v":"NA"},"%"]
[]
[null,"Internal combustion engine potential and actual emissions"]
[null,null,"a","b","c","d","e"]
[null,"Pollutant","GWP1","Engine Rated Output","Actual Annual Throughput","Potential Annual Hours3","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity4 Limits"]
[]
[null,null,null,"(MMBtu/hr)","(MMBtu/yr)","(hr/yr)","(lbs/MMBtu)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,{"$f":"IF(E5=select,0,IF(OR(E5=rd,E5=rg),(E7*E9/10^6),IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),(E7*E9/(10^6)))))","v":0},{"$f":"IF(F8='Data Validation'!B39,E8,IF(AND(F8='Data Validation'!B40,E5=rd),(('Engine Emission Factors'!H48*E8)/1000000),IF(AND(F8='Data Validation'!B40,E5=rg),(('Engine Emission Factors'!H49*E8)/1000000),IF(F8='Data Validation'!B38,(E8*D18),IF(F8=\" \",0)))))","v":0},{"$f":"IF($E$6=so,0,IF($E$6=Routine,8760,IF($E$6=Emer,500)))","v":0},"by pollutant","(b * d * e) / 2000","(b * c * e) / 2000"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,"see engine emission factors tab",{"$f":"SUM(J20:J26)","v":6}]
[null,"PM",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C5,'Engine Emission Factors'!$B5),IF($E$5=rg,'Engine Emission Factors'!$E5,IF($E$5=tng,'Engine Emission Factors'!$D5,IF($E$5=ngr,'Engine Emission Factors'!$F5,IF($E$5=ngl,'Engine Emission Factors'!$G5,IF($E$5=ng2l,'Engine Emission Factors'!$H5,IF($E$5=select,'Engine Emission Factors'!$I6)))))))","v":0},{"$f":"$D$18*$F$18*$G20/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G20)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G20)/2000),0))","v":0},{"$f":"IF(K20>H20,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C6,'Engine Emission Factors'!$B6),IF($E$5=rg,'Engine Emission Factors'!$E6,IF($E$5=tng,'Engine Emission Factors'!$D6,IF($E$5=ngr,'Engine Emission Factors'!$F6,IF($E$5=ngl,'Engine Emission Factors'!$G6,IF($E$5=ng2l,'Engine Emission Factors'!$H6,IF($E$5=select,'Engine Emission Factors'!$I7)))))))","v":0},{"$f":"$D$18*$F$18*$G21/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G21)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G21)/2000),0))","v":0},{"$f":"IF(K21>H21,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C7,'Engine Emission Factors'!$B7),IF($E$5=rg,'Engine Emission Factors'!$E7,IF($E$5=tng,'Engine Emission Factors'!$D7,IF($E$5=ngr,'Engine Emission Factors'!$F7,IF($E$5=ngl,'Engine Emission Factors'!$G7,IF($E$5=ng2l,'Engine Emission Factors'!$H7,IF($E$5=select,'Engine Emission Factors'!$I8)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G22)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G22)/2000),0))","v":0}]
[null,"SOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C8*E11,'Engine Emission Factors'!$B8),IF($E$5=rg,'Engine Emission Factors'!$E8,IF($E$5=tng,'Engine Emission Factors'!$D8*E11,IF($E$5=ngr,'Engine Emission Factors'!$F8,IF($E$5=ngl,'Engine Emission Factors'!$G8,IF($E$5=ng2l,'Engine Emission Factors'!$H8,IF($E$5=select,'Engine Emission Factors'!$I9)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G23)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G23)/2000),0))","v":0},1,1]
[null,"NOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C9,'Engine Emission Factors'!$B9),IF($E$5=rg,'Engine Emission Factors'!$E9,IF($E$5=tng,'Engine Emission Factors'!$D9,IF($E$5=ngr,'Engine Emission Factors'!$F9,IF($E$5=ngl,'Engine Emission Factors'!$G9,IF($E$5=ng2l,'Engine Emission Factors'!$H9,IF($E$5=select,'Engine Emission Factors'!$I10)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G24)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G24)/2000),0))","v":0},1,1]
[null,"VOC",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C10,'Engine Emission Factors'!$B10),IF($E$5=rg,'Engine Emission Factors'!$E10,IF($E$5=tng,'Engine Emission Factors'!$D10,IF($E$5=ngr,'Engine Emission Factors'!$F10,IF($E$5=ngl,'Engine Emission Factors'!$G10,IF($E$5=ng2l,'Engine Emission Factors'!$H10,IF($E$5=select,'Engine Emission Factors'!$I11)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G25)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G25)/2000),0))","v":0},1,1]
[null,"CO",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C11,'Engine Emission Factors'!$B11),IF($E$5=rg,'Engine Emission Factors'!$E11,IF($E$5=tng,'Engine Emission Factors'!$D11,IF($E$5=ngr,'Engine Emission Factors'!$F11,IF($E$5=ngl,'Engine Emission Factors'!$G11,IF($E$5=ng2l,'Engine Emission Factors'!$H11,IF($E$5=select,'Engine Emission Factors'!$I12)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G26)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G26)/2000),0))","v":0},1,2]
[null,"Lead",null,null,null,null,"n/a",null,null,0]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2",0]
[null,"CO2 2",1,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C13,'Engine Emission Factors'!$B13),IF($E$5=rg,'Engine Emission Factors'!$E13,IF($E$5=tng,'Engine Emission Factors'!$D13,IF($E$5=ngr,'Engine Emission Factors'!$F13,IF($E$5=ngl,'Engine Emission Factors'!$G13,IF($E$5=ng2l,'Engine Emission Factors'!$H13,IF($E$5=select,'Engine Emission Factors'!$I13)))))))","v":0},{"$f":"$D$18*$F$18*$G29/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G29)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G29)/2000),0))","v":0},0]
[null,"CH4 2",25,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C14,'Engine Emission Factors'!$B14),IF($E$5=rg,'Engine Emission Factors'!$E14,IF($E$5=tng,'Engine Emission Factors'!$D14,IF($E$5=ngr,'Engine Emission Factors'!$F14,IF($E$5=ngl,'Engine Emission Factors'!$G14,IF($E$5=ng2l,'Engine Emission Factors'!$H14,IF($E$5=select,'Engine Emission Factors'!$I14)))))))","v":0},{"$f":"$D$18*$F$18*$G30/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G30)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G30)/2000),0))","v":0},0]
[null,"N2O 2",298,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C15,'Engine Emission Factors'!$B15),IF($E$5=rg,'Engine Emission Factors'!$E15,IF($E$5=tng,'Engine Emission Factors'!$D15,IF($E$5=ngr,'Engine Emission Factors'!$F15,IF($E$5=ngl,'Engine Emission Factors'!$G15,IF($E$5=ng2l,'Engine Emission Factors'!$H15,IF($E$5=select,'Engine Emission Factors'!$I15)))))))","v":0},{"$f":"$D$18*$F$18*$G31/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G31)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G31)/2000),0))","v":0},0]
[null,null,null,null,null,"GHG total (CO2e) 2",null,{"$f":"(C29*H29)+(C30*H30)+(C31*H31)","v":0},{"$f":"(C29*I29)+(C30*I30)+(C31*I31)","v":0},1,1000]
[null,"Hazardous Air Pollutants",null,null,null,null,"see engine emission factors tab"]
[null,"1,1,2,2-tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C17,'Engine Emission Factors'!$B17),IF($E$5=rg,'Engine Emission Factors'!$E17,IF($E$5=tng,'Engine Emission Factors'!$D17,IF($E$5=ngr,'Engine Emission Factors'!$F17,IF($E$5=ngl,'Engine Emission Factors'!$G17,IF($E$5=ng2l,'Engine Emission Factors'!$H17,IF($E$5=select,'Engine Emission Factors'!$I17)))))))","v":0},{"$f":"$D$18*$F$18*$G34/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G34)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G34)/2000),0))","v":0}]
[null,"1,1,2-trichloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C18,'Engine Emission Factors'!$B18),IF($E$5=rg,'Engine Emission Factors'!$E18,IF($E$5=tng,'Engine Emission Factors'!$D18,IF($E$5=ngr,'Engine Emission Factors'!$F18,IF($E$5=ngl,'Engine Emission Factors'!$G18,IF($E$5=ng2l,'Engine Emission Factors'!$H18,IF($E$5=select,'Engine Emission Factors'!$I18)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G35)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G35)/2000),0))","v":0}]
[null,"1,3-butadiene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C19,'Engine Emission Factors'!$B19),IF($E$5=rg,'Engine Emission Factors'!$E19,IF($E$5=tng,'Engine Emission Factors'!$D19,IF($E$5=ngr,'Engine Emission Factors'!$F19,IF($E$5=ngl,'Engine Emission Factors'!$G19,IF($E$5=ng2l,'Engine Emission Factors'!$H19,IF($E$5=select,'Engine Emission Factors'!$I19)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G36)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G36)/2000),0))","v":0}]
[null,"1,3-dichloropropene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C20,'Engine Emission Factors'!$B20),IF($E$5=rg,'Engine Emission Factors'!$E20,IF($E$5=tng,'Engine Emission Factors'!$D20,IF($E$5=ngr,'Engine Emission Factors'!$F20,IF($E$5=ngl,'Engine Emission Factors'!$G20,IF($E$5=ng2l,'Engine Emission Factors'!$H20,IF($E$5=select,'Engine Emission Factors'!$I20)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G37)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G37)/2000),0))","v":0}]
[null,"Acetaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C21,'Engine Emission Factors'!$B21),IF($E$5=rg,'Engine Emission Factors'!$E21,IF($E$5=tng,'Engine Emission Factors'!$D21,IF($E$5=ngr,'Engine Emission Factors'!$F21,IF($E$5=ngl,'Engine Emission Factors'!$G21,IF($E$5=ng2l,'Engine Emission Factors'!$H21,IF($E$5=select,'Engine Emission Factors'!$I21)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G38)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G38)/2000),0))","v":0}]
[null,"Acrolein",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C22,'Engine Emission Factors'!$B22),IF($E$5=rg,'Engine Emission Factors'!$E22,IF($E$5=tng,'Engine Emission Factors'!$D22,IF($E$5=ngr,'Engine Emission Factors'!$F22,IF($E$5=ngl,'Engine Emission Factors'!$G22,IF($E$5=ng2l,'Engine Emission Factors'!$H22,IF($E$5=select,'Engine Emission Factors'!$I22)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G39)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G39)/2000),0))","v":0}]
[null,"Benzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C23,'Engine Emission Factors'!$B23),IF($E$5=rg,'Engine Emission Factors'!$E23,IF($E$5=tng,'Engine Emission Factors'!$D23,IF($E$5=ngr,'Engine Emission Factors'!$F23,IF($E$5=ngl,'Engine Emission Factors'!$G23,IF($E$5=ng2l,'Engine Emission Factors'!$H23,IF($E$5=select,'Engine Emission Factors'!$I23)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G40)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G40)/2000),0))","v":0}]
[null,"Biphenyl",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C24,'Engine Emission Factors'!$B24),IF($E$5=rg,'Engine Emission Factors'!$E24,IF($E$5=tng,'Engine Emission Factors'!$D24,IF($E$5=ngr,'Engine Emission Factors'!$F24,IF($E$5=ngl,'Engine Emission Factors'!$G24,IF($E$5=ng2l,'Engine Emission Factors'!$H24,IF($E$5=select,'Engine Emission Factors'!$I24)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G41)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G41)/2000),0))","v":0}]
[null,"Carbon tetrachloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C25,'Engine Emission Factors'!$B25),IF($E$5=rg,'Engine Emission Factors'!$E25,IF($E$5=tng,'Engine Emission Factors'!$D25,IF($E$5=ngr,'Engine Emission Factors'!$F25,IF($E$5=ngl,'Engine Emission Factors'!$G25,IF($E$5=ng2l,'Engine Emission Factors'!$H25,IF($E$5=select,'Engine Emission Factors'!$I25)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G42)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G42)/2000),0))","v":0}]
[null,"Chlorobenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C26,'Engine Emission Factors'!$B26),IF($E$5=rg,'Engine Emission Factors'!$E26,IF($E$5=tng,'Engine Emission Factors'!$D26,IF($E$5=ngr,'Engine Emission Factors'!$F26,IF($E$5=ngl,'Engine Emission Factors'!$G26,IF($E$5=ng2l,'Engine Emission Factors'!$H26,IF($E$5=select,'Engine Emission Factors'!$I26)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G43)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G43)/2000),0))","v":0}]
[null,"Chloroform",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C27,'Engine Emission Factors'!$B27),IF($E$5=rg,'Engine Emission Factors'!$E27,IF($E$5=tng,'Engine Emission Factors'!$D27,IF($E$5=ngr,'Engine Emission Factors'!$F27,IF($E$5=ngl,'Engine Emission Factors'!$G27,IF($E$5=ng2l,'Engine Emission Factors'!$H27,IF($E$5=select,'Engine Emission Factors'!$I27)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G44)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G44)/2000),0))","v":0}]
[null,"Ethylbenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C28,'Engine Emission Factors'!$B28),IF($E$5=rg,'Engine Emission Factors'!$E28,IF($E$5=tng,'Engine Emission Factors'!$D28,IF($E$5=ngr,'Engine Emission Factors'!$F28,IF($E$5=ngl,'Engine Emission Factors'!$G28,IF($E$5=ng2l,'Engine Emission Factors'!$H28,IF($E$5=select,'Engine Emission Factors'!$I28)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G45)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G45)/2000),0))","v":0}]
[null,"Ethylene dibromide",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C29,'Engine Emission Factors'!$B29),IF($E$5=rg,'Engine Emission Factors'!$E29,IF($E$5=tng,'Engine Emission Factors'!$D29,IF($E$5=ngr,'Engine Emission Factors'!$F29,IF($E$5=ngl,'Engine Emission Factors'!$G29,IF($E$5=ng2l,'Engine Emission Factors'!$H29,IF($E$5=select,'Engine Emission Factors'!$I29)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G46)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G46)/2000),0))","v":0}]
[null,"Formaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C30,'Engine Emission Factors'!$B30),IF($E$5=rg,'Engine Emission Factors'!$E30,IF($E$5=tng,'Engine Emission Factors'!$D30,IF($E$5=ngr,'Engine Emission Factors'!$F30,IF($E$5=ngl,'Engine Emission Factors'!$G30,IF($E$5=ng2l,'Engine Emission Factors'!$H30,IF($E$5=select,'Engine Emission Factors'!$I30)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G47)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G47)/2000),0))","v":0}]
[null,"Hexane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C31,'Engine Emission Factors'!$B31),IF($E$5=rg,'Engine Emission Factors'!$E31,IF($E$5=tng,'Engine Emission Factors'!$D31,IF($E$5=ngr,'Engine Emission Factors'!$F31,IF($E$5=ngl,'Engine Emission Factors'!$G31,IF($E$5=ng2l,'Engine Emission Factors'!$H31,IF($E$5=select,'Engine Emission Factors'!$I31)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G48)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G48)/2000),0))","v":0}]
[null,"Methanol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C32,'Engine Emission Factors'!$B32),IF($E$5=rg,'Engine Emission Factors'!$E32,IF($E$5=tng,'Engine Emission Factors'!$D32,IF($E$5=ngr,'Engine Emission Factors'!$F32,IF($E$5=ngl,'Engine Emission Factors'!$G32,IF($E$5=ng2l,'Engine Emission Factors'!$H32,IF($E$5=select,'Engine Emission Factors'!$I32)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G49)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G49)/2000),0))","v":0}]
[null,"Methylene chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C33,'Engine Emission Factors'!$B33),IF($E$5=rg,'Engine Emission Factors'!$E33,IF($E$5=tng,'Engine Emission Factors'!$D33,IF($E$5=ngr,'Engine Emission Factors'!$F33,IF($E$5=ngl,'Engine Emission Factors'!$G33,IF($E$5=ng2l,'Engine Emission Factors'!$H33,IF($E$5=select,'Engine Emission Factors'!$I33)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G50)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G50)/2000),0))","v":0}]
[null,"Naphthalene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C34,'Engine Emission Factors'!$B34),IF($E$5=rg,'Engine Emission Factors'!$E34,IF($E$5=tng,'Engine Emission Factors'!$D34,IF($E$5=ngr,'Engine Emission Factors'!$F34,IF($E$5=ngl,'Engine Emission Factors'!$G34,IF($E$5=ng2l,'Engine Emission Factors'!$H34,IF($E$5=select,'Engine Emission Factors'!$I34)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G51)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G51)/2000),0))","v":0}]
[null,"PAH",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C35,'Engine Emission Factors'!$B35),IF($E$5=rg,'Engine Emission Factors'!$E35,IF($E$5=tng,'Engine Emission Factors'!$D35,IF($E$5=ngr,'Engine Emission Factors'!$F35,IF($E$5=ngl,'Engine Emission Factors'!$G35,IF($E$5=ng2l,'Engine Emission Factors'!$H35,IF($E$5=select,'Engine Emission Factors'!$I35)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G52)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G52)/2000),0))","v":0}]
[null,"Phenol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C36,'Engine Emission Factors'!$B36),IF($E$5=rg,'Engine Emission Factors'!$E36,IF($E$5=tng,'Engine Emission Factors'!$D36,IF($E$5=ngr,'Engine Emission Factors'!$F36,IF($E$5=ngl,'Engine Emission Factors'!$G36,IF($E$5=ng2l,'Engine Emission Factors'!$H36,IF($E$5=select,'Engine Emission Factors'!$I36)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G53)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G53)/2000),0))","v":0}]
[null,"Styrene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C37,'Engine Emission Factors'!$B37),IF($E$5=rg,'Engine Emission Factors'!$E37,IF($E$5=tng,'Engine Emission Factors'!$D37,IF($E$5=ngr,'Engine Emission Factors'!$F37,IF($E$5=ngl,'Engine Emission Factors'!$G37,IF($E$5=ng2l,'Engine Emission Factors'!$H37,IF($E$5=select,'Engine Emission Factors'!$I37)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G54)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G54)/2000),0))","v":0}]
[null,"Tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C38,'Engine Emission Factors'!$B38),IF($E$5=rg,'Engine Emission Factors'!$E38,IF($E$5=tng,'Engine Emission Factors'!$D38,IF($E$5=ngr,'Engine Emission Factors'!$F38,IF($E$5=ngl,'Engine Emission Factors'!$G38,IF($E$5=ng2l,'Engine Emission Factors'!$H38,IF($E$5=select,'Engine Emission Factors'!$I38)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G55)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G55)/2000),0))","v":0}]
[null,"Toluene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C39,'Engine Emission Factors'!$B39),IF($E$5=rg,'Engine Emission Factors'!$E39,IF($E$5=tng,'Engine Emission Factors'!$D39,IF($E$5=ngr,'Engine Emission Factors'!$F39,IF($E$5=ngl,'Engine Emission Factors'!$G39,IF($E$5=ng2l,'Engine Emission Factors'!$H39,IF($E$5=select,'Engine Emission Factors'!$I39)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G56)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G56)/2000),0))","v":0}]
[null,"Vinyl chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C40,'Engine Emission Factors'!$B40),IF($E$5=rg,'Engine Emission Factors'!$E40,IF($E$5=tng,'Engine Emission Factors'!$D40,IF($E$5=ngr,'Engine Emission Factors'!$F40,IF($E$5=ngl,'Engine Emission Factors'!$G40,IF($E$5=ng2l,'Engine Emission Factors'!$H40,IF($E$5=select,'Engine Emission Factors'!$I40)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G57)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G57)/2000),0))","v":0}]
[null,"Xylene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C41,'Engine Emission Factors'!$B41),IF($E$5=rg,'Engine Emission Factors'!$E41,IF($E$5=tng,'Engine Emission Factors'!$D41,IF($E$5=ngr,'Engine Emission Factors'!$F41,IF($E$5=ngl,'Engine Emission Factors'!$G41,IF($E$5=ng2l,'Engine Emission Factors'!$H41,IF($E$5=select,'Engine Emission Factors'!$I41)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G58)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G58)/2000),0))","v":0}]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H34:H58)","v":0},{"$f":"SUM(I34:I58)","v":0}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1",null,null,null,"4 See information on insignficnat activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab."]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 Routine = 24 hr/day * 365 day/yr or 8760 hr/yr; Emergency = 500 hr/yr",null,null,null,"Minn. R. 7007.1300"]

{"sheet":"Engine 2","index":3,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[8,1,8,3],[8,5,8,8],[0,1,0,10],[1,1,1,10],[2,1,2,8],[4,1,4,3],[4,4,4,5],[4,6,4,7],[14,10,15,10],[16,10,17,10],[32,6,32,8],[59,1,59,4],[59,5,60,8],[60,1,60,4],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[61,1,61,4],[61,5,61,6],[5,5,5,8],[14,7,15,7],[14,8,15,8],[9,1,9,3],[9,5,9,8],[10,1,10,3],[10,5,10,8],[11,1,11,8],[12,1,12,8],[5,1,5,3],[6,1,6,3],[6,5,6,8],[7,1,7,3],[7,5,7,8]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"Air emissions from internal combustion engines"]
[null,"Reciprocating internal combustion engine (RICE)"]
[]
[null,"Engine and fuel type",null,null,"Choose one",null,"Facility identifier for engine",null,"Engine 2"]
[null,"Engine use",null,null,"Choose one","If emergency engine is used for peak-shaving or contracted for >15 hr/yr, choose 'Routine.'"]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(OR(E5=rd,E5=rg),\"Rated mechanical output\",IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),\"Rated fuel input\",\" \")))","v":" "},null,null,0,{"$f":"IF(B7=\" \",\" \",IF(B7=\"Rated mechanical output\",'Data Validation'!A23,IF(B7=\"Rated fuel input\",'Data Validation'!A24)))","v":" "}]
[null,"Choose one to calculate actual emissions",null,null,0,{"$f":"IF(B8='Data Validation'!B32,\" \",IF(B8='Data Validation'!B33,'Data Validation'!B38,IF(AND(B8='Data Validation'!B34,OR(E5=tng,OR(E5=ngl,OR(E5=ngr,OR(E5=ng2l))))),'Data Validation'!B39,IF(AND(B8='Data Validation'!B34,OR(E5=rd,OR(E5=rg))),'Data Validation'!B40,\" \"))))","v":" "}]
[null,{"$f":"IF(F7=\" \",\" \",IF(F7='Data Validation'!A23,'Data Validation'!A28,IF(F7='Data Validation'!A24,'Data Validation'!A29)))","v":" "},null,null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,'Engine Emission Factors'!F48,IF(E5=rg,'Engine Emission Factors'!F49,IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),'Engine Emission Factors'!G47,\" \"))))","v":" "},{"$f":"IF(B9=\" \",\" \",IF(B9='Data Validation'!A28,\"(Btu/HP-hr)\",IF(B9='Data Validation'!A29,\"Btu/scf\")))","v":" "}]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"Heat value of fuel\",IF(E5=rg,\"Heat value of fuel\",\" \")))","v":" "},null,"Heat value of fuel",{"$f":"IF(E5=rd,'Engine Emission Factors'!H48,IF(E5=rg,'Engine Emission Factors'!H49,\" \"))","v":" "},{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"(Btu/gal)\",IF(E5=rg,\"(Btu/gal)\",\" \")))","v":" "}]
[null,"Sulfur content of the fuel",null,null,{"$f":"IF(AND(E5=rd,E7>=600),\"0.0015\",IF(E5=tng,\"0.00065\",\"NA\"))","v":"NA"},"%"]
[]
[null,"Internal combustion engine potential and actual emissions"]
[null,null,"a","b","c","d","e"]
[null,"Pollutant","GWP1","Engine Rated Output","Actual Annual Throughput","Potential Annual Hours3","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity4 Limits"]
[]
[null,null,null,"(MMBtu/hr)","(MMBtu/yr)","(hr/yr)","(lbs/MMBtu)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,{"$f":"IF(E5=select,0,IF(OR(E5=rd,E5=rg),(E7*E9/10^6),IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),(E7*E9/(10^6)))))","v":0},{"$f":"IF(F8='Data Validation'!B39,E8,IF(AND(F8='Data Validation'!B40,E5=rd),(('Engine Emission Factors'!H48*E8)/1000000),IF(AND(F8='Data Validation'!B40,E5=rg),(('Engine Emission Factors'!H49*E8)/1000000),IF(F8='Data Validation'!B38,(E8*D18),IF(F8=\" \",0)))))","v":0},{"$f":"IF($E$6=so,0,IF($E$6=Routine,8760,IF($E$6=Emer,500)))","v":0},"by pollutant","(b * d * e) / 2000","(b * c * e) / 2000"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,"see engine emission factors tab",{"$f":"SUM(J20:J26)","v":6}]
[null,"PM",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C5,'Engine Emission Factors'!$B5),IF($E$5=rg,'Engine Emission Factors'!$E5,IF($E$5=tng,'Engine Emission Factors'!$D5,IF($E$5=ngr,'Engine Emission Factors'!$F5,IF($E$5=ngl,'Engine Emission Factors'!$G5,IF($E$5=ng2l,'Engine Emission Factors'!$H5,IF($E$5=select,'Engine Emission Factors'!$I6)))))))","v":0},{"$f":"$D$18*$F$18*$G20/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G20)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G20)/2000),0))","v":0},{"$f":"IF(K20>H20,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C6,'Engine Emission Factors'!$B6),IF($E$5=rg,'Engine Emission Factors'!$E6,IF($E$5=tng,'Engine Emission Factors'!$D6,IF($E$5=ngr,'Engine Emission Factors'!$F6,IF($E$5=ngl,'Engine Emission Factors'!$G6,IF($E$5=ng2l,'Engine Emission Factors'!$H6,IF($E$5=select,'Engine Emission Factors'!$I7)))))))","v":0},{"$f":"$D$18*$F$18*$G21/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G21)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G21)/2000),0))","v":0},{"$f":"IF(K21>H21,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C7,'Engine Emission Factors'!$B7),IF($E$5=rg,'Engine Emission Factors'!$E7,IF($E$5=tng,'Engine Emission Factors'!$D7,IF($E$5=ngr,'Engine Emission Factors'!$F7,IF($E$5=ngl,'Engine Emission Factors'!$G7,IF($E$5=ng2l,'Engine Emission Factors'!$H7,IF($E$5=select,'Engine Emission Factors'!$I8)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G22)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G22)/2000),0))","v":0}]
[null,"SOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C8*E11,'Engine Emission Factors'!$B8),IF($E$5=rg,'Engine Emission Factors'!$E8,IF($E$5=tng,'Engine Emission Factors'!$D8*E11,IF($E$5=ngr,'Engine Emission Factors'!$F8,IF($E$5=ngl,'Engine Emission Factors'!$G8,IF($E$5=ng2l,'Engine Emission Factors'!$H8,IF($E$5=select,'Engine Emission Factors'!$I9)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G23)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G23)/2000),0))","v":0},1,1]
[null,"NOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C9,'Engine Emission Factors'!$B9),IF($E$5=rg,'Engine Emission Factors'!$E9,IF($E$5=tng,'Engine Emission Factors'!$D9,IF($E$5=ngr,'Engine Emission Factors'!$F9,IF($E$5=ngl,'Engine Emission Factors'!$G9,IF($E$5=ng2l,'Engine Emission Factors'!$H9,IF($E$5=select,'Engine Emission Factors'!$I10)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G24)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G24)/2000),0))","v":0},1,1]
[null,"VOC",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C10,'Engine Emission Factors'!$B10),IF($E$5=rg,'Engine Emission Factors'!$E10,IF($E$5=tng,'Engine Emission Factors'!$D10,IF($E$5=ngr,'Engine Emission Factors'!$F10,IF($E$5=ngl,'Engine Emission Factors'!$G10,IF($E$5=ng2l,'Engine Emission Factors'!$H10,IF($E$5=select,'Engine Emission Factors'!$I11)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G25)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G25)/2000),0))","v":0},1,1]
[null,"CO",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C11,'Engine Emission Factors'!$B11),IF($E$5=rg,'Engine Emission Factors'!$E11,IF($E$5=tng,'Engine Emission Factors'!$D11,IF($E$5=ngr,'Engine Emission Factors'!$F11,IF($E$5=ngl,'Engine Emission Factors'!$G11,IF($E$5=ng2l,'Engine Emission Factors'!$H11,IF($E$5=select,'Engine Emission Factors'!$I12)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G26)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G26)/2000),0))","v":0},1,2]
[null,"Lead",null,null,null,null,"n/a",null,null,0]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2",0]
[null,"CO2 2",1,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C13,'Engine Emission Factors'!$B13),IF($E$5=rg,'Engine Emission Factors'!$E13,IF($E$5=tng,'Engine Emission Factors'!$D13,IF($E$5=ngr,'Engine Emission Factors'!$F13,IF($E$5=ngl,'Engine Emission Factors'!$G13,IF($E$5=ng2l,'Engine Emission Factors'!$H13,IF($E$5=select,'Engine Emission Factors'!$I13)))))))","v":0},{"$f":"$D$18*$F$18*$G29/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G29)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G29)/2000),0))","v":0},0]
[null,"CH4 2",25,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C14,'Engine Emission Factors'!$B14),IF($E$5=rg,'Engine Emission Factors'!$E14,IF($E$5=tng,'Engine Emission Factors'!$D14,IF($E$5=ngr,'Engine Emission Factors'!$F14,IF($E$5=ngl,'Engine Emission Factors'!$G14,IF($E$5=ng2l,'Engine Emission Factors'!$H14,IF($E$5=select,'Engine Emission Factors'!$I14)))))))","v":0},{"$f":"$D$18*$F$18*$G30/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G30)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G30)/2000),0))","v":0},0]
[null,"N2O 2",298,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C15,'Engine Emission Factors'!$B15),IF($E$5=rg,'Engine Emission Factors'!$E15,IF($E$5=tng,'Engine Emission Factors'!$D15,IF($E$5=ngr,'Engine Emission Factors'!$F15,IF($E$5=ngl,'Engine Emission Factors'!$G15,IF($E$5=ng2l,'Engine Emission Factors'!$H15,IF($E$5=select,'Engine Emission Factors'!$I15)))))))","v":0},{"$f":"$D$18*$F$18*$G31/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G31)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G31)/2000),0))","v":0},0]
[null,null,null,null,null,"GHG total (CO2e) 2",null,{"$f":"(C29*H29)+(C30*H30)+(C31*H31)","v":0},{"$f":"(C29*I29)+(C30*I30)+(C31*I31)","v":0},1,1000]
[null,"Hazardous Air Pollutants",null,null,null,null,"see engine emission factors tab"]
[null,"1,1,2,2-tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C17,'Engine Emission Factors'!$B17),IF($E$5=rg,'Engine Emission Factors'!$E17,IF($E$5=tng,'Engine Emission Factors'!$D17,IF($E$5=ngr,'Engine Emission Factors'!$F17,IF($E$5=ngl,'Engine Emission Factors'!$G17,IF($E$5=ng2l,'Engine Emission Factors'!$H17,IF($E$5=select,'Engine Emission Factors'!$I17)))))))","v":0},{"$f":"$D$18*$F$18*$G34/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G34)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G34)/2000),0))","v":0}]
[null,"1,1,2-trichloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C18,'Engine Emission Factors'!$B18),IF($E$5=rg,'Engine Emission Factors'!$E18,IF($E$5=tng,'Engine Emission Factors'!$D18,IF($E$5=ngr,'Engine Emission Factors'!$F18,IF($E$5=ngl,'Engine Emission Factors'!$G18,IF($E$5=ng2l,'Engine Emission Factors'!$H18,IF($E$5=select,'Engine Emission Factors'!$I18)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G35)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G35)/2000),0))","v":0}]
[null,"1,3-butadiene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C19,'Engine Emission Factors'!$B19),IF($E$5=rg,'Engine Emission Factors'!$E19,IF($E$5=tng,'Engine Emission Factors'!$D19,IF($E$5=ngr,'Engine Emission Factors'!$F19,IF($E$5=ngl,'Engine Emission Factors'!$G19,IF($E$5=ng2l,'Engine Emission Factors'!$H19,IF($E$5=select,'Engine Emission Factors'!$I19)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G36)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G36)/2000),0))","v":0}]
[null,"1,3-dichloropropene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C20,'Engine Emission Factors'!$B20),IF($E$5=rg,'Engine Emission Factors'!$E20,IF($E$5=tng,'Engine Emission Factors'!$D20,IF($E$5=ngr,'Engine Emission Factors'!$F20,IF($E$5=ngl,'Engine Emission Factors'!$G20,IF($E$5=ng2l,'Engine Emission Factors'!$H20,IF($E$5=select,'Engine Emission Factors'!$I20)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G37)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G37)/2000),0))","v":0}]
[null,"Acetaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C21,'Engine Emission Factors'!$B21),IF($E$5=rg,'Engine Emission Factors'!$E21,IF($E$5=tng,'Engine Emission Factors'!$D21,IF($E$5=ngr,'Engine Emission Factors'!$F21,IF($E$5=ngl,'Engine Emission Factors'!$G21,IF($E$5=ng2l,'Engine Emission Factors'!$H21,IF($E$5=select,'Engine Emission Factors'!$I21)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G38)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G38)/2000),0))","v":0}]
[null,"Acrolein",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C22,'Engine Emission Factors'!$B22),IF($E$5=rg,'Engine Emission Factors'!$E22,IF($E$5=tng,'Engine Emission Factors'!$D22,IF($E$5=ngr,'Engine Emission Factors'!$F22,IF($E$5=ngl,'Engine Emission Factors'!$G22,IF($E$5=ng2l,'Engine Emission Factors'!$H22,IF($E$5=select,'Engine Emission Factors'!$I22)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G39)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G39)/2000),0))","v":0}]
[null,"Benzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C23,'Engine Emission Factors'!$B23),IF($E$5=rg,'Engine Emission Factors'!$E23,IF($E$5=tng,'Engine Emission Factors'!$D23,IF($E$5=ngr,'Engine Emission Factors'!$F23,IF($E$5=ngl,'Engine Emission Factors'!$G23,IF($E$5=ng2l,'Engine Emission Factors'!$H23,IF($E$5=select,'Engine Emission Factors'!$I23)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G40)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G40)/2000),0))","v":0}]
[null,"Biphenyl",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C24,'Engine Emission Factors'!$B24),IF($E$5=rg,'Engine Emission Factors'!$E24,IF($E$5=tng,'Engine Emission Factors'!$D24,IF($E$5=ngr,'Engine Emission Factors'!$F24,IF($E$5=ngl,'Engine Emission Factors'!$G24,IF($E$5=ng2l,'Engine Emission Factors'!$H24,IF($E$5=select,'Engine Emission Factors'!$I24)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G41)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G41)/2000),0))","v":0}]
[null,"Carbon tetrachloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C25,'Engine Emission Factors'!$B25),IF($E$5=rg,'Engine Emission Factors'!$E25,IF($E$5=tng,'Engine Emission Factors'!$D25,IF($E$5=ngr,'Engine Emission Factors'!$F25,IF($E$5=ngl,'Engine Emission Factors'!$G25,IF($E$5=ng2l,'Engine Emission Factors'!$H25,IF($E$5=select,'Engine Emission Factors'!$I25)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G42)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G42)/2000),0))","v":0}]
[null,"Chlorobenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C26,'Engine Emission Factors'!$B26),IF($E$5=rg,'Engine Emission Factors'!$E26,IF($E$5=tng,'Engine Emission Factors'!$D26,IF($E$5=ngr,'Engine Emission Factors'!$F26,IF($E$5=ngl,'Engine Emission Factors'!$G26,IF($E$5=ng2l,'Engine Emission Factors'!$H26,IF($E$5=select,'Engine Emission Factors'!$I26)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G43)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G43)/2000),0))","v":0}]
[null,"Chloroform",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C27,'Engine Emission Factors'!$B27),IF($E$5=rg,'Engine Emission Factors'!$E27,IF($E$5=tng,'Engine Emission Factors'!$D27,IF($E$5=ngr,'Engine Emission Factors'!$F27,IF($E$5=ngl,'Engine Emission Factors'!$G27,IF($E$5=ng2l,'Engine Emission Factors'!$H27,IF($E$5=select,'Engine Emission Factors'!$I27)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G44)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G44)/2000),0))","v":0}]
[null,"Ethylbenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C28,'Engine Emission Factors'!$B28),IF($E$5=rg,'Engine Emission Factors'!$E28,IF($E$5=tng,'Engine Emission Factors'!$D28,IF($E$5=ngr,'Engine Emission Factors'!$F28,IF($E$5=ngl,'Engine Emission Factors'!$G28,IF($E$5=ng2l,'Engine Emission Factors'!$H28,IF($E$5=select,'Engine Emission Factors'!$I28)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G45)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G45)/2000),0))","v":0}]
[null,"Ethylene dibromide",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C29,'Engine Emission Factors'!$B29),IF($E$5=rg,'Engine Emission Factors'!$E29,IF($E$5=tng,'Engine Emission Factors'!$D29,IF($E$5=ngr,'Engine Emission Factors'!$F29,IF($E$5=ngl,'Engine Emission Factors'!$G29,IF($E$5=ng2l,'Engine Emission Factors'!$H29,IF($E$5=select,'Engine Emission Factors'!$I29)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G46)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G46)/2000),0))","v":0}]
[null,"Formaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C30,'Engine Emission Factors'!$B30),IF($E$5=rg,'Engine Emission Factors'!$E30,IF($E$5=tng,'Engine Emission Factors'!$D30,IF($E$5=ngr,'Engine Emission Factors'!$F30,IF($E$5=ngl,'Engine Emission Factors'!$G30,IF($E$5=ng2l,'Engine Emission Factors'!$H30,IF($E$5=select,'Engine Emission Factors'!$I30)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G47)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G47)/2000),0))","v":0}]
[null,"Hexane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C31,'Engine Emission Factors'!$B31),IF($E$5=rg,'Engine Emission Factors'!$E31,IF($E$5=tng,'Engine Emission Factors'!$D31,IF($E$5=ngr,'Engine Emission Factors'!$F31,IF($E$5=ngl,'Engine Emission Factors'!$G31,IF($E$5=ng2l,'Engine Emission Factors'!$H31,IF($E$5=select,'Engine Emission Factors'!$I31)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G48)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G48)/2000),0))","v":0}]
[null,"Methanol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C32,'Engine Emission Factors'!$B32),IF($E$5=rg,'Engine Emission Factors'!$E32,IF($E$5=tng,'Engine Emission Factors'!$D32,IF($E$5=ngr,'Engine Emission Factors'!$F32,IF($E$5=ngl,'Engine Emission Factors'!$G32,IF($E$5=ng2l,'Engine Emission Factors'!$H32,IF($E$5=select,'Engine Emission Factors'!$I32)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G49)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G49)/2000),0))","v":0}]
[null,"Methylene chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C33,'Engine Emission Factors'!$B33),IF($E$5=rg,'Engine Emission Factors'!$E33,IF($E$5=tng,'Engine Emission Factors'!$D33,IF($E$5=ngr,'Engine Emission Factors'!$F33,IF($E$5=ngl,'Engine Emission Factors'!$G33,IF($E$5=ng2l,'Engine Emission Factors'!$H33,IF($E$5=select,'Engine Emission Factors'!$I33)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G50)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G50)/2000),0))","v":0}]
[null,"Naphthalene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C34,'Engine Emission Factors'!$B34),IF($E$5=rg,'Engine Emission Factors'!$E34,IF($E$5=tng,'Engine Emission Factors'!$D34,IF($E$5=ngr,'Engine Emission Factors'!$F34,IF($E$5=ngl,'Engine Emission Factors'!$G34,IF($E$5=ng2l,'Engine Emission Factors'!$H34,IF($E$5=select,'Engine Emission Factors'!$I34)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G51)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G51)/2000),0))","v":0}]
[null,"PAH",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C35,'Engine Emission Factors'!$B35),IF($E$5=rg,'Engine Emission Factors'!$E35,IF($E$5=tng,'Engine Emission Factors'!$D35,IF($E$5=ngr,'Engine Emission Factors'!$F35,IF($E$5=ngl,'Engine Emission Factors'!$G35,IF($E$5=ng2l,'Engine Emission Factors'!$H35,IF($E$5=select,'Engine Emission Factors'!$I35)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G52)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G52)/2000),0))","v":0}]
[null,"Phenol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C36,'Engine Emission Factors'!$B36),IF($E$5=rg,'Engine Emission Factors'!$E36,IF($E$5=tng,'Engine Emission Factors'!$D36,IF($E$5=ngr,'Engine Emission Factors'!$F36,IF($E$5=ngl,'Engine Emission Factors'!$G36,IF($E$5=ng2l,'Engine Emission Factors'!$H36,IF($E$5=select,'Engine Emission Factors'!$I36)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G53)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G53)/2000),0))","v":0}]
[null,"Styrene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C37,'Engine Emission Factors'!$B37),IF($E$5=rg,'Engine Emission Factors'!$E37,IF($E$5=tng,'Engine Emission Factors'!$D37,IF($E$5=ngr,'Engine Emission Factors'!$F37,IF($E$5=ngl,'Engine Emission Factors'!$G37,IF($E$5=ng2l,'Engine Emission Factors'!$H37,IF($E$5=select,'Engine Emission Factors'!$I37)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G54)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G54)/2000),0))","v":0}]
[null,"Tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C38,'Engine Emission Factors'!$B38),IF($E$5=rg,'Engine Emission Factors'!$E38,IF($E$5=tng,'Engine Emission Factors'!$D38,IF($E$5=ngr,'Engine Emission Factors'!$F38,IF($E$5=ngl,'Engine Emission Factors'!$G38,IF($E$5=ng2l,'Engine Emission Factors'!$H38,IF($E$5=select,'Engine Emission Factors'!$I38)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G55)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G55)/2000),0))","v":0}]
[null,"Toluene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C39,'Engine Emission Factors'!$B39),IF($E$5=rg,'Engine Emission Factors'!$E39,IF($E$5=tng,'Engine Emission Factors'!$D39,IF($E$5=ngr,'Engine Emission Factors'!$F39,IF($E$5=ngl,'Engine Emission Factors'!$G39,IF($E$5=ng2l,'Engine Emission Factors'!$H39,IF($E$5=select,'Engine Emission Factors'!$I39)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G56)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G56)/2000),0))","v":0}]
[null,"Vinyl chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C40,'Engine Emission Factors'!$B40),IF($E$5=rg,'Engine Emission Factors'!$E40,IF($E$5=tng,'Engine Emission Factors'!$D40,IF($E$5=ngr,'Engine Emission Factors'!$F40,IF($E$5=ngl,'Engine Emission Factors'!$G40,IF($E$5=ng2l,'Engine Emission Factors'!$H40,IF($E$5=select,'Engine Emission Factors'!$I40)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G57)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G57)/2000),0))","v":0}]
[null,"Xylene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C41,'Engine Emission Factors'!$B41),IF($E$5=rg,'Engine Emission Factors'!$E41,IF($E$5=tng,'Engine Emission Factors'!$D41,IF($E$5=ngr,'Engine Emission Factors'!$F41,IF($E$5=ngl,'Engine Emission Factors'!$G41,IF($E$5=ng2l,'Engine Emission Factors'!$H41,IF($E$5=select,'Engine Emission Factors'!$I41)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G58)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G58)/2000),0))","v":0}]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H34:H58)","v":0},{"$f":"SUM(I34:I58)","v":0}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1",null,null,null,"4 See information on insignficant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab."]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 Routine = 24 hr/day * 365 day/yr or 8760 hr/yr; Emergency = 500 hr/yr",null,null,null,"Minn. R. 7007.1300"]

{"sheet":"Engine 3","index":4,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[8,1,8,3],[8,5,8,8],[0,1,0,10],[1,1,1,10],[2,1,2,8],[4,1,4,3],[4,4,4,5],[4,6,4,7],[14,10,15,10],[16,10,17,10],[32,6,32,8],[59,1,59,4],[59,5,60,8],[60,1,60,4],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[61,1,61,4],[61,5,61,6],[5,5,5,8],[14,7,15,7],[14,8,15,8],[9,1,9,3],[9,5,9,8],[10,1,10,3],[10,5,10,8],[11,1,11,8],[12,1,12,8],[5,1,5,3],[6,1,6,3],[6,5,6,8],[7,1,7,3],[7,5,7,8]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"Air emissions from internal combustion engines"]
[null,"Reciprocating internal combustion engine (RICE)"]
[]
[null,"Engine and fuel type",null,null,"Choose one",null,"Facility identifier for engine",null,"Engine 3"]
[null,"Engine use",null,null,"Choose one","If emergency engine is used for peak-shaving or contracted for >15 hr/yr, choose 'Routine.'"]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(OR(E5=rd,E5=rg),\"Rated mechanical output\",IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),\"Rated fuel input\",\" \")))","v":" "},null,null,0,{"$f":"IF(B7=\" \",\" \",IF(B7=\"Rated mechanical output\",'Data Validation'!A23,IF(B7=\"Rated fuel input\",'Data Validation'!A24)))","v":" "}]
[null,"Choose one to calculate actual emissions",null,null,0,{"$f":"IF(B8='Data Validation'!B32,\" \",IF(B8='Data Validation'!B33,'Data Validation'!B38,IF(AND(B8='Data Validation'!B34,OR(E5=tng,OR(E5=ngl,OR(E5=ngr,OR(E5=ng2l))))),'Data Validation'!B39,IF(AND(B8='Data Validation'!B34,OR(E5=rd,OR(E5=rg))),'Data Validation'!B40,\" \"))))","v":" "}]
[null,{"$f":"IF(F7=\" \",\" \",IF(F7='Data Validation'!A23,'Data Validation'!A28,IF(F7='Data Validation'!A24,'Data Validation'!A29)))","v":" "},null,null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,'Engine Emission Factors'!F48,IF(E5=rg,'Engine Emission Factors'!F49,IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),'Engine Emission Factors'!G47,\" \"))))","v":" "},{"$f":"IF(B9=\" \",\" \",IF(B9='Data Validation'!A28,\"(Btu/HP-hr)\",IF(B9='Data Validation'!A29,\"Btu/scf\")))","v":" "}]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"Heat value of fuel\",IF(E5=rg,\"Heat value of fuel\",\" \")))","v":" "},null,"Heat value of fuel",{"$f":"IF(E5=rd,'Engine Emission Factors'!H48,IF(E5=rg,'Engine Emission Factors'!H49,\" \"))","v":" "},{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"(Btu/gal)\",IF(E5=rg,\"(Btu/gal)\",\" \")))","v":" "}]
[null,"Sulfur content of the fuel",null,null,{"$f":"IF(AND(E5=rd,E7>=600),\"0.0015\",IF(E5=tng,\"0.00065\",\"NA\"))","v":"NA"},"%"]
[]
[null,"Internal combustion engine potential and actual emissions"]
[null,null,"a","b","c","d","e"]
[null,"Pollutant","GWP1","Engine Rated Output","Actual Annual Throughput","Potential Annual Hours3","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity4 Limits"]
[]
[null,null,null,"(MMBtu/hr)","(MMBtu/yr)","(hr/yr)","(lbs/MMBtu)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,{"$f":"IF(E5=select,0,IF(OR(E5=rd,E5=rg),(E7*E9/10^6),IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),(E7*E9/(10^6)))))","v":0},{"$f":"IF(F8='Data Validation'!B39,E8,IF(AND(F8='Data Validation'!B40,E5=rd),(('Engine Emission Factors'!H48*E8)/1000000),IF(AND(F8='Data Validation'!B40,E5=rg),(('Engine Emission Factors'!H49*E8)/1000000),IF(F8='Data Validation'!B38,(E8*D18),IF(F8=\" \",0)))))","v":0},{"$f":"IF($E$6=so,0,IF($E$6=Routine,8760,IF($E$6=Emer,500)))","v":0},"by pollutant","(b * d * e) / 2000","(b * c * e) / 2000"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,"see engine emission factors tab",{"$f":"SUM(J20:J26)","v":6}]
[null,"PM",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C5,'Engine Emission Factors'!$B5),IF($E$5=rg,'Engine Emission Factors'!$E5,IF($E$5=tng,'Engine Emission Factors'!$D5,IF($E$5=ngr,'Engine Emission Factors'!$F5,IF($E$5=ngl,'Engine Emission Factors'!$G5,IF($E$5=ng2l,'Engine Emission Factors'!$H5,IF($E$5=select,'Engine Emission Factors'!$I6)))))))","v":0},{"$f":"$D$18*$F$18*$G20/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G20)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G20)/2000),0))","v":0},{"$f":"IF(K20>H20,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C6,'Engine Emission Factors'!$B6),IF($E$5=rg,'Engine Emission Factors'!$E6,IF($E$5=tng,'Engine Emission Factors'!$D6,IF($E$5=ngr,'Engine Emission Factors'!$F6,IF($E$5=ngl,'Engine Emission Factors'!$G6,IF($E$5=ng2l,'Engine Emission Factors'!$H6,IF($E$5=select,'Engine Emission Factors'!$I7)))))))","v":0},{"$f":"$D$18*$F$18*$G21/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G21)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G21)/2000),0))","v":0},{"$f":"IF(K21>H21,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C7,'Engine Emission Factors'!$B7),IF($E$5=rg,'Engine Emission Factors'!$E7,IF($E$5=tng,'Engine Emission Factors'!$D7,IF($E$5=ngr,'Engine Emission Factors'!$F7,IF($E$5=ngl,'Engine Emission Factors'!$G7,IF($E$5=ng2l,'Engine Emission Factors'!$H7,IF($E$5=select,'Engine Emission Factors'!$I8)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G22)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G22)/2000),0))","v":0}]
[null,"SOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C8*E11,'Engine Emission Factors'!$B8),IF($E$5=rg,'Engine Emission Factors'!$E8,IF($E$5=tng,'Engine Emission Factors'!$D8*E11,IF($E$5=ngr,'Engine Emission Factors'!$F8,IF($E$5=ngl,'Engine Emission Factors'!$G8,IF($E$5=ng2l,'Engine Emission Factors'!$H8,IF($E$5=select,'Engine Emission Factors'!$I9)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G23)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G23)/2000),0))","v":0},1,1]
[null,"NOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C9,'Engine Emission Factors'!$B9),IF($E$5=rg,'Engine Emission Factors'!$E9,IF($E$5=tng,'Engine Emission Factors'!$D9,IF($E$5=ngr,'Engine Emission Factors'!$F9,IF($E$5=ngl,'Engine Emission Factors'!$G9,IF($E$5=ng2l,'Engine Emission Factors'!$H9,IF($E$5=select,'Engine Emission Factors'!$I10)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G24)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G24)/2000),0))","v":0},1,1]
[null,"VOC",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C10,'Engine Emission Factors'!$B10),IF($E$5=rg,'Engine Emission Factors'!$E10,IF($E$5=tng,'Engine Emission Factors'!$D10,IF($E$5=ngr,'Engine Emission Factors'!$F10,IF($E$5=ngl,'Engine Emission Factors'!$G10,IF($E$5=ng2l,'Engine Emission Factors'!$H10,IF($E$5=select,'Engine Emission Factors'!$I11)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G25)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G25)/2000),0))","v":0},1,1]
[null,"CO",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C11,'Engine Emission Factors'!$B11),IF($E$5=rg,'Engine Emission Factors'!$E11,IF($E$5=tng,'Engine Emission Factors'!$D11,IF($E$5=ngr,'Engine Emission Factors'!$F11,IF($E$5=ngl,'Engine Emission Factors'!$G11,IF($E$5=ng2l,'Engine Emission Factors'!$H11,IF($E$5=select,'Engine Emission Factors'!$I12)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G26)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G26)/2000),0))","v":0},1,2]
[null,"Lead",null,null,null,null,"n/a",null,null,0]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2",0]
[null,"CO2 2",1,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C13,'Engine Emission Factors'!$B13),IF($E$5=rg,'Engine Emission Factors'!$E13,IF($E$5=tng,'Engine Emission Factors'!$D13,IF($E$5=ngr,'Engine Emission Factors'!$F13,IF($E$5=ngl,'Engine Emission Factors'!$G13,IF($E$5=ng2l,'Engine Emission Factors'!$H13,IF($E$5=select,'Engine Emission Factors'!$I13)))))))","v":0},{"$f":"$D$18*$F$18*$G29/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G29)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G29)/2000),0))","v":0},0]
[null,"CH4 2",25,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C14,'Engine Emission Factors'!$B14),IF($E$5=rg,'Engine Emission Factors'!$E14,IF($E$5=tng,'Engine Emission Factors'!$D14,IF($E$5=ngr,'Engine Emission Factors'!$F14,IF($E$5=ngl,'Engine Emission Factors'!$G14,IF($E$5=ng2l,'Engine Emission Factors'!$H14,IF($E$5=select,'Engine Emission Factors'!$I14)))))))","v":0},{"$f":"$D$18*$F$18*$G30/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G30)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G30)/2000),0))","v":0},0]
[null,"N2O 2",298,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C15,'Engine Emission Factors'!$B15),IF($E$5=rg,'Engine Emission Factors'!$E15,IF($E$5=tng,'Engine Emission Factors'!$D15,IF($E$5=ngr,'Engine Emission Factors'!$F15,IF($E$5=ngl,'Engine Emission Factors'!$G15,IF($E$5=ng2l,'Engine Emission Factors'!$H15,IF($E$5=select,'Engine Emission Factors'!$I15)))))))","v":0},{"$f":"$D$18*$F$18*$G31/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G31)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G31)/2000),0))","v":0},0]
[null,null,null,null,null,"GHG total (CO2e) 2",null,{"$f":"(C29*H29)+(C30*H30)+(C31*H31)","v":0},{"$f":"(C29*I29)+(C30*I30)+(C31*I31)","v":0},1,1000]
[null,"Hazardous Air Pollutants",null,null,null,null,"see engine emission factors tab"]
[null,"1,1,2,2-tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C17,'Engine Emission Factors'!$B17),IF($E$5=rg,'Engine Emission Factors'!$E17,IF($E$5=tng,'Engine Emission Factors'!$D17,IF($E$5=ngr,'Engine Emission Factors'!$F17,IF($E$5=ngl,'Engine Emission Factors'!$G17,IF($E$5=ng2l,'Engine Emission Factors'!$H17,IF($E$5=select,'Engine Emission Factors'!$I17)))))))","v":0},{"$f":"$D$18*$F$18*$G34/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G34)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G34)/2000),0))","v":0}]
[null,"1,1,2-trichloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C18,'Engine Emission Factors'!$B18),IF($E$5=rg,'Engine Emission Factors'!$E18,IF($E$5=tng,'Engine Emission Factors'!$D18,IF($E$5=ngr,'Engine Emission Factors'!$F18,IF($E$5=ngl,'Engine Emission Factors'!$G18,IF($E$5=ng2l,'Engine Emission Factors'!$H18,IF($E$5=select,'Engine Emission Factors'!$I18)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G35)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G35)/2000),0))","v":0}]
[null,"1,3-butadiene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C19,'Engine Emission Factors'!$B19),IF($E$5=rg,'Engine Emission Factors'!$E19,IF($E$5=tng,'Engine Emission Factors'!$D19,IF($E$5=ngr,'Engine Emission Factors'!$F19,IF($E$5=ngl,'Engine Emission Factors'!$G19,IF($E$5=ng2l,'Engine Emission Factors'!$H19,IF($E$5=select,'Engine Emission Factors'!$I19)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G36)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G36)/2000),0))","v":0}]
[null,"1,3-dichloropropene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C20,'Engine Emission Factors'!$B20),IF($E$5=rg,'Engine Emission Factors'!$E20,IF($E$5=tng,'Engine Emission Factors'!$D20,IF($E$5=ngr,'Engine Emission Factors'!$F20,IF($E$5=ngl,'Engine Emission Factors'!$G20,IF($E$5=ng2l,'Engine Emission Factors'!$H20,IF($E$5=select,'Engine Emission Factors'!$I20)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G37)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G37)/2000),0))","v":0}]
[null,"Acetaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C21,'Engine Emission Factors'!$B21),IF($E$5=rg,'Engine Emission Factors'!$E21,IF($E$5=tng,'Engine Emission Factors'!$D21,IF($E$5=ngr,'Engine Emission Factors'!$F21,IF($E$5=ngl,'Engine Emission Factors'!$G21,IF($E$5=ng2l,'Engine Emission Factors'!$H21,IF($E$5=select,'Engine Emission Factors'!$I21)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G38)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G38)/2000),0))","v":0}]
[null,"Acrolein",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C22,'Engine Emission Factors'!$B22),IF($E$5=rg,'Engine Emission Factors'!$E22,IF($E$5=tng,'Engine Emission Factors'!$D22,IF($E$5=ngr,'Engine Emission Factors'!$F22,IF($E$5=ngl,'Engine Emission Factors'!$G22,IF($E$5=ng2l,'Engine Emission Factors'!$H22,IF($E$5=select,'Engine Emission Factors'!$I22)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G39)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G39)/2000),0))","v":0}]
[null,"Benzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C23,'Engine Emission Factors'!$B23),IF($E$5=rg,'Engine Emission Factors'!$E23,IF($E$5=tng,'Engine Emission Factors'!$D23,IF($E$5=ngr,'Engine Emission Factors'!$F23,IF($E$5=ngl,'Engine Emission Factors'!$G23,IF($E$5=ng2l,'Engine Emission Factors'!$H23,IF($E$5=select,'Engine Emission Factors'!$I23)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G40)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G40)/2000),0))","v":0}]
[null,"Biphenyl",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C24,'Engine Emission Factors'!$B24),IF($E$5=rg,'Engine Emission Factors'!$E24,IF($E$5=tng,'Engine Emission Factors'!$D24,IF($E$5=ngr,'Engine Emission Factors'!$F24,IF($E$5=ngl,'Engine Emission Factors'!$G24,IF($E$5=ng2l,'Engine Emission Factors'!$H24,IF($E$5=select,'Engine Emission Factors'!$I24)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G41)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G41)/2000),0))","v":0}]
[null,"Carbon tetrachloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C25,'Engine Emission Factors'!$B25),IF($E$5=rg,'Engine Emission Factors'!$E25,IF($E$5=tng,'Engine Emission Factors'!$D25,IF($E$5=ngr,'Engine Emission Factors'!$F25,IF($E$5=ngl,'Engine Emission Factors'!$G25,IF($E$5=ng2l,'Engine Emission Factors'!$H25,IF($E$5=select,'Engine Emission Factors'!$I25)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G42)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G42)/2000),0))","v":0}]
[null,"Chlorobenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C26,'Engine Emission Factors'!$B26),IF($E$5=rg,'Engine Emission Factors'!$E26,IF($E$5=tng,'Engine Emission Factors'!$D26,IF($E$5=ngr,'Engine Emission Factors'!$F26,IF($E$5=ngl,'Engine Emission Factors'!$G26,IF($E$5=ng2l,'Engine Emission Factors'!$H26,IF($E$5=select,'Engine Emission Factors'!$I26)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G43)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G43)/2000),0))","v":0}]
[null,"Chloroform",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C27,'Engine Emission Factors'!$B27),IF($E$5=rg,'Engine Emission Factors'!$E27,IF($E$5=tng,'Engine Emission Factors'!$D27,IF($E$5=ngr,'Engine Emission Factors'!$F27,IF($E$5=ngl,'Engine Emission Factors'!$G27,IF($E$5=ng2l,'Engine Emission Factors'!$H27,IF($E$5=select,'Engine Emission Factors'!$I27)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G44)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G44)/2000),0))","v":0}]
[null,"Ethylbenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C28,'Engine Emission Factors'!$B28),IF($E$5=rg,'Engine Emission Factors'!$E28,IF($E$5=tng,'Engine Emission Factors'!$D28,IF($E$5=ngr,'Engine Emission Factors'!$F28,IF($E$5=ngl,'Engine Emission Factors'!$G28,IF($E$5=ng2l,'Engine Emission Factors'!$H28,IF($E$5=select,'Engine Emission Factors'!$I28)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G45)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G45)/2000),0))","v":0}]
[null,"Ethylene dibromide",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C29,'Engine Emission Factors'!$B29),IF($E$5=rg,'Engine Emission Factors'!$E29,IF($E$5=tng,'Engine Emission Factors'!$D29,IF($E$5=ngr,'Engine Emission Factors'!$F29,IF($E$5=ngl,'Engine Emission Factors'!$G29,IF($E$5=ng2l,'Engine Emission Factors'!$H29,IF($E$5=select,'Engine Emission Factors'!$I29)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G46)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G46)/2000),0))","v":0}]
[null,"Formaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C30,'Engine Emission Factors'!$B30),IF($E$5=rg,'Engine Emission Factors'!$E30,IF($E$5=tng,'Engine Emission Factors'!$D30,IF($E$5=ngr,'Engine Emission Factors'!$F30,IF($E$5=ngl,'Engine Emission Factors'!$G30,IF($E$5=ng2l,'Engine Emission Factors'!$H30,IF($E$5=select,'Engine Emission Factors'!$I30)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G47)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G47)/2000),0))","v":0}]
[null,"Hexane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C31,'Engine Emission Factors'!$B31),IF($E$5=rg,'Engine Emission Factors'!$E31,IF($E$5=tng,'Engine Emission Factors'!$D31,IF($E$5=ngr,'Engine Emission Factors'!$F31,IF($E$5=ngl,'Engine Emission Factors'!$G31,IF($E$5=ng2l,'Engine Emission Factors'!$H31,IF($E$5=select,'Engine Emission Factors'!$I31)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G48)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G48)/2000),0))","v":0}]
[null,"Methanol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C32,'Engine Emission Factors'!$B32),IF($E$5=rg,'Engine Emission Factors'!$E32,IF($E$5=tng,'Engine Emission Factors'!$D32,IF($E$5=ngr,'Engine Emission Factors'!$F32,IF($E$5=ngl,'Engine Emission Factors'!$G32,IF($E$5=ng2l,'Engine Emission Factors'!$H32,IF($E$5=select,'Engine Emission Factors'!$I32)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G49)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G49)/2000),0))","v":0}]
[null,"Methylene chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C33,'Engine Emission Factors'!$B33),IF($E$5=rg,'Engine Emission Factors'!$E33,IF($E$5=tng,'Engine Emission Factors'!$D33,IF($E$5=ngr,'Engine Emission Factors'!$F33,IF($E$5=ngl,'Engine Emission Factors'!$G33,IF($E$5=ng2l,'Engine Emission Factors'!$H33,IF($E$5=select,'Engine Emission Factors'!$I33)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G50)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G50)/2000),0))","v":0}]
[null,"Naphthalene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C34,'Engine Emission Factors'!$B34),IF($E$5=rg,'Engine Emission Factors'!$E34,IF($E$5=tng,'Engine Emission Factors'!$D34,IF($E$5=ngr,'Engine Emission Factors'!$F34,IF($E$5=ngl,'Engine Emission Factors'!$G34,IF($E$5=ng2l,'Engine Emission Factors'!$H34,IF($E$5=select,'Engine Emission Factors'!$I34)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G51)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G51)/2000),0))","v":0}]
[null,"PAH",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C35,'Engine Emission Factors'!$B35),IF($E$5=rg,'Engine Emission Factors'!$E35,IF($E$5=tng,'Engine Emission Factors'!$D35,IF($E$5=ngr,'Engine Emission Factors'!$F35,IF($E$5=ngl,'Engine Emission Factors'!$G35,IF($E$5=ng2l,'Engine Emission Factors'!$H35,IF($E$5=select,'Engine Emission Factors'!$I35)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G52)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G52)/2000),0))","v":0}]
[null,"Phenol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C36,'Engine Emission Factors'!$B36),IF($E$5=rg,'Engine Emission Factors'!$E36,IF($E$5=tng,'Engine Emission Factors'!$D36,IF($E$5=ngr,'Engine Emission Factors'!$F36,IF($E$5=ngl,'Engine Emission Factors'!$G36,IF($E$5=ng2l,'Engine Emission Factors'!$H36,IF($E$5=select,'Engine Emission Factors'!$I36)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G53)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G53)/2000),0))","v":0}]
[null,"Styrene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C37,'Engine Emission Factors'!$B37),IF($E$5=rg,'Engine Emission Factors'!$E37,IF($E$5=tng,'Engine Emission Factors'!$D37,IF($E$5=ngr,'Engine Emission Factors'!$F37,IF($E$5=ngl,'Engine Emission Factors'!$G37,IF($E$5=ng2l,'Engine Emission Factors'!$H37,IF($E$5=select,'Engine Emission Factors'!$I37)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G54)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G54)/2000),0))","v":0}]
[null,"Tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C38,'Engine Emission Factors'!$B38),IF($E$5=rg,'Engine Emission Factors'!$E38,IF($E$5=tng,'Engine Emission Factors'!$D38,IF($E$5=ngr,'Engine Emission Factors'!$F38,IF($E$5=ngl,'Engine Emission Factors'!$G38,IF($E$5=ng2l,'Engine Emission Factors'!$H38,IF($E$5=select,'Engine Emission Factors'!$I38)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G55)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G55)/2000),0))","v":0}]
[null,"Toluene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C39,'Engine Emission Factors'!$B39),IF($E$5=rg,'Engine Emission Factors'!$E39,IF($E$5=tng,'Engine Emission Factors'!$D39,IF($E$5=ngr,'Engine Emission Factors'!$F39,IF($E$5=ngl,'Engine Emission Factors'!$G39,IF($E$5=ng2l,'Engine Emission Factors'!$H39,IF($E$5=select,'Engine Emission Factors'!$I39)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G56)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G56)/2000),0))","v":0}]
[null,"Vinyl chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C40,'Engine Emission Factors'!$B40),IF($E$5=rg,'Engine Emission Factors'!$E40,IF($E$5=tng,'Engine Emission Factors'!$D40,IF($E$5=ngr,'Engine Emission Factors'!$F40,IF($E$5=ngl,'Engine Emission Factors'!$G40,IF($E$5=ng2l,'Engine Emission Factors'!$H40,IF($E$5=select,'Engine Emission Factors'!$I40)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G57)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G57)/2000),0))","v":0}]
[null,"Xylene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C41,'Engine Emission Factors'!$B41),IF($E$5=rg,'Engine Emission Factors'!$E41,IF($E$5=tng,'Engine Emission Factors'!$D41,IF($E$5=ngr,'Engine Emission Factors'!$F41,IF($E$5=ngl,'Engine Emission Factors'!$G41,IF($E$5=ng2l,'Engine Emission Factors'!$H41,IF($E$5=select,'Engine Emission Factors'!$I41)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G58)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G58)/2000),0))","v":0}]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H34:H58)","v":0},{"$f":"SUM(I34:I58)","v":0}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1",null,null,null,"4 See information on insignficant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab."]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 Routine = 24 hr/day * 365 day/yr or 8760 hr/yr; Emergency = 500 hr/yr",null,null,null,"Minn. R. 7007.1300"]

{"sheet":"Engine 4","index":5,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[8,1,8,3],[8,5,8,8],[0,1,0,10],[1,1,1,10],[2,1,2,8],[4,1,4,3],[4,4,4,5],[4,6,4,7],[14,10,15,10],[16,10,17,10],[32,6,32,8],[59,1,59,4],[59,5,60,8],[60,1,60,4],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[61,1,61,4],[61,5,61,6],[5,5,5,8],[14,7,15,7],[14,8,15,8],[9,1,9,3],[9,5,9,8],[10,1,10,3],[10,5,10,8],[11,1,11,8],[12,1,12,8],[5,1,5,3],[6,1,6,3],[6,5,6,8],[7,1,7,3],[7,5,7,8]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"Air emissions from internal combustion engines"]
[null,"Reciprocating internal combustion engine (RICE)"]
[]
[null,"Engine and fuel type",null,null,"Choose one",null,"Facility identifier for engine",null,"Engine 4"]
[null,"Engine use",null,null,"Choose one","If emergency engine is used for peak-shaving or contracted for >15 hr/yr, choose 'Routine.'"]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(OR(E5=rd,E5=rg),\"Rated mechanical output\",IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),\"Rated fuel input\",\" \")))","v":" "},null,null,0,{"$f":"IF(B7=\" \",\" \",IF(B7=\"Rated mechanical output\",'Data Validation'!A23,IF(B7=\"Rated fuel input\",'Data Validation'!A24)))","v":" "}]
[null,"Choose one to calculate actual emissions",null,null,0,{"$f":"IF(B8='Data Validation'!B32,\" \",IF(B8='Data Validation'!B33,'Data Validation'!B38,IF(AND(B8='Data Validation'!B34,OR(E5=tng,OR(E5=ngl,OR(E5=ngr,OR(E5=ng2l))))),'Data Validation'!B39,IF(AND(B8='Data Validation'!B34,OR(E5=rd,OR(E5=rg))),'Data Validation'!B40,\" \"))))","v":" "}]
[null,{"$f":"IF(F7=\" \",\" \",IF(F7='Data Validation'!A23,'Data Validation'!A28,IF(F7='Data Validation'!A24,'Data Validation'!A29)))","v":" "},null,null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,'Engine Emission Factors'!F48,IF(E5=rg,'Engine Emission Factors'!F49,IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),'Engine Emission Factors'!G47,\" \"))))","v":" "},{"$f":"IF(B9=\" \",\" \",IF(B9='Data Validation'!A28,\"(Btu/HP-hr)\",IF(B9='Data Validation'!A29,\"Btu/scf\")))","v":" "}]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"Heat value of fuel\",IF(E5=rg,\"Heat value of fuel\",\" \")))","v":" "},null,"Heat value of fuel",{"$f":"IF(E5=rd,'Engine Emission Factors'!H48,IF(E5=rg,'Engine Emission Factors'!H49,\" \"))","v":" "},{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"(Btu/gal)\",IF(E5=rg,\"(Btu/gal)\",\" \")))","v":" "}]
[null,"Sulfur content of the fuel",null,null,{"$f":"IF(AND(E5=rd,E7>=600),\"0.0015\",IF(E5=tng,\"0.00065\",\"NA\"))","v":"NA"},"%"]
[]
[null,"Internal combustion engine potential and actual emissions"]
[null,null,"a","b","c","d","e"]
[null,"Pollutant","GWP1","Engine Rated Output","Actual Annual Throughput","Potential Annual Hours3","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity4 Limits"]
[]
[null,null,null,"(MMBtu/hr)","(MMBtu/yr)","(hr/yr)","(lbs/MMBtu)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,{"$f":"IF(E5=select,0,IF(OR(E5=rd,E5=rg),(E7*E9/10^6),IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),(E7*E9/(10^6)))))","v":0},{"$f":"IF(F8='Data Validation'!B39,E8,IF(AND(F8='Data Validation'!B40,E5=rd),(('Engine Emission Factors'!H48*E8)/1000000),IF(AND(F8='Data Validation'!B40,E5=rg),(('Engine Emission Factors'!H49*E8)/1000000),IF(F8='Data Validation'!B38,(E8*D18),IF(F8=\" \",0)))))","v":0},{"$f":"IF($E$6=so,0,IF($E$6=Routine,8760,IF($E$6=Emer,500)))","v":0},"by pollutant","(b * d * e) / 2000","(b * c * e) / 2000"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,"see engine emission factors tab",{"$f":"SUM(J20:J26)","v":6}]
[null,"PM",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C5,'Engine Emission Factors'!$B5),IF($E$5=rg,'Engine Emission Factors'!$E5,IF($E$5=tng,'Engine Emission Factors'!$D5,IF($E$5=ngr,'Engine Emission Factors'!$F5,IF($E$5=ngl,'Engine Emission Factors'!$G5,IF($E$5=ng2l,'Engine Emission Factors'!$H5,IF($E$5=select,'Engine Emission Factors'!$I6)))))))","v":0},{"$f":"$D$18*$F$18*$G20/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G20)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G20)/2000),0))","v":0},{"$f":"IF(K20>H20,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C6,'Engine Emission Factors'!$B6),IF($E$5=rg,'Engine Emission Factors'!$E6,IF($E$5=tng,'Engine Emission Factors'!$D6,IF($E$5=ngr,'Engine Emission Factors'!$F6,IF($E$5=ngl,'Engine Emission Factors'!$G6,IF($E$5=ng2l,'Engine Emission Factors'!$H6,IF($E$5=select,'Engine Emission Factors'!$I7)))))))","v":0},{"$f":"$D$18*$F$18*$G21/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G21)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G21)/2000),0))","v":0},{"$f":"IF(K21>H21,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C7,'Engine Emission Factors'!$B7),IF($E$5=rg,'Engine Emission Factors'!$E7,IF($E$5=tng,'Engine Emission Factors'!$D7,IF($E$5=ngr,'Engine Emission Factors'!$F7,IF($E$5=ngl,'Engine Emission Factors'!$G7,IF($E$5=ng2l,'Engine Emission Factors'!$H7,IF($E$5=select,'Engine Emission Factors'!$I8)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G22)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G22)/2000),0))","v":0}]
[null,"SOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C8*E11,'Engine Emission Factors'!$B8),IF($E$5=rg,'Engine Emission Factors'!$E8,IF($E$5=tng,'Engine Emission Factors'!$D8*E11,IF($E$5=ngr,'Engine Emission Factors'!$F8,IF($E$5=ngl,'Engine Emission Factors'!$G8,IF($E$5=ng2l,'Engine Emission Factors'!$H8,IF($E$5=select,'Engine Emission Factors'!$I9)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G23)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G23)/2000),0))","v":0},1,1]
[null,"NOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C9,'Engine Emission Factors'!$B9),IF($E$5=rg,'Engine Emission Factors'!$E9,IF($E$5=tng,'Engine Emission Factors'!$D9,IF($E$5=ngr,'Engine Emission Factors'!$F9,IF($E$5=ngl,'Engine Emission Factors'!$G9,IF($E$5=ng2l,'Engine Emission Factors'!$H9,IF($E$5=select,'Engine Emission Factors'!$I10)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G24)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G24)/2000),0))","v":0},1,1]
[null,"VOC",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C10,'Engine Emission Factors'!$B10),IF($E$5=rg,'Engine Emission Factors'!$E10,IF($E$5=tng,'Engine Emission Factors'!$D10,IF($E$5=ngr,'Engine Emission Factors'!$F10,IF($E$5=ngl,'Engine Emission Factors'!$G10,IF($E$5=ng2l,'Engine Emission Factors'!$H10,IF($E$5=select,'Engine Emission Factors'!$I11)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G25)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G25)/2000),0))","v":0},1,1]
[null,"CO",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C11,'Engine Emission Factors'!$B11),IF($E$5=rg,'Engine Emission Factors'!$E11,IF($E$5=tng,'Engine Emission Factors'!$D11,IF($E$5=ngr,'Engine Emission Factors'!$F11,IF($E$5=ngl,'Engine Emission Factors'!$G11,IF($E$5=ng2l,'Engine Emission Factors'!$H11,IF($E$5=select,'Engine Emission Factors'!$I12)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G26)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G26)/2000),0))","v":0},1,2]
[null,"Lead",null,null,null,null,"n/a",null,null,0]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2",0]
[null,"CO2 2",1,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C13,'Engine Emission Factors'!$B13),IF($E$5=rg,'Engine Emission Factors'!$E13,IF($E$5=tng,'Engine Emission Factors'!$D13,IF($E$5=ngr,'Engine Emission Factors'!$F13,IF($E$5=ngl,'Engine Emission Factors'!$G13,IF($E$5=ng2l,'Engine Emission Factors'!$H13,IF($E$5=select,'Engine Emission Factors'!$I13)))))))","v":0},{"$f":"$D$18*$F$18*$G29/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G29)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G29)/2000),0))","v":0},0]
[null,"CH4 2",25,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C14,'Engine Emission Factors'!$B14),IF($E$5=rg,'Engine Emission Factors'!$E14,IF($E$5=tng,'Engine Emission Factors'!$D14,IF($E$5=ngr,'Engine Emission Factors'!$F14,IF($E$5=ngl,'Engine Emission Factors'!$G14,IF($E$5=ng2l,'Engine Emission Factors'!$H14,IF($E$5=select,'Engine Emission Factors'!$I14)))))))","v":0},{"$f":"$D$18*$F$18*$G30/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G30)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G30)/2000),0))","v":0},0]
[null,"N2O 2",298,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C15,'Engine Emission Factors'!$B15),IF($E$5=rg,'Engine Emission Factors'!$E15,IF($E$5=tng,'Engine Emission Factors'!$D15,IF($E$5=ngr,'Engine Emission Factors'!$F15,IF($E$5=ngl,'Engine Emission Factors'!$G15,IF($E$5=ng2l,'Engine Emission Factors'!$H15,IF($E$5=select,'Engine Emission Factors'!$I15)))))))","v":0},{"$f":"$D$18*$F$18*$G31/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G31)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G31)/2000),0))","v":0},0]
[null,null,null,null,null,"GHG total (CO2e) 2",null,{"$f":"(C29*H29)+(C30*H30)+(C31*H31)","v":0},{"$f":"(C29*I29)+(C30*I30)+(C31*I31)","v":0},1,1000]
[null,"Hazardous Air Pollutants",null,null,null,null,"see engine emission factors tab"]
[null,"1,1,2,2-tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C17,'Engine Emission Factors'!$B17),IF($E$5=rg,'Engine Emission Factors'!$E17,IF($E$5=tng,'Engine Emission Factors'!$D17,IF($E$5=ngr,'Engine Emission Factors'!$F17,IF($E$5=ngl,'Engine Emission Factors'!$G17,IF($E$5=ng2l,'Engine Emission Factors'!$H17,IF($E$5=select,'Engine Emission Factors'!$I17)))))))","v":0},{"$f":"$D$18*$F$18*$G34/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G34)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G34)/2000),0))","v":0}]
[null,"1,1,2-trichloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C18,'Engine Emission Factors'!$B18),IF($E$5=rg,'Engine Emission Factors'!$E18,IF($E$5=tng,'Engine Emission Factors'!$D18,IF($E$5=ngr,'Engine Emission Factors'!$F18,IF($E$5=ngl,'Engine Emission Factors'!$G18,IF($E$5=ng2l,'Engine Emission Factors'!$H18,IF($E$5=select,'Engine Emission Factors'!$I18)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G35)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G35)/2000),0))","v":0}]
[null,"1,3-butadiene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C19,'Engine Emission Factors'!$B19),IF($E$5=rg,'Engine Emission Factors'!$E19,IF($E$5=tng,'Engine Emission Factors'!$D19,IF($E$5=ngr,'Engine Emission Factors'!$F19,IF($E$5=ngl,'Engine Emission Factors'!$G19,IF($E$5=ng2l,'Engine Emission Factors'!$H19,IF($E$5=select,'Engine Emission Factors'!$I19)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G36)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G36)/2000),0))","v":0}]
[null,"1,3-dichloropropene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C20,'Engine Emission Factors'!$B20),IF($E$5=rg,'Engine Emission Factors'!$E20,IF($E$5=tng,'Engine Emission Factors'!$D20,IF($E$5=ngr,'Engine Emission Factors'!$F20,IF($E$5=ngl,'Engine Emission Factors'!$G20,IF($E$5=ng2l,'Engine Emission Factors'!$H20,IF($E$5=select,'Engine Emission Factors'!$I20)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G37)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G37)/2000),0))","v":0}]
[null,"Acetaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C21,'Engine Emission Factors'!$B21),IF($E$5=rg,'Engine Emission Factors'!$E21,IF($E$5=tng,'Engine Emission Factors'!$D21,IF($E$5=ngr,'Engine Emission Factors'!$F21,IF($E$5=ngl,'Engine Emission Factors'!$G21,IF($E$5=ng2l,'Engine Emission Factors'!$H21,IF($E$5=select,'Engine Emission Factors'!$I21)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G38)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G38)/2000),0))","v":0}]
[null,"Acrolein",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C22,'Engine Emission Factors'!$B22),IF($E$5=rg,'Engine Emission Factors'!$E22,IF($E$5=tng,'Engine Emission Factors'!$D22,IF($E$5=ngr,'Engine Emission Factors'!$F22,IF($E$5=ngl,'Engine Emission Factors'!$G22,IF($E$5=ng2l,'Engine Emission Factors'!$H22,IF($E$5=select,'Engine Emission Factors'!$I22)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G39)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G39)/2000),0))","v":0}]
[null,"Benzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C23,'Engine Emission Factors'!$B23),IF($E$5=rg,'Engine Emission Factors'!$E23,IF($E$5=tng,'Engine Emission Factors'!$D23,IF($E$5=ngr,'Engine Emission Factors'!$F23,IF($E$5=ngl,'Engine Emission Factors'!$G23,IF($E$5=ng2l,'Engine Emission Factors'!$H23,IF($E$5=select,'Engine Emission Factors'!$I23)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G40)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G40)/2000),0))","v":0}]
[null,"Biphenyl",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C24,'Engine Emission Factors'!$B24),IF($E$5=rg,'Engine Emission Factors'!$E24,IF($E$5=tng,'Engine Emission Factors'!$D24,IF($E$5=ngr,'Engine Emission Factors'!$F24,IF($E$5=ngl,'Engine Emission Factors'!$G24,IF($E$5=ng2l,'Engine Emission Factors'!$H24,IF($E$5=select,'Engine Emission Factors'!$I24)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G41)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G41)/2000),0))","v":0}]
[null,"Carbon tetrachloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C25,'Engine Emission Factors'!$B25),IF($E$5=rg,'Engine Emission Factors'!$E25,IF($E$5=tng,'Engine Emission Factors'!$D25,IF($E$5=ngr,'Engine Emission Factors'!$F25,IF($E$5=ngl,'Engine Emission Factors'!$G25,IF($E$5=ng2l,'Engine Emission Factors'!$H25,IF($E$5=select,'Engine Emission Factors'!$I25)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G42)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G42)/2000),0))","v":0}]
[null,"Chlorobenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C26,'Engine Emission Factors'!$B26),IF($E$5=rg,'Engine Emission Factors'!$E26,IF($E$5=tng,'Engine Emission Factors'!$D26,IF($E$5=ngr,'Engine Emission Factors'!$F26,IF($E$5=ngl,'Engine Emission Factors'!$G26,IF($E$5=ng2l,'Engine Emission Factors'!$H26,IF($E$5=select,'Engine Emission Factors'!$I26)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G43)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G43)/2000),0))","v":0}]
[null,"Chloroform",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C27,'Engine Emission Factors'!$B27),IF($E$5=rg,'Engine Emission Factors'!$E27,IF($E$5=tng,'Engine Emission Factors'!$D27,IF($E$5=ngr,'Engine Emission Factors'!$F27,IF($E$5=ngl,'Engine Emission Factors'!$G27,IF($E$5=ng2l,'Engine Emission Factors'!$H27,IF($E$5=select,'Engine Emission Factors'!$I27)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G44)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G44)/2000),0))","v":0}]
[null,"Ethylbenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C28,'Engine Emission Factors'!$B28),IF($E$5=rg,'Engine Emission Factors'!$E28,IF($E$5=tng,'Engine Emission Factors'!$D28,IF($E$5=ngr,'Engine Emission Factors'!$F28,IF($E$5=ngl,'Engine Emission Factors'!$G28,IF($E$5=ng2l,'Engine Emission Factors'!$H28,IF($E$5=select,'Engine Emission Factors'!$I28)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G45)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G45)/2000),0))","v":0}]
[null,"Ethylene dibromide",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C29,'Engine Emission Factors'!$B29),IF($E$5=rg,'Engine Emission Factors'!$E29,IF($E$5=tng,'Engine Emission Factors'!$D29,IF($E$5=ngr,'Engine Emission Factors'!$F29,IF($E$5=ngl,'Engine Emission Factors'!$G29,IF($E$5=ng2l,'Engine Emission Factors'!$H29,IF($E$5=select,'Engine Emission Factors'!$I29)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G46)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G46)/2000),0))","v":0}]
[null,"Formaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C30,'Engine Emission Factors'!$B30),IF($E$5=rg,'Engine Emission Factors'!$E30,IF($E$5=tng,'Engine Emission Factors'!$D30,IF($E$5=ngr,'Engine Emission Factors'!$F30,IF($E$5=ngl,'Engine Emission Factors'!$G30,IF($E$5=ng2l,'Engine Emission Factors'!$H30,IF($E$5=select,'Engine Emission Factors'!$I30)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G47)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G47)/2000),0))","v":0}]
[null,"Hexane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C31,'Engine Emission Factors'!$B31),IF($E$5=rg,'Engine Emission Factors'!$E31,IF($E$5=tng,'Engine Emission Factors'!$D31,IF($E$5=ngr,'Engine Emission Factors'!$F31,IF($E$5=ngl,'Engine Emission Factors'!$G31,IF($E$5=ng2l,'Engine Emission Factors'!$H31,IF($E$5=select,'Engine Emission Factors'!$I31)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G48)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G48)/2000),0))","v":0}]
[null,"Methanol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C32,'Engine Emission Factors'!$B32),IF($E$5=rg,'Engine Emission Factors'!$E32,IF($E$5=tng,'Engine Emission Factors'!$D32,IF($E$5=ngr,'Engine Emission Factors'!$F32,IF($E$5=ngl,'Engine Emission Factors'!$G32,IF($E$5=ng2l,'Engine Emission Factors'!$H32,IF($E$5=select,'Engine Emission Factors'!$I32)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G49)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G49)/2000),0))","v":0}]
[null,"Methylene chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C33,'Engine Emission Factors'!$B33),IF($E$5=rg,'Engine Emission Factors'!$E33,IF($E$5=tng,'Engine Emission Factors'!$D33,IF($E$5=ngr,'Engine Emission Factors'!$F33,IF($E$5=ngl,'Engine Emission Factors'!$G33,IF($E$5=ng2l,'Engine Emission Factors'!$H33,IF($E$5=select,'Engine Emission Factors'!$I33)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G50)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G50)/2000),0))","v":0}]
[null,"Naphthalene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C34,'Engine Emission Factors'!$B34),IF($E$5=rg,'Engine Emission Factors'!$E34,IF($E$5=tng,'Engine Emission Factors'!$D34,IF($E$5=ngr,'Engine Emission Factors'!$F34,IF($E$5=ngl,'Engine Emission Factors'!$G34,IF($E$5=ng2l,'Engine Emission Factors'!$H34,IF($E$5=select,'Engine Emission Factors'!$I34)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G51)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G51)/2000),0))","v":0}]
[null,"PAH",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C35,'Engine Emission Factors'!$B35),IF($E$5=rg,'Engine Emission Factors'!$E35,IF($E$5=tng,'Engine Emission Factors'!$D35,IF($E$5=ngr,'Engine Emission Factors'!$F35,IF($E$5=ngl,'Engine Emission Factors'!$G35,IF($E$5=ng2l,'Engine Emission Factors'!$H35,IF($E$5=select,'Engine Emission Factors'!$I35)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G52)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G52)/2000),0))","v":0}]
[null,"Phenol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C36,'Engine Emission Factors'!$B36),IF($E$5=rg,'Engine Emission Factors'!$E36,IF($E$5=tng,'Engine Emission Factors'!$D36,IF($E$5=ngr,'Engine Emission Factors'!$F36,IF($E$5=ngl,'Engine Emission Factors'!$G36,IF($E$5=ng2l,'Engine Emission Factors'!$H36,IF($E$5=select,'Engine Emission Factors'!$I36)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G53)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G53)/2000),0))","v":0}]
[null,"Styrene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C37,'Engine Emission Factors'!$B37),IF($E$5=rg,'Engine Emission Factors'!$E37,IF($E$5=tng,'Engine Emission Factors'!$D37,IF($E$5=ngr,'Engine Emission Factors'!$F37,IF($E$5=ngl,'Engine Emission Factors'!$G37,IF($E$5=ng2l,'Engine Emission Factors'!$H37,IF($E$5=select,'Engine Emission Factors'!$I37)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G54)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G54)/2000),0))","v":0}]
[null,"Tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C38,'Engine Emission Factors'!$B38),IF($E$5=rg,'Engine Emission Factors'!$E38,IF($E$5=tng,'Engine Emission Factors'!$D38,IF($E$5=ngr,'Engine Emission Factors'!$F38,IF($E$5=ngl,'Engine Emission Factors'!$G38,IF($E$5=ng2l,'Engine Emission Factors'!$H38,IF($E$5=select,'Engine Emission Factors'!$I38)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G55)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G55)/2000),0))","v":0}]
[null,"Toluene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C39,'Engine Emission Factors'!$B39),IF($E$5=rg,'Engine Emission Factors'!$E39,IF($E$5=tng,'Engine Emission Factors'!$D39,IF($E$5=ngr,'Engine Emission Factors'!$F39,IF($E$5=ngl,'Engine Emission Factors'!$G39,IF($E$5=ng2l,'Engine Emission Factors'!$H39,IF($E$5=select,'Engine Emission Factors'!$I39)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G56)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G56)/2000),0))","v":0}]
[null,"Vinyl chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C40,'Engine Emission Factors'!$B40),IF($E$5=rg,'Engine Emission Factors'!$E40,IF($E$5=tng,'Engine Emission Factors'!$D40,IF($E$5=ngr,'Engine Emission Factors'!$F40,IF($E$5=ngl,'Engine Emission Factors'!$G40,IF($E$5=ng2l,'Engine Emission Factors'!$H40,IF($E$5=select,'Engine Emission Factors'!$I40)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G57)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G57)/2000),0))","v":0}]
[null,"Xylene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C41,'Engine Emission Factors'!$B41),IF($E$5=rg,'Engine Emission Factors'!$E41,IF($E$5=tng,'Engine Emission Factors'!$D41,IF($E$5=ngr,'Engine Emission Factors'!$F41,IF($E$5=ngl,'Engine Emission Factors'!$G41,IF($E$5=ng2l,'Engine Emission Factors'!$H41,IF($E$5=select,'Engine Emission Factors'!$I41)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G58)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G58)/2000),0))","v":0}]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H34:H58)","v":0},{"$f":"SUM(I34:I58)","v":0}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1",null,null,null,"4 See information on insignficant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab."]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 Routine = 24 hr/day * 365 day/yr or 8760 hr/yr; Emergency = 500 hr/yr",null,null,null,"Minn. R. 7007.1300"]

{"sheet":"Engine 5","index":6,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[8,1,8,3],[8,5,8,8],[0,1,0,10],[1,1,1,10],[2,1,2,8],[4,1,4,3],[4,4,4,5],[4,6,4,7],[14,10,15,10],[16,10,17,10],[32,6,32,8],[59,1,59,4],[59,5,60,8],[60,1,60,4],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[61,1,61,4],[61,5,61,6],[5,5,5,8],[14,7,15,7],[14,8,15,8],[9,1,9,3],[9,5,9,8],[10,1,10,3],[10,5,10,8],[11,1,11,8],[12,1,12,8],[5,1,5,3],[6,1,6,3],[6,5,6,8],[7,1,7,3],[7,5,7,8]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"Air emissions from internal combustion engines"]
[null,"Reciprocating internal combustion engine (RICE)"]
[]
[null,"Engine and fuel type",null,null,"Choose one",null,"Facility identifier for engine",null,"Engine 5"]
[null,"Engine use",null,null,"Choose one","If emergency engine is used for peak-shaving or contracted for >15 hr/yr, choose 'Routine.'"]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(OR(E5=rd,E5=rg),\"Rated mechanical output\",IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),\"Rated fuel input\",\" \")))","v":" "},null,null,0,{"$f":"IF(B7=\" \",\" \",IF(B7=\"Rated mechanical output\",'Data Validation'!A23,IF(B7=\"Rated fuel input\",'Data Validation'!A24)))","v":" "}]
[null,"Choose one to calculate actual emissions",null,null,0,{"$f":"IF(B8='Data Validation'!B32,\" \",IF(B8='Data Validation'!B33,'Data Validation'!B38,IF(AND(B8='Data Validation'!B34,OR(E5=tng,OR(E5=ngl,OR(E5=ngr,OR(E5=ng2l))))),'Data Validation'!B39,IF(AND(B8='Data Validation'!B34,OR(E5=rd,OR(E5=rg))),'Data Validation'!B40,\" \"))))","v":" "}]
[null,{"$f":"IF(F7=\" \",\" \",IF(F7='Data Validation'!A23,'Data Validation'!A28,IF(F7='Data Validation'!A24,'Data Validation'!A29)))","v":" "},null,null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,'Engine Emission Factors'!F48,IF(E5=rg,'Engine Emission Factors'!F49,IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),'Engine Emission Factors'!G47,\" \"))))","v":" "},{"$f":"IF(B9=\" \",\" \",IF(B9='Data Validation'!A28,\"(Btu/HP-hr)\",IF(B9='Data Validation'!A29,\"Btu/scf\")))","v":" "}]
[null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"Heat value of fuel\",IF(E5=rg,\"Heat value of fuel\",\" \")))","v":" "},null,"Heat value of fuel",{"$f":"IF(E5=rd,'Engine Emission Factors'!H48,IF(E5=rg,'Engine Emission Factors'!H49,\" \"))","v":" "},{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,\"(Btu/gal)\",IF(E5=rg,\"(Btu/gal)\",\" \")))","v":" "}]
[null,"Sulfur content of the fuel",null,null,{"$f":"IF(AND(E5=rd,E7>=600),\"0.0015\",IF(E5=tng,\"0.00065\",\"NA\"))","v":"NA"},"%"]
[]
[null,"Internal combustion engine potential and actual emissions"]
[null,null,"a","b","c","d","e"]
[null,"Pollutant","GWP1","Engine Rated Output","Actual Annual Throughput","Potential Annual Hours3","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity4 Limits"]
[]
[null,null,null,"(MMBtu/hr)","(MMBtu/yr)","(hr/yr)","(lbs/MMBtu)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,{"$f":"IF(E5=select,0,IF(OR(E5=rd,E5=rg),(E7*E9/10^6),IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),(E7*E9/(10^6)))))","v":0},{"$f":"IF(F8='Data Validation'!B39,E8,IF(AND(F8='Data Validation'!B40,E5=rd),(('Engine Emission Factors'!H48*E8)/1000000),IF(AND(F8='Data Validation'!B40,E5=rg),(('Engine Emission Factors'!H49*E8)/1000000),IF(F8='Data Validation'!B38,(E8*D18),IF(F8=\" \",0)))))","v":0},{"$f":"IF($E$6=so,0,IF($E$6=Routine,8760,IF($E$6=Emer,500)))","v":0},"by pollutant","(b * d * e) / 2000","(b * c * e) / 2000"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,"see engine emission factors tab",{"$f":"SUM(J20:J26)","v":6}]
[null,"PM",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C5,'Engine Emission Factors'!$B5),IF($E$5=rg,'Engine Emission Factors'!$E5,IF($E$5=tng,'Engine Emission Factors'!$D5,IF($E$5=ngr,'Engine Emission Factors'!$F5,IF($E$5=ngl,'Engine Emission Factors'!$G5,IF($E$5=ng2l,'Engine Emission Factors'!$H5,IF($E$5=select,'Engine Emission Factors'!$I6)))))))","v":0},{"$f":"$D$18*$F$18*$G20/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G20)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G20)/2000),0))","v":0},{"$f":"IF(K20>H20,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C6,'Engine Emission Factors'!$B6),IF($E$5=rg,'Engine Emission Factors'!$E6,IF($E$5=tng,'Engine Emission Factors'!$D6,IF($E$5=ngr,'Engine Emission Factors'!$F6,IF($E$5=ngl,'Engine Emission Factors'!$G6,IF($E$5=ng2l,'Engine Emission Factors'!$H6,IF($E$5=select,'Engine Emission Factors'!$I7)))))))","v":0},{"$f":"$D$18*$F$18*$G21/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G21)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G21)/2000),0))","v":0},{"$f":"IF(K21>H21,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C7,'Engine Emission Factors'!$B7),IF($E$5=rg,'Engine Emission Factors'!$E7,IF($E$5=tng,'Engine Emission Factors'!$D7,IF($E$5=ngr,'Engine Emission Factors'!$F7,IF($E$5=ngl,'Engine Emission Factors'!$G7,IF($E$5=ng2l,'Engine Emission Factors'!$H7,IF($E$5=select,'Engine Emission Factors'!$I8)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G22)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G22)/2000),0))","v":0}]
[null,"SOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C8*E11,'Engine Emission Factors'!$B8),IF($E$5=rg,'Engine Emission Factors'!$E8,IF($E$5=tng,'Engine Emission Factors'!$D8*E11,IF($E$5=ngr,'Engine Emission Factors'!$F8,IF($E$5=ngl,'Engine Emission Factors'!$G8,IF($E$5=ng2l,'Engine Emission Factors'!$H8,IF($E$5=select,'Engine Emission Factors'!$I9)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G23)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G23)/2000),0))","v":0},1,1]
[null,"NOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C9,'Engine Emission Factors'!$B9),IF($E$5=rg,'Engine Emission Factors'!$E9,IF($E$5=tng,'Engine Emission Factors'!$D9,IF($E$5=ngr,'Engine Emission Factors'!$F9,IF($E$5=ngl,'Engine Emission Factors'!$G9,IF($E$5=ng2l,'Engine Emission Factors'!$H9,IF($E$5=select,'Engine Emission Factors'!$I10)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G24)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G24)/2000),0))","v":0},1,1]
[null,"VOC",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C10,'Engine Emission Factors'!$B10),IF($E$5=rg,'Engine Emission Factors'!$E10,IF($E$5=tng,'Engine Emission Factors'!$D10,IF($E$5=ngr,'Engine Emission Factors'!$F10,IF($E$5=ngl,'Engine Emission Factors'!$G10,IF($E$5=ng2l,'Engine Emission Factors'!$H10,IF($E$5=select,'Engine Emission Factors'!$I11)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G25)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G25)/2000),0))","v":0},1,1]
[null,"CO",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C11,'Engine Emission Factors'!$B11),IF($E$5=rg,'Engine Emission Factors'!$E11,IF($E$5=tng,'Engine Emission Factors'!$D11,IF($E$5=ngr,'Engine Emission Factors'!$F11,IF($E$5=ngl,'Engine Emission Factors'!$G11,IF($E$5=ng2l,'Engine Emission Factors'!$H11,IF($E$5=select,'Engine Emission Factors'!$I12)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G26)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G26)/2000),0))","v":0},1,2]
[null,"Lead",null,null,null,null,"n/a",null,null,0]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2",0]
[null,"CO2 2",1,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C13,'Engine Emission Factors'!$B13),IF($E$5=rg,'Engine Emission Factors'!$E13,IF($E$5=tng,'Engine Emission Factors'!$D13,IF($E$5=ngr,'Engine Emission Factors'!$F13,IF($E$5=ngl,'Engine Emission Factors'!$G13,IF($E$5=ng2l,'Engine Emission Factors'!$H13,IF($E$5=select,'Engine Emission Factors'!$I13)))))))","v":0},{"$f":"$D$18*$F$18*$G29/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G29)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G29)/2000),0))","v":0},0]
[null,"CH4 2",25,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C14,'Engine Emission Factors'!$B14),IF($E$5=rg,'Engine Emission Factors'!$E14,IF($E$5=tng,'Engine Emission Factors'!$D14,IF($E$5=ngr,'Engine Emission Factors'!$F14,IF($E$5=ngl,'Engine Emission Factors'!$G14,IF($E$5=ng2l,'Engine Emission Factors'!$H14,IF($E$5=select,'Engine Emission Factors'!$I14)))))))","v":0},{"$f":"$D$18*$F$18*$G30/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G30)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G30)/2000),0))","v":0},0]
[null,"N2O 2",298,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C15,'Engine Emission Factors'!$B15),IF($E$5=rg,'Engine Emission Factors'!$E15,IF($E$5=tng,'Engine Emission Factors'!$D15,IF($E$5=ngr,'Engine Emission Factors'!$F15,IF($E$5=ngl,'Engine Emission Factors'!$G15,IF($E$5=ng2l,'Engine Emission Factors'!$H15,IF($E$5=select,'Engine Emission Factors'!$I15)))))))","v":0},{"$f":"$D$18*$F$18*$G31/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G31)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G31)/2000),0))","v":0},0]
[null,null,null,null,null,"GHG total (CO2e) 2",null,{"$f":"(C29*H29)+(C30*H30)+(C31*H31)","v":0},{"$f":"(C29*I29)+(C30*I30)+(C31*I31)","v":0},1,1000]
[null,"Hazardous Air Pollutants",null,null,null,null,"see engine emission factors tab"]
[null,"1,1,2,2-tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C17,'Engine Emission Factors'!$B17),IF($E$5=rg,'Engine Emission Factors'!$E17,IF($E$5=tng,'Engine Emission Factors'!$D17,IF($E$5=ngr,'Engine Emission Factors'!$F17,IF($E$5=ngl,'Engine Emission Factors'!$G17,IF($E$5=ng2l,'Engine Emission Factors'!$H17,IF($E$5=select,'Engine Emission Factors'!$I17)))))))","v":0},{"$f":"$D$18*$F$18*$G34/2000","v":0},{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G34)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G34)/2000),0))","v":0}]
[null,"1,1,2-trichloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C18,'Engine Emission Factors'!$B18),IF($E$5=rg,'Engine Emission Factors'!$E18,IF($E$5=tng,'Engine Emission Factors'!$D18,IF($E$5=ngr,'Engine Emission Factors'!$F18,IF($E$5=ngl,'Engine Emission Factors'!$G18,IF($E$5=ng2l,'Engine Emission Factors'!$H18,IF($E$5=select,'Engine Emission Factors'!$I18)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G35)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G35)/2000),0))","v":0}]
[null,"1,3-butadiene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C19,'Engine Emission Factors'!$B19),IF($E$5=rg,'Engine Emission Factors'!$E19,IF($E$5=tng,'Engine Emission Factors'!$D19,IF($E$5=ngr,'Engine Emission Factors'!$F19,IF($E$5=ngl,'Engine Emission Factors'!$G19,IF($E$5=ng2l,'Engine Emission Factors'!$H19,IF($E$5=select,'Engine Emission Factors'!$I19)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G36)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G36)/2000),0))","v":0}]
[null,"1,3-dichloropropene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C20,'Engine Emission Factors'!$B20),IF($E$5=rg,'Engine Emission Factors'!$E20,IF($E$5=tng,'Engine Emission Factors'!$D20,IF($E$5=ngr,'Engine Emission Factors'!$F20,IF($E$5=ngl,'Engine Emission Factors'!$G20,IF($E$5=ng2l,'Engine Emission Factors'!$H20,IF($E$5=select,'Engine Emission Factors'!$I20)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G37)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G37)/2000),0))","v":0}]
[null,"Acetaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C21,'Engine Emission Factors'!$B21),IF($E$5=rg,'Engine Emission Factors'!$E21,IF($E$5=tng,'Engine Emission Factors'!$D21,IF($E$5=ngr,'Engine Emission Factors'!$F21,IF($E$5=ngl,'Engine Emission Factors'!$G21,IF($E$5=ng2l,'Engine Emission Factors'!$H21,IF($E$5=select,'Engine Emission Factors'!$I21)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G38)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G38)/2000),0))","v":0}]
[null,"Acrolein",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C22,'Engine Emission Factors'!$B22),IF($E$5=rg,'Engine Emission Factors'!$E22,IF($E$5=tng,'Engine Emission Factors'!$D22,IF($E$5=ngr,'Engine Emission Factors'!$F22,IF($E$5=ngl,'Engine Emission Factors'!$G22,IF($E$5=ng2l,'Engine Emission Factors'!$H22,IF($E$5=select,'Engine Emission Factors'!$I22)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G39)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G39)/2000),0))","v":0}]
[null,"Benzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C23,'Engine Emission Factors'!$B23),IF($E$5=rg,'Engine Emission Factors'!$E23,IF($E$5=tng,'Engine Emission Factors'!$D23,IF($E$5=ngr,'Engine Emission Factors'!$F23,IF($E$5=ngl,'Engine Emission Factors'!$G23,IF($E$5=ng2l,'Engine Emission Factors'!$H23,IF($E$5=select,'Engine Emission Factors'!$I23)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G40)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G40)/2000),0))","v":0}]
[null,"Biphenyl",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C24,'Engine Emission Factors'!$B24),IF($E$5=rg,'Engine Emission Factors'!$E24,IF($E$5=tng,'Engine Emission Factors'!$D24,IF($E$5=ngr,'Engine Emission Factors'!$F24,IF($E$5=ngl,'Engine Emission Factors'!$G24,IF($E$5=ng2l,'Engine Emission Factors'!$H24,IF($E$5=select,'Engine Emission Factors'!$I24)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G41)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G41)/2000),0))","v":0}]
[null,"Carbon tetrachloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C25,'Engine Emission Factors'!$B25),IF($E$5=rg,'Engine Emission Factors'!$E25,IF($E$5=tng,'Engine Emission Factors'!$D25,IF($E$5=ngr,'Engine Emission Factors'!$F25,IF($E$5=ngl,'Engine Emission Factors'!$G25,IF($E$5=ng2l,'Engine Emission Factors'!$H25,IF($E$5=select,'Engine Emission Factors'!$I25)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G42)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G42)/2000),0))","v":0}]
[null,"Chlorobenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C26,'Engine Emission Factors'!$B26),IF($E$5=rg,'Engine Emission Factors'!$E26,IF($E$5=tng,'Engine Emission Factors'!$D26,IF($E$5=ngr,'Engine Emission Factors'!$F26,IF($E$5=ngl,'Engine Emission Factors'!$G26,IF($E$5=ng2l,'Engine Emission Factors'!$H26,IF($E$5=select,'Engine Emission Factors'!$I26)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G43)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G43)/2000),0))","v":0}]
[null,"Chloroform",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C27,'Engine Emission Factors'!$B27),IF($E$5=rg,'Engine Emission Factors'!$E27,IF($E$5=tng,'Engine Emission Factors'!$D27,IF($E$5=ngr,'Engine Emission Factors'!$F27,IF($E$5=ngl,'Engine Emission Factors'!$G27,IF($E$5=ng2l,'Engine Emission Factors'!$H27,IF($E$5=select,'Engine Emission Factors'!$I27)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G44)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G44)/2000),0))","v":0}]
[null,"Ethylbenzene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C28,'Engine Emission Factors'!$B28),IF($E$5=rg,'Engine Emission Factors'!$E28,IF($E$5=tng,'Engine Emission Factors'!$D28,IF($E$5=ngr,'Engine Emission Factors'!$F28,IF($E$5=ngl,'Engine Emission Factors'!$G28,IF($E$5=ng2l,'Engine Emission Factors'!$H28,IF($E$5=select,'Engine Emission Factors'!$I28)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G45)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G45)/2000),0))","v":0}]
[null,"Ethylene dibromide",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C29,'Engine Emission Factors'!$B29),IF($E$5=rg,'Engine Emission Factors'!$E29,IF($E$5=tng,'Engine Emission Factors'!$D29,IF($E$5=ngr,'Engine Emission Factors'!$F29,IF($E$5=ngl,'Engine Emission Factors'!$G29,IF($E$5=ng2l,'Engine Emission Factors'!$H29,IF($E$5=select,'Engine Emission Factors'!$I29)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G46)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G46)/2000),0))","v":0}]
[null,"Formaldehyde",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C30,'Engine Emission Factors'!$B30),IF($E$5=rg,'Engine Emission Factors'!$E30,IF($E$5=tng,'Engine Emission Factors'!$D30,IF($E$5=ngr,'Engine Emission Factors'!$F30,IF($E$5=ngl,'Engine Emission Factors'!$G30,IF($E$5=ng2l,'Engine Emission Factors'!$H30,IF($E$5=select,'Engine Emission Factors'!$I30)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G47)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G47)/2000),0))","v":0}]
[null,"Hexane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C31,'Engine Emission Factors'!$B31),IF($E$5=rg,'Engine Emission Factors'!$E31,IF($E$5=tng,'Engine Emission Factors'!$D31,IF($E$5=ngr,'Engine Emission Factors'!$F31,IF($E$5=ngl,'Engine Emission Factors'!$G31,IF($E$5=ng2l,'Engine Emission Factors'!$H31,IF($E$5=select,'Engine Emission Factors'!$I31)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G48)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G48)/2000),0))","v":0}]
[null,"Methanol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C32,'Engine Emission Factors'!$B32),IF($E$5=rg,'Engine Emission Factors'!$E32,IF($E$5=tng,'Engine Emission Factors'!$D32,IF($E$5=ngr,'Engine Emission Factors'!$F32,IF($E$5=ngl,'Engine Emission Factors'!$G32,IF($E$5=ng2l,'Engine Emission Factors'!$H32,IF($E$5=select,'Engine Emission Factors'!$I32)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G49)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G49)/2000),0))","v":0}]
[null,"Methylene chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C33,'Engine Emission Factors'!$B33),IF($E$5=rg,'Engine Emission Factors'!$E33,IF($E$5=tng,'Engine Emission Factors'!$D33,IF($E$5=ngr,'Engine Emission Factors'!$F33,IF($E$5=ngl,'Engine Emission Factors'!$G33,IF($E$5=ng2l,'Engine Emission Factors'!$H33,IF($E$5=select,'Engine Emission Factors'!$I33)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G50)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G50)/2000),0))","v":0}]
[null,"Naphthalene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C34,'Engine Emission Factors'!$B34),IF($E$5=rg,'Engine Emission Factors'!$E34,IF($E$5=tng,'Engine Emission Factors'!$D34,IF($E$5=ngr,'Engine Emission Factors'!$F34,IF($E$5=ngl,'Engine Emission Factors'!$G34,IF($E$5=ng2l,'Engine Emission Factors'!$H34,IF($E$5=select,'Engine Emission Factors'!$I34)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G51)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G51)/2000),0))","v":0}]
[null,"PAH",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C35,'Engine Emission Factors'!$B35),IF($E$5=rg,'Engine Emission Factors'!$E35,IF($E$5=tng,'Engine Emission Factors'!$D35,IF($E$5=ngr,'Engine Emission Factors'!$F35,IF($E$5=ngl,'Engine Emission Factors'!$G35,IF($E$5=ng2l,'Engine Emission Factors'!$H35,IF($E$5=select,'Engine Emission Factors'!$I35)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G52)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G52)/2000),0))","v":0}]
[null,"Phenol",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C36,'Engine Emission Factors'!$B36),IF($E$5=rg,'Engine Emission Factors'!$E36,IF($E$5=tng,'Engine Emission Factors'!$D36,IF($E$5=ngr,'Engine Emission Factors'!$F36,IF($E$5=ngl,'Engine Emission Factors'!$G36,IF($E$5=ng2l,'Engine Emission Factors'!$H36,IF($E$5=select,'Engine Emission Factors'!$I36)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G53)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G53)/2000),0))","v":0}]
[null,"Styrene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C37,'Engine Emission Factors'!$B37),IF($E$5=rg,'Engine Emission Factors'!$E37,IF($E$5=tng,'Engine Emission Factors'!$D37,IF($E$5=ngr,'Engine Emission Factors'!$F37,IF($E$5=ngl,'Engine Emission Factors'!$G37,IF($E$5=ng2l,'Engine Emission Factors'!$H37,IF($E$5=select,'Engine Emission Factors'!$I37)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G54)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G54)/2000),0))","v":0}]
[null,"Tetrachloroethane",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C38,'Engine Emission Factors'!$B38),IF($E$5=rg,'Engine Emission Factors'!$E38,IF($E$5=tng,'Engine Emission Factors'!$D38,IF($E$5=ngr,'Engine Emission Factors'!$F38,IF($E$5=ngl,'Engine Emission Factors'!$G38,IF($E$5=ng2l,'Engine Emission Factors'!$H38,IF($E$5=select,'Engine Emission Factors'!$I38)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G55)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G55)/2000),0))","v":0}]
[null,"Toluene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C39,'Engine Emission Factors'!$B39),IF($E$5=rg,'Engine Emission Factors'!$E39,IF($E$5=tng,'Engine Emission Factors'!$D39,IF($E$5=ngr,'Engine Emission Factors'!$F39,IF($E$5=ngl,'Engine Emission Factors'!$G39,IF($E$5=ng2l,'Engine Emission Factors'!$H39,IF($E$5=select,'Engine Emission Factors'!$I39)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G56)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G56)/2000),0))","v":0}]
[null,"Vinyl chloride",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C40,'Engine Emission Factors'!$B40),IF($E$5=rg,'Engine Emission Factors'!$E40,IF($E$5=tng,'Engine Emission Factors'!$D40,IF($E$5=ngr,'Engine Emission Factors'!$F40,IF($E$5=ngl,'Engine Emission Factors'!$G40,IF($E$5=ng2l,'Engine Emission Factors'!$H40,IF($E$5=select,'Engine Emission Factors'!$I40)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G57)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G57)/2000),0))","v":0}]
[null,"Xylene",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C41,'Engine Emission Factors'!$B41),IF($E$5=rg,'Engine Emission Factors'!$E41,IF($E$5=tng,'Engine Emission Factors'!$D41,IF($E$5=ngr,'Engine Emission Factors'!$F41,IF($E$5=ngl,'Engine Emission Factors'!$G41,IF($E$5=ng2l,'Engine Emission Factors'!$H41,IF($E$5=select,'Engine Emission Factors'!$I41)))))))","v":0},0,{"$f":"IF(OR($F$8='Data Validation'!$B$39,'Data Validation'!$B$40),(($D$18*$E$18*$G58)/2000),IF($F$8='Data Validation'!$B$38,(($E$18*$G58)/2000),0))","v":0}]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H34:H58)","v":0},{"$f":"SUM(I34:I58)","v":0}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1",null,null,null,"4 See information on insignificant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab."]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 Routine = 24 hr/day * 365 day/yr or 8760 hr/yr; Emergency = 500 hr/yr",null,null,null,"Minn. R. 7007.1300"]

{"sheet":"Potential Emissions","index":7,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,4,1],[2,1,2,8],[0,1,0,8]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"Potential emissions: Engines"]
[null,{"$f":"IF('Data Validation'!B27=\"yes\",\"The flag next to a potential emission total means your potential emissions exceed the permitting threshold and a permit is required.\",\"These pollutant totals represent the information you entered on the blue tabs.\")","v":"These pollutant totals represent the information you entered on the blue tabs."}]
[null,"Pollutant",{"$f":"'Engine 1'!$I$5","v":"Engine 1"},{"$f":"'Engine 2'!$I$5","v":"Engine 2"},{"$f":"'Engine 3'!$I$5","v":"Engine 3"},{"$f":"'Engine 4'!$I$5","v":"Engine 4"},{"$f":"'Engine 5'!$I$5","v":"Engine 5"},"Potential Emissions","Permitting Threshold"]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants",{"$f":"IF('Engine 1'!$J$19=6,\"Insignificant\",\"\")","v":"Insignificant"},{"$f":"IF('Engine 2'!$J$19=6,\"Insignificant\",\"\")","v":"Insignificant"},{"$f":"IF('Engine 3'!$J$19=6,\"Insignificant\",\"\")","v":"Insignificant"},{"$f":"IF('Engine 4'!$J$19=6,\"Insignificant\",\"\")","v":"Insignificant"},{"$f":"IF('Engine 5'!$J$19=6,\"Insignificant\",\"\")","v":"Insignificant"}]
[null,"PM",{"$f":"'Engine 1'!$H20","v":0},{"$f":"'Engine 2'!$H20","v":0},{"$f":"'Engine 3'!$H20","v":0},{"$f":"'Engine 4'!$H20","v":0},{"$f":"'Engine 5'!$H20","v":0},{"$f":"SUM(C7:G7)","v":0},100]
[null,"PM10",{"$f":"'Engine 1'!$H21","v":0},{"$f":"'Engine 2'!$H21","v":0},{"$f":"'Engine 3'!$H21","v":0},{"$f":"'Engine 4'!$H21","v":0},{"$f":"'Engine 5'!$H21","v":0},{"$f":"SUM(C8:G8)","v":0},25]
[null,"PM2.5",{"$f":"'Engine 1'!$H22","v":0},{"$f":"'Engine 2'!$H22","v":0},{"$f":"'Engine 3'!$H22","v":0},{"$f":"'Engine 4'!$H22","v":0},{"$f":"'Engine 5'!$H22","v":0},0,100]
[null,"SOx",{"$f":"'Engine 1'!$H23","v":0},{"$f":"'Engine 2'!$H23","v":0},{"$f":"'Engine 3'!$H23","v":0},{"$f":"'Engine 4'!$H23","v":0},{"$f":"'Engine 5'!$H23","v":0},0,50]
[null,"NOx",{"$f":"'Engine 1'!$H24","v":0},{"$f":"'Engine 2'!$H24","v":0},{"$f":"'Engine 3'!$H24","v":0},{"$f":"'Engine 4'!$H24","v":0},{"$f":"'Engine 5'!$H24","v":0},0,100]
[null,"VOC",{"$f":"'Engine 1'!$H25","v":0},{"$f":"'Engine 2'!$H25","v":0},{"$f":"'Engine 3'!$H25","v":0},{"$f":"'Engine 4'!$H25","v":0},{"$f":"'Engine 5'!$H25","v":0},0,100]
[null,"CO",{"$f":"'Engine 1'!$H26","v":0},{"$f":"'Engine 2'!$H26","v":0},{"$f":"'Engine 3'!$H26","v":0},{"$f":"'Engine 4'!$H26","v":0},{"$f":"'Engine 5'!$H26","v":0},0,100]
[null,"Lead",{"$f":"'Engine 1'!$H27","v":0},{"$f":"'Engine 2'!$H27","v":0},{"$f":"'Engine 3'!$H27","v":0},{"$f":"'Engine 4'!$H27","v":0},{"$f":"'Engine 5'!$H27","v":0},0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",{"$f":"'Engine 1'!$H29","v":0},{"$f":"'Engine 2'!$H29","v":0},{"$f":"'Engine 3'!$H29","v":0},{"$f":"'Engine 4'!$H29","v":0},{"$f":"'Engine 5'!$H29","v":0},0]
[null,"CH4",{"$f":"'Engine 1'!$H30","v":0},{"$f":"'Engine 2'!$H30","v":0},{"$f":"'Engine 3'!$H30","v":0},{"$f":"'Engine 4'!$H30","v":0},{"$f":"'Engine 5'!$H30","v":0},0]
[null,"N2O",{"$f":"'Engine 1'!$H31","v":0},{"$f":"'Engine 2'!$H31","v":0},{"$f":"'Engine 3'!$H31","v":0},{"$f":"'Engine 4'!$H31","v":0},{"$f":"'Engine 5'!$H31","v":0},0]
[null,"GHG total CO2e",null,null,null,null,null,{"$f":"(H16*1)+(H17*25)+(H18*298)","v":0},100000]
[null,"Hazardous Air Pollutants"]
[null,"1,1,2,2-tetrachloroethane",{"$f":"'Engine 1'!$H34","v":0},{"$f":"'Engine 2'!$H34","v":0},{"$f":"'Engine 3'!$H34","v":0},{"$f":"'Engine 4'!$H34","v":0},{"$f":"'Engine 5'!$H34","v":0},{"$f":"SUM(C21:G21)","v":0}]
[null,"1,1,2-trichloroethane",{"$f":"'Engine 1'!$H35","v":0},{"$f":"'Engine 2'!$H35","v":0},{"$f":"'Engine 3'!$H35","v":0},{"$f":"'Engine 4'!$H35","v":0},{"$f":"'Engine 5'!$H35","v":0},{"$f":"SUM(C22:G22)","v":0}]
[null,"1,3-butadiene",{"$f":"'Engine 1'!$H36","v":0},{"$f":"'Engine 2'!$H36","v":0},{"$f":"'Engine 3'!$H36","v":0},{"$f":"'Engine 4'!$H36","v":0},{"$f":"'Engine 5'!$H36","v":0},0]
[null,"1,3-dichloropropene",{"$f":"'Engine 1'!$H37","v":0},{"$f":"'Engine 2'!$H37","v":0},{"$f":"'Engine 3'!$H37","v":0},{"$f":"'Engine 4'!$H37","v":0},{"$f":"'Engine 5'!$H37","v":0},0]
[null,"Acetaldehyde",{"$f":"'Engine 1'!$H38","v":0},{"$f":"'Engine 2'!$H38","v":0},{"$f":"'Engine 3'!$H38","v":0},{"$f":"'Engine 4'!$H38","v":0},{"$f":"'Engine 5'!$H38","v":0},0]
[null,"Acrolein",{"$f":"'Engine 1'!$H39","v":0},{"$f":"'Engine 2'!$H39","v":0},{"$f":"'Engine 3'!$H39","v":0},{"$f":"'Engine 4'!$H39","v":0},{"$f":"'Engine 5'!$H39","v":0},0]
[null,"Benzene",{"$f":"'Engine 1'!$H40","v":0},{"$f":"'Engine 2'!$H40","v":0},{"$f":"'Engine 3'!$H40","v":0},{"$f":"'Engine 4'!$H40","v":0},{"$f":"'Engine 5'!$H40","v":0},0]
[null,"Biphenyl",{"$f":"'Engine 1'!$H41","v":0},{"$f":"'Engine 2'!$H41","v":0},{"$f":"'Engine 3'!$H41","v":0},{"$f":"'Engine 4'!$H41","v":0},{"$f":"'Engine 5'!$H41","v":0},0]
[null,"Carbon tetrachloride",{"$f":"'Engine 1'!$H42","v":0},{"$f":"'Engine 2'!$H42","v":0},{"$f":"'Engine 3'!$H42","v":0},{"$f":"'Engine 4'!$H42","v":0},{"$f":"'Engine 5'!$H42","v":0},0]
[null,"Chlorobenzene",{"$f":"'Engine 1'!$H43","v":0},{"$f":"'Engine 2'!$H43","v":0},{"$f":"'Engine 3'!$H43","v":0},{"$f":"'Engine 4'!$H43","v":0},{"$f":"'Engine 5'!$H43","v":0},0]
[null,"Chloroform",{"$f":"'Engine 1'!$H44","v":0},{"$f":"'Engine 2'!$H44","v":0},{"$f":"'Engine 3'!$H44","v":0},{"$f":"'Engine 4'!$H44","v":0},{"$f":"'Engine 5'!$H44","v":0},0]
[null,"Ethylbenzene",{"$f":"'Engine 1'!$H45","v":0},{"$f":"'Engine 2'!$H45","v":0},{"$f":"'Engine 3'!$H45","v":0},{"$f":"'Engine 4'!$H45","v":0},{"$f":"'Engine 5'!$H45","v":0},0]
[null,"Ethylene dibromide",{"$f":"'Engine 1'!$H46","v":0},{"$f":"'Engine 2'!$H46","v":0},{"$f":"'Engine 3'!$H46","v":0},{"$f":"'Engine 4'!$H46","v":0},{"$f":"'Engine 5'!$H46","v":0},0]
[null,"Formaldehyde",{"$f":"'Engine 1'!$H47","v":0},{"$f":"'Engine 2'!$H47","v":0},{"$f":"'Engine 3'!$H47","v":0},{"$f":"'Engine 4'!$H47","v":0},{"$f":"'Engine 5'!$H47","v":0},0]
[null,"Hexane",{"$f":"'Engine 1'!$H48","v":0},{"$f":"'Engine 2'!$H48","v":0},{"$f":"'Engine 3'!$H48","v":0},{"$f":"'Engine 4'!$H48","v":0},{"$f":"'Engine 5'!$H48","v":0},0]
[null,"Methanol",{"$f":"'Engine 1'!$H49","v":0},{"$f":"'Engine 2'!$H49","v":0},{"$f":"'Engine 3'!$H49","v":0},{"$f":"'Engine 4'!$H49","v":0},{"$f":"'Engine 5'!$H49","v":0},0]
[null,"Methylene chloride",{"$f":"'Engine 1'!$H50","v":0},{"$f":"'Engine 2'!$H50","v":0},{"$f":"'Engine 3'!$H50","v":0},{"$f":"'Engine 4'!$H50","v":0},{"$f":"'Engine 5'!$H50","v":0},0]
[null,"Naphthalene",{"$f":"'Engine 1'!$H51","v":0},{"$f":"'Engine 2'!$H51","v":0},{"$f":"'Engine 3'!$H51","v":0},{"$f":"'Engine 4'!$H51","v":0},{"$f":"'Engine 5'!$H51","v":0},0]
[null,"PAH",{"$f":"'Engine 1'!$H52","v":0},{"$f":"'Engine 2'!$H52","v":0},{"$f":"'Engine 3'!$H52","v":0},{"$f":"'Engine 4'!$H52","v":0},{"$f":"'Engine 5'!$H52","v":0},0]
[null,"Phenol",{"$f":"'Engine 1'!$H53","v":0},{"$f":"'Engine 2'!$H53","v":0},{"$f":"'Engine 3'!$H53","v":0},{"$f":"'Engine 4'!$H53","v":0},{"$f":"'Engine 5'!$H53","v":0},0]
[null,"Styrene",{"$f":"'Engine 1'!$H54","v":0},{"$f":"'Engine 2'!$H54","v":0},{"$f":"'Engine 3'!$H54","v":0},{"$f":"'Engine 4'!$H54","v":0},{"$f":"'Engine 5'!$H54","v":0},0]
[null,"Tetrachloroethane",{"$f":"'Engine 1'!$H55","v":0},{"$f":"'Engine 2'!$H55","v":0},{"$f":"'Engine 3'!$H55","v":0},{"$f":"'Engine 4'!$H55","v":0},{"$f":"'Engine 5'!$H55","v":0},0]
[null,"Toluene",{"$f":"'Engine 1'!$H56","v":0},{"$f":"'Engine 2'!$H56","v":0},{"$f":"'Engine 3'!$H56","v":0},{"$f":"'Engine 4'!$H56","v":0},{"$f":"'Engine 5'!$H56","v":0},0]
[null,"Vinyl chloride",{"$f":"'Engine 1'!$H57","v":0},{"$f":"'Engine 2'!$H57","v":0},{"$f":"'Engine 3'!$H57","v":0},{"$f":"'Engine 4'!$H57","v":0},{"$f":"'Engine 5'!$H57","v":0},0]
[null,"Xylene",{"$f":"'Engine 1'!$H58","v":0},{"$f":"'Engine 2'!$H58","v":0},{"$f":"'Engine 3'!$H58","v":0},{"$f":"'Engine 4'!$H58","v":0},{"$f":"'Engine 5'!$H58","v":0},0]
[null,"HAP Indiv. Max",{"$f":"IF(H46=H21,B21,IF(H46=H22,B22,IF(H46=H23,B23,IF(H46=H24,B24,IF(H46=H25,B25,IF(H46=H26,B26,IF(H46=H27,B27,IF(H46=H28,B28,IF(H46=H29,B29,IF(H46=H30,B30,IF(H46=H31,B31,IF(H46=H32,B32,IF(H46=H33,B33,IF(H46=H34,B34,IF(H46=H35,B35,IF(H46=H36,B36,IF(H46=H37,B37,IF(H46=H38,B38,IF(H46=H39,B39,IF(H46=H40,B40,IF(H46=H41,B41,IF(H46=H42,B42,IF(H46=H43,B43,IF(H46=H44,B44,IF(H46=H45,B45)))))))))))))))))))))))))","v":"1,1,2,2-tetrachloroethane"},null,null,null,null,{"$f":"MAX(H21:H45)","v":0},10]
[null,"HAP total",null,null,null,null,null,{"$f":"SUM(H21:H45)","v":0},25]

{"sheet":"Actual Emissions","index":8,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,4,1],[0,1,0,8],[2,1,2,8]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"Actual emissions: Engines"]
[null,{"$f":"IF('Data Validation'!B30=\"yes\",\"The flag next to your actual emissions total indicates that your business exceeds the Option D limit and an individual permit is required.\",\"These pollutant totals represent the information you entered on the blue tabs.\")","v":"These pollutant totals represent the information you entered on the blue tabs."}]
[null,"Pollutant","Engine 1","Engine 2","Engine 3","Engine 4","Engine 5","Actual Emissions","Opt. D Permit Limits"]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants"]
[null,"PM",{"$f":"'Engine 1'!$I20","v":0},{"$f":"'Engine 2'!$I20","v":0},{"$f":"'Engine 3'!$I20","v":0},{"$f":"'Engine 4'!$I20","v":0},{"$f":"'Engine 5'!$I20","v":0},{"$f":"SUM(C7:G7)","v":0},50]
[null,"PM10",{"$f":"'Engine 1'!$I21","v":0},{"$f":"'Engine 2'!$I21","v":0},{"$f":"'Engine 3'!$I21","v":0},{"$f":"'Engine 4'!$I21","v":0},{"$f":"'Engine 5'!$I21","v":0},{"$f":"SUM(C8:G8)","v":0},50]
[null,"PM2.5",{"$f":"'Engine 1'!$I22","v":0},{"$f":"'Engine 2'!$I22","v":0},{"$f":"'Engine 3'!$I22","v":0},{"$f":"'Engine 4'!$I22","v":0},{"$f":"'Engine 5'!$I22","v":0},0,50]
[null,"SOx",{"$f":"'Engine 1'!$I23","v":0},{"$f":"'Engine 2'!$I23","v":0},{"$f":"'Engine 3'!$I23","v":0},{"$f":"'Engine 4'!$I23","v":0},{"$f":"'Engine 5'!$I23","v":0},0,50]
[null,"NOx",{"$f":"'Engine 1'!$I24","v":0},{"$f":"'Engine 2'!$I24","v":0},{"$f":"'Engine 3'!$I24","v":0},{"$f":"'Engine 4'!$I24","v":0},{"$f":"'Engine 5'!$I24","v":0},0,50]
[null,"VOC",{"$f":"'Engine 1'!$I25","v":0},{"$f":"'Engine 2'!$I25","v":0},{"$f":"'Engine 3'!$I25","v":0},{"$f":"'Engine 4'!$I25","v":0},{"$f":"'Engine 5'!$I25","v":0},0,50]
[null,"CO",{"$f":"'Engine 1'!$I26","v":0},{"$f":"'Engine 2'!$I26","v":0},{"$f":"'Engine 3'!$I26","v":0},{"$f":"'Engine 4'!$I26","v":0},{"$f":"'Engine 5'!$I26","v":0},0,50]
[null,"Lead",{"$f":"'Engine 1'!$I27","v":0},{"$f":"'Engine 2'!$I27","v":0},{"$f":"'Engine 3'!$I27","v":0},{"$f":"'Engine 4'!$I27","v":0},{"$f":"'Engine 5'!$I27","v":0},0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",{"$f":"'Engine 1'!$I29","v":0},{"$f":"'Engine 2'!$I29","v":0},{"$f":"'Engine 3'!$I29","v":0},{"$f":"'Engine 4'!$I29","v":0},{"$f":"'Engine 5'!$I29","v":0},{"$f":"SUM(C16:G16)","v":0}]
[null,"CH4",{"$f":"'Engine 1'!$I30","v":0},{"$f":"'Engine 2'!$I30","v":0},{"$f":"'Engine 3'!$I30","v":0},{"$f":"'Engine 4'!$I30","v":0},{"$f":"'Engine 5'!$I30","v":0},0]
[null,"N2O",{"$f":"'Engine 1'!$I31","v":0},{"$f":"'Engine 2'!$I31","v":0},{"$f":"'Engine 3'!$I31","v":0},{"$f":"'Engine 4'!$I31","v":0},{"$f":"'Engine 5'!$I31","v":0},0]
[null,"GHG Total CO2e",null,null,null,null,null,0,50000]
[null,"Hazardous Air Pollutants"]
[null,"1,1,2,2-tetrachloroethane",{"$f":"'Engine 1'!$I34","v":0},{"$f":"'Engine 2'!$I34","v":0},{"$f":"'Engine 3'!$I34","v":0},{"$f":"'Engine 4'!$I34","v":0},{"$f":"'Engine 5'!$I34","v":0},{"$f":"SUM(C21:G21)","v":0}]
[null,"1,1,2-trichloroethane",{"$f":"'Engine 1'!$I35","v":0},{"$f":"'Engine 2'!$I35","v":0},{"$f":"'Engine 3'!$I35","v":0},{"$f":"'Engine 4'!$I35","v":0},{"$f":"'Engine 5'!$I35","v":0},{"$f":"SUM(C22:G22)","v":0}]
[null,"1,3-butadiene",{"$f":"'Engine 1'!$I36","v":0},{"$f":"'Engine 2'!$I36","v":0},{"$f":"'Engine 3'!$I36","v":0},{"$f":"'Engine 4'!$I36","v":0},{"$f":"'Engine 5'!$I36","v":0},0]
[null,"1,3-dichloropropene",{"$f":"'Engine 1'!$I37","v":0},{"$f":"'Engine 2'!$I37","v":0},{"$f":"'Engine 3'!$I37","v":0},{"$f":"'Engine 4'!$I37","v":0},{"$f":"'Engine 5'!$I37","v":0},0]
[null,"Acetaldehyde",{"$f":"'Engine 1'!$I38","v":0},{"$f":"'Engine 2'!$I38","v":0},{"$f":"'Engine 3'!$I38","v":0},{"$f":"'Engine 4'!$I38","v":0},{"$f":"'Engine 5'!$I38","v":0},0]
[null,"Acrolein",{"$f":"'Engine 1'!$I39","v":0},{"$f":"'Engine 2'!$I39","v":0},{"$f":"'Engine 3'!$I39","v":0},{"$f":"'Engine 4'!$I39","v":0},{"$f":"'Engine 5'!$I39","v":0},0]
[null,"Benzene",{"$f":"'Engine 1'!$I40","v":0},{"$f":"'Engine 2'!$I40","v":0},{"$f":"'Engine 3'!$I40","v":0},{"$f":"'Engine 4'!$I40","v":0},{"$f":"'Engine 5'!$I40","v":0},0]
[null,"Biphenyl",{"$f":"'Engine 1'!$I41","v":0},{"$f":"'Engine 2'!$I41","v":0},{"$f":"'Engine 3'!$I41","v":0},{"$f":"'Engine 4'!$I41","v":0},{"$f":"'Engine 5'!$I41","v":0},0]
[null,"Carbon tetrachloride",{"$f":"'Engine 1'!$I42","v":0},{"$f":"'Engine 2'!$I42","v":0},{"$f":"'Engine 3'!$I42","v":0},{"$f":"'Engine 4'!$I42","v":0},{"$f":"'Engine 5'!$I42","v":0},0]
[null,"Chlorobenzene",{"$f":"'Engine 1'!$I43","v":0},{"$f":"'Engine 2'!$I43","v":0},{"$f":"'Engine 3'!$I43","v":0},{"$f":"'Engine 4'!$I43","v":0},{"$f":"'Engine 5'!$I43","v":0},0]
[null,"Chloroform",{"$f":"'Engine 1'!$I44","v":0},{"$f":"'Engine 2'!$I44","v":0},{"$f":"'Engine 3'!$I44","v":0},{"$f":"'Engine 4'!$I44","v":0},{"$f":"'Engine 5'!$I44","v":0},0]
[null,"Ethylbenzene",{"$f":"'Engine 1'!$I45","v":0},{"$f":"'Engine 2'!$I45","v":0},{"$f":"'Engine 3'!$I45","v":0},{"$f":"'Engine 4'!$I45","v":0},{"$f":"'Engine 5'!$I45","v":0},0]
[null,"Ethylene dibromide",{"$f":"'Engine 1'!$I46","v":0},{"$f":"'Engine 2'!$I46","v":0},{"$f":"'Engine 3'!$I46","v":0},{"$f":"'Engine 4'!$I46","v":0},{"$f":"'Engine 5'!$I46","v":0},0]
[null,"Formaldehyde",{"$f":"'Engine 1'!$I47","v":0},{"$f":"'Engine 2'!$I47","v":0},{"$f":"'Engine 3'!$I47","v":0},{"$f":"'Engine 4'!$I47","v":0},{"$f":"'Engine 5'!$I47","v":0},0]
[null,"Hexane",{"$f":"'Engine 1'!$I48","v":0},{"$f":"'Engine 2'!$I48","v":0},{"$f":"'Engine 3'!$I48","v":0},{"$f":"'Engine 4'!$I48","v":0},{"$f":"'Engine 5'!$I48","v":0},0]
[null,"Methanol",{"$f":"'Engine 1'!$I49","v":0},{"$f":"'Engine 2'!$I49","v":0},{"$f":"'Engine 3'!$I49","v":0},{"$f":"'Engine 4'!$I49","v":0},{"$f":"'Engine 5'!$I49","v":0},0]
[null,"Methylene chloride",{"$f":"'Engine 1'!$I50","v":0},{"$f":"'Engine 2'!$I50","v":0},{"$f":"'Engine 3'!$I50","v":0},{"$f":"'Engine 4'!$I50","v":0},{"$f":"'Engine 5'!$I50","v":0},0]
[null,"Naphthalene",{"$f":"'Engine 1'!$I51","v":0},{"$f":"'Engine 2'!$I51","v":0},{"$f":"'Engine 3'!$I51","v":0},{"$f":"'Engine 4'!$I51","v":0},{"$f":"'Engine 5'!$I51","v":0},0]
[null,"PAH",{"$f":"'Engine 1'!$I52","v":0},{"$f":"'Engine 2'!$I52","v":0},{"$f":"'Engine 3'!$I52","v":0},{"$f":"'Engine 4'!$I52","v":0},{"$f":"'Engine 5'!$I52","v":0},0]
[null,"Phenol",{"$f":"'Engine 1'!$I53","v":0},{"$f":"'Engine 2'!$I53","v":0},{"$f":"'Engine 3'!$I53","v":0},{"$f":"'Engine 4'!$I53","v":0},{"$f":"'Engine 5'!$I53","v":0},0]
[null,"Styrene",{"$f":"'Engine 1'!$I54","v":0},{"$f":"'Engine 2'!$I54","v":0},{"$f":"'Engine 3'!$I54","v":0},{"$f":"'Engine 4'!$I54","v":0},{"$f":"'Engine 5'!$I54","v":0},0]
[null,"Tetrachloroethane",{"$f":"'Engine 1'!$I55","v":0},{"$f":"'Engine 2'!$I55","v":0},{"$f":"'Engine 3'!$I55","v":0},{"$f":"'Engine 4'!$I55","v":0},{"$f":"'Engine 5'!$I55","v":0},0]
[null,"Toluene",{"$f":"'Engine 1'!$I56","v":0},{"$f":"'Engine 2'!$I56","v":0},{"$f":"'Engine 3'!$I56","v":0},{"$f":"'Engine 4'!$I56","v":0},{"$f":"'Engine 5'!$I56","v":0},0]
[null,"Vinyl chloride",{"$f":"'Engine 1'!$I57","v":0},{"$f":"'Engine 2'!$I57","v":0},{"$f":"'Engine 3'!$I57","v":0},{"$f":"'Engine 4'!$I57","v":0},{"$f":"'Engine 5'!$I57","v":0},0]
[null,"Xylene",{"$f":"'Engine 1'!$I58","v":0},{"$f":"'Engine 2'!$I58","v":0},{"$f":"'Engine 3'!$I58","v":0},{"$f":"'Engine 4'!$I58","v":0},{"$f":"'Engine 5'!$I58","v":0},0]
[null,"HAP Indiv. Max",{"$f":"IF(H46=H21,B21,IF(H46=H22,B22,IF(H46=H23,B23,IF(H46=H24,B24,IF(H46=H25,B25,IF(H46=H26,B26,IF(H46=H27,B27,IF(H46=H28,B28,IF(H46=H29,B29,IF(H46=H30,B30,IF(H46=H31,B31,IF(H46=H32,B32,IF(H46=H33,B33,IF(H46=H34,B34,IF(H46=H35,B35,IF(H46=H36,B36,IF(H46=H37,B37,IF(H46=H38,B38,IF(H46=H39,B39,IF(H46=H40,B40,IF(H46=H41,B41,IF(H46=H42,B42,IF(H46=H43,B43,IF(H46=H44,B44,IF(H46=H45,B45)))))))))))))))))))))))))","v":"1,1,2,2-tetrachloroethane"},null,null,null,null,{"$f":"MAX(H21:H45)","v":0},5]
[null,"HAP total",null,null,null,null,null,{"$f":"SUM(H21:H45)","v":0},12.5]

{"sheet":"Permits & Requirements","index":9,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[37,1,37,8],[26,1,26,2],[26,3,26,4],[27,2,27,8],[28,2,28,8],[29,2,30,8],[31,1,33,8],[34,1,35,8],[45,2,45,3],[45,4,45,6],[38,2,38,8],[39,2,39,8],[40,2,40,8],[41,2,41,8],[42,2,42,6],[43,2,43,8],[44,2,44,6],[0,1,0,8],[2,1,4,8],[8,1,8,4],[8,5,16,8],[9,1,9,4],[10,1,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4],[13,2,14,2],[13,3,14,3],[13,4,14,4],[15,1,16,1],[15,2,16,2],[13,1,14,1],[15,3,16,3],[1,1,1,8],[15,4,16,4],[17,5,17,6],[18,4,23,4],[22,7,23,7],[22,8,23,8],[24,1,24,8],[18,3,22,3],[5,1,6,8],[18,1,19,1],[18,2,19,2],[20,8,21,8],[20,7,21,7],[20,1,21,1],[20,2,21,2],[22,1,23,1],[22,2,23,2],[18,5,19,6],[20,5,21,6],[22,5,23,6],[18,7,19,7],[18,8,19,8]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
[null,"Permits and requirements"]
[null,"The need for a permit is based on your entire business's potential air emissions. All activities that put pollutants into the air (including paint and solvent use, woodworking, metalworking) need to be assessed in addition to the engines included in this calculator. Once you determine if you need a permit, based on whether an NSPS applies and your total potential emissions, you can then use your actual emissions to see which permit is the best fit for your business."]
[]
[]
[null,"Content below is based on the information entered into this calculator and is not an official MPCA permit determination."]
[]
[]
[null,"Is a permit required?",null,null,null,"What type of permit?\nAssumes all air pollutant activities are entered into this calculator.\nIf you have additional air emission sources, the recommendation below cannot be used. You must assess your facility's total potential emissions from all sources to identify your permitting needs."]
[null,"The summary below is based on information you entered in the blue tabs. "]
[null,"Your business's potential emissions from engines","Your business's actual emissions from engines","A federal NSPS for engines","A federal NESHAP for engines"]
[]
[]
[null,{"$f":"IF('Data Validation'!B27=\"yes\",\"does\",\"does not\")","v":"does not"},{"$f":"IF('Data Validation'!B30=\"yes\",\"does\",\"does not\")","v":"does not"},{"$f":"IF('Data Validation'!B11>0,\"no response, go to Federal Standards tab\",IF(AND('Data Validation'!B11=0,'Data Validation'!B6>0),\"does\",\"does not\"))","v":"no response, go to Federal Standards tab"},{"$f":"IF('Data Validation'!B21>0,\"no response, go to Federal Standards tab\",IF(AND('Data Validation'!B21=0,'Data Validation'!B16>0),\"does\",\"does not\"))","v":"no response, go to Federal Standards tab"}]
[]
[null,"exceed permit thresholds","exceed Option D limits","apply to your business","apply to your business"]
[]
[null,"Potential emissions from engines exceeds permit thresholds","Actual emissions from engines exceeds Option D limits","Federal NSPS for engines applies?","Federal NESHAP for engines applies?","Which permit do you need?",null,"More Information ","Forms"]
[null,"no","n/a","Applicability of NSPS IIII or JJJJ does not1 indicate a need for a permit as provided by ","Applicability of a NESHAP does not determine if a permit is required.","Below permit thresholds",null,"n/a","n/a"]
[]
[null,"yes","no",null,null,"Registration Option D",null,"Info about Air Registration Permits","Application Forms, scroll to Section 3"]
[]
[null,"yes","yes",null,null,"Other state or federal permit",null,"Info about Air Permits","Application Forms, scroll to Section 1"]
[null,null,null,"Minn. R. 7007.0300"]
[null,"1 If your engine did not rely on performance testing to demonstrate NSPS compliance and any compression ignition engines are less than 30 liters per cylinder."]
[]
[null,"Types of insignificant activities",null,"Minn. R. 7007.1300"]
[null,"subp. 2","Not required to be listed."]
[null,"supb. 3","Required to be listed but emissions do not need to be included in total facility emission calculations, unless requested by MPCA."]
[null,"subp. 4","Required to be listed if applying for a Part 70 (Federal permit or federally enforceable permit limits) but emissions do not need to be included in total facility emission calculations, unless requested by MPCA."]
[]
[null,"If emissions units listed in 7007.1300 are subject to additional requirements under section 114(a)(3) of the act (Monitoring Requirements) or section 112 of the act (Hazardous Air Pollutants), or if part of a title I modification, or, if accounted for, make a stationary source subject to a part 70 permit, emissions from the emissions units must be calculated in the permit application."]
[]
[]
[null,"If all emission points are insignificant and total emissions do not exceed permitting thresholds, a permit is not required. Comply with any applicable regulations. "]
[]
[]
[null,"Stack Height Determination"]
[null,"Required if:","1) Installing a non-emergency engine, including insignificant activities, or"]
[null,null,"2) There are existing non-emergency engines installed after January 1, 2000, or"]
[null,null,"3) Installing any permit-required engine, including emergency engines."]
[null,"How:","Use the EPA SCREEN3 program to enter engine and site-specific information to identify the necessary stack height for the engine at:"]
[null,null,"https://www.epa.gov/scram/air-quality-dispersion-modeling-screening-models#screen3"]
[null,null,"See input requirements and instructions on modeling more than one engine on the MPCA Form EC-03. "]
[null,null,"https://www.pca.state.mn.us/sites/default/files/aq-f1-ec03.doc"]
[null,"Resource:","MPCA air permits webpage for engines at:",null,"https://www.pca.state.mn.us/air/engines"]

{"sheet":"Engine Emission Factors","index":10,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,0,1,7],[0,0,0,7],[52,1,52,4]]}
[{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
["Engine emission factors"]
[null,"RECIPROCATING ENGINES (<600HP) DIESEL (lb/MMBtu)","RECIPROCATING ENGINES (>=600HP) DIESEL (lb/MMBtu)1","TURBINE ENGINES (electrical generation) NATURAL GAS (lb/MMBtu)1","RECIPROCATING GASOLINE (lb/MMBtu)2","RECIPROCATING Natural Gas 4-Stroke  Rich-Burn (lb/MMBtu)","RECIPROCATING Natural Gas 4-Stroke Lean-Burn (lb/MMBtu)","RECIPROCATING Natural Gas 2-Stroke Lean-Burn (lb/MMBtu)"]
["source","AP42 Chpt 3.3 (10/96)","AP42 Chpt 3.4 (10/96)","AP42 Chpt 3.1 (4/00)","AP42 Chpt 3.3 (10/96)","AP42 Chpt 3.2-3 (7/00)","AP42 Chpt 3.2-2 (7/00)","AP42 Chpt 3.2-2 (7/00)"]
["PM",0.31,0.1,6.6E-3,0.1,{"$f":"0.0095+0.00991","v":1.941E-2},{"$f":"0.0000771+0.00991","v":9.9871000000000005E-3},{"$f":"0.0384+0.00991","v":4.8309999999999999E-2}]
["PM10",0.31,{"$f":"0.0496+0.0077","v":5.7299999999999997E-2},{"$f":"0.0019+0.0047","v":6.6E-3},0.1,{"$f":"0.0095+0.00991","v":1.941E-2},{"$f":"G5","v":9.9871000000000005E-3},{"$f":"H5","v":4.8309999999999999E-2}]
["PM2.5",0.31,{"$f":"0.0479+0.0077","v":5.5599999999999997E-2},{"$f":"D6","v":6.6E-3},0.1,{"$f":"F6","v":1.941E-2},{"$f":"G5","v":9.9871000000000005E-3},{"$f":"H6","v":4.8309999999999999E-2}]
["SOx",0.28999999999999998,1.01,0.94,8.4000000000000005E-2,5.8799999999999998E-4,5.8799999999999998E-4,5.8799999999999998E-4]
["NOx",4.41,3.2,0.32,1.63,2.21,4.08,3.17]
["VOC",{"$f":"0.35+0+0.01+0","v":0.36},0.09,2.0999999999999999E-3,{"$f":"2.1+0.09+0.69+0.15","v":3.03},2.9600000000000001E-2,0.11799999999999999,0.12]
["CO",0.95,0.85,8.2000000000000003E-2,0.99,3.72,0.317,0.38600000000000001]
["40 CFR 98, subp. C, Table C-1 and C-2",null,null,null,null,null,null," "]
["CO2",{"$f":"B48","v":163.05402211679217},{"$f":"B48","v":163.05402211679217},{"$f":"B47","v":116.97737173495123},{"$f":"B49","v":154.80872678530486},{"$f":"B47","v":116.97737173495123},{"$f":"B47","v":116.97737173495123},{"$f":"G13","v":116.97737173495123}]
["CH4",{"$f":"C48","v":6.6138732605513324E-3},{"$f":"C48","v":6.6138732605513324E-3},{"$f":"C47","v":2.2046244201837776E-3},{"$f":"C49","v":6.6138732605513324E-3},{"$f":"C47","v":2.2046244201837776E-3},{"$f":"C47","v":2.2046244201837776E-3},{"$f":"G14","v":2.2046244201837776E-3}]
["N2O",{"$f":"D48","v":1.3227746521102665E-3},{"$f":"D48","v":1.3227746521102665E-3},{"$f":"D47","v":2.2046244201837776E-4},{"$f":"D49","v":1.3227746521102665E-3},{"$f":"D47","v":2.2046244201837776E-4},{"$f":"D47","v":2.2046244201837776E-4},2.2046244201837776E-4]
["source (same as criteria)",null,null,null,"HAPs from Diesel<600HP",null,null," "]
["1,1,2,2-tetrachloroethane",null,null,null,null,2.5299999999999998E-5,4.0000000000000003E-5,6.6299999999999999E-5]
["1,1,2-trichloroethane",null,null,null,null,1.5299999999999999E-5,3.18E-5,5.27E-5]
["1,3-butadiene",3.9100000000000002E-5,null,4.3000000000000001E-7,3.9100000000000002E-5,6.6299999999999996E-4,2.6699999999999998E-4,8.1999999999999998E-4]
["1,3-dichloropropene",null,null,null,null,1.27E-5,2.6400000000000001E-5,4.3800000000000001E-5]
["Acetaldehyde",7.67E-4,2.5199999999999999E-5,4.0000000000000003E-5,{"$f":"B21","v":7.67E-4},2.7899999999999999E-3,8.3599999999999994E-3,7.7600000000000004E-3]
["Acrolein",9.2499999999999999E-5,7.8800000000000008E-6,6.3999999999999997E-6,{"$f":"B22","v":9.2499999999999999E-5},2.63E-3,5.1399999999999996E-3,7.7799999999999996E-3]
["Benzene",9.3300000000000002E-4,7.76E-4,1.2E-5,{"$f":"B23","v":9.3300000000000002E-4},1.58E-3,4.4000000000000002E-4,1.9400000000000001E-3]
["Biphenyl",null,null,null,null,null,2.12E-4,3.9500000000000003E-6]
["Carbon tetrachloride",null,null,null,null,1.77E-5,3.6699999999999998E-5,6.0699999999999998E-5]
["Chlorobenzene",null,null,null,null,1.29E-5,3.04E-5,4.4400000000000002E-5]
["Chloroform",null,null,null,null,1.3699999999999999E-5,2.8500000000000002E-5,4.71E-5]
["Ethylbenzene",null,null,3.1999999999999999E-5,null,2.48E-5,3.9700000000000003E-5,1.08E-4]
["Ethylene dibromide",null,null,null,null,2.1299999999999999E-5,4.4299999999999999E-5,7.3399999999999995E-5]
["Formaldehyde",1.1800000000000001E-3,7.8899999999999993E-5,7.1000000000000002E-4,{"$f":"B30","v":1.1800000000000001E-3},2.0500000000000001E-2,5.28E-2,5.5199999999999999E-2]
["Hexane",null,null,null,null,null,1.1100000000000001E-3,4.4499999999999997E-4]
["Methanol",null,null,null,null,3.0599999999999998E-3,2.5000000000000001E-3,2.48E-3]
["Methylene chloride",null,null,null,null,4.1199999999999999E-5,2.0000000000000002E-5,1.47E-4]
["Naphthalene",8.4800000000000001E-5,1.2999999999999999E-4,1.3E-6,{"$f":"B34","v":8.4800000000000001E-5},9.7100000000000002E-5,7.4400000000000006E-5,9.6299999999999996E-5]
["PAH",1.6799999999999999E-4,2.12E-4,2.2000000000000001E-6,1.6799999999999999E-4,1.4100000000000001E-4,2.69E-5,1.34E-4]
["Phenol",null,null,null,null,null,2.4000000000000001E-5,4.21E-5]
["Styrene",null,null,null,null,1.19E-5,2.3600000000000001E-5,5.4799999999999997E-5]
["Tetrachloroethane",null,null,null,null,null,2.48E-6]
["Toluene",4.0900000000000002E-4,2.81E-4,1.2999999999999999E-4,{"$f":"B39","v":4.0900000000000002E-4},5.5800000000000001E-4,4.08E-4,9.6299999999999999E-4]
["Vinyl chloride",null,null,null,null,7.1799999999999999E-6,1.49E-5,2.4700000000000001E-5]
["Xylene",2.8499999999999999E-4,1.93E-4,6.3999999999999997E-5,{"$f":"B41","v":2.8499999999999999E-4},1.95E-4,1.84E-4,2.6800000000000001E-4]
[1,"SOx emission factor given is multiplied by the sulfur content in the fuel (in percent) in the Engine (n) tabs."]
[2,"All particulate is assumed to be less than or equal to 1 micrometer in size. "]
[]
[]
["Fuel","CO2 Emission Factor3\n(lbs/million BTU)","CH4 Emission Factor3\n(lbs/million BTU)","N2O Emission Factor3\n(lbs/million BTU)","Source for Emission Factors","Brake-specific fuel consumption \n(btu/hp*hr)4","Heat value\n(Btu/scf)","Heat Value 5\n(Btu/gal)"]
["NATURAL GAS",{"$f":"53.06/0.453592","v":116.97737173495123},{"$f":"0.001/0.453592","v":2.2046244201837776E-3},{"$f":"0.0001/0.453592","v":2.2046244201837776E-4},"40 CFR 98, subp. C, Table C-1",null,1020]
["DISTILLATE OIL 2",{"$f":"73.96/0.453592","v":163.05402211679217},{"$f":"0.003/0.453592","v":6.6138732605513324E-3},{"$f":"0.0006/0.453592","v":1.3227746521102665E-3},"40 CFR 98, subp. C, Table C-1",7000,null,{"$f":"0.138*1000000","v":138000}]
["GASOLINE",{"$f":"70.22/0.453592","v":154.80872678530486},{"$f":"C48","v":6.6138732605513324E-3},{"$f":"D48","v":1.3227746521102665E-3},"40 CFR 98, subp. C, Table C-1",7000,null,125000]
[3,"(1 lb = 0.453592 kg)"]
[4,"An average brake-specific fuel consumption of 7,000 Btu/hp-hr was assumed to convert from lb/MMBtu to lb/hp-hr (see AP42 Chpt 3.3)."]
[null,"7000 btu/hp*hr x GHG EF (lb/E6BTU)= lb GHG/hp*hr"]
[5,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2"]
[null,null,null,null,null," "]

{"sheet":"Data Validation","index":11,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
[{"$f":"Instructions!O4","v":"p-sbap5-25  •  9/3/19"}]
["Data Validation"]
[]
["Engines","Equation/reference"]
["Engine and Fuel Type","NSPS applies"]
["Choose one",{"$f":"SUM(B7:B8)","v":0}]
["Reciprocating - diesel",{"$f":"COUNTIF('Federal Standards'!N15,\"Yes\")","v":0}]
["Reciprocating - gasoline"]
["Turbine - natural gas"]
["Recip - nat gas 4-stroke rich burn","NSPS no selection"]
["Recip - nat gas 4-stroke lean burn",{"$f":"SUM(B12:B13)","v":1}]
["Recip - nat gas 2-stroke lean burn",{"$f":"COUNTIF('Federal Standards'!N15,\"Choose Y/N\")","v":1}]
[]
[]
["Engine Use","NESHAP applies"]
["Choose one",{"$f":"SUM(B17:B18)","v":0}]
["Routine",{"$f":"COUNTIF('Federal Standards'!N24,\"Yes\")","v":0}]
["Emergency"]
[]
[null,"NESHAP no selection"]
["Input Value",{"$f":"SUM(B22:B23)","v":1}]
["Choose one",{"$f":"COUNTIF('Federal Standards'!N24,\"Choose Y/N\")","v":1}]
["Horsepower(HP) or Brake Power (HP-hr)"]
["Standard cubic feet/hr (scf/hr)"]
[]
[null,"Potential Exceed"]
["Fuel Conversion",{"$f":"IF(OR('Potential Emissions'!H7>=100,OR('Potential Emissions'!H8>=25,OR('Potential Emissions'!H9>=100,OR('Potential Emissions'!H10>=50,OR('Potential Emissions'!H11>=100,OR('Potential Emissions'!H12>=100,OR('Potential Emissions'!H13>=100,OR('Potential Emissions'!H14>=0.5,OR('Potential Emissions'!H19>=100000,OR('Potential Emissions'!H46>=10,'Potential Emissions'!H47>=25)))))))))),\"yes\",\"no\")","v":"no"}]
["Brake specific fuel consumption"]
["Heat value of fuel","Actual Exceed"]
[null,{"$f":"IF(OR('Actual Emissions'!H7>=50,OR('Actual Emissions'!H8>=50,OR('Actual Emissions'!H9>=50,OR('Actual Emissions'!H10>=50,OR('Actual Emissions'!H11>=50,OR('Actual Emissions'!H12>=50,OR('Actual Emissions'!H13>=50,OR('Actual Emissions'!H14>=0.5,OR('Actual Emissions'!H19>=50000,OR('Actual Emissions'!H46>=5,'Actual Emissions'!H47>=12.5)))))))))),\"yes\",\"no\")","v":"no"}]
[]
["General selection","Choose one to calculate actual emissions"]
["Response","Number of hours operated per 12 months"]
["Choose Y/N","Quantity of fuel actually burned per 12 months"]
["Yes"]
["No"]
[null,"Actual emissions entry"]
[null,"hours per year (hr/yr)"]
[null,"million Btu per year (MMBtu/yr)"]
[null,"gallons per year (gal/yr)"]