{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Input","1) - 2) EPs & Summary","3) Storage Pile","4) Conveyors","5) Screening","6) Silo Filling","7) Loadout","8) - 9) Dryer","10) - 11) Hot Oil Heater","12) Chapter 20","13) Engines","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":66,"n_cols":4,"rows_kept":66,"cut":false,"hidden":false,"merged":[[35,0,36,5],[7,3,9,5],[31,1,31,5],[32,3,32,5],[32,1,32,2],[27,1,27,5],[28,1,28,5],[29,0,30,0],[29,1,30,5],[33,3,33,5],[33,1,33,2],[34,1,34,5]]}
["Instructions:"]
["Please fill in the cells highlighted in yellow with information related to your specific plant."]
[]
["Fact Sheet Attachment"]
["Operation parameters and limitations"]
[]
["Operation parameter"]
["What's the type of the asphalt plant?",null,null,{"$f":"IF(B8=\"Batch mix plant\",\"Max= 250,000 tons/month (ca. 347 tons/hr)\",IF(B8=\"Drum mix plant\",\"Max= 500,000 tons/month (ca. 694 tons/hr)\",\"\"))","v":""}]
["Hot Mix Asphalt produced per hour",null,"tons/hr"]
["Maximum hours of operation",{"$f":"B11/B9","v":{"$error":"#DIV/0!"}},"hr/yr"]
["Asphalt processed per year",null,"ton/yr",{"$f":"IF(B8=\"Batch mix plant\",\"Max=400,000 ton/yr\",IF(B8=\"Drum mix plant\",\"Max=850,000 ton/yr\",\"\"))","v":""}]
[]
["Storage pile information"]
["Acres occupied by storage piles",null,"acre"]
["Storage pile moisture content",null,"%"]
[]
["Dryer information"]
["Oil applied to the material after the Dryer"]
["Control Device that Operates on the Dryer"]
["Dryer Heat Input Rating",null,"MMBtu/hr"]
["Type of Fuel Used in the Dryer"]
[]
["Oil heater information"]
["Rated capacity of hot oil heater",null,"MMBtu/hr"]
["Type of Fuel Used in the oil heater"]
[]
["Generator Engine information"]
["Will the plant be hooked to the grid?"]
["Is the generator engine portable?"]
["Will the plant stay at the same location more than 12 consecutive months?"]
[]
["Fuel Type *"]
["Engine Rating",null,null,"HP"]
["Engine Heat Input",null,null,{"$f":"IF(A34=\"Fuel use factor\",Sheet2!O1,Sheet2!O2)","v":"MMBtu/hr"}]
["Engine type (only if natural gas)"]
["* If the hot mix asphalt plant will be permitted under the permit-by-rule program and it is considered a stationary engine the only fuel type permitted for use is diesel"]
[]
["Modelling parameters"]
["Dryer Stack"]
["UTM X",null,"m"]
["UTM Y",null,"m"]
["Elevation",null,"m"]
["Stack Height",null,"m"]
["Temperature of Exhaust\n",null,"C"]
["Exit Velocity of Exhaust",null,"m/s"]
["Inside Diameter of Stack",null,"m"]
["Flow Rate of Exhaust",null,"m3 / s"]
[]
["Generator Engine Stack"]
["UTM X",null,"m"]
["UTM Y",null,"m"]
["Elevation",null,"m"]
["Stack Height",null,"m"]
["Temperature of Exhaust\n",null,"C"]
["Exit Velocity of Exhaust",null,"m/s"]
["Inside Diameter of Stack",null,"m"]
["Flow Rate of Exhaust",null,"m3 / s"]
["Oil Heater Stack"]
["UTM X",null,"m"]
["UTM Y",null,"m"]
["Elevation",null,"m"]
["Stack Height",null,"m"]
["Temperature of Exhaust\n",null,"C"]
["Exit Velocity of Exhaust",null,"m/s"]
["Inside Diameter of Stack",null,"m"]
["Flow Rate of Exhaust",null,"m3 / s"]

