R-9 Hydraulic Network Topology, Nodal Demands, and Pipe Design Options for MATLAB Modeling
Description
This dataset contains the tabular input data used for graph-based modeling and optimization of the R-9 water distribution network in MATLAB. The Excel workbook includes: (1) 72 pipes with pipe identifier, length, origin node, and destination node; (2) 61 demand nodes with nodal demand, elevation, and minimum required pressure head; and (3) 10 commercial pipe options with diameter, Hazen-Williams coefficient, and historical unit cost. The external source or reservoir connected to node 1 is represented by a dash in the first origin record. The data were adapted and reformatted from the R-9 benchmark reported by Surco, Vecchi, and Ravagnani (2018), based on the network previously described by Gomes et al. (2009). They were used as instructional input in a completed engineering education study on the application of graph theory and MATLAB to model engineering systems, automate the construction of incidence matrices and conservation equations, and support project-based learning in hydraulic network analysis. The workbook contains input data only. It does not contain student information, personal data, simulation outputs, or optimization results. The unit costs are historical benchmark values and should not be interpreted as current market prices. Primary source: https://doi.org/10.2166/ws.2017.148 Underlying benchmark: https://doi.org/10.4314/wsa.v35i4.76801
Files
Steps to reproduce
1. Download the Excel workbook and open the worksheet named “DATOS”. 2. Treat the worksheet as three independent tables: a. Pipes, cells A1:D73: pipe identifier, length in meters, origin node, and destination node. b. Nodes, cells E1:H62: node identifier, demand in liters per second, elevation in meters, and minimum required pressure head in meters. c. Pipe options, cells I1:K11: commercial diameter in millimeters, Hazen-Williams coefficient, and historical unit cost in USD per meter. 3. Replace the dash in the origin field of pipe 1 with a unique identifier for the external source or reservoir, such as node 0 or “Reservoir”. 4. Import the pipe origin and destination columns into MATLAB and construct a directed graph. The resulting representation should contain 61 demand nodes, one external source or reservoir, and 72 pipes. 5. Generate the graph incidence matrix using the imported origin and destination information. 6. Verify the network topology. For a connected graph with 62 vertices and 72 edges, the number of independent cycles is 72 - 62 + 1 = 11. 7. Use the nodal demands to formulate the mass-conservation equations. Use the pipe lengths, selected diameters, Hazen-Williams coefficients, nodal elevations, and minimum pressure requirements to formulate and solve the hydraulic equations. 8. The commercial diameter and unit-cost table can be used to formulate a discrete optimization problem that minimizes the total pipe investment while satisfying the hydraulic constraints. 9. MATLAB was used in the associated educational research, but the tabular data may also be processed using Python, R, EPANET, or equivalent hydraulic-network software.
Institutions
- Pontificia Universidad Católica Madre y MaestraSantiago Province, Santiago