Excel Spreadsheet for Septic Tank Design
Download for free this excel spreadsheet tool for the design of septic tanks.
Looking for a simple yet reliable way to design septic tanks? This free Excel spreadsheet is built to help you calculate the volume and dimensions of a septic tank step by step, without the need for complex manual formulas. Whether you’re a civil/environmental engineering student, a practicing engineer, or just curious about how septic tanks are designed, this tool guides you through the process with clarity.
What the Tool Covers
Inside the spreadsheet, you’ll find clearly marked input cells (blue boxes) where you enter your project data. The sheet will then automatically calculate values (yellow boxes). Here’s what you can do with it:
- General Information
- Enter the number of daily users and average water consumption per person.
- The spreadsheet instantly calculates the daily flow rate (Q).
- Based on Q, it suggests the retention time (T) using standard formulas:
- If Q < 6 → T = 24 hours
- If Q between 6–14 → T = 33 – 1.5 × Q
- If Q > 14 → T = 12 hours
- Sludge Volume
- Define the desludging period (e.g., 2–5 years).
- The tool factors in sludge and scum accumulation rates (25 L/person for blackwater, 40 L/person for mixed flows).
- Using the sizing factor (F) table, which adjusts for ambient temperature, the spreadsheet calculates the volume of sludge storage required.
- Basin Dimensions
- After the calculations, the sheet gives you the total septic tank volume and breaks it down into design dimensions.
- It provides guidance on minimum depth (≥1.2 m), freeboard allowance, and tank width (W).
- It also suggests compartment lengths (first compartment ≈ 2/3 of total length, second ≈ 1/3).
- Visual Reference
- The sheet includes a schematic drawing of a two-chamber septic tank (primary + secondary), showing inlet and outlet positions to help visualize the final layout.
How to Use It
- Download the Excel tool (free of charge).
- Fill in the blue input boxes with your project data.
- Review the automatically generated results in yellow boxes.
- Refer to the included tables and figures to adjust values (e.g., sludge factor, retention time).
- Use the final outputs (tank volume, dimensions) for your design drawings or feasibility studies.
To make things even easier, I’ve also prepared a tutorial video that walks you through the process step by step. This way, you can see how the tool works in practice and immediately apply it to your own project.
Why This Tool Is Useful
Makes septic design more accessible for students, NGOs, humanitarian engineers, and professionals working on small to medium wastewater projects.
Saves time compared to manual septic tank sizing.
Ensures designs follow standard engineering practices.
Other Spreadsheets
Wastewater MBBR BOD Removal and Nitrification – Design Sheet