Guessing from the bucket wastes chemicals on one pool and leaves the next one cloudy. This calculator works out each pool's gallons from its size, compares your test results with your target ranges for chlorine and salt pools, and gives an Estimated dose, cost and how to add it.
Every step is laid out before you buy, so you can see how a dose gets worked out with screenshots from the real file. It also works hand in hand with our pool service quote calculator.
What the Pool Chemical Dosing Calculator does
- Pool gallons from length, width and depth for rectangle, round, oval and freeform pools
- Free chlorine, pH, alkalinity, calcium, stabilizer and salt, with Low, In range or High
- Doses of liquid chlorine, acid, soda ash, baking soda, calcium, stabilizer and salt
- Separate target ranges for chlorine and salt pools
- Your own prices and label doses, with the cost of every visit
- Drain-and-refill share when calcium, stabilizer or salt is too high
- Chemical cost per visit, ready to copy into the Pool Service Quote Calculator
What's inside
7 tabs: Start Here, Dashboard, Dose, Pools, Products, Lists, Settings.
Who it's for
Pool techs who want the right dose for every pool and the cost of every visit.
What you get
Two spreadsheet files (.xlsx): one filled with examples so you can see exactly how it works, and a blank copy ready for your business. For Microsoft Excel and Google Sheets. No macros, no subscription.
The formulas are locked, so a stray keystroke can't break them. You only type in the yellow cells.
What you need to use it
- Microsoft Excel 2010 or newer, on Windows or Mac, including Microsoft 365
- Or Google Sheets in any web browser, free with a Google account
- A laptop or desktop works best for setup. Phones and tablets are fine for checking numbers and quick entries.
- No macros, add-ins or internet connection needed once it's downloaded. Apple Numbers isn't supported.
Doses are Estimated starting points from common pool chemistry charts. Always follow the product label, add in stages and retest. Never mix chemicals.
Questions
Can I use my own products?
Yes. Type your price and the dose from your label on the Products tab.
Does it handle salt pools?
Yes. Each pool is Chlorine or Salt, and salt pools use their own target ranges and get a salt dose.
Is there a blank version?
Yes. Every download has two files: one filled with examples so you can see how everything works, and a blank copy ready for your own business. Your rates and settings come filled in as a starting point, so change them to match yours.
Can I change the formulas?
The gray formula cells are locked so they can't be erased by accident. If you really want to change one, open Review in Excel and choose Unprotect Sheet. There's no password.
Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The math works the same. Locks don't carry over, so just type in the yellow cells.
How do Free Lifetime Updates work?
Whenever we release a new version, you can download it free from your account, forever. We'll email you when there's something new.
