Excel Reports from Storm and Sanitary Analysis

We’ve all had to make stormwater reports that include endless summaries and tables. One way to get what you need is to use Excel. SSA has a tool that exports your model elements and information to excel.

Output > Excel Table Reports

The whole model gets pushed to an Excel workbook- with each element getting its own worksheet.

Here is a closer look at the subbasin output. A nice way to get a summary of weighted CN, Time of Concentration, etc.

Autodesk Storm and Sanitary Analysis is available for North American subscription customers of Civil 3D and Map 3D. You can download SSA at www.autodesk.com/subscription, and learn more about SSA, including demonstration videos, here.

You might also want to read: Moving Civil 3D Pipe Networks to Autodesk Storm and Sanitary Analysis.

Comments

[Laith Wark]

Dana, This is all very good but do you know when SSA will be available to non-NUSA subscribers? Also does this tool show water pooling (back up) in the event of pipe blockage? Thanks.

[MattAnderson]

Laith -

SSA can route storms and actively use the pipe storage to simulate a storage condition in the pipe network. For example, SSA can use the pipes as underground storage in the pipe network leading to a restrictor plate or orifice condition.

If you need to simulate a closing of a valve, there are control rules that can turn off or restrict an item at a specific time or event. SSA would then route the event using the available links and nodes (pipes, manholes, junctions, storage nodes etc).

Do you have something particular in mind?

Matt Anderson, PE