Stabilizer (CYA) Addition

Excel Formulas › Pool & Spa Service

All versionsMAX

Cyanuric acid (CYA) stabilizes chlorine against sunlight. Like salt, it’s dosed by the ppm shortfall and volume — and can only be lowered by dilution, so don’t overshoot.


Quick formula: pounds of stabilizer to add:
=MAX(target_cya - current_cya, 0) * gallons / 120000
The CYA ppm gap times gallons over a constant. A 30-ppm raise in 20,000 gal is ~5 lb.

Functions used (tap for the full reference guide):

The example

20,000 gal, 20 → 50 ppm.

AB
1ItemValue
2(50−20)×20000/120000—
3Stabilizer→ ~5 lb

The formula

The formula:

=MAX(target_cya - current_cya, 0) * gallons / 120000 // CYA gap × volume ÷ constant

How it works

How it works:

  1. CYA gap = target − current; MAX(…, 0) since you can’t add negative.
  2. Multiply by gallons and divide by the constant (~120,000 for lb/ppm).
  3. CYA dissolves slowly — add via the skimmer sock and allow days; retest before re-dosing.
  4. Too-high CYA weakens chlorine; the only fix is dilution.

Educational use only — not chemical-safety or professional advice. Pool chemical dosing varies by product strength, water chemistry, and local rules. Always follow the product label, add chemicals to water (never water to chemical), test before and after, and never mix chemicals. Verify with a professional.

Try it: interactive demo

Live demo

Gallons, current CYA, target CYA.

Stabilizer:

Variations

In ounces

Pounds × 16:

=pounds * 16

Over target?

Dilute to lower:

=IF(current_cya>target_cya, "Dilute", "Add CYA")

Dilution fraction

Drain & refill share:

=1 - target_cya/current_cya

Pitfalls & errors

Dissolves slowly. Add via sock, wait days, retest before more.

Floor at zero. You can’t add negative stabilizer.

Overshoot = dilute. High CYA only comes down by water replacement.

Practice workbook

📊
Download the free Stabilizer (CYA) Addition practice workbook
A CYA sheet with the ounces, over-target, and dilution variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate stabilizer (CYA) to add in Excel?
CYA gap times gallons over a constant: =MAX(target_cya - current_cya, 0) * gallons / 120000.
How do I lower high CYA?
Only by dilution — partial drain and refill: =1 - target_cya/current_cya.
How fast does CYA dissolve?
Slowly — add via a skimmer sock, allow several days, and retest before adding more.

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: Salt to add for a target ppm · Chlorine dose to raise FC · Pool volume in gallons

Function references: MAX