{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["README","1.0 ","1.1","1.2","2.0","2.0 P70","2.0C","2.0C P70","2.0K","2.0L","2.0P","2.0S","2.0Z","2.1","2.2","2.3","2.4","2.5L","2.7","2.8","2.9","2.T","3.0","3.0 P70","3.0 CK","3.0 List","3.0 List P70","4.0","DRY CLEANER"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":75,"comments":27,"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":"README","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[20,0,20,10],[11,0,11,10],[14,0,14,10],[13,0,13,10],[0,0,0,10],[17,0,17,10],[18,0,18,10],[3,0,3,10],[2,0,2,10],[4,0,5,10],[12,0,12,10],[6,0,6,10],[10,0,10,10],[36,2,36,10],[23,0,23,10],[28,0,28,10],[21,1,21,10],[24,1,24,10],[25,2,25,10],[26,1,26,10],[31,0,31,10],[32,1,32,10],[35,2,35,10],[34,2,34,10],[33,2,33,10],[29,1,29,10]]}
["Emission Inventory Questionnaire (EIQ) Forms created with Microsoft Excel®"]
[]
["This workbook contains multiple worksheets that replicate each of the individual hard copy EIQ forms (see tab names at bottom)."]
["Forms 2.0 P70, 2.0C P70, 2.1, and 3.0 P70 reflect changes finalized in November 2009.  Form 3.0 List is only a tool for Excel users, not a DNR form."]
["These forms have several capabilities not possible in either Word® Fill-In forms or hardcopy versions. (e.g.: automatic calculations, comment boxes and instructions, copy/paste and linking capability, copy-and-edit for future submissions.)"]
[]
["When the EIQ is complete, please print each form, sign Form 1.0 to certify the submission, and follow the invoice mailing instructions."]
[]
["Spreadsheet Features:"]
[]
["Protection: Only the cells requiring data entry can have letters or numbers typed into them; the tab button moves through these cells."]
["Comments: Moving the mouse over a cell with a small red triangle in the upper right-hand corner causes pop-up instructions to appear."]
["Validation: If you type an unacceptable value into a cell, a message will prompt you to re-enter the value."]
["Calculation: Green colored cells will automatically fill with the results of a calculation when the supporting cells are completed."]
["Dropdown: Lists of acceptable entries will appear for some choices."]
[]
["Creating the EIQ:"]
["As with the former Word® Fill-in and hardcopy forms, you will need multiple copies of some EIQ forms, and some forms may not apply to your facility."]
["Follow the tips below to manipulate and edit the forms, creating an EIQ that works for you."]
[]
["Create duplicate forms: "]
[null,"While the form to be duplicated is active, on the Edit menu, click Move or Copy Sheet, and complete the choices."]
[]
["Rename forms: "]
[null,"To clarify the subject of each form, a suggested naming convention is Form Number - Emission Unit Number"]
[null,null,"(e.g.:  2.0 - EP01, 2.0 - EP02, 2.T - EU01, 2.T - EU02)"]
[null,"Double-click the worksheet name tab at the bottom and type the new name over the existing name."]
[]
["Rearranging forms:"]
[null,"Click and hold the form tab at bottom, then slide the arrow to the appropriate position and release."]
[]
["Link cells from different forms:"]
[null,"Linking cells from one form to another can be highly useful, especially for the following:"]
[null,null,"• Linking the fields Facility Name, FIPS County, Plant Number and Emission Year from Form 1.0 to all forms."]
[null,null,"• Linking a worksheet that calculates an emission factor (2.3, 2.7, 2.8) to the emission factor field on Form 2.0."]
[null,null,"• Linking emissions calculated on Form 2.0 to Form 3.0."]
[null,null,"• When a cell is updated, all links that point to that cell will update automatically."]
[null,"Creating cell links by typing the actual cell reference:"]
[null,null,"• Cell links should look like:  ='Worksheet Name'!Cell Name."]
[null,null,"• Since there may be multiples of each form, be sure to use the correct worksheet tab name."]
[null,null,"• Typing in cell references is the only option when linking from a green calculated cell due to protections."]
[null,null,null,"(e.g.,  Link emissions calculated on Form 2.0 to Form 3.0 "]
[null,null,null,null,"To link PM10 emissions on Form 3.0, type the following in cell C11: ='2.0'!F24,"]
[null,null,null,null,"To link SOx emissions on Form 3.0, type the following in cell D11: ='2.0'!F26.)"]
[null,null,"• To link two unlocked cells, a shortcut method is copying the initial cell, then choosing Paste Special, Paste Link."]
[]
["Printing the forms:"]
[null,"From the File menu, in the Print What section, choose either Entire Workbook or Active Sheet(s)."]
[null,"Each worksheet will print on only one page (see the View menu, Page Break Preview) despite any additional text on the page."]
[null,"To print the comment fields, from the File menu, choose Page Setup, the Sheet tab and the Comments dropdown list."]
[]
["Need Assistance?"]
[null,"Contact Us:  ","Missouri Department of Natural Resources"]
[null,null,"Air Pollution Control Program, Emission Inventory Unit"]
[null,null,"Phone: 573-751-4817"]
[null,null,"E-mail:  eiq@dnr.mo.gov"]
[null,null,null,null,null,null,null,null,null,null,"v.1-2015"]

{"sheet":"1.0 ","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[40,6,45,7],[40,8,45,8],[39,0,39,5],[40,0,40,5],[45,0,45,5],[44,0,44,5],[43,0,43,5],[42,0,42,5],[41,0,41,5],[38,6,38,8],[34,0,34,4],[36,0,36,4],[4,0,5,8],[38,0,38,4],[36,5,36,8],[37,5,37,8],[37,0,37,4],[35,0,35,4],[26,2,26,3],[26,0,26,1],[24,7,24,8],[34,7,34,8],[35,7,35,8],[35,5,35,6],[34,5,34,6],[24,4,24,5],[28,0,28,8],[23,7,23,8],[23,0,23,3],[23,4,23,5],[27,0,27,1],[25,4,25,5],[25,0,25,3],[10,0,10,1],[20,3,21,3],[22,0,22,3],[11,7,11,8],[11,4,11,5],[15,0,15,1],[14,0,14,1],[14,2,14,3],[15,2,15,3],[14,6,15,8],[15,4,15,5],[14,4,14,5],[11,0,11,1],[27,2,27,3],[16,0,16,2],[13,0,13,3],[12,0,12,3],[24,0,24,3],[19,7,19,8],[20,7,21,8],[20,6,21,6],[25,7,25,8],[6,0,6,4],[7,0,7,4],[8,5,8,8],[11,2,11,3],[9,5,9,8],[9,0,9,4],[8,0,8,4],[10,7,10,8],[6,7,6,8],[7,7,7,8],[10,2,10,3],[17,0,17,2],[10,4,10,5],[16,4,16,5],[20,4,21,4],[31,0,33,8],[17,4,17,5],[22,4,22,5],[20,5,21,5],[12,4,12,6],[13,4,13,6],[17,6,17,8],[16,6,16,8],[22,7,22,8],[27,7,27,8],[26,7,26,8],[26,4,26,6],[27,4,27,6]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 1.0  GENERAL PLANT INFORMATION"]
["         Request Confidentiality - Check this box only if you intend to formally request confidentiality (see instructions online)."]
[]
["FACILITY NAME",null,null,null,null,"FIPS COUNTY NO.","PLANT NO.","YEAR OF DATA"]
[]
["FACILITY STREET ADDRESS",null,null,null,null,"COUNTY NAME"]
[]
["CITY",null,"ZIP CODE +4",null,"PHONE NUMBER WITH AREA CODE",null,"EXT.","FAX NUMBER WITH AREA CODE"]
[]
["FACILITY MAILING ADDRESS",null,null,null,"CITY",null,null,"STATE","ZIP CODE +4"]
[]
["FACILITY CONTACT NAME ",null,"FACILITY CONTACT TITLE",null,"FACILITY CONTACT E-MAIL",null,"WHERE TO SEND EIQ IN FUTURE (CHECK ONE)"]
[]
["PRODUCT/PRINCIPAL ACTIVITY",null,null,"SIC","NAICS",null,"NUMBER OF EMPLOYEES"]
[]
[null,"LATITUDE","LONGITUDE",null,null,"UTM COORDINATES"]
["DEGREES",null,null,"ZONE","EASTING (M)","NORTHING (M)","ACC (M)","HORIZONTAL DATUM (CHECK ONE)"]
["MINUTES"]
["SECONDS"]
["OWNER OR OPERATOR COMPANY NAME",null,null,null,"PHONE NUMBER WITH AREA CODE",null,"EXT.","FAX NUMBER WITH AREA CODE"]
[]
["MAILING ADDRESS",null,null,null,"CITY",null,"STATE","ZIP CODE +4"]
[]
["CONTACT PERSON NAME ",null,"CONTACT PERSON TITLE",null,"CONTACT PERSON E-MAIL",null,null,"COUNTRY"]
[]
["TOTAL PLANT EMISSIONS FROM FORM 3.0 (TONS PER YEAR)"]
["PM10","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5","NH3 "]
[]
["The undersigned hereby certifies that they have personally examined and are familiar with the information and statements contained herein and further certifies that they believe this information and statements to be true, accurate and complete.  The undersigned certifies that knowingly making a false statement or misrepresenting the facts presented in this document is a violation of state law.  "]
[]
[]
["PRINT NAME OF AUTHORIZED COMPANY REPRESENTATIVE",null,null,null,null,"TITLE"]
[]
["SIGNATURE",null,null,null,null,"DATE"]
[]
["CONTACT INFORMATION"]
["Missouri Department of Natural Resources"]
["Air Pollution Control Program"]
["1659 E. Elm St., P.O. Box 176"]
["Jefferson City, MO 65101"]
["573-751-4817"]
["https://dnr.mo.gov/air/business-industry/air-emissions/reporting"]
["eiq@dnr.mo.gov"]
["MO 780-1431-xls (11-14)            "]

