{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["User's Manual","Model","Design Drawing"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":11,"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":"User's Manual","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,3,4,26],[0,0,0,27],[1,1,1,26],[27,3,27,26],[29,3,29,26],[28,3,28,26],[25,3,25,26],[5,3,5,26],[6,3,6,26],[7,3,7,26],[8,3,8,26],[9,3,9,26],[22,3,22,26],[18,3,18,26],[17,3,17,26],[16,3,16,26],[15,3,15,26],[30,0,30,27],[1,0,29,0],[1,27,29,27],[26,3,26,26],[10,3,10,26],[12,3,12,26],[19,3,19,26],[20,3,20,26],[21,3,21,26],[23,3,23,26],[24,3,24,26],[11,3,11,26],[14,3,14,26],[13,3,13,26],[2,3,2,26],[3,3,3,26]]}
[]
[null,"Sed-Emmett Basin Model User's Manual"]
[null,"1.",null,"Excel will automatically block macros upon downloading the tool. Unlock the macros."]
[null,null,1.1000000000000001,"In the file explorer, go to downloads, right click the excel download, click properties, under the general tab look for the security section and check unblock."]
[null,null,1.2,"There are also other ways to unblock macros. Please use any way most appropriate."]
[null,"2.",null,"Enable the Solver Add-In. You will only need to enable this once."]
[null,null,2.1,"Click file, select \"Options\", select \"Add-Ins.\""]
[null,null,"2.2","Near the bottom of the window, there is a dropdown list next to \"Manage.\" Select \"Excel Add-Ins\" and click \"Go.\""]
[null,null,2.2999999999999998,"In the Add-Ins dialog box, check the box next to \"Solver Add-In.\" Click \"OK\" to activate the add-in which will also save it for all future uses."]
[null,"3.",null,"Model Sheet - Enter required inputs in cells c9:c22. Make note of the required units."]
[null,null,3.1,"In cell c9, enter the area (acres) of land that drains to the sediment basin."]
[null,null,3.2,"In cell c10, enter the area (acres) of land that is disturbed and drains to the sediment basin."]
[null,null,3.3,"In cell c11, enter the NRCS curve number of the drainage area before construction began (i.e., pre-construction)."]
[null,null,3.4,"In cell c12, enter the anticipated NRCS curve number of the drainage area during construction."]
[null,null,3.5,"In cell c13, use the drop down menu to enter if the receiving stream is classified as an exceptional Tennessee water, has available parameters, or has unavailable parameters due to siltation."]
[null,null,3.6,"In cell c14, enter the corresponding (either 5-year or 2-year [instructions will auto-populate based on the input in cell c13]) design precipitation depth in inches."]
[null,null,3.7,"In cell c15, enter the corresponding (either 5-year or 2-year [instructions will auto-populate based on the input in cell c13]) design flow rate in cfs."]
[null,null,3.8,"In call c16, use the drop down menu to specficy which dewater device you will use for your sediment basin. "]
[null,null,3.9,"In cell c17, enter the ideal dewatering time. If cell c16=\"Perforated Riser\" the input must be between 48 and 72 hours. If cell c15=\"Skimmer\" an input of 72 hours will autopopulate. "]
[null,null,"3.10","In cell c18, enter the differnce in density between soil particles and water particles. A standard soil particle density is 2,650 kg/m3 and a standard water particle density is 998 kg/m3. "]
[null,null,3.11,"In cell c19, enter your desired sediment basin geometry length to width ratio in ft:ft."]
[null,null,3.12,"In cell c20, enter your desired sediment basin geometry hortizontal to vertical ratio in ft:ft."]
[null,null,3.13,"In cell c21, enter your desired sediment storage depth in feet. A minimum of 4 feet may be ideal to reduce mosquito breeding in the permanent pool storage, but is not required. "]
[null,null,3.14,"In cell c22, use the drop down menu to enter either particle size distribution (PSD) or %Sand silt and clay from the drop down menu. This input is the basis in which the tool sizes the sediment basin (based off settling time of particulates and how much of the particulates you want to remove)."]
[null,"4.",null,"Model Sheet - Enter the appropriate PSD (particle size diameter [mm] and % finer) in cells B24:C29 or percent of soil that is sand silt and clay in cells c32:c35."]
[null,null,"4.1","If PSD was selected in cell c22, enter the desired particle size that is to settle out completely. If %Sand silt and clay was selected in cell c22, enter the classification and percent of that classification to settle out in cells c30 and d30, respectively. "]
[null,null,"4.2","If %Sand, silt and clay was selected in cell c22, enter the classification (cell c30 [drop down menu]) and the percentage (cell d30) of particulates to be settled, respecitvely. "]
[null,"5.",null,"Model Sheet - After all the input are entered, the RUN button will change from a red to green highlight indicating the model is ready to RUN. Upon clicking the button results will tabulate in columns J, K, and L."]
[null,null,"5.1","Cells F25:F34 will highlight green, yellow, or red indicating if the model meets state standards. A legend is provided in the model sheet."]
[null,null,"5.2","Any time a change is made to any input, the results will be erased and the RUN button will return to a red highlight. This ensures the results showing are always reflective of the inputs showing. Simply click RUN again to display results for any changes/modifications."]
["Developed by J. Cole Emmett and Ian M. Simpson"]

{"sheet":"Model","index":1,"n_rows":77,"n_cols":431,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,1,1,11],[6,1,6,3],[8,9,8,11],[6,5,6,7],[6,9,6,11],[3,9,3,11],[4,1,4,7],[3,1,3,7],[4,9,4,10],[0,14,0,19],[27,14,27,17],[30,16,30,17],[31,16,31,17],[34,14,34,15],[3,14,3,19],[6,19,8,19],[6,18,8,18],[6,17,8,17],[11,14,11,19],[6,31,6,33],[6,35,6,37],[8,35,8,37],[16,35,16,37],[14,31,14,33],[26,35,26,37],[31,35,31,37],[23,31,23,33],[20,5,20,7],[14,5,14,7],[23,5,23,7],[18,5,18,7],[19,5,19,7],[21,5,21,7],[22,5,22,7],[16,9,16,11],[31,9,31,11],[26,9,26,11],[18,31,18,33],[19,31,19,33],[20,31,20,33],[21,31,21,33],[22,31,22,33],[13,17,17,17],[13,18,17,18],[13,19,17,19],[64,17,64,18],[65,17,65,18],[41,14,41,16],[48,14,48,17],[55,16,55,17],[60,14,60,18],[61,17,61,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rows to be hidden"]
[null,"Sed-Emmett Basin Model"]
[]
[null,"Developed by: J. Cole Emmett and Ian M. Simpson",null,null,null,null,null,null,null,"Tennessee Water Resources Research Center",null,null,null,null,"%Sand, silt, clay velocities"]
[null,"Disclaimer: This tool is to be used for guidance of sediment basin design only. The design engineer is responsible for the final design.",null,null,null,null,null,null,null,"University of Tennessee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%Sand, Silt, Clay","Diameter to remove (mm)","Vt (m/s)","Vt to use","F","Vo (m/s)"]
[null,"REQUIRED INPUTS",null,null,null,"BASIN COMPUTATIONS & REGULATIONS",null,null,null,"BASIN DESIGN",null,null,null,null,{"$f":"IF($C$22=\"%Sand silt and clay\",\"Sand\",\"\")","v":""},{"$f":"IF($C$30=\"Sand\",2-(2-0.05)*$D$30/100,\"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(D32),D32,0)","v":0},{"$f":"MAX(Q7:Q9)","v":0},{"$f":"(R7/T7)","v":0},2.8016781683272099E-4,null,null,null,null,null,null,null,null,null,null,null,"BASIN COMPUTATIONS & REGULATIONS",null,null,null,"BASIN DESIGN"]
[null,"Parameter","Value","Units",null,"Parameter","Value","Units",null,"Parameter","Value","Units",null,null,{"$f":"IF($C$22=\"%Sand silt and clay\",\"Silt\",\"\")","v":""},{"$f":"IF($C$30=\"Silt\",0.05-(0.05-0.002)*$D$30/100,\"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(D33),D33,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parameter","Value","Units",null,"Parameter","Value","Units"]
[null,"Contributing Drainage Area",null,"acres",null,null,null,null,null,"Live Storage",null,null,null,null,{"$f":"IF($C$22=\"%Sand silt and clay\",\"Clay\",\"\")","v":""},{"$f":"IF($C$30=\"Clay\",0.002-(0.002-0)*$D$30/100,\"NA\")","v":"NA"},{"$f":"IF(ISNUMBER(D34),D34,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live Storage"]
[null,"Disturbed Area within Drainage Area",null,"acres",null,null,null,null,null,"Surface Area",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$10,\"\")","v":""},"ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface Area",{"$f":"ROUNDUP($C$15/$AG$17,0)","v":{"$error":"#VALUE!"}},"ft2"]
[null,"Curve NumberPre-Construction",null,"-",null,null,null,null,null,"Width",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$11,\"\")","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width",{"$f":"ROUND((SQRT($AK$10/$C$19)),0)","v":{"$error":"#VALUE!"}},"ft"]
[null,"Curve NumberConstruction",null,"-",null,null,null,null,null,"Length",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$12,\"\")","v":""},"ft",null,null,"PSD velocities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length",{"$f":"ROUND($AK$11*$C$19,0)","v":{"$error":"#VALUE!"}},"ft",null,null,null,null,null,"Sand"]
[null,"Stream Parameter",null,"-",null,null,null,null,null,"Height",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$13,\"\")","v":""},"ft",null,null,"Particle Diameter","% Finer","Vt (m/s)","Vt to use","F","Vo (m/s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height",{"$f":"ROUNDUP($O$32,2)","v":2.6799999999999997},"ft",null,null,null,null,null,"Silt"]
[null,{"$f":"IF(OR(C13=\"Exceptional\",C13=\"Unavailable due to siltation\"), \"Design Precipitation Depth: 5yr-24hr\", IF(C13=\"Available\", \"Design Precipitation Depth: 2yr-24hr\", \"Design Precipitation Depth\"))","v":"Design Precipitation Depth"},null,"in",null,null,null,null,null,"Design Volume",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$14,\"\")","v":""},"ft3",null,null,{"$f":"B24","v":0},0,"",{"$f":"ROUNDUP((($B$30*10^-3)^2)*($C$18-$C$17)*(9.81)/(18*(0.000891)),5)","v":0},{"$f":"R14/T14","v":0},6.9999999999999999E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design Volume",{"$f":"ROUND(($AK$13/6)*((2*$AK$19*$AK$20)+(2*$AK11*$AK$12)+($AK$11*$AK$20)+($AK$19*$AK$12)),0)","v":{"$error":"#VALUE!"}},"ft3",null,null,null,null,null,"Clay"]
[null,{"$f":"IF(OR(C13=\"Exceptional\",C13=\"Unavailable due to siltation\"), \"Design Drainage Area Discharge: 5yr-24hr\", IF(C13=\"Available\", \"Design Drainage Area Discharge: 2yr-24hr\", \"Design Drainage Area Discharge\"))","v":"Design Drainage Area Discharge"},null,"cfs",null,"Automated Computations",null,null,null,"Min. Surface Area - TDEC",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$15,\"\")","v":""},"ft2",null,null,0,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Automated Computations",null,null,null,"Min. Surface Area - TDEC",{"$f":"ROUND(0.01*$C$15*43560,0)","v":0},"ft2"]
[null,"Dewatering Device",null,"-",null,"Settling Velocity",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AG$16,\"\")","v":""},"ft/s",null,"Min. Volume - TDEC",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$16,\"\")","v":""},"ft3",null,null,0,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Settling Velocity",{"$f":"IF($C$22=\"PSD\",$R$14*3.28084,IF($C$22=\"%Sand silt and clay\",$R$7*3.28084,\"\"))","v":""},"ft/s",null,"Min. Volume - TDEC",{"$f":"IF(\n  AND(\n    ISNUMBER($C$9),\n    ISNUMBER($C$11),\n    ISNUMBER($C$12)\n  ),\n  _xlfn.LET(\n    _xlpm.c, (1000/$C$12 - 10),\n    _xlpm.p, (1000/$C$11 - 10),\n    ROUND(((($C$14 - (0.2*_xlpm.c))^2 / ($C$14 - (0.2*_xlpm.c) + _xlpm.c)) / 12 * ($C$9 * 43560))\n    -\n    ((($C$14 - (0.2*_xlpm.p))^2 / ($C$14 - (0.2*_xlpm.p) + _xlpm.p)) / 12 * ($C$9 * 43560)),0)\n  ),\n  \"\"\n)","v":""},"ft3"]
[null,"Ideal Dewatering Time",null,"hrs",null,"Critical Settling Velocity",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AG$17,\"\")","v":""},"ft/s",null,"Sediment Storage",null,null,null,null,0,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical Settling Velocity",{"$f":"IF($C$22=\"PSD\",$T$14*3.28084,IF($C$22=\"%Sand silt and clay\",$T$7*3.28084,\"\"))","v":""},"ft/s",null,"Sediment Storage"]
[null,"Particle Density - Water Density",1652,"kg/m3",null,"Fractional Removal",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AG$18,\"\")","v":""},"-",null,"Height",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$18,\"\")","v":""},"ft",null,null,0,0,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fractional Removal",{"$f":"IF($C$22=\"PSD\",$S$14,IF($C$22=\"%Sand silt and clay\",$S$7,\"\"))","v":""},"-",null,"Height",{"$f":"IF($O$39<=$C$21, ROUNDUP(($C$21),2), ROUNDUP($O$39,2))","v":1.53},"ft"]
[null,"Length:Width Ratio",null,"ft:ft",null,"TDEC Design Requirments & Guidance",null,null,null,"Width",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$19,\"\")","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TDEC Design Requirments",null,null,null,"Width",{"$f":"ROUNDUP($AK$28+2*$C$20*$AK$18,0)","v":{"$error":"#VALUE!"}},"ft"]
[null,"Horizontal:Vertical Ratio",null,"ft:ft",null,"Upon running the model, the below parameters will highlight in color based on the following legend:",null,null,null,"Length",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$20,\"\")","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upon running the model, the below parameters will highlight in color based on the following legend:",null,null,null,"Length",{"$f":"ROUNDUP($AK$29+$C$20*2*$AK$18,0)","v":{"$error":"#VALUE!"}},"ft"]
[null,"Min Sediment Storage Depth",null,"ft",null,"Green: Sed-Emmett output meets TDEC design requirement.",null,null,null,"Surface Area",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$21,\"\")","v":""},"ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green: Sed-Emmett output meets TDEC design requirement.",null,null,null,"Surface Area",{"$f":"ROUNDUP(($AK$19*$AK$20),0)","v":{"$error":"#VALUE!"}},"ft2"]
[null,"Design by Which Particle Size Classification?",null,{"$f":"IF($C$22=\"PSD\",\"mm\",IF($C$22=\"%Sand silt and clay\",\"%\",IF($C$22=\"\",\"NA\",\"\")))","v":"NA"},null,"Yellow: Sed-Emmett output does not meet TDEC design volume/surface area requirement, but is within 10%.",null,null,null,"Design Volume",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$22,\"\")","v":""},"ft3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow: Sed-Emmett output does not meet TDEC design volume/surface area requirement, but is within 5%.",null,null,null,"Design Volume",{"$f":"ROUND(($AK$18/6)*((2*$AK$28*$AK$29)+(2*$AK$19*$AK$20)+($AK$19*$AK$29)+($AK$28*$AK$20)),0)","v":{"$error":"#VALUE!"}},"ft3"]
[null,{"$f":"IF($C$22=\"PSD\",\"Particle Diameter (mm)\",\"\")","v":""},{"$f":"IF($C$22=\"PSD\",\"Cumulative Percent Finer (%)\",\"\")","v":""},{"$f":"IF($C$22=\"PSD\",\"Settling Velocity (m/s)\",\"\")","v":""},null,"Red: Sed-Emmett output does not meet TDEC design requirement.",null,null,null,"Cleanout Height",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$23,\"\")","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red: Sed-Emmett output does not meet TDEC design requirement.",null,null,null,"Cleanout Height",{"$f":"ROUND($O$46,2)","v":1.01},"ft"]
[null,null,null,{"$f":"IF(AND($C$22=\"PSD\",ISNUMBER($B24)),ROUNDUP((($B24*10^-3)^2)*($C$18)*(9.81)/(18*(0.000891)),5),\"\")","v":""},null,"Grey: Not modeled in Sed-Emmet",null,null,null,"Cleanout Volume",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$24,\"\")","v":""},"ft3",null,null,"All PSD Variables Entered?","All %Sand,Silt,Clay Variables Entered?","Was model Run?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grey: Not modeled in Sed-Emmet",null,null,null,"Cleanout Volume",{"$f":"ROUND(($AK$23/6)*((2*$AK$28*$AK$29)+((2*($AK$28+2*($C$20*$AK$23)))*($AK$29+2*($C$20*$AK$23)))+(($AK$28+2*($C$20*$AK$23))*$AK$29)+(($AK$28*($AK$29+2*($C$20*$AK$23))))),0)","v":{"$error":"#VALUE!"}},"ft3"]
[null,null,null,{"$f":"IF(AND($C$22=\"PSD\",ISNUMBER($B25)),ROUNDUP((($B25*10^-3)^2)*($C$18)*(9.81)/(18*(0.000891)),5),\"\")","v":""},null,"Min. L:W ",2,"ft/ft",null,"Min. Cleanout Volume - TDEC",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$25,\"\")","v":""},"ft3",null,null,{"$f":"IF(AND(ISNUMBER($C$9),ISNUMBER($C$10),ISNUMBER($C$11),ISNUMBER($C$12),ISTEXT($C$13),ISNUMBER($C$14),ISNUMBER($C$15),ISTEXT($C$16),ISNUMBER($C$17),ISNUMBER($C$18),ISNUMBER($C$19),ISNUMBER($C$20),ISNUMBER($C$21),ISTEXT($C$22),ISNUMBER($B$30),ISNUMBER($B$24:$C$28)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(ISNUMBER($C$9),ISNUMBER($C$10),ISNUMBER($C$11),ISNUMBER($C$12),ISTEXT($C$13),ISNUMBER($C$14),ISNUMBER($C$15),ISTEXT($C$16),ISNUMBER($C$17),ISNUMBER($C$18),ISNUMBER($C$19),ISNUMBER($C$20),ISNUMBER($C$21),ISTEXT($C$22),ISTEXT($C$30),ISNUMBER($D$30),ISNUMBER($C$32:$C$34)),\"Yes\",\"No\")","v":"No"},"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. L:W ",2,"ft/ft",null,"Min. Cleanout Volume - TDEC",{"$f":"IF(ISNUMBER($C$10),$C$10*$G$30,\"\")","v":""},"ft3"]
[null,null,null,{"$f":"IF(AND($C$22=\"PSD\",ISNUMBER($B26)),ROUNDUP((($B26*10^-3)^2)*($C$18)*(9.81)/(18*(0.000891)),5),\"\")","v":""},null,"Min. H:V",2,"ft/ft",null,"Min. Volume - TDEC",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$26,\"\")","v":""},"ft3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. H:V",2,"ft/ft",null,"Min. Volume - TDEC",{"$f":"IF(ISNUMBER($C$10),$C$10*$G$28,\"\")","v":""},"ft3"]
[null,null,null,{"$f":"IF(AND($C$22=\"PSD\",ISNUMBER($B27)),ROUNDUP((($B27*10^-3)^2)*($C$18)*(9.81)/(18*(0.000891)),5),\"\")","v":""},null,"Min. Basin Volume (excl. freeboard and 25-yr highwater)","Live Storage + Sediment Storage","ft3",null,"Basin  Geometry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Sediment Storage + Live Storage Volume ","1809 Live + 1809 Sediment","ft3:ac",null,"Basin  Geometry"]
[null,null,null,{"$f":"IF(AND($C$22=\"PSD\",ISNUMBER($B28)),ROUNDUP((($B28*10^-3)^2)*($C$18)*(9.81)/(18*(0.000891)),5),\"\")","v":""},null,"Min. Sediment Storage Volume",3618,"ft3:ac",null,"Bottom Width",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$28,\"\")","v":""},"ft",null,null,"Cubic Equation for Live Storage Height Height",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Sediment Storage Volume",1809,"ft3:ac",null,"Bottom Width",{"$f":"ROUNDUP($AK$11-$C$20*2*($AK$13+$AK$18),0)","v":{"$error":"#VALUE!"}},"ft"]
[null,{"$f":"IF($C$22=\"PSD\",\"Design to remove 100% of which particle size (mm)\",\"\")","v":""},{"$f":"IF($C$22=\"%Sand silt and clay\",\"Particle Size to Remove?\",\"\")","v":""},{"$f":"IF($C$22=\"%Sand silt and clay\",\"Percent to Remove (%)\",\"\")","v":""},null,"Min. Live Storage Volume","Const. Vol - Pre-Construc Vol.","ft3",null,"Bottom Length",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$29,\"\")","v":""},"ft",null,null,"A","B","C","Min Design Vol",null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Live Storage Volume",1809,"ft3:ac",null,"Bottom Length",{"$f":"ROUNDUP($AK$12-$C$20*2*($AK$13+$AK$18),0)","v":{"$error":"#VALUE!"}},"ft"]
[null,null,null,null,null,"Min. Sediment Cleanout Volume",1809,"ft3:ac",null,"Total Design Volume (excl. freeboard and 25-yr highwater)",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$30,\"\")","v":""},"ft3",null,null,{"$f":"2*($C$20^2)","v":0},{"$f":"-$C$20*($AK$11+$AK$12)","v":{"$error":"#VALUE!"}},{"$f":"$AK$10","v":{"$error":"#VALUE!"}},{"$f":"$AK$16","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Sediment Cleanout Volume",905,"ft3:ac",null,"Total Design Volume (excl. freeboard)",{"$f":"ROUNDUP(($AK$10+$AK$28*$AK$29)/2*($AK$13+$AK$18),0)","v":{"$error":"#VALUE!"}},"ft3"]
[null,null,{"$f":"IF($C$22=\"%Sand silt and clay\",\"Percent of Soil (%)\",\"\")","v":""},{"$f":"IF($C$22=\"%Sand silt and clay\",\"Settling Velocity (m/s)\",\"\")","v":""},null,"Min. Live Storage Surface Area",0.01,"ft2:ft3/s",null,"Min. Total Design Volume (excl. freeboard and 25-yr highwater) - TDEC",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$31,\"\")","v":""},"ft3",null,null,"Height","Equals (D)","Difference (D-Equals)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Live Storage Surface Area",0.01,"ft2:ft3/s",null,"Min. Total Design Volume (excl. Freeboard) - TDEC",{"$f":"IF(AND(ISNUMBER($C$9),ISNUMBER($C$10)),$AK$26+$AK$16,\"\")","v":""},"ft3"]
[null,{"$f":"IF($C$22=\"%Sand silt and clay\",\"Sand\",\"\")","v":""},null,{"$f":"IF(AND($C$22=\"%Sand silt and clay\",ISNUMBER($C$32)),IF(P7=\"NA\",\"NA\",ROUNDUP(((P7*10^-3)^2)*($C$18)*(9.81)/(18*(0.000891)),5)),\"\")","v":""},null,"Max Dewatering Time",72,"hrs",null,{"$f":"IF($C$16=\"Perforated Riser\", \"Perforated Riser\", IF($C$16=\"Skimmer\", \"Skimmer\", \"Dewatering Structure\"))","v":"Dewatering Structure"},null,null,null,null,2.673118592105868,{"$f":"$O$30*$O$32^3+$P$30*$O$32^2+$Q$30*$O$32","v":{"$error":"#VALUE!"}},{"$f":"$R$30-$P$32","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dewatering Time - Max",72,"hrs",null,{"$f":"IF($C$16=\"Perforated Riser\", \"Perforated Riser - Total Area of Orifices in Each Row Assuming 3 Rows (view drawing)\", IF($C$16=\"Skimmer\", \"Skimmer\", \"Dewatering Structure\"))","v":"Dewatering Structure"},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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,2.2732120035285042]
[null,{"$f":"IF($C$22=\"%Sand silt and clay\",\"Silt\",\"\")","v":""},null,{"$f":"IF(AND($C$22=\"%Sand silt and clay\",ISNUMBER($C$33)),IF(P8=\"NA\",\"NA\",ROUNDUP(((P8*10^-3)^2)*($C$18)*(9.81)/(18*(0.000891)),5)),\"\")","v":""},null,"Min. Dewatering Time",48,"hrs",null,{"$f":"IF($C$16=\"Perforated Riser\", \"Total Area of Orifices in Each Row, Assuming 3 Rows (view drawing)\", IF($C$16=\"Skimmer\", \"Skimmer Size\",\"Size\"))","v":"Size"},{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$33,\"\")","v":""},{"$f":"IF($C$16=\"Perforated Riser\", \"in²\", IF($C$16=\"Skimmer\", \"in\",\"-\"))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dewatering Time - Min",48,"hrs",null,{"$f":"IF($C$16=\"Perforated Riser\", \"Total Area of Orifices in Each Row\", IF($C$16=\"Skimmer\", \"Skimmer Size\",\"Size\"))","v":"Size"},{"$f":"IF($C$16=\"Skimmer\",$Q$58,IF($C$16=\"Perforated Riser\",ROUNDUP($P$64,1),\"\"))","v":""},{"$f":"IF($C$16=\"Perforated Riser\", \"in²\", IF($C$16=\"Skimmer\", \"in\",\"-\"))","v":"-"}]
[null,{"$f":"IF($C$22=\"%Sand silt and clay\",\"Clay\",\"\")","v":""},null,{"$f":"IF(AND($C$22=\"%Sand silt and clay\",ISNUMBER($C$34)),IF(P9=\"NA\",\"NA\",ROUNDUP(((P9*10^-3)^2)*($C$18)*(9.81)/(18*(0.000891)),5)),\"\")","v":""},null,"Min. Forebay Volume (20% Live Storage Volume)",{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),0.2*K14,\"Depends on Live Storage\")","v":"Depends on Live Storage"},"ft3",null,{"$f":"IF($C$16=\"Perforated Riser\", \"Actual Dewater Time\", IF($C$16=\"Skimmer\", \"Actual Dewater Time (using Faircloth orifice dewatering rates)\",\"Actual Dewater Time\"))","v":"Actual Dewater Time"},{"$f":"IF(AND(OR($O$25=\"Yes\",$P$25=\"Yes\"),$Q$25=\"Yes\"),$AK$34,\"\")","v":""},"hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forebay Volume","20% Live Storage","ft3",null,"Actual Dewater Time",{"$f":"IF($C$16=\"Skimmer\",ROUNDUP($R$52,0),IF($C$16=\"Perforated Riser\",ROUNDUP($R$63,1),\"\"))","v":""},"hrs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equation for Sediment Storage Height"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AK$26","v":""},{"$f":"($AK$28*$AK$29+($AK$28+(2*$C$20)*$O$39)*($AK$29+(2*$C$20)*$O$39))/2*$O$39","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height","A-B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5249283697353075,{"$f":"$O$37-$P$37","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sediment Cleanout"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","Volume"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AK$22/2","v":{"$error":"#VALUE!"}},{"$f":"($AK$28*$AK$29+($AK$28+2*$C$20*$O$46)*($AK$29+2*$C$20*$O$46))/2*$O$46","v":{"$error":"#VALUE!"}},{"$f":"($AK$28*$AK$29+($AK$28+2*$C$20*$AK$23)*($AK$28+2*$C$20*$AK$23))/2*$AK$23","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height","A-B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0147234135544585,{"$f":"$O$44-$P$44","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faircloth Skimmer (updated 2/2/2026)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discharge","Orifice Size","Qmax","Dewater Time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(cfs)","(in)","(cfs)","(hrs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,1.5,{"$f":"$AK$14/($G$33*60*60)","v":{"$error":"#VALUE!"}},{"$f":"($AK$14/$Q$57)/3600","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5462962962962962E-2,2,"Qmin","(days)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.6446759259259256E-2,2.5,"(cfs)",{"$f":"$R$52/24","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11015046296296296,3,{"$f":"$AK$14/($G$32*60*60)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22063657407407408,4,"Orifice Size"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3533101851851852,5,{"$f":"_xlfn.LET(\n    _xlpm.lo, MIN($Q$52,$Q$55),\n    _xlpm.hi, MAX($Q$52,$Q$55),\n    _xlpm.vals, $O$52:$O$59,\n\n    IF(\n        COUNTIFS(_xlpm.vals,\">=\"&_xlpm.lo,_xlpm.vals,\"<=\"&_xlpm.hi),\n        _xlfn.MAXIFS(_xlpm.vals,_xlpm.vals,\">=\"&_xlpm.lo,_xlpm.vals,\"<=\"&_xlpm.hi),\n        _xlfn.MINIFS(_xlpm.vals, _xlpm.vals, \">\"&_xlpm.hi)\n    )\n)","v":0},"(cfs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.60931712962962958,6,{"$f":"VLOOKUP($Q$57,$O$52:$P$59,2,FALSE)","v":{"$error":"#N/A"}},"(in)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0715856481481481,8]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perforated Riser"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diameter",1,"(inches)","Total Dewater Time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d ",{"$f":"ROUND(($AK$13),2)","v":2.68},"(ft)",{"$f":"ROUNDUP(SUM($P$75:$P$77),0)","v":{"$error":"#VALUE!"}},"(hrs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area of Perforation",{"$f":"PI()/4*$P$62^2","v":0.78539816339744828},"(sq. in.)",{"$f":"$R$63/24","v":{"$error":"#VALUE!"}},"(days)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"depth_bot",{"$f":"$P$63-($P$63*(3/3))","v":0},"(ft)","Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"depth_mid",{"$f":"$P$63-($P$63*(2/3))","v":0.89333333333333353},"(ft)",{"$f":"$C$17-R63","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"depth_top",{"$f":"$P$63-($P$63*(1/3))","v":1.7866666666666668},"(ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"head_bot",{"$f":"P63-P65","v":2.68},"(ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"head_mid",{"$f":"P63-P66","v":1.7866666666666666},"(ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"head_top",{"$f":"P63-P67","v":0.89333333333333331},"(ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V_bot",{"$f":"($P$66/6)*((2*$AK$19*$AK$20)+(2*($AK$19+(2*$C$20*$P$66))*($AK$20+(2*$C$20*$P$66)))+(($AK$19+(2*$C$20*$P$66))*($AK$20))+(($AK$19)*($AK$20+(2*$C$20*$P$66))))","v":{"$error":"#VALUE!"}},"ft^3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V_mid",{"$f":"(($P$67-$P$66)/6)*((2*($AK$19+(2*$C$20*(($P$67-$P$66))))*($AK$20+(2*$C$20*($P$67-$P$66))))+(2*($AK$19+(2*$C$20*($P$67)))*($AK$20+(2*$C$20*($P$67))))+(($AK$19+(2*$C$20*($P$67)))*($AK$20+(2*$C$20*($P$67-$P$66))))+(($AK$19+(2*$C$20*($P$67-$P$66)))*($AK$20+(2*$C$20*($P$67)))))","v":{"$error":"#VALUE!"}},"ft^3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V_top",{"$f":"(($P$68-$P$67)/6)*((2*($AK$19+(2*$C$20*(($P$68-$P$67))))*($AK$20+(2*$C$20*($P$68-$P$67))))+(2*($AK$19+(2*$C$20*($P$68)))*($AK$20+(2*$C$20*($P$68))))+(($AK$19+(2*$C$20*($P$68)))*($AK$20+(2*$C$20*($P$68-$P$67))))+(($AK$19+(2*$C$20*($P$68-$P$67)))*($AK$20+(2*$C$20*($P$68)))))","v":{"$error":"#VALUE!"}},"ft^3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vtot",{"$f":"SUM(P71:P73)","v":{"$error":"#VALUE!"}},"ft^3","=","Live Storage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T_bot",{"$f":"(($P$71)/(0.5*0.6*($P$64/144)*(SQRT(64))*((SQRT($P$70)))+((SQRT($P$65)))))/3600","v":{"$error":"#VALUE!"}},"(hrs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T_mid",{"$f":"(($P$72)/(0.5*0.6*($P$64/144)*(SQRT(64))*((SQRT($P$70))+(SQRT($P$69)))+((SQRT($P$65))+(SQRT($P$66)))))/3600","v":{"$error":"#VALUE!"}},"(hrs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T_top",{"$f":"(($P$73)/(0.5*0.6*($P$64/144)*(SQRT(64))*((SQRT($P$70))+(SQRT($P$69))+SQRT($P$68))+((SQRT($P$65))+(SQRT($P$66))+(SQRT($P$67)))))/3600","v":{"$error":"#VALUE!"}},"(hrs)"]

{"sheet":"Design Drawing","index":2,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,2,38,9],[39,2,40,9],[35,1,40,1],[35,12,40,12],[3,23,3,25],[5,23,5,25],[13,23,13,25],[23,23,23,25],[32,19,32,20],[33,19,33,20],[34,19,34,20],[35,13,38,20],[39,13,40,20],[32,2,32,6],[33,2,33,6],[34,2,34,6],[31,1,31,9],[31,12,31,20],[34,8,34,9],[33,8,33,9],[32,8,32,9],[32,13,32,17],[33,13,33,17],[34,13,34,17]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASIN DESIGN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parameter","Value + Units","Value + Units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live Storage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface Area",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$10)),Model!$K$10 & \" ft²\",\"Surface Area (ft²)\")","v":"Surface Area (ft²)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$10)),Model!$K$10 & \" ft²\",\"Surface Area (ft²)\")","v":"Surface Area (ft²)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$11)),Model!$K$11 & \" ft\", \"Width (ft)\")","v":"Width (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$11)),Model!$K$11 & \" ft\", \"Width (ft)\")","v":"Width (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$12)),Model!$K$12 & \" ft\", \"Length (ft)\")","v":"Length (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$12)),Model!$K$12 & \" ft\", \"Length (ft)\")","v":"Length (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$13)),Model!$K$13 & \" ft\", \"Height (ft)\")","v":"Height (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$13)),Model!$K$13 & \" ft\", \"Height (ft)\")","v":"Height (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design Volume",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$14)),Model!$K$14 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$14)),Model!$K$14 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Surface Area - TDEC",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$15)),Model!$K$15 & \" ft²\", \"Surface Area (ft²)\")","v":"Surface Area (ft²)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$15)),Model!$K$15& \" ft²\", \"Surface Area (ft²)\")","v":"Surface Area (ft²)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Volume - TDEC",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$16)),Model!$K$16 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$16)),Model!$K$16 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sediment Storage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$18)),Model!$K$18 & \" ft\", \"Height (ft)\")","v":"Height (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$18)),Model!$K$18 & \" ft\", \"Height (ft)\")","v":"Height (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$19)),Model!$K$19 & \" ft\", \"Width (ft)\")","v":"Width (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$19)),Model!$K$19 & \" ft\", \"Width (ft)\")","v":"Width (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$20)),Model!$K$20 & \" ft\", \"Length (ft)\")","v":"Length (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$20)),Model!$K$20 & \" ft\", \"Length (ft)\")","v":"Length (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface Area",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$21)),Model!$K$21 & \" ft²\", \"Surface Area (ft²)\")","v":"Surface Area (ft²)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$21)),Model!$K$21 & \" ft²\", \"Surface Area (ft²)\")","v":"Surface Area (ft²)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design Volume",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$22)),Model!$K$22 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$22)),Model!$K$22 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cleanout Height",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$23)),Model!$K$23 & \" ft\", \"Height (ft)\")","v":"Height (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$23)),Model!$K$23 & \" ft\", \"Height (ft)\")","v":"Height (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cleanout Volume",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$24)),Model!$K$24 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$24)),Model!$K$24 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Cleanout Volume - TDEC",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$25)),Model!$K$25 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$25)),Model!$K$25 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min. Volume - TDEC",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$26)),Model!$K$26 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$26)),Model!$K$26 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basin  Geometry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bottom Width",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$28)),Model!$K$28 & \" ft\", \"Width (ft)\")","v":"Width (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$28)),Model!$K$28 & \" ft\", \"Width (ft)\")","v":"Width (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bottom Length",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$29)),Model!$K$29 & \" ft\", \"Length (ft)\")","v":"Length (ft)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$29)),Model!$K$29 & \" ft\", \"Length (ft)\")","v":"Length (ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Design Volume (excl. freeboard and 25-yr highwater)",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$30)),Model!$K$30 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$30)),Model!$K$30 & \" ft³\", \"Volume (ft³)\")","v":"Volume (ft³)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizontal:Vertical Ratio",{"$f":"IF(AND(ISNUMBER(Model!$C$20),Model!$Q$25=\"Yes\",Model!$C$16=\"Skimmer\"),Model!$C$20 & \" ft:ft\", \"H:V (ft:ft)\")","v":"H:V (ft:ft)"},{"$f":"IF(AND(ISNUMBER(Model!$C$20),Model!$Q$25=\"Yes\",Model!$C$16=\"Perforated Riser\"),Model!$C$20 & \" ft:ft\", \"H:V (ft:ft)\")","v":"H:V (ft:ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Model!$C$16=\"Perforated Riser\", \"Perforated Riser - Total Area of Orifices in Each Row Assuming 3 Rows (view drawing)\", IF(Model!$C$16=\"Skimmer\", \"Skimmer\", \"Dewatering Structure\"))","v":"Dewatering Structure"},"Skimmer Size","Perforated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Model!$C$16=\"Perforated Riser\", \"Total Area of Orifices in Each Row\", IF(Model!$C$16=\"Skimmer\", \"Skimmer Size\",\"Size\"))","v":"Size"},{"$f":"IF(AND(ISNUMBER(Model!$K$33),Model!$C$16=\"Skimmer\"),Model!$K$33&\" in\",\"Skimmer Size\")","v":"Skimmer Size"},{"$f":"IF(AND(ISNUMBER(Model!$K$33),Model!$C$16=\"Perforated Riser\"),Model!$K$33&\" in² per row\",\"Orifice(s)\")","v":"Orifice(s)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual Dewater Time",{"$f":"IF(AND(Model!$C$16=\"Skimmer\",ISNUMBER(Model!$K$34)),Model!$K$34 & \" hr\", \"Time (hr)\")","v":"Time (hr)"},{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$34)),Model!$K$34 & \" hr\", \"Time (hr)\")","v":"Time (hr)"}]
[null,"Disclaimer: This tool is to be used for guidance of sediment basin design only. The design engineer is responsible for the final design.",null,null,null,null,null,null,null,null,null,null,"Disclaimer: This tool is to be used for guidance of sediment basin design only. The design engineer is responsible for the final design.",null,null,null,null,null,null,null,null,null,null,"Orifice Interval","-",{"$f":"IF(AND(Model!$C$16=\"Perforated Riser\",ISNUMBER(Model!$K$34)),ROUND(Model!$P$63/3,2) & \" ft\", \"Dist. (ft)\")","v":"Dist. (ft)"}]
[null,"Project:",null,null,null,null,null,"Revision:",null,null,null,null,"Project:",null,null,null,null,null,"Revision:"]
[null,"Location:",null,null,null,null,null,"Date:",null,null,null,null,"Location:",null,null,null,null,null,"Date:"]
[null,"Description:",null,null,null,null,null,"Engineer(s):",null,null,null,null,"Description:",null,null,null,null,null,"Engineer(s):"]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,"Notes:"]
[]
[]
[]
[null,null,{"$f":"IF(AND(OR(Model!$K$34<48,Model!$K$34>72),ISNUMBER(Model!$K$34),Model!$C$16=\"Skimmer\"),\"Dewatering time based on Faircloth rates. Available sizes do not allow a dewatering time between 48 and 72 hours. A larger skimmer was selected as novel amendments now allow personnel to partially close the skimmer orifice to slow the dewatering rate.\",IF(OR(Model!$C$16=\"\",Model!$C$16=\"Perforated Riser\"),\"\",\"Dewatering time based on rates expressed by Faircloth.\"))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(Model!$K$34),Model!$C$16=\"Perforated Riser\"),\"Refer to Section 4.4.12.2.2 of the TDEC EPSC Manual to design a perforated riser with a different orifice configuration.\",\"\")","v":""}]