I am compiling a drainage design manual for a municipality. The question has come up - What is the maximum length of a pipe where it is appropriate to design as a culvert? Are there some rules of thumb out there for the definition of a culvert versus a storm sewer?
I think the easiest way is similar IRstuff's idea. Save the file as a .txt file. Then open Excel, do File, Open, Files of Type "All Files" (*.*) and pick the saved .txt file. The Text Import Wizard window comes up (at least in Office 97 it does). Pick Delimited, Next, check...
I have done several of these to calculate needed detention volume based on a triangular hydrograph from Modified Rational. email me at mroberts@ndmce.com and I will forward some to you. They usually have to be customized to each City's criteria. It involves some sort of lookup function for...
I've done the same type thing before. Rather than area you need to get an equivalent KD or conveyance factor. This will account for the increased wetted perimeter to area ratio that you get with multiple pipes. A 36" RCP has a KD=666 (with an n=0.013). An 8" pvc has a KD=14.3 (with...
There is a program called Spanner that works very well. We bring large spread sheets into autocad all the time with it. Go to http://www.wfcadtools.com/span40.htm