DDW-2024-013003

Capacity calculation sheet.xlsx Page 1 of 10/27/2024
Division of Drinking Water Water System Capacity Calculation Sheet—
yes
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
- - - - - - - - -
yes
- - - - - - - - - - - - - - - - -
- - - > > >
- - - > > >
- - - > > >
- - - > > >
- - - > > >
(Last Update 3/30/2017)
gpd/ERC Total (gpm)Gallons/ERC Total (gallons)
52%
gpd/ERC Total (gpm)Gallons/ERC Total (gallons)
gpd/ERC Total (gpm)Gallons/ERC Total (gallons)
88.3
300.0
124,440
*Enter the green cells only*
Rainbow Ranchos 11048System Name System Number
per residential connection
other connections
flow
duration
1.1 Indoor Water Use
1.2 Outdoor Water Use
1.3 Fire Flow Water Use
2. Summary of Water System Capacity Requirements
Number of residential connections - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -
Number of other connections - - - ERCs of other connections
Total Equivalent Residential Connections (ERCs)
Source Storage
Is the drinking water used for outdoor irrigation?
Residential ERCs using drinking water for irrigation
Percentage of Residential ERCs using DW for irrigation
Average irrigated acreage
Total irrigated acreage of (park, school, etc.)
Irrigation zone
Source Storage
Does the water system provide fire protection?
Maximum fire demand (in gpm) for or
Maximum fire suppression (in hours) for or
Required Fire Suppression Storage (in gallons)

- - - - - - - - 97
0 0.9
50
0.20
0.00
(Enter notes here regarding whether and what % of
irrigation water is supplied by PWS.)
3
Enter notes here, e.g.
fire official contact info or comments.)
(Example: water use of 2 factories
equals to water use of 55 homes.)
97.9
MIN. REQUIREMENTS FOR INDOOR WATER USE
MIN. REQUIREMENTS FOR IRRIGATION USE
60,000
MINIMUM REQUIREMENTS FOR WATER SYSTEM
Source Storage
None
339.8%
800 400
976 506
1,776 906
54.4 39,160
33.9 25,280
88.3 124,440
Map Zones
1
2
3
4
5
6
water system pressure zone
water system pressure zone
1,000
1
(*Verify req'd fire flow and duration with local fire code officials.*
(indoor + outdoor)(indoor + outdoor + fire)
2.1 Does this system have adequate source capacity (per R309-510-7)?
Required Source Capacity gpm
Existing Source Capacity gpm
Source Capacity Deficit gpm
Existing % of Total Req'd
2.2 Does this system have adequate storage capacity (per R309-510-8)?
Total Required Storage gal
This source capacity assessment is a general overall system calculation. It may not reflect the variations in individual areas or pressure zones.
This storage capacity assessment is a general overall system calculation. It may not reflect the variations in individual areas or pressure zones.
Capacity calculation sheet.xlsx Page 2 of 10/27/2024
Existing Storage Capacity gal
Storage Capacity Deficit gal
gal
Is storage deficiency solely due to
fire storage?
Existing % of Total Req'd
w/ flush toilets
w/o flush toilets
w/ flushometer valves
302,000
60,000
MINIMUM REQUIREMENTS FOR INDOOR USE
60 0 30 0
20 0 10 0
5 0 2.5 0
N/A 100 N/A 50
7 3.5 8.8
Total Existing Source Capacity (in gpm)
Total Projected ERCs
3
Total Existing Storage Cap. (in gallons)
None
Not
Applicable
242.7%
Modern Recreation Camp 0.00 0.0
Semi-Developed Camp 0.00 0.0
Semi-Developed Camp 0.00 0.0
RV Park 0.13 0.0
Roadway Rest Stop 0.0
300
100
302,000
Required Fire Storage
(See R309-510, Tables 510-1, 2, & 4 for other facility types.)
Number of people per camp site
3. Transient PWS Indoor Water Use ERC Calcuation
4. Data Input for Calculating ERCs, Source and Storage
—
Source Storage
Facility Type
Source Storage
GPD/person*GPD/site or pad Gallons/person Gallon/siteor pad ERC/site or pad
(GPD/vehicle)(Gal./vehicle)
ERC/1000
vehicles served
Vehicles
served/day
Residential Connections
Obligated ERCs
Total # of sites/pads ERCs
ERCs
Existing
Future
0
0
0
0
0
0
WS002 1996 Well 300
97
3 empty lots
ST001 Rainbow Ranchos Tank 35,000
ST002 Rainbow Ranchos Newtank 267,000
(Enter notes here. If additional space is needed, click the "Additional Notes"
tab on the bottom of the screen.)
4.2 Summary - Existing Sources
4.1 Projected ERCs Calculation (optional)
4.3 Summary - Existing Storage Tanks
(enter in green cells below)
(enter below)
(enter below)
Rainbow Ranchos
Maximum ERCs (assuming indoor use only)540
Capacity calculation sheet.xlsx Page 3 of 10/27/2024
Additional Notes
System Name: System Number:Rainbow Ranchos 11048
(Enter additional notes here, for example, water system information related to capacity calculations, etc.)
Capacity calculation sheet.xlsx Page 4 of 10/27/2024
Capacity calculation sheet.xlsx Page 5 of 10/27/2024
Irrigation Demands & ERCs
(This reference table is used to automate the calculations in the PWS Capacity Calculation sheet. Do not alter.)
System Name: System Number:Rainbow Ranchos 11048
Zone Peak Day Avg Year Storage
Demand Demand Reqmt (to be added to indoor and fire flow demands)
3.39 1.66 2,528 Avg. Yr.Storage Peak
Peak Day (ac-ft/yr Requirement Instantaneous
zone (gpm/irr. ac)per irr. ac.)(gal/irr. ac)(gpm/irr. ac)
1 2.26 1.17 1,782 4.52
2 2.80 1.23 1,873 5.60
3 3.39 1.66 2,528 6.78
4 3.96 1.87 2,848 7.92
5 4.52 2.68 4,081 9.04
6 4.90 3.26 4,964 9.80
IRRIGATION DEMANDS
3
Capacity calculation sheet.xlsx Page 6 of 10/27/2024