 |
|
10-31-2009, 06:24 PM
|
#1
|
|
Vendor and Brewer
Feedback Score: 0 reviews
Join Date: Aug 2006
Location: Piscataway, NJ
Posts: 20,769
Liked 478 Times on 340 Posts Likes Given: 9
|
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!
Last edited by Bobby_M; 11-04-2009 at 08:24 PM.
|
|
|
10-31-2009, 11:49 PM
|
#2
|
|
Senior Member
Feedback Score: 0 reviews
Join Date: Sep 2008
Location: , Maryland, The Tax Me State
Posts: 4,918
Liked 217 Times on 179 Posts Likes Given: 201
|
Looks good Bobby...
Thanks
|
|
|
11-01-2009, 03:25 AM
|
#3
|
|
Feedback Score: 0 reviews
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 955
Liked 32 Times on 23 Posts Likes Given: 2
|
Excellent work. Looks great! 
|
|
|
11-01-2009, 11:59 AM
|
#4
|
|
Vendor and Brewer
Feedback Score: 0 reviews
Join Date: Aug 2006
Location: Piscataway, NJ
Posts: 20,769
Liked 478 Times on 340 Posts Likes Given: 9
|
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!
|
|
|
11-02-2009, 12:08 PM
|
#5
|
|
Feedback Score: 0 reviews
Join Date: Sep 2007
Location: In front of my computer in Hammond IN
Posts: 117
Likes Given: 2
|
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
|
|
|
11-02-2009, 01:48 PM
|
#6
|
|
Vendor and Brewer
Feedback Score: 0 reviews
Join Date: Aug 2006
Location: Piscataway, NJ
Posts: 20,769
Liked 478 Times on 340 Posts Likes Given: 9
|
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!
|
|
|
11-02-2009, 02:04 PM
|
#7
|
|
Feedback Score: 0 reviews
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 955
Liked 32 Times on 23 Posts Likes Given: 2
|
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!
|
|
|
11-03-2009, 08:24 AM
|
#8
|
|
Feedback Score: 0 reviews
Join Date: Sep 2008
Posts: 194
Liked 1 Times on 1 Posts
|
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!
|
|
|
11-03-2009, 05:31 PM
|
#9
|
|
Vendor and Brewer
Feedback Score: 0 reviews
Join Date: Aug 2006
Location: Piscataway, NJ
Posts: 20,769
Liked 478 Times on 340 Posts Likes Given: 9
|
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!
|
|
|
11-03-2009, 05:47 PM
|
#10
|
|
Feedback Score: 0 reviews
Join Date: Sep 2008
Posts: 194
Liked 1 Times on 1 Posts
|
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!
|
|
|
| Thread Tools |
|
|
| Display Modes |
Linear Mode
|
|
|
|