How do you calculate flocculant dose for a pool?

Divide the pool's gallons by 10,000 and multiply by the label rate per 10,000 gallons, then by any multiplier the label permits. A 20,000 gallon pool at 8 fl oz per 10,000 gallons is 2 × 8 = 16 fl oz, the Flocculant Dose calculator's own example.

When can I use more than the label dose?

Only when the label permits a higher rate, for example double for severe cloudiness. Record the highest multiplier each label allows on Setup; any treatment whose severity factor times adjustment goes past it shows Out of limits.

Why count the water vacuumed to waste?

Floc settles to the floor and is vacuumed to waste, so the water goes down the drain and has to be refilled. In the example the refill water costs more than the flocculant: 420 against 256 over the season.

How do I work out the water to waste?

Read a water meter before and after the refill, or multiply the depth lost by the pool's surface area: 1 inch over 600 sq ft is about 374 gallons.

Flocculant or clarifier?

Flocculant clumps fine particles into heavy flocs that sink and are vacuumed to waste, clearing heavy cloudiness fast. Clarifier makes small clumps the filter catches over days. This log is for flocculant treatments.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test treatments and shows Self-check: PASS.

Industry Cost Kits

Flocculant Dose Log Excel Template

Flocculant dose = pool gallons ÷ 10,000 × label rate per 10,000 gallons × any label-permitted multiplier. Log every floc-and-vacuum treatment and see its dose, whether the multiplier stays inside what the label permits, and what the product and the water vacuumed to waste cost, by pool and by month.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This flocculant dose log is a working Excel workbook for pool service technicians, service managers and aquatic facility operators. Each floc treatment is one row with its date, the pool, the product, the severity factor and any further label adjustment, and the water vacuumed to waste; each pool's volume and each product's label rate, highest permitted multiplier, bottle size and price come from Setup. The workbook gives the dose in fluid ounces, checks the multiplier against the label, and costs the product and the refill water for every treatment, pool and month. It ships with a season of 18 treatments on eight pools at a fictional pool service, so every tile and chart is filled in when you open it.

In the example a 20,000 gallon pool on a floc labelled at 8 fl oz per 10,000 gallons takes 16 fl oz, half a 32 fl oz bottle at 18: 9.00 of product. Vacuuming 2,000 gallons to waste at 9.50 per 1,000 adds 19.00, more than the floc. Across the season 371 fl oz of floc cost 256 and 44,200 gallons of water 420. Two treatments went past the label: a second dose on top of a double at one house (2.5× against a 2× label) and a 2× dose of a concentrate whose label stops at 1.5× at the swim club's closing.

The workbook sizes the dose; it does not replace the label's circulation, settling and vacuuming directions. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your company, currency and water cost per 1,000 gallons, the pools with their volume, and the flocculants with their label rate, highest permitted multiplier, bottle size and price
Treatments table, one row per treatment: date, pool, product, severity factor, label adjustment and water vacuumed to waste, with a Check column
Per treatment: volume basis, label dose, multiplier, dose, a label check in words, bottles, product cost, water cost and treatment cost
Dashboard with four tiles (treatments, flocculant used, treatments over the label multiplier, treatment cost), flocculant by month, treatment cost by pool, and the pool and six-month tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Flocculant Dose calculator (Self-check: PASS)
CSV with live formulas for the Treatments table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to dose floc treatments from each pool's volume and the label, to catch technicians going past the label multiplier, or to see what clearing cloudy water costs each pool in product and refill water.

How to use it

On Setup, type your company, currency and water cost, list your pools with their volume, and your flocculants with their label rate, highest permitted multiplier, bottle size and price.
On Treatments, give each treatment a row: date, pool, product, severity factor, label adjustment and the water vacuumed to waste.
Fix anything the Check column names.
Open the Dashboard: flocculant by month, cost by pool, and any treatment over the label multiplier.

Frequently Asked Questions

How do you calculate flocculant dose for a pool?: Divide the pool's gallons by 10,000 and multiply by the label rate per 10,000 gallons, then by any multiplier the label permits. A 20,000 gallon pool at 8 fl oz per 10,000 gallons is 2 × 8 = 16 fl oz, the Flocculant Dose calculator's own example.
When can I use more than the label dose?: Only when the label permits a higher rate, for example double for severe cloudiness. Record the highest multiplier each label allows on Setup; any treatment whose severity factor times adjustment goes past it shows Out of limits.
Why count the water vacuumed to waste?: Floc settles to the floor and is vacuumed to waste, so the water goes down the drain and has to be refilled. In the example the refill water costs more than the flocculant: 420 against 256 over the season.
How do I work out the water to waste?: Read a water meter before and after the refill, or multiply the depth lost by the pool's surface area: 1 inch over 600 sq ft is about 374 gallons.
Flocculant or clarifier?: Flocculant clumps fine particles into heavy flocs that sink and are vacuumed to waste, clearing heavy cloudiness fast. Clarifier makes small clumps the filter catches over days. This log is for flocculant treatments.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test treatments and shows Self-check: PASS.