{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Bioreactor Design","Conductivity","Example Design","References","Notes"],"not_rendered":{"charts":0,"images":13,"macros":0,"external_links":0,"defined_names":2,"comments":2,"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":"Bioreactor Design","index":0,"n_rows":46,"n_cols":26,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,7,1,9],[11,9,11,11],[37,1,43,3],[11,2,11,3],[10,13,10,16],[2,8,2,9],[3,8,3,9],[2,5,2,6],[3,5,3,6],[7,9,8,11],[4,5,4,6],[4,8,4,9]]}
[]
[null,"USDA- Natural Resources Conservation Service",null,null,null,null,null,"MD Version 1.6 - 4_14_20"]
[null,"Project Name",null,null,"Designed by:",null,null,"Date:"]
[null,"Site Location",null,null,"Checked by:",null,null,"Date:"]
[null,"County",null,null,"Approved by:",null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drain capacity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,{"$f":"IF(D14>0,D14*0.15,10000)","v":10000},"Option 1"]
[null,"Determine Design Capacity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CPT",null,null,{"$f":"IF(I11>0,I11*0.15,10000)","v":10000},"Option 2"]
[null,"Option 1 - Mainline Configuration",null,null,null,"Option 2 - Drainage Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Dual Wall",null,null,{"$f":"IF(I14>0,I14*0.15,10000)","v":10000},"Option 3"]
[null,"Mainline tile size (in)",null,null,null,"Drainage area of tile system (ac)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Clay or Concrete",null,null,{"$f":"IF(K10>0,K10,10000)","v":10000},"Option 4"]
[null,"Mainline tile grade (%)",null,null,null,"Drainage coefficient (inches/day)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(Y6:Y9)","v":10000}]
[null,"Mainline tile material",null,null,null,"Capacity of drainage system ",null,null,{"$f":"I9*I10*43560/12/24/3600","v":0}]
[null,null,{"$f":"IF(U6=2,0.012,IF(U6=3, 0.013,X14))","v":1.4999999999999999E-2}]
[null,"Peak velocity in mainline given size and grade",null,{"$f":"1.49*(D10/100)^0.5*((Y14/12/4)^(2/3))/C12","v":0},null,"Option 3 - Direct Entry (from model or other source)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"selected","n","tile size","inlet area(Perf)"]
[null,"Peak flow from mainline size and grade",null,{"$f":"+D13*PI()*(Y14/2/12)^2","v":0},null,"Capacity of drainage system (cfs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPT",null,3,{"$f":"INDEX(W19:W27,W14)","v":1.4999999999999999E-2},{"$f":"INDEX(U19:U27,W14)","v":6},{"$f":"INDEX(X19:X27,W14)","v":1}]
[]
[null,"Design Capacity:",null,{"$f":"IF(Y10=10000,0,Y10)","v":0},"(15% of Option 1, 2, or 3 - or 100% of Option 4 - whichever is lowest)"]
[null,"Size Bioreactor:"]
[null,"Design type (soil cover or open type)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tile Dia. (in.)",null,"n","area (in2/ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,1.4999999999999999E-2,1]
[null,"Conductivity of wood media (ft/s)",null,{"$f":"Conductivity!AJ74/2.54/12","v":9.6420239136774555E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,1.4999999999999999E-2,1]
[null,"Porosity of wood media (decimal %)",null,{"$f":"INDEX(V43:X45,U39,Y35)","v":0.53},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,1.4999999999999999E-2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,1.6E-2,1]
[null,"Flow length, L (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.7000000000000001E-2,1]
[null,"Trench width, W (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,1.7999999999999999E-2,1.5]
[null,"Inlet stop log height above trench bottom (in)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,1.7999999999999999E-2,1.5]
[null,"Outlet stop log height above trench bottom (in)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,0.02,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,0.02,1.5]
[null,"Average flow depth (ft)",null,{"$f":"(D25+D26)/2/12","v":0}]
[null,"Hydraulic gradient (ft/ft)",null,{"$f":"IF(D23>0,(D25-D26)/12/D23,\"\")","v":""}]
[]
[null,"Loading density (Acres per 100 sq.ft. bioreactor)",null,{"$f":"IF(AND(D23>0,D24>0),I9/(D23*D24/100),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: University of Illinois bioreactor design software"]
[null,"Estimated load reduction (%)",null,{"$f":"IF(AND(ISNUMBER(D31),D31>0),95.42/D31^0.435,\"\")","v":""},"minimum 30%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydraulic Conductivity (ft/s)"]
[null,"Hydraulic retention time (hours)",null,{"$f":"IF(AND(D35>0,ISNUMBER(D35)),D23*D24*D28*D21/D35/(60*60),\"\")","v":""},"minimum 3 hrs"]
[null,"Bioreactor flow capacity (cfs)",null,{"$f":"IF(AND(D28>0,D16>0),MIN(D20*D29*(D24*D28),D14),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of woodchip","No soil on top","1 ft of soil","2 ft of soil",1,{"$f":"V35","v":"No soil on top"}]
[null,"% of design capacity",null,{"$f":"IF(AND(ISNUMBER(D35),D16>0),D35/D16*100,\"\")","v":""},"target 100%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardwood",{"$f":"0.97/2.54/12","v":3.1824146981627298E-2},{"$f":"0.84/2.54/12","v":2.7559055118110232E-2},{"$f":"0.94/2.54/12","v":3.0839895013123356E-2},null,{"$f":"W35","v":"1 ft of soil"}]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shredded",{"$f":"0.69/2.54/12","v":2.2637795275590549E-2},{"$f":"0.61/2.54/12","v":2.001312335958005E-2},{"$f":"0.6/2.54/12","v":1.968503937007874E-2},null,{"$f":"X35","v":"2 ft of soil"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed",{"$f":"0.69/2.54/12","v":2.2637795275590549E-2},{"$f":"0.59/2.54/12","v":1.9356955380577426E-2},{"$f":"0.53/2.54/12","v":1.7388451443569555E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porosity (decimal %)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of woodchip","No soil on top","1 ft of soil","2 ft of soil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardwood",0.59,0.55000000000000004,0.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shredded",0.64,0.6,0.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed",0.53,0.47,0.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]

{"sheet":"Conductivity","index":1,"n_rows":74,"n_cols":36,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"Source: University of Illinois bioreactor design software"]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,1,"CPT"]
[null,null,null,null,null,null,2,"Dual Wall"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Chipometer data"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average for vanDriel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,"Hydraulic Conductivity (ft/s)"]
[]
[null,"Type of woodchip","No soil on top","1 ft of soil","2 ft of soil",1,{"$f":"C27","v":"No soil on top"},null,null,"NOTE: a wide variety of hydraulic conductivities exist."]
[null,"Hardwood",{"$f":"0.97/2.54/12","v":3.1824146981627298E-2},{"$f":"0.84/2.54/12","v":2.7559055118110232E-2},{"$f":"0.94/2.54/12","v":3.0839895013123356E-2},null,{"$f":"D27","v":"1 ft of soil"},null,null,"Go with the field data rather than the chipometer (horizontal vs vertical)"]
[null,"Shredded",{"$f":"0.69/2.54/12","v":2.2637795275590549E-2},{"$f":"0.61/2.54/12","v":2.001312335958005E-2},{"$f":"0.6/2.54/12","v":1.968503937007874E-2},null,{"$f":"E27","v":"2 ft of soil"},null,null,"Use vanDriel; it is much lower than the Chun data (more conservative)."]
[null,"Mixed",{"$f":"0.69/2.54/12","v":2.2637795275590549E-2},{"$f":"0.59/2.54/12","v":1.9356955380577426E-2},{"$f":"0.53/2.54/12","v":1.7388451443569555E-2}]
[null,3]
[]
[null,"Porosity (decimal %)"]
[null,"Type of woodchip","No soil on top","1 ft of soil","2 ft of soil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Averages"]
[null,"Hardwood",0.59,0.55000000000000004,0.54]
[null,"Shredded",0.64,0.6,0.59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3.9+3.95+3.46)/3","v":3.7699999999999996}]
[null,"Mixed",0.53,0.47,0.47]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3.56+3.71+3.68)/3","v":3.65}]
[null,null,null,"selected","n","tile size","inlet area(Perf)"]
[null,"CPT",null,5,{"$f":"INDEX(D44:D52,D42)","v":1.4999999999999999E-2},{"$f":"INDEX(B44:B52,D42)","v":10},{"$f":"INDEX(E44:E52,D42)","v":1},null,"ADS Tech Note 1.02",null,"Oct. 2008","http://www.ads-pipe.com/pdf/en/A1.02-Single_Wall_Perf_Patterns.pdf "]
[null,"Tile Dia. (in.)",null,"n","area (in2/ft)"]
[null,4,null,1.4999999999999999E-2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3.57+3.4+3.06)/3","v":3.3433333333333333}]
[null,5,null,1.4999999999999999E-2,1]
[null,6,null,1.4999999999999999E-2,1]
[null,8,null,1.4999999999999999E-2,1]
[null,10,null,1.4999999999999999E-2,1]
[null,12,null,1.7000000000000001E-2,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3.47+2.8+2.52)/3","v":2.9299999999999997}]
[null,15,null,0.02,1.5]
[null,18,null,0.02,1.5]
[null,21,null,0.02,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(2.5+2.78+2.94)/3","v":2.7399999999999998}]
[null,"Note: bioreactor flow rate will depend on:"]
[null,"1. hydraulic conductivity of wood chips",null,null,null,{"$f":"#REF!*#REF!*(#REF!*#REF!)","v":{"$error":"#REF!"}},"cfs"]
[null,"2. flow capacity of collector manifold",null,null,null,"*"]
[null,"3. flow capacity of outlet pipe",null,null,null,{"$f":"1.49*(#REF!)^0.5*((6/12/4)^(2/3))/0.015","v":{"$error":"#REF!"}},"assume 6\" dia"]
[null,"4. flow received from drainage tile system"]
[null,null,null,null,null,null,null,null,"* Assume that the collector manifold (regular CPT slots/openings) is not the limiting factor."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use \"creek water experiment\" rather than \"deionised water experiment\"."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average of vanDriel and Chun:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U24,AJ36,AJ40,AJ44,AJ49,AJ53)/6","v":2.9388888888888887}]

{"sheet":"Example Design","index":2,"n_rows":46,"n_cols":26,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,13,10,16],[11,2,11,3],[11,9,11,11],[37,1,43,3],[1,7,1,9],[2,5,2,6],[2,8,2,9],[3,5,3,6],[3,8,3,9],[7,9,8,11],[4,5,4,6],[4,8,4,9]]}
[]
[null,"USDA- Natural Resources Conservation Service",null,null,null,null,null,"MD Version 1.6 - 4/14/2020"]
[null,"Project Name","EXAMPLE ONLY",null,"Designed by:",null,null,"Date:"]
[null,"Site Location",null,null,"Checked by:",null,null,"Date:"]
[null,"County",null,null,"Approved by:",null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drain capacity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,{"$f":"IF(D14>0,D14*0.15,10000)","v":3.2709293591408395E-2},"Option 1"]
[null,"Determine Design Capacity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CPT",null,null,{"$f":"IF(I11>0,I11*0.15,10000)","v":2.5996093750000001E-2},"Option 2"]
[null,"Option 1 - Mainline Configuration",null,null,null,"Option 2 - Drainage Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Dual Wall",null,null,{"$f":"IF(I14>0,I14*0.15,10000)","v":10000},"Option 3"]
[null,"Mainline tile size (in)",null,null,null,"Drainage area of tile system (ac)",null,null,11,null,null,null,null,null,null,null,null,null,null,null,3,"Clay or Concrete",null,null,{"$f":"IF(K10>0,K10,10000)","v":10000},"Option 4"]
[null,"Mainline tile grade (%)",null,0.2,null,"Drainage coefficient (inches/day)",null,null,0.375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(Y6:Y9)","v":2.5996093750000001E-2}]
[null,"Mainline tile material",null,null,null,"Capacity of drainage system ",null,null,{"$f":"I9*I10*43560/12/24/3600","v":0.17330729166666667}]
[null,null,{"$f":"IF(U6=2,0.012,IF(U6=3, 0.013,X14))","v":1.4999999999999999E-2}]
[null,"Peak velocity in mainline given size and grade",null,{"$f":"1.49*(D10/100)^0.5*((Y14/12/4)^(2/3))/C12","v":1.1105804288248959},null,"Option 3 - Direct Entry (from model or other source)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"selected","n","tile size","inlet area(Perf)"]
[null,"Peak flow from mainline size and grade",null,{"$f":"+D13*PI()*(Y14/2/12)^2","v":0.21806195727605596},null,"Capacity of drainage system (cfs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPT",null,3,{"$f":"INDEX(W19:W27,W14)","v":1.4999999999999999E-2},{"$f":"INDEX(U19:U27,W14)","v":6},{"$f":"INDEX(X19:X27,W14)","v":1}]
[]
[null,"Design Capacity:",null,{"$f":"IF(Y10=10000,0,Y10)","v":2.5996093750000001E-2},"(15% of Option 1, 2, or 3 - or 100% of Option 4 - whichever is lowest)"]
[null,"Size Bioreactor:"]
[null,"Design type (soil cover or open type)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tile Dia. (in.)",null,"n","area (in2/ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,1.4999999999999999E-2,1]
[null,"Conductivity of wood media (ft/s)",null,{"$f":"Conductivity!AJ74/2.54/12","v":9.6420239136774555E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,1.4999999999999999E-2,1]
[null,"Porosity of wood media (decimal %)",null,{"$f":"INDEX(V43:X45,U39,Y35)","v":0.53},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,1.4999999999999999E-2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,1.6E-2,1]
[null,"Flow length, L (ft)",null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.7000000000000001E-2,1]
[null,"Trench width, W (ft)",null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,1.7999999999999999E-2,1.5]
[null,"Inlet stop log height above trench bottom (in)",null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,1.7999999999999999E-2,1.5]
[null,"Outlet stop log height above trench bottom (in)",null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,0.02,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,0.02,1.5]
[null,"Average flow depth (ft)",null,{"$f":"(D25+D26)/2/12","v":3.0833333333333335}]
[null,"Hydraulic gradient (ft/ft)",null,{"$f":"IF(D23>0,(D25-D26)/12/D23,\"\")","v":8.3333333333333332E-3}]
[]
[null,"Loading density (Acres per 100 sq.ft. bioreactor)",null,{"$f":"IF(AND(D23>0,D24>0),I9/(D23*D24/100),\"\")","v":4.5833333333333339},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: University of Illinois bioreactor design software"]
[null,"Estimated load reduction (%)",null,{"$f":"IF(AND(ISNUMBER(D31),D31>0),95.42/D31^0.435,\"\")","v":49.206840932179546},"minimum 30%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydraulic Conductivity (ft/s)"]
[null,"Hydraulic retention time (hours)",null,{"$f":"IF(AND(D35>0,ISNUMBER(D35)),D23*D24*D28*D21/D35/(60*60),\"\")","v":3.6645141776937624},"minimum 3 hrs"]
[null,"Bioreactor flow capacity (cfs)",null,{"$f":"IF(AND(D28>0,D16>0),MIN(D20*D29*(D24*D28),D14),\"\")","v":2.9729573733838822E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of woodchip","No soil on top","1 ft of soil","2 ft of soil",1,{"$f":"V35","v":"No soil on top"}]
[null,"% of design capacity",null,{"$f":"IF(AND(ISNUMBER(D35),D16>0),D35/D16*100,\"\")","v":114.36169610612679},"target 100%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardwood",{"$f":"0.97/2.54/12","v":3.1824146981627298E-2},{"$f":"0.84/2.54/12","v":2.7559055118110232E-2},{"$f":"0.94/2.54/12","v":3.0839895013123356E-2},null,{"$f":"W35","v":"1 ft of soil"}]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shredded",{"$f":"0.69/2.54/12","v":2.2637795275590549E-2},{"$f":"0.61/2.54/12","v":2.001312335958005E-2},{"$f":"0.6/2.54/12","v":1.968503937007874E-2},null,{"$f":"X35","v":"2 ft of soil"}]
[null,"There are many possible combinations of length/width and stoplog settings that would achieve the design targets.  This is one potential design.  We used Option 2 for this example, but entered Option 1 information as well, to document the fact that the drainage coefficient method was the limiting factor of the methods considered.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed",{"$f":"0.69/2.54/12","v":2.2637795275590549E-2},{"$f":"0.59/2.54/12","v":1.9356955380577426E-2},{"$f":"0.53/2.54/12","v":1.7388451443569555E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porosity (decimal %)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of woodchip","No soil on top","1 ft of soil","2 ft of soil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardwood",0.59,0.55000000000000004,0.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shredded",0.64,0.6,0.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mixed",0.53,0.47,0.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]

{"sheet":"References","index":3,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["References"]
[]
[]
["ADS, Inc. Drainage Handbook. 2010. Hydraulics. Table 3-1. http://www.ads-pipe.com/pdf/en/ADH3-Hydraulics_(ID_2999).pdf  "]
[]
["American Society of Agricultural and Biological Engineers.  2015.  Design and Construction of Subsurface Drainage Systems on Agricultural Lands in Humid Areas.  ASAE EP260.5 FEB 2015."]
[]
["Christianson, Laura, Alok Bhandari, and Matthew J. Helmers. 2011. Pilot-Scale Evaluation of Denitrification Drainage Bioreactors: Reactor Geometry and Performance. Journal of Environmental Engineering 137(4): 213-220."]
[]
["Christianson, Laura, A. Castello, R. Christianson, M. Helmers, A. Bhandari. 2010. Hydraulic Property Determination of Denitrifying Bioreactor Fill Media. Applied Engineering in Agriculture 26(5): 849-854."]
[]
["Robertson, W. D., D. W. Blowes, C. J. Ptacek, and J. A. Cherry. 2000. Long‐term performance of in situ reactive barriers for nitrate remediation. Ground Water 38(5): 689‐695."]
[]
["USDA-NRCS. 2001. Water Management (Drainage). National Engineering Handbook, Part 650, Chpater 14, Table 14-7."]
[]
["Van Driel, P. W., Robertson, W. D., and Merkley, L. C. 2006. Denitrification of agricultural drainage using wood-based reactors. Transactions of the ASABE 49(2): 565-573."]

{"sheet":"Notes","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Date","Version","By","Notes"]
[2010,"---",null,"Iowa-Indiana interim design spreadsheet"]
["2013-08-05","1.1","R.Book","Adjust for Illinois use, update to new interim standard 747 and University of Illinois-generated woodchip properties"]
["2013-08-07","1.2","R.Book","Add entries for site name and location, designer name, date, etc."]
["2013-08-13","1.3","R.Book","Add conditional formatting on critical design values"]
["2016-11-29","1.4","R.Book","Change format to match Saturated Buffer design method"]
[null,null,null,"Add function for determining system capacity using drainage coefficient"]
["2016-12-29","1.5","R.Book","Adjusted minor omissions based on review comments"]
[null,null,null,"Added Example Design tab as a reference."]
["2020-04-14",1.6,"KWolfe","Modified for use in Maryland"]