The Great Bottle Opener Giveaway

Home Brew Forums > Home Brewing Beer > Beginners Beer Brewing Forum > All Grain Mash/Sparge Water Calculator

Reply
 
LinkBack Thread Tools
Old 12-17-2008, 02:40 PM   #1
LakeErieBrew
Feedback Score: 0 reviews
Recipes 
 
Join Date: Nov 2008
Location: Sheffield Lake, Ohio
Posts: 279
Liked 3 Times on 3 Posts

Default All Grain Mash/Sparge Water Calculator

One thing that made all-grain brewing a bit mystifying for me was the amount of water to use for mashing and sparging.

I made a very simple calculator in Excel to help calculate the amounts of mash water, sparge water, and boil volume based on the amount of grain, amount of wort you want to put in primary, grain absorption, etc. These various parameters can be changed based on your recipe.

Please give it a try and let me know if it can be improved. I used a free file hosting site, so I apologize if there are any pop-ups.

Link

__________________
LakeErieBrew is offline
 
Reply With Quote Quick reply to this message
Old 12-17-2008, 03:00 PM   #2
Edcculus
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2007
Location: Greenville, SC
Posts: 4,567
Liked 39 Times on 37 Posts

Default

Sweet!

But Beersmith can calculate that for you.

__________________
Edcculus is offline
Le-Nick Likes This 
Reply With Quote Quick reply to this message
Old 12-17-2008, 03:07 PM   #3
The Pol
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2007
Posts: 11,616
Liked 51 Times on 48 Posts

Default

I love spreadsheets, but there are a lot of brewing software programs out there and they all do the same thing, as well as let you design a recipe.

__________________
The Pol is offline
MattGuk Likes This 
Reply With Quote Quick reply to this message
Old 12-17-2008, 04:10 PM   #4
TerryWendel
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2008
Location: Kennesaw, GA
Posts: 36
Default

I can't figure out BeerSmith. I usually just do these calculations by hand.

__________________
PipeDreams Brewery
Primary: Bipolar Squirrel Nut Brown, No Oats Oatmeal Stout
Secondary: Nada.
Bottled: Scottish 60/, Aunt Gingers XMas Ale, No Play I.P.A.
Kegged: Still dreaming.

"I have a right to nothing which another has a right to take away." - Thomas Jefferson
TerryWendel is offline
 
Reply With Quote Quick reply to this message
Old 12-17-2008, 04:40 PM   #5
LakeErieBrew
Feedback Score: 0 reviews
Recipes 
 
Join Date: Nov 2008
Location: Sheffield Lake, Ohio
Posts: 279
Liked 3 Times on 3 Posts

Default

I wasn't trying to reinvent the wheel with this little spreadsheet, just trying to make things quicker than doing it by hand.

I would like to give Beer Smith or a similar program another shot. I tried Beer Smith but couldn't figure it out after a few minutes, and haven't tried again since.

__________________
LakeErieBrew is offline
brew_ny Likes This 
Reply With Quote Quick reply to this message
Old 03-29-2010, 03:30 PM   #6
Bopper
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2006
Posts: 2,002
Liked 2 Times on 2 Posts
Likes Given: 129

Default

Just thought I'd bump this thread up. Nice spreadsheet!

__________________
Bopper is offline
 
Reply With Quote Quick reply to this message
Old 03-29-2010, 05:04 PM   #7
MikeP
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2010
Location: Longmont, CO
Posts: 61
Default

is the .15 qt per lb of water absorption by grain something of a 'known constant', or does that tend to vary based on the grains used, i.e. flaked, or the type of grind, etc?

__________________
MikeP is offline
 
Reply With Quote Quick reply to this message
Old 05-02-2010, 02:55 AM   #8
cgondoli1
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2010
Location: Rochester, NY
Posts: 104
Liked 1 Times on 1 Posts

Default Thanks

this makes it stupid easy for someone who doesnt have beersmith edcculus...

__________________
cgondoli1 is offline
 
Reply With Quote Quick reply to this message
Old 05-02-2010, 12:10 PM   #9
MajorTom
Feedback Score: 0 reviews
Recipes 
 
Join Date: Nov 2008
Posts: 179
Default

Here is the one I frequently use. Its super easy to use and also figures temperatures for strike water and sparge water. I was also too dumb to figure out beersmith :-)

http://www.brewheads.com/batch.php

__________________
MajorTom is offline
 
Reply With Quote Quick reply to this message
Old 06-25-2010, 06:37 PM   #10
DrawTap88
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2010
Location: Joliet, IL
Posts: 1,074
Liked 9 Times on 9 Posts
Likes Given: 10

Default

Quote:
Originally Posted by MajorTom View Post
Here is the one I frequently use. Its super easy to use and also figures temperatures for strike water and sparge water. I was also too dumb to figure out beersmith :-)

http://www.brewheads.com/batch.php
That brewheads wortksheet is sweet. Thanks.
__________________

Fermenting: Nothing
Secondary: Nothing
Bottled: Oatmeal Porter, Double Chocolate Chipotle Porter
Kegged: IPA, Red Rye

DrawTap88 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
Mash water/sparge water ratio Philsc Beginners Beer Brewing Forum 28 06-13-2014 09:11 PM
Mash Water Chemistry Calculator - Feedback Wanted Bearcat Brewmeister Brewing Software 30 11-17-2010 06:57 PM
mash water/sparge water ratios Budzu All Grain & Partial Mash Brewing 7 07-19-2009 11:49 PM
Calculator for 170 sparge water? macabra11 All Grain & Partial Mash Brewing 7 05-04-2009 11:17 PM
mash water/sparge water ammounts? aoverturff Beginners Beer Brewing Forum 3 09-17-2008 03:08 AM