How to Use the SWMM 5 Excel Tool with InfoSewer CSV Files
1. Export Link and Manholes in InfoSewer for your current Scenario to CSV files,
2. Set up the Excel Add on for SWMM 5 by using the command Tools, and Configure Tools (Figure 1)
3. Run SWMM 5 and edit the data in Excel, you should be able to copy and paste the information from the CSV files into the correct SWMM 5 sections.
Figure 1. SWMM 5 Excel Add On Tool
You can use the Variable Flow Percentage Flow Splitter in InfoSewer to model overflow in a node when the two stage solution in InfoSewer does not have a full pipe in the 1st stage of the solution, http://www.swmm5.net/2011/06/infosewer-link-and-head-calculations.html The problem is that the 1st stage of the solution has non full pipes but the 2nd stage in which the flows are calculated has adjusted depths that show the pipes are full and the HGL is high. The flow splitter is used to allow the overflow water from the high HGL to flow into the overflow link to the outfall.
You can do this by having two Flow Split Curves, one for the low flow to the downstream node and one for the overflow to an outfall. The X value of the flow curve is the inflow to the Loading Manhole, the Y value is the flow in the conduit that you desire to have a flow split. Each of the pipes associated with the loading manhole has a different flow split curve.
Here are the steps in the modeling suggestion:
1. Have two curves: (1) One for low flow and (2) One for Higher Flow (Figure 1),
2. You can set up the curves to have all of the loading flow go to one or the other link as shown in Figure 2, when the inflow to the loading node is below 5 gpm the flow will go to the downstream link, when the flow is above 5 gpm all of the flow will go to the overflow link to the outfall.
3.
Figure 1. Two Variable Flow Percentage Curves
Figure 2. The divided flow in the normal link and the overflow link.
| |||||
 |  |  |  |  |  |
