{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tanks","Datasets"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":4,"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":"Tanks","index":0,"n_rows":52,"n_cols":31,"rows_kept":52,"cut":false,"hidden":false,"merged":[[39,1,39,3],[39,6,39,8],[6,0,6,2],[6,3,6,5],[6,8,6,10],[20,20,20,21],[20,22,20,28],[20,29,20,30],[4,8,4,11],[5,3,5,6],[5,8,5,11],[6,22,6,28],[6,29,6,30],[6,20,6,21]]}
[]
["Universal Calculation Spreadsheets"]
["Tanks"]
[]
[]
[null,null,null,"Current Capacity",null,null,null,null,"Maximum Proposed Capacity"]
["Tanks",null,null,null,null,null,"Units",null,null,null,null,"Units",null,null,null,null,null,null,null,"Material","Anhydrous Ethanol",null,"Denaturant",null,null,null,null,null,null,"Corrosion Inhibitor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HAP Weight Fraction",1.29E-2,1.8E-3,2.8999999999999998E-3,2.0000000000000002E-5,1E-4,5.0000000000000002E-5,1.21E-2,1.8E-3,5.0000000000000001E-4,0.25,0.1]
[null,"ID","Emission Unit Name","Tank Content","Maximum Tank Capacity (Gal)","Maximum Working Volume (Gal)","Throughput (Gal/yr)","Turnovers","Height (ft)","Length (ft)","Diameter (ft)","Tank Orientation","Tank Location","Type of Tank","Type of Primary Seal","VOC, lb/ yr",null,"Amount of VOC from Ethanol","Amount of VOC from Denaturant","Hazardous Air \nPollutant","Acetaldehyde","Methanol","Benzene","Carbon disulfide","Cumene","Ethyl Benzene","n-Hexane","Toluene","Xylenes","Methanol","Xylenes"]
["1st Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D10=Datasets!$R$2,P10,IF(D10=Datasets!$R$4,0.95*P10,0))","v":0},{"$f":"IF(D10=Datasets!$R$3,P10,IF(D10=Datasets!$R$4,0.05*P10,0))","v":0},null,{"$f":"R10*U$8","v":0},{"$f":"R10*V$8","v":0},{"$f":"S10*W$8","v":0},{"$f":"S10*X$8","v":0},{"$f":"S10*Y$8","v":0},{"$f":"S10*Z$8","v":0},{"$f":"S10*AA$8","v":0},{"$f":"S10*AB$8","v":0},{"$f":"S10*AC$8","v":0},{"$f":"(P10-R10-S10)*AD$8","v":0},{"$f":"(P10-R10-S10)*AE$8","v":0}]
["2nd Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D11=Datasets!$R$2,P11,IF(D11=Datasets!$R$4,0.95*P11,0))","v":0},{"$f":"IF(D11=Datasets!$R$3,P11,IF(D11=Datasets!$R$4,0.05*P11,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["3rd Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D12=Datasets!$R$2,P12,IF(D12=Datasets!$R$4,0.95*P12,0))","v":0},{"$f":"IF(D12=Datasets!$R$3,P12,IF(D12=Datasets!$R$4,0.05*P12,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["4th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D13=Datasets!$R$2,P13,IF(D13=Datasets!$R$4,0.95*P13,0))","v":0},{"$f":"IF(D13=Datasets!$R$3,P13,IF(D13=Datasets!$R$4,0.05*P13,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["5th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D14=Datasets!$R$2,P14,IF(D14=Datasets!$R$4,0.95*P14,0))","v":0},{"$f":"IF(D14=Datasets!$R$3,P14,IF(D14=Datasets!$R$4,0.05*P14,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["6th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15=Datasets!$R$2,P15,IF(D15=Datasets!$R$4,0.95*P15,0))","v":0},{"$f":"IF(D15=Datasets!$R$3,P15,IF(D15=Datasets!$R$4,0.05*P15,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["7th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16=Datasets!$R$2,P16,IF(D16=Datasets!$R$4,0.95*P16,0))","v":0},{"$f":"IF(D16=Datasets!$R$3,P16,IF(D16=Datasets!$R$4,0.05*P16,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["8th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D17=Datasets!$R$2,P17,IF(D17=Datasets!$R$4,0.95*P17,0))","v":0},{"$f":"IF(D17=Datasets!$R$3,P17,IF(D17=Datasets!$R$4,0.05*P17,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["9th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D18=Datasets!$R$2,P18,IF(D18=Datasets!$R$4,0.95*P18,0))","v":0},{"$f":"IF(D18=Datasets!$R$3,P18,IF(D18=Datasets!$R$4,0.05*P18,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["10th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D19=Datasets!$R$2,P19,IF(D19=Datasets!$R$4,0.95*P19,0))","v":0},{"$f":"IF(D19=Datasets!$R$3,P19,IF(D19=Datasets!$R$4,0.05*P19,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Material","Anhydrous Ethanol",null,"Denaturant",null,null,null,null,null,null,"Corrosion Inhibitor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HAP Weight Fraction",1.29E-2,1.8E-3,2.8999999999999998E-3,2.0000000000000002E-5,1E-4,5.0000000000000002E-5,1.21E-2,1.8E-3,5.0000000000000001E-4,0.25,0.1]
[null,"ID","Emission Unit Name","Tank Content","Maximum Tank Capacity (Gal)","Maximum Working Volume (Gal)","Throughput (Gal/yr)","Turnovers","Height (ft)","Length (ft)","Diameter (ft)","Tank Orientation","Tank Location","Type of Tank","Type of Primary Seal","VOC, lb/yr",null,"Amount of VOC from Ethanol","Amount of VOC from Denaturant","Hazardous Air \nPollutant","Acetaldehyde","Methanol","Benzene","Carbon disulfide","Cumene","Ethyl Benzene","n-Hexane","Toluene","Xylenes","Methanol","Xylenes"]
["1st Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D24=Datasets!$R$2,P24,IF(D24=Datasets!$R$4,0.95*P24,0))","v":0},{"$f":"IF(D24=Datasets!$R$3,P24,IF(D24=Datasets!$R$4,0.05*P24,0))","v":0},null,{"$f":"R24*U$8","v":0},{"$f":"R24*V$8","v":0},{"$f":"S24*W$8","v":0},{"$f":"S24*X$8","v":0},{"$f":"S24*Y$8","v":0},{"$f":"S24*Z$8","v":0},{"$f":"S24*AA$8","v":0},{"$f":"S24*AB$8","v":0},{"$f":"S24*AC$8","v":0},{"$f":"(P24-R24-S24)*AD$8","v":0},{"$f":"(P24-R24-S24)*AE$8","v":0}]
["2nd Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D25=Datasets!$R$2,P25,IF(D25=Datasets!$R$4,0.95*P25,0))","v":0},{"$f":"IF(D25=Datasets!$R$3,P25,IF(D25=Datasets!$R$4,0.05*P25,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["3rd Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D26=Datasets!$R$2,P26,IF(D26=Datasets!$R$4,0.95*P26,0))","v":0},{"$f":"IF(D26=Datasets!$R$3,P26,IF(D26=Datasets!$R$4,0.05*P26,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["4th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D27=Datasets!$R$2,P27,IF(D27=Datasets!$R$4,0.95*P27,0))","v":0},{"$f":"IF(D27=Datasets!$R$3,P27,IF(D27=Datasets!$R$4,0.05*P27,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["5th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D28=Datasets!$R$2,P28,IF(D28=Datasets!$R$4,0.95*P28,0))","v":0},{"$f":"IF(D28=Datasets!$R$3,P28,IF(D28=Datasets!$R$4,0.05*P28,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["6th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=Datasets!$R$2,P29,IF(D29=Datasets!$R$4,0.95*P29,0))","v":0},{"$f":"IF(D29=Datasets!$R$3,P29,IF(D29=Datasets!$R$4,0.05*P29,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["7th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D30=Datasets!$R$2,P30,IF(D30=Datasets!$R$4,0.95*P30,0))","v":0},{"$f":"IF(D30=Datasets!$R$3,P30,IF(D30=Datasets!$R$4,0.05*P30,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["8th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D31=Datasets!$R$2,P31,IF(D31=Datasets!$R$4,0.95*P31,0))","v":0},{"$f":"IF(D31=Datasets!$R$3,P31,IF(D31=Datasets!$R$4,0.05*P31,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["9th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D32=Datasets!$R$2,P32,IF(D32=Datasets!$R$4,0.95*P32,0))","v":0},{"$f":"IF(D32=Datasets!$R$3,P32,IF(D32=Datasets!$R$4,0.05*P32,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
["10th Tank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D33=Datasets!$R$2,P33,IF(D33=Datasets!$R$4,0.95*P33,0))","v":0},{"$f":"IF(D33=Datasets!$R$3,P33,IF(D33=Datasets!$R$4,0.05*P33,0))","v":0},null,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[null,"Total Individual HAPs",null,null,null,null,"Total Individual HAPs"]
[null,"lb/year","lb/hr","tons/yr",null,null,"lb/year","lb/hr","tons/yr"]
["VOC",{"$f":"SUM(P10:P19)","v":0},{"$f":"B42/8760","v":0},{"$f":"B42/2000","v":0},null,"VOC",{"$f":"SUM(P24:P33)","v":0},{"$f":"G42/8760","v":0},{"$f":"G42/2000","v":0}]
["Acetaldehyde",{"$f":"SUM(U10:U19)","v":0},{"$f":"B43/8760","v":0},{"$f":"B43/2000","v":0},null,"Acetaldehyde",{"$f":"SUM(U24:U33)","v":0},{"$f":"G43/8760","v":0},{"$f":"G43/2000","v":0}]
["Methanol",{"$f":"SUM(V10:V19)+SUM(AD10:AD19)","v":0},0,0,null,"Methanol",{"$f":"SUM(V24:V33)+SUM(AD24:AD33)","v":0},0,0]
["Benzene",{"$f":"SUM(W10:W19)","v":0},0,0,null,"Benzene",{"$f":"SUM(W24:W33)","v":0},0,0]
["Carbon disulfide",{"$f":"SUM(X10:X19)","v":0},0,0,null,"Carbon disulfide",{"$f":"SUM(X24:X33)","v":0},0,0]
["Cumene",{"$f":"SUM(Y10:Y19)","v":0},0,0,null,"Cumene",{"$f":"SUM(Y24:Y33)","v":0},0,0]
["Ethyl Benzene",{"$f":"SUM(Z10:Z19)","v":0},0,0,null,"Ethyl Benzene",{"$f":"SUM(Z24:Z33)","v":0},0,0]
["n-Hexane",{"$f":"SUM(AA10:AA19)","v":0},0,0,null,"n-Hexane",{"$f":"SUM(AA24:AA33)","v":0},0,0]
["Toluene",{"$f":"SUM(AB10:AB19)","v":0},0,0,null,"Toluene",{"$f":"SUM(AB24:AB33)","v":0},0,0]
["Xylenes",{"$f":"SUM(AC10:AC19)+SUM(AE10:AE19)","v":0},0,0,null,"Xylenes",{"$f":"SUM(AC24:AC33)+SUM(AE24:AE33)","v":0},0,0]
["Total",{"$f":"SUM(B43:B51)","v":0},0,{"$f":"B52/2000","v":0},null,"Total",{"$f":"SUM(G43:G51)","v":0},0,{"$f":"G52/2000","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]