{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Storage Pile","Results Summary","Calculations","Datasets"],"not_rendered":{"charts":0,"images":12,"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":"Storage Pile","index":0,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,8,5,11],[6,3,6,6],[6,8,6,11],[10,0,10,1],[10,4,10,5],[8,0,8,2],[8,3,8,5],[8,8,8,10]]}
[]
["Universal Calculation Spreadsheets"]
["Storage Piles"]
[]
["Please, enter information describing the receiving capacity"]
[]
["Questions",null,null,"Current Capacity",null,null,null,null,"Maximum Proposed Capacity"]
[]
["Number of Storage Pile"]
[]
["Wind Speed (m/sec)",null,3]
[]
[null,"ID","Emission Unit Name","Pile Capacity, bu","Moisture content, %","Transfer type","Control",null,"ID","Emission Unit Name","Pile Capacity, bu","Moisture content, %","Transfer type","Control"]
["1st Storage Pile",null,null,null,null,null,null,"1st Storage Pile"]
["2nd Storage Pile",null,null,null,null,null,null,"2nd Storage Pile"]
["3rd Storage Pile",null,null,null,null,null,null,"3rd Storage Pile"]
["4th Storage Pile",null,null,null,null,null,null,"4th Storage Pile"]
["5th Storage Pile",null,null,null,null,null,null,"5th Storage Pile"]
["6th Storage Pile",null,null,null,null,null,null,"6th Storage Pile"]
["7th Storage Pile",null,null,null,null,null,null,"7th Storage Pile"]
["8th Storage Pile",null,null,null,null,null,null,"8th Storage Pile"]
["9th Storage Pile",null,null,null,null,null,null,"9th Storage Pile"]
["10th Storage Pile",null,null,null,null,null,null,"10th Storage Pile"]

{"sheet":"Results Summary","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,8,6,8],[5,9,5,10],[5,0,6,0],[5,1,5,2],[5,4,6,4],[5,5,5,6]]}
[]
["Universal Calculation Spreadsheets"]
["Results Summary"]
[]
["Fugitive PTE"]
["Pollutants","Current PTE",null,null,"Pollutants","Total PTE after Project","DDGS dryers",null,"Pollutants","Project PTE"]
[null,"(lb/hr)","(ton/yr)",null,null,"(lb/hr)","(ton/yr)",null,null,"(lb/hr)","(ton/yr)"]
["  PMfilterable",{"$f":"C8*2000/8760","v":0},{"$f":"Calculations!B28","v":0},null,"  PMfilterable",{"$f":"G8*2000/8760","v":0},{"$f":"Calculations!H28","v":0},null,"  PMfilterable",{"$f":"F8-B8","v":0},{"$f":"G8-C8","v":0}]
["  PM10",{"$f":"C9*2000/8760","v":0},{"$f":"Calculations!B31","v":0},null,"  PM10",{"$f":"G9*2000/8760","v":0},{"$f":"Calculations!H31","v":0},null,"  PM10",{"$f":"F9-B9","v":0},{"$f":"G9-C9","v":0}]
["  PM2.5",0,{"$f":"Calculations!B34","v":0},null,"  PM2.5",0,{"$f":"Calculations!H34","v":0},null,"  PM2.5",0,0]

{"sheet":"Calculations","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[19,1,19,3],[12,0,13,0],[12,1,12,2],[13,1,13,2],[2,5,5,5],[3,4,5,4],[2,2,5,2],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[3,7,5,7]]}
["Fact Sheet Attachment:  Storage Pile"]
[]
["Control type","Control Efficiency",null,"Number of piles controlled","Overall Control Efficiency",null,"Number of piles controlled","Control Efficiency"]
["None",0,null,{"$f":"COUNTIF('Storage Pile'!$G$14:$G$23,Calculations!A4)","v":0},{"$f":"IF(OR(D4>0,'Storage Pile'!D9-SUM(Calculations!D4:D6)>0),B4,IF(D5>0,B5,B6))","v":0.85},null,{"$f":"COUNTIF('Storage Pile'!$N$14:$N$23,Calculations!A4)","v":0},{"$f":"IF(OR(G4>0,'Storage Pile'!I9-SUM(Calculations!G4:G6)>0),B4,IF(G5>0,B5,B6))","v":0.85}]
["Covered",0.7,null,{"$f":"COUNTIF('Storage Pile'!$G$14:$G$23,Calculations!A5)","v":0},null,null,{"$f":"COUNTIF('Storage Pile'!$N$14:$N$23,Calculations!A5)","v":0}]
["Covered & Suppressant",0.85,null,{"$f":"COUNTIF('Storage Pile'!$G$14:$G$23,Calculations!A6)","v":0},null,null,{"$f":"COUNTIF('Storage Pile'!$N$14:$N$23,Calculations!A6)","v":0}]
[]
["Assumptions"]
["· All emissions from storage pile are fugitive."]
["· Material moisture content is based on product specifications. "]
["· The calculations are for an active storage pile including receiving and shipping. "]
[]
["E =","k * (0.0032) * (U/5)^1.3"]
[null,"(M/2)^1.4"]
[]
["  Factor","  Description",null,null,"PM Value","PM10 Value","PM2.5 Value"]
["E =","Emission factor (lb/ton)",null,null,{"$f":"((E18*(0.0032)*((E19/5)^1.3))/(E20/2)^1.4)","v":9.6252705913146646E-4},{"$f":"((F18*(0.0032)*((F19/5)^1.3))/(F20/2)^1.4)","v":4.5524928472434227E-4},{"$f":"((G18*(0.0032)*((G19/5)^1.3))/(G20/2)^1.4)","v":6.8937748829686119E-5}]
["k =","Particle size multiplier (dimensionless)",null,null,0.74,0.35,5.2999999999999999E-2]
["U =","mean wind speed (miles per hour)",null,null,{"$f":"'Storage Pile'!$C$11*2.23694","v":6.71082},{"$f":"'Storage Pile'!$C$11*2.23694","v":6.71082},{"$f":"'Storage Pile'!$C$11*2.23694","v":6.71082}]
["M =","material moisture content (%)",null,null,5,5,5]
["Emission factor source = AP-42 5th Edition Chapter 13.2.4 Equation for active storage piles"]
[]
[]
["Total Throughput",{"$f":"IF('Storage Pile'!D9=0,0,#REF!*2000/56-SUM('Storage Pile'!#REF!))","v":0},"bushels/year",null,null,null,"Total Throughput",{"$f":"IF('Storage Pile'!I9=0,0,#REF!*2000/56-SUM('Storage Pile'!#REF!))","v":0},"bushels/year"]
[null,{"$f":"B24*56/2000","v":0},"ton/yr",null,null,null,null,{"$f":"H24*56/2000","v":0},"ton/yr"]
[]
[{"$f":"\"Total PM Emissions = \"&FIXED(E17,4,TRUE)&\" lb/ton · \"&FIXED(B25,0,TRUE)&\" ton/year · 1ton/2,000 lb . (100% - \"&E4&\"%) Control efficiency\"","v":"Total PM Emissions = 0.0010 lb/ton · 0 ton/year · 1ton/2,000 lb . (100% - 0.85%) Control efficiency"},null,null,null,null,null,{"$f":"\"Total PM Emissions = \"&FIXED(E17,4,TRUE)&\" lb/ton · \"&FIXED(H25,0,TRUE)&\" ton/year · 1ton/2,000 lb . (100% - \"&H4&\"%) Control efficiency\"","v":"Total PM Emissions = 0.0010 lb/ton · 0 ton/year · 1ton/2,000 lb . (100% - 0.85%) Control efficiency"}]
["=",{"$f":"E17*B25/2000*(1-E4)","v":0},"ton/year",null,null,null,"=",{"$f":"E17*H25/2000*(1-H4)","v":0},"ton/year"]
[]
[{"$f":"\"Total PM10 Emissions = \"&FIXED(F17,5,TRUE)&\" lb/ton · \"&FIXED(B25,0,TRUE)&\" ton/year · 1ton/2,000 lb . (100% - \"&E4&\"%) Control efficiency\"","v":"Total PM10 Emissions = 0.00046 lb/ton · 0 ton/year · 1ton/2,000 lb . (100% - 0.85%) Control efficiency"},null,null,null,null,null,{"$f":"\"Total PM10 Emissions = \"&FIXED(F17,5,TRUE)&\" lb/ton · \"&FIXED(H25,0,TRUE)&\" ton/year · 1ton/2,000 lb . (100% - \"&H4&\"%) Control efficiency\"","v":"Total PM10 Emissions = 0.00046 lb/ton · 0 ton/year · 1ton/2,000 lb . (100% - 0.85%) Control efficiency"}]
["=",{"$f":"F17*B25/2000*(1-E4)","v":0},"ton/year",null,null,null,"=",{"$f":"F17*H25/2000*(1-H4)","v":0},"ton/year"]
[]
[{"$f":"\"Total PM2.5 Emissions = \"&FIXED(G17,5,TRUE)&\" lb/ton · \"&FIXED(B25,0,TRUE)&\" ton/year · 1ton/2,000 lb . (100% - \"&E4&\"%) Control efficiency\"","v":"Total PM2.5 Emissions = 0.00007 lb/ton · 0 ton/year · 1ton/2,000 lb . (100% - 0.85%) Control efficiency"},null,null,null,null,null,{"$f":"\"Total PM2.5 Emissions = \"&FIXED(G17,5,TRUE)&\" lb/ton · \"&FIXED(H25,0,TRUE)&\" ton/year · 1ton/2,000 lb . (100% - \"&H4&\"%) Control efficiency\"","v":"Total PM2.5 Emissions = 0.00007 lb/ton · 0 ton/year · 1ton/2,000 lb . (100% - 0.85%) Control efficiency"}]
["=",{"$f":"G17*B25/2000*(1-E4)","v":0},"ton/year",null,null,null,"=",{"$f":"G17*H25/2000*(1-H4)","v":0},"ton/year"]

{"sheet":"Datasets","index":3,"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]