{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Haul Roads","Datasets"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":25,"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":"Haul Roads","index":0,"n_rows":50,"n_cols":38,"rows_kept":50,"cut":false,"hidden":false,"merged":[[43,20,43,22],[44,20,44,22],[45,20,45,22],[46,20,46,22],[47,20,47,22],[48,20,48,22],[37,20,37,22],[38,20,38,22],[39,20,39,22],[40,20,40,22],[41,20,41,22],[42,20,42,22],[30,20,30,22],[30,23,30,24],[30,33,30,34],[30,37,30,38],[31,35,31,36],[33,23,35,25],[33,26,35,28],[28,20,28,22],[28,23,28,24],[28,33,28,34],[28,37,28,38],[29,20,29,22],[29,23,29,24],[29,33,29,34],[29,37,29,38],[27,20,27,22],[27,23,27,24],[27,33,27,34],[27,37,27,38],[24,20,24,22],[24,23,24,24],[24,33,24,34],[24,37,24,38],[25,20,25,22],[25,23,25,24],[25,33,25,34],[25,37,25,38],[20,23,20,24],[20,33,20,34],[20,37,20,38],[21,20,21,22],[21,23,21,24],[21,33,21,34],[21,37,21,38],[26,20,26,22],[26,23,26,24],[26,33,26,34],[26,37,26,38],[17,35,18,36],[17,37,18,38],[19,20,19,22],[19,23,19,24],[19,33,19,34],[19,37,19,38],[26,13,26,14],[24,13,24,14],[24,17,24,18],[20,13,20,14],[19,13,19,14],[17,17,18,18],[19,17,19,18],[20,17,20,18],[23,17,23,18],[22,20,22,22],[22,23,22,24],[22,33,22,34],[22,37,22,38],[23,20,23,22],[23,23,23,24],[23,33,23,34],[23,37,23,38],[20,20,20,22],[11,33,11,34],[12,33,12,34],[13,33,13,34],[14,33,14,34],[17,20,18,22],[17,23,18,24],[17,25,18,26],[17,27,17,28],[17,29,17,31],[17,32,18,32],[17,33,18,34],[48,0,48,2],[21,3,21,4],[22,3,22,4],[23,3,23,4],[25,3,25,4],[24,0,24,2],[29,0,29,2],[43,0,43,2],[25,0,25,2],[47,0,47,2],[46,0,46,2],[44,0,44,2],[45,0,45,2],[33,3,35,5],[30,3,30,4],[29,17,29,18],[33,6,35,8],[37,0,37,2],[38,0,38,2],[39,0,39,2],[21,0,21,2],[27,0,27,2],[42,0,42,2],[40,0,40,2],[41,0,41,2],[31,15,31,16],[28,0,28,2],[30,0,30,2],[30,13,30,14],[23,13,23,14],[30,17,30,18],[26,17,26,18],[21,17,21,18],[27,17,27,18],[28,17,28,18],[25,17,25,18],[22,17,22,18],[23,0,23,2],[27,3,27,4],[17,0,18,2],[17,5,18,6],[17,7,17,8],[17,9,17,11],[17,3,18,4],[19,3,19,4],[20,3,20,4],[22,0,22,2],[29,13,29,14],[28,3,28,4],[24,3,24,4],[29,3,29,4],[26,0,26,2],[26,3,26,4],[19,0,19,2],[20,0,20,2],[11,13,11,14],[12,13,12,14],[13,13,13,14],[14,13,14,14],[17,15,18,16],[17,12,18,12],[17,13,18,14],[21,13,21,14],[28,13,28,14],[27,13,27,14],[22,13,22,14],[25,13,25,14]]}
[]
["Universal Calculation Spreadsheets"]
["Haul Road Emissions"]
[]
[]
[]
["Paved roads  {AP-42 Chapter 13.2.1 (1/11)}",null,null,null,null,null,null,null,"Unpaved roads  {AP-42 Chapter 13.2.2 (11/06)}",null,null,null,null,null,null,null,null,null,null,null,"Paved roads  {AP-42 Chapter 13.2.1 (1/11)}",null,null,null,null,null,null,null,"Unpaved roads  {AP-42 Chapter 13.2.2 (11/06)}"]
[]
["Equation (2):",null,null,null,null,null,null,null,"Equation (1a):",null,null,null,null,null,null,null,null,null,null,null,"Equation (2):",null,null,null,null,null,null,null,"Equation (1a):"]
[null,null,null,null,null,null,null,null,"(Modified)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Modified)"]
[]
[null,null,"k",null,null,null,null,null,null,null,"k","a","b","d",null,null,null,null,null,null,null,null,"k",null,null,null,null,null,null,null,"k","a","b","d"]
[null,"PM",1.0999999999999999E-2,null,null,null,null,null,null,"PM",4.9000000000000004,0.7,0.45,0.3,null,null,null,null,null,null,null,"PM",1.0999999999999999E-2,null,null,null,null,null,null,"PM",4.9000000000000004,0.7,0.45,0.3]
[null,"PM10",2.2000000000000001E-3,null,null,null,null,null,null,"PM10",1.5,0.9,0.45,0.5,null,null,null,null,null,null,null,"PM10",2.2000000000000001E-3,null,null,null,null,null,null,"PM10",1.5,0.9,0.45,0.5]
[null,"PM2.5",5.4000000000000001E-4,null,null,null,null,null,null,"PM2.5",0.15,0.9,0.45,0.5,null,null,null,null,null,null,null,"PM2.5",5.4000000000000001E-4,null,null,null,null,null,null,"PM2.5",0.15,0.9,0.45,0.5]
[]
["Haul Road / Traffic Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haul Road / Traffic Parameters"]
["Activity / Road Description",null,null,"Input Road Type",null,"Road Type / Silt Value",null,"Roundtrip Length             (feet)",null,"Truck Weight        (tons)",null,null,"Ave. Speed (mph)","Unrestricted Maximum Throughput (units/yr)",null,"Ave. Truck Capacity (units/truck)",null,"Annual VMT",null,null,"Activity / Road Description",null,null,"Input Road Type",null,"Road Type / Silt Value",null,"Roundtrip Length             (feet)",null,"Truck Weight        (tons)",null,null,"Ave. Speed (mph)","Unrestricted Maximum Throughput (units/yr)",null,"Ave. Truck Capacity (units/truck)",null,"Annual VMT"]
[null,null,null,null,null,null,null,"empty","full","empty","full","Ave.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"empty","full","empty","full","Ave."]
["Raw Material 1 Delivery",null,null,null,null,{"$f":"IF(D20=\"\",\"\",IF(OR(D20=Datasets!$AI$2,D20=Datasets!$AI$3,D20=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D20=\"\",\"\",IF(OR(D20=Datasets!$AI$2,D20=Datasets!$AI$5),3,IF(OR(D20=Datasets!$AI$3,D20=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,{"$f":"IF(H20+I20=0,\"\",(H20*J20+I20*K20)/(H20+I20))","v":""},15,null,null,28,"ton",{"$f":"IF(H20+I20=0,\"-\",(N20/P20)*((H20+I20)/5280))","v":"-"},null,null,"Raw Material 1 Delivery",null,null,null,null,{"$f":"IF(X20=\"\",\"\",IF(OR(X20=Datasets!$AI$2,X20=Datasets!$AI$3,X20=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X20=\"\",\"\",IF(OR(X20=Datasets!$AI$2,X20=Datasets!$AI$5),3,IF(OR(X20=Datasets!$AI$3,X20=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,{"$f":"IF(AB20+AC20=0,\"\",(AB20*AD20+AC20*AE20)/(AB20+AC20))","v":""},15,null,null,28,"ton",{"$f":"IF(AB20+AC20=0,\"-\",(AH20/AJ20)*((AB20+AC20)/5280))","v":"-"}]
["Raw Material 2 Delivery",null,null,null,null,{"$f":"IF(D21=\"\",\"\",IF(OR(D21=Datasets!$AI$2,D21=Datasets!$AI$3,D21=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D21=\"\",\"\",IF(OR(D21=Datasets!$AI$2,D21=Datasets!$AI$5),3,IF(OR(D21=Datasets!$AI$3,D21=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,28,"ton",{"$f":"IF(H21+I21=0,\"-\",(N21/P21)*((H21+I21)/5280))","v":"-"},null,null,"Raw Material 2 Delivery",null,null,null,null,{"$f":"IF(X21=\"\",\"\",IF(OR(X21=Datasets!$AI$2,X21=Datasets!$AI$3,X21=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X21=\"\",\"\",IF(OR(X21=Datasets!$AI$2,X21=Datasets!$AI$5),3,IF(OR(X21=Datasets!$AI$3,X21=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,28,"ton",{"$f":"IF(AB21+AC21=0,\"-\",(AH21/AJ21)*((AB21+AC21)/5280))","v":"-"}]
["Product 1 Shipping",null,null,null,null,{"$f":"IF(D22=\"\",\"\",IF(OR(D22=Datasets!$AI$2,D22=Datasets!$AI$3,D22=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D22=\"\",\"\",IF(OR(D22=Datasets!$AI$2,D22=Datasets!$AI$5),3,IF(OR(D22=Datasets!$AI$3,D22=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,28,"ton",{"$f":"IF(H22+I22=0,\"-\",(N22/P22)*((H22+I22)/5280))","v":"-"},null,null,"Product 1 Shipping",null,null,null,null,{"$f":"IF(X22=\"\",\"\",IF(OR(X22=Datasets!$AI$2,X22=Datasets!$AI$3,X22=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X22=\"\",\"\",IF(OR(X22=Datasets!$AI$2,X22=Datasets!$AI$5),3,IF(OR(X22=Datasets!$AI$3,X22=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,28,"ton",{"$f":"IF(AB22+AC22=0,\"-\",(AH22/AJ22)*((AB22+AC22)/5280))","v":"-"}]
["Product 2 Shipping",null,null,null,null,{"$f":"IF(D23=\"\",\"\",IF(OR(D23=Datasets!$AI$2,D23=Datasets!$AI$3,D23=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D23=\"\",\"\",IF(OR(D23=Datasets!$AI$2,D23=Datasets!$AI$5),3,IF(OR(D23=Datasets!$AI$3,D23=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,7900,"ton","-",null,null,"Product 2 Shipping",null,null,null,null,{"$f":"IF(X23=\"\",\"\",IF(OR(X23=Datasets!$AI$2,X23=Datasets!$AI$3,X23=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X23=\"\",\"\",IF(OR(X23=Datasets!$AI$2,X23=Datasets!$AI$5),3,IF(OR(X23=Datasets!$AI$3,X23=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,7900,"ton","-"]
["Other1",null,null,null,null,{"$f":"IF(D24=\"\",\"\",IF(OR(D24=Datasets!$AI$2,D24=Datasets!$AI$3,D24=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D24=\"\",\"\",IF(OR(D24=Datasets!$AI$2,D24=Datasets!$AI$5),3,IF(OR(D24=Datasets!$AI$3,D24=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,7900,"gal","-",null,null,"Other1",null,null,null,null,{"$f":"IF(X24=\"\",\"\",IF(OR(X24=Datasets!$AI$2,X24=Datasets!$AI$3,X24=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X24=\"\",\"\",IF(OR(X24=Datasets!$AI$2,X24=Datasets!$AI$5),3,IF(OR(X24=Datasets!$AI$3,X24=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,7900,"gal","-"]
["Other2",null,null,null,null,{"$f":"IF(D25=\"\",\"\",IF(OR(D25=Datasets!$AI$2,D25=Datasets!$AI$3,D25=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D25=\"\",\"\",IF(OR(D25=Datasets!$AI$2,D25=Datasets!$AI$5),3,IF(OR(D25=Datasets!$AI$3,D25=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,28,"ton",{"$f":"IF(H25+I25=0,\"-\",(N25/P25)*((H25+I25)/5280))","v":"-"},null,null,"Other2",null,null,null,null,{"$f":"IF(X25=\"\",\"\",IF(OR(X25=Datasets!$AI$2,X25=Datasets!$AI$3,X25=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X25=\"\",\"\",IF(OR(X25=Datasets!$AI$2,X25=Datasets!$AI$5),3,IF(OR(X25=Datasets!$AI$3,X25=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,28,"ton",{"$f":"IF(AB25+AC25=0,\"-\",(AH25/AJ25)*((AB25+AC25)/5280))","v":"-"}]
["Other3",null,null,null,null,{"$f":"IF(D26=\"\",\"\",IF(OR(D26=Datasets!$AI$2,D26=Datasets!$AI$3,D26=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D26=\"\",\"\",IF(OR(D26=Datasets!$AI$2,D26=Datasets!$AI$5),3,IF(OR(D26=Datasets!$AI$3,D26=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,8150,"gal",{"$f":"IF(H26+I26=0,\"-\",(N26/P26)*((H26+I26)/5280))","v":"-"},null,null,"Other3",null,null,null,null,{"$f":"IF(X26=\"\",\"\",IF(OR(X26=Datasets!$AI$2,X26=Datasets!$AI$3,X26=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X26=\"\",\"\",IF(OR(X26=Datasets!$AI$2,X26=Datasets!$AI$5),3,IF(OR(X26=Datasets!$AI$3,X26=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,8150,"gal",{"$f":"IF(AB26+AC26=0,\"-\",(AH26/AJ26)*((AB26+AC26)/5280))","v":"-"}]
["Other4",null,null,null,null,{"$f":"IF(D27=\"\",\"\",IF(OR(D27=Datasets!$AI$2,D27=Datasets!$AI$3,D27=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D27=\"\",\"\",IF(OR(D27=Datasets!$AI$2,D27=Datasets!$AI$5),3,IF(OR(D27=Datasets!$AI$3,D27=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,1500,"gal","-",null,null,"Other4",null,null,null,null,{"$f":"IF(X27=\"\",\"\",IF(OR(X27=Datasets!$AI$2,X27=Datasets!$AI$3,X27=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X27=\"\",\"\",IF(OR(X27=Datasets!$AI$2,X27=Datasets!$AI$5),3,IF(OR(X27=Datasets!$AI$3,X27=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,1500,"gal","-"]
["Other5",null,null,null,null,{"$f":"IF(D28=\"\",\"\",IF(OR(D28=Datasets!$AI$2,D28=Datasets!$AI$3,D28=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D28=\"\",\"\",IF(OR(D28=Datasets!$AI$2,D28=Datasets!$AI$5),3,IF(OR(D28=Datasets!$AI$3,D28=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,5000,"gal","-",null,null,"Other5",null,null,null,null,{"$f":"IF(X28=\"\",\"\",IF(OR(X28=Datasets!$AI$2,X28=Datasets!$AI$3,X28=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X28=\"\",\"\",IF(OR(X28=Datasets!$AI$2,X28=Datasets!$AI$5),3,IF(OR(X28=Datasets!$AI$3,X28=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,5000,"gal","-"]
["Other6",null,null,null,null,{"$f":"IF(D29=\"\",\"\",IF(OR(D29=Datasets!$AI$2,D29=Datasets!$AI$3,D29=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D29=\"\",\"\",IF(OR(D29=Datasets!$AI$2,D29=Datasets!$AI$5),3,IF(OR(D29=Datasets!$AI$3,D29=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,2900,"gal",{"$f":"IF(H29+I29=0,\"-\",(N29/P29)*((H29+I29)/5280))","v":"-"},null,null,"Other6",null,null,null,null,{"$f":"IF(X29=\"\",\"\",IF(OR(X29=Datasets!$AI$2,X29=Datasets!$AI$3,X29=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X29=\"\",\"\",IF(OR(X29=Datasets!$AI$2,X29=Datasets!$AI$5),3,IF(OR(X29=Datasets!$AI$3,X29=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,2900,"gal",{"$f":"IF(AB29+AC29=0,\"-\",(AH29/AJ29)*((AB29+AC29)/5280))","v":"-"}]
["Other7",null,null,null,null,{"$f":"IF(D30=\"\",\"\",IF(OR(D30=Datasets!$AI$2,D30=Datasets!$AI$3,D30=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D30=\"\",\"\",IF(OR(D30=Datasets!$AI$2,D30=Datasets!$AI$5),3,IF(OR(D30=Datasets!$AI$3,D30=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,{"$f":"IF(H30+I30=0,\"\",(H30*J30+I30*K30)/(H30+I30))","v":""},15,null,null,28,"ton",{"$f":"IF(H30+I30=0,\"-\",(N30/P30)*((H30+I30)/5280))","v":"-"},null,null,"Other7",null,null,null,null,{"$f":"IF(X30=\"\",\"\",IF(OR(X30=Datasets!$AI$2,X30=Datasets!$AI$3,X30=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X30=\"\",\"\",IF(OR(X30=Datasets!$AI$2,X30=Datasets!$AI$5),3,IF(OR(X30=Datasets!$AI$3,X30=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,{"$f":"IF(AB30+AC30=0,\"\",(AB30*AD30+AC30*AE30)/(AB30+AC30))","v":""},15,null,null,28,"ton",{"$f":"IF(AB30+AC30=0,\"-\",(AH30/AJ30)*((AB30+AC30)/5280))","v":"-"}]
["Other8",null,null,null,null,{"$f":"IF(D31=\"\",\"\",IF(OR(D31=Datasets!$AI$2,D31=Datasets!$AI$3,D31=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(D31=\"\",\"\",IF(OR(D31=Datasets!$AI$2,D31=Datasets!$AI$5),3,IF(OR(D31=Datasets!$AI$3,D31=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,28,"ton",{"$f":"IF(H31+I31=0,\"-\",(N31/P31)*((H31+I31)/5280))","v":"-"},null,null,"Other8",null,null,null,null,{"$f":"IF(X31=\"\",\"\",IF(OR(X31=Datasets!$AI$2,X31=Datasets!$AI$3,X31=Datasets!$AI$4),\"U\",\"P\"))","v":""},{"$f":"IF(X31=\"\",\"\",IF(OR(X31=Datasets!$AI$2,X31=Datasets!$AI$5),3,IF(OR(X31=Datasets!$AI$3,X31=Datasets!$AI$6),6,10)))","v":""},null,null,15,40,"",15,null,null,28,"ton",{"$f":"IF(AB31+AC31=0,\"-\",(AH31/AJ31)*((AB31+AC31)/5280))","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total VMT:",{"$f":"SUM(R20:S31)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total VMT:",{"$f":"SUM(AL20:AM31)","v":0}]
[null,null,null,"Emission Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emission Calculations"]
[null,null,null,"Emission Factors (lb/VMT)",null,null,"Potential Emissions\n(tons/yr)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emission Factors (lb/VMT)",null,null,"Potential Emissions\n(tons/yr)"]
[null,null,null,null,null,null,null,null,null,null,"Description of Constants/Variables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Description of Constants/Variables"]
[null,null,null,null,null,null,null,null,null,null,"E:","haul road emissions (lb/VMT)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E:","haul road emissions (lb/VMT)"]
[null,null,null,"PM","PM10","PM2.5","PM","PM10","PM2.5",null,"k, d:","dimensionless constants from Draft AP-42",null,null,null,null,null,null,null,null,null,null,null,"PM","PM10","PM2.5","PM","PM10","PM2.5",null,"k, d:","dimensionless constants from Draft AP-42"]
[{"$f":"IF(A20=\"\",\"\",A20)","v":"Raw Material 1 Delivery"},null,null,{"$f":"IF($F20=\"p\",IF($M20>=1,$C$13*($G20^0.91)*($L20^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F20=\"u\",IF(M20>=10,$K$13*(($G20/12)^$L$13)*(($L20/3)^$M$13)*((365-$M$45)/365)*(($M20/30)^$N$13)*(1-$M$49/100),\"error\"),IF($F20=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F20=\"p\",IF($M20>=1,$C$14*($G20^0.91)*($L20^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F20=\"u\",IF(M20>=10,$K$14*(($G20/12)^$L$14)*(($L20/3)^$M$14)*((365-$M$45)/365)*(($M20/30)^$N$14)*(1-$M$49/100),\"error\"),IF($F20=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F20=\"p\",IF($M20>=1,$C$15*($G20^0.91)*($L20^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F20=\"u\",IF(M20>=10,$K$15*(($G20/12)^$L$15)*(($L20/3)^$M$15)*((365-$M$45)/365)*(($M20/30)^$N$15)*(1-$M$49/100),\"error\"),IF($F20=\"\",\"\",\"error\")))","v":""},{"$f":"IF(D38=\"\",\"\",$R20*D38/2000)","v":""},"","",null,null,"  Chapter 13.IV (paved)",null,null,null,null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",U20)","v":"Raw Material 1 Delivery"},null,null,{"$f":"IF($Z20=\"p\",IF($AG20>=1,$W$13*($AA20^0.91)*($AF20^1.02)*(1-($AG$45/(4*365))),\"error\"),IF($Z20=\"u\",IF(AG20>=10,$AE$13*(($AA20/12)^$AF$13)*(($AF20/3)^$AG$13)*((365-$AG$45)/365)*(($AG20/30)^$AH$13)*(1-$AG$49/100),\"error\"),IF($Z20=\"\",\"\",\"error\")))","v":""},{"$f":"IF($Z20=\"p\",IF($AG20>=1,$W$14*($AA20^0.91)*($AF20^1.02)*(1-($AG$45/(4*365))),\"error\"),IF($Z20=\"u\",IF(AG20>=10,$AE$14*(($AA20/12)^$AF$14)*(($AF20/3)^$AG$14)*((365-$AG$45)/365)*(($AG20/30)^$AH$14)*(1-$AG$49/100),\"error\"),IF($Z20=\"\",\"\",\"error\")))","v":""},{"$f":"IF($Z20=\"p\",IF($AG20>=1,$W$15*($AA20^0.91)*($AF20^1.02)*(1-($AG$45/(4*365))),\"error\"),IF($Z20=\"u\",IF(AG20>=10,$AE$15*(($AA20/12)^$AF$15)*(($AF20/3)^$AG$15)*((365-$AG$45)/365)*(($AG20/30)^$AH$15)*(1-$AG$49/100),\"error\"),IF($Z20=\"\",\"\",\"error\")))","v":""},{"$f":"IF(X38=\"\",\"\",$AL20*X38/2000)","v":""},{"$f":"IF(Y38=\"\",\"\",$AL20*Y38/2000)","v":""},{"$f":"IF(Z38=\"\",\"\",$AL20*Z38/2000)","v":""},null,null,"  Chapter 13.IV (paved)"]
[{"$f":"IF(A21=\"\",\"\",A21)","v":"Raw Material 2 Delivery"},null,null,{"$f":"IF($F21=\"p\",IF($M21>=1,$C$13*($G21^0.91)*($L21^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F21=\"u\",IF(M21>=10,$K$13*(($G21/12)^$L$13)*(($L21/3)^$M$13)*((365-$M$45)/365)*(($M21/30)^$N$13)*(1-$M$49/100),\"error\"),IF($F21=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F21=\"p\",IF($M21>=1,$C$14*($G21^0.91)*($L21^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F21=\"u\",IF(M21>=10,$K$14*(($G21/12)^$L$14)*(($L21/3)^$M$14)*((365-$M$45)/365)*(($M21/30)^$N$14)*(1-$M$49/100),\"error\"),IF($F21=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F21=\"p\",IF($M21>=1,$C$15*($G21^0.91)*($L21^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F21=\"u\",IF(M21>=10,$K$15*(($G21/12)^$L$15)*(($L21/3)^$M$15)*((365-$M$45)/365)*(($M21/30)^$N$15)*(1-$M$49/100),\"error\"),IF($F21=\"\",\"\",\"error\")))","v":""},"","","",null,"k, a, b, c, d:","dimensionless constants from AP-42",null,null,null,null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",U21)","v":"Raw Material 2 Delivery"},null,null,{"$f":"IF($Z21=\"p\",IF($AG21>=1,$W$13*($AA21^0.91)*($AF21^1.02)*(1-($AG$45/(4*365))),\"error\"),IF($Z21=\"u\",IF(AG21>=10,$AE$13*(($AA21/12)^$AF$13)*(($AF21/3)^$AG$13)*((365-$AG$45)/365)*(($AG21/30)^$AH$13)*(1-$AG$49/100),\"error\"),IF($Z21=\"\",\"\",\"error\")))","v":""},{"$f":"IF($Z21=\"p\",IF($AG21>=1,$W$14*($AA21^0.91)*($AF21^1.02)*(1-($AG$45/(4*365))),\"error\"),IF($Z21=\"u\",IF(AG21>=10,$AE$14*(($AA21/12)^$AF$14)*(($AF21/3)^$AG$14)*((365-$AG$45)/365)*(($AG21/30)^$AH$14)*(1-$AG$49/100),\"error\"),IF($Z21=\"\",\"\",\"error\")))","v":""},{"$f":"IF($Z21=\"p\",IF($AG21>=1,$W$15*($AA21^0.91)*($AF21^1.02)*(1-($AG$45/(4*365))),\"error\"),IF($Z21=\"u\",IF(AG21>=10,$AE$15*(($AA21/12)^$AF$15)*(($AF21/3)^$AG$15)*((365-$AG$45)/365)*(($AG21/30)^$AH$15)*(1-$AG$49/100),\"error\"),IF($Z21=\"\",\"\",\"error\")))","v":""},{"$f":"IF(X39=\"\",\"\",$AL21*X39/2000)","v":""},"","",null,"k, a, b, c, d:","dimensionless constants from AP-42"]
[{"$f":"IF(A22=\"\",\"\",A22)","v":"Product 1 Shipping"},null,null,{"$f":"IF($F22=\"p\",IF($M22>=1,$C$13*($G22^0.91)*($L22^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F22=\"u\",IF(M22>=10,$K$13*(($G22/12)^$L$13)*(($L22/3)^$M$13)*((365-$M$45)/365)*(($M22/30)^$N$13)*(1-$M$49/100),\"error\"),IF($F22=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F22=\"p\",IF($M22>=1,$C$14*($G22^0.91)*($L22^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F22=\"u\",IF(M22>=10,$K$14*(($G22/12)^$L$14)*(($L22/3)^$M$14)*((365-$M$45)/365)*(($M22/30)^$N$14)*(1-$M$49/100),\"error\"),IF($F22=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F22=\"p\",IF($M22>=1,$C$15*($G22^0.91)*($L22^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F22=\"u\",IF(M22>=10,$K$15*(($G22/12)^$L$15)*(($L22/3)^$M$15)*((365-$M$45)/365)*(($M22/30)^$N$15)*(1-$M$49/100),\"error\"),IF($F22=\"\",\"\",\"error\")))","v":""},"","","",null,null,"  Tables 13.2.1-1 & 13.2.2-2 (unpaved)",null,null,null,null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",U22)","v":"Product 1 Shipping"},null,null,"","","",{"$f":"IF(X40=\"\",\"\",$AL22*X40/2000)","v":""},"","",null,null,"  Tables 13.2.1-1 & 13.2.2-2 (unpaved)"]
[{"$f":"IF(A23=\"\",\"\",A23)","v":"Product 2 Shipping"},null,null,{"$f":"IF($F23=\"p\",IF($M23>=1,$C$13*($G23^0.91)*($L23^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F23=\"u\",IF(M23>=10,$K$13*(($G23/12)^$L$13)*(($L23/3)^$M$13)*((365-$M$45)/365)*(($M23/30)^$N$13)*(1-$M$49/100),\"error\"),IF($F23=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F23=\"p\",IF($M23>=1,$C$14*($G23^0.91)*($L23^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F23=\"u\",IF(M23>=10,$K$14*(($G23/12)^$L$14)*(($L23/3)^$M$14)*((365-$M$45)/365)*(($M23/30)^$N$14)*(1-$M$49/100),\"error\"),IF($F23=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F23=\"p\",IF($M23>=1,$C$15*($G23^0.91)*($L23^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F23=\"u\",IF(M23>=10,$K$15*(($G23/12)^$L$15)*(($L23/3)^$M$15)*((365-$M$45)/365)*(($M23/30)^$N$15)*(1-$M$49/100),\"error\"),IF($F23=\"\",\"\",\"error\")))","v":""},"","","",null,"sL:","silt loading (g/m2) of paved road surface",null,null,null,null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",U23)","v":"Product 2 Shipping"},null,null,"","","",{"$f":"IF(X41=\"\",\"\",$AL23*X41/2000)","v":""},"","",null,"sL:","silt loading (g/m2) of paved road surface"]
[{"$f":"IF(A24=\"\",\"\",A24)","v":"Other1"},null,null,{"$f":"IF($F24=\"p\",IF($M24>=1,$C$13*($G24^0.91)*($L24^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F24=\"u\",IF(M24>=10,$K$13*(($G24/12)^$L$13)*(($L24/3)^$M$13)*((365-$M$45)/365)*(($M24/30)^$N$13)*(1-$M$49/100),\"error\"),IF($F24=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F24=\"p\",IF($M24>=1,$C$14*($G24^0.91)*($L24^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F24=\"u\",IF(M24>=10,$K$14*(($G24/12)^$L$14)*(($L24/3)^$M$14)*((365-$M$45)/365)*(($M24/30)^$N$14)*(1-$M$49/100),\"error\"),IF($F24=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F24=\"p\",IF($M24>=1,$C$15*($G24^0.91)*($L24^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F24=\"u\",IF(M24>=10,$K$15*(($G24/12)^$L$15)*(($L24/3)^$M$15)*((365-$M$45)/365)*(($M24/30)^$N$15)*(1-$M$49/100),\"error\"),IF($F24=\"\",\"\",\"error\")))","v":""},"","","",null,"sC:","silt content (%) of unpaved road surface",null,null,null,null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",U24)","v":"Other1"},null,null,"","","",{"$f":"IF(X42=\"\",\"\",$AL24*X42/2000)","v":""},"","",null,"sC:","silt content (%) of unpaved road surface"]
[{"$f":"IF(A25=\"\",\"\",A25)","v":"Other2"},null,null,{"$f":"IF($F25=\"p\",IF($M25>=1,$C$13*($G25^0.91)*($L25^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F25=\"u\",IF(M25>=10,$K$13*(($G25/12)^$L$13)*(($L25/3)^$M$13)*((365-$M$45)/365)*(($M25/30)^$N$13)*(1-$M$49/100),\"error\"),IF($F25=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F25=\"p\",IF($M25>=1,$C$14*($G25^0.91)*($L25^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F25=\"u\",IF(M25>=10,$K$14*(($G25/12)^$L$14)*(($L25/3)^$M$14)*((365-$M$45)/365)*(($M25/30)^$N$14)*(1-$M$49/100),\"error\"),IF($F25=\"\",\"\",\"error\")))","v":""},{"$f":"IF($F25=\"p\",IF($M25>=1,$C$15*($G25^0.91)*($L25^1.02)*(1-($M$45/(4*365))),\"error\"),IF($F25=\"u\",IF(M25>=10,$K$15*(($G25/12)^$L$15)*(($L25/3)^$M$15)*((365-$M$45)/365)*(($M25/30)^$N$15)*(1-$M$49/100),\"error\"),IF($F25=\"\",\"\",\"error\")))","v":""},{"$f":"IF(D43=\"\",\"\",$R25*D43/2000)","v":""},"","",null,"W:","average vehicle weight (tons)",null,null,null,null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",U25)","v":"Other2"},null,null,"","","",{"$f":"IF(X43=\"\",\"\",$AL25*X43/2000)","v":""},"","",null,"W:","average vehicle weight (tons)"]
["Other3",null,null,"","","",{"$f":"IF(D44=\"\",\"\",$R26*D44/2000)","v":""},"","",null,"P:","days/yr with at least 0.01\" of precipitation",null,null,null,null,null,null,null,null,"Other3",null,null,"","","",{"$f":"IF(X44=\"\",\"\",$AL26*X44/2000)","v":""},"","",null,"P:","days/yr with at least 0.01\" of precipitation"]
["Other4",null,null,"","","",{"$f":"IF(D45=\"\",\"\",$R27*D45/2000)","v":""},"","",null,null,"P =",90,"   default = 90",null,null,null,null,null,null,"Other4",null,null,"","","",{"$f":"IF(X45=\"\",\"\",$AL27*X45/2000)","v":""},"","",null,null,"P =",90,"   default = 90"]
["Other5",null,null,"","","",{"$f":"IF(D46=\"\",\"\",$R28*D46/2000)","v":""},"","",null,"S:","mean vehicle speed on road (mph)",null,null,null,null,null,null,null,null,"Other5",null,null,"","","",{"$f":"IF(X46=\"\",\"\",$AL28*X46/2000)","v":""},"","",null,"S:","mean vehicle speed on road (mph)"]
["Other6",null,null,"","","",{"$f":"IF(D47=\"\",\"\",$R29*D47/2000)","v":""},"","",null,null,"   default = 30, minimum =15",null,null,null,null,null,null,null,null,"Other6",null,null,"","","",{"$f":"IF(X47=\"\",\"\",$AL29*X47/2000)","v":""},"","",null,null,"   default = 30, minimum =15"]
["Other7",null,null,"","","",{"$f":"IF(D48=\"\",\"\",$R30*D48/2000)","v":""},"","",null,"CE:","unpaved road, dust control efficiency",null,null,null,null,null,null,null,null,"Other7",null,null,"","","",{"$f":"IF(X48=\"\",\"\",$AL30*X48/2000)","v":""},"","",null,"CE:","unpaved road, dust control efficiency"]
["Other8",null,null,"","","",{"$f":"IF(D49=\"\",\"\",$R31*D49/2000)","v":""},"","",null,null,"CE =",0,"   default = 0%",null,null,null,null,null,null,"Other8",null,null,"","","",{"$f":"IF(X49=\"\",\"\",$AL31*X49/2000)","v":""},"","",null,null,"CE =",0,"   default = 0%"]
[null,null,null,null,null,"Total Annual Emissions:",{"$f":"SUM(G38:G49)","v":0},{"$f":"SUM(H38:H49)","v":0},{"$f":"SUM(I38:I49)","v":0},null,"VMT:","vehicle miles traveled",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Annual Emissions:",{"$f":"SUM(AA38:AA49)","v":0},{"$f":"SUM(AB38:AB49)","v":0},{"$f":"SUM(AC38:AC49)","v":0},null,"VMT:","vehicle miles traveled"]

{"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]