{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cooling Tower","Datasets"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":2,"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":"Cooling Tower","index":0,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":false,"merged":[[64,0,64,2],[64,7,64,9],[65,0,66,0],[65,7,66,7],[38,7,40,11],[38,0,40,5],[6,0,6,1],[23,0,24,0],[32,0,32,2],[33,0,34,0],[23,7,24,7],[32,7,32,9],[33,7,34,7],[8,1,8,4],[8,8,8,11]]}
[]
["Universal Calculation Spreadsheets"]
["Cooling Towers"]
[]
[]
[]
[]
["Potential to Emit Calculations for Emissions from the Cooling Tower (Max. 4)",null,null,null,null,null,null,"Potential to Emit Calculations for Emissions from the Cooling Tower (Max. 4)"]
["Number of cooling towers",1,null,null,null,null,null,null,1]
["Circulation rate:",null,null,null,null,"gal/hr ",null,"Circulation rate:",null,null,null,null,"gal/hr "]
[null,{"$f":"B10*8760/1000","v":0},{"$f":"C10*8760/1000","v":0},0,0,"Mgal/yr (based on 8,760 hrs/yr)",null,null,{"$f":"I10*8760/1000","v":0},{"$f":"J10*8760/1000","v":0},0,0,"Mgal/yr (based on 8,760 hrs/yr)"]
["Biocide used:","NO","NO","NO","NO",null,null,"Biocide used:","NO","NO","NO","NO"]
[]
["Drift loss percent:",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,"%",null,"Drift loss percent:",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,"%"]
["Water density:",8.34,8.34,8.34,8.34,"lbs/gal",null,"Water density:",8.34,8.34,8.34,8.34,"lbs/gal"]
[]
["TDS concentration:",2000,2000,2000,2000,"ppm single sample event",null,"TDS concentration:",2000,2000,2000,2000,"ppm single sample event"]
[null,2000,2000,2000,2000,"ppm average annual rate",null,null,2000,2000,2000,2000,"ppm average annual rate"]
[]
["Emission Factor Calculation for PM and PM10",null,null,null,null,null,null,"Emission Factor Calculation for PM and PM10"]
[]
["Emission factor equation from AP-42, Section 13.4-2 (01/1995)",null,null,null,null,null,null,"Emission factor equation from AP-42, Section 13.4-2 (01/1995)"]
[]
["PM/PM10 emission factor =",null,null,null,null,null,null,"PM/PM10 emission factor ="]
[]
[]
[null,8.34E-4,"lbs/Mgal single sample event (highest hourly rate)",null,null,null,null,null,8.34E-4,"lbs/Mgal single sample event (highest hourly rate)"]
[null,8.34E-4,"lbs/Mgal average annual rate",null,null,null,null,null,8.34E-4,"lbs/Mgal average annual rate"]
[]
["Hourly Emissions = (lbs/Mgal single sample event)(hourly throughput gal/hr)(1 Mgal/1,000 gal)",null,null,null,null,null,null,"Hourly Emissions = (lbs/Mgal single sample event)(hourly throughput gal/hr)(1 Mgal/1,000 gal)"]
["Annual Emissions = (lbs/Mgal average annual rate)(annual throughput Mgal/yr)/(2,000 lbs/ton)",null,null,null,null,null,null,"Annual Emissions = (lbs/Mgal average annual rate)(annual throughput Mgal/yr)/(2,000 lbs/ton)"]
[]
["Cooling Tower Emission Summary",null,null,null,null,null,null,"Cooling Tower Emission Summary"]
["Pollutant","Hourly PTE","Annual PTE",null,null,null,null,"Pollutant","Hourly PTE","Annual PTE"]
[null,"(lbs/hr)","(tons/year)",null,null,null,null,null,"(lbs/hr)","(tons/year)"]
["PM",{"$f":"$B$27*(($B$10+$C$10+$D$10+$E$10)/1000)","v":0},{"$f":"$B$28*SUM($B$11:$E$11)/2000","v":0},null,null,null,null,"PM",{"$f":"$I$27*((I10+J10+K10+L10)/1000)","v":0},{"$f":"$I$28*SUM($I$11:$L$11)/2000","v":0}]
["PM10",{"$f":"($B$27*(($B$10+$C$10+$D$10+$E$10)/1000)*0.7)","v":0},{"$f":"$B$28*SUM($B$11:$E$11)/2000*0.7","v":0},null,null,null,null,"PM10",{"$f":"($I$27*((I10+J10+K10+L10)/1000)*0.7)","v":0},{"$f":"$I$28*SUM($I$11:$L$11)/2000*0.7","v":0}]
["PM2.5",{"$f":"($B$27*(($B$10+$C$10+$D$10+$E$10)/1000)*0.42)","v":0},{"$f":"$B$28*SUM($B$11:$E$11)/2000*0.42","v":0},null,null,null,null,"PM2.5",{"$f":"($I$27*((I10+J10+K10+L10)/1000)*0.42)","v":0},{"$f":"$I$28*SUM($I$11:$L$11)/2000*0.42","v":0}]
["PM10 and PM2.5 emissions estimated to be 70% and 42% (respectively) of total PM emissions based on Appendix A to Particulate Matter (PM) 2.5 Significance Thresholds and Calculation Methodology published by the South Coast Air Quality Management District",null,null,null,null,null,null,"PM10 and PM2.5 emissions estimated to be 70% and 42% (respectively) of total PM emissions based on Appendix A to Particulate Matter (PM) 2.5 Significance Thresholds and Calculation Methodology published by the South Coast Air Quality Management District"]
[]
[]
[]
["Emission Factor Calculation for VOCs"]
["Bioside",null,null,null,null,null,null,"Bioside"]
[null,{"$f":"IF(B12=Datasets!$D$2,1,0)","v":0},{"$f":"IF(C12=Datasets!$D$2,1,0)","v":0},{"$f":"IF(D12=Datasets!$D$2,1,0)","v":0},{"$f":"IF(E12=Datasets!$D$2,1,0)","v":0},null,null,null,{"$f":"IF(I12=Datasets!$D$2,1,0)","v":0},{"$f":"IF(J12=Datasets!$D$2,1,0)","v":0},{"$f":"IF(K12=Datasets!$D$2,1,0)","v":0},{"$f":"IF(L12=Datasets!$D$2,1,0)","v":0}]
["Biocide Content (ppmv)",10,10,10,10,null,null,"Biocide Content (ppmv)",10,10,10,10]
["Biocide VOC Fraction (Unitless)",0.01,0.01,0.01,0.01,null,null,"Biocide VOC Fraction (Unitless)",0.01,0.01,0.01,0.01]
["Biocide Density (lb/gal)",12.1,12.1,12.1,12.1,null,null,"Biocide Density (lb/gal)",12.1,12.1,12.1,12.1]
["Biocide Use (gal/yr)",{"$f":"B46*B10*8760/1000000","v":0},{"$f":"C46*C10*8760/1000000","v":0},0,0,null,null,"Biocide Use (gal/yr)",{"$f":"I46*I10*8760/1000000","v":0},{"$f":"J46*J10*8760/1000000","v":0},0,0]
["Biocide Use (ton/yr)",{"$f":"B49*B48/2000","v":0},{"$f":"C49*C48/2000","v":0},0,0,null,null,"Biocide Use (ton/yr)",{"$f":"I49*I48/2000","v":0},{"$f":"J49*J48/2000","v":0},{"$f":"K49*K48/2000","v":0},{"$f":"L49*L48/2000","v":0}]
["VOC Emission Rate (lb/hr)",{"$f":"(B46*B47*B48*B10*B45)/1000000","v":0},{"$f":"(C46*C47*C48*C10*C45)/1000000","v":0},{"$f":"(D46*D47*D48*D10*D45)/1000000","v":0},{"$f":"(E46*E47*E48*E10*E45)/1000000","v":0},null,null,"VOC Emission Rate (lb/hr)",{"$f":"(I46*I47*I48*I10*I45)/1000000","v":0},{"$f":"(J46*J47*J48*J10*J45)/1000000","v":0},{"$f":"(K46*K47*K48*K10*K45)/1000000","v":0},{"$f":"(L46*L47*L48*L10*L45/1000000)","v":0}]
["VOC Emission Rate (ton/yr)",{"$f":"B51*8760/2000","v":0},{"$f":"C51*8760/2000","v":0},0,0,null,null,"VOC Emission Rate (ton/yr)",{"$f":"I51*8760/2000","v":0},{"$f":"J51*8760/2000","v":0},{"$f":"K51*8760/2000","v":0},{"$f":"L51*8760/2000","v":0}]
[]
["Antiscalant",null,null,null,null,null,null,"Antiscalant"]
["Additive Rate (gal/day)",20,20,20,20,null,null,"Additive Rate (gal/day)",20,20,20,20]
["Density (lb/gal)",15,15,15,15,null,null,"Density (lb/gal)",15,15,15,15]
["VOC Fraction",0.6,0.6,0.6,0.6,null,null,"VOC Fraction",0.6,0.6,0.6,0.6]
["HAP Fraction",0.01,0.01,0.01,0.01,null,null,"HAP Fraction",0.01,0.01,0.01,0.01]
["VOC Emission Rate (lb/hr)",{"$f":"B55*B56*B57*B45/24","v":0},{"$f":"C55*C56*C57*C45/24","v":0},{"$f":"D55*D56*D57*D45/24","v":0},{"$f":"E55*E56*E57*E45/24","v":0},null,null,"VOC Emission Rate (lb/hr)",{"$f":"I55*I56*I57*I45/24","v":0},{"$f":"J55*J56*J57*J45/24","v":0},{"$f":"K55*K56*K57*K45/24","v":0},{"$f":"L55*L56*L57*L45/24","v":0}]
["VOC Emission Rate (ton/yr)",{"$f":"B59*8760/2000","v":0},{"$f":"C59*8760/2000","v":0},{"$f":"D59*8760/2000","v":0},{"$f":"E59*8760/2000","v":0},null,null,"VOC Emission Rate (ton/yr)",{"$f":"I59*8760/2000","v":0},{"$f":"J59*8760/2000","v":0},{"$f":"K59*8760/2000","v":0},{"$f":"L59*8760/2000","v":0}]
["HAP Emissions (lb/hr)",{"$f":"B55*B56*B58/24*B45","v":0},{"$f":"C55*C56*C58/24*C45","v":0},{"$f":"D55*D56*D58/24*D45","v":0},{"$f":"E55*E56*E58/24*E45","v":0},null,null,"HAP Emissions (lb/hr)",{"$f":"I55*I56*I58/24*I45","v":0},{"$f":"J55*J56*J58/24*J45","v":0},{"$f":"K55*K56*K58/24*K45","v":0},{"$f":"L55*L56*L58*L45/24","v":0}]
["HAP Emissions (ton/yr)",{"$f":"B61*8760/2000","v":0},{"$f":"C61*8760/2000","v":0},0,0,null,null,"HAP Emissions (ton/yr)",{"$f":"I61*8760/2000","v":0},{"$f":"J61*8760/2000","v":0},{"$f":"K61*8760/2000","v":0},{"$f":"L61*8760/2000","v":0}]
[]
[]
["Cooling Tower Emission Summary",null,null,null,null,null,null,"Cooling Tower Emission Summary"]
["Pollutant","Hourly PTE","Annual PTE",null,null,null,null,"Pollutant","Hourly PTE","Annual PTE"]
[null,"(lbs/hr)","(tons/year)",null,null,null,null,null,"(lbs/hr)","(tons/year)"]
["VOC",{"$f":"SUM(B51:E51)+SUM(B59:E59)","v":0},{"$f":"SUM(B52:E52)+SUM(B60:E60)","v":0},null,null,null,null,"VOC",{"$f":"SUM(I51:L51)+SUM(I59:L59)","v":0},{"$f":"SUM(I52:L52)+SUM(I60:L60)","v":0}]
["HAP",{"$f":"SUM(B61:E61)","v":0},{"$f":"SUM(B62:E62)","v":0},null,null,null,null,"HAP",{"$f":"SUM(I61:L61)","v":0},{"$f":"SUM(I62:L62)","v":0}]

{"sheet":"Datasets","index":1,"n_rows":22,"n_cols":44,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Unit Type","% Straight to Hopper","Control type","Yes/NO","Choice","Permit Type","Construction Permit","Raw Material","Enclosure","Material Transfer","Pile Control","Dryer Type","Fermentation Control","Type of solids","Enclosure","Type of Loadout","Loading Type","Tank Content","Tank Orientation","Tank Location","Type of Tank","Type of Primary Seal","Shell Condition","Number of columns","Default Control Equipment","Controlled Units","Boiler Types","NSPS","Fermenter/beerwell","Fermentation Type","Control Type","Control Type","Storage Control type","Ave. Truck Capacity","Input Road Type","Fuel Type","Engine Configuration","Type of Secondary Seal","Internal Shell Conditions","External Shell Color","External Shell Condition","Deck Type","Deck Fitting Category","Results Summary"]
["Truck","0:100","None/Uncontrolled","YES","X","Construction Permit","New Construction","Corn","Enclosed","Front-End Loader","Covered","column dryer","Vent Scrubber","DDGS","Enclosed","Truck","None","Ethanol","Vertical","Above Ground","Fixed Roof","Mechanical Shoe","Light Rust","Self Support",0.95,"Dump Pits","Uncontrolled","Pre-NSPS","Fermenter","Batch Fermentation","None/Uncontrolled","None/Uncontrolled","None/Uncontrolled","ton","Unpaved Low Silt","Natural Gas","2-STROKE LEAN-BURN","Shoe Mounted ","Light Rust","White","Good","Bolted","Typical ","Current PTE, (lb/hr)"]
["Rail Car","10:90","Baghouse","NO",null,"Operating Permit","Existing Plant","Milo","Partially Enclosed","Conveyor","Covered & Supressant","rack dryer","CO2 Scubber","WDGS","Partially Enclosed","Rail Car","Submerged Loading","Denaturant","Horizontal","Under Ground","External Floating Roof","Liquid Mounted","Dense Rust",1,0.99,"Grain Handling","Low Nox burners","Post-NSPS","Beerwell","Continous Fermentation","Scrubber","RTO","Baghouse","gal","Unpaved Medium Silt","Gasoline","4-STROKE LEAN-BURN","Rim Mounted","Dense Rust","Aluminum/ Specular","Poor","Welded","Detail","Current PTE, (ton/yr)"]
[null,"20:80",null,null,null,null,null,"Cellulose","Choke-flow","Dump Truck","None","self‐cleaning screens","No Control",null,"Other","Both","Bottom-Fill Loading","Denatured Ethanol",null,null,"Internal Floating Roof","Vapor Mounted","Gunite Lining",2,null,"Receiving & Handling","Flue Gas recirculation",null,null,null,null,null,"Oiler",null,"Unpaved High Silt","Dual Fuel (95% NG + Diesel","4-STROKE RICH-BURN",null,"Gunite Lining","Aluminum/ Diffuse",null,null,null,"PTE after the project, (lb/hr)"]
[null,"30:70",null,null,null,null,null,"Other","Other","Loadout Spout",null,"other",null,null,null,null,null,"Corrosion Inhibitor",null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,"Paved Low Silt",null,null,null,null,"Gray/ Light",null,null,null,"PTE after the project, (ton/yr)"]
[null,"40:60",null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,"Hydrochloric Acid",null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,"Paved Medium Silt",null,null,null,null,"Gray/ Medium",null,null,null,"Project PTE, (lb/hr)"]
[null,"50:50",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,"Paved High Silt",null,null,null,null,"Red/ Prime",null,null,null,"Project PTE, (ton/yr)"]
[null,"60:40",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,"70:30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Fugitive PTE, (lb/hr)"]
[null,"80:20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Fugitive PTE, (ton/yr)"]
[null,"90:10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fugitive PTE after the Project, (lb/hr)"]
[null,"100:10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fugitive PTE after the Project, (ton/yr)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Fugitive PTE, (lb/hr)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Fugitive PTE, (ton/yr)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]