EZ Water Calculator 2.0 - Page 2 - Home Brew Forums
Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Calculator 2.0

Reply
 
Thread Tools
Old 09-15-2010, 05:38 PM   #11
wildwest450
Registered User
Recipes 
 
Dec 2007
Posts: 9,043
Liked 173 Times on 158 Posts


Quote:
Originally Posted by adam01 View Post
Any chance for a tsp size addition conversion ?
4 grams is approx 1 tsp.



 
Reply With Quote
Old 09-15-2010, 06:01 PM   #12
-TH-
Recipes 
 
Oct 2008
Zeeland, Michigan
Posts: 902
Liked 90 Times on 53 Posts


Quote:
Originally Posted by jmo88 View Post
.... Any chance of uploading an html version. My Excel 2008 for Mac doesn't like the radial buttons for alkalinity and bicarbonate. This was the case in the last version too, so I always used the html version, which worked for selecting alkalinity.
Not real soon. I'm having a hard time getting anything to successfully convert it to html or even any web-based spreadsheet format for that matter.

All that the radio buttons do is put a "1" in cell K3 for HCO3 or a "2" for CaCO3. You could try to just do that manually in your Mac version by typing 1 or 2 in cell K3 and see if that works. Maybe if I had access to a mac I could tweak it to work better but for now...


__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

 
Reply With Quote
Old 09-15-2010, 06:57 PM   #13
adam01
Recipes 
 
Aug 2010
Lucas, Tx
Posts: 413
Liked 10 Times on 8 Posts


You may want to round to 2 digits for mash thickness since 1.25qts/lb is common.

If you turn off adjust for sparge water, then you're expected to put enough in the mash
to account for all the water, correct?

Is there a benefit to only putting salts into the mash vs mash + sparge ?
(Mash is easier)

Adam

 
Reply With Quote
Old 09-15-2010, 07:23 PM   #14
Reelale
Recipes 
 
Sep 2009
Posts: 17,765
Liked 1374 Times on 1332 Posts


Nice work TH. It's a lot busier than version 1, but a whole lot more information too. I kinda miss the SRM ranges though.....

 
Reply With Quote
Old 09-15-2010, 08:14 PM   #15
jmo88
Recipes 
 
Sep 2008
Seattle
Posts: 1,380
Liked 23 Times on 15 Posts


Quote:
Originally Posted by -TH- View Post
Not real soon. I'm having a hard time getting anything to successfully convert it to html or even any web-based spreadsheet format for that matter.

All that the radio buttons do is put a "1" in cell K3 for HCO3 or a "2" for CaCO3. You could try to just do that manually in your Mac version by typing 1 or 2 in cell K3 and see if that works. Maybe if I had access to a mac I could tweak it to work better but for now...
Good enough for me. That worked. It's an easy enough workaround.
__________________
(~):} Just a little Furthur (~):}

 
Reply With Quote
Old 09-15-2010, 08:35 PM   #16
wuertele
HBT_LIFETIMESUPPORTER.png
 
wuertele's Avatar
Recipes 
 
Oct 2009
Menlo Park
Posts: 134
Liked 1 Times on 1 Posts


Great work! And thank you VERY much for the OpenOffice version!

 
Reply With Quote
Old 09-15-2010, 08:35 PM   #17
AScott
Recipes 
 
Aug 2009
MN
Posts: 117
Liked 4 Times on 3 Posts


Man, and I just finally got comfortable with version 1. There's always more to learn...

Thanks for all the hard work, -TH-. I can't imagine how complicated this must be to get into spreadsheet form for people like me.

 
Reply With Quote
Old 09-15-2010, 09:37 PM   #18
wuertele
HBT_LIFETIMESUPPORTER.png
 
wuertele's Avatar
Recipes 
 
Oct 2009
Menlo Park
Posts: 134
Liked 1 Times on 1 Posts


My water report (Bear Gulch Water District, CA, http://www.calwater.com/wq/ccr/2009/...g-2009_web.pdf) does not list bicarbonate or alkalinity. Is there a way to derive it from other values that might be found on the water report?

 
Reply With Quote
Old 09-15-2010, 10:20 PM   #19
wildwest450
Registered User
Recipes 
 
Dec 2007
Posts: 9,043
Liked 173 Times on 158 Posts


Quote:
Originally Posted by Reelale View Post
Nice work TH. It's a lot busier than version 1, but a whole lot more information too. I kinda miss the SRM ranges though.....
Why miss something that apparently is far less important than we thought?

 
Reply With Quote
Old 09-15-2010, 11:02 PM   #20
ajdelange
HBT_LIFETIMESUPPORTER.png
Recipes 
 
Aug 2010
McLean/Ogden, Virginia/Quebec
Posts: 8,934
Liked 1371 Times on 1045 Posts


Quote:
Originally Posted by wuertele View Post
My water report (Bear Gulch Water District, CA, http://www.calwater.com/wq/ccr/2009/...g-2009_web.pdf) does not list bicarbonate or alkalinity. Is there a way to derive it from other values that might be found on the water report?
Given that bicarbonate is one of the most prevalent ions in most drinking water you can get an idea of how much is present by adding enough to bring the total electronic charge per liter to 0 based on all the other ions reported. In your case the situation is complicated by the fact that averages are presented and that the water has an inordinate amount of aluminum. Caveats given, I estimate that your alkalinity is around 189 mg/L as CaCO3.



Reason: Ran calculation w/ spreadsheet in "as Sulfur" mode. Corrected here.

 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
North Penn Water Authority (Montgomery Co., PA) Water Report lebshiff21 Brew Science 11 04-30-2014 10:13 PM
IPA water recipe - adjusting high bicarbonate water conpewter Brew Science 19 10-01-2010 05:29 PM
Water quality, what to do....Hard water and high pH. BroadStreetBrewery Brew Science 9 09-11-2010 04:12 AM
Water adjustment - Austin, TX water chloramines pale ale anastasis Brew Science 4 04-02-2010 05:31 PM
Tucson, AZ water profile results from water dept. herbler Brew Science 40 02-02-2010 05:31 PM


Forum Jump