• AWWA IMTECH51397
Provide PDF Format

Learn More

AWWA IMTECH51397

  • Master Planning Utilizing H2ONET Extended Period Simulation and Microsoft Access Generated Summary Reports
  • Conference Proceeding by American Water Works Association, 01/01/1999
  • Publisher: AWWA

$12.00$24.00


In December 1996, the Las Vegas Valley Water District acquired a hydraulicmodeling software package called H2ONET for all of the District's distributionsystem modeling. This modeling consists of steady state analyses for maximum day,peak hour and fireflow analyses, and extended period simulations (EPS) for thedevelopment of operating strategies, evaluation of current system performance,analysis of emergency and planned shutdowns, and master planning. Due to thelarge quantity of data generated by this model, the need for detailed and concisesummary reports was crucial. Since H2ONET produces individual output summariesfor junctions, pipes, pumps, tanks and valves for each hour of the EPS, theindividual summaries could not be transferred as a single file into MicrosoftExcel where previously developed macros were used to produce comprehensive24-hour summaries for all elements of the model. Multiple methods were evaluatedfor resolving this issue. This paper discusses the chosen method in which a datapost processor is used to convert the flat file structure of the model outputinto a relational database format in Oracle. The database tables are then linkedto Microsoft Access where related tables and queries are utilized to producesummary reports. Includes figures, appendix.

Related Products

AWWA DSS60330

AWWA DSS60330

Developing Nashville's Master Water Plan..

$12.00 $24.00

AWWA CONS51061

AWWA CONS51061

Rates, Water Budgets and Outdoor Water Use..

$12.00 $24.00

AWWA ACE99537

AWWA ACE99537

Leveraging Optimization Success Throughout a Utility..

$12.00 $24.00

AWWA ACE95175

AWWA ACE95175

FIELD LOK Gaskets, An Effective Ductile Iron Pressure Pipe Joint Restraining System..

$12.00 $24.00