Building Drainage & Stormwater Management Calculation Excel Template

This Excel template serves as a practical computational bridge between hydrologic analysis and hydraulic design in building-scale water management. At its core, it implements the Rational Method and Modified Rational Method for peak runoff estimation, incorporating variables such as impervious area, runoff coefficient (C), time of concentration (Tc), and intensity-duration-frequency (IDF) relationships derived from regional rainfall data. The template typically segments the building site into discrete subcatchments (e.g., roof zones, paved courtyards, landscaped areas), each assigned unique C-values and flow paths, enabling distributed runoff calculation and convergence analysis for combined or separate stormwater systems. Hydraulic design modules then size conveyance elements—including gutters (using Manning’s equation for open-channel flow), downspouts (based on orifice and pipe flow equations), and underground pipes (applying Manning’s equation with slope, roughness, and full-flow capacity constraints)—while checking against minimum velocity, self-cleansing thresholds, and allowable surcharge limits. Advanced versions include storage routing (e.g., level-pool reservoir routing) for detention basins, infiltration volume credit calculations per green infrastructure standards (e.g., EPA SWMM-based logic), and export-ready reporting for submission to authorities like local municipalities or environmental agencies.