{"text_format":"1","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":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":33,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,5],[24,4,24,14],[26,6,26,14],[13,2,13,14],[18,1,18,13],[19,1,19,13],[17,2,17,14],[25,1,25,2],[21,1,21,14],[22,1,22,14],[23,2,23,3],[24,2,24,3],[23,5,23,8],[27,6,27,14],[14,2,14,14],[15,2,15,14],[16,2,16,14],[20,1,20,14],[12,2,12,14],[4,1,4,14],[0,6,0,14],[1,6,3,14],[0,1,3,5],[11,1,11,14],[5,1,5,14],[6,1,6,14],[7,1,7,14],[8,1,8,14],[9,1,10,14]]}
[null,null,null,null,null,null,"Aggregate: sand and gravel\nair emissions calculator"]
[null,null,null,null,null,null,"p-sbap5-30 •  4/22/19"]
[]
[]
[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) Business Assistance program."]
[null,"We provide free, confidential, environmental assistance to small businesses. For more information:"]
[null,"Call:","651/282-6143",null,"Email:","smallbizhelp.pca@state.mn.us"]
[null,null,"800/657-3938"]
[]
[null,"Online at the MPCA's website:",null,null,null,null,"More information found on the MPCA's Aggregate - sand and gravel webpage: "]
[null,"https://www.pca.state.mn.us/smallbizhelp",null,null,null,null,"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,"cut":false,"hidden":false,"merged":[[52,13,53,14],[49,2,49,12],[2,1,2,14],[3,1,5,7],[29,1,29,12],[30,2,30,7],[30,9,30,12],[31,2,31,8],[31,9,31,12],[32,1,32,12],[44,13,45,14],[3,8,5,14],[47,1,47,12],[47,13,47,14],[6,2,6,13],[6,14,11,14],[0,1,0,14],[34,2,34,12],[38,1,38,12],[38,13,38,14],[39,1,39,12],[15,13,15,14],[15,1,15,12],[16,13,19,14],[1,1,1,14],[18,2,18,12],[25,4,25,8],[33,2,33,12],[35,1,35,12],[34,13,35,14],[7,2,9,13],[10,2,12,13],[62,9,62,12],[60,1,60,12],[63,2,63,12],[64,2,64,12],[79,1,79,14],[74,1,75,1],[70,1,70,14],[77,1,77,14],[78,1,78,7],[78,8,78,9],[78,10,78,12],[78,13,78,14],[71,1,72,14],[73,2,73,14],[74,2,75,14],[76,2,76,14],[43,1,43,12],[40,2,40,12],[41,2,41,12],[29,13,33,14],[28,1,28,12],[28,13,28,14],[52,1,52,12],[53,1,54,12],[66,2,66,12],[67,2,67,12],[65,1,65,12],[57,1,57,14],[58,1,58,14],[55,1,55,14],[65,13,67,14],[59,1,59,14],[60,13,60,14],[61,1,61,12],[56,2,56,5],[56,6,56,12],[61,13,64,14],[62,2,62,7],[20,13,21,14],[13,1,13,14],[23,1,23,12],[14,1,14,14],[50,1,50,12],[48,13,51,14],[51,8,51,12],[48,1,48,12],[51,2,51,7],[46,1,46,14],[36,1,36,14],[37,1,37,14],[26,1,26,14],[27,1,27,14],[39,13,43,14],[44,8,44,11],[7,1,8,1],[19,2,19,12],[16,1,17,12],[20,1,22,12],[24,4,24,6]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 •  4/22/19"}]
[null,"U.S. Environmental Protection Agency (EPA) standards"]
[]
[null,"New source performance standards (NSPS) require new emission sources to be less polluting than older sources.",null,null,null,null,null,null,"National emission standards for hazardous air pollutants (NESHAP) prevent or reduce emissions that have health impacts."]
[]
[]
[null,"▪ ","Each NSPS or NESHAP applies to specific equipment, processes, or industries. "]
[null,"▪ ","Multiple federal standards may apply to your business. It is possible that if you make a change at your business, a federal standard that did not previously apply now will, or the one you are already following may have additional requirements. 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?",null,null,null,null,null,null,null,null,null,null,null,"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:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$16=\"Yes\",\"Because this NSPS applies to your operation, you need an air permit.\",IF($N$16=\"No\",\"Continue to the next question.\",IF($N$16=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[]
[null,"1)","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. ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N16=\"Yes\",\"Continue to the next question.\",IF(N16=\"No\",\"\",IF(N16=\"Choose Y/N\",\" \")))","v":" "}]
[]
[]
[]
[null,null,null,"Resource","EPA Rule information"]
[null,null,null,"Regulation","40 CFR pt. 60, subp. OOO"]
[]
[]
[null,"Does an NSPS for internal combustion engines apply to you?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"The two NSPSs that apply to engines are:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(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",null,null,null,null,null,"Full Text:","40 CFR 60, subp. IIII"]
[null,"2)","Standards of Performance for Spark Ignition Engines ",null,null,null,null,null,null,"40 CFR 60, subp. JJJJ"]
[]
[null,"· ","To help understand if the rule applies, use the Regulation Navigation Tool provided by EPA for NSPS IIII and JJJJ. "]
[null,null,"https://www3.epa.gov/ttn/atw/ice/quiz.html",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(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?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"This standard applies if you have a storage tank or container at your site that: ",null,null,null,null,null,null,null,null,null,null,null,{"$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:",null,null,null,null,null,"40 CFR pt. 60, subp. Kb",null,null,null,null,{"$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?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"The standard for calciners and dryers in mineral industries applies if:",null,null,null,null,null,null,null,null,null,null,null,{"$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:",null,null,null,null,null,"40 CFR pt. 60, subp. UUU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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:",null,null,null,"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?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"A NESHAP that may apply to your crusher engine or generator is for:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(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",null,null,null,null,null,"Full Text:","40 CFR 63, subp. ZZZZ"]
[null,null,"To help understand if the rule applies, use the Regulation Navigation Tool provided by EPA"]
[null,null,"https://www3.epa.gov/airtoxics/rice/output/quiz.html"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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.pdf"]
[]
[]
[null,"*Definition of \"construction, modification, or reconstruction\""]
[null,"If your business does an activity which is considered construction, modification, or reconstruction, as defined below or within the standard, an NSPS or NESHAP may apply to your business or create the need for a permit amendment. "]
[]
[null,"▪ ","Construction includes fabricating, erecting, or installing an aggregate plant, engine, or storage tank."]
[null,"▪ ","Modification is a physical or operational change at an existing facility that increases the amount of an air pollutant or results in the emission of a new air pollutant."]
[]
[null,"▪ ","Reconstruction is the replacement of components at an existing facility that exceeds 50% of the cost required to build a new facility."]
[]
[null,"The full definitions of construction and modification are available at:",null,null,null,null,null,null,"40 CFR § 60.2",null,"and reconstruction at: ",null,null,"40 CFR § 60.15"]

{"sheet":"State general permit","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[33,1,33,14],[30,2,30,14],[31,3,31,14],[44,1,44,14],[43,3,43,8],[42,2,42,14],[41,1,41,14],[34,1,36,14],[37,3,37,8],[38,3,38,6],[39,3,39,8],[40,1,40,14],[37,9,38,13],[39,9,39,13],[32,2,32,12],[0,1,0,14],[1,1,1,14],[29,1,29,12],[29,13,29,14],[7,9,7,11],[2,1,2,14],[7,4,7,5],[4,2,4,14],[6,1,6,14],[7,6,7,7],[10,5,10,13],[10,2,10,4],[24,2,27,4],[11,2,13,4],[14,2,19,4],[9,1,9,14],[3,2,3,10],[3,11,3,12],[8,1,8,14],[28,1,28,14],[24,5,25,13],[11,5,13,13],[26,5,27,13],[14,5,15,13],[16,6,17,13],[18,6,19,13],[20,2,20,4],[20,5,21,13],[22,6,23,13]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 •  4/22/19"}]
[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",null,null,null,null,null,null,null,null,"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:"]
[null,null,null,null,{"$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."]
[]
[null,null,null,null,null,"▪ ","If your potential emissions do not exceed permitting thresholds, you may qualify for a Registration Permit Option A. Go to the permits & requirements tab."]
[]
[null,null,null,null,null,"▪ ","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."]
[]
[null,null,null,null,null,"▪ ","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."]
[]
[null,null,null,null,null,"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?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"▪ ","See if your business qualifies for the general air permit for nonmetallic mineral processors by completing the:"]
[null,null,null,"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,"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)",null,null,null,null,null,"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",null,null,null,null,null,"Minn. R. 7007.1100, subp. 5"]
[]
[null,"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,"cut":false,"hidden":false,"merged":[[53,1,53,9],[45,1,48,1],[49,1,50,1],[51,1,51,2],[23,4,24,4],[41,8,42,8],[41,9,42,9],[41,1,44,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[41,7,42,7],[40,1,40,2],[23,10,24,10],[23,1,26,2],[39,1,39,9],[36,1,36,9],[37,1,37,9],[38,1,38,10],[23,3,24,3],[22,1,22,2],[27,1,30,1],[31,1,32,1],[33,1,33,2],[35,1,35,9],[23,5,24,5],[23,6,24,6],[23,7,24,7],[23,8,24,8],[23,9,24,9],[20,1,20,4],[17,1,18,10],[14,1,14,10],[1,1,1,10],[0,1,0,10],[4,2,4,4],[5,2,5,4],[4,6,4,7],[20,6,20,8],[15,1,15,9],[16,1,16,10],[7,2,7,4],[8,2,8,4],[5,6,6,7],[7,6,7,7],[10,2,12,9],[2,1,2,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[6,2,6,4]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 •  4/22/19"}]
[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","2.5 to 10 inches",null,null,null,null,null,null," 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?",null,null,null,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"]
[]
[null,null,null,"(tons/hour)","(tons/year)","(lb/ton)","(tons/year)","(lb/ton)","(ton/year)","(lb/ton)","(ton/year)"]
[null,null,null,null,"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":6.9999999999999999E-4},{"$f":"$E28*F28/2000","v":0},{"$f":"'Aggregate emission factors'!G10","v":6.9999999999999999E-4},{"$f":"$E28*H28/2000","v":0},{"$f":"'Aggregate emission factors'!E36","v":5.0000000000000001E-4},{"$f":"$E28*J28/2000","v":0}]
[null,null,"Secondary",0,{"$f":"D29*8760","v":0},{"$f":"'Aggregate emission factors'!E12","v":2.5000000000000001E-2},0,{"$f":"'Aggregate emission factors'!G12","v":8.6999999999999994E-3},0,{"$f":"'Aggregate emission factors'!E37","v":2.5000000000000001E-4},0]
[null,null,"Tertiary",0,0,{"$f":"'Aggregate emission factors'!E14","v":5.4000000000000003E-3},0,{"$f":"'Aggregate emission factors'!G14","v":2.3999999999999998E-3},0,{"$f":"'Aggregate emission factors'!E38","v":5.0000000000000001E-4},0]
[null,null,"Fines",0,0,{"$f":"'Aggregate emission factors'!E16","v":3.9E-2},0,{"$f":"'Aggregate emission factors'!G16","v":1.4999999999999999E-2},0,{"$f":"'Aggregate emission factors'!E39","v":3.4999999999999994E-4},0]
[null,"Screening","Screening",0,0,{"$f":"'Aggregate emission factors'!E18","v":2.5000000000000001E-2},0,{"$f":"'Aggregate emission factors'!G18","v":8.6999999999999994E-3},0,{"$f":"'Aggregate emission factors'!E40","v":2.5000000000000001E-4},0]
[null,null,"Fines ",0,0,{"$f":"'Aggregate emission factors'!E20","v":0.3},0,{"$f":"'Aggregate emission factors'!G20","v":7.1999999999999995E-2},0,{"$f":"'Aggregate emission factors'!E41","v":2.5000000000000001E-3},0]
[null,"Convey and Transfer Points",null,{"$f":"F21*D28","v":0},{"$f":"D34*F21*8760","v":0},{"$f":"'Aggregate emission factors'!E22","v":3.0000000000000001E-3},0,{"$f":"'Aggregate emission factors'!G22","v":1.1000000000000001E-3},0,{"$f":"'Aggregate emission factors'!E42","v":6.4999999999999994E-5},0]
[null,"Total tons of emissions (excluding combustion from engines)",null,null,null,null,{"$f":"SUM(G28:G34)","v":0},null,{"$f":"SUM(I28:I34)","v":0},null,{"$f":"SUM(K28:K34)","v":0}]
[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"]
[]
[null,null,null,"(tons/year)","(lb/ton)","(tons/year)","(lb/ton)","(ton/year)","(lb/ton)","(ton/year)"]
[null,null,null,null,null,"b*c/2000",null,"b*e/2000",null,"b*g/2000"]
[null,"Crushing","Primary",0,{"$f":"F28","v":6.9999999999999999E-4},{"$f":"$D46*E46/2000","v":0},{"$f":"H28","v":6.9999999999999999E-4},{"$f":"$D46*G46/2000","v":0},{"$f":"J28","v":5.0000000000000001E-4},{"$f":"$D46*I46/2000","v":0}]
[null,null,"Secondary",0,2.5000000000000001E-2,{"$f":"$D47*E47/2000","v":0},8.6999999999999994E-3,{"$f":"$D47*G47/2000","v":0},2.5000000000000001E-4,{"$f":"$D47*I47/2000","v":0}]
[null,null,"Tertiary",0,5.4000000000000003E-3,{"$f":"$D48*E48/2000","v":0},2.3999999999999998E-3,{"$f":"$D48*G48/2000","v":0},5.0000000000000001E-4,{"$f":"$D48*I48/2000","v":0}]
[null,null,"Fines",0,3.9E-2,{"$f":"$D49*E49/2000","v":0},1.4999999999999999E-2,{"$f":"$D49*G49/2000","v":0},3.4999999999999994E-4,{"$f":"$D49*I49/2000","v":0}]
[null,"Screening","Screening",0,2.5000000000000001E-2,{"$f":"$D50*E50/2000","v":0},8.6999999999999994E-3,{"$f":"$D50*G50/2000","v":0},2.5000000000000001E-4,{"$f":"$D50*I50/2000","v":0}]
[null,null,"Fines ",0,0.3,{"$f":"$D51*E51/2000","v":0},7.1999999999999995E-2,{"$f":"$D51*G51/2000","v":0},2.5000000000000001E-3,{"$f":"$D51*I51/2000","v":0}]
[null,"Convey and Transfer Points",null,0,3.0000000000000001E-3,{"$f":"$D52*E52/2000","v":0},1.1000000000000001E-3,{"$f":"$D52*G52/2000","v":0},6.4999999999999994E-5,{"$f":"$D52*I52/2000","v":0}]
[null,"Total tons of emissions (excluding combustion from engines)",null,null,null,{"$f":"SUM(F46:F52)","v":0},null,{"$f":"SUM(H46:H52)","v":0},null,{"$f":"SUM(J46:J52)","v":0}]
[null,"Emission factor source: see 'Aggregate Emission Factors' tab"]

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

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

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

{"sheet":"Potential emissions","index":7,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,2,46,3],[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,1,5,1]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 •  4/22/19"}]
[null,"Potential emissions - Aggregate: sand & gravel"]
[null,{"$f":"IF('Data validation'!A22=\"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,{"$f":"IF('Crusher engine'!J20=7,\"Insignificant Activity\",\" \")","v":" "},{"$f":"IF(Generator!J20=7,\"Insignificant Activity\",\" \")","v":" "}]
[null,"PM",{"$f":"Aggregate!G35","v":0},{"$f":"'Crusher engine'!H20","v":0},{"$f":"Generator!H20","v":0},{"$f":"Fugitive!I57","v":0},{"$f":"SUM(C8:F8)","v":0},100]
[null,"PM10",{"$f":"Aggregate!I35","v":0},{"$f":"'Crusher engine'!H21","v":0},{"$f":"Generator!H21","v":0},{"$f":"Fugitive!I58","v":0},0,25]
[null,"PM2.5",{"$f":"Aggregate!K35","v":0},{"$f":"'Crusher engine'!H22","v":0},{"$f":"Generator!H22","v":0},{"$f":"Fugitive!I59","v":0},0,100]
[null,"SOx",null,{"$f":"'Crusher engine'!H23","v":0},{"$f":"Generator!H23","v":0},null,0,50]
[null,"NOx",null,{"$f":"'Crusher engine'!H24","v":0},{"$f":"Generator!H24","v":0},null,0,100]
[null,"VOC",null,{"$f":"'Crusher engine'!H25","v":0},{"$f":"Generator!H25","v":0},null,0,100]
[null,"CO",null,{"$f":"'Crusher engine'!H26","v":0},{"$f":"Generator!H26","v":0},null,0,100]
[null,"Lead",null,{"$f":"'Crusher engine'!H27","v":0},{"$f":"Generator!H27","v":0},null,0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",null,{"$f":"'Crusher engine'!H29","v":0},{"$f":"Generator!H29","v":0},null,{"$f":"SUM(C17:F17)","v":0}]
[null,"CH4",null,{"$f":"'Crusher engine'!H30","v":0},{"$f":"Generator!H30","v":0},null,{"$f":"SUM(C18:F18)","v":0}]
[null,"N2O",null,{"$f":"'Crusher engine'!H31","v":0},{"$f":"Generator!H31","v":0},null,{"$f":"SUM(C19:F19)","v":0}]
[null,"GHG Total CO2e",null,null,null,null,{"$f":"(G17*1)+(G18*25)+(G19*298)","v":0},100000]
[null,"Hazardous Air Pollutants"]
[null,"1,1,2,2-tetrachloroethane",null,{"$f":"'Crusher engine'!H34","v":0},{"$f":"Generator!H34","v":0},null,{"$f":"SUM(C22:F22)","v":0}]
[null,"1,1,2-trichloroethane",null,{"$f":"'Crusher engine'!H35","v":0},{"$f":"Generator!H35","v":0},null,0]
[null,"1,3-butadiene",null,{"$f":"'Crusher engine'!H36","v":0},{"$f":"Generator!H36","v":0},null,0]
[null,"1,3-dichloropropene",null,{"$f":"'Crusher engine'!H37","v":0},{"$f":"Generator!H37","v":0},null,0]
[null,"Acetaldehyde",null,{"$f":"'Crusher engine'!H38","v":0},{"$f":"Generator!H38","v":0},null,0]
[null,"Acrolein",null,{"$f":"'Crusher engine'!H39","v":0},{"$f":"Generator!H39","v":0},null,0]
[null,"Benzene",null,{"$f":"'Crusher engine'!H40","v":0},{"$f":"Generator!H40","v":0},null,0]
[null,"Biphenyl",null,{"$f":"'Crusher engine'!H41","v":0},{"$f":"Generator!H41","v":0},null,0]
[null,"Carbon tetrachloride",null,{"$f":"'Crusher engine'!H42","v":0},{"$f":"Generator!H42","v":0},null,0]
[null,"Chlorobenzene",null,{"$f":"'Crusher engine'!H43","v":0},{"$f":"Generator!H43","v":0},null,0]
[null,"Chloroform",null,{"$f":"'Crusher engine'!H44","v":0},{"$f":"Generator!H44","v":0},null,0]
[null,"Ethylbenzene",null,{"$f":"'Crusher engine'!H45","v":0},{"$f":"Generator!H45","v":0},null,0]
[null,"Ethylene dibromide",null,{"$f":"'Crusher engine'!H46","v":0},{"$f":"Generator!H46","v":0},null,0]
[null,"Formaldehyde",null,{"$f":"'Crusher engine'!H47","v":0},{"$f":"Generator!H47","v":0},null,0]
[null,"Hexane",null,{"$f":"'Crusher engine'!H48","v":0},{"$f":"Generator!H48","v":0},null,{"$f":"SUM(C36:F36)","v":0}]
[null,"Methanol",null,{"$f":"'Crusher engine'!H49","v":0},{"$f":"Generator!H49","v":0},null,0]
[null,"Methylene chloride",null,{"$f":"'Crusher engine'!H50","v":0},{"$f":"Generator!H50","v":0},null,0]
[null,"Naphthalene",null,{"$f":"'Crusher engine'!H51","v":0},{"$f":"Generator!H51","v":0},null,0]
[null,"PAH",null,{"$f":"'Crusher engine'!H52","v":0},{"$f":"Generator!H52","v":0},null,0]
[null,"Phenol",null,{"$f":"'Crusher engine'!H53","v":0},{"$f":"Generator!H53","v":0},null,0]
[null,"Styrene",null,{"$f":"'Crusher engine'!H54","v":0},{"$f":"Generator!H54","v":0},null,0]
[null,"Tetrachloroethane",null,{"$f":"'Crusher engine'!H55","v":0},{"$f":"Generator!H55","v":0},null,0]
[null,"Toluene",null,{"$f":"'Crusher engine'!H56","v":0},{"$f":"Generator!H56","v":0},null,0]
[null,"Vinyl chloride",null,{"$f":"'Crusher engine'!H57","v":0},{"$f":"Generator!H57","v":0},null,0]
[null,"Xylene",null,{"$f":"'Crusher engine'!H58","v":0},{"$f":"Generator!H58","v":0},null,0]
[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"},null,null,null,{"$f":"MAX(G22:G46)","v":0},10]
[null,"HAP total",null,null,null,null,{"$f":"SUM(G22:G46)","v":0},25]

{"sheet":"Actual emissions","index":8,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"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 •  4/22/19"}]
[null,"Actual emissions - Aggregate: sand & gravel"]
[null,{"$f":"IF('Data validation'!A25=\"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","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!F53","v":0},{"$f":"'Crusher engine'!I20","v":0},{"$f":"Generator!I20","v":0},{"$f":"Fugitive!I67","v":0},{"$f":"SUM(C8:F8)","v":0},50]
[null,"PM10",{"$f":"Aggregate!H53","v":0},{"$f":"'Crusher engine'!I21","v":0},{"$f":"Generator!I21","v":0},{"$f":"Fugitive!I68","v":0},0,50]
[null,"PM2.5",{"$f":"Aggregate!J53","v":0},{"$f":"'Crusher engine'!I22","v":0},{"$f":"Generator!I22","v":0},{"$f":"Fugitive!I69","v":0},0,50]
[null,"SOx",null,{"$f":"'Crusher engine'!I23","v":0},{"$f":"Generator!I23","v":0},null,0,50]
[null,"NOx",null,{"$f":"'Crusher engine'!I24","v":0},{"$f":"Generator!I24","v":0},null,0,50]
[null,"VOC",null,{"$f":"'Crusher engine'!I25","v":0},{"$f":"Generator!I25","v":0},null,0,50]
[null,"CO",null,{"$f":"'Crusher engine'!I26","v":0},{"$f":"Generator!I26","v":0},null,0,50]
[null,"Lead",null,{"$f":"'Crusher engine'!I27","v":0},{"$f":"Generator!I27","v":0},null,0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",null,{"$f":"'Crusher engine'!I29","v":0},{"$f":"Generator!I29","v":0},null,{"$f":"SUM(C17:F17)","v":0}]
[null,"CH4",null,{"$f":"'Crusher engine'!I30","v":0},{"$f":"Generator!I30","v":0},null,{"$f":"SUM(C18:F18)","v":0}]
[null,"N2O",null,{"$f":"'Crusher engine'!I31","v":0},{"$f":"Generator!I31","v":0},null,{"$f":"SUM(C19:F19)","v":0}]
[null,"GHG Total CO2e",null,null,null,null,{"$f":"(G17*1)+(G18*25)+(G19*298)","v":0},50000]
[null,"Hazardous Air Pollutants"]
[null,"1,1,2,2-tetrachloroethane",null,{"$f":"'Crusher engine'!I34","v":0},{"$f":"Generator!I34","v":0},null,{"$f":"SUM(C22:F22)","v":0}]
[null,"1,1,2-trichloroethane",null,{"$f":"'Crusher engine'!I35","v":0},{"$f":"Generator!I35","v":0},null,0]
[null,"1,3-butadiene",null,{"$f":"'Crusher engine'!I36","v":0},{"$f":"Generator!I36","v":0},null,0]
[null,"1,3-dichloropropene",null,{"$f":"'Crusher engine'!I37","v":0},{"$f":"Generator!I37","v":0},null,0]
[null,"Acetaldehyde",null,{"$f":"'Crusher engine'!I38","v":0},{"$f":"Generator!I38","v":0},null,0]
[null,"Acrolein",null,{"$f":"'Crusher engine'!I39","v":0},{"$f":"Generator!I39","v":0},null,0]
[null,"Benzene",null,{"$f":"'Crusher engine'!I40","v":0},{"$f":"Generator!I40","v":0},null,0]
[null,"Biphenyl",null,{"$f":"'Crusher engine'!I41","v":0},{"$f":"Generator!I41","v":0},null,0]
[null,"Carbon tetrachloride",null,{"$f":"'Crusher engine'!I42","v":0},{"$f":"Generator!I42","v":0},null,0]
[null,"Chlorobenzene",null,{"$f":"'Crusher engine'!I43","v":0},{"$f":"Generator!I43","v":0},null,0]
[null,"Chloroform",null,{"$f":"'Crusher engine'!I44","v":0},{"$f":"Generator!I44","v":0},null,0]
[null,"Ethylbenzene",null,{"$f":"'Crusher engine'!I45","v":0},{"$f":"Generator!I45","v":0},null,0]
[null,"Ethylene dibromide",null,{"$f":"'Crusher engine'!I46","v":0},{"$f":"Generator!I46","v":0},null,0]
[null,"Formaldehyde",null,{"$f":"'Crusher engine'!I47","v":0},{"$f":"Generator!I47","v":0},null,0]
[null,"Hexane",null,{"$f":"'Crusher engine'!I48","v":0},{"$f":"Generator!I48","v":0},null,0]
[null,"Methanol",null,{"$f":"'Crusher engine'!I49","v":0},{"$f":"Generator!I49","v":0},null,0]
[null,"Methylene chloride",null,{"$f":"'Crusher engine'!I50","v":0},{"$f":"Generator!I50","v":0},null,0]
[null,"Naphthalene",null,{"$f":"'Crusher engine'!I51","v":0},{"$f":"Generator!I51","v":0},null,0]
[null,"PAH",null,{"$f":"'Crusher engine'!I52","v":0},{"$f":"Generator!I52","v":0},null,0]
[null,"Phenol",null,{"$f":"'Crusher engine'!I53","v":0},{"$f":"Generator!I53","v":0},null,0]
[null,"Styrene",null,{"$f":"'Crusher engine'!I54","v":0},{"$f":"Generator!I54","v":0},null,0]
[null,"Tetrachloroethane",null,{"$f":"'Crusher engine'!I55","v":0},{"$f":"Generator!I55","v":0},null,0]
[null,"Toluene",null,{"$f":"'Crusher engine'!I56","v":0},{"$f":"Generator!I56","v":0},null,0]
[null,"Vinyl chloride",null,{"$f":"'Crusher engine'!I57","v":0},{"$f":"Generator!I57","v":0},null,0]
[null,"Xylene",null,{"$f":"'Crusher engine'!I58","v":0},{"$f":"Generator!I58","v":0},null,0]
[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"},null,null,null,{"$f":"MAX(G22:G46)","v":0},5]
[null,"HAP total",null,null,null,null,{"$f":"SUM(G22:G46)","v":0},12.5]

{"sheet":"Permits & requirements","index":9,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[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],[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],[17,5,19,6],[17,7,19,7],[17,8,19,8],[20,4,25,4],[20,5,20,6],[21,5,21,6],[21,7,23,7],[21,8,23,8],[24,7,25,7],[24,8,25,8],[40,1,40,2],[40,3,40,4],[41,2,41,8],[26,8,29,8],[34,1,34,6],[35,2,37,3],[35,4,37,5],[38,2,38,3],[38,4,38,5],[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],[20,1,21,1],[20,2,21,2],[32,1,33,8],[31,1,31,8],[22,1,23,1],[22,2,23,2],[24,1,25,1],[24,2,25,2],[26,1,29,7],[24,5,25,6],[22,5,23,6]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 •  4/22/19"}]
[null,"Permits & requirements"]
[null,"The need for a permit is based on your entire business' potential air emissions. All activities that put pollutants into the air (such as paint and solvent use that are not associated with maintenance) need to be assessed if they are not included in this calculator. Once you identify if you need a permit, based on whether an NSPS applies and potential emissions, you can then use your actual emissions to see which permit is the best fit for your business."]
[]
[]
[null,"Content below is based on the information entered into this calculator and is not an official MPCA permit determination."]
[]
[]
[null,"Is a permit required?",null,null,null,"What type of permit?\nAssumes all air pollutant activities are entered into this calculator.\nIf you have additional air emission sources, the recommendation below cannot be used. You must assess your facility's total potential emissions from all sources to identify your permitting needs."]
[null,"The summary below is based on information you entered in the blue tabs. "]
[null,"Your business's potential emissions","Your business's actual emissions","A federal NSPS","A federal NESHAP"]
[]
[null,{"$f":"IF('Data validation'!A22=\"yes\",\"do\",\"do not\")","v":"do not"},{"$f":"IF('Data validation'!A25=\"yes\",\"do\",\"do not\")","v":"do not"},{"$f":"IF('Data validation'!A17>0,\"Return to Federal tab and answer all Y/N questions\",IF(AND('Data validation'!A17=0,'Data validation'!A12>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"]
[null,null,null,"yes",null,"Registration Option A",null,"Info about Air Registration Permits","Application Forms, scroll to Section 3"]
[null,"yes","no","no",null,"Registration Option D"]
[null,null,null,"yes"]
[null,"yes","yes","no",null,"Other state or federal permit",null,"Info about Air Permits","Application Forms, scroll to Section 1"]
[null,null,null,"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.",null,null,null,null,null,null,"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,"cut":false,"hidden":false,"merged":[[24,1,26,9],[30,2,30,9],[27,1,29,9],[41,1,41,2],[39,1,40,1],[32,1,32,9],[33,1,34,2],[35,1,38,1],[35,6,36,9],[37,6,38,9],[33,3,33,4],[39,6,40,9],[33,5,34,9],[15,2,16,2],[19,7,20,7],[21,7,22,7],[17,2,18,2],[19,2,20,2],[23,6,23,9],[23,1,23,5],[1,1,1,9],[3,1,3,9],[13,7,14,7],[15,7,16,7],[17,7,18,7],[13,9,14,9],[15,9,16,9],[17,9,18,9],[4,3,8,3],[4,4,7,4],[4,5,7,5],[4,6,7,6],[19,9,20,9],[21,9,22,9],[4,9,7,9],[4,1,8,2],[0,1,0,9],[21,1,22,2],[13,5,14,5],[15,5,16,5],[17,5,18,5],[19,5,20,5],[21,5,22,5],[17,1,20,1],[9,1,16,1],[9,2,10,2],[11,2,12,2],[13,2,14,2],[4,7,7,7],[4,8,7,8]]}
[null,{"$f":"Instructions!G2","v":"p-sbap5-30 •  4/22/19"}]
[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"]
[]
[]
[]
[null,null,null,null,"(lb/ton)","(%)","(lb/ton)","(%)","(lb/ton)","(%)"]
[null,"Crushing","Primary1","Uncontrolled",6.9999999999999999E-4,null,{"$f":"E10","v":6.9999999999999999E-4},null,"ND"]
[null,null,null,"Controlled","ND",null,"ND",null,"ND"]
[null,null,"Secondary2","Uncontrolled",2.5000000000000001E-2,null,8.6999999999999994E-3,null,"ND"]
[null,null,null,"Controlled","ND",null,"ND",null,5.0000000000000002E-5]
[null,null,"Tertiary","Uncontrolled",5.4000000000000003E-3,{"$f":"(E14-E15)/E14","v":0.7777777777777779},2.3999999999999998E-3,{"$f":"(G14-G15)/G14","v":0.77499999999999991},"ND"]
[null,null,null,"Controlled",1.1999999999999999E-3,null,5.4000000000000001E-4,null,1E-4]
[null,null,"Fines","Uncontrolled",3.9E-2,{"$f":"(E16-E17)/E16","v":0.92307692307692302},1.4999999999999999E-2,{"$f":"(G16-G17)/G16","v":0.92},"ND"]
[null,null,null,"Controlled",3.0000000000000001E-3,null,1.1999999999999999E-3,null,6.9999999999999994E-5]
[null,"Screening","Screening","Uncontrolled",2.5000000000000001E-2,{"$f":"(E18-E19)/E18","v":0.91200000000000003},8.6999999999999994E-3,{"$f":"(G18-G19)/G18","v":0.9149425287356322},"ND"]
[null,null,null,"Controlled",2.2000000000000001E-3,null,7.3999999999999999E-4,null,5.0000000000000002E-5]
[null,null,"Fines ","Uncontrolled",0.3,{"$f":"(E20-E21)/E20","v":0.98799999999999999},7.1999999999999995E-2,{"$f":"(G20-G21)/G20","v":0.96944444444444455},"ND"]
[null,null,null,"Controlled",3.5999999999999999E-3,null,2.2000000000000001E-3,null,"ND"]
[null,"Conveyor Transfer Points",null,"Uncontrolled",3.0000000000000001E-3,{"$f":"(E22-E23)/E22","v":0.95333333333333337},1.1000000000000001E-3,{"$f":"(G22-G23)/G22","v":0.95818181818181813},"ND"]
[null,null,null,"Controlled",1.3999999999999999E-4,null,4.6E-5,null,1.2999999999999999E-5]
[null,"1Emission factors from AP-42, Chapter 11.19-2, unless otherwise stated.",null,null,null,null,"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"]
[null,null,null,"(reason)","(lb/ton)"]
[null,"Crushing","Primary",1,{"$f":"E38","v":5.0000000000000001E-4},1,"Emissions factor assumed, worst-case, to equal PM-2.5 of secondary crusher."]
[null,null,"Secondary",2,{"$f":"I13*5","v":2.5000000000000001E-4}]
[null,null,"Tertiary",2,{"$f":"I15*5","v":5.0000000000000001E-4},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":2.5000000000000001E-4},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":2.5000000000000001E-3}]
[null,"Conveyor Transfer Points",null,2,{"$f":"I23*5","v":6.4999999999999994E-5}]

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

{"sheet":"Data validation","index":12,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,0,1,2]]}
[{"$f":"Instructions!G2","v":"p-sbap5-30 •  4/22/19"}]
["Data validation"]
[]
["General data","Engines"]
["Selection","Engine and fuel type","Choose one to calculate actual emissions"]
["Choose Y/N","Choose one","Number of hours operated per 12 months"]
["Yes","Reciprocating - diesel","Quantity of fuel actually burned per 12 months"]
["No","Reciprocating - gasoline"]
[null,"Turbine - natural gas"]
["Equation/reference","Recip - nat gas 4-stroke rich burn","Actual emissions entry"]
["NSPS applies","Recip - nat gas 4-stroke lean burn","hours per year (hr/yr)"]
[{"$f":"SUM(A13:A14)","v":0},"Recip - nat gas 2-stroke lean burn","million Btu per year (MMBtu/yr)"]
[{"$f":"COUNTIF('Federal standards'!N16,\"Yes\")","v":0},null,"gallons per year (gal/yr)"]
[{"$f":"COUNTIF('Federal standards'!N48,\"Yes\")","v":0},"Engine use"]
[null,"Choose one"]
["NSPS no selection","Routine"]
[{"$f":"SUM(A18:A19)","v":2},"Emergency"]
[{"$f":"IF('Federal standards'!N16=\"Choose Y/N\",1,0)","v":1}]
[{"$f":"IF('Federal standards'!N48=\"Choose Y/N\",1,0)","v":1},"Input Value"]
[null,"Choose one"]
["Potential exceed","Horsepower(HP) or Brake Power (HP-hr)"]
[{"$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"},"Standard cubic feet/hr (scf/hr)"]
[]
["Actual exceed","Fuel Conversion"]
[{"$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"},"Brake specific fuel consumption"]
[null,"Heat value of fuel"]