Inlet On Grade
Inlet on Grade is an Excel application which calculates the flow capacity of street sections and catch basins on continuous grade using the Modified Manning's Equation in accordance with HEC-12.
It solves for depth/flow rate values given 16 variables which characterize composite street section and inlet geometries in English units.
The results are calculated utilizing the spreadsheet and Excel Visual Basic macros and are displayed graphically alongside the input utilizing Excel Form tools. To protect the integrity of the computations, the application has been protected from changes. Output is documented by printing the form.
It will also create paired head-discharge rating files suitable for input into SWMM5 - one for curb-inlet only, one for the combination curb-opening and grate.
It was developed on Excel 97/2000 platforms.
A number of assumptions apply:
- The Modified Manning's Equation applies. Spread is greater than 40 times the depth at the curb per HEC-12 Section 5.0.
- Flow geometry is confined to the half-street between the face of curb and crown. Area of flow is truncated for the composite street section per HEC-12 Appendix C.
Version V31 6/27/2008 8:37am 247kB INLET ON GRADE V31.XLS:
- Allows export of SWMM5 head-discharge rating curves.
- Includes grate splash-over velocity consideration.
- Allows printing of various HEC-12 results charts.
The spreadsheet has been compressed in a '.zip' file. It is provided 'as-is' without warranty of any kind.