|
Innovyze President Dr. Paul F. Boulos Named President-Elect of the | |||||
|
Broomfield, Colorado USA, October 23, 2012 — Innovyze, a leading global innovator of wet infrastructure modeling and simulation software and technologies, today announced that its president and chief operating officer, Paul F. Boulos, Ph.D., BCEEM, Hon.D.WRE, Dist.D.NE, F.ASCE, has been re-elected to the Board of Trustees and named president-elect of the American Academy of Water Resources Engineers (AAWRE) of the American Society of Civil Engineers (ASCE). Dr. Boulos was first elected to the AAWRE Board of Trustees in 2009. His naming as AAWRE president-elect is the first in a three-year sequence of positions: in October 2013 and 2014, Dr. Boulos will serve as president and past president, respectively. In these roles, Dr. Boulos will seek to strategically position AAWRE for national and global prominence as the leading expert certification organization for water resources engineering professionals. “Dr. Boulos’ extensive professional experience and exceptional leadership skills make him an outstanding asset for AAWRE,” said the organization’s past President, founding board member and trustee William H. Espey, Jr., Ph.D., P.E., D.WRE, President of RPS Espey in Austin, TX. “He is an individual of extraordinary merit, and his contributions to our profession are innumerable. There is no doubt that he will bring innovative ideas to energize our water resources engineering certification program and further strengthen our profession around the world.” Dr. Boulos is one of the world’s foremost experts on water resources and navigation engineering, authoring nine authoritative books and more than 200 technical articles on issues critical to the water and wastewater industry. He is the recipient of numerous honors from national and international scientific and engineering societies, governments, universities, and NGOs. Among these acknowledgements are notable technical awards for excellence in scholarship from the American Society of Civil Engineers, the American Water Works Association and the U.S. Environmental Protection Agency. He also received the U.S. Ellis Island Medal of Honor, one of America’s highest accolades; the Pride of Heritage Award from the Lebanese American Foundation; the Alumni of the Year Award by the Lebanese American University; and was inducted into the University of Kentucky College of Engineering Hall of Distinction, the highest honor the university bestows on its alumni. He was given Honorary Diplomate status by AAWRE as well as Distinguished Diplomate status in Navigation Engineering by the Academy of Coastal, Ocean, Port & Navigation Engineers, both academies’ top honors. He is a Fellow of the American Society of Civil Engineers and a Diplomate (by Eminence) of the American Academy of Environmental Engineers. Dr. Boulos serves on the Board of Trustees of the Lebanese American University (New York, NY and Beirut, Lebanon); the Boards of Directors of Innovyze, MWH Global (Broomfield, CO) and America-Mideast Educational and Training Services, Inc./AMIDEAST (Washington, D.C.); and the Dean’s International Council of the Harris School of Public Policy Studies at the University of Chicago (Chicago, IL). He has been a member of advisory boards and councils for many organizations, including the Buck Advisory Council of the Buck Institute for Research on Aging (Novato, CA), the Arab American National Museum (Dearborn, MI), the USEPA Science Advisory Board, the Urban Water Resources Research Council of the Environmental and Water Resources Institute (EWRI), and the National Academy of Sciences/National Research Council. Dr. Boulos received his Doctorate, Master of Science and Bachelor of Science degrees in Civil Engineering from the University of Kentucky as well as a Bachelor degree in General Science from the Lebanese American University. He has also completed Harvard Business School’s Advanced Management Program. The American Academy of Water Resources Engineers was created by the American Society of Civil Engineers and its Environmental and Water Resources Institute to improve the practice, elevate the standards, and advance the profession of water resources engineering. Key AAWRE goals are to identify and certify engineers with specialized knowledge in water resources for the benefit of the public; recognize the ethical practice of water resources engineering at the expert level; enhance the practice of water resources engineering; support and promote positions on water resources issues important to the public health, safety and welfare; and encourage life-long learning and continued professional development. “Dr. Boulos is one of the world’s foremost leaders in water resources engineering and a leading engineering executive, and we are pleased and honored that he will continue to make invaluable contributions to AAWRE,” said AAWRE incoming President Robert G. Traver, Ph.D., P.E., D.WRE, Director of the Villanova Center for the Advancement of Sustainability in Engineering and Professor, Department of Civil and Environmental Engineering at Villanova University (Villanova, PA). “His wealth of experience, vibrant leadership, and great passion for our profession will greatly advance the mission and role of AAWRE by promoting the growth of the academy and giving professional engineers an opportunity to gain recognition by the water resources industry.” “AAWRE owes its success not to chance, but to the dedication of its Board members and staff,” said Boulos. “They have donated their time, talent and resources with a passionate commitment to our water resources profession and our members. Serving and representing this organization is not a duty, but an honor. I look forward to continuing to work with the Board to promote the importance of certification … initiate and support innovations that improve the practice, elevate the standards, advance the cause and the future of the water resources engineering profession … and effectively serve the water resources community.” For more information on AAWRE, visit www.aawre.org. | |||||
Subject: How to Have both Depth and Elevation for the Node Rim Elevation in InfoSWMM
If you turn on store Absolute Junction Rim option then the Rim Elevation = Invert Elevation + Maximum Node Depth will be shown in the DB Table Junction Hydraulic Modeling Data and the Attribute Browser of InfoSWMM and H2OMAP SWMM
Figure 1. Store Absolute Junction Rim Elevation Option
Now the Rim Elevation can be copied from the DB Table
Figure 2. The DB for Junction Modeling Data
And Pasted to the Elevation Table in Junction Information
Figure 3. The DB for the Junction Information Data
Then you can go back and turn off the Preferences flag and you will have the Rim Elevation in in the Information Table and the Maximum Depth in the Junction Hydraulic Modeling Data DB Table, I do this all of the time as it helps to see both the depth and the Elevation.
InfoMaster is an Esri-based business analytics, optimization, and management system for sewer networks. It leverages existing GIS and IT investments to give utilities a cost effective business intelligence and a data collection platform for informed decision making. With versions designed for the desktop, Web, and iOS mobile devices, InfoMaster provides for day-to-day operational management and long-term network planning for users throughout the organization.
The data available in water and sewer networks continues to grow exponentially, whether CCTV video of sewer lines or hundreds of thousands of smart meter readings. InfoMaster is designed to help utilities review, organize and analyze all this information within their existing Esri architecture. Using sophisticated built-in tools, SQL query sets, or custom scripting, users can manage their infrastructure data in ways not previously achievable.
Unlike many traditional business intelligence applications, InfoMaster comes preconfigured to understand water and sewer networks. InfoMaster knows that sewer pipes have upstream and downstream manholes, a hydrant is connected to the distribution system with a lateral, scoring of CCTV defects, and dozens of other items functionality specific to water networks. The database leverages the existing Esri water and wastewater data models to include the ability to store information about incidents and tasks related to the network. Central to InfoMaster is its ability to exchange with other enterprise CMMS or ERP databases enabling a true 360 degree view of the infrastructure.
InfoMaster gives utilities a new perspective on their capital and operational planning. Armed with a clear view of their infrastructure condition, capital and recurring costs, likelihood of failure, consequence of failure, historical incidents and maintenance, planners and managers can revamp capital and operational plans. Utilities can shift operational budget away from reactive and into proactive management.
InfoMaster utilizes the rich Esri results and presentation environment, letting users create thematic maps with flexible symbology and rich detail. Its built-in report generator comes with dozens of standard reports and also allows users to quickly build custom reports and graphs against any piece of data stored in the system. In addition, management dashboards make it possible to effectively track level of service metrics and other key operational data, allowing ata- glance assessments of the past, present and future state of strategic assets.
InfoMaster Mobile enables infrastructure data to be created, used, consumed, and verified by staff in the field on a variety of devices. Using the Esri ArcGIS Server, InfoMaster Mobile leverages the geodatabase for use outside the office. It can run on both Web browsers and iOS (iPad, and iPhone) devices.
