Septic Service: Estimated Daily Flow

Excel Formulas › Septic Service

All versions

Septic sizing starts with how much water a household sends to the tank each day. Multiply the number of people by a gallons-per-person-per-day figure and you have the design flow that drives tank and field sizing.


Quick formula: Occupants times gallons per person per day:
=B2*C2

Four people at 60 gallons a day each is a 240-gallon daily flow.

Functions used (tap for the full reference guide):

The example

Three homes, each with an occupant count and the gallons-per-person figure used for that home.

ABCD
1HomePeopleGal/personDaily flow
2Home A460240
3Home B660360
4Home C275150

The formula

People times the per-person daily figure is the whole calculation:

=B2*C2 // occupants x gallons per person per day

How it works

Two inputs:

  1. B2 is the number of people the system serves — often taken as two per bedroom for design.
  2. C2 is the gallons-per-person-per-day figure; 60 is a common design value, higher where water use runs heavy.
  3. The product is the estimated daily flow that tank capacity and drain-field size are based on.
  4. Keep the per-person figure in its own cell so you can switch between local design codes.

Many codes size by bedrooms, not occupants, to fix a home's rated capacity regardless of who lives there — swap the people count for bedrooms times two.

Try it: interactive demo

Interactive

Enter the number of occupants and the gallons per person per day.

Variations

Size by bedrooms

Two people per bedroom is a common design assumption.

=(B2*2)*C2

Peak-day allowance

Add a safety factor for guests and laundry days.

=B2*C2*1.5

Pitfalls & errors

This is a design estimate, not a metered flow. Actual use varies with fixtures, habits, and leaks — a running toilet can double the real number.

Check the local per-person figure. Design values differ by jurisdiction, and using the wrong one under-sizes or over-sizes the whole system.

Practice workbook

📊
Download the free Septic Service: Estimated Daily Flow practice workbook
Edit the yellow people and gallons-per-person cells; the daily flow recalculates.

Frequently asked questions

Is 60 gallons per person right?
It is a common design figure, but jurisdictions vary from about 50 to 75. Water-saving fixtures pull the real number down; heavy laundry and long showers push it up. Use your local design value.
Why do codes size by bedrooms?
Bedrooms fix a home's rated capacity no matter who currently lives there, so a system stays adequate when the house changes hands. Two people per bedroom is the usual assumption.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Septic Service: Pump-Out Interval by Household Size · Pool: Gallons From Dimensions · Plumbing: Fixture Units Total

Function references: PRODUCT