|
It is currently February 11th, 2012, 1:07 am
|
 |
|
 |
|
| Author |
Message |
|
taekwondodo
|
Post subject: Re: The Pool Calculator  Posted: August 31st, 2009, 1:37 am |
| In The Industry & Supporter |
 |
 |
Joined: April 25th, 2009, 11:49 pm Posts: 420
|
sgtdvldog wrote: I had tried to get to the Pool Calculator from my Palm Centro and it wouldn't work correctly. So I took the formulas and put them into a spreadsheet that I can view from Documents to go.
This isn't as inclusive as the website, but it suits my needs. If I need to double check something I go to the website. This spreadsheet calculates Bleach, Borax, Baking Soda, Calcium Chloride and Stabilizer only. It calculates Bleach by oz and the rest by weight. If you use it, you will need to put in the Gallons and Bleach %.
Forgot to mention, it should work on a pc/laptop as well as long as you have something that can open up MS Excel spreadsheets.
Hope others find this useful. Thanks - will give this a try this month logging a few pools. I've got a could of shocks to do... may want to add it to the Min FC table...
_________________ ~45Kg Pool with attached Spa, NSP-72 DE, Minmax 400 Heater, Tahoe Blue Pebbletech, Jandy SWG via Aqualink RS-8, The Pool Cleaner (black) Pumps: X3 Hybrid Pump (switches to SPA), 2HP Spa (additional, when SPA is on), and a 1HP For Waterfall 8, 4x12 Solar Panels on the roof of the pool-house (~12' up) CAPTAIN JAMES T. KIRK: "I'M SORRY. I CAN'T HEAR YOU OVER THE SOUND OF HOW AWESOME I AM" (Thanks to TFP!)
|
|
|
|
 |
|
sgtdvldog
|
Post subject: Re: The Pool Calculator  Posted: August 31st, 2009, 12:29 pm |
| Lifetime Supporter |
 |
Joined: July 10th, 2009, 10:34 am Posts: 105 Location: Blue Springs, MO
|
|
Here is another version. I have added the Shock Levels from Chem Geeks chart and also added a section to calculate the FC effect of adding x oz of bleach.
You do not have the required permissions to view the files attached to this post.
_________________ 24'x4' AGP Round S166T Hayward Sand Filter S48K2A2 Hayward Pump
|
|
|
|
 |
|
polyvue
|
Post subject: Re: The Pool Calculator  Posted: September 1st, 2009, 10:08 pm |
| Registered User |
 |
Joined: August 24th, 2009, 7:53 pm Posts: 1219 Location: Sacramento, California USA
|
sgtdvldog wrote: Here is another version. I have added the Shock Levels from Chem Geeks chart and also added a section to calculate the FC effect of adding x oz of bleach. Thank you for the spreadsheet. I have a few quibbles with its operation, but have not seen the previous version that was posted. If I'm off-base with these minor criticisms or have missed an earlier explanation, I apologize...
Columns B & C. If the value entered for Now exceeds the value of Target, then the Add column suggests an amount to be removed from the pool. How would I do this? (a bit tongue-in-cheek here!) Most difficult for me to figure was the following example.
In the PH section (row 11) I entered: Now = 8.0 Target = 7.6 (typical for my pool). The result displayed in the Add column was [minus] - 24. oz of Borax. Interesting, but it’s a lot easier to add muriatic acid to lower pH, than to remove Borax (I think!)
Effect of Adding Bleach (cell B32)… Perhaps it should copy the value from D6?
CYA / FC table - The FC values seem computed for non-SWG pools or are they? If whatever changes you decide to make to the spreadsheet could also be made to work for SWG pools, I think more people will find this of value.
_________________ 14,555 gal in-ground 16'x29' white plaster Pool w/spa (2007); Goldline Aqua Logic AQL-PS-8 control w/Aqua Cell 15 Salt Water Chlorination (SWCG); Hayward TriStar 1HP (1.85 SF) main / 1.5HP (1.60 SF) spa pumps; Hayward Swimclear cart filter C4025, ColorLogic LED lights; Tankless SP-18-4 electric heater; Polaris 280 cleaner. __ View of spiral galaxy in Ursa Major NGC6217 - Hubble Telescope 2009
|
|
|
|
 |
|
sgtdvldog
|
Post subject: Re: The Pool Calculator  Posted: September 3rd, 2009, 8:00 am |
| Lifetime Supporter |
 |
Joined: July 10th, 2009, 10:34 am Posts: 105 Location: Blue Springs, MO
|
|
The spreadsheet isn't meant to replace the pool calculator online. I created it so I could basically calculate the amount of bleach to add without having to log on and could do it from my phone. If you need to lower something or it isn't included on the spreadsheet, then I would recommend the pool calculator website. I didn't realize there was a difference in calculations for a SWG pool.
I mentioned earlier, the spreadsheet won't be as inclusive as the website or the iPhone app, since I don't have the programming capabilities that Jason has.
_________________ 24'x4' AGP Round S166T Hayward Sand Filter S48K2A2 Hayward Pump
|
|
|
|
 |
|
Gooserider
|
Post subject: Re: The Pool Calculator  Posted: September 6th, 2009, 7:19 pm |
| Lifetime Supporter |
 |
 |
Joined: February 25th, 2009, 11:34 pm Posts: 153 Location: North Billerica, MA, USA, etc.
|
|
One minor little item on the website PC that I mostly ignore since it really doesn't make any difference to the end result is in the bleach addition area - I get my bleach from the pool stores in the 5 gallon plastic carboys of 12%... It works out to between $3-4 /gallon which IMHO is better than paying ~$2/gal for 6% at Walmart or equivalent, especially when figuring in the hassles of moving lots of gallon jugs and getting rid of the empties...
However on the pool calc, the largest option for container size is 182 oz. This doesn't really make a lot of difference since the only effect of specifying a different container size is that the info window will tell you how many jugs to use, along with the cups, etc... Since the number I use is the ounces in the main window, it doesn't make much difference to me, but I thought I would mention it in the interest of "feature completeness"
Gooserider
_________________ Free-form Inground gunnite pool, Estimated 16-17K gallons. Purex model SMBW4036 36sq ft DE filter, Hayward Mod SP1607X10 Pump w/ 1HP replacement motor, 1.5" plumbing all over, Polaris Pressure side cleaner w/ booster pump, more than 15yrs old, less than 30. Not painted, deteriorating tile surround.
Ran on BBB last summer, never saw the pool looking so good, and with so little effort. Pool now closed for winter.
Gooserider
|
|
|
|
 |
|
PaulR
|
Post subject: Re: The Pool Calculator  Posted: September 6th, 2009, 11:47 pm |
| Lifetime Supporter |
 |
Joined: January 11th, 2009, 6:59 pm Posts: 1974 Location: Cupertino, CA
|
|
And here I thought I was picky.... --paulr
_________________ BBB "Intermediate Swimmer" IG plaster pool 18.5K gal, Hayward Pro-Grid DE filter, 3/4 HP Hydramax II; Polaris 380, 3/4 HP booster AG spa 325 gal, probably Sundance of some kind Water testing instructions on one page
|
|
|
|
 |
|
JasonLion
|
Post subject: Re: The Pool Calculator  Posted: September 8th, 2009, 10:01 pm |
| Site Admin |
 |
 |
Joined: May 7th, 2007, 3:03 pm Posts: 22093 Location: Silver Spring, MD
|
|
The theory is that if the Pool Calculator tells you to add 8 gallons of liquid chlorine, and you have 5 gallon jugs, that you can figure out how many jugs that is for yourself (one and three fifths). But if you have 182 oz jugs, you probably want help doing the math to find out how many jugs that is (around 5.6).
_________________ 19K gal, vinyl, 1/2 HP WhisperFlo pump, 200 sqft cartridge filter, AutoPilot Digital SWG, Dolphin Dynamic cleaning robot TFP Admin. Creator of The Pool Calculator. Other handy links: Support this site, TF Test Kits, Pool School
|
|
|
|
 |
|
Gooserider
|
Post subject: Re: The Pool Calculator  Posted: September 8th, 2009, 11:04 pm |
| Lifetime Supporter |
 |
 |
Joined: February 25th, 2009, 11:34 pm Posts: 153 Location: North Billerica, MA, USA, etc.
|
That's why I said it was a very minor buglet, not something that needed much (if any) attention... On the relative scale, I would say it is in the "fruit-fly" class as opposed to the "Palmetto Roach" class... Eventually I'd like to get a pump for my carboys, but right now I am just pouring into some home made measuring cups made from cut down bleach bottles and "calibrated" by means of a Sharpie and some of the measuring cups out of the kitchen... I'm typically adding about 120 oz at a go (because I don't test as often as I should  ) and I figure at that scale +/- 10 oz is no big deal My water has stayed perfect looking all summer, and pool season is rapidly coming to a close for me... It has been getting to cool to be tempting to swim, and we definitely want to close before the leaves start falling in 3-4 weeks.... Gooserider
_________________ Free-form Inground gunnite pool, Estimated 16-17K gallons. Purex model SMBW4036 36sq ft DE filter, Hayward Mod SP1607X10 Pump w/ 1HP replacement motor, 1.5" plumbing all over, Polaris Pressure side cleaner w/ booster pump, more than 15yrs old, less than 30. Not painted, deteriorating tile surround.
Ran on BBB last summer, never saw the pool looking so good, and with so little effort. Pool now closed for winter.
Gooserider
|
|
|
|
 |
