{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Instructions","Federal standards","State rules","Hot mix asphalt","Load out and silos","Generator","Natural gas (auxilary heat)","Propane (auxilary heat)","Fugitive","Potential emissions","Actual emissions","Permits & requirements","Hot mix emission factors","Engine Emission Factors","Data Validation"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":49,"comments":4,"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":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,6,0,14],[0,1,3,5],[13,2,13,14],[14,2,14,14],[4,1,4,14],[12,1,12,14],[6,1,6,14],[9,1,9,14],[7,1,7,14],[8,1,8,14],[5,1,5,14],[10,1,11,14],[15,2,15,14],[16,2,16,14],[17,2,17,14],[18,2,18,14],[19,1,19,13],[20,1,20,13],[27,4,27,8],[29,1,29,2],[25,2,25,3],[25,4,25,14],[21,1,21,14],[23,1,23,14],[22,1,22,14],[24,2,24,3],[24,5,24,8],[29,3,29,8]]}
[null,null,null,null,null,null,"Hot mix asphalt\nair emissions calculator"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p-sbap5-20  •  4/8/19"]
[]
[null,"Instructions"]
[null,"1) Begin with the first blue tab. "]
[null,"2) Use the blue tabs across the bottom to enter information for your business."]
[null,"3) The green tabs total all 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) You can use the blue tabs to calculate your actual emissions for the air emission inventory, a report due annually if you have an air permit. "]
[]
[]
[null,"Color key"]
[null,"Blue","Enter information for your facility in the blue boxes."]
[null,"White","Do not change the values/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 blue boxes."]
[null,"Yellow","Permit and insignificant activity thresholds."]
[null,"Orange","Orange boxes are filled with standard values. You may change them if you have test results that provide data specific to your site."]
[null,"Blue Text","Key information"]
[]
[]
[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:",null,"https://www.pca.state.mn.us/regulations/hot-mix-asphalt"]

{"sheet":"Federal standards","index":1,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[56,13,57,14],[51,13,55,14],[24,4,24,9],[40,1,40,12],[42,1,43,12],[44,1,44,12],[38,1,38,12],[36,2,36,12],[37,13,38,14],[37,2,37,12],[28,4,28,10],[50,1,50,12],[50,13,50,14],[53,2,53,12],[46,13,47,14],[47,1,48,12],[16,1,16,12],[19,1,19,12],[35,1,35,12],[46,10,46,11],[46,2,46,9],[26,4,26,5],[27,4,27,10],[26,6,26,8],[41,1,41,12],[29,1,30,12],[25,6,25,8],[42,13,45,14],[6,14,11,14],[7,1,8,1],[7,2,8,13],[9,1,11,1],[32,13,36,14],[9,2,11,13],[20,1,20,2],[20,3,20,5],[21,3,21,7],[17,2,17,12],[18,2,18,12],[12,1,12,14],[13,1,13,14],[3,1,5,7],[3,8,5,14],[20,6,20,12],[34,2,34,8],[34,9,34,12],[14,1,14,14],[20,13,21,14],[21,1,21,2],[15,1,15,12],[15,13,15,14],[33,2,33,7],[31,1,31,12],[16,13,19,14],[23,3,23,9],[31,13,31,14],[32,1,32,12],[69,1,69,14],[39,1,39,14],[41,13,41,14],[55,1,55,12],[52,2,52,7],[52,9,52,12],[45,2,45,5],[45,6,45,12],[68,1,68,7],[68,8,68,9],[68,10,68,12],[68,13,68,14],[66,2,66,14],[64,1,65,1],[64,2,65,14],[56,2,56,12],[67,1,67,14],[63,2,63,14],[51,1,51,12],[0,1,0,14],[49,1,49,14],[54,2,54,12],[6,2,6,13],[33,9,33,12],[57,2,57,12],[58,1,58,12],[59,1,59,12],[61,1,62,14],[60,1,60,14],[25,4,25,5],[1,1,1,14],[2,1,2,14]]}
[null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"U.S. Environmental Protection Agency (EPA) standards"]
[]
[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 applies to 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 hot mix asphalt facilities."]
[]
[]
[]
[]
[null,"New source performance standards (NSPS)"]
[null,"Does the NSPS for hot mix asphalt facilities apply to you?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"This standard applies if:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$16=\"Yes\",\"Because this NSPS applies to your operation, you need an air permit.\",IF($N$16=\"No\",\"Continue to the next question.\",IF($N$16=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,"1)","you manufacture hot mix asphalt by heating and drying aggregate and mixing with asphalt cements, and"]
[null,"2)","your plant or equipment was constructed, reconstructed, or modified* after June 11, 1973."]
[]
[null,"Resource: ",null,"EPA Rule information",null,null,null,null,null,null,null,null,null,{"$f":"IF(N16=\"Yes\",\"Continue to the next question\",IF(N16=\"No\",\"\",IF(N16=\"Choose Y/N\",\" \")))","v":" "}]
[null,"Regulation: ",null,"40 CFR pt. 60, subp. I"]
[]
[null,null,null,"If your facility also has on-site aggregate crushing or grinding:"]
[null,null,null,"1)","The NSPS for nonmetallic mineral processors may apply"]
[null,null,null,null,"Resource: ",null,"EPA Rule information"]
[null,null,null,null,"Regulation: ",null,"40 CFR pt. 60, subp. OOO"]
[null,null,null,"2)","A separate calculator for aggregates is available and includes NSPS OOO."]
[null,null,null,null,"https://www.pca.state.mn.us/regulations/aggregate-sand-and-gravel"]
[]
[]
[null,"Does an NSPS for internal combustion engines apply to you?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"The two NSPSs that apply to engines are:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N32=\"Yes\",\"You must follow NSPS requirements. Assess emissions to see if you need a permit.\",IF(N32=\"No\",\"Continue to the next question.\",IF(N32=\"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 the rule applies, use the Regulation Navigation Tool provided by EPA for NSPS IIII and JJJJ. "]
[null,null,"https://www3.epa.gov/ttn/atw/ice/quiz.html",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N32=\"Yes\",\"Continue to the next question.\",IF(N32=\"No\",\"\",IF(N32=\"Choose Y/N\",\" \")))","v":" "}]
[null,"There are also engine standards for hazardous air pollutants -- see NESHAP info below."]
[]
[]
[null,"Does any other NSPS apply to you?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"Additional performance standards: Even if the standards listed above do not apply to you, there are other NSPS that might, depending on what other equipment or activities you have at the facility.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N42=\"Yes\",\"Because an NSPS applies to your operation, you need an air permit.\",IF(N42=\"No\",\"Continue to the next question.\",IF(N42=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[]
[]
[null,null,"A list of performance standards is available at:",null,null,null,"https://www.pca.state.mn.us/sites/default/files/aq-f1-gi09d.doc"]
[null,null,"A permit is not required solely because it is subject to one or more NSPS as listed in:",null,null,null,null,null,null,null,"Minn. R. 7007.0300",null,null,{"$f":"IF(N42=\"Yes\",\"Continue to the next question.\",IF(N42=\"No\",\"\",IF(N42=\"Choose Y/N\",\" \")))","v":" "}]
[]
[]
[null,"National emission standards for hazardous air pollutants"]
[null,"Does a federal NESHAP apply?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"A NESHAP that may apply to your crusher engine or generator is for:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N51=\"Yes\",\"Follow NESHAP requirements. Assess emissions to see if you need a permit.\",IF(N51=\"No\",\"Continue to the next blue tab.\",IF(N51=\"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 the rule applies, use the Regulation Navigation Tool provided by EPA"]
[null,null,"https://www3.epa.gov/airtoxics/rice/output/quiz.html"]
[]
[null,null,"A list of other NESHAPs is found at the end of the following document:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N51=\"Yes\",\"Continue to the next blue tab.\",IF(N51=\"No\",\"\",IF(N51=\"Choose Y/N\",\" \")))","v":" "}]
[null,null,"https://www.pca.state.mn.us/sites/default/files/aq-f3-rp07.pdf"]
[]
[]
[null,"*Definition of \"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, an NSPS or NESHAP may apply to your business or create the need for a permit amendment. "]
[]
[null,"▪ ","Construction includes fabricating, erecting, or installing an aggregate plant, engine, or storage tank."]
[null,"▪ ","Modification is a physical or operational change 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":"State rules","index":2,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,14],[5,1,6,14],[8,1,9,14],[4,1,4,14],[2,1,2,14],[3,1,3,14],[7,1,7,14],[12,3,15,8],[12,9,15,14],[11,1,11,14],[22,1,23,14],[24,1,24,14],[28,5,28,6],[16,3,19,14],[28,7,28,8],[29,5,29,6],[21,2,21,8],[21,9,21,14],[0,1,0,14],[34,2,34,10],[34,11,34,12],[28,10,29,14],[30,10,30,14],[29,7,29,8],[30,5,30,6],[30,7,30,8],[33,1,33,14],[31,1,32,14],[29,3,29,4],[10,1,10,14],[26,2,27,14],[30,3,30,4],[28,3,28,4],[20,3,20,14]]}
[null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"State rules for hot mix asphalt plants"]
[null,"All hot mix asphalt facilities must comply with these state rules."]
[]
[null,"Operating requirements"]
[null,"Compliance must be demonstrated through inspections, maintenance, monitoring, testing, recordkeeping, and reporting requirements. These requirements are listed on the hot mix asphalt 'Complying with air requirements' webpage."]
[]
[null,"https://www.pca.state.mn.us/regulations/hot-mix-asphalt-plants-complying-air-requirements"]
[]
[]
[null,"Material use"]
[null,"Hot mix asphalt plants can only use:"]
[null,null,"Materials","▪  clay, silt, sand, gravel, and crushed stone produced from naturally occurring geologic formations, without additives; \n▪  recycled asphalt pavement\n▪  portland cement concrete",null,null,null,null,null,"▪  recycled sediments from asphalt plant scrubber operations\n▪  fines from asphalt plant fabric filter operations\n▪  asphalt cement \n▪  hydrated lime"]
[]
[]
[]
[null,null,"Fuels","▪  natural gas, methane, butane, and propane\n▪  gasoline, kerosene, diesel fuel, jet fuel, and fuel oils (No. 1, No. 2, No. 3, No. 4, No. 5, No. 6)\n▪  on-specification used oil, defined in Minn. R. 7045.0020, subp. 60a, provided that total halogens not exceed 1,000 parts per million\n▪  virgin oil that is discarded before use and that otherwise meets the requirements of this item for on-specification used oil"]
[]
[]
[]
[null,null,"Additives","▪  silicone, organic soaps, and other substances of a similar nature added to the asphalt cement"]
[null,null,"You can request approval for materials that are not included above.",null,null,null,null,null,null,"See requirements in Minn. R. 7011.0913"]
[]
[]
[null,"Control equipment"]
[null,"1)","All control equipment must be operated according to the manufactures' specifications"]
[null,"2)","If you choose to use a control efficiency to limit your actual emissions of particulate matter, the control equipment must be at least as efficient as the following:"]
[]
[null,null,null,"Control",null,"PM",null,"PM-10",null,null,"Note: If you use a different type of control equipment, see required efficiencies in"]
[null,null,null,"Fabric filter",null,0.99,null,0.93]
[null,null,null,"Venturi scrubber",null,0.94,null,0.84,null,null,"Minn. R. 7011.0070"]
[]
[]
[null,"Performance tests"]
[null,"1)","A performance test for particulate matter and opacity are required for all hot mix asphalt plants. ",null,null,null,null,null,null,null,null,"Minn. R. 7011.0922"]

