Home › Shop › Filter Sizing and Pressure Drop Evaluation
Excel tool

Filter Sizing and Pressure Drop Evaluation

How many filter units do you need for this flow, how fast will the pressure drop climb, and when must you change the elements out?

Size a liquid or gas filter and follow its pressure drop: area and units from a flux limit, clean and cake pressure drop, constant rate or pressure, time to the limit, cycle capacity, wash and backwash, and a change-out trigger from your readings.

USD 39 one-time purchase

  • Excel workbook (.xlsx), no macros, version v1.0
  • Excel 2010 or later, Windows and Mac
  • Instant download after payment; updates to this major version included
  • Single-user licence; team and site options
  • Refund if it does not work as described or has an error we cannot fix: contact support within 14 days of purchase — full refund policy
Filter Sizing and Pressure Drop Evaluation — sample pages

What it does

Area and number of units

Filter area from your flux or face-velocity limit, and the number of units rounded up, or your installed number.

Clean pressure drop

From Darcy medium data, or one clean point on the maker's curve scaled with flow and viscosity.

Cake pressure drop

From specific cake resistance, solids concentration, density and porosity, for constant-rate or constant-pressure filtration.

Time to the limit

Filtration time to the pressure drop limit, terminal flux, dirt capacity or your maximum time, with the one that governs named.

Cycle capacity

Filtrate and solids per cycle, cake thickness, wash and backwash volumes, cycle time and units for continuous service.

Change-out trigger

Up to six differential-pressure readings with a trend, an alert level and the time left before the limit.

Built for engineers

  • Visible formulas — nothing hidden, so you can check every step.
  • Fully referenced — methods from the standard references, checked against their published worked examples.
  • Safe to share — sheets are protected against accidental edits, with an open password so you can still customise.
  • Built-in input checks — clear warnings for impossible inputs and values outside typical ranges.

For engineering estimates; verify against site data. Code-based methods are aligned with the publicly documented procedure; they are not a licensed reproduction or a certification.

Preview the workbook

An illustration of the sheet layout of this workbook, not a screenshot of calculated results. Select the image to enlarge it. For questions before you buy, email [email protected].

Filter Sizing and Pressure Drop Evaluation Excel workbook sample pages
Layout illustration (not a results screenshot).

Specification and checks

FormatExcel workbook (.xlsx), no macros
Versionv1.0
Works inExcel 2010 or later, Windows and Mac
UnitsSI, US and British, mixed freely
IncludesGuide tab with method and references, calculator, print-ready report
Checked againstAn independent Python model that integrates the filtration equations numerically (the workbook uses the closed forms): the default case, every combination of service, filter type, filtration mode and clean-pressure-drop basis, SI, US and British unit variants with every input and result unit switched, and edge cases (blank, zero, negative, text and invalid inputs give a clear message and blank results, never an error value).
Free versionTry the free pipe pressure drop calculator

Compatibility, licence and support

FileExcel workbook (.xlsx), no macros, version v1.0; works in Excel 2010 or later on Windows and Mac. Sheets are protected against accidental edits, with an open password so you can customise.
LicenceSingle user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms.
UpdatesUpdates to this major version are included; download them again from the link in your receipt.
SupportEmail [email protected] with your order number — questions on the method, your inputs or your results are welcome.
RefundsIf the tool does not work as described, or has an error we cannot fix, email [email protected] with your order number within 14 days of purchase and we will refund you in full. Refunds are not offered for a change of mind once a file has been downloaded. Read the full refund policy.