Electric Brewing Supply 30A BCS Giveaway!


Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Adjustment spreadsheet
Reply
 
LinkBack Thread Tools
Old 10-27-2009, 01:52 AM   #101
jmo88
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2008
Location: Seattle
Posts: 1,401
Liked 19 Times on 14 Posts
Likes Given: 9

Default

TH,

I can only use your online version of the spreadsheet. I can't select the Alkalinity button on the excel sheet, but I can on the webpage. I am using excel for mac version 12.0. Is this because of my version? Just wondering if it's a simple fix.

__________________
(~):} Just a little Furthur (~):}
jmo88 is offline
 
Reply With Quote Quick reply to this message
Old 10-28-2009, 02:59 PM   #102
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 978
Liked 62 Times on 37 Posts
Likes Given: 2

Default

Quote:
Originally Posted by Bobby_M View Post
No, I'm saying you'd do the same "per gallon" additions to the boil kettle except do not add baking soda. There's no reason I can think of to use baking soda in the boil if your sodium is already high enough and the HCO3 is for mash pH.

Apparently 1gram of NaHCO3 adds 72ppm of sodium in one gallon. Let's say you mash with 4gallons and sparge another 4 gallons for a preboil of 8 gallons. If you add 4 grams of NaHCO3 to the mash, you have 72ppm sodium. If you leave it out of the boil addition, the sodium effectively halves to 36ppm.

I can't think of a way that TH could facilitate that kind of flexibility without also making the spreadsheet obnoxiously complicated.
Ok I worked on this a while and I think I found a good way to allow for some control of the sparge water adjustments (including the ability to skip some) while keeping the spreadsheet somewhat simple to use. While it may be approaching "obnoxiously complicated", it shouldn't appear that way to the user. Now me on the other hand....

See post #1 or my signature for the latest version 1.5.
Note: The online version does not have this.
__________________
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 10-28-2009, 03:51 PM   #103
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: 22,113
Liked 1020 Times on 680 Posts
Likes Given: 28

Default

TH, you are my hero at the moment. The spreadsheet is becoming just a touch more complex but I really think it's more useful.

There are two things that I've tweaked on my local copy and you may choose to implement or not. First. On the additions box, I put an indicator as to whether it makes RA go up or down. That helps me choose additions. I'm sure I'll eventually learn and not need it, but for now, it's nice.

The other thing is providing more complete output in the raw format page. Here's what I did:

Starting Water, in ppm:
Ca: 30
Mg: 10
Na: 28
Cl: 53
SO4: 15
CaCO3: 59

Mash/Sparge Vol in gallons 5 * 3
Dilution Rate: 0% *

Adjustments in grams/ml mash and boil kettle:
CaCO3: 1 * 0.6
CaSO4: 2 * 1.2
CaCl2: 3 * 1.8
MgSO4: 4 * 2.4
NaHCO3: 5 * 0
NaCl: 6 * 3.6
HCL Acid in ml: 0 * 0
Lactic Acid in ml: 0 * 0

Mash Water/Total water in ppm:
Ca: 118 * 118
Mg: 30 * 30
Na: 225 * 198
Cl: 321 * 321
SO4: 156 * 156
CaCO3: 282 * 211

RA for Mash Only: 180 (20 to 25 SRM)
Cl to SO4 for Total Water 2.06 (Very Malty)


Enough of the formatting remains in the paste that you can provide both the mash/BK additions and mash profile/total profile in the same rows respectively without garbling the data. Also note the RA is really only pertinent to the mash and Cl/SO4 ratio only pertinent to the total water.

The way I use this now is formulate my desired profile, make trial and error adjustments and then copy/paste the raw data into my NOTES window in Beertoolspro. Unfortunately, BTP doesn't really do water very well and it doesn't export its own water additions on the brewsheet print out but it DOES print out the notes... which now contains data derived for this spreadsheet.

Seriously, thanks for putting the work into this. It's what I'm recommending to all my brewclub members (if they want my help with it anyway).

__________________
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 10-28-2009, 03:55 PM   #104
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: 22,113
Liked 1020 Times on 680 Posts
Likes Given: 28

Default

Oh, do you mind if I do a video tutorial on how to use this thing?

__________________
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 10-28-2009, 05:49 PM   #105
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 978
Liked 62 Times on 37 Posts
Likes Given: 2

Default

Quote:
Originally Posted by Bobby_M View Post
Oh, do you mind if I do a video tutorial on how to use this thing?
That would be awesome!

I will look into the other things you mentioned as well.
__________________
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 10-28-2009, 06:04 PM   #106
ShortSnoutBrewing
Kwanesum Chinook Illahee
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
ShortSnoutBrewing's Avatar
Recipes 
 
Join Date: Oct 2007
Location: Portland, OR
Posts: 3,266
Liked 12 Times on 11 Posts
Likes Given: 1

Default

Quote:
Originally Posted by Bobby_M View Post
Oh, do you mind if I do a video tutorial on how to use this thing?
Please do Bobby!!
__________________
www.facebook.com/shortsnoutbrewing
www.twitter.com/ShortSnoutBrew
www.shortsnoutbrewing.com
ShortSnoutBrewing is offline
 
Reply With Quote Quick reply to this message
Old 10-28-2009, 06:14 PM   #107
GilaMinumBeer
In yo' garage, steelin' yo parts.
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
GilaMinumBeer's Avatar
Recipes 
 
Join Date: Jan 2008
Location: Oblivion
Posts: 48,115
Liked 4829 Times on 4432 Posts
Likes Given: 59

Default

I am just sad I haven't had the time to brew with this tool yet.

I have enjoyed it's progression and commend you for the time it took/takes.

Excellent work from a guy that, before this, was clueless and dis-interested in making water adjustments.

I am still clueless. But at least now I am interested.

__________________
GilaMinumBeer is offline
 
Reply With Quote Quick reply to this message
Old 10-28-2009, 06:29 PM   #108
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 978
Liked 62 Times on 37 Posts
Likes Given: 2

Default

Quote:
Originally Posted by Bobby_M View Post
There are two things that I've tweaked on my local copy and you may choose to implement or not. First. On the additions box, I put an indicator as to whether it makes RA go up or down. That helps me choose additions. I'm sure I'll eventually learn and not need it, but for now, it's nice.

The other thing is providing more complete output in the raw format page.
Good suggestions. I made both changes and re-uploaded. Give it a look to see if that's what you had in mind.

BTW Bobby I'm glad you like it and I thank you for your support. Its the least I can do considering how much I learned from your website, videos, etc. In my opinion you've put together some of the best stuff out there!
__________________
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 10-29-2009, 03:14 AM   #109
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: 22,113
Liked 1020 Times on 680 Posts
Likes Given: 28

Default

It's done as far as I'm concerned. I'll be doing a short tutorial showing how I use it sometime this week. I really wish I had a decent little preamp because my PC mic input sucks bad. Thanks.

__________________
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, 01:57 AM   #110
JerD
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2008
Location: NW Indiana
Posts: 168
Default

I'm loving the heck out of this tool. One more question though. Is the dilution rate figured in for the boil additions, or just the mash water? If I figure for 40%dilution, I just take six gallons of source water and 4 gallons of distilled water and blend it all together to make the dilution process simple.

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