{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions","Federal standards","MN bulk ag. rule","Grain elevator potential","Grain elevator actual","Feed mill potential","Feed mill actual","Natural gas dryer","Propane dryer","Fugitive","Potential emissions","Actual emissions","Permits & requirements","Data validation"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":28,"comments":0,"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":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[14,1,14,14],[24,1,24,14],[17,2,17,14],[18,2,18,14],[0,5,0,14],[4,1,4,14],[16,1,16,14],[9,1,9,14],[5,1,5,14],[10,1,11,14],[6,1,8,14],[12,1,13,14],[1,5,3,14],[0,1,3,4],[33,1,33,10],[33,11,33,14],[19,2,19,14],[20,2,20,14],[21,2,21,14],[30,4,30,13],[30,1,30,3],[32,1,32,8],[25,1,25,14],[26,1,26,14],[27,2,27,3],[28,2,28,3],[27,5,27,8],[27,10,27,14],[28,4,28,14]]}
[null,null,null,null,null,"Grain elevators and feed mills\nAir emissions calculator"]
[null,null,null,null,null,"p-sbap5-28  •  6/6/23"]
[]
[]
[null,"Instructions"]
[null,"1) Start with the Federal Standards tab to identify if a federal rule applies to your business."]
[null,"2) Next, go to the MN Bulk Ag. Rule tab. Find out about nuisance rules that all grain handling facilities are required to follow, Minnesota's rules for bulk\n    agricultural commodities, and whether you need to control emissions (either by using emission control equipment, other means of controlling or\n    minimizing emissions)."]
[]
[]
[null,"3) Enter information on the other blue tabs to calculate your potential air emissions from other activities, including grain dryers. "]
[null,"4) The green tabs total the potential and actual emissions from the information you entered in the blue tabs. The emission totals will help you decide\n    which permit to apply for. "]
[]
[null,"5) The Permits & Requirements tab summarizes the information you entered in the blue tabs, what your emissions mean, and what type of permit\n    you may need based on the information entered into this calculator."]
[]
[null,"6) 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 or formulas in white boxes. White boxes contain intermediate calculations for determining emissions.  "]
[null,"Green","Your emission totals are in green boxes. These are automatically calculated based on information entered in blue boxes."]
[null,"Yellow","Permit and insignificant activity thresholds"]
[null,"Orange","Orange boxes are filled with standard values. You may change them if you have test results that provide data specific to your site."]
[null,"Blue Text","Key information and tips."]
[]
[null,"Assistance"]
[null,"This calculator was created by the Minnesota Pollution Control Agency's (MPCA) Small Business Environmental Assistance Program (SBEAP)."]
[null,"We provide free, confidential, environmental assistance to small businesses. For more information:"]
[null,"Call:","651/282-6143",null,"Email:","smallbizhelp.pca@state.mn.us"]
[null,null,"800/657-3938"]
[]
[null,"Online at the MPCA website at: ",null,null,"https://www.pca.state.mn.us/smallbizhelp"]
[]
[null,"For more information for grain elevators and feed mills, visit the MPCA website at:"]
[null,"https://www.pca.state.mn.us/business-with-us/grain-elevators-feed-mills-and-fertilizer-mixing-plants"]

