Become a TFP Supporter Pool Math Forum Rules Pool School
Results 1 to 7 of 7

Thread: Borates addition calculation spreadsheet

  1. Back To Top    #1

    Join Date
    Sep 2016
    Location
    Tampa, FL
    Posts
    17

    Borates addition calculation spreadsheet

    I read the add borates section and created an (extremely ugly) spreadsheet (xls and xlsx files available)Borates calculation.zip to simplify the decision on which way to go (easy with poolproof) or still easy with the TFP system (20 mule borax and muriatic acid).

    All you need to do is add the gallons of your pool in the green cell.

    Please note:
    Costs are "hard coded" as per small print.
    This works for a chlorine pool
    It simply uses the calculation included in pool school


    Any comment/feedback is welcome and I will be happy to update the file! My small contribution to a great forum!!

    Borates calculation.zip
    Tampa, FL 16,000 gallons, concrete in ground screened pool, Sta-Rite 70sqft cartridge filter, Marathon 3/4 Pump, city water. I test with Taylor K-2006

  2. Back To Top    #2
    JoyfulNoise's Avatar
    Join Date
    May 2015
    Location
    Tucson, AZ
    Posts
    8,811

    Re: Borates addition calculation spreadsheet

    Your spreadsheet could be improved by comparing the costs of adding borates to a pool either by using the borax/MA method OR by using boric acid. Boric acid can be obtained form several sources but the best one by far in terms of price is from Duda Diesel. They can ship boric acid in 55lb containers for less than $80 total (usually).

    If one wants to add borates, it is almost always easier to use boric acid rather than 20 Mule Team Borax. Borax acts like a strong base and raises the pH very quickly which is why you need muriatic acid to compensate. This often leads to pool water cloudiness as the borax can induce localized scaling of calcium. The borax method typically requires the pool owner to add the borates in batches to avoid high pH and scaling. The borax/MA method also causes wild swings in pH (low pH when you add the MA then high pH when you add the borax) which is a lot harder on the pool surfaces and equipment.

    Boric acid, on the contrary, is a weak acid. You can pretty much add an entire quantity of boric acid needed to raise the borate level to 50ppm all in one batch with only a small decrease in pH, typically around 0.3-0.4 units. That makes boric acid much, much easier to handle and work with.

    Most people will find the boric acid method so much easier to implement that they'll pay more for boric acid simply to avoid the hassle of the borax/MA method. When I borated my pool several years ago, the difference in cost between the two methods was about $10 with the boric acid being the more expensive route. It was easily worth the additional $10 to not have to deal with premixing 13 boxes of borax in 5 gallon pails and adding 3+ gallons of MA. My pH dropped by a total of 0.3 units (which is fine by me since my pH is typically up at 7.6-7.8) and the entire process took less than 45mins to complete.
    Matt
    16k IG PebbleTec pool, 650gal spa, spillway and waterfall, 3HP IntelliFlo VS / 1.5HP WhisperFlo, Pentair QuadDE-100 filter, IC40 SWCG, MasterTemp 400k BTU/hr NG heater, KreepyKrauly suction-side cleaner Dolphin S300i robot, EasyTouch controls, city water, K-1001, K-2006 and K-1766 test kits, Mannitol test for borates

  3. Back To Top    #3
    Mod Squad pooldv's Avatar
    Join Date
    Aug 2012
    Location
    DFW, TX
    Posts
    20,494

    Re: Borates addition calculation spreadsheet

    PoolMath will do the calculation and tell you how much borax and acid to add.
    TFP Moderator
    If TFP helped you or saved you money - Become a TFP Supporter! <--Click here
    2012 build and pics, 20k gal gunite, black onyx pebblesheen, OK flagstone, IntellifoVS, cart filter w/Pleatco, IC40 SWG, Solartouch, 5 12'x4' solar panels, HP50HA heat pump, 8mil solar cover, borates, TF-100 test kit, SONOS, Doheny's Discovery Robot, hot tub on bleach

  4. Back To Top    #4

    Join Date
    Sep 2016
    Location
    Tampa, FL
    Posts
    17

    Re: Borates addition calculation spreadsheet

    Well that was a waste of everyone's time!
    Thank you for the info!
    Tampa, FL 16,000 gallons, concrete in ground screened pool, Sta-Rite 70sqft cartridge filter, Marathon 3/4 Pump, city water. I test with Taylor K-2006

  5. Back To Top    #5
    Cuzmail's Avatar
    Join Date
    Aug 2016
    Location
    Needville area of Texas
    Posts
    17

    Re: Borates addition calculation spreadsheet

    Quote Originally Posted by JoyfulNoise View Post
    Boric acid can be obtained form several sources but the best one by far in terms of price is from Duda Diesel.
    Are you buying the granular or powdered boric acid?
    50,000 gallon in ground plaster old school wonder. 4' to 12' depth with a 7' round spa.

  6. Back To Top    #6
    JoyfulNoise's Avatar
    Join Date
    May 2015
    Location
    Tucson, AZ
    Posts
    8,811

    Re: Borates addition calculation spreadsheet

    Granular. Powdered is too fine and will be difficult to work with.
    Matt
    16k IG PebbleTec pool, 650gal spa, spillway and waterfall, 3HP IntelliFlo VS / 1.5HP WhisperFlo, Pentair QuadDE-100 filter, IC40 SWCG, MasterTemp 400k BTU/hr NG heater, KreepyKrauly suction-side cleaner Dolphin S300i robot, EasyTouch controls, city water, K-1001, K-2006 and K-1766 test kits, Mannitol test for borates

  7. Back To Top    #7
    Cuzmail's Avatar
    Join Date
    Aug 2016
    Location
    Needville area of Texas
    Posts
    17

    Re: Borates addition calculation spreadsheet

    Quote Originally Posted by JoyfulNoise View Post
    Granular. Powdered is too fine and will be difficult to work with.
    Thanks! Ordering this weekend.
    50,000 gallon in ground plaster old school wonder. 4' to 12' depth with a 7' round spa.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •