{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions","Federal standards","MPCA insignificant activities","Natural gas","Propane","Fuel oil","Waste oil","Wood","Potential emissions","Actual emissions","Permits & requirements","Fuel oil emission factors","Wood emission factors","Data validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":37,"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":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[29,10,29,14],[0,5,0,14],[1,5,1,14],[3,1,3,14],[4,1,4,14],[11,1,11,14],[12,2,12,14],[13,2,13,14],[14,2,14,14],[15,2,15,14],[16,2,16,14],[5,1,5,14],[8,1,8,14],[2,5,2,14],[6,1,7,14],[28,5,28,10],[26,4,26,13],[17,2,17,14],[20,1,20,14],[24,2,24,3],[22,1,22,14],[23,2,23,3],[23,5,23,8],[24,4,24,14],[21,1,21,14],[23,10,23,14]]}
[null,null,null,null,null,"Boilers, furnaces, and space heaters\nAir emissions calculator"]
[]
[null,null,null,null,null,"p-sbap5-21  •  6/5/23"]
[null,"Instructions"]
[null,"1) Start with the blue 'Federal standards' tab, then use the other blue tabs to enter information about your boilers."]
[null,"2) The green tabs add up potential and actual emissions from the information entered on the blue tabs."]
[null,"3) The yellow 'Permits & requirements' tab will help you decide which permit to apply for if the only emissions at your business is from boilers entered into\n    this calculator."]
[]
[null,"4) Later, you can use the blue tabs to calculate your actual emissions for the air emission inventory, a report due annually if you have an air permit. "]
[]
[]
[null,"Color key"]
[null,"Blue","Enter information for your facility in the blue boxes."]
[null,"White","Do not change the values or formulas in white boxes. White boxes contain 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,"More information on boiler requirements at: ",null,null,null,"https://www.pca.state.mn.us/business-with-us/boilers"]

{"sheet":"Federal standards","index":1,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[13,1,13,14],[36,1,36,14],[37,1,37,14],[25,1,25,14],[5,1,5,14],[12,1,12,14],[15,1,15,12],[15,13,15,14],[14,1,14,14],[20,13,21,14],[20,2,21,7],[18,10,18,12],[18,8,18,9],[47,1,47,14],[16,1,16,12],[22,1,22,14],[24,1,24,14],[23,6,23,14],[46,13,46,14],[39,1,40,14],[42,2,43,14],[41,2,41,14],[44,2,44,14],[46,8,46,9],[27,1,27,12],[27,13,27,14],[17,1,17,12],[16,13,19,14],[18,2,19,7],[1,1,1,14],[7,2,8,13],[9,2,11,13],[9,1,11,1],[7,1,8,1],[6,14,11,14],[6,2,6,13],[2,1,4,7],[2,8,4,14],[0,1,0,14],[46,10,46,12],[45,1,45,14],[46,1,46,7],[38,1,38,14],[28,13,32,14],[33,1,33,12],[35,2,35,12],[30,10,30,12],[34,2,34,12],[33,13,35,14],[32,2,32,8],[30,2,31,7],[23,1,23,2],[23,3,23,5],[26,1,26,14]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"U.S. Environmental Protection Agency (EPA) standards"]
[null,"New source performance standards (NSPS) require new emission sources to be less polluting than older sources.",null,null,null,null,null,null,"National emission standards for hazardous air pollutants (NESHAP) prevent or reduce emissions that have health impacts."]
[]
[]
[]
[null,"▪ ","Each NSPS or NESHAP applies to specific equipment, processes, or industries. "]
[null,"▪ ","Multiple federal standards may apply to your business. It is possible that if you make a change at your business, a federal standard that did not previously apply now will, or the one you are already following may have additional requirements."]
[]
[null,"▪ ","Federal standards can determine whether you need a permit and what requirements you must follow. You may have to follow federal standard requirements in addition to state permit requirements. Below are some of the common federal standards that affect boilers used for process or space heat."]
[]
[]
[]
[]
[null,"New source performance standards (NSPS)"]
[null,"Does the NSPS for steam generating units at small sources apply to your business?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"This standards is for small industrial-commercial-institutional steam generating units.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$16=\"Yes\",\"Because an NSPS applies to your business, you need an air permit.\",IF($N$16=\"No\",\"Continue to the next question below.\",IF($N$16=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[null,"This standard applies if:"]
[null,"1)","your steam-generating boiler has a maximum capacity greater than 10 million Btu per hour, and ",null,null,null,null,null,"Full Text:",null,"40 CFR 60, subp. Dc"]
[]
[null,"2)","your boiler was constructed, modified, or reconstructed* after \nJune 9, 1989.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N16=\"Yes\",\"Continue to the next question.\",IF(N16=\"No\",\"\",IF(N16=\"Choose Y/N\",\" \")))","v":" "}]
[]
[]
[null,"Resource: ",null,"EPA Rule information"]
[]
[]
[null,"National emission standards for hazardous air pollutants (NESHAP)"]
[null,"Does a NESHAP apply?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,"This standard is for industrial, commercial, and institutional area source boilers.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N28=\"Yes\",\"Follow NESHAP requirements.\",IF(N28=\"No\",\"Continue to the MPCA insignificant activities tab.\",IF(N28=\"Choose Y/N\",\" \",\" \")))","v":" "}]
[]
[null,null,"To determine if this rule affects your business, use the Regulation Navigation Tool provided on EPA website at:",null,null,null,null,null,null,"Full Text:","40 CFR 63, subp. JJJJJJ"]
[]
[null,null,"EPA Regulation Navigation Tools"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N28=\"Yes\",\"Continue to the MPCA insignificant activities tab.\",IF(N28=\"No\",\"\",IF(N28=\"Choose Y/N\",\" \")))","v":" "}]
[null,null,"A list of other NESHAPs is found on the MPCA website at the end of the following document:"]
[null,null,"https://www.pca.state.mn.us/sites/default/files/aq-f3-rp07.doc"]
[]
[]
[null,"*Definition of \"construction, modification, or reconstruction\""]
[null,"If your business does an activity which is considered construction, modification, or reconstruction, as defined here or in the standard, it may cause an NSPS or NESHAP to apply to your business or create the need for a permit amendment. "]
[]
[null,"▪ ","Construction includes fabricating, erecting, or installing a boiler. "]
[null,"▪ ","Modification is a physical change or change in operations at an existing facility that increases the amount of an air pollutant or results in the emission of a new air pollutant."]
[]
[null,"▪ ","Reconstruction is the replacement of components at an existing facility that exceeds 50% of the cost required to build a new facility."]
[]
[null,"The full definitions of construction and modification are available at:",null,null,null,null,null,null,"40 CFR § 60.2",null,"and reconstruction at: ",null,null,"40 CFR § 60.15"]