{"sheet":"Federal standards","index":1,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,9,47,15],[47,2,47,8],[37,13,39,14],[27,2,27,14],[41,13,41,14],[30,10,30,12],[30,8,30,9],[30,13,30,14],[30,1,30,7],[34,1,37,12],[33,1,33,12],[33,13,36,14],[46,7,46,13],[32,13,32,14],[32,1,32,12],[28,2,28,14],[9,1,9,12],[11,2,12,12],[23,1,23,14],[24,1,24,14],[25,2,25,14],[15,1,15,6],[14,1,14,14],[13,2,13,12],[15,7,15,14],[18,1,19,14],[17,1,17,14],[10,2,10,9],[9,13,13,14],[26,2,26,14],[20,2,20,10],[21,2,21,10],[22,2,22,10],[46,2,46,6],[29,1,29,14],[44,2,45,12],[42,1,43,12],[41,1,41,12],[42,13,45,14],[39,2,39,12],[8,2,8,12],[3,13,3,14],[3,1,3,12],[4,13,8,14],[0,1,0,14],[1,1,1,14],[4,1,4,12],[5,2,5,12],[6,2,7,12]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"U.S. Environmental Protection Agency (EPA) new source performance standards (NSPS) "]
[]
[null,"Does the federal new source performance standard for grain elevators apply?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"This standard applies to unloading stations, loading stations, grain dryers, and grain handling operations that:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$4=\"Yes\",\"Because an NSPS applies to your operation, you need an air permit.\",IF($N$4=\"No\",\"Continue to the next question below.\",IF($N$4=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,"1)","were constructed, modified, or reconstructed after August 3, 1978, and"]
[null,"2)","are not located at animal food manufacturers, pet food manufacturers, cereal manufacturers, breweries, or livestock feedlots, and"]
[]
[null,"3)","have a permanent storage capacity of 2.5 million US bushels or more."]
[null,"or",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$4=\"Yes\",\"Continue to the next question\",IF($N$4=\"No\",\"\",IF($N$4=\"Choose Y/N\",\" \")))","v":" "}]
[null,"1)","were constructed, modified, or reconstructed after August 3, 1978, and"]
[null,"2)","are located at a wheat flour mill, wet corn mill, dry corn mill (for human consumption), rice mill, or soybean oil extraction plant, and"]
[]
[null,"3)","have a permanent storage capacity of about 1 million US bushels or more.  "]
[]
[null,"The full text of NSPS for Grain Elevators is available at:",null,null,null,null,null,"40 CFR pt. 60, subp. DD"]
[]
[null,"What is included in construction, modification, and reconstruction?"]
[null,"If you do an activity which counts as construction, modification, or reconstruction it may cause the grain elevator NSPS to apply to you or create the need for a permit amendment. Some examples of construction, modification and reconstruction are:"]
[]
[null,"· ","create, build, or install a new grain dryer or a grain dryer that increases grain handling capacity,"]
[null,"· ","increase in permanent storage capacity that increases the hourly grain handling capacity, or"]
[null,"· ","replace components that cost 50% of the full cost to construct a similar, new facility."]
[]
[null,"The activities below do not count as modifications, as stated in the grain elevator NSPS:"]
[null,"· ","add gravity loadout spouts to existing grain storage or transfer bins,"]
[null,"· ","install automatic grain weighing scales, "]
[null,"· ","replace motor and drive units in existing grain handling equipment, or"]
[null,"· ","install permanent storage capacity without increasing hourly grain handling capacity."]
[]
[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"]
[]
[null,"Does the federal regulation for feed mills apply to you?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"\"Regulations for Prepared Feeds Manufacturing\" is a different type of federal rule, not an NSPS, that may affect you. ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$33=\"Yes\",\"Follow the requirements of the rule.\",IF($N$33=\"No\",\"Continue to the next question.\",IF($N$33=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,"Although many feed mills are exempt from the federal NSPS for grain elevators, grain processing facilities and feed mills may be subject to the federal rule for \"Prepared Feeds Manufacturing.\" This rule is independent of other permits and regulations. Whether or not this rule applies to your facility does not affect whether you need a permit, and likewise whether you need a permit does not affect whether this rule applies. "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$33=\"Yes\",\"Continue to the next question.\",IF($N$33=\"No\",\" \",IF($N$33=\"Choose Y/N\",\" \")))","v":" "}]
[null,null,"For information see EPA fact sheet (40 CFR pt. 63, subp. 7D): "]
[null,null,"https://www.epa.gov/stationary-sources-air-pollution/prepared-feeds-manufacturing-national-emission-standards-hazardous"]
[]
[null,"Do other federal new source performance standards apply?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"Even if the grain elevator NSPS does not apply to your facility, there are other NSPS that might apply depending on what other equipment or activities you have at your facility.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$42=\"Yes\",\"Because an NSPS applies to your operation, you need an air permit.\",IF($N$42=\"No\",\"Continue to the next blue tab.\",IF($N$42=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[]
[null,null,"For example, if you have a generator, turbine, or an engine that is not on wheels, see the rules for internal combustion engines."]
[]
[null,null,"More information is available on the MPCA website at:",null,null,null,null,"https://www.pca.state.mn.us/business-with-us/stationary-engines"]
[null,null,"See a list of other NSPS that may apply to you on the MPCA website at:",null,null,null,null,null,null,"https://www.pca.state.mn.us/sites/default/files/aq-f1-gi09d.doc"]

{"sheet":"MN bulk ag. rule","index":2,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[[14,1,15,14],[65,11,65,14],[21,1,22,14],[26,2,26,14],[31,2,31,14],[33,1,33,7],[27,2,27,14],[29,1,29,14],[33,8,33,11],[23,1,23,14],[53,1,53,14],[52,10,52,14],[52,7,52,9],[42,1,42,14],[40,2,40,14],[43,2,43,14],[12,5,12,6],[13,2,13,8],[13,9,13,14],[12,8,12,10],[12,11,12,13],[12,2,12,4],[1,1,1,14],[0,1,0,14],[4,2,4,14],[8,1,8,14],[9,1,11,14],[2,1,2,14],[3,1,3,14],[5,2,5,14],[6,1,7,14],[52,1,52,6],[51,4,51,14],[41,3,41,10],[51,1,51,3],[47,2,47,14],[48,6,48,10],[48,2,48,5],[44,1,44,14],[45,11,45,14],[41,11,41,14],[45,3,45,10],[49,3,49,10],[50,1,50,14],[49,11,49,14],[32,1,32,14],[34,1,34,14],[39,1,39,14],[16,1,16,12],[16,13,16,14],[36,1,38,14],[24,1,24,14],[30,2,30,7],[30,9,30,14],[25,1,25,14],[28,1,28,14],[17,12,17,14],[17,1,17,11],[35,1,35,14],[18,2,18,14],[19,2,20,14],[75,11,75,14],[67,1,67,14],[73,1,74,14],[68,1,68,14],[69,2,69,14],[70,2,70,14],[71,3,71,14],[72,3,72,14],[59,3,59,14],[58,1,58,14],[64,1,64,14],[55,1,55,14],[56,1,57,14],[60,3,60,14],[61,3,61,14],[62,3,63,14]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Minnesota bulk agricultural nuisance rule"]
[null,"All grain and commodity facilities in Minnesota must comply with the bulk ag. nuisance rule"]
[null,"The rule states:"]
[null,"· ","Grain or commodity facilities may not operate or maintain a facility that creates a public nuisance, and"]
[null,"· ","If the operation or maintenance of a facility creates a public nuisance, you are required to eliminate the nuisance."]
[]
[]
[null,"Nuisances and fugitive dust"]
[null,"Complaints are commonly made about bees wings and dust from grain handling facilities and must be managed. If the grain elevator NSPS applies, you must still comply with the MPCA's nuisance and fugitive dust rules. If the grain elevator NSPS does not apply and you are required to comply with the bulk ag. rule instead, there are limits on the amount of dust and other solids that can be released into the air. See prohibited discharges."]
[]
[]
[null,"· ","Bulk ag. nuisance rule",null,null,"Minn. R. 7011.1010",null,"· ","Bulk ag. prohibited discharges ",null,null,"Minn. R. 7011.1005, subp. 3"]
[null,"· ","Preventing particulate matter from becoming airborne (fugitive dust) ",null,null,null,null,null,null,"Minn. R. 7011.0150"]
[]
[]
[null,"Does the Minnesota bulk ag. rule apply to you?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"Family farms are exempt from the MPCA’s bulk ag. rule, but the facility must meet the statutory definition: ",null,null,null,null,null,null,null,null,null,null,"Minn. Stat. § 116B.02, subp. 5 and 6"]
[null,"· ","\"Family farm\" is any farm owned by one or more persons who are related, with at least one owner living at or operating the farm. "]
[null,"· ","\"Family farm corporation\" is a corporation founded for the purpose of farming and owning agricultural land. The majority of stockholders must be related, cannot be corporations, and at least one of the stockholders, as a person, must be living at or operating the farm."]
[]
[null,"--> \"Related\" means the owners are all within the first three degrees of kindred which includes (1st) parents, children, siblings, (2nd) grandparents, grandchildren, uncle/aunt, (3rd) niece/nephew, great grandparents, great grandchildren."]
[]
[]
[null,"If you are not a family farm:"]
[null,"The Bulk Ag. Rule applies to facilities where grains and commodities are unloaded, handled, cleaned, dried, stored, ground, or loaded."]
[null,"· ","\"Grain\" means corn, wheat, soybeans, sorghum, rice, rye, oats, barley, flax, or sunflower seeds."]
[null,"· ","\"Commodity\" means grain by-products, seed, beet pulp or pellets, and alfalfa meal or pellets."]
[]
[null,"If you have both grain and commodity operations at the same facility, it is possible for:"]
[null,"1)","the grain elevator NSPS to apply to your grain operations ",null,null,null,null,null,"and","the bulk ag. rule apply to your commodity operations. "]
[null,"or        2)","the grain and commodity operations to both need to follow only to the bulk ag. rule."]
[]
[null,"Full text of the Bulk Agricultural Commodity Facilities rule is available at:",null,null,null,null,null,null,"Minn. R. 7011.1000 to 7011.1015"]
[]
[null,"Are emissions required to be controlled?"]
[null,"When emission must be controlled, you can use the pollutant capture efficiency (for particulate matter (PM) and particulate matter less than 10 micrometers (PM-10)) in your actual emission calculations. See more information in each tab in the section 'What you need to know about the calculations' #3. But, first, answer the questions below to see if you are required to control emissions."]
[]
[]
[]
[null,"1)","Which of the following is true for your facility?"]
[null,null,null,"Choose one"]
[]
[null,"2)","What is your annual throughput* in tons?\""]
[null,"*Throughput = (tons of commodities received + tons of commodities shipped)  /  2           based on the average of the last 3 years"]
[null,null,null,"Choose one"]
[]
[null,"3)","When was the facility constructed, modified, or reconstructed?"]
[null,null,"*See definitions at Minn. R. 7005.0100",null,null,null,"https://www.revisor.mn.gov/rules/7005.0100/"]
[null,null,null,"Choose one"]
[]
[null,"Control is not required.",null,null,"Review the prohibited discharges and the nuisance rule. Continue to the next tab to calculate air emissions."]
[null,"Control is required. See MPCA Control Equipment Rule. ",null,null,null,null,null,"Minn. R. 7011.0060 to 7011.0080",null,null," Continue to the next tab to calculate air emissions."]
[]
[]
[null,"Opacity standards"]
[null,"According to your entries above, you are required to control emissions. This means you must limit the opacity (amount that light is obscured by dusts and particles) to meet the following standards.  "]
[]
[null,"1) Fugitive emissions"]
[null,null,"Opacity","Process"]
[null,null,0.05,"Truck unloading station, railcar loading and unloading station, or grain handling"]
[null,null,0.1,"Truck loading station"]
[null,null,0.2,"Ship or barge loading or unloading station. During trimming or topping off, when normal loading procedures cannot be used, no opacity standard applies."]
[]
[null,"2) If using control equipment, the collection efficiency must be at least 80% by weight and not discharge in excess of 10% opacity."]
[null,null,null,null,null,null,null,null,null,null,null,"Minn. R. 7011.1005"]
[]
[null,"Temporary storage piles"]
[null,"There is no performance standard for portable equipment and fugitive emissions directly associated with a temporary storage facility when you:"]
[null,"1)","are required to control emissions under the Bulk Ag. Rule, AND"]
[null,"2)","have temporary grain storage piles that meet the following conditions:"]
[null,null,"· ","have an asphalt, concrete, or comparable base with rigid, self-supporting sidewalls, and"]
[null,null,"· ","provide adequate aeration and acceptable covering. "]
[null,"The portable equipment cannot be fixed in any one spot and can be moved. Portable equipment includes portable receiving pits, portable augers and conveyors, and portable reclaim equipment directly associated with the temporary storage facility. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Minn. Statute 116.07, subd. 2c."]

{"sheet":"Grain elevator potential","index":3,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[[69,1,69,4],[48,1,48,2],[50,1,52,2],[37,2,39,11],[37,1,39,1],[40,2,43,11],[44,1,45,1],[64,1,64,2],[65,1,65,2],[46,1,46,11],[59,1,62,1],[53,4,68,4],[53,7,68,7],[44,2,45,11],[40,1,43,1],[47,8,47,11],[0,1,0,11],[1,1,1,11],[4,1,4,11],[17,1,17,11],[36,1,36,11],[12,6,12,7],[5,1,5,11],[6,2,7,6],[7,7,7,9],[8,7,8,9],[8,2,8,6],[18,3,18,4],[10,6,10,8],[11,6,11,7],[34,1,35,11],[15,1,16,11],[72,1,73,11],[49,3,50,3],[49,4,50,4],[49,5,50,5],[49,6,50,6],[49,7,50,7],[49,8,50,8],[49,9,50,9],[49,10,50,10],[49,11,50,11],[66,1,68,1],[63,1,63,2],[70,1,70,5],[70,6,70,11],[71,1,71,11],[53,1,58,1],[29,1,29,11],[22,1,22,2],[20,1,20,4],[18,1,18,2],[2,1,2,11],[10,2,14,4],[14,5,14,8],[3,6,3,11]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Air emissions for grain elevators - Potential emissions"]
[null,"Important: If you are applying for a state or federal individual air permit, do not use this tab for your application. Individual permit applications must calculate potential emissions for each "]
[null,"emission unit. Guidance is available at MPCA's air permit emission calculation page:",null,null,null,null,"https://www.pca.state.mn.us/business-with-us/grain-elevators-and-feed-mills-emission-calculations"]
[null,"Calculate your facility's maximum capacity."]
[null,"There are two classifications of elevators.1 The type of elevator you are will determine how to calculate the facility's maximum capacity."]
[null,null,"Country elevator: receives more than 50 percent of its grain from farmers in the immediate vicinity during the harvest season. "]
[null,null,null,null,null,null,null,"What type of elevator is your facility?"]
[null,"or","Terminal elevator: receives grain primarily from other elevators.",null,null,null,null,"Choose one"]
[]
[null,null,{"$f":"IF(H9=\"Country elevator\",\"Maximum capacity is the largest amount of grain that arrived at or was handled by your facility in the past five years increased by 20% to allow for annual variations.\",IF(H9=\"Terminal Elevator\",\"Maximum capacity is the most amount of grain that could possibly be processed assuming an unlimited supply is available.\",IF(H9=\"Select one\",\" \")))","v":false},null,null,null,{"$f":"IF(H9=\"Select One\",\"\",IF(H9=\"terminal elevator\",\"Maximum capacity (tons per year)\",IF(H9=\"country elevator\",\"Maximum capacity (tons per year)\")))","v":false},null,null,{"$f":"IF(H9=\"Country elevator\",\"Year 1\",IF(H9=\"Terminal Elevator\",\" \",IF(H9=\"Select one\",\" \")))","v":false},null,"ton per year"]
[null,null,null,null,null,null,0,null,null,{"$f":"IF(H9=\"Country elevator\",\"Year 2\",IF(H9=\"Terminal Elevator\",\" \",IF(H9=\"Select one\",\" \")))","v":false},null,"ton per year"]
[null,null,null,null,null,null,{"$f":"MAX(K11:K15)*1.2","v":0},null,null,{"$f":"IF(H9=\"Country elevator\",\"Year 3\",IF(H9=\"Terminal Elevator\",\" \",IF(H9=\"Select one\",\" \")))","v":false},null,"ton per year"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H9=\"Country elevator\",\"Year 4\",IF(H9=\"Terminal Elevator\",\" \",IF(H9=\"Select one\",\" \")))","v":false},null,"ton per year"]
[null,null,null,null,null,"-------Enter amount of grain for the previous 5 years--------->",null,null,null,{"$f":"IF(H9=\"Country elevator\",\"Year 5\",IF(H9=\"Terminal Elevator\",\" \",IF(H9=\"Select one\",\" \")))","v":false},null,"ton per year"]
[]
[]
[null,"Facility information for emission calculations"]
[null,"Max. Capacity (ton/year)",null,{"$f":"IF(G12=0,G13,IF(G13=0,G12,IF(SUM(G12,G13)=0,0,IF(AND(G12>0,G13>0),\"Choose One Elevator Type\"))))","v":0},null,"Max. capacity will be entered automatically from above"]
[]
[null,"Do you have a traditional facility with a headhouse?",null,null,null,"Choose Y/N"]
[]
[null,"Grain received by:",null,"Truck straight","Choose Y/N",null,null,"Grain loaded out by:","Truck unspecified","Choose Y/N"]
[null,null,null,"Truck hopper","Choose Y/N"]
[null,null,null,"Rail","Choose Y/N",null,null,null,"Rail","Choose Y/N"]
[null,null,null,"Barge","Choose Y/N","--> If yes, type:",null,null,"Barge","Choose Y/N"]
[null,null,null,"Ship","Choose Y/N",null,null,null,"Ship","Choose Y/N"]
[]
[null,null,null,"Do you clean the grain?","Choose Y/N","-----> ",null,null,"If yes, what is the total grain cleaning capacity?",null,"tons per hour"]
[]
[null,null,null,"Do you have 1 or more grain dryers?","Choose Y/N","----> If yes, what type(s)?",null,null,"Total capacity (ton per hour)",null,"Drying Capacity"]
[null,null,null,null,null,"Rack","Choose Y/N","----->",null,null,{"$f":"I34+I33+I32","v":0},"ton per hour"]
[null,null,null,null,null,"Rack with self-cleaning screen (<50 mesh)","Choose Y/N","----->",null,null,{"$f":"K32*8760","v":0},"ton per year"]
[null,null,null,null,null,"Column","Choose Y/N","----->"]
[]
[]
[null,"What you need to know about the calculations:"]
[null,"1)","In the table below, potential emissions are calculated based on your entries above. If you receive or ship grain multiple ways (truck, rail, ship, and/or barge), the highest emitting method is used to calculate your potential emissions. You can account for actual quantities received or shipped when you calculate actual emissions on the next tab."]
[]
[]
[null,"2)","The emissions from the headhouse and handling are calculated each time the grain is elevated. In potential emission calculations, as shown in the table below, it is assumed that the maximum capacity of grain is received, then elevated for storage, then elevated again for shipping. In addition, the grain is assumed to be elevated again after cleaning and after drying if those activities take place at the facility. Emissions from storage bin vents occur when grain is put into storage bins or silos after it is received, after cleaning, and after drying. This is the method of calculation specified by EPA in AP-42, section 9.9.1.3."]
[]
[]
[]
[null,"3)","Emission control capture efficiency cannot be used when calculating your potential emissions. Therefore, the control efficiency is set at zero, or no control. You can use control efficiencies on the actual emissions tab."]
[]
[]
[null,"Grain elevator potential emissions",null,null,null,null,null,null,"Source unless otherwise noted:  EPA AP-42 Chapter 9.9.1"]
[null,"a",null,"b","c","d","e","f","g","h","h","i"]
[null,null,null,"Maximum Capacity","PM Control Efficiency","PM Emission Factor","PM Emissions","PM10 Control Efficiency","PM10 Emission Factor","PM10 Emissions","PM2.5 Emission Factor","PM2.5 Emissions"]
[null,"Activity"]
[null,null,null,"(tons/year)","(% control)","(lb/ton)","(tons/year)","(% control)","(lb/ton)","(ton/year)","(lb/ton)","(ton/year)"]
[null,null,null,{"$f":"D19","v":0},null,null,"b*d/2000",null,null,"b*g/2000",null,"b*h*(1-f)/2000"]
[null,"Receiving","Truck straight",{"$f":"IF(E23=\"yes\",D53,0)","v":0},{"$f":"'Grain elevator actual'!E84","v":0},0.18,{"$f":"D54*F54/2000","v":0},0,5.8999999999999997E-2,{"$f":"D54*I54/2000","v":0},0.01,{"$f":"D54*K54/2000","v":0}]
[null,null,"Truck hopper",{"$f":"IF(D54=D53,0,IF(D59=D53,0,IF(D58=D53,0,IF(E24=\"yes\",D53,0))))","v":0},null,3.5000000000000003E-2,0,null,7.7999999999999996E-3,0,1.2999999999999999E-3,0]
[null,null,"Rail",{"$f":"IF(D54=D53,0,IF(D59=D53,0,IF(D58=D53,0,IF(D55=D53,0,IF(E25=\"yes\",D53,0)))))","v":0},null,3.2000000000000001E-2,0,null,7.7999999999999996E-3,0,1.2999999999999999E-3,0]
[null,null,"Barge unload cont.",{"$f":"IF(D54=D53,0,IF(D59=D53,0,IF(D58=D53,0,IF(D56=D53,0,IF(D55=D53,0,IF(G26=\"continuous unloader\",D53,0))))))","v":0},null,2.9000000000000001E-2,0,null,7.3000000000000001E-3,0,1.9E-3,0]
[null,null,"Barge marine leg",{"$f":"IF(D54=D53,0,IF(D59=D53,0,IF(G26=\"marine leg\",D53,0)))","v":0},null,0.15,0,null,3.7999999999999999E-2,0,5.0000000000000001E-3,0]
[null,null,"Ship",{"$f":"IF(D54=D53,0,IF(E27=\"yes\",D53,0))","v":0},null,0.15,0,null,3.7999999999999999E-2,0,5.0000000000000001E-3,0]
[null,"Loadout / Shipping","Truck unspecified",{"$f":"IF(J23=\"yes\",D53,0)","v":0},null,8.5999999999999993E-2,0,null,2.9000000000000001E-2,0,4.8999999999999998E-3,0]
[null,null,"Railcar",{"$f":"IF(D60=D53,0,IF(D63=D53,0,IF(J25=\"yes\",D53,0)))","v":0},null,2.7E-2,0,null,2.2000000000000001E-3,0,3.6999999999999999E-4,0]
[null,null,"Barge",{"$f":"IF(D60=D53,0,IF(D63=D53,0,IF(D61=D53,0,IF(J26=\"yes\",D53,0))))","v":0},null,1.6E-2,0,null,4.0000000000000001E-3,0,5.5000000000000003E-4,0]
[null,null,"Ship",{"$f":"IF(D60=D53,0,IF(J27=\"yes\",D53,0))","v":0},null,4.8000000000000001E-2,0,null,1.2E-2,0,2.2000000000000001E-3,0]
[null,"Headhouse & Handling2",null,{"$f":"IF($F$21=\"Choose Y/N\",0,IF($F$21=\"Yes\",((D53*2)+D65+D67+D68+D69),IF($F$21=\"No\",0)))","v":0},null,6.0999999999999999E-2,0,null,3.4000000000000002E-2,0,5.7999999999999996E-3,0]
[null,"Grain Cleaning3",null,{"$f":"IF(E29=\"yes\",IF((J29*8760)<D19,(J29*8760),D53),0)","v":0},null,{"$f":"0.075/2*10","v":0.375},0,null,{"$f":"0.019/2*10","v":9.5000000000000001E-2},0,{"$f":"0.0032/2*10","v":1.6E-2},0]
[null,"Storage Bin (vent)",null,{"$f":"D53+D65+D67+D68+D69","v":0},null,2.5000000000000001E-2,0,null,6.3E-3,0,1.1000000000000001E-3,0]
[null,"Grain Drying ","Rack",{"$f":"IF(G32=\"yes\",IF((I32*8760)<D53,(I32*8760),D53),0)","v":0},null,3,0,null,0.75,0,0.13,0]
[null,null,"Rack (<50 mesh)",{"$f":"IF(G33=\"no\",0,IF((I33*8760)<(D53-D67),(I33*8760),(D53-D67)))","v":0},null,0.47,0,null,0.12,0,0.02,0]
[null,null,"Column",{"$f":"IF(G34=\"no\",0,IF((I34*8760)<(D53-D67-D68),(I34*8760),(D53-D67-D68)))","v":0},null,0.22,0,null,5.5E-2,0,9.4000000000000004E-3,0]
[null,"Total tons of emissions (excluding dryer combustion)",null,null,null,null,{"$f":"SUM(G54:G69)","v":0},null,null,{"$f":"SUM(J54:J69)","v":0},null,{"$f":"SUM(L54:L69)","v":0}]
[null,"1 EPA memo defining country elevator and terminal elevator on EPA website at",null,null,null,null,"https://www.epa.gov/sites/production/files/2015-08/documents/grainfnl.pdf"]
[null,"2  Legs, conveyors, belts, distributor, scale, enclosed cleaners, etc."]
[null,"3 Internal vibrating; emission factor is an average of back-calculated values from AP-42 Table 9.9.1-1 (4/03), which provides a cyclone-controlled emission factor.  A cyclone was assumed to be 80% efficient; from Minn. R. 7011.0070."]

{"sheet":"Grain elevator actual","index":4,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,11],[13,1,13,7],[8,1,11,1],[8,2,11,11],[37,1,37,5],[37,6,37,11],[2,1,2,11],[3,2,3,11],[4,1,7,1],[4,2,7,11],[15,3,16,3],[15,4,16,4],[15,6,16,6],[15,9,16,9],[13,8,13,11],[40,6,40,11],[15,10,16,10],[15,11,16,11],[38,1,38,5],[38,6,38,11],[15,1,18,2],[42,1,43,10],[12,1,12,11],[41,1,41,11],[14,1,14,2],[30,1,30,2],[31,1,31,2],[19,1,24,1],[25,1,28,1],[29,1,29,2],[39,1,39,5],[39,6,39,11],[40,1,40,5],[32,1,34,1],[15,5,16,5],[15,7,16,7],[15,8,16,8]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Air emissions for grain elevators - Actual emissions"]
[null,"What you need to know about the calculations:"]
[null,"1)","In the table below, enter in the blue cells the actual quantities of grain received, loaded out, cleaned, and dried during the past 12 months."]
[null,"2)","The emissions from the headhouse and handling are calculated each time the grain is elevated. In potential emission calculations, as shown in the table below, it is assumed that the maximum capacity of grain is received, then elevated for storage, then elevated again for shipping. In addition, the grain is assumed to be elevated again after cleaning and after drying, if those activities take place at the facility. Emissions from storage bin vents occur when grain is put into storage bins or silos - after it is received, after cleaning, and after drying. This is the method of calculation prescribed by EPA in AP-42, section 9.9.1.3."]
[]
[]
[]
[null,"3)","Enter the appropriate particulate matter (PM) control efficiencies for PM and PM10. Control efficiency is the percent of pollutant captured by the control equipment, such as a cyclone or filters. You may assume 0% control efficiency. Otherwise, the percent control for the different types of control equipment is listed in Minn. R. 7011.0070 and is based on whether emissions are captured through a total enclosure, a certified hood, or an uncertified hood. See the requirements for certified hoods (Minn. R. 7011.0072) and for requirements for maintenance, monitoring, and recordkeeping for control equipment (Minn. R. 7011.0075 and 0080).1, 2, 3, 4"]
[]
[]
[]
[]
[null,"Grain elevator actual emissions",null,null,null,null,null,null,"Source unless otherwise noted:  EPA AP-42 Chapter 9.9.1"]
[null,"a",null,"b","c","d","e","f","g","h","h","i"]
[null,"Activity",null,"Actual Throughput","PM Control Efficiency1","PM Emission Factor","PM Emissions","PM10 Control Efficiency1","PM10 Emission Factor","PM10 Emissions","PM2.5 Emission Factor","PM2.5 Emissions"]
[]
[null,null,null,"(tons/year)","(% control)","(lb/ton)","(tons/year)","(% control)","(lb/ton)","(ton/year)","(lb/ton)","(ton/year)"]
[null,null,null,null,null,null,"b*d*(1-c)/2000",null,null,"b*g*(1-f)/2000",null,"b*h*(1-f)/2000"]
[null,"Receiving","Truck straight",null,0,0.18,{"$f":"D20*F20*(1-E20)/2000","v":0},0,5.8999999999999997E-2,{"$f":"D20*I20*(1-H20)/2000","v":0},0.01,{"$f":"D20*K20*(1-H20)/2000","v":0}]
[null,null,"Truck hopper",null,0,3.5000000000000003E-2,0,0,7.7999999999999996E-3,0,1.2999999999999999E-3,{"$f":"D21*K21*(1-H21)/2000","v":0}]
[null,null,"Rail",null,{"$f":"'Grain elevator actual'!E57","v":0},3.2000000000000001E-2,0,0,7.7999999999999996E-3,0,1.2999999999999999E-3,{"$f":"D22*K22*(1-H22)/2000","v":0}]
[null,null,"Barge unload cont.",null,{"$f":"'Grain elevator actual'!E58","v":0},2.9000000000000001E-2,0,0,7.3000000000000001E-3,0,1.9E-3,0]
[null,null,"Barge marine leg",null,{"$f":"'Grain elevator actual'!E59","v":0},0.15,0,0,3.7999999999999999E-2,0,5.0000000000000001E-3,0]
[null,null,"Ship",null,{"$f":"'Grain elevator actual'!E60","v":0},0.15,0,0,3.7999999999999999E-2,0,5.0000000000000001E-3,0]
[null,"Loadout / Shipping","Truck unspecified",null,{"$f":"'Grain elevator actual'!E61","v":0},8.5999999999999993E-2,0,0,2.9000000000000001E-2,0,4.8999999999999998E-3,0]
[null,null,"Railcar",null,{"$f":"'Grain elevator actual'!E62","v":0},2.7E-2,0,0,2.2000000000000001E-3,0,3.6999999999999999E-4,0]
[null,null,"Barge",null,{"$f":"'Grain elevator actual'!E63","v":0},1.6E-2,0,0,4.0000000000000001E-3,0,5.5000000000000003E-4,0]
[null,null,"Ship",null,{"$f":"'Grain elevator actual'!E64","v":0},4.8000000000000001E-2,0,0,1.2E-2,0,2.2000000000000001E-3,0]
[null,"Headhouse & Handling5",null,null,0,6.0999999999999999E-2,0,0,3.4000000000000002E-2,0,5.7999999999999996E-3,0]
[null,"Grain Cleaning6",null,null,{"$f":"'Grain elevator actual'!E66","v":0},{"$f":"0.075/2*10","v":0.375},0,0,{"$f":"0.019/2*10","v":9.5000000000000001E-2},0,{"$f":"0.0032/2*10","v":1.6E-2},0]
[null,"Storage Bin (vent)",null,{"$f":"D20+D21+D22+D23+D24+D25+D31+D33+D34+D35","v":0},{"$f":"'Grain elevator actual'!E67","v":0},2.5000000000000001E-2,{"$f":"D32*F32*(1-E32)/2000","v":0},0,6.3E-3,0,1.1000000000000001E-3,0]
[null,"Grain Drying ","Rack",null,{"$f":"'Grain elevator actual'!E68","v":0},3,{"$f":"D33*F33*(1-E33)/2000","v":0},0,0.75,0,0.13,0]
[null,null,"Rack (<50 mesh)",null,{"$f":"'Grain elevator actual'!E69","v":0},0.47,{"$f":"D34*F34*(1-E34)/2000","v":0},0,0.12,0,0.02,0]
[null,null,"Column",null,{"$f":"'Grain elevator actual'!E70","v":0},0.22,{"$f":"D35*F35*(1-E35)/2000","v":0},0,5.5E-2,0,9.4000000000000004E-3,0]
[null,"Total tons emissions (excluding combustion from dryers)",null,null,null,null,{"$f":"SUM(G20:G35)","v":0},null,null,{"$f":"SUM(J20:J35)","v":0},null,{"$f":"SUM(L20:L35)","v":0}]
[null,"Below information can be found on the Minnesota Revisors website:"]
[null,"1 Control efficiencies are listed in Minn. R. 7011.0070.",null,null,null,null,"https://www.revisor.mn.gov/rules/?id=7011.0070"]
[null,"2 Certified hood requirements are listed in Minn. R. 7011.0072",null,null,null,null,"https://www.revisor.mn.gov/rules?id=7011.0072"]
[null,"3 Requirements for control equipment are listed in Minn. R. 7011.0075",null,null,null,null,"https://www.revisor.mn.gov/rules?id=7011.0075"]
[null,"4 Monitoring and recordkeeping for controls is in Minn. R. 7011.0080",null,null,null,null,"https://www.revisor.mn.gov/rules?id=7011.0080"]
[null,"5  Legs, conveyors, belts, distributor, scale, enclosed cleaners, etc. Throughput is the sum of all shipping, receiving, cleaning, and drying throughputs."]
[null,"6 Internal Vibrating; Emission factor is an average of back-calculated values from AP-42 Table 9.9.1-1 (4/03), which provides a cyclone-controlled emission factor.  A cyclone was assumed to be 80% efficient; from Minn. R. 7011.0070."]

{"sheet":"Feed mill potential","index":5,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,1,1,11],[27,1,30,1],[27,2,30,11],[31,1,32,1],[15,1,15,3],[16,1,16,3],[4,1,4,11],[10,1,10,3],[11,1,11,2],[15,6,15,9],[16,6,16,9],[5,5,6,11],[5,2,5,3],[24,1,24,11],[25,1,26,1],[25,2,26,11],[59,1,59,11],[53,1,54,11],[55,1,56,11],[57,1,58,11],[60,1,61,11],[40,7,51,7],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,51,1],[40,1,40,2],[41,1,41,2],[42,1,44,1],[45,1,45,2],[40,4,51,4],[6,2,6,3],[33,1,33,11],[18,1,18,3],[19,1,19,2],[31,2,32,11],[7,1,7,11],[8,1,8,4],[3,6,3,11],[2,1,2,11],[36,8,37,8],[36,9,37,9],[36,10,37,10],[36,11,37,11],[22,1,23,11],[36,1,39,2],[35,1,35,2],[36,3,37,3],[36,4,37,4],[36,5,37,5],[36,6,37,6],[36,7,37,7],[34,1,34,7],[34,8,34,11]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Air emissions for feed mills - Potential emissions"]
[null,"Important: If you are applying for a state or federal individual air permit, do not use this tab for your application. Individual permit applications must calculate potential emissions for each "]
[null,"emission unit. Guidance is available at MPCA's air permit emission calculation page:",null,null,null,null,"https://www.pca.state.mn.us/business-with-us/grain-elevators-and-feed-mills-emission-calculations"]
[null,"Facility information for emission calculations"]
[null,"Facility name:",null,null,null,"For grain processing facilities, max. capacity is the maximum amount of grain you could possibly process in a year assuming an unlimited supply is available."]
[null,"Max. capacity:",null,null,"tons/year "]
[]
[null,"Do you have a traditional facility with a headhouse?",null,null,null,"Choose Y/N"]
[]
[null,"Do you have any milling equipment?",null,null,"Choose Y/N",null,"Total capacity (ton per hour)",null,"Total milling capacity"]
[null,"If yes, what type(s)?",null,"Hammermill","Choose Y/N","----->",null,null,{"$f":"G14+G13+G12","v":0},"ton per hour"]
[null,null,null,"Flaker","Choose Y/N","----->",null,null,{"$f":"I12*8760","v":0},"ton per year"]
[null,null,null,"Cracker","Choose Y/N","----->"]
[]
[null,"Do you do pellet cooling?",null,null,"Choose Y/N",null,"Do you clean the grain at some point?",null,null,null,"Choose Y/N"]
[null,"If yes, what is your pellet cooling capacity?",null,null,null,"(ton per hour)","If yes, what is the total grain cleaning capacity?",null,null,null,null,"ton per hour"]
[]
[null,"Do you have 1 or more grain dryers?",null,null,"Choose Y/N",null,"Total capacity (ton per hour)",null,"Drying Capacity"]
[null,"If yes, what type(s)?",null,"Rack dryer","Choose Y/N","----->",null,null,{"$f":"G22+G21+G20","v":0},"ton per hour"]
[null,null,null,"Rack dryer with self cleaning screen (<50 mesh)","Choose Y/N","----->",null,null,{"$f":"I20*8760","v":0},"ton per year"]
[null,null,null,"Column dryer","Choose Y/N","----->"]
[]
[]
[null,"What you need to know about the calculations:"]
[null,"1)","In the table below, potential emissions are calculated based on your entries above. You can account for actual quantities processed when you calculate actual emissions on the next tab."]
[]
[null,"2)","The emissions from the headhouse and handling are calculated each time the grain is elevated. In potential emission calculations, as shown in the table below, it is assumed that the maximum capacity of grain is received, then elevated for storage, then elevated again for shipping. In addition, the grain is assumed to be elevated again after cleaning and after drying, if those activities take place at the facility. Emissions from storage bin vents occur when grain is put into storage bins or silos after it is received, after cleaning, and after drying. This is the method of calculation prescribed by EPA in AP-42, section 9.9.1.3."]
[]
[]
[]
[null,"3)","Emissions control capture efficiency cannot be used to calculate your potential emissions. Therefore the control efficiency is set at zero, or no control. You can enter control efficiencies on the actual emissions tab."]
[]
[]
[null,"Feed mill potential emissions",null,null,null,null,null,null,"Source unless otherwise noted:  EPA AP-42 Chapter 9.9.1"]
[null,"a",null,"b","c","d","e","f","g","h","h","i"]
[null,"Activity",null,"Maximum Capacity","PM Control Efficiency","PM Emission Factor","PM Emissions","PM10 Control Efficiency","PM10 Emission Factor","PM10 Emissions","PM2.5 Emission Factor","PM2.5 Emissions"]
[]
[null,null,null,"(tons/year)","(% control)","(lb/ton)","(tons/year)","(% control)","(lb/ton)","(ton/year)","(lb/ton)","(ton/year)"]
[null,null,null,{"$f":"$C$7","v":0},null,null,"b*d/2000",null,null,"b*g/2000",null,"b*h/2000"]
[null,"Grain Receiving",null,{"$f":"$D$40","v":0},0,1.7000000000000001E-2,{"$f":"D41*F41/2000","v":0},0,2.5000000000000001E-3,{"$f":"D41*I41/2000","v":0},{"$f":"I41","v":2.5000000000000001E-3},{"$f":"D41*K41/2000","v":0}]
[null,"Grain Loadout ",null,{"$f":"$D$41","v":0},null,3.3E-3,{"$f":"D42*F42/2000","v":0},null,8.0000000000000004E-4,{"$f":"D42*I42/2000","v":0},8.0000000000000004E-4,{"$f":"D42*K42/2000","v":0}]
[null,"Milling","Hammermill1",{"$f":"IF(E12=\"yes\",IF(($G$12*8760)<$D$40,($G$12*8760),$D$40),0)","v":0},null,{"$f":"AVERAGE((0.067/2*10),(0.012*100))","v":0.76749999999999996},0,null,{"$f":"F43*0.5","v":0.38374999999999998},0,0.38374999999999998,0]
[null,null,"Flaker2",{"$f":"IF($E$13=\"yes\",IF(($G$13*8760)<$D$40,($G$13*8760),$D$40),0)","v":0},null,{"$f":"0.15/2*10","v":0.75},0,null,{"$f":"F44*0.5","v":0.375},0,0.375,0]
[null,null,"Cracker2",{"$f":"IF($E$14=\"yes\",IF(($G$14*8760)<$D$40,($G$14*8760),$D$40),0)","v":0},null,{"$f":"0.024/2*10","v":0.12},0,null,{"$f":"F45*0.5","v":0.06},0,0.06,0]
[null,"Pellet Cooler3",null,{"$f":"IF($E$16=\"yes\",IF(($E$17*8760)<$D$40,($E$17*8760),$D$40),0)","v":0},null,{"$f":"AVERAGE((0.36/2*10),(0.15*10))","v":1.65},0,null,{"$f":"F46*0.5","v":0.82499999999999996},0,0.82499999999999996,0]
[null,"Headhouse & Grain Handling4 ",null,{"$f":"IF($F$9=\"Choose Y/N\",0,IF($F$9=\"Yes\",($D$41+D$42+D$48+D$50+D$51+D$52+D$46+D$43),IF($F$9=\"No\",0)))","v":0},null,6.0999999999999999E-2,0,null,3.4000000000000002E-2,0,5.7999999999999996E-3,0]
[null,"Grain Cleaning (internal vibrating5)",null,{"$f":"IF($K$16=\"yes\",IF(($K$17*8760)<$D$40,($K$17*8760),$D$40),0)","v":0},null,0.375,0,null,9.5000000000000001E-2,0,{"$f":"0.0032/2*10","v":1.6E-2},0]
[null,"Storage Bin (vent)",null,{"$f":"D$41+D44+D45+D$48+D$50+D$51+D$52+D$43","v":0},null,2.5000000000000001E-2,0,null,6.3E-3,0,1.1000000000000001E-3,0]
[null,"Grain Drying ","Rack",{"$f":"IF(E$20=\"yes\",IF((G$20*8760)<D$40,(G$20*8760),D$40),0)","v":0},null,3,0,null,0.75,0,0.13,0]
[null,null,"Rack (<50mesh)",{"$f":"IF(E21=\"no\",0,IF((G21*8760)<(D40-D50),(G21*8760),(D40-D50)))","v":0},null,0.47,0,null,0.12,0,0.02,0]
[null,null,"Column",{"$f":"IF(E22=\"no\",0,IF((G22*8760)<(D40-D50-D51),(G22*8760),(D40-D50-D51)))","v":0},null,0.22,0,null,5.5E-2,0,9.4000000000000004E-3,0]
[null,"Total tons emissions (excluding combustion from dryers)",null,null,null,null,{"$f":"SUM(G41:G52)","v":0},null,null,{"$f":"SUM(J41:J52)","v":0},null,{"$f":"SUM(L41:L52)","v":0}]
[null,"1 Emission factor for hammermill is an average of back-calculated values from AP-42 Table 9.9.1-2, which provides a cyclone-controlled emission factor and a baghouse-controlled emission factor.  A cyclone was assumed to be 80% efficient, and a baghouse was assumed to be 99% efficient; from Minn. R. 7011.0070."]
[]
[null,"2 Emission factor is an average of back-calculated values from AP-42 Table 9.9.1-1, which provides a cyclone-controlled emission factor.  A cyclone was assumed to be 80% efficient; from Minn. R. 7011.0070."]
[]
[null,"3 Emission factor is an average of back-calculated values from AP-42 Table 9.9.1-2, which provides a cyclone-controlled emission factor and a high-efficiency cyclone-controlled emission factor.  A cyclone was assumed to be 80% efficient,  a high-efficiency cyclone was assumed to be 90% efficient; from Minn. R. 7011.0070."]
[]
[null,"4 Legs, conveyors, belts, distributor, scale, enclosed cleaners, etc."]
[null,"5 Internal Vibrating; Emission factor is an average of back-calculated values from AP-42 Table 9.9.1-1 (4/03), which provides a cyclone-controlled emission factor.  A cyclone was assumed to be 80% efficient; from Minn. R. 7011.0070."]

{"sheet":"Feed mill actual","index":6,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,45,11],[14,1,14,2],[28,1,30,1],[24,1,24,2],[20,1,20,2],[19,1,19,2],[21,1,23,1],[25,1,25,2],[26,1,26,2],[27,1,27,2],[43,1,43,11],[36,1,36,5],[36,6,36,11],[37,1,38,11],[39,1,40,11],[41,1,42,11],[33,1,33,5],[33,6,33,11],[35,1,35,5],[35,6,35,11],[34,1,34,5],[34,6,34,11],[1,1,1,11],[0,1,0,11],[12,1,12,11],[13,1,13,7],[13,8,13,11],[2,1,2,11],[3,2,3,11],[4,1,7,1],[4,2,7,11],[8,1,11,1],[8,2,11,11],[15,3,16,3],[15,1,18,2],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[15,10,16,10],[15,11,16,11]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Air emissions for feed mills - Actual emissions"]
[null,"What you need to know about the calculations:"]
[null,"1)","In the table below, enter in the blue cells the actual quantities of product received, loaded out, milled, cleaned, and dried during the past 12 months.  "]
[null,"2)","The emissions from the headhouse and handling are calculated each time the grain is elevated. In potential emission calculations, as shown in the table below, it is assumed that the maximum capacity of grain is received, then elevated for storage, then elevated again for shipping. In addition, the grain is assumed to be elevated again after cleaning and after drying, if those activities take place at the facility. Emissions from storage bin vents occur when grain is put into storage bins or silos after it is received, after cleaning, and after drying. This is the method of calculation specified by EPA in AP-42, section 9.9.1.3."]
[]
[]
[]
[null,"3)","Enter the appropriate particulate matter (PM) control efficiencies for PM and PM10. Control efficiency is the percent of pollutant captured by the control equipment, such as a cyclone or filters. You may assume 0% control. Otherwise, the percent control for the different types of control equipment is listed in Minn. R. 7011.0070 and is based on whether emissions are captured through a total enclosure, a certified hood, or an uncertified hood. See the requirements for certified hoods (Minn. R. 7011.0072) and for requirements for maintenance, monitoring, and recordkeeping for control equipment (Minn. R. 7011.0075 and 0080).1, 2, 3, 4"]
[]
[]
[]
[]
[null,"Feed mill actual emissions",null,null,null,null,null,null,"Source unless otherwise noted:  EPA AP-42 Chapter 9.9.1"]
[null,"a",null,"b","c","d","e","f","g","h","h","i"]
[null,"Activity",null,"Maximum Capacity","PM Control Efficiency1","PM Emission Factor","PM Emissions","PM10 Control Efficiency1","PM10 Emission Factor","PM10 Emissions","PM2.5 Emission Factor","PM2.5 Emissions"]
[]
[null,null,null,"(tons/year)","(% control)","(lb/ton)","(tons/year)","(% control)","(lb/ton)","(ton/year)","(lb/ton)","(ton/year)"]
[null,null,null,null,null,null,"b*d*(1-c)/2000",null,null,"b*g*(1-f)/2000",null,"b*h*(1-f)/2000"]
[null,"Grain Receiving",null,null,0,1.7000000000000001E-2,{"$f":"D20*F20*(1-E20)/2000","v":0},0,2.5000000000000001E-3,{"$f":"D20*I20*(1-H20)/2000","v":0},{"$f":"I20","v":2.5000000000000001E-3},{"$f":"D20*K20*(1-H20)/2000","v":0}]
[null,"Grain Loadout ",null,null,0,3.3E-3,0,0,8.0000000000000004E-4,0,8.0000000000000004E-4,{"$f":"D21*K21*(1-H21)/2000","v":0}]
[null,"Milling","Hammermill5",null,0,{"$f":"AVERAGE((0.067/2*10),(0.012*100))","v":0.76749999999999996},0,0,{"$f":"F22*0.5","v":0.38374999999999998},0,0.38374999999999998,0]
[null,null,"Flaker6",null,0,{"$f":"0.15/2*10","v":0.75},0,0,{"$f":"F23*0.5","v":0.375},0,0.375,0]
[null,null,"Cracker6",null,0,{"$f":"0.024/2*10","v":0.12},0,0,{"$f":"F24*0.5","v":0.06},0,0.06,0]
[null,"Pellet Cooler7",null,null,0,{"$f":"AVERAGE((0.36/2*10),(0.15*10))","v":1.65},0,0,{"$f":"F25*0.5","v":0.82499999999999996},0,0.82499999999999996,0]
[null,"Headhouse & Grain Handling8 ",null,null,0,6.0999999999999999E-2,0,0,3.4000000000000002E-2,0,5.7999999999999996E-3,0]
[null,"Grain Cleaning (internal vibrating9)",null,null,0,0.375,0,0,9.5000000000000001E-2,0,{"$f":"0.0032/2*10","v":1.6E-2},0]
[null,"Storage Bin (vent)",null,{"$f":"D20+D22+D23+D24+D27+D30+D29+D31","v":0},0,2.5000000000000001E-2,{"$f":"D28*F28*(1-E28)/2000","v":0},0,6.3E-3,{"$f":"D28*I28*(1-H28)/2000","v":0},1.1000000000000001E-3,0]
[null,"Grain Drying ","Rack",null,0,3,0,0,0.75,0,0.13,0]
[null,null,"Rack (<50mesh)",null,0,0.47,0,0,0.12,0,0.02,0]
[null,null,"Column",null,0,0.22,0,0,5.5E-2,0,9.4000000000000004E-3,{"$f":"D31*K31*(1-H31)/2000","v":0}]
[null,"Total Emissions (excluding combustion from dryers, if applicable)",null,null,null,null,{"$f":"SUM(G20:G31)","v":0},null,null,{"$f":"SUM(J20:J31)","v":0},null,{"$f":"SUM(L20:L31)","v":0}]
[null,"Below information can be found on the Minnesota Revisors website:"]
[null,"1  Control efficiencies are listed in Minn. R. 7011.0070.",null,null,null,null,"https://www.revisor.mn.gov/rules/?id=7011.0070"]
[null,"2 Certified hood requirements are listed in Minn. R. 7011.0072",null,null,null,null,"https://www.revisor.mn.gov/rules?id=7011.0072"]
[null,"3 Requirements for control equipment are listed in Minn. R. 7011.0075",null,null,null,null,"https://www.revisor.mn.gov/rules?id=7011.0075"]
[null,"4 Monitoring and recordkeeping for controls is in Minn. R. 7011.0080",null,null,null,null,"https://www.revisor.mn.gov/rules?id=7011.0080"]
[null,"5 Emission factor for hammermill is an average of back-calculated values from AP-42 Table 9.9.1-2, which provides a cyclone-controlled emission factor and a baghouse-controlled emission factor.  A cyclone was assumed to be 80% efficient, and a baghouse was assumed to be 99% efficient; from Minn. R. 7011.0070."]
[]
[null,"6 Emission factor is an average of back-calculated values from AP-42 Table 9.9.1-1, which provides a cyclone-controlled emission factor.  A cyclone was assumed to be 80% efficient; from Minn. R. 7011.0070."]
[]
[null,"7 Emission factor is an average of back-calculated values from AP-42 Table 9.9.1-2, which provides a cyclone-controlled emission factor and a high-efficiency cyclone-controlled emission factor.  A cyclone was assumed to be 80% efficient,  a high-efficiency cyclone was assumed to be 90% efficient; from Minn. R. 7011.0070."]
[]
[null,"8 Legs, conveyors, belts, distributor, scale, enclosed cleaners, etc."]
[null,"9 Internal Vibrating; Emission factor is an average of back-calculated values from AP-42 Table 9.9.1-1 (4/03), which provides a cyclone-controlled emission factor.  A cyclone was assumed to be 80% efficient; from Minn. R. 7011.0070."]

{"sheet":"Natural gas dryer","index":7,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[8,12,10,13],[8,14,10,15],[8,16,10,17],[46,1,46,8],[47,1,47,8],[14,10,15,10],[25,1,25,5],[30,1,30,5],[11,3,12,3],[11,4,12,4],[11,5,12,5],[6,1,6,5],[7,1,7,3],[7,4,7,5],[7,7,7,8],[1,12,1,17],[2,12,3,13],[2,14,3,15],[2,16,3,17],[4,12,5,13],[4,14,5,15],[4,16,5,17],[6,12,7,13],[6,14,7,15],[6,16,7,17],[48,1,48,5],[48,6,48,7],[0,1,0,10],[1,1,1,8],[9,1,9,8],[7,10,7,11],[2,1,3,8],[4,1,4,8],[5,1,5,8],[11,6,12,6],[11,7,12,7],[11,8,12,8],[11,10,12,10],[16,1,16,5],[11,1,12,1],[11,2,12,2]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Air emissions from natural gas grain dryers",null,null,null,null,null,null,null,null,null,null,"Tip: How to use this calculator"]
[null,"Natural gas combustion (less than 100 million Btu per hour)",null,null,null,null,null,null,null,null,null,null,"If you have…",null,"For potential emissions",null,"For actual emissions"]
[]
[null,"If you have a boiler with a rating of more than 100 million Btu per hour, different emission factors must be used (see EPA AP-42 Chapter 1.4).",null,null,null,null,null,null,null,null,null,null,"One process/heating unit",null,"Enter maximum rated heat input",null,"Enter amount of fuel burned or actual operation hours"]
[]
[null,"What is the total maximum rated heat input for your natural gas units?",null,null,null,null,0,"Btu per hour","(Check your units!)",null,null,null,"More than one process/heating unit",null,"Enter the total maximum rated heat input of all units, combined",null,"Enter amount of fuel burned. Do not use operation hours."]
[null,"In the previous 12 months, how many",null,null,"Choose one",null,0,{"$f":"IF(E8='Data validation'!A31,\" \",IF(E8='Data validation'!A32,\"hours/year\",IF(E8='Data validation'!A33,\"cu ft/year\")))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"A unit that can burn more than one fuel type",null,"Calculate for both fuel types. The highest ton/yr per pollutant is to be used for potential emissions",null,"Enter amount of each type of fuel burned."]
[null,"Natural gas potential and actual emissions"]
[null,null,"a","b","c","d","e"]
[null,"Pollutant","GWP1","Dryer hourly natural gas usage2","Actual natural gas burned","Hours in a Year","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity4 Limits"]
[]
[null,null,null,"(cu ft/hr)","(cu ft/yr)","(hr/yr)","(lbs/cu ft)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,"(Btu/hr) / (1020 Btu/cu ft)",null,"24 hrs/day * 365 days/yr",null,"(b * d * e) / 2000","( c * e ) / 2000"]
[null,null,null,{"$f":"G7/1020","v":0},{"$f":"IF(E8='Data validation'!A31,0,IF(E8='Data validation'!A32,((G8/1026)*G7),IF(E8='Data validation'!A33,G8)))","v":0},8760,"by pollutant"]
[null,"Criteria air pollutants",null,null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.4",{"$f":"SUM(J18:J30)","v":7}]
[null,"PM",null,null,null,null,7.6000000000000001E-6,{"$f":"$D$16*$F$16*$G18/2000","v":0},{"$f":"($E$16*$G18)/2000","v":0},{"$f":"IF(K18>H18,1,0)","v":1},1]
[null,"PM10",null,null,null,null,7.6000000000000001E-6,0,{"$f":"($E$16*$G19)/2000","v":0},{"$f":"IF(K19>H19,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,7.6000000000000001E-6,0,0]
[null,"SOx",null,null,null,null,5.9999999999999997E-7,0,0,1,1]
[null,"NOx",null,null,null,null,1E-4,0,0,1,1]
[null,"VOC",null,null,null,null,5.4999999999999999E-6,0,0,1,1]
[null,"CO",null,null,null,null,8.3999999999999995E-5,0,0,1,2]
[null,"Lead",null,null,null,null,5.0000000000000003E-10,0,0,0]
[null,"Greenhouse gas emissions",null,null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2",0]
[null,"CO2 2",1,null,null,null,{"$f":"53.06/1000000*1026/0.453592","v":0.12001878340005998},{"$f":"$D$16*$F$16*$G27/2000","v":0},{"$f":"($E$16*$G27)/2000","v":0},0]
[null,"CH4 2",25,null,null,null,{"$f":"(10^-3)/(10^6)*1026/0.453592","v":2.2619446551085559E-6},{"$f":"$D$16*$F$16*$G28/2000","v":0},{"$f":"($E$16*$G28)/2000","v":0},0]
[null,"N2O 2",298,null,null,null,{"$f":"(10^-4)/(10^6)*1026/0.453592","v":2.2619446551085559E-7},{"$f":"$D$16*$F$16*$G29/2000","v":0},{"$f":"($E$16*$G29)/2000","v":0},0]
[null,null,null,null,null,"GHG Total (CO2e) 3",null,{"$f":"(C27*H27)+(C28*H28)+(C29*H29)","v":0},{"$f":"(C27*I27)+(C28*I28)+(C29*I29)","v":0},1,1000]
[null,"Hazardous air pollutants",null,null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.4"]
[null,"Benzene",null,null,null,null,{"$f":"0.0021/10^6","v":2.0999999999999998E-9},{"$f":"$D$16*$F$16*$G32/2000","v":0},{"$f":"($E$16*$G32)/2000","v":0}]
[null,"Formaldehyde",null,null,null,null,{"$f":"0.075/10^6","v":7.4999999999999997E-8},0,0]
[null,"Hexane",null,null,null,null,{"$f":"1.8/1000000","v":1.8000000000000001E-6},0,0]
[null,"Naphthalene",null,null,null,null,6.0999999999999996E-10,0,0]
[null,"Toluene",null,null,null,null,3.3999999999999998E-9,0,0]
[null,"Arsenic",null,null,null,null,2.0000000000000001E-10,0,0]
[null,"Beryllium",null,null,null,null,1.2000000000000001E-11,0,0]
[null,"Cadmium",null,null,null,null,1.0999999999999999E-9,0,0]
[null,"Chromium",null,null,null,null,1.3999999999999999E-9,0,0]
[null,"Cobalt",null,null,null,null,8.3999999999999994E-11,0,0]
[null,"Manganese",null,null,null,null,3.7999999999999998E-10,0,0]
[null,"Mercury",null,null,null,null,2.5999999999999998E-10,0,0]
[null,"Nickel",null,null,null,null,2.1000000000000002E-9,0,0]
[null,"Selenium",null,null,null,null,2.4000000000000001E-11,0,0]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H32:H45)","v":0},{"$f":"SUM(I32:I45)","v":0}]
[null,"1 Global Warming Potential from 40 CFR Part 98, Subpart A, Table A-1"]
[null,"2 CO2e = carbon dioxide equivalents"]
[null,"3 See insignificant activities at Minn. R. 7007.1300 and on the 'Permits & Requirements' tab.",null,null,null,null,"Minn. R. 7007.1300"]

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

{"sheet":"Fugitive","index":9,"n_rows":88,"n_cols":19,"rows_kept":88,"cut":false,"hidden":false,"merged":[[14,2,15,3],[12,4,15,7],[10,1,10,8],[29,1,29,2],[84,3,84,4],[84,5,84,8],[83,1,89,2],[82,6,82,8],[83,3,83,4],[80,5,80,8],[81,5,81,8],[83,5,83,6],[80,1,80,4],[78,2,78,3],[78,6,78,7],[81,1,81,4],[51,1,51,2],[36,1,36,2],[36,6,36,7],[48,1,48,2],[32,1,32,2],[23,1,23,2],[33,5,33,8],[34,1,34,2],[46,1,46,8],[56,2,57,3],[56,4,57,5],[35,1,35,2],[35,4,35,7],[50,1,50,2],[52,1,52,2],[40,1,41,2],[42,1,43,2],[39,1,39,8],[48,6,48,8],[49,5,49,7],[50,6,50,7],[47,1,47,7],[56,1,60,1],[59,2,60,2],[59,3,60,3],[59,4,60,4],[59,5,60,5],[59,6,60,6],[59,7,60,7],[55,1,55,8],[0,1,0,8],[2,1,2,8],[16,1,17,8],[26,1,26,2],[27,1,27,2],[28,1,28,2],[1,1,1,8],[3,1,3,8],[4,1,5,8],[9,1,9,8],[18,1,18,8],[19,1,19,8],[6,4,7,8],[11,2,11,3],[8,1,8,8],[26,6,26,7],[27,6,27,7],[28,6,28,7],[12,1,13,1],[14,1,15,1],[6,2,6,3],[21,1,21,2],[22,1,22,2],[12,2,13,3],[69,4,70,4],[69,5,70,5],[69,6,70,6],[69,7,70,7],[66,2,67,3],[66,4,67,5],[66,6,67,7],[69,2,70,2],[69,3,70,3],[86,5,86,8],[86,3,86,4],[20,1,20,4],[79,1,79,3],[58,2,58,3],[58,4,58,5],[58,6,58,7],[66,1,70,1],[31,1,31,2],[41,8,42,8],[41,5,42,5],[37,1,38,8],[30,1,30,2],[33,1,33,2],[49,1,49,2],[41,6,42,6],[41,7,42,7],[34,4,34,7],[58,8,60,8],[56,6,57,7],[68,2,68,3],[68,4,68,5],[68,6,68,7],[68,8,70,8]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[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,"<-------- Enter the throughput used in the 'grain elevator potential' tab here. "]
[null,null,{"$f":"'Grain elevator potential'!$D$19+'Feed mill potential'!$C$7","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,"Unpaved road2"]
[null,"Enter the data for you’re the method of receiving and shipping below to calculate unpaved road emissions.",null,null,null,null,null,null,null,null,"Table A. Typical silt content values of surface material on industrial unpaved roads"]
[null,"Actual grain shipped and received",null,null,null,null,null,null,null,null,"AP-42 Table 13.2.2-1"]
[null,"Total amount of grain",null,null,"tons/year",null,null,null,null,null,"Industry","Road use","Mean Silt Content (%)"]
[null," by Trucks",null,0,"% ",null,null,null,null,null,"Copper smelting","Plant road",17]
[null," by Rail and Barge",null,0,"% ",null,null,null,null,null,"Iron and steel production","Plant road",6]
[null,null,null,null,null,null,null,null,null,null,"Sand and gravel processing","Plant road",4.8]
[null,null,null,"Truck 1","Truck 2",null,null,null,null,null,null,"Material storage area",7.1]
[null,"% of total trips made by truck",null,0,0,null,"W = mean vehicle weight (ton)",null,{"$f":"D27*((D28+D29)/2)+E27*((E28+E29)/2)","v":0},null,"Stone quarrying and processing","Plant road",10]
[null,"Empty weight of vehicle (tons)",null,null,null,null,"Vpotential = # vehicle trips / yr",null,{"$f":"IFERROR(IF((C8/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28))))=0,0,IF((C8/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28))))>0,(C8/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28)))))),0)","v":0},null,null,"Haul road to/from pit",8.3000000000000007]
[null,"Full weight of loaded vehicle (tons)",null,null,null,null,"Vactual = # vehicle trips / yr",null,{"$f":"IFERROR(IF(((D22*D23)/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28))))=0,0,IF(((D22*D23)/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28))))>0,((D22*D23)/((Fugitive!D27*(Fugitive!D29-Fugitive!D28))+(Fugitive!E27*(Fugitive!E29-Fugitive!E28)))))),0)","v":0},null,"Taconite mining and processing","Plant road",4.3]
[null,"S = speed on unpaved road, mph",null,null,null,null,null,null,null,null,null,"Haul road to/from pit",5.8]
[null,"m = miles of unpaved road per trip",null,null,null,null,null,"Potential Vehicle Miles Traveled (VMT)/yr = Vpotential x miles",{"$f":"IF((I28*D31)>0,(I28*D31),0)","v":0},null,"Western surface coal mining","Plant road",5.0999999999999996]
[null,"M = surface moisture content (%)",null,0.5,"Enter site data8,9",null,null,"Actual Vehicle Miles Traveled (VMT)/yr = Vactual x miles",{"$f":"IF((I29*D31)>0,(I29*D31),0)","v":0},null,null,"Haul road to/from pit",8.4]
[null,"s = silt content of road (%)",null,"Enter from Table","See Table A",null,null,null,null,null,null,"Scraper route",17]
[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,null,null,null,null,"Haul road (freshly graded)",24]
[null,"k = PM particle size multiplier ",null,6,"PM emission factor (lb/VMT)",null,null,null,{"$f":"IFERROR(((D35*((D33/12)^1)*((D30/30)^0.3)/((D32/0.5)^0.3))-0.00047)*((365-D34)/365),0)","v":0},null,"Construction sites","Scraper routes",8.5]
[null,"k10 = PM10 particle size multiplier ",null,1.8,"PM10 emission factor (lb/VMT)",null,null,null,{"$f":"IFERROR(((D36*((D33/12)^1)*((D30/30)^0.5)/((D32/0.5)^0.2))-0.00047)*((365-D34)/365),0)","v":0},null,"Lumber sawmills","Log yards",8.4]
[null,"k2.5 = PM2.5 particle size multiplier ",null,0.18,null,null,"PM2.5 emission factor (lb/VMT)",null,{"$f":"IFERROR(((D37*((D33/12)^1)*((D30/30)^0.5)/((D32/0.5)^0.2))-0.00036)*((365-D34)/365),0)","v":0},null,"Municipal solid waste landfills","Disposal routes",6.4]
[]
[]
[null,"Outside storage piles"]
[null,"Maximum amount of grain stored in outside piles",null,null,"tons/year","Material handling (of outside piles)5",null,null,null,null,"Table B. Typical silt and moisture contents of materials at various industries ",null,null,null,"Table C. Wind erosion of ground pile"]
[null,null,null,null,null,"Individual Emission Factors","Truck to Conveyor (lb/ton)","Conveyor to Pile (lb/ton)","Loading to Truck (lb/ton)",null,"AP-42 Table 13.2.4-1",null,null,null,"Values are over a 5-year period"]
[null,"Actual amount of grain stored in outside piles (last 12 months)",null,null,"tons/year",null,null,null,null,null,"Industry","Material","Silt Content (%)",null,"Station","City","County","State","Percent of Hours Greater Than 12 mph"]
[null,null,null,null,null,"PM",3.5000000000000003E-2,6.0999999999999999E-2,8.5999999999999993E-2,null,"Iron and steel production ","Pellet ore ",4.3,null,"KRST","Rochester","Olmsted","MN",40.9]
[null,null,null,null,null,"PM10",7.7999999999999996E-3,3.4000000000000002E-2,2.9000000000000001E-2,null,null,"Lump ore ",9.5,null,"KMML","Marshall","Lyon","MN",39.200000000000003]
[null,null,null,null,null,"PM2.5",{"$f":"0.0013","v":1.2999999999999999E-3},5.7999999999999996E-3,4.8999999999999998E-3,null,null,"Coal ",4.5999999999999996,null,"KAXN","Alexandria","Douglas","MN",35.200000000000003]
[null,null,null,null,null,null,null,null,null,null,null,"Slag ",5.3,null,"KDLH","Duluth Intl","Saint Louis","MN",33.5]
[null,"Wind erosion of ground pile6",null,null,null,null,null,null,null,null,null,"Flue dust ",13,null,"KMKT","Mankato","Blue Earth","MN",31.2]
[null,"d = # days pile is active per year",null,null,null,null,"Wind erosion emission factor reference7, 8",null,null,null,null,"Coke breeze ",4.9000000000000004,null,"KHCO","Hallock","Kittson","MN",31.2]
[null,"a = acres of pile base",null,null,null,"PM emission factor (lb/day*acre)",null,null,{"$f":"IFERROR((1.7*(D51/1.5)*((365-D53)/235)*(D52/15)),0)","v":0},null,null,"Blended ore ",15,null,"KRWF","Redwood Falls","Redwood","MN",30.5]
[null,"s = silt content of material (%) 4",null,"Enter from Table","See Table B",null,"PM10 emission factor  = PM * 50%",null,{"$f":"I50*0.5","v":0},null,null,"Sinter ",0.7,null,"KMSP","Minneapolis","Hennepin","MN",28.2]
[null,"f = % wind > 12 mph at pile height",null,"Enter from Table","See Table C or enter 43.1",null,null,"PM2.5 emission factor  = PM * 7.5%",{"$f":"I50*0.075","v":0},null,null,"Limestone ",1,null,"KPKD","Park Rapids","Hubbard","MN",27.2]
[null,"p = # of days w/ >=0.01\" precip/yr",null,{"$f":"(133+121+115+109+108)/5","v":117.2},"4",null,null,null,null,null,"Stone quarrying and processing","Crushed limestone",1.6,null,"KSTP","St Paul","Ramsey","MN",24.9]
[null,null,null,null,null,null,null,null,null,null,null,"Various limestone products",3.9,null,"KBDE","Baudette","Lake of the Woods","MN",24.8]
[null,null,null,null,null,null,null,null,null,null,"Taconite mining and processing","Pellets ",3.4,null,"KFCM","Eden Prarie","Hennepin","MN",23]
[null,"Fugitive emission totals",null,null,null,null,null,null,null,null,null,"Tailings ",11,null,"KSTC","St Cloud","Sherburne","MN",22.7]
[null,"Potential fugitive emissions","Unpaved road\n(VMT/yr)",null,"Material Handling\n(ton/yr)",null,"Ground pile\n(365 days * acre) / yr",null,null,null,"Western surface coal mining","Coal ",6.2,null,"KMIC","Crystal","Hennepin","MN",21.7]
[null,null,null,null,null,null,null,null,null,null,null,"Overburden ",7.5,null,"KBRD","Brainerd","Crow Wing","MN",20.9]
[null,null,{"$f":"I31","v":0},null,{"$f":"D41","v":0},null,{"$f":"D50*365","v":0},null,"Total Potential Emissions (ton/year)",null,null,"Exposed ground ",15,null,"KHIB","Hibbing","Saint Louis","MN",15.8]
[null,null,"Emission factor (lb/VMT)","Potential emissions (ton/yr)","Emission factor (lb/ton)","Potential emissions (ton/yr)","Emission factor (lb/d*acre)","Potential emissions (ton/yr)",null,null,"Coal-fired power plant","Coal ( as received) ",2.2000000000000002,null,"KINL","International Falls","Koochiching","MN",13.5]
[null,null,null,null,null,null,null,null,null,null,"Municipal solid waste landfills","Sand ",2.6,null,"KEST","Estherville","Emmet","IA",43.1]
[null,"PM",{"$f":"I35","v":0},{"$f":"C59*C62/2000","v":0},{"$f":"G44+H44+I44","v":0.182},{"$f":"E59*E62/2000","v":0},{"$f":"I50","v":0},{"$f":"G59*G62/2000","v":0},{"$f":"D62+F62+H62","v":0},null,null,"Slag ",3.8,null,"KMCW","Mason City","Cerro Gordo","IA",40.5]
[null,"PM10",{"$f":"I36","v":0},{"$f":"C59*C63/2000","v":0},{"$f":"G45+H45+I45","v":7.0800000000000002E-2},{"$f":"E59*E63/2000","v":0},{"$f":"I51","v":0},{"$f":"G59*G63/2000","v":0},{"$f":"D63+F63+H63","v":0},null,null,"Cover ",9,null,"KFAR","Fargo","Cass","ND",40.299999999999997]
[null,"PM2.5",{"$f":"I37","v":0},{"$f":"C59*C64/2000","v":0},{"$f":"G46+H46+I46","v":1.2E-2},{"$f":"E59*E64/2000","v":0},{"$f":"I52","v":0},{"$f":"G59*G64/2000","v":0},{"$f":"D64+F64+H64","v":0},null,null,"Clay/dirt mix",9.1999999999999993,null,"KGFK","Grand Forks","Grand Forks","ND",38.1]
[null,null,null,null,null,null,null,null,null,null,null,"Clay",6,null,"KFSD","Sioux Falls","Minnehaha","SD",35.200000000000003]
[null,null,null,null,null,null,null,null,null,null,null,"Fly ash ",80,null,"KLSE","La Crosse","La Crosse","WI",22]
[null,"Actual fugitive emissions","Unpaved road\n(VMT/yr)",null,"Material Handling\n(ton/yr)",null,"Ground pile\n(days * acre) / yr",null,null,null,null,"Misc. fill materials",12]
[]
[null,null,{"$f":"I32","v":0},null,{"$f":"D43","v":0},null,{"$f":"D49*D50","v":0},null,"Total Actual Emissions (ton/year)"]
[null,null,"Emission factor (lb/VMT)","Actual emissions (ton/yr)","Emission factor (lb/ton)","Actual emissions (ton/yr)","Emission factor (lb/d*acre)","Actual emissions (ton/yr)"]
[]
[null,"PM",{"$f":"I35","v":0},{"$f":"C69*C72/2000","v":0},{"$f":"E62","v":0.182},{"$f":"E69*E72/2000","v":0},{"$f":"G62","v":0},{"$f":"G69*G72/2000","v":0},{"$f":"D72+F72+H72","v":0}]
[null,"PM10",{"$f":"I36","v":0},{"$f":"C69*C73/2000","v":0},{"$f":"E63","v":7.0800000000000002E-2},{"$f":"E69*E73/2000","v":0},{"$f":"G63","v":0},{"$f":"G69*G73/2000","v":0},{"$f":"D73+F73+H73","v":0}]
[null,"PM2.5",0,{"$f":"C69*C74/2000","v":0},{"$f":"E64","v":1.2E-2},{"$f":"E69*E74/2000","v":0},{"$f":"G64","v":0},{"$f":"G69*G74/2000","v":0},{"$f":"D74+F74+H74","v":0}]
[]
[]
[]
[null,"References"]
[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 particule 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,null,null,null,"https://www.ncdc.noaa.gov/ghcn/comparative-climatic-data"]
[null,null,null,"5 Material handling reference",null,"Source: Based on AP-42 9.9 (03/2003)"]
[null,null,null,"6 Wind erosion from continuously active piles",null,"EPA Control of open fugitive dust sources, Sept. 1988, Equation 4-9"]
[null,null,null,"7 Wind erosion emission factor equation (lb/day/acre)=1.7(s/1.5)((365-p)/235)(f/15)"]
[null,null,null,"8 PM10 and PM2.5 fractions, updated Nov 2006",null,"AP-42 13.2.5 Aerodynamic particle size multipliers for Equation 2"]
[null,null,null,"9 Default moisture content value of 0.5 percent in Equation 1b is discouraged and reduces emission factor quality by 2 letters."]

{"sheet":"Potential emissions","index":10,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,8],[0,1,0,8],[1,1,1,8],[31,11,32,11],[22,11,30,11],[3,1,5,1],[2,10,2,11],[20,1,20,8],[15,1,15,8],[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,8,4,8],[6,1,6,3],[3,10,4,10],[3,11,4,11]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Potential emissions: Grain elevators and feed mills"]
[null,{"$f":"IF('Data validation'!B20=\"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 in the blue tabs.\")","v":"These pollutant totals represent the information you entered in the blue tabs."},null,null,null,null,null,null,null,null,"Without Insignificant Activities"]
[null,"Pollutant","Grain Elevator","Feed Mill","Natural Gas","Propane","Fugitive","Potential Emissions","Permitting Threshold",null,"Potential Emissions","Insignificant Activity Limits"]
[]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)",null,"(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants",null,null,{"$f":"IF('Natural gas dryer'!J17=7,\"Insignificant Activity\",\" \")","v":"Insignificant Activity"},{"$f":"IF('Propane dryer'!J20=7,\"Insignificant Activity\",\" \")","v":"Insignificant Activity"}]
[null,"PM",{"$f":"'Grain elevator potential'!G70","v":0},{"$f":"'Feed mill potential'!G53","v":0},{"$f":"'Natural gas dryer'!H18","v":0},{"$f":"'Propane dryer'!H19","v":0},{"$f":"Fugitive!I62","v":0},{"$f":"SUM(C8:G8)","v":0},100,null,{"$f":"H8+IF($E$7=\"Insignificant Activity\",-E8,0)+IF($F$7=\"Insignificant Activity\",-F8,0)","v":0},1]
[null,"PM10",{"$f":"'Grain elevator potential'!J70","v":0},{"$f":"'Feed mill potential'!J53","v":0},{"$f":"'Natural gas dryer'!H19","v":0},{"$f":"'Propane dryer'!H20","v":0},{"$f":"Fugitive!I63","v":0},{"$f":"SUM(C9:G9)","v":0},25,null,{"$f":"H9+IF($E$7=\"Insignificant Activity\",-E9,0)+IF($F$7=\"Insignificant Activity\",-F9,0)","v":0},1]
[null,"PM2.5",{"$f":"'Grain elevator potential'!L70","v":0},{"$f":"'Feed mill potential'!L53","v":0},{"$f":"'Natural gas dryer'!H20","v":0},{"$f":"'Propane dryer'!H21","v":0},{"$f":"Fugitive!I64","v":0},{"$f":"SUM(C10:G10)","v":0},100,{"$f":"J11+J12","v":2},0,1]
[null,"SOx",null,null,{"$f":"'Natural gas dryer'!H21","v":0},{"$f":"'Propane dryer'!H22","v":0},null,0,50,{"$f":"IF(E12>1,1,0)+IF(F12>1,1,0)","v":0},0,1]
[null,"NOx",null,null,{"$f":"'Natural gas dryer'!H22","v":0},{"$f":"'Propane dryer'!H23","v":0},null,0,100,{"$f":"IF(E12=0,1,0)+IF(F12=0,1,0)","v":2},0,1]
[null,"VOC",null,null,{"$f":"'Natural gas dryer'!H23","v":0},{"$f":"'Propane dryer'!H24","v":0},null,0,100,null,0,1]
[null,"CO",null,null,{"$f":"'Natural gas dryer'!H24","v":0},{"$f":"'Propane dryer'!H25","v":0},null,0,100,null,0,2]
[null,"Lead",null,null,{"$f":"'Natural gas dryer'!H25","v":0},{"$f":"'Propane dryer'!H26","v":0},null,0,0.5,null,0]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",null,null,{"$f":"'Natural gas dryer'!H27","v":0},{"$f":"'Propane dryer'!H28","v":0},null,0,null,null,0]
[null,"CH4",null,null,{"$f":"'Natural gas dryer'!H28","v":0},{"$f":"'Propane dryer'!H29","v":0},null,0,null,null,0]
[null,"N2O",null,null,{"$f":"'Natural gas dryer'!H29","v":0},{"$f":"'Propane dryer'!H30","v":0},null,0,null,null,0]
[null,"GHG Total CO2e",null,null,{"$f":"'Natural gas dryer'!H30","v":0},{"$f":"'Propane dryer'!H31","v":0},null,{"$f":"(H17*1)+(H18*25)*(H19*298)","v":0},100000,null,{"$f":"SUM(K17:K19)","v":0},1000]
[null,"Hazardous Air Pollutants"]
[null,"Benzene",null,null,{"$f":"'Natural gas dryer'!H32","v":0},{"$f":"'Propane dryer'!H33","v":0},null,0,null,null,{"$f":"H22+IF($E$7=\"Insignificant Activity\",-E22,0)+IF($F$7=\"Insignificant Activity\",-F22,0)","v":0}]
[null,"Formaldehyde",null,null,{"$f":"'Natural gas dryer'!H33","v":0},{"$f":"'Propane dryer'!H34","v":0},null,0,null,null,0]
[null,"Hexane",null,null,{"$f":"'Natural gas dryer'!H34","v":0},{"$f":"'Propane dryer'!H35","v":0},null,0,null,null,0]
[null,"Naphthalene",null,null,{"$f":"'Natural gas dryer'!H35","v":0},{"$f":"'Propane dryer'!H36","v":0},null,{"$f":"SUM(C25:G25)","v":0},null,null,0]
[null,"Toluene",null,null,{"$f":"'Natural gas dryer'!H36","v":0},{"$f":"'Propane dryer'!H37","v":0},null,0,null,null,0]
[null,"Arsenic",null,null,{"$f":"'Natural gas dryer'!H37","v":0},{"$f":"'Propane dryer'!H38","v":0},null,0,null,null,0]
[null,"Beryllium",null,null,{"$f":"'Natural gas dryer'!H38","v":0},{"$f":"'Propane dryer'!H39","v":0},null,0,null,null,0]
[null,"Cadmium",null,null,{"$f":"'Natural gas dryer'!H39","v":0},{"$f":"'Propane dryer'!H40","v":0},null,0,null,null,0]
[null,"Chromium",null,null,{"$f":"'Natural gas dryer'!H40","v":0},{"$f":"'Propane dryer'!H41","v":0},null,0,null,null,0]
[null,"Cobalt",null,null,{"$f":"'Natural gas dryer'!H41","v":0},{"$f":"'Propane dryer'!H42","v":0},null,0,null,null,0]
[null,"Manganese",null,null,{"$f":"'Natural gas dryer'!H42","v":0},{"$f":"'Propane dryer'!H43","v":0},null,0,null,null,0]
[null,"Mercury",null,null,{"$f":"'Natural gas dryer'!H43","v":0},{"$f":"'Propane dryer'!H44","v":0},null,0,null,null,0]
[null,"Nickel",null,null,{"$f":"'Natural gas dryer'!H44","v":0},{"$f":"'Propane dryer'!H45","v":0},null,0,null,null,0]
[null,"Selenium",null,null,{"$f":"'Natural gas dryer'!H45","v":0},{"$f":"'Propane dryer'!H46","v":0},null,0,null,null,0]
[null,"HAP Indiv. Max",{"$f":"IF(H36=H22,B22,IF(H36=H23,B23,IF(H36=H24,B24,IF(H36=H25,B25,IF(H36=H26,B26,IF(H36=H27,B27,IF(H36=H28,B28,IF(H36=H29,B29,IF(H36=H30,B30,IF(H36=H31,B31,IF(H36=H32,B32,IF(H36=H33,B33,IF(H36=H34,B34,IF(H36=H35,B35))))))))))))))","v":"Benzene"},null,null,null,null,{"$f":"MAX(H22:H35)","v":0},10,null,{"$f":"MAX(K22:K35)","v":0}]
[null,"HAP total",null,null,null,null,null,{"$f":"SUM(H22:H35)","v":0},25,null,{"$f":"SUM(K22:K35)","v":0}]

{"sheet":"Actual emissions","index":11,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[20,1,20,8],[15,1,15,8],[6,1,6,8],[0,1,0,8],[2,1,2,8],[1,1,1,8],[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],[3,8,4,8]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Actual emissions: Grain elevators and feed mills"]
[null,{"$f":"IF('Data validation'!B23=\"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 in the blue tabs.\")","v":"These pollutant totals represent the information you entered in the blue tabs."}]
[null,"Pollutant","Grain Elevator","Feed Mill","Natural Gas","Propane","Fugitive","Actual Emissions","Opt. D Permit Limits"]
[]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants"]
[null,"PM",{"$f":"'Grain elevator actual'!G36","v":0},{"$f":"'Feed mill actual'!G32","v":0},{"$f":"'Natural gas dryer'!I18","v":0},{"$f":"'Propane dryer'!I19","v":0},{"$f":"Fugitive!I72","v":0},{"$f":"SUM(C8:G8)","v":0},50]
[null,"PM10",{"$f":"'Grain elevator actual'!J36","v":0},{"$f":"'Feed mill actual'!J32","v":0},{"$f":"'Natural gas dryer'!I19","v":0},{"$f":"'Propane dryer'!I20","v":0},{"$f":"Fugitive!I73","v":0},{"$f":"SUM(C9:G9)","v":0},50]
[null,"PM2.5",{"$f":"'Grain elevator actual'!L36","v":0},{"$f":"'Feed mill actual'!L32","v":0},{"$f":"'Natural gas dryer'!I20","v":0},{"$f":"'Propane dryer'!I21","v":0},{"$f":"Fugitive!I74","v":0},{"$f":"SUM(C10:G10)","v":0}]
[null,"SOx",null,null,{"$f":"'Natural gas dryer'!I21","v":0},{"$f":"'Propane dryer'!I22","v":0},null,0,50]
[null,"NOx",null,null,{"$f":"'Natural gas dryer'!I22","v":0},{"$f":"'Propane dryer'!I23","v":0},null,0,50]
[null,"VOC",null,null,{"$f":"'Natural gas dryer'!I23","v":0},{"$f":"'Propane dryer'!I24","v":0},null,0,50]
[null,"CO",null,null,{"$f":"'Natural gas dryer'!I24","v":0},{"$f":"'Propane dryer'!I25","v":0},null,0,50]
[null,"Lead",null,null,{"$f":"'Natural gas dryer'!I25","v":0},{"$f":"'Propane dryer'!I26","v":0},null,0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",null,null,{"$f":"'Natural gas dryer'!I27","v":0},{"$f":"'Propane dryer'!I28","v":0},null,{"$f":"SUM(C17:G17)","v":0}]
[null,"CH4",null,null,{"$f":"'Natural gas dryer'!I28","v":0},{"$f":"'Propane dryer'!I29","v":0},null,{"$f":"SUM(C18:G18)","v":0}]
[null,"N2O",null,null,{"$f":"'Natural gas dryer'!I29","v":0},{"$f":"'Propane dryer'!I30","v":0},null,{"$f":"SUM(C19:G19)","v":0}]
[null,"GHG Total CO2e",null,null,{"$f":"'Natural gas dryer'!I30","v":0},{"$f":"'Propane dryer'!I31","v":0},null,{"$f":"SUM(C20:G20)","v":0},50000]
[null,"Hazardous Air Pollutants"]
[null,"Benzene",null,null,{"$f":"'Natural gas dryer'!I32","v":0},{"$f":"'Propane dryer'!I33","v":0},null,{"$f":"SUM(C22:G22)","v":0},{"$f":"SUM(E22:F22)","v":0}]
[null,"Formaldehyde",null,null,{"$f":"'Natural gas dryer'!I33","v":0},{"$f":"'Propane dryer'!I34","v":0},null,0,{"$f":"SUM(E23:F23)","v":0}]
[null,"Hexane",null,null,{"$f":"'Natural gas dryer'!I34","v":0},{"$f":"'Propane dryer'!I35","v":0},null,0,0]
[null,"Naphthalene",null,null,{"$f":"'Natural gas dryer'!I35","v":0},{"$f":"'Propane dryer'!I36","v":0},null,0,0]
[null,"Toluene",null,null,{"$f":"'Natural gas dryer'!I36","v":0},{"$f":"'Propane dryer'!I37","v":0},null,0,0]
[null,"Arsenic",null,null,{"$f":"'Natural gas dryer'!I37","v":0},{"$f":"'Propane dryer'!I38","v":0},null,0,0]
[null,"Beryllium",null,null,{"$f":"'Natural gas dryer'!I38","v":0},{"$f":"'Propane dryer'!I39","v":0},null,0,0]
[null,"Cadmium",null,null,{"$f":"'Natural gas dryer'!I39","v":0},{"$f":"'Propane dryer'!I40","v":0},null,0,0]
[null,"Chromium",null,null,{"$f":"'Natural gas dryer'!I40","v":0},{"$f":"'Propane dryer'!I41","v":0},null,0,0]
[null,"Cobalt",null,null,{"$f":"'Natural gas dryer'!I41","v":0},{"$f":"'Propane dryer'!I42","v":0},null,0,0]
[null,"Manganese",null,null,{"$f":"'Natural gas dryer'!I42","v":0},{"$f":"'Propane dryer'!I43","v":0},null,0,0]
[null,"Mercury",null,null,{"$f":"'Natural gas dryer'!I43","v":0},{"$f":"'Propane dryer'!I44","v":0},null,0,0]
[null,"Nickel",null,null,{"$f":"'Natural gas dryer'!I44","v":0},{"$f":"'Propane dryer'!I45","v":0},null,0,0]
[null,"Selenium",null,null,{"$f":"'Natural gas dryer'!I45","v":0},{"$f":"'Propane dryer'!I46","v":0},null,0,0]
[null,"HAP Indiv. Max",{"$f":"IF(H36=H22,B22,IF(H36=H23,B23,IF(H36=H24,B24,IF(H36=H25,B25,IF(H36=H26,B26,IF(H36=H27,B27,IF(H36=H28,B28,IF(H36=H29,B29,IF(H36=H30,B30,IF(H36=H31,B31,IF(H36=H32,B32,IF(H36=H33,B33,IF(H36=H34,B34,IF(H36=H35,B35))))))))))))))","v":"Benzene"},null,null,null,null,{"$f":"MAX(H22:H35)","v":0},5]
[null,"HAP total",null,null,{"$f":"'Natural gas dryer'!H78","v":0},{"$f":"'Propane dryer'!H80","v":0},null,{"$f":"SUM(H22:H35)","v":0},12.5]

{"sheet":"Permits & requirements","index":12,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,2,31,8],[32,2,33,8],[34,1,36,8],[37,1,38,8],[40,1,40,8],[23,8,25,8],[24,5,24,6],[25,5,25,6],[26,5,26,6],[26,7,27,7],[26,8,27,8],[27,5,27,6],[22,4,27,4],[22,5,22,6],[23,5,23,6],[23,7,25,7],[29,1,29,2],[29,3,29,4],[30,2,30,8],[0,1,0,8],[1,1,1,8],[2,1,5,8],[9,1,9,4],[9,5,17,8],[10,1,10,4],[11,1,12,1],[11,2,12,2],[11,3,12,3],[13,1,15,1],[13,2,15,2],[13,3,15,3],[16,1,17,1],[16,2,17,2],[16,3,17,3],[6,1,7,8],[11,4,12,4],[18,8,21,8],[18,1,21,1],[18,2,21,2],[18,3,21,3],[18,4,21,4],[18,5,21,6],[13,4,15,4],[16,4,17,4],[18,7,21,7]]}
[null,{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
[null,"Permits and requirements"]
[null,"The need for a permit is based on your entire business's potential air emissions. All activities that put pollutants into the air (including paint and solvent use, fuel use for stationary equipment, and other activities - not associated with maintenance) need to be assessed in addition to the grain, mill, and dryer emissions included in this calculator. Once you determine if you need a permit, based on whether an NSPS applies and your total potential emissions, you can then use your actual emissions to see which permit is the best fit for your business."]
[]
[]
[]
[null,"Content below is based on the information entered into this calculator and is not an official MPCA permit determination."]
[]
[]
[null,"Is a permit required?",null,null,null,"What type of permit?\nAssumes all air pollutant activities are entered into this calculator.\nIf you have additional air emission sources, the recommendation below cannot be used. You must assess your facility's total potential emissions from all sources to identify your permitting needs."]
[null,"The summary below is based on information you entered in the blue tabs. "]
[null,"Your business's potential emissions","Your business's actual emissions","A federal NSPS","A federal NESHAP"]
[]
[null,{"$f":"IF('Potential emissions'!B3=\"The flag next to a potential emission total means your potential emissions exceed the permitting threshold and a permit is required.\",\"do\",\"do not\")","v":"do not"},{"$f":"IF('Actual emissions'!B3=\"The flag next to your actual emissions total indicates that your business exceeds the Option D limit and an individual permit is required.\",\"do\",\"do not\")","v":"do not"},{"$f":"IF('Data validation'!B13>0,\"Return to Federal tab and answer Y/N\",IF(AND('Data validation'!B13=0,'Data validation'!B6>0),\"does\",\"does not\"))","v":"Return to Federal tab and answer Y/N"},{"$f":"IF('Federal standards'!N33=\"Choose Y/N\",\"Return to Federal tab and answer Y/N\",IF('Federal standards'!N33=\"Yes\",\"does\",IF('Federal standards'!N33=\"no\",\"does not\")))","v":"Return to Federal tab and answer Y/N"}]
[]
[]
[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?","Federal NESHAP applies?","Which permit do you need?",null,"More Information ","Forms"]
[]
[]
[]
[null,"no","n/a","no","Applicability of a NESHAP does not determine if a permit is required.","Below permit thresholds",null,"n/a","n/a"]
[null,"no","n/a","yes",null,"Registration Option A",null,"Info about Air Registration Permits","Application Forms, scroll to Registration Section"]
[null,"yes","no","no",null,"Registration Option D"]
[null,"yes","no","yes",null,"Registration Option D"]
[null,"yes","yes","no",null,"Other state or federal permit",null,"Info about Air Permits","Application Forms, scroll to Section 1"]
[null,"yes","yes","yes",null,"Other state or federal permit"]
[]
[null,"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,"Also see conditionally insignificant activities and conditionally exempt sources."]

{"sheet":"Data validation","index":13,"n_rows":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
[{"$f":"Instructions!F2","v":"p-sbap5-28  •  6/6/23"}]
["Data Validation"]
[]
["State Standards tab","Equation/reference"]
["Choose one","NSPS applies"]
["Located in Anoka, Carver, Dakota, Hennepin, Ramsey, Scott, or Washington County",{"$f":"SUM(B7:B9)","v":0}]
["Located in a city with a population of 7,500 people or more",{"$f":"COUNTIF('Federal standards'!N4,\"Yes\")","v":0}]
["Located in a city with a population of less than 7,500 people",{"$f":"COUNTIF('Federal standards'!N42,\"Yes\")","v":0}]
["Not located in city limits or the options above"]
[]
["Choose one"]
["More than 180,000 tons","NSPS no selection"]
["Between 120,000 and 180,000 tons",{"$f":"SUM(B14:B16)","v":2}]
["Less than 120,000 tons",{"$f":"IF('Federal standards'!N4=\"Choose Y/N\",1,0)","v":1}]
[null,{"$f":"IF('Federal standards'!N42=\"Choose Y/N\",1,0)","v":1}]
["Choose one"]
["Prior to Jan. 1, 1984"]
["On or after Jan. 1, 1984"]
[null,"Potential Emissions exceed"]
["Grain Elevator Potential",{"$f":"IF(OR('Potential emissions'!H20>=100000,OR('Potential emissions'!H8>=100,OR('Potential emissions'!H9>=25,OR('Potential emissions'!H10>=50,OR('Potential emissions'!H11>=50,OR('Potential emissions'!H12>=100,OR('Potential emissions'!H13>=100,OR('Potential emissions'!H14>=100,OR('Potential emissions'!H15>=0.5,OR('Potential emissions'!H61>=25,'Potential emissions'!H60>=10)))))))))),\"yes\",\"no\")","v":"no"}]
["Choose one"]
["Country elevator","Actual emissions exceed"]
["Terminal elevator",{"$f":"IF(OR('Actual emissions'!H20>=50000,OR('Actual emissions'!H8>=50,OR('Actual emissions'!H9>=50,OR('Actual emissions'!H10>=50,OR('Actual emissions'!H11>=50,OR('Actual emissions'!H12>=50,OR('Actual emissions'!H13>=50,OR('Actual emissions'!H14>=50,OR('Actual emissions'!H15>=0.25,OR('Actual emissions'!H61>=12.5,'Actual emissions'!H60>=5)))))))))),\"yes\",\"no\")","v":"no"}]
[]
["General selection"]
["Choose Y/N"]
["Yes","Fugitives"]
["No","Potential emission calculation"]
[null,"Choose one"]
["Natural Gas - Actual Use","NSPS for grain elevators or feed mills applies"]
["Choose one","Applying for an Option D permit"]
["hours were the units actually operated?"]
["cubic feet of gas were actually used?","Potential emission calculation"]
[null,"Choose one"]
["Propane","NSPS for grain elevators or feed mills applies"]
["Choose one","NSPS does not apply"]
["hours were the units actually operated?"]
["gallons of propane were actually used?"]