The most important Drainage Calculation Spreadsheets

The most important Drainage Calculation Spreadsheets

30 May 2021OffByThe Engineering Community

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

error: Content is protected !!