{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Dust control","Standards","Mechanical Finishing","Abrasive Blasting","Blasting charts","Data Validation"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":96,"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":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,2,8,14],[15,2,15,13],[18,2,18,13],[0,7,2,14],[26,2,26,3],[5,1,5,14],[14,1,14,14],[23,1,23,14],[16,2,16,14],[17,2,17,14],[24,1,24,13],[9,2,10,14],[19,2,19,13],[6,1,6,14],[29,1,29,3],[29,4,29,13],[20,2,20,14],[25,1,25,14],[26,5,26,8],[26,10,26,14],[27,2,27,3],[27,4,27,14]]}
[null,null,null,null,null,null,null,"Abrasive blasting \nAir emissions calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p-sbap5-19  •  6/5/23"]
[]
[null,"Instructions"]
[null,"1) Start with the grey tabs."]
[null,null,"\"Dust control\" tab. Regardless of the air emission calculation results and whether an air permit is required, you must take all reasonable measures to control dust and prevent the release of particulate matter from air-based blasting "]
[]
[null,null,"\"Standards\" tab. Find out if your abrasive blasting meets the criteria to qualify as an insignificant activity or a conditionally insignificant activity and whether a federal rule may apply to the business."]
[]
[null,"2) Using guidance from the \"Standards\" tab, continue to the blue tabs to calculate emissions."]
[]
[]
[null,"Color key"]
[null,"Blue","Enter information for your facility in the blue boxes."]
[null,"Orange","Orange boxes are filled with standard values. You can change them if you have test results that provide data specific to your site."]
[null,"White","Do not change the values or formulas in white boxes. White boxes contain intermediate calculations for determining emissions.  "]
[null,"Green","Your emission totals are in green boxes. These are automatically calculated based on information entered in blue boxes."]
[null,"Yellow","Permit and insignificant activity thresholds"]
[null,"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"]

{"sheet":"Dust control","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,2],[13,1,15,14],[8,2,9,14],[7,2,7,14],[18,1,18,14],[20,2,20,14],[19,2,19,14],[21,2,22,14],[0,1,0,14],[1,1,1,14],[6,1,6,14],[10,2,10,14],[11,2,11,14],[3,1,4,14]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-19  •  6/5/23"}]
[null,"Implementing dust control measures"]
[]
[null,"Regardless of the air emission calculation results and whether an air permit is required, you must take all reasonable measures to control dust and prevent the release of particulate matter from air-based blasting operations.1"]
[]
[]
[null,"Such measures may include:"]
[null,"▪ ","Permanent enclosures or temporary tenting over equipment being blasted or over the entire area "]
[null,"▪ ","Modified-wet blasting (adding only enough water to the air-based blasting stream to capture dust without causing the wetted dust to adhere to the surface being blasted)"]
[]
[null,"▪ ","Vacuum blasting (air-based blasting using a nozzle attachment and negative air pressure to capture dust) "]
[null,"▪ ","Other dust-control techniques"]
[]
[null,"Constantly monitor the effectiveness of your dust control measures. If dust is released into the air even with the measures you have implemented, you must take additional measures. If environmental conditions (such as high winds) prevent complete capture of particulate matter, you must stop blasting until conditions improve or you apply enough additional control measures to prevent a release."]
[]
[]
[null,null,"Fugitive dust emissions management and best practices"]
[]
[null,"In addition to preventing and controlling dusts, other regulatory requirements apply to:"]
[null,"▪ ","blasting a structure that may bear lead paint"]
[null,"▪ ","blasting a residence, school, or any building built before 1978 in which children are cared for"]
[null,"▪ ","blasting steel structures such as bridges, water towers, aboveground storage tanks, grain bins, truss towers, railroad cars, barges, and commercial vehicles/trucks"]
[]
[null,"▪ ","the management and disposal of blasting debris"]
[]
[null,null,"https://www.pca.state.mn.us/sites/default/files/w-hw4-39a.pdf"]
[]
[null,"1Minn. R. 7011.0150"]