{"sheet":"1) - 2) EPs & Summary","index":1,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[45,5,45,7],[44,5,44,7],[37,5,37,7],[38,5,38,7],[39,5,39,7],[40,5,40,7],[41,5,41,7],[42,5,42,7],[43,5,43,7]]}
["Fact Sheet Attachment"]
["Hot Mix Asphalt Plant: Potential to Emit Summary"]
[]
["Summary of lb/hr total emissions"]
["Pollutant","Storage Pile","Conveyors","Screening","Silo Filling","Loadout","Dryer","Hot oil Heater","Engine","Total"]
["PM",{"$f":"'3) Storage Pile'!B31","v":0},{"$f":"'4) Conveyors'!B40","v":0},{"$f":"+'5) Screening'!C11","v":0},{"$f":"+'6) Silo Filling'!C9","v":0},{"$f":"+'7) Loadout'!C9","v":0},{"$f":"MAX('8) - 9) Dryer'!C15)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D13)","v":0},{"$f":"'13) Engines'!D19","v":0},{"$f":"SUM(B6:I6)","v":0}]
["PM10",{"$f":"'3) Storage Pile'!B32","v":0},{"$f":"'4) Conveyors'!B41","v":0},{"$f":"+'5) Screening'!C12","v":0},{"$f":"+'6) Silo Filling'!C10","v":0},{"$f":"+'7) Loadout'!C10","v":0},{"$f":"MAX('8) - 9) Dryer'!C16)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D14)","v":0},{"$f":"'13) Engines'!D19","v":0},{"$f":"SUM(B7:I7)","v":0}]
["PM2.5",{"$f":"'3) Storage Pile'!B33","v":0},{"$f":"'4) Conveyors'!B42","v":0},{"$f":"+'5) Screening'!C13","v":0},{"$f":"+'6) Silo Filling'!C11","v":0},{"$f":"+'7) Loadout'!C11","v":0},{"$f":"MAX('8) - 9) Dryer'!C17)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D15)","v":0},{"$f":"'13) Engines'!D19","v":0},0]
["SOx","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!C18)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D16)","v":0},{"$f":"'13) Engines'!D21","v":0},0]
["NOx","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!C19)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D17)","v":0},{"$f":"'13) Engines'!D20","v":0},0]
["CO","-","-","-",{"$f":"+'6) Silo Filling'!C12","v":0},{"$f":"+'7) Loadout'!C12","v":0},{"$f":"MAX('8) - 9) Dryer'!C20)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D20)","v":0},{"$f":"'13) Engines'!D22","v":0},0]
["VOC","-","-","-",{"$f":"+'6) Silo Filling'!C13","v":0},{"$f":"+'7) Loadout'!C13","v":0},{"$f":"MAX('8) - 9) Dryer'!C21)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D18)","v":0},{"$f":"'13) Engines'!D23","v":0},0]
["Pb","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!C22)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D23)","v":0},null,0]
["HAP","-","-","-",{"$f":"+'6) Silo Filling'!C14","v":0},{"$f":"+'7) Loadout'!C14","v":0},{"$f":"MAX('8) - 9) Dryer'!C23)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D21)","v":0},{"$f":"'13) Engines'!D30","v":0},0]
["GHG (mass basis)","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!C28)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D29)","v":0},{"$f":"SUM('13) Engines'!D25:D27)","v":0},0]
["GHG (CO2e basis)","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!C29)","v":0},{"$f":"MAX('10) - 11) Hot Oil Heater'!D30)","v":0},{"$f":"'13) Engines'!D25+25*'13) Engines'!D26+298*'13) Engines'!D27","v":0},0]
[]
["Summary of ton/year total emissions"]
["Pollutant","Storage Pile","Conveyors","Screening","Silo Filling","Loadout","Dryer","Hot oil Heater","Engine","Total*"]
["PM",{"$f":"'3) Storage Pile'!C31","v":0},{"$f":"'4) Conveyors'!C40","v":{"$error":"#DIV/0!"}},{"$f":"+'5) Screening'!D11","v":{"$error":"#DIV/0!"}},{"$f":"+'6) Silo Filling'!D9","v":{"$error":"#DIV/0!"}},{"$f":"+'7) Loadout'!D9","v":{"$error":"#DIV/0!"}},{"$f":"MAX('8) - 9) Dryer'!D15)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E13)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B20:I20)","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"'3) Storage Pile'!C32","v":0},{"$f":"'4) Conveyors'!C41","v":{"$error":"#DIV/0!"}},{"$f":"+'5) Screening'!D12","v":{"$error":"#DIV/0!"}},{"$f":"+'6) Silo Filling'!D10","v":{"$error":"#DIV/0!"}},{"$f":"+'7) Loadout'!D10","v":{"$error":"#DIV/0!"}},{"$f":"MAX('8) - 9) Dryer'!D16)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E14)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B21:I21)","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"'3) Storage Pile'!C33","v":0},{"$f":"'4) Conveyors'!C42","v":{"$error":"#DIV/0!"}},{"$f":"+'5) Screening'!D13","v":{"$error":"#DIV/0!"}},{"$f":"+'6) Silo Filling'!D11","v":{"$error":"#DIV/0!"}},{"$f":"+'7) Loadout'!D11","v":{"$error":"#DIV/0!"}},{"$f":"MAX('8) - 9) Dryer'!D17)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E15)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B22:I22)","v":{"$error":"#DIV/0!"}}]
["SOx","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!D18)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E16)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E21","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B23:I23)","v":{"$error":"#DIV/0!"}}]
["NOx","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!D19)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E17)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E20","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["CO","-","-","-",{"$f":"+'6) Silo Filling'!D12","v":{"$error":"#DIV/0!"}},{"$f":"+'7) Loadout'!D12","v":{"$error":"#DIV/0!"}},{"$f":"MAX('8) - 9) Dryer'!D20)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E20)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["VOC","-","-","-",{"$f":"+'6) Silo Filling'!D13","v":{"$error":"#DIV/0!"}},{"$f":"+'7) Loadout'!D13","v":{"$error":"#DIV/0!"}},{"$f":"MAX('8) - 9) Dryer'!D21)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E18)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Pb","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!D22)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E23)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["HAP","-","-","-",{"$f":"+'6) Silo Filling'!D14","v":{"$error":"#DIV/0!"}},{"$f":"+'7) Loadout'!D14","v":{"$error":"#DIV/0!"}},{"$f":"MAX('8) - 9) Dryer'!D23)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E21)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E30","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["GHG (mass basis)","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!D28)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('13) Engines'!E25:E27)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["GHG (CO2e basis)","-","-","-","-","-",{"$f":"MAX('8) - 9) Dryer'!D29)","v":{"$error":"#DIV/0!"}},{"$f":"MAX('10) - 11) Hot Oil Heater'!E30)","v":{"$error":"#DIV/0!"}},{"$f":"'13) Engines'!E25+25*'13) Engines'!E26+298*'13) Engines'!E27","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["* Color coding"]
[null,null,"Above the limits of PbR program"]
[null,null,"If a regular CP is issued, an operating permit might be required depending on operation"]
[null,null,"Within acceptable limits"]
["Fact Sheet Attachment"]
["Emission Unit Summary"]
[]
["Process type","Emission Point","Control ID #","Control description","Emission Unit ID #","Emission /Process Description"]
["Storage Pile","EP-01","-","-","EU-01","Storage Pile- Wind Erosion, Loading and Unloading"]
["Conveyors","EP-02","-","-","EU-02","Gathering, Rap and Slat Conveyors"]
["Screening","EP-03","-","-","EU-03","Screening Emissions"]
["Silo Filling","EP-04","-","-","EU-04","Storage Silo Filling and Asphalt Storage Tank Emissions"]
["Load-out","EP-05","-","-","EU-05","Load-Out Emissions"]
["Dryer","EP-06","C-01",{"$f":"Input!B19","v":0},"EU-06","Dryer"]
["Hot Oil Heater","EP-07","-","-","EU-07","Hot oil heater emissions"]
["Engine","EP-08","-","-","EU-08","Engine"]
[]
[]
[]
[]
[]
[]
["Operation parameters and limitations"]
[]
[{"$f":"'4) Conveyors'!A4","v":"Hot Mix Asphalt produced per hour (tons/hr) ="},null,null,{"$f":"Input!B9","v":0}]
[{"$f":"'4) Conveyors'!A5","v":"Maximum hours of operation (hr/yr) = "},null,null,{"$f":"Input!B10","v":{"$error":"#DIV/0!"}}]
[{"$f":"'4) Conveyors'!A6","v":"Asphalt processed per year (ton/yr) = "},null,null,{"$f":"Input!B11","v":0}]

{"sheet":"3) Storage Pile","index":2,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,5,4,9],[26,1,26,2],[11,0,11,9],[14,1,14,3],[15,1,15,3],[21,0,21,10],[5,5,5,9]]}
["Fact Sheet Attachment"]
["Storage Pile Emissions: EP-01"]
[]
["Hot Mix Asphalt produced per hour (tons/hr) =",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D55","v":0}]
["Aggregate processed per hour (tons/hr) =",null,null,null,{"$f":"E4*0.95","v":0},"AP-42 Chapter 11.1 states that aggregate and RAP (if used) constitute over 92% by weight of the total mixture.  For these calculations, it is assumed that 95% of the hot mix asphalt produced is aggregate."]
["Maximum occupancy on pile (hr/yr) = ",null,null,null,8760]
["Acres occupied by storage piles (acre) = ",null,null,null,{"$f":"Input!B14","v":0}]
["Storage pile moisture content (%) = ",null,null,null,{"$f":"Input!B15","v":0}]
[]
["Emissions Source","PM Emission Factor (lb/hr/acre) [1]","PM Emission Rate (lb/hr)","PM10 Emission Rate (lb/hr) [2]","PM2.5 Emission Rate (lb/hr) [2]","PM Emission Rate (tpy) [3]","PM10 Emission rate (tpy) [3]","PM2.5 Emission Rate (tpy) [3]"]
["Storage Pile- Wind Erosion",{"$f":"1.7*(E14/1.5)*((365-E15)/235)*(E16/15)*(1/24)","v":0.22398739164696613},{"$f":"B11*E7","v":0},{"$f":"C11*0.5","v":0},{"$f":"C11*0.146","v":0},{"$f":"C11*E6/2000","v":0},{"$f":"D11*E6/2000","v":0},{"$f":"E11*E6/2000","v":0}]
["[1] PM Emission Factor (lb/hr/acre) derived from the following equation taken from the Air Pollution Engineering Manual p.136:                                                                      E = 1.7 * (s/1.5) * ((365-p)/235) * (f/15) * (1/24)"]
["where:","E = Emission Factor (lb/hr/acre)"]
[null,"s = silt content of aggregate",null,null,1.9,"from AP-42 Table 13.2.4-1, the upper range for Crushed Limestone"]
[null,"p = # days with > .25mm of\n      precipitation per year",null,null,90,"from AP-42 Figure 13.2.2-1, For Nebraska"]
[null,"f = % of time that the unobstructed\n      wind speed exceeds 5.4 m/s \n      at the mean pile height",null,null,32,"%, from Metrological Data, NDEQ"]
["[2] PM10 and PM2.5 emission rates are calculated using the scaling factors found in CEIDARS for Mineral Process Loss- Loading and Unloading Bulk Materials"]
["[3] Emission Rate (tpy) = Emission Rate (lb/hr) * Maximum occupancy on pile (hr/yr) * (1 ton/2000 lb)"]
[]
["Emissions Source","PM Emission Factor (lb/ton) [1]","PM10 Emission Factor (lb/ton) [1]","PM2.5 Emission Factor (lb/ton) [1]","PM Emission Rate (lb/hr)","PM10 Emission Rate (lb/hr) ","PM2.5 Emission Rate (lb/hr)","PM Emission Rate (tpy) ","PM10 Emission rate (tpy)","PM2.5 Emission Rate (tpy)"]
["Storage Pile- Loading and Unloading",{"$f":"D26*0.0032*((D24/5)^1.3)/((D25/2)^1.4)","v":4.2662536633067899E-3},{"$f":"D27*0.0032*((D24/5)^1.3)/((D25/2)^1.4)","v":2.0178226785910491E-3},{"$f":"D28*0.0032*((D24/5)^1.3)/((D25/2)^1.4)","v":3.0555600561521604E-4},{"$f":"B21*E5","v":0},{"$f":"C21*E5","v":0},{"$f":"D21*E5","v":0},{"$f":"E21*E6/2000","v":0},{"$f":"F21*E6/2000","v":0},{"$f":"G21*E6/2000","v":0}]
["[1] Emission Factors (lb/ton) derived from the following equation in AP-42 Chapter 13.2.4 (Nov. 2006), Equation 1:                                                                                                                  E = k * (0.0032) * ((U/5)^1.3) / ((M/2)^1.4)"]
["where:","E = Emission Factor (lb/ton)"]
[null,"U = mean wind speed (mph)    =",null,10,"mph in Nebraska"]
[null,"M = material moisture content =",null,2.5,"% given by facility in the form of an input question in this spreadsheet"]
[null,"k   =    particle size multiplier    = ",null,0.74,"for PM30 from AP-42 Section 13.2.4"]
[null,"k   =    particle size multiplier    = ",null,0.35,"for PM10 from AP-42 Section 13.2.4"]
[null,"k   =    particle size multiplier    = ",null,5.2999999999999999E-2,"for PM2.5 from AP-42 Section 13.2.4"]
[]
["Total Storage Pile Pollutant Emissions","Emissions (lb/hr)","Emissions (tpy)"]
["PM",{"$f":"E21+C11","v":0},{"$f":"H21+F11","v":0}]
["PM10",{"$f":"F21+D11","v":0},{"$f":"I21+G11","v":0}]
["PM2.5",{"$f":"G21+E11","v":0},{"$f":"J21+H11","v":0}]

{"sheet":"4) Conveyors","index":3,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[10,0,10,3],[14,0,14,3],[18,0,18,3],[22,0,22,3],[35,1,35,7]]}
["Fact Sheet Attachment"]
["Conveyor Emissions: EP-02"]
[]
["Hot Mix Asphalt produced per hour (tons/hr) =",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D55","v":0}]
["Maximum hours of operation (hr/yr) = ",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D56","v":{"$error":"#DIV/0!"}}]
["Asphalt processed per year (ton/yr) = ",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D57","v":0}]
["Storage pile moisture content (%) = ",null,null,null,{"$f":"'3) Storage Pile'!E8","v":0}]
["Oil applied to the material after the dryer:",null,null,null,{"$f":"IF(Input!B18=\"Yes\",1,0)","v":0}]
[null," (Yes = 1, No = 0)"]
["Pollutant","Emission Factor (lb/ton) [1]","Emission Rate (lb/hr)","Emission Rate (tpy)"]
["Gathering Conveyor"]
["PM",{"$f":"IF(E7>1.3,F30,F29)","v":3.0000000000000001E-3},{"$f":"B12*$E$4","v":0},{"$f":"C12*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"IF(E7>1.3,G30,G29)","v":1.1000000000000001E-3},{"$f":"B13*$E$4","v":0},{"$f":"C13*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"IF(E7>1.3,H30,H29)","v":4.3799999999999997E-4},{"$f":"B14*$E$4","v":0},{"$f":"C14*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["Belt Conveyor"]
["PM",{"$f":"IF(E7>1.3,F30,F29)","v":3.0000000000000001E-3},{"$f":"B16*$E$4","v":0},{"$f":"C16*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"IF(E7>1.3,G30,G29)","v":1.1000000000000001E-3},{"$f":"B17*$E$4","v":0},{"$f":"C17*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"IF(E7>1.3,H30,H29)","v":4.3799999999999997E-4},{"$f":"B18*$E$4","v":0},{"$f":"C18*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["RAP Conveyor"]
["PM",{"$f":"F32","v":3.0000000000000001E-3},{"$f":"B20*$E$4","v":0},{"$f":"C20*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"G32","v":1.1000000000000001E-3},{"$f":"B21*$E$4","v":0},{"$f":"C21*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"H32","v":4.3799999999999997E-4},0,{"$f":"C22*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["Slat Conveyor"]
["PM",{"$f":"IF(E8=1, F34,F35)","v":3.0000000000000001E-3},0,{"$f":"C24*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"IF(E8=1, G34,G35)","v":1.1000000000000001E-3},0,{"$f":"C25*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"IF(E8=1,H34,H35)","v":4.3799999999999997E-4},0,{"$f":"C26*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["[1] Emission Factors are from AP-42 Chapter 11.19 (August. 2004), Table 11.19.2-2, Conveyor Transfer Point:"]
["Gathering and Belt Conveyor Emission Factors",null,null,null,null,"PM (lb/ton)","PM10 (lb/ton)","PM2.5 (lb/ton) *"]
[null,"If storage pile moisture content is < 1.3%, Emission Factor is:",null,null,null,3.0000000000000001E-3,1.1000000000000001E-3,{"$f":"F29*0.146","v":4.3799999999999997E-4}]
[null,"If storage pile moisture content is > 1.3%, Emission Factor is:",null,null,null,1.3999999999999999E-4,4.6E-5,1.2999999999999999E-5]
["RAP Conveyor Emission Factor"]
[null,"Emission Factor is:",null,null,null,3.0000000000000001E-3,1.1000000000000001E-3,{"$f":"F32*0.146","v":4.3799999999999997E-4}]
["Slat Conveyor Emission Factor"]
[null,"If oil is applied after the dryer, a 60% control is assumed and the Emission Factor is:",null,null,null,{"$f":"F35*0.4","v":1.2000000000000001E-3},{"$f":"G35*0.4","v":4.4000000000000007E-4},{"$f":"H35*0.4","v":1.752E-4}]
[null,"If oil is not applied after the dryer, the Emission Factor is:",null,null,null,3.0000000000000001E-3,1.1000000000000001E-3,{"$f":"F35*0.146","v":4.3799999999999997E-4}]
[null,"* Uncontrolled PM2.5 emission factors are derived using the scaling factors found in CEIDARS for Mineral Process Loss- Loading and Unloading Bulk Materials."]
["[2] Emission Rate (tpy) = Emission Rate (lb/hr) * (asphalt processed per year (ton/yr) / asphalt processed per hour (ton/hr)) * (1 ton/2000 lb)"]
[]
["Total Conveyor Pollutant Emissions","Emissions (lb/hr)","Emissions (tpy)"]
["PM",{"$f":"SUM(C12,C16,C20,C24)","v":0},{"$error":"#DIV/0!"}]
["PM10",0,{"$error":"#DIV/0!"}]
["PM2.5",0,{"$error":"#DIV/0!"}]

{"sheet":"5) Screening","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,6],[4,5,4,7]]}
["Fact Sheet Attachment"]
["Screening Emissions: EP-03"]
[]
["Hot Mix Asphalt produced per hour (tons/hr) =",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D55","v":0}]
["Aggregate processed per hour (tons/hr) = ",null,null,null,{"$f":"E4*0.95","v":0},"AP-42 Chapter 11.1 states that aggregate and RAP (if used) constitute over 92% by weight of the total mixture.  For these calculations, it is assumed that 95% of the hot mix asphalt produced is aggregate."]
["Maximum hours of operation (hr/yr) = ",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D56","v":{"$error":"#DIV/0!"}}]
["Asphalt processed per year (ton/yr) = ",null,null,null,{"$f":"E6*E4","v":{"$error":"#DIV/0!"}}]
["Storage pile moisture content (%) = ",null,null,null,{"$f":"'3) Storage Pile'!E8","v":0}]
[]
["Pollutant","Emission Factor (lb/ton) [1]","Emission Rate (lb/hr)","Emission Rate (tpy)"]
["PM",{"$f":"IF($E$8>1.3,E17,E16)","v":2.5000000000000001E-2},{"$f":"B11*$E$5","v":0},{"$f":"C11*($E$7/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"IF($E$8>1.3,F17,F16)","v":8.6999999999999994E-3},{"$f":"B12*$E$5","v":0},{"$f":"C12*($E$7/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"IF($E$8>1.3,G17,G16)","v":3.65E-3},{"$f":"B13*$E$5","v":0},{"$error":"#DIV/0!"}]
["[1] Emission Factors are from AP-42 Chapter 11.19 (August. 2004), Table 11.19.2-2, Screening:"]
[null,null,null,null,"PM (lb/ton)","PM10 (lb/ton)","PM2.5 (lb/ton) *"]
["If storage pile moisture content is < 1.3%, Emission Factor is:",null,null,null,2.5000000000000001E-2,8.6999999999999994E-3,{"$f":"E16*0.146","v":3.65E-3}]
["If storage pile moisture content is > 1.3%, Emission Factor is:",null,null,null,2.2000000000000001E-3,7.3999999999999999E-4,5.0000000000000002E-5]
["* The uncontrolled (moisture content ≤ 1.3%) PM2.5 emission factor is derived using the scaling factor found in CEIDARS for Mineral Process Loss- Loading and Unloading Bulk Materials."]

{"sheet":"6) Silo Filling","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,3],[1,0,1,5]]}
["Fact Sheet Attachment"]
["Storage Silo Filling and Asphalt Storage Tank Emissions: EP-04"]
[]
["Hot Mix Asphalt produced per hour (tons/hr) =",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D55","v":0}]
["Maximum hours of operation (hr/yr) = ",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D56","v":{"$error":"#DIV/0!"}}]
["Asphalt processed per year (ton/yr) = ",null,null,null,{"$f":"E4*E5","v":{"$error":"#DIV/0!"}}]
[]
["Pollutant","Emission Factor (lb/ton) [1]","Emission Rate (lb/hr)","Emission Rate (tpy)"]
["PM",{"$f":"0.000332+(0.00105)*(0.5)*(EXP(0.0251*(325+460)-20.43))","v":5.8588927901473853E-4},{"$f":"B9*$E$4","v":0},{"$f":"C9*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"0.000332+(0.00105)*(0.5)*(EXP(0.0251*(325+460)-20.43))","v":5.8588927901473853E-4},{"$f":"B10*$E$4","v":0},{"$f":"C10*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"0.000332+(0.00105)*(0.5)*(EXP(0.0251*(325+460)-20.43))","v":5.8588927901473853E-4},0,{"$error":"#DIV/0!"}]
["CO",{"$f":"0.00488*(0.5)*(EXP(0.0251*(325+460)-20.43))","v":1.1799806491351657E-3},{"$f":"B12*$E$4","v":0},{"$error":"#DIV/0!"}]
["VOC",{"$f":"0.0504*0.5*(EXP(0.0251*(325+460)-20.43))","v":1.2186685392707451E-2},{"$f":"B13*$E$4","v":0},{"$error":"#DIV/0!"}]
["HAP",{"$f":"((0.00105*0.5*(EXP(0.0251*(325+460)-20.43)))*0.114)+((0.0504*0.5*(EXP(0.0251*(325+460)-20.43)))*0.013)","v":1.8737028791287704E-4},{"$f":"B14*$E$4","v":0},{"$error":"#DIV/0!"}]
["[1] Emission factors for PM, PM10, PM2.5, CO, and VOC derived from the equations in AP-42 Chapter 11.1 (Apr. 2004), Table 11.1-14 for Silo Filling, using the default values as discussed in footnote \"a\" of the table. The emission factor for HAP was derived from Tables 11.1-15  and 11.1-16 for Speciation Profile for Silo Filling and Asphalt Storage Tanks Emissions."]

{"sheet":"7) Loadout","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,3],[15,0,15,3]]}
["Fact Sheet Attachment"]
["Loadout Emissions: EP-05"]
[]
["Hot Mix Asphalt produced per hour (tons/hr) =",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D55","v":0}]
["Maximum hours of operation (hr/yr) = ",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D56","v":{"$error":"#DIV/0!"}}]
["Asphalt processed per year (ton/yr) = ",null,null,null,{"$f":"E5*E4","v":{"$error":"#DIV/0!"}}]
[]
["Pollutant","Emission Factor (lb/ton) [1]","Emission Rate (lb/hr)","Emission Rate (tpy)"]
["PM",{"$f":"0.000181+(0.00141)*(0.5)*(EXP(((0.0251)*(325+460)-20.43)))","v":5.2193703181979169E-4},{"$f":"B9*$E$4","v":0},{"$f":"C9*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"0.000181+(0.00141)*(0.5)*(EXP(((0.0251)*(325+460)-20.43)))","v":5.2193703181979169E-4},{"$f":"B10*$E$4","v":0},{"$f":"C10*($E$6/$E$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"0.000181+(0.00141)*(0.5)*(EXP(((0.0251)*(325+460)-20.43)))","v":5.2193703181979169E-4},0,{"$error":"#DIV/0!"}]
["CO [2]",{"$f":"(0.00558*(0.5)*(EXP(((0.0251*(325+460)-20.43)))))+(0.0011*0.32)","v":1.701240168478325E-3},{"$f":"B12*$E$4","v":0},{"$error":"#DIV/0!"}]
["VOC [2]",{"$f":"(0.0172*0.5*(EXP(((0.0251*(325+460)-20.43)))))+0.0011","v":5.258948189574765E-3},{"$f":"B13*$E$4","v":0},{"$error":"#DIV/0!"}]
["HAP",{"$f":"((0.00141*0.5*(EXP(0.0251*(325+460)-20.43)))*(0.0593+0.0118))+((0.0172*0.5*(EXP(0.0251*(325+460)-20.43)))*0.015)","v":8.6624845806008649E-5},{"$f":"B14*$E$4","v":0},{"$error":"#DIV/0!"}]
["[1] Emission factors derived from the equations in AP-42 Chapter 11.1 (Apr. 2004), Table 11.1-14 for Drum-mix or batch plant load-out, using the default values as discussed in footnote \"a\" of the table. The emission factor for HAP was derived from Tables 11.1-15 and Table 11.1-16; this includes HAP emissions from loadout and those that occur after the trucks are loaded (referred to as yard emissions)."]
["[2] In addition to loadout, emissions of CO and TOC occur after the trucks are loaded (referred to as yard emissions). The emission factors for yard emissions as found in AP-42 Chapter 11.1, page 11.1-9 are accounted for in the CO and VOC emission factors above.  (0.0011 lb/ton for TOC and (0.0011 * 0.32) lb/ton for CO.)"]

{"sheet":"8) - 9) Dryer","index":7,"n_rows":80,"n_cols":8,"rows_kept":80,"cut":false,"hidden":false,"merged":[[73,0,73,1],[74,0,74,1],[75,0,75,1],[23,0,23,3],[51,0,51,1],[52,0,52,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[42,0,42,1],[41,0,41,1],[43,0,43,1],[50,0,50,1],[35,0,36,6]]}
["Fact Sheet Attachment"]
["Dryer Emissions: EP-06"]
[]
["Hot Mix Asphalt produced per hour (tons/hr) =",null,null,null,null,{"$f":"'1) - 2) EPs & Summary'!$D$55","v":0}]
["Maximum hours of operation (hr/yr) = ",null,null,null,null,{"$f":"'1) - 2) EPs & Summary'!$D$56","v":{"$error":"#DIV/0!"}}]
["Asphalt processed per year (ton/yr) = ",null,null,null,null,{"$f":"F4*F5","v":{"$error":"#DIV/0!"}}]
["Storage pile moisture content (%) = ",null,null,null,null,{"$f":"'3) Storage Pile'!$E$8","v":0}]
["Control Device that Operates on the Dryer: ",null,null,null,null,{"$f":"IF(Input!$B$19=\"Baghouse\",1,IF(Input!$B$19=\"Wet Scrubber\",2,3))","v":3}]
[null," (Baghouse=1, Wet Scrubber=2, No Control=3)"]
["Dryer Heat Input Rating (MMBtu/hr) = ",null,null,null,null,{"$f":"Input!$B$20","v":0}]
["Type of Fuel Used in the Dryer",null,null,null,null,{"$f":"IF(Input!$B$21=\"Natural Gas\",1,IF(Input!$B$21=\"No. 2 Fuel Oil (diesel)\",2,IF(Input!$B$21=\"Waste Oil\",3,IF(Input!$B$21=\"Coal\",4,IF(Input!$B$21=\"No. 5 Fuel Oil\",5,IF(Input!$B$21=\"No. 6 Fuel Oil\",6,IF(Input!$B$21=\"Propane\",7,8)))))))","v":8}]
["(Natural Gas = 1, No. 2 Fuel Oil (diesel) = 2, Waste Oil = 3, Coal = 4, No. 5 Fuel Oil = 5, No. 6 Fuel Oil = 6, Propane = 7, Other = 8)"]
[]
["Pollutant","Emission Factor","Emission Rate (lb/hr)","Emission Rate (tpy)"]
["PM",{"$f":"IF(F8=1,D34,IF(F8=2,D33,D32))","v":28},{"$f":"B15*$F$4","v":0},{"$f":"C15*($F$6/$F$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"IF(F8=1,E34,IF(F8=2,E33,E32))","v":6.5},{"$f":"B16*$F$4","v":0},{"$f":"C16*($F$6/$F$4)/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"IF(F8=1,F34,IF(F8=2,F33,F32))","v":1.5653999999999999},0,{"$error":"#DIV/0!"}]
["SOx",{"$f":"IF(F11=1,C40,IF(F11=2,C41,IF(F11=3,C42,IF(F11=4,C43,IF(F11=5,C44,IF(F11=6,C45,IF(F11=7,C46)))))))","v":false},0,{"$error":"#DIV/0!"}]
["NOx",{"$f":"IF(F11=1,D40,IF(F11=2,D41,IF(F11=3,D42,IF(F11=4,D43,IF(F11=5,D44,IF(F11=6,D45,IF(F11=7,D46)))))))","v":false},0,{"$f":"C19*($F$6/$F$4)/2000","v":{"$error":"#DIV/0!"}}]
["CO",{"$f":"IF(F11=1,E40,IF(F11=2,E41,IF(F11=3,E42,IF(F11=4,E43,IF(F11=5,E44,IF(F11=6,E45,IF(F11=7,E46)))))))","v":false},0,{"$f":"C20*($F$6/$F$4)/2000","v":{"$error":"#DIV/0!"}}]
["VOC",{"$f":"IF(F11=1,F40,IF(F11=2,F41,IF(F11=3,F42,IF(F11=4,F43,IF(F11=5,F44,IF(F11=6,F45,IF(F11=7,F46)))))))","v":false},0,{"$error":"#DIV/0!"}]
["Pb",{"$f":"IF(F11=1,G40,IF(F11=2,G41,IF(F11=3,G42,IF(F11=4,G43,IF(F11=5,G44,IF(F11=6,G45,IF(F11=7,G46)))))))","v":false},0,{"$error":"#DIV/0!"}]
["HAP",{"$f":"IF(F11=1,H40,IF(F11=2,H41,IF(F11=3,H42,IF(F11=4,H43,IF(F11=5,H44,IF(F11=6,H45,IF(F11=7,H46)))))))","v":false},{"$f":"B23*$F$4","v":0},{"$error":"#DIV/0!"}]
["Green House Gases"]
["CO2",{"$f":"IF(F11=1,C49,IF(F11=2,C50,IF(F11=3,C51,IF(F11=4,C52,IF(F11=5,C53,IF(F11=6,C54,IF(F11=7,C55)))))))","v":false},{"$f":"B25*$F$10*2.20462","v":0},{"$error":"#DIV/0!"}]
["CH4",{"$f":"IF(F11=1,D49,IF(F11=2,D50,IF(F11=3,D51,IF(F11=4,D52,IF(F11=5,D53,IF(F11=6,D54,IF(F11=7,D55)))))))","v":false},{"$f":"B26*$F$10*2.20462","v":0},{"$error":"#DIV/0!"}]
["N2O",{"$f":"IF(F11=1,E49,IF(F11=2,E50,IF(F11=3,E51,IF(F11=4,E52,IF(F11=5,E53,IF(F11=6,E54,IF(F11=7,E55)))))))","v":false},0,{"$error":"#DIV/0!"}]
["GHG (mass basis)","-",{"$f":"SUM(C25:C27)","v":0},{"$f":"SUM(D25:D27)","v":{"$error":"#DIV/0!"}}]
["GHG (CO2e basis)","-",{"$f":"C25+C26*25+C27*298","v":0},{"$f":"C29*($F$6/$F$4)/2000","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"PM (lb/ton)","PM10 (lb/ton)*","PM2.5 (lb/ton) **"]
["If the dryer is uncontrolled, the emission factor is:",null,null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",32,28)","v":28},{"$f":"IF(Input!$B$8=\"Batch mix plant\",4.5,6.5)","v":6.5},{"$f":"IF(Input!$B$8=\"Batch mix plant\",0.2871,1.5654)","v":1.5653999999999999}]
["If the dryer is controlled by a venturi or wet scrubber, the emission factor is:",null,null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",0.14,0.045)","v":4.4999999999999998E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",0.14,0.045)","v":4.4999999999999998E-2},{"$f":"E33*0.146","v":6.5699999999999995E-3}]
["If the dryer is controlled by a fabric filter, the emission factor is:",null,null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",0.042,0.033)","v":3.3000000000000002E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",0.027,0.023)","v":2.3E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",0.0254,0.0223)","v":2.23E-2}]
["* All PM data are derived from AP-42 tables 11.1-1 through 4. PM10 assumed to equal total PM if no data are available for PM10 emissions"]
["** The wet scrubber PM2.5 emission factor is derived using the scaling factor found in CEIDARS for Mineral Process Loss- Loading and Unloading Bulk Materials. Both other values are derived from AP42 Table 11-1-2 + Inorganic and Organic condensable PM from Table 11-1-1"]
[]
[]
[null,null,"SOx (lb/ton)","NOx (lb/ton)","CO (lb/ton)","VOC (lb/ton)","Pb (lb/ton)","HAP (lb/ton)"]
["If the dryer combusts natural gas, the emission factor is:",null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",C63,C72)","v":3.3999999999999998E-3},{"$f":"IF(Input!$B$8=\"Batch mix plant\",D63,D72)","v":2.5999999999999999E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",E63,E72)","v":0.13},{"$f":"IF(Input!$B$8=\"Batch mix plant\",F63,F72)","v":3.2000000000000001E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",G63,G72)","v":5.4000000000000001E-4},{"$f":"IF(Input!$B$8=\"Batch mix plant\",H63,H72)","v":5.4770000000000001E-3}]
["If the dryer combusts No. 2 fuel oil (diesel), the emission factor is:",null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",C64,C73)","v":1.0999999999999999E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",D64,D73)","v":5.5E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",E64,E73)","v":0.13},{"$f":"IF(Input!$B$8=\"Batch mix plant\",F64,F73)","v":3.2000000000000001E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",G64,G73)","v":5.4000000000000001E-4},{"$f":"IF(Input!$B$8=\"Batch mix plant\",H64,H73)","v":8.8769999999999995E-3}]
["If the dyer combusts waste oil, the emission factor is:",null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",C65,C74)","v":5.8000000000000003E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",D65,D74)","v":5.5E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",E65,E74)","v":0.13},{"$f":"IF(Input!$B$8=\"Batch mix plant\",F65,F74)","v":3.2000000000000001E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",G65,G74)","v":5.4000000000000001E-4},{"$f":"IF(Input!$B$8=\"Batch mix plant\",H65,H74)","v":1.0177E-2}]
["If the dryer combusts coal, the emission factor is:",null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",C66,C75)","v":0.19},{"$f":"IF(Input!$B$8=\"Batch mix plant\",D66,D75)","v":0.19},{"$f":"IF(Input!$B$8=\"Batch mix plant\",E66,E75)","v":275},{"$f":"IF(Input!$B$8=\"Batch mix plant\",F66,F75)","v":0},{"$f":"IF(Input!$B$8=\"Batch mix plant\",G66,G75)","v":5.4000000000000001E-4},{"$f":"IF(Input!$B$8=\"Batch mix plant\",H66,H75)","v":0}]
["If the dryer combusts No. 5 fuel oil, the emission factor is:",null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",C67,C76)","v":4.2627399999999996E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",D67,D76)","v":2.8819999999999998E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",E67,E76)","v":2.6199999999999999E-3},{"$f":"IF(Input!$B$8=\"Batch mix plant\",F67,F76)","v":3.9824000000000001E-4},{"$f":"IF(Input!$B$8=\"Batch mix plant\",G67,G76)","v":5.4000000000000001E-4},{"$f":"IF(Input!$B$8=\"Batch mix plant\",H67,H76)","v":1.7699999999999999E-4}]
["If the dryer combusts No. 6 fuel oil, the emission factor is:",null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",C68,C77)","v":4.2627399999999996E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",D68,D77)","v":2.8819999999999998E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",E68,E77)","v":2.6199999999999999E-3},{"$f":"IF(Input!$B$8=\"Batch mix plant\",F68,F77)","v":3.5999999999999997E-2},{"$f":"IF(Input!$B$8=\"Batch mix plant\",G68,G77)","v":5.4000000000000001E-4},{"$f":"IF(Input!$B$8=\"Batch mix plant\",H68,H77)","v":1.7699999999999999E-4}]
["If the dryer combusts propane fuel, the emission factor is:",null,{"$f":"IF(Input!$B$8=\"Batch mix plant\",C69,C78)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Input!$B$8=\"Batch mix plant\",D69,D78)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Input!$B$8=\"Batch mix plant\",E69,E78)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Input!$B$8=\"Batch mix plant\",F69,F78)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Input!$B$8=\"Batch mix plant\",G69,G78)","v":5.4000000000000001E-4},{"$f":"IF(Input!$B$8=\"Batch mix plant\",H69,H78)","v":5.4770000000000001E-3}]
[]
[null,null,"CO2 (Kg/MMBtu)","CH4 (Kg/MMBtu)","N2O  (Kg/MMBtu)"]
["If the dryer combusts natural gas, the emission factor is:",null,53.06,1E-3,1E-4]
["If the dryer combusts No. 2 fuel oil (diesel), the emission factor is:",null,73.959999999999994,3.0000000000000001E-3,5.9999999999999995E-4]
["If the dyer combusts waste oil, the emission factor is:",null,74,3.0000000000000001E-3,5.9999999999999995E-4]
["If the dryer combusts coal, the emission factor is:",null,113.67,{"$f":"0.011","v":1.0999999999999999E-2},{"$f":"0.0016","v":1.6000000000000001E-3}]
["If the dryer combusts No. 5 fuel oil, the emission factor is:",null,72.930000000000007,3.0000000000000001E-3,5.9999999999999995E-4]
["If the dryer combusts No. 6 fuel oil, the emission factor is:",null,75.099999999999994,3.0000000000000001E-3,5.9999999999999995E-4]
["If the dryer combusts propane fuel, the emission factor is:",null,62.87,3.0000000000000001E-3,5.9999999999999995E-4]
[]
[]
[]
[]
[]
[]
["batch",null,"SOx (lb/ton)","NOx (lb/ton)","CO (lb/ton)","VOC (lb/ton)","Pb (lb/ton)","HAP (lb/ton)"]
["If the dryer combusts natural gas, the emission factor is:",null,4.5999999999999999E-3,2.5000000000000001E-2,0.4,8.2000000000000007E-3,8.8999999999999995E-7,{"$f":"0.0000246+0.00779","v":7.8145999999999997E-3}]
["If the dryer combusts No. 2 fuel oil (diesel), the emission factor is:",null,8.7999999999999995E-2,0.12,0.4,8.2000000000000007E-3,8.8999999999999995E-7,{"$f":"0.0000246+0.00779","v":7.8145999999999997E-3}]
["If the dyer combusts waste oil, the emission factor is:",null,8.7999999999999995E-2,0.12,0.4,5.2400000000000005E-4,1.0000000000000001E-5,{"$f":"0.0000246+0.00789","v":7.9145999999999991E-3}]
["If the dryer combusts coal, the emission factor is:",null,4.2999999999999997E-2,0.19,275]
["If the dryer combusts No. 5 fuel oil, the emission factor is:",null,4.2627399999999996E-2,2.8819999999999998E-2,2.6199999999999999E-3,3.9824000000000001E-4,1.0000000000000001E-5,{"$f":"0.0000246+0.00789","v":7.9145999999999991E-3}]
["If the dryer combusts No. 6 fuel oil, the emission factor is:",null,4.2627399999999996E-2,2.8819999999999998E-2,2.6199999999999999E-3,3.5999999999999997E-2,1.0000000000000001E-5,7.9145999999999991E-3]
["If the dryer combusts propane fuel, the emission factor is:",null,{"$f":"1.5/91.5*$F$10/$F$4","v":{"$error":"#DIV/0!"}},{"$f":"13/91.5*$F$10/$F$4","v":{"$error":"#DIV/0!"}},{"$f":"7.5/91.5*$F$10/$F$4","v":{"$error":"#DIV/0!"}},{"$f":"1/91.5*$F$10/$F$4","v":{"$error":"#DIV/0!"}},8.8999999999999995E-7,{"$f":"0.0000246+0.00779","v":7.8145999999999997E-3}]
[]
["drum",null,"SOx (lb/ton)","NOx (lb/ton)","CO (lb/ton)","VOC (lb/ton)","Pb (lb/ton)","HAP (lb/ton)"]
["If the dryer combusts natural gas, the emission factor is:",null,3.3999999999999998E-3,2.5999999999999999E-2,0.13,3.2000000000000001E-2,5.4000000000000001E-4,{"$f":"0.0053+0.000177","v":5.4770000000000001E-3}]
["If the dryer combusts No. 2 fuel oil (diesel), the emission factor is:",null,1.0999999999999999E-2,5.5E-2,0.13,3.2000000000000001E-2,5.4000000000000001E-4,{"$f":"0.0087+0.000177","v":8.8769999999999995E-3}]
["If the dyer combusts waste oil, the emission factor is:",null,5.8000000000000003E-2,5.5E-2,0.13,3.2000000000000001E-2,5.4000000000000001E-4,{"$f":"0.01+0.000177","v":1.0177E-2}]
["If the dryer combusts coal, the emission factor is:",null,0.19,0.19,275,null,5.4000000000000001E-4]
["If the dryer combusts No. 5 fuel oil, the emission factor is:",null,4.2627399999999996E-2,2.8819999999999998E-2,2.6199999999999999E-3,3.9824000000000001E-4,5.4000000000000001E-4,{"$f":"0.000177","v":1.7699999999999999E-4}]
["If the dryer combusts No. 6 fuel oil, the emission factor is:",null,4.2627399999999996E-2,2.8819999999999998E-2,2.6199999999999999E-3,3.5999999999999997E-2,5.4000000000000001E-4,{"$f":"0.000177","v":1.7699999999999999E-4}]
["If the dryer combusts propane fuel, the emission factor is:",null,{"$f":"1.5/91.5*$F$10/$F$4","v":{"$error":"#DIV/0!"}},{"$f":"13/91.5*$F$10/$F$4","v":{"$error":"#DIV/0!"}},{"$f":"7.5/91.5*$F$10/$F$4","v":{"$error":"#DIV/0!"}},{"$f":"1/91.5*$F$10/$F$4","v":{"$error":"#DIV/0!"}},5.4000000000000001E-4,{"$f":"0.0053+0.000177","v":5.4770000000000001E-3}]
[]
["All emission factors are from AP-42 Ch. 11.1 except Propane from AP-42 Ch. 1.5"]

{"sheet":"10) - 11) Hot Oil Heater","index":8,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[23,0,23,4],[26,2,27,2],[30,0,30,4],[31,0,31,4]]}
["Fact Sheet Attachment"]
["Hot Oil Heater Emissions EP-07"]
[]
["Hot Mix Asphalt produced per hour (tons/hr) =",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D55","v":0}]
["Maximum hours of hot oil heater operation per year (hr/yr) = ",null,null,null,{"$f":"'1) - 2) EPs & Summary'!D56","v":{"$error":"#DIV/0!"}}]
["Rated capacity of hot oil heater (MMBtu/hr) =",null,null,null,{"$f":"Input!B24","v":0}]
["Maximum Fuel Rate (gal/hr) [MMBtu/hr / 0.153 gal/MMBtu] = ",null,null,null,{"$f":"E6/0.153","v":0}]
["Maximum Fuel Rate (106 scf/hr) [MMBtu/hr / 1100 106 scf/MMBtu] = ",null,null,null,{"$f":"E6/1100","v":0}]
["Type of Fuel Used in the hot oil heater",null,null,null,{"$f":"IF(Input!B25=\"Natural Gas\",1,IF(Input!B25=\"No. 2 Fuel Oil (diesel)\",2,3))","v":3}]
["(Natural Gas = 1, No. 2 Fuel Oil (diesel) = 2, Other = 3)"]
[]
["Pollutant",{"$f":"IF($E$9=1,\"Emission Factor (lb/106 scf)\",IF($E$9=2,\"Emission Factor (lb/103 gal)\"))","v":false},"Emission Factor Source [1]","Emission Rate (lb/hr)","Emission Rate (tpy) [3]"]
["PM",{"$f":"IF($E$9=1,1.9,IF($E$9=2,2))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-2\",IF($E$9=2,\"Table 1.3-1\"))","v":false},{"$f":"IF($E$9=1,B13*$E$8,IF($E$9=2,B13*$E$7/1000))","v":false},{"$f":"D13*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["PM10",{"$f":"IF($E$9=1,7.6,IF($E$9=2,3.3))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-2\",IF($E$9=2,\"Tables 1.3-1 and 1.3-2\"))","v":false},false,{"$f":"D14*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["PM2.5",{"$f":"IF($E$9=1,7.6,IF($E$9=2,3.3))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-2\",IF($E$9=2,\"Tables 1.3-1 and 1.3-2\"))","v":false},false,{"$error":"#DIV/0!"}]
["SOx",{"$f":"IF($E$9=1,0.6,IF($E$9=2,144))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-2\",IF($E$9=2,\"Table 1.3-1\"))","v":false},false,{"$error":"#DIV/0!"}]
["NOx",{"$f":"IF($E$9=1,100,IF($E$9=2,20))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-1\",IF($E$9=2,\"Table 1.3-1\"))","v":false},false,{"$error":"#DIV/0!"}]
["VOC",{"$f":"IF($E$9=1,5.5,IF($E$9=2,0.34))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-2\",IF($E$9=2,\"Table 1.3-3\"))","v":false},false,{"$error":"#DIV/0!"}]
[null,{"$f":"IF($E$9=1,\"Emission Factor (lb/106 scf)\",IF($E$9=2,\"Emission Factor (lb/gal)\"))","v":false}]
["CO",{"$f":"IF($E$9=1,84,IF($E$9=2,0.0012))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-1\",IF($E$9=2,\"Table 11.1-13\"))","v":false},{"$f":"IF($E$9=1,B20*$E$8,IF($E$9=2,B20*$E$7))","v":false},{"$f":"D20*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["HAP",{"$f":"IF($E$9=1,1.88,IF($E$9=2,0.000023))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-3\",IF($E$9=2,\"Table 11.1-13\"))","v":false},false,{"$f":"D21*$E$5/2000","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF($E$9=1,\"Emission Factor (lb/106 scf)\",IF($E$9=2,\"Emission Factor (lb/10 12 Btu)\"))","v":false}]
["Pb",{"$f":"IF($E$9=1,0.0005,IF($E$9=2,9))","v":false},{"$f":"IF($E$9=1,\"Table 1.4-2\",IF($E$9=2,\"Table 1.3-10\"))","v":false},{"$f":"IF($E$9=1,B23*$E$8,IF($E$9=2,B23*$E$6/1000000))","v":false},{"$f":"D23*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["Greenhouse Gases"]
[null,"Emission Factor (kg/MMBtu)","Emission Factor Source [2]","Emission Rate (lb/hr)","Emission Rate (tpy) [3]"]
["CO2",{"$f":"IF($E$9=1,53.06,IF($E$9=2,73.96))","v":false},"40 CFR 98, Subpart C, Tables 1",{"$f":"B26*$E$6*2.20462","v":0},{"$f":"D26*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["CH4",{"$f":"IF($E$9=1,0.001,IF($E$9=2,0.003))","v":false},"40 CFR 98, Subpart C, Tables 2",{"$f":"B27*$E$6*2.20462","v":0},{"$f":"D27*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["N2O",{"$f":"IF($E$9=1,0.0001,IF($E$9=2,0.0006))","v":false},null,{"$f":"B28*$E$6*2.20462","v":0},{"$f":"D28*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["GHG (mass basis)",{"$f":"B26+B27+B28","v":0},null,{"$f":"B29*E6*2.20462","v":0},{"$f":"D29*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["GHG (CO2e)",{"$f":"B26+B27*25*B28*298","v":0},null,{"$f":"B30*E6*2.20462","v":0},{"$f":"D30*$E$5/2000","v":{"$error":"#DIV/0!"}}]
["[1] Emission Factors are from AP-42, Chapter 1.3 and 1.4 (May 2010) for Boilers < 100 MMBtu/hr and Chapter 11.1 (Apr. 2004), for No. 2 fuel oil and natural gas.  The emission factors that require a sulfur content input are calculated using 1%, which is the maximum sulfur content of fuel allowed by Chapter 42, Section 011.06B."]
["[2] Emission Factors for GHGs are summations of the CO2, CH4, and N2O emission factors for Distillate Fuel Oil No. 2  from 40 CFR Part 98."]
["[3] Emission Rate (tpy) = Emission Rate (lb/hr) * Maximum hours of hot oil heater operation per year (hr/yr) * (1 ton/2000 lb)"]

{"sheet":"12) Chapter 20","index":9,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,2,31,3],[13,1,13,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[14,0,15,6],[4,0,5,0],[4,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[30,2,30,3],[29,2,29,3],[16,0,17,6],[20,0,21,2],[20,3,21,6],[22,0,22,2],[22,3,22,6],[23,0,24,2],[23,3,23,6],[24,3,24,6],[25,0,25,2],[25,3,25,6],[27,0,28,0],[27,1,28,1],[27,2,28,3]]}
["Fact Sheet Attachment"]
["Ch. 20 Emission Limitations"]
[]
["Title 129, Chapter 20, Section 001"]
["Emission Point ID","Description",null,null,"Design Throughput","CH. 20 Limit     ","Max. Emissions"]
[null,null,null,null,"tph","lb/hr","lb/hr"]
[{"$f":"'1) - 2) EPs & Summary'!B39","v":"EP-01"},{"$f":"'1) - 2) EPs & Summary'!F39","v":"Storage Pile- Wind Erosion, Loading and Unloading"},null,null,{"$f":"'3) Storage Pile'!$E$4","v":0},{"$f":"IF(E7<30,4.1*E7^0.67,55*(E7^0.11)-40)","v":0},{"$f":"'1) - 2) EPs & Summary'!B6","v":0}]
[{"$f":"'1) - 2) EPs & Summary'!B40","v":"EP-02"},{"$f":"'1) - 2) EPs & Summary'!F40","v":"Gathering, Rap and Slat Conveyors"},null,null,{"$f":"'3) Storage Pile'!$E$4","v":0},{"$f":"IF(E8<30,4.1*E8^0.67,55*(E8^0.11)-40)","v":0},{"$f":"'1) - 2) EPs & Summary'!C6","v":0}]
[{"$f":"'1) - 2) EPs & Summary'!B41","v":"EP-03"},{"$f":"'1) - 2) EPs & Summary'!F41","v":"Screening Emissions"},null,null,{"$f":"'3) Storage Pile'!$E$4","v":0},0,{"$f":"'1) - 2) EPs & Summary'!D6","v":0}]
[{"$f":"'1) - 2) EPs & Summary'!B42","v":"EP-04"},{"$f":"'1) - 2) EPs & Summary'!F42","v":"Storage Silo Filling and Asphalt Storage Tank Emissions"},null,null,{"$f":"'3) Storage Pile'!$E$4","v":0},{"$f":"IF(E10<30,4.1*E10^0.67,55*(E10^0.11)-40)","v":0},{"$f":"'1) - 2) EPs & Summary'!E6","v":0}]
[{"$f":"'1) - 2) EPs & Summary'!B43","v":"EP-05"},{"$f":"'1) - 2) EPs & Summary'!F43","v":"Load-Out Emissions"},null,null,{"$f":"'3) Storage Pile'!$E$4","v":0},0,{"$f":"'1) - 2) EPs & Summary'!F6","v":0}]
[{"$f":"'1) - 2) EPs & Summary'!B44","v":"EP-06"},{"$f":"'1) - 2) EPs & Summary'!F44","v":"Dryer"},null,null,{"$f":"'3) Storage Pile'!$E$4","v":0},{"$f":"IF(E12<30,4.1*E12^0.67,55*(E12^0.11)-40)","v":0},{"$f":"'1) - 2) EPs & Summary'!G6","v":0}]
[{"$f":"'1) - 2) EPs & Summary'!B45","v":"EP-07"},{"$f":"'1) - 2) EPs & Summary'!F45","v":"Hot oil heater emissions"},null,null,{"$f":"'3) Storage Pile'!$E$4","v":0},{"$f":"IF(E13<30,4.1*E13^0.67,55*(E13^0.11)-40)","v":0},{"$f":"'1) - 2) EPs & Summary'!H6","v":0}]
[{"$f":"'1) - 2) EPs & Summary'!B46","v":"EP-08"},{"$f":"'1) - 2) EPs & Summary'!F46","v":"Engine"},null,null,{"$f":"'3) Storage Pile'!$E$4","v":0},{"$f":"IF(E14<30,4.1*E14^0.67,55*(E14^0.11)-40)","v":0},{"$f":"'1) - 2) EPs & Summary'!I6","v":0}]
["a Where applicable, design throughput is estimated based on the lowest throughput rate. This ensures the most conservative limit for each emission point category."]
[]
["b Permitted emission are calculated to be the total lb/hr emissions expected for all emission points in every category."]
[]
[]
["Title 129, Chapter 20, Section 002"]
["Total Heat Input (MMBtu/hr) ",null,null,"Maximum Allowable Emissions of PM  (lbs/MMBtu)"]
[]
["10 or less",null,null,0.6]
["Between 10 and 10,000",null,null,"1.026/I0.233"]
[null,null,null,"Where I = total heat input in MMBtu/hr."]
["10,000 or more",null,null,0.12]
[]
["Emission Point","Emission Unit","Description",null,"Rating","Allowable PM","Max. Emissions"]
[null,null,null,null,"MMBtu/hr","lb/MMBtu","lb/MMBtu"]
[{"$f":"'1) - 2) EPs & Summary'!B44","v":"EP-06"},{"$f":"'1) - 2) EPs & Summary'!E44","v":"EU-06"},{"$f":"'1) - 2) EPs & Summary'!A44","v":"Dryer"},{"$f":"'1) - 2) EPs & Summary'!E44","v":"EU-06"},{"$f":"'8) - 9) Dryer'!F10","v":0},{"$f":"IF(E30<=10,0.6,IF(E30<=10000,1.026/(E30^0.233),0.12))","v":0.6},{"$f":"'8) - 9) Dryer'!C15/'8) - 9) Dryer'!F10","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1) - 2) EPs & Summary'!B45","v":"EP-07"},{"$f":"'1) - 2) EPs & Summary'!E45","v":"EU-07"},{"$f":"'1) - 2) EPs & Summary'!A45","v":"Hot Oil Heater"},{"$f":"'1) - 2) EPs & Summary'!E45","v":"EU-07"},{"$f":"'10) - 11) Hot Oil Heater'!E6","v":0},{"$f":"IF(E31<=10,0.6,IF(E31<=10000,1.026/(E31^0.233),0.12))","v":0.6},{"$f":"'10) - 11) Hot Oil Heater'!B13*'10) - 11) Hot Oil Heater'!E7/1000/'10) - 11) Hot Oil Heater'!E6","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1) - 2) EPs & Summary'!B46","v":"EP-08"},{"$f":"'1) - 2) EPs & Summary'!E46","v":"EU-08"},{"$f":"'1) - 2) EPs & Summary'!A46","v":"Engine"},{"$f":"'1) - 2) EPs & Summary'!E46","v":"EU-08"},{"$f":"'13) Engines'!G7","v":0},{"$f":"IF(E32<=10,0.6,IF(E32<=10000,1.026/(E32^0.233),0.12))","v":0.6},{"$f":"'13) Engines'!D19/'13) Engines'!G6","v":{"$error":"#DIV/0!"}}]

{"sheet":"13) Engines","index":10,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,15,4]]}
["Fact Sheet Attachment"]
["Engine EP-08",null,null,null,null,null,null,null,null,null,"Criteria Pollutants","2-Stroke Lean Burn Engine","4-Stroke Lean Burn Engine"," 4-Stroke Rich Burn Engine","Gasoline","Diesel"]
[null,null,null,null,null,null,null,null,null,null,"PM/PM10/PM2.5",{"$f":"0.0384+0.00991","v":4.8309999999999999E-2},{"$f":"0.0000771+0.00991","v":9.9871000000000005E-3},{"$f":"0.00991+0.0095","v":1.941E-2},0.1,7.0000000000000007E-2]
["Non-Road determination",null,null,null,null,null,{"$f":"IF(Input!B29=\"The generator is portable on its own\",IF(Input!B30=\"No\",1,2),2)","v":2},"1= non road, 2 = stationary",null,null,"NOx [3]",3.17,4.08,2.21,1.63,4.41]
["Engine Rating (hp)",null,null,null,null,null,{"$f":"Input!B33","v":0},"HP",null,null,"SO2",5.8799999999999998E-4,5.8799999999999998E-4,5.8799999999999998E-4,8.4000000000000005E-2,0.28999999999999998]
[{"$f":"Input!A34","v":"Engine Heat Input"},null,null,null,null,null,{"$f":"Input!B34","v":0},{"$f":"Input!D34","v":"MMBtu/hr"},null,null,"CO [3,5]",0.38600000000000001,0.317,3.72,0.99,0.95]
["Engine Heat Input",null,null,null,null,null,{"$f":"IF(A6=\"Fuel use factor\",G5*G6/1000000,G6)","v":0},"MMBtu/hr",null,null,"VOC [3,5]",0.12,0.11799999999999999,2.9600000000000001E-2,{"$f":"0.07+2.1+0.09+0.69+0.15","v":3.0999999999999996},{"$f":"0.35+0.01+0.07","v":0.43}]
["Fuel use factor",null,null,null,null,null,{"$f":"IF(A6=\"Fuel use factor\",G6,G6/G5*1000000)","v":{"$error":"#DIV/0!"}},"BTU/HP-hr",null,null,"Greenhouse Gases"]
["Maximum Fuel Capacity (MMscf/yr) Natural gas [MMBtu/hr x hr/yr / 1100 106 scf/MMBtu]",null,null,null,null,null,{"$f":"G7*G10/1100","v":{"$error":"#DIV/0!"}},null,null,null,"CO2",53.06,53.06,53.06,75.040000000000006,73.959999999999994]
["Operating Hours:",null,null,null,null,null,{"$f":"IF(G4=1,0,IF(Input!B28=\"Yes. Generator will be used only in emergency situations\",500,Input!B10))","v":{"$error":"#DIV/0!"}},null,null,null,"Methane [4]",1E-3,1E-3,1E-3,3.0000000000000001E-3,3.0000000000000001E-3]
["Type of Fuel Used in the Engine",null,null,null,null,null,{"$f":"IF(Input!B32=\"Natural Gas\",1,IF(Input!B32=\"No. 2 Fuel Oil (diesel)\",2,3))","v":3},null,null,null,"N2O [4]",1E-4,1E-4,1E-4,5.9999999999999995E-4,5.9999999999999995E-4]
["(Natural Gas = 1, No. 2 Fuel Oil (diesel) = 2, Gasoline = 3)",null,null,null,null,null,null,null,null,null,"Hazardous air pollutants "]
["Engine Type",null,null,null,null,null,{"$f":"IF(Input!B35=\"2-Stroke Lean Burn Engine\",1,IF(Input!B35=\"4-Stroke Lean Burn Engine\",2,IF(Input!B35=\"4-Stroke Rich Burn Engine\",3,4)))","v":4}]
["(2-Stroke Lean Burn Engine = 1, 4-Stroke Lean Burn Engine = 2, 4-Stroke Rich Burn Engine = 3, I don’t know =4)"]
[null,null,null,null,null,null,null,null,null,null,"Highest HAP",7.0900000000000005E-2,5.2800000000000007E-2,2.0499999999999997E-2,2.5800000000000003E-3,2.5800000000000003E-3]
["Pollutant","Emission Factor","Units","Potential Uncontrolled Emissions",null,null,null,null,null,null,"Total Haps",0.15371782254999999,7.1928288000000021E-2,3.2418080000000009E-2,6.4536000000000012E-3,6.4536000000000012E-3]
[null,null,null,"(lb/hr)","(tpy)"]
["Criteria Pollutants",null,null,null,null,null,null,null,null,null,"All emissions factors are from AP-42 Chapters 3.2 and 3.3"]
["PM/PM10/PM2.5",{"$f":"IF($G$11=1,IF($G$13=1,L3,IF($G$13=2,M3,IF($G$13=3,N3,MAX(L3:N3)))),IF($G$11=2,P3,O3))","v":0.1},"lb/MMBtu",{"$f":"IF(G4=1,0,$G$7*B19)","v":0},{"$f":"D19*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["NOx",{"$f":"IF($G$11=1,IF($G$13=1,L4,IF($G$13=2,M4,IF($G$13=3,N4,MAX(L4:N4)))),IF($G$11=2,P4,O4))","v":1.63},"lb/MMBtu",{"$f":"IF(G4=1,0,$G$7*B20)","v":0},{"$f":"D20*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["SO2",{"$f":"IF($G$11=1,IF($G$13=1,L5,IF($G$13=2,M5,IF($G$13=3,N5,MAX(L5:N5)))),IF($G$11=2,P5,O5))","v":8.4000000000000005E-2},"lb/MMBtu",{"$f":"IF(G4=1,0,$G$7*B21)","v":0},{"$f":"D21*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["CO",{"$f":"IF($G$11=1,IF($G$13=1,L6,IF($G$13=2,M6,IF($G$13=3,N6,MAX(L6:N6)))),IF($G$11=2,P6,O6))","v":0.99},"lb/MMBtu",{"$f":"IF(G4=1,0,$G$7*B22)","v":0},{"$f":"D22*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["VOC",{"$f":"IF($G$11=1,IF($G$13=1,L7,IF($G$13=2,M7,IF($G$13=3,N7,MAX(L7:N7)))),IF($G$11=2,P7,O7))","v":3.0999999999999996},"lb/MMBtu",{"$f":"IF(G4=1,0,$G$7*B23)","v":0},{"$f":"D23*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["Greenhouse Gases"]
["CO2",{"$f":"IF($G$11=1,IF($G$13=1,L9,IF($G$13=2,M9,IF($G$13=3,N9,MAX(L9:N9)))),IF($G$11=2,P9,O9))","v":75.040000000000006},"kg CO2/MMBtu",{"$f":"IF(G4=1,0,B25*$G$7*2.20462)","v":0},{"$f":"D25*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["Methane",{"$f":"IF($G$11=1,IF($G$13=1,L10,IF($G$13=2,M10,IF($G$13=3,N10,MAX(L10:N10)))),IF($G$11=2,P10,O10))","v":3.0000000000000001E-3},"kg CO2/MMBtu",{"$f":"IF(G4=1,0,B26*$G$7*2.20462)","v":0},{"$f":"D26*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["N2O",{"$f":"IF($G$11=1,IF($G$13=1,L11,IF($G$13=2,M11,IF($G$13=3,N11,MAX(L11:N11)))),IF($G$11=2,P11,O11))","v":5.9999999999999995E-4},"kg CO2/MMBtu",{"$f":"IF(G4=1,0,B27*$G$7*2.20462)","v":0},{"$f":"D27*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["Hazardous air pollutants "]
["Highest HAP",{"$f":"IF($G$11=1,IF($G$13=1,L15,IF($G$13=2,M15,IF($G$13=3,N15,MAX(L15:N15)))),IF($G$11=2,P15,O15))","v":2.5800000000000003E-3},"lb/MMBtu",{"$f":"IF(G4=1,0,$G$7*B29)","v":0},{"$f":"D29*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]
["Total HAPs",{"$f":"IF($G$11=1,IF($G$13=1,L16,IF($G$13=2,M16,IF($G$13=3,N16,MAX(L16:N16)))),IF($G$11=2,P16,O16))","v":6.4536000000000012E-3},"lb/MMBtu",{"$f":"IF(G4=1,0,$G$7*B30)","v":0},{"$f":"D30*$G$10*0.0005","v":{"$error":"#DIV/0!"}}]

{"sheet":"Sheet2","index":11,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Length Units","Temperature","Velocity","Flow rate",null,"Yes","Natural Gas","Baghouse","Yes. Generator will be used only in emergency situations","The generator is portable on its own","Batch mix plant",{"$f":"IF(Input!B8=\"Batch mix plant\",347,IF(Input!B8=\"Drum mix plant\",694,\"\"))","v":""},"Natural Gas","Fuel use factor","BTU/HP-hr","2-Stroke Lean Burn Engine","Natural Gas"]
["m","C","m/s","m3 / s",null,"No","No. 2 Fuel Oil (diesel)","Wet Scrubber","Yes, when available. Otherwise the generator will be used.","The generator is physically attached to another part of the plant","Drum mix plant",{"$f":"IF(Input!B8=\"Batch mix plant\",400000,IF(Input!B8=\"Drum mix plant\",850000,\"\"))","v":""},"No. 2 Fuel Oil (diesel)","Engine Heat Input","MMBtu/hr","4-Stroke Lean Burn Engine","No. 2 Fuel Oil (diesel)"]
["ft","F","ft/s","ft3 / s",null,null,"Waste Oil","No Control","No. It will depend solely on the generator",null,null,null,"Other",null,null,"4-Stroke Rich Burn Engine","Gasoline"]
[null,"K",null,null,null,null,"No. 5 Fuel Oil",null,null,null,null,null,null,null,null,"I don’t know"]
[null,null,null,null,null,null,"No. 6 Fuel Oil"]
[null,null,null,null,null,null,"Propane"]
[null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,"Coal"]