{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Federal standards","State general permit","Aggregate","Crusher Engine","Generator","Fugitive","Potential emissions","Actual emissions","Permits & requirements","Aggregate emission factors","Engine emission factors","Data validation"],"not_rendered":{"images":2,"defined_names":64,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"merged":[[0,1,2,5],[0,6,0,14],[1,6,2,14],[3,1,3,14],[4,1,4,14],[5,1,5,14],[6,1,6,14],[7,1,7,14],[8,1,9,14],[10,1,10,14],[11,2,11,14],[12,2,12,14],[13,2,13,14],[14,2,14,14],[15,2,15,14],[16,2,16,14],[17,1,17,13],[18,1,18,13],[19,1,19,14],[20,1,20,14],[21,1,21,14],[22,2,22,3],[22,5,22,8],[23,2,23,3],[23,4,23,14],[24,1,24,2],[25,6,25,14],[26,1,26,5],[26,6,26,14]]}
[{"$nulls":6},"Aggregate: Sand and gravel\nAir emissions calculator"]
[{"$nulls":6},"p-sbap5-30 • 7/31/25"]
[]
[null,"Instructions"]
[null,"1) Begin with the first blue tab across the bottom to enter information for your business."]
[null,"2) The green tab totals all potential and actual emissions from the information entered on the blue tabs."]
[null,"3) The yellow 'Permits & Requirements' tab will help you decide which permit to apply for. "]
[null,"4) Later, 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","Important tips"]
[]
[]
[null,"Assistance"]
[null,"This calculator was created by the Minnesota Pollution Control Agency's (MPCA) Small Business Environmental Assistance Program (SBEAP)."]
[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's website:",{"$nulls":4},"More information found on the MPCA's Aggregate - sand and gravel webpage: "]
[null,"https://www.pca.state.mn.us/smallbizhelp",{"$nulls":4},"https://www.pca.state.mn.us/regulations/aggregate-sand-and-gravel"]

{"sheet":"Federal standards","index":1,"n_rows":79,"n_cols":14,"rows_kept":79,"merged":[[0,1,0,14],[1,1,1,14],[2,1,2,14],[3,1,5,7],[3,8,5,14],[6,2,6,13],[6,14,11,14],[7,1,8,1],[7,2,9,13],[10,2,12,13],[13,1,13,14],[14,1,14,14],[15,1,15,12],[15,13,15,14],[16,1,17,12],[16,13,19,14],[18,2,18,12],[19,2,19,12],[20,1,22,12],[20,13,21,14],[23,1,23,12],[24,4,24,6],[25,4,25,8],[26,1,26,14],[27,1,27,14],[28,1,28,12],[28,13,28,14],[29,1,29,12],[29,13,33,14],[30,2,30,7],[30,9,30,12],[31,2,31,8],[31,9,31,12],[32,1,32,12],[33,2,33,12],[34,2,34,12],[34,13,35,14],[35,1,35,12],[36,1,36,14],[37,1,37,14],[38,1,38,12],[38,13,38,14],[39,1,39,12],[39,13,43,14],[40,2,40,12],[41,2,41,12],[43,1,43,12],[44,8,44,11],[44,13,45,14],[46,1,46,14],[47,1,47,12],[47,13,47,14],[48,1,48,12],[48,13,51,14],[49,2,49,12],[50,1,50,12],[51,2,51,7],[51,8,51,12],[52,1,52,12],[52,13,53,14],[53,1,54,12],[55,1,55,14],[56,2,56,5],[56,6,56,12],[57,1,57,14],[58,1,58,14],[59,1,59,14],[60,1,60,12],[60,13,60,14],[61,1,61,12],[61,13,64,14],[62,2,62,7],[62,9,62,12],[63,2,63,12],[64,2,64,12],[65,1,65,12],[65,13,67,14],[66,2,66,12],[67,2,67,12],[70,1,70,14],[71,1,72,14],[73,2,73,14],[74,1,75,1],[74,2,75,14],[76,2,76,14],[77,1,77,14],[78,1,78,7],[78,8,78,9],[78,10,78,12],[78,13,78,14],[79,1,79,14]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[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.",{"$nulls":6},"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. A NESHAP can impose requirements on existing equipment without any changes at the facility."]
[]
[]
[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 aggregate mining and processing."]
[]
[]
[]
[null,"New source performance standards (NSPS)"]
[null,"Does the NSPS for nonmetallic mineral processors apply to you?",{"$nulls":11},"Choose Y/N"]
[null,"This standard applies to each crusher, grinding mill, screening operation, bucket elevator, belt conveyor, bagging operation, storage bin, enclosed truck or railcar loading station if:",{"$nulls":11},{"$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)","your fixed plant is larger than 25 tons/hour or your portable plant is larger than 150 tons/hour, AND"]
[null,"2)","your plant or equipment was constructed, reconstructed, or modified* after August 31, 1983."]
[null,"There are 18 nonmetallic minerals, including 'crushed and broken stone' and 'sand and gravel,' whose crusher, grinding mill, screens, bucket elevator, belt conveyor, bagging operation, storage bins, and truck loading stations are addressed by this regulation to reduce particulate matter air emissions. ",{"$nulls":11},{"$f":"IF(N16=\"Yes\",\"Continue to the next question.\",IF(N16=\"No\",\"\",IF(N16=\"Choose Y/N\",\" \")))","v":" "}]
[]
[]
[]
[{"$nulls":3},"Resource","EPA Rule information"]
[{"$nulls":3},"Regulation","40 CFR pt. 60, subp. OOO"]
[]
[]
[null,"Does an NSPS for internal combustion engines apply to you?",{"$nulls":11},"Choose Y/N"]
[null,"The two NSPSs that apply to engines are:",{"$nulls":11},{"$f":"IF(N29=\"Yes\",\"You must follow NSPS requirements. Assess emissions to see if you need a permit.\",IF(N29=\"No\",\"Continue to the next question.\",IF(N29=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,"1)","Standards of Performance for Compression Ignition Engines",{"$nulls":5},"Full Text:","40 CFR 60, subp. IIII"]
[null,"2)","Standards of Performance for Spark Ignition Engines ",{"$nulls":6},"40 CFR 60, subp. JJJJ"]
[]
[null,"· ","To help understand if the rule applies, use the Regulation Navigation Tool provided by EPA for NSPS IIII and JJJJ. "]
[null,null,"https://regnav.app.cloud.gov/ice/ice%20-%20Storyline%20output/story_html5.html",{"$nulls":10},{"$f":"IF(N29=\"Yes\",\"Continue to the next question.\",IF(N29=\"No\",\"\",IF(N29=\"Choose Y/N\",\" \")))","v":" "}]
[null,"There are also engine standards for hazardous air pollutants -- see NESHAP info below."]
[]
[]
[null,"Does the NSPS for volatile organic liquid (petroleum) storage apply to you?",{"$nulls":11},"Choose Y/N"]
[null,"This standard applies if you have a storage tank or container at your site that: ",{"$nulls":11},{"$f":"IF(N39=\"Yes\",\"You must follow NSPS requirements. Assess emissions to see if you need a permit.\",IF(N39=\"No\",\"Continue to the next question.\",IF(N39=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,"1)","was constructed, reconstructed, or modified* after July 23, 1984, "]
[null,"2)","holds about 19,800 gallons or more, and"]
[null,"3)","stores volatile organic liquids (including petroleum products such as fuel)."]
[]
[null,null,"The full text of NSPS for volatile liquid storage is available at:",{"$nulls":5},"40 CFR pt. 60, subp. Kb",{"$nulls":4},{"$f":"IF(N39=\"Yes\",\"Continue to the next question.\",IF(N39=\"No\",\"\",IF(N39=\"Choose Y/N\",\" \")))","v":" "}]
[]
[]
[null,"Does the NSPS for calciners and dryers or another NSPS apply to you?",{"$nulls":11},"Choose Y/N"]
[null,"The standard for calciners and dryers in mineral industries applies if:",{"$nulls":11},{"$f":"IF(N48=\"Yes\",\"Because this NSPS applies to your operation, you need an air permit.\",IF(N48=\"No\",\"Continue to the next question.\",IF(N48=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,"1)","you use a dryer or calciner at your site that was purchased, constructed, reconstructed, or modified* after April 23, 1986."]
[]
[null,null,"The full text of NSPS for calciners and dryers is available at:",{"$nulls":5},"40 CFR pt. 60, subp. UUU"]
[{"$nulls":13},{"$f":"IF(N48=\"Yes\",\"Continue to the next question.\",IF(N48=\"No\",\"\",IF(N48=\"Choose Y/N\",\" \")))","v":" "}]
[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,"A list of performance standards is available at:",{"$nulls":3},"https://www.pca.state.mn.us/sites/default/files/aq-f1-gi09d.doc"]
[]
[]
[null,"National emission standards for hazardous air pollutants"]
[null,"Does a federal NESHAP apply?",{"$nulls":11},"Choose Y/N"]
[null,"A NESHAP that may apply to your crusher engine or generator is for:",{"$nulls":11},{"$f":"IF(N61=\"Yes\",\"Follow NESHAP requirements. Assess emissions for permit thresholds.\",IF(N61=\"No\",\"Continue to the next blue tab.\",IF(N61=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,null,"Stationary Reciprocating Internal Combustion Engines",{"$nulls":5},"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://regnav.app.cloud.gov/rice/rice%20-%20Storyline%20output/story_html5.html"]
[{"$nulls":13},{"$f":"IF(N61=\"Yes\",\"Continue to the next blue tab.\",IF(N61=\"No\",\"\",IF(N61=\"Choose Y/N\",\" \")))","v":" "}]
[null,null,"A list of other NESHAPs is found at the end of the following document:"]
[null,null,"https://www.pca.state.mn.us/sites/default/files/aq-f3-rp07.docx"]
[]
[]
[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:",{"$nulls":6},"40 CFR § 60.2",null,"and reconstruction at: ",null,null,"40 CFR § 60.15"]

{"sheet":"State general permit","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"merged":[[0,1,0,14],[1,1,1,14],[2,1,2,14],[3,2,3,10],[3,11,3,12],[4,2,4,14],[6,1,6,14],[7,4,7,5],[7,6,7,7],[7,9,7,11],[8,1,8,14],[9,1,9,14],[10,2,10,4],[10,5,10,13],[11,2,13,4],[11,5,13,13],[14,2,19,4],[14,5,15,13],[16,6,17,13],[18,6,19,13],[20,2,20,4],[20,5,21,13],[22,6,23,13],[24,2,27,4],[24,5,25,13],[26,5,27,13],[28,1,28,14],[29,1,29,12],[29,13,29,14],[30,2,30,14],[31,3,31,14],[32,2,32,12],[33,1,33,14],[34,1,36,14],[37,3,37,8],[37,9,38,13],[38,3,38,6],[39,3,39,8],[39,9,39,13],[40,1,40,14],[41,1,41,14],[42,2,42,14],[43,3,43,8],[44,1,44,14]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[null,"State rules for aggregate processing"]
[null,"An air permit is required if"]
[null,"1)","one or more federal performance standard applies, excluding those listed in Minn. R. 7007.0300, or",{"$nulls":8},"Minn. R. 7007.0300"]
[null,"2)","your business' overall potential air emissions exceed permit thresholds."]
[]
[null,"On the federal standards tab, you indicated that the following performance standards apply:"]
[{"$nulls":4},{"$f":"IF('Federal standards'!$N$16=\"Yes\",\"NSPS OOO\",\" \")","v":" "},null,{"$f":"IF('Federal standards'!$N$29=\"Yes\",\"NSPS IIII or JJJJ\",\" \")","v":" "},null,{"$f":"IF('Federal standards'!$N$39=\"Yes\",\"NSPS Kb\",\" \")","v":" "},{"$f":"IF('Federal standards'!$N$48=\"Yes\",\"NSPS UUU/other NSPS\",\" \")","v":" "}]
[null,{"$f":"IF(OR('Federal standards'!$N$16=\"Choose Y/N\",OR('Federal standards'!$N$29=\"Choose Y/N\",OR('Federal standards'!$N$39=\"Choose Y/N\",'Federal standards'!$N$48=\"Choose Y/N\"))),\"Return to the federal standards tab and answer all Y/N questions.\",\" \")","v":"Return to the federal standards tab and answer all Y/N questions."}]
[]
[null,null,"When…",null,null,"Then…"]
[null,null,"NSPS UUU or NSPS apply \n(excludes OOO, IIII, JJJJ, Kb)",null,null,"A permit is required but, you do not qualify for the general permit. Continue to the next blue tab to calculate your potential emissions."]
[]
[]
[null,null,"NSPS OOO applies\n(NSPS IIII, JJJJ, or Kb may also apply)",null,null,"A permit is required; Calculate your potential air emissions to see if they exceed permitting thresholds."]
[]
[{"$nulls":5},"▪ ","If your potential emissions do not exceed permitting thresholds, you may qualify for a Registration Permit Option A. Go to the permits & requirements tab."]
[]
[{"$nulls":5},"▪ ","If your potential emissions do exceed permitting thresholds, see If you qualify for the nonmetallic mineral general air permit. Go to the qualification review checklist below."]
[]
[null,null,"only NSPS IIII, JJJJ, or Kb apply",null,null,"A permit may be required; Calculate your potential air emissions to see if they exceed permitting thresholds."]
[]
[{"$nulls":5},"▪ ","If your potential emissions do exceed permitting thresholds, see If you qualify for the nonmetallic mineral general air permit. Go to the qualification review checklist below."]
[]
[null,null,"an NSPS does not apply",null,null,"See if your potential emissions exceed permit thresholds. Continue to the following blue tabs to calculate your potential emissions."]
[]
[{"$nulls":5},"Then, if your potential emissions exceed permitting thresholds, you may qualify for the general permit. Go to the qualification checklist below or to the permits and requirements tab. "]
[]
[]
[null,"Does your business qualify for the MPCA general air permit for nonmetallic mineral processors?",{"$nulls":11},"Choose Y/N"]
[null,"▪ ","See if your business qualifies for the general air permit for nonmetallic mineral processors by completing the:"]
[{"$nulls":3},"NM-00: Qualifications Review Checklist – Nonmetallic Mineral Processing General Permit (aq-f4-nm00)"]
[null,"▪ ","If the business qualifies for the general permit, your business cannot obtain a registration permit. "]
[]
[null,"If yes, stop here: You have indicated that your business qualifies for the general air permit. You do not need to calculate your potential emissions. Begin the air application process with the submittal cover page (SCP-01) and complete all applicable forms for the nonmetallic mineral general permit. See the application forms on the air permit and forms page – scroll down the webpage to #4."]
[]
[]
[null,null,"▪ ","SCP-01: Submittal cover page (aq-f1-scp01)",{"$nulls":5},"If your business qualifies for the general permit and an individual permit, you may apply for either type."]
[null,null,"▪ ","Air permit forms webpage"]
[null,null,"▪ ","More information on types of air permits",{"$nulls":5},"Minn. R. 7007.1100, subp. 5"]
[]
[null,"If no, continue to the next blue tab and calculate your potential air emissions to see which type of permit is required. "]
[null,null,"The permits and requirements tab will help you decide which permit best fits your facility."]
[null,null,"▪ ","More information on types of air permits"]

{"sheet":"Aggregate","index":3,"n_rows":54,"n_cols":11,"rows_kept":54,"merged":[[0,1,0,10],[1,1,1,10],[2,1,2,10],[4,2,4,4],[4,6,4,7],[4,9,4,10],[5,2,5,4],[5,6,6,7],[5,9,5,10],[6,2,6,4],[6,9,6,10],[7,2,7,4],[7,6,7,7],[8,2,8,4],[10,2,12,9],[14,1,14,10],[15,1,15,9],[16,1,16,10],[17,1,18,10],[20,1,20,4],[20,6,20,8],[22,1,22,2],[23,1,26,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,24,6],[23,7,24,7],[23,8,24,8],[23,9,24,9],[23,10,24,10],[27,1,30,1],[31,1,32,1],[33,1,33,2],[35,1,35,9],[36,1,36,9],[37,1,37,9],[38,1,38,10],[39,1,39,9],[40,1,40,2],[41,1,44,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[41,7,42,7],[41,8,42,8],[41,9,42,9],[45,1,48,1],[49,1,50,1],[51,1,51,2],[53,1,53,9]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[null,"Air emissions for aggregates: sand and gravel"]
[null,"For the aggregate activities, use the following parameters."]
[]
[null,"Crushing","Aggregate output diameter ",null,null,"Screening","Occurring between crushers…",null,null,"Keep records"]
[null,"Primary","3 to 12 inches",null,null,"Screening","Primary to Secondary & \nSecondary to Tertiary",null,null,"Use the Compliance Calendar"]
[null,"Secondary","1 to 4 inches",{"$nulls":6}," for Aggregate Facilities"]
[null,"Tertiary","0.5 to 2.5 centimeters (3/16 to 1 inch)",null,null,"Fines ","Tertiary to Fines & Fines"]
[null,"Fines","maximum of 0.5 centimeters (3/16 inch)"]
[]
[null,null,"Convey and transfer points: One transfer point is counted for every time the material is handled and moved from a piece of equipment or pile. For example, when the aggregate is dumped from an arriving vehicle into a pile, when aggregate is scooped from the pile and dumped into a hopper, when the aggregate is conveyed from one piece of equipment to another, etc. "]
[]
[]
[]
[null,"Potential emissions - Aggregate: sand and gravel "]
[null,"Enter the maximum amount of aggregate that each unit can process per hour, based on manufacturer specifications."]
[null,"If you have more than one unit of the same type, enter the total maximum hourly throughput in the blue box. "]
[null,"For example: If you have 2 primary crushers where crusher 1 can process 150 tons per hour and crusher 2 can process 50 tons per hour, enter 200 tons per hour in the maximum throughput blue box."]
[]
[]
[null,"How many transfer points are there for the material?",{"$nulls":3},0,"number of transfer points"]
[]
[null,"a",null,"b","c","d","e","f","g","h","i"]
[null,"Potential Activity",null,"Maximum Throughput","Maximum Throughput","PM Emission Factor","PM Emissions","PM10 Emission Factor","PM10 Emissions","PM2.5 Emission Factor","PM2.5 Emissions"]
[]
[{"$nulls":3},"(tons/hour)","(tons/year)","(lb/ton)","(tons/year)","(lb/ton)","(ton/year)","(lb/ton)","(ton/year)"]
[{"$nulls":4},"b*8760",null,"c*d/2000",null,"c*f/2000",null,"c*h/2000"]
[null,"Crushing","Primary",0,{"$f":"D28*8760","v":0},{"$f":"'Aggregate emission factors'!E10","v":0.0007},{"$f":"$E28*F28/2000","v":{"v":0,"d":"0.00"}},{"$f":"'Aggregate emission factors'!G10","v":0.0007},{"$f":"$E28*H28/2000","v":{"v":0,"d":"0.00"}},{"$f":"'Aggregate emission factors'!E36","v":0.0005},{"$f":"$E28*J28/2000","v":{"v":0,"d":"0.00"}}]
[null,null,"Secondary",0,{"$f":"D29*8760","v":0},{"$f":"'Aggregate emission factors'!E12","v":0.025},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!G12","v":0.0087},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!E37","v":0.00025},{"v":0,"d":"0.00"}]
[null,null,"Tertiary",0,0,{"$f":"'Aggregate emission factors'!E14","v":0.0054},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!G14","v":0.0024},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!E38","v":0.0005},{"v":0,"d":"0.00"}]
[null,null,"Fines",0,0,{"$f":"'Aggregate emission factors'!E16","v":0.039},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!G16","v":0.015},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!E39","v":3.4999999999999994E-4},{"v":0,"d":"0.00"}]
[null,"Screening","Screening",0,0,{"$f":"'Aggregate emission factors'!E18","v":0.025},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!G18","v":0.0087},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!E40","v":0.00025},{"v":0,"d":"0.00"}]
[null,null,"Fines ",0,0,{"$f":"'Aggregate emission factors'!E20","v":0.3},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!G20","v":0.072},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!E41","v":0.0025},{"v":0,"d":"0.00"}]
[null,"Convey and Transfer Points",null,{"$f":"F21*D28","v":0},{"$f":"D34*F21*8760","v":0},{"$f":"'Aggregate emission factors'!E22","v":0.003},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!G22","v":0.0011},{"v":0,"d":"0.00"},{"$f":"'Aggregate emission factors'!E42","v":6.5e-05},{"v":0,"d":"0.00"}]
[null,"Total tons of emissions (excluding combustion from engines)",{"$nulls":4},{"$f":"SUM(G28:G34)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(I28:I34)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(K28:K34)","v":{"v":0,"d":"0.00"}}]
[null,"Emission factor source: see 'Aggregate Emission Factors' tab"]
[]
[]
[null,"Actual emissions - Aggregate: sand and gravel"]
[null,"Enter the actual tons of aggregate that went through the following equipment processes:"]
[null,"a",null,"b","c","d","e","f","g","h"]
[null,"Actual Activity",null,"Actual Throughput","PM Emission Factor","PM Emissions","PM10 Emission Factor","PM10 Emissions","PM2.5 Emission Factor1","PM2.5 Emissions"]
[]
[{"$nulls":3},"(tons/year)","(lb/ton)","(tons/year)","(lb/ton)","(ton/year)","(lb/ton)","(ton/year)"]
[{"$nulls":5},"b*c/2000",null,"b*e/2000",null,"b*g/2000"]
[null,"Crushing","Primary",0,{"$f":"F28","v":0.0007},{"$f":"$D46*E46/2000","v":{"v":0,"d":"0.00"}},{"$f":"H28","v":0.0007},{"$f":"$D46*G46/2000","v":{"v":0,"d":"0.00"}},{"$f":"J28","v":0.0005},{"$f":"$D46*I46/2000","v":{"v":0,"d":"0.00"}}]
[null,null,"Secondary",0,0.025,{"$f":"$D47*E47/2000","v":{"v":0,"d":"0.00"}},0.0087,{"$f":"$D47*G47/2000","v":{"v":0,"d":"0.00"}},0.00025,{"$f":"$D47*I47/2000","v":{"v":0,"d":"0.00"}}]
[null,null,"Tertiary",0,0.0054,{"$f":"$D48*E48/2000","v":{"v":0,"d":"0.00"}},0.0024,{"$f":"$D48*G48/2000","v":{"v":0,"d":"0.00"}},0.0005,{"$f":"$D48*I48/2000","v":{"v":0,"d":"0.00"}}]
[null,null,"Fines",0,0.039,{"$f":"$D49*E49/2000","v":{"v":0,"d":"0.00"}},0.015,{"$f":"$D49*G49/2000","v":{"v":0,"d":"0.00"}},3.4999999999999994E-4,{"$f":"$D49*I49/2000","v":{"v":0,"d":"0.00"}}]
[null,"Screening","Screening",0,0.025,{"$f":"$D50*E50/2000","v":{"v":0,"d":"0.00"}},0.0087,{"$f":"$D50*G50/2000","v":{"v":0,"d":"0.00"}},0.00025,{"$f":"$D50*I50/2000","v":{"v":0,"d":"0.00"}}]
[null,null,"Fines ",0,0.3,{"$f":"$D51*E51/2000","v":{"v":0,"d":"0.00"}},0.072,{"$f":"$D51*G51/2000","v":{"v":0,"d":"0.00"}},0.0025,{"$f":"$D51*I51/2000","v":{"v":0,"d":"0.00"}}]
[null,"Convey and Transfer Points",null,0,0.003,{"$f":"$D52*E52/2000","v":{"v":0,"d":"0.00"}},0.0011,{"$f":"$D52*G52/2000","v":{"v":0,"d":"0.00"}},6.5e-05,{"$f":"$D52*I52/2000","v":{"v":0,"d":"0.00"}}]
[null,"Total tons of emissions (excluding combustion from engines)",{"$nulls":3},{"$f":"SUM(F46:F52)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(H46:H52)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J46:J52)","v":{"v":0,"d":"0.00"}}]
[null,"Emission factor source: see 'Aggregate Emission Factors' tab"]

{"sheet":"Crusher Engine","index":4,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,8],[5,4,5,5],[5,6,5,7],[8,1,8,3],[11,1,11,3],[12,1,12,8],[13,1,13,8],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[17,9,18,9],[33,6,33,8],[60,1,60,4],[61,1,61,4]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[null,"Air emissions from internal combustion engines"]
[null,"For each engine, complete one engine tab and include all information in the blue boxes. "]
[]
[null,"Calculate the potential and actual air emissions from this engine"]
[{"$nulls":3},"Engine and fuel type","Choose one"]
[{"$nulls":3},"Engine use","Choose one"]
[{"$nulls":3},{"$f":"IF($E$6='Data validation'!$A$6,\" \",IF(OR($E$6=rd,$E$6=rg),\"Rated mechanical output\",IF(OR($E$6=pro,OR($E$6=ngl,OR($E$6=ngr,OR($E$6=tng,$E$6=ng2l)))),\"Rated fuel input\",\" \")))","v":" "},0,{"$f":"IF($D$8=\" \",\" \",IF($D$8=\"Rated mechanical output\",'Data validation'!$A$24,IF(AND($D$8=\"Rated fuel input\",$E$6=pro),'Data validation'!$A$26,'Data validation'!$A$25)))","v":" "}]
[null,"Choose one to calculate actual emissions",null,null,0,{"$f":"IF($B$9='Data validation'!$B$5,\" \",IF($B$9='Data validation'!$B$6,'Data validation'!$B$11,IF(AND($B$9='Data validation'!$B$7,OR($E$6=tng,OR($E$6=ngl,OR($E$6=ngr,OR($E$6=ng2l))))),'Data validation'!$B$12,IF(AND($B$9='Data validation'!$B$7,OR($E$6=rd,OR($E$6=rg,OR($E$6=pro)))),'Data validation'!$B$13,\" \"))))","v":" "}]
[{"$nulls":3},{"$f":"IF($F$8=\" \",\" \",IF($F$8='Data validation'!$A$24,'Data validation'!$A$29,IF(OR($F$8='Data validation'!$A$25,$F$8='Data validation'!$A$26),'Data validation'!$A$30)))","v":" "},{"$f":"IF(E6='Data validation'!A6,\" \",IF(E6=rd,'Engine emission factors'!F53,IF(E6=rg,'Engine emission factors'!F54,IF(OR(E6=ngl,OR(E6=ngr,OR(E6=tng,E6=ng2l))),'Engine emission factors'!G52,IF(E6=pro,'Engine emission factors'!H55,\" \")))))","v":" "},{"$f":"IF($D$10=\" \",\" \",IF($D$10='Data validation'!$A$29,\"(Btu/HP-hr)\",IF(AND($D$10='Data validation'!$A$30,$E$6=pro),\"(Btu/gal)\",IF($D$10='Data validation'!$A$30,\"(Btu/scf)\"))))","v":" "}]
[{"$nulls":3},{"$f":"IF($E$6='Data validation'!$A$6,\" \",IF($E$6=rd,\"Heat value of fuel\",IF($E$6=rg,\"Heat value of fuel\",\" \")))","v":" "},{"$f":"IF(E6=rd,'Engine emission factors'!H53,IF(E6=rg,'Engine emission factors'!H54,\" \"))","v":" "},{"$f":"IF($E$6='Data validation'!$A$6,\" \",IF($E$6=rd,\"(Btu/gal)\",IF($E$6=rg,\"(Btu/gal)\",\" \")))","v":" "}]
[null,"Sulfur content of the fuel",null,null,{"$f":"IF(E6=rd,\"0.0015\",IF(E6=pro,\"0.54\",IF(E6=tng,\"0.00065\",\"NA\")))","v":"NA"},{"$f":"IF(OR(E6=rd,E6=tng),\"%\",IF(E6=pro,\"gr/100ft3\",\"\"))","v":""}]
[]
[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","Insignificant Activity4 Limits"]
[]
[{"$nulls":3},"(MMBtu/hr)","(MMBtu/yr)","(hr/yr)","(lbs/MMBtu)","(ton/yr)","(tons/yr)","(tons/yr)"]
[{"$nulls":3},{"$f":"IF(E6=select,0,IF(OR(E6=rd,E6=rg),(E8*E10/10^6),IF(E6=pro,(E8*E10/10^6),IF(OR(E6=ngl,OR(E6=ngr,OR(E6=tng,E6=ng2l))),(E8*E10/(10^6))))))","v":0},{"$f":"IF(F9='Data validation'!B12,E9,IF(AND(F9='Data validation'!B13,E6=rd),(('Engine emission factors'!H53*E9)/1000000),IF(AND(F9='Data validation'!B13,E6=rg),(('Engine emission factors'!H54*E9)/1000000),IF(AND(F9='Data validation'!B13,E6=pro),(('Engine emission factors'!H55*E9)/1000000),IF(F9='Data validation'!B11,(E9*D19),IF(F9=\" \",0))))))","v":0},{"$f":"IF($E$7=so,0,IF($E$7=Routine,8760,IF($E$7=Emer,500)))","v":0},"by pollutant","(b * d * e) / 2000","(c * e) / 2000"]
[null,"Criteria Air Pollutants",{"$nulls":6},"see engine emission factors tab"]
[null,"PM",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C5,'Engine emission factors'!$B5),IF($E$6=rg,'Engine emission factors'!$E5,IF($E$6=tng,'Engine emission factors'!$D5,IF($E$6=ngr,'Engine emission factors'!$F5,IF($E$6=ngl,'Engine emission factors'!$G5,IF($E$6=ng2l,'Engine emission factors'!$H5,IF($E$6=pro,'Engine emission factors'!$I5,IF($E$6=select,'Engine emission factors'!$AA5))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G21/2000","v":{"v":0,"d":"0.00"}},{"$f":"($E$19*$G21)/2000","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.0"}]
[null,"PM10",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C6,'Engine emission factors'!$B6),IF($E$6=rg,'Engine emission factors'!$E6,IF($E$6=tng,'Engine emission factors'!$D6,IF($E$6=ngr,'Engine emission factors'!$F6,IF($E$6=ngl,'Engine emission factors'!$G6,IF($E$6=ng2l,'Engine emission factors'!$H6,IF($E$6=pro,'Engine emission factors'!$I6,IF($E$6=select,'Engine emission factors'!$AA6))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G22/2000","v":{"v":0,"d":"0.00"}},{"$f":"($E$19*$G22)/2000","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.0"}]
[null,"PM2.5",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C7,'Engine emission factors'!$B7),IF($E$6=rg,'Engine emission factors'!$E7,IF($E$6=tng,'Engine emission factors'!$D7,IF($E$6=ngr,'Engine emission factors'!$F7,IF($E$6=ngl,'Engine emission factors'!$G7,IF($E$6=ng2l,'Engine emission factors'!$H7,IF($E$6=pro,'Engine emission factors'!$I7,IF($E$6=select,'Engine emission factors'!$AA7))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"SOx",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C8*$E$12,'Engine emission factors'!$B8*$E$12),IF($E$6=rg,'Engine emission factors'!$E8,IF($E$6=tng,'Engine emission factors'!$D8*$E$12,IF($E$6=ngr,'Engine emission factors'!$F8,IF($E$6=ngl,'Engine emission factors'!$G8,IF($E$6=ng2l,'Engine emission factors'!$H8,IF($E$6=pro,'Engine emission factors'!$I8*$E$12,IF($E$6=select,'Engine emission factors'!$AA8))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.0"}]
[null,"NOx",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C9,'Engine emission factors'!$B9),IF($E$6=rg,'Engine emission factors'!$E9,IF($E$6=tng,'Engine emission factors'!$D9,IF($E$6=ngr,'Engine emission factors'!$F9,IF($E$6=ngl,'Engine emission factors'!$G9,IF($E$6=ng2l,'Engine emission factors'!$H9,IF($E$6=pro,'Engine emission factors'!$I9,IF($E$6=select,'Engine emission factors'!$AA9))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.0"}]
[null,"VOC",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C10,'Engine emission factors'!$B10),IF($E$6=rg,'Engine emission factors'!$E10,IF($E$6=tng,'Engine emission factors'!$D10,IF($E$6=ngr,'Engine emission factors'!$F10,IF($E$6=ngl,'Engine emission factors'!$G10,IF($E$6=ng2l,'Engine emission factors'!$H10,IF($E$6=pro,'Engine emission factors'!$I10,IF($E$6=select,'Engine emission factors'!$AA10))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.0"}]
[null,"CO",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C11,'Engine emission factors'!$B11),IF($E$6=rg,'Engine emission factors'!$E11,IF($E$6=tng,'Engine emission factors'!$D11,IF($E$6=ngr,'Engine emission factors'!$F11,IF($E$6=ngl,'Engine emission factors'!$G11,IF($E$6=ng2l,'Engine emission factors'!$H11,IF($E$6=pro,'Engine emission factors'!$I11,IF($E$6=select,'Engine emission factors'!$AA11))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2,"d":"2.0"}]
[null,"Lead",{"$nulls":4},"n/a",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Greenhouse Gas Emissions",{"$nulls":6},"Source: 40 CFR 98, Subp. C, Table C-1 and C-2"]
[null,"CO2 2",1,{"$nulls":3},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C13,'Engine emission factors'!$B13),IF($E$6=rg,'Engine emission factors'!$E13,IF($E$6=tng,'Engine emission factors'!$D13,IF($E$6=ngr,'Engine emission factors'!$F13,IF($E$6=ngl,'Engine emission factors'!$G13,IF($E$6=ng2l,'Engine emission factors'!$H13,IF($E$6=pro,'Engine emission factors'!$I13,IF($E$6=select,'Engine emission factors'!$AA13))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G30/2000","v":{"v":0,"d":"0.00"}},{"$f":"($E$19*$G30)/2000","v":{"v":0,"d":"0.00"}}]
[null,"CH4 2",25,{"$nulls":3},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C14,'Engine emission factors'!$B14),IF($E$6=rg,'Engine emission factors'!$E14,IF($E$6=tng,'Engine emission factors'!$D14,IF($E$6=ngr,'Engine emission factors'!$F14,IF($E$6=ngl,'Engine emission factors'!$G14,IF($E$6=ng2l,'Engine emission factors'!$H14,IF($E$6=pro,'Engine emission factors'!$I14,IF($E$6=select,'Engine emission factors'!$AA14))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G31/2000","v":{"v":0,"d":"0.0000"}},{"$f":"($E$19*$G31)/2000","v":{"v":0,"d":"0.0000"}}]
[null,"N2O 2",298,{"$nulls":3},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C15,'Engine emission factors'!$B15),IF($E$6=rg,'Engine emission factors'!$E15,IF($E$6=tng,'Engine emission factors'!$D15,IF($E$6=ngr,'Engine emission factors'!$F15,IF($E$6=ngl,'Engine emission factors'!$G15,IF($E$6=ng2l,'Engine emission factors'!$H15,IF($E$6=pro,'Engine emission factors'!$I15,IF($E$6=select,'Engine emission factors'!$Q15))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G32/2000","v":{"v":0,"d":"0.0000"}},{"$f":"($E$19*$G32)/2000","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":5},"GHG total (CO2e) 2",null,{"$f":"(C30*H30)+(C31*H31)+(C32*H32)","v":{"v":0,"d":"0.00"}},{"$f":"(C30*I30)+(C31*I31)+(C32*I32)","v":{"v":0,"d":"0.00"}},1000]
[null,"Hazardous Air Pollutants",{"$nulls":4},"see engine emission factors tab"]
[null,"1,1,2,2-tetrachloroethane",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C17,'Engine emission factors'!$B17),IF($E$6=rg,'Engine emission factors'!$E17,IF($E$6=tng,'Engine emission factors'!$D17,IF($E$6=ngr,'Engine emission factors'!$F17,IF($E$6=ngl,'Engine emission factors'!$G17,IF($E$6=ng2l,'Engine emission factors'!$H17,IF($E$6=pro,'Engine emission factors'!$I17,IF($E$6=select,'Engine emission factors'!$Q17))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G35/2000","v":{"v":0,"d":"0.0000"}},{"$f":"($E$19*$G35)/2000","v":{"v":0,"d":"0.0000"}}]
[null,"1,1,2-trichloroethane",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C18,'Engine emission factors'!$B18),IF($E$6=rg,'Engine emission factors'!$E18,IF($E$6=tng,'Engine emission factors'!$D18,IF($E$6=ngr,'Engine emission factors'!$F18,IF($E$6=ngl,'Engine emission factors'!$G18,IF($E$6=ng2l,'Engine emission factors'!$H18,IF($E$6=pro,'Engine emission factors'!$I18,IF($E$6=select,'Engine emission factors'!$Q18))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"$f":"($E$19*$G36)/2000","v":{"v":0,"d":"0.0000"}}]
[null,"1,3-butadiene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C19,'Engine emission factors'!$B19),IF($E$6=rg,'Engine emission factors'!$E19,IF($E$6=tng,'Engine emission factors'!$D19,IF($E$6=ngr,'Engine emission factors'!$F19,IF($E$6=ngl,'Engine emission factors'!$G19,IF($E$6=ng2l,'Engine emission factors'!$H19,IF($E$6=pro,'Engine emission factors'!$I19,IF($E$6=select,'Engine emission factors'!$Q19))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"1,3-dichloropropene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C20,'Engine emission factors'!$B20),IF($E$6=rg,'Engine emission factors'!$E20,IF($E$6=tng,'Engine emission factors'!$D20,IF($E$6=ngr,'Engine emission factors'!$F20,IF($E$6=ngl,'Engine emission factors'!$G20,IF($E$6=ng2l,'Engine emission factors'!$H20,IF($E$6=pro,'Engine emission factors'!$I20,IF($E$6=select,'Engine emission factors'!$AA20))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Acetaldehyde",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C21,'Engine emission factors'!$B21),IF($E$6=rg,'Engine emission factors'!$E21,IF($E$6=tng,'Engine emission factors'!$D21,IF($E$6=ngr,'Engine emission factors'!$F21,IF($E$6=ngl,'Engine emission factors'!$G21,IF($E$6=ng2l,'Engine emission factors'!$H21,IF($E$6=pro,'Engine emission factors'!$I21,IF($E$6=select,'Engine emission factors'!$AA21))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Acrolein",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C22,'Engine emission factors'!$B22),IF($E$6=rg,'Engine emission factors'!$E22,IF($E$6=tng,'Engine emission factors'!$D22,IF($E$6=ngr,'Engine emission factors'!$F22,IF($E$6=ngl,'Engine emission factors'!$G22,IF($E$6=ng2l,'Engine emission factors'!$H22,IF($E$6=pro,'Engine emission factors'!$I22,IF($E$6=select,'Engine emission factors'!$AA22))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Benzene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C23,'Engine emission factors'!$B23),IF($E$6=rg,'Engine emission factors'!$E23,IF($E$6=tng,'Engine emission factors'!$D23,IF($E$6=ngr,'Engine emission factors'!$F23,IF($E$6=ngl,'Engine emission factors'!$G23,IF($E$6=ng2l,'Engine emission factors'!$H23,IF($E$6=pro,'Engine emission factors'!$I23,IF($E$6=select,'Engine emission factors'!$AA23))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Biphenyl",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C24,'Engine emission factors'!$B24),IF($E$6=rg,'Engine emission factors'!$E24,IF($E$6=tng,'Engine emission factors'!$D24,IF($E$6=ngr,'Engine emission factors'!$F24,IF($E$6=ngl,'Engine emission factors'!$G24,IF($E$6=ng2l,'Engine emission factors'!$H24,IF($E$6=pro,'Engine emission factors'!$I24,IF($E$6=select,'Engine emission factors'!$AA24))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Carbon tetrachloride",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C25,'Engine emission factors'!$B25),IF($E$6=rg,'Engine emission factors'!$E25,IF($E$6=tng,'Engine emission factors'!$D25,IF($E$6=ngr,'Engine emission factors'!$F25,IF($E$6=ngl,'Engine emission factors'!$G25,IF($E$6=ng2l,'Engine emission factors'!$H25,IF($E$6=pro,'Engine emission factors'!$I25,IF($E$6=select,'Engine emission factors'!$AA25))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Chlorobenzene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C26,'Engine emission factors'!$B26),IF($E$6=rg,'Engine emission factors'!$E26,IF($E$6=tng,'Engine emission factors'!$D26,IF($E$6=ngr,'Engine emission factors'!$F26,IF($E$6=ngl,'Engine emission factors'!$G26,IF($E$6=ng2l,'Engine emission factors'!$H26,IF($E$6=pro,'Engine emission factors'!$I26,IF($E$6=select,'Engine emission factors'!$AA26))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Chloroform",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C27,'Engine emission factors'!$B27),IF($E$6=rg,'Engine emission factors'!$E27,IF($E$6=tng,'Engine emission factors'!$D27,IF($E$6=ngr,'Engine emission factors'!$F27,IF($E$6=ngl,'Engine emission factors'!$G27,IF($E$6=ng2l,'Engine emission factors'!$H27,IF($E$6=pro,'Engine emission factors'!$I27,IF($E$6=select,'Engine emission factors'!$AA27))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Ethylbenzene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C28,'Engine emission factors'!$B28),IF($E$6=rg,'Engine emission factors'!$E28,IF($E$6=tng,'Engine emission factors'!$D28,IF($E$6=ngr,'Engine emission factors'!$F28,IF($E$6=ngl,'Engine emission factors'!$G28,IF($E$6=ng2l,'Engine emission factors'!$H28,IF($E$6=pro,'Engine emission factors'!$I28,IF($E$6=select,'Engine emission factors'!$AA28))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Ethylene dibromide",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C29,'Engine emission factors'!$B29),IF($E$6=rg,'Engine emission factors'!$E29,IF($E$6=tng,'Engine emission factors'!$D29,IF($E$6=ngr,'Engine emission factors'!$F29,IF($E$6=ngl,'Engine emission factors'!$G29,IF($E$6=ng2l,'Engine emission factors'!$H29,IF($E$6=pro,'Engine emission factors'!$I29,IF($E$6=select,'Engine emission factors'!$AA29))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Formaldehyde",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C30,'Engine emission factors'!$B30),IF($E$6=rg,'Engine emission factors'!$E30,IF($E$6=tng,'Engine emission factors'!$D30,IF($E$6=ngr,'Engine emission factors'!$F30,IF($E$6=ngl,'Engine emission factors'!$G30,IF($E$6=ng2l,'Engine emission factors'!$H30,IF($E$6=pro,'Engine emission factors'!$I30,IF($E$6=select,'Engine emission factors'!$AA30))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Hexane",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C31,'Engine emission factors'!$B31),IF($E$6=rg,'Engine emission factors'!$E31,IF($E$6=tng,'Engine emission factors'!$D31,IF($E$6=ngr,'Engine emission factors'!$F31,IF($E$6=ngl,'Engine emission factors'!$G31,IF($E$6=ng2l,'Engine emission factors'!$H31,IF($E$6=pro,'Engine emission factors'!$I31,IF($E$6=select,'Engine emission factors'!$AA31))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Methanol",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C32,'Engine emission factors'!$B32),IF($E$6=rg,'Engine emission factors'!$E32,IF($E$6=tng,'Engine emission factors'!$D32,IF($E$6=ngr,'Engine emission factors'!$F32,IF($E$6=ngl,'Engine emission factors'!$G32,IF($E$6=ng2l,'Engine emission factors'!$H32,IF($E$6=pro,'Engine emission factors'!$I32,IF($E$6=select,'Engine emission factors'!$AA32))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Methylene chloride",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C33,'Engine emission factors'!$B33),IF($E$6=rg,'Engine emission factors'!$E33,IF($E$6=tng,'Engine emission factors'!$D33,IF($E$6=ngr,'Engine emission factors'!$F33,IF($E$6=ngl,'Engine emission factors'!$G33,IF($E$6=ng2l,'Engine emission factors'!$H33,IF($E$6=pro,'Engine emission factors'!$I33,IF($E$6=select,'Engine emission factors'!$AA33))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Naphthalene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C34,'Engine emission factors'!$B34),IF($E$6=rg,'Engine emission factors'!$E34,IF($E$6=tng,'Engine emission factors'!$D34,IF($E$6=ngr,'Engine emission factors'!$F34,IF($E$6=ngl,'Engine emission factors'!$G34,IF($E$6=ng2l,'Engine emission factors'!$H34,IF($E$6=pro,'Engine emission factors'!$I34,IF($E$6=select,'Engine emission factors'!$AA34))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"PAH",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C35,'Engine emission factors'!$B35),IF($E$6=rg,'Engine emission factors'!$E35,IF($E$6=tng,'Engine emission factors'!$D35,IF($E$6=ngr,'Engine emission factors'!$F35,IF($E$6=ngl,'Engine emission factors'!$G35,IF($E$6=ng2l,'Engine emission factors'!$H35,IF($E$6=pro,'Engine emission factors'!$I35,IF($E$6=select,'Engine emission factors'!$AA35))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Phenol",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C36,'Engine emission factors'!$B36),IF($E$6=rg,'Engine emission factors'!$E36,IF($E$6=tng,'Engine emission factors'!$D36,IF($E$6=ngr,'Engine emission factors'!$F36,IF($E$6=ngl,'Engine emission factors'!$G36,IF($E$6=ng2l,'Engine emission factors'!$H36,IF($E$6=pro,'Engine emission factors'!$I36,IF($E$6=select,'Engine emission factors'!$AA36))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Styrene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C37,'Engine emission factors'!$B37),IF($E$6=rg,'Engine emission factors'!$E37,IF($E$6=tng,'Engine emission factors'!$D37,IF($E$6=ngr,'Engine emission factors'!$F37,IF($E$6=ngl,'Engine emission factors'!$G37,IF($E$6=ng2l,'Engine emission factors'!$H37,IF($E$6=pro,'Engine emission factors'!$I37,IF($E$6=select,'Engine emission factors'!$AA37))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Tetrachloroethane",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C38,'Engine emission factors'!$B38),IF($E$6=rg,'Engine emission factors'!$E38,IF($E$6=tng,'Engine emission factors'!$D38,IF($E$6=ngr,'Engine emission factors'!$F38,IF($E$6=ngl,'Engine emission factors'!$G38,IF($E$6=ng2l,'Engine emission factors'!$H38,IF($E$6=pro,'Engine emission factors'!$I38,IF($E$6=select,'Engine emission factors'!$AA38))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Toluene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C39,'Engine emission factors'!$B39),IF($E$6=rg,'Engine emission factors'!$E39,IF($E$6=tng,'Engine emission factors'!$D39,IF($E$6=ngr,'Engine emission factors'!$F39,IF($E$6=ngl,'Engine emission factors'!$G39,IF($E$6=ng2l,'Engine emission factors'!$H39,IF($E$6=pro,'Engine emission factors'!$I39,IF($E$6=select,'Engine emission factors'!$AA39))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Vinyl chloride",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C40,'Engine emission factors'!$B40),IF($E$6=rg,'Engine emission factors'!$E40,IF($E$6=tng,'Engine emission factors'!$D40,IF($E$6=ngr,'Engine emission factors'!$F40,IF($E$6=ngl,'Engine emission factors'!$G40,IF($E$6=ng2l,'Engine emission factors'!$H40,IF($E$6=pro,'Engine emission factors'!$I40,IF($E$6=select,'Engine emission factors'!$AA40))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Xylene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C41,'Engine emission factors'!$B41),IF($E$6=rg,'Engine emission factors'!$E41,IF($E$6=tng,'Engine emission factors'!$D41,IF($E$6=ngr,'Engine emission factors'!$F41,IF($E$6=ngl,'Engine emission factors'!$G41,IF($E$6=ng2l,'Engine emission factors'!$H41,IF($E$6=pro,'Engine emission factors'!$I41,IF($E$6=select,'Engine emission factors'!$AA41))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":5},"HAP total",null,{"$f":"SUM(H35:H59)","v":{"v":0,"d":"0.0000"}},{"$f":"SUM(I35:I59)","v":{"v":0,"d":"0.0000"}}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1"]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 Routine = 24 hr/day * 365 day/yr or 8760 hr/yr; Emergency = 500 hr/yr for purposes of calculating potential air emission to identify whether or not a permit is required."]
[null,"4 See information on insignificant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab.",{"$nulls":4},"Minn. R. 7007.1300"]

{"sheet":"Generator","index":5,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,8],[5,4,5,5],[5,6,5,7],[8,1,8,3],[11,1,11,3],[12,1,12,8],[13,1,13,8],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[17,9,18,9],[33,6,33,8],[60,1,60,4],[61,1,61,4]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[null,"Air emissions from internal combustion engines"]
[null,"For each engine, complete one engine tab and include all information in the blue boxes. "]
[]
[null,"Calculate the potential and actual air emissions from this engine"]
[{"$nulls":3},"Engine and fuel type","Choose one"]
[{"$nulls":3},"Engine use","Choose one"]
[{"$nulls":3},{"$f":"IF($E$6='Data validation'!$A$6,\" \",IF(OR($E$6=rd,$E$6=rg),\"Rated mechanical output\",IF(OR($E$6=pro,OR($E$6=ngl,OR($E$6=ngr,OR($E$6=tng,$E$6=ng2l)))),\"Rated fuel input\",\" \")))","v":" "},0,{"$f":"IF($D$8=\" \",\" \",IF($D$8=\"Rated mechanical output\",'Data validation'!$A$24,IF(AND($D$8=\"Rated fuel input\",$E$6=pro),'Data validation'!$A$26,'Data validation'!$A$25)))","v":" "}]
[null,"Choose one to calculate actual emissions",null,null,0,{"$f":"IF($B$9='Data validation'!$B$5,\" \",IF($B$9='Data validation'!$B$6,'Data validation'!$B$11,IF(AND($B$9='Data validation'!$B$7,OR($E$6=tng,OR($E$6=ngl,OR($E$6=ngr,OR($E$6=ng2l))))),'Data validation'!$B$12,IF(AND($B$9='Data validation'!$B$7,OR($E$6=rd,OR($E$6=rg,OR($E$6=pro)))),'Data validation'!$B$13,\" \"))))","v":" "}]
[{"$nulls":3},{"$f":"IF($F$8=\" \",\" \",IF($F$8='Data validation'!$A$24,'Data validation'!$A$29,IF(OR($F$8='Data validation'!$A$25,$F$8='Data validation'!$A$26),'Data validation'!$A$30)))","v":" "},{"$f":"IF(E6='Data validation'!A6,\" \",IF(E6=rd,'Engine emission factors'!F53,IF(E6=rg,'Engine emission factors'!F54,IF(OR(E6=ngl,OR(E6=ngr,OR(E6=tng,E6=ng2l))),'Engine emission factors'!G52,IF(E6=pro,'Engine emission factors'!H55,\" \")))))","v":" "},{"$f":"IF($D$10=\" \",\" \",IF($D$10='Data validation'!$A$29,\"(Btu/HP-hr)\",IF(AND($D$10='Data validation'!$A$30,$E$6=pro),\"(Btu/gal)\",IF($D$10='Data validation'!$A$30,\"(Btu/scf)\"))))","v":" "}]
[{"$nulls":3},{"$f":"IF($E$6='Data validation'!$A$6,\" \",IF($E$6=rd,\"Heat value of fuel\",IF($E$6=rg,\"Heat value of fuel\",\" \")))","v":" "},{"$f":"IF(E6=rd,'Engine emission factors'!H53,IF(E6=rg,'Engine emission factors'!H54,\" \"))","v":" "},{"$f":"IF($E$6='Data validation'!$A$6,\" \",IF($E$6=rd,\"(Btu/gal)\",IF($E$6=rg,\"(Btu/gal)\",\" \")))","v":" "}]
[null,"Sulfur content of the fuel",null,null,{"$f":"IF(E6=rd,\"0.0015\",IF(E6=pro,\"0.54\",IF(E6=tng,\"0.00065\",\"NA\")))","v":"NA"},{"$f":"IF(OR(E6=rd,E6=tng),\"%\",IF(E6=pro,\"gr/100ft3\",\"\"))","v":""}]
[]
[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","Insignificant Activity4 Limits"]
[]
[{"$nulls":3},"(MMBtu/hr)","(MMBtu/yr)","(hr/yr)","(lbs/MMBtu)","(ton/yr)","(tons/yr)","(tons/yr)"]
[{"$nulls":3},{"$f":"IF(E6=select,0,IF(OR(E6=rd,E6=rg),(E8*E10/10^6),IF(E6=pro,(E8*E10/10^6),IF(OR(E6=ngl,OR(E6=ngr,OR(E6=tng,E6=ng2l))),(E8*E10/(10^6))))))","v":0},{"$f":"IF(F9='Data validation'!B12,E9,IF(AND(F9='Data validation'!B13,E6=rd),(('Engine emission factors'!H53*E9)/1000000),IF(AND(F9='Data validation'!B13,E6=rg),(('Engine emission factors'!H54*E9)/1000000),IF(AND(F9='Data validation'!B13,E6=pro),(('Engine emission factors'!H55*E9)/1000000),IF(F9='Data validation'!B11,(E9*D19),IF(F9=\" \",0))))))","v":0},{"$f":"IF($E$7=so,0,IF($E$7=Routine,8760,IF($E$7=Emer,500)))","v":0},"by pollutant","(b * d * e) / 2000","(c * e) / 2000"]
[null,"Criteria Air Pollutants",{"$nulls":6},"see engine emission factors tab"]
[null,"PM",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C5,'Engine emission factors'!$B5),IF($E$6=rg,'Engine emission factors'!$E5,IF($E$6=tng,'Engine emission factors'!$D5,IF($E$6=ngr,'Engine emission factors'!$F5,IF($E$6=ngl,'Engine emission factors'!$G5,IF($E$6=ng2l,'Engine emission factors'!$H5,IF($E$6=pro,'Engine emission factors'!$I5,IF($E$6=select,'Engine emission factors'!$AA5))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G21/2000","v":{"v":0,"d":"0.00"}},{"$f":"($E$19*$G21)/2000","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.0"}]
[null,"PM10",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C6,'Engine emission factors'!$B6),IF($E$6=rg,'Engine emission factors'!$E6,IF($E$6=tng,'Engine emission factors'!$D6,IF($E$6=ngr,'Engine emission factors'!$F6,IF($E$6=ngl,'Engine emission factors'!$G6,IF($E$6=ng2l,'Engine emission factors'!$H6,IF($E$6=pro,'Engine emission factors'!$I6,IF($E$6=select,'Engine emission factors'!$AA6))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G22/2000","v":{"v":0,"d":"0.00"}},{"$f":"($E$19*$G22)/2000","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.0"}]
[null,"PM2.5",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C7,'Engine emission factors'!$B7),IF($E$6=rg,'Engine emission factors'!$E7,IF($E$6=tng,'Engine emission factors'!$D7,IF($E$6=ngr,'Engine emission factors'!$F7,IF($E$6=ngl,'Engine emission factors'!$G7,IF($E$6=ng2l,'Engine emission factors'!$H7,IF($E$6=pro,'Engine emission factors'!$I7,IF($E$6=select,'Engine emission factors'!$AA7))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"SOx",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C8*$E$12,'Engine emission factors'!$B8*$E$12),IF($E$6=rg,'Engine emission factors'!$E8,IF($E$6=tng,'Engine emission factors'!$D8*$E$12,IF($E$6=ngr,'Engine emission factors'!$F8,IF($E$6=ngl,'Engine emission factors'!$G8,IF($E$6=ng2l,'Engine emission factors'!$H8,IF($E$6=pro,'Engine emission factors'!$I8*$E$12,IF($E$6=select,'Engine emission factors'!$AA8))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.0"}]
[null,"NOx",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C9,'Engine emission factors'!$B9),IF($E$6=rg,'Engine emission factors'!$E9,IF($E$6=tng,'Engine emission factors'!$D9,IF($E$6=ngr,'Engine emission factors'!$F9,IF($E$6=ngl,'Engine emission factors'!$G9,IF($E$6=ng2l,'Engine emission factors'!$H9,IF($E$6=pro,'Engine emission factors'!$I9,IF($E$6=select,'Engine emission factors'!$AA9))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.0"}]
[null,"VOC",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C10,'Engine emission factors'!$B10),IF($E$6=rg,'Engine emission factors'!$E10,IF($E$6=tng,'Engine emission factors'!$D10,IF($E$6=ngr,'Engine emission factors'!$F10,IF($E$6=ngl,'Engine emission factors'!$G10,IF($E$6=ng2l,'Engine emission factors'!$H10,IF($E$6=pro,'Engine emission factors'!$I10,IF($E$6=select,'Engine emission factors'!$AA10))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.0"}]
[null,"CO",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C11,'Engine emission factors'!$B11),IF($E$6=rg,'Engine emission factors'!$E11,IF($E$6=tng,'Engine emission factors'!$D11,IF($E$6=ngr,'Engine emission factors'!$F11,IF($E$6=ngl,'Engine emission factors'!$G11,IF($E$6=ng2l,'Engine emission factors'!$H11,IF($E$6=pro,'Engine emission factors'!$I11,IF($E$6=select,'Engine emission factors'!$AA11))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2,"d":"2.0"}]
[null,"Lead",{"$nulls":4},"n/a",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Greenhouse Gas Emissions",{"$nulls":6},"Source: 40 CFR 98, Subp. C, Table C-1 and C-2"]
[null,"CO2 2",1,{"$nulls":3},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C13,'Engine emission factors'!$B13),IF($E$6=rg,'Engine emission factors'!$E13,IF($E$6=tng,'Engine emission factors'!$D13,IF($E$6=ngr,'Engine emission factors'!$F13,IF($E$6=ngl,'Engine emission factors'!$G13,IF($E$6=ng2l,'Engine emission factors'!$H13,IF($E$6=pro,'Engine emission factors'!$I13,IF($E$6=select,'Engine emission factors'!$AA13))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G30/2000","v":{"v":0,"d":"0.00"}},{"$f":"($E$19*$G30)/2000","v":{"v":0,"d":"0.00"}}]
[null,"CH4 2",25,{"$nulls":3},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C14,'Engine emission factors'!$B14),IF($E$6=rg,'Engine emission factors'!$E14,IF($E$6=tng,'Engine emission factors'!$D14,IF($E$6=ngr,'Engine emission factors'!$F14,IF($E$6=ngl,'Engine emission factors'!$G14,IF($E$6=ng2l,'Engine emission factors'!$H14,IF($E$6=pro,'Engine emission factors'!$I14,IF($E$6=select,'Engine emission factors'!$AA14))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G31/2000","v":{"v":0,"d":"0.0000"}},{"$f":"($E$19*$G31)/2000","v":{"v":0,"d":"0.0000"}}]
[null,"N2O 2",298,{"$nulls":3},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C15,'Engine emission factors'!$B15),IF($E$6=rg,'Engine emission factors'!$E15,IF($E$6=tng,'Engine emission factors'!$D15,IF($E$6=ngr,'Engine emission factors'!$F15,IF($E$6=ngl,'Engine emission factors'!$G15,IF($E$6=ng2l,'Engine emission factors'!$H15,IF($E$6=pro,'Engine emission factors'!$I15,IF($E$6=select,'Engine emission factors'!$Q15))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G32/2000","v":{"v":0,"d":"0.0000"}},{"$f":"($E$19*$G32)/2000","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":5},"GHG total (CO2e) 2",null,{"$f":"(C30*H30)+(C31*H31)+(C32*H32)","v":{"v":0,"d":"0.00"}},{"$f":"(C30*I30)+(C31*I31)+(C32*I32)","v":{"v":0,"d":"0.00"}},1000]
[null,"Hazardous Air Pollutants",{"$nulls":4},"see engine emission factors tab"]
[null,"1,1,2,2-tetrachloroethane",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C17,'Engine emission factors'!$B17),IF($E$6=rg,'Engine emission factors'!$E17,IF($E$6=tng,'Engine emission factors'!$D17,IF($E$6=ngr,'Engine emission factors'!$F17,IF($E$6=ngl,'Engine emission factors'!$G17,IF($E$6=ng2l,'Engine emission factors'!$H17,IF($E$6=pro,'Engine emission factors'!$I17,IF($E$6=select,'Engine emission factors'!$Q17))))))))","v":{"v":0,"d":"0.0000"}},{"$f":"$D$19*$F$19*$G35/2000","v":{"v":0,"d":"0.0000"}},{"$f":"($E$19*$G35)/2000","v":{"v":0,"d":"0.0000"}}]
[null,"1,1,2-trichloroethane",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C18,'Engine emission factors'!$B18),IF($E$6=rg,'Engine emission factors'!$E18,IF($E$6=tng,'Engine emission factors'!$D18,IF($E$6=ngr,'Engine emission factors'!$F18,IF($E$6=ngl,'Engine emission factors'!$G18,IF($E$6=ng2l,'Engine emission factors'!$H18,IF($E$6=pro,'Engine emission factors'!$I18,IF($E$6=select,'Engine emission factors'!$Q18))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"$f":"($E$19*$G36)/2000","v":{"v":0,"d":"0.0000"}}]
[null,"1,3-butadiene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C19,'Engine emission factors'!$B19),IF($E$6=rg,'Engine emission factors'!$E19,IF($E$6=tng,'Engine emission factors'!$D19,IF($E$6=ngr,'Engine emission factors'!$F19,IF($E$6=ngl,'Engine emission factors'!$G19,IF($E$6=ng2l,'Engine emission factors'!$H19,IF($E$6=pro,'Engine emission factors'!$I19,IF($E$6=select,'Engine emission factors'!$Q19))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"1,3-dichloropropene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C20,'Engine emission factors'!$B20),IF($E$6=rg,'Engine emission factors'!$E20,IF($E$6=tng,'Engine emission factors'!$D20,IF($E$6=ngr,'Engine emission factors'!$F20,IF($E$6=ngl,'Engine emission factors'!$G20,IF($E$6=ng2l,'Engine emission factors'!$H20,IF($E$6=pro,'Engine emission factors'!$I20,IF($E$6=select,'Engine emission factors'!$AA20))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Acetaldehyde",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C21,'Engine emission factors'!$B21),IF($E$6=rg,'Engine emission factors'!$E21,IF($E$6=tng,'Engine emission factors'!$D21,IF($E$6=ngr,'Engine emission factors'!$F21,IF($E$6=ngl,'Engine emission factors'!$G21,IF($E$6=ng2l,'Engine emission factors'!$H21,IF($E$6=pro,'Engine emission factors'!$I21,IF($E$6=select,'Engine emission factors'!$AA21))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Acrolein",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C22,'Engine emission factors'!$B22),IF($E$6=rg,'Engine emission factors'!$E22,IF($E$6=tng,'Engine emission factors'!$D22,IF($E$6=ngr,'Engine emission factors'!$F22,IF($E$6=ngl,'Engine emission factors'!$G22,IF($E$6=ng2l,'Engine emission factors'!$H22,IF($E$6=pro,'Engine emission factors'!$I22,IF($E$6=select,'Engine emission factors'!$AA22))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Benzene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C23,'Engine emission factors'!$B23),IF($E$6=rg,'Engine emission factors'!$E23,IF($E$6=tng,'Engine emission factors'!$D23,IF($E$6=ngr,'Engine emission factors'!$F23,IF($E$6=ngl,'Engine emission factors'!$G23,IF($E$6=ng2l,'Engine emission factors'!$H23,IF($E$6=pro,'Engine emission factors'!$I23,IF($E$6=select,'Engine emission factors'!$AA23))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Biphenyl",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C24,'Engine emission factors'!$B24),IF($E$6=rg,'Engine emission factors'!$E24,IF($E$6=tng,'Engine emission factors'!$D24,IF($E$6=ngr,'Engine emission factors'!$F24,IF($E$6=ngl,'Engine emission factors'!$G24,IF($E$6=ng2l,'Engine emission factors'!$H24,IF($E$6=pro,'Engine emission factors'!$I24,IF($E$6=select,'Engine emission factors'!$AA24))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Carbon tetrachloride",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C25,'Engine emission factors'!$B25),IF($E$6=rg,'Engine emission factors'!$E25,IF($E$6=tng,'Engine emission factors'!$D25,IF($E$6=ngr,'Engine emission factors'!$F25,IF($E$6=ngl,'Engine emission factors'!$G25,IF($E$6=ng2l,'Engine emission factors'!$H25,IF($E$6=pro,'Engine emission factors'!$I25,IF($E$6=select,'Engine emission factors'!$AA25))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Chlorobenzene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C26,'Engine emission factors'!$B26),IF($E$6=rg,'Engine emission factors'!$E26,IF($E$6=tng,'Engine emission factors'!$D26,IF($E$6=ngr,'Engine emission factors'!$F26,IF($E$6=ngl,'Engine emission factors'!$G26,IF($E$6=ng2l,'Engine emission factors'!$H26,IF($E$6=pro,'Engine emission factors'!$I26,IF($E$6=select,'Engine emission factors'!$AA26))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Chloroform",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C27,'Engine emission factors'!$B27),IF($E$6=rg,'Engine emission factors'!$E27,IF($E$6=tng,'Engine emission factors'!$D27,IF($E$6=ngr,'Engine emission factors'!$F27,IF($E$6=ngl,'Engine emission factors'!$G27,IF($E$6=ng2l,'Engine emission factors'!$H27,IF($E$6=pro,'Engine emission factors'!$I27,IF($E$6=select,'Engine emission factors'!$AA27))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Ethylbenzene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C28,'Engine emission factors'!$B28),IF($E$6=rg,'Engine emission factors'!$E28,IF($E$6=tng,'Engine emission factors'!$D28,IF($E$6=ngr,'Engine emission factors'!$F28,IF($E$6=ngl,'Engine emission factors'!$G28,IF($E$6=ng2l,'Engine emission factors'!$H28,IF($E$6=pro,'Engine emission factors'!$I28,IF($E$6=select,'Engine emission factors'!$AA28))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Ethylene dibromide",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C29,'Engine emission factors'!$B29),IF($E$6=rg,'Engine emission factors'!$E29,IF($E$6=tng,'Engine emission factors'!$D29,IF($E$6=ngr,'Engine emission factors'!$F29,IF($E$6=ngl,'Engine emission factors'!$G29,IF($E$6=ng2l,'Engine emission factors'!$H29,IF($E$6=pro,'Engine emission factors'!$I29,IF($E$6=select,'Engine emission factors'!$AA29))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Formaldehyde",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C30,'Engine emission factors'!$B30),IF($E$6=rg,'Engine emission factors'!$E30,IF($E$6=tng,'Engine emission factors'!$D30,IF($E$6=ngr,'Engine emission factors'!$F30,IF($E$6=ngl,'Engine emission factors'!$G30,IF($E$6=ng2l,'Engine emission factors'!$H30,IF($E$6=pro,'Engine emission factors'!$I30,IF($E$6=select,'Engine emission factors'!$AA30))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Hexane",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C31,'Engine emission factors'!$B31),IF($E$6=rg,'Engine emission factors'!$E31,IF($E$6=tng,'Engine emission factors'!$D31,IF($E$6=ngr,'Engine emission factors'!$F31,IF($E$6=ngl,'Engine emission factors'!$G31,IF($E$6=ng2l,'Engine emission factors'!$H31,IF($E$6=pro,'Engine emission factors'!$I31,IF($E$6=select,'Engine emission factors'!$AA31))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Methanol",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C32,'Engine emission factors'!$B32),IF($E$6=rg,'Engine emission factors'!$E32,IF($E$6=tng,'Engine emission factors'!$D32,IF($E$6=ngr,'Engine emission factors'!$F32,IF($E$6=ngl,'Engine emission factors'!$G32,IF($E$6=ng2l,'Engine emission factors'!$H32,IF($E$6=pro,'Engine emission factors'!$I32,IF($E$6=select,'Engine emission factors'!$AA32))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Methylene chloride",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C33,'Engine emission factors'!$B33),IF($E$6=rg,'Engine emission factors'!$E33,IF($E$6=tng,'Engine emission factors'!$D33,IF($E$6=ngr,'Engine emission factors'!$F33,IF($E$6=ngl,'Engine emission factors'!$G33,IF($E$6=ng2l,'Engine emission factors'!$H33,IF($E$6=pro,'Engine emission factors'!$I33,IF($E$6=select,'Engine emission factors'!$AA33))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Naphthalene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C34,'Engine emission factors'!$B34),IF($E$6=rg,'Engine emission factors'!$E34,IF($E$6=tng,'Engine emission factors'!$D34,IF($E$6=ngr,'Engine emission factors'!$F34,IF($E$6=ngl,'Engine emission factors'!$G34,IF($E$6=ng2l,'Engine emission factors'!$H34,IF($E$6=pro,'Engine emission factors'!$I34,IF($E$6=select,'Engine emission factors'!$AA34))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"PAH",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C35,'Engine emission factors'!$B35),IF($E$6=rg,'Engine emission factors'!$E35,IF($E$6=tng,'Engine emission factors'!$D35,IF($E$6=ngr,'Engine emission factors'!$F35,IF($E$6=ngl,'Engine emission factors'!$G35,IF($E$6=ng2l,'Engine emission factors'!$H35,IF($E$6=pro,'Engine emission factors'!$I35,IF($E$6=select,'Engine emission factors'!$AA35))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Phenol",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C36,'Engine emission factors'!$B36),IF($E$6=rg,'Engine emission factors'!$E36,IF($E$6=tng,'Engine emission factors'!$D36,IF($E$6=ngr,'Engine emission factors'!$F36,IF($E$6=ngl,'Engine emission factors'!$G36,IF($E$6=ng2l,'Engine emission factors'!$H36,IF($E$6=pro,'Engine emission factors'!$I36,IF($E$6=select,'Engine emission factors'!$AA36))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Styrene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C37,'Engine emission factors'!$B37),IF($E$6=rg,'Engine emission factors'!$E37,IF($E$6=tng,'Engine emission factors'!$D37,IF($E$6=ngr,'Engine emission factors'!$F37,IF($E$6=ngl,'Engine emission factors'!$G37,IF($E$6=ng2l,'Engine emission factors'!$H37,IF($E$6=pro,'Engine emission factors'!$I37,IF($E$6=select,'Engine emission factors'!$AA37))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Tetrachloroethane",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C38,'Engine emission factors'!$B38),IF($E$6=rg,'Engine emission factors'!$E38,IF($E$6=tng,'Engine emission factors'!$D38,IF($E$6=ngr,'Engine emission factors'!$F38,IF($E$6=ngl,'Engine emission factors'!$G38,IF($E$6=ng2l,'Engine emission factors'!$H38,IF($E$6=pro,'Engine emission factors'!$I38,IF($E$6=select,'Engine emission factors'!$AA38))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Toluene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C39,'Engine emission factors'!$B39),IF($E$6=rg,'Engine emission factors'!$E39,IF($E$6=tng,'Engine emission factors'!$D39,IF($E$6=ngr,'Engine emission factors'!$F39,IF($E$6=ngl,'Engine emission factors'!$G39,IF($E$6=ng2l,'Engine emission factors'!$H39,IF($E$6=pro,'Engine emission factors'!$I39,IF($E$6=select,'Engine emission factors'!$AA39))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Vinyl chloride",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C40,'Engine emission factors'!$B40),IF($E$6=rg,'Engine emission factors'!$E40,IF($E$6=tng,'Engine emission factors'!$D40,IF($E$6=ngr,'Engine emission factors'!$F40,IF($E$6=ngl,'Engine emission factors'!$G40,IF($E$6=ng2l,'Engine emission factors'!$H40,IF($E$6=pro,'Engine emission factors'!$I40,IF($E$6=select,'Engine emission factors'!$AA40))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,"Xylene",{"$nulls":4},{"$f":"IF($E$6=rd,IF($E$8>=600,'Engine emission factors'!$C41,'Engine emission factors'!$B41),IF($E$6=rg,'Engine emission factors'!$E41,IF($E$6=tng,'Engine emission factors'!$D41,IF($E$6=ngr,'Engine emission factors'!$F41,IF($E$6=ngl,'Engine emission factors'!$G41,IF($E$6=ng2l,'Engine emission factors'!$H41,IF($E$6=pro,'Engine emission factors'!$I41,IF($E$6=select,'Engine emission factors'!$AA41))))))))","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[{"$nulls":5},"HAP total",null,{"$f":"SUM(H35:H59)","v":{"v":0,"d":"0.0000"}},{"$f":"SUM(I35:I59)","v":{"v":0,"d":"0.0000"}}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1"]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 Routine = 24 hr/day * 365 day/yr or 8760 hr/yr; Emergency = 500 hr/yr for purposes of calculating potential air emission to identify whether or not a permit is required."]
[null,"4 See information on insignificant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab.",{"$nulls":4},"Minn. R. 7007.1300"]

{"sheet":"Fugitive","index":6,"n_rows":91,"n_cols":21,"rows_kept":91,"merged":[[0,1,0,8],[1,1,1,8],[2,1,2,8],[3,1,3,8],[4,1,5,8],[6,1,6,8],[7,1,7,8],[8,2,8,8],[9,2,9,3],[9,4,10,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,2,14,3],[15,1,16,1],[15,2,16,3],[15,4,18,7],[17,1,18,1],[17,2,18,3],[19,1,19,8],[20,2,20,3],[20,4,21,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[26,5,26,7],[27,5,27,7],[28,5,28,7],[29,1,29,2],[30,4,30,7],[31,1,31,2],[32,1,32,2],[33,5,33,8],[34,1,34,2],[34,4,34,7],[35,1,35,2],[35,4,35,7],[36,1,36,2],[36,6,36,7],[37,1,37,8],[44,1,44,8],[45,1,45,2],[46,1,46,2],[46,4,46,8],[46,19,47,19],[46,20,47,20],[47,1,47,2],[47,4,47,7],[48,1,48,2],[49,1,49,2],[50,1,50,8],[51,1,51,8],[52,1,52,2],[52,4,52,8],[53,1,53,2],[53,4,53,8],[54,1,54,2],[55,1,55,2],[56,1,56,2],[56,4,56,7],[59,1,63,1],[59,2,59,3],[59,4,59,5],[59,6,59,7],[60,2,60,3],[60,4,60,5],[60,6,60,7],[61,2,61,3],[61,4,61,5],[61,6,61,7],[61,8,62,8],[69,1,73,1],[69,2,69,3],[69,4,69,5],[69,6,69,7],[70,2,70,3],[70,4,70,5],[70,6,70,7],[71,2,71,3],[71,4,71,5],[71,6,71,7],[71,8,72,8],[78,2,78,3],[78,6,78,7],[79,4,79,8],[80,5,80,8],[81,5,81,8],[82,7,89,8],[83,1,83,2],[85,1,85,3]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[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,"More information on fugitive dust emissions management and best practices can be found here: "]
[null,"https://www.pca.state.mn.us/sites/default/files/p-sbap5-45.pdf"]
[]
[null,null,"Throughput  (maximum capacity) ",null,"<-------- The maximum throughput used on the aggregate tab for potential emissions is automatically entered here."]
[null,null,{"$f":"SUM(Aggregate!E28:E34)","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 aggregate processed which, you entered into the aggregate tab, is used here. "]
[null,null,{"$f":"SUM(Aggregate!D46:D52)","v":0},"tons/year"]
[]
[null,"Unpaved road2"]
[null,"Enter the data for your trucks below to calculate unpaved road emissions."]
[{"$nulls":3},"Vehicle 1","Vehicle 2",{"$nulls":5},"Table A. Typical silt content values of surface material on industrial unpaved roads"]
[null,"% of total trips made by vehicle",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},"W = mean vehicle weight (ton)",null,null,{"$f":"D27*((D28+D29)/2)+E27*((E28+E29)/2)","v":{"v":0,"d":"0.0"}},null,"AP-42 Table 13.2.2-1"]
[null,"Empty weight of vehicle (tons)",null,0,0,"Vpotential = # vehicle trips / yr",null,null,{"$f":"IFERROR(IF(($C$11/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28))))=0,0,IF(($C$11/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28))))>0,($C$11/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28)))))),0)","v":0},null,"Industry","Road use","Mean Silt Content (%)"]
[null,"Full weight of loaded vehicle (tons)",null,0,0,"Vactual = # vehicle trips / yr",null,null,{"$f":"IFERROR(IF(((C22)/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28))))=0,0,IF((C22)/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28)))>0,((C22)/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28)))))),0)","v":0},null,"Copper smelting","Plant road",17]
[null,"S = speed on unpaved road, mph",null,0,{"$nulls":6},"Iron and steel production","Plant road",6]
[null,"m = miles of unpaved road per trip",null,0,"Potential Vehicle Miles Traveled (VMT)/yr = Vpotential x miles",{"$nulls":3},{"$f":"IF((I28*D31)>0,(I28*D31),0)","v":{"v":0,"d":"0.00"}},null,"Sand and gravel processing","Plant road",4.8]
[null,"M = surface moisture content (%)",null,0.5,"Enter site data9,10",null,null,"Actual Vehicle Miles Traveled (VMT)/yr = Vactual x miles",{"$f":"IF((I29*D31)>0,(I29*D31),0)","v":{"v":0,"d":"0.00"}},null,null,"Material storage area",7.1]
[null,"s = silt content of road (%)",null,"Enter from Table","See Table A",{"$nulls":5},"Stone quarrying and processing","Plant road",10]
[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",{"$nulls":5},"Haul road to/from pit",8.3]
[null,"k = PM particle size multiplier ",null,6,"PM emission factor (lb/VMT)",{"$nulls":3},{"$f":"IFERROR((((D35*((D33/12)^1)*((D30/30)^0.3)/((D32/0.5)^0.3))-0.00047)*((365-D34)/365)),0)","v":{"v":0,"d":"0.00"}},null,"Taconite mining and processing","Plant road",4.3]
[null,"k10 = PM10 particle size multiplier ",null,1.8,"PM10 emission factor (lb/VMT)",{"$nulls":3},{"$f":"IFERROR((((D36*((D33/12)^1)*((D30/30)^0.5)/((D32/0.5)^0.2))-0.00047)*((365-D34)/365)),0)","v":{"v":0,"d":"0.00"}},null,null,"Haul road to/from pit",5.8]
[null,"k2.5 = PM2.5 particle size multiplier ",null,0.18,null,null,"PM2.5 emission factor (lb/VMT)",null,{"$f":"IFERROR((((D37*((D33/12)^1)*((D30/30)^0.5)/((D32/0.5)^0.2))-0.00036)*((365-D34)/365)),0)","v":{"v":0,"d":"0.00"}},null,"Western surface coal mining","Plant road",5.1]
[{"$nulls":11},"Haul road to/from pit",8.4]
[{"$nulls":11},"Scraper route",17]
[{"$nulls":11},"Haul road (freshly graded)",24]
[{"$nulls":10},"Construction sites","Scraper routes",8.5]
[{"$nulls":10},"Lumber sawmills","Log yards",8.4]
[{"$nulls":10},"Municipal solid waste landfills","Disposal routes",6.4]
[]
[null,"Material handling at stockpiles5"]
[null,"k = PM particle size multiplier ",null,0.74,{"$nulls":6},"Table B. Typical silt and moisture contents of materials at various industries ",{"$nulls":4},"Table C. Wind erosion of ground pile"]
[null,"k10 = PM10 particle size multiplier ",null,0.35,"Material handling emission factor equation6",{"$nulls":5},"AP-42 Table 13.2.4-1",{"$nulls":4},"Values are over a 5-year period",{"$nulls":3},"Percent of Hours Greater Than 12 mph","Mean wind speed (mph) (2018-2022)"]
[null,"k2.5 = PM2.5 particle size multiplier ",null,0.053,"PM emission factor (lb/ton)",{"$nulls":3},{"$f":"IFERROR((D46*0.0032*(((D49/5)^1.3)/((D50/2)^1.4))),0)","v":{"v":0,"d":"0.0000"}},null,"Industry","Material","Silt Content (%)","Moisture Content (%)",null,"Station","City","County","State"]
[null,"U = mean wind speed (mph)",null,"Enter from Table","See Table B",null,null,"PM10 emission factor (lb/ton)",{"$f":"IFERROR((D47*0.0032*(((D49/5)^1.3)/((D50/2)^1.4))),0)","v":{"v":0,"d":"0.0000"}},null,"Iron and steel production ","Pellet ore ",4.3,2.2,null,"KRST","Rochester","Olmsted","MN",40.9,{"v":11.25881852048962,"d":"11.3"}]
[null,"M = material moisture content (%)",null,"Enter from Table","See Table C",null,null,"PM2.5 emission factor (lb/ton)",{"$f":"IFERROR((D48*0.0032*(((D49/5)^1.3)/((D50/2)^1.4))),0)","v":{"v":0,"d":"0.0000"}},null,null,"Lump ore ",9.5,5.4,null,"KMML","Marshall","Lyon","MN",39.2,{"v":11.72421493902438,"d":"11.7"}]
[{"$nulls":11},"Coal ",4.6,4.8,null,"KAXN","Alexandria","Douglas","MN",35.2,{"v":10.126875334403408,"d":"10.1"}]
[null,"Wind erosion of ground pile7",{"$nulls":9},"Slag ",5.3,0.92,null,"KDLH","Duluth Intl","Saint Louis","MN",33.5,{"v":9.86407978723404,"d":"9.9"}]
[null,"d = # days pile is active per year",null,0,{"$nulls":7},"Flue dust ",13,7,null,"KMKT","Mankato","Blue Earth","MN",31.2,{"v":10.291786292498655,"d":"10.3"}]
[null,"a = acres of pile base",null,0,"Wind erosion emission factor reference8, 9",{"$nulls":6},"Coke breeze ",4.9,7.8,null,"KHCO","Hallock","Kittson","MN",31.2,"--"]
[null,"s = silt content of material (%)",null,"Enter from Table","See Table B",null,null,"PM emission factor (lb/day*acre)",{"$f":"IFERROR((1.7*(D55/1.5)*((365-D57)/235)*(D56/15)),0)","v":{"v":0,"d":"0.00"}},null,null,"Blended ore ",15,6.6,null,"KRWF","Redwood Falls","Redwood","MN",30.5,{"v":9.645530101225358,"d":"9.6"}]
[null,"f = % wind > 12 mph at pile height",null,"Enter from Table","See Table C or enter 43.1",null,null,"PM10 emission factor  = PM * 50%",{"$f":"I55*0.5","v":{"v":0,"d":"0.00"}},null,null,"Sinter ",0.7,"--",null,"KMSP","Minneapolis","Hennepin","MN",28.2,{"v":9.037175531914892,"d":"9.0"}]
[null,"p = # of days w/ >=0.01\" precip/yr",null,{"$f":"(133+121+115+109+108)/5","v":117.2},"4",{"$nulls":3},{"$f":"I56*0.075","v":{"v":0,"d":"0.00"}},null,null,"Limestone ",1,0.2,null,"KPKD","Park Rapids","Hubbard","MN",27.2,{"v":8.674084356647093,"d":"8.7"}]
[{"$nulls":10},"Stone quarrying and processing","Crushed limestone",1.6,0.7,null,"KSTP","St Paul","Ramsey","MN",24.9,{"v":8.257350746268653,"d":"8.3"}]
[null,"Fugitive emission totals",{"$nulls":9},"Various limestone products",3.9,2.1,null,"KBDE","Baudette","Lake of the Woods","MN",24.8,{"v":8.352129527991206,"d":"8.4"}]
[null,"Potential fugitive emissions","Unpaved road",null,"Material handling at stockpiles",null,"Wind erosion of ground pile",{"$nulls":3},"Taconite mining and processing","Pellets ",3.4,0.9,null,"KFCM","Eden Prarie","Hennepin","MN",23,{"v":8.34364555614688,"d":"8.3"}]
[null,null,"(VMT/yr)",null,"(ton/yr)",null,"(365d*a/yr)",{"$nulls":4},"Tailings ",11,0.4,null,"KSTC","St Cloud","Sherburne","MN",22.7,{"v":7.948307610431076,"d":"7.9"}]
[null,null,{"$f":"I31","v":0},null,{"$f":"C11","v":0},null,{"$f":"D54*365","v":0},null,"Total potential emissions",null,"Western surface coal mining","Coal ",6.2,6.9,null,"KMIC","Crystal","Hennepin","MN",21.7,{"v":7.843284473398483,"d":"7.8"}]
[null,null,"Emission factor","Potential","Emission factor","Potential","Emission factor","Potential",{"$nulls":3},"Overburden ",7.5,"--",null,"KBRD","Brainerd","Crow Wing","MN",20.9,{"v":7.685705162320376,"d":"7.7"}]
[null,null,"(lb/VMT)","(ton/yr)","(lb/ton)","(ton/yr)","(lb/d*acre)","(ton/yr)","(ton/year)",null,null,"Exposed ground ",15,3.4,null,"KHIB","Hibbing","Saint Louis","MN",15.8,{"v":6.581992541289298,"d":"6.6"}]
[null,"PM",{"$f":"I35","v":{"v":0,"d":"0.00"}},{"$f":"C62*C65/2000","v":{"v":0,"d":"0.00"}},{"$f":"I48","v":{"v":0,"d":"0.0000"}},{"$f":"E62*E65/2000","v":{"v":0,"d":"0.00"}},{"$f":"I55","v":{"v":0,"d":"0.00"}},{"$f":"G65*$G$62/2000","v":{"v":0,"d":"0.00"}},{"$f":"(D65+F65+H65)","v":{"v":0,"d":"0.00"}},null,"Coal-fired power plant","Coal ( as received) ",2.2,4.5,null,"KINL","International Falls","Koochiching","MN",13.5,{"v":6.804078452444918,"d":"6.8"}]
[null,"PM10",{"$f":"I36","v":{"v":0,"d":"0.00"}},{"$f":"C62*C66/2000","v":{"v":0,"d":"0.00"}},{"$f":"I49","v":{"v":0,"d":"0.0000"}},{"$f":"E62*E66/2000","v":{"v":0,"d":"0.00"}},{"$f":"I56","v":{"v":0,"d":"0.00"}},{"$f":"G66*$G$62/2000","v":{"v":0,"d":"0.00"}},{"$f":"(D66+F66+H66)","v":{"v":0,"d":"0.00"}},null,"Municipal solid waste landfills","Sand ",2.6,7.4,null,"KEST","Estherville","Emmet","IA",43.1,{"v":11.666423629590208,"d":"11.7"}]
[null,"PM2.5",{"$f":"I37","v":{"v":0,"d":"0.00"}},{"$f":"C62*C67/2000","v":{"v":0,"d":"0.00"}},{"$f":"I50","v":{"v":0,"d":"0.0000"}},{"$f":"E62*E67/2000","v":{"v":0,"d":"0.00"}},{"$f":"I57","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"(D67+F67+H67)","v":{"v":0,"d":"0.00"}},null,null,"Slag ",3.8,3.6,null,"KMCW","Mason City","Cerro Gordo","IA",40.5,{"v":10.964177754124531,"d":"11.0"}]
[{"$nulls":11},"Cover ",9,12,null,"KFAR","Fargo","Cass","ND",40.3,{"v":10.930995210218205,"d":"10.9"}]
[{"$nulls":11},"Clay/dirt mix",9.2,14,null,"KGFK","Grand Forks","Grand Forks","ND",38.1,{"v":10.73090957446807,"d":"10.7"}]
[null,"Actual fugitive emissions","Unpaved road",null,"Material handling at stockpiles",null,"Wind erosion of ground pile",{"$nulls":4},"Clay",6,10,null,"KFSD","Sioux Falls","Minnehaha","SD",35.2,{"v":9.860420212765938,"d":"9.9"}]
[null,null,"(VMT/yr)",null,"(ton/yr)",null,"(d*a/yr)",{"$nulls":4},"Fly ash ",80,27,null,"KLSE","La Crosse","La Crosse","WI",22,{"v":8.126109632783376,"d":"8.1"}]
[null,null,{"$f":"I32","v":0},null,{"$f":"C22","v":0},null,{"$f":"D53*D54","v":0},null,"Total actual emissions",null,null,"Misc. fill materials",12,11]
[null,null,"Emission factor","Actual","Emission factor","Actual","Emission factor","Actual"]
[null,null,"(lb/VMT)","(ton/yr)","(lb/ton)","(ton/yr)","(lb/d*acre)","(ton/yr)","(ton/year)"]
[null,"PM",{"$f":"I35","v":{"v":0,"d":"0.00"}},{"$f":"C72*C75/2000","v":{"v":0,"d":"0.00"}},{"$f":"E65","v":{"v":0,"d":"0.0000"}},{"$f":"E72*E75/2000","v":{"v":0,"d":"0.00"}},{"$f":"I55","v":{"v":0,"d":"0.00"}},{"$f":"$G$72*G75/2000","v":{"v":0,"d":"0.00"}},{"$f":"D75+F75+H75","v":{"v":0,"d":"0.00"}}]
[null,"PM10",{"$f":"I36","v":{"v":0,"d":"0.00"}},{"$f":"C72*C76/2000","v":{"v":0,"d":"0.00"}},{"$f":"E66","v":{"v":0,"d":"0.0000"}},{"$f":"E72*E76/2000","v":{"v":0,"d":"0.00"}},{"$f":"I56","v":{"v":0,"d":"0.00"}},{"$f":"$G$72*G76/2000","v":{"v":0,"d":"0.00"}},{"$f":"D76+F76+H76","v":{"v":0,"d":"0.00"}}]
[null,"PM2.5",{"$f":"I37","v":{"v":0,"d":"0.00"}},{"$f":"C72*C77/2000","v":{"v":0,"d":"0.00"}},{"$f":"E67","v":{"v":0,"d":"0.0000"}},{"$f":"E72*E77/2000","v":{"v":0,"d":"0.00"}},{"$f":"I57","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"D77+F77+H77","v":{"v":0,"d":"0.00"}}]
[]
[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)",{"$nulls":3},"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)",{"$nulls":3},"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 from continuously active piles"]
[null,"EPA Control of open fugitive dust sources, Sept. 1988, Equation 4-9"]
[null,"8 Wind erosion emission factor equation (lb/day/acre)=1.7(s/1.5)((365-p)/235)(f/15)"]
[null,"9 PM10 and PM2.5 fractions, updated Nov 2006"]
[null,"AP-42 13.2.5 Aerodynamic particle size multipliers for Equation 2"]
[null,"10 Default moisture content value of 0.5 percent in Equation 1b is discouraged and reduces emission factor quality by 2 letters."]

{"sheet":"Potential emissions","index":7,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,5,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[46,2,46,3]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[null,"Potential emissions - Aggregate: sand & gravel"]
[null,{"$f":"IF('Data validation'!C22=\"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","Aggregate","Crusher Engine","Generator","Fugitives","Potential Emissions","Permitting Threshold"]
[]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants"]
[null,"PM",{"$f":"Aggregate!G35","v":{"v":0,"d":"0.00"}},{"$f":"'Crusher Engine'!H21","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H21","v":{"v":0,"d":"0.00"}},{"$f":"Fugitive!I65","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C8:F8)","v":{"v":0,"d":"0.00"}},100]
[null,"PM10",{"$f":"Aggregate!I35","v":{"v":0,"d":"0.00"}},{"$f":"'Crusher Engine'!H22","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H22","v":{"v":0,"d":"0.00"}},{"$f":"Fugitive!I66","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},25]
[null,"PM2.5",{"$f":"Aggregate!K35","v":{"v":0,"d":"0.00"}},{"$f":"'Crusher Engine'!H23","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H23","v":{"v":0,"d":"0.00"}},{"$f":"Fugitive!I67","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},100]
[null,"SOx",null,{"$f":"'Crusher Engine'!H24","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H24","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},50]
[null,"NOx",null,{"$f":"'Crusher Engine'!H25","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H25","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},100]
[null,"VOC",null,{"$f":"'Crusher Engine'!H26","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H26","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},100]
[null,"CO",null,{"$f":"'Crusher Engine'!H27","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H27","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},100]
[null,"Lead",null,{"$f":"'Crusher Engine'!H28","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H28","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",null,{"$f":"'Crusher Engine'!H30","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H30","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C17:F17)","v":{"v":0,"d":"0.00"}}]
[null,"CH4",null,{"$f":"'Crusher Engine'!H31","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H31","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C18:F18)","v":{"v":0,"d":"0.0000"}}]
[null,"N2O",null,{"$f":"'Crusher Engine'!H32","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H32","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C19:F19)","v":{"v":0,"d":"0.0000"}}]
[null,"GHG Total CO2e",{"$nulls":4},{"$f":"(G17*1)+(G18*25)+(G19*298)","v":{"v":0,"d":"0.00"}},100000]
[null,"Hazardous Air Pollutants"]
[null,"1,1,2,2-tetrachloroethane",null,{"$f":"'Crusher Engine'!H35","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H35","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C22:F22)","v":{"v":0,"d":"0.0000"}}]
[null,"1,1,2-trichloroethane",null,{"$f":"'Crusher Engine'!H36","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H36","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"1,3-butadiene",null,{"$f":"'Crusher Engine'!H37","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H37","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"1,3-dichloropropene",null,{"$f":"'Crusher Engine'!H38","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H38","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Acetaldehyde",null,{"$f":"'Crusher Engine'!H39","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H39","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Acrolein",null,{"$f":"'Crusher Engine'!H40","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H40","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Benzene",null,{"$f":"'Crusher Engine'!H41","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H41","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Biphenyl",null,{"$f":"'Crusher Engine'!H42","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H42","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Carbon tetrachloride",null,{"$f":"'Crusher Engine'!H43","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H43","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Chlorobenzene",null,{"$f":"'Crusher Engine'!H44","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H44","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Chloroform",null,{"$f":"'Crusher Engine'!H45","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H45","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Ethylbenzene",null,{"$f":"'Crusher Engine'!H46","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H46","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Ethylene dibromide",null,{"$f":"'Crusher Engine'!H47","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H47","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Formaldehyde",null,{"$f":"'Crusher Engine'!H48","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H48","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Hexane",null,{"$f":"'Crusher Engine'!H49","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H49","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C36:F36)","v":{"v":0,"d":"0.0000"}}]
[null,"Methanol",null,{"$f":"'Crusher Engine'!H50","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H50","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Methylene chloride",null,{"$f":"'Crusher Engine'!H51","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H51","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Naphthalene",null,{"$f":"'Crusher Engine'!H52","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H52","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"PAH",null,{"$f":"'Crusher Engine'!H53","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H53","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Phenol",null,{"$f":"'Crusher Engine'!H54","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H54","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Styrene",null,{"$f":"'Crusher Engine'!H55","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H55","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Tetrachloroethane",null,{"$f":"'Crusher Engine'!H56","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H56","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Toluene",null,{"$f":"'Crusher Engine'!H57","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H57","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Vinyl chloride",null,{"$f":"'Crusher Engine'!H58","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H58","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Xylene",null,{"$f":"'Crusher Engine'!H59","v":{"v":0,"d":"0.00"}},{"$f":"Generator!H59","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"HAP Indiv. Max",{"$f":"IF(G47=G22,B22,IF(G47=G23,B23,IF(G47=G24,B24,IF(G47=G25,B25,IF(G47=G26,B26,IF(G47=G27,B27,IF(G47=G28,B28,IF(G47=G29,B29,IF(G47=G30,B30,IF(G47=G31,B31,IF(G47=G32,B32,IF(G47=G33,B33,IF(G47=G34,B34,IF(G47=G35,B35,IF(G47=G36,B36,IF(G47=G37,B37,IF(G47=G38,B38,IF(G47=G39,B39,IF(G47=G40,B40,IF(G47=G41,B41,IF(G47=G42,B42,IF(G47=G43,B43,IF(G47=G44,B44,IF(G47=G45,B45,IF(G47=G46,B46)))))))))))))))))))))))))","v":"1,1,2,2-tetrachloroethane"},{"$nulls":3},{"$f":"MAX(G22:G46)","v":{"v":0,"d":"0.0000"}},10]
[null,"HAP total",{"$nulls":4},{"$f":"SUM(G22:G46)","v":{"v":0,"d":"0.00"}},25]

{"sheet":"Actual emissions","index":8,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,5,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[null,"Actual emissions - Aggregate: sand & gravel"]
[null,{"$f":"IF('Data validation'!C25=\"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","Aggregate","Crusher Engine","Generator","Fugitives","Actual Emissions","Permitting Threshold"]
[]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants"]
[null,"PM",{"$f":"Aggregate!F53","v":{"v":0,"d":"0.00"}},{"$f":"'Crusher Engine'!I21","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I21","v":{"v":0,"d":"0.00"}},{"$f":"Fugitive!I75","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C8:F8)","v":{"v":0,"d":"0.00"}},50]
[null,"PM10",{"$f":"Aggregate!H53","v":{"v":0,"d":"0.00"}},{"$f":"'Crusher Engine'!I22","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I22","v":{"v":0,"d":"0.00"}},{"$f":"Fugitive!I76","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},50]
[null,"PM2.5",{"$f":"Aggregate!J53","v":{"v":0,"d":"0.00"}},{"$f":"'Crusher Engine'!I23","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I23","v":{"v":0,"d":"0.00"}},{"$f":"Fugitive!I77","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},50]
[null,"SOx",null,{"$f":"'Crusher Engine'!I24","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I24","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},50]
[null,"NOx",null,{"$f":"'Crusher Engine'!I25","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I25","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},50]
[null,"VOC",null,{"$f":"'Crusher Engine'!I26","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I26","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},50]
[null,"CO",null,{"$f":"'Crusher Engine'!I27","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I27","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},50]
[null,"Lead",null,{"$f":"'Crusher Engine'!I28","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I28","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.00"},0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",null,{"$f":"'Crusher Engine'!I30","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I30","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C17:F17)","v":{"v":0,"d":"0.00"}}]
[null,"CH4",null,{"$f":"'Crusher Engine'!I31","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I31","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C18:F18)","v":{"v":0,"d":"0.0000"}}]
[null,"N2O",null,{"$f":"'Crusher Engine'!I32","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I32","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C19:F19)","v":{"v":0,"d":"0.0000"}}]
[null,"GHG Total CO2e",{"$nulls":4},{"$f":"(G17*1)+(G18*25)+(G19*298)","v":{"v":0,"d":"0.00"}},50000]
[null,"Hazardous Air Pollutants"]
[null,"1,1,2,2-tetrachloroethane",null,{"$f":"'Crusher Engine'!I35","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I35","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(C22:F22)","v":{"v":0,"d":"0.0000"}}]
[null,"1,1,2-trichloroethane",null,{"$f":"'Crusher Engine'!I36","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I36","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"1,3-butadiene",null,{"$f":"'Crusher Engine'!I37","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I37","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"1,3-dichloropropene",null,{"$f":"'Crusher Engine'!I38","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I38","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Acetaldehyde",null,{"$f":"'Crusher Engine'!I39","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I39","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Acrolein",null,{"$f":"'Crusher Engine'!I40","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I40","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Benzene",null,{"$f":"'Crusher Engine'!I41","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I41","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Biphenyl",null,{"$f":"'Crusher Engine'!I42","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I42","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Carbon tetrachloride",null,{"$f":"'Crusher Engine'!I43","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I43","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Chlorobenzene",null,{"$f":"'Crusher Engine'!I44","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I44","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Chloroform",null,{"$f":"'Crusher Engine'!I45","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I45","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Ethylbenzene",null,{"$f":"'Crusher Engine'!I46","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I46","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Ethylene dibromide",null,{"$f":"'Crusher Engine'!I47","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I47","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Formaldehyde",null,{"$f":"'Crusher Engine'!I48","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I48","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Hexane",null,{"$f":"'Crusher Engine'!I49","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I49","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Methanol",null,{"$f":"'Crusher Engine'!I50","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I50","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Methylene chloride",null,{"$f":"'Crusher Engine'!I51","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I51","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Naphthalene",null,{"$f":"'Crusher Engine'!I52","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I52","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"PAH",null,{"$f":"'Crusher Engine'!I53","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I53","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Phenol",null,{"$f":"'Crusher Engine'!I54","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I54","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Styrene",null,{"$f":"'Crusher Engine'!I55","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I55","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Tetrachloroethane",null,{"$f":"'Crusher Engine'!I56","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I56","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Toluene",null,{"$f":"'Crusher Engine'!I57","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I57","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Vinyl chloride",null,{"$f":"'Crusher Engine'!I58","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I58","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"Xylene",null,{"$f":"'Crusher Engine'!I59","v":{"v":0,"d":"0.00"}},{"$f":"Generator!I59","v":{"v":0,"d":"0.00"}},null,{"v":0,"d":"0.0000"}]
[null,"HAP Indiv. Max",{"$f":"IF(G47=G22,B22,IF(G47=G23,B23,IF(G47=G24,B24,IF(G47=G25,B25,IF(G47=G26,B26,IF(G47=G27,B27,IF(G47=G28,B28,IF(G47=G29,B29,IF(G47=G30,B30,IF(G47=G31,B31,IF(G47=G32,B32,IF(G47=G33,B33,IF(G47=G34,B34,IF(G47=G35,B35,IF(G47=G36,B36,IF(G47=G37,B37,IF(G47=G38,B38,IF(G47=G39,B39,IF(G47=G40,B40,IF(G47=G41,B41,IF(G47=G42,B42,IF(G47=G43,B43,IF(G47=G44,B44,IF(G47=G45,B45,IF(G47=G46,B46)))))))))))))))))))))))))","v":"1,1,2,2-tetrachloroethane"},{"$nulls":3},{"$f":"MAX(G22:G46)","v":{"v":0,"d":"0.0000"}},5]
[null,"HAP total",{"$nulls":4},{"$f":"SUM(G22:G46)","v":{"v":0,"d":"0.00"}},12.5]

{"sheet":"Permits & requirements","index":9,"n_rows":62,"n_cols":9,"rows_kept":62,"merged":[[0,1,0,8],[1,1,1,8],[2,1,4,8],[5,1,6,8],[8,1,8,4],[8,5,16,8],[9,1,9,4],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[12,1,14,1],[12,2,14,2],[12,3,14,3],[12,4,14,4],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[17,1,19,1],[17,2,19,2],[17,3,19,3],[17,4,19,4],[17,5,19,6],[17,7,19,7],[17,8,19,8],[20,1,21,1],[20,2,21,2],[20,4,25,4],[20,5,20,6],[21,5,21,6],[21,7,23,7],[21,8,23,8],[22,1,23,1],[22,2,23,2],[22,5,23,6],[24,1,25,1],[24,2,25,2],[24,5,25,6],[24,7,25,7],[24,8,25,8],[26,1,29,7],[26,8,29,8],[31,1,31,8],[32,1,33,8],[34,1,34,6],[35,2,37,3],[35,4,37,5],[38,2,38,3],[38,4,38,5],[40,1,40,2],[40,3,40,4],[41,2,41,8],[42,2,42,8],[43,2,44,8],[45,1,47,8],[48,1,48,8],[50,1,50,2],[50,3,50,4],[51,1,51,5],[52,1,52,5],[53,1,53,4],[54,1,54,4],[56,1,56,8],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[61,1,61,2],[61,3,61,5]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[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?",{"$nulls":3},"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'!C22=\"yes\",\"do\",\"do not\")","v":"do not"},{"$f":"IF('Data validation'!C25=\"yes\",\"do\",\"do not\")","v":"do not"},{"$f":"IF('Data validation'!C17>0,\"Return to Federal tab and answer all Y/N questions\",IF(AND('Data validation'!C17=0,'Data validation'!C12>0),\"does\",\"does not\"))","v":"Return to Federal tab and answer all Y/N questions"},{"$f":"IF('Federal standards'!N61=\"Choose Y/N\",\"Return to Federal tab and answer all Y/N questions\",IF('Federal standards'!N61=\"Yes\",\"does\",IF('Federal standards'!N61=\"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 if your business does not qualify for the general permit?",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"]
[{"$nulls":3},"yes",null,"Registration Option A",null,"Info about Air Registration Permits","Application Forms, scroll to Registration section"]
[null,"yes","no","no",null,"Registration Option D"]
[{"$nulls":3},"yes"]
[null,"yes","yes","no",null,"Other state or federal permit",null,"Info about Air Permits","Application Forms, scroll to Section 1"]
[{"$nulls":3},"yes"]
[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 to demonstrate NSPS compliance and any compression ignition engines are less than 30 liters per cylinder. \nApplicability of NSPS Kb does not indicate a need for a permit if construction, reconstruction or modification commenced after July 23, 1984, if all storage vessels subject to Kb at the facility each have a capacity of 40 cubic meters to less than 75 cubic meters.",{"$nulls":6},"Minn. R. 7007.0300"]
[]
[]
[]
[]
[null,"Does your business qualify for the nonmetallic mineral general permit?"]
[null,"If your business meets the qualifications for the general permit, you cannot obtain a registration permit. Use the checklist (NM-00), linked below, to see if your business qualifies for the general permit. "]
[]
[null,"NM-00: Qualifications Review Checklist – Nonmetallic Mineral Processing General Permit (aq-f4-nm00)"]
[null,null,"See the application forms on the air permit and forms page – scroll down the webpage to #4.",null,"Be sure to complete and include Form SCP-01 with your application."]
[]
[]
[null,null,"Info about Individual Air Permits",null,"SCP-01: Submittal cover page (aq-f1-scp01)"]
[]
[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":"Aggregate emission factors","index":10,"n_rows":42,"n_cols":10,"rows_kept":42,"merged":[[0,1,0,9],[1,1,1,9],[3,1,3,9],[4,1,8,2],[4,3,8,3],[4,4,7,4],[4,5,7,5],[4,6,7,6],[4,7,7,7],[4,8,7,8],[4,9,7,9],[9,1,16,1],[9,2,10,2],[11,2,12,2],[13,2,14,2],[13,5,14,5],[13,7,14,7],[13,9,14,9],[15,2,16,2],[15,5,16,5],[15,7,16,7],[15,9,16,9],[17,1,20,1],[17,2,18,2],[17,5,18,5],[17,7,18,7],[17,9,18,9],[19,2,20,2],[19,5,20,5],[19,7,20,7],[19,9,20,9],[21,1,22,2],[21,5,22,5],[21,7,22,7],[21,9,22,9],[23,1,23,5],[23,6,23,9],[24,1,26,9],[27,1,29,9],[30,2,30,9],[32,1,32,9],[33,1,34,2],[33,3,33,4],[33,5,34,9],[35,1,38,1],[35,6,36,9],[37,6,38,9],[39,1,40,1],[39,6,40,9],[41,1,41,2]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
[null,"Emission factors for aggregate processing1"]
[]
[null,"Emission factors and calculated percent controls"]
[null,"Activity",null,"Uncontrolled or Controlled Emission Factor","PM Emission Factor","PM Emission Control (calculated)","PM10 Emission Factor","PM10 Emission Control (calculated)","PM2.5 Emission Factor","PM2.5 Emission Control"]
[]
[]
[]
[{"$nulls":4},"(lb/ton)","(%)","(lb/ton)","(%)","(lb/ton)","(%)"]
[null,"Crushing","Primary1","Uncontrolled",0.0007,null,{"$f":"E10","v":0.0007},null,"ND"]
[{"$nulls":3},"Controlled","ND",null,"ND",null,"ND"]
[null,null,"Secondary2","Uncontrolled",0.025,null,0.0087,null,"ND"]
[{"$nulls":3},"Controlled","ND",null,"ND",null,5e-05]
[null,null,"Tertiary","Uncontrolled",0.0054,{"$f":"(E14-E15)/E14","v":{"v":0.7777777777777779,"d":"77.78%"}},0.0024,{"$f":"(G14-G15)/G14","v":{"v":0.7749999999999999,"d":"77.50%"}},"ND"]
[{"$nulls":3},"Controlled",0.0012,null,0.00054,null,1E-4]
[null,null,"Fines","Uncontrolled",0.039,{"$f":"(E16-E17)/E16","v":{"v":0.923076923076923,"d":"92.31%"}},0.015,{"$f":"(G16-G17)/G16","v":{"v":0.92,"d":"92.00%"}},"ND"]
[{"$nulls":3},"Controlled",0.003,null,0.0012,null,7e-05]
[null,"Screening","Screening","Uncontrolled",0.025,{"$f":"(E18-E19)/E18","v":{"v":0.912,"d":"91.20%"}},0.0087,{"$f":"(G18-G19)/G18","v":{"v":0.9149425287356322,"d":"91.49%"}},"ND"]
[{"$nulls":3},"Controlled",0.0022,null,0.00074,null,5e-05]
[null,null,"Fines ","Uncontrolled",0.3,{"$f":"(E20-E21)/E20","v":{"v":0.988,"d":"98.80%"}},0.072,{"$f":"(G20-G21)/G20","v":{"v":0.9694444444444446,"d":"96.94%"}},"ND"]
[{"$nulls":3},"Controlled",0.0036,null,0.0022,null,"ND"]
[null,"Conveyor Transfer Points",null,"Uncontrolled",0.003,{"$f":"(E22-E23)/E22","v":{"v":0.9533333333333334,"d":"95.33%"}},0.0011,{"$f":"(G22-G23)/G22","v":{"v":0.9581818181818181,"d":"95.82%"}},"ND"]
[{"$nulls":3},"Controlled",0.00014,null,4.6E-5,null,1.3e-05]
[null,"1Emission factors from AP-42, Chapter 11.19-2, unless otherwise stated.",{"$nulls":4},"https://www3.epa.gov/ttn/chief/ap42/ch11/final/c11s1902.pdf"]
[null,"2WebFIRE SCC 3-05-020-01: EPA.  1995.  Section 11.19.2, Construction Aggregate Processing: Crushed Stone Processing.  In: Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources, Fifth Edition, AP-42.  U.S. Environmental Protection Agency, Office of Air Quality Planning and Standards.  Research Triangle Park, North Carolina. (Assume PM = PM-10)"]
[]
[]
[null,"3WebFIRE SCC 3-05-020-02: EPA.  August, 2004.  Section 11.19.2, Crushed Stone Processing and Pulverized Mineral Processing.  In: Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources, Fifth Edition, AP-42.  U.S. Environmental Protection Agency, Office of Air Quality Planning and Standards.  Research Triangle Park, North Carolina."]
[]
[]
[]
[]
[null,"Uncontrolled PM-2.5 factors"]
[null,"Activity",null,"PM2.5 Emission Factor",null,"Reference"]
[{"$nulls":3},"(reason)","(lb/ton)"]
[null,"Crushing","Primary",1,{"$f":"E38","v":0.0005},1,"Emissions factor assumed, worst-case, to equal PM-2.5 of secondary crusher."]
[null,null,"Secondary",2,{"$f":"I13*5","v":0.00025}]
[null,null,"Tertiary",2,{"$f":"I15*5","v":0.0005},2,"Back calculated from controlled emission factor using a conservative minimum percent emission control of 80%."]
[null,null,"Fines",2,{"$f":"I17*5","v":3.4999999999999994E-4}]
[null,"Screening","Screening",2,{"$f":"I19*5","v":0.00025},3,"Emission factor assumed, worst-case, to be 10 times greater than uncontrolled screening PM-2.5 emission factor."]
[null,null,"Fines ",3,{"$f":"E40*10","v":0.0025}]
[null,"Conveyor Transfer Points",null,2,{"$f":"I23*5","v":6.5e-05}]

{"sheet":"Engine emission factors","index":11,"n_rows":59,"n_cols":9,"rows_kept":59,"merged":[[0,0,0,8],[58,1,58,4]]}
[{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
["Engine emission factors"]
[null,"RECIPROCATING ENGINES (<600HP) DIESEL (lb/MMBtu)1","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)","RECIPROCATING Propane3,4,5\n(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)","EPA/AIRS by SCC3,4"]
["PM",0.31,0.1,6.6E-3,0.1,{"$f":"0.0095+0.00991","v":0.01941},{"$f":"0.0000771+0.00991","v":0.0099871},{"$f":"0.0384+0.00991","v":0.04831},{"$f":"I6","v":{"v":0.05434782608695652,"d":"0.0543"}}]
["PM10",0.31,{"$f":"0.0496+0.0077","v":0.0573},{"$f":"0.0019+0.0047","v":{"v":6.6E-3,"d":"0.0066"}},0.1,{"$f":"0.0095+0.00991","v":0.01941},{"$f":"G5","v":0.0099871},{"$f":"H5","v":0.04831},{"$f":"5/(H55/(10^6)*1000)","v":{"v":0.05434782608695652,"d":"0.0543"}}]
["PM2.5",0.31,{"$f":"0.0479+0.0077","v":0.0556},{"$f":"D6","v":{"v":6.6E-3,"d":"0.0066"}},0.1,{"$f":"F6","v":0.01941},{"$f":"G5","v":0.0099871},{"$f":"H6","v":0.04831},{"$f":"I6","v":{"v":0.05434782608695652,"d":"0.0543"}}]
["SOx",1.01,1.01,0.94,0.084,0.000588,0.000588,0.000588,{"$f":"(0.1)/(H55/(10^6)*1000)","v":{"v":1.0869565217391304E-3,"d":"0.00109"}}]
["NOx",4.41,3.2,0.32,1.63,2.21,4.08,3.17,{"$f":"139/(H55/(10^6)*1000)","v":{"v":1.5108695652173914,"d":"1.51"}}]
["VOC",{"$f":"0.35+0+0.01+0","v":0.36},0.09,0.0021,{"$f":"2.1+0.09+0.69+0.15","v":3.03},0.0296,0.118,0.12,{"$f":"83/(H55/(10^6)*1000)","v":{"v":0.9021739130434783,"d":"0.902"}}]
["CO",0.95,0.85,0.082,0.99,3.72,0.317,0.386,{"$f":"129/(H55/(10^6)*1000)","v":{"v":1.4021739130434783,"d":"1.40"}}]
["40 CFR 98, subp. C, Table C-1 and C-2",{"$nulls":6}," "," "]
["CO2",{"$f":"B53","v":{"v":163.05402211679217,"d":"163.05"}},{"$f":"B53","v":{"v":163.05402211679217,"d":"163.05"}},{"$f":"B52","v":{"v":116.97737173495123,"d":"116.98"}},{"$f":"B54","v":{"v":154.80872678530486,"d":"154.81"}},{"$f":"B52","v":{"v":116.97737173495123,"d":"116.98"}},{"$f":"B52","v":{"v":116.97737173495123,"d":"116.98"}},{"$f":"G13","v":{"v":116.97737173495123,"d":"117"}},{"$f":"B55","v":{"v":136.0473729695409,"d":"136.05"}}]
["CH4",{"$f":"C53","v":{"v":0.006613873260551332,"d":"0.0066"}},{"$f":"C53","v":{"v":0.006613873260551332,"d":"0.0066"}},{"$f":"C52","v":{"v":2.2046244201837776E-3,"d":"0.0022"}},{"$f":"C54","v":{"v":0.006613873260551332,"d":"0.0066"}},{"$f":"C52","v":{"v":2.2046244201837776E-3,"d":"0.0022"}},{"$f":"C52","v":{"v":2.2046244201837776E-3,"d":"0.0022"}},{"$f":"G14","v":{"v":2.2046244201837776E-3,"d":"0.0022"}},{"$f":"C55","v":{"v":0.006613873260551332,"d":"0.0066139"}}]
["N2O",{"$f":"D53","v":{"v":1.3227746521102665E-3,"d":"0.0013"}},{"$f":"D53","v":{"v":1.3227746521102665E-3,"d":"0.0013"}},{"$f":"D52","v":{"v":2.2046244201837776E-4,"d":"0.0002"}},{"$f":"D54","v":{"v":1.3227746521102665E-3,"d":"0.0013"}},{"$f":"D52","v":{"v":2.2046244201837776E-4,"d":"0.0002"}},{"$f":"D52","v":{"v":2.2046244201837776E-4,"d":"0.0002"}},{"v":2.2046244201837776E-4,"d":"0.0002"},{"$f":"D55","v":{"v":1.3227746521102665E-3,"d":"0.0013"}}]
["source","AP42 Chpt 3.3 (10/96)","AP42 Chpt 3.4 (10/96)","AP42 Chpt 3.1 (4/00)","HAPs from Diesel<600HP","AP42 Chpt 3.2-3 (7/00)","AP42 Chpt 3.2-2 (7/00)","AP42 Chpt 3.2-2 (7/00)","Calculated5"]
["1,1,2,2-tetrachloroethane",{"$nulls":4},2.53e-05,4e-05,6.63e-05,{"$f":"AVERAGE(F17:H17)*$G$52/$G$55","v":{"v":1.7783783783783785E-5,"d":"0.0000178"}}]
["1,1,2-trichloroethane",{"$nulls":4},1.53e-05,3.18E-5,5.27E-5,{"$f":"AVERAGE(F18:H18)*$G$52/$G$55","v":{"v":1.3486486486486486E-5,"d":"0.0000135"}}]
["1,3-butadiene",3.91e-05,null,4.3e-07,3.91e-05,0.000663,0.000267,0.00082,{"v":2.3648648648648648E-4,"d":"0.000236"}]
["1,3-dichloropropene",{"$nulls":4},1.27E-5,2.64e-05,4.38e-05,{"v":1.1202702702702703E-5,"d":"0.0000112"}]
["Acetaldehyde",7.67E-4,2.52e-05,4e-05,{"$f":"B21","v":7.67E-4},0.00279,0.00836,0.00776,{"v":2.5554054054054056E-3,"d":"0.00256"}]
["Acrolein",9.25e-05,7.88e-06,6.4e-06,{"$f":"B22","v":9.25e-05},2.63E-3,0.00514,0.00778,{"v":0.002101351351351351,"d":"0.00210"}]
["Benzene",0.000933,7.76E-4,1.2E-5,{"$f":"B23","v":0.000933},1.58E-3,0.00044,0.00194,{"v":5.3513513513513513E-4,"d":"0.000535"}]
["Biphenyl",{"$nulls":5},2.12E-4,3.95e-06,{"v":4.3773648648648644E-5,"d":"0.0000438"}]
["Carbon tetrachloride",{"$nulls":4},1.77E-5,3.67e-05,6.07e-05,{"v":1.5554054054054056E-5,"d":"0.0000156"}]
["Chlorobenzene",{"$nulls":4},1.29E-5,3.04E-5,4.44e-05,{"v":1.1851351351351351E-5,"d":"0.0000119"}]
["Chloroform",{"$nulls":4},1.37e-05,2.85e-05,4.71E-5,{"v":1.2067567567567568E-5,"d":"0.0000121"}]
["Ethylbenzene",null,null,3.2e-05,null,2.48E-5,3.97e-05,1.08E-4,{"v":2.3310810810810808E-5,"d":"0.0000233"}]
["Ethylene dibromide",{"$nulls":4},2.13e-05,4.43e-05,7.34e-05,{"v":1.8783783783783782E-5,"d":"0.0000188"}]
["Formaldehyde",0.00118,7.89e-05,0.00071,{"$f":"B30","v":0.00118},0.0205,0.0528,0.0552,{"v":0.017364864864864864,"d":"0.0174"}]
["Hexane",{"$nulls":5},0.00111,0.000445,{"v":3.1520270270270272E-4,"d":"0.000315"}]
["Methanol",{"$nulls":4},0.00306,0.0025,2.48E-3,{"v":1.0864864864864865E-3,"d":"0.00109"}]
["Methylene chloride",{"$nulls":4},4.12e-05,2e-05,1.47E-4,{"v":2.8135135135135132E-5,"d":"0.0000281"}]
["Naphthalene",8.48e-05,0.00013,1.3E-6,{"$f":"B34","v":8.48e-05},9.71e-05,7.44e-05,9.63e-05,{"v":3.6189189189189185E-5,"d":"0.0000362"}]
["PAH",0.000168,2.12E-4,2.2e-06,0.000168,0.000141,2.69E-5,1.34E-4,{"v":4.0797297297297304E-5,"d":"0.0000408"}]
["Phenol",{"$nulls":5},2.4e-05,4.21E-5,{"v":1.3398648648648651E-5,"d":"0.0000134"}]
["Styrene",{"$nulls":4},1.19E-5,2.36e-05,5.48e-05,{"v":1.2202702702702704E-5,"d":"0.0000122"}]
["Tetrachloroethane",{"$nulls":5},2.48E-6,null,{"v":1.0054054054054054E-6,"d":"0.00000101"}]
["Toluene",0.000409,2.81E-4,0.00013,{"$f":"B39","v":0.000409},0.000558,4.08E-4,0.000963,{"v":2.6067567567567565E-4,"d":"0.000261"}]
["Vinyl chloride",{"$nulls":4},7.18e-06,1.49E-5,2.47e-05,{"v":6.3216216216216207E-6,"d":"0.00000632"}]
["Xylene",0.000285,1.93E-4,6.4e-05,{"$f":"B41","v":0.000285},1.95E-4,1.84E-4,0.000268,{"v":8.7432432432432431E-5,"d":"0.0000874"}]
[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. "]
[3,"Propane criteria emission factors ARB \"Instructions for the Emission Data System Review & Update Report 8/91\" referencing EPA/AIRS emission factors by source classification code. "]
[4,"SOx emission factor from AP-42 Section 1.5 Table 1.5-1 for propane. The SO2 emission factor is based on fuel sulfur content as 0.10S lb/1000 gal, where S is sulfur content of fuel in gr/100ft3. National average sulfur content"]
[null,"of propane 0.54 gr/100ft3","https://www3.epa.gov/ttnchie1/conference/ei12/area/haneke.pdf"]
[5,"Propane toxic emission factors were calculated from the natural gas toxic emission factors using the following formula: TEFP = TEFNG * HVP/HVNG"]
[null,"TEFP = Propane toxic emission factor; TEFNG = Average of natural gas toxic emission factors; HVP = Heating value for propane; HVNG = Heating value for natural gas"]
[]
[]
["Fuel","CO2 Emission Factor1\n(lbs/million BTU)","CH4 Emission Factor1\n(lbs/million BTU)","N2O Emission Factor1\n(lbs/million BTU)","Source for Emission Factors","Brake-specific fuel consumption \n(btu/hp*hr)2","Heat value3\n(Btu/scf)","Heat Value3\n(Btu/gal)"]
["NATURAL GAS",{"$f":"53.06/0.453592","v":116.97737173495123},{"$f":"0.001/0.453592","v":{"v":2.2046244201837776E-3,"d":"2.20E-03"}},{"$f":"0.0001/0.453592","v":{"v":2.2046244201837776E-4,"d":"2.20E-04"}},"40 CFR 98, subp. C, Table C-1 and C-2",null,1020]
["DISTILLATE OIL 2",{"$f":"73.96/0.453592","v":163.05402211679217},{"$f":"0.003/0.453592","v":{"v":0.006613873260551332,"d":"6.61E-03"}},{"$f":"0.0006/0.453592","v":{"v":1.3227746521102665E-3,"d":"1.32E-03"}},"40 CFR 98, subp. C, Table C-1 and C-2",7000,null,{"$f":"0.138*1000000","v":138000}]
["GASOLINE",{"$f":"70.22/0.453592","v":154.80872678530486},{"$f":"C53","v":{"v":0.006613873260551332,"d":"6.61E-03"}},{"$f":"D53","v":{"v":1.3227746521102665E-3,"d":"1.32E-03"}},"40 CFR 98, subp. C, Table C-1 and C-2",7000,null,125000]
["PROPANE",{"$f":"61.71/0.453592","v":136.0473729695409},{"$f":"C53","v":{"v":0.006613873260551332,"d":"6.61E-03"}},{"$f":"D53","v":{"v":1.3227746521102665E-3,"d":"1.32E-03"}},"40 CFR 98, subp. C, Table C-1 and C-2",null,2516,{"$f":"0.092*1000000","v":92000}]
[1,"(1 lb = 0.453592 kg)"]
[2,"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"]
[3,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2"]

{"sheet":"Data validation","index":12,"n_rows":47,"n_cols":3,"rows_kept":47,"hidden":true,"merged":[[0,0,0,2],[1,0,1,2]]}
[{"$f":"Instructions!G2","v":"p-sbap5-30 • 7/31/25"}]
["Data Validation"]
[]
["Engines",null,"General data"]
["Engine and Fuel Type","Choose one to calculate actual emissions","Selection"]
["Choose one","Number of hours operated per 12 months","Choose Y/N"]
["Reciprocating - diesel","Quantity of fuel actually burned per 12 months","Yes"]
["Reciprocating - gasoline",null,"No"]
["Reciprocating - propane"]
["Turbine - natural gas","Actual emissions entry","Equation/reference"]
["Recip - nat gas 4-stroke rich burn","hours per year (hr/yr)","NSPS applies"]
["Recip - nat gas 4-stroke lean burn","million Btu per year (MMBtu/yr)",{"$f":"SUM(C13:C14)","v":0}]
["Recip - nat gas 2-stroke lean burn","gallons per year (gal/yr)",{"$f":"COUNTIF('Federal standards'!N16,\"Yes\")","v":0}]
[null,null,{"$f":"COUNTIF('Federal standards'!N48,\"Yes\")","v":0}]
[]
["Engine Use",null,"NSPS no selection"]
["Choose one",null,{"$f":"SUM(C18:C19)","v":2}]
["Routine",null,{"$f":"IF('Federal standards'!N16=\"Choose Y/N\",1,0)","v":1}]
["Emergency",null,{"$f":"IF('Federal standards'!N48=\"Choose Y/N\",1,0)","v":1}]
[]
[null,null,"Potential exceed"]
["Input Value",null,{"$f":"IF(OR('Potential emissions'!G8>=100,OR('Potential emissions'!G9>=25,OR('Potential emissions'!G10>=100,OR('Potential emissions'!G11>=50,OR('Potential emissions'!G12>=100,OR('Potential emissions'!G13>=100,OR('Potential emissions'!G14>=100,OR('Potential emissions'!G15>=0.5,OR('Potential emissions'!G20>=100000,OR('Potential emissions'!G47>=10,'Potential emissions'!G48>=25)))))))))),\"yes\",\"no\")","v":"no"}]
["Choose one"]
["horsepower(HP) or brake power (HP-hr)",null,"Actual exceed"]
["standard cubic feet/hr (scf/hr)",null,{"$f":"IF(OR('Actual emissions'!G8>=50,OR('Actual emissions'!G9>=50,OR('Actual emissions'!G10>=50,OR('Actual emissions'!G11>=50,OR('Actual emissions'!G12>=50,OR('Actual emissions'!G13>=50,OR('Actual emissions'!G14>=50,OR('Actual emissions'!G15>=0.5,OR('Actual emissions'!G20>=50000,OR('Actual emissions'!G47>=5,'Actual emissions'!G48>=12.5)))))))))),\"yes\",\"no\")","v":"no"}]
["gallons/hr (gal/hr)"]
[]
["Fuel Conversion"]
["Brake specific fuel consumption"]
["Heat value of fuel"]
{"$rows_empty":15}
["Updates:"]
["11/01/2019: formula for actual emissions "]