Kegconnection Complete Starter Kit and More Giveaway!


Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Adjustment spreadsheet

Reply
 
LinkBack Thread Tools
Old 11-05-2009, 02:43 AM   #111
Bobby_M
Vendor and Brewer
HBT_SPONSOR.png
Vendor Ads 
Feedback Score: 2 reviews
 
Bobby_M's Avatar
Recipes 
 
Join Date: Aug 2006
Location: Whitehouse Station, NJ
Posts: 21,836
Liked 910 Times on 606 Posts
Likes Given: 26

Default

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.

__________________
BrewHardware.com
Sightglass, Refractometer, Ball Valve, Weldless bulkhead, Thermometer, Decals, Stainless Steel Fittings, Compression Fittings, Camlock Quick Disconnects, Scale, RIMS tube, Plate Chiller, Chugger Pump, Super Clear Silicone Tubing, and more!

New Stuff?
Bobby_M is offline
 
Reply With Quote Quick reply to this message
Old 11-05-2009, 02:51 AM   #112
JerD
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2008
Location: NW Indiana
Posts: 168
Default

Awesome
Thanks alot

__________________
JerD is offline
 
Reply With Quote Quick reply to this message
Old 11-06-2009, 02:30 PM   #113
Joetuo
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2006
Location: Roselle, IL
Posts: 66
Default

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?

__________________
Joetuo is offline
 
Reply With Quote Quick reply to this message
Old 11-06-2009, 03:38 PM   #114
Bobby_M
Vendor and Brewer
HBT_SPONSOR.png
Vendor Ads 
Feedback Score: 2 reviews
 
Bobby_M's Avatar
Recipes 
 
Join Date: Aug 2006
Location: Whitehouse Station, NJ
Posts: 21,836
Liked 910 Times on 606 Posts
Likes Given: 26

Default

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.

__________________
BrewHardware.com
Sightglass, Refractometer, Ball Valve, Weldless bulkhead, Thermometer, Decals, Stainless Steel Fittings, Compression Fittings, Camlock Quick Disconnects, Scale, RIMS tube, Plate Chiller, Chugger Pump, Super Clear Silicone Tubing, and more!

New Stuff?
Bobby_M is offline
 
Reply With Quote Quick reply to this message
Old 11-06-2009, 06:07 PM   #115
Joetuo
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2006
Location: Roselle, IL
Posts: 66
Default

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.

__________________
Joetuo is offline
 
Reply With Quote Quick reply to this message
Old 11-06-2009, 06:15 PM   #116
wildwest450
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2007
Posts: 9,099
Liked 163 Times on 149 Posts
Likes Given: 4

Default

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.
__________________
wildwest450 is offline
 
Reply With Quote Quick reply to this message
Old 11-06-2009, 06:19 PM   #117
Joetuo
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2006
Location: Roselle, IL
Posts: 66
Default

ROFL I see what you did there.

__________________
Joetuo is offline
 
Reply With Quote Quick reply to this message
Old 11-07-2009, 06:56 PM   #118
weetodd
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2006
Location: Seattle. WA
Posts: 197
Liked 1 Times on 1 Posts

Default

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

__________________
weetodd is offline
 
Reply With Quote Quick reply to this message
Old 11-08-2009, 12:50 PM   #119
Brew-boy
Feedback Score: 0 reviews
 
Brew-boy's Avatar
Recipes 
 
Join Date: May 2006
Location: Lapeer, Michigan
Posts: 2,415
Liked 13 Times on 10 Posts
Likes Given: 9

Default

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/
Brew-boy is offline
 
Reply With Quote Quick reply to this message
Old 11-08-2009, 11:01 PM   #120
gruversm
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
gruversm's Avatar
Recipes 
 
Join Date: Mar 2008
Location: Edwardsburg, MI, Michigan
Posts: 338
Liked 2 Times on 2 Posts
Likes Given: 1

Default

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

On Tap:
Horehound Tripel,Gumballhead,Sierra Nevada Pale Ale, Founder's Breakfast Stout Clone, Hefeweizen
gruversm 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
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 12:12 PM
water adjustment positiverpr Recipes/Ingredients 2 10-14-2008 03:09 PM