How To Make HTML Code for Excel Spreadsheets

How To Make HTML Code for Excel Spreadsheets

Tabelizer Program for Converting Speadsheets to HTML Code

Copy your Speadsheet to this link http://tableizer.journalistopia.com/ and then tabelize it and copy the html and css code to a blog or other online comments box,  

	InfoSWMM	H2OMAP SWMM	US EPA
Titles	Y	Y	Y
Options	Y	Y	Y
Files	Y	Y	Y
Raingages	Y	Y	Y
Temperature	Y	Y	Y
Evaporation	Y	Y	Y
Subcatchments	Y	Y	Y
Infiltration Subareas	Y	Y	Y
3 Types of Infiltration Per Subcatchment	Y	Y	N
Aquifers	Y	Y	Y
Groundwater	Y	Y	Y
Snowmelt	Y	Y	Y
Junctions	Y	Y	Y
Outfalls	Y	Y	Y
Storages	Y	Y	Y
Dividers	Y	Y	Y
Conduits	Y	Y	Y
Pumps	Y	Y	Y
Orifices	Y	Y	Y
Weirs	Y	Y	Y
Outlets	Y	Y	Y
Cross Section Shapes	Y	Y	Y
Dual Drainage Outlets	Y	Y	N
1D - 2D Connections	Y	N	N
HEC-22 Inlets	Y	Y	N
Transects	Y	Y	Y
Losses	Y	Y	Y
Controls	Y	Y	Y
Pollutants	Y	Y	Y
Landuses	Y	Y	Y
Buildup	Y	Y	Y
Washoff	Y	Y	Y
Coverage	Y	Y	Y
Inflow	Y	Y	Y
DWF	Y	Y	Y
Patterns	Y	Y	Y
RDII	Y	Y	Y
Unit Hydrographs	Y	Y	Y
Loading	Y	Y	Y
Treatment	Y	Y	Y
Curves	Y	Y	Y
Time Series	Y	Y	Y
Reports	Y	Y	P
Coordinates	Y	Y	Y
Vertices	Y	Y	Y
Polygons	Y	Y	Y
Labels	Y	Y	Y
Symbols	Y	Y	Y
Backdrop	Y	Y	Y
Tags	Y	Y	Y
Profiles	Y	Y	Y
Map	Y	Y	Y
LID Controls	Y	Y	Y
LID Usage	Y	Y	Y
LID Reports	Y	Y	P
LID Graphs	Y	Y	N
Calibration Data	Y	Y	P
Scatter Graphs	Y	Y	Y
Mixed Graphs	Y	Y	N
SWMM 5 Engine Up to Date	Y	Y	Y

Global Dry Weather Flow Reduction in InfoSWMM and H2OMAP SWMM

Global Dry Weather Flow Reduction in InfoSWMM and H2OMAP SWMM

A cool tip to reduce the overall dry weather flow in InfoSWMM and H2OMAP SWMM without changing the mean dry weather flow is to do the following:

1.       Make a Reduction or Increase Flow Pattern in the Operations tab of the Attribute Browser (2),
2.      For example, if we want to have 85 percent of the flow use a value of 0.85
3.      In the Node DWF DB Table (2) use the pattern just created (3)
4.      All of the flows in the DWF table and during your simulation will be reduced by 15 percent.

InfoSWMM 2D Report Variables

InfoSWMM 2D Report Variables

InfoSWMM 2D Report Variables by dickinsonre InfoSWMM 2D Report Variables The Junction Graph variables for 2D Depth, 2D Speed, 2D Froude Number, 2D Unit Flow, 2D Inflow, 2D Volume and 2D Angle for a InfoSWMM 2D simulation for up to 1000 years can be plotted in the Report Manager of InfoSWMM.  This is an image of the 2D inflow over a 10 year period (A), all seven graph variables (B) for the mesh triangle associated with the 1D node (C).  The 2D inflow is + for flow out of the node to a mesh triangle and – for flow from the mesh triangle to the  1D junction. via Blogger http://www.swmm5.net/2013/08/infoswmm-2d-report-variables.html

Grupo de Apoyo para usuarios de SWMM (SWMM in Spanish/ SWMM en Español)

There is a Google Group for Hispanic SWMM5 users around the world that has a lot of good discussions and more importantly help for your SWMM5 modeling.   You can easily join if you use GMAIL or Google+   The link is https://groups.google.com/forum/?fromgroups#!forum/swmm-espanol

Siphon Modeling in InfoSewer and Arc Map