{"sheet":"Hot mix asphalt","index":3,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[[98,1,98,4],[6,1,6,3],[7,1,7,3],[8,1,8,3],[18,1,18,5],[20,1,20,5],[9,1,9,6],[18,6,18,7],[12,5,12,9],[15,1,15,3],[16,1,16,3],[17,1,17,9],[12,1,12,3],[16,5,16,9],[18,8,18,9],[1,1,1,9],[101,5,101,9],[99,5,100,9],[97,1,97,9],[98,5,98,8],[5,2,5,3],[5,4,5,5],[6,4,6,5],[22,1,22,9],[2,1,2,9],[14,1,14,5],[13,1,13,9],[11,1,11,9],[3,1,3,9],[4,4,4,5],[99,1,101,4],[11,12,11,13],[10,12,10,14],[5,9,6,9],[4,6,4,8],[5,6,5,8],[6,6,6,8]]}
[null,null,null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"Air emissions from hot mix asphalt plants"]
[null,"Facility information"]
[]
[null,null,null,"Facility name:",null,null,"If you are using a different fuel in the dryer:",null,null,"Choose which one"]
[null,null,"Plant type",null,"Choose one",null,{"$f":"IF(J5=\"Choose which one\",\" \",\"Then, choose this as your fuel type ------->\")","v":" "},null,null,{"$f":"IF(J5=\"Choose which one\",\" \",IF(OR(J5='Data Validation'!B20,OR(J5='Data Validation'!B21,J5='Data Validation'!B22)),'Data Validation'!C20,IF(OR(J5='Data Validation'!B23,OR(J5='Data Validation'!B27,OR(J5='Data Validation'!B28,J5='Data Validation'!B29))),'Data Validation'!C23,IF(OR(J5='Data Validation'!B24,OR(J5='Data Validation'!B25,'Data Validation'!B26)),'Data Validation'!C24))))","v":" "}]
[null,"What fuel is used in your dryer?",null,null,"Choose one",null,{"$f":"IF(J5=\"Choose which one\",\" \",\"<---------------------------------------- Choose from drop-down list\")","v":" "}]
[null,"What is your maximum production rate?",null,null,null,"tons of mix per hour"]
[null,"How many hours do you actually operate?",null,null,null,"hours/year"]
[]
[null,"Performance testing"]
[]
[null,"Do you have valid performance test results?",null,null,"Choose one","*Must be MPCA-approved performance test"]
[]
[null,"Enter the particulate matter performance test factors (if available):"]
[null,"PM"]
[null,"PM10",null,null,null,"Use the same factor for PM10 as PM if you do not have an MPCA-approved PM10 factor."]
[]
[null,"Which type of emissions control do you have for the dryer, hot screen, and mixers?",null,null,null,null,"Choose one",null,"Minn. R. 7011.0060 - 7011.0080"]
[]
[null,"Control efficiency, applied to actual emissions:  PM =",null,null,null,null,{"$f":"'Data Validation'!C34","v":0},"PM10 = ",{"$f":"'Data Validation'!C37","v":0}]
[]
[null,"Potential and actual emissions - Hot mix asphalt"]
[null,null,"a","b","c","d","e",null,"f"]
[null,"Pollutant1","GWP2","Production rate","Actual hours operated","Potential annual hours","Potential Emission Factor3,5","Potential Emissions","Actual Emission Factor3, 5","Actual Emissions"]
[null,null,null,"(ton/hr)","(hr/yr)","(hr/yr)","(lbs/ton)","(ton/yr)","(lbs/ton)","(tons/yr)"]
[null,null,null,{"$f":"E8","v":0},{"$f":"E9","v":0},8760,"by pollutant","(b * d * e) / 2000","by pollutant","(b * c * f) / 2000"]
[null,"Criteria Air Pollutants"]
[null,"PM",null,null,null,null,{"$f":"IF($E$13=\"Yes\",$E$16,IF(OR($E$13=\"No\",$E$13=\"Choose one\"),(IF($E$6=Ba,'Hot mix emission factors'!B12,IF($E$6=Dr,'Hot mix emission factors'!E12,0)))))","v":0},{"$f":"$D$27*$F$27*$G29/2000","v":0},{"$f":"IF(OR($G$19=\"Choose one\",$G$19=No),G29,(G29*(1-G21)))","v":0},{"$f":"($D$27*$E$27*$I29)/2000","v":0}]
[null,"PM10",null,null,null,null,{"$f":"IF($E$13=\"Yes\",$E$17,IF(OR($E$13=\"No\",$E$13=\"Choose one\"),(IF($E$6=Ba,'Hot mix emission factors'!B13,IF($E$6=Dr,'Hot mix emission factors'!E13,0)))))","v":0},{"$f":"$D$27*$F$27*$G30/2000","v":0},{"$f":"IF(OR($G$19=\"Choose one\",$G$19=No),G30,(G30*(1-I21)))","v":0},{"$f":"($D$27*$E$27*$I30)/2000","v":0}]
[null,"PM2.5",null,null,null,null,{"$f":"IF($E$6=Ba,'Hot mix emission factors'!B14,IF($E$6=Dr,'Hot mix emission factors'!E14,0))","v":0},0,{"$f":"G31","v":0},0]
[null,"SOx5",null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B15,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C15,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D15,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E15,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F15,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G15,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,{"$f":"G32","v":0},0]
[null,"NOx",null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B16,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C16,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D16,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E16,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F16,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G16,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,"VOC",null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B17,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C17,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D17,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E17,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F17,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G17,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,"CO",null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B18,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C18,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D18,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E18,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F18,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G18,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,"Lead",null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B19,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C19,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D19,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E19,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F19,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G19,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,{"$f":"IF(OR($G$19=\"Choose one\",$G$19=No),G36,(G36*(1-I21)))","v":0},0]
[null,"Greenhouse Gas Emissions"]
[null,"CO2",1,null,null,null,{"$f":"IF($E$6=Ba,'Hot mix emission factors'!B21,IF($E$6=Dr,'Hot mix emission factors'!E21,0))","v":0},{"$f":"$D$27*$F$27*$G38/2000","v":0},{"$f":"G38","v":0},0]
[null,"CH4",298,null,null,null,{"$f":"IF($E$6=Ba,'Hot mix emission factors'!B22,IF($E$6=Dr,'Hot mix emission factors'!E22,0))","v":0},{"$f":"$D$27*$F$27*$G39/2000","v":0},{"$f":"G39","v":0},0]
[null,null,null,null,null,"GHG total (CO2e) 4",null,{"$f":"(C38*H38)+(C39*H39)","v":0},null,{"$f":"(C38*J38)+(C39*J39)","v":0}]
[null,{"$f":"'Hot mix emission factors'!A23","v":"Non-PAH HAPS"}]
[null,{"$f":"'Hot mix emission factors'!A24","v":"Acetaldehyde"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B24,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C24,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D24,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E24,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F24,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G24,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},{"$f":"$D$27*$F$27*$G42/2000","v":0},{"$f":"G42","v":0},{"$f":"($D$27*$E$27*$I42)/2000","v":0}]
[null,{"$f":"'Hot mix emission factors'!A25","v":"Benzene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B25,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C25,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D25,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E25,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F25,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G25,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,{"$f":"G43","v":0},0]
[null,{"$f":"'Hot mix emission factors'!A26","v":"Ethylbenzene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B26,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C26,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D26,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E26,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F26,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G26,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A27","v":"Formaldehyde"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B27,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C27,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D27,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E27,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F27,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G27,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A28","v":"Quinone"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B28,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C28,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D28,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E28,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F28,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G28,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A29","v":"Toluene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B29,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C29,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D29,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E29,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F29,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G29,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A30","v":"Xylene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B30,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C30,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D30,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E30,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F30,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G30,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A31","v":"Hexane"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B31,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C31,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D31,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E31,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F31,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G31,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A32","v":"Isooctane"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B32,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C32,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D32,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E32,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F32,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G32,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A33","v":"Methyl chloroform"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B33,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C33,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D33,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E33,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F33,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G33,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A34","v":"Acrolein"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B34,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C34,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D34,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E34,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F34,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G34,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A35","v":"Propionaldehyde"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B35,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C35,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D35,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E35,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F35,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G35,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A36","v":"PAH HAPs"}]
[null,{"$f":"'Hot mix emission factors'!A37","v":"2-Methylnaphthalene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B37,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C37,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D37,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E37,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F37,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G37,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A38","v":"Acenaphthene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B38,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C38,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D38,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E38,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F38,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G38,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A39","v":"Acenaphthylene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B39,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C39,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D39,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E39,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F39,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G39,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A40","v":"Antharacene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B40,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C40,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D40,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E40,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F40,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G40,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A41","v":"Benzo(a)anthracene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B41,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C41,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D41,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E41,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F41,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G41,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A42","v":"Benzo(a)pyrene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B42,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C42,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D42,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E42,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F42,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G42,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A43","v":"Benzo(b)fluoranthene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B43,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C43,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D43,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E43,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F43,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G43,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A44","v":"Benzo(g,h,i)perylene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B44,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C44,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D44,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E44,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F44,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G44,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A45","v":"Benzo(k)fluoranthene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B45,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C45,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D45,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E45,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F45,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G45,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A46","v":"Chrysene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B46,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C46,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D46,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E46,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F46,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G46,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A47","v":"Dibenz(a,h)anthracene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B47,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C47,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D47,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E47,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F47,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G47,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A48","v":"Fluoranthene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B48,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C48,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D48,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E48,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F48,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G48,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A49","v":"Fluorene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B49,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C49,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D49,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E49,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F49,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G49,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A50","v":"Indeno(1,2,3-cd)pyrene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B50,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C50,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D50,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E50,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F50,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G50,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A51","v":"Naphthalene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B51,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C51,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D51,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E51,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F51,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G51,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A52","v":"Phenanthrene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B52,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C52,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D52,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E52,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F52,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G52,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A53","v":"Pyrene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B53,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C53,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D53,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E53,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F53,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G53,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A54","v":"Benzo(e)pyrene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B54,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C54,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D54,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E54,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F54,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G54,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A55","v":"Perylene"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B55,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C55,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D55,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E55,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F55,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G55,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,{"$f":"G73","v":0},0]
[null,{"$f":"'Hot mix emission factors'!A56","v":"Metal HAPs"}]
[null,{"$f":"'Hot mix emission factors'!A57","v":"Antimony"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B57,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C57,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D57,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E57,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F57,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G57,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A58","v":"Arsenic"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B58,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C58,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D58,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E58,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F58,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G58,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A59","v":"Beryllium"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B59,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C59,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D59,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E59,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F59,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G59,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A60","v":"Cadmium"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B60,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C60,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D60,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E60,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F60,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G60,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A61","v":"Chromium"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B61,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C61,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D61,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E61,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F61,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G61,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A62","v":"Chromium (VI)"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B62,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C62,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D62,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E62,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F62,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G62,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A63","v":"Cobalt"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B63,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C63,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D63,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E63,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F63,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G63,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A64","v":"Manganese"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B64,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C64,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D64,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E64,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F64,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G64,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A65","v":"Mercury"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B65,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C65,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D65,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E65,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F65,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G65,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A66","v":"Nickel"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B66,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C66,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D66,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E66,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F66,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G66,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A67","v":"Selenium"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B67,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C67,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D67,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E67,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F67,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G67,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,{"$f":"G85","v":0},0]
[null,{"$f":"'Hot mix emission factors'!A68","v":"Dioxins"}]
[null,{"$f":"'Hot mix emission factors'!A69","v":"Total TCCD"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B69,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C69,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D69,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E69,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F69,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G69,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},{"$f":"$D$27*$F$27*$G87/2000","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!A70","v":"Total PeCDD"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B70,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C70,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D70,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E70,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F70,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G70,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A71","v":"Total HxCDD"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B71,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C71,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D71,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E71,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F71,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G71,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A72","v":"Total HpCDD"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B72,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C72,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D72,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E72,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F72,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G72,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A73","v":"Total PCDD"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B73,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C73,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D73,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E73,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F73,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G73,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A74","v":"Furans"}]
[null,{"$f":"'Hot mix emission factors'!A75","v":"Total TCDF"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B75,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C75,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D75,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E75,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F75,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G75,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A76","v":"Total PeCDF"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B76,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C76,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D76,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E76,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F76,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G76,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A77","v":"Total HxCDF"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B77,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C77,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D77,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E77,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F77,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G77,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A78","v":"Total HpCDF"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B78,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C78,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D78,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E78,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F78,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G78,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},0,0,0]
[null,{"$f":"'Hot mix emission factors'!A79","v":"Total PCDF"},null,null,null,null,{"$f":"IF(AND($E$6=Ba,$E$7=NG),'Hot mix emission factors'!B79,IF(AND($E$6=Ba,$E$7=D),'Hot mix emission factors'!C79,IF(AND($E$6=Ba,$E$7=O),'Hot mix emission factors'!D79,IF(AND($E$6=Dr,$E$7=NG),'Hot mix emission factors'!E79,IF(AND($E$6=Dr,$E$7=D),'Hot mix emission factors'!F79,IF(AND($E$6=Dr,$E$7=O),'Hot mix emission factors'!G79,IF(OR($E$6=\"Choose one\",$E$7=\"Choose one\"),0)))))))","v":0},{"$f":"$D$27*$F$27*$G97/2000","v":0},0,0]
[null,"1 Actual emission factors: SOx, NOx, CO, VOC, Vol-HAPs = no control; MHAP = fabric filter emission factor for fabric filter and venturi scrubber"]
[null,"2 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1",null,null,null,"4 CO2e = carbon dioxide equivalents"]
[null,"3 See hot mix emission factors tab for references, Potential = uncontrolled; Emission factor cells without content (blank orange cell) for HAPs, Dioxins, and Furans means no data provided in AP-42.",null,null,null,"5 Prior to the use of a dryer fuel with a sulfur content greater than 0.70 percent, you must perform air modeling with SCREEN3."]
[]
[null,null,null,null,null,"https://www.epa.gov/scram/air-quality-dispersion-modeling-screening-models"]

{"sheet":"Load out and silos","index":4,"n_rows":66,"n_cols":16,"rows_kept":66,"cut":false,"hidden":false,"merged":[[65,9,65,15],[19,1,19,7],[19,9,19,15],[43,1,43,7],[43,9,43,15],[64,1,64,7],[64,9,64,15],[22,1,22,7],[22,9,22,15],[63,9,63,15],[63,1,63,7],[1,1,1,7],[2,1,2,7],[13,1,13,7],[13,9,13,15],[4,1,4,4],[8,9,8,15],[8,1,8,7]]}
[null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"Air emissions from hot mix asphalt plants"]
[null,"Load outs and silo filling"]
[]
[null,"Do you have site specific asphalt volatility and hot mix temperature?",null,null,null,"Choose one"]
[null,null,null,"Asphalt volatility",null,"where a 0.5 percent loss-on-heating is expressed as “-0.5”"]
[null,null,null,"Hot mix asphalt temperature",null,"degrees Fahrenheit (°F)"]
[]
[null,"Load out potential and actual emissions",null,null,null,null,null,null,null,"Silo filling potential and actual emissions"]
[null,null,"b","c","d","e",null,null,null,null,"b","c","d","e"]
[null,"Pollutant","Plant capacity","Actual hours operated","Potential annual hours","Emission Factor1","Potential Emissions","Actual Emissions",null,"Pollutant","Plant capacity","Actual hours operated","Potential annual hours","Emission Factor1, 3","Potential Emissions","Actual Emissions"]
[null,null,"ton/hour","(hr/yr)","(hr/yr)","(lbs/ton)","(ton/yr)","(tons/yr)",null,null,"ton/hour","(hr/yr)","(hr/yr)","(lbs/ton)","(ton/yr)","(tons/yr)"]
[null,null,{"$f":"'Hot mix asphalt'!E8","v":0},{"$f":"'Hot mix asphalt'!E9","v":0},8760,"by pollutant","(b * d * e) / 2000","(b * c * e) / 2000",null,null,{"$f":"C13","v":0},{"$f":"D13","v":0},8760,"by pollutant","(b * d * e) / 2000","(b * c * e) / 2000"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,null,"Criteria Air Pollutants"]
[null,"PM",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!J12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))","v":0},{"$f":"$C$13*$E$13*$F15/2000","v":0},{"$f":"($C$13*$D$13*$F15)/2000","v":0},null,"PM",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!L12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))","v":0},{"$f":"$K$13*$M$13*$N15/2000","v":0},{"$f":"($K$13*$L$13*$N15)/2000","v":0}]
[null,"PM10",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!J13,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))","v":0},{"$f":"$C$13*$E$13*$F16/2000","v":0},{"$f":"($C$13*$D$13*$F16)/2000","v":0},null,"PM10",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!L13,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))","v":0},{"$f":"$K$13*$M$13*$N16/2000","v":0},{"$f":"($K$13*$L$13*$N16)/2000","v":0}]
[null,"PM2.5",null,null,null,{"$f":"F16","v":0},0,{"$f":"($C$13*$D$13*$F17)/2000","v":0},null,"PM2.5",null,null,null,{"$f":"N16","v":0},{"$f":"$K$13*$M$13*$N17/2000","v":0},{"$f":"($K$13*$L$13*$N17)/2000","v":0}]
[null,"VOC",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!J15,IF($F$5=\"yes\",(0.94)*(0.0172*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))","v":0},0,{"$f":"($C$13*$D$13*$F18)/2000","v":0},null,"VOC",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!L15,IF($F$5=\"yes\",(0.94)*(0.0172*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))","v":0},{"$f":"$K$13*$M$13*$N18/2000","v":0},{"$f":"($K$13*$L$13*$N18)/2000","v":0}]
[null,"CO",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!J16,IF($F$5=\"yes\",(0.94)*(0.0172*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))","v":0},0,{"$f":"($C$13*$D$13*$F19)/2000","v":0},null,"CO",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!L16,IF($F$5=\"yes\",(0.94)*(0.0172*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))","v":0},{"$f":"$K$13*$M$13*$N19/2000","v":0},{"$f":"($K$13*$L$13*$N19)/2000","v":0}]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,null,null,"Greenhouse Gas Emissions"]
[null,"Methane",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J18","v":0},{"$f":"$C$13*$E$13*$F21/2000","v":0},{"$f":"($C$13*$D$13*$F21)/2000","v":0},null,"Methane",null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L18","v":0},{"$f":"$K$13*$M$13*$N21/2000","v":0},{"$f":"($K$13*$L$13*$N21)/2000","v":0}]
[null,null,null,null,"GHG total (CO2e) 2",null,{"$f":"G21*25","v":0},{"$f":"H21*25","v":0},null,null,null,null,"GHG total (CO2e) 2",null,{"$f":"O21*25","v":0},{"$f":"P21*25","v":0}]
[null,{"$f":"'Hot mix emission factors'!I20","v":"Non-PAH/Volatile HAPS"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J20","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"($C$13*$D$13*$F23)/2000","v":{"$error":"#VALUE!"}},null,{"$f":"'Hot mix emission factors'!I20","v":"Non-PAH/Volatile HAPS"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L20","v":{"$error":"#VALUE!"}},{"$f":"$K$13*$M$13*$N23/2000","v":{"$error":"#VALUE!"}},{"$f":"($K$13*$L$13*$N23)/2000","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'Hot mix emission factors'!I21","v":"Benzene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J21","v":0},{"$f":"$C$13*$E$13*$F24/2000","v":0},0,null,{"$f":"'Hot mix emission factors'!I21","v":"Benzene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L21","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I22","v":"Bromomethane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J22","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I22","v":"Bromomethane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L22","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I23","v":"2-Butanone"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J23","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I23","v":"2-Butanone"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L23","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I24","v":"Carbon Disulfide"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J24","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I24","v":"Carbon Disulfide"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L24","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I25","v":"Chloroethane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J25","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I25","v":"Chloroethane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L25","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I26","v":"Chloromethane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J26","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I26","v":"Chloromethane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L26","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I27","v":"Cumene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J27","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I27","v":"Cumene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I28","v":"Ethylbenzene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J28","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I28","v":"Ethylbenzene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L28","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I29","v":"Formaldehyde"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J29","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I29","v":"Formaldehyde"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L29","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I30","v":"n-Hexane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J30","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I30","v":"n-Hexane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L30","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I31","v":"Isooctane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J31","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I31","v":"Isooctane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L31","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I32","v":"Methylene Chloride"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J32","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I32","v":"Methylene Chloride"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L32","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I33","v":"MTBE"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J33","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I33","v":"MTBE"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I34","v":"Styrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J34","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I34","v":"Styrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L34","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I35","v":"Tetrachloroethene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J35","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I35","v":"Tetrachloroethene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I36","v":"Toluene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J36","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I36","v":"Toluene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L36","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I37","v":"1,1,1-Trichloroethane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J37","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I37","v":"1,1,1-Trichloroethane"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I38","v":"Trichloroenthene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J38","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I38","v":"Trichloroenthene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I39","v":"Trichlorofluoromethane"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J39","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I39","v":"Trichlorofluoromethane"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I40","v":"Xylene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J40","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I40","v":"Xylene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L40","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I41","v":"PAH HAPs"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J41","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"'Hot mix emission factors'!I41","v":"PAH HAPs"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.000181+0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L41","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"'Hot mix emission factors'!I42","v":"Acenaphthene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J42","v":0},{"$f":"$C$13*$E$13*$F45/2000","v":0},0,null,{"$f":"'Hot mix emission factors'!I42","v":"Acenaphthene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L42","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I43","v":"Acenaphthylene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J43","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I43","v":"Acenaphthylene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L43","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I44","v":"Anthracene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J44","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I44","v":"Anthracene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L44","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I45","v":"Benzo(a)anthracene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J45","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I45","v":"Benzo(a)anthracene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L45","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I46","v":"Benzo(b)fluoranthene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J46","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I46","v":"Benzo(b)fluoranthene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I47","v":"Benzo(k)fluoranthene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J47","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I47","v":"Benzo(k)fluoranthene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I48","v":"Benzo(g,h,i)perylene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J48","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I48","v":"Benzo(g,h,i)perylene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I49","v":"Benzo(a)pyrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J49","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I49","v":"Benzo(a)pyrene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I50","v":"Benzo(e)pyrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J50","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I50","v":"Benzo(e)pyrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L50","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I51","v":"Chrysene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J51","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I51","v":"Chrysene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L51","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I52","v":"Dibenz(a,h)anthracene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J52","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I52","v":"Dibenz(a,h)anthracene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I53","v":"Fluoranthene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J53","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I53","v":"Fluoranthene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L53","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I54","v":"Fluorene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J54","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I54","v":"Fluorene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L54","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I55","v":"Indeno(1,2,3-cd)pyrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J55","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I55","v":"Indeno(1,2,3-cd)pyrene"},null,null,null,null,0,0]
[null,{"$f":"'Hot mix emission factors'!I56","v":"2-Methylnaphthalene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J56","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I56","v":"2-Methylnaphthalene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L56","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I57","v":"Naphthalene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J57","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I57","v":"Naphthalene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L57","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I58","v":"Perylene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J58","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I58","v":"Perylene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L58","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I59","v":"Phenanthrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J59","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I59","v":"Phenanthrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L59","v":0},0,0]
[null,{"$f":"'Hot mix emission factors'!I60","v":"Pyrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$J$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!J60","v":0},0,0,null,{"$f":"'Hot mix emission factors'!I60","v":"Pyrene"},null,null,null,{"$f":"IF($F$5=\"no\",'Hot mix emission factors'!$L$12,IF($F$5=\"yes\",(0.00141*(-$E$6)*EXP((0.0251)*($E$7+460)-20.43)),IF($F$5=\"Choose one\",0)))*'Hot mix emission factors'!L60","v":0},0,0]
[null,"1See hot mix emission factors tab for references",null,null,null,null,null,null,null,"1See hot mix emission factors tab for references"]
[null,"2 CO2e = carbon dioxide equivalents for CH4 = 25; Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1",null,null,null,null,null,null,null,"2 CO2e = carbon dioxide equivalents for CH4 = 25; Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1"]
[null,null,null,null,null,null,null,null,null,"3 Emission factor cells without content (blank orange cell) means no data provided in AP-42. "]

{"sheet":"Generator","index":5,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,1,1,10],[2,1,2,8],[4,1,4,3],[4,4,4,5],[4,6,4,7],[5,1,5,3],[5,5,5,8],[6,1,6,3],[6,5,6,8],[7,1,7,3],[7,5,7,8],[8,1,8,3],[8,5,8,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],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[61,1,61,4],[61,5,61,6],[14,10,15,10],[16,10,17,10],[32,6,32,8],[59,1,59,4],[59,5,60,8],[60,1,60,4]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/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,"Generator"]
[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'!D6,\" \",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'!D21,IF(B7=\"Rated fuel input\",'Data Validation'!D22)))","v":" "}]
[null,"Choose one to calculate actual emissions",null,null,0,{"$f":"IF(B8='Data Validation'!D33,\" \",IF(B8='Data Validation'!D34,'Data Validation'!D29,IF(AND(B8='Data Validation'!D35,OR(E5=tng,OR(E5=ngl,OR(E5=ngr,OR(E5=ng2l))))),'Data Validation'!D30,IF(AND(B8='Data Validation'!D35,OR(E5=rd,OR(E5=rg))),'Data Validation'!D31,\" \"))))","v":" "}]
[null,{"$f":"IF(F7=\" \",\" \",IF(F7='Data Validation'!D21,'Data Validation'!D25,IF(F7='Data Validation'!D22,'Data Validation'!D26)))","v":" "},null,null,{"$f":"IF(E5='Data Validation'!A6,\" \",IF(E5=rd,'Engine Emission Factors'!F47,IF(E5=rg,'Engine Emission Factors'!F48,IF(OR(E5=ngl,OR(E5=ngr,OR(E5=tng,E5=ng2l))),'Engine Emission Factors'!G46,\" \"))))","v":" "},{"$f":"IF(B9=\" \",\" \",IF(B9='Data Validation'!D25,\"(Btu/HP-hr)\",IF(B9='Data Validation'!D26,\"Btu/scf\")))","v":" "}]
[null,{"$f":"IF(E5='Data Validation'!D6,\" \",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'!H47,IF(E5=rg,'Engine Emission Factors'!H48,\" \"))","v":" "},{"$f":"IF(E5='Data Validation'!D6,\" \",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)","(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'!D30,E8,IF(AND(F8='Data Validation'!D31,E5=rd),(('Engine Emission Factors'!H47*E8)/1000000),IF(AND(F8='Data Validation'!D31,E5=rg),(('Engine Emission Factors'!H48*E8)/1000000),IF(F8='Data Validation'!D29,(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'!$C4,'Engine Emission Factors'!$B4),IF($E$5=rg,'Engine Emission Factors'!$E4,IF($E$5=tng,'Engine Emission Factors'!$D4,IF($E$5=ngr,'Engine Emission Factors'!$F4,IF($E$5=ngl,'Engine Emission Factors'!$G4,IF($E$5=ng2l,'Engine Emission Factors'!$H4,IF($E$5=select,'Engine Emission Factors'!$I5)))))))","v":0},{"$f":"$D$18*$F$18*$G20/2000","v":0},{"$f":"($D$18*$E$18*$G20)/2000","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'!$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*$G21/2000","v":0},{"$f":"($D$18*$E$18*$G21)/2000","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'!$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},0,0]
[null,"SOx",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,0,1,1]
[null,"NOx",null,null,null,null,{"$f":"IF($E$5=rd,IF($E$7>=600,'Engine Emission Factors'!$C8,'Engine Emission Factors'!$B8),IF($E$5=rg,'Engine Emission Factors'!$E8,IF($E$5=tng,'Engine Emission Factors'!$D8,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,0,1,1]
[null,"VOC",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,0,1,1]
[null,"CO",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,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'!$C12,'Engine Emission Factors'!$B12),IF($E$5=rg,'Engine Emission Factors'!$E12,IF($E$5=tng,'Engine Emission Factors'!$D12,IF($E$5=ngr,'Engine Emission Factors'!$F12,IF($E$5=ngl,'Engine Emission Factors'!$G12,IF($E$5=ng2l,'Engine Emission Factors'!$H12,IF($E$5=select,'Engine Emission Factors'!$I12)))))))","v":0},{"$f":"$D$18*$F$18*$G29/2000","v":0},{"$f":"($D$18*$E$18*$G29)/2000","v":0},0]
[null,"CH4 2",25,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*$G30/2000","v":0},{"$f":"($D$18*$E$18*$G30)/2000","v":0},0]
[null,"N2O 2",298,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*$G31/2000","v":0},{"$f":"($D$18*$E$18*$G31)/2000","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'!$C16,'Engine Emission Factors'!$B16),IF($E$5=rg,'Engine Emission Factors'!$E16,IF($E$5=tng,'Engine Emission Factors'!$D16,IF($E$5=ngr,'Engine Emission Factors'!$F16,IF($E$5=ngl,'Engine Emission Factors'!$G16,IF($E$5=ng2l,'Engine Emission Factors'!$H16,IF($E$5=select,'Engine Emission Factors'!$I16)))))))","v":0},{"$f":"$D$18*$F$18*$G34/2000","v":0},{"$f":"($D$18*$E$18*$G34)/2000","v":0}]
[null,"1,1,2-trichloroethane",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},0,{"$f":"($D$18*$E$18*$G35)/2000","v":0}]
[null,"1,3-butadiene",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,0]
[null,"1,3-dichloropropene",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,0]
[null,"Acetaldehyde",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,0]
[null,"Acrolein",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,0]
[null,"Benzene",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,0]
[null,"Biphenyl",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,0]
[null,"Carbon tetrachloride",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,0]
[null,"Chlorobenzene",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,0]
[null,"Chloroform",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,0]
[null,"Ethylbenzene",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,0]
[null,"Ethylene dibromide",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,0]
[null,"Formaldehyde",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,0]
[null,"Hexane",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,0]
[null,"Methanol",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,0]
[null,"Methylene chloride",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,0]
[null,"Naphthalene",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,0]
[null,"PAH",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,0]
[null,"Phenol",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,0]
[null,"Styrene",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,0]
[null,"Tetrachloroethane",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,0]
[null,"Toluene",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,0]
[null,"Vinyl chloride",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,0]
[null,"Xylene",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,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":"Natural gas (auxilary heat)","index":6,"n_rows":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,1,46,8],[47,1,47,5],[47,6,47,7],[1,1,1,10],[6,1,6,5],[5,1,5,8],[7,7,7,8],[7,1,7,3],[7,4,7,5],[2,1,3,8],[4,1,4,8],[13,10,14,10],[24,1,24,5],[29,1,29,5],[9,1,9,8],[45,1,45,8],[1,12,1,17],[2,12,3,13],[2,14,3,15],[2,16,3,17],[4,12,5,13],[4,14,5,15],[4,16,5,17],[6,12,7,13],[6,14,7,15],[6,16,7,17],[8,12,10,13],[8,14,10,15],[8,16,10,17]]}
[null,null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"Air emissions from natural gas combustion",null,null,null,null,null,null,null,null,null,null,"Tip: How to use this calculator"]
[null,"Natural gas combustion (less than 100 million Btu per hour)",null,null,null,null,null,null,null,null,null,null,"If you have…",null,"For potential emissions",null,"For actual emissions"]
[]
[null,"If you have a boiler with a rating of more than 100 million Btu per hour, different emission factors must be used (see EPA AP-42 Chapter 1.4).",null,null,null,null,null,null,null,null,null,null,"One process/heating unit",null,"Enter maximum rated heat input",null,"Enter amount of fuel burned or actual operation hours"]
[]
[null,"What is the total maximum rated heat input for the equipment?",null,null,null,null,0,"Btu per hour","(Check your units!)",null,null,null,"More than one process/heating unit",null,"Enter the total maximum rated heat input of all units, combined",null,"Enter amount of fuel burned. Do not use operation hours."]
[null,"In the previous 12 months, how many",null,null,"Choose one",null,0,{"$f":"IF(E8='Data Validation'!D40,\"\",IF(E8='Data Validation'!D41,\"hours/year\",IF(E8='Data Validation'!D42,\"cu ft/year\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"A unit that can burn more than one fuel type",null,"Calculate for both fuel types. The highest ton/yr per pollutant is to be used for potential emissions",null,"Enter amount of each type of fuel burned."]
[null,"Natural gas potential and actual emissions"]
[null,null,"a","b","c","d","e"]
[null,"Pollutant","GWP1","Hourly natural gas usage","Actual natural gas burned","Hours in a Year","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity3 Limits"]
[null,null,null,"(cu ft/hr)","(cu ft/yr)","(hr/yr)","(lbs/cu ft)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,"(Btu/hr) / (1050 Btu/cu ft)",null,"24 hrs/day * 365 days/yr",null,"(b * d * e) / 2000","( c * e) / 2000"]
[null,null,null,{"$f":"G7/1050","v":0},{"$f":"IF(E8='Data Validation'!D40,0,IF($E$8='Data Validation'!D41,(D15*G8),IF($E$8='Data Validation'!D42,G8)))","v":0},8760,"by pollutant"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.5",{"$f":"SUM(J17:J29)","v":6}]
[null,"PM",null,null,null,null,7.6000000000000001E-6,{"$f":"$D$15*$F$15*$G17/2000","v":0},{"$f":"$E$15*$G17/2000","v":0},{"$f":"IF(K17>H17,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"G17","v":7.6000000000000001E-6},0,{"$f":"$E$15*$G18/2000","v":0},{"$f":"IF(K18>H18,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"G18","v":7.6000000000000001E-6},0,0]
[null,"SOx",null,null,null,null,5.9999999999999997E-7,0,0,1,1]
[null,"NOx",null,null,null,null,1E-4,0,0,1,1]
[null,"VOC",null,null,null,null,5.4999999999999999E-6,0,0,1,1]
[null,"CO",null,null,null,null,8.3999999999999995E-5,0,0,1,2]
[null,"Lead",null,null,null,null,5.0000000000000003E-10,0,0,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":"53.06/1000000*1026/0.453592","v":0.12001878340005998},{"$f":"$D$15*$F$15*$G26/2000","v":0},{"$f":"$E$15*$G26/2000","v":0},0]
[null,"CH4 2",25,null,null,null,{"$f":"(10^-3)/(10^6)*1026/0.453592","v":2.2619446551085559E-6},{"$f":"$D$15*$F$15*$G27/2000","v":0},{"$f":"$E$15*$G27/2000","v":0},0]
[null,"N2O 2",298,null,null,null,{"$f":"(10^-4)/(10^6)*1026/0.453592","v":2.2619446551085559E-7},{"$f":"$D$15*$F$15*$G28/2000","v":0},0,0]
[null,null,null,null,null,"GHG Total (CO2e) 2",null,{"$f":"(C26*H26)+(C27*H27)+(C28*H28)","v":0},{"$f":"(C26*I26)+(C27*I27)+(C28*I28)","v":0},null,1000]
[null,"Hazardous Air Pollutants",null,null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.4"]
[null,"Benzene",null,null,null,null,{"$f":"0.0021/10^6","v":2.0999999999999998E-9},{"$f":"$D$15*$F$15*$G31/2000","v":0},{"$f":"$E$15*$G31/2000","v":0}]
[null,"Formaldehyde",null,null,null,null,{"$f":"0.075/10^6","v":7.4999999999999997E-8},0,0]
[null,"Hexane",null,null,null,null,{"$f":"1.8/1000000","v":1.8000000000000001E-6},0,0]
[null,"Naphthalene",null,null,null,null,6.0999999999999996E-10,0,0]
[null,"Toluene",null,null,null,null,3.3999999999999998E-9,0,0]
[null,"Arsenic",null,null,null,null,2.0000000000000001E-10,0,0]
[null,"Beryllium",null,null,null,null,1.2000000000000001E-11,0,0]
[null,"Cadmium",null,null,null,null,1.0999999999999999E-9,0,0]
[null,"Chromium",null,null,null,null,1.3999999999999999E-9,0,0]
[null,"Cobalt",null,null,null,null,8.3999999999999994E-11,0,0]
[null,"Manganese",null,null,null,null,3.7999999999999998E-10,0,0]
[null,"Mercury",null,null,null,null,2.5999999999999998E-10,0,0]
[null,"Nickel",null,null,null,null,2.1000000000000002E-9,0,0]
[null,"Selenium",null,null,null,null,2.4000000000000001E-11,0,0]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H31:H44)","v":0},{"$f":"SUM(I31:I44)","v":0}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1"]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 See insignificant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab.",null,null,null,null,"Minn. R. 7007.1300"]

{"sheet":"Propane (auxilary heat)","index":7,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,1,48,5],[48,6,48,7],[7,1,7,8],[6,1,6,3],[6,4,6,5],[8,1,8,5],[8,7,8,8],[46,1,46,8],[47,1,47,8],[30,1,30,5],[10,1,10,8],[25,1,25,5],[1,12,1,17],[2,12,3,13],[2,14,3,15],[5,1,5,5],[2,1,3,8],[1,1,1,10],[2,16,3,17],[4,12,5,13],[4,14,5,15],[4,16,5,17],[14,10,15,10],[16,1,16,5],[6,12,7,13],[6,14,7,15],[6,16,7,17],[8,12,10,13],[8,14,10,15],[8,16,10,17]]}
[null,null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"Air emissions from burning propane",null,null,null,null,null,null,null,null,null,null,"Tip: How to use this calculator"]
[null,"Propane combustion",null,null,null,null,null,null,null,null,null,null,"If you have…",null,"For potential emissions",null,"For actual emissions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"One process/heating unit",null,"Enter maximum rated heat input",null,"Enter amount of fuel burned or actual operation hours"]
[null,"What is the maximum rated heat input?",null,null,null,null,0,"Btu per hour","(Check your units!)"]
[null,"In the previous 12 months, how many",null,null,"Choose one",null,0,{"$f":"IF(E7='Data Validation'!D46,\" \",IF(E7='Data Validation'!D47,\"hours/year\",IF(E7='Data Validation'!D48,\"gallons/year\")))","v":" "},null,null,null,null,"More than one process/heating unit",null,"Enter the total maximum rated heat input of all units, combined",null,"Enter amount of fuel burned. Do not use operation hours."]
[]
[null,"Sulfur content of propane",null,null,null,null,0.18,"grains/100 cubic feet",null,null,null,null,"A unit that can burn more than one fuel type",null,"Calculate for both fuel types. The highest ton/yr per pollutant is to be used for potential emissions",null,"Enter amount of each type of fuel burned."]
[]
[null,"Propane potential and actual emissions"]
[null,null,"a","b","c","d","e"]
[null,"Pollutant","GWP1","Hourly propane usage","Actual propane burned","Hours in a Year","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity3 Limits"]
[null,null,null,"(gal/hr)","(gal/yr)","(hr/yr)","(lb/gal)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,"(Btu/hr) / (91500 Btu/gal)",null,"24 hrs/day * 365 days/yr",null,"(b * d * e) / 2000","( c * e ) / 2000"]
[null,null,null,{"$f":"G6/91500","v":0},{"$f":"IF(E7='Data Validation'!D46,0,IF(E7='Data Validation'!D47,('Propane (auxilary heat)'!D16*'Propane (auxilary heat)'!G7),IF(E7='Data Validation'!D48,'Propane (auxilary heat)'!G7)))","v":0},8760,"by pollutant"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.5",{"$f":"SUM(J18:J30)","v":6}]
[null,"PM",null,null,null,null,{"$f":"0.7/1000","v":6.9999999999999999E-4},{"$f":"$D$16*$F$16*$G18/2000","v":0},{"$f":"($E$16*$G18)/2000","v":0},{"$f":"IF(K18>H18,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"G18","v":6.9999999999999999E-4},0,{"$f":"($E$16*$G19)/2000","v":0},{"$f":"IF(K19>H19,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"G19","v":6.9999999999999999E-4},0,0]
[null,"SOx",null,null,null,null,{"$f":"0.001*G9","v":1.7999999999999998E-4},0,0,1,1]
[null,"NOx",null,null,null,null,1.2999999999999999E-2,0,0,1,1]
[null,"VOC",null,null,null,null,1E-3,0,0,1,1]
[null,"CO",null,null,null,null,7.4999999999999997E-3,0,0,1,2]
[null,"Lead",null,null,null,null,"n/a"]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2"]
[null,"CO2",1,null,null,null,{"$f":"61.46/1000000*91500/0.453592","v":12.39790384310129},{"$f":"$D$16*$F$16*$G27/2000","v":0},{"$f":"($E$16*$G27)/2000","v":0}]
[null,"CH4",25,null,null,null,{"$f":"(1*10^-3)/1000000*91500/0.453592","v":2.0172313444681564E-4},{"$f":"$D$16*$F$16*$G28/2000","v":0},0]
[null,"N2O",298,null,null,null,{"$f":"(1*10^-4)/1000000*91500/0.453592","v":2.0172313444681566E-5},{"$f":"$D$16*$F$16*$G29/2000","v":0},0]
[null,null,null,null,null,"GHG Total (CO2e) 2",null,{"$f":"(C27*H27)+(C28*H28)+(C29*H29)","v":0},{"$f":"(C27*I27)+(C28*I28)+(C29*I29)","v":0},null,1000]
[null,"Hazardous Air Pollutants",null,null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.4"]
[null,"Benzene",null,null,null,null,{"$f":"(0.0021/10^6)/2488*91500","v":7.7230707395498392E-8},{"$f":"$D$16*$F$16*$G32/2000","v":0},{"$f":"($E$16*$G32)/2000","v":0}]
[null,"Formaldehyde",null,null,null,null,{"$f":"(0.075/10^6)/2488*91500","v":2.7582395498392283E-6},{"$f":"$D$16*$F$16*$G33/2000","v":0},0]
[null,"Hexane",null,null,null,null,{"$f":"(1.8/1000000)/2488*91500","v":6.6197749196141489E-5},0,0]
[null,"Naphthalene",null,null,null,null,{"$f":"0.00000000061/2488*91500","v":2.2433681672025725E-8},0,0]
[null,"Toluene",null,null,null,null,{"$f":"0.0000000034/2488*91500","v":1.25040192926045E-7},0,0]
[null,"Arsenic",null,null,null,null,{"$f":"0.0000000002/2488*91500","v":7.3553054662379418E-9},0,0]
[null,"Beryllium",null,null,null,null,{"$f":"0.000000000012/2488*91500","v":4.4131832797427654E-10},0,0]
[null,"Cadmium",null,null,null,null,{"$f":"0.0000000011/2488*91500","v":4.0454180064308678E-8},0,0]
[null,"Chromium",null,null,null,null,{"$f":"0.0000000014/2488*91500","v":5.1487138263665588E-8},0,0]
[null,"Cobalt",null,null,null,null,{"$f":"0.000000000084/2488*91500","v":3.0892282958199354E-9},0,0]
[null,"Manganese",null,null,null,null,{"$f":"0.00000000038/2488*91500","v":1.397508038585209E-8},0,0]
[null,"Mercury",null,null,null,null,{"$f":"0.00000000026/2488*91500","v":9.5618971061093229E-9},0,0]
[null,"Nickel",null,null,null,null,{"$f":"0.0000000021/2488*91500","v":7.7230707395498392E-8},0,0]
[null,"Selenium",null,null,null,null,{"$f":"0.000000000024/2488*91500","v":8.8263665594855309E-10},0,0]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H32:H45)","v":0},{"$f":"SUM(I32:I45)","v":0}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1"]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 See insignificant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab.",null,null,null,null,"Minn. R. 7007.1300"]

{"sheet":"Fugitive","index":8,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":false,"merged":[[47,5,47,7],[64,1,65,1],[61,4,61,5],[61,6,61,7],[35,1,35,8],[42,1,42,8],[38,1,38,2],[38,4,38,8],[39,1,39,2],[39,4,39,7],[36,1,36,8],[41,1,41,2],[41,4,41,7],[40,1,40,2],[40,4,40,7],[37,1,37,2],[43,1,43,8],[47,1,47,2],[49,1,49,8],[51,1,53,1],[48,1,48,2],[48,4,48,7],[51,2,51,3],[46,1,46,2],[74,1,74,5],[74,7,80,8],[75,1,75,2],[75,3,75,6],[76,1,76,6],[77,1,77,2],[77,3,77,6],[78,1,78,6],[71,4,71,8],[72,5,72,8],[73,5,73,8],[1,1,1,8],[21,1,21,8],[22,1,22,8],[24,5,24,7],[3,1,3,8],[4,1,5,8],[7,2,7,3],[7,4,8,8],[18,2,18,3],[18,4,19,8],[17,1,17,8],[9,1,9,8],[10,1,10,8],[11,1,11,8],[12,2,12,3],[13,1,14,1],[13,2,14,3],[13,4,16,7],[15,1,16,1],[15,2,16,3],[46,4,46,7],[44,1,44,2],[45,1,45,2],[45,4,45,8],[44,4,44,8],[2,1,2,8],[26,5,26,7],[25,5,25,7],[26,1,26,2],[27,1,27,2],[28,4,28,7],[29,1,29,2],[29,4,29,7],[34,1,34,2],[24,1,24,2],[25,1,25,2],[28,1,28,2],[31,1,31,2],[34,6,34,7],[31,5,31,8],[32,4,32,7],[33,1,33,2],[33,4,33,7],[32,1,32,2],[30,1,30,2],[70,2,70,3],[70,6,70,7],[50,1,50,8],[51,8,55,8],[61,8,65,8],[62,2,62,3],[62,4,62,5],[62,6,62,7],[63,2,63,3],[59,1,59,8],[61,1,63,1],[61,2,61,3],[51,4,51,5],[51,6,51,7],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5],[53,6,53,7],[52,6,52,7],[63,4,63,5],[63,6,63,7],[60,1,60,8]]}
[null,null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"Air emissions from fugitive sources"]
[null,"Fugitive emissions1"]
[null,"Potential emissions"]
[null,"Your potential emissions from fugitive sources must be used in identifying whether a permit is required. Fugitive sources include unpaved roads, material handling at stockpiles, and wind erosion of ground piles. "]
[]
[]
[null,null,"Throughput  (maximum capacity) ",null,"<-------- The maximum throughput used on the hot mix asphalt tab for potential emissions is automatically entered here."]
[null,null,{"$f":"'Hot mix asphalt'!E8*'Hot mix asphalt'!F27","v":0},"tons/year"]
[]
[null,"Actual emissions"]
[null,"Are you applying for or have an Option D registration permit? "]
[null,"If…","Then…"]
[null,"Yes","You are required…",null,"…to calculate actual emissions from fugitive sources (unpaved roads, material handling for stockpiles, and wind erosion of ground piles). \nEnter actual throughput for each activity below."]
[]
[null,"No","You are not required…"]
[]
[]
[null,null,"Throughput (actual amount) ",null,"<-------- The actual amount of hot mix asphalt processed, which you entered into the hot mix asphalt tab, is used here. "]
[null,null,{"$f":"'Hot mix asphalt'!$E$27*'Hot mix asphalt'!$D$27","v":0},"tons/year"]
[]
[null,"Unpaved road2"]
[null,"Enter the data for your trucks below to calculate unpaved road emissions."]
[null,null,null,"Vehicle 1","Vehicle 2"]
[null,"% of total trips made by vehicle",null,0,0,"W = mean vehicle weight (ton)",null,null,{"$f":"D25*((D26+D27)/2)+E25*((E26+E27)/2)","v":0}]
[null,"Empty weight of vehicle (tons)",null,null,null,"Vpotential = # vehicle trips / yr",null,null,{"$f":"IFERROR(IF(($C$9/((Fugitive!D25*(Fugitive!D27-Fugitive!D26))+(Fugitive!E25*(Fugitive!E27-Fugitive!E26))))=0,0,IF(($C$9/((Fugitive!D25*(Fugitive!D27-Fugitive!D26))+(Fugitive!E25*(Fugitive!E27-Fugitive!E26))))>0,($C$9/((Fugitive!D25*(Fugitive!D27-Fugitive!D26))+(Fugitive!E25*(Fugitive!E27-Fugitive!E26)))))),0)","v":0}]
[null,"Full weight of loaded vehicle (tons)",null,null,null,"Vactual = # vehicle trips / yr",null,null,{"$f":"IFERROR(IF(((C20)/((Fugitive!D25*(Fugitive!D27-Fugitive!D26))+(Fugitive!E25*(Fugitive!E27-Fugitive!E26))))=0,0,IF((C20)/((Fugitive!D25*(Fugitive!D27-Fugitive!D26))+(Fugitive!E25*(Fugitive!E27-Fugitive!E26)))>0,((C20)/((Fugitive!D25*(Fugitive!D27-Fugitive!D26))+(Fugitive!E25*(Fugitive!E27-Fugitive!E26)))))),0)","v":0}]
[null,"S = speed on unpaved road, mph"]
[null,"m = miles of unpaved road per trip",null,null,"Potential Vehicle Miles Traveled (VMT)/yr = Vpotential x miles",null,null,null,{"$f":"IF((I26*D29)>0,(I26*D29),0)","v":0}]
[null,"M = surface moisture content (%)",null,1.5,"Actual Vehicle Miles Traveled (VMT)/yr = Vactual x miles",null,null,null,{"$f":"IF((I27*D29)>0,(I27*D29),0)","v":0}]
[null,"s = silt content of road (%)",null,6]
[null,"p = # of days w/ >=0.01\" precip/yr",null,{"$f":"(133+121+115+109+108)/5","v":117.2},"4","Unpaved road emission factor equation3"]
[null,"k = PM particle size multiplier ",null,6,"PM emission factor (lb/VMT)",null,null,null,{"$f":"((D33*((D31/12)^1)*((D28/30)^0.3)/((D30/0.5)^0.3))-0.00047)*((365-D32)/365)","v":-3.1908493150684933E-4}]
[null,"k10 = PM10 particle size multiplier ",null,1.8,"PM10 emission factor (lb/VMT)",null,null,null,{"$f":"((D34*((D31/12)^1)*((D28/30)^0.5)/((D30/0.5)^0.2))-0.00047)*((365-D32)/365)","v":-3.1908493150684933E-4}]
[null,"k2.5 = PM2.5 particle size multiplier ",null,0.18,null,null,"PM2.5 emission factor (lb/VMT)",null,{"$f":"((D35*((D31/12)^1)*((D28/30)^0.5)/((D30/0.5)^0.2))-0.00036)*((365-D32)/365)","v":-2.4440547945205483E-4}]
[]
[null,"Material handling at stockpiles5"]
[null,"k = PM particle size multiplier ",null,0.74]
[null,"k10 = PM10 particle size multiplier ",null,0.35,"Material handling emission factor equation6"]
[null,"k2.5 = PM2.5 particle size multiplier ",null,5.2999999999999999E-2,"PM emission factor (lb/ton)",null,null,null,{"$f":"D38*0.0032*(((D41/5)^1.3)/((D42/2)^1.4))","v":8.722378401376912E-3}]
[null,"U = mean wind speed (mph)",null,10,"PM10 emission factor (lb/ton)",null,null,null,{"$f":"D39*0.0032*(((D41/5)^1.3)/((D42/2)^1.4))","v":4.1254492438944851E-3}]
[null,"M = material moisture content (%)",null,1.5,"PM2.5 emission factor (lb/ton)",null,null,null,{"$f":"D40*0.0032*(((D41/5)^1.3)/((D42/2)^1.4))","v":6.247108855040221E-4}]
[]
[null,"Wind erosion of ground pile7"]
[null,"d = # days pile is present per year"]
[null,"a = acres of pile base",null,null,"Wind erosion emission factor reference8"]
[null,"s = silt content of material (%)",null,7.1,"PM emission factor (lb/day*acre)",null,null,null,{"$f":"1.7*(D47/1.5)*((365-D48)/235)*(D49/15)","v":16.969906382978724}]
[null,"p = # of days w/ >=0.01\" precip/yr",null,{"$f":"(133+121+115+109+108)/5","v":117.2},"4","PM10 emission factor  = PM * 36%",null,null,{"$f":"I47*0.36","v":6.1091662978723402}]
[null,"f = % wind > 12 mph at pile height",null,30,"PM2.5 emission factor  = PM * 9.5%",null,null,null,{"$f":"I47*0.095","v":1.6121411063829789}]
[]
[null,"Potential fugitive emissions"]
[null,"Potential \nactivity","Unpaved road",null,"Material handling at stockpiles",null,"Wind erosion of ground pile",null,"Total potential emissions (ton/year)"]
[null,null,"(VMT/yr)",null,"(ton/yr)",null,"(365d*a/yr)"]
[null,null,{"$f":"I29","v":0},null,{"$f":"C9","v":0},null,{"$f":"IF(C9>0,(D46*365),0)","v":0}]
[null,null,"Emission factor","Potential","Emission factor","Potential","Emission factor","Potential"]
[null,null,"(lb/VMT)","(ton/yr)","(lb/ton)","(ton/yr)","(lb/d*acre)","(ton/yr)"]
[null,"PM",{"$f":"I33","v":-3.1908493150684933E-4},{"$f":"C$54*C57/2000","v":0},{"$f":"I40","v":8.722378401376912E-3},{"$f":"E$54*E57/2000","v":0},{"$f":"I47","v":16.969906382978724},{"$f":"G57*$G$54/2000","v":0},{"$f":"D57+F57+H57","v":0}]
[null,"PM10",{"$f":"I34","v":-3.1908493150684933E-4},{"$f":"C$54*C58/2000","v":0},{"$f":"I41","v":4.1254492438944851E-3},{"$f":"E$54*E58/2000","v":0},{"$f":"I48","v":6.1091662978723402},{"$f":"G58*$G$54/2000","v":0},{"$f":"D58+F58+H58","v":0}]
[null,"PM2.5",{"$f":"I35","v":-2.4440547945205483E-4},0,{"$f":"I42","v":6.247108855040221E-4},0,{"$f":"I49","v":1.6121411063829789},0,{"$f":"D59+F59+H59","v":0}]
[]
[null,"Actual fugitive emissions"]
[null,"Actual \nactivity","Unpaved road",null,"Material handling at stockpiles",null,"Wind erosion of ground pile",null,"Total actual emissions (ton/year)"]
[null,null,"(VMT/yr)",null,"(ton/yr)",null,"(days * acre) / yr"]
[null,null,{"$f":"I30","v":0},null,{"$f":"C20","v":0},null,{"$f":"D45*D46","v":0}]
[null,null,"Emission factor","Potential","Emission factor","Potential","Emission factor","Potential"]
[null,null,"(lb/VMT)","(ton/yr)","(lb/ton)","(ton/yr)","(lb/d*acre)","(ton/yr)"]
[null,"PM",{"$f":"I33","v":-3.1908493150684933E-4},{"$f":"C$64*C67/2000","v":0},{"$f":"E57","v":8.722378401376912E-3},{"$f":"E$64*E67/2000","v":0},{"$f":"I47","v":16.969906382978724},{"$f":"$G$64*G67/2000","v":0},{"$f":"D67+F67+H67","v":0}]
[null,"PM10",{"$f":"I34","v":-3.1908493150684933E-4},{"$f":"C$64*C68/2000","v":0},{"$f":"E58","v":4.1254492438944851E-3},{"$f":"E$64*E68/2000","v":0},{"$f":"I48","v":6.1091662978723402},{"$f":"$G$64*G68/2000","v":0},{"$f":"D68+F68+H68","v":0}]
[null,"PM2.5",{"$f":"I35","v":-2.4440547945205483E-4},0,{"$f":"E59","v":6.247108855040221E-4},0,{"$f":"I49","v":1.6121411063829789},0,{"$f":"D69+F69+H69","v":0}]
[]
[null,"1 Sources: ","Minn. Rule 7007.0200 Subpart 2. B.",null,"Minn. Rule 7007.1130 Subpart 4. ",null,"Minn. Rule 7007.1300 Subpart 3. J."]
[null,"2 Unpaved road emissions reference sources:",null,null,"Source: AP-42 13.2.2 (11/2006)"]
[null,"3 Unpaved road particulate matter emission factor equation (lb/VMT)",null,null,null,"PM = {{[k[(s/12)^1][(S/30)^0.3)]/[(M/0.5)^0.3]}-0.00047}*(365-p/365)"]
[null,"PM-10 = {{[k[(s/12)^1][(S/30)^0.5)]/[(M/0.5)^0.2]}-0.00047}*(365-p/365)",null,null,null,"PM-10 = {{[k[(s/12)^1][(S/30)^0.5)]/[(M/0.5)^0.2]}-0.00036}*(365-p/365)"]
[null,"4 Average across MN precipitation data in Comparative Climatic Data (CCD-2015) tables, page 42."]
[null,"5 Stockpile reference",null,"Source: AP-42 13.2.4 (11/2006)"]
[null,"6 Stockpile emission factor equation (lb/ton) = k(0.0032)((U/5)1.3/(M/2)1.4)"]
[null,"7 Wind erosion reference",null,"EPA Air/Superfund National Technical Guidance Study Series, Vol. III, Table 21-23"]
[null,"8 Wind erosion emission factor equation (lb/day/acre)=1.7(s/1.5)((365-p)/235)(f/15)"]

{"sheet":"Potential emissions","index":9,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,1,4,1],[2,1,2,10],[79,1,79,10],[99,3,99,4],[99,5,99,6],[103,2,103,3],[19,1,19,10],[14,1,14,10],[93,3,93,4],[93,5,93,6],[94,5,94,6],[100,5,100,6],[102,3,102,6],[98,3,98,6],[101,3,101,6]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"Potential emissions: hot mix asphalt"]
[null,{"$f":"IF('Data Validation'!A36=\"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 into this calculator.\")","v":"These pollutant totals represent the information you entered into this calculator."}]
[null,"Pollutant","Hot Mix Asphalt","Load Out","Silos","Generator","Natural Gas, other","Propane, other","Fugitive","Potential Emissions","Permitting Threshold"]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants",null,null,null,null,{"$f":"IF(AND('Natural gas (auxilary heat)'!J16=6,'Natural gas (auxilary heat)'!G7>0),\"Insignificant Activity\",\"\")","v":""},{"$f":"IF(AND('Propane (auxilary heat)'!J17=6,'Propane (auxilary heat)'!G6>0),\"Insignificant Activity\",\"\")","v":""}]
[null,"PM",{"$f":"'Hot mix asphalt'!H29","v":0},{"$f":"'Load out and silos'!G15","v":0},{"$f":"'Load out and silos'!O15","v":0},{"$f":"Generator!H20","v":0},{"$f":"'Natural gas (auxilary heat)'!H17","v":0},{"$f":"'Propane (auxilary heat)'!H18","v":0},{"$f":"Fugitive!I57","v":0},{"$f":"SUM(C7:I7)","v":0},100]
[null,"PM10",{"$f":"'Hot mix asphalt'!H30","v":0},{"$f":"'Load out and silos'!G16","v":0},{"$f":"'Load out and silos'!O16","v":0},{"$f":"Generator!H21","v":0},{"$f":"'Natural gas (auxilary heat)'!H18","v":0},{"$f":"'Propane (auxilary heat)'!H19","v":0},{"$f":"Fugitive!I58","v":0},{"$f":"SUM(C8:I8)","v":0},25]
[null,"PM2.5",{"$f":"'Hot mix asphalt'!H31","v":0},{"$f":"'Load out and silos'!G17","v":0},{"$f":"'Load out and silos'!O17","v":0},{"$f":"Generator!H22","v":0},{"$f":"'Natural gas (auxilary heat)'!H19","v":0},{"$f":"'Propane (auxilary heat)'!H20","v":0},{"$f":"Fugitive!I59","v":0},{"$f":"SUM(C9:I9)","v":0},100]
[null,"SOx",{"$f":"'Hot mix asphalt'!H32","v":0},null,null,{"$f":"Generator!H23","v":0},{"$f":"'Natural gas (auxilary heat)'!H20","v":0},{"$f":"'Propane (auxilary heat)'!H21","v":0},null,0,50]
[null,"NOx",{"$f":"'Hot mix asphalt'!H33","v":0},null,null,{"$f":"Generator!H24","v":0},{"$f":"'Natural gas (auxilary heat)'!H21","v":0},{"$f":"'Propane (auxilary heat)'!H22","v":0},null,0,100]
[null,"VOC",{"$f":"'Hot mix asphalt'!H34","v":0},{"$f":"'Load out and silos'!G18","v":0},{"$f":"'Load out and silos'!O18","v":0},{"$f":"Generator!H25","v":0},{"$f":"'Natural gas (auxilary heat)'!H22","v":0},{"$f":"'Propane (auxilary heat)'!H23","v":0},null,0,100]
[null,"CO",{"$f":"'Hot mix asphalt'!H35","v":0},{"$f":"'Load out and silos'!G19","v":0},{"$f":"'Load out and silos'!O19","v":0},{"$f":"Generator!H26","v":0},{"$f":"'Natural gas (auxilary heat)'!H23","v":0},{"$f":"'Propane (auxilary heat)'!H24","v":0},null,0,100]
[null,"Lead",{"$f":"'Hot mix asphalt'!H36","v":0},null,null,{"$f":"Generator!H27","v":0},{"$f":"'Natural gas (auxilary heat)'!H24","v":0},{"$f":"'Propane (auxilary heat)'!H25","v":0},null,0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",{"$f":"'Hot mix asphalt'!H38","v":0},null,null,{"$f":"Generator!H29","v":0},{"$f":"'Natural gas (auxilary heat)'!H26","v":0},{"$f":"'Propane (auxilary heat)'!H27","v":0},null,0]
[null,"CH4",{"$f":"'Hot mix asphalt'!H39","v":0},{"$f":"'Load out and silos'!G21","v":0},{"$f":"'Load out and silos'!O21","v":0},{"$f":"Generator!H30","v":0},{"$f":"'Natural gas (auxilary heat)'!H27","v":0},{"$f":"'Propane (auxilary heat)'!H28","v":0},null,0]
[null,"N2O",null,null,null,{"$f":"Generator!H31","v":0},{"$f":"'Natural gas (auxilary heat)'!H28","v":0},{"$f":"'Propane (auxilary heat)'!H29","v":0},null,0]
[null,"GHG Total CO2e",null,null,null,null,null,null,null,{"$f":"(J16*1)+(J17*25)*(J18*298)","v":0},100000]
[null,"Hazardous Air Pollutants"]
[null,"1,1,1-Trichloroethane",null,{"$f":"'Load out and silos'!G40","v":0},{"$f":"'Load out and silos'!O40","v":0},null,null,null,null,{"$f":"SUM(C21:I21)","v":0}]
[null,"1,1,2,2-tetrachloroethane",null,null,null,{"$f":"Generator!H34","v":0},null,null,null,{"$f":"SUM(C22:I22)","v":0}]
[null,"1,1,2-trichloroethane",null,null,null,{"$f":"Generator!H35","v":0},null,null,null,0]
[null,"1,3-butadiene",null,null,null,{"$f":"Generator!H36","v":0},null,null,null,0]
[null,"1,3-dichloropropene",null,null,null,{"$f":"Generator!H37","v":0},null,null,null,0]
[null,"2-Butanone",null,{"$f":"'Load out and silos'!G26","v":0},{"$f":"'Load out and silos'!O26","v":0},null,null,null,null,0]
[null,"2-Methylnaphthalene",{"$f":"'Hot mix asphalt'!H55","v":0},{"$f":"'Load out and silos'!G59","v":0},{"$f":"'Load out and silos'!O59","v":0},null,null,null,null,0]
[null,"Acenaphthene",{"$f":"'Hot mix asphalt'!H56","v":0},{"$f":"'Load out and silos'!G45","v":0},{"$f":"'Load out and silos'!O45","v":0},null,null,null,null,0]
[null,"Acenaphthylene",{"$f":"'Hot mix asphalt'!H57","v":0},{"$f":"'Load out and silos'!G46","v":0},{"$f":"'Load out and silos'!O46","v":0},null,null,null,null,0]
[null,"Acetaldehyde",{"$f":"'Hot mix asphalt'!H42","v":0},null,null,{"$f":"Generator!H38","v":0},null,null,null,0]
[null,"Acetaldehyde",null,null,null,null,null,null,null,0]
[null,"Acrolein",{"$f":"'Hot mix asphalt'!H52","v":0},null,null,{"$f":"Generator!H39","v":0},null,null,null,0]
[null,"Antharacene",{"$f":"'Hot mix asphalt'!H58","v":0},{"$f":"'Load out and silos'!G47","v":0},{"$f":"'Load out and silos'!O47","v":0},null,null,null,null,0]
[null,"Benzene",{"$f":"'Hot mix asphalt'!H43","v":0},{"$f":"'Load out and silos'!G24","v":0},{"$f":"'Load out and silos'!O24","v":0},{"$f":"Generator!H40","v":0},{"$f":"'Natural gas (auxilary heat)'!H31","v":0},{"$f":"'Propane (auxilary heat)'!H32","v":0},null,0]
[null,"Benzo(a)anthracene",{"$f":"'Hot mix asphalt'!H59","v":0},{"$f":"'Load out and silos'!G48","v":0},{"$f":"'Load out and silos'!O48","v":0},null,null,null,null,0]
[null,"Benzo(a)pyrene",{"$f":"'Hot mix asphalt'!H60","v":0},{"$f":"'Load out and silos'!G49","v":0},{"$f":"'Load out and silos'!O49","v":0},null,null,null,null,0]
[null,"Benzo(b)fluoranthene",{"$f":"'Hot mix asphalt'!H61","v":0},{"$f":"'Load out and silos'!G50","v":0},{"$f":"'Load out and silos'!O50","v":0},null,null,null,null,0]
[null,"Benzo(e)pyrene",{"$f":"'Hot mix asphalt'!H62","v":0},{"$f":"'Load out and silos'!G51","v":0},{"$f":"'Load out and silos'!O51","v":0},null,null,null,null,0]
[null,"Benzo(g,h,i)perylene",{"$f":"'Hot mix asphalt'!H63","v":0},{"$f":"'Load out and silos'!G52","v":0},{"$f":"'Load out and silos'!O52","v":0},null,null,null,null,0]
[null,"Benzo(k)fluoranthene",{"$f":"'Hot mix asphalt'!H64","v":0},{"$f":"'Load out and silos'!G53","v":0},{"$f":"'Load out and silos'!O53","v":0},null,null,null,null,0]
[null,"Biphenyl",null,null,null,{"$f":"Generator!H41","v":0},null,null,null,0]
[null,"Bromomethane",null,{"$f":"'Load out and silos'!G25","v":0},{"$f":"'Load out and silos'!O25","v":0},null,null,null,null,0]
[null,"Carbon Disulfide",null,{"$f":"'Load out and silos'!G27","v":0},{"$f":"'Load out and silos'!O27","v":0},null,null,null,null,0]
[null,"Carbon tetrachloride",null,null,null,{"$f":"Generator!H42","v":0},null,null,null,0]
[null,"Chlorobenzene",null,null,null,{"$f":"Generator!H43","v":0},null,null,null,0]
[null,"Chloroethane",null,{"$f":"'Load out and silos'!G28","v":0},{"$f":"'Load out and silos'!O28","v":0},null,null,null,null,0]
[null,"Chloroform",null,null,null,{"$f":"Generator!H44","v":0},null,null,null,0]
[null,"Chloromethane",null,{"$f":"'Load out and silos'!G29","v":0},{"$f":"'Load out and silos'!O29","v":0},null,null,null,null,0]
[null,"Chrysene",{"$f":"'Hot mix asphalt'!H64","v":0},{"$f":"'Load out and silos'!G54","v":0},{"$f":"'Load out and silos'!O54","v":0},null,null,null,null,0]
[null,"Cumene",null,{"$f":"'Load out and silos'!G30","v":0},{"$f":"'Load out and silos'!O30","v":0},null,null,null,null,0]
[null,"Dibenz(a,h)anthracene",{"$f":"'Hot mix asphalt'!H65","v":0},{"$f":"'Load out and silos'!G55","v":0},{"$f":"'Load out and silos'!O55","v":0},null,null,null,null,0]
[null,"Ethylbenzene",{"$f":"'Hot mix asphalt'!H44","v":0},{"$f":"'Load out and silos'!G31","v":0},{"$f":"'Load out and silos'!O31","v":0},{"$f":"Generator!H45","v":0},null,null,null,0]
[null,"Ethylene dibromide",null,null,null,{"$f":"Generator!H46","v":0},null,null,null,0]
[null,"Fluoranthene",{"$f":"'Hot mix asphalt'!H66","v":0},{"$f":"'Load out and silos'!G56","v":0},{"$f":"'Load out and silos'!O56","v":0},null,null,null,null,0]
[null,"Fluorene",{"$f":"'Hot mix asphalt'!H67","v":0},{"$f":"'Load out and silos'!G57","v":0},{"$f":"'Load out and silos'!O57","v":0},null,null,null,null,0]
[null,"Formaldehyde",{"$f":"'Hot mix asphalt'!H45","v":0},{"$f":"'Load out and silos'!G32","v":0},{"$f":"'Load out and silos'!O32","v":0},{"$f":"Generator!H47","v":0},{"$f":"'Natural gas (auxilary heat)'!H32","v":0},{"$f":"'Propane (auxilary heat)'!H33","v":0},null,0]
[null,"Hexane",{"$f":"'Hot mix asphalt'!H49","v":0},null,null,{"$f":"Generator!H48","v":0},{"$f":"'Natural gas (auxilary heat)'!H33","v":0},{"$f":"'Propane (auxilary heat)'!H34","v":0},null,0]
[null,"Indeno(1,2,3-cd)pyrene",{"$f":"'Hot mix asphalt'!H68","v":0},{"$f":"'Load out and silos'!G58","v":0},{"$f":"'Load out and silos'!O58","v":0},null,null,null,null,0]
[null,"Isooctane",{"$f":"'Hot mix asphalt'!H50","v":0},{"$f":"'Load out and silos'!G34","v":0},{"$f":"'Load out and silos'!O34","v":0},null,null,null,null,0]
[null,"Methanol",null,null,null,{"$f":"Generator!H49","v":0},null,null,null,0]
[null,"Methyl chloroform",{"$f":"'Hot mix asphalt'!H51","v":0},null,null,null,null,null,null,0]
[null,"Methylene Chloride",null,{"$f":"'Load out and silos'!G35","v":0},{"$f":"'Load out and silos'!O35","v":0},{"$f":"Generator!H50","v":0},null,null,null,0]
[null,"MTBE",null,{"$f":"'Load out and silos'!G36","v":0},{"$f":"'Load out and silos'!O36","v":0},null,null,null,null,0]
[null,"Naphthalene",{"$f":"'Hot mix asphalt'!H69","v":0},{"$f":"'Load out and silos'!G60","v":0},{"$f":"'Load out and silos'!O60","v":0},{"$f":"Generator!H51","v":0},{"$f":"'Natural gas (auxilary heat)'!H34","v":0},{"$f":"'Propane (auxilary heat)'!H35","v":0},null,0]
[null,"n-Hexane",null,{"$f":"'Load out and silos'!G33","v":0},{"$f":"'Load out and silos'!O33","v":0},null,null,null,null,0]
[null,"Perylene",{"$f":"'Hot mix asphalt'!H73","v":0},{"$f":"'Load out and silos'!G61","v":0},{"$f":"'Load out and silos'!O61","v":0},null,null,null,null,0]
[null,"Phenanthrene",{"$f":"'Hot mix asphalt'!H70","v":0},{"$f":"'Load out and silos'!G62","v":0},{"$f":"'Load out and silos'!O62","v":0},null,null,null,null,0]
[null,"Phenol",null,null,null,{"$f":"Generator!H53","v":0},null,null,null,0]
[null,"Propionaldehyde",{"$f":"'Hot mix asphalt'!H53","v":0},null,null,null,null,null,null,0]
[null,"Pyrene",{"$f":"'Hot mix asphalt'!H73","v":0},{"$f":"'Load out and silos'!G63","v":0},{"$f":"'Load out and silos'!O63","v":0},null,null,null,null,0]
[null,"Quinone",{"$f":"'Hot mix asphalt'!H46","v":0},null,null,null,null,null,null,0]
[null,"Styrene",null,{"$f":"'Load out and silos'!G37","v":0},{"$f":"'Load out and silos'!O37","v":0},{"$f":"Generator!H54","v":0},null,null,null,0]
[null,"Tetrachloroethane",null,null,null,{"$f":"Generator!H55","v":0},null,null,null,0]
[null,"Tetrachloroethene",null,{"$f":"'Load out and silos'!G38","v":0},{"$f":"'Load out and silos'!O38","v":0},null,null,null,null,0]
[null,"Toluene",{"$f":"'Hot mix asphalt'!H47","v":0},{"$f":"'Load out and silos'!G39","v":0},{"$f":"'Load out and silos'!O39","v":0},{"$f":"Generator!H56","v":0},{"$f":"'Natural gas (auxilary heat)'!H35","v":0},{"$f":"'Propane (auxilary heat)'!H36","v":0},null,0]
[null,"Trichloroenthene",null,{"$f":"'Load out and silos'!G41","v":0},{"$f":"'Load out and silos'!O41","v":0},null,null,null,null,0]
[null,"Trichlorofluoromethane",null,{"$f":"'Load out and silos'!G42","v":0},{"$f":"'Load out and silos'!O42","v":0},null,null,null,null,0]
[null,"Vinyl chloride",null,null,null,{"$f":"Generator!H57","v":0},null,null,null,0]
[null,"Xylene",{"$f":"'Hot mix asphalt'!H48","v":0},{"$f":"'Load out and silos'!G43","v":0},{"$f":"'Load out and silos'!O43","v":0},{"$f":"Generator!H58","v":0},null,null,null,0]
[null,"Metal HAPs"]
[null,"Antimony",{"$f":"'Hot mix asphalt'!H75","v":0},null,null,null,null,null,null,0]
[null,"Arsenic",{"$f":"'Hot mix asphalt'!H76","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H36","v":0},{"$f":"'Propane (auxilary heat)'!H37","v":0},null,0]
[null,"Beryllium",{"$f":"'Hot mix asphalt'!H77","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H37","v":0},{"$f":"'Propane (auxilary heat)'!H38","v":0},null,0]
[null,"Cadmium",{"$f":"'Hot mix asphalt'!H78","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H38","v":0},{"$f":"'Propane (auxilary heat)'!H39","v":0},null,0]
[null,"Chromium",{"$f":"'Hot mix asphalt'!H79","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H39","v":0},{"$f":"'Propane (auxilary heat)'!H40","v":0},null,0]
[null,"Chromium (VI)",{"$f":"'Hot mix asphalt'!H80","v":0},null,null,null,null,null,null,{"$f":"SUM(C86:I86)","v":0}]
[null,"Cobalt",{"$f":"'Hot mix asphalt'!H81","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H40","v":0},{"$f":"'Propane (auxilary heat)'!H41","v":0},null,0]
[null,"Manganese",{"$f":"'Hot mix asphalt'!H82","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H41","v":0},{"$f":"'Propane (auxilary heat)'!H42","v":0},null,0]
[null,"Mercury",{"$f":"'Hot mix asphalt'!H83","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H42","v":0},{"$f":"'Propane (auxilary heat)'!H43","v":0},null,0]
[null,"Nickel",{"$f":"'Hot mix asphalt'!H84","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H43","v":0},{"$f":"'Propane (auxilary heat)'!H44","v":0},null,0]
[null,"Selenium",{"$f":"'Hot mix asphalt'!H85","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!H44","v":0},{"$f":"'Propane (auxilary heat)'!H45","v":0},null,0]
[null,"Dioxins"]
[null,"Total TCCD",{"$f":"'Hot mix asphalt'!H87","v":0},null,null,null,null,null,null,{"$f":"C93","v":0}]
[null,"Total PeCDD",{"$f":"'Hot mix asphalt'!H88","v":0},{"$f":"IF('Hot mix asphalt'!$E$6=Ba,\"No emission factors in AP-42 for a\",IF(AND('Hot mix asphalt'!$E$6=Dr,NG),\"No emission factors in AP-42 for a\",\"\"))","v":""},null,{"$f":"IF(D94=\"No emission factors in AP-42 for a\",'Hot mix asphalt'!E6,\"\")","v":""},null,null,null,{"$f":"C94","v":0}]
[null,"Total HxCDD",{"$f":"'Hot mix asphalt'!H89","v":0},null,{"$f":"IF(D94=\"No emission factors in AP-42 for a\",\"that is using\",\"\")","v":""},{"$f":"IF(D94=\"No emission factors in AP-42 for a\",'Hot mix asphalt'!E7,\"\")","v":""},null,null,null,0]
[null,"Total HpCDD",{"$f":"'Hot mix asphalt'!H90","v":0},null,null,null,null,null,null,0]
[null,"Total PCDD",{"$f":"'Hot mix asphalt'!H91","v":0},null,null,null,null,null,null,{"$f":"C97","v":0}]
[null,"Furans"]
[null,"Total TCDF",{"$f":"'Hot mix asphalt'!H93","v":0},null,null,null,null,null,null,{"$f":"C99","v":0}]
[null,"Total PeCDF",{"$f":"'Hot mix asphalt'!H94","v":0},{"$f":"IF('Hot mix asphalt'!$E$6=Ba,\"No emission factors in AP-42 for a\",IF(AND('Hot mix asphalt'!$E$6=Dr,NG),\"No emission factors in AP-42 for a\",\"\"))","v":""},null,{"$f":"IF(D100=\"No emission factors in AP-42 for a\",'Hot mix asphalt'!E6,\"\")","v":""},null,null,null,{"$f":"C100","v":0}]
[null,"Total HxCDF",{"$f":"'Hot mix asphalt'!H95","v":0},null,{"$f":"IF(D100=\"No emission factors in AP-42 for a\",\"that is using\",\"\")","v":""},{"$f":"IF(D100=\"No emission factors in AP-42 for a\",'Hot mix asphalt'!E7,\"\")","v":""},null,null,null,0]
[null,"Total HpCDF",{"$f":"'Hot mix asphalt'!H96","v":0},null,null,null,null,null,null,0]
[null,"Total PCDF",{"$f":"'Hot mix asphalt'!H97","v":0},null,null,null,null,null,null,0]
[null,"HAP Indiv. Max",null,null,null,null,null,null,null,{"$f":"MAX(J21:J103)","v":0},10]
[null,"HAP total",null,null,null,null,null,null,null,{"$f":"SUM(J21:J103)","v":0},25]

{"sheet":"Actual emissions","index":10,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":false,"merged":[[79,1,79,10],[91,1,91,10],[97,1,97,10],[103,2,103,3],[1,1,1,10],[3,1,4,1],[14,1,14,10],[19,1,19,10],[2,1,2,10]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"Actual emissions: hot mix asphalt"]
[null,{"$f":"IF('Data Validation'!A39=\"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 into this calculator.\")","v":"These pollutant totals represent the information you entered into this calculator."}]
[null,"Pollutant","Hot Mix Asphalt","Load Out","Silos","Generator","Natural Gas, other","Propane, other","Fugitive","Actual Emissions","Opt. D Permit Limits"]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants"]
[null,"PM",{"$f":"'Hot mix asphalt'!J29","v":0},{"$f":"'Load out and silos'!H15","v":0},{"$f":"'Load out and silos'!P15","v":0},{"$f":"Generator!I20","v":0},{"$f":"'Natural gas (auxilary heat)'!I17","v":0},{"$f":"'Propane (auxilary heat)'!I18","v":0},{"$f":"Fugitive!I67","v":0},{"$f":"SUM(C7:I7)","v":0},50]
[null,"PM10",{"$f":"'Hot mix asphalt'!J30","v":0},{"$f":"'Load out and silos'!H16","v":0},{"$f":"'Load out and silos'!P16","v":0},{"$f":"Generator!I21","v":0},{"$f":"'Natural gas (auxilary heat)'!I18","v":0},{"$f":"'Propane (auxilary heat)'!I19","v":0},{"$f":"Fugitive!I68","v":0},{"$f":"SUM(C8:I8)","v":0},50]
[null,"PM2.5",{"$f":"'Hot mix asphalt'!J31","v":0},{"$f":"'Load out and silos'!H17","v":0},{"$f":"'Load out and silos'!P17","v":0},{"$f":"Generator!I22","v":0},{"$f":"'Natural gas (auxilary heat)'!I19","v":0},{"$f":"'Propane (auxilary heat)'!I20","v":0},{"$f":"Fugitive!I69","v":0},{"$f":"SUM(C9:I9)","v":0},50]
[null,"SOx",{"$f":"'Hot mix asphalt'!J32","v":0},null,null,{"$f":"Generator!I23","v":0},{"$f":"'Natural gas (auxilary heat)'!I20","v":0},{"$f":"'Propane (auxilary heat)'!I21","v":0},null,0,50]
[null,"NOx",{"$f":"'Hot mix asphalt'!J33","v":0},null,null,{"$f":"Generator!I24","v":0},{"$f":"'Natural gas (auxilary heat)'!I21","v":0},{"$f":"'Propane (auxilary heat)'!I22","v":0},null,0,50]
[null,"VOC",{"$f":"'Hot mix asphalt'!J34","v":0},{"$f":"'Load out and silos'!H18","v":0},{"$f":"'Load out and silos'!P18","v":0},{"$f":"Generator!I25","v":0},{"$f":"'Natural gas (auxilary heat)'!I22","v":0},{"$f":"'Propane (auxilary heat)'!I23","v":0},null,0,50]
[null,"CO",{"$f":"'Hot mix asphalt'!J35","v":0},{"$f":"'Load out and silos'!H19","v":0},{"$f":"'Load out and silos'!P19","v":0},{"$f":"Generator!I26","v":0},{"$f":"'Natural gas (auxilary heat)'!I23","v":0},{"$f":"'Propane (auxilary heat)'!I24","v":0},null,0,50]
[null,"Lead",{"$f":"'Hot mix asphalt'!J36","v":0},null,null,{"$f":"Generator!I27","v":0},{"$f":"'Natural gas (auxilary heat)'!I24","v":0},{"$f":"'Propane (auxilary heat)'!I25","v":0},null,0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",{"$f":"'Hot mix asphalt'!J38","v":0},null,null,{"$f":"Generator!I29","v":0},{"$f":"'Natural gas (auxilary heat)'!I26","v":0},{"$f":"'Propane (auxilary heat)'!I27","v":0},null,{"$f":"SUM(C16:I16)","v":0}]
[null,"CH4",{"$f":"'Hot mix asphalt'!J39","v":0},{"$f":"'Load out and silos'!H21","v":0},{"$f":"'Load out and silos'!P21","v":0},{"$f":"Generator!I30","v":0},{"$f":"'Natural gas (auxilary heat)'!I27","v":0},{"$f":"'Propane (auxilary heat)'!I28","v":0},null,{"$f":"SUM(C17:I17)","v":0}]
[null,"N2O",null,null,null,{"$f":"Generator!I31","v":0},{"$f":"'Natural gas (auxilary heat)'!I28","v":0},{"$f":"'Propane (auxilary heat)'!I29","v":0},null,{"$f":"SUM(C18:I18)","v":0}]
[null,"GHG Total CO2e",null,null,null,null,null,null,null,{"$f":"SUM(J16:J18)","v":0},50000]
[null,"Hazardous Air Pollutants"]
[null,"1,1,1-Trichloroethane",null,{"$f":"'Load out and silos'!H40","v":0},{"$f":"'Load out and silos'!P40","v":0},null,null,null,null,{"$f":"SUM(C21:I21)","v":0}]
[null,"1,1,2,2-tetrachloroethane",null,null,null,{"$f":"Generator!I34","v":0},null,null,null,{"$f":"SUM(C22:I22)","v":0}]
[null,"1,1,2-trichloroethane",null,null,null,{"$f":"Generator!I35","v":0},null,null,null,0]
[null,"1,3-butadiene",null,null,null,{"$f":"Generator!I36","v":0},null,null,null,0]
[null,"1,3-dichloropropene",null,null,null,{"$f":"Generator!I37","v":0},null,null,null,0]
[null,"2-Butanone",null,{"$f":"'Load out and silos'!H26","v":0},{"$f":"'Load out and silos'!P26","v":0},null,null,null,null,0]
[null,"2-Methylnaphthalene",{"$f":"'Hot mix asphalt'!J55","v":0},{"$f":"'Load out and silos'!H59","v":0},{"$f":"'Load out and silos'!P59","v":0},null,null,null,null,0]
[null,"Acenaphthene",{"$f":"'Hot mix asphalt'!J56","v":0},{"$f":"'Load out and silos'!H45","v":0},{"$f":"'Load out and silos'!P45","v":0},null,null,null,null,0]
[null,"Acenaphthylene",{"$f":"'Hot mix asphalt'!J57","v":0},{"$f":"'Load out and silos'!H46","v":0},{"$f":"'Load out and silos'!P46","v":0},null,null,null,null,0]
[null,"Acetaldehyde",{"$f":"'Hot mix asphalt'!J42","v":0},null,null,{"$f":"Generator!I38","v":0},null,null,null,0]
[null,"Acetaldehyde",null,null,null,null,null,null,null,0]
[null,"Acrolein",{"$f":"'Hot mix asphalt'!J52","v":0},null,null,{"$f":"Generator!I39","v":0},null,null,null,0]
[null,"Antharacene",{"$f":"'Hot mix asphalt'!J58","v":0},{"$f":"'Load out and silos'!H47","v":0},{"$f":"'Load out and silos'!P47","v":0},null,null,null,null,0]
[null,"Benzene",{"$f":"'Hot mix asphalt'!J43","v":0},{"$f":"'Load out and silos'!H24","v":0},{"$f":"'Load out and silos'!P24","v":0},{"$f":"Generator!I40","v":0},{"$f":"'Natural gas (auxilary heat)'!I31","v":0},{"$f":"'Propane (auxilary heat)'!I32","v":0},null,0]
[null,"Benzo(a)anthracene",{"$f":"'Hot mix asphalt'!J59","v":0},{"$f":"'Load out and silos'!H48","v":0},{"$f":"'Load out and silos'!P48","v":0},null,null,null,null,0]
[null,"Benzo(a)pyrene",{"$f":"'Hot mix asphalt'!J60","v":0},{"$f":"'Load out and silos'!H49","v":0},{"$f":"'Load out and silos'!P49","v":0},null,null,null,null,0]
[null,"Benzo(b)fluoranthene",{"$f":"'Hot mix asphalt'!J61","v":0},{"$f":"'Load out and silos'!H50","v":0},{"$f":"'Load out and silos'!P50","v":0},null,null,null,null,0]
[null,"Benzo(e)pyrene",{"$f":"'Hot mix asphalt'!J62","v":0},{"$f":"'Load out and silos'!H51","v":0},{"$f":"'Load out and silos'!P51","v":0},null,null,null,null,0]
[null,"Benzo(g,h,i)perylene",{"$f":"'Hot mix asphalt'!J63","v":0},{"$f":"'Load out and silos'!H52","v":0},{"$f":"'Load out and silos'!P52","v":0},null,null,null,null,0]
[null,"Benzo(k)fluoranthene",{"$f":"'Hot mix asphalt'!J64","v":0},{"$f":"'Load out and silos'!H53","v":0},{"$f":"'Load out and silos'!P53","v":0},null,null,null,null,0]
[null,"Biphenyl",null,null,null,{"$f":"Generator!I41","v":0},null,null,null,0]
[null,"Bromomethane",null,{"$f":"'Load out and silos'!H25","v":0},{"$f":"'Load out and silos'!P25","v":0},null,null,null,null,0]
[null,"Carbon Disulfide",null,{"$f":"'Load out and silos'!H27","v":0},{"$f":"'Load out and silos'!P27","v":0},null,null,null,null,0]
[null,"Carbon tetrachloride",null,null,null,{"$f":"Generator!I42","v":0},null,null,null,0]
[null,"Chlorobenzene",null,null,null,{"$f":"Generator!I43","v":0},null,null,null,0]
[null,"Chloroethane",null,{"$f":"'Load out and silos'!H28","v":0},{"$f":"'Load out and silos'!P28","v":0},null,null,null,null,0]
[null,"Chloroform",null,null,null,{"$f":"Generator!I44","v":0},null,null,null,0]
[null,"Chloromethane",null,{"$f":"'Load out and silos'!H29","v":0},{"$f":"'Load out and silos'!P29","v":0},null,null,null,null,0]
[null,"Chrysene",{"$f":"'Hot mix asphalt'!J64","v":0},{"$f":"'Load out and silos'!H54","v":0},{"$f":"'Load out and silos'!P54","v":0},null,null,null,null,0]
[null,"Cumene",null,{"$f":"'Load out and silos'!H30","v":0},{"$f":"'Load out and silos'!P30","v":0},null,null,null,null,0]
[null,"Dibenz(a,h)anthracene",{"$f":"'Hot mix asphalt'!J65","v":0},{"$f":"'Load out and silos'!H55","v":0},{"$f":"'Load out and silos'!P55","v":0},null,null,null,null,0]
[null,"Ethylbenzene",{"$f":"'Hot mix asphalt'!J44","v":0},{"$f":"'Load out and silos'!H31","v":0},{"$f":"'Load out and silos'!P31","v":0},{"$f":"Generator!I45","v":0},null,null,null,0]
[null,"Ethylene dibromide",null,null,null,{"$f":"Generator!I46","v":0},null,null,null,0]
[null,"Fluoranthene",{"$f":"'Hot mix asphalt'!J66","v":0},{"$f":"'Load out and silos'!H56","v":0},{"$f":"'Load out and silos'!P56","v":0},null,null,null,null,0]
[null,"Fluorene",{"$f":"'Hot mix asphalt'!J67","v":0},{"$f":"'Load out and silos'!H57","v":0},{"$f":"'Load out and silos'!P57","v":0},null,null,null,null,0]
[null,"Formaldehyde",{"$f":"'Hot mix asphalt'!J45","v":0},{"$f":"'Load out and silos'!H32","v":0},{"$f":"'Load out and silos'!P32","v":0},{"$f":"Generator!I47","v":0},{"$f":"'Natural gas (auxilary heat)'!I32","v":0},{"$f":"'Propane (auxilary heat)'!I33","v":0},null,0]
[null,"Hexane",{"$f":"'Hot mix asphalt'!J49","v":0},null,null,{"$f":"Generator!I48","v":0},{"$f":"'Natural gas (auxilary heat)'!I33","v":0},{"$f":"'Propane (auxilary heat)'!I34","v":0},null,0]
[null,"Indeno(1,2,3-cd)pyrene",{"$f":"'Hot mix asphalt'!J68","v":0},{"$f":"'Load out and silos'!H58","v":0},{"$f":"'Load out and silos'!P58","v":0},null,null,null,null,0]
[null,"Isooctane",{"$f":"'Hot mix asphalt'!J50","v":0},{"$f":"'Load out and silos'!H34","v":0},{"$f":"'Load out and silos'!P34","v":0},null,null,null,null,0]
[null,"Methanol",null,null,null,{"$f":"Generator!I49","v":0},null,null,null,0]
[null,"Methyl chloroform",{"$f":"'Hot mix asphalt'!J51","v":0},null,null,null,null,null,null,0]
[null,"Methylene Chloride",null,{"$f":"'Load out and silos'!H35","v":0},{"$f":"'Load out and silos'!P35","v":0},{"$f":"Generator!I50","v":0},null,null,null,0]
[null,"MTBE",null,{"$f":"'Load out and silos'!H36","v":0},{"$f":"'Load out and silos'!P36","v":0},null,null,null,null,0]
[null,"Naphthalene",{"$f":"'Hot mix asphalt'!J69","v":0},{"$f":"'Load out and silos'!H60","v":0},{"$f":"'Load out and silos'!P60","v":0},{"$f":"Generator!I51","v":0},{"$f":"'Natural gas (auxilary heat)'!I34","v":0},{"$f":"'Propane (auxilary heat)'!I35","v":0},null,0]
[null,"n-Hexane",null,{"$f":"'Load out and silos'!H33","v":0},{"$f":"'Load out and silos'!P33","v":0},null,null,null,null,0]
[null,"Perylene",{"$f":"'Hot mix asphalt'!J73","v":0},{"$f":"'Load out and silos'!H61","v":0},{"$f":"'Load out and silos'!P61","v":0},null,null,null,null,0]
[null,"Phenanthrene",{"$f":"'Hot mix asphalt'!J70","v":0},{"$f":"'Load out and silos'!H62","v":0},{"$f":"'Load out and silos'!P62","v":0},null,null,null,null,0]
[null,"Phenol",null,null,null,{"$f":"Generator!I53","v":0},null,null,null,0]
[null,"Propionaldehyde",{"$f":"'Hot mix asphalt'!J53","v":0},null,null,null,null,null,null,0]
[null,"Pyrene",{"$f":"'Hot mix asphalt'!J73","v":0},{"$f":"'Load out and silos'!H63","v":0},{"$f":"'Load out and silos'!P63","v":0},null,null,null,null,0]
[null,"Quinone",{"$f":"'Hot mix asphalt'!J46","v":0},null,null,null,null,null,null,0]
[null,"Styrene",null,{"$f":"'Load out and silos'!H37","v":0},{"$f":"'Load out and silos'!P37","v":0},{"$f":"Generator!I54","v":0},null,null,null,0]
[null,"Tetrachloroethane",null,null,null,{"$f":"Generator!I55","v":0},null,null,null,0]
[null,"Tetrachloroethene",null,{"$f":"'Load out and silos'!H38","v":0},{"$f":"'Load out and silos'!P38","v":0},null,null,null,null,0]
[null,"Toluene",{"$f":"'Hot mix asphalt'!J47","v":0},{"$f":"'Load out and silos'!H39","v":0},{"$f":"'Load out and silos'!P39","v":0},{"$f":"Generator!I56","v":0},{"$f":"'Natural gas (auxilary heat)'!I35","v":0},{"$f":"'Propane (auxilary heat)'!I36","v":0},null,0]
[null,"Trichloroenthene",null,{"$f":"'Load out and silos'!H41","v":0},{"$f":"'Load out and silos'!P41","v":0},null,null,null,null,0]
[null,"Trichlorofluoromethane",null,{"$f":"'Load out and silos'!H42","v":0},{"$f":"'Load out and silos'!P42","v":0},null,null,null,null,0]
[null,"Vinyl chloride",null,null,null,{"$f":"Generator!I57","v":0},null,null,null,0]
[null,"Xylene",{"$f":"'Hot mix asphalt'!J48","v":0},{"$f":"'Load out and silos'!H43","v":0},{"$f":"'Load out and silos'!P43","v":0},{"$f":"Generator!I58","v":0},null,null,null,0]
[null,"Metal HAPs"]
[null,"Antimony",{"$f":"'Hot mix asphalt'!J75","v":0},null,null,null,null,null,null,0]
[null,"Arsenic",{"$f":"'Hot mix asphalt'!J76","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I36","v":0},{"$f":"'Propane (auxilary heat)'!I37","v":0},null,0]
[null,"Beryllium",{"$f":"'Hot mix asphalt'!J77","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I37","v":0},{"$f":"'Propane (auxilary heat)'!I38","v":0},null,0]
[null,"Cadmium",{"$f":"'Hot mix asphalt'!J78","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I38","v":0},{"$f":"'Propane (auxilary heat)'!I39","v":0},null,0]
[null,"Chromium",{"$f":"'Hot mix asphalt'!J79","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I39","v":0},{"$f":"'Propane (auxilary heat)'!I40","v":0},null,0]
[null,"Chromium (VI)",{"$f":"'Hot mix asphalt'!J80","v":0},null,null,null,null,null,null,{"$f":"SUM(C86:I86)","v":0}]
[null,"Cobalt",{"$f":"'Hot mix asphalt'!J81","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I40","v":0},{"$f":"'Propane (auxilary heat)'!I41","v":0},null,0]
[null,"Manganese",{"$f":"'Hot mix asphalt'!J82","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I41","v":0},{"$f":"'Propane (auxilary heat)'!I42","v":0},null,0]
[null,"Mercury",{"$f":"'Hot mix asphalt'!J83","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I42","v":0},{"$f":"'Propane (auxilary heat)'!I43","v":0},null,0]
[null,"Nickel",{"$f":"'Hot mix asphalt'!J84","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I43","v":0},{"$f":"'Propane (auxilary heat)'!I44","v":0},null,0]
[null,"Selenium",{"$f":"'Hot mix asphalt'!J85","v":0},null,null,null,{"$f":"'Natural gas (auxilary heat)'!I44","v":0},{"$f":"'Propane (auxilary heat)'!I45","v":0},null,0]
[null,"Dioxins"]
[null,"Total TCCD",{"$f":"'Hot mix asphalt'!J87","v":0},null,null,null,null,null,null,0]
[null,"Total PeCDD",{"$f":"'Hot mix asphalt'!J88","v":0},null,null,null,null,null,null,0]
[null,"Total HxCDD",{"$f":"'Hot mix asphalt'!J89","v":0},null,null,null,null,null,null,0]
[null,"Total HpCDD",{"$f":"'Hot mix asphalt'!J90","v":0},null,null,null,null,null,null,0]
[null,"Total PCDD",{"$f":"'Hot mix asphalt'!J91","v":0},null,null,null,null,null,null,0]
[null,"Furans"]
[null,"Total TCDF",{"$f":"'Hot mix asphalt'!J93","v":0},null,null,null,null,null,null,0]
[null,"Total PeCDF",{"$f":"'Hot mix asphalt'!J94","v":0},null,null,null,null,null,null,0]
[null,"Total HxCDF",{"$f":"'Hot mix asphalt'!J95","v":0},null,null,null,null,null,null,0]
[null,"Total HpCDF",{"$f":"'Hot mix asphalt'!J96","v":0},null,null,null,null,null,null,0]
[null,"Total PCDF",{"$f":"'Hot mix asphalt'!J97","v":0},null,null,null,null,null,null,0]
[null,"HAP Indiv. Max",null,null,null,null,null,null,null,{"$f":"MAX(J21:J103)","v":0},10]
[null,"HAP total",null,null,null,null,null,null,null,{"$f":"SUM(J21:J103)","v":0},25]

{"sheet":"Permits & requirements","index":11,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[39,1,39,2],[39,3,39,4],[37,1,37,8],[45,1,45,8],[17,1,19,1],[17,2,19,2],[17,4,19,4],[24,8,25,8],[25,5,25,6],[17,5,19,6],[24,7,25,7],[17,3,19,3],[40,1,40,5],[41,1,41,5],[42,1,42,4],[43,1,43,4],[50,1,50,2],[50,3,50,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[1,1,1,8],[8,1,8,4],[8,5,16,8],[9,1,9,4],[10,1,11,1],[5,1,6,8],[12,4,14,4],[2,1,4,8],[7,1,7,8],[10,2,11,2],[10,3,11,3],[10,4,11,4],[12,1,14,1],[12,2,14,2],[12,3,14,3],[32,2,33,8],[34,1,36,8],[29,1,29,2],[29,3,29,4],[30,2,30,8],[31,2,31,8],[26,1,27,6],[26,7,27,8],[17,7,19,7],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[17,8,19,8],[20,4,25,4],[20,5,20,6],[21,5,21,6],[21,7,23,7],[21,8,23,8],[22,5,22,6],[23,5,23,6],[24,5,24,6]]}
[null,null,null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[null,"Permits & Requirements"]
[null,"The need for a permit is based on your entire business' potential air emissions. All activities that put pollutants into the air (such as paint and solvent use that are not associated with maintenance) need to be assessed if they are not included in this calculator. Once you identify if you need a permit, based on whether an NSPS applies and 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","Your business's actual emissions","A federal NSPS","A federal NESHAP"]
[]
[null,{"$f":"IF('Data Validation'!A36=\"yes\",\"do\",\"do not\")","v":"do not"},{"$f":"IF('Data Validation'!A39=\"yes\",\"do\",\"do not\")","v":"do not"},{"$f":"IF('Data Validation'!A28>0,\"Return to Federal tab and answer all Y/N questions\",IF(AND('Data Validation'!A28=0,'Data Validation'!A20>0),\"does\",\"does not\"))","v":"Return to Federal tab and answer all Y/N questions"},{"$f":"IF('Federal standards'!N51=\"Choose Y/N\",\"Return to Federal tab and answer all Y/N questions\",IF('Federal standards'!N51=\"Yes\",\"does\",IF('Federal standards'!N51=\"No\",\"does not\")))","v":"Return to Federal tab and answer all Y/N questions"}]
[]
[]
[null,"exceed permit thresholds","exceed Option D limits","apply to your business","apply to your business"]
[]
[null,"Potential emissions exceed permit thresholds","Actual emissions exceed Option D limits","Federal NSPS applies?1","Federal NESHAP applies?","Which permit do you need?",null,"More Information ","Forms"]
[]
[]
[null,"no","n/a","no","Applicability of a NESHAP does not determine if a permit is required.","Below permit thresholds",null,"n/a","n/a"]
[null,"no","n/a","yes",null,"Registration Option A",null,"Info about Air Registration Permits","Application Forms, scroll to Section 3"]
[null,"yes","no","no",null,"Registration Option D"]
[null,"yes","no","yes",null,"Registration Option D"]
[null,"yes","yes","no",null,"Other state or federal permit",null,"Info about Air Permits","Application Forms, scroll to Section 1"]
[null,"yes","yes","yes",null,"Other state or federal permit"]
[null,"1 Applicability of NSPS IIII or JJJJ does not indicate a need for a permit if your engine did not rely on performance testing\nto demonstrate NSPS compliance and any compression ignition engines are less than 30 liters per cylinder.",null,null,null,null,null,"Minn. R. 7007.0300"]
[]
[]
[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,"Crusher engine and generator"]
[null,"A stack height determination is required if:"]
[null,"1) Installing a non-emergency engine, including insignificant activities, OR"]
[null,"2) There are existing non-emergency engines installed after January 1, 2000, OR"]
[null,"3) Installing any permit-required engine, including emergency engines."]
[]
[null,"Use the SCREEN3 program to enter engine and site-specific information to identify the necessary stack height for the engine."]
[null,"https://www.epa.gov/scram/air-quality-dispersion-modeling-screening-models#screen3"]
[null,"See input requirements and instructions on modeling more than one engine on the MPCA Form EC-03. "]
[null,"https://www.pca.state.mn.us/sites/default/files/aq-f1-ec03.doc"]
[]
[null,"MPCA Air permits page for engines",null,"https://www.pca.state.mn.us/air/engines"]

{"sheet":"Hot mix emission factors","index":12,"n_rows":92,"n_cols":13,"rows_kept":92,"cut":false,"hidden":false,"merged":[[91,3,93,6],[1,1,1,3],[82,3,83,6],[2,12,6,12],[2,9,6,9],[2,10,6,10],[1,9,1,10],[1,11,1,12],[1,4,1,6],[2,11,6,11],[9,9,9,10],[9,11,9,12],[61,8,62,12],[84,3,85,6],[86,3,87,6],[88,3,90,6]]}
["Emission factors for hot mix asphalt",null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"},null,null,null,null,null,"p-sbap5-20"]
[null,"Batch plant with rotary dryer",null,null,"Drum mix plant",null,null,null,null,"Load out ",null,"Silo Filling"]
[null,"Natural Gas","Diesel No. 2 Fuel Oil","Waste/drain Oil","Natural Gas","Diesel No. 2 Fuel Oil","Waste/drain Oil",null,null,"No site specific information","Equation with site specific information.","No site specific information","Equation with site specific information."]
[null,"Methane","No. 1 Fuel Oil","No. 6 Fuel Oil","Methane","No. 1 Fuel Oil","No. 6 Fuel Oil"]
[null,"Butane","Gasoline","No. 3 Fuel Oil","Butane","Gasoline","No. 3 Fuel Oil"]
[null,"Propane","Kerosene","No. 4 Fuel Oil","Propane","Kerosene","No. 4 Fuel Oil"]
[null,null,"Jet fuel","No. 5 Fuel Oil",null,"Jet fuel","No. 5 Fuel Oil"]
["Units","lb/ton","lb/ton","lb/ton","lb/ton","lb/ton","lb/ton",null,null,"lb/ton","lb/ton","lb/ton","lb/ton"]
[null,"SCC 3-05-002-45","SCC 3-05-002-46","SCC 3-05-002-47","SCC 3-05-002-55","SCC 3-05-002-58","SCC 3-05-002-61",null,null," SCC 3-05-002-14"," SCC 3-05-002-14"," SCC 3-05-002-13"," SCC 3-05-002-13"]
["source","AP-42 11.1","AP-42 11.1","AP-42 11.2","AP-42 11.3","AP-42 11.4","AP-42 11.5",null,"source","AP42 Tables 11.1-14 and 11.1-16",null,"AP42 Tables 11.1-14 and 11.1-16"]
["Criteria",null,null,null,null,null,null,null,"Criteria"]
["PM",32.017099999999999,32.017099999999999,32.017099999999999,28.0654,28.0654,28.0654,null,"PM",5.22E-4,"0.000181 + 0.00141(-V)e((0.0251)(T + 460) - 20.43)",5.8600000000000004E-4,"0.000332 + 0.00105(-V)e((0.0251)(T + 460) - 20.43)"]
["PM10",4.5,4.5,4.5,6.5,6.5,6.5,null,"PM10",5.22E-4,"0.000181 + 0.00141(-V)e((0.0251)(T + 460) - 20.43)",5.8600000000000004E-4,"0.000332 + 0.00105(-V)e((0.0251)(T + 460) - 20.43)"]
["PM2.5",0.27,0.27,0.27,1.5,1.5,1.5,null,"PM2.5"]
["SO2",4.5999999999999999E-3,8.7999999999999995E-2,8.7999999999999995E-2,3.3999999999999998E-3,1.0999999999999999E-2,5.8000000000000003E-2,null,"VOC",3.9090000000000001E-3,"(.94)(0.0172(-V)e((0.0251)(T + 460) - 20.43))",1.2187E-2,"(1.00)(0.0504(-V)e((0.0251)(T + 460) - 20.43))"]
["NOx",2.5000000000000001E-2,0.12,0.12,2.5999999999999999E-2,5.5E-2,5.5E-2,null,"CO",1.3489999999999999E-3,"0.00558(-)e((0.0251)(T + 460) - 20.43)",1.1800000000000001E-3,"0.00488(-V)e((0.0251)(T + 460) -20.43)"]
["VOC",8.2000000000000007E-3,8.2000000000000007E-3,3.5999999999999997E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,null,"GHG","Compound/TOC1",null,"Compound/TOC1"]
["CO",0.4,0.4,0.4,0.13,0.13,0.13,null,"Methane",6.5000000000000002E-2,null,2.5999999999999999E-3]
["Pb",{"$f":"(0.00000089*0.03)*100","v":2.6699999999999998E-6},{"$f":"(0.00000089*0.03)*100","v":2.6699999999999998E-6},{"$f":"(0.00001*0.03)*100","v":3.0000000000000004E-5},{"$f":"(0.00000062*0.03)*100","v":1.8599999999999998E-6},5.4000000000000001E-4,{"$f":"(0.000015*0.03)*100","v":4.4999999999999996E-5}]
["GHG",null,null,null,null,null,null,null,"Non-PAH/Volatile HAPS","Compound/TOC1","Notes","Compound/TOC1","Notes"]
["CO2",37,37,37,33,33,33,null,"Benzene",5.1999999999999995E-4,null,3.2000000000000003E-4]
["CH4",7.4000000000000003E-3,7.4000000000000003E-3,7.4000000000000003E-3,1.2E-2,1.2E-2,1.2E-2,null,"Bromomethane",9.6000000000000002E-5,null,4.8999999999999998E-5]
["Non-PAH HAPS",null,null,null,null,null,null,null,"2-Butanone",4.8999999999999998E-4,null,3.8999999999999999E-4]
["Acetaldehyde",3.2000000000000003E-4,3.2000000000000003E-4,3.2000000000000003E-4,null,null,1.2999999999999999E-3,null,"Carbon Disulfide",1.2999999999999999E-4,null,1.6000000000000001E-4]
["Benzene",2.7999999999999998E-4,2.7999999999999998E-4,2.7999999999999998E-4,3.8999999999999999E-4,3.8999999999999999E-4,3.8999999999999999E-4,null,"Chloroethane",2.0999999999999998E-6,null,4.0000000000000003E-5]
["Ethylbenzene",2.2000000000000001E-3,2.2000000000000001E-3,2.2000000000000001E-3,2.4000000000000001E-4,2.4000000000000001E-4,2.4000000000000001E-4,null,"Chloromethane",1.4999999999999999E-4,null,2.3000000000000001E-4]
["Formaldehyde",7.3999999999999999E-4,7.3999999999999999E-4,7.3999999999999999E-4,3.0999999999999999E-3,3.0999999999999999E-3,3.0999999999999999E-3,null,"Cumene",1.1000000000000001E-3,null,null,"No Data (ND)"]
["Quinone",2.7E-4,2.7E-4,2.7E-4,null,null,1.6000000000000001E-4,null,"Ethylbenzene",2.8E-3,null,3.8000000000000002E-4]
["Toluene",1E-3,1E-3,1E-3,1.4999999999999999E-4,2.8999999999999998E-3,2.8999999999999998E-3,null,"Formaldehyde",8.8000000000000003E-4,null,6.8999999999999999E-3]
["Xylene",2.7000000000000001E-3,2.7000000000000001E-3,2.7000000000000001E-3,2.0000000000000001E-4,2.0000000000000001E-4,2.0000000000000001E-4,null,"n-Hexane",1.5E-3,null,1E-3]
["Hexane",null,null,null,9.2000000000000003E-4,9.2000000000000003E-4,9.2000000000000003E-4,null,"Isooctane",1.8E-5,null,3.1E-6]
["Isooctane",null,null,null,4.0000000000000003E-5,4.0000000000000003E-5,4.0000000000000003E-5,null,"Methylene Chloride",0,null,2.7E-6]
["Methyl chloroform",null,null,null,4.8000000000000001E-5,4.8000000000000001E-5,4.8000000000000001E-5,null,"MTBE",0,null,null,"ND"]
["Acrolein",null,null,null,null,null,2.5999999999999998E-5,null,"Styrene",7.2999999999999999E-5,null,5.3999999999999998E-5]
["Propionaldehyde",null,null,null,null,null,1.2999999999999999E-4,null,"Tetrachloroethene",7.7000000000000001E-5,null,null,"ND"]
["PAH HAPs","**HAPS emission factors provided as fabric filter controlled. Assumption: volatile HAPS = no control; particulate HAPS = 97% control (from Pb emission factor difference). ",null,null,null,null,null,null,"Toluene",2.0999999999999999E-3,null,6.2E-4]
["2-Methylnaphthalene",7.1000000000000005E-5,7.1000000000000005E-5,7.1000000000000005E-5,7.3999999999999996E-5,1.7000000000000001E-4,1.7000000000000001E-4,null,"1,1,1-Trichloroethane",0,null,null,"ND"]
["Acenaphthene",8.9999999999999996E-7,8.9999999999999996E-7,8.9999999999999996E-7,1.3999999999999999E-6,1.3999999999999999E-6,1.3999999999999999E-6,null,"Trichloroenthene",0,null,null,"ND"]
["Acenaphthylene",5.7999999999999995E-7,5.7999999999999995E-7,5.7999999999999995E-7,8.6000000000000007E-6,2.1999999999999999E-5,2.1999999999999999E-5,null,"Trichlorofluoromethane",1.2999999999999999E-5,null,null,"ND"]
["Antharacene",2.1E-7,2.1E-7,2.1E-7,2.2000000000000001E-7,3.1E-6,3.1E-6,null,"Xylene",{"$f":"0.41%+0.08%","v":4.8999999999999998E-3},"m-/p-Xylene = 0.41%; o-Xylene = 0.08%",{"$f":"0.2%+0.057%","v":2.5700000000000002E-3},"m-/p-Xylene = 0.2%; o-Xylene = 0.057%"]
["Benzo(a)anthracene",4.5999999999999998E-9,4.5999999999999998E-9,4.5999999999999998E-9,2.1E-7,2.1E-7,2.1E-7,null,"PAH HAPs","Compound/Organic PM2 ",null,"Compound/Organic PM2"]
["Benzo(a)pyrene",3.1000000000000002E-10,3.1000000000000002E-10,3.1000000000000002E-10,9.8000000000000001E-9,9.8000000000000001E-9,9.8000000000000001E-9,null,"Acenaphthene",2.5999999999999999E-3,null,4.7000000000000002E-3]
["Benzo(b)fluoranthene",9.3999999999999998E-9,9.3999999999999998E-9,9.3999999999999998E-9,9.9999999999999995E-8,9.9999999999999995E-8,9.9999999999999995E-8,null,"Acenaphthylene",2.7999999999999998E-4,null,1.3999999999999999E-4]
["Benzo(g,h,i)perylene",5.0000000000000003E-10,5.0000000000000003E-10,5.0000000000000003E-10,4.0000000000000001E-8,4.0000000000000001E-8,4.0000000000000001E-8,null,"Anthracene",6.9999999999999999E-4,null,1.2999999999999999E-3]
["Benzo(k)fluoranthene",1.3000000000000001E-8,1.3000000000000001E-8,1.3000000000000001E-8,4.1000000000000003E-8,4.1000000000000003E-8,4.1000000000000003E-8,null,"Benzo(a)anthracene",1.9000000000000001E-4,null,5.5999999999999995E-4]
["Chrysene",3.8000000000000001E-9,3.8000000000000001E-9,3.8000000000000001E-9,1.8E-7,1.8E-7,1.8E-7,null,"Benzo(b)fluoranthene",7.6000000000000004E-5,null,null,"No Data (ND)"]
["Dibenz(a,h)anthracene",9.4999999999999995E-11,9.4999999999999995E-11,9.4999999999999995E-11,null,null,null,null,"Benzo(k)fluoranthene",2.1999999999999999E-5,null,null,"ND"]
["Fluoranthene",1.6E-7,1.6E-7,2.4000000000000001E-5,6.0999999999999998E-7,6.0999999999999998E-7,6.0999999999999998E-7,null,"Benzo(g,h,i)perylene",1.9000000000000001E-5,null,null,"ND"]
["Fluorene",1.5999999999999999E-6,1.5999999999999999E-6,1.5999999999999999E-6,3.8E-6,1.1E-5,1.1E-5,null,"Benzo(a)pyrene",2.3E-5,null,null,"ND"]
["Indeno(1,2,3-cd)pyrene",3E-10,3E-10,3E-10,6.9999999999999998E-9,6.9999999999999998E-9,6.9999999999999998E-9,null,"Benzo(e)pyrene",7.7999999999999999E-5,null,9.5000000000000005E-5]
["Naphthalene",3.6000000000000001E-5,3.6000000000000001E-5,3.6000000000000001E-5,9.0000000000000006E-5,6.4999999999999997E-4,6.4999999999999997E-4,null,"Chrysene",1.0300000000000001E-3,null,2.0999999999999999E-3]
["Phenanthrene",2.6000000000000001E-6,2.6000000000000001E-6,3.6999999999999998E-5,7.6000000000000001E-6,2.3E-5,2.3E-5,null,"Dibenz(a,h)anthracene",3.7000000000000002E-6,null,null,"ND"]
["Pyrene",6.1999999999999999E-8,6.1999999999999999E-8,5.5000000000000002E-5,5.4000000000000002E-7,3.0000000000000001E-6,3.0000000000000001E-6,null,"Fluoranthene",5.0000000000000001E-4,null,1.5E-3]
["Benzo(e)pyrene",null,null,null,1.1000000000000001E-7,1.1000000000000001E-7,1.1000000000000001E-7,null,"Fluorene",7.7000000000000002E-3,null,1.01E-2]
["Perylene",null,null,null,8.7999999999999994E-9,8.7999999999999994E-9,8.7999999999999994E-9,null,"Indeno(1,2,3-cd)pyrene",4.6999999999999999E-6,null,null,"ND"]
["Metal HAPs","**HAPS emission factors provided as fabric filter controlled. Assumption: volatile HAPS = no control; particulate HAPS = 97% control (from Pb emission factor difference). ",null,null,null,null,null,null,"2-Methylnaphthalene",2.3800000000000002E-2,null,5.2699999999999997E-2]
["Antimony",null,null,null,1.8E-7,1.8E-7,1.8E-7,null,"Naphthalene",1.2500000000000001E-2,null,1.8200000000000001E-2]
["Arsenic",{"$f":"(0.00000046*0.03)*100","v":1.3799999999999999E-6},{"$f":"B58","v":1.3799999999999999E-6},{"$f":"B58","v":1.3799999999999999E-6},{"$f":"(0.00000056*0.03)*100","v":1.6800000000000002E-6},{"$f":"E58","v":1.6800000000000002E-6},{"$f":"E58","v":1.6800000000000002E-6},null,"Perylene",2.2000000000000001E-4,null,2.9999999999999997E-4]
["Beryllium",{"$f":"(0.00000015*0.03)*100","v":4.4999999999999998E-7},{"$f":"B59","v":4.4999999999999998E-7},{"$f":"B59","v":4.4999999999999998E-7},null,null,null,null,"Phenanthrene",8.0999999999999996E-3,null,1.7999999999999999E-2]
["Cadmium",{"$f":"(0.00000061*0.03)*100","v":1.8299999999999998E-6},{"$f":"B60","v":1.8299999999999998E-6},{"$f":"B60","v":1.8299999999999998E-6},{"$f":"(0.00000041*0.03)*100","v":1.2299999999999999E-6},{"$f":"E60","v":1.2299999999999999E-6},{"$f":"E60","v":1.2299999999999999E-6},null,"Pyrene",1.5E-3,null,4.4000000000000003E-3]
["Chromium",{"$f":"(0.00000057*0.03)*100","v":1.7100000000000001E-6},{"$f":"B61","v":1.7100000000000001E-6},{"$f":"B61","v":1.7100000000000001E-6},{"$f":"(0.0000055*0.03)*100","v":1.6499999999999998E-5},1.6499999999999998E-5,1.6499999999999998E-5,null,"1 Emission factor for compound is determined by multiplying the percentage presented for the compound by the emission factor for total organic compounds (TOC)."]
["Chromium (VI)",{"$f":"(0.000000048*0.03)*100","v":1.4399999999999999E-7},{"$f":"B62","v":1.4399999999999999E-7},{"$f":"B62","v":1.4399999999999999E-7},{"$f":"(0.00000045*0.03)*100","v":1.3499999999999998E-6},1.3499999999999998E-6,1.3499999999999998E-6,null,"2 Emission factor for compound is determined by multiplying the percentage presented for the compound by the emission factor for extractable organic particulate (organic PM)."]
["Cobalt",null,null,null,{"$f":"(0.000000026*0.03)*100","v":7.7999999999999997E-8},7.7999999999999997E-8,7.7999999999999997E-8]
["Manganese",{"$f":"(0.0000069*0.03)*100","v":2.0699999999999998E-5},{"$f":"B64","v":2.0699999999999998E-5},{"$f":"B64","v":2.0699999999999998E-5},{"$f":"(0.0000077*0.03)*100","v":2.3100000000000002E-5},2.3100000000000002E-5,2.3100000000000002E-5]
["Mercury",{"$f":"(0.00000041*0.03)*100","v":1.2299999999999999E-6},{"$f":"B65","v":1.2299999999999999E-6},{"$f":"B65","v":1.2299999999999999E-6},{"$f":"(0.00000024*0.03)*100","v":7.1999999999999988E-7},7.1999999999999988E-7,7.1999999999999988E-7]
["Nickel",{"$f":"(0.000003*0.03)*100","v":9.0000000000000002E-6},{"$f":"B66","v":9.0000000000000002E-6},{"$f":"B66","v":9.0000000000000002E-6},{"$f":"(0.000063*0.03)*100","v":1.8899999999999999E-4},1.8899999999999999E-4,1.8899999999999999E-4]
["Selenium",{"$f":"(0.00000049*0.03)*100","v":1.4699999999999999E-6},{"$f":"B67","v":1.4699999999999999E-6},{"$f":"B67","v":1.4699999999999999E-6},{"$f":"(0.00000035*0.03)*100","v":1.0499999999999999E-6},1.0499999999999999E-6,1.0499999999999999E-6]
["Dioxins","none listed in AP42","none listed in AP42","none listed in AP42","none listed in AP42"]
["Total TCCD",null,null,null,null,9.3000000000000008E-13,9.3000000000000008E-13]
["Total PeCDD",null,null,null,null,2.2000000000000002E-11,2.2000000000000002E-11]
["Total HxCDD",null,null,null,null,1.2000000000000001E-11,1.2000000000000001E-11]
["Total HpCDD",null,null,null,null,1.8999999999999999E-11,1.8999999999999999E-11]
["Total PCDD",null,null,null,null,2.7999999999999998E-9,2.7999999999999998E-9]
["Furans","none listed in AP42","none listed in AP42","none listed in AP42","none listed in AP42"]
["Total TCDF",null,null,null,null,3.7E-12,3.7E-12]
["Total PeCDF",null,null,null,null,8.3999999999999994E-11,8.3999999999999994E-11]
["Total HxCDF",null,null,null,null,1.3E-11,1.3E-11]
["Total HpCDF",null,null,null,null,9.9999999999999994E-12,9.9999999999999994E-12]
["Total PCDF",null,null,null,null,1.5E-10,1.5E-10]
[]
[]
["Particulate Control","PM (%)","PM10 (%)","Control descriptions"]
["Fabric filter - total enclosure",0.99,0.93,"Fabric filter is a control device in which the incoming gas stream passes through a porous fabric filter forming a dust cake"]
["Fabric filter - certified hood",0.79,0.74]
["Fabric filter - uncertified hood",0.59,0.56000000000000005,"Venturi scrubber is a control device in which the incoming gas stream passes through a venturi into which a low pressure liquid is introduced"]
["Venturi scrubber - total enclosure",0.94,0.84]
["Venturi scrubber - certified hood",0.76,0.68,"Total enclosure means an enclosure that completely surrounds emissions from an emissions unit such that all emissions are captured and discharged through ductwork to control equipment."]
["Venturi scrubber - uncertified hood",0.56999999999999995,0.51]
[null,null,null,"Certified hood conforms to the design and operating practices recommended in \"Industrial Ventilation - A Manual of Recommended Practice, American Conference of Governmental Industrial Hygienists.\" This document is subject to frequent change."]
[]
[]
[null,null,null,"Hood is a shaped inlet to a pollution control system that does not totally surround emissions from an emissions unit, that is designed, used, and maintained to capture and discharge the air emissions through ductwork to control equipment, "]

{"sheet":"Engine Emission Factors","index":13,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[51,1,51,4],[0,0,0,6]]}
["Engine emission factors",null,null,null,null,null,null,{"$f":"Instructions!$O$3","v":"p-sbap5-20  •  4/8/19"}]
[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":"G4","v":9.9871000000000005E-3},{"$f":"H4","v":4.8309999999999999E-2}]
["PM2.5",0.31,{"$f":"0.0479+0.0077","v":5.5599999999999997E-2},{"$f":"D5","v":6.6E-3},0.1,{"$f":"F5","v":1.941E-2},{"$f":"G4","v":9.9871000000000005E-3},{"$f":"H5","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":"B47","v":163.05402211679217},{"$f":"B47","v":163.05402211679217},{"$f":"B46","v":116.97737173495123},{"$f":"B48","v":154.80872678530486},{"$f":"B46","v":116.97737173495123},{"$f":"B46","v":116.97737173495123},{"$f":"G12","v":116.97737173495123}]
["CH4",{"$f":"C47","v":6.6138732605513324E-3},{"$f":"C47","v":6.6138732605513324E-3},{"$f":"C46","v":2.2046244201837776E-3},{"$f":"C48","v":6.6138732605513324E-3},{"$f":"C46","v":2.2046244201837776E-3},{"$f":"C46","v":2.2046244201837776E-3},{"$f":"G13","v":2.2046244201837776E-3}]
["N2O",{"$f":"D47","v":1.3227746521102665E-3},{"$f":"D47","v":1.3227746521102665E-3},{"$f":"D46","v":2.2046244201837776E-4},{"$f":"D48","v":1.3227746521102665E-3},{"$f":"D46","v":2.2046244201837776E-4},{"$f":"D46","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":"B20","v":7.67E-4},2.7899999999999999E-3,8.3599999999999994E-3,7.7600000000000004E-3]
["Acrolein",9.2499999999999999E-5,7.8800000000000008E-6,6.3999999999999997E-6,{"$f":"B21","v":9.2499999999999999E-5},2.63E-3,5.1399999999999996E-3,7.7799999999999996E-3]
["Benzene",9.3300000000000002E-4,7.76E-4,1.2E-5,{"$f":"B22","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":"B29","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":"B33","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":"B38","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":"B40","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":"C47","v":6.6138732605513324E-3},{"$f":"D47","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":14,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":true,"merged":[[0,0,0,3],[1,0,1,3],[3,1,3,2]]}
["p-sbap5-20"]
["Data Validation - Hot Mix Asphalt"]
[]
["General","Hot Mix Asphalt",null,"Generator"]
["Options","Plant type",null,"Engine and fuel type"]
["Choose one","Choose one",null,"Choose one"]
["Yes","Batch plant with rotary dryer",null,"Reciprocating - diesel"]
["No","Drum mix plant",null,"Reciprocating - gasoline"]
[null,null,null,"Turbine - natural gas"]
["Options 2",null,null,"Recip - nat gas 4-stroke rich burn"]
["Choose Y/N","Fuel Type",null,"Recip - nat gas 4-stroke lean burn"]
["Yes","Choose one",null,"Recip - nat gas 2-stroke lean burn"]
["No","Natural gas"]
[null,"Diesel (No. 2 fuel oil)",null,"Engine use"]
[null,"Waste/Drain Oil (No. 6 fuel oil)",null,"Choose one"]
[null,null,null,"Routine"]
[null,null,null,"Emergency"]
["Equation/reference","Additional Fuels"]
["NSPS applies","Choose which one","Choose as Fuel Type","Input Value"]
[{"$f":"SUM(A21:A24)","v":0},"Methane","Natural gas","Choose one"]
[{"$f":"COUNTIF('Federal standards'!N16,\"Yes\")","v":0},"Butane","Natural gas","Horsepower(HP) or Brake Power (HP-hr)"]
[{"$f":"COUNTIF('Federal standards'!N32,\"Yes\")","v":0},"Propane","Natural gas","Standard cubic feet/hr (scf/hr)"]
[{"$f":"COUNTIF('Federal standards'!N42,\"Yes\")","v":0},"No. 1 fuel oil","Diesel (No. 2 fuel oil)"]
[null,"No. 3 fuel oil","Waste/Drain Oil (No. 6 fuel oil)","Fuel Conversion"]
[null,"No. 4 fuel oil","Waste/Drain Oil (No. 6 fuel oil)","Brake specific fuel consumption"]
[null,"No. 5 fuel oil","Waste/Drain Oil (No. 6 fuel oil)","Heat value of fuel"]
["NSPS no selection","Gasoline","Diesel (No. 2 fuel oil)"]
[{"$f":"SUM(A29:A32)","v":3},"Kerosene","Diesel (No. 2 fuel oil)","Actual emissions entry"]
[{"$f":"IF('Federal standards'!N16=\"Choose Y/N\",1,0)","v":1},"Jet fuel","Diesel (No. 2 fuel oil)","hours per year (hr/yr)"]
[{"$f":"IF('Federal standards'!N32=\"Choose Y/N\",1,0)","v":1},null,null,"million Btu per year (MMBtu/yr)"]
[{"$f":"IF('Federal standards'!$N$42=\"Choose Y/N\",1,0)","v":1},null,null,"gallons per year (gal/yr)"]
[null,"If no performance test","Then, "]
[null,"Choose one","PM =","Choose one to calculate actual emissions"]
[null,"No control",{"$f":"IF(OR('Hot mix asphalt'!G19='Data Validation'!B33,'Hot mix asphalt'!G19='Data Validation'!B34),0,IF('Hot mix asphalt'!G19='Data Validation'!B35,'Hot mix emission factors'!B83,IF('Hot mix asphalt'!G19='Data Validation'!B36,'Hot mix emission factors'!B84,IF('Hot mix asphalt'!G19='Data Validation'!B37,'Hot mix emission factors'!B86,IF('Hot mix asphalt'!G19='Data Validation'!B38,'Hot mix emission factors'!B87,IF('Hot mix asphalt'!G19='Data Validation'!B39,'Hot mix emission factors'!B88,IF('Hot mix asphalt'!G19='Data Validation'!B40,'Hot mix emission factors'!B89)))))))","v":0},"Number of hours operated per 12 months"]
["Potential emissions","Fabric filter - total enclosure",null,"Quantity of fuel actually burned per 12 months"]
[{"$f":"IF((OR('Potential emissions'!J7>=100,OR('Potential emissions'!J8>=25,OR('Potential emissions'!J9>=100,OR('Potential emissions'!J10>=50,OR('Potential emissions'!J11>=100,OR('Potential emissions'!J12>=100,OR('Potential emissions'!J13>=100,OR('Potential emissions'!J14>=0.5,OR('Potential emissions'!J19>=100000,OR('Potential emissions'!J104>=10,'Potential emissions'!J105>=25))))))))))),\"yes\",\"no\")","v":"no"},"Fabric filter - certified hood","PM10 ="]
[null,"Fabric filter - uncertified hood",{"$f":"IF(OR('Hot mix asphalt'!G19='Data Validation'!B33,'Hot mix asphalt'!G19='Data Validation'!B34),0,IF('Hot mix asphalt'!G19='Data Validation'!B35,'Hot mix emission factors'!C83,IF('Hot mix asphalt'!G19='Data Validation'!B36,'Hot mix emission factors'!C84,IF('Hot mix asphalt'!G19='Data Validation'!B37,'Hot mix emission factors'!C86,IF('Hot mix asphalt'!G19='Data Validation'!B38,'Hot mix emission factors'!C87,IF('Hot mix asphalt'!G19='Data Validation'!B39,'Hot mix emission factors'!C88,IF('Hot mix asphalt'!G19='Data Validation'!B40,'Hot mix emission factors'!C89)))))))","v":0}]
["Actual Emissions","Venturi scrubber - total enclosure",null,"Auxillary heat"]
[{"$f":"IF((OR('Actual emissions'!J7>=50,OR('Actual emissions'!J8>=50,OR('Actual emissions'!J9>=50,OR('Actual emissions'!J10>=50,OR('Actual emissions'!J11>=50,OR('Actual emissions'!J12>=50,OR('Actual emissions'!J13>=50,OR('Actual emissions'!J14>=0.5,OR('Actual emissions'!J19>=50000,OR('Actual emissions'!J67>=5,'Actual emissions'!J68>=12.5))))))))))),\"yes\",\"no\")","v":"no"},"Venturi scrubber - certified hood",null,"Natural Gas"]
[null,"Venturi scrubber - uncertified hood",null,"Choose one"]
[null,null,null,"hours were the units actually operated?"]
[null,null,null,"cubic feet of gas were actually burned?"]
[]
[]
[null,null,null,"Propane"]
[null,null,null,"Choose one"]
[null,null,null,"hours were the units actually operated?"]
[null,null,null,"gallons of propane were actually burned?"]