Comparing Chlorine Costs

EQArtimus

Active member
Oct 16, 2011
25
I was doing the same calculations over and over to determine the cheapest cost of bleach for my pool -- so I created a spreadsheet that assists with this and thought I would share it.

If you find a source for bleach (i.e. Walmart or Albertsons) and want to know if it is cheaper that another source -- which happens to be at a different dilution or quantity, you can do that easily with this sheet.

Just enter the concentration (6,10, 12.5%), the quantity (Gallons or Oz), and the price. The sheet will return for you the price you would pay for the same amount of chlorine in various volumes and concentrations.

The sheet is locked (so that you can only enter into the cells that are input and not into formulas) but it is not password protected, so if you want to fiddle with it, you may just unlock it.

edit:
Doesn't seem that I can attach it, so I put it up on a webserver here:
http://www.david-traub.com/chlorineCalc.xlsx
 

yeggim

Well-known member
Jul 2, 2010
334
Philly
Nicely done. I like how the prices are extrapolated to reflect the corresponding cost in different concentrations. Makes it easy to compare my cheapest source of household bleach against the pool stores' 12.5% price.
 

CaOCl2

LifeTime Supporter
May 23, 2007
326
Montreal Canada
Because all measurements (from a test kit) and additions of chlorine are done using ppm as a unit of measurement, the spreadsheet should reflect the cost per ppm for whatever source of chlorine.

My own spreadsheet has a columns where you enter product volume, concentration, specific density (if bleach), and price. It then calculates the cost per ppm for a 10,000 liter pool. That number can then be scaled for whatever volume pool.

I know that a 30 ppm shock for my pool costs $1.44 using cal-hypo.
 

HofstraJet

Well-known member
CaOCl2 said:
Because all measurements (from a test kit) and additions of chlorine are done using ppm as a unit of measurement, the spreadsheet should reflect the cost per ppm for whatever source of chlorine.

My own spreadsheet has a columns where you enter product volume, concentration, specific density (if bleach), and price. It then calculates the cost per ppm for a 10,000 liter pool. That number can then be scaled for whatever volume pool.

I know that a 30 ppm shock for my pool costs $1.44 using cal-hypo.

Sounds like a great idea!

Can you please post a link to your spreadsheet?

Thanks!
 

LisaM

Well-known member
May 26, 2011
113
Thanks for the great spreadsheet. I have been trying to figure out if chlorine from the pool store or bleach was cheaper an clearly chlorine from the pool store is cheaper in my area but without this i never would have figured it out. Thanks!!!!
 

JimB

Active member
Jul 5, 2008
37
It appears that the spreadsheet is gone. Does anyone else have it and can post it here or email it to me.
 

npittman

Member
Jun 4, 2012
24
South Louisiana
Just saw on the Clorox website that their bleach will come concentrated in smaller bottles in August! IDK what concentration, but I'm all for smaller bottles to lug!!!
 

Enjoying this content?

Support TFP with a donation.

Give Support

CaOCl2

LifeTime Supporter
May 23, 2007
326
Montreal Canada
For any Canadians reading this, Costco has "HTH Max 70" cal-hypo, 70% concentration, a 22,7 kg bucket for 69,99CDN$, it's a great deal, works out to 0,0440$ per ppm (for 10 000 liters)
 
Thread Status
Hello , This is an inactive thread. Any new postings here are unlikely to be seen or responded to by other members. You will get much more visibility by Starting A New Thread