|
poolpop
|
Post subject: Re: The Pool Calculator  Posted: February 10th, 2010, 2:08 am |
Joined: May 16th, 2009, 9:23 pm Posts: 21 Location: West Tennessee
|
Wondering if your considering a Android App for the pool calculator. There is a Pool Calculator App in the Market, but I wanted yours if I could get it. Here is a link to the android market developer site http://developer.android.com/index.html Thanks for all you do!
_________________ 18,500 Gal. 27 ft AG Vinyl - Hayward Pump with Cooper 21" Sand Filter - GO VOLS!
|
|
|
|
 |
|
JasonLion
|
Post subject: Re: The Pool Calculator  Posted: February 10th, 2010, 3:09 pm |
| Site Admin |
 |
 |
Joined: May 7th, 2007, 3:03 pm Posts: 22093 Location: Silver Spring, MD
|
|
poolpop, thanks for the suggestion. I will add that to my wish list for possible support at a future date.
_________________ 19K gal, vinyl, 1/2 HP WhisperFlo pump, 200 sqft cartridge filter, AutoPilot Digital SWG, Dolphin Dynamic cleaning robot TFP Admin. Creator of The Pool Calculator. Other handy links: Support this site, TF Test Kits, Pool School
|
|
|
|
 |
|
Sherra
|
Post subject: Re: The Pool Calculator  Posted: March 13th, 2010, 4:25 pm |
| New User |
 |
