Water Modification Videos, TH's Spreadsheet

**Bobby_M** · 10-31-2009, 06:24 PM

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.

http://www.youtube.com/watch?v=o1n7-RjEJEM

Part 2, modify for pale ale:
http://www.youtube.com/watch?v=pKT6EE7ong0

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.
http://www.youtube.com/watch?v=yn0GwU7TqNE

**Hammy71** · 10-31-2009, 11:49 PM

Looks good Bobby...
Thanks

**-TH-** · 11-01-2009, 03:25 AM

Excellent work. Looks great!

**Bobby_M** · 11-01-2009, 11:59 AM

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.

millstone · 11-02-2009, 12:08 PM

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

**Bobby_M** · 11-02-2009, 01:48 PM

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 ;-)

**-TH-** · 11-02-2009, 02:04 PM

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!

mgo737 · 11-03-2009, 08:24 AM

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!

**Bobby_M** · 11-03-2009, 05:31 PM

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.

mgo737 · 11-03-2009, 05:47 PM

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!