This question concerns stormwater modeling using Civil 3d 2014. I have my HGL and EGL information in an excel spreadsheet, and I'd like to paste that information in the Prospector under Pipes. Is that possible? It seems like they can only be entered one at a time. Not only that, but it refreshes after every time one single piece of new information is entered.
Anybody have a solution around this annoyance?
For clarity here's the excel information that I want to get into Prospector:
This can be done using vba or vb.net. Assuming that you know how to do program.
If you look in the samples section there is a pipe network to excel vba function which may already do the job otherwise you will need to add this information to the export & import.
You can obtain this information via the SSA application so long as you have modelled it in SSA. Windes Microdrainage will not pass this information across.
Otherwise the only way to do this will be manually for each pipe.