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