In December 1996, the Las Vegas Valley Water District acquired a hydraulic
modeling software package called H2ONET for all of the District's distribution
system modeling. This modeling consists of steady state analyses for maximum day,
peak hour and fireflow analyses, and extended period simulations (EPS) for the
development of operating strategies, evaluation of current system performance,
analysis of emergency and planned shutdowns, and master planning. Due to the
large quantity of data generated by this model, the need for detailed and concise
summary reports was crucial. Since H2ONET produces individual output summaries
for junctions, pipes, pumps, tanks and valves for each hour of the EPS, the
individual summaries could not be transferred as a single file into Microsoft
Excel where previously developed macros were used to produce comprehensive
24-hour summaries for all elements of the model. Multiple methods were evaluated
for resolving this issue. This paper discusses the chosen method in which a data
post processor is used to convert the flat file structure of the model output
into a relational database format in Oracle. The database tables are then linked
to Microsoft Access where related tables and queries are utilized to produce
summary reports. Includes figures, appendix.
| Edition : | Vol. - No. |
| Number of Pages : | 26 |
| Published : | 01/01/1999 |