Siphon Modeling in InfoSewer and Arc Map

Siphon Modeling in InfoSewer and Arc Map Atrribute Display by dickinsonre Siphon Modeling in InfoSewer and Arc Map Here is a typical view of  a siphon in InfoSewer, the rising links have a d/D of 1 and the dropping links typically have a d/D value less than 1.  The q/Q for the rising links is based on the slope and the dropping links typically have a q/Q less than 1 as the full flow is high due to the steep slopes.  You can show both the d/D and q/Q values in an Arc Map Display by using the following code.  I find it easier to first plot one variable using the InfoSewer Map Display followed by editing the TOC Properties for Pipes to show more than one variable at a time in the Label properties. Function FindLabel ([D_OVER_D],  [Q_OVER_Q] ) If IsNull([D_OVER_D]) then Exit Function FindLabel ="" &  FormatNumber([D_OVER_D],3) & "  d/D "  & "" &  FormatNumber([Q_OVER_Q],3) & " q/Q" End Function via Blogger http://www.swmm5.net/2013/08/siphon-modeling-in-infosewer-and-arc.html

SWMM 4 and SWMM 5 St. Venant Solutions Contrasted

SWMM 4 and SWMM 5 St. Venant Solutions Contrasted

SWMM 4 and SWMM 5 St. Venant Solutions Contrasted by dickinsonre SWMM 4 and SWMM 5 St. Venant Solutions Contrasted 1. Compute at time t+delta t the values of dQ/dt for the Links and dH/dt for the Nodes from the properties at time t 2 Iterate at least 2 times until either all nodes and links are converged or a maximum of 8 iterations are reached 3. Use the values of Q and H at time t+delta t for the new time step The SWMM5 Solution for Flow and Depth at each time step.  The new depth and new flow is always based on the old depth and old flow and normally converges fast as the flow is gradually varied.   The solution is iterative and implicitly uses the new depth and flow at each iteration. The SWMM4 Solution for Flow and Depth is solved Explicitly at each time step.  The new depth and new flow is always based on the old depth and old flow and and a half and full time step during the time step. via Blogger http://www.swmm5.net/2013/08/swmm-4-and-swmm-5-st-venant-solutions.html

The SWMM 4 Dynamic Wave Solution for ISOL=0

The SWMM 4 Dynamic Wave Solution for ISOL=0

The SWMM 4 Dynamic Wave Solution for ISOL=0 by dickinsonre The SWMM 4 Dynamic Wave Solution for ISOL=0 The attached PDF file is a copy of the Extran 3 solution in the  SWMM 4 manual explaining the ISOL=0 solution in SWMM 4 / Extran 4.  The current SWMM 5 solution in its dynamic wave solution is an adaptive time step iterative solution of the ISOL=0 solution in SWMM 4. via Blogger http://www.swmm5.net/2013/08/the-swmm-4-dynamic-wave-solution-for.html

The SWMM 4 Dynamic Wave Solution

The SWMM 4 Dynamic Wave Solution

The SWMM 4 Dynamic Wave Solution by dickinsonre The SWMM 4 Dynamic Wave Solution The attached PDF file is a copy of Appendix C of the SWMM 4 manual explaining the three St Venant solutions in SWMM 4 / Extran 4.  The current SWMM 5 solution in its dynamic wave solution is an adaptive time step iterative solution of the ISOL Zero solution in SWMM 4. via Blogger http://www.swmm5.net/2013/08/the-swmm-4-dynamic-wave-solution.html

Continuous Simulation using SWMM 5 LID and Groundwater Features in a Linked 1D/2D Network using InfoSWMM 2D for a 50 Year Period

Continuous Simulation using SWMM 5 LID and Groundwater Features in a Linked 1D/2D Network using InfoSWMM 2D for a 50 Year Period

Continuous Simulation using SWMM 5 LID and Groundwater Features in a Linked 1D/2D Network using InfoSWMM 2D for a 50 Year Period by dickinsonre Continuous Simulation using SWMM 5 LID and Groundwater Features in a Linked 1D/2D Network using InfoSWMM 2D for a 50 Year Period A poster at the recent ECI conference on the Past, Present and Future of Watershed modeling. via Blogger http://www.swmm5.net/2013/08/continuous-simulation-using-swmm-5-lid.html

The Structure of InfoSWMM in Arc Map

The Structure of InfoSWMM in Arc Map

The Structure of InfoSWMM in Arc Map by dickinsonre The Structure of InfoSWMM in Arc Map via Blogger http://www.swmm5.net/2013/08/the-structure-of-infoswmm-in-arc-map.html

