Yet Another Brewing Spreadsheet - Home Brew Forums
Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > Yet Another Brewing Spreadsheet

Reply
 
Thread Tools
Old 01-17-2007, 04:38 AM   #1
Walker
I use secondaries. :p
HBT_LIFETIMESUPPORTER.png
 
Walker's Avatar
Recipes 
 
Sep 2005
Cary, NC
Posts: 10,987
Liked 101 Times on 89 Posts



Hey folks....

There might already be something like this out there, but putting together my own helped me understand things a lot better. So... if I have repeated the work of someone else, I DON'T CARE.

The following is a spreadsheet I put together to help me calculate the volumes and temperatures of water for a single-step infusion mash with a single batch sparge.

I tried to describe everything going on in the spreadsheet, but if you think you might want to use this and are not clear on something, go ahead and shoot me a PM and I'll see if I can set you straight.

I have no immediate intentions of adding or removing anything from this spreadsheet because there are lots of free resources out there to help you calculate color and bitterness and gravity and all that jazz. This is really just for helping you get your water in order.

(See most recent postings for the latest version of the spreadsheet)


__________________
Ground Fault Brewing Co.

 
Reply With Quote
Old 01-17-2007, 04:52 AM   #2
RichBrewer
HBT_LIFETIMESUPPORTER.png
 
RichBrewer's Avatar
Recipes 
 
Feb 2006
Denver, Colorado
Posts: 5,892
Liked 165 Times on 86 Posts


That is a cool spread sheet Walker. I'm going to play with it a bit.

One question though. Where is the area for hydrometer readings???


__________________
Cheers,
Rich

 
Reply With Quote
Old 01-17-2007, 04:53 AM   #3
Walker
I use secondaries. :p
HBT_LIFETIMESUPPORTER.png
 
Walker's Avatar
Recipes 
 
Sep 2005
Cary, NC
Posts: 10,987
Liked 101 Times on 89 Posts


Quote:
Originally Posted by RichBrewer
One question though. Where is the area for hydrometer readings???
Bend over and I'll show you.
__________________
Ground Fault Brewing Co.

 
Reply With Quote
Old 01-17-2007, 04:55 AM   #4
RichBrewer
HBT_LIFETIMESUPPORTER.png
 
RichBrewer's Avatar
Recipes 
 
Feb 2006
Denver, Colorado
Posts: 5,892
Liked 165 Times on 86 Posts


Quote:
Originally Posted by Walker-san
Bend over and I'll show you.
You've got a lot of nerve talking to me like that!
__________________
Cheers,
Rich

 
Reply With Quote
Old 01-17-2007, 04:56 AM   #5
dibby33
 
dibby33's Avatar
Recipes 
 
Nov 2006
Hobart, Tasmania
Posts: 2,127
Liked 15 Times on 15 Posts


Oh oh, Mods are rutting again...
__________________

Primary
s : Ginger Beer, Wheat Beer
.
Secondary :
Empty
Bottled
: all drunk
Drinking : A Lot.
Next Up : Wheat Beer with grainy things

 
Reply With Quote
Old 01-17-2007, 02:30 PM   #6
EdWort
HBT_LIFETIMESUPPORTER.png
 
EdWort's Avatar
Recipes 
 
Jul 2006
Bee Cave, Texas
Posts: 11,914
Liked 336 Times on 169 Posts


Walker-san needs a refractor for Christmas.

 
Reply With Quote
Old 01-17-2007, 02:39 PM   #7
the_bird
10th-Level Beer Nerd
HBT_LIFETIMESUPPORTER.png
 
the_bird's Avatar
Recipes 
 
May 2006
Adams, MA
Posts: 20,879
Liked 520 Times on 419 Posts


This is really cool, Walker, a lot easier than doing the calculations by hand each time. Thanks!
__________________
Come join Yankee Ingenuity!

"I'm kind of toasted. But I looked at my watch and it's only 6:30 so I can't stop drinking yet." - Yooper's Bob
"Brown eye finally recovered after the abuse it endured in Ptown last weekend, but it took almost a full week." - Paulie
"no, he just doesn't speak 'stupid'. i, however, am fluent...." - motobrewer
"... I'll go both ways." - Melana

 
Reply With Quote
Old 01-17-2007, 02:49 PM   #8
Chairman Cheyco
***DRAMATIZATION***
HBT_LIFETIMESUPPORTER.png
 
Chairman Cheyco's Avatar
Recipes 
 
Dec 2005
Calgary
Posts: 3,246
Liked 11 Times on 11 Posts


Quote:
Originally Posted by Walker-san
Bend over and I'll show you.

Yes! The universal answer!!! There is not a question which cannot be adequately answered by this reply.

Good spreadsheet too... or whatever, I didn't really look at it.
__________________
Once the wind has been broken, it cannot be fixed.

 
Reply With Quote
Old 02-01-2007, 08:30 PM   #9
Walker
I use secondaries. :p
HBT_LIFETIMESUPPORTER.png
 
Walker's Avatar
Recipes 
 
Sep 2005
Cary, NC
Posts: 10,987
Liked 101 Times on 89 Posts


I made some changes to this after some feedback from a couple of people.

(See most recent postings for the latest version of the spreadsheet)
__________________
Ground Fault Brewing Co.

 
Reply With Quote
Old 02-01-2007, 11:13 PM   #10
Lazarus Long
Recipes 
 
Nov 2006
Charlotte, NC
Posts: 34

Thanks Walker-san.

I was bumbling around trying to make a spread sheet but your's is much better.

You saved me quite a lot of time.

Kudos from Charlotte.


__________________
Teaching Someone To Brew Is The Best Way To Thank The Person Who Taught You!
Primary 1: Apfelwein
Primary 2: Worchestershire Porter
Secondary 1: Empty
Secondary 2: Empty
Bottled: English Old Ale, Altbier, EOB, Ballantine's Old IPA Clone, John Barley Wine.

 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Brewing Spreadsheet albannach Brewing Software 7 08-22-2013 06:07 AM
how to use spreadsheet Stubbs5150 Brew Science 2 08-30-2009 08:26 PM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 07:01 PM
Help with Palmer's RA Spreadsheet BigNastyBrew All Grain & Partial Mash Brewing 2 02-09-2009 09:44 PM
spreadsheet shrades Mead Forum 7 01-20-2009 12:57 AM


Forum Jump