Plumbing: Drain Slope and Total Fall

Excel Formulas › Plumbing

All versions

A quarter inch per foot is the number every plumber knows. Multiply it by the run and you get the total fall — the number that decides whether the line clears the joists or ends up under the slab.


Quick formula: Run times slope gives total fall:
=PRODUCT(B2,C2)

A 32-foot branch at a quarter inch per foot has to drop 8 inches from fixture to stack.

Functions used (tap for the full reference guide):

The example

Three drain runs at the pitches typically used for their pipe sizes.

ABCDE
1LineRun (ft)Slope (in/ft)Fall (in)Grade %
2Kitchen branch320.258.002.08%
3Bath group180.254.502.08%
4Main to street640.1258.001.04%

The formula

PRODUCT multiplies the two inputs; a second formula converts the pitch to a percent grade:

=PRODUCT(B2,C2) // run in feet x slope in inches per foot = fall in inches

How it works

Keep the units straight and the rest is easy:

  1. B2 is the developed length in feet, measured along the pipe rather than across the room.
  2. C2 is the slope in inches per foot — 0.25 for a quarter inch, 0.125 for an eighth.
  3. PRODUCT(...) multiplies them to give the fall in inches.
  4. =C2/12 expresses the same pitch as a percent grade for the plan set.

Pipes 3 inches and larger are often allowed an eighth inch per foot; 2-inch and smaller usually want the full quarter. Halving the slope halves the fall, which is often what saves a tight ceiling.

Try it: interactive demo

Interactive

Enter the run length and the pitch you are working to.

Variations

Invert elevation at the far end

Subtract the fall from the starting invert to get the finish height.

=D2-PRODUCT(B2,C2)

Slope from a known fall

Work backwards when the two ends are already fixed.

=D2/B2

Pitfalls & errors

Too much slope is a real problem, not a safety margin. Water outruns the solids and the line clogs — a rule of thumb is to stay at or under half an inch per foot on horizontal branches.

Measure developed length, following every offset, not the straight-line distance on the floor plan. Offsets add feet and therefore add fall.

Practice workbook

📊
Download the free Plumbing: Drain Slope and Total Fall practice workbook
Edit the yellow run and slope cells; fall and grade recalculate.

Frequently asked questions

Quarter inch or eighth inch per foot?
Most codes require a quarter inch per foot for pipe 2.5 inches and under, and permit an eighth for 3 inches and larger. Your local amendment is the final word.
How does this relate to percent grade?
A quarter inch per foot is 0.25/12, or about 2.08%. An eighth is roughly 1.04%. Engineers usually speak in percent, plumbers in inches per foot.

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: Plumbing: Multi-Fixture Quote · Plumbing: Service Call Quote · Slope Intercept

Function references: PRODUCT