How to Create an InfoSWMM model from CSV Files, Alternate Method

How to Create an InfoSWMM model from CSV Files, Alternate Method

How to Create an InfoSWMM model from CSV Files, Alternate Method by dickinsonre How to Create an InfoSWMM model from CSV Files, Alternate Method An InfoSWMM model can be newly created from a CSV file but it helps to have an idea of the maximum extents before you initialize the Arc Map project.  Use the ArcGIS default and Edit the extents of your future imported network (Figure 1).  Import the CSV files (Figure 2) and define the imported variables (Figure 3) followed by an Update Map from DB (Figure 4) which will draw your imported nodes and links on the Arc Map screen.  The updated Map should be within the extents of your defined spatial reference (Figure 5).  It is important to have the proper spatial reference for your imported data in Arc Map.  If you do not have the proper extents then when you update the Map from DB you will have a warning message "The coordinates or measures are out of bounds".  Figure 1.  Import a background shape file and initialize your InfoSWMM map to the coordinates of the shapefile. Figure 2.  Import a CSV file for both pipes and nodes using the Import Manager of InfoSWMM Figure 3.  Set up the Field Mapping between the CSV parameters and the Node and Link Parameters of InfosWMM. Figure 4.  Update the Map from the DB tables you just imported using the command Force All Network. Figure 5.  The imported model has the same coordinates as the original imported shapefile. via Blogger http://www.swmm5.net/2013/08/how-to-create-infoswmm-model-from-csv.html

How to Create an InfoSWMM model from CSV Files

How to Create an InfoSWMM model from CSV Files

How to Create an InfoSWMM model from CSV Files by dickinsonre How to Create an InfoSWMM model from CSV Files An InfoSWMM model can be newly created from a CSV file but it helps to have a background map or shapefile to initialize the Arc Map project.  BEFORE initializing yourInfoSWMM map Add a data layer using the Arc Map command Add Data.   Create a new InfoSWMM project using the same spatial reference as your added shapefile (Figure 1).  Import the CSV files (Figure 2) and define the imported variables (Figure 3) followed by an Update Map from DB (Figure 4) which will draw your imported nodes and links on the Arc Map screen.  The updated Map will have the same coordinates as the background shapefile (Figure 5).  It is important to have the proper spatial reference for your imported data in Arc Map. Figure 1.  Import a background shape file and initialize your InfoSWMM map to the coordinates of the shapefile. Figure 2.  Import a CSV file for both pipes and nodes using the Import Manager of InfoSWMM Figure 3.  Set up the Field Mapping between the CSV parameters and the Node and Link Parameters of InfosWMM. Figure 4.  Update the Map from the DB tables you just imported using the command Force All Network. Figure 5.  The imported model has the same coordinates as the original imported shapefile. via Blogger http://www.swmm5.net/2013/08/how-to-create-infoswmm-model-from-csv_8.html

  

How to Search My Blogs by concentrating on one blog for Information about SWMM5, InfoSWMM and InfoSewer

How to Search My Blogs by concentrating on one Blog:   I have spent a lot of time in the last week redoing all of my tags, names and websites.   You can search SWMM5.NET or SWMM5.ORG for information on infoswmm, infosewer and of course SWMM 5  Hopefully, this makes them a bit more organized – there are a total of 900 posts as of today, but each post now has labels and multiple tags

The site http://www.swmm5.net/  has a built in Google Custom Search Engine which as even more flexibility

How to Save Node and Link Relates in H2OMAP SWMM to Shapefiles

How to Save Node and Link Summary Tables in H2OMAP SWMM to Shapefiles

How to Save Node and Link Summary Tables in H2OMAP SWMM to Shapefiles by dickinsonre How to Save Node and Link Summary Tables in H2OMAP SWMM to Shapefiles The export manager of H2OMAP SWMM is very flexible, you can export shape, MIF and CSV files but you have to do some copy and pasting to allow the program to export ALL of the node and pipe summary tables.  The export manager will export any node or pipe information in the DB hydraulic and information tables.  If you copy and paste, for example, the output pipe summary table to the Pipe information tables (Figure 1) then you can use the Export Manager (Figure 2) to save the shape file with tables(Figure 4) and view the shape file in Arc Map (Figure 4).  The TOC properties in Arc Map can be used to show the maximum d over D or maximum Q over Qfull values in Arc Map using this VBScript. Function FindLabel ( [DOVEMAXD] )   FindLabel = "" & FormatNumber([DOVEMAXD],2) & "" End Function Figure 1.  Copy and Paste the Pipe Summary information from the Output Tables to the Pipe Information  Tables. Figure 2.  Select a link Shapefile using the Export Manager Figure 3.  Save the Link Information and other data to a shape file. Figure 4.  The created shapefile added to Arc Map and displayed using the Layer Properties of Arc Map via Blogger http://www.swmm5.net/2013/08/how-to-save-node-and-link-summary.html

