Culvert Protection (MN TR-3) Excel Spreadsheet |
Aids in design of riprap outlet basin for culverts. Includes three alternative designs: horizontal blanket, preformed scour hole, and lined channel expansion. Also aids in design of culvert inlet protection. Includes a Help tab. |
|
Culvert Design Excel Spreadsheet |
Calculates capacity of circular culverts based on culvert material, inlet type, diameter, and length. Analysis is also based on water and culvert elevation. Includes a Help tab. |
|
Cross Section Plotting Excel Spreadsheet |
Cross Section Plotting Excel Spreadsheet, Plots cross section of streambank based on manual input of elevation and distance for existing ground, top of water, constructed grade, and riprap. This spreadsheet could be modified for cross sections of other features. |
|
Natural Channel Flow Excel Spreadsheet Calculator |
Natural Channel Flow Excel Spreadsheet Calculator. Calculates the flow capacity of a stream which varies in roughness across its profile. Up to 24 different sets of cross section data can be entered. Includes a Help tab. |
|
Vortex Panel Method for a 2D Airfoil |
Excel calculator using vortex panel method for a 2D airfoil. The algorithm is from Kuethe and Chow, Foundations of Aerodynamics, 4th Edition, Wiley (1986). |
|
Oblique Planar Shocks Excel Spreadsheet |
Two-dimensional, oblique shocks. The user must be willing to learn Excel’s Solver Add-in in order to use it! It is set so that the user can easily input the upstream Mach number and turn angle. Using the Solver constraints the user can solve for either the strong (M2 <1) or weak (M2 >1) solution. |
|
|