{"sheet":"MPCA insignificant activities","index":2,"n_rows":126,"n_cols":17,"rows_kept":126,"cut":false,"hidden":false,"merged":[[101,1,101,14],[1,16,4,20],[3,1,3,14],[0,1,0,14],[28,1,28,14],[22,1,22,14],[34,1,34,14],[47,1,47,14],[58,1,58,14],[75,1,80,1],[84,1,91,1],[29,2,29,12],[44,2,44,12],[46,1,46,14],[35,2,35,12],[97,2,99,12],[67,1,67,14],[69,1,69,14],[72,1,72,14],[92,1,92,14],[96,1,96,14],[81,2,82,12],[81,1,82,1],[90,4,90,12],[41,2,41,12],[39,13,39,14],[39,1,39,12],[40,1,40,14],[49,1,49,14],[76,3,77,3],[87,4,87,12],[88,4,88,12],[78,4,78,12],[45,2,45,12],[19,1,19,14],[60,13,61,14],[26,1,26,14],[66,13,66,14],[27,1,27,12],[27,13,27,14],[65,1,65,14],[123,2,123,4],[109,2,109,14],[115,2,116,14],[119,3,120,14],[105,1,105,14],[110,1,111,14],[117,2,118,14],[113,2,114,14],[122,2,122,4],[43,1,43,14],[33,1,33,12],[74,2,75,3],[74,4,75,12],[83,2,84,3],[83,4,84,12],[89,2,89,12],[42,2,42,12],[124,2,124,4],[8,1,8,14],[37,1,37,12],[15,1,15,14],[62,1,62,14],[50,1,50,14],[32,1,32,14],[36,1,36,14],[38,1,38,14],[33,13,33,14],[52,13,52,14],[54,3,55,11],[57,3,57,11],[56,3,56,11],[53,3,53,11],[20,2,21,12],[23,2,23,12],[24,2,25,12],[48,1,48,14],[37,13,37,14],[59,2,61,12],[52,1,52,12],[30,2,31,12],[107,2,108,14],[1,1,1,14],[18,1,18,12],[16,1,16,12],[4,1,5,12],[7,1,7,12],[9,1,9,12],[4,13,4,14],[7,13,7,14],[9,13,9,14],[16,13,16,14],[18,13,18,14],[11,2,11,12],[12,2,12,12],[13,1,13,14],[6,1,6,14],[14,1,14,12],[14,13,14,14],[10,1,10,14],[2,1,2,14],[17,1,17,14],[125,2,125,4],[63,2,64,12],[63,13,64,14],[68,1,68,12],[68,13,68,14],[70,2,71,12],[66,1,66,12],[79,4,79,12],[80,4,80,12],[73,13,73,14],[85,4,86,12],[93,2,95,12],[73,1,73,12],[76,2,77,2],[76,4,77,12],[104,1,104,14],[90,2,90,3],[85,2,86,2],[85,3,86,3],[100,1,100,14],[91,4,91,12],[122,6,124,14],[112,1,112,14],[106,2,106,14]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"MPCA insignificant activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tip: This section will be quicker to complete if you make a list of your heating units, the fuel they use, and the rated heat input of each unit."]
[null,"Answer the questions below to see if your heating units qualify as insignificant activities and if they must be included in a permit application."]
[]
[null,"Is your boiler, furnace, or space heater used only for heating water for on-site personal use (such as bathroom sinks) \nor is it used only for food preparation at your restaurant or cafeteria?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[]
[null,"Do each of your process boilers, furnaces, and space heaters have a rated heat input of less than 19,000 Btu/hr?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,"Is the combined rated heat input of all the process boilers, furnaces, and space heaters less than or equal to 420,000 Btu/hr?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,null,"Your heating units are insignificant activities which are not required to be listed on a permit application.1"]
[null,null,"You do not need to calculate the heating units' air emissions, unless requested by MPCA."]
[]
[null,"Do you have space heaters?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,"Do your space heaters burn kerosene, natural gas, or propane? ",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,"Is the combined heat input of all kerosene, natural gas, or propane space heaters less than or equal to 420,000 Btu/hr?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,null,"Your kerosene, natural gas, or propane space heaters are insignificant activities which must be listed on a permit application.2 You do not have to calculate or include the space heaters' air emissions, unless requested by MPCA."]
[]
[]
[null,null,"Your kerosene, natural gas, or propane space heaters may be insignificant, based on the unit's total air emissions."]
[null,null,"Answer questions below about other units at your business, then continue to the section titled \n\"Insignificant activities: emission limits.\" "]
[]
[]
[null,"Do your space heaters burn fuels other than kerosene, natural gas, or propane? ",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,null,"Your space heaters burning other fuels may be insignificant, based on each space heater's air emissions."]
[null,null,"Answer questions below about other heating units at your business, \nthen continue to the section titled \"Insignificant activities: emission limits.\""]
[]
[]
[null,"Do you have process boilers or furnaces?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,null,"Continue to the blue tabs to calculate air emissions, as needed. "]
[]
[null,"Do each of your process boilers and furnaces have a rated heat input of 420,000 Btu/hr or less?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,"Is the combined heat input of all your process boilers and furnaces less than or equal to 1,400,000 Btu/hr?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,null,"Your process boilers and furnaces are insignificant activities which must be listed on a permit application.2"]
[null,null,"You do not have to calculate or include the heating units' air emissions, unless requested by MPCA."]
[]
[null,null,"Your process boilers or furnaces may be insignificant activities, based on the unit's total air emissions."]
[null,null,"Continue to \"Insignificant activities: emission limits\" below."]
[]
[]
[null,"Insignificant activities: emission limits"]
[null,"Use the blue fuel tabs at the bottom of this spreadsheet to calculate air emissions from each heating unit that was not identified as an insignificant activity above. "]
[null,"The questions below will determine if each heating unit is an insignificant activity based on the calculated amount of air pollutants it emits. "]
[]
[null,"Does each heating unit have potential emissions less than the amounts in the table below? (If some do and others do not, select \"both\")",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,null,"Tons","Pollutant"]
[null,null,1,"particulate matter (PM), particulate matter less than 10 micrometers (PM10), nitrogen oxide (NOx), sulfur dioxide (SO2), and volatile organic compounds (VOC)"]
[]
[null,null,2,"carbon monoxide (CO)"]
[null,null,1000,"carbon dioxide equivalents (CO2e)"]
[]
[null,null,"Each heating unit that has emissions less than those in the table above is an insignificant activity which must be listed on a permit application.2 However, you do not have to calculate or include the heating unit's air emissions, unless requested by MPCA."]
[]
[]
[]
[null,null,"For each heating unit that has emissions equal to or greater than the amounts in the table, \ncontinue to the next question."]
[]
[]
[null,"Are you amending or applying for a registration permit or other state air permit?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,"Are you submitting an initial part 70 permit application?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[]
[null,null,"Your heating units are not insignificant activities and must be in your permit application. You must include the heating unit's emissions in your potential emissions calculations for the entire business."]
[]
[]
[null,"Does each heating unit have emissions less than the limits listed in the table below?",null,null,null,null,null,null,null,null,null,null,null,"Choose Y/N"]
[null,null,"Limit for potential emissions",null,"Pollutant"]
[]
[null,null,2.2799999999999998,"lb/hr","particulate matter (PM), particulate matter less than 10 micrometers (PM10), nitrogen oxide (NOx), sulfur dioxide (SO2), and volatile organic compounds (VOC)"]
[]
[null,null,5.7,"lb/hr","carbon monoxide (CO)"]
[null,null,10000,"ton/year","carbon dioxide equivalents (CO2e)"]
[null,null,25,"%","individual hazardous air pollutant (HAP) thresholds in Minn. R. 7007.1300, subp. 5 3, 4"]
[null,"OR"]
[]
[null,null,"Limit for actual emissions",null,"Pollutant"]
[]
[null,null,1,"ton/yr","particulate matter (PM), particulate matter less than 10 micrometers (PM10), nitrogen oxide (NOx), sulfur dioxide (SO2), and volatile organic compounds (VOC)"]
[]
[null,null,2,"ton/yr","carbon monoxide (CO)"]
[null,null,1000,"ton/yr","carbon dioxide equivalents (CO2e)"]
[null,null,"AND"]
[null,null,"Potential emissions",null,"Pollutant"]
[null,null,25,"% (or less)","individual hazardous air pollutant (HAP) thresholds in Minn. R. 7007.1300, subp. 5 3, 4"]
[]
[null,null,"Each heating unit that has emissions less than those listed in a table above is an insignificant activity which must be listed in an initial Part 70 permit application.5  You do not need to include these heating units' emissions in your potential emissions calculations, unless requested by MPCA."]
[]
[]
[]
[null,null,"Each heating unit that has emissions equal to or greater than those listed in a table above is NOT an insignificant activity and therefore must be in your permit application. You must include the heating unit's emissions in your potential emissions calculations for the entire business."]
[]
[]
[]
[]
[]
[]
[null,"Exclusions and definitions"]
[null,"Your heating units cannot be an insignificant activity and emissions must be included in a permit application, if:"]
[null,"▪ ","it is subject to a NESHAP (Section 112) or required to submit compliance certifications (Section 114(a)(3))"]
[null,"▪ ","it is part of a Title I modification such as prevention of significant deterioration (PSD), nonattainment new source review (NSR), NSPS, or new hazardous air pollutant standards"]
[]
[null,"▪ ","you would become subject to a Part 70 permit by adding the emissions from the heating units"]
[null,"Your heating units may be an insignificant activity depending on the maximum heat input, total heat input of all units, fuel type, equipment type, or emissions."]
[]
[]
[null,"▪ ","'Rated heat input' means the number of Btu per hour which the manufacturer has determined to be the maximum, continuous rated capability of the heating equipment. You can often find the heat input on the nameplate for the heating unit."]
[]
[null,"▪ ","'Space heater' means a heating unit that is not connected to piping or ducting to distribute the heat. Space heaters can be hung from the ceiling, a stationary stove, or movable throughout your building."]
[]
[null,"▪ ","'Process boiler' or 'furnace' includes all indirect heat exchangers where fossil fuel is burned to produce steam, hot water, hot air, or other hot liquid, gas, or solid, where the products of combustion do not have direct contact with the heated medium."]
[]
[null,null,null,"For this rule, fossil fuel includes natural gas, petroleum, coal, wood, peat, and any form of solid, liquid, or gaseous fuel derived from those materials."]
[]
[]
[null,1,"Minn. R. 7007.1300, subp. 2(A)",null,null,4,"The option to use combined hazardous air pollutant (HAP) actual emissions is not provided in this table. All process boilers, furnaces, and space heaters emit one or more of the hazardous air pollutants that are excluded from that option."]
[null,2,"Minn. R. 7007.1300, subp. 3"]
[null,3,"Minn. R. 7007.1300, subp. 5"]
[null,5,"Minn. R. 7007.1300, subp. 4",null,null,null,"https://www.revisor.mn.gov/rules/7007.1300/"]

{"sheet":"Natural gas","index":3,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,1,0,10],[8,1,8,5],[5,1,5,8],[7,4,7,5],[6,1,6,5],[7,1,7,3],[7,7,7,8],[8,6,8,8],[8,14,10,15],[8,16,10,17],[2,1,3,8],[2,16,3,17],[1,12,1,17],[4,1,4,8],[6,14,7,15],[4,14,5,15],[4,16,5,17],[6,16,7,17],[4,12,5,13],[1,1,1,10],[6,12,7,13],[2,12,3,13],[2,14,3,15],[9,1,9,8],[8,12,10,13],[48,6,48,7],[46,1,46,8],[47,1,47,8],[48,1,48,5],[11,10,12,10],[10,1,15,1],[11,2,15,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"Air emissions from burning natural gas",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'!A6,\" \",IF(E8='Data validation'!A7,\"hours/year\",IF(E8='Data validation'!A8,\"cu ft/year\")))","v":" "}]
[null,{"$f":"IF(E8='Data validation'!A8,\"(you can use your gas bill)\",\" \")","v":" "},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,"Pollutant","a","b","c","d","e"]
[null,null,"GWP1","Maximum hourly usage","Actual natural gas burned","Hours in a Year","Emission Factor","Potential Emissions","Actual Emissions",null,"Insignificant Activity3 Limits"]
[]
[null,null,null,"(cu ft/hr)","(cu ft/yr)","(hr/yr)","(lbs/cu ft)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,"(Btu/hr) / (1020 Btu/cuft)",null,"24 hr/day * 365 day/yr",null,"(b * d * e) / 2000","( c * e ) / 2000"]
[null,null,null,{"$f":"G7/1020","v":0},{"$f":"IF(E8='Data validation'!A6,0,IF(E8='Data validation'!A7,((G8/1020)*G7),IF(E8='Data validation'!A8,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:J25)","v":6}]
[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,{"$f":"G18","v":7.6000000000000001E-6},0,0,{"$f":"IF(K19>H19,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"G19","v":7.6000000000000001E-6},0,0]
[null,"SOx",null,null,null,null,5.9999999999999997E-7,0,0,{"$f":"IF(K21>H21,1,0)","v":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,null,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) 2",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","index":4,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,10],[8,1,8,5],[8,7,8,8],[10,1,10,8],[9,1,9,8],[7,1,7,5],[7,6,7,8],[4,1,4,8],[1,1,1,10],[6,7,6,8],[5,1,5,5],[6,1,6,3],[6,4,6,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],[8,16,10,17],[2,1,3,8],[47,1,47,8],[6,12,7,13],[6,14,7,15],[6,16,7,17],[15,10,16,10],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,10,13,10],[11,1,16,1],[12,2,16,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[8,12,10,13],[8,14,10,15],[48,1,48,8],[49,1,49,5],[49,6,49,7]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"Air emissions from burning propane ",null,null,null,null,null,null,null,null,null,null,"Tip: How to use this calculator"]
[null,"Propane combustion",null,null,null,null,null,null,null,null,null,null,"If you have…",null,"For potential emissions",null,"For actual emissions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"One process/heating unit",null,"Enter maximum rated heat input",null,"Enter amount of fuel burned or actual operation hours"]
[null,"What is the total maximum rated heat input for your propane units?",null,null,null,null,0,"Btu per hour","(Check your units!)"]
[null,"In the previous 12 months, how many",null,null,"Choose one",null,0,{"$f":"IF(E7='Data validation'!A12,\" \",IF(E7='Data validation'!A13,\"hours/year\",IF(E7='Data validation'!A14,\"gallons/year\")))","v":" "},null,null,null,null,"More than one process/heating unit",null,"Enter the total maximum rated heat input of all units, combined",null,"Enter amount of fuel burned. Do not use operation hours."]
[]
[null,"Sulfur content of propane",null,null,null,null,0.18,"grains/100 cubic feet",null,null,null,null,"A unit that can burn more than one fuel type",null,"Calculate for both fuel types. The highest ton/yr per pollutant is to be used for potential emissions",null,"Enter amount of each type of fuel burned."]
[]
[null,"Propane potential and actual emissions"]
[null,"Pollutant","a","b","c","d","e"]
[null,null,"GWP1","Maximum hourly 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 hr/day * 365 day/yr",null,"(b * d * e) / 2000","( c * e ) / 2000"]
[null,null,null,{"$f":"G6/91500","v":0},{"$f":"IF(E7='Data validation'!A12,0,IF(E7='Data validation'!A13,((G7/91500)*G6),IF(E7='Data validation'!A14,G7)))","v":0},8760,"by pollutant"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.5",{"$f":"SUM(J19:J26)","v":6}]
[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},{"$f":"IF(K19>H19,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"G19","v":6.9999999999999999E-4},0,0,{"$f":"IF(K20>H20,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"G20","v":6.9999999999999999E-4},0,0]
[null,"SOx",null,null,null,null,{"$f":"0.001*G9","v":1.7999999999999998E-4},0,0,{"$f":"IF(K22>H22,1,0)","v":1},1]
[null,"NOx",null,null,null,null,1.2999999999999999E-2,0,0,{"$f":"IF(K23>H23,1,0)","v":1},1]
[null,"VOC",null,null,null,null,1E-3,0,0,{"$f":"IF(K24>H24,1,0)","v":1},1]
[null,"CO",null,null,null,null,7.4999999999999997E-3,0,0,{"$f":"IF(K25>H25,1,0)","v":1},2]
[null,"Lead",null,null,null,null,"n/a"]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2"]
[null,"CO2",1,null,null,null,{"$f":"61.46/1000000*91500/0.453592","v":12.39790384310129},{"$f":"$D$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},{"$f":"IF(K31>H31,1,0)","v":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)/2488*91500","v":7.7230707395498392E-8},{"$f":"$D$17*$F$17*$G33/2000","v":0},{"$f":"($E$17*$G33)/2000","v":0}]
[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":"Fuel oil","index":5,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,1,0,10],[8,7,8,8],[9,7,9,8],[10,1,10,5],[10,7,10,8],[8,1,8,3],[8,4,8,5],[7,1,7,5],[5,1,5,5],[1,1,1,10],[2,1,3,8],[9,1,9,5],[8,16,10,17],[6,12,7,13],[6,14,7,15],[6,16,7,17],[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],[8,12,10,13],[8,14,10,15],[17,10,18,10],[19,1,19,8],[28,1,28,8],[33,1,33,8],[11,1,11,8],[14,10,15,10],[14,8,15,8],[14,7,15,7],[14,6,15,6],[14,5,15,5],[14,4,15,4],[14,3,15,3],[13,1,18,1],[14,2,18,2],[53,1,53,8],[54,1,54,8],[55,1,55,5],[55,6,55,7],[12,1,12,8]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"Air emissions from burning fuel oil ",null,null,null,null,null,null,null,null,null,null,"Tip: How to use this calculator"]
[null,"Fuel oil combustion: Fuel oil no. 1, 2 (diesel), 5, 6",null,null,null,null,null,null,null,null,null,null,"If you have…",null,"For potential emissions",null,"For actual emissions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"One process/heating unit",null,"Enter maximum rated heat input",null,"Enter amount of fuel burned or actual operation hours"]
[null,"What type of fuel oil do you burn?",null,null,null,null,"Choose one",{"$f":"IF($G$6='Fuel oil emission factors'!B5,'Fuel oil emission factors'!B4,IF($G$6='Fuel oil emission factors'!D5,'Fuel oil emission factors'!B4,IF($G$6='Fuel oil emission factors'!F5,'Fuel oil emission factors'!F4,IF($G$6='Fuel oil emission factors'!H5,'Fuel oil emission factors'!F4,IF($G$6='Fuel oil emission factors'!A5,\" \")))))","v":" "}]
[null,null,null,null,null,"What type of boiler do you have?","Choose one",null,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,"What is the total maximum rated heat input for your fuel oil units?",null,null,null,null,0,"Btu per hour","(Check your units!)"]
[null,"In the previous 12 months, how many",null,null,"Choose one",null,0,{"$f":"IF(E9='Data validation'!A18,\" \",IF(E9='Data validation'!A19,\"hours/year\",IF(E9='Data validation'!A20,\"gallons/year\")))","v":" "},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,"Heat value of the fuel oil",null,null,null,null,{"$f":"IF(G6='Fuel oil emission factors'!B5,'Fuel oil emission factors'!C51,IF(G6='Fuel oil emission factors'!D5,'Fuel oil emission factors'!C52,IF(G6='Fuel oil emission factors'!F5,'Fuel oil emission factors'!C53,IF(G6='Fuel oil emission factors'!H5,'Fuel oil emission factors'!C54,IF(G6='Fuel oil emission factors'!A5,0)))))","v":0},"Btu per gallon"]
[null,"Sulfur content of fuel",null,null,null,null,0.05,"%"]
[]
[null,"Fuel oil potential and actual emissions"]
[null,"Pollutant","a","b","c","d","e"]
[null,null,"GWP1","Maximum hourly usage","Actual fuel oil burned","Hours in a Year","Emission Factor3","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) / (Btu/gallon)",null,"24 hr/day * 365 day/yr",null,"(b * d * e) / 2000","( c * e ) / 2000"]
[null,null,null,{"$f":"IF(G10=0,0,IF(G10>0,G8/G10,0))","v":0},{"$f":"IF(E9='Data validation'!A18,0,IF(E9='Data validation'!A19,((G9/G10)*G8),IF(E9='Data validation'!A20,G9)))","v":0},8760,"by pollutant"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,null,{"$f":"SUM(J21:J27)","v":6}]
[null,"PM",null,null,null,null,{"$f":"IF(OR($G$6=\"Choose one\",$G$7=\"Choose one\"),0,IF(AND($G$6=FOone,$G$7=FOcom),'Fuel oil emission factors'!B9,IF(AND($G$6=FOone,$G$7=FOind),'Fuel oil emission factors'!C9,IF(AND($G$6=FOtwo,$G$7=FOcom),'Fuel oil emission factors'!D9,IF(AND($G$6=FOtwo,$G$7=FOind),'Fuel oil emission factors'!E9,IF(AND($G$6=FOfive,$G$7=FOcom),'Fuel oil emission factors'!F9,IF(AND($G$6=FOfive,$G$7=FOind),'Fuel oil emission factors'!G9,IF(AND($G$6=FOsix,$G$7=FOcom),'Fuel oil emission factors'!H9,IF(AND($G$6=FOsix,$G$7=FOind),'Fuel oil emission factors'!I9)))))))))","v":0},{"$f":"$D$19*$F$19*$G21/2000","v":0},{"$f":"($E$19*$G21)/2000","v":0},{"$f":"IF(K21>H21,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"IF(OR($G$6=\"Choose one\",$G$7=\"Choose one\"),0,IF(AND($G$6=FOone,$G$7=FOcom),'Fuel oil emission factors'!B10,IF(AND($G$6=FOone,$G$7=FOind),'Fuel oil emission factors'!C10,IF(AND($G$6=FOtwo,$G$7=FOcom),'Fuel oil emission factors'!D10,IF(AND($G$6=FOtwo,$G$7=FOind),'Fuel oil emission factors'!E10,IF(AND($G$6=FOfive,$G$7=FOcom),'Fuel oil emission factors'!F10,IF(AND($G$6=FOfive,$G$7=FOind),'Fuel oil emission factors'!G10,IF(AND($G$6=FOsix,$G$7=FOcom),'Fuel oil emission factors'!H10,IF(AND($G$6=FOsix,$G$7=FOind),'Fuel oil emission factors'!I10)))))))))","v":0},0,0,{"$f":"IF(K22>H22,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"IF(OR($G$6=\"Choose one\",$G$7=\"Choose one\"),0,IF(AND($G$6=FOone,$G$7=FOcom),'Fuel oil emission factors'!B11,IF(AND($G$6=FOone,$G$7=FOind),'Fuel oil emission factors'!C11,IF(AND($G$6=FOtwo,$G$7=FOcom),'Fuel oil emission factors'!D11,IF(AND($G$6=FOtwo,$G$7=FOind),'Fuel oil emission factors'!E11,IF(AND($G$6=FOfive,$G$7=FOcom),'Fuel oil emission factors'!F11,IF(AND($G$6=FOfive,$G$7=FOind),'Fuel oil emission factors'!G11,IF(AND($G$6=FOsix,$G$7=FOcom),'Fuel oil emission factors'!H11,IF(AND($G$6=FOsix,$G$7=FOind),'Fuel oil emission factors'!I11)))))))))","v":0},0,0]
[null,"SOx",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B17,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D17,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F17,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H17,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},0,0,{"$f":"IF(K24>H24,1,0)","v":1},1]
[null,"NOx",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B18,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D18,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F18,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H18,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},0,0,{"$f":"IF(K25>H25,1,0)","v":1},1]
[null,"VOC",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B19,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D19,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F19,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H19,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},0,0,{"$f":"IF(K26>H26,1,0)","v":1},1]
[null,"CO",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B20,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D20,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F20,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H20,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},0,0,{"$f":"IF(K27>H27,1,0)","v":1},2]
[null,"Lead",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B21,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D21,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F21,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H21,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},0,0]
[null,"Greenhouse Gas Emissions"]
[null,"CO2",1,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B23,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D23,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F23,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H23,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},{"$f":"$D$19*$F$19*$G30/2000","v":0},{"$f":"($E$19*$G30)/2000","v":0}]
[null,"CH4",25,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B24,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D24,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F24,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H24,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},{"$f":"$D$19*$F$19*$G31/2000","v":0},{"$f":"($E$19*$G31)/2000","v":0}]
[null,"N2O",298,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B25,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D25,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F25,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H25,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},{"$f":"$D$19*$F$19*$G32/2000","v":0},{"$f":"($E$19*$G32)/2000","v":0}]
[null,null,null,null,null,"GHG Total (CO2e) 2",null,{"$f":"(C30*H30)+(C31*H31)+(C32*H32)","v":0},{"$f":"(C30*I30)+(C31*I31)+(C32*I32)","v":0},{"$f":"IF(K33>H33,1,0)","v":1},1000]
[null,"Hazardous Air Pollutants"]
[null,"Benzene",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B27,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D27,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F27,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H27,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},{"$f":"IF(G35=0,\" \",IF(G35>0,($D$19*$F$19*$G35/2000)))","v":" "},{"$f":"IF(G35=0,\" \",IF(G35>0,(($E$19*$G35)/2000)))","v":" "}]
[null,"Ethylbenzene",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B28,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D28,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F28,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H28,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},{"$f":"IF(G36=0,\" \",IF(G36>0,($D$19*$F$19*$G36/2000)))","v":" "},{"$f":"IF(G36=0,\" \",IF(G36>0,(($E$19*$G36)/2000)))","v":" "}]
[null,"Formaldehyde",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B29,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D29,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F29,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H29,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Methyl chloroform",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B30,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D30,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F30,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H30,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0},{"$f":"IF(G38=0,\" \",IF(G38>0,($D$19*$F$19*$G38/2000)))","v":" "},{"$f":"IF(G38=0,\" \",IF(G38>0,(($E$19*$G38)/2000)))","v":" "}]
[null,"Naphthalene",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B31,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D31,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F31,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H31,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Toluene",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B32,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D32,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F32,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H32,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"o-Xylene",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B33,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D33,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F33,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H33,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Antimony",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B35,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D35,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F35,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H35,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Arsenic",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B36,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D36,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F36,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H36,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Beryllium",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B37,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D37,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F37,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H37,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Cadmium",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B38,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D38,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F38,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H38,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Chromium",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B39,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D39,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F39,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H39,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Chromium (VI)",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B40,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D40,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F40,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H40,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Cobalt",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B41,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D41,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F41,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H41,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Manganese",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B42,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D42,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F42,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H42,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Mercury",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B43,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D43,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F43,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H43,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Nickel",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B44,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D44,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F44,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H44,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,"Selenium",null,null,null,null,{"$f":"IF($G$6='Fuel oil emission factors'!$B$5,'Fuel oil emission factors'!B45,IF($G$6='Fuel oil emission factors'!$D$5,'Fuel oil emission factors'!D45,IF($G$6='Fuel oil emission factors'!$F$5,'Fuel oil emission factors'!F45,IF($G$6='Fuel oil emission factors'!$H$5,'Fuel oil emission factors'!H45,IF($G$6='Fuel oil emission factors'!$A$5,0)))))","v":0}," "," "]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H35:H52)","v":0},{"$f":"SUM(I35:I52)","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":"Waste oil","index":6,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,1,0,10],[14,7,15,7],[14,10,15,10],[5,1,5,5],[1,1,1,10],[14,8,15,8],[13,1,18,1],[43,1,43,8],[44,1,44,5],[17,10,18,10],[6,7,6,8],[9,7,9,8],[10,1,10,5],[10,7,10,8],[6,1,6,3],[6,4,6,5],[7,1,7,8],[14,2,18,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[44,6,44,7],[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],[8,12,10,13],[8,14,10,15],[8,16,10,17],[2,1,3,8],[42,1,42,8],[6,12,7,13],[6,14,7,15],[6,16,7,17],[12,1,12,8],[8,1,8,5],[9,1,9,5],[11,1,11,8],[33,7,33,8],[28,7,28,8],[19,7,19,8]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"Air emissions from burning waste oil ",null,null,null,null,null,null,null,null,null,null,"Tip: How to use this calculator"]
[null,"Waste oil combustion",null,null,null,null,null,null,null,null,null,null,"If you have…",null,"For potential emissions",null,"For actual emissions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"One process/heating unit",null,"Enter maximum rated heat input",null,"Enter amount of fuel burned or actual operation hours"]
[null,"What is the total maximum rated heat input for your waste oil units?",null,null,null,null,0,"Btu per hour","(Check your units!)"]
[null,"In the previous 12 months, how many",null,null,"Choose one",null,0,{"$f":"IF(E7='Data validation'!A18,\" \",IF(E7='Data validation'!A19,\"hours/year\",IF(E7='Data validation'!A20,\"gallons/year\")))","v":" "},null,null,null,null,"More than one process/heating unit",null,"Enter the total maximum rated heat input of all units, combined",null,"Enter amount of fuel burned. Do not use operation hours."]
[]
[null,"Ash content",null,null,null,"Ash content",5,"% by weight",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,"Sulfur content",null,null,null,null,0.5,"% by weight"]
[null,"Lead content",null,null,null,null,0.05,"% by weight"]
[]
[null,"Waste oil potential and actual emissions"]
[null,"Pollutant","a","b","c","d","e"]
[null,null,"GWP1","Maximum hourly usage2 ","Actual waste oil 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 / 135000 Btu/gal",null,"24 hr/day * 365 day/yr",null,"(b * d * e) / 2000","( c * e ) / 2000"]
[null,null,null,{"$f":"G6/135000","v":0},{"$f":"IF(E7='Data validation'!A18,0,IF(E7='Data validation'!A19,((G7/135000)*G6),IF(E7='Data validation'!A20,G7)))","v":0},8760,"by pollutant"]
[null,"Criteria Air Pollutants",null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.11",null,{"$f":"SUM(J21:J28)","v":6}]
[null,"PM",null,null,null,null,{"$f":"0.064*G9","v":0.32},{"$f":"$D$19*$F$19*$G21/2000","v":0},{"$f":"($E$19*$G21)/2000","v":0},{"$f":"IF(K21>H21,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"0.051*G9","v":0.255},0,0,{"$f":"IF(K22>H22,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"G22","v":0.255},0,0]
[null,"SOx",null,null,null,null,{"$f":"0.147*G10","v":7.3499999999999996E-2},0,0,{"$f":"IF(K24>H24,1,0)","v":1},1]
[null,"NOx",null,null,null,null,1.9E-2,0,0,{"$f":"IF(K25>H25,1,0)","v":1},1]
[null,"VOC",null,null,null,null,1E-3,0,0,{"$f":"IF(K26>H26,1,0)","v":1},1]
[null,"CO",null,null,null,null,5.0000000000000001E-3,0,0,{"$f":"IF(K27>H27,1,0)","v":1},2]
[null,"Lead",null,null,null,null,{"$f":"0.055*G11","v":2.7500000000000003E-3},0,0]
[null,"Greenhouse Gas Emissions",null,null,null,null,null,"Source: 40 CFR 98, Subp. C, Table C-1 and C-2"]
[null,"CO2",1,null,null,null,22.02,{"$f":"$D$19*$F$19*$G30/2000","v":0},{"$f":"($E$19*$G30)/2000","v":0}]
[null,"CH4",25,null,null,null,8.92E-4,{"$f":"$D$19*$F$19*$G31/2000","v":0},{"$f":"($E$19*$G31)/2000","v":0}]
[null,"N2O",298,null,null,null,1.7799999999999999E-4,{"$f":"$D$19*$F$19*$G32/2000","v":0},{"$f":"($E$19*$G32)/2000","v":0}]
[null,null,null,null,null,"GHG Total (CO2e) 2",null,{"$f":"(C30*H30)+(C31*H31)+(C32*H32)","v":0},{"$f":"(C30*I30)+(C31*I31)+(C32*I32)","v":0},{"$f":"IF(K33>H33,1,0)","v":1},1000]
[null,"Hazardous Air Pollutants",null,null,null,null,null,"Source:  EPA AP-42 Chapter 1.11"]
[null,"Naphthalene",null,null,null,null,{"$f":"0.013/1000","v":1.2999999999999999E-5},{"$f":"$D$19*$F$19*$G35/2000","v":0},{"$f":"($E$19*$G35)/2000","v":0}]
[null,"Arsenic",null,null,null,null,{"$f":"0.11/1000","v":1.1E-4},0,{"$f":"($E$19*$G36)/2000","v":0}]
[null,"Cadmium",null,null,null,null,{"$f":"0.0093/1000","v":9.299999999999999E-6},0,0]
[null,"Chromium",null,null,null,null,{"$f":"0.02/1000","v":2.0000000000000002E-5},0,0]
[null,"Cobalt",null,null,null,null,{"$f":"0.00021/1000","v":2.1E-7},0,0]
[null,"Manganese",null,null,null,null,{"$f":"0.068/1000","v":6.7999999999999999E-5},0,0]
[null,"Nickel",null,null,null,null,{"$f":"0.011/1000","v":1.1E-5},0,0]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H35:H41)","v":0},{"$f":"SUM(I35:I41)","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":"Wood","index":7,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[71,1,71,8],[72,1,72,8],[73,1,73,5],[73,6,73,7],[13,2,17,2],[18,1,18,8],[27,1,27,8],[32,1,32,8],[12,1,17,1],[7,7,7,8],[11,1,11,8],[16,10,17,10],[6,1,6,5],[9,1,9,5],[9,7,9,8],[7,1,7,3],[7,4,7,5],[10,1,10,8],[13,10,14,10],[13,8,14,8],[13,7,14,7],[13,6,14,6],[13,5,14,5],[13,4,14,4],[13,3,14,3],[5,1,5,5],[0,1,0,10],[1,1,1,10],[2,1,3,8],[4,1,4,8],[5,6,5,7],[8,12,10,13],[8,14,10,15],[8,16,10,17],[6,12,7,13],[6,14,7,15],[6,16,7,17],[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]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"Air emissions from burning wood",null,null,null,null,null,null,null,null,null,null,"Tip: How to use this calculator"]
[null,"Wood combustion: wet, dry, and bark",null,null,null,null,null,null,null,null,null,null,"If you have…",null,"For potential emissions",null,"For actual emissions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"One process/heating unit",null,"Enter maximum rated heat input",null,"Enter amount of fuel burned or actual operation hours"]
[null,"What type of wood do you burn?",null,null,null,null,"Choose one"]
[null,"What is the total maximum rated heat input for your wood 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'!A24,\" \",IF(E8='Data validation'!A25,\"hours/year\",IF(E8='Data validation'!A26,\"tons/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,"Heat value of wood",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B6,IF($G$6=DW,'Wood emission factors'!D6,IF($G$6=WW,'Wood emission factors'!C6,IF($G$6=AWT,'Wood emission factors'!E6)))))","v":0},"Btu per ton"]
[]
[null,"Wood potential and actual emissions"]
[null,"Pollutant","a","b","c","d","e"]
[null,null,"GWP1","Maximum hourly usage","Actual wood burned","Hours in a Year","Emission Factor3","Potential Emissions","Actual Emissions",null,"Insignificant Activity3 Limits"]
[]
[null,null,null,"(ton/hr)","(ton/yr)","(hr/yr)","(lb/ton)","(ton/yr)","(tons/yr)",null,"(tons/yr)"]
[null,null,null,"(Btu/hr) / (Btu/ton)",null,"24 hr/day*365 day/yr",null,"(b * d * e) / 2000","( c * e ) / 2000"]
[null,null,null,{"$f":"IF(G10=0,0,IF(G10>0,(G7/G10)))","v":0},{"$f":"IF(OR(G8=0,G10=0),0,IF(E8='Data validation'!A24,0,IF(E8='Data validation'!A25,(G7*G8/G10),IF(E8='Data validation'!A26,G8))))","v":0},8760,"by pollutant"]
[null,"Criteria Air Pollutants",null,null,null,null,null,null,null,{"$f":"SUM(J20:J27)","v":6}]
[null,"PM",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B8,IF($G$6=WW,'Wood emission factors'!C8,IF($G$6=DW,'Wood emission factors'!D8,IF($G$6=AWT,'Wood emission factors'!E8)))))","v":0},{"$f":"$D$18*$F$18*$G20/2000","v":0},{"$f":"($E$18*$G20)/2000","v":0},{"$f":"IF(K20>H20,1,0)","v":1},1]
[null,"PM10",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B9,IF($G$6=WW,'Wood emission factors'!C9,IF($G$6=DW,'Wood emission factors'!D9,IF($G$6=AWT,'Wood emission factors'!E9)))))","v":0},0,0,{"$f":"IF(K21>H21,1,0)","v":1},1]
[null,"PM2.5",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B10,IF($G$6=WW,'Wood emission factors'!C10,IF($G$6=DW,'Wood emission factors'!D10,IF($G$6=AWT,'Wood emission factors'!E10)))))","v":0},0,0]
[null,"SOx",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B11,IF($G$6=WW,'Wood emission factors'!C11,IF($G$6=DW,'Wood emission factors'!D11,IF($G$6=AWT,'Wood emission factors'!E11)))))","v":0},0,0,{"$f":"IF(K23>H23,1,0)","v":1},1]
[null,"NOx",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B12,IF($G$6=WW,'Wood emission factors'!C12,IF($G$6=DW,'Wood emission factors'!D12,IF($G$6=AWT,'Wood emission factors'!E12)))))","v":0},0,0,{"$f":"IF(K24>H24,1,0)","v":1},1]
[null,"VOC",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B13,IF($G$6=WW,'Wood emission factors'!C13,IF($G$6=DW,'Wood emission factors'!D13,IF($G$6=AWT,'Wood emission factors'!E13)))))","v":0},0,0,{"$f":"IF(K25>H25,1,0)","v":1},1]
[null,"CO",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B14,IF($G$6=WW,'Wood emission factors'!C14,IF($G$6=DW,'Wood emission factors'!D14,IF($G$6=AWT,'Wood emission factors'!E14)))))","v":0},0,0,{"$f":"IF(K26>H26,1,0)","v":1},2]
[null,"Lead",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B15,IF($G$6=WW,'Wood emission factors'!C15,IF($G$6=DW,'Wood emission factors'!D15,IF($G$6=AWT,'Wood emission factors'!E15)))))","v":0},0,0]
[null,"Greenhouse Gas Emissions"]
[null,"CO2",1,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B17,IF($G$6=WW,'Wood emission factors'!C17,IF($G$6=DW,'Wood emission factors'!D17,IF($G$6=AWT,'Wood emission factors'!E17)))))","v":0},{"$f":"$D$18*$F$18*$G29/2000","v":0},{"$f":"($E$18*$G29)/2000","v":0}]
[null,"CH4",25,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B18,IF($G$6=WW,'Wood emission factors'!C18,IF($G$6=DW,'Wood emission factors'!D18,IF($G$6=AWT,'Wood emission factors'!E18)))))","v":0},{"$f":"$D$18*$F$18*$G30/2000","v":0},{"$f":"($E$18*$G30)/2000","v":0}]
[null,"N2O",298,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B19,IF($G$6=WW,'Wood emission factors'!C19,IF($G$6=DW,'Wood emission factors'!D19,IF($G$6=AWT,'Wood emission factors'!E19)))))","v":0},{"$f":"$D$18*$F$18*$G31/2000","v":0},{"$f":"($E$18*$G31)/2000","v":0}]
[null,null,null,null,null,"GHG Total (CO2e) 2",null,{"$f":"(C29*H29)+(C30*H30)+(C31*H31)","v":0},{"$f":"(C29*I29)+(C30*I30)+(C31*I31)","v":0},{"$f":"IF(K32>H32,1,0)","v":1},1000]
[null,"Hazardous Air Pollutants"]
[null,"Acetaldehyde",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B21,IF($G$6=WW,'Wood emission factors'!C21,IF($G$6=DW,'Wood emission factors'!D21,IF($G$6=AWT,'Wood emission factors'!E21)))))","v":0},{"$f":"$D$18*$F$18*$G34/2000","v":0},{"$f":"($E$18*$G34)/2000","v":0}]
[null,"Acetophenone",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B22,IF($G$6=WW,'Wood emission factors'!C22,IF($G$6=DW,'Wood emission factors'!D22,IF($G$6=AWT,'Wood emission factors'!E22)))))","v":0},{"$f":"$D$18*$F$18*$G35/2000","v":0},{"$f":"($E$18*$G35)/2000","v":0}]
[null,"Acrolein",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B23,IF($G$6=WW,'Wood emission factors'!C23,IF($G$6=DW,'Wood emission factors'!D23,IF($G$6=AWT,'Wood emission factors'!E23)))))","v":0},0,0]
[null,"Benzene",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B24,IF($G$6=WW,'Wood emission factors'!C24,IF($G$6=DW,'Wood emission factors'!D24,IF($G$6=AWT,'Wood emission factors'!E24)))))","v":0},0,0]
[null,"Bis(2-ethylhexyl)phthalate",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B25,IF($G$6=WW,'Wood emission factors'!C25,IF($G$6=DW,'Wood emission factors'!D25,IF($G$6=AWT,'Wood emission factors'!E25)))))","v":0},0,0]
[null,"Carbon tetrachloride",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B26,IF($G$6=WW,'Wood emission factors'!C26,IF($G$6=DW,'Wood emission factors'!D26,IF($G$6=AWT,'Wood emission factors'!E26)))))","v":0},0,0]
[null,"Chlorine",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B27,IF($G$6=WW,'Wood emission factors'!C27,IF($G$6=DW,'Wood emission factors'!D27,IF($G$6=AWT,'Wood emission factors'!E27)))))","v":0},0,0]
[null,"2-Chloroacetophenone",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B28,IF($G$6=WW,'Wood emission factors'!C28,IF($G$6=DW,'Wood emission factors'!D28,IF($G$6=AWT,'Wood emission factors'!E28)))))","v":0},0,0]
[null,"Chlorobenzene",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B29,IF($G$6=WW,'Wood emission factors'!C29,IF($G$6=DW,'Wood emission factors'!D29,IF($G$6=AWT,'Wood emission factors'!E29)))))","v":0},0,0]
[null,"Chloroform",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B30,IF($G$6=WW,'Wood emission factors'!C30,IF($G$6=DW,'Wood emission factors'!D30,IF($G$6=AWT,'Wood emission factors'!E30)))))","v":0},0,0]
[null,"2,4-Dinitrophenol",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B31,IF($G$6=WW,'Wood emission factors'!C31,IF($G$6=DW,'Wood emission factors'!D31,IF($G$6=AWT,'Wood emission factors'!E31)))))","v":0},0,0]
[null,"Ethyl benzene",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B32,IF($G$6=WW,'Wood emission factors'!C32,IF($G$6=DW,'Wood emission factors'!D32,IF($G$6=AWT,'Wood emission factors'!E32)))))","v":0},0,0]
[null,"Ethylene dibromide",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B33,IF($G$6=WW,'Wood emission factors'!C33,IF($G$6=DW,'Wood emission factors'!D33,IF($G$6=AWT,'Wood emission factors'!E33)))))","v":0},0,0]
[null,"Ethylene dichloride",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B34,IF($G$6=WW,'Wood emission factors'!C34,IF($G$6=DW,'Wood emission factors'!D34,IF($G$6=AWT,'Wood emission factors'!E34)))))","v":0},0,0]
[null,"Formaldehyde",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B35,IF($G$6=WW,'Wood emission factors'!C35,IF($G$6=DW,'Wood emission factors'!D35,IF($G$6=AWT,'Wood emission factors'!E35)))))","v":0},0,0]
[null,"Methylene chloride",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B36,IF($G$6=WW,'Wood emission factors'!C36,IF($G$6=DW,'Wood emission factors'!D36,IF($G$6=AWT,'Wood emission factors'!E36)))))","v":0},0,0]
[null,"Methyl chloroform",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B37,IF($G$6=WW,'Wood emission factors'!C37,IF($G$6=DW,'Wood emission factors'!D37,IF($G$6=AWT,'Wood emission factors'!E37)))))","v":0},0,0]
[null,"Naphthalene",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B38,IF($G$6=WW,'Wood emission factors'!C38,IF($G$6=DW,'Wood emission factors'!D38,IF($G$6=AWT,'Wood emission factors'!E38)))))","v":0},0,0]
[null,"Phenol",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B39,IF($G$6=WW,'Wood emission factors'!C39,IF($G$6=DW,'Wood emission factors'!D39,IF($G$6=AWT,'Wood emission factors'!E39)))))","v":0},0,0]
[null,"Propionaldehyde",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B40,IF($G$6=WW,'Wood emission factors'!C40,IF($G$6=DW,'Wood emission factors'!D40,IF($G$6=AWT,'Wood emission factors'!E40)))))","v":0},0,0]
[null,"Styrene",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B41,IF($G$6=WW,'Wood emission factors'!C41,IF($G$6=DW,'Wood emission factors'!D41,IF($G$6=AWT,'Wood emission factors'!E41)))))","v":0},0,0]
[null,"2,3,7,8-Tetrachlorodibenzo-p-dioxin",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B42,IF($G$6=WW,'Wood emission factors'!C42,IF($G$6=DW,'Wood emission factors'!D42,IF($G$6=AWT,'Wood emission factors'!E42)))))","v":0},0,0]
[null,"2,4,6-Trichlorophenol",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B43,IF($G$6=WW,'Wood emission factors'!C43,IF($G$6=DW,'Wood emission factors'!D43,IF($G$6=AWT,'Wood emission factors'!E43)))))","v":0},0,0]
[null,"Toluene",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B44,IF($G$6=WW,'Wood emission factors'!C44,IF($G$6=DW,'Wood emission factors'!D44,IF($G$6=AWT,'Wood emission factors'!E44)))))","v":0},0,0]
[null,"Vinyl chloride",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B45,IF($G$6=WW,'Wood emission factors'!C45,IF($G$6=DW,'Wood emission factors'!D45,IF($G$6=AWT,'Wood emission factors'!E45)))))","v":0},0,0]
[null,"o-Xylenes",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B46,IF($G$6=WW,'Wood emission factors'!C46,IF($G$6=DW,'Wood emission factors'!D46,IF($G$6=AWT,'Wood emission factors'!E46)))))","v":0},0,0]
[null,"Antimony",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B47,IF($G$6=WW,'Wood emission factors'!C47,IF($G$6=DW,'Wood emission factors'!D47,IF($G$6=AWT,'Wood emission factors'!E47)))))","v":0},0,0]
[null,"Arsenic",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B48,IF($G$6=WW,'Wood emission factors'!C48,IF($G$6=DW,'Wood emission factors'!D48,IF($G$6=AWT,'Wood emission factors'!E48)))))","v":0},0,0]
[null,"Beryllium",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B49,IF($G$6=WW,'Wood emission factors'!C49,IF($G$6=DW,'Wood emission factors'!D49,IF($G$6=AWT,'Wood emission factors'!E49)))))","v":0},0,0]
[null,"Cadmium",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B50,IF($G$6=WW,'Wood emission factors'!C50,IF($G$6=DW,'Wood emission factors'!D50,IF($G$6=AWT,'Wood emission factors'!E50)))))","v":0},0,0]
[null,"Chromium",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B51,IF($G$6=WW,'Wood emission factors'!C51,IF($G$6=DW,'Wood emission factors'!D51,IF($G$6=AWT,'Wood emission factors'!E51)))))","v":0},0,0]
[null,"Chromium (VI)",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B52,IF($G$6=WW,'Wood emission factors'!C52,IF($G$6=DW,'Wood emission factors'!D52,IF($G$6=AWT,'Wood emission factors'!E52)))))","v":0},0,0]
[null,"Cobalt",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B53,IF($G$6=WW,'Wood emission factors'!C53,IF($G$6=DW,'Wood emission factors'!D53,IF($G$6=AWT,'Wood emission factors'!E53)))))","v":0},0,0]
[null,"Manganese",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B54,IF($G$6=WW,'Wood emission factors'!C54,IF($G$6=DW,'Wood emission factors'!D54,IF($G$6=AWT,'Wood emission factors'!E54)))))","v":0},0,0]
[null,"Mercury",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B55,IF($G$6=WW,'Wood emission factors'!C55,IF($G$6=DW,'Wood emission factors'!D55,IF($G$6=AWT,'Wood emission factors'!E55)))))","v":0},0,0]
[null,"Nickel",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B56,IF($G$6=WW,'Wood emission factors'!C56,IF($G$6=DW,'Wood emission factors'!D56,IF($G$6=AWT,'Wood emission factors'!E56)))))","v":0},0,0]
[null,"Selenium",null,null,null,null,{"$f":"IF($G$6=Choose_one,0,IF($G$6=BBW,'Wood emission factors'!B57,IF($G$6=WW,'Wood emission factors'!C57,IF($G$6=DW,'Wood emission factors'!D57,IF($G$6=AWT,'Wood emission factors'!E57)))))","v":0},0,0]
[null,null,null,null,null,"HAP total",null,{"$f":"SUM(H34:H70)","v":0},{"$f":"SUM(I34:I70)","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":"Potential emissions","index":8,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,1,0,8],[62,1,63,8],[64,1,64,8],[1,1,1,8],[2,1,2,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],[19,1,19,6]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"Potential emissions: Boilers, furnaces, and space heaters"]
[null,{"$f":"IF('Data validation'!B29=\"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,"Pollutant","Natural Gas","Propane","Fuel Oil","Waste Oil","Wood","Potential Emissions","Permitting Threshold"]
[]
[null,null,"(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)","(ton/yr)"]
[null,"Criteria Air Pollutants",{"$f":"IF('Natural gas'!J17=6,\"Insignificant\",0)","v":"Insignificant"},{"$f":"IF(Propane!J18=6,\"Insignificant\",\" \")","v":"Insignificant"},{"$f":"IF('Fuel oil'!J20=6,\"Insignificant\",\" \")","v":"Insignificant"},{"$f":"IF('Waste oil'!J20=6,\"Insignificant\",\" \")","v":"Insignificant"},{"$f":"IF(Wood!J19=6,\"Insignificant\",\" \")","v":"Insignificant"}]
[null,"PM",{"$f":"'Natural gas'!H18","v":0},{"$f":"Propane!H19","v":0},{"$f":"'Fuel oil'!H21","v":0},{"$f":"'Waste oil'!H21","v":0},{"$f":"Wood!H20","v":0},{"$f":"SUM(C8:G8)","v":0},100]
[null,"PM10",{"$f":"'Natural gas'!H19","v":0},{"$f":"Propane!H20","v":0},{"$f":"'Fuel oil'!H22","v":0},{"$f":"'Waste oil'!H22","v":0},{"$f":"Wood!H21","v":0},0,25]
[null,"PM2.5",{"$f":"'Natural gas'!H20","v":0},{"$f":"Propane!H21","v":0},{"$f":"'Fuel oil'!H23","v":0},{"$f":"'Waste oil'!H23","v":0},{"$f":"Wood!H22","v":0},0,100]
[null,"SOx",{"$f":"'Natural gas'!H21","v":0},{"$f":"Propane!H22","v":0},{"$f":"'Fuel oil'!H24","v":0},{"$f":"'Waste oil'!H24","v":0},{"$f":"Wood!H23","v":0},0,50]
[null,"NOx",{"$f":"'Natural gas'!H22","v":0},{"$f":"Propane!H23","v":0},{"$f":"'Fuel oil'!H25","v":0},{"$f":"'Waste oil'!H25","v":0},{"$f":"Wood!H24","v":0},0,100]
[null,"VOC",{"$f":"'Natural gas'!H23","v":0},{"$f":"Propane!H24","v":0},{"$f":"'Fuel oil'!H26","v":0},{"$f":"'Waste oil'!H26","v":0},{"$f":"Wood!H25","v":0},0,100]
[null,"CO",{"$f":"'Natural gas'!H24","v":0},{"$f":"Propane!H25","v":0},{"$f":"'Fuel oil'!H27","v":0},{"$f":"'Waste oil'!H27","v":0},{"$f":"Wood!H26","v":0},0,100]
[null,"Lead",{"$f":"'Natural gas'!H25","v":0},{"$f":"Propane!H26","v":0},{"$f":"'Fuel oil'!H28","v":0},{"$f":"'Waste oil'!H28","v":0},{"$f":"Wood!H27","v":0},0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",{"$f":"'Natural gas'!H27","v":0},{"$f":"Propane!H28","v":0},{"$f":"'Fuel oil'!H30","v":0},{"$f":"'Waste oil'!H30","v":0},{"$f":"Wood!H29","v":0},{"$f":"SUM(C17:G17)","v":0}]
[null,"CH4",{"$f":"'Natural gas'!H28","v":0},{"$f":"Propane!H29","v":0},{"$f":"'Fuel oil'!H31","v":0},{"$f":"'Waste oil'!H31","v":0},{"$f":"Wood!H30","v":0},{"$f":"SUM(C18:G18)","v":0}]
[null,"N2O",{"$f":"'Natural gas'!H29","v":0},{"$f":"Propane!H30","v":0},{"$f":"'Fuel oil'!H32","v":0},{"$f":"'Waste oil'!H32","v":0},{"$f":"Wood!H31","v":0},{"$f":"SUM(C19:G19)","v":0}]
[null,"GHG total CO2e",null,null,null,null,null,{"$f":"(H17*1)+(H18*25)+(H19*298)","v":0},100000]
[null,"Hazardous Air Pollutants"]
[null,"Acetaldehyde",null,null,null,null,{"$f":"Wood!H34","v":0},{"$f":"SUM(C22:G22)","v":0}]
[null,"Acetophenone",null,null,null,null,{"$f":"Wood!H35","v":0},0]
[null,"Acrolein",null,null,null,null,{"$f":"Wood!H36","v":0},0]
[null,"Benzene",{"$f":"'Natural gas'!H32","v":0},{"$f":"Propane!H33","v":0},{"$f":"'Fuel oil'!H35","v":" "},null,{"$f":"Wood!H37","v":0},0]
[null,"Bis(2-ethylhexyl)phthalate",null,null,null,null,{"$f":"Wood!H38","v":0},0]
[null,"Carbon tetrachloride",null,null,null,null,{"$f":"Wood!H39","v":0},0]
[null,"Chlorine",null,null,null,null,{"$f":"Wood!H40","v":0},0]
[null,"2-Chloroacetophenone",null,null,null,null,{"$f":"Wood!H41","v":0},0]
[null,"Chlorobenzene",null,null,null,null,{"$f":"Wood!H42","v":0},0]
[null,"Chloroform",null,null,null,null,{"$f":"Wood!H43","v":0},0]
[null,"2,4-Dinitrotoluene",null,null,null,null,{"$f":"Wood!H44","v":0},0]
[null,"Ethyl benzene",null,null,{"$f":"'Fuel oil'!H36","v":" "},null,{"$f":"Wood!H45","v":0},0]
[null,"Ethylene dibromide",null,null,null,null,{"$f":"Wood!H46","v":0},0]
[null,"Ethylene dichloride",null,null,null,null,{"$f":"Wood!H47","v":0},0]
[null,"Formaldehyde",{"$f":"'Natural gas'!H33","v":0},{"$f":"Propane!H34","v":0},{"$f":"'Fuel oil'!H37","v":" "},null,{"$f":"Wood!H48","v":0},0]
[null,"Hexane",{"$f":"'Natural gas'!H34","v":0},{"$f":"Propane!H35","v":0},null,null,null,0]
[null,"Methylene chloride",null,null,null,null,{"$f":"Wood!H49","v":0},0]
[null,"Methyl chloroform",null,null,{"$f":"'Fuel oil'!H38","v":" "},null,{"$f":"Wood!H50","v":0},0]
[null,"Naphthalene",{"$f":"'Natural gas'!H35","v":0},{"$f":"Propane!H36","v":0},{"$f":"'Fuel oil'!H39","v":" "},{"$f":"'Waste oil'!H35","v":0},{"$f":"Wood!H51","v":0},0]
[null,"Phenol",null,null,null,null,{"$f":"Wood!H52","v":0},0]
[null,"Propionaldehyde",null,null,null,null,{"$f":"Wood!H53","v":0},0]
[null,"Styrene",null,null,null,null,{"$f":"Wood!H54","v":0},0]
[null,"2,3,7,8-Tetrachlorodibenzo-p-dioxin",null,null,null,null,{"$f":"Wood!H55","v":0},0]
[null,"2,4,6-Trichlorophenol",null,null,null,null,{"$f":"Wood!H56","v":0},0]
[null,"Toluene",{"$f":"'Natural gas'!H36","v":0},{"$f":"Propane!H37","v":0},{"$f":"'Fuel oil'!H40","v":" "},null,{"$f":"Wood!H57","v":0},0]
[null,"Vinyl acetate",null,null,null,null,{"$f":"Wood!H58","v":0},0]
[null,"o-Xylene",null,null,{"$f":"'Fuel oil'!H41","v":" "},null,{"$f":"Wood!H59","v":0},{"$f":"SUM(C48:G48)","v":0}]
[null,"Antimony",null,null,{"$f":"'Fuel oil'!H42","v":" "},null,{"$f":"Wood!H60","v":0},0]
[null,"Arsenic",{"$f":"'Natural gas'!H37","v":0},{"$f":"Propane!H38","v":0},{"$f":"'Fuel oil'!H43","v":" "},{"$f":"'Waste oil'!H36","v":0},{"$f":"Wood!H61","v":0},0]
[null,"Beryllium",{"$f":"'Natural gas'!H38","v":0},{"$f":"Propane!H39","v":0},{"$f":"'Fuel oil'!H44","v":" "},null,{"$f":"Wood!H62","v":0},0]
[null,"Cadmium",{"$f":"'Natural gas'!H39","v":0},{"$f":"Propane!H40","v":0},{"$f":"'Fuel oil'!H45","v":" "},{"$f":"'Waste oil'!H37","v":0},{"$f":"Wood!H63","v":0},0]
[null,"Chromium",{"$f":"'Natural gas'!H40","v":0},{"$f":"Propane!H41","v":0},{"$f":"'Fuel oil'!H46","v":" "},{"$f":"'Waste oil'!H38","v":0},{"$f":"Wood!H64","v":0},0]
[null,"Chromium (VI)",null,null,{"$f":"'Fuel oil'!H47","v":" "},null,{"$f":"Wood!H65","v":0},0]
[null,"Cobalt",{"$f":"'Natural gas'!H41","v":0},{"$f":"Propane!H42","v":0},{"$f":"'Fuel oil'!H48","v":" "},{"$f":"'Waste oil'!H39","v":0},{"$f":"Wood!H66","v":0},0]
[null,"Manganese",{"$f":"'Natural gas'!H42","v":0},{"$f":"Propane!H43","v":0},{"$f":"'Fuel oil'!H49","v":" "},{"$f":"'Waste oil'!H40","v":0},{"$f":"Wood!H67","v":0},0]
[null,"Mercury",{"$f":"'Natural gas'!H43","v":0},{"$f":"Propane!H44","v":0},{"$f":"'Fuel oil'!H50","v":" "},null,{"$f":"Wood!H68","v":0},0]
[null,"Nickel",{"$f":"'Natural gas'!H44","v":0},{"$f":"Propane!H45","v":0},{"$f":"'Fuel oil'!H51","v":" "},{"$f":"'Waste oil'!H41","v":0},{"$f":"Wood!H69","v":0},0]
[null,"Selenium",{"$f":"'Natural gas'!H45","v":0},{"$f":"Propane!H46","v":0},{"$f":"'Fuel oil'!H52","v":" "},null,{"$f":"Wood!H70","v":0},0]
[null,"HAP Indiv. Max",null,null,null,null,null,{"$f":"MAX(H22:H59)","v":0},10]
[null,"HAP total",null,null,null,null,null,{"$f":"SUM(H22:H59)","v":0},25]
[null,"1 Xylenes (total) includes emission factors listed as o-Xylene."]
[null,{"$f":"IF(OR(H60>=10,H61>=25),\"Your potential air emissions of a single HAP or total of all HAPs has exceeded permitting thresholds. You are a major source of HAPs: see the industrial, commercial, and institutional boilers and process heaters below. (40 CFR 63, supb. DDDDD)\",\"\")","v":""}]
[]
[null,{"$f":"IF(OR(H60>=10,H61>=25),\"https://www.epa.gov/stationary-sources-air-pollution/industrial-commercial-and-institutional-boilers-and-process-heaters\",\"\")","v":""}]

{"sheet":"Actual emissions","index":9,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[19,1,19,6],[1,1,1,8],[2,1,2,8],[0,1,0,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!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"Actual emissions: Boilers, funaces, and space heaters"]
[null,{"$f":"IF('Data validation'!B32=\"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","Natural Gas","Propane","Fuel Oil","Waste Oil","Wood","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":"'Natural gas'!I18","v":0},{"$f":"Propane!I19","v":0},{"$f":"'Fuel oil'!I21","v":0},{"$f":"'Waste oil'!I21","v":0},{"$f":"Wood!I20","v":0},{"$f":"SUM(C8:G8)","v":0},50]
[null,"PM10",{"$f":"'Natural gas'!I19","v":0},{"$f":"Propane!I20","v":0},{"$f":"'Fuel oil'!I22","v":0},{"$f":"'Waste oil'!I22","v":0},{"$f":"Wood!I21","v":0},0,50]
[null,"PM2.5",{"$f":"'Natural gas'!I20","v":0},{"$f":"Propane!I21","v":0},{"$f":"'Fuel oil'!I23","v":0},{"$f":"'Waste oil'!I23","v":0},{"$f":"Wood!I22","v":0},0]
[null,"SOx",{"$f":"'Natural gas'!I21","v":0},{"$f":"Propane!I22","v":0},{"$f":"'Fuel oil'!I24","v":0},{"$f":"'Waste oil'!I24","v":0},{"$f":"Wood!I23","v":0},0,50]
[null,"NOx",{"$f":"'Natural gas'!I22","v":0},{"$f":"Propane!I23","v":0},{"$f":"'Fuel oil'!I25","v":0},{"$f":"'Waste oil'!I25","v":0},{"$f":"Wood!I24","v":0},0,50]
[null,"VOC",{"$f":"'Natural gas'!I23","v":0},{"$f":"Propane!I24","v":0},{"$f":"'Fuel oil'!I26","v":0},{"$f":"'Waste oil'!I26","v":0},{"$f":"Wood!I25","v":0},0,50]
[null,"CO",{"$f":"'Natural gas'!I24","v":0},{"$f":"Propane!I25","v":0},{"$f":"'Fuel oil'!I27","v":0},{"$f":"'Waste oil'!I27","v":0},{"$f":"Wood!I26","v":0},0,50]
[null,"Lead",{"$f":"'Natural gas'!I25","v":0},{"$f":"Propane!I26","v":0},{"$f":"'Fuel oil'!I28","v":0},{"$f":"'Waste oil'!I28","v":0},{"$f":"Wood!I27","v":0},0,0.5]
[null,"Greenhouse Gas Emissions "]
[null,"CO2",{"$f":"'Natural gas'!I27","v":0},{"$f":"Propane!I28","v":0},{"$f":"'Fuel oil'!I30","v":0},{"$f":"'Waste oil'!I30","v":0},{"$f":"Wood!I29","v":0},{"$f":"SUM(C17:G17)","v":0}]
[null,"CH4",{"$f":"'Natural gas'!I28","v":0},{"$f":"Propane!I29","v":0},{"$f":"'Fuel oil'!I31","v":0},{"$f":"'Waste oil'!I31","v":0},{"$f":"Wood!I30","v":0},{"$f":"SUM(C18:G18)","v":0}]
[null,"N2O",{"$f":"'Natural gas'!I29","v":0},{"$f":"Propane!I30","v":0},{"$f":"'Fuel oil'!I32","v":0},{"$f":"'Waste oil'!I32","v":0},{"$f":"Wood!I31","v":0},{"$f":"SUM(C19:G19)","v":0}]
[null,"GHG total CO2e",null,null,null,null,null,{"$f":"(H17*1)+(H18*25)+(H19*298)","v":0},50000]
[null,"Hazardous Air Pollutants"]
[null,"Acetaldehyde",null,null,null,null,{"$f":"Wood!I34","v":0},{"$f":"SUM(C22:G22)","v":0}]
[null,"Acetophenone",null,null,null,null,{"$f":"Wood!I35","v":0},0]
[null,"Acrolein",null,null,null,null,{"$f":"Wood!I36","v":0},0]
[null,"Benzene",{"$f":"'Natural gas'!I32","v":0},{"$f":"Propane!I33","v":0},{"$f":"'Fuel oil'!I35","v":" "},null,{"$f":"Wood!I37","v":0},0]
[null,"Bis(2-ethylhexyl)phthalate",null,null,null,null,{"$f":"Wood!I38","v":0},0]
[null,"Carbon tetrachloride",null,null,null,null,{"$f":"Wood!I39","v":0},0]
[null,"Chlorine",null,null,null,null,{"$f":"Wood!I40","v":0},0]
[null,"2-Chloroacetophenone",null,null,null,null,{"$f":"Wood!I41","v":0},0]
[null,"Chlorobenzene",null,null,null,null,{"$f":"Wood!I42","v":0},0]
[null,"Chloroform",null,null,null,null,{"$f":"Wood!I43","v":0},0]
[null,"2,4-Dinitrotoluene",null,null,null,null,{"$f":"Wood!I44","v":0},0]
[null,"Ethyl benzene",null,null,{"$f":"'Fuel oil'!I36","v":" "},null,{"$f":"Wood!I45","v":0},0]
[null,"Ethylene dibromide",null,null,null,null,{"$f":"Wood!I46","v":0},0]
[null,"Ethylene dichloride",null,null,null,null,{"$f":"Wood!I47","v":0},0]
[null,"Formaldehyde",{"$f":"'Natural gas'!I33","v":0},{"$f":"Propane!I34","v":0},{"$f":"'Fuel oil'!I37","v":" "},null,{"$f":"Wood!I48","v":0},0]
[null,"Hexane",{"$f":"'Natural gas'!I34","v":0},{"$f":"Propane!I35","v":0},null,null,null,0]
[null,"Methylene chloride",null,null,null,null,{"$f":"Wood!I49","v":0},0]
[null,"Methyl chloroform",null,null,{"$f":"'Fuel oil'!I38","v":" "},null,{"$f":"Wood!I50","v":0},0]
[null,"Naphthalene",{"$f":"'Natural gas'!I35","v":0},{"$f":"Propane!I36","v":0},{"$f":"'Fuel oil'!I39","v":" "},{"$f":"'Waste oil'!I35","v":0},{"$f":"Wood!I51","v":0},0]
[null,"Phenol",null,null,null,null,{"$f":"Wood!I52","v":0},0]
[null,"Propionaldehyde",null,null,null,null,{"$f":"Wood!I53","v":0},0]
[null,"Styrene",null,null,null,null,{"$f":"Wood!I54","v":0},0]
[null,"2,3,7,8-Tetrachlorodibenzo-p-dioxin",null,null,null,null,{"$f":"Wood!I55","v":0},0]
[null,"2,4,6-Trichlorophenol",null,null,null,null,{"$f":"Wood!I56","v":0},0]
[null,"Toluene",{"$f":"'Natural gas'!I36","v":0},{"$f":"Propane!I37","v":0},{"$f":"'Fuel oil'!I40","v":" "},null,{"$f":"Wood!I57","v":0},0]
[null,"Vinyl acetate",null,null,null,null,{"$f":"Wood!I58","v":0},0]
[null,"o-Xylene",null,null,{"$f":"'Fuel oil'!I41","v":" "},null,{"$f":"Wood!I59","v":0},0]
[null,"Antimony",null,null,{"$f":"'Fuel oil'!I42","v":" "},null,{"$f":"Wood!I60","v":0},0]
[null,"Arsenic",{"$f":"'Natural gas'!I37","v":0},{"$f":"Propane!I38","v":0},{"$f":"'Fuel oil'!I43","v":" "},{"$f":"'Waste oil'!I36","v":0},{"$f":"Wood!I61","v":0},0]
[null,"Beryllium",{"$f":"'Natural gas'!I38","v":0},{"$f":"Propane!I39","v":0},{"$f":"'Fuel oil'!I44","v":" "},null,{"$f":"Wood!I62","v":0},0]
[null,"Cadmium",{"$f":"'Natural gas'!I39","v":0},{"$f":"Propane!I40","v":0},{"$f":"'Fuel oil'!I45","v":" "},{"$f":"'Waste oil'!I37","v":0},{"$f":"Wood!I63","v":0},0]
[null,"Chromium",{"$f":"'Natural gas'!I40","v":0},{"$f":"Propane!I41","v":0},{"$f":"'Fuel oil'!I46","v":" "},{"$f":"'Waste oil'!I38","v":0},{"$f":"Wood!I64","v":0},0]
[null,"Chromium (VI)",null,null,{"$f":"'Fuel oil'!I47","v":" "},null,{"$f":"Wood!I65","v":0},0]
[null,"Cobalt",{"$f":"'Natural gas'!I41","v":0},{"$f":"Propane!I42","v":0},{"$f":"'Fuel oil'!I48","v":" "},{"$f":"'Waste oil'!I39","v":0},{"$f":"Wood!I66","v":0},0]
[null,"Manganese",{"$f":"'Natural gas'!I42","v":0},{"$f":"Propane!I43","v":0},{"$f":"'Fuel oil'!I49","v":" "},{"$f":"'Waste oil'!I40","v":0},{"$f":"Wood!I67","v":0},0]
[null,"Mercury",{"$f":"'Natural gas'!I43","v":0},{"$f":"Propane!I44","v":0},{"$f":"'Fuel oil'!I50","v":" "},null,{"$f":"Wood!I68","v":0},0]
[null,"Nickel",{"$f":"'Natural gas'!I44","v":0},{"$f":"Propane!I45","v":0},{"$f":"'Fuel oil'!I51","v":" "},{"$f":"'Waste oil'!I41","v":0},{"$f":"Wood!I69","v":0},0]
[null,"Selenium",{"$f":"'Natural gas'!I45","v":0},{"$f":"Propane!I46","v":0},{"$f":"'Fuel oil'!I52","v":" "},null,{"$f":"Wood!I70","v":0},{"$f":"SUM(C59:G59)","v":0}]
[null,"HAP Indiv. Max",null,null,null,null,null,{"$f":"MAX(H22:H59)","v":0},5]
[null,"HAP total",null,null,null,null,null,{"$f":"SUM(H22:H59)","v":0},12.5]
[null,"1 Xylenes (total) includes emission factors listed as o-Xylene."]

{"sheet":"Permits & requirements","index":10,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[31,2,32,8],[33,1,35,8],[36,1,37,8],[5,1,5,8],[28,1,28,2],[28,3,28,4],[29,2,29,8],[30,2,30,8],[9,4,11,4],[17,3,20,3],[17,4,20,4],[17,7,20,7],[15,4,16,4],[17,1,20,1],[17,2,20,2],[17,8,20,8],[0,1,0,8],[1,1,1,8],[2,1,4,8],[7,5,16,8],[8,1,8,4],[15,1,16,1],[9,1,11,1],[9,2,11,2],[15,2,16,2],[15,3,16,3],[9,3,11,3],[7,1,7,4],[12,1,14,1],[12,2,14,2],[12,3,14,3],[12,4,14,4],[17,5,20,6],[21,4,26,4],[22,7,24,7],[22,8,24,8],[25,7,26,7],[25,8,26,8],[21,5,21,6],[22,5,22,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[23,5,23,6]]}
[null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
[null,"Permits and requirements"]
[null,"The need for a permit is based on your entire facility's potential air emissions. All activities that put pollutants into the air (including paint and solvent use, woodworking, or metalworking) need to be assessed in addition to your heating units. 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 a recommendation based on the information entered into this calculator and is not a regulatory 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 the information you entered in blue tabs. "]
[null,"Your facility's potential emissions from boilers","Your facility's \nactual emissions from boilers","A federal NSPS for boilers","A federal NESHAP for boilers"]
[]
[]
[null,{"$f":"IF('Data validation'!B29=\"yes\",\"does\",\"does not\")","v":"does not"},{"$f":"IF('Data validation'!B32=\"yes\",\"does\",\"does not\")","v":"does not"},{"$f":"IF('Federal standards'!N16=\"Yes\",\"does\",IF('Federal standards'!N16=\"No\",\"does not\",IF('Federal standards'!N16=\"Choose Y/N\",\"Return to federal standards tab (choose Y/N)\")))","v":"Return to federal standards tab (choose Y/N)"},{"$f":"IF('Federal standards'!N28=\"Yes\",\"does\",IF('Federal standards'!N28=\"No\",\"does not\",IF('Federal standards'!N28=\"Choose Y/N\",\"Return to federal standards tab (choose Y/N)\")))","v":"Return to federal standards tab (choose Y/N)"}]
[]
[]
[null,"exceed permit thresholds","exceed Option D limits","apply to your business","apply to your business"]
[]
[null,"Potential emissions from boilers exceeds permit thresholds","Actual emissions from boilers exceeds Option D limits","Federal NSPS for boilers applies?","Federal NESHAP for boilers 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 forms"]
[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"]
[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. "]

{"sheet":"Fuel oil emission factors","index":11,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,0,1,8],[0,0,0,8],[2,1,2,8],[69,1,69,3],[54,1,54,2],[55,1,55,3],[3,5,3,8],[3,1,3,4]]}
[{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
["Emission factors - Fuel oil"]
[null,"Factors from AP-42 Chapter 1.3 Fuel Oil Combustion, May 2010"]
[null,"Distillate Oil",null,null,null,"Residual Oil"]
["Choose one","Fuel Oil No. 1",null,"Fuel Oil No. 2",null,"Fuel Oil No. 5",null,"Fuel Oil No. 6"]
[null,"Commercial","Industrial","Commercial","Industrial","Commercial","Industrial","Commercial","Industrial"]
["Source","Assume No. 1 = No. 2","Assume No. 1 = No. 2","Table 1.3-1 <100 MMBtu","Table 1.3-6","Table 1.3-7","Table 1.3-5","Table 1.3-7","Table 1.5-5"]
["Units","lb/gal","lb/gal","lb/gal","lb/gal","lb/gal","lb/gal","lb/gal","lb/gal"]
["PM",{"$f":"(8.34*0.24)/1000","v":2.0015999999999996E-3},{"$f":"2/1000","v":2E-3},{"$f":"(8.34*0.24)/1000","v":2.0015999999999996E-3},{"$f":"2/1000","v":2E-3},{"$f":"(8.34*1.2)/1000","v":1.0008E-2},{"$f":"(8.34*1.2)/1000","v":1.0008E-2},{"$f":"(8.34*(1.12*('Fuel oil'!$G$11)+0.37))/1000","v":3.5528399999999998E-3},{"$f":"(8.34*(1.12*('Fuel oil'!$G$11)+0.37))/1000","v":3.5528399999999998E-3}]
["PM10",{"$f":"(5.17*0.24)/1000","v":1.2407999999999998E-3},{"$f":"1/1000","v":1E-3},{"$f":"(5.17*0.24)/1000","v":1.2407999999999998E-3},{"$f":"1/1000","v":1E-3},{"$f":"(5.17*1.2)/1000","v":6.2039999999999994E-3},{"$f":"(7.17*1.2)/1000","v":8.6039999999999988E-3},{"$f":"(5.17*(1.12*('Fuel oil'!$G$11)+0.37))/1000","v":2.2024200000000001E-3},{"$f":"(7.17*(1.12*('Fuel oil'!$G$11)+0.37))/1000","v":3.05442E-3}]
["PM2.5",{"$f":"(1.92*0.24)/1000","v":4.6079999999999998E-4},{"$f":"0.25/1000","v":2.5000000000000001E-4},{"$f":"(1.92*0.24)/1000","v":4.6079999999999998E-4},{"$f":"0.25/1000","v":2.5000000000000001E-4},{"$f":"(1.92*1.2)/1000","v":2.3039999999999996E-3},{"$f":"(4.67*1.2)/1000","v":5.6040000000000005E-3},{"$f":"(1.92*(1.12*('Fuel oil'!$G$11)+0.37))/1000","v":8.1791999999999998E-4},{"$f":"(4.67*(1.12*('Fuel oil'!$G$11)+0.37))/1000","v":1.98942E-3}]
[]
[]
[null,"Fuel Oil No. 1",null,"Fuel Oil No. 2",null,"Fuel Oil No. 5",null,"Fuel Oil No. 6"]
["Source","Table 1.3-1 <100 MMBtu",null,"Table 1.3-1 <100 MMBtu",null,"Table 1.3-1 <100 MMBtu",null,"Table 1.3-1 <100 MMBtu"]
["Units","lb/gal",null,"lb/gal",null,"lb/gal",null,"lb/gal"]
["SOx1",{"$f":"(142*'Fuel oil'!$G$11)/1000","v":7.1000000000000004E-3},null,{"$f":"(142*'Fuel oil'!$G$11)/1000","v":7.1000000000000004E-3},null,{"$f":"(157*'Fuel oil'!$G$11)/1000","v":7.8500000000000011E-3},null,{"$f":"(157*'Fuel oil'!$G$11)/1000","v":7.8500000000000011E-3}]
["NOx",{"$f":"20/1000","v":0.02},null,{"$f":"20/1000","v":0.02},null,{"$f":"55/1000","v":5.5E-2},null,{"$f":"55/1000","v":5.5E-2}]
["VOC",{"$f":"0.2/1000","v":2.0000000000000001E-4},null,{"$f":"0.2/1000","v":2.0000000000000001E-4},null,{"$f":"0.28/1000","v":2.8000000000000003E-4},null,{"$f":"0.28/1000","v":2.8000000000000003E-4}]
["CO",{"$f":"5/1000","v":5.0000000000000001E-3},null,{"$f":"5/1000","v":5.0000000000000001E-3},null,{"$f":"5/1000","v":5.0000000000000001E-3},null,{"$f":"5/1000","v":5.0000000000000001E-3}]
["Lead",{"$f":"(9*10^(-12))/1000","v":8.9999999999999995E-15},null,{"$f":"(9*10^(-12))/1000","v":8.9999999999999995E-15},null,{"$f":"H21","v":1.5100000000000002E-6},null,{"$f":"0.00151/1000","v":1.5100000000000002E-6}]
["Source","See table below",null,"See table below",null,"See table below",null,"See table below"]
["CO2",{"$f":"B66","v":22.399850000000001},null,{"$f":"B67","v":22.454256000000004},null,{"$f":"B68","v":22.462440000000008},null,{"$f":"B69","v":24.783000000000005}]
["CH4",{"$f":"C66","v":9.1740000000000007E-4},null,{"$f":"C67","v":9.1080000000000002E-4},null,{"$f":"C68","v":9.2400000000000013E-4},null,{"$f":"C69","v":9.8999999999999999E-4}]
["N2O",{"$f":"D61","v":6.0000000000000001E-3},null,{"$f":"D67","v":1.8216E-3},null,{"$f":"D68","v":1.8480000000000003E-3},null,{"$f":"D69","v":1.98E-3}]
["Source","Assume = Residual",null,"Assume = Residual",null,"Table 1.3-9",null,"Table 1.3-9"]
["Benzene",{"$f":"F27","v":2.1400000000000001E-7},null,{"$f":"B27","v":2.1400000000000001E-7},null,{"$f":"H27","v":2.1400000000000001E-7},null,{"$f":"0.000214/1000","v":2.1400000000000001E-7}]
["Ethylbenzene",6.36E-8,null,6.36E-8,null,6.36E-8,null,{"$f":"0.0000636/1000","v":6.36E-8}]
["Formaldehyde",3.3000000000000003E-5,null,3.3000000000000003E-5,null,3.3000000000000003E-5,null,{"$f":"0.033/1000","v":3.3000000000000003E-5}]
["Methyl chloroform",{"$f":"F30","v":2.36E-7},null,{"$f":"B30","v":2.36E-7},null,{"$f":"H30","v":2.36E-7},null,{"$f":"0.000236/1000","v":2.36E-7}]
["Naphthalene",1.13E-6,null,1.13E-6,null,1.13E-6,null,{"$f":"0.00113/1000","v":1.13E-6}]
["Toluene",6.1999999999999999E-6,null,6.1999999999999999E-6,null,6.1999999999999999E-6,null,{"$f":"0.0062/1000","v":6.1999999999999999E-6}]
["o-Xylene",1.0900000000000001E-7,null,1.0900000000000001E-7,null,1.0900000000000001E-7,null,{"$f":"0.000109/1000","v":1.0900000000000001E-7}]
["Source","Table 1.3-10",null,"Table 1.3-10",null,"Assume = to Fuel Oil No 6",null,"Table 1.3-11"]
["Antimony",null,null,null,null,{"$f":"H35","v":5.2500000000000006E-6},null,{"$f":"0.00525/1000","v":5.2500000000000006E-6}]
["Arsenic",{"$f":"4*10^(-12)*C51","v":5.5599999999999995E-7},null,{"$f":"4*10^(-12)*C52","v":5.5199999999999997E-7},null,{"$f":"H36","v":1.3200000000000001E-6},null,{"$f":"0.00132/1000","v":1.3200000000000001E-6}]
["Beryllium",{"$f":"3*10^(-12)*C51","v":4.1700000000000004E-7},null,{"$f":"3*10^(-12)*C52","v":4.1400000000000003E-7},null,2.7800000000000001E-8,null,{"$f":"0.0000278/1000","v":2.7800000000000001E-8}]
["cadmium",{"$f":"3*10^(-12)*C51","v":4.1700000000000004E-7},null,{"$f":"3*10^(-12)*C52","v":4.1400000000000003E-7},null,3.9800000000000004E-7,null,{"$f":"0.000398/1000","v":3.9800000000000004E-7}]
["Chromium",{"$f":"3*10^(-12)*C51","v":4.1700000000000004E-7},null,{"$f":"3*10^(-12)*C52","v":4.1400000000000003E-7},null,8.4500000000000006E-7,null,{"$f":"0.000845/1000","v":8.4500000000000006E-7}]
["Chromium (VI)",null,null,null,null,2.48E-7,null,{"$f":"0.000248/1000","v":2.48E-7}]
["Cobalt",null,null,null,null,6.02E-6,null,{"$f":"0.00602/1000","v":6.02E-6}]
["Manganese",{"$f":"6*10^(-12)*C51","v":8.3400000000000008E-7},null,{"$f":"6*10^(-12)*C52","v":8.2800000000000006E-7},null,{"$f":"H42","v":3.0000000000000001E-6},null,{"$f":"0.003/1000","v":3.0000000000000001E-6}]
["Mercury",{"$f":"3*10^(-12)*C51","v":4.1700000000000004E-7},null,{"$f":"3*10^(-12)*C52","v":4.1400000000000003E-7},null,1.1299999999999999E-7,null,{"$f":"0.000113/1000","v":1.1299999999999999E-7}]
["Nickel",{"$f":"3*10^(-12)*C51","v":4.1700000000000004E-7},null,{"$f":"3*10^(-12)*C52","v":4.1400000000000003E-7},null,8.4500000000000008E-5,null,{"$f":"0.0845/1000","v":8.4500000000000008E-5}]
["Selenium",{"$f":"15*10^(-12)*C51","v":2.0849999999999999E-6},null,{"$f":"15*10^(-12)*C52","v":2.0700000000000001E-6},null,6.8299999999999996E-7,null,{"$f":"0.000683/1000","v":6.8299999999999996E-7}]
[1,"SOx emission factor given is multiplied by the sulfur content in the fuel in the blue Fuel Oil tab."]
[]
[]
["Heat Value","Heat Value1","Heat Value"]
[null,"mmBtu/gal","Btu/gal"]
["Fuel Oil No. 1",0.13900000000000001,{"$f":"B51*1000000","v":139000}]
["Fuel Oil No. 2",0.13800000000000001,{"$f":"B52*1000000","v":138000}]
["Fuel Oil No. 5",0.14000000000000001,{"$f":"B53*1000000","v":140000}]
["Fuel Oil No. 6",0.15,{"$f":"B54*1000000","v":150000}]
[1,"40 CFR 98, subp. C, Table C-1 and C-2"]
[2,"AP-42 Appendix A. weights of selected substances"]
[]
[]
["GHG 1","CO2","CH4","N2O "]
[null,"kg/MMBtu","kg/MMBtu","kg/MMBtu"]
["Fuel Oil No. 1",73.25,3.0000000000000001E-3,6.0000000000000001E-3]
["Fuel Oil No. 2",73.959999999999994,3.0000000000000001E-3,6.0000000000000001E-3]
["Fuel Oil No. 5",72.930000000000007,3.0000000000000001E-3,6.0000000000000001E-3]
["Fuel Oil No. 6",75.099999999999994,3.0000000000000001E-3,6.0000000000000001E-3]
[null,"lb/gal","lb/gal","lb/gal"]
["Fuel Oil No. 1",{"$f":"B61*C51/1000000*2.2","v":22.399850000000001},{"$f":"C61*C51/1000000*2.2","v":9.1740000000000007E-4},{"$f":"D61*C51/1000000*2.2","v":1.8348000000000001E-3}]
["Fuel Oil No. 2",{"$f":"B62*C52/1000000*2.2","v":22.454256000000004},{"$f":"C62*C52/1000000*2.2","v":9.1080000000000002E-4},{"$f":"D62*C52/1000000*2.2","v":1.8216E-3}]
["Fuel Oil No. 5",{"$f":"B63*C53/1000000*2.2","v":22.462440000000008},{"$f":"C63*C53/1000000*2.2","v":9.2400000000000013E-4},{"$f":"D63*C53/1000000*2.2","v":1.8480000000000003E-3}]
["Fuel Oil No. 6",{"$f":"B64*C54/1000000*2.2","v":24.783000000000005},{"$f":"C64*C54/1000000*2.2","v":9.8999999999999999E-4},{"$f":"D64*C54/1000000*2.2","v":1.98E-3}]
[1,"40 CFR 98, subp. C, Table C-1 and C-2"]

{"sheet":"Wood emission factors","index":12,"n_rows":129,"n_cols":9,"rows_kept":129,"cut":false,"hidden":false,"merged":[[1,0,1,4],[63,6,63,7],[76,6,76,8],[58,6,59,6],[64,1,64,3],[63,0,63,3],[58,5,59,5]]}
[null,null,null,null,{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
["Emission factors - Wood"]
["Factors from AP-42 Chapter 1.6 Wood Residue Combustion, Sept. 2003","Factors from AP-42 Chapter 1.6 Wood Residue Combustion, Sept. 2003"]
["Wood Type",{"$f":"BBW","v":"Bark or Bark with Wet Wood"},{"$f":"WW","v":"Wet Wood"},{"$f":"DW","v":"Dry Wood"},{"$f":"AWT","v":"All Wood Types"}]
["Moisture",0.5,0.4,0.2]
["Heat Value (Btu/ton)",{"$f":"D61","v":8740000},{"$f":"D62","v":10488000},{"$f":"D63","v":17480000},{"$f":"MIN(B6:D6)","v":8740000}]
["Units","lb/ton","lb/ton","lb/ton","lb/ton"]
["PM",{"$f":"B76*B$6/1000000","v":4.8944000000000001},3.4610400000000001,6.992,{"$f":"MAX(B8:D8)","v":6.992}]
["PM10",4.37,3.0415199999999998,6.2927999999999997,{"$f":"MAX(B9:D9)","v":6.2927999999999997}]
["PM2.5",3.7582,2.6219999999999999,5.4188000000000001,5.4188000000000001]
["SOx",0.2185,0.26219999999999999,0.437,0.437]
["NOx",1.9228000000000001,2.3073600000000001,8.5652000000000008,8.5652000000000008]
["VOC",0.14857999999999999,0.17829600000000001,0.29715999999999998,0.29715999999999998]
["CO",5.2439999999999998,6.2927999999999997,10.488,10.488]
["Lead",4.1952000000000005E-4,5.0342400000000004E-4,8.390400000000001E-4,8.390400000000001E-4]
["GHG (see GHG table)"]
["CO2",{"$f":"$G61/1000000*B$6*2.20462","v":1807.3739314399998},2168.8487177279999,3614.7478628799995,3614.7478628799995]
["CH4",0.13873232735999999,0.16647879283199998,0.27746465471999998,0.27746465471999998]
["N2O",6.9366163679999995E-2,8.3239396415999992E-2,0.13873232735999999,0.13873232735999999]
["HAPs (Table 1.6-3 and 4)"]
["Acetaldehyde",{"$f":"$B92*B$6/1000000","v":7.2541999999999997E-3},8.7050400000000007E-3,1.4508399999999999E-2,1.4508399999999999E-2]
["Acetophenone",2.7967999999999999E-8,3.3561600000000005E-8,5.5935999999999999E-8,5.5935999999999999E-8]
["Acrolein",3.4959999999999998E-2,4.1952000000000003E-2,6.9919999999999996E-2,6.9919999999999996E-2]
["Benzene",3.6707999999999998E-2,4.4049600000000001E-2,7.3415999999999995E-2,7.3415999999999995E-2]
["Bis(2-ethylhexyl)phthalate",4.1077999999999998E-7,4.9293600000000001E-7,8.2155999999999995E-7,8.2155999999999995E-7]
["Carbon tetrachloride",3.9330000000000002E-4,4.7196000000000006E-4,7.8660000000000004E-4,7.8660000000000004E-4]
["Chlorine",6.9046000000000003E-3,8.2855200000000011E-3,1.3809200000000001E-2,1.3809200000000001E-2]
["2-Chloroacetophenone",2.0976000000000002E-8,2.5171200000000002E-8,4.1952000000000004E-8,4.1952000000000004E-8]
["Chlorobenzene",2.4471999999999997E-4,2.9366400000000001E-4,4.8943999999999995E-4,4.8943999999999995E-4]
["Chloroform",2.0102000000000002E-4,2.4122399999999998E-4,4.0204000000000005E-4,4.0204000000000005E-4]
["2,4-Dinitrophenol",1.5732E-6,1.88784E-6,3.1464000000000001E-6,3.1464000000000001E-6]
["Ethyl benzene",2.7094E-4,3.2512799999999999E-4,5.4188000000000001E-4,5.4188000000000001E-4]
["Ethylene dibromide",2.5345999999999997E-3,3.0415199999999998E-3,5.0691999999999994E-3,5.0691999999999994E-3]
["Ethylene dichloride",2.8842000000000001E-4,3.4610400000000002E-4,5.7684000000000001E-4,5.7684000000000001E-4]
["Formaldehyde",3.8455999999999997E-2,4.6147200000000006E-2,7.6911999999999994E-2,7.6911999999999994E-2]
["Methylene chloride",{"$f":"$B109*B$6/1000000","v":2.0102000000000002E-4},{"$f":"$B109*C$6/1000000","v":2.4122399999999998E-4},{"$f":"$B109*D$6/1000000","v":4.0204000000000005E-4},4.0204000000000005E-4]
["Methyl chloroform",{"$f":"$B108*B$6/1000000","v":2.7094000000000003E-3},{"$f":"$B108*C$6/1000000","v":3.2512800000000001E-3},{"$f":"$B108*D$6/1000000","v":5.4188000000000005E-3},5.4188000000000005E-3]
["Naphthalene",{"$f":"$B110*B$6/1000000","v":8.4778000000000002E-4},1.017336E-3,1.69556E-3,1.69556E-3]
["Phenol",4.4574000000000003E-4,5.3488800000000007E-4,8.9148000000000005E-4,8.9148000000000005E-4]
["Propionaldehyde",5.3313999999999998E-4,6.3976799999999998E-4,1.06628E-3,1.06628E-3]
["Styrene",1.6605999999999999E-2,1.9927199999999999E-2,3.3211999999999998E-2,3.3211999999999998E-2]
["2,3,7,8-Tetrachlorodibenzo-p-dioxin",7.5163999999999998E-11,9.0196799999999997E-11,1.50328E-10,1.50328E-10]
["2,4,6-Trichlorophenol",1.9227999999999997E-7,2.3073600000000001E-7,3.8455999999999994E-7,3.8455999999999994E-7]
["Toluene",8.0408000000000007E-3,9.6489600000000016E-3,1.6081600000000001E-2,1.6081600000000001E-2]
["Vinyl chloride",1.5731999999999999E-4,1.88784E-4,3.1463999999999998E-4,3.1463999999999998E-4]
["o-Xylenes",2.185E-4,2.6219999999999998E-4,4.37E-4,4.37E-4]
["Antimony",6.9046000000000003E-5,8.2855200000000006E-5,1.3809200000000001E-4,1.3809200000000001E-4]
["Arsenic",1.9228E-4,2.3073599999999999E-4,3.8455999999999999E-4,3.8455999999999999E-4]
["Beryllium",9.6140000000000015E-6,1.1536800000000001E-5,1.9228000000000003E-5,1.9228000000000003E-5]
["Cadmium",3.5833999999999996E-5,4.3000799999999997E-5,7.1667999999999992E-5,7.1667999999999992E-5]
["Chromium",1.8353999999999999E-4,2.2024799999999998E-4,3.6707999999999999E-4,3.6707999999999999E-4]
["Chromium (VI)",3.0589999999999997E-5,3.6708000000000002E-5,6.1179999999999994E-5,6.1179999999999994E-5]
["Cobalt",5.6809999999999993E-5,6.8171999999999997E-5,1.1361999999999999E-4,1.1361999999999999E-4]
["Manganese",1.3984E-2,1.6780799999999998E-2,2.7968E-2,2.7968E-2]
["Mercury",3.0589999999999997E-5,3.6708000000000002E-5,6.1179999999999994E-5,6.1179999999999994E-5]
["Nickel",2.8842000000000001E-4,3.4610400000000002E-4,5.7684000000000001E-4,5.7684000000000001E-4]
["Selenium",2.4471999999999999E-5,2.9366399999999997E-5,4.8943999999999998E-5,4.8943999999999998E-5]
[]
["Heat Value","Heat Value1","Moisture Content","Heat Value",null,"GHG1","kg/MMBtu"]
[null,"MMBtu/ton","% by weight","Btu/ton"]
["Bark or Bark with Wet Wood",{"$f":"((100-C61)/100)*$B$63","v":8.74},50,{"$f":"B61*10^6","v":8740000},null,"CO2",93.8]
["Wet Wood",{"$f":"((100-C62)/100)*$B$63","v":10.488},40,{"$f":"B62*10^6","v":10488000},null,"CH4",7.1999999999999998E-3]
["Dry Wood",17.48,20,{"$f":"B63*10^6","v":17480000},null,"N2O",3.5999999999999999E-3]
["Formula to calculate on a wet basis = ( (100  −  Moisture content) / 100 ) * Heat Value on a dry basis (20%) ",null,null,null,null,1,"40 CFR 98, subp. C, Table C-1 and C-2"]
[1,"40 CFR 98, subp. C, Table C-1 and C-2"]
[]
[]
[]
["Emission Factors - Wood (lb/million Btu) "]
[null,"Factors from AP-42 Chapter 1.6 Wood Residue Combustion, Sept. 2003"]
["Wood Type","Bark or Bark with Wet Wood","Wet Wood","Dry Wood"]
["Moisture",0.5,0.4,0.2,null,"GHG1","CO2","CH4","N2O"]
["Heat Value (Btu/ton)",{"$f":"B6","v":8740000},{"$f":"C6","v":10488000},{"$f":"D6","v":17480000},null,null,"kg/MMBtu","kg/MMBtu","kg/MMBtu"]
["Control Type","Uncontrolled","Uncontrolled","Uncontrolled",null,"All Wood Types",93.8,7.1999999999999998E-3,3.5999999999999999E-3]
["Units","lb/MMBtu","lb/MMBtu","lb/MMBtu",null,null,"lb/MMBtu","lb/MMBtu","lb/MMBtu"]
["PM",0.56000000000000005,0.33,0.4,null,"All Wood Types",{"$f":"G74*1000*0.00220462","v":206.79335599999999},{"$f":"H74*1000*0.00220462","v":1.5873264000000002E-2},{"$f":"I74*1000*0.00220462","v":7.9366320000000008E-3}]
["PM10",0.5,0.28999999999999998,0.36,null,1,"40 CFR 98, subp. C, Table C-1 and C-2"]
["PM2.5",0.43,0.25,0.31]
["SOx",2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["NOx",0.22,0.22,0.49]
["VOC",1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2]
["CO",0.6,0.6,0.6]
["Lead",4.8000000000000001E-5,4.8000000000000001E-5,4.8000000000000001E-5]
[]
[null,"All Wood Types"]
["Units","lb/MMBtu"]
["Source","GHG table"]
["CO2",{"$f":"G76","v":206.79335599999999}]
["CH4",{"$f":"H76","v":1.5873264000000002E-2}]
["N2O",{"$f":"I76","v":7.9366320000000008E-3}]
["Source","Table 1.6-3 and 4"]
["Acetaldehyde",8.3000000000000001E-4]
["Acetophenone",3.2000000000000001E-9]
["Acrolein",4.0000000000000001E-3]
["Benzene",4.1999999999999997E-3]
["Bis(2-ethylhexyl)phthalate",4.6999999999999997E-8]
["Carbon tetrachloride",4.5000000000000003E-5]
["Chlorine",7.9000000000000001E-4]
["2-Chloroacetophenone",2.4E-9]
["Chlorobenzene",2.8E-5]
["Chloroform",2.3E-5]
["2,4-Dinitrophenol",1.8E-7]
["Ethyl benzene",3.1000000000000001E-5]
["Ethylene dibromide",2.9E-4]
["Ethylene dichloride",3.3000000000000003E-5]
["Formaldehyde",4.4000000000000003E-3]
["MEK",5.4E-6]
["Methyl chloroform",3.1E-4]
["Methylene chloride",2.3E-5]
["Naphthalene",9.7E-5]
["Phenol",5.1E-5]
["Propionaldehyde",6.0999999999999999E-5]
["Styrene",1.9E-3]
["2,3,7,8-Tetrachlorodibenzo-p-dioxin",8.5999999999999997E-12]
["2,4,6-Trichlorophenol",2.1999999999999998E-8]
["Toluene",9.2000000000000003E-4]
["Vinyl chloride",1.8E-5]
["o-Xylenes",2.5000000000000001E-5]
["Antimony",7.9000000000000006E-6]
["Arsenic",2.1999999999999999E-5]
["Beryllium",1.1000000000000001E-6]
["Cadmium",4.0999999999999997E-6]
["Chromium",2.0999999999999999E-5]
["Chromium (VI)",3.4999999999999999E-6]
["Cobalt",6.4999999999999996E-6]
["Manganese",1.6000000000000001E-3]
["Mercury",3.4999999999999999E-6]
["Nickel",3.3000000000000003E-5]
["Selenium",2.7999999999999999E-6]

{"sheet":"Data validation","index":13,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
[{"$f":"Instructions!F3","v":"p-sbap5-21  •  6/5/23"}]
["Data validation"]
[]
["Acutal emission entries:","Options for fuel types:"]
["Natural Gas","Fuel Oil"]
["Choose one","Choose one"]
["hours were the units operated?","Fuel Oil No. 1"]
["cubic feet of natural gas were burned?","Fuel Oil No. 2"]
[null,"Fuel Oil No. 5"]
[null,"Fuel Oil No. 6"]
["Propane"]
["Choose one"]
["hours were the units operated?","Fuel Oil"]
["gallons of propane were burned?","Choose one"]
[null,{"$f":"FOcom","v":"Commercial"}]
[null,{"$f":"FOind","v":"Industrial"}]
["Fuel and Waste Oil"]
["Choose one"]
["hours were the units operated?","Wood and Control Type"]
["gallons of fuel were burned?","Choose one"]
[null,"Bark or Bark with Wet Wood"]
[null,"Dry Wood"]
["Wood","Wet Wood"]
["Choose one","All Wood Types"]
["hours were the units operated?"]
["tons of wood were burned?"]
[]
[null,"Potential Emissions Exceed"]
["Responses",{"$f":"IF(OR('Potential emissions'!H10>100,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'!H9>25,OR('Potential emissions'!H8>100,OR('Potential emissions'!H61>25,'Potential emissions'!H60>10))))))))),\"yes\",\"no\")","v":"no"}]
["Choose Y/N"]
["Yes","Actual Emissions Exceed"]
["No",{"$f":"IF(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.5,OR('Actual emissions'!H61>=12.5,'Actual emissions'!H60>=5))))))))),\"yes\",\"no\")","v":"no"}]
["Both"]
[]
[]
[]
[]
[]
[]
[]
[]
["Update "]
["ISSUE: the cells of some pollutants on the potential and actual emission tabs pulled from different pollutants in the natural gas, propane, fuel oil and waste oil tab."]
["This issue affects versions 2/13/2019 and 3/29/2021. "]
["The issue is corrected in the Feb 2022 version. "]