Spike Brewing 12.5 Conical Fermenter Giveaway - Enter Now!

Home Brew Forums > Home Brewing Beer > Brew Science > Water Modification Videos, TH's Spreadsheet

Reply
 
LinkBack Thread Tools
Old 10-31-2009, 06:24 PM   #1
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,901
Liked 939 Times on 625 Posts
Likes Given: 28

Default Water Modification Videos, TH's Spreadsheet

Of course I don't have to remind you folks that I'm a complete novice at this topic. I'm not claiming authority in any way, just trying to pass on nuggets of info that other people were good enough to pass on to me.

This is part one in a series of at least 3, still editing and rendering the 2nd and 3rd parts.

Corrections and criticisms welcome.. If you click the video to go directly to youtube, you can watch in HQ to see the text better.



Part 2, modify for pale ale:


Part 3, modify for dark beer and includes the concept of separate mash/boil additions and the ability to exclude some salts from the boil addition if necessary.
__________________
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?

Last edited by Bobby_M; 11-04-2009 at 08:24 PM.
Bobby_M is offline
 
Reply With Quote Quick reply to this message
Old 10-31-2009, 11:49 PM   #2
Hammy71
Senior Member
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
Hammy71's Avatar
Recipes 
 
Join Date: Sep 2008
Location: , Maryland, The Tax Me State
Posts: 5,570
Liked 397 Times on 309 Posts
Likes Given: 600

Default

Looks good Bobby...
Thanks

__________________
Hammy71 is offline
 
Reply With Quote Quick reply to this message
Old 11-01-2009, 03:25 AM   #3
-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

Excellent work. Looks great!

__________________
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 11-01-2009, 11:59 AM   #4
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,901
Liked 939 Times on 625 Posts
Likes Given: 28

Default

I couldn't figure out a way to make it more concise and I realize it's a little rambly. Anyway, I added part 2 last night.

__________________
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-02-2009, 12:08 PM   #5
millstone
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2007
Location: In front of my computer in Hammond IN
Posts: 161
Liked 2 Times on 2 Posts
Likes Given: 4

Default

good stuff, I always enjoy your videos. In part two, you talk about the amount of mash and sparge water required and you only talk about adding salts based on the amount of mash water. The application also shows salt additions for the boil, are you not adding any salts as shown on the app to your boil? Also in part one I have watched it maybe a dozen times and every time I look at part one the gallon of milk is still on the counter. Don't you think you should put it away.

tom

__________________
millstone is offline
 
Reply With Quote Quick reply to this message
Old 11-02-2009, 01:48 PM   #6
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,901
Liked 939 Times on 625 Posts
Likes Given: 28

Default

Hey Tom, I think the chatter about the mash/boil additions was cut out of part two but I'm pretty sure I mention it in part 3, which is yet to be edited. I'll make sure I put that in there or at least annotate the video somewhere.

That milk jug is empty and it's my job to put it in the recycle bin in the garage. However, instead of doing what I'm supposed to, I sit here making videos for you guys ;-)

__________________
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-02-2009, 02:04 PM   #7
-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

Bobby, I spent the 10 bucks and got a domain name for the spreadsheet. It is: www.EZWaterCalculator.com. Maybe you can update your videos and signature if its not too late. Soon I will put a link on the website to your videos.

Cheers!

__________________
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 11-03-2009, 08:24 AM   #8
mgo737
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2008
Posts: 194
Liked 1 Times on 1 Posts

Default

TH, can you take your spreadsheet one step further and have it convert the grams to teaspoons of each salt? That would be so helpful... Love the program otherwise!

__________________
mgo737 is offline
 
Reply With Quote Quick reply to this message
Old 11-03-2009, 05:31 PM   #9
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,901
Liked 939 Times on 625 Posts
Likes Given: 28

Default

TH, no problem. I'm glad I didn't put the URL in the video render itself.

mgo737, I figured out the volume to weights on most of the salts last night and added it as a formula on the raw text output worksheet. I don't have it in front of me at the moment but IIRC, the fine powders like chalk and gypsum were 1/4 tsp per gram and epsom salt and baking soda were 1/8 tsp per gram. Those were lightly packed and level screeded amounts. I'll verify when I go home. I would caution that you'll be accepting a small level of error depending on how much moisture the salt has absorbed and how fine the powders are. I think calcium chloride has quite a large grain structure but it might be finer than yours and that would throw off the weight per volume. It's not rocket science though, I suppose.

__________________
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-03-2009, 05:47 PM   #10
mgo737
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2008
Posts: 194
Liked 1 Times on 1 Posts

Default

Well, I know what the adjustments are. I just feel the online calculator would be the absolute bomb if it converted grams to teaspoons on a separate line automatically...

This page has the conversion factors:
http://www.howtobrew.com/section3/chapter15-4.html

Thanks,
Mike

P.S. Bobby M and everyone else who helped, I just had my first bottle of the first beer I brewed using salts. It was far and away the best beer I ever brewed! I previously was stupidly using RO water with no adjustments and getting mediocre to bad beer. Thanks all!

__________________
mgo737 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
EZ Water Adjustment spreadsheet -TH- Brew Science 194 04-01-2012 05:13 AM
Side by side water modification test Bobby_M Brew Science 53 03-16-2010 03:39 PM
Water modification for extract brews? carbon111 Extract Brewing 14 06-21-2009 04:16 PM
Devising water recipes using Palmer's spreadsheet SpanishCastleAle General Techniques 0 02-22-2009 12:12 PM
Water Chemistry Modification? cweston All Grain & Partial Mash Brewing 3 06-07-2006 04:19 PM