How to Use the Output Relate in Excel using H2OMAP SWMM

How to Use the Output Relate in Excel using H2OMAP SWMM

How to Use the Output Relate in Excel usingH2OMAP SWMM by dickinsonre How to Use the Output Relate in Excel using H2OMAP SWMM You have to perform the following steps: 1.       Make an Output Relate (using the Operations Tab of the H2OMAP SWMM Browser) which will be the same as the Pipe Summary Table in the Output Report Manager 2.      Run the model to make the Output Relate and then update the Relate (Figure 1) 3.      Using Windows Explorer navigate to the HSDB folder of your H2MAP SWMM project 4.      Continue to the Relate Subfolder and open up the Relate DBD file in Excel (Figure 2) 5.      You cannot SAVE this file but you can save is as a new Excel File Figure 1.  Output Relate in H2OMAP SWMM to use the Pipe Summary Table Figure 2.   How to Use the Output Relate in Excel via Blogger http://www.swmm5.net/2013/08/how-to-use-output-relate-in-excel-using.htm

Annual International Conference on modeling urban water systems, Feb 21-22 2013 in Toronto - call for papers

Annual International Conference on modeling urban water systems, Feb 21-22 2013 in Toronto - call for papers

My note, this is a conference well worth attending, the Convenor is Dr Bill James and the venue is described at the CHIWater link shown below.

Once again it's the time to request one or more abstracts for the Annual International Conference on the Modeling of Urban Water Systems (formerly SWMM users meeting), to be held Feb 21-22 2013 in Toronto (note the venue). As you probably know, this is the 46th (!) meeting in this extraordinary series. This year our featured speakers include many well-known scientists, researchers and engineers (listed on our website).
The meeting is well attended: your audience exceeds 100 folks in your specialty. Also, the meeting is inexpensive, highly-regarded, professional, friendly and collaborative. Proceedings are produced as a peer-reviewed, integrated archival-quality book (you get the previous year's monograph at this conference, two-for-one value). The conference addresses all aspects of urban water systems, including planning, design, construction, operation, monitoring, models, safety, and security; how to manage urban water systems including water supply, drainage, pollution control, domestic, municipal, and industrial waters and stormwater from surface water catchments or ground water; and real-time control along with education, outreach, and practical applications. We welcome abstracts in any and all of the following general categories:; LIDs and BMPs; TMDLs; Urban water disasters, Urban flood management, Land Use; Nonpoint Sources of Pollution; Pavement; Pathogens; Stormwater and Urban drainage; Potable Water Supplies; Water distribution; Water System utilities; and other management and socio-political issues. Although the discussion is generally technical, it meshes well with management and difficult topics connected to urban water and related to computer modeling. Please visit:
http://www.chiwater.com/Training/Conferences/conferencetoronto.asp
Please email your 1-page abstract(s) to me in the next week or so. Alternatively, if you need a more formal invitation or a flyer, let me know.  We look forward to seeing you and your colleagues in Toronto - you won't get a better deal in these economically-challenged times!

Advanced Labeling in InfoSWMM or H2OMAP SWMM to show MM or IN on a HGL Plot

Advanced Labeling in InfoSWMM or H2OMAP SWMM to show MM or IN on a HGL Plot

Advanced Labeling in InfoSWMM or H2OMAP SWMM to show MM or IN on a HGL Plot by dickinsonre Advanced Labeling in InfoSWMM or H2OMAP SWMM to show MM or IN on a HGL Plot Here is how to get the maximum depth shown in millimeters or inches on a HGL Plot in InfoSWMM or H2OMAP SWMM– use the OTHER LINK Dimensions option.  You need to run the model again to have your new diameter shown on the HGL plot.  We use the output file to make the HGL plot and without a new model run the maximum depth will not be shown in either InfoSWMM or H2OMAP SWMM.   Keys: Use Other Units instead of feet or meters, and Use the Advanced Labeling in InfoSWMM or H2OMAP SWMM via Blogger http://www.swmm5.net/2013/08/advanced-labeling-in-infoswmm-or-h2omap.html