{"sheet":"1.1","index":2,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[8,0,41,9],[4,8,4,9],[5,0,5,4],[4,0,4,4],[5,5,5,6],[5,8,5,9],[7,0,7,9],[6,0,6,9]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 1.1 PROCESS FLOW DIAGRAM"]
["FACILITY NAME",null,null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.","YEAR OF DATA"]
[]
["Use this page or a separate sheet to provide a Process Flow Diagram per the instructions for Form 1.1 in the Instruction Packet.  Do not forget to include all processes used in your facility.  Make sure to label each process "]
["and piece of equipment and provide an identification number for all emission units (including fugitive emissions) and air pollution control equipment.  Make sure to use the same identification number throughout the entire EIQ. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MO 780-1619-xls (12-09)   "]

{"sheet":"1.2","index":3,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[16,1,17,4],[18,8,19,8],[16,6,17,6],[16,5,17,5],[16,9,17,9],[16,8,17,8],[16,7,17,7],[7,0,7,9],[14,1,15,4],[8,0,8,9],[12,5,12,9],[12,1,13,4],[14,5,15,5],[14,6,15,6],[14,9,15,9],[14,8,15,8],[14,7,15,7],[4,8,4,9],[5,0,5,4],[4,0,4,4],[6,0,6,9],[5,5,5,6],[5,8,5,9],[20,1,21,4],[20,5,21,5],[20,6,21,6],[18,5,19,5],[18,6,19,6],[18,1,19,4],[20,7,21,7],[18,7,19,7],[20,8,21,8],[20,9,21,9],[18,9,19,9],[40,9,41,9],[28,9,29,9],[34,1,35,4],[34,5,35,5],[34,6,35,6],[34,7,35,7],[34,8,35,8],[34,9,35,9],[30,7,31,7],[30,8,31,8],[30,9,31,9],[28,7,29,7],[28,8,29,8],[40,1,41,4],[40,5,41,5],[40,6,41,6],[40,7,41,7],[40,8,41,8],[22,1,23,4],[30,1,31,4],[30,5,31,5],[30,6,31,6],[24,5,25,5],[24,6,25,6],[28,1,29,4],[28,5,29,5],[28,6,29,6],[24,1,25,4],[26,1,27,4],[26,5,27,5],[26,6,27,6],[22,5,23,5],[32,8,33,8],[32,9,33,9],[36,8,37,8],[36,9,37,9],[24,9,25,9],[26,7,27,7],[24,7,25,7],[24,8,25,8],[26,8,27,8],[26,9,27,9],[22,9,23,9],[22,8,23,8],[22,7,23,7],[38,8,39,8],[38,9,39,9],[32,6,33,6],[32,7,33,7],[22,6,23,6],[38,7,39,7],[36,1,37,4],[36,5,37,5],[36,6,37,6],[36,7,37,7],[32,1,33,4],[32,5,33,5],[38,1,39,4],[38,5,39,5],[38,6,39,6]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 1.2 SUMMARY OF EMISSION UNITS AND RELATED PROCESSES"]
["FACILITY NAME",null,null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.","YEAR OF DATA"]
[]
["INSTRUCTIONS"]
["If all emissions are under the reporting threshold, mark below as \"Insignificant\", and do not report on Forms 2.0 and 3.0.                   If one pollutant exceeds the reporting threshold, mark below as \"Active\" and report all pollutants on Forms 2.0 and 3.0."]
["REPORTING THRESHOLD"]
["Pollutant","PM10","SOx","NOx","VOC","CO","CATEGORY 1 HAPs","CATEGORY 2 HAPs","PM2.5","NH3"]
["Threshold (lbs)",876,2000,2000,876,2000,20,200,876,876]
["Threshold (tons)",0.438,1,1,0.438,1,0.01,0.1,0.438,0.438]
["EMISSION UNIT NO.","EMISSION UNIT DESCRIPTION                                       (USE SAME DESCRIPTION ON FORM 2.0)",null,null,null,"OPERATING STATUS (CHOOSE ONE)"]
["SCC",null,null,null,null,"Active","Inactive","Dismantled","Under Construction","Insignificant"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MO 780-1620-xls (12-09)   "]

{"sheet":"2.0","index":4,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[31,4,32,4],[23,5,24,5],[25,5,26,5],[27,5,28,5],[29,5,30,5],[31,5,32,5],[35,5,36,5],[37,5,38,5],[39,5,40,5],[35,2,36,2],[37,3,38,3],[35,4,36,4],[37,4,38,4],[39,3,40,3],[35,3,36,3],[39,4,40,4],[43,0,43,7],[42,0,42,7],[19,0,19,7],[23,0,24,0],[25,0,26,0],[27,0,28,0],[29,0,30,0],[33,0,34,0],[27,1,28,1],[29,1,30,1],[25,4,26,4],[33,4,34,4],[29,3,30,3],[31,3,32,3],[33,3,34,3],[27,4,28,4],[25,2,26,2],[23,4,24,4],[6,0,6,7],[31,1,32,1],[33,1,34,1],[31,0,32,0],[16,0,16,1],[16,2,16,3],[23,1,24,1],[25,1,26,1],[27,2,28,2],[29,4,30,4],[7,1,7,7],[8,1,8,7],[23,6,24,7],[33,5,34,5],[4,0,4,3],[4,4,4,5],[5,4,5,5],[5,0,5,3],[15,6,15,7],[15,0,15,1],[13,0,13,2],[13,3,13,4],[13,5,13,6],[9,0,9,7],[10,4,10,7],[11,4,11,7],[10,1,10,3],[11,1,11,3],[12,0,12,4],[14,6,14,7],[37,0,38,0],[39,0,40,0],[15,2,15,3],[37,1,38,1],[39,1,40,1],[35,1,36,1],[39,2,40,2],[37,2,38,2],[35,0,36,0],[31,2,32,2],[29,2,30,2],[23,2,24,2],[23,3,24,3],[25,3,26,3],[27,3,28,3],[33,2,34,2]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0  EMISSION UNIT INFORMATION"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.","YEAR OF DATA"]
[null,null,null,null,"",null,"",""]
["1. EMISSION UNIT IDENTIFICATION"]
["EMISSION UNIT NO.","EMISSION UNIT DESCRIPTION"]
[]
["2. EMISSION PROCESS DETAIL"]
["SEG. NO.","SOURCE CLASSIFICATION CODE (SCC)",null,null,"SCC DESCRIPTION"]
[]
["DO THE EMISSIONS FROM THIS UNIT FLOW THROUGH A STACK OR VENT?",null,null,null,null,"IF YES, COMPLETE FORM 2.0S STACK/VENT INFORMATION"]
["ARE THE EMISSIONS FROM THIS UNIT FUGITIVE?",null,null,null,null,"IF FUGITIVE, WHAT PERCENTAGE?"]
["3. OPERATING RATE/SCHEDULE",null,null,null,null,null,"4. ANNUAL FUEL CHARACTERISTICS"]
["ANNUAL THROUGHPUT ",null,"UNITS",null,"DEC-FEB (%)",null,"For coal or fuel oil, list details below"]
[null,null,null,null,"MAR-MAY (%)",null,"Heat Content (BTU/Fuel Unit)"]
["HOURS / DAY","DAYS / WEEK","WEEKS / YR.","TOTAL HOURS / YR.","JUN-AUG (%)",null,"ASH % (INCLUDE IN EF)"]
[null,null,null,{"$f":"IF(OR($A$19=\"\",$B$19=\"\",$C$19=\"\"),\"\",$A$19*$B$19*$C$19)","v":""},"SEPT-NOV (%)",null,"SULFUR % (INCLUDE IN EF)"]
["5.  EMISSION CALCULATIONS"]
[null,"1.","2.","3.","4.","5."]
["AIR POLLUTANT","SOURCE OF EMISSION FACTOR","EMISSION FACTOR ","EMISSION FACTOR (EF) CONTROL STATUS            ","OVERALL CONTROL EFFICIENCY         (% FORMAT)         ","ACTUAL EMISSIONS   (TONS/YR)"]
["Instructions:","Choose from the Source of Emission Factor List                    at lower right","Lbs./unit of throughput","If EF includes control mark \"C\",               otherwise \"U\"","Combination of all capture and destruction efficiencies ","If controlled, include Form 2.0C Control Device Listing","List Other Worksheets or AP-42/Other Reference"]
["PM10",null,null,null,{"$f":"IF(OR(D24=\"\",B46=\"\"),\"\",IF(AND(D24=\"UNCONTROLLED FACTOR\",B46=\"YES\"),H46,0))","v":""},{"$f":"IF(OR($A$17=\"\",B24=\"\",C24=\"\",D24=\"\",E24=\"\"),\"\",$A$17*C24*(1-E24/100)/2000)","v":""},"SOURCE OF EMISSION FACTOR LIST"]
[]
["SOX ",null,null,null,{"$f":"IF(OR(D26=\"\",B47=\"\"),\"\",IF(AND(D26=\"UNCONTROLLED FACTOR\",B47=\"YES\"),H47,0))","v":""},{"$f":"IF(OR($A$17=\"\",B26=\"\",C26=\"\",D26=\"\",E26=\"\"),\"\",$A$17*C26*(1-E26/100)/2000)","v":""},"1. CEM ","Include documentation"]
[null,null,null,null,null,null,"2. Stack Test","Include documentation"]
["NOX ",null,null,null,{"$f":"IF(OR(D28=\"\",B48=\"\"),\"\",IF(AND(D28=\"UNCONTROLLED FACTOR\",B48=\"YES\"),H48,0))","v":""},{"$f":"IF(OR($A$17=\"\",B28=\"\",C28=\"\",D28=\"\",E28=\"\"),\"\",$A$17*C28*(1-E28/100)/2000)","v":""},"3. Mass Balance","Include documentation"]
[null,null,null,null,null,null,"4. AP-42","Include reference"]
["VOC",null,null,null,{"$f":"IF(OR(D30=\"\",B49=\"\"),\"\",IF(AND(D30=\"UNCONTROLLED FACTOR\",B49=\"YES\"),H49,0))","v":""},{"$f":"IF(OR($A$17=\"\",B30=\"\",C30=\"\",D30=\"\",E30=\"\"),\"\",$A$17*C30*(1-E30/100)/2000)","v":""},"4F. FIRE or webFIRE"]
[null,null,null,null,null,null,"5. Other","Include documentation"]
["CO",null,null,null,{"$f":"IF(OR(D32=\"\",B50=\"\"),\"\",IF(AND(D32=\"UNCONTROLLED FACTOR\",B50=\"YES\"),H50,0))","v":""},{"$f":"IF(OR($A$17=\"\",B32=\"\",C32=\"\",D32=\"\",E32=\"\"),\"\",$A$17*C32*(1-E32/100)/2000)","v":""},"EC. Engr Calc","Include documentation"]
[null,null,null,null,null,null,"LS. Landfill Spdsht","Include documentation"]
["LEAD",null,null,null,{"$f":"IF(OR(D34=\"\",B51=\"\"),\"\",IF(AND(D34=\"UNCONTROLLED FACTOR\",B51=\"YES\"),H51,0))","v":""},{"$f":"IF(OR($A$17=\"\",B34=\"\",C34=\"\",D34=\"\",E34=\"\"),\"\",$A$17*C34*(1-E34/100)/2000)","v":""},"TK. TANKS Program","Supply TANKS output"]
[null,null,null,null,null,null,"2.3. VOC Mass Bal","Complete Form 2.3"]
["HAPs",null,null,null,{"$f":"IF(OR(D36=\"\",B52=\"\"),\"\",IF(AND(D36=\"UNCONTROLLED FACTOR\",B52=\"YES\"),H52,0))","v":""},{"$f":"IF(OR($A$17=\"\",B36=\"\",C36=\"\",D36=\"\",E36=\"\"),\"\",$A$17*C36*(1-E36/100)/2000)","v":""},"2.4. Liquid Loading","Complete Form 2.4"]
[null,null,null,null,null,null,"2.7. Haul Road ","Complete Form 2.7"]
["PM2.5",null,null,null,{"$f":"IF(OR(D38=\"\",B53=\"\"),\"\",IF(AND(D38=\"UNCONTROLLED FACTOR\",B53=\"YES\"),H53,0))","v":""},{"$f":"IF(OR($A$17=\"\",B38=\"\",C38=\"\",D38=\"\",E38=\"\"),\"\",$A$17*C38*(1-E38/100)/2000)","v":""},"2.8. Storage Pile ","Complete Form 2.8"]
[null,null,null,null,null,null,"2.T. HAP Worksheet ","Complete Form 2.T"]
["NH3 ",null,null,null,{"$f":"IF(OR(D40=\"\",B54=\"\"),\"\",IF(AND(D40=\"UNCONTROLLED FACTOR\",B54=\"YES\"),H54,0))","v":""},{"$f":"IF(OR($A$17=\"\",B40=\"\",C40=\"\",D40=\"\",E40=\"\"),\"\",$A$17*C40*(1-E40/100)/2000)","v":""},"2.9. Stack Test/CEM ","Complete Form 2.9"]
[null,null,null,null,null,null,"2.0L. Landfill ","Complete Form 2.0L"]
["MO 780-1621-xls (12-09) "]
["6. OVERALL CONTROL EFFICIENCY (%) WORKSHEET                                                                                                                                                                                                                   "]
["The combination of capture and destruction efficiencies for control devices in a series that reduce emissions."]
["AIR POLLUTANT","IS THERE AN ACTIVE CONTROL DEVICE THAT CONTROLS THIS POLLUTANT?","CAPTURE EFFICIENCY               (CP)                                  (%)","CONTROL             EFFICIENCY             DEVICE 1                           (CE1)                                     (%)","CONTROL EFFICIENCY              DEVICE 2               (CE2)                         (%)","CONTROL EFFICIENCY DEVICE 3                       (CE3)                    (%)","CONTROL EFFICIENCY DEVICE 4                                          (CE4)                           (%)","OVERALL  CONTROLL EFFICIENCY (%)"]
["PM10",null,null,null,null,null,null,{"$f":"IF(B46=\"NO\",0,IF(AND(C46=\"\",D46=\"\",E46=\"\",F46=\"\",G46=\"\"),\"\",IF(E46=0,C46*D46/100,IF(F46=0,C46/100*(D46+E46-D46*E46/100),IF(G46=0,C46/100*(D46+E46+F46-D46*E46/100-D46*F46/100-E46*F46/100+D46*E46*F46/100^2),C46/100*(D46+E46+F46-D46*E46/100-D46*F46/100-E46*F46/100+D46*E46*F46/100^2+G46*(1-D46/100-E46/100+D46*E46/100^2-F46/100+D46*F46/100^2+E46*F46/100^2-D46*E46*F46/100^3)))))))","v":""}]
["SOX ",null,null,null,null,null,null,{"$f":"IF(B47=\"NO\",0,IF(AND(C47=\"\",D47=\"\",E47=\"\",F47=\"\",G47=\"\"),\"\",IF(E47=0,C47*D47/100,IF(F47=0,C47/100*(D47+E47-D47*E47/100),IF(G47=0,C47/100*(D47+E47+F47-D47*E47/100-D47*F47/100-E47*F47/100+D47*E47*F47/100^2),C47/100*(D47+E47+F47-D47*E47/100-D47*F47/100-E47*F47/100+D47*E47*F47/100^2+G47*(1-D47/100-E47/100+D47*E47/100^2-F47/100+D47*F47/100^2+E47*F47/100^2-D47*E47*F47/100^3)))))))","v":""}]
["NOX ",null,null,null,null,null,null,""]
["VOC",null,null,null,null,null,null,""]
["CO",null,null,null,null,null,null,""]
["LEAD",null,null,null,null,null,null,""]
["HAPs",null,null,null,null,null,null,""]
["PM2.5",null,null,null,null,null,null,""]
["NH3 ",null,null,null,null,null,null,""]

{"sheet":"2.0 P70","index":5,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[41,5,42,5],[37,4,38,4],[37,5,38,5],[39,5,40,5],[41,4,42,4],[37,3,38,3],[31,1,32,1],[41,0,42,0],[41,1,42,1],[41,2,42,2],[41,3,42,3],[39,0,40,0],[4,4,4,5],[5,4,5,5],[5,0,5,3],[13,0,13,2],[13,3,13,4],[13,5,13,6],[9,0,9,7],[10,4,10,7],[11,4,11,7],[10,1,10,3],[4,0,4,3],[11,1,11,3],[12,0,12,4],[6,0,6,7],[12,5,12,7],[14,6,14,7],[35,0,36,0],[31,2,32,2],[29,2,30,2],[23,2,24,2],[23,3,24,3],[25,3,26,3],[27,3,28,3],[15,6,15,7],[15,2,15,3],[35,1,36,1],[33,2,34,2],[15,0,15,1],[23,4,24,4],[25,4,26,4],[16,0,16,1],[16,2,16,3],[23,1,24,1],[25,1,26,1],[27,2,28,2],[25,2,26,2],[19,0,19,7],[23,0,24,0],[25,0,26,0],[27,0,28,0],[29,0,30,0],[27,1,28,1],[29,1,30,1],[29,3,30,3],[33,3,34,3],[27,4,28,4],[29,4,30,4],[35,5,36,5],[45,0,45,7],[44,0,44,7],[33,0,34,0],[33,1,34,1],[31,0,32,0],[39,1,40,1],[39,2,40,2],[31,3,32,3],[33,4,34,4],[37,0,38,0],[37,1,38,1],[37,2,38,2],[41,6,42,7],[7,1,7,7],[8,1,8,7],[33,5,34,5],[23,5,24,5],[25,5,26,5],[27,5,28,5],[29,5,30,5],[31,5,32,5],[31,4,32,4],[23,6,24,7],[35,2,36,2],[35,4,36,4],[39,3,40,3],[35,3,36,3],[39,4,40,4]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0 PART 70 OPERATING PERMIT EMISSION UNIT INFORMATION"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.","YEAR OF DATA"]
[null,null,null,null,"",null,"",""]
["1. EMISSION UNIT IDENTIFICATION"]
["EMISSION UNIT NO.","EMISSION UNIT DESCRIPTION"]
[]
["2. EMISSION PROCESS DETAIL"]
["SEG. NO.","SOURCE CLASSIFICATION CODE (SCC)",null,null,"SCC DESCRIPTION"]
[]
["DO THE EMISSIONS FROM THIS UNIT FLOW THROUGH A STACK OR VENT?",null,null,null,null,"IF YES, COMPLETE FORM 2.0S STACK/VENT INFORMATION"]
["ARE THE EMISSIONS FROM THIS UNIT FUGITIVE?",null,null,null,null,"IF FUGITIVE, WHAT PERCENTAGE?"]
["3. OPERATING RATE/SCHEDULE",null,null,null,null,null,"4. ANNUAL FUEL CHARACTERISTICS"]
["ANNUAL THROUGHPUT ",null,"UNITS",null,"DEC-FEB (%)",null,"For coal or fuel oil, list details below"]
[null,null,null,null,"MAR-MAY (%)",null,"Heat Content (BTU/Fuel Unit)"]
["HOURS / DAY","DAYS / WEEK","WEEKS / YR","TOTAL HOURS / YR","JUN-AUG (%)",null,"ASH % (INCLUDE IN EF)"]
[null,null,null,{"$f":"IF(OR($A$19=\"\",$B$19=\"\",$C$19=\"\"),\"\",$A$19*$B$19*$C$19)","v":""},"SEPT-NOV (%)",null,"SULFUR % (INCLUDE IN EF)"]
["5.  EMISSION CALCULATIONS"]
[null,"1.","2.","3.","4.","5."]
["AIR POLLUTANT","SOURCE OF EMISSION FACTOR","EMISSION FACTOR ","EMISSION FACTOR (EF) CONTROL STATUS            ","OVERALL CONTROL EFFICIENCY         (% FORMAT)         ","ACTUAL EMISSIONS   (TONS/YR)"]
["Instructions:","Choose from the Source of Emission Factor List                    at lower right","Lbs/unit of throughput","If EF includes control mark \"C\",               otherwise \"U\"","Combination of all capture and destruction efficiencies ","If controlled, include Form 2.0C Control Device Listing","List Other Worksheets or AP-42/Other Reference"]
["PM10 FIL *",null,null,null,{"$f":"IF(OR(D24=\"\",B48=\"\"),\"\",IF(AND(D24=\"UNCONTROLLED FACTOR\",B48=\"YES\"),H48,0))","v":""},{"$f":"IF(OR($A$17=\"\",B24=\"\",C24=\"\",D24=\"\",E24=\"\"),\"\",$A$17*C24*(1-E24/100)/2000)","v":""},"SOURCE OF EMISSION FACTOR LIST"]
[]
["SOX ",null,null,null,{"$f":"IF(OR(D26=\"\",B49=\"\"),\"\",IF(AND(D26=\"UNCONTROLLED FACTOR\",B49=\"YES\"),H49,0))","v":""},{"$f":"IF(OR($A$17=\"\",B26=\"\",C26=\"\",D26=\"\",E26=\"\"),\"\",$A$17*C26*(1-E26/100)/2000)","v":""},"1. CEM ","Include documentation"]
[null,null,null,null,null,null,"2. Stack Test","Include documentation"]
["NOX ",null,null,null,{"$f":"IF(OR(D28=\"\",B50=\"\"),\"\",IF(AND(D28=\"UNCONTROLLED FACTOR\",B50=\"YES\"),H50,0))","v":""},{"$f":"IF(OR($A$17=\"\",B28=\"\",C28=\"\",D28=\"\",E28=\"\"),\"\",$A$17*C28*(1-E28/100)/2000)","v":""},"3. Mass Balance","Include documentation"]
[null,null,null,null,null,null,"4. AP-42","Include reference"]
["VOC",null,null,null,{"$f":"IF(OR(D30=\"\",B51=\"\"),\"\",IF(AND(D30=\"UNCONTROLLED FACTOR\",B51=\"YES\"),H51,0))","v":""},{"$f":"IF(OR($A$17=\"\",B30=\"\",C30=\"\",D30=\"\",E30=\"\"),\"\",$A$17*C30*(1-E30/100)/2000)","v":""},"4F. FIRE or webFIRE"]
[null,null,null,null,null,null,"5. Other","Include documentation"]
["CO",null,null,null,{"$f":"IF(OR(D32=\"\",B52=\"\"),\"\",IF(AND(D32=\"UNCONTROLLED FACTOR\",B52=\"YES\"),H52,0))","v":""},{"$f":"IF(OR($A$17=\"\",B32=\"\",C32=\"\",D32=\"\",E32=\"\"),\"\",$A$17*C32*(1-E32/100)/2000)","v":""},"EC. Engr Calc","Include documentation"]
[null,null,null,null,null,null,"LS. Landfill Spdsht","Include documentation"]
["LEAD",null,null,null,{"$f":"IF(OR(D34=\"\",B53=\"\"),\"\",IF(AND(D34=\"UNCONTROLLED FACTOR\",B53=\"YES\"),H53,0))","v":""},{"$f":"IF(OR($A$17=\"\",B34=\"\",C34=\"\",D34=\"\",E34=\"\"),\"\",$A$17*C34*(1-E34/100)/2000)","v":""},"TK. TANKS Program","Supply TANKS output"]
[null,null,null,null,null,null,"2.3. VOC Mass Bal","Complete Form 2.3"]
["HAPs",null,null,null,{"$f":"IF(OR(D36=\"\",B54=\"\"),\"\",IF(AND(D36=\"UNCONTROLLED FACTOR\",B54=\"YES\"),H54,0))","v":""},{"$f":"IF(OR($A$17=\"\",B36=\"\",C36=\"\",D36=\"\",E36=\"\"),\"\",$A$17*C36*(1-E36/100)/2000)","v":""},"2.4. Liquid Loading","Complete Form 2.4"]
[null,null,null,null,null,null,"2.7. Haul Road ","Complete Form 2.7"]
["PM2.5 FIL *",null,null,null,{"$f":"IF(OR(D38=\"\",B57=\"\"),\"\",IF(AND(D38=\"UNCONTROLLED FACTOR\",B57=\"YES\"),H57,0))","v":""},{"$f":"IF(OR($A$17=\"\",B38=\"\",C38=\"\",D38=\"\",E38=\"\"),\"\",$A$17*C38*(1-E38/100)/2000)","v":""},"2.8. Storage Pile ","Complete Form 2.8"]
[null,null,null,null,null,null,"2.T. HAP Worksheet ","Complete Form 2.T"]
["NH3 ",null,null,null,{"$f":"IF(OR(D40=\"\",B56=\"\"),\"\",IF(AND(D40=\"UNCONTROLLED FACTOR\",B56=\"YES\"),H56,0))","v":""},{"$f":"IF(OR($A$17=\"\",B40=\"\",C40=\"\",D40=\"\",E40=\"\"),\"\",$A$17*C40*(1-E40/100)/2000)","v":""},"2.9. Stack Test/CEM ","Complete Form 2.9"]
[null,null,null,null,null,null,"2.0L. Landfill ","Complete Form 2.0L"]
["PM CON *",null,null,null,{"$f":"IF(OR(D42=\"\",B57=\"\"),\"\",IF(AND(D42=\"UNCONTROLLED FACTOR\",B57=\"YES\"),H57,0))","v":""},{"$f":"IF(OR($A$17=\"\",B42=\"\",C42=\"\",D42=\"\",E42=\"\"),\"\",$A$17*C42*(1-E42/100)/2000)","v":""},"* If PM CON is reported, PM10 and PM25 entries above are required and should represent only the filterable PM10 and filterable PM25."]
[]
["MO 780-2087-xls (12-09) "]
["6. OVERALL CONTROL EFFICIENCY (%) WORKSHEET                                                                                                                                                                                                                   "]
["The combination of capture and destruction efficiencies for control devices in a series that reduce emissions."]
["AIR POLLUTANT","IS THERE AN ACTIVE CONTROL DEVICE THAT CONTROLS THIS POLLUTANT?","CAPTURE EFFICIENCY               (CP)                                  (%)","CONTROL             EFFICIENCY             DEVICE 1                           (CE1)                                     (%)","CONTROL EFFICIENCY              DEVICE 2               (CE2)                         (%)","CONTROL EFFICIENCY DEVICE 3                       (CE3)                    (%)","CONTROL EFFICIENCY                                                 DEVICE 4                                       (CE4)                           (%)","OVERALL  CONTROLL EFFICIENCY (%)"]
["PM10 FIL",null,null,null,null,null,null,{"$f":"IF(B48=\"NO\",0,IF(AND(C48=\"\",D48=\"\",E48=\"\",F48=\"\",G48=\"\"),\"\",IF(E48=0,C48*D48/100,IF(F48=0,C48/100*(D48+E48-D48*E48/100),IF(G48=0,C48/100*(D48+E48+F48-D48*E48/100-D48*F48/100-E48*F48/100+D48*E48*F48/100^2),C48/100*(D48+E48+F48-D48*E48/100-D48*F48/100-E48*F48/100+D48*E48*F48/100^2+G48*(1-D48/100-E48/100+D48*E48/100^2-F48/100+D48*F48/100^2+E48*F48/100^2-D48*E48*F48/100^3)))))))","v":""}]
["SOX ",null,null,null,null,null,null,""]
["NOX ",null,null,null,null,null,null,""]
["VOC",null,null,null,null,null,null,""]
["CO",null,null,null,null,null,null,""]
["LEAD",null,null,null,null,null,null,""]
["HAPs",null,null,null,null,null,null,""]
["PM2.5 FIL",null,null,null,null,null,null,""]
["NH3 ",null,null,null,null,null,null,""]
["PM CON",null,null,null,null,null,null,""]

{"sheet":"2.0C","index":6,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[34,0,34,1],[38,0,38,2],[38,3,38,10],[32,0,32,4],[32,5,32,10],[33,0,33,7],[33,8,33,10],[35,0,35,1],[37,0,37,1],[36,0,36,1],[22,0,22,7],[22,8,22,10],[28,7,28,8],[24,0,24,1],[25,0,25,1],[23,0,23,1],[18,7,18,8],[18,9,18,10],[19,7,19,10],[20,7,20,10],[20,0,20,6],[18,3,18,5],[19,0,19,6],[18,0,18,2],[4,9,4,10],[4,7,4,8],[4,5,4,6],[4,0,4,4],[6,7,6,8],[5,0,5,4],[5,5,5,6],[5,7,5,8],[21,0,21,4],[21,5,21,10],[10,0,10,4],[10,5,10,10],[12,0,12,1],[17,7,17,8],[17,9,17,10],[11,0,11,7],[11,8,11,10],[16,3,16,10],[17,3,17,5],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,2],[17,0,17,2],[9,7,9,10],[5,9,5,10],[9,0,9,6],[7,7,7,8],[8,7,8,10],[8,0,8,6],[6,3,6,5],[6,0,6,2],[7,9,7,10],[6,9,6,10],[7,3,7,5],[7,0,7,2],[26,0,26,1],[31,0,31,6],[27,3,27,10],[28,0,28,2],[28,3,28,5],[27,0,27,2],[30,0,30,6],[30,7,30,10],[31,7,31,10],[28,9,28,10],[29,3,29,5],[29,7,29,8],[29,9,29,10],[29,0,29,2]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0C CONTROL DEVICE INFORMATION"]
["FACILITY NAME",null,null,null,null,"FIPS COUNTY NO.  ",null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.","DEVICE NO.",null,"DEVICE CODE"]
[]
["CONTROL DEVICE DESCRIPTION",null,null,null,null,null,null,"OPERATING STATUS (CHECK ONE)"]
[]
["ARE THE EMISSIONS CONTROLLED THROUGH THE STACK/VENT ONLY?"]
["LIST ALL STACK/VENT NUMBERS SHARING THIS CONTROL DEVICE (LISTED ON FORM 2.0S STACK/VENT INFORMATION)"]
["AIR POLLUTANT",null,"PM10","SOX ","NOX ","VOC","CO","LEAD","HAP(s)","PM2.5","NH3 "]
["CAPTURE EFFICIENCY (%)"]
["CONTROL DEVICE EFFICIENCY (%)"]
["SOURCE OF EFFICIENCY (CODES)"]
["CAS NUMBER(S) FOR CONTROLLED HAPS"]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.","DEVICE NO.",null,"DEVICE CODE"]
[]
["CONTROL DEVICE DESCRIPTION",null,null,null,null,null,null,"OPERATING STATUS (CHECK ONE)"]
[]
["ARE THE EMISSIONS CONTROLLED THROUGH THE STACK/VENT ONLY?"]
["LIST ALL STACK/VENT NUMBERS SHARING THIS CONTROL DEVICE (LISTED ON FORM 2.0S STACK/VENT INFORMATION)"]
["AIR POLLUTANT",null,"PM10","SOX ","NOX ","VOC","CO","LEAD","HAP(s)","PM2.5","NH3 "]
["CAPTURE EFFICIENCY (%)"]
["CONTROL DEVICE EFFICIENCY (%)"]
["SOURCE OF EFFICIENCY (CODES)"]
["CAS NUMBER(S) FOR CONTROLLED HAPS"]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.","DEVICE NO.",null,"DEVICE CODE"]
[]
["CONTROL DEVICE DESCRIPTION",null,null,null,null,null,null,"OPERATING STATUS (CHECK ONE)"]
[]
["ARE THE EMISSIONS CONTROLLED THROUGH THE STACK/VENT ONLY?"]
["LIST ALL STACK/VENT NUMBERS SHARING THIS CONTROL DEVICE (LISTED ON FORM 2.0S STACK/VENT INFORMATION)"]
["AIR POLLUTANT",null,"PM10","SOX ","NOX ","VOC","CO","LEAD","HAP(s)","PM2.5","NH3 "]
["CAPTURE EFFICIENCY (%)"]
["CONTROL DEVICE EFFICIENCY (%)"]
["SOURCE OF EFFICIENCY (CODES)"]
["CAS NUMBER(S) FOR CONTROLLED HAPS"]
["MO 780-1434-xls (12-09) "]

{"sheet":"2.0C P70","index":7,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[9,7,9,11],[22,8,22,11],[5,9,5,11],[7,3,7,5],[8,7,8,11],[7,7,7,8],[7,9,7,11],[5,7,5,8],[8,0,8,6],[6,7,6,8],[6,3,6,5],[4,5,4,6],[4,0,4,4],[5,0,5,4],[5,5,5,6],[4,9,4,11],[4,7,4,8],[6,9,6,11],[18,0,18,2],[10,0,10,4],[12,0,12,1],[13,0,13,1],[11,0,11,7],[11,8,11,11],[17,9,17,11],[17,0,17,2],[17,3,17,5],[6,0,6,2],[7,0,7,2],[9,0,9,6],[18,7,18,8],[10,5,10,11],[16,3,16,11],[14,0,14,1],[15,0,15,1],[16,0,16,2],[29,9,29,11],[28,9,28,11],[23,0,23,1],[25,0,25,1],[26,0,26,1],[27,0,27,2],[18,9,18,11],[24,0,24,1],[21,5,21,11],[20,7,20,11],[27,3,27,11],[28,3,28,5],[28,7,28,8],[17,7,17,8],[22,0,22,7],[19,7,19,11],[18,3,18,5],[19,0,19,6],[20,0,20,6],[21,0,21,4],[28,0,28,2],[38,0,38,2],[32,0,32,4],[29,3,29,5],[35,0,35,1],[37,0,37,1],[36,0,36,1],[33,0,33,7],[38,3,38,11],[32,5,32,11],[29,7,29,8],[30,0,30,6],[34,0,34,1],[29,0,29,2],[31,0,31,6],[31,7,31,11],[30,7,30,11],[33,8,33,11]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0C PART 70 OPERATING PERMIT CONTROL DEVICE INFORMATION"]
["FACILITY NAME",null,null,null,null,"FIPS COUNTY NO.  ",null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.","DEVICE NO.",null,"DEVICE CODE"]
[]
["CONTROL DEVICE DESCRIPTION",null,null,null,null,null,null,"OPERATING STATUS (CHECK ONE)"]
[]
["ARE THE EMISSIONS CONTROLLED THROUGH THE STACK/VENT ONLY?"]
["LIST ALL STACK/VENT NUMBERS SHARING THIS CONTROL DEVICE (LISTED ON FORM 2.0S STACK/VENT INFORMATION)"]
["AIR POLLUTANT",null,"PM10 FIL","SOX ","NOX ","VOC","CO","LEAD","HAP(s)","PM2.5 FIL","NH3 ","PM CON"]
["CAPTURE EFFICIENCY (%)"]
["CONTROL DEVICE EFFICIENCY (%)"]
["SOURCE OF EFFICIENCY (CODES)"]
["CAS NUMBER(S) FOR CONTROLLED HAPS"]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.","DEVICE NO.",null,"DEVICE CODE"]
[]
["CONTROL DEVICE DESCRIPTION",null,null,null,null,null,null,"OPERATING STATUS (CHECK ONE)"]
[]
["ARE THE EMISSIONS CONTROLLED THROUGH THE STACK/VENT ONLY?"]
["LIST ALL STACK/VENT NUMBERS SHARING THIS CONTROL DEVICE (LISTED ON FORM 2.0S STACK/VENT INFORMATION)"]
["AIR POLLUTANT",null,"PM10 FIL","SOX ","NOX ","VOC","CO","LEAD","HAP(s)","PM2.5 FIL","NH3 ","PM CON"]
["CAPTURE EFFICIENCY (%)"]
["CONTROL DEVICE EFFICIENCY (%)"]
["SOURCE OF EFFICIENCY (CODES)"]
["CAS NUMBER(S) FOR CONTROLLED HAPS"]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.","DEVICE NO.",null,"DEVICE CODE"]
[]
["CONTROL DEVICE DESCRIPTION",null,null,null,null,null,null,"OPERATING STATUS (CHECK ONE)"]
[]
["ARE THE EMISSIONS CONTROLLED THROUGH THE STACK/VENT ONLY?"]
["LIST ALL STACK/VENT NUMBERS SHARING THIS CONTROL DEVICE (LISTED ON FORM 2.0S STACK/VENT INFORMATION)"]
["AIR POLLUTANT",null,"PM10 FIL","SOX ","NOX ","VOC","CO","LEAD","HAP(s)","PM2.5 FIL","NH3 ","PM CON"]
["CAPTURE EFFICIENCY (%)"]
["CONTROL DEVICE EFFICIENCY (%)"]
["SOURCE OF EFFICIENCY (CODES)"]
["CAS NUMBER(S) FOR CONTROLLED HAPS"]
["MO 780-2088-xls (12-09) "]

{"sheet":"2.0K","index":8,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[33,0,34,1],[33,2,34,3],[33,4,34,5],[32,0,32,1],[35,0,35,8],[36,0,36,8],[37,0,37,1],[37,2,37,3],[37,6,37,7],[37,8,38,8],[38,0,38,1],[38,2,38,3],[38,6,38,7],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,31,8],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[32,2,32,3],[32,4,32,5],[32,6,32,7],[23,8,24,8],[24,0,24,1],[24,2,24,3],[24,4,24,5],[24,6,24,7],[26,0,27,1],[26,2,27,3],[26,4,27,5],[28,0,28,8],[25,0,25,1],[25,2,25,3],[25,4,25,5],[25,6,25,7],[43,0,43,8],[38,4,38,5],[39,0,39,1],[37,4,37,5],[39,2,39,3],[39,4,39,5],[42,0,42,8],[39,6,39,7],[40,0,41,1],[40,2,41,3],[9,4,9,5],[9,6,9,7],[10,6,10,7],[10,4,10,5],[40,4,41,5],[12,2,13,3],[17,6,17,7],[10,2,10,3],[29,0,29,8],[30,0,30,1],[10,0,10,1],[11,2,11,3],[9,8,10,8],[11,4,11,5],[11,6,11,7],[11,0,11,1],[9,0,9,1],[9,2,9,3],[21,0,21,8],[22,0,22,8],[23,0,23,1],[23,2,23,3],[23,4,23,5],[23,6,23,7],[16,8,17,8],[16,6,16,7],[18,6,18,7],[12,4,13,5],[15,0,15,8],[12,0,13,1],[14,0,14,8],[17,0,17,1],[17,2,17,3],[17,4,17,5],[16,0,16,1],[16,2,16,3],[16,4,16,5],[19,0,20,1],[19,2,20,3],[19,4,20,5],[18,0,18,1],[18,2,18,3],[18,4,18,5],[5,5,5,6],[5,3,5,4],[4,7,4,8],[4,0,4,2],[4,3,4,4],[4,5,4,6],[5,7,5,8],[5,0,5,2],[8,0,8,8],[6,7,6,8],[6,0,6,2],[6,3,6,6],[7,0,7,2],[7,7,7,8],[7,3,7,6]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0K CHARCOAL KILN INFORMATION"]
["FACILITY NAME",null,null,"FIPS COUNTY NO.",null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,null,"SEG. NO."]
[]
["COMPLETE ONE OF THE FOLLOWING SECTIONS FOR EACH CHARCOAL KILN/CONCRETE PAD"]
["KILN ID NO.",null,"YEAR KILN BEGAN OPERATING",null,"TONS PRODUCED THIS YEAR",null,"IF NO PRODUCTION, LAST YEAR OF PRODUCTION",null,"AFTERBURNER OR RECOVERY SYSTEM"]
[]
["MAXIMUM TONS PRODUCED IN ONE BATCH",null,"NUMBER OF HOURS REQUIRED TO PRODUCE ONE BATCH",null,"MAX HOURLY DESIGN RATE",null,"DOLLARS SPENT ON RENOVATION"]
[null,null,null,null,{"$f":"IF(OR(A13=\"\",C13=\"\"),\"\",A13/C13)","v":""},null,"LAST YEAR","SINCE 1991"]
[]
["PRESENT CONDITION"]
[]
["KILN ID NO.",null,"YEAR KILN BEGAN OPERATING",null,"TONS PRODUCED THIS YEAR",null,"IF NO PRODUCTION, LAST YEAR OF PRODUCTION",null,"AFTERBURNER OR RECOVERY SYSTEM"]
[]
["MAXIMUM TONS PRODUCED IN ONE BATCH",null,"NUMBER OF HOURS REQUIRED TO PRODUCE ONE BATCH",null,"MAX HOURLY DESIGN RATE",null,"DOLLARS SPENT ON RENOVATION"]
[null,null,null,null,{"$f":"IF(OR(A20=\"\",C20=\"\"),\"\",A20/C20)","v":""},null,"LAST YEAR","SINCE 1991"]
[]
["PRESENT CONDITION"]
[]
["KILN ID NO.",null,"YEAR KILN BEGAN OPERATING",null,"TONS PRODUCED THIS YEAR",null,"IF NO PRODUCTION, LAST YEAR OF PRODUCTION",null,"AFTERBURNER OR RECOVERY SYSTEM"]
[]
["MAXIMUM TONS PRODUCED IN ONE BATCH",null,"NUMBER OF HOURS REQUIRED TO PRODUCE ONE BATCH",null,"MAX HOURLY DESIGN RATE",null,"DOLLARS SPENT ON RENOVATION"]
[null,null,null,null,{"$f":"IF(OR(A27=\"\",C27=\"\"),\"\",A27/C27)","v":""},null,"LAST YEAR","SINCE 1991"]
[]
["PRESENT CONDITION"]
[]
["KILN ID NO.",null,"YEAR KILN BEGAN OPERATING",null,"TONS PRODUCED THIS YEAR",null,"IF NO PRODUCTION, LAST YEAR OF PRODUCTION",null,"AFTERBURNER OR RECOVERY SYSTEM"]
[]
["MAXIMUM TONS PRODUCED IN ONE BATCH",null,"NUMBER OF HOURS REQUIRED TO PRODUCE ONE BATCH",null,"MAX HOURLY DESIGN RATE",null,"DOLLARS SPENT ON RENOVATION"]
[null,null,null,null,{"$f":"IF(OR(A34=\"\",C34=\"\"),\"\",A34/C34)","v":""},null,"LAST YEAR","SINCE 1991"]
[]
["PRESENT CONDITION"]
[]
["KILN ID NO.",null,"YEAR KILN BEGAN OPERATING",null,"TONS PRODUCED THIS YEAR",null,"IF NO PRODUCTION, LAST YEAR OF PRODUCTION",null,"AFTERBURNER OR RECOVERY SYSTEM"]
[]
["MAXIMUM TONS PRODUCED IN ONE BATCH",null,"NUMBER OF HOURS REQUIRED TO PRODUCE ONE BATCH",null,"MAX HOURLY DESIGN RATE",null,"DOLLARS SPENT ON RENOVATION"]
[null,null,null,null,{"$f":"IF(OR(A41=\"\",C41=\"\"),\"\",A41/C41)","v":""},null,"LAST YEAR","SINCE 1991"]
[]
["PRESENT CONDITION"]
[]
["MO 780-1530-xls (12-09)"]

{"sheet":"2.0L","index":9,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[18,0,18,4],[18,5,18,9],[19,0,19,3],[25,0,25,9],[22,0,22,4],[23,5,23,8],[21,5,21,9],[13,0,13,2],[15,3,15,6],[14,3,14,5],[10,0,12,2],[15,7,17,9],[14,0,17,2],[7,4,7,7],[8,0,8,9],[12,7,14,9],[6,4,6,7],[44,5,44,8],[44,0,44,3],[40,0,40,3],[16,6,17,6],[16,3,17,5],[21,0,21,3],[32,5,32,9],[29,5,29,8],[24,0,24,9],[20,5,20,9],[7,8,7,9],[9,7,11,9],[4,0,4,2],[5,0,5,2],[5,3,5,5],[26,5,26,9],[26,0,26,4],[9,0,9,2],[9,3,9,6],[5,6,5,7],[6,8,6,9],[22,5,22,9],[6,0,6,3],[10,3,10,6],[13,3,13,6],[11,3,11,6],[12,3,12,5],[7,0,7,3],[20,0,20,4],[28,0,28,4],[27,5,27,8],[23,0,23,3],[30,5,30,9],[29,0,29,3],[43,0,43,4],[43,5,43,9],[41,0,41,9],[42,0,42,9],[40,5,40,8],[39,0,39,4],[39,5,39,9],[35,5,35,8],[35,0,35,3],[38,0,38,9],[37,0,37,9],[5,8,5,9],[4,8,4,9],[4,6,4,7],[4,3,4,5],[36,0,36,9],[34,0,34,4],[34,5,34,9],[32,0,32,4],[30,0,30,4],[28,5,28,9],[31,5,31,8],[33,5,33,8],[27,0,27,3],[33,0,33,3],[31,0,31,3],[19,5,19,9]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0L LANDFILL WORKSHEET"]
["FACILITY NAME",null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["EMISSION UNIT NO.",null,null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,null,"SEG. NO."]
[]
["LANDFILL INFORMATION"]
["TYPE OF LANDFILL (CHECK ONE)",null,null,"IF CLOSED, DATE OF LAST WASTE ACCEPTED",null,null,null,"Used EPA's software (LANDGEM) (attach summary)"]
[]
[null,null,null,"TIME SINCE CLOSURE (YRS.) c="]
[null,null,null,null,null,null,"CELL(B15)","Used DNR spreadsheet created with Microsoft® Excel® (attach copies)"]
["TYPE OF CONTROL (CHECK ONE)",null,null,"TIME SINCE INITIAL REFUSE PLACEMENT (YRS.) t="]
[null,null,null,null,null,null,"CELL(B13)"]
[null,null,null,"CAPTURE EFFICIENCY",null,null,null,"Default capture efficiency is 75 percent.  Documentation must be supplied for other values."]
[null,null,null,null,null,null,"CELL(B17)"]
[]
["DESTRUCTION EFFICIENCY (%)",null,null,null,null,"LANDFILL DESIGN CAPACITY (CUBIC METERS)"]
[null,null,null,null,"CELL(B24)"]
["AVERAGE ANNUAL REFUSE ACCEPTANCE RATE (Mg/YR.) R=",null,null,null,null,"MASS OF SOLID WASTE IN THE LANDFILL (Mg)"]
[null,null,null,null,"CELL(B14)"]
["ACRES OF LANDFILL",null,null,null,null,"GAS SENT OFF-SITE (MMCF)"]
[null,null,null,null,"CELL(B16)",null,null,null,null,"CELL(B18)"]
["CALCULATION OF EMISSIONS"]
["Default values are 100 m^3/Mg for L (Methane generation rate potential) and 0.04/yr for k (Methane generation rate constant)."]
["METHANE GENERATION RATE (QCH4) (m3/YR.)",null,null,null,null,"METHANE GENERATION RATE (MMCF)"]
[null,null,null,null,"CELL(G11)",null,null,null,null,"CELL(H11)"]
["SO2 EMISSIONS (LB./YR.)",null,null,null,null,"HCl EMISSIONS (LB./YR.)"]
[null,null,null,null,"CELL(N35)",null,null,null,null,"CELL(I50)"]
["NMOC (VOC) FUGITIVE EMISSIONS (LB./YR.)",null,null,null,null,"NMOC (HAP ONLY) FUGITIVE EMISSIONS (LB./YR.)"]
[null,null,null,null,"CELL(G88)",null,null,null,null,"CELL(G51)"]
["NMOC (VOC) COLLECTED, UNCONTROLLED (LB./YR.)",null,null,null,null,"NMOC (HAP ONLY) COLLECTED, UNCONTROLLED (LB./YR.)"]
[null,null,null,null,"CELL(I88)",null,null,null,null,"CELL(I51)"]
["NMOC (VOC) EMISSIONS FROM CONTROL (LB./YR.)",null,null,null,null,"NMOC (HAP ONLY) EMISSIONS FROM CONTROL (LB./YR.)"]
[null,null,null,null,"CELL(K88)",null,null,null,null,"CELL(K51)"]
["CALCULATION OF EMISSION FACTORS"]
["Report fugitive emissions and controlled emissions on separate Forms 2.0."]
["Fugitive emissions use SCC 50100402, throughput units of acres."]
["VOC FUGITIVE EMISSION FACTOR (LB./ACRE)",null,null,null,null,"HAP FUGITIVE EMISSION FACTOR (LB./ACRE)"]
[null,null,null,null,"CELL(L31)",null,null,null,null,"CELL(L32)"]
["Waste gas flares use SCC 50100410, throughput unit of MMCF burned."]
["For SCCs for other controls, contact your regulatory agency."]
["VOC TO CONTROL EMISSION FACTOR (LB./MMCF)",null,null,null,null,"HAP TO CONTROL EMISSION FACTOR (LB./MMCF)"]
[null,null,null,null,"CELL(N31)",null,null,null,null,"CELL(N33)"]
["MO 780-1583-xls (12-09)"]

{"sheet":"2.0P","index":10,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[27,5,27,7],[32,0,32,7],[6,0,6,7],[43,3,44,3],[43,4,44,4],[43,5,44,5],[43,6,44,7],[7,4,7,7],[9,3,9,5],[10,3,10,5],[41,3,41,7],[42,6,42,7],[17,4,18,4],[15,3,15,7],[17,3,18,3],[17,6,18,7],[26,5,26,7],[27,3,27,4],[4,0,4,1],[5,0,5,1],[5,6,5,7],[5,4,5,5],[5,2,5,3],[4,6,4,7],[4,4,4,5],[4,2,4,3],[10,0,10,2],[9,0,9,2],[8,4,8,7],[7,0,7,1],[8,0,8,1],[25,0,25,2],[11,3,12,4],[14,0,14,2],[13,0,13,2],[17,5,18,5],[23,0,23,2],[23,3,23,5],[14,5,14,7],[13,3,13,4],[14,3,14,4],[13,5,13,7],[22,0,22,2],[22,3,22,5],[11,0,11,2],[12,0,12,2],[21,4,21,7],[16,6,16,7],[26,3,26,4],[26,0,26,2],[27,0,27,2],[30,3,31,3],[28,3,28,7],[29,6,29,7],[30,4,31,4],[30,5,31,5],[30,6,31,7],[19,0,19,7],[20,0,20,1],[20,4,20,7],[21,0,21,1],[24,0,24,2],[24,3,25,4],[33,0,33,1],[33,4,33,7],[34,0,34,1],[34,4,34,7],[35,0,35,2],[35,3,35,5],[40,5,40,7],[36,0,36,2],[36,3,36,5],[39,5,39,7],[40,0,40,2],[40,3,40,4],[37,0,37,2],[37,3,38,4],[38,0,38,2],[39,0,39,2],[39,3,39,4]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0P PORTABLE PLANT INFORMATION"]
["COMPANY NAME",null,"FIPS COUNTY NO.",null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["PORTABLE EQUIPMENT OPERATING SITE INFORMATION"]
["FIPS COUNTY NO.",null,"PLANT NO.","PROJECT NO.","TYPE OF INSTALLATION/UNIT"]
[]
["SITE OR LOCATION NAME",null,null,"PERCENT OF TOTAL THROUGHPUT AT SITE (%)",null,null,"FIRST DATE AT SITE","LAST DATE AT SITE"]
[]
["ADDRESS",null,null,"Period of Operation",null,"HOURS","DAYS ","WEEKS"]
[]
["CITY",null,null,"ZIP CODE +4",null,"PHONE NUMBER WITH AREA CODE"]
[]
[null,"Latitude","Longitude","UTM Coordinates"]
["Degrees",null,null,"EASTING (M)","NORTHING (M)","ACC (M)","HORIZONTAL DATUM (CHECK ONE)"]
["Minutes"]
["Seconds"]
["PORTABLE EQUIPMENT OPERATING SITE INFORMATION"]
["FIPS COUNTY NO.",null,"PLANT NO.","PROJECT NO.","TYPE OF INSTALLATION/UNIT"]
[]
["SITE OR LOCATION NAME",null,null,"PERCENT OF TOTAL THROUGHPUT AT SITE (%)",null,null,"FIRST DATE AT SITE","LAST DATE AT SITE"]
[]
["ADDRESS",null,null,"Period of Operation",null,"HOURS","DAYS ","WEEKS"]
[]
["CITY",null,null,"ZIP CODE +4",null,"PHONE NUMBER WITH AREA CODE"]
[]
[null,"Latitude","Longitude","UTM Coordinates"]
["Degrees",null,null,"EASTING (M)","NORTHING (M)","ACC (M)","HORIZONTAL DATUM (CHECK ONE)"]
["Minutes"]
["Seconds"]
["PORTABLE EQUIPMENT OPERATING SITE INFORMATION"]
["FIPS COUNTY NO.",null,"PLANT NO.","PROJECT NO.","TYPE OF INSTALLATION/UNIT"]
[]
["SITE OR LOCATION NAME",null,null,"PERCENT OF TOTAL THROUGHPUT AT SITE (%)",null,null,"FIRST DATE AT SITE","LAST DATE AT SITE"]
[]
["ADDRESS",null,null,"Period of Operation",null,"HOURS","DAYS ","WEEKS"]
[]
["CITY",null,null,"ZIP CODE +4",null,"PHONE NUMBER WITH AREA CODE"]
[]
[null,"Latitude","Longitude","UTM Coordinates"]
["Degrees",null,null,"EASTING (M)","NORTHING (M)","ACC (M)","HORIZONTAL DATUM (CHECK ONE)"]
["Minutes"]
["Seconds"]
["MO 780-1433-xls (12-09)"]

{"sheet":"2.0S","index":11,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[13,0,13,1],[13,2,13,4],[13,6,14,6],[14,2,14,4],[15,2,15,6],[27,0,27,1],[27,2,27,4],[27,6,28,6],[19,4,19,5],[25,2,25,3],[25,4,25,5],[21,0,21,1],[24,0,24,9],[19,2,19,3],[19,6,19,7],[4,0,4,4],[5,8,5,9],[4,8,4,9],[5,5,5,6],[4,5,4,6],[5,0,5,4],[6,2,6,4],[6,6,7,6],[9,2,9,6],[7,2,7,4],[6,0,6,1],[7,0,7,1],[10,0,10,9],[16,7,16,9],[16,0,16,1],[16,2,16,6],[11,4,11,5],[11,2,11,3],[6,7,7,9],[8,0,8,1],[9,0,9,1],[8,7,8,9],[9,7,9,9],[8,2,8,6],[13,7,14,9],[12,6,12,7],[12,8,12,9],[11,8,11,9],[11,6,11,7],[14,0,14,1],[15,0,15,1],[15,7,15,9],[12,4,12,5],[12,2,12,3],[17,0,17,9],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[22,0,22,1],[22,2,22,6],[22,7,22,9],[20,0,20,1],[19,8,19,9],[20,2,20,4],[20,6,21,6],[21,2,21,4],[20,7,21,9],[29,0,29,1],[29,2,29,6],[29,7,29,9],[30,0,30,1],[30,2,30,6],[30,7,30,9],[23,0,23,1],[23,2,23,6],[23,7,23,9],[28,0,28,1],[28,2,28,4],[27,7,28,9],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[25,6,25,7],[25,8,25,9],[34,2,34,4],[34,6,35,6],[35,0,35,1],[35,2,35,4],[34,0,34,1],[36,0,36,1],[36,2,36,6],[34,7,35,9],[31,0,31,9],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[33,6,33,7],[33,8,33,9],[33,2,33,3],[33,4,33,5],[36,7,36,9],[37,0,37,1],[37,2,37,6],[37,7,37,9],[38,0,38,9],[39,2,39,3],[39,4,39,5],[39,6,39,7],[39,8,39,9],[43,0,43,1],[43,2,43,6],[43,7,43,9],[44,0,44,1],[44,2,44,6],[44,7,44,9],[40,2,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[41,0,41,1],[41,2,41,4],[41,6,42,6],[41,7,42,9],[42,0,42,1],[42,2,42,4],[45,0,45,9],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0S STACK/VENT INFORMATION"]
["FACILITY NAME",null,null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.","YEAR OF DATA"]
[]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.",null,"FOR A NON-CIRCULAR STACK:                                       DIAMETER = (1.128A)^1/2                                                      (A=CROSS-SECTIONAL AREA IN SQ FEET)"]
[]
["STACK/VENT NO.",null,"STACK/VENT DESCRIPTION",null,null,null,null,"% OF EMISSIONS RELEASED"]
[]
["STACK/VENT OPERATING STATUS (CHECK ONE)"]
["HEIGHT (FT.)","DIAMETER (FT.)","TEMPERATURE (F)",null,"VELOCITY (FT./MIN.)",null,"FLOW RATE (CU FT./MIN.)",null,"LIST OTHER POINTS SHARING THIS STACK/VENT"]
[]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.",null,"FOR A NON-CIRCULAR STACK:                                       DIAMETER = (1.128A)^1/2                                                      (A=CROSS-SECTIONAL AREA IN SQ FEET)"]
[]
["STACK/VENT NO.",null,"STACK/VENT DESCRIPTION",null,null,null,null,"% OF EMISSIONS RELEASED"]
[]
["STACK/VENT OPERATING STATUS (CHECK ONE)"]
["HEIGHT (FT.)","DIAMETER (FT.)","TEMPERATURE (F)",null,"VELOCITY (FT./MIN.)",null,"FLOW RATE (CU FT./MIN.)",null,"LIST OTHER POINTS SHARING THIS STACK/VENT"]
[]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.",null,"FOR A NON-CIRCULAR STACK:                                       DIAMETER = (1.128A)^1/2                                                      (A=CROSS-SECTIONAL AREA IN SQ FEET)"]
[]
["STACK/VENT NO.",null,"STACK/VENT DESCRIPTION",null,null,null,null,"% OF EMISSIONS RELEASED"]
[]
["STACK/VENT OPERATING STATUS (CHECK ONE)"]
["HEIGHT (FT.)","DIAMETER (FT.)","TEMPERATURE (F)",null,"VELOCITY (FT./MIN.)",null,"FLOW RATE (CU FT./MIN.)",null,"LIST OTHER POINTS SHARING THIS STACK/VENT"]
[]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.",null,"FOR A NON-CIRCULAR STACK:                                       DIAMETER = (1.128A)^1/2                                                      (A=CROSS-SECTIONAL AREA IN SQ FEET)"]
[]
["STACK/VENT NO.",null,"STACK/VENT DESCRIPTION",null,null,null,null,"% OF EMISSIONS RELEASED"]
[]
["STACK/VENT OPERATING STATUS (CHECK ONE)"]
["HEIGHT (FT.)","DIAMETER (FT.)","TEMPERATURE (F)",null,"VELOCITY (FT./MIN.)",null,"FLOW RATE (CU FT./MIN.)",null,"LIST OTHER POINTS SHARING THIS STACK/VENT"]
[]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.",null,"FOR A NON-CIRCULAR STACK:                                       DIAMETER = (1.128A)^1/2                                                      (A=CROSS-SECTIONAL AREA IN SQ FEET)"]
[]
["STACK/VENT NO.",null,"STACK/VENT DESCRIPTION",null,null,null,null,"% OF EMISSIONS RELEASED"]
[]
["STACK/VENT OPERATING STATUS (CHECK ONE)"]
["HEIGHT (FT.)","DIAMETER (FT.)","TEMPERATURE (F)",null,"VELOCITY (FT./MIN.)",null,"FLOW RATE (CU FT./MIN.)",null,"LIST OTHER POINTS SHARING THIS STACK/VENT"]
[]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.",null,"FOR A NON-CIRCULAR STACK:                                       DIAMETER = (1.128A)^1/2                                                      (A=CROSS-SECTIONAL AREA IN SQ FEET)"]
[]
["STACK/VENT NO.",null,"STACK/VENT DESCRIPTION",null,null,null,null,"% OF EMISSIONS RELEASED"]
[]
["STACK/VENT OPERATING STATUS (CHECK ONE)"]
["HEIGHT (FT.)","DIAMETER (FT.)","TEMPERATURE (F)",null,"VELOCITY (FT./MIN.)",null,"FLOW RATE (CU FT./MIN.)",null,"LIST OTHER POINTS SHARING THIS STACK/VENT"]
[]
["MO 780-1435-xls (12-09)"]

{"sheet":"2.0Z","index":12,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,0,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[5,0,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[9,0,9,1],[9,2,9,4],[9,5,9,7],[9,8,9,10],[10,0,10,1],[10,2,10,4],[10,5,10,7],[10,8,10,10],[6,0,6,10],[7,0,7,1],[7,2,7,5],[7,7,7,8],[7,9,7,10],[8,0,8,1],[8,2,8,5],[8,7,8,8],[8,9,8,10],[14,0,14,1],[15,0,15,1],[14,2,14,3],[14,4,14,6],[14,7,14,10],[15,2,15,3],[15,4,15,6],[15,7,15,10],[11,0,11,10],[12,0,12,1],[12,2,12,3],[12,4,12,6],[12,7,12,10],[13,7,13,10],[13,4,13,6],[13,2,13,3],[13,0,13,1],[19,0,19,1],[19,2,19,4],[19,5,19,7],[19,8,19,10],[20,0,20,1],[20,2,20,4],[20,5,20,7],[20,8,20,10],[16,0,16,10],[17,0,17,1],[17,2,17,5],[17,7,17,8],[17,9,17,10],[18,0,18,1],[18,2,18,5],[18,7,18,8],[18,9,18,10],[24,0,24,1],[24,2,24,3],[24,4,24,6],[24,7,24,10],[25,0,25,1],[25,2,25,3],[25,4,25,6],[25,7,25,10],[21,0,21,10],[22,0,22,1],[22,2,22,3],[22,4,22,6],[22,7,22,10],[23,0,23,1],[23,2,23,3],[23,4,23,6],[23,7,23,10],[29,0,29,1],[29,2,29,4],[29,5,29,7],[29,8,29,10],[30,0,30,1],[30,2,30,4],[30,5,30,7],[30,8,30,10],[26,0,26,10],[27,0,27,1],[27,2,27,5],[27,7,27,8],[27,9,27,10],[28,0,28,1],[28,2,28,5],[28,7,28,8],[28,9,28,10],[31,0,31,10],[32,0,32,1],[32,2,32,3],[32,4,32,6],[32,7,32,10],[33,0,33,1],[33,2,33,3],[33,4,33,6],[33,7,33,10],[34,0,34,1],[34,2,34,3],[34,4,34,6],[34,7,34,10],[36,0,37,10],[35,0,35,1],[35,2,35,3],[35,4,35,6],[35,7,35,10]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.0Z OZONE SEASON INFORMATION - EMISSIONS STATEMENT"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["OPERATING RATE/SCHEDULE (DURING PEAK OZONE SEASON ONLY)"]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,null,"SEG. NO.","DAILY THROUGHPUT",null,"UNITS"]
[]
["DAYS/WEEK",null,"WEEKS OF OPERATION",null,null,"START TIME ON TYPICAL DAY",null,null,"END TIME ON TYPICAL DAY"]
[]
["EMISSIONS CALCULATIONS"]
["Air Pollutant",null,"Emission Factor",null,"Control Efficiency (%)",null,null,"Actual Emissions (lbs./day)"]
["VOC",null,null,null,null,null,null,{"$f":"IF(OR($H$9=\"\",C14=\"\",E14=\"\"),\"\",$H9*C14*(100-E14)/100)","v":""}]
["NOX ",null,null,null,null,null,null,{"$f":"IF(OR($H$9=\"\",C15=\"\",E15=\"\"),\"\",$H$9*C15*(100-E15)/100)","v":""}]
["CO",null,null,null,null,null,null,{"$f":"IF(OR($H$9=\"\",C16=\"\",E16=\"\"),\"\",$H$9*C16*(100-E16)/100)","v":""}]
["OPERATING RATE/SCHEDULE (DURING PEAK OZONE SEASON ONLY)"]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,null,"SEG. NO.","DAILY THROUGHPUT",null,"UNITS"]
[]
["DAYS/WEEK",null,"WEEKS OF OPERATION",null,null,"START TIME ON TYPICAL DAY",null,null,"END TIME ON TYPICAL DAY"]
[]
["EMISSIONS CALCULATIONS"]
["Air Pollutant",null,"Emission Factor",null,"Control Efficiency (%)",null,null,"Actual Emissions (lbs./day)"]
["VOC",null,null,null,null,null,null,{"$f":"IF(OR($H$19=\"\",C24=\"\",E24=\"\"),\"\",$H19*C24*(100-E24)/100)","v":""}]
["NOX ",null,null,null,null,null,null,{"$f":"IF(OR($H$19=\"\",C25=\"\",E25=\"\"),\"\",$H$19*C25*(100-E25)/100)","v":""}]
["CO",null,null,null,null,null,null,{"$f":"IF(OR($H$19=\"\",C26=\"\",E26=\"\"),\"\",$H$19*C26*(100-E26)/100)","v":""}]
["OPERATING RATE/SCHEDULE (DURING PEAK OZONE SEASON ONLY)"]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,null,"SEG. NO.","DAILY THROUGHPUT",null,"UNITS"]
[]
["DAYS/WEEK",null,"WEEKS OF OPERATION",null,null,"START TIME ON TYPICAL DAY",null,null,"END TIME ON TYPICAL DAY"]
[]
["EMISSIONS CALCULATIONS"]
["Air Pollutant",null,"Emission Factor",null,"Control Efficiency (%)",null,null,"Actual Emissions (lbs./day)"]
["VOC",null,null,null,null,null,null,{"$f":"IF(OR($H$29=\"\",C34=\"\",E34=\"\"),\"\",$H29*C34*(100-E34)/100)","v":""}]
["NOX ",null,null,null,null,null,null,{"$f":"IF(OR($H$29=\"\",C35=\"\",E35=\"\"),\"\",$H$29*C35*(100-E35)/100)","v":""}]
["CO",null,null,null,null,null,null,{"$f":"IF(OR($H$29=\"\",C36=\"\",E36=\"\"),\"\",$H$29*C36*(100-E36)/100)","v":""}]
[]
[]
["MO 780-1452-xls (12-09)"]

{"sheet":"2.1","index":13,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,0,35,9],[36,0,37,2],[38,6,38,9],[38,0,38,2],[36,3,37,5],[38,3,38,5],[36,6,36,9],[37,6,37,9],[8,0,8,9],[25,0,34,2],[25,8,34,9],[25,6,34,7],[14,6,14,7],[14,8,14,9],[13,8,13,9],[13,6,13,7],[23,0,23,9],[24,8,24,9],[9,0,9,1],[10,0,15,1],[15,2,15,7],[15,8,15,9],[12,2,12,4],[11,2,11,4],[17,0,18,9],[24,0,24,2],[16,0,16,9],[19,0,19,9],[25,3,34,5],[24,6,24,7],[24,3,24,5],[20,0,22,9],[14,2,14,4],[11,8,11,9],[10,8,10,9],[9,8,9,9],[10,6,10,7],[9,6,9,7],[12,6,12,7],[12,8,12,9],[10,2,10,4],[9,2,9,4],[13,2,13,4],[11,6,11,7],[4,0,4,3],[4,7,4,8],[4,4,4,6],[7,0,7,3],[7,4,7,8],[6,4,6,8],[6,0,6,3],[5,0,5,3],[5,4,5,6],[5,7,5,8]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.1 FUEL COMBUSTION WORKSHEET"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["EMISSION UNIT NO.",null,null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,null,null,"SEG. NO. "]
[]
["1. COMBUSTION EQUIPMENT INFORMATION"]
["COAL FIRING                                                  CODE LIST",null,"EQUIPMENT DESCRIPTION",null,null,"YEAR                              PUT IN SERVICE","COAL FIRING                                 CODE NO.                           (CODE LIST AT LEFT)",null,"MAXIMUM DESIGN                                                   RATE                                               (MILLION BTU/HR.)"]
["1. TANGENTIAL                                        2. OPPOSED                                            3. FRONT                                               4. DRY/WET BOTTOM                   OTHER (SPECIFY)           "]
[]
[]
[]
[]
[null,null,"Sum of total maximum hourly design rates",null,null,null,null,null,{"$f":"IF(COUNTA(I11:I15)>0,SUM(I11:I15),\"\")","v":""}]
["COMBUSTION EQUIPMENT USE (CHECK ONE)"]
[]
[]
["COMBUSTION EQUIPMENT CATEGORY - COAL USE ONLY (CHECK ONE)"]
[]
[]
[]
["2. FUEL INFORMATION (CHECK ONLY ONE)"]
["LIQUID FUELS",null,null,"GASEOUS FUELS",null,null,"SOLID FUELS",null,"OTHER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. CALCULATION OF MAXIMUM HOURLY DESIGN RATE"]
["TOTAL HEAT CONTENT                        (BTU/FUEL UNIT)",null,null,"MAXIMUM HOURLY DESIGN RATE (FUEL UNIT/HR.)",null,null,"        Maximum Design Rate (mmbtu/hr.) × 1,000,000 (btu/mmbtu)"]
[null,null,null,null,null,null,"Heat Content (btu/fuel unit) "]
[null,null,null,{"$f":"IF(OR($I$16=\"\",$A$39=\"\"),\"\",$I$16/($A$39/1000000))","v":""}]
["MO 780-1436-xls (12-09)"]

{"sheet":"2.2","index":14,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,3],[4,8,4,9],[4,6,4,7],[4,4,4,5],[11,0,11,9],[10,0,10,2],[6,0,6,9],[5,0,5,3],[5,8,5,9],[31,0,31,9],[8,0,8,2],[8,3,8,5],[17,0,17,4],[17,5,17,9],[12,0,13,9],[15,0,16,9],[27,3,27,5],[28,3,28,5],[14,0,14,9],[25,3,25,5],[25,0,25,2],[8,6,8,7],[18,0,18,4],[19,0,19,9],[21,0,21,2],[9,0,9,2],[24,0,24,2],[23,0,23,2],[22,0,22,2],[5,6,5,7],[5,4,5,5],[7,0,7,2],[8,8,8,9],[10,6,10,7],[10,8,10,9],[30,0,30,5],[30,6,30,8],[29,6,29,8],[28,6,28,8],[27,6,27,8],[26,6,26,8],[26,3,26,5],[26,0,26,2],[28,0,28,2],[27,0,27,2],[29,0,29,5],[25,6,25,8],[20,0,20,2],[10,3,10,5],[21,3,21,5],[22,3,22,5],[7,6,7,7],[9,6,9,7],[9,3,9,5],[20,3,20,5],[22,6,22,8],[18,5,18,9],[21,6,21,8],[7,8,7,9],[23,3,23,5],[24,3,24,5],[20,6,20,8],[24,6,24,8],[23,6,23,8]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.2 INCINERATOR WORKSHEET"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["1. EQUIPMENT INFORMATION"]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SCC UNITS",null,"SEG. NO."]
[]
["MAXIMUM HOURLY DESIGN RATE",null,null,"UNITS/HR.",null,null,"MAKE / MODEL",null,"SERIAL NUMBER"]
[]
["INCINERATOR USE (CHECK ONE):"]
[]
[]
["EQUIPMENT TYPE (CHECK APPROPRIATE BOXES):"]
[]
[]
["NUMBER OF CHAMBERS NOT INCLUDING STACK",null,null,null,null,"SECONDARY CHAMBER TEMPERATURE (F)"]
[]
["2. WASTE INFORMATION AND THROUGHPUTS"]
["PROCESS WASTE TYPES",null,null,"HEAT CONTENT (BTU/UNITS)",null,null,"ANNUAL THROUGHPUT",null,null,"UNITS"]
[]
[]
[]
[]
[]
[]
[]
[]
["Total annual throughput = ",null,null,null,null,null,{"$f":"IF(AND(G22=0,G23=0,G24=0,G25=0,G26=0,G27=0,G28=0,G29=0),\"\",IF(J22=\"LBS/YR\",G22,G22*2000)+IF(J23=\"LBS/YR\",G23,G23*2000)+IF(J24=\"LBS/YR\",G24,G24*2000)+IF(J25=\"LBS/YR\",G25,G25*2000)+IF(J26=\"LBS/YR\",G26,G26*2000)+IF(J27=\"LBS/YR\",G27,G27*2000)+IF(J28=\"LBS/YR\",G28,G28*2000)+IF(J29=\"LBS/YR\",G29,G29*2000))","v":""},null,null,"LBS./YR."]
["Total annual throughput (TONS/YR.) = {Total annual throughput (LBS./YR.)} / 2,000",null,null,null,null,null,{"$f":"IF(G30=\"\",\"\",G30/2000)","v":""},null,null,"TONS/YR."]
["Enter the total annual throughput (TONS/YR.) into Section 3 on Form 2.0."]
["MO 780-1438-xls (12-09)"]

{"sheet":"2.3","index":15,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[27,4,27,5],[22,1,22,2],[32,0,32,7],[29,0,29,7],[30,0,30,6],[31,0,31,6],[24,0,25,2],[24,4,25,6],[26,0,26,7],[20,1,20,2],[23,1,23,2],[27,0,27,2],[28,0,28,2],[27,3,28,3],[4,0,4,3],[4,4,4,5],[9,0,11,7],[6,0,6,3],[6,4,6,5],[6,6,6,7],[7,0,7,3],[7,4,7,5],[7,6,7,7],[5,0,5,3],[34,0,34,5],[33,0,33,5],[33,6,34,6],[5,4,5,5],[15,1,15,2],[19,1,19,2],[21,1,21,2],[18,1,18,2],[17,1,17,2],[14,1,14,2],[8,0,8,7],[12,0,12,7],[13,1,13,2],[28,4,28,5],[27,6,28,6],[16,1,16,2]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.3 VOC PROCESS MASS-BALANCE WORKSHEET  "]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.","YEAR OF DATA"]
[null,null,null,null,"",null,"",""]
["EMISSION UNIT NO.",null,null,null,"SCC ",null,"SEG. NO."]
[]
["INSTRUCTIONS"]
["If your facility already calculates your VOC or HAP emissions and emission factor directly through a spreadsheet or engineering calculation, this form is optional as long as you supply your supporting documentation.  This form is designed for annual throughputs measured in gallons or tons only.  If you use another unit of measure, supply documentation of how you calculated total emissions and an emission factor.  Maintain copies of the Material Safety Data Sheet for each material listed and hazardous waste shipment reports for on-demand requests.  "]
[]
[]
["1. TOTAL ANNUAL THROUGHPUT AND TOTAL POUNDS OF VOC"]
[null,null,null,"[A]","[B]","[C]","[D]","[E]"]
["APPLICATION METHOD","MATERIAL TYPE",null,"ANNUAL THROUGHPUT                     (ton/yr. or gal./yr.)","MAXIMUM % BY WT. OF    VOC IN MATERIAL","DENSITY (LBS./UNIT)   IF (A) IN TONS, (C)=2,000","LBS. OF VOC PER UNIT                                (B) × (C) = (D) ","VOC (LBS./YR.)                                                           (A) × (D) = (E)"]
[null,null,null,null,null,null,{"$f":"IF(OR(E16=\"\",F16=\"\"),\"\",E16/100*F16)","v":""},{"$f":"IF(OR(D16=\"\",E16=\"\",F16=\"\",G16=\"\"),\"\",D16*G16)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(E17=\"\",F17=\"\"),\"\",E17/100*F17)","v":""},{"$f":"IF(OR(D17=\"\",E17=\"\",F17=\"\",G17=\"\"),\"\",D17*G17)","v":""}]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
["Enter the total annual throughput value [F] into Section [3], Annual Throughput on Form 2.0",null,null,"[F] TOTAL ANNUAL THROUGHPUT",null,null,null,"[G] TOTAL VOC (LBS./YR.)"]
[null,null,null,{"$f":"IF(SUM($D$16:$D$24)=0,\"\",SUM($D$16:$D$24))","v":""},null,null,null,{"$f":"IF(AND($H$16=\"\",$H$17=\"\",$H$18=\"\",$H$19=\"\",$H$20=\"\",$H$21=\"\",$H$22=\"\",$H$23=\"\",$H$24=\"\"),\"\",SUM($H$16:$H$24))","v":""}]
["2. CALCULATION OF POUNDS OF VOC RECOVERED"]
["AMOUNT OF MATERIAL SHIPPED AS HAZARDOUS WASTE (LBS./YR.)",null,null,"×","% VOC CONTENT OF WASTE",null,"=","[H] LBS. OF VOC RECOVERED"]
[null,null,null,null,null,null,null,{"$f":"IF(OR($A$29=\"\",$E$29=\"\"),\"\",A29*E29/100)","v":""}]
["3. CALCULATION OF POUNDS OF VOC EMITTED PRIOR TO CONTROL EQUIPMENT"]
["[G]      -    [H]    =     [I]       ",null,null,null,null,null,null,"[I] LBS. OF VOC EMITTED PRIOR TO CONTROL"]
["[Total lbs. of VOC] - [lbs. of VOC recovered] =",null,null,null,null,null,null,{"$f":"IF($H$26=\"\",\"\",$H$26-IF($H$29=\"\",0,$H$29))","v":""}]
["4. CALCULATION OF EMISSION FACTOR"]
["[I]      /    [F]    =     [J]       ",null,null,null,null,null,"Enter [J] on Form 2.0 as VOC EF","[J] EMISSION FACTOR IN LBS./UNIT"]
["[lbs of VOC emitted prior to control equipment] / [Total annual throughput] =",null,null,null,null,null,null,{"$f":"IF(IF(OR($D$26=\"\",$H$32=\"\"),\"\",$H$32/$D$26)<0,\"Negative Value -Revise\",IF(OR($H$32=\"\",$D$26=\"\"),\"\",$H32/$D$26))","v":""}]
["MO 780-1440-xls (12-09)"]

{"sheet":"2.4","index":16,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,0,33,7],[34,0,34,7],[11,6,11,7],[31,0,31,7],[30,0,30,7],[29,0,29,7],[28,0,28,7],[27,0,27,7],[17,4,17,7],[11,0,11,2],[7,0,7,7],[11,3,11,5],[8,6,8,7],[8,3,8,5],[10,6,10,7],[10,3,10,5],[14,0,14,7],[15,0,15,3],[8,0,8,2],[9,6,9,7],[9,3,9,5],[9,0,9,2],[4,0,4,7],[5,5,5,6],[5,3,5,4],[5,0,5,2],[18,4,18,7],[18,0,18,3],[6,0,6,2],[6,5,6,6],[6,3,6,4],[16,4,16,7],[10,0,10,2],[12,0,12,7],[17,0,17,3],[16,0,16,3],[15,4,15,7],[13,0,13,7],[19,0,19,7],[20,0,20,7],[22,0,22,7],[26,6,26,7],[24,0,24,5],[24,6,24,7],[25,0,26,5],[25,6,25,7],[23,0,23,7],[21,0,21,7]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.4 VOLATILE ORGANIC LIQUID LOADING WORKSHEET  "]
["Note: This form is used to calculate emissions from loading organic liquids into tank trucks, rail tank cars and barges. "]
["FACILITY NAME",null,null,"FIPS COUNTY NO.",null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["1. LOADING INFORMATION"]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO."]
[]
["ANNUAL THROUGHPUT OF LIQUID (1,000 GALLONS)",null,null,"CONTROL DEVICE TYPE",null,null,"CONTROL EFFICIENCY (%)"]
[]
["TYPE OF LOADING (CHECK ONE)"]
[]
["2. CHEMICAL INFORMATION"]
["BULK LIQUID TYPE",null,null,null,"MOLECULAR WEIGHT OF MATERIAL LOADED [LB. / (LB./MOLE)]"]
[]
["TRUE VAPOR PRESSURE OF BULK LIQUID (PSIA)",null,null,null,"SATURATION FACTOR"]
[]
["TEMPERATURE OF LIQUID (DEGREES RANKINE) = DEGREES FAHRENHEIT + 460 DEGREES FAHRENHEIT"]
[]
["3. LOADING LOSS EMISSION FACTOR CALCULATION"]
["LOADING LOSS EMISSION FACTOR ="]
["12.46 x (Molecular Weight) x (True vapor pressure) x (Saturation) / (Temperature in Degrees Rankine)"]
["LOADING LOSS EMISSION FACTOR",null,null,null,null,null,"UNITS"]
[{"$f":"IF(OR($E$17=\"\",$A$19=\"\",$E$19=\"\",$A$21=\"\"),\"\",(12.46*$E$17*$A$19*$E$19)/$A$21)","v":""}]
[null,null,null,null,null,null,"lbs. per 1,000 gallons     "]
["NOTE"]
[]
["Enter the Control Efficiency (%) from Section 1 (above) into Section 5, Column 4 on Form 2.0."]
["Enter the Annual Throughput of Liquid from Section 1, expressed in thousands of gallons, into Section 3 on Form 2.0."]
["Enter the Loading Loss Emission Factor from Section 3 into the VOC box of Section 5, Column 2 on Form 2.0"]
[]
["Remember when calculating emissions, use a separate Form 2.0, Emission Unit Information, for each type of                                                                          liquid loaded in the tank during the year."]
["Use the same unit number but with the Source Classification Code that corresponds to the different liquid type.  "]
["MO 780-1625-xls (12-09)"]

{"sheet":"2.5L","index":17,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,0,40,2],[40,3,40,5],[40,6,41,8],[41,0,41,2],[41,3,41,5],[34,0,34,2],[34,3,34,5],[34,6,35,8],[35,0,35,2],[35,3,35,5],[39,6,39,8],[36,0,36,1],[36,3,36,4],[37,0,37,1],[37,3,37,4],[38,0,38,2],[38,3,38,5],[38,6,38,8],[39,0,39,2],[39,3,39,5],[32,0,32,2],[32,3,32,5],[32,6,32,8],[33,0,33,2],[33,3,33,5],[33,6,33,8],[30,0,30,1],[30,3,30,4],[31,0,31,1],[31,3,31,4],[28,0,28,2],[28,3,28,5],[28,6,29,8],[29,0,29,2],[29,3,29,5],[26,0,26,2],[26,3,26,5],[26,6,26,8],[27,0,27,2],[27,3,27,5],[27,6,27,8],[24,0,24,1],[24,3,24,4],[25,0,25,1],[25,3,25,4],[22,0,22,2],[22,3,22,5],[22,6,23,8],[23,0,23,2],[23,3,23,5],[20,0,20,2],[20,3,20,5],[20,6,20,8],[21,0,21,2],[21,3,21,5],[21,6,21,8],[18,0,18,1],[18,3,18,4],[19,0,19,1],[19,3,19,4],[16,0,16,2],[16,3,16,5],[16,6,17,8],[17,0,17,2],[17,3,17,5],[14,0,14,2],[14,3,14,5],[14,6,14,8],[15,0,15,2],[15,3,15,5],[15,6,15,8],[12,0,12,1],[12,3,12,4],[13,0,13,1],[13,3,13,4],[8,0,8,2],[8,3,8,5],[6,0,6,1],[6,3,6,4],[7,3,7,4],[7,0,7,1],[4,7,4,8],[4,5,4,6],[4,0,4,3],[5,7,5,8],[5,5,5,6],[5,0,5,3],[8,6,8,8],[9,6,9,8],[9,3,9,5],[9,0,9,2],[10,3,10,5],[10,0,10,2],[10,6,11,8],[11,3,11,5],[11,0,11,2]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.5L GENERAL LIQUID STORAGE TANK INFORMATION"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.","PLANT NO.",null,"YEAR OF DATA"]
[]
["EMISSION UNIT NO. ",null,"TANK ID","SCC (BREATHING OR WORKING)",null,"SEG. NO.","DIAMETER (FT.)","HEIGHT (FT.)","LENGTH (FT.)"]
[]
["CAPACITY (IN THOUSANDS OF GALLONS)",null,null,"THROUGHPUT (IN THOUSANDS OF GALLONS)",null,null,"TANKS PROGRAM USED?"]
[]
["CAS NUMBER",null,null,"CHEMICAL",null,null,"CHOOSE TYPE OF TANK (CHECK ONE)"]
[]
["EMISSION UNIT NO. ",null,"TANK ID","SCC (BREATHING OR WORKING)",null,"SEG. NO. ","DIAMETER (FT.)","HEIGHT (FT.)","LENGTH (FT.)"]
[]
["CAPACITY (IN THOUSANDS OF GALLONS)",null,null,"THROUGHPUT (IN THOUSANDS OF GALLONS)",null,null,"TANKS PROGRAM USED?"]
[]
["CAS NUMBER",null,null,"CHEMICAL",null,null,"CHOOSE TYPE OF TANK (CHECK ONE)"]
[]
["EMISSION UNIT NO. ",null,"TANK ID","SCC (BREATHING OR WORKING)",null,"SEG. NO.","DIAMETER (FT.)","HEIGHT (FT.)","LENGTH (FT.)"]
[]
["CAPACITY (IN THOUSANDS OF GALLONS)",null,null,"THROUGHPUT (IN THOUSANDS OF GALLONS)",null,null,"TANKS PROGRAM USED?"]
[]
["CAS NUMBER",null,null,"CHEMICAL",null,null,"CHOOSE TYPE OF TANK (CHECK ONE)"]
[]
["EMISSION UNIT NO. ",null,"TANK ID","SCC (BREATHING OR WORKING)",null,"SEG. NO.","DIAMETER (FT.)","HEIGHT (FT.)","LENGTH (FT.)"]
[]
["CAPACITY (IN THOUSANDS OF GALLONS)",null,null,"THROUGHPUT (IN THOUSANDS OF GALLONS)",null,null,"TANKS PROGRAM USED?"]
[]
["CAS NUMBER",null,null,"CHEMICAL",null,null,"CHOOSE TYPE OF TANK (CHECK ONE)"]
[]
["EMISSION UNIT NO. ",null,"TANK ID","SCC (BREATHING OR WORKING)",null,"SEG. NO.","DIAMETER (FT.)","HEIGHT (FT.)","LENGTH (FT.)"]
[]
["CAPACITY (IN THOUSANDS OF GALLONS)",null,null,"THROUGHPUT (IN THOUSANDS OF GALLONS)",null,null,"TANKS PROGRAM USED?"]
[]
["CAS NUMBER",null,null,"CHEMICAL",null,null,"CHOOSE TYPE OF TANK (CHECK ONE)"]
[]
["EMISSION UNIT NO. ",null,"TANK ID","SCC (BREATHING OR WORKING)",null,"SEG. NO.","DIAMETER (FT.)","HEIGHT (FT.)","LENGTH (FT.)"]
[]
["CAPACITY (IN THOUSANDS OF GALLONS)",null,null,"THROUGHPUT (IN THOUSANDS OF GALLONS)",null,null,"TANKS PROGRAM USED?"]
[]
["CAS NUMBER",null,null,"CHEMICAL",null,null,"CHOOSE TYPE OF TANK (CHECK ONE)"]
[]
["MO 780-1444-xls (12-09)"]

{"sheet":"2.7","index":18,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[14,0,14,6],[12,7,12,8],[15,0,15,3],[16,0,16,3],[15,4,15,6],[13,7,13,8],[14,7,14,8],[7,0,8,0],[12,0,12,2],[12,3,12,5],[13,0,13,6],[9,0,9,9],[7,1,7,9],[10,0,10,9],[11,3,11,5],[11,7,11,8],[8,1,8,9],[11,0,11,2],[16,7,16,8],[15,7,15,8],[21,5,21,9],[21,0,21,4],[20,0,20,4],[18,0,18,6],[20,5,20,9],[19,0,19,9],[17,0,17,6],[16,4,16,6],[22,0,22,4],[22,5,22,9],[23,5,23,9],[23,0,23,4],[17,7,17,8],[18,7,18,8],[25,0,25,4],[26,0,26,4],[25,5,25,9],[26,5,26,9],[24,0,24,9],[31,0,32,1],[33,0,34,1],[32,8,32,9],[31,8,31,9],[33,8,33,9],[31,2,32,7],[33,2,34,7],[34,8,34,9],[30,0,30,9],[27,0,27,9],[29,0,29,4],[28,0,28,4],[29,6,29,9],[28,6,28,9],[28,5,29,5],[6,0,6,9],[4,8,4,9],[5,4,5,6],[5,0,5,3],[4,0,4,3],[4,4,4,6],[5,8,5,9]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.7 HAUL ROAD FUGITIVE EMISSIONS WORKSHEET"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.","YEAR OF DATA"]
[null,null,null,null,null,null,null,"",""]
["INSTRUCTIONS"]
["This worksheet is optional  ","If the sum of all Vehicle Miles Traveled, or VMT, at the facility is less than 100, this form is not necessary and the emission unit should be marked as insignificant on Form 1.2.  "]
[null,"If the haul road parameters are the same as last year and the updated emission factor equation is used (AP-42, Section 13.2.2, Unpaved Roads, Nov. 2006), enter the current annual VMT as the throughput on Form 2.0."]
["Do not calculate a separate emission factor for each vehicle class.  Use the weighted average for the entire fleet traveling the haul road to calculate the emission factors."]
["1. HAUL ROAD INFORMATION"]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO.","Type of Dust Control        (check one)",null,"Control Efficiency"]
[null,null,null,null,null,null,null,null,null,0.95]
["LENGTH OF ROAD (MILES):  IF ONE-WAY, DIVIDE BY 2",null,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,0.9]
["SILT CONTENT (%)  (DEFAULT = 8.3%)",null,null,null,"SURFACE MATERIAL OF ROAD",null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,0.5]
["DAYS OF RAIN WITH AT LEAST 0.01\" PER YEAR (DEFAULT = 105)"]
[null,null,null,null,null,null,null,null,null,0]
["2. HAUL TRUCK INFORMATION"]
["MAKE/MODEL ",null,null,null,null,"UNLOADED TRUCK WEIGHT (TONS) — WEIGHTED AVERAGE FOR FLEET"]
[]
["AVERAGE WEIGHT OF MATERIAL PER LOAD (TONS)",null,null,null,null,"AVERAGE LOADED WEIGHT (TONS) — WEIGHTED AVERAGE FOR FLEET"]
[{"$f":"IF(OR($F$22=\"\",$F$24=\"\"),\"\",IF(($F$24-$F$22)<0,\"Negative Value - Revise\",$F$24-$F$22))","v":""}]
["3. MATERIAL HAULED"]
["TYPE OF MATERIALS HAULED",null,null,null,null,"ANNUAL AMOUNT HAULED (TONS)"]
[]
["4. CALCULATION OF ANNUAL VEHICLES MILES TRAVELED"]
["ANNUAL VMT",null,null,null,null,"Annual VMT ="," 2 × (Length of road) × (Annual amount hauled)"]
[{"$f":"IF(OR($A$15=\"\",$F$27=\"\",$A$24=\"\"),\"\",2*$A$15*$F$27/$A$24)","v":""},null,null,null,null,null,"(Average weight of material per load)"]
["5. CALCULATION OF HAUL ROAD UNCONTROLLED EMISSION FACTOR"]
["PM2.5 Emission Factor",null,null,null,null,null,null,null,"PM2.5 EMISSION FACTOR"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($A$17=\"\",$A$19=\"\",$F$22=\"\",$F$24=\"\"),\"\",0.15*($A$17/12)^0.9*(($F$22+$F$24)/6)^0.45*((365-$A$19)/365))","v":""}]
["PM10 Emission Factor",null,null,null,null,null,null,null,"PM10 EMISSION FACTOR"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($A$17=\"\",$A$19=\"\",$F$22=\"\",$F$24=\"\"),\"\",1.5*($A$17/12)^0.9*(($F$22+$F$24)/6)^0.45*((365-$A$19)/365))","v":""}]
["MO 780-1445-xls (12-09)"]

{"sheet":"2.8","index":19,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,2,29,6],[28,2,28,6],[27,2,27,6],[24,3,24,4],[24,5,24,7],[24,0,24,2],[32,0,33,8],[30,0,30,1],[29,0,29,1],[28,0,28,1],[27,0,27,1],[26,7,26,8],[26,2,26,6],[30,7,30,8],[29,7,29,8],[28,7,28,8],[27,7,27,8],[26,0,26,1],[30,2,30,6],[23,0,23,4],[21,0,21,4],[21,5,21,8],[23,5,23,8],[22,3,22,4],[22,5,22,7],[22,0,22,2],[12,5,12,6],[13,7,19,8],[13,5,19,6],[16,0,16,4],[14,0,14,4],[12,0,12,4],[4,7,4,8],[6,0,6,8],[4,0,4,3],[4,4,4,5],[10,5,10,8],[9,3,9,4],[8,3,8,4],[5,0,5,3],[5,4,5,5],[5,7,5,8],[7,3,7,4],[31,0,31,8],[25,0,25,8],[20,0,20,8],[8,6,9,8],[7,6,7,8],[7,0,7,1],[8,0,9,1],[18,0,18,4],[10,0,10,4],[15,0,15,4],[13,0,13,3],[11,0,11,3],[11,5,11,8],[19,0,19,4],[17,0,17,4],[12,7,12,8]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.8 STORAGE PILE WORKSHEET"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.","YEAR OF DATA"]
[]
["1. STORAGE PILE INFORMATION"]
["EMISSION UNIT NO.",null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,"SEG. NO.","TYPE OF MATERIAL STORED"]
[null,null,"ACTIVITY"]
[null,null,"WIND EROSION"]
["MOISTURE CONTENT (%)",null,null,null,null,"AREA OF STORAGE PILE (ACRES)"]
[null,null,null,null,"(DEFAULT = 0.7%)"]
["SILT CONTENT(%)",null,null,null,null,"RAW MATERIAL LOADING METHOD       (CHECK ONE):",null,"RAW MATERIAL UNLOADING METHOD (CHECK ONE):"]
[null,null,null,null,"(DEFAULT = 1.6%)"]
["STORAGE DURATION (DAYS)"]
[]
["ANNUAL AMOUNT STORED (TONS)"]
[]
["MAXIMUM HOURLY AMOUNT STORED (TONS)"]
[]
["2. OTHER FACTORS AFFECTING EMISSION RATES"]
["MEAN WIND SPEED (MPH)",null,null,null,null,"% OF TIME WIND > 12 MPH"]
[null,null,null,"(DEFAULT = 10 MPH)",null,null,null,null,"(DEFAULT = 32%)"]
["DRY DAYS PER YEAR",null,null,null,null,"VEHICLE ACTIVITY FACTOR"]
[null,null,null,"(DEFAULT = 260 DAYS)",null,null,null,null,"(DEFAULT = 1.0)"]
["4. STORAGE PILE EMISSION FACTOR CALCULATIONS"]
["CALCULATION",null,"FORMULA",null,null,null,null,"RESULT"]
["[3-A-1]                            Load In - Load Out Component                                       (lb./ton)",null,"0.0032 x .35 x (Mean wind speed / 5) ^1.3 / (Moisture content % / 2) ^1.4",null,null,null,null,{"$f":"IF(OR($A$12=0,$A$23=0),\"\",0.0032*0.35*($A$23/5)^1.3/($A$12/2)^1.4)","v":""}]
["[3-A-2]                               Vehicle Activity Component                              (lb./ton)",null,"0.05 x (Silt content % / 1.5) x (Dry days per year / 235) x Vehicle Activity Factor",null,null,null,null,{"$f":"IF(OR($A$14=\"\",$F$25=\"\",$A$25=\"\"),\"\",0.05*($A$14/1.5)*($A$25/235)*$F$25)","v":""}]
["[3-A-3]                            Activity PM10                                             Emission Factor                                        (lb./ton)",null,"[3-A-1] Load In - Load Out Component + [3-A-2] Vehicle Activity Component",null,null,null,null,{"$f":"IF(OR($H$28=\"\",$H$29=\"\"),\"\",SUM($H$28:$H$29))","v":""}]
["[3-B]                                           Wind Erosion PM10 Emission Factor                                       (lb./acre-yr.)",null,"0.85 x (Silt content % / 1.5) x (Storage duration (Days)) x (Dry days per year / 235) x (% of time wind >12 MPH /15)",null,null,null,null,{"$f":"IF(OR($A$14=0,$A$16=0,$A$25=0),\"\",0.85*($A$14/1.5)*($A$16)*($A$25/235)*($F$23/15))","v":""}]
["NOTE"]
["If you use a Source Classification Code and emission factor from the list in the instructions for this form, make sure to complete Section 1, Storage Pile Information for each storage pile.  "]
[]
["MO 780-1446-xls (12-09) "]

{"sheet":"2.9","index":20,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[4,0,4,3],[4,8,4,9],[4,6,4,7],[4,4,4,5],[5,0,5,3],[5,4,5,5],[5,8,5,9],[5,6,5,7],[6,0,6,1],[6,2,6,5],[8,5,8,7],[8,2,8,4],[8,0,8,1],[20,4,20,5],[21,4,21,5],[8,8,9,9],[6,6,6,7],[7,6,7,7],[9,5,9,7],[9,2,9,4],[25,0,25,4],[24,0,24,4],[39,0,39,3],[27,5,27,9],[33,5,33,9],[31,5,31,9],[29,8,29,9],[27,0,27,4],[37,4,37,5],[35,0,35,9],[39,4,39,5],[38,4,38,5],[7,0,7,1],[6,8,6,9],[7,8,7,9],[7,2,7,5],[23,4,23,5],[22,4,22,5],[23,6,23,7],[22,6,22,7],[9,0,9,1],[23,0,23,3],[22,0,22,3],[20,0,20,3],[21,0,21,3],[18,0,18,9],[21,8,21,9],[19,0,19,9],[17,0,17,9],[10,0,10,9],[16,0,16,9],[15,0,15,9],[14,0,14,9],[13,0,13,9],[12,0,12,9],[11,0,11,9],[20,6,20,7],[21,6,21,7],[29,5,29,7],[33,0,33,4],[29,3,29,4],[29,0,29,2],[32,5,32,9],[31,0,31,4],[28,0,28,9],[20,8,20,9],[23,8,23,9],[22,8,22,9],[26,5,26,9],[25,5,25,9],[24,5,24,9],[26,0,26,4],[34,5,34,9],[34,0,34,4],[32,0,32,4],[30,5,30,7],[30,8,30,9],[30,0,30,2],[30,3,30,4],[44,0,46,9],[42,0,42,7],[36,0,36,3],[36,6,39,9],[43,0,43,7],[43,8,43,9],[42,8,42,9],[36,4,36,5],[41,0,41,9],[40,0,40,9],[37,0,37,3],[38,0,38,3]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.9 STACK TEST/CONTINUOUS EMISSIONS MONITOR WORKSHEET"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["EMISSION UNIT NO.",null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,null,"SEG. NO. ",null,"STACK NO."]
[]
["TYPE",null,"POLLUTANT TESTED",null,null,"CAS NUMBER",null,null,"Note:  Use a separate worksheet for each pollutant tested."]
[]
["1. EMISSION SOURCE INFORMATION"]
["EQUIPMENT MAKE/MODEL"]
[]
["TYPE OF CONTROL DEVICE"]
[]
["LIMITATIONS ON EMISSIONS, PRODUCTION OR OPERATING TIME (IF ANY)"]
[]
["2. STACK TEST INFORMATION"]
["TESTING FIRM NAME"]
[]
["TESTING FIRM ADDRESS",null,null,null,"CITY",null,"STATE",null,"ZIP CODE + 4"]
[]
["EPA METHOD(S) USED",null,null,null,"TEST DATE(S)",null,"RESULTS",null,"COMPLIANCE"]
[]
["TEST TECHNIQUE (CHECK ONE)",null,null,null,null,"LATEST CALIBRATION OF TESTING EQUIPMENT"]
[]
["AGENCY OBSERVING TEST (CHECK ONE)",null,null,null,null,"NAME OF OBSERVER(S)"]
[]
["3. CONTINUOUS EMISSION MONITORING INFORMATION"]
["CONCENTRATION OF POLLUTANT",null,null,"UNITS",null,"FLOW RATE OF STACK",null,null,"UNITS"]
[]
["LATEST CALIBRATION OF MONITOR",null,null,null,null,"RESULTS OF CALIBRATION"]
[]
["MONITOR AVERAGING PERIOD",null,null,null,null,"PERCENT MONITOR DOWN TIME"]
[]
["4. EMISSION FACTOR CALCULATION"]
["EMISSION RATE ",null,null,null,"UNITS",null,"Note:  Documentation should include summary page information from the test data to verify the emission and production rate."]
[null,null,null,null,"LBS./HR."]
["PRODUCTION RATE ",null,null,null,"UNITS/HR."]
[]
["EMISSION FACTOR ="]
["[{EMISSION RATE} / {PRODUCTION RATE}]"]
["EMISSION FACTOR",null,null,null,null,null,null,null,"UNITS"]
[{"$f":"IF(IF(OR(A38=\"\",A40=\"\"),\"\",A38/A40)<=0,\"Negative or Zero Value: Re-Enter\",IF(OR(A38=\"\",A40=\"\"),\"\",A38/A40))","v":""}]
["Enter the emission factor into the appropriate box in Section 5, Column 3 on Form 2.0.                                                                                                                                If applicable, enter the control device type and control efficiency (%) in Section 5 on Form 2.0.  "]
[]
[]
["MO 780-1447-xls (12-09) "]

{"sheet":"2.T","index":21,"n_rows":220,"n_cols":10,"rows_kept":220,"cut":false,"hidden":false,"merged":[[28,0,28,9],[26,0,27,1],[26,2,27,4],[8,0,10,9],[24,6,25,7],[24,0,25,1],[24,2,25,3],[26,6,27,9],[4,6,4,7],[4,0,4,5],[6,0,6,5],[7,0,7,5],[5,6,5,7],[5,0,5,5],[6,6,6,8],[7,6,7,8]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 2.T HAZARDOUS AIR POLLUTANT WORKSHEET"]
["FACILITY NAME",null,null,null,null,null,"FIPS COUNTY NO.",null,"PLANT NO.","YEAR OF DATA"]
[]
["EMISSION UNIT NO.",null,null,null,null,null,"SOURCE CLASSIFICATION CODE (SCC)",null,null,"SEG. NO."]
[]
["Use this form to report any Hazardous Air Pollutant, or HAP, which is emitted in any amount greater than the chemical reporting levels per each emission unit.  The instructions for this form provide a list of the HAPs regulated under the Clean Air Act.  The amount emitted (Column 4) should be reported before control equipment reductions are applied. Provide documentation (other worksheets, etc.) if the amount in Column 3 does not equal the amount in Column 4.  The HAP reporting levels per emission unit are as follows:  Category 1 HAPs - sum of 20 pounds per year; All other HAPs - sum of 200 pounds per year."]
[]
[]
["1.","2.","3.","4.","5.","6.","7.","8.","9.","10."]
["HAP CHEMICAL","CAS NUMBER","AMOUNT USED OR HANDLED                       (LBS./YR.)","UNCONTROLLED AMOUNT EMITTED (LBS./YR.)","UNCONTROLLED EMISSIONS REPORTED AS VOC OR PM10                        (LBS./YR.)","UNCONTROLLED EMISSIONS REPORTED AS HAPs (LBS./YR.)","HAP CONTROL DEVICE(S)","CONTROL                EFFICIENCY                                                (%)","CONTROLLED EMISSIONS REPORTED AS VOC OR PM10                              (LBS./YR.)","CONTROLLED EMISSIONS REPORTED AS HAPs                               (LBS./YR.)"]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,$A$32:$E$220,5,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(E14=\"\",H14=\"\"),\"\",E14*(100-H14)/100)","v":""},{"$f":"IF(OR(F14=\"\",H14=\"\"),\"\",F14*(100-H14)/100)","v":""}]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,$A$32:$E$220,5,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(E15=\"\",H15=\"\"),\"\",E15*(100-H15)/100)","v":""},{"$f":"IF(OR(F15=\"\",H15=\"\"),\"\",F15*(100-H15)/100)","v":""}]
[null,"",null,null,null,null,null,null,{"$f":"IF(OR(E16=\"\",H16=\"\"),\"\",E16*(100-H16)/100)","v":""},{"$f":"IF(OR(F16=\"\",H16=\"\"),\"\",F16*(100-H16)/100)","v":""}]
[null,"",null,null,null,null,null,null,{"$f":"IF(OR(E17=\"\",H17=\"\"),\"\",E17*(100-H17)/100)","v":""},{"$f":"IF(OR(F17=\"\",H17=\"\"),\"\",F17*(100-H17)/100)","v":""}]
[null,"",null,null,null,null,null,null,{"$f":"IF(OR(E18=\"\",H18=\"\"),\"\",E18*(100-H18)/100)","v":""},{"$f":"IF(OR(F18=\"\",H18=\"\"),\"\",F18*(100-H18)/100)","v":""}]
[null,"",null,null,null,null,null,null,{"$f":"IF(OR(E19=\"\",H19=\"\"),\"\",E19*(100-H19)/100)","v":""},{"$f":"IF(OR(F19=\"\",H19=\"\"),\"\",F19*(100-H19)/100)","v":""}]
[null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,null,"",""]
[null,"",null,null,null,null,null,null,"",""]
[null,null,"HAP Emission Totals =",null,"SUM (LBS./YR.)","SUM (LBS./YR.)",null,null,"SUM (LBS./YR.)","SUM (LBS./YR.)"]
[null,null,null,null,{"$f":"IF(AND(E14=\"\",E15=\"\",E16=\"\",E17=\"\",E18=\"\",E19=\"\",E20=\"\",E21=\"\",E22=\"\",E23=\"\",E24=\"\"),\"\",SUM(E14:E24))","v":""},{"$f":"IF(AND(F14=\"\",F15=\"\",F16=\"\",F17=\"\",F18=\"\",F19=\"\",F20=\"\",F21=\"\",F22=\"\",F23=\"\",F24=\"\"),\"\",SUM(F14:F24))","v":""},null,null,{"$f":"IF(AND(I14=\"\",I15=\"\",I16=\"\",I17=\"\",I18=\"\",I19=\"\",I20=\"\",I21=\"\",I22=\"\",I23=\"\",I24=\"\"),\"\",SUM(I14:I24))","v":""},{"$f":"IF(AND(J14=\"\",J15=\"\",J16=\"\",J17=\"\",J18=\"\",J19=\"\",J20=\"\",J21=\"\",J22=\"\",J23=\"\",J24=\"\"),\"\",SUM(J14:J24))","v":""}]
["Uncontrolled HAP Emission Factor =",null,"Sum of uncontrolled emissions reported as HAPs                                                                       (Column 6 Total)/Annual Throughput (Form 2.0) ",null,null,"11. HAP EMISSION FACTOR"]
[]
["Enter the HAP emission factor for all chemicals that are not reported as VOCs or PM10 from Block 11 above as the HAP Emission Factor in Section 5 on Form 2.0."]
["MO 780-1448-xls (12-09) "]
[]
[]
["POLYCYCLIC ORGANIC MATTER",null,null,null,"TP15"]
["ARSENIC COMPOUNDS (INORG INC ARSINE)",null,null,null,"20-01-9"]
["CHROMIUM COMPOUNDS",null,null,null,"20-06-4"]
["LEAD COMPOUNDS ",null,null,null,"20-11-1"]
["MERCURY COMPOUNDS (ALKYL & ARYL)",null,null,null,"20-13-3"]
["MERCURY COMPOUNDS (INORGANIC)",null,null,null,"20-13-3"]
["NICKEL COMPOUNDS",null,null,null,"20-14-4"]
["CHLORDANE",null,null,null,"57-74-9"]
["BENZENE",null,null,null,"71-43-2"]
["METHOXYCHLOR",null,null,null,"72-43-5"]
["VINYL CHLORIDE",null,null,null,"75-01-4"]
["HEPTACHLOR",null,null,null,"76-44-8"]
["BENZIDINE",null,null,null,"92-87-5"]
["BUTADIENE, [1,3-]",null,null,null,"106-99-0"]
["CHLOROMETHYL METHYL ETHER",null,null,null,"107-30-2"]
["HEXACHLOROBENZENE",null,null,null,"118-74-1"]
["BIS (CHLOROMETHYL) ETHER",null,null,null,"542-88-1"]
["ASBESTOS",null,null,null,"1332-21-4"]
["PCB [POLYCHLORINATED BIPHENYLS]",null,null,null,"1336-36-3"]
["TRIFLURALIN",null,null,null,"1582-09-8"]
["TETRACHLORODIBENZO-P-DIOXIN, [2,3,7,8-]",null,null,null,"1746-01-6"]
["TOXAPHENE",null,null,null,"8001-35-2"]
["COKE OVEN EMISSIONS",null,null,null,"8007-45-2"]
["MINERAL FIBERS",null,null,null,"TP14"]
["RADIONUCLIDES (INCLUDING RADON)",null,null,null,"TP16"]
["ANTIMONY COMPOUNDS",null,null,null,"20-00-8"]
["BERYLLIUM COMPOUNDS",null,null,null,"20-03-1"]
["CADMIUM COMPOUNDS",null,null,null,"20-04-2"]
["COBALT COMPOUNDS",null,null,null,"20-07-5"]
["CYANIDE COMPOUNDS",null,null,null,"20-09-7"]
["GLYCOL ETHERS",null,null,null,"20-10-0"]
["MANGANESE COMPOUNDS",null,null,null,"20-12-2"]
["SELENIUM COMPOUNDS",null,null,null,"20-16-6"]
["FORMALDEHYDE",null,null,null,"50-00-0"]
["DINITROPHENOL, [2,4-]",null,null,null,"51-28-5"]
["URETHANE [ETHYL CARBAMATE]",null,null,null,"51-79-6"]
["ACETYLAMINOFLUORENE, [2-]",null,null,null,"53-96-3"]
["CARBON TETRACHLORIDE",null,null,null,"56-23-5"]
["PARATHION",null,null,null,"56-38-2"]
["DIMETHYL HYDRAZINE, [1,1-]",null,null,null,"57-14-7"]
["PROPIOLACTONE, [BETA-]",null,null,null,"57-57-8"]
["LINDANE [GAMMA-HEXACHLOROCYCLOHEXANE]",null,null,null,"58-89-9"]
["NITROSOMORPHOLINE, [N-]",null,null,null,"59-89-2"]
["DIMETHYLAMINOAZOBENZENE, [4-]",null,null,null,"60-11-7"]
["METHYL HYDRAZINE",null,null,null,"60-34-4"]
["ACETAMIDE",null,null,null,"60-35-5"]
["ANILINE",null,null,null,"62-53-3"]
["DICHLORVOS",null,null,null,"62-73-7"]
["NITROSODIMETHYLAMINE, [N-]",null,null,null,"62-75-9"]
["CARBARYL",null,null,null,"63-25-2"]
["DIETHYL SULFATE",null,null,null,"64-67-5"]
["METHANOL",null,null,null,"67-56-1"]
["CHLOROFORM",null,null,null,"67-66-3"]
["HEXACHLOROETHANE",null,null,null,"67-72-1"]
["DIMETHYL FORMAMIDE",null,null,null,"68-12-2"]
["TRICHLOROETHANE, [1,1,1-]",null,null,null,"71-55-6"]
["DDE",null,null,null,"72-55-9"]
["BROMOMETHANE",null,null,null,"74-83-9"]
["METHYL CHLORIDE",null,null,null,"74-87-3"]
["METHYL IODIDE",null,null,null,"74-88-4"]
["ETHYL CHLORIDE",null,null,null,"75-00-3"]
["ACETONITRILE",null,null,null,"75-05-8"]
["ACETALDEHYDE",null,null,null,"75-07-0"]
["DICHLOROMETHANE",null,null,null,"75-09-2"]
["CARBON DISULFIDE",null,null,null,"75-15-0"]
["ETHYLENE OXIDE",null,null,null,"75-21-8"]
["BROMOFORM",null,null,null,"75-25-2"]
["DICHLOROETHANE, [1,1-]",null,null,null,"75-34-3"]
["DICHLOROETHYLENE, [1,1-]",null,null,null,"75-35-4"]
["PHOSGENE",null,null,null,"75-44-5"]
["PROPYLENEIMINE, [1,2-]",null,null,null,"75-55-8"]
["PROPYLENE OXIDE",null,null,null,"75-56-9"]
["HEXACHLOROCYCLOPENTADIENE",null,null,null,"77-47-4"]
["DIMETHYL SULFATE",null,null,null,"77-78-1"]
["ISOPHPRONE",null,null,null,"78-59-1"]
["DICHLOROPROPANE, [1,2-]",null,null,null,"78-87-5"]
["TRICHLOROETHANE, [1,1,2-]",null,null,null,"79-00-5"]
["TRICHLOROETHYLENE",null,null,null,"79-01-6"]
["ACRYLAMIDE",null,null,null,"79-06-1"]
["ACRYLIC ACID",null,null,null,"79-10-7"]
["CHLOROACETIC ACID",null,null,null,"79-11-8"]
["TETRACHLOROETHANE, [1,1,2,2-]",null,null,null,"79-34-5"]
["DIMETHYLCARBAMOYL CHLORIDE",null,null,null,"79-44-7"]
["NITROPROPANE, [2-]",null,null,null,"79-46-9"]
["METHYL METHACRYLATE",null,null,null,"80-62-6"]
["PENTACHLORONITROBENZENE",null,null,null,"82-68-8"]
["DIBUTYL PHTHALATE",null,null,null,"84-74-2"]
["PHTHALIC ANHYDRIDE",null,null,null,"85-44-9"]
["HEXACHLOROBUTADIENE",null,null,null,"87-68-3"]
["PENTACHLOROPHENOL",null,null,null,"87-86-5"]
["TRICHLOROPHENOL, [2,4,6-]",null,null,null,"88-06-2"]
["ANISIDINE, [ORTHO-]",null,null,null,"90-04-0"]
["NAPHTHALENE",null,null,null,"91-20-3"]
["QUINOLINE",null,null,null,"91-22-5"]
["DICHLOROBENZIDINE, [3.3-]",null,null,null,"91-94-1"]
["BIPHENYL, [1,1-]",null,null,null,"92-52-4"]
["AMINOBIPHENYL, [4-]",null,null,null,"92-67-1"]
["NITROBIPHENYL, [4-]",null,null,null,"92-93-3"]
["DICHLOROPHENOXYACETIC ACID, [2,4-]",null,null,null,"94-75-7"]
["XYLENE, [ORTHO-]",null,null,null,"95-47-6"]
["CRESOL, [ORTHO-]",null,null,null,"95-48-7"]
["TOLUIDINE, [ORTHO-]",null,null,null,"95-53-4"]
["DIAMINOTOLUENE, [2,4-]",null,null,null,"95-80-7"]
["TRICHLOROPHENOL, [2,4,5-]",null,null,null,"95-95-4"]
["STYRENE OXIDE",null,null,null,"96-09-3"]
["DIBROMO-3-CHLOROPROPANE, [1,2-]",null,null,null,"96-12-8"]
["ETHYLENE THIOUREA",null,null,null,"96-45-7"]
["BENZOTRICHLORIDE",null,null,null,"98-07-7"]
["CUMENE",null,null,null,"98-82-8"]
["ACETOPHENONE",null,null,null,"98-86-2"]
["NITROBENZENE",null,null,null,"98-95-3"]
["NITROPHENOL, [4-]",null,null,null,"100-02-7"]
["ETHYLBENZENE",null,null,null,"100-41-4"]
["STYRENE",null,null,null,"100-42-5 "]
["BENZYL CHLORIDE",null,null,null,"100-44-7"]
["METHYLENE BIS (2-CHLOROANILINE), [4,4-]",null,null,null,"101-14-4"]
["DIPHENYLMETHANE DIISOCYANATE, [4,4-]",null,null,null,"101-68-8"]
["METHYLENEDIANILINE, [4,4-]",null,null,null,"101-77-9"]
["XYLENE, [PARA-]",null,null,null,"106-42-3"]
["CRESOL, [PARA-]",null,null,null,"106-44-5"]
["DICHLOROBENZENE [1,4-]",null,null,null,"106-46-7"]
["PHENYLENEDIAMINE, [PARA-]",null,null,null,"106-50-3"]
["QUINONE",null,null,null,"106-51-4"]
["BUTYLENE OXIDE, [1,2-]",null,null,null,"106-88-7"]
["EPICHLOROHYDRIN",null,null,null,"106-89-8"]
["DIBROMOETHANE, [1,2-]",null,null,null,"106-93-4"]
["ACROLEIN",null,null,null,"107-02-8"]
["ALLYL CHLORIDE",null,null,null,"107-05-1"]
["DICHLOROETHANE, [1,2-]",null,null,null,"107-06-2"]
["ACRYLONITRILE",null,null,null,"107-13-1"]
["ETHYLENE GLYCOL",null,null,null,"107-21-1"]
["VINYL ACETATE",null,null,null,"108-05-4"]
["METHYL ISOBUTYL KETONE",null,null,null,"108-10-1"]
["MALEIC ANHYDRIDE",null,null,null,"108-31-6"]
["XYLENE, [META-]",null,null,null,"108-38-3"]
["CRESOL, [META-]",null,null,null,"108-39-4"]
["TOLUENE",null,null,null,"108-88-3"]
["CHLOROBENZENE",null,null,null,"108-90-7"]
["PHENOL",null,null,null,"108-95-2"]
["HEXANE, [N-]",null,null,null,"110-54-3"]
["DIETHANOLAMINE",null,null,null,"111-42-2"]
["BIS (CHLOROETHYL) ETHER",null,null,null,"111-44-4"]
["PROPOXUR [BAYGON]",null,null,null,"114-26-1"]
["DI (2-ETHYLEHEXYL) PHTHALATE, (DEHP)",null,null,null,"117-81-7"]
["DIMETHOXYBENZIDINE, [3,3'-]",null,null,null,"119-90-4"]
["DIMETHYL BENZIDINE,  [3,3'-]",null,null,null,"119-93-7"]
["CATECHOL",null,null,null,"120-80-9"]
["TRICHLOROBENZENE, [1,2,4-]",null,null,null,"120-82-1"]
["DINITROTOLUENE, [2,4-]",null,null,null,"121-14-2"]
["TRIETHYLAMINE",null,null,null,"121-44-8"]
["DIMETHYLANILINE, [N,N-]",null,null,null,"121-69-7"]
["DIPHENYLHYDRAZINE, [1,2-]",null,null,null,"122-66-7"]
["HYDROQUINONE",null,null,null,"123-31-9"]
["PROPIONALDEHYDE",null,null,null,"123-38-6"]
["DIOXANE, [1,4-]",null,null,null,"123-91-1"]
["CHLOROPRENE",null,null,null,"126-99-8"]
["TETRACHLOROETHYLENE",null,null,null,"127-18-4"]
["DIMETHYL PHTHALATE",null,null,null,"131-11-3"]
["DIBENZOFURAN",null,null,null,"132-64-9"]
["CAPTAN",null,null,null,"133-06-2"]
["CHLORAMBEN",null,null,null,"133-90-4"]
["ETHYL ACRYLATE",null,null,null,"140-88-5"]
["ETHYLENEIMINE [AZIRIDINE]",null,null,null,"151-56-4"]
["CALCIUM CYANAMIDE",null,null,null,"156-62-7"]
["HYDRAZINE",null,null,null,"302-01-2"]
["DIAZOMETHANE",null,null,null,"334-88-3"]
["CARBONYL SULFIDE",null,null,null,"463-58-1"]
["CHLOROBENZILATE",null,null,null,"510-15-6"]
["CHLOROACETOPHENONE, [2-]",null,null,null,"532-27-4"]
["DINITRO-O-CRESOL, [4,6-]",null,null,null,"534-52-1"]
["TRIMETHYLPENTANE, [2,2,4-]",null,null,null,"540-84-1"]
["DICHLOROPROPENE, [1,3-]",null,null,null,"542-75-6"]
["TOULENE DIISOCYANATE, [2,4-]",null,null,null,"584-84-9"]
["VINYL BROMIDE",null,null,null,"593-60-2"]
["METHYL ISOCYANATE",null,null,null,"624-83-9"]
["HEXAMETHYLPHOSPHORAMIDE",null,null,null,"680-31-9"]
["NITROSO-N-METHYLUREA, [N-]",null,null,null,"684-93-5"]
["HEXAMETHYLENE-1,6- DIISOCYANATE",null,null,null,"822-06-0"]
["PROPANE SULTONE, [1,3-]",null,null,null,"1120-71-4"]
["CRESOLS (MIXED ISOMERS)",null,null,null,"1319-77-3"]
["XYLENES (MIXED ISOMERS)",null,null,null,"1330-20-7"]
["METHYL TERT-BUTYL ETHER",null,null,null,"1634-04-4"]
["TITANIUM TETRACHLORIDE",null,null,null,"7550-45-0"]
["HYDROGEN CHLORIDE",null,null,null,"7647-01-0"]
["HYDROGEN FLUORIDE",null,null,null,"7664-39-3"]
["PHOSPHOROUS (YELLOW OR WHITE)",null,null,null,"7723-14-0"]
["CHLORINE",null,null,null,"7782-50-5"]
["PHOSPHINE",null,null,null,"7803-51-2"]

{"sheet":"3.0","index":22,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,8,35,9],[37,8,38,9],[22,8,23,8],[20,6,21,6],[33,0,33,10],[20,3,21,3],[23,0,23,1],[25,0,25,10],[34,7,35,7],[37,7,38,7],[6,0,6,1],[8,0,8,1],[9,0,9,1],[27,0,28,1],[24,0,24,1],[7,0,7,1],[26,0,26,10],[22,9,23,9],[6,2,7,10],[12,5,13,5],[14,5,15,5],[8,2,8,10],[12,6,13,6],[12,7,13,7],[14,7,15,7],[14,10,15,10],[14,9,15,9],[14,6,15,6],[18,0,18,1],[20,0,20,1],[21,0,21,1],[19,0,19,1],[29,0,30,10],[22,5,23,5],[20,10,21,10],[20,8,21,8],[20,9,21,9],[20,5,21,5],[20,7,21,7],[22,7,23,7],[22,0,22,1],[20,4,21,4],[44,0,44,3],[44,4,44,6],[47,0,47,10],[46,0,46,10],[44,8,44,10],[45,0,45,10],[42,0,42,10],[41,7,41,10],[41,4,41,6],[41,0,41,3],[12,9,13,9],[14,8,15,8],[16,9,17,9],[10,9,11,9],[10,10,11,10],[12,10,13,10],[43,7,43,10],[43,4,43,6],[43,0,43,3],[40,4,40,6],[40,0,40,3],[40,7,40,10],[39,0,39,10],[22,3,23,3],[22,10,23,10],[36,0,36,10],[34,0,35,6],[37,0,38,6],[34,10,35,10],[22,4,23,4],[22,6,23,6],[32,0,32,1],[31,0,31,10],[18,7,19,7],[18,9,19,9],[16,10,17,10],[14,4,15,4],[16,4,17,4],[16,5,17,5],[16,8,17,8],[16,7,17,7],[16,6,17,6],[18,6,19,6],[18,4,19,4],[18,5,19,5],[18,8,19,8],[18,10,19,10],[12,4,13,4],[10,8,11,8],[12,3,13,3],[14,3,15,3],[16,2,17,2],[22,2,23,2],[14,2,15,2],[16,3,17,3],[18,3,19,3],[20,2,21,2],[18,2,19,2],[12,8,13,8],[37,10,38,10],[4,0,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[5,0,5,3],[5,4,5,6],[5,7,5,8],[16,0,16,1],[17,0,17,1],[14,0,14,1],[15,0,15,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[5,9,5,10],[10,3,11,3],[10,2,11,2],[12,2,13,2],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 3.0 EMISSIONS FEE CALCULATION"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["1.",null,"Use one row to list the emissions from one emission unit.  Sum the emissions in the page total box at the bottom of the column.  If more than one page is needed, use the first row of the duplicated page to list the page totals from this page.  Express figures in tons per year and round to two decimal places."]
["EMISSION UNIT NO."]
["SCC",null,"AIR POLLUTANT"]
[null,null,"PM10","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5","NH3 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PAGE TOTALS",null,{"$f":"IF(AND(C11=\"\",C13=\"\",C15=\"\",C17=\"\",C19=\"\",C21=\"\",C23=\"\"),\"\",SUM(C11:C24))","v":""},"","","","","","","",""]
["Note: Fill out the lower portion of this form one time only."]
["2. ACTUAL EMISSIONS (Use the sum of all page totals for each pollutant for actual emission figures below.)"]
["Total",null,"PM10","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5","NH3 "]
[null,null,{"$f":"IF(C25=\"\",\"\",C25)","v":""},{"$f":"IF(D25=\"\",\"\",D25)","v":""},"","","","","","",""]
["Copy the actual emissions from section 2 to the appropriate box(es) in the Total Plant Emissions Section of                                                           Form 1.0 General Plant Information."]
[]
["3. CHARGEABLE EMISSIONS (Maximum 4,000 Tons/Yr. cap per pollutant)"]
["Total",null,{"$f":"IF(C29=\"\",\"\",IF(C29>4000,4000,C29))","v":""},{"$f":"IF(D29=\"\",\"\",IF(D29>4000,4000,D29))","v":""},{"$f":"IF(E29=\"\",\"\",IF(E29>4000,4000,E29))","v":""},{"$f":"IF(F29=\"\",\"\",IF(F29>4000,4000,F29))","v":""},"NO FEES FOR CO",{"$f":"IF(H29=\"\",\"\",IF(H29>4000,4000,H29))","v":""},{"$f":"IF(I29=\"\",\"\",IF(I29>4000,4000,I29))","v":""},"NO FEES FOR         PM2.5","NO FEES FOR          NH3"]
["4. SUM OF CHARGEABLE EMISSIONS SUBJECT TO FEES                                                                                                    "]
["Round chargeable emissions to the nearest whole ton.  The minimum emission tonnage is one ton, and the maximum is 12,000 tons per year.",null,null,null,null,null,null,null,{"$f":"IF(AND(C33=\"\",D33=\"\",E33=\"\",F33=\"\",H33=\"\",I33=\"\"),\"\",IF(SUM(C33,D33,E33,F33,H33,I33)>12000,12000,IF(SUM(C33,D33,E33,F33,H33,I33)<0.5,1,FIXED(SUM(C33,D33,E33,F33,H33,I33),0,FALSE))))","v":""},null,"Tons/Yr."]
[]
["5. TOTAL ANNUAL EMISSIONS FEE"]
["Multiply the sum of chargeable emissions as calculated in section 4 by fee set in 10 CSR 10-6.110 and enter this amount in section 5. ",null,null,null,null,null,null,"$",{"$f":"IF(I35=\"\",\"\",I35*55)","v":""}]
[]
["6. ANNUAL EMISSIONS FEE REMITTED TO THE CITY OF KANSAS CITY OR ST. LOUIS COUNTY LOCAL AIR AGENCY "]
["CHECK NUMBER",null,null,null,"CHECK DATE",null,null,"AMOUNT REMITTED IN CALENDAR YEAR OF RECORD"]
[]
["7. ANNUAL EMISSIONS FEE REMITTED TO THE STATE (SECTION 5 MINUS SECTION 6)"]
["CHECK NUMBER",null,null,null,"CHECK DATE",null,null,"CHECK AMOUNT"]
[null,null,null,null,null,null,null,"$"]
["8. INCLUDE A CHECK FOR THE AMOUNT IN SECTION 7, PAYABLE TO THE MISSOURI AIR POLLUTION CONTROL PROGRAM.       "]
["Mail the check for the emissions fee to the State Air Agency listed on Form 1.0."]
["9. SEND THE COMPLETED QUESTIONNAIRE AND ANY SUPPORTING DOCUMENTATION TO THE AGENCY LISTED AT THE BOTTOM OF FORM 1.0 GENERAL PLANT INFORMATION.  "]
["MO 780-1509-xls (12-15)"]

{"sheet":"3.0 P70","index":23,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[48,0,48,11],[47,0,47,11],[46,0,46,11],[14,11,15,11],[12,11,13,11],[40,0,40,11],[45,8,45,11],[44,7,44,11],[42,7,42,11],[22,11,23,11],[20,11,21,11],[18,11,19,11],[16,11,17,11],[20,2,21,2],[20,0,20,1],[21,0,21,1],[19,0,19,1],[18,2,19,2],[16,7,17,7],[18,0,18,1],[4,9,4,11],[5,0,5,3],[5,4,5,6],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[8,0,8,1],[6,2,6,11],[7,2,7,11],[5,7,5,8],[10,2,11,2],[4,0,4,3],[4,4,4,6],[4,7,4,8],[6,0,7,1],[9,0,9,1],[10,11,11,11],[10,0,10,1],[11,0,11,1],[12,10,13,10],[12,8,13,8],[12,9,13,9],[10,8,11,8],[10,9,11,9],[5,9,5,11],[12,2,13,2],[14,2,15,2],[16,2,17,2],[14,4,15,4],[16,4,17,4],[12,3,13,3],[14,3,15,3],[16,8,17,8],[10,7,11,7],[16,6,17,6],[22,0,22,1],[22,6,23,6],[20,5,21,5],[22,5,23,5],[23,0,23,1],[20,3,21,3],[22,2,23,2],[22,3,23,3],[12,5,13,5],[14,5,15,5],[12,6,13,6],[14,6,15,6],[18,6,19,6],[18,5,19,5],[12,0,12,1],[16,0,16,1],[17,0,17,1],[15,0,15,1],[14,0,14,1],[13,0,13,1],[41,4,41,6],[42,0,42,3],[41,0,41,3],[43,0,43,11],[45,0,45,3],[45,4,45,6],[42,4,42,6],[44,4,44,6],[41,7,41,11],[44,0,44,3],[12,4,13,4],[20,6,21,6],[8,2,8,11],[20,4,21,4],[16,5,17,5],[16,3,17,3],[18,3,19,3],[20,7,21,7],[18,4,19,4],[18,8,19,8],[18,7,19,7],[12,7,13,7],[14,7,15,7],[14,9,15,9],[14,8,15,8],[20,10,21,10],[16,10,17,10],[18,10,19,10],[14,10,15,10],[20,9,21,9],[16,9,17,9],[20,8,21,8],[18,9,19,9],[10,10,11,10],[33,0,33,1],[24,2,25,2],[22,4,23,4],[32,0,32,11],[31,0,31,11],[24,5,25,5],[29,0,30,1],[26,0,26,1],[25,0,25,1],[24,4,25,4],[24,3,25,3],[28,0,28,11],[24,11,25,11],[27,0,27,11],[24,8,25,8],[24,0,24,1],[24,9,25,9],[22,10,23,10],[22,9,23,9],[24,10,25,10],[24,6,25,6],[22,7,23,7],[24,7,25,7],[22,8,23,8],[34,0,34,11],[35,0,36,6],[35,7,36,7],[35,11,36,11],[35,8,36,10],[38,0,39,6],[38,7,39,7],[37,0,37,11],[38,11,39,11],[38,8,39,10]]}
[null,null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,null,"AIR POLLUTION CONTROL PROGRAM"]
[null,null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,null,"FORM 3.0 PART 70 OPERATING PERMIT EMISSIONS FEE CALCULATION"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["1.               EMISSION UNIT NO.",null,"Use one row to list the emissions from one emission unit.  Sum the emissions in the page total box at the bottom of the column.  If more than one page is needed, use the first row of the duplicated page to list the page totals from this page.  "]
[null,null,"Express figures in tons per year and round to two decimal places."]
["SCC",null,"AIR POLLUTANT"]
[null,null,"PM10 FIL","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5 FIL","NH3 ","PM CON"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PAGE TOTALS",null,{"$f":"IF(AND(C11=\"\",C13=\"\",C15=\"\",C17=\"\",C19=\"\",C21=\"\",C23=\"\",C25=\"\"),\"\",SUM(C11:C26))","v":""},"","","","","","","","",""]
["Note: Fill out the lower portion of this form one time only."]
["2. ACTUAL EMISSIONS (Use the sum of all page totals for each pollutant for actual emission figures below.)"]
["Total",null,"PM10 TOTAL","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5 TOTAL","NH3 ","PM CON "]
[null,null,{"$f":"IF(AND(C27=\"\",L27=\"\"),\"\",IF(C27=\"\",\"\",IF(AND(L27=\"\",C27>0),C27,C27+L27)))","v":""},{"$f":"IF(D27=\"\",\"\",D27)","v":""},"","","","","",{"$f":"IF(AND(J27=\"\",L27=\"\"),\"\",IF(J27=\"\",\"\",IF(AND(L27=\"\",J27>0),J27,J27+L27)))","v":""},"","Included in Total PM10 and PM2.5"]
["Copy the actual emissions from section 2 to the appropriate box(es) in the Total Plant Emissions Section of                                                           Form 1.0 General Plant Information."]
["3. CHARGEABLE EMISSIONS (Maximum 4,000 Tons/Yr. cap per pollutant.)"]
["Total",null,{"$f":"IF(C31=\"\",\"\",IF(C31>4000,4000,C31))","v":""},{"$f":"IF(D31=\"\",\"\",IF(D31>4000,4000,D31))","v":""},{"$f":"IF(E31=\"\",\"\",IF(E31>4000,4000,E31))","v":""},{"$f":"IF(F31=\"\",\"\",IF(F31>4000,4000,F31))","v":""},"NO FEES FOR CO",{"$f":"IF(H31=\"\",\"\",IF(H31>4000,4000,H31))","v":""},{"$f":"IF(I31=\"\",\"\",IF(I31>4000,4000,I31))","v":""},"NO FEES FOR         PM2.5","NO FEES FOR          NH3","PM CON is included in PM10 and PM2.5"]
["4. SUM OF CHARGEABLE EMISSIONS SUBJECT TO FEES                                                                                                    "]
["Round chargeable emissions to the nearest whole ton.  The minimum emission tonnage is one ton, and the maximum is 12,000 tons per year.",null,null,null,null,null,null,null,{"$f":"IF(AND(C34=\"\",D34=\"\",E34=\"\",F34=\"\",H34=\"\",I34=\"\"),\"\",IF(SUM(C34,D34,E34,F34,H34,I34)>12000,12000,IF(SUM(C34,D34,E34,F34,H34,I34)<0.5,1,FIXED(SUM(C34,D34,E34,F34,H34,I34),0,FALSE))))","v":""}]
[]
["5. TOTAL ANNUAL EMISSIONS FEE"]
["Multiply the sum of chargeable emissions as calculated in section 4 by fee set in 10 CSR 10-6.110 and enter this amount in section 5.",null,null,null,null,null,null,"$",{"$f":"IF(I36=\"\",\"\",I36*55)","v":""}]
[]
["6. ANNUAL EMISSIONS FEE REMITTED TO THE CITY OF KANSAS CITY OR ST. LOUIS COUNTY LOCAL AIR AGENCY "]
["CHECK NUMBER",null,null,null,"CHECK DATE",null,null,"AMOUNT REMITTED IN CALENDAR YEAR OF RECORD"]
[]
["7. ANNUAL EMISSIONS FEE REMITTED TO THE STATE (SECTION 5 MINUS SECTION 6)"]
["CHECK NUMBER",null,null,null,"CHECK DATE",null,null,"CHECK AMOUNT"]
[null,null,null,null,null,null,null,"$"]
["8. INCLUDE A CHECK FOR THE AMOUNT IN SECTION 7, PAYABLE TO THE MISSOURI AIR POLLUTION CONTROL PROGRAM.       "]
["Mail the check for the emissions fee to the State Air Agency listed on Form 1.0 General Plant Information."]
["9. SEND THE COMPLETED QUESTIONNAIRE AND ANY SUPPORTING DOCUMENTATION TO THE AGENCY LISTED AT THE BOTTOM OF FORM 1.0 GENERAL PLANT INFORMATION.  "]
["MO 780-2089-xls (12-15)"]

{"sheet":"3.0 CK","index":24,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,0,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[5,0,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[11,0,11,1],[12,0,12,1],[13,0,13,1],[16,0,16,1],[17,0,17,1],[14,0,14,1],[15,0,15,1],[10,2,11,2],[12,2,13,2],[10,6,11,6],[10,7,11,7],[12,6,13,6],[14,6,15,6],[10,8,11,8],[10,9,11,9],[14,2,15,2],[23,0,23,1],[16,3,17,3],[18,3,19,3],[20,3,21,3],[16,2,17,2],[19,0,19,1],[10,3,11,3],[18,2,19,2],[22,2,23,2],[18,0,18,1],[20,2,21,2],[20,0,20,1],[21,0,21,1],[22,0,22,1],[12,3,13,3],[14,3,15,3],[10,0,10,1],[32,0,32,10],[14,4,15,4],[16,4,17,4],[14,5,15,5],[24,8,25,8],[22,8,23,8],[20,4,21,4],[16,8,17,8],[18,8,19,8],[20,8,21,8],[20,9,21,9],[18,7,19,7],[20,7,21,7],[20,10,21,10],[16,10,17,10],[18,10,19,10],[14,10,15,10],[16,9,17,9],[18,9,19,9],[14,9,15,9],[14,8,15,8],[6,2,7,10],[22,7,23,7],[22,3,23,3],[22,6,23,6],[22,4,23,4],[7,0,7,1],[6,0,6,1],[8,0,8,1],[8,2,8,10],[20,5,21,5],[16,6,17,6],[12,5,13,5],[12,4,13,4],[16,5,17,5],[18,4,19,4],[22,5,23,5],[22,10,23,10],[22,9,23,9],[10,10,11,10],[12,10,13,10],[12,8,13,8],[12,9,13,9],[10,4,11,4],[10,5,11,5],[12,7,13,7],[14,7,15,7],[16,7,17,7],[9,0,9,1],[34,7,35,9],[25,0,25,1],[24,0,24,1],[24,9,25,9],[24,3,25,3],[24,2,25,2],[18,6,19,6],[20,6,21,6],[18,5,19,5],[29,0,30,1],[27,0,27,10],[24,5,25,5],[24,4,25,4],[28,0,28,10],[26,0,26,1],[24,10,25,10],[24,7,25,7],[24,6,25,6],[31,0,31,10],[34,10,35,10],[33,0,33,1],[34,0,34,6],[36,0,36,5],[39,0,39,10],[37,0,37,5],[36,6,37,10],[38,0,38,10],[40,0,40,10],[35,0,35,6]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 3.0 CK CHARCOAL KILN EMISSIONS FEE CALCULATION"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.",null,"YEAR OF DATA"]
[]
["1.",null,"Use one row to list the emissions from one emission unit.  Sum the emissions in the page total box at the bottom of the column.  If more than one page is needed, use the first row of the duplicated page to list the page totals from this page.  Express figures in tons per year and round to two decimal places."]
["EMISSION UNIT NO"]
["SCC",null,"AIR POLLUTANT"]
[null,null,"PM10","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5","NH3 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PAGE TOTALS",null,{"$f":"IF(AND(C11=\"\",C13=\"\",C15=\"\",C17=\"\",C19=\"\",C21=\"\",C23=\"\",C25=\"\"),\"\",SUM(C11:C26))","v":""},"","","","","","","",""]
["Note: Fill out the lower portion of this form one time only."]
["2. ACTUAL EMISSIONS (Use the sum of all page totals for each pollutant for actual emission figures below.)"]
[null,null,"PM10","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5","NH3 "]
[null,null,{"$f":"IF(C27=\"\",\"\",C27)","v":""},"","","","","","","",""]
["Copy the actual emissions from section 2 to the appropriate box(s) in the Total Plant Emissions section of Form 1.0."]
["3. CHARGEABLE EMISSIONS (Maximum 4,000 Tons/Yr. cap per pollutant)"]
[null,null,{"$f":"IF(C31=\"\",\"\",IF(C31>4000,4000,C31))","v":""},{"$f":"IF(D31=\"\",\"\",IF(D31>4000,4000,D31))","v":""},{"$f":"IF(E31=\"\",\"\",IF(E31>4000,4000,E31))","v":""},{"$f":"IF(F31=\"\",\"\",IF(F31>4000,4000,F31))","v":""},"NO FEES FOR CO",{"$f":"IF(H31=\"\",\"\",IF(H31>4000,4000,H31))","v":""},{"$f":"IF(I31=\"\",\"\",IF(I31>4000,4000,I31))","v":""},"NO FEES FOR         PM2.5","NO FEES FOR NH3"]
["4. SUM OF EMISSIONS                                                                                           ",null,null,null,null,null,null,{"$f":"IF(AND(C34=\"\",D34=\"\",E34=\"\",F34=\"\",H34=\"\",I34=\"\"),\"\",IF(SUM(C34,D34,E34,F34,H34,I34)>12000,12000,IF(SUM(C34,D34,E34,F34,H34,I34)<0.5,1,(FIXED(SUM(C34,D34,E34,F34,H34,I34),0,FALSE)))))","v":""},null,null,"Tons/Yr."]
["Round figure to nearest ton per year"]
["5. TOTAL ANNUAL EMISSIONS FEE"]
["Facilities that produce charcoal from wood are exempt from fees."]
["6. INCLUDE A CHECK FOR THE AMOUNT IN BOX 5, PAYABLE TO THE MISSOURI AIR POLLUTION CONTROL PROGRAM."]
["Mail the check for the emissions fee to the State Air Agency listed on Form 1.0."]
["7. SEND THE COMPLETED QUESTIONNAIRE AND ANY SUPPORTING DOCUMENTATION TO THE AGENCY LISTED AT THE BOTTOM OF FORM 1.0."]
["MO 780-1508-xls (12-15)"]

{"sheet":"3.0 List","index":25,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,0,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[10,2,11,2],[12,2,13,2],[5,0,5,3],[6,2,7,10],[10,3,11,3],[10,0,10,1],[11,0,11,1],[5,4,5,6],[5,7,5,8],[5,9,5,10],[16,0,16,1],[15,0,15,1],[14,0,14,1],[12,3,13,3],[14,3,15,3],[16,2,17,2],[30,10,31,10],[22,6,23,6],[18,9,19,9],[18,8,19,8],[20,7,21,7],[22,10,23,10],[20,10,21,10],[16,10,17,10],[18,10,19,10],[16,7,17,7],[20,8,21,8],[16,8,17,8],[20,9,21,9],[18,7,19,7],[16,6,17,6],[20,6,21,6],[16,9,17,9],[18,6,19,6],[50,0,50,1],[24,4,25,4],[24,3,25,3],[26,0,26,1],[26,2,27,2],[24,2,25,2],[26,4,27,4],[27,0,27,1],[22,9,23,9],[24,6,25,6],[22,7,23,7],[30,5,31,5],[30,6,31,6],[30,7,31,7],[26,6,27,6],[26,7,27,7],[28,5,29,5],[30,9,31,9],[22,2,23,2],[22,0,22,1],[23,0,23,1],[6,0,6,1],[8,0,8,1],[9,0,9,1],[25,0,25,1],[24,0,24,1],[17,0,17,1],[12,0,12,1],[28,6,29,6],[30,8,31,8],[12,5,13,5],[14,5,15,5],[16,5,17,5],[10,8,11,8],[12,8,13,8],[14,8,15,8],[14,6,15,6],[14,7,15,7],[18,2,19,2],[10,4,11,4],[10,5,11,5],[10,6,11,6],[12,7,13,7],[12,6,13,6],[12,4,13,4],[8,2,8,10],[24,7,25,7],[24,5,25,5],[22,3,23,3],[20,4,21,4],[22,4,23,4],[29,0,29,1],[28,0,28,1],[7,0,7,1],[24,10,25,10],[14,10,15,10],[10,9,11,9],[10,10,11,10],[12,10,13,10],[12,9,13,9],[14,9,15,9],[10,7,11,7],[14,4,15,4],[16,4,17,4],[16,3,17,3],[14,2,15,2],[18,0,18,1],[20,2,21,2],[20,0,20,1],[26,3,27,3],[18,4,19,4],[20,3,21,3],[26,5,27,5],[18,3,19,3],[13,0,13,1],[24,9,25,9],[24,8,25,8],[22,8,23,8],[21,0,21,1],[19,0,19,1],[28,10,29,10],[28,7,29,7],[26,8,27,8],[26,9,27,9],[26,10,27,10],[28,8,29,8],[28,9,29,9],[18,5,19,5],[20,5,21,5],[22,5,23,5],[30,0,30,1],[30,2,31,2],[30,3,31,3],[31,0,31,1],[32,5,33,5],[28,2,29,2],[28,3,29,3],[32,3,33,3],[32,4,33,4],[30,4,31,4],[28,4,29,4],[34,0,34,1],[34,2,35,2],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,6],[32,0,32,1],[32,2,33,2],[35,0,35,1],[33,0,33,1],[32,9,33,9],[32,10,33,10],[34,7,35,7],[34,8,35,8],[32,7,33,7],[32,8,33,8],[34,9,35,9],[34,10,35,10],[32,6,33,6],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[38,10,39,10],[39,0,39,1],[36,8,37,8],[36,6,37,6],[36,9,37,9],[36,10,37,10],[37,0,37,1],[38,0,38,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[38,5,39,5],[36,0,36,1],[36,2,37,2],[36,3,37,3],[36,4,37,4],[36,5,37,5],[36,7,37,7],[44,9,45,9],[44,10,45,10],[45,0,45,1],[42,9,43,9],[42,10,43,10],[43,0,43,1],[44,0,44,1],[40,7,41,7],[40,8,41,8],[40,9,41,9],[40,10,41,10],[41,0,41,1],[42,0,42,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[40,0,40,1],[40,2,41,2],[40,3,41,3],[40,4,41,4],[40,5,41,5],[40,6,41,6],[44,2,45,2],[44,3,45,3],[44,4,45,4],[44,8,45,8],[44,5,45,5],[44,6,45,6],[44,7,45,7],[42,6,43,6],[42,7,43,7],[42,8,43,8],[48,6,49,6],[48,7,49,7],[48,8,49,8],[48,9,49,9],[48,10,49,10],[49,0,49,1],[46,7,47,7],[46,8,47,8],[46,9,47,9],[46,10,47,10],[47,0,47,1],[48,0,48,1],[48,2,49,2],[48,3,49,3],[48,4,49,4],[48,5,49,5],[46,0,46,1],[46,2,47,2],[46,3,47,3],[46,4,47,4],[46,5,47,5],[46,6,47,6]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 3.0 LIST EMISSIONS FEE CALCULATION"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.",null,"YEAR OF DATA"]
[]
[null,null,"Use one row to list the emissions from one emission unit.  Sum the emissions in the page total box at the bottom of the column.  If more than one page is needed, use the first row of the duplicated page to list the page totals from this page.  Express figures in tons per year and round to two decimal places."]
["EMISSION UNIT NO."]
["SCC",null,"AIR POLLUTANT"]
[null,null,"PM10","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5","NH3 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PAGE TOTALS",null,{"$f":"IF(AND(C11=\"\",C13=\"\",C15=\"\",C17=\"\",C19=\"\",C21=\"\",C23=\"\",C25=\"\",C27=\"\",C29=\"\",C31=\"\",C33=\"\",C35=\"\",C37=\"\",C39=\"\",C41=\"\",C43=\"\",C45=\"\",C47=\"\",C49=\"\"),\"\",SUM(C11:C50))","v":""},{"$f":"IF(AND(D11=\"\",D13=\"\",D15=\"\",D17=\"\",D19=\"\",D21=\"\",D23=\"\",D25=\"\",D27=\"\",D29=\"\",D31=\"\",D33=\"\",D35=\"\",D37=\"\",D39=\"\",D41=\"\",D43=\"\",D45=\"\",D47=\"\",D49=\"\"),\"\",SUM(D11:D50))","v":""},"","","","","","",""]

{"sheet":"3.0 List P70","index":26,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[32,11,33,11],[30,11,31,11],[28,11,29,11],[26,11,27,11],[40,11,41,11],[38,11,39,11],[36,11,37,11],[34,11,35,11],[12,11,13,11],[24,11,25,11],[22,11,23,11],[20,11,21,11],[18,11,19,11],[16,11,17,11],[14,11,15,11],[48,4,49,4],[48,5,49,5],[48,6,49,6],[48,7,49,7],[48,11,49,11],[46,11,47,11],[44,11,45,11],[42,11,43,11],[48,8,49,8],[48,9,49,9],[48,10,49,10],[44,8,45,8],[44,9,45,9],[44,10,45,10],[49,0,49,1],[42,9,43,9],[42,10,43,10],[43,0,43,1],[44,0,44,1],[44,2,45,2],[44,3,45,3],[44,4,45,4],[44,5,45,5],[44,6,45,6],[46,5,47,5],[46,6,47,6],[46,7,47,7],[46,8,47,8],[46,0,46,1],[46,2,47,2],[46,3,47,3],[46,4,47,4],[46,9,47,9],[46,10,47,10],[47,0,47,1],[48,0,48,1],[48,2,49,2],[48,3,49,3],[44,7,45,7],[42,5,43,5],[42,6,43,6],[42,7,43,7],[42,8,43,8],[42,0,42,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[45,0,45,1],[40,4,41,4],[40,5,41,5],[40,6,41,6],[40,7,41,7],[36,10,37,10],[37,0,37,1],[38,0,38,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[40,8,41,8],[40,9,41,9],[40,10,41,10],[41,0,41,1],[38,9,39,9],[38,10,39,10],[39,0,39,1],[40,0,40,1],[40,2,41,2],[40,3,41,3],[36,9,37,9],[32,9,33,9],[32,10,33,10],[34,7,35,7],[34,8,35,8],[34,10,35,10],[32,6,33,6],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[34,9,35,9],[34,0,34,1],[34,2,35,2],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,6],[36,5,37,5],[36,7,37,7],[36,8,37,8],[35,0,35,1],[36,0,36,1],[36,2,37,2],[36,3,37,3],[36,4,37,4],[7,0,7,1],[6,0,6,1],[8,0,8,1],[8,2,8,11],[7,2,7,11],[6,2,6,11],[9,0,9,1],[25,0,25,1],[24,0,24,1],[18,6,19,6],[20,6,21,6],[18,5,19,5],[20,5,21,5],[22,3,23,3],[18,4,19,4],[20,4,21,4],[22,5,23,5],[22,4,23,4],[10,11,11,11],[56,0,56,1],[24,4,25,4],[24,3,25,3],[26,0,26,1],[26,2,27,2],[24,2,25,2],[26,4,27,4],[28,0,28,1],[28,2,29,2],[28,3,29,3],[27,0,27,1],[26,3,27,3],[29,0,29,1],[28,4,29,4],[32,0,32,1],[32,2,33,2],[32,3,33,3],[32,4,33,4],[33,0,33,1],[30,0,30,1],[30,2,31,2],[30,3,31,3],[30,4,31,4],[31,0,31,1],[32,8,33,8],[22,10,23,10],[22,9,23,9],[24,10,25,10],[24,6,25,6],[22,7,23,7],[22,6,23,6],[24,9,25,9],[24,8,25,8],[30,9,31,9],[30,10,31,10],[30,6,31,6],[30,7,31,7],[30,8,31,8],[28,8,29,8],[28,6,29,6],[28,9,29,9],[28,10,29,10],[28,7,29,7],[26,7,27,7],[26,8,27,8],[26,9,27,9],[26,10,27,10],[24,7,25,7],[12,5,13,5],[14,5,15,5],[16,5,17,5],[36,6,37,6],[24,5,25,5],[26,6,27,6],[32,5,33,5],[12,6,13,6],[32,7,33,7],[30,5,31,5],[26,5,27,5],[28,5,29,5],[20,10,21,10],[16,10,17,10],[18,10,19,10],[14,10,15,10],[10,8,11,8],[10,9,11,9],[10,10,11,10],[12,10,13,10],[12,8,13,8],[12,9,13,9],[20,9,21,9],[16,8,17,8],[18,8,19,8],[16,9,17,9],[18,9,19,9],[20,8,21,8],[16,4,17,4],[16,3,17,3],[18,3,19,3],[20,3,21,3],[14,3,15,3],[22,2,23,2],[14,9,15,9],[14,8,15,8],[10,3,11,3],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,4,11,4],[12,4,13,4],[14,4,15,4],[12,3,13,3],[20,7,21,7],[18,7,19,7],[14,6,15,6],[16,6,17,6],[12,7,13,7],[14,7,15,7],[16,7,17,7],[22,8,23,8],[12,0,12,1],[13,0,13,1],[18,0,18,1],[20,2,21,2],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[19,0,19,1],[18,2,19,2],[4,0,4,3],[4,4,4,6],[16,0,16,1],[17,0,17,1],[50,11,51,11],[51,0,51,1],[50,5,51,5],[50,6,51,6],[50,7,51,7],[50,8,51,8],[10,2,11,2],[12,2,13,2],[14,2,15,2],[16,2,17,2],[4,7,4,8],[4,9,4,11],[5,0,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,11],[14,0,14,1],[15,0,15,1],[10,0,10,1],[11,0,11,1],[50,0,50,1],[50,2,51,2],[54,9,55,9],[54,10,55,10],[50,3,51,3],[50,4,51,4],[52,3,53,3],[52,4,53,4],[50,9,51,9],[50,10,51,10],[52,9,53,9],[52,10,53,10],[52,11,53,11],[53,0,53,1],[52,5,53,5],[52,6,53,6],[52,7,53,7],[52,8,53,8],[52,0,52,1],[52,2,53,2],[54,11,55,11],[55,0,55,1],[54,5,55,5],[54,6,55,6],[54,7,55,7],[54,8,55,8],[54,0,54,1],[54,2,55,2],[54,3,55,3],[54,4,55,4]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"FORM 3.0 LIST PART 70 OPERATING PERMIT EMISSIONS FEE CALCULATION"]
["FACILITY NAME",null,null,null,"FIPS COUNTY NO.",null,null,"PLANT NO.",null,"YEAR OF DATA"]
[]
[null,null,"Use one row to list the emissions from one emission unit.  Sum the emissions in the page total box at the bottom of the column.  If more than one page is needed, use the first row of the duplicated page to list the page "]
["EMISSION UNIT NO.",null,"totals from this page.  Express figures in tons per year and round to two decimal places."]
["SCC",null,"AIR POLLUTANT"]
[null,null,"PM10 FIL","SOX ","NOX ","VOC","CO","LEAD","HAPs","PM2.5 FIL","NH3 ","PM CON"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PAGE TOTALS",null,{"$f":"IF(AND(C11=\"\",C13=\"\",C15=\"\",C17=\"\",C19=\"\",C21=\"\",C23=\"\",C25=\"\",C27=\"\",C29=\"\",C31=\"\",C33=\"\",C35=\"\",C37=\"\",C39=\"\",C41=\"\",C43=\"\",C45=\"\",C47=\"\",C49=\"\"),\"\",SUM(C11:C50))","v":""},"","","","","","","","",""]

{"sheet":"4.0","index":27,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":false,"merged":[[20,0,24,2],[19,0,19,2],[18,0,18,2],[6,0,7,7],[19,3,24,7],[4,0,4,4],[5,0,5,4],[8,0,10,7],[17,1,17,2],[16,1,16,2],[15,1,15,2],[14,1,14,2],[13,1,13,2],[11,0,11,7],[12,0,12,2]]}
[null,null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,null,"AIR POLLUTION CONTROL PROGRAM"]
[null,null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,null,"FORM 4.0 FINANCIAL COST ESTIMATE"]
["FACILITY NAME",null,null,null,null,"FIPS COUNTY NO.","PLANT NO.","YEAR OF DATA"]
[]
["The Missouri Air Conservation Law, Chapter 643, requires a financial cost estimate.  The cost estimate is an evaluation of any additional costs of doing business attributable to the Federal Clean Air Act, as amended.  "]
[]
["Calculate the cost and expenses incurred to complete the Emission Inventory Questionnaire, including the calculation of emission fees.  If you hired an outside consultant, include the time and money charged to your company.  Also include any cost incurred if you installed air pollution control equipment, any additional monitoring or testing expense or any additional personnel costs incurred to comply with the Missouri Air Conservation Law and the Federal Clean Air Act, as amended.  "]
[]
[]
["Be sure to use the codes found in the instructions:  www.dnr.mo.gov/env/apcp/eiq/eiqinformation.htm ."]
["CATEGORY REPORTING",null,null,"CODE FOR PERSONNEL OR EQUIPMENT","NUMBER OF EMPLOYEES","TOTAL NUMBER OF HOURS REQUIRED","COST PER HOUR","TOTAL COST"]
["1.","EIQ reviewed and completed by company personnel (engineers, technical specialists, others).",null,null,null,null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),\"\",F14*G14)","v":""}]
["2.","EIQ completed by outside engineering consultants.",null,null,null,null,null,{"$f":"IF(OR(F15=\"\",G15=\"\"),\"\",F15*G15)","v":""}]
["3.","Pollution control equipment, monitoring, or testing                                                               (List items separately)."]
["4.","Estimate of the number of jobs added to implement the Federal Clean Air Act, as amended.",null,null,null,null,null,{"$f":"IF(OR(F17=\"\",G17=\"\"),\"\",F17*G17)","v":""}]
["5.","Personnel and other costs associated with complying with the Clean Air Act, as amended, not included above.                                                                            "]
["Total",null,null,null,{"$f":"IF(AND(E14=\"\",E15=\"\",E17=\"\"),\"\",SUM(E14,E15,E17))","v":""},{"$f":"IF(AND(F14=\"\",F15=\"\",F17=\"\"),\"\",SUM(F14,F15,F17))","v":""},null,{"$f":"IF(AND(H14=\"\",H15=\"\",H16=\"\",H17=\"\",H18=\"\"),\"\",SUM(H14:H18))","v":""}]
["REMARKS"]
[]
[]
[]
[]
[]
["MO 780-1622-xls (12-09)"]
[]
[]
[null,"A01","Accountant / Bookkeeper ",{"$f":"CONCATENATE(B29,\" \",C29)","v":"A01 Accountant / Bookkeeper "}]
[null,"A02","Administrative Assistant / Secretary",{"$f":"CONCATENATE(B30,\" \",C30)","v":"A02 Administrative Assistant / Secretary"}]
[null,"A03","Consultant (Engineering, Environmental, and Safety)","A03 Consultant (Engineering, Environmental, and Safety)"]
[null,"A04","Coordinator (Compliance, Environmental, Facility, Permit and Safety)","A04 Coordinator (Compliance, Environmental, Facility, Permit and Safety)"]
[null,"A05","Director ","A05 Director "]
[null,"A06","Data Assistant / Data Processor","A06 Data Assistant / Data Processor"]
[null,"A07","Draftsman / CAD Operator","A07 Draftsman / CAD Operator"]
[null,"A08","Engineer - Environmental/Air Quality","A08 Engineer - Environmental/Air Quality"]
[null,"A09","Engineer - Professional (not Environmental)","A09 Engineer - Professional (not Environmental)"]
[null,"A10","Engineer - Other","A10 Engineer - Other"]
[null,"A11","Environmental Chemist/Scientist","A11 Environmental Chemist/Scientist"]
[null,"A12","Environmental Assistant","A12 Environmental Assistant"]
[null,"A13","Floor Employee / Operator","A13 Floor Employee / Operator"]
[null,"A14","Geologist","A14 Geologist"]
[null,"A15","Industrial Hygienist","A15 Industrial Hygienist"]
[null,"A16","Investigator, Senior","A16 Investigator, Senior"]
[null,"A17","Manager / Supervisor","A17 Manager / Supervisor"]
[null,"A18","Metallurgist","A18 Metallurgist"]
[null,"A19","MIS Programmer","A19 MIS Programmer"]
[null,"A20","Owner / Co-owner","A20 Owner / Co-owner"]
[null,"A21","President / Vice President / CEO","A21 President / Vice President / CEO"]
[null,"A22","Production Planner","A22 Production Planner"]
[null,"A23","Regulatory Leader","A23 Regulatory Leader"]
[null,"A24","Scientist (Air Quality and Environmental)","A24 Scientist (Air Quality and Environmental)"]
[null,"A25","Senior Field Specialist","A25 Senior Field Specialist"]
[null,"A26","Specialist ","A26 Specialist "]
[null,"A27","Superintendent ","A27 Superintendent "]
[null,"A28","Systems Administrator / Operator","A28 Systems Administrator / Operator"]
[null,"A29","Technician ","A29 Technician "]
[null,"AXX","Other (Put job title in remarks section)","AXX Other (Put job title in remarks section)"]
[null,"B01","Ash Removal System","B01 Ash Removal System"]
[null,"B02","Chromium Plating Emissions Control Device","B02 Chromium Plating Emissions Control Device"]
[null,"B03","Control Equipment","B03 Control Equipment"]
[null,"B04","Dust Collectors","B04 Dust Collectors"]
[null,"B05","Dust Sprayers","B05 Dust Sprayers"]
[null,"B06","Filters","B06 Filters"]
[null,"B07","Maintenance of Control Equipment","B07 Maintenance of Control Equipment"]
[null,"B08","Mill Steam Inerting","B08 Mill Steam Inerting"]
[null,"B09","Nitrogen Oxides Burners","B09 Nitrogen Oxides Burners"]
[null,"B10","Rack With Emission Controls","B10 Rack With Emission Controls"]
[null,"B11","Scrubber","B11 Scrubber"]
[null,"B12","Suppressants","B12 Suppressants"]
[null,"B13","Thermal Oxidizer","B13 Thermal Oxidizer"]
[null,"B14","Vapor Condenser","B14 Vapor Condenser"]
[null,"B15","Water Trucks","B15 Water Trucks"]
[null,"BXX","OTHER : (List in remarks section)","BXX OTHER : (List in remarks section)"]
[null,"C01","Engineering Support And Consultants","C01 Engineering Support And Consultants"]
[null,"C02","Environmental Technicians","C02 Environmental Technicians"]
[null,"C03","Maintenance Personnel","C03 Maintenance Personnel"]
[null,"C04","Supervisory Personnel","C04 Supervisory Personnel"]
[null,"C05","Water Truck Drivers","C05 Water Truck Drivers"]
[null,"C06","Other Control Device Operators","C06 Other Control Device Operators"]
[null,"CXX","OTHER : (List in remarks section)","CXX OTHER : (List in remarks section)"]
[null,"D01","CEM Capital Costs","D01 CEM Capital Costs"]
[null,"D02","CEM Operations and Maintenance","D02 CEM Operations and Maintenance"]
[null,"D03","CEM Testing","D03 CEM Testing"]
[null,"D04","Continuous Emissions Monitor (CEM)",{"$f":"CONCATENATE(B85,\" \",C85)","v":"D04 Continuous Emissions Monitor (CEM)"}]
[null,"D05","Contract Labor","D05 Contract Labor"]
[null,"D06","Data Reporting","D06 Data Reporting"]
[null,"D07","Leak Detection and Repair","D07 Leak Detection and Repair"]
[null,"D08","Testing","D08 Testing"]
[null,"D09","Vapor Combustion Performance Test","D09 Vapor Combustion Performance Test"]
[null,"DXX","OTHER : (List in remarks section)","DXX OTHER : (List in remarks section)"]
[null,"E01","CAD Draftsman","E01 CAD Draftsman"]
[null,"E02","Electricity","E02 Electricity"]
[null,"E03","Calculation of Emission Fees","E03 Calculation of Emission Fees"]
[null,"E04","Nonspecific Costs","E04 Nonspecific Costs"]
[null,"E05","Permit Fees","E05 Permit Fees"]
[null,"E06","Software Maintenance Contract","E06 Software Maintenance Contract"]
[null,"E07","Taxes","E07 Taxes"]
[null,"E08","Training and Meeting Expenses","E08 Training and Meeting Expenses"]
[null,"EXX","OTHER : (List in remarks section)","EXX OTHER : (List in remarks section)"]

{"sheet":"DRY CLEANER","index":28,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[26,7,26,12],[33,5,34,5],[33,6,34,6],[33,7,34,7],[33,1,34,1],[33,0,34,0],[33,9,34,9],[33,12,34,12],[33,4,34,4],[22,0,22,3],[22,4,22,8],[22,9,22,11],[23,0,23,12],[20,0,20,12],[21,9,21,12],[21,4,21,8],[21,0,21,3],[24,0,25,12],[15,7,15,12],[14,7,14,12],[19,0,19,6],[18,7,18,8],[19,7,19,8],[19,9,19,12],[17,0,17,6],[17,7,17,12],[18,9,18,12],[18,0,18,6],[4,6,4,7],[4,4,4,5],[4,2,4,3],[5,8,5,9],[39,0,39,4],[38,0,38,4],[28,7,28,12],[5,11,5,12],[6,0,6,12],[5,0,5,1],[5,2,5,3],[5,4,5,5],[4,0,4,1],[4,11,4,12],[4,8,4,9],[9,6,9,9],[9,0,9,5],[7,0,7,2],[7,10,7,12],[8,10,8,12],[8,0,8,2],[8,7,8,9],[7,7,7,9],[8,3,8,6],[48,9,48,10],[48,11,48,12],[48,0,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[42,6,42,10],[42,0,42,5],[5,6,5,7],[7,3,7,6],[12,0,12,5],[12,6,12,9],[12,11,12,12],[13,0,13,12],[10,0,10,5],[10,6,10,9],[10,11,10,12],[11,11,11,12],[11,6,11,9],[11,0,11,5],[14,0,14,6],[16,7,16,12],[16,0,16,6],[15,0,15,6],[47,5,47,6],[47,7,47,8],[46,9,46,12],[44,6,44,10],[44,0,44,5],[45,11,45,12],[47,9,47,10],[47,11,47,12],[47,0,47,2],[47,3,47,4],[43,11,43,12],[43,6,43,10],[40,0,40,12],[33,8,34,8],[33,2,34,3],[38,5,38,9],[36,5,36,9],[33,10,34,10],[42,11,42,12],[38,10,39,10],[36,10,37,10],[38,11,39,11],[39,5,39,9],[38,12,39,12],[9,11,9,12],[45,6,45,10],[45,0,45,5],[43,0,43,5],[26,0,26,6],[41,0,41,12],[35,0,35,12],[36,11,37,11],[36,12,37,12],[29,7,29,12],[30,7,30,12],[31,7,31,12],[31,0,31,6],[27,7,27,12],[27,0,27,6],[28,0,28,6],[29,0,29,6],[30,0,30,6],[37,5,37,8],[37,0,37,4],[36,0,36,4],[32,0,32,12],[33,11,34,11],[44,11,44,12]]}
[null,"MISSOURI DEPARTMENT OF NATURAL RESOURCES"]
[null,"AIR POLLUTION CONTROL PROGRAM"]
[null,"EMISSIONS INVENTORY QUESTIONNAIRE, OR EIQ"]
[null,"DRY CLEANER - NON-CHLORINATED AND PETROLEUM BASED SOLVENTS"]
["FIPS COUNTY NO.",null,"PLANT NO.",null,"COUNTY",null,"EMISSION UNIT NO.",null,"SCC",null,"SEG. NO.","YEAR OF DATA"]
[]
["1. DRY CLEANER INFORMATION"]
["FACILITY NAME",null,null,"CONTACT PERSON NAME/TITLE",null,null,null,"PHONE NUMBER WITH AREA CODE",null,null,"FAX NUMBER WITH AREA CODE"]
[]
["STREET ADDRESS",null,null,null,null,null,"CITY",null,null,null,"STATE","ZIP CODE +4"]
[]
["MAILING ADDRESS (IF DIFFERENT FROM ABOVE)",null,null,null,null,null,"CITY",null,null,null,"STATE","ZIP CODE +4"]
[]
["2. PARENT COMPANY INFORMATION"]
["PARENT COMPANY NAME",null,null,null,null,null,null,"OWNER'S PHONE NUMBER WITH AREA CODE"]
[]
["STREET ADDRESS, P.O. BOX OR ROUTE NUMBER",null,null,null,null,null,null,"FAX NUMBER WITH AREA CODE"]
[]
["CITY",null,null,null,null,null,null,"STATE",null,"ZIP CODE +4"]
[]
["3. MACHINE INFORMATION"]
["NUMBER OF DRY TO DRY MACHINES",null,null,null,"NUMBER OF TRANSFER MACHINES",null,null,null,null,"TOTAL COMBINED DRYER CAPACITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lbs."]
["4. SOLVENT DETAIL"]
["SOLVENT TYPE (CHECK ONE)"]
[]
["Calculate Solvent Use",null,null,null,null,null,null,"Non-Chlorinated (Non-perc)"]
["Gallons on hand from previous year"]
["Gallons brought on-site during calendar year (+)"]
["Unused gallons transferred off-site (-)"]
["Gallons on hand at end of calendar year (-)"]
["(a) Total gallons used during calendar year (=)",null,null,null,null,null,null,{"$f":"IF(OR(H28=\"\",H29=\"\",H30=\"\",H31=\"\"),\"\",H28+H29-H30-H31)","v":""}]
["5. CALCULATE GALLONS SOLVENT SHIPPED AS WASTE"]
["Number of Filters","×","Conversion Factor (Default  = 0.1)",null,"=","(b)",null,"Gallons of Sludge","×",0.1,"=","(c)"]
[]
["6. CALCULATE AIR EMISSIONS FEE "]
["[a-b-c] × Solvent Density",null,null,null,null,"Solvent Density             lbs./gal.",null,null,null,null,"1.",{"$f":"IF(OR(H32=\"\",G34=\"\",M34=\"\"),\"\",IF((((H32-G34-M34)*6.316)/2000)<0.5,1,FIXED((((H32-G34-M34)*6.316)/2000),0,TRUE)))","v":""},"Tons/Yr."]
["2,000 pounds per ton",null,null,null,null,"Stoddard:  6.316        Other:  "]
["One ton minimum used to calculate fees",null,null,null,null,"Tons/Yr. (rounded to the nearest whole number)",null,null,null,null,"2.","$",{"$f":"IF(L37=\"\",\"\",L37*48)","v":""}]
["(See instructions for current fee schedule).",null,null,null,null,"× Emission Fee"]
["7. CERTIFICATION"]
["The undersigned certifies that they have personally examined and are familiar with the information and statements contained herin and further certifies they believe this information is true, accurate and complete.  The undersigned certifies that knowingly making a false statement or misrepresenting the facts presented in this document is a violation of state law.  "]
["PRINTED NAME AND TITLE OF PERSON COMPLETING FORM",null,null,null,null,null,"SIGNATURE OF PERSON COMPLETING FORM",null,null,null,null,"DATE"]
[]
["PRINTED NAME AND TITLE OF AUTHORIZED COMPANY REPRESENTATIVE",null,null,null,null,null,"SIGNATURE OF AUTHORIZED COMPANY REPRESENTATIVE",null,null,null,null,"DATE"]
[]
["CHECK INFORMATION",null,null,null,null,null,null,null,null,"OFFICE USE ONLY"]
["EMISSION FEE",null,null,"CHECK AMOUNT",null,"CHECK DATE",null,"CHECK NO.",null,"LOGGED IN BY",null,"DATE RECEIVED"]
[]
["MO 780-1954-xls (12-09)"]