SWMM Reporter

SWMM Reporter is a suite of tools for calibration of SWMM models and compilation of summary statistics. It has two principal outputs for model calibration:

 

  1. Scatterplots comparing summary statistics for any number of metered and observed storm pairs. 
  2. Time series hydrographs for specific periods that facilitate comparison of metered and observed data.

 

It has two principal outputs for statistical summaries:

 

  1. 1. A table of event duration, frequency and volume for selected conduits. This is intended for compiling annual CSO statistics, but can have other uses as well.
  2. A table similar to #1 immediately above, except events are counted based on the number of days of record, rather than based on parsed storm events.

 

Procedures for using SWMM Reporter for model calibration

 

  1. Open the SWMM Reporter database in Access.
  2. Populate table “STORMS” with each storm during calibration period. “StormStart” should be set at start of storm. “StormEnd” should be set an appropriate time after the end of the storm (e.g. 3 hours) to ensure that nearly all wet weather inflow is included in the subsequent gages vs. meter comparisons. “Storm” is an ID for internal use. You can simply assign numbers, or enter the date of each storm. Ensure that there are no duplicates. “Dry Period” should be left unchecked for storms. (Dry periods can optionally be entered and statistics will be tabulated for them, although data are not exported later on.) A listing of storms can be obtained from NetSTORM’s STORM module or by other means.
  3. Populate “GageData” with your flow metering data.
  4. Populate “Gages”. “Conduit” and “Junction” are the SWMM IDs which the data will be compared with. “Gagenum” should match the IDs in “GageData.” “Station” can be the same as GageNum – it is the name used in the results spreadsheet. “Offset” is subtracted from model results. It is useful if the gage was not set at the same invert as the model junction.
  5. Set the location of the model database in the SWMMReporter program at Analyze | SWMM Reporter | Select Database.
  6. Run Analyze | SWMM Reporter | Compile Gage Statistics. Check that the resulting “_GageStats” table is correct.
  7. To prepare model graphs set up a model input file with NODE and LINK reports for the calibration locations as in the example: 

 

[REPORT]

NODE 06-9 6635 2543 COVE14 39-37 4625

NODE BELL07 4725 5432 4172 FIRST01

LINK 06-09 6635 2548 COVE14 51-33 

LINK PURC08 BELL07 4727 OHIO 6767 

 

  1. Run the model from the command line (SWMM5 inpfile rptfile outfile) with SWMM5.EXE in your computer’s command-line path. (EPA GUIs prior to 5.0.12 delete the REPORT lines from your input file when saving a model!)
  2. Import the model results Analyze | SWMM Reporter | SWMM5 Text Results.
  3. Run the program to compile model statistics and generate summary data Analyze | SWMM Reporter | Prepare calibration spreadsheet. This creates a spreadsheet called ModGage.xls in the same folder as the database.
  4. Create a second spreadsheet based on the example SWMMCalPlots.xls that references all the data in ModGage (this is done because SWMMReporter erases and re-writes ModGage each time it is run). Create one or more additional sheets with calibration plots as in the template.
  5. Re-run steps 8 through 10 each time the model is run.