The most important Drainage Calculation Spreadsheets

14 day Residence : This sheet calculates the required minimum pond size at SHW for a 14 day residence permanent wet pool
Boring Calculations : This sheet calculates the required number of borings and hydraulic conductivity tests for a pond
Buoyancy Calculations: This sheet verifies the required soil depth over a pond liner
Channel Sections : This sheet calculates geometric elements of various cross sections and segments of a circle
Conversions – DRI and Metric : This sheet converts metric to English and vice versa and DRI to conductivity conversions
Curve Number Calculations : This sheet converts Curve Numbers to coefficient of runoff numbers
Effluent Filtration : This sheet verifies the recovery time for an effluent filtration system
Head Loss: This sheet calculates head losses in pipes
Intensity (Rainfall) : This sheet calculates rainfall intensity and allowable discharge in FDOT’s Zones 1 through 11 for the 2 to 50 years events
Kinematic Wave : This sheet calculates the time of concentration using the kinematic wave formula
Littoral Shelf: This sheet calculates the required shelf size if the pond is larger than required
Modified Rational : This sheet calculates the required storage volume for a 2 to 50 year storm event in all 11 FDOT zones
NRCS Runoff Calculator: This sheet calculates runoff by the NRCS method
NRTS Tc Calculator: This sheet calculates the NRCS time of concentration
Orifice Bleeddown Calculator: This sheet calculates the required orifice size to discharge ½ the treatment volume in 60 hours or more
Pipe Calculations: This sheet calculates slopes, volumes, velocities and capacities of pipes flowing full
Pond Volume: This sheet calculates pond volumes based on surface area and elevation
Rainfall Hydrograph Calculator: This sheet generates rainfall hydrographs for input into other programs
Rating Curve Calculator: This sheet calculates rating curves for compound weirs for input other programs
Retention Basin Recovery: This sheet calculates retention basin recovery timeframes
Sediment Sump Sizing: This sheet calculates the required sediment sump size.
Simplified Analytical Method: This sheet provides a simplified pond (surface water management system) volume recovery analysis
Tc Lag Method: This sheet calculated lag time
V-Notch Calculations: This sheet verifies the 24 hours bleeddown requirement for a V-notch weir
Vegetative Upland Buffer: This sheet calculates vegetative upland buffers for a residential stormwater quality treatment alternative practice
Weir Calculations: This sheet calculates weir dimensions based on height, width or discharge rate
Weir Notch Flow: This sheet calculates the bleed down time for a weir notch

Download Link