Stormwater Management Model (SWMM) Information for watershed water quality, hydrology and hydraulics modelers (Note this Blog is not associated with the EPA). You will find Blog Posts and Twitter Embeds on the Subjects of SWMM5, InfoSWMM, InfoSewer, SWMMLive, InfoSWMM SUSTAIN, SWMM4 and SWMM in general.
Subscribe to this blog
Follow by Email
How to Make an Excel Fixed Width File from SWMM 5
How to Make an ExcelFixedWidthFile from SWMM5
You can use this macro for MATLAB or some other DOS based program by using the Tools command of SWMM5 and configuring the EXCELfile option. If you use the EXCEL tool then your SWMM5 input file will be opened up in EXCEL and you can use this macro to make a fixed format file for SWMM5. Note, SWMM5 does not use fixed format but other programs may need it for reading, You adjust the column widths in the macro for your program.
Here is the macro, which is placed in Excel using these command:
Copy the code above.
Alt + F11 to open the Visual Basic Editor.
Click Insert-Module from the menu.
Paste the code into the window that appears at right.
Sub CreateFixedWidthFile(strFile As String, ws As Worksheet, s() As Integer)
Soffit Level (pipe technology)The top point of the inside open section of a pipe or box conduit. The soffit is the highest point of the internal surface of a pipe or culvert at any cross-section. The soffit is also referred to as the pipe obvert. So it is not quite the Crown of the Pipe. Here is an image I found that hopefully explains it better.
Engine Error NumberDescription ERROR 101: memory allocation error. ERROR 103: cannot solve KW equations for Link ERROR 105: cannot open ODE solver. ERROR 107: cannot compute a valid time step. ERROR 108: ambiguous outlet ID name for Subcatchment
New InfoSWMM linked 2D Link and 3D Node graphics help you understand one of the most critical outputs in any Stormwater, Combined Sewershed or Sanitary Sewershed Network Model the value and timing of how full the pipes and nodes are over time and how this changes during Wet Weather Flow (Runoff or Infiltration Inflow).These new graphs are included in InfoSWMM v 14.6 and InfoSWMM SA V2 (InfoSWMM SA is not an Esri Extension in ArcMap but uses Arc Engine for GIS processing power) has many new graphical and map display tools that help answer the following modeling questions in a easy to understand group of linked Time Track Graph, 2D Graphs and 2D Thumbnails. If you are modeling a Stormwater Network and need to know the d/D or depth over maximum depth over time and at the peak of the Runoff event you can view linked graphs as shown in Figure 1.If you are modeling a Sanitary Network and need to find the d/D for Rainfall Induced Infiltration and Inflow (RDII) you can see the RDII fl…