Joined: June 25th, 2007, 6:45 pm Posts: 10 Location: South Carolina
|
|
I just downloaded the app for my iPod. It's going to save me a lot of running into the house to my computer during start-up season (which started today for me). The Pool Calculator app is only the 2nd app I've paid money for since I got my iPod Touch last year. I only buy quality, useful apps, and this one definitely made the cut for me to loosen the grip on my credit card! (I knew it would because I love the on-line calculator so much.) Thanks Jason!
_________________ Sherra Kershaw County, South Carolina 18x36 27,500 gal IG Vinyl Liner, sand filter, 1hp single speed pump running 6 hours twice per day, Hayward Swim Pure salt chlorinator, 2 skimmers, main drain, 3 returns, husband, 2 kids, 2 dogs
|
|
|
|
 |
|
polyvue
|
Post subject: Re: The Pool Calculator  Posted: March 14th, 2010, 10:59 am |
| Registered User |
 |
Joined: August 24th, 2009, 7:53 pm Posts: 1219 Location: Sacramento, California USA
|
Sherra wrote: I just downloaded the app for my iPod. It's going to save me a lot of running into the house to my computer during start-up season. I'd like to see that cell phone ap sometime. Does that mean I have to purchase a cell phone and carry it with me? It's by no means a certain fact that you "get what you pay for" in terms of technology, but I can attest to the usefulness and flexibility of the Pool Calculator. I compared its results to my own ad hoc hodge-podge of Saturation Index (SI) formulas during several months last summer but I couldn't find a dependable way to muck it up, so my computer adopted it, and I'm happy that it works on computers not connected to the internet. After some connivance and thievery, I've managed to replicate its functions in an Excel spreadsheet (for the ease in updating treatment logs as I enter my test results each week). For anyone who currently uses the Pool Calculator written by Jason on a desktop computer and has it in their mind that the new Taylor Watergram Calculator ($7.95) will untether them from the office, I wish to purvey a word of warning – and my sympathies if you have already purchased this product. In college, I bought several inexpensive hand-held calculators (Seiko, Casio, TI.) All of them still work. The Taylor product is pretty to look at and almost entirely useless. The credit-card sized calculator is very frustrating to use. Bright sunshine is required to operate it and if tucked in a shirt pocket for a few seconds or brought indoors without plenty of artificial light, it will happily reset to default values. The key pad’s numbers are too small and you can’t use a stylus or pen, it’s so unresponsive that I thought at first mine was defective. The LCD display is puny, twice the length of a No. 2 pencil eraser and about as wide – but this won’t be of large concern because the most frequently displayed output is: E r r o r Wait! I haven’t finished….
_________________ 14,555 gal in-ground 16'x29' white plaster Pool w/spa (2007); Goldline Aqua Logic AQL-PS-8 control w/Aqua Cell 15 Salt Water Chlorination (SWCG); Hayward TriStar 1HP (1.85 SF) main / 1.5HP (1.60 SF) spa pumps; Hayward Swimclear cart filter C4025, ColorLogic LED lights; Tankless SP-18-4 electric heater; Polaris 280 cleaner. __ View of spiral galaxy in Ursa Major NGC6217 - Hubble Telescope 2009
|
|
|
|
 |
