EZ Water Adjustment spreadsheet - Page 12 - Home Brew Forums

Register Now!
Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Adjustment spreadsheet

Reply
 
Thread Tools
Old 11-05-2009, 03:43 AM   #111
Bobby_M
Vendor and Brewer
HBT_SPONSOR.png
 
Bobby_M's Avatar
Recipes 
 
Aug 2006
Whitehouse Station, NJ
Posts: 23,201
Liked 1658 Times on 1071 Posts


It assumes dilution of the total water so if you have 4 gallons mash and 6 gallons sparge with a 50% dilution, it assumes 2 gallons mash and 3 gallons sparge is distilled.
__________________
Welcome to BrewHardware.com. I love you.
BIAB Large Mesh False Bottoms and SS HERMS COILS are IN!!
Chugger Pumps, Pump Kits, Camlocks, Sightglasses, Clear USA made Silicone Tubing, RIMS, Electric Install Parts, etc.

 
Reply With Quote
Old 11-05-2009, 03:51 AM   #112
JerD
Recipes 
 
Jun 2008
NW Indiana
Posts: 168

Awesome
Thanks alot

 
Reply With Quote
Old 11-06-2009, 03:30 PM   #113
Joetuo
Recipes 
 
Sep 2006
Roselle, IL
Posts: 66

After reading the thread and watching bobby's video's (thanks a lot) I just want to clear up one thing....

If all my numbers are in the proper range (all green) then I don't have to worry about the Ph of my mash?

 
Reply With Quote
Old 11-06-2009, 04:38 PM   #114
Bobby_M
Vendor and Brewer
HBT_SPONSOR.png
 
Bobby_M's Avatar
Recipes 
 
Aug 2006
Whitehouse Station, NJ
Posts: 23,201
Liked 1658 Times on 1071 Posts


No, you still do. The proper range thing is only in regards to each individual ion and says nothing about mash pH because it doesn't know the SRM of the beer you're trying to brew. If you watch the 3rd video, I talk about dialing in your residual alkalinity so that the SRM range on the bottom of the sheet matches what you're trying to brew.
__________________
Welcome to BrewHardware.com. I love you.
BIAB Large Mesh False Bottoms and SS HERMS COILS are IN!!
Chugger Pumps, Pump Kits, Camlocks, Sightglasses, Clear USA made Silicone Tubing, RIMS, Electric Install Parts, etc.

 
Reply With Quote
Old 11-06-2009, 07:07 PM   #115
Joetuo
Recipes 
 
Sep 2006
Roselle, IL
Posts: 66

Ok so basically i just need to get all the numbers green and make sure the SRM is in range of what I am brewing then I am golden.

 
Reply With Quote
Old 11-06-2009, 07:15 PM   #116
wildwest450
Registered User
Recipes 
 
Dec 2007
Posts: 9,043
Liked 173 Times on 158 Posts


Quote:
Originally Posted by Joetuo View Post
Ok so basically i just need to get all the numbers green and make sure the SRM is in range of what I am brewing then I am golden.
With an srm of 6 or less.

 
Reply With Quote
Old 11-06-2009, 07:19 PM   #117
Joetuo
Recipes 
 
Sep 2006
Roselle, IL
Posts: 66

ROFL I see what you did there.

 
Reply With Quote
Old 11-07-2009, 07:56 PM   #118
weetodd
Recipes 
 
Oct 2006
Seattle. WA
Posts: 197
Liked 1 Times on 1 Posts


Really great spreadsheet, thanks for creating it and for also making it available for download. Also, thanks Bobby for the great videos.

One question on the initial numbers for mash water volume and sparge water volume. For example purposes let's say I mash with 5 gallons, sparge with 3 for 8 total preboil and expect a post boil volume of 6. The mash water one is easy--just the volume of water that is used in the initial mash (5). But, for the sparge water? In Bobby's videos, he uses the full amount of the sparge water (the additional 3 in my example) to get additions for the full pre-boil volume--so we're adding enough minerals to get the right ppm for 8 gallons. After thinking about this, doesn't the boil remove water but leave the minerals behind? (I'm not a scientist so not sure if the minerals would evaporate with the water vapor) So should the mineral additions calculate off of how much minerals we want with the finished beer (6 gallons vs. preboil of 8)

Thanks

 
Reply With Quote
Old 11-08-2009, 01:50 PM   #119
Brew-boy
 
Brew-boy's Avatar
Recipes 
 
May 2006
Lapeer, Michigan
Posts: 2,282
Liked 16 Times on 13 Posts


Greta tool TH and very nice video Bobby, Thanks for all your help guys.
__________________
Next:Smoked Pilsner.
Primary:Belgian Red, American Stout w/Roeselare
On Tap:Pale Ale, English Bitter
Aging: Imperial Oatmeal Stout on Vanilla beans.

I rather owe you a dollar than cheat you out of it.."Dad"

http://lapeerareabrewers.com/

http://groups.yahoo.com/group/LapeerAreaBrewers/

 
Reply With Quote
Old 11-09-2009, 12:01 AM   #120
gruversm
HBT_SUPPORTER.png
 
gruversm's Avatar
Recipes 
 
Mar 2008
Edwardsburg, MI, Michigan
Posts: 365
Liked 3 Times on 3 Posts


Quote:
Originally Posted by lamarguy View Post
It works, you just need a couple of old VB dlls...

Google and download VBRUN300.dll and cmdialog.vbx to the same directory as BREWATER.exe.
Norton Internet Security is flagging the executable as a possible Virus.

 
Reply With Quote


Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Water Modification Videos, TH's Spreadsheet Bobby_M Brew Science 234 08-22-2011 03:44 PM
First try at water adjustment carp Brew Science 5 10-14-2009 12:32 AM
Water Adjustment? jgardner6 General Beer Discussion 5 08-11-2009 02:33 AM
Devising water recipes using Palmer's spreadsheet SpanishCastleAle General Techniques 0 02-22-2009 01:12 PM
water adjustment positiverpr Recipes/Ingredients 2 10-14-2008 03:09 PM


Forum Jump