Spike Brewing 12.5 Conical Fermenter Giveaway - Enter Now!

Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Calculator 2.0

Reply
 
LinkBack Thread Tools
Old 09-15-2010, 05:38 PM   #11
wildwest450
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2007
Posts: 9,099
Liked 165 Times on 150 Posts
Likes Given: 4

Default

Quote:
Originally Posted by adam01 View Post
Any chance for a tsp size addition conversion ?
4 grams is approx 1 tsp.
__________________
wildwest450 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 06:01 PM   #12
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 975
Liked 59 Times on 35 Posts
Likes Given: 2

Default

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
-TH- is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 06:57 PM   #13
adam01
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: Lucas, Tx
Posts: 344
Liked 3 Times on 3 Posts

Default

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

__________________
adam01 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 07:23 PM   #14
Reelale
Feedback Score: 3 reviews
Recipes 
 
Join Date: Sep 2009
Posts: 17,736
Liked 1373 Times on 1331 Posts
Likes Given: 55

Default

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.....

__________________
Reelale is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 08:14 PM   #15
jmo88
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2008
Location: Seattle
Posts: 1,401
Liked 18 Times on 14 Posts
Likes Given: 9

Default

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 (~):}
jmo88 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 08:35 PM   #16
wuertele
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
wuertele's Avatar
Recipes 
 
Join Date: Oct 2009
Location: Menlo Park
Posts: 134
Liked 1 Times on 1 Posts

Default

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

__________________
wuertele is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 08:35 PM   #17
AScott
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
AScott's Avatar
Recipes 
 
Join Date: Aug 2009
Location: MN
Posts: 109
Liked 4 Times on 3 Posts

Default

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.

__________________
AScott is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 09:37 PM   #18
wuertele
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
wuertele's Avatar
Recipes 
 
Join Date: Oct 2009
Location: Menlo Park
Posts: 134
Liked 1 Times on 1 Posts

Default

My water report (Bear Gulch Water District, CA, http://www.calwater.com/wq/ccr/2009/bear-gulch-bg/bear-gulch-bg-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?

__________________
wuertele is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 10:20 PM   #19
wildwest450
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2007
Posts: 9,099
Liked 165 Times on 150 Posts
Likes Given: 4

Default

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?
__________________
wildwest450 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 11:02 PM   #20
ajdelange
Senior Member
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 5,866
Liked 571 Times on 471 Posts
Likes Given: 16

Default

Quote:
Originally Posted by wuertele View Post
My water report (Bear Gulch Water District, CA, http://www.calwater.com/wq/ccr/2009/bear-gulch-bg/bear-gulch-bg-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.
__________________

Last edited by ajdelange; 09-16-2010 at 04:54 PM. Reason: Ran calculation w/ spreadsheet in "as Sulfur" mode. Corrected here.
ajdelange is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
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 04:31 PM