1. To activate the Add-in
This process is detailed in pp. 141 of the EPA SWMM manual (http://www.epa.gov/ednnrmrl/models/swmm ... manual.pdf). Basically the user needs to go to "Tools->Program Preferences->Configure Tools" on SWMM main menu. Then in the pop-up "Tool Options" menu choose "Add." A "Tool Properties" window will pop-up, and the user can assign a name to the Excel Add-in for the "Name" field. For the "Program" field, the user needs to navigate to the location of the Excel executable file at "C:\Program Files\Microsoft Office\Office10\Excel.exe" (the file path may vary). Leave the "Working Directory" field as blank, and choose "INPFILE" macro for the "Parameters" field. Check both "Disable SWMM while executing" and "Update SWMM after closing."
After the above is set up, click OK and the Excel Add-in is registered in SWMM5. The Add-in tool is under the "Tools" menu. One important thing now is to go to "Tools->Program Preferences," and in the pop-up window check "Tab Delimited Project File."
2. Use the Excel Add-in
The SWMM5 input file by default is a tab-delimited .txt file. The user can view the file using Wordpad, but the editing is not very convenient, especially when it comes to calibration for a watershed with large number of subbasins. The Excel Add-in provides great relief for such operations.
Create a simple watershed model in SWMM, and then go to "Tools->Excel Editor (or whatever the user names the Add-in)." The input file for the watershed model is then displayed in tab-delimited format in Excel. In this environment, the user can edit the input data much easier (as compared to double-click each model component and key in the values in the Graphic User Interface). This becomes more apparent when the number of subbasins increases. When the editing is finished, close the Excel program, and then click "YES" or "OK" to all the pop-up windows. After that, the SWMM model interface pops back and the input parameters are updated.
So with this knowledge the model setup process can be much easier. In the initial model setup, the user may not bother to input any parameter values (i.e. subbasin area, width, slope, etc.). Instead, the model can be delineated and all components represented. Then the user can open the "Excel Editor" and copy/paste the model parameter values from another table of pre-created input parameter values (which is always the case). This process will totally by-pass the manually key-in of parameter values.
The second case of this feature applies is the model calibration. In a traditional way, suppose the user needs to change the value of depression storage for the impervious area. That means for a 30-subbasin watershed, the user needs to roam around the watershed and double-click 30 times to finish that single parameter change. Imagine if it takes five times to find the best value for that single parameter. With this feature, the user can open up the input file, set a depression storage value for the first subbasin, and then drag down for all the other 29 subbasins. Close Excel and go back to SWMM, and the updated model can be ran immediately.