New Tool Release: Municipal Water Demand Forecaster

New Tool Release: Municipal Water Demand Forecaster

Before you can size a pipe, select a pump, or design a treatment plant, you have to answer one fundamental question: How much water will this community actually need 20 years from now?

In municipal engineering, underestimating demand leads to low pressure, water shortages, and system failure. Overestimating leads to oversized, stagnant pipes and wasted millions in capital expenditure. To help engineers build perfectly scaled master plans, I am thrilled to release the Municipal Water Demand Forecaster! 📈🏙️

This web-based workstation automates geometric population projections, accounts for system leakage (Non-Revenue Water), and applies standard peaking factors to generate your exact Average Daily Demand (ADD), Maximum Daily Demand (MDD), and Peak Hourly Demand (PHD) over any design horizon.

civilsheets.blogspot.com/p/municipal-water-demand-forecaster.html
Municipal Water Demand Forecaster
Master Planning & System Sizing
Metric (MLD)
Imperial (MGD)
Export Projections
1. Population Dynamics
Base Year
2026
Design Horizon
20 yrs
Current Population ($P_0$)
50,000
Annual Growth Rate ($r$)
2.5 %
2. Consumption & Losses
Per Capita Demand
Dom, Com, Inst
150 Lpcd
Non-Revenue Water
Leakage & Unbilled
20 %
3. Peaking Factors
Max Day Factor (MDF)
1.8
Peak Hour Factor (PHF)
3.0
DESIGN YEAR 2046
Future Population
81,931
Avg Daily Demand
Base Production
15.36 MLD
Max Daily Demand
Plant/Storage Design
27.65 MLD
Peak Hourly Demand
Pipe/Pump Design
46.09 MLD
Infrastructure Capacity Scaling Visualizing NRW and Peaking Impacts
Capacity (MLD) 12.3 Net Demand Domestic/Com +20% NRW 15.4 Avg Daily (ADD) Sizes WTP & Sources ADD × 1.8 27.7 Max Daily (MDD) Sizes Storage Tanks ADD × 3.0 46.1 Peak Hour (PHD) Sizes Pipe Network

The Engineering Problem: Designing for the Extremes

If a community uses 1 million liters of water over the course of a day, you cannot simply build a treatment plant and pipe network that delivers exactly 11.5 liters per second continuously. Water consumption is highly variable.

To ensure pipes maintain pressure and reservoirs never run dry, engineers segment water demand into three critical design tiers:

  • Average Daily Demand (ADD): The total annual water volume divided by 365. This dictates your raw water source (reservoirs, wells) and the baseline operational capacity of your Water Treatment Plant. It is calculated by multiplying the population by the per capita usage, and adding a buffer for Non-Revenue Water (NRW).
  • Maximum Daily Demand (MDD): The highest 24-hour usage day of the year (usually in mid-summer during a drought). Treatment plants and strategic distribution tanks are sized to handle this to ensure the city doesn't run out of water over a 24-hour cycle. (Typically 1.5x to 2.5x ADD).
  • Peak Hourly Demand (PHD): The highest 1-hour usage period (usually 7:00 AM when everyone showers, or 6:00 PM when irrigation kicks on). This is what sizes your pipes and booster pumps. If the pipes are sized for ADD, turning on a tap during PHD will result in a pathetic dribble of water because the friction loss in the undersized pipes will consume all the pressure. (Typically 2.5x to 4.0x ADD).

The Municipal Water Demand Forecaster automates this entire planning progression, calculating how geometric population growth compounds against system losses and peaking factors over your project's lifecycle.


How to Use the Workstation

This solver eliminates spreadsheet errors and provides instantaneous master planning curves. Here is the workflow to build your projection:

1

Define Population Dynamics

Enter the starting year, your planning horizon (typically 20 or 30 years), the current baseline population, and the expected annual geometric growth rate ($r$). The tool will calculate the exact compounded population size for the design year.

1. Population Dynamics
Design Horizon
20 Years
Annual Growth Rate (r)
2.5 %
2

Set Consumption & Losses

Input the per capita demand (Lpcd or Gpcd). If you don't know it, use the built-in dropdown to select a standard preset (e.g., 150 Lpcd for a suburb). Crucially, input your expected Non-Revenue Water (NRW) percentage to account for physical pipe leakage and unbilled municipal usage.

2. Consumption & Losses
Per Capita Demand (q)
150 Lpcd
Non-Revenue Water
20 %
3

Define the Peaking Factors

Enter the multipliers for the Maximum Day and Peak Hour. The tool contains integrated AWWA theory tables to guide your selection (e.g., MDF = 1.8, PHF = 3.0) if local codes are unavailable.

4

Extract the Master Plan Flow Rates

The tool instantly calculates the compounded population and computes the exact volumetric flow rates needed for the Design Year. The visual waterfall chart shows exactly how NRW and Peaking multipliers drastically upsize your final infrastructure capacity requirements.

Avg Daily Demand
15.36 MLD
Max Daily Demand
27.65 MLD
Peak Hourly Demand
46.09 MLD

Smart Features & Integrated Theory

Reference Tables Built-In

No need to constantly open your fluid mechanics textbook. The Master Planning Methodology section at the bottom of the tool includes handy reference tables detailing typical per capita consumption (by development type) and AWWA-standard peaking factor ranges, complete with full citations.

Interactive Projections

The dynamic line chart visually maps the compounding effect of population growth against the three demand tiers across the entire lifespan of the project. Hover over the chart to see exact interpolated capacities for intermediate years.

Export and Report

Once you are satisfied with the inputs, scroll down to the Year-by-Year Projection Table to see the exact numerical capacities required for every year of the design horizon. Click the Export Projections button to download a pristine CSV report to directly append to your engineering master plan calculations.

Head over to the tool page to start building your projection! If you find this helpful, or if you want to see extended capabilities (like fire flow calculations) added to CivilSheets, let me know in the comments.

Happy Designing!
- CivilSheets

No comments:

Post a Comment

New Tool Release: RC Column Analysis & P-M Interaction Diagram Generator

New Tool Release: RC Column Analysis & P-M Interaction Diagram Generator Designing reinforced concrete ...