|
mzimm
|
Post subject: Re: The Pool Calculator  Posted: May 15th, 2010, 8:12 am |
Joined: May 13th, 2010, 7:16 am Posts: 2
|
poolpop wrote: Wondering if your considering a Android App for the pool calculator. There is a Pool Calculator App in the Market, but I wanted yours if I could get it. Here is a link to the android market developer site http://developer.android.com/index.html Thanks for all you do! I just downloaded the other developers app from Market on my Android device - I have invoked the "uninstall and refund" because it is kind of bulky and very incomplete. I use your iphone app on my wifes ipod. I would really like to be able to install an app like this on my HTC Droid. What are the chances you will develop this for the Android market? Thanks Mike
|
|
|
|
 |
|
JasonLion
|
Post subject: Re: The Pool Calculator  Posted: May 15th, 2010, 10:09 am |
| Site Admin |
 |
 |
Joined: May 7th, 2007, 3:03 pm Posts: 22093 Location: Silver Spring, MD
|
|
mzimm, welcome to TFP! Support for Android is in process, but it isn't going to happen right away.
_________________ 19K gal, vinyl, 1/2 HP WhisperFlo pump, 200 sqft cartridge filter, AutoPilot Digital SWG, Dolphin Dynamic cleaning robot TFP Admin. Creator of The Pool Calculator. Other handy links: Support this site, TF Test Kits, Pool School
|
|
|
|
 |
|
mzimm
|
Post subject: Re: The Pool Calculator  Posted: May 16th, 2010, 4:12 pm |
Joined: May 13th, 2010, 7:16 am Posts: 2
|
|
Thank you! Very cool - I will keep checking back.
|
|
|
|
 |
|
pedsrn
|
Post subject: Re: The Pool Calculator  Posted: May 20th, 2010, 12:51 am |
Joined: May 29th, 2007, 9:22 pm Posts: 46 Location: Alabama
|
|
Downloaded the iphone app..awesome.
One question on the ph.. when it says, "Given a ph of x and a borate of 0..."
What does the borate of zero mean? How do you know what your borate level is? That confuses me a bit.
TIA!
_________________ 24' Vinyl, AG, Sand Filter, 1 1/2 HP Hayward PowerFlo LX, BB&B
|
|
|
|
 |
|
pedsrn
|
Post subject: Re: The Pool Calculator  Posted: May 20th, 2010, 1:42 am |
Joined: May 29th, 2007, 9:22 pm Posts: 46 Location: Alabama
|
|
sorry, nevermind...
just stumbled across chem 201 and found the answer to my question.
_________________ 24' Vinyl, AG, Sand Filter, 1 1/2 HP Hayward PowerFlo LX, BB&B
|
|
|
|
 |
|
CarrolltonTXPool
|
Post subject: Re: The Pool Calculator  Posted: May 20th, 2010, 12:04 pm |
Joined: May 7th, 2010, 9:49 pm Posts: 81 Location: Dallas, TX
|
|
I may be seeing it and just missing it but on the iPhone app where do you put in the goals? I put by target FC to 5.0, by Now FC is 4.5, and it says at the top Free Chlorine (FC) - Goal: Not setup. HOw do i get these in there?
_________________ 21.5K gal IG plaster pool, FNSP 60 Vertical Grid DE filter (150 GPM), 2.0 HP Pump; Polaris 280, 3/4 HP booster
|
|
|
|
 |
|
JasonLion
|
Post subject: Re: The Pool Calculator  Posted: May 20th, 2010, 5:32 pm |
| Site Admin |
 |
 |
Joined: May 7th, 2007, 3:03 pm Posts: 22093 Location: Silver Spring, MD
|
|
The strip across the bottom that says FC PH TA CH etc. scrolls horizontally. Drag it to the left and you will see the Goals tab. Press that and you can setup your goal levels.
_________________ 19K gal, vinyl, 1/2 HP WhisperFlo pump, 200 sqft cartridge filter, AutoPilot Digital SWG, Dolphin Dynamic cleaning robot TFP Admin. Creator of The Pool Calculator. Other handy links: Support this site, TF Test Kits, Pool School
|
|
|
|
 |
|
CarrolltonTXPool
|
Post subject: Re: The Pool Calculator  Posted: May 21st, 2010, 8:36 am |
Joined: May 7th, 2010, 9:49 pm Posts: 81 Location: Dallas, TX
|
|
ah, thanks. didn't think to scroll that part.
_________________ 21.5K gal IG plaster pool, FNSP 60 Vertical Grid DE filter (150 GPM), 2.0 HP Pump; Polaris 280, 3/4 HP booster
|
|
|
|
 |
|
|
 |
|
 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|