Complete Excel sheet For STP Design with Bar Screen, Equalization, MBBR Tanks, Clarification & Filtration

Designing a sewage treatment plant means sizing several unit processes together — screening, equalization, biological treatment, clarification, and filtration — while keeping hydraulic retention time, air demand, and tank volumes consistent across the whole train. The Complete STP Design Excel Sheet from GrowMechanical automates that full train in one spreadsheet, built around a proven 2500 KLD MBBR-based reference design that you can rescale to your own project capacity.

It is built for environmental engineers, civil and process engineers, EPC contractors, and consultants designing sewage treatment plants for municipalities, townships, industrial campuses, and institutional facilities.

Treatment Train Covered by This Spreadsheet

• Bar Screen Chamber — removes rags, plastics, and coarse suspended solids
• Equalization Tank — stabilizes flow and homogenizes influent quality
• Two-Stage MBBR Biological Tanks — staged BOD reduction using moving bed biofilm reactor media
• Tube Settler / Secondary Clarifier — separates biomass sludge from treated water
• Pressure Sand Filter (PSF) — removes residual suspended solids and turbidity
• Activated Carbon Filter (ACF) — polishes treated water and removes odor/color
• Sludge Handling System — supports hygienic, mechanized solids disposal

What the Spreadsheet Calculates

• Flow rate and hourly hydraulic loading from your plant capacity (KLD)
• Bar screen chamber sizing
• Equalization tank volume based on flow variability
• MBBR tank volumes and hydraulic retention time (HRT) per stage
• Media fill fraction and biological surface area
• Aeration air flow requirement
• Clarifier, PSF, and ACF sizing
• Expected BOD/COD reduction across the treatment train

Reference Design: 2500 KLD MBBR-Based STP

The spreadsheet is built around a fully worked 2500 KLD (kiloliters per day) reference case so you can see realistic, validated numbers before adapting the sheet to your own capacity:

Key Features

• Fully editable Excel workbook covering the complete treatment train in one file
• Scalable: rebuild every tank and equipment size for your own plant capacity
• Two-stage MBBR sizing with independent HRT calculation per stage
• Aeration air demand calculation for blower selection
• Backwash system sizing included for PSF and ACF units
• Robust, corrosion-resistant design assumptions suitable for above-ground, below-ground, or semi-underground installation

Typical Applications

• Municipal sewage treatment plant design
• Housing societies and residential townships
• Industrial worker colonies and campuses
• Hotels, resorts, and institutional facilities
• Hospitals and healthcare facility wastewater systems
• Food, textile, pharmaceutical, and general industrial effluent treatment

Who Should Use This Spreadsheet

Environmental engineers, civil and process engineers, EPC contractors, and consultants who need to size an MBBR-based sewage treatment plant quickly, produce a defensible design basis, or scale a proven reference design to a new project capacity.

What You’ll Receive

• One fully editable Excel workbook covering the full STP treatment train
• The complete 2500 KLD reference design as a working example
• Instant digital download after purchase
• Lifetime access to your downloaded file, with free updates if the sheet is revised

Compatibility

Compatible with Microsoft Excel 2010 and later, and Excel for Microsoft 365, on Windows and Mac.

How to Use This STP Design Spreadsheet

1. Enter your required plant capacity (KLD) and inlet BOD/COD values
2. Review the automatically recalculated flow rate and hydraulic loading
3. Check equalization tank, MBBR stage, clarifier, and filtration sizing outputs
4. Confirm aeration air demand for blower selection
5. Export the summary sheet for your design basis or tender documentation

For utility water and pump systems feeding this treatment train, see our centrifugal pump design and selection tool. For solids handling and separation equipment upstream, our vertical drum separator design Excel sheet and filter sizing calculation spreadsheets are directly relevant. If your plant includes a scrubber for odor control, see our scrubber design and selection Excel sheet. For a full project package, the Engineering Design & Calculation Master Excel Bundle bundles process and utility calculators together, and you can browse our full library of process engineering Excel calculators for more tools.

Frequently Asked Questions

Can I use this for a plant capacity other than 2500 KLD?

Yes. The 2500 KLD case is a fully worked reference design; every tank size, HRT, and air demand formula is editable so you can scale the entire treatment train to your own required capacity.

What treatment technology does this spreadsheet size?

It sizes an MBBR (Moving Bed Biofilm Reactor) based treatment train with two biological stages, followed by clarification, pressure sand filtration, and activated carbon filtration.

Does the spreadsheet include sludge handling?

Yes, sludge handling is included as part of the treatment train design, supporting mechanized and hygienic solids disposal from the clarification stage.

Is this suitable for industrial effluent as well as municipal sewage?

Yes. The same MBBR-based treatment train design applies to domestic sewage and many industrial wastewater streams; you should adjust inlet BOD/COD and flow variability assumptions to match your specific effluent characteristics.

How is the file delivered?

As an instant digital download immediately after purchase, so you can begin your STP design the same day.

Get Your Complete STP Design Sheet Today

Skip re-deriving tank volumes and HRT for every treatment stage. Download the Complete STP Design Excel Sheet and size your full MBBR-based sewage treatment plant from a proven 2500 KLD reference design in minutes.