Bobby_M

Vendor Ads 

Recipes 

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!

JerD

Recipes 

Awesome
Thanks alot

Joetuo

Recipes 

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?

Bobby_M

Vendor Ads 

Recipes 

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!

Joetuo

Recipes 

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.

wildwest450

Recipes 

With an srm of 6 or less.

Joetuo

Recipes 

ROFL I see what you did there.

weetodd

Recipes 

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

Brew-boy

Recipes 

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/

gruversm

Recipes 

Norton Internet Security is flagging the executable as a possible Virus.

__________________
Primary: Firestone Walker Reserve Clone, German Wheat
On Tap: Horehound Tripel,Gumballhead,Sierra Nevada Pale Ale, Founder's Breakfast Stout Clone, Hefeweizen