{"sheet":"Standards","index":2,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[61,11,61,14],[54,11,54,14],[62,7,62,10],[62,11,62,14],[63,7,63,10],[63,11,63,14],[55,7,55,10],[55,11,55,14],[56,7,56,10],[56,11,56,14],[57,7,57,10],[57,11,57,14],[58,7,58,10],[58,11,58,14],[59,7,59,10],[59,11,59,14],[61,7,61,10],[32,2,33,12],[62,2,62,5],[63,2,63,5],[48,7,48,10],[48,11,48,14],[49,7,49,10],[49,11,49,14],[50,7,50,10],[50,11,50,14],[51,7,51,10],[51,11,51,14],[52,7,52,10],[52,11,52,14],[53,7,53,10],[53,11,53,14],[0,1,0,14],[1,1,1,14],[3,1,5,14],[42,12,42,14],[43,12,43,14],[38,1,38,14],[39,1,39,12],[40,1,40,12],[22,2,22,12],[28,2,28,12],[9,2,10,12],[7,1,7,14],[11,2,11,12],[16,2,18,13],[61,2,61,5],[60,7,60,10],[48,2,48,5],[41,12,41,14],[60,2,60,5],[60,11,60,14],[49,2,49,5],[50,2,50,5],[51,2,51,5],[57,2,57,5],[58,2,58,5],[59,2,59,5],[54,2,54,5],[55,2,55,5],[54,7,54,10],[46,1,46,14],[56,2,56,5],[34,2,34,12],[47,1,47,14],[52,2,52,5],[53,2,53,5],[41,2,41,9],[34,13,34,14],[9,13,11,14],[25,13,29,14],[37,1,37,14],[12,2,12,12],[12,13,14,14],[13,3,13,12],[14,3,14,12],[22,13,23,14],[26,2,27,12],[31,1,31,14],[23,3,25,12],[32,13,33,14]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-19  •  6/5/23"}]
[null,"Regulations and requirements"]
[]
[null,"The need for a permit is based on your entire business's potential air emissions. All activities that put pollutants into the air (such as painting, wood working, metalworking, and fuel use) need to be assessed. Once you identify if you need a permit, based on the total potential emissions from your business and whether an NSPS applies, you can then use your actual emissions to see which permit is the best fit for your business."]
[]
[]
[]
[null,"MPCA standards"]
[null,"Insignificant activity if it meets one of the following:"]
[null,"▪ ","Abrasive blasting is part of routine housekeeping or facility maintenance and not associated with your primary manufacturing or processes.",null,null,null,null,null,null,null,null,null,null,"Minn. R. 7007.1300, subp. 2"]
[]
[null,"▪ ","Abrasives are suspended in water or sponge media."]
[null,"▪ ","The potential amount of particulate matter air emissions is 1 ton or less. ",null,null,null,null,null,null,null,null,null,null,"Minn. R. 7007.1300, subp. 3"]
[null,null,"▪ ","Potential means that the abrasive blasting is operating at the maximum possible rate, 24 hours-a-day."]
[null,null,"▪ ","Calculate potential emissions using the Abrasive Blasting tab."]
[]
[null,null,"Minn. R. 7007.1300 was modified and became effective January 14, 2019.  Qualifying for an insignificant activity no longer includes processing equipment that emits particulate matter that is vented indoors 100% of the time and does not use air filtering systems used to control indoor air emissions. "]
[]
[]
[]
[null,"Conditionally insignificant activity must meet all of the following:"]
[null,"▪ ","This rule does not apply if lead is a component of any mechanical finishing operation, including as a component of the metal being finished."]
[null,"▪ ","The actual amount of particulate matter emissions is 5 tons or less from all mechanical finishing at the business ",null,null,null,null,null,null,null,null,null,null,"Minn. R. 7008.4110"]
[null,null,"▪ ","Mechanical finishing includes abrasive blasting, buffing, polishing, carving, cutting, drilling, machining, routing, sanding, sawing, surface grinding, or turning equipment, but does not include abrasive blasting for removing lead-containing paint."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Contains monitoring and recordkeeping requirements"]
[null,"▪ ","Must install, operate, and maintain control equipment designed to control emissions of particulate matter on all mechanical finishing."]
[]
[null,"▪ ","Must calculate actual emissions using Mechanical Finishing tab."]
[]
[]
[null,"Additional MPCA resources"]
[null,"▪ ","If your blasting activity is part of, or connected with, manufacturing or processing, it may be subject to the Industrial Process Equipment Rule. An example is a booth used to blast the paint off a manufactured product so it can be repainted.  ",null,null,null,null,null,null,null,null,null,null,"Industrial process equipment rule"]
[]
[null,"▪ ","About air permits and thresholds can be found on the MPCA Air Permits webpage.",null,null,null,null,null,null,null,null,null,null,"Who needs an air permit?"]
[]
[]
[null,"U.S. Environmental Protection Agency (EPA) standards"]
[null,"National emission standards for hazardous air pollutants (NESHAP) for metal fabrication and finishing"]
[null,"This standard is for dry abrasive blasting, dry grinding or polishing with machines, dry machining, spray painting, and welding activities.",null,null,null,null,null,null,null,null,null,null,null," "]
[null,"This standard applies to dry abrasive blasting if"]
[null,"1)","your business' NAICS or SIC code pairing is listed in the same row in the table below, and",null,null,null,null,null,null,null,null,"Full Text:","40 CFR 63, subp. XXXXXX"]
[null,"2)","your abrasive blast media contains more than ",null,null,null,null,null,null,null,null,"Flow chart: ","Applicability and requirements"]
[null,null,"▪ ","0.1% cadmium, chromium, nickel, or lead",null,null,null,null,null,null,null,"Resource:","EPA Rule information"]
[null,null,"▪ ","1.0% manganese"]
[]
[null,"Table: source categories affected by NESHAP 6X"]
[null,"Hint: If you are unsure, tax forms and worker's compensation documents often identify your NAICS or SIC code. "]
[null,"NAICS","NAICS Description",null,null,null,"SIC","EPA Source Category",null,null,null,"SIC Code Description"]
[null,332111,"Iron and Steel Forging",null,null,null,3462,"Iron and Steel Forging",null,null,null,"Iron and Steel Forging"]
[null,332117,"Powder Metallurgy Part Manufacturing",null,null,null,3499,"Fabricated Metal Products, NEC",null,null,null,"Fabricated Metal Products, NEC"]
[null,332312,"Fabricated Structural Metal Manufacturing",null,null,null,3441,"Fabricated Structural Metal Manufacturing",null,null,null,"Fabricated Structural Metal Fabrication"]
[null,332313,"Plate Work Manufacturing",null,null,null,3443,"Fabricated Plate Work (Boiler Shops)",null,null,null,"Fabricated Plate Work and Boiler Shops"]
[null,332410,"Power Boiler and Heat Exchanger Manufacturing",null,null,null,3443,"Fabricated Plate Work (Boiler Shops)",null,null,null,"Fabricated Plate Work and Boiler Shops"]
[null,332420,"Metal Tank (Heavy Gauge) Manufacturing",null,null,null,3443,"Fabricated Plate Work (Boiler Shops)",null,null,null,"Fabricated Plate Work and Boiler Shops"]
[null,332618,"Other Fabricated Wire Product Manufacturing",null,null,null,3399,"Primary Metals Products Manufacturing",null,null,null,"Primary Metals Products Manufacturing"]
[null,332919,"Other Metal Valve and Pipe Fitting Manufacturing",null,null,null,3494,"Valves and Pipe Fittings, NEC",null,null,null,"Valves and Pipe Fittings, NEC"]
[null,332999,"All Other Miscellaneous Fabricated Metal Product Mfg.",null,null,null,3499,"Fabricated Metal Products, NEC",null,null,null,"Fabricated Metal Products, NEC"]
[null,333120,"Construction Machinery Manufacturing",null,null,null,3531,"Industrial Machinery & Equipment: Finishing Ops",null,null,null,"Construction Machinery Manufacturing"]
[null,333132,"Oil and Gas Field Machinery and Equipment Mfg.",null,null,null,3533,"Industrial Machinery & Equipment: Finishing Ops",null,null,null,"Oil and Gas Field Machinery Equipment Manufacturing"]
[null,333414,"Heating Equipment (except Warm Air Furnaces) Mfg.",null,null,null,3433,"Heating Equipment, except electric",null,null,null,"Heating Equipment, except electric"]
[null,333911,"Pump and Pumping Equipment Manufacturing",null,null,null,3561,"Industrial Machinery & Equipment: Finishing Ops",null,null,null,"Pumps and Pumping Equipment Manufacturing"]
[null,335312,"Motor and Generator Manufacturing",null,null,null,3621,"Electrical & Electronic Equipment Finishing Ops",null,null,null,"Motors and Generators Manufacturing"]
[null,335999,"All Other Misc. Electrical Equipment & Component Mfg.",null,null,null,3699,"Electrical & Electronic Equipment Finishing Ops",null,null,null,"Electrical Machinery, Equipment, and Supplies, NEC"]
[null,"NEC = not elsewhere classified"]

{"sheet":"Mechanical Finishing","index":3,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[[41,2,42,9],[43,2,46,9],[47,2,47,4],[14,1,14,9],[2,1,2,9],[15,1,15,9],[16,1,17,1],[16,2,17,3],[16,4,17,4],[16,5,17,5],[16,6,17,9],[12,2,12,5],[12,6,12,7],[5,2,6,9],[20,1,21,1],[20,2,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,9],[18,1,19,1],[18,2,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,9],[22,4,23,4],[22,5,23,5],[22,6,23,9],[26,1,26,9],[27,1,27,9],[24,1,25,1],[24,2,25,3],[24,4,25,4],[24,5,25,9],[22,1,23,1],[22,2,23,3],[32,1,33,1],[32,2,33,3],[32,4,33,4],[32,5,33,9],[28,1,29,1],[28,2,29,3],[28,4,29,6],[30,1,31,1],[30,2,31,3],[30,4,31,4],[38,3,38,5],[34,1,34,9],[35,1,35,9],[36,1,37,1],[36,2,37,3],[36,4,37,4],[36,5,37,9],[0,1,0,9],[1,1,1,9],[3,2,4,9],[9,2,9,9],[10,2,11,9],[8,1,8,9],[66,2,66,9],[67,2,67,9],[49,4,49,5],[49,1,49,3],[50,1,50,3],[54,1,54,3],[60,1,60,3],[57,1,57,4],[51,2,52,9],[53,2,53,9],[55,2,55,9],[56,2,56,9],[58,2,59,9],[61,2,64,9],[65,2,65,9]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-19  •  6/5/23"}]
[null,"Air emissions from mechanical finishing, conditionally insignificant activity"]
[null,"Use this calculator to see if your mechanical finishing operations are a conditionally insignificant activity and to recalculate annually."]
[null,null,"Mechanical finishing operations means buffing, abrasive blasting, polishing, carving, cutting, drilling, machining, routing, sanding, sawing, surface grinding, or turning equipment. Does not include abrasive blasting for removing lead-containing paint."]
[]
[null,null,"▪  If lead is a component of any mechanical finishing operation, including the composition of the metal being finished, this rule does not apply. \n   Check the safety data sheet of the metal being finished. "]
[]
[]
[null,"In order to qualify, you must:"]
[null,null,"A. install, operate, and maintain control equipment designed to control emissions of particulate matter on the mechanical finishing operations; and\n"]
[null,null,"B. limit emissions of particulate matter from all mechanical finishing operations to less than 10,000 pounds in each calendar year, calculated according to the method below. All emissions of particulate matter from all mechanical finishing operations at the stationary source must be accounted for in the annual calculation."]
[]
[null,null,"C. comply with the monitoring and record keeping requirements (see below)",null,null,null,"Minn. R. 7008.4110"]
[]
[null,"Enter information for your business in the blue cells."]
[null,"Step 1"]
[null,"OP","Enter total hours the control equipment was operated last year",null,0,"hours"]
[]
[null,"EF","Enter the design concentration of PM from your control equipment",null,0,"grain/cubic foot","This information is often listed on the control equipment nameplate, or enter 0.07 if you have cyclones or 0.03 if you have fabric filters."]
[]
[null,"Qair","Designed airflow rate from the control equipment ",null,0,"CFM","This information is often listed on the equipment nameplate."]
[]
[null,null,"Conversion factor",null,{"$f":"(1/7000)*(60/1)","v":8.5714285714285719E-3},"lb./grain * min/hour","1 lb. = 7000 grains; 60 minutes = 1 hour"]
[]
[null,"EC","OP * EF * Qair * Conversion factor =",null,{"$f":"E17*E19*E21*E23","v":0},"pounds of PM emissions from control equipment for the year"]
[]
[]
[null,"Step 2"]
[null,null,"Choose your control equipment type1 from the drop-down list",null,"Choose control equipment type"]
[]
[null,"R","Ratio of uncaptured to captured emissions from the control equipment",null,{"$f":"'Data Validation'!E43","v":"--"}]
[]
[null,"EU","R * EC =",null,{"$f":"IFERROR(E25*E31,0)","v":0},"pounds of uncaptured emissions from control equipment for the year"]
[]
[]
[null,"Result"]
[null,"E","EC * EU =",null,{"$f":"E25+E33","v":0},"total pounds of particulate matter for the year"]
[]
[null,null,null,"This number must be less than 10,000 pounds to qualify."]
[]
[null,"1Control equipment type definitions:"]
[null,null,"A total enclosure means an enclosure that completely surrounds emissions from an emissions unit such that all emissions are captured and discharged through ductwork to control equipment."]
[]
[null,null,"A hood means a shaped inlet to a pollution control system that does not totally surround emissions from an emissions unit, that is designed, used, and maintained to capture and discharge the air emissions through ductwork to control equipment, and that conforms to the design and operating practices recommended in \"Industrial Ventilation - A Manual of Recommended Practice, American Conference of Governmental Industrial Hygienists.\" This document is subject to frequent change. A spray booth can be a hood if it meets the definition in this subpart."]
[]
[]
[]
[null,null,"A certified hood complies with Minn. R. 7011.0072"]
[]
[null,"Monitoring and record keeping",null,null,"Minn. R. 7008.4110"]
[null,"Control equipment:"]
[null,"▪ ","Operate and maintain, as required by the manufacturer's specification. Proper operation and maintenance includes effective performance, adequate funding, adequate operator staffing and training, and adequate laboratory and process controls, including appropriate quality assurance procedures."]
[]
[null,"▪ ","Inspect once each calendar quarter or more frequently according to the manufacturer's specification"]
[null,"Maintain records:"]
[null,"▪ ","of inspection, maintenance, and repair activities and the manufacturer's inspection, maintenance, and repair specifications for the control equipment for at least five years."]
[null,"▪ ","for each calendar year of the hours operated and design airflow rate for the control equipment associated with each mechanical finishing operation"]
[null,"If not using the default design airflow rate:"]
[null,"▪ ","If the default value for design airflow rate is not used, maintain records for each calendar year of the manufacturer's design concentration for particulate matter from the control equipment associated with each mechanical finishing operation"]
[]
[null,"If using a certified hood:"]
[null,"▪ ","If the emissions from mechanical finishing operations are vented to the control equipment through a hood, you may evaluate, on a form provided by the commissioner, whether the hood conforms to the design and operating practices recommended in \"Industrial Ventilation - A Manual of Recommended Practice, American Conference of Governmental Industrial Hygienists,\" in order to use the certified hood values in subpart 4. The manual is incorporated by reference under part 7011.0061.  An owner or operator that performs this evaluation must:\n"]
[]
[]
[]
[null,null,"     ▪  if a permit is required under chapter 7007, include with the permit application the certification required in part 7011.0072, subpart 2"]
[null,null,"     ▪  maintain at the stationary source records of the evaluation of each hood"]
[null,null,"     ▪  record each month the fan rotation speed, fan power draw, face velocity, or other comparable airflow indicator for each hood"]

{"sheet":"Abrasive Blasting","index":4,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[42,9,42,10],[40,13,40,14],[41,13,41,14],[42,13,42,14],[38,13,38,14],[0,1,0,18],[43,7,43,8],[44,7,44,8],[17,9,19,10],[20,9,21,10],[6,9,6,10],[6,11,6,14],[17,11,19,14],[20,11,21,14],[16,11,16,14],[38,7,38,8],[37,9,37,10],[36,7,36,8],[8,11,8,14],[9,11,9,14],[10,11,10,14],[16,9,16,10],[17,15,21,17],[16,15,16,17],[34,7,35,8],[41,15,41,16],[41,17,41,18],[42,17,42,18],[40,15,40,16],[46,9,46,10],[46,11,46,12],[50,1,50,18],[44,13,44,14],[47,13,47,14],[49,1,49,2],[49,7,49,8],[47,1,47,2],[47,11,47,12],[47,15,47,16],[47,9,47,10],[45,1,45,2],[46,1,46,2],[46,13,46,14],[46,15,46,16],[44,15,44,16],[46,7,46,8],[45,7,45,8],[45,9,45,10],[28,6,28,9],[26,5,26,9],[20,2,20,4],[32,1,32,18],[29,6,29,9],[28,10,29,11],[28,12,29,18],[45,11,45,12],[45,13,45,14],[45,15,45,16],[42,15,42,16],[33,13,33,14],[34,13,35,14],[36,13,36,14],[37,13,37,14],[34,17,35,18],[33,17,33,18],[36,17,36,18],[33,7,33,8],[34,9,35,10],[36,9,36,10],[37,17,38,18],[40,17,40,18],[40,9,40,10],[41,9,41,10],[52,1,52,15],[33,15,33,16],[34,15,35,16],[36,15,36,16],[37,15,37,16],[38,15,38,16],[38,9,38,10],[33,9,33,10],[33,11,33,12],[34,11,35,12],[36,11,36,12],[48,13,48,14],[49,13,49,14],[49,9,49,10],[49,11,49,12],[49,15,49,16],[48,1,48,2],[48,9,48,10],[47,7,47,8],[48,7,48,8],[48,11,48,12],[48,15,48,16],[38,11,38,12],[8,9,8,10],[37,3,37,4],[33,5,33,6],[41,1,41,2],[42,1,42,2],[40,1,40,2],[44,1,44,2],[40,11,40,12],[41,11,41,12],[42,11,42,12],[37,11,37,12],[43,9,43,10],[37,5,37,6],[38,5,38,6],[37,7,37,8],[44,9,44,10],[44,11,44,12],[36,5,36,6],[34,5,35,6],[34,3,35,4],[36,3,36,4],[38,3,38,4],[33,1,38,2],[33,3,33,4],[51,1,51,8],[51,9,51,18],[1,1,1,18],[7,15,7,17],[8,15,8,17],[9,15,9,17],[10,15,10,17],[6,15,6,17],[26,10,26,11],[16,1,18,4],[16,5,18,6],[25,1,25,11],[7,5,7,6],[6,5,6,6],[6,1,6,4],[21,3,21,7],[9,1,11,7],[7,9,7,10],[9,9,9,10],[10,9,10,10],[20,5,20,6],[22,5,22,6],[23,5,23,6],[7,11,7,14]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-19  •  6/5/23"}]
[null,"Air emissions from abrasive blasting"]
[]
[null,"Abrasive/blast media characteristics"]
[null,"If the abrasive media you are using does not fit into any of the categories provided, select \"Other\" from the drop-down list. "]
[]
[null,"Which abrasive is being used?",null,null,null,"Choose one",null,null,null,"Abrasive",null,"Examples of media",null,null,null,"Density (lb/ft3)"]
[null,null,null,null,"What is the density of the abrasive?",0,null,"lb/ft3",null,"Sand",null,"Silica sand, crushed glass",null,null,null,"99 (sand)"]
[null,null,null,null,null,null,null,null,null,"Grit ",null,"Metals, minerals, synthetics",null,null,null,"160 (aluminum oxide)"]
[null,"Review the safety data sheet for your blast media. Enter any hazardous air pollutants and the maximum contents in the blue cells if the abrasive blasting emission calculator. See \"HAP list\" tab for assistance.",null,null,null,null,null,null,null,"Shot",null,"Metals, minerals, synthetics, cut wire",null,null,null,"487 (steel)"]
[null,null,null,null,null,null,null,null,null,"Other",null,"Coal and smelter slag, glass beads"]
[]
[]
[null,"Equipment and manufacturer specifications"]
[null,"There are two manufacturer specifications that may be used for determining the maximum capacity of the abrasive blasting operation."]
[]
[null,"Which manufacturer specification will you use to calculate maximum capacity?",null,null,null,"Choose one",null,null,null,"Specification",null,"Description",null,null,null,"Required"]
[null,null,null,null,null,null,null,null,null,"Manufacturer maximum rate",null,"Maximum amount of abrasive/blast media that the equipment is capable of passing through the gun. ",null,null,null,"The rate or parameters used must be identified by the manufacturer of the blasting equipment."]
[]
[]
[null,null,"Manufacturer rated capacity",null,null,0,null,"lb/hour",null,"Nozzle parameters",null,"The diameter and pressure at the nozzle identified on manufacturer specifications."]
[]
[null,null,null,null,"Nozzle diameter","Choose one",null,"inches"]
[null,null,null,null,"Nozzle pressure","Choose one",null,"psig"]
[]
[null,"Calculate actual emissions"]
[null,"During the last 12 months, how many ",null,null,null,"Choose one",null,null,null,null,0,null,{"$f":"IF(F27='Data Validation'!E16,\" \",IF(F27='Data Validation'!E17,\"hour/year\",IF(F27='Data Validation'!E18,\"lb/year\")))","v":" "}]
[]
[null,"What type of control equipment is being used?",null,null,null,null,"Choose one",null,null,null,"See definitions in Minn. R. 7011.0070",null,"Taking credit for control equipment is an option and requires compliance with the rule, which includes monitoring and recordkeeping requirements."]
[null,"What is the capture efficiency claimed?",null,null,null,null,"Choose one"]
[]
[]
[null,"Abrasive blasting emission calculations"]
[null,"Pollutant",null,"a",null,"b",null,"c",null,"d",null,null,null,"e"]
[null,null,null,"Maximum hourly usage",null,"Actual annual throughput",null,"Hours in a year",null,"Emission factor",null,"Potential emissions",null,"Control efficiency1",null,"Actual emissions",null,"Insignificant activity limits"]
[]
[null,null,null,"(lb/hr)",null,"(lb/yr)",null,"(hr/yr)",null,"(lb/lb)",null,"(ton/yr)",null,"(%)",null,"(tons/yr)",null,"(tons/yr)"]
[null,null,null,null,null,null,null,"24 hr/day * 365 day/yr",null,"by pollutant",null,"(a * c * d) / 2000",null,null,null,"( b * d ) / 2000"]
[null,null,null,{"$f":"IF(F17='Data Validation'!C5,0,IF(F17='Data Validation'!C6,F21,IF(F17='Data Validation'!C7,'Blasting charts'!E4)))","v":0},null,{"$f":"IF(F27='Data Validation'!E16,0,IF(F27='Data Validation'!E17,K27*D39,IF(F27='Data Validation'!E18,K27)))","v":0},null,8760]
[null,"Criteria air pollutants"]
[null,"PM",null,null,null,null,null,null,null,{"$f":"IF(F7=\"Choose one\",0,IF(F7='Blasting charts'!B23,'Blasting charts'!C23,IF(F7='Blasting charts'!B24,'Blasting charts'!C24,IF(F7='Blasting charts'!B25,'Blasting charts'!C25,IF(F7='Blasting charts'!B26,'Blasting charts'!C26)))))","v":0},null,{"$f":"$D$39*$H$39*J41/2000","v":0},{"$f":"D$39*H$39*J41/2000","v":0},{"$f":"'Blasting charts'!K31","v":0},null,{"$f":"F$39*J41*(1-N41)/2000","v":0},null,1]
[null,"PM10",null,null,null,null,null,null,null,{"$f":"IF(F7='Data Validation'!B5,0,IF(F7='Blasting charts'!B23,'Blasting charts'!D23,IF(F7='Blasting charts'!B24,'Blasting charts'!C24,IF(F7='Blasting charts'!B25,'Blasting charts'!D25,IF(F7='Blasting charts'!B26,'Blasting charts'!D26)))))","v":0},null,{"$f":"$D$39*$H$39*J42/2000","v":0},{"$f":"D$39*H$39*J42/2000","v":0},{"$f":"'Blasting charts'!L31","v":0},null,{"$f":"F$39*J42*(1-N42)/2000","v":0},null,1]
[null,"PM2.5",null,null,null,null,null,null,null,{"$f":"J42","v":0},null,0,0,null,null,0]
[null,"Hazardous air pollutants2",null,null,null,null,null,"(%)3",null,"lb/lb"]
[null,null,null,null,null,null,null,null,null,{"$f":"$J$41*H45","v":0},null,{"$f":"$D$39*$H$39*$J45/2000","v":0},{"$f":"D$39*H$39*J45/2000","v":0},null,null,{"$f":"F$39*$J45*(1-N45)/2000","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"$J$41*H46","v":0},null,{"$f":"$D$39*$H$39*$J46/2000","v":0},{"$f":"D$39*H$39*J46/2000","v":0},null,null,{"$f":"F$39*$J46*(1-N46)/2000","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0,0,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"$J$41*H48","v":0},null,{"$f":"$D$39*$H$39*$J48/2000","v":0},{"$f":"D$39*H$39*J48/2000","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0,null,null,0]
[null,"1Control efficiency may only be used when calculating actual emissions and when in compliance with the rule. Percent control is based on type of equipment and capture efficiency (Minn. R. 7011.0070)."]
[null,"2Review the material safety data sheet for the media used for presence of hazardous air pollutants (HAPs).",null,null,null,null,null,null,null,"List of individual pollutants and commonly reported individual pollutants in groups (aq-ei4-32)"]
[null,"3Add the metal HAP(s) and percent concentration to the pollutant list in the emission calculations."]

{"sheet":"Blasting charts","index":5,"n_rows":53,"n_cols":20,"rows_kept":53,"cut":false,"hidden":false,"merged":[[43,1,44,1],[31,1,32,1],[33,1,34,1],[35,1,36,1],[37,1,38,1],[39,1,40,1],[41,1,42,1],[17,1,19,13],[4,20,5,20],[4,1,6,1],[1,1,1,13],[0,1,0,13],[4,2,5,13]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-19  •  6/5/23"}]
[null,"Air emissions from abrasive blasting"]
[]
[null,"Flow Rate at the nozzle (lb abrasive/hr)*",null,null,{"$f":"IF(T7='Data Validation'!B5,0,S7*('Abrasive Blasting'!F8/99))","v":0},"lb/hr (adjusted with material density)"]
[null,"Internal Nozzle Diameter\n(inches)","Nozzle Pressure\n(psig)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diameter","Pressure","Flow rate","Material"]
[null,null,30,40,50,60,70,80,90,100,110,120,130,140,"Coefficient","Area",{"$f":"SUM(Q8:Q21)","v":0},{"$f":"SUM(R8:R21)","v":0},{"$f":"SUM(S8:S22)","v":0},{"$f":"'Abrasive Blasting'!F7","v":"Choose one"}]
[null,0.125,28,35,42,49,55,63,70,77,{"$f":"J8*((K$7+14)/(J$7+14))","v":83.754385964912288},{"$f":"J8*(L7+14)/(J7+14)","v":90.508771929824562},{"$f":"K8*(M7+14)/(K7+14)","v":97.26315789473685},{"$f":"L8*(N7+14)/(L7+14)","v":104.01754385964912},14,{"$f":"(1/4)*PI()*(0.125^2)","v":1.2271846303085129E-2},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B8,1,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!C$7,1,\" \")","v":" "},{"$f":"IF(AND($Q$7=1,$R$7=1),C8,IF(AND($Q$7=1,$R$7=2),D8,IF(AND($Q$7=1,$R$7=3),E8,IF(AND($Q$7=1,$R$7=4),F8,IF(AND($Q$7=1,$R$7=5),G8,IF(AND($Q$7=1,$R$7=6),H8,IF(AND($Q$7=1,$R$7=7),I8,IF(AND($Q$7=1,$R$7=8),J8,IF(AND($Q$7=1,$R$7=9),K8,IF(AND($Q$7=1,$R$7=10),L8,IF(AND($Q$7=1,$R$7=11),M8,IF(AND($Q$7=1,$R$7=12),N8,0))))))))))))","v":0}]
[null,0.1875,65,80,94,107,122,135,149,165,{"$f":"J9*(K$7+$O9)/(J$7+$O9)","v":177.54752851711027},{"$f":"K9*(L$7+$O9)/(K$7+$O9)","v":190.09505703422053},{"$f":"L9*(M$7+$O9)/(L$7+$O9)","v":202.6425855513308},{"$f":"M9*(N$7+$O9)/(M$7+$O9)","v":215.19011406844106},{"$f":"O8/P8*P9","v":31.500000000000004},{"$f":"(1/4)*PI()*((3/16)^2)","v":2.7611654181941541E-2},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B9,2,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!D$7,2,\" \")","v":" "},{"$f":"IF(AND($Q$7=2,$R$7=1),C9,IF(AND($Q$7=2,$R$7=2),D9,IF(AND($Q$7=2,$R$7=3),E9,IF(AND($Q$7=2,$R$7=4),F9,IF(AND($Q$7=2,$R$7=5),G9,IF(AND($Q$7=2,$R$7=6),H9,IF(AND($Q$7=2,$R$7=7),I9,IF(AND($Q$7=2,$R$7=8),J9,IF(AND($Q$7=2,$R$7=9),K9,IF(AND($Q$7=2,$R$7=10),L9,IF(AND($Q$7=2,$R$7=11),M9,IF(AND($Q$7=2,$R$7=12),N9,0))))))))))))","v":0}]
[null,0.25,109,138,168,195,221,255,280,309,{"$f":"J10*(K$7+$O10)/(J$7+$O10)","v":328.80769230769232},348.61538461538464,368.42307692307696,388.23076923076923,{"$f":"O9/P9*P10","v":56.000000000000007},{"$f":"(1/4)*PI()*(0.25^2)","v":4.9087385212340517E-2},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B10,3,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!E$7,3,\" \")","v":" "},{"$f":"IF(AND($Q$7=3,$R$7=1),C10,IF(AND($Q$7=3,$R$7=2),D10,IF(AND($Q$7=3,$R$7=3),E10,IF(AND($Q$7=3,$R$7=4),F10,IF(AND($Q$7=3,$R$7=5),G10,IF(AND($Q$7=3,$R$7=6),H10,IF(AND($Q$7=3,$R$7=7),I10,IF(AND($Q$7=3,$R$7=8),J10,IF(AND($Q$7=3,$R$7=9),K10,IF(AND($Q$7=3,$R$7=10),L10,IF(AND($Q$7=3,$R$7=11),M10,IF(AND($Q$7=3,$R$7=12),N10,0))))))))))))","v":0}]
[null,0.3125,205,247,292,354,377,420,462,507,534.04,561.07999999999993,588.11999999999989,615.16,87.500000000000014,{"$f":"(1/4)*PI()*((5/16)^2)","v":7.6699039394282062E-2},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B11,4,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!F$7,4,\" \")","v":" "},{"$f":"IF(AND($Q$7=4,$R$7=1),C11,IF(AND($Q$7=4,$R$7=2),D11,IF(AND($Q$7=4,$R$7=3),E11,IF(AND($Q$7=4,$R$7=4),F11,IF(AND($Q$7=4,$R$7=5),G11,IF(AND($Q$7=4,$R$7=6),H11,IF(AND($Q$7=4,$R$7=7),I11,IF(AND($Q$7=4,$R$7=8),J11,IF(AND($Q$7=4,$R$7=9),K11,IF(AND($Q$7=4,$R$7=10),L11,IF(AND($Q$7=4,$R$7=11),M11,IF(AND($Q$7=4,$R$7=12),N11,0))))))))))))","v":0}]
[null,0.375,285,355,417,477,540,600,657,720,751.85840707964599,783.71681415929197,815.57522123893796,847.43362831858394,126.00000000000001,{"$f":"(1/4)*PI()*((3/8)^2)","v":0.11044661672776616},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B12,5,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!G$7,5,\" \")","v":" "},{"$f":"IF(AND($Q$7=5,$R$7=1),C12,IF(AND($Q$7=5,$R$7=2),D12,IF(AND($Q$7=5,$R$7=3),E12,IF(AND($Q$7=5,$R$7=4),F12,IF(AND($Q$7=5,$R$7=5),G12,IF(AND($Q$7=5,$R$7=6),H12,IF(AND($Q$7=5,$R$7=7),I12,IF(AND($Q$7=5,$R$7=8),J12,IF(AND($Q$7=5,$R$7=9),K12,IF(AND($Q$7=5,$R$7=10),L12,IF(AND($Q$7=5,$R$7=11),M12,IF(AND($Q$7=5,$R$7=12),N12,0))))))))))))","v":0}]
[null,0.4375,385,472,560,645,755,820,905,940,974.62246777163909,1009.2449355432782,1043.8674033149171,1078.4898710865559,171.5,{"$f":"(1/4)*PI()*((7/16)^2)","v":0.15033011721279282},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B13,6,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!H$7,6,\" \")","v":" "},{"$f":"IF(AND($Q$7=6,$R$7=1),C13,IF(AND($Q$7=6,$R$7=2),D13,IF(AND($Q$7=6,$R$7=3),E13,IF(AND($Q$7=6,$R$7=4),F13,IF(AND($Q$7=6,$R$7=5),G13,IF(AND($Q$7=6,$R$7=6),H13,IF(AND($Q$7=6,$R$7=7),I13,IF(AND($Q$7=6,$R$7=8),J13,IF(AND($Q$7=6,$R$7=9),K13,IF(AND($Q$7=6,$R$7=10),L13,IF(AND($Q$7=6,$R$7=11),M13,IF(AND($Q$7=6,$R$7=12),N13,0))))))))))))","v":0}]
[null,0.5,503,615,725,835,945,1050,1160,1265,1304.0432098765432,1343.0864197530864,1382.1296296296296,1421.1728395061727,224.00000000000003,{"$f":"(1/4)*PI()*(0.5^2)","v":0.19634954084936207},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B14,7,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!I$7,7,\" \")","v":" "},{"$f":"IF(AND($Q$7=7,$R$7=1),C14,IF(AND($Q$7=7,$R$7=2),D14,IF(AND($Q$7=7,$R$7=3),E14,IF(AND($Q$7=7,$R$7=4),F14,IF(AND($Q$7=7,$R$7=5),G14,IF(AND($Q$7=7,$R$7=6),H14,IF(AND($Q$7=7,$R$7=7),I14,IF(AND($Q$7=7,$R$7=8),J14,IF(AND($Q$7=7,$R$7=9),K14,IF(AND($Q$7=7,$R$7=10),L14,IF(AND($Q$7=7,$R$7=11),M14,IF(AND($Q$7=7,$R$7=12),N14,0))))))))))))","v":0}]
[null,0.625,820,990,1170,1336,1510,1680,1850,2030,2075.1111111111113,2120.2222222222226,2165.3333333333339,2210.4444444444448,350.00000000000006,{"$f":"(1/4)*PI()*((5/8)^2)","v":0.30679615757712825},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B15,8,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!J$7,8,\" \")","v":" "},{"$f":"IF(AND($Q$7=8,$R$7=1),C15,IF(AND($Q$7=8,$R$7=2),D15,IF(AND($Q$7=8,$R$7=3),E15,IF(AND($Q$7=8,$R$7=4),F15,IF(AND($Q$7=8,$R$7=5),G15,IF(AND($Q$7=8,$R$7=6),H15,IF(AND($Q$7=8,$R$7=7),I15,IF(AND($Q$7=8,$R$7=8),J15,IF(AND($Q$7=8,$R$7=9),K15,IF(AND($Q$7=8,$R$7=10),L15,IF(AND($Q$7=8,$R$7=11),M15,IF(AND($Q$7=8,$R$7=12),N15,0))))))))))))","v":0}]
[null,0.75,1140,1420,1670,1915,2160,2400,2630,2880,2927.682119205298,2975.364238410596,3023.0463576158941,3070.7284768211921,504.00000000000006,{"$f":"(1/4)*PI()*(0.75^2)","v":0.44178646691106466},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B16,9,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!K$7,9,\" \")","v":" "},{"$f":"IF(AND($Q$7=9,$R$7=1),C16,IF(AND($Q$7=9,$R$7=2),D16,IF(AND($Q$7=9,$R$7=3),E16,IF(AND($Q$7=9,$R$7=4),F16,IF(AND($Q$7=9,$R$7=5),G16,IF(AND($Q$7=9,$R$7=6),H16,IF(AND($Q$7=9,$R$7=7),I16,IF(AND($Q$7=9,$R$7=8),J16,IF(AND($Q$7=9,$R$7=9),K16,IF(AND($Q$7=9,$R$7=10),L16,IF(AND($Q$7=9,$R$7=11),M16,IF(AND($Q$7=9,$R$7=12),N16,0))))))))))))","v":0}]
[null,1,2030,2460,2900,3340,3780,4200,4640,5060,5110.803212851406,5161.606425702812,5212.4096385542171,5263.212851405623,896.00000000000011,{"$f":"(1/4)*PI()*(1^2)","v":0.78539816339744828},{"$f":"IF('Abrasive Blasting'!$F$23='Blasting charts'!B17,10,\" \")","v":" "},{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!L$7,10,\" \")","v":" "},{"$f":"IF(AND($Q$7=10,$R$7=1),C17,IF(AND($Q$7=10,$R$7=2),D17,IF(AND($Q$7=10,$R$7=3),E17,IF(AND($Q$7=10,$R$7=4),F17,IF(AND($Q$7=10,$R$7=5),G17,IF(AND($Q$7=10,$R$7=6),H17,IF(AND($Q$7=10,$R$7=7),I17,IF(AND($Q$7=10,$R$7=8),J17,IF(AND($Q$7=10,$R$7=9),K17,IF(AND($Q$7=10,$R$7=10),L17,IF(AND($Q$7=10,$R$7=11),M17,IF(AND($Q$7=10,$R$7=12),N17,0))))))))))))","v":0}]
[null,"*The flow rates in the above chart are for sand.  If you are using steel or aluminum oxide as your abrasive blast material, the spreadsheet will automatically convert the flow rate provided to these other abrasive material types. Flow rates in grey are using the original guidance ratio equation from SCAQMD Memorandum from J. Nenzell to Metallurgical Engineers, Subject: Abrasive Blasting, March 13, 1975."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!M$7,11,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Abrasive Blasting'!$F$24='Blasting charts'!N$7,12,\" \")","v":" "}]
[]
[null,"Emission Factors for Abrasives*","PM (lb PM/lb abrasive)","PM10 (lb PM10/lb of Abrasive)**",null,"PM10 emissions derived from STAPPA/ALAPCO PM10 factors which were based on the amount of PM generated:  "]
[null,"Sand",4.1000000000000002E-2,{"$f":"C23*0.7","v":2.87E-2},null,"sand = 0.7 lbs PM10 per lb of PM; grit= 0.7 lb PM10 per lb of PM; Steel shot = 0.86 lb PM10 per lb of PM"]
[null,"Grit",0.01,{"$f":"C24*0.7","v":6.9999999999999993E-3},null,"For \"Other\", assume PM10=PM"]
[null,"Shot",4.0000000000000001E-3,{"$f":"C25*0.86","v":3.4399999999999999E-3}]
[null,"Other",0.01,0.01]
[]
[]
[]
[null,"Control equipment","Pollutant","Control efficiency (%)",null,null,null,null,"Equipment","Capture","PM","PM10"]
[null,"Choose one",null,"Total enclosure","Certified hood","Uncertified hood",null,null,{"$f":"IF('Abrasive Blasting'!G29=\"Choose one\",0,IF('Abrasive Blasting'!G29='Blasting charts'!B32,1,IF('Abrasive Blasting'!G29='Blasting charts'!B34,2,IF('Abrasive Blasting'!G29='Blasting charts'!B36,3,IF('Abrasive Blasting'!G29='Blasting charts'!B38,4,IF('Abrasive Blasting'!G29='Blasting charts'!B40,5,IF('Abrasive Blasting'!G29='Blasting charts'!B42,6,IF('Abrasive Blasting'!G29='Blasting charts'!B44,7))))))))","v":0},{"$f":"IF('Abrasive Blasting'!G30=\"Choose one\",0,IF('Abrasive Blasting'!G30='Blasting charts'!D31,1,IF('Abrasive Blasting'!G30='Blasting charts'!E31,2,IF('Abrasive Blasting'!G30='Blasting charts'!F31,3))))","v":0},{"$f":"SUM(K32:K45)","v":0},{"$f":"SUM(L32:L46)","v":0}]
[null,"Cyclone (high efficiency)","PM",0.9,0.72,0.54,null,null,null,null,{"$f":"IF(AND($I$31=1,$J$31=1),D32,IF(AND($I$31=1,$J$31=2),E32,IF(AND($I$31=1,$J$31=3),F32,0)))","v":0}]
[null,null,"PM10",0.78,0.62,0.46,null,null,null,null,null,{"$f":"IF(AND($I$31=1,$J$31=1),D33,IF(AND($I$31=1,$J$31=2),E33,IF(AND($I$31=1,$J$31=3),F33,0)))","v":0}]
[null,"Cyclone (medium efficiency)","PM",0.8,0.64,0.48,null,null,null,null,{"$f":"IF(AND($I$31=2,$J$31=1),D34,IF(AND($I$31=2,$J$31=2),E34,IF(AND($I$31=2,$J$31=3),F34,0)))","v":0}]
[null,null,"PM10",0.6,0.48,0.36,null,null,null,null,null,{"$f":"IF(AND($I$31=2,$J$31=1),D35,IF(AND($I$31=2,$J$31=2),E35,IF(AND($I$31=2,$J$31=3),F35,0)))","v":0}]
[null,"Cyclone (low efficiency)","PM",0.25,0.2,0.15,null,null,null,null,{"$f":"IF(AND($I$31=3,$J$31=1),D36,IF(AND($I$31=3,$J$31=2),E36,IF(AND($I$31=3,$J$31=3),F36,0)))","v":0}]
[null,null,"PM10",0.25,0.2,0.15,null,null,null,null,null,{"$f":"IF(AND($I$31=3,$J$31=1),D37,IF(AND($I$31=3,$J$31=2),E37,IF(AND($I$31=3,$J$31=3),F37,0)))","v":0}]
[null,"Wet cyclone","PM",0.84,0.68,0.51,null,null,null,null,{"$f":"IF(AND($I$31=4,$J$31=1),D38,IF(AND($I$31=4,$J$31=2),E38,IF(AND($I$31=4,$J$31=3),F38,0)))","v":0}]
[null,null,"PM10",0.84,0.68,0.51,null,null,null,null,null,{"$f":"IF(AND($I$31=4,$J$31=1),D39,IF(AND($I$31=4,$J$31=2),E39,IF(AND($I$31=4,$J$31=3),F39,0)))","v":0}]
[null,"Wall or panel filter","PM",0.85,0.68,0.51,null,null,null,null,{"$f":"IF(AND($I$31=5,$J$31=1),D40,IF(AND($I$31=5,$J$31=2),E40,IF(AND($I$31=5,$J$31=3),F40,0)))","v":0}]
[null,null,"PM10",0.85,0.68,0.51,null,null,null,null,null,{"$f":"IF(AND($I$31=5,$J$31=1),D41,IF(AND($I$31=5,$J$31=2),E41,IF(AND($I$31=5,$J$31=3),F41,0)))","v":0}]
[null,"HEPA or ULPA filter","PM",0.99980000000000002,0.8,0.6,null,null,null,null,{"$f":"IF(AND($I$31=6,$J$31=1),D42,IF(AND($I$31=6,$J$31=2),E42,IF(AND($I$31=6,$J$31=3),F42,0)))","v":0}]
[null,null,"PM10",0.99980000000000002,0.8,0.6,null,null,null,null,null,{"$f":"IF(AND($I$31=6,$J$31=1),D43,IF(AND($I$31=6,$J$31=2),E43,IF(AND($I$31=6,$J$31=3),F43,0)))","v":0}]
[null,"None claimed",null,null,null,null,null,null,null,null,{"$f":"IF($J$31=7,0,0)","v":0}]
[]
[]
[]
[]
[null,"Ratio Dimensions","High Efficiency","Medium Efficiency","Low Efficiency"]
[null,"Height of inlet, H/D","≤0.44",">0.44 and <0.8","≥0.8"]
[null,"Width of inlet, W/D","≤0.2",">0.2 and <0.375","≥0.375"]
[null,"Diameter of gas exit, De/D","≤0.4",">0.4 and <0.75","≥0.75"]
[null,"Length of vortex finder, S/D","≤0.5",">0.5 and <0.875","≥0.875"]

{"sheet":"Data Validation","index":6,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":true,"merged":[[0,1,0,5],[1,1,1,5],[33,1,33,3],[34,1,34,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[32,4,34,4],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3]]}
[null,{"$f":"Instructions!O4","v":"p-sbap5-19  •  6/5/23"}]
[null,"Air emissions from abrasive blasting"]
[]
[null,"Blast media","Manufacturer Specification",null,"Control equipment","Capture efficiency"]
[null,"Choose one","Choose one",null,"Choose one","Choose one"]
[null,"Sand","Manufacturer maximum rate",null,"Cyclone (high efficiency)","Total enclosure"]
[null,"Grit","Nozzle parameters",null,"Cyclone (medium efficiency)","Certified hood"]
[null,"Shot",null,null,"Cyclone (low efficiency)","Uncertified hood"]
[null,"Other",null,null,"Wet cyclone"]
[null,null,null,null,"Wall or panel filter"]
[null,null,null,null,"HEPA or ULPA filter"]
[null,null,null,null,"None claimed"]
[]
[]
[]
[null,"Flow Rate at the nozzle (lb abrasive/hr)*",null,null,"Choose one"]
[null,"Nozzle Diameter","Nozzle Pressure",null,"hours was the blasting equipment operated?"]
[null,"Choose one","Choose one",null,"actual pounds of abrasive media were used?"]
[null,0.125,30]
[null,0.1875,40]
[null,0.25,50]
[null,0.3125,60]
[null,0.375,70]
[null,0.4375,80]
[null,0.5,90]
[null,0.625,100]
[null,0.75,110]
[null,1,120]
[null,null,130]
[null,null,140]
[]
[]
[null,"Mechanical finishing",null,null,"Ratio of uncaptured to captured emissions from the control equipment"]
[null,"Control equipment type"]
[null,"Choose control equipment type"]
[null,"total enclosure vented to any type of control equipment",null,null,0]
[null,"certified hood vented to a fabric filter",null,null,3.57]
[null,"certified hood vented to a cyclone or other type of control equipment",null,null,1.1399999999999999]
[null,"uncertified hood vented to a fabric filter",null,null,14.29]
[null,"uncertified hood vented to a cyclone or other type of control equipment",null,null,4.54]
[]
[null,"Control equipment selection"]
[null,{"$f":"'Mechanical Finishing'!E29","v":"Choose control equipment type"},null,null,{"$f":"IF(B43=B35,\"--\",IF(B43=B36,E36,IF(B43=B37,E37,IF(B43=B38,E38,IF(B43=B39,E39,IF(B43=B40,E40))))))","v":"--"}]