The Great Bottle Opener Giveaway

Home Brew Forums > Home Brewing Beer > Brew Science > Updated water calculator

Reply
 
LinkBack Thread Tools
Old 03-05-2011, 04:08 AM   #1
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 114 Times on 71 Posts
Likes Given: 4

Default Updated water calculator

I finally finished overhauling the water and mash pH spreadsheet that I have been maintaining. I started this work a few months ago when I realized that even the "basic" interface was not as intuitive as I thought it was. It seems nobody wants to enter salts as ppm even though that makes the addition independent of the water amount.

Here is what I changed:
* rearranged the basic interface into water, grist, salts&acids, report and necessary salt additions. This should be more intuitive.
* changed the treatment of undissolved chalk such that it only contributes half its calcium since it contributes only half its alkalinity. Chalk's solubility in mash seems to be limited and what does not dissolve and contribute to a rise in alkalinity should not contribute calcium ions either.
* salt additions can now be made in g and mg/l. You can select the unit
* the salts to be added can be reported in g and tsp. The latter is useful if your scale breaks down or you don't own one yet.
* lactic acid and phosphoric acid are supported. How out there is using hydrochloric or sulfuric acid? I could add this as well.
* water boiling has been added to the "advanced page". This was easy to add since I already supported lime treatment
* I added pH shift estimations for the major water treatment steps

This is what I kept:
* The basic and advanced pages are still there. Anything entered in the basic page will automatically carry over into the advanced page. The idea is to support a wide variety of users
* the basic formatting remained ion order to better support its use on mobile devices
* I avoided macros or the use of fancy functionality in hope that this spreadsheet can be supported by mobile devices
* the SRM based mash pH prediction is still there.
* support for SI and US units. Under the hood it uses SI units almost exclusively.

I plan to add grist based mash pH prediction. Not so much because it is much more precise than the SRM based prediction but because you don't have to enter the %roasted value, which I admit is a bit ambiguous and not that easy to grasp.

I gave it a fair amount of testing and when updating it I made sure to reuse as much of what I already had in order to reduce the number of bugs that were introduced. I was also tempted to password protect the content but then I noticed that when you open a password protected Excel file in OpenOffce you are not asked for a password when unlocking pages. So much for security Smiley. But the pages are still protected in order to avoid accidental changes to the formulas.

Kaiser_water_calculator.xls

Kai

Kaiser is offline
2
People Like This 
Reply With Quote Quick reply to this message
Old 03-16-2011, 01:46 PM   #2
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 114 Times on 71 Posts
Likes Given: 4

Default

I updated the wording for the %roasted field, it is meant to express the percentage of color that is coming from roasted malts and not the percentage of roasted malt of the specialty malts. This can make quite a difference and I found this when working on a refinement of the formula.

Example.

If you have a grist with 5% crystal 60 and 3% 500L carafa, the % roasted is:

3*500 / (5*60 + 3*500) = 83%

This example neglects the color from the base malt, which should be fine if the base is pale malt.

Kai

Kaiser is offline
captain_entropy Likes This 
Reply With Quote Quick reply to this message
Old 03-18-2011, 03:48 AM   #3
Sixbillionethans
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2006
Location: Wauwatosa, WI
Posts: 162
Liked 7 Times on 6 Posts
Likes Given: 1

Default

Awesome, thanks for posting. I'll check this out and see if I want to incorporate into my brew spreadsheet. My current spreadsheet version includes borrowed formulas from the EZ Water Calculator.

__________________
Sixbillionethans is offline
 
Reply With Quote Quick reply to this message
Old 03-26-2011, 07:05 PM   #4
Inhiding
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2009
Location: Cambria
Posts: 46
Liked 4 Times on 4 Posts
Likes Given: 1

Default

When using the mash & sparge option, the amounts of salts to be added to the sparge, do they go into the boil? or do I add them into the sparge water and sparge with that modified water? or does it matter?

thanks in advance

Aaron

__________________
Inhiding 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
EZ Water Calculator 2.0 -TH- Brew Science 159 03-21-2014 01:57 PM
Question on EZ Water Calculator 2.0 adromo Brew Science 2 02-12-2011 04:40 PM
EZ Water Calculator questions, targeting oatmeal stout winvarin Brew Science 12 01-22-2011 02:53 PM
Home-made Brewing Calculator millaj92 Brew Science 1 01-07-2011 03:38 AM