**Subject:** How to Import the SWMM 5 Report File as a Layer in infoSWMM

__ __

The idea of this blog of note is to show how one may extract information from the SWMM 5 or InfoSWMM RPT file and import the Excel File as a feature in InfoSWMM. This blog has an example Excel file to illustrate the linkage. The steps are:

__ __

Step 1: Copy the whole row from Conduit Summary from the InfoSWMM Browser

Step 2: Add the two columns length and slope from the Link Summary Table and the InfoSWMM Browser

Step 3: You need a few calculations based on the table values from SWMM 5 to estimate the CFL time steps in the .

Step 4: Add the Excel Spreadsheet as a layer in InfoSWMM – the **Named Range** should be added to insure valid numbers and not Nulls after the join

Step 5: You can now plot the CFL Time Step for the Links using the Layer Properties command in Arc Map

__ __

Step 1: Copy the whole row from Conduit Summary

__ __

__ __

Step 2: Add the two columns length and slope from the Link Summary Table

__ __

__ __

__ __

Step 3: You need a few calculations based on the table values from SWMM 5 to estimate the CFL time steps.

__ __

The CFL Step = Length / (Full Velocity + (Gravity * Full Depth)^0.5)

Full Velocity = Full Flow / Full Area

__ __

You also need to create a Name A Range for you data so that the data does not show up as Nulls

__ __

__ __

__ __

Step 4: Add the Excel Spreadsheet as a layer in InfoSWMM – the Named Range should be added

__ __

__ __

__ __

Step 4: Join the Excel Table to the InfoSWMM Conduit Feature Layer

__ __

__ __

Step 5: You can now plot the CFL Time Step for the Links using the Layer Properties command in Arc Map

__ __

__ __

__ __

__ __

via Blogger http://www.swmm5.net/2013/08/how-to-import-swmm-5-report-file-as.html