Get your HBT Growlers, Shirts and Membership before the Rush!


Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > Yet Another Brewing Spreadsheet
Reply
 
LinkBack Thread Tools
Old 01-17-2007, 04:38 AM   #1
Walker
I use secondaries. :p
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Walker's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cary, NC
Posts: 11,236
Liked 89 Times on 79 Posts
Likes Given: 11

Default Yet Another Brewing Spreadsheet

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.
Walker is offline
 
Reply With Quote Quick reply to this message
Old 01-17-2007, 04:52 AM   #2
RichBrewer
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
RichBrewer's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Denver, Colorado
Posts: 5,767
Liked 85 Times on 41 Posts
Likes Given: 77

Default

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

RichBrewer is offline
 
Reply With Quote Quick reply to this message
Old 01-17-2007, 04:53 AM   #3
Walker
I use secondaries. :p
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Walker's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cary, NC
Posts: 11,236
Liked 89 Times on 79 Posts
Likes Given: 11

Default

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.
Walker is offline
 
Reply With Quote Quick reply to this message
Old 01-17-2007, 04:55 AM   #4
RichBrewer
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
RichBrewer's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Denver, Colorado
Posts: 5,767
Liked 85 Times on 41 Posts
Likes Given: 77

Default

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

RichBrewer is offline
 
Reply With Quote Quick reply to this message
Old 01-17-2007, 04:56 AM   #5
dibby33
Feedback Score: 0 reviews
 
dibby33's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Hobart, Tasmania
Posts: 2,164
Liked 3 Times on 3 Posts

Default

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
dibby33 is offline
 
Reply With Quote Quick reply to this message
Old 01-17-2007, 02:30 PM   #6
EdWort
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
EdWort's Avatar
Recipes 
 
Join Date: Jul 2006
Location: Bee Cave, Texas
Posts: 11,969
Liked 276 Times on 142 Posts
Likes Given: 7

Default

Walker-san needs a refractor for Christmas.

__________________

Cheers,

EdWort

Haus Pale Ale, Bavarian Hefeweizen, Robust Porter, Oktoberfest Ale, Wounded Knee IPA, Rye IPA, BCB IPA, Kolsch, Apfelwein

EdWort is offline
 
Reply With Quote Quick reply to this message
Old 01-17-2007, 02:39 PM   #7
the_bird
10th-Level Beer Nerd
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
the_bird's Avatar
Recipes 
 
Join Date: May 2006
Location: Adams, MA
Posts: 20,591
Liked 392 Times on 325 Posts
Likes Given: 105

Default

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

That'll do, Pigley. That'll do.
the_bird is offline
 
Reply With Quote Quick reply to this message
Old 01-17-2007, 02:49 PM   #8
Chairman Cheyco
***DRAMATIZATION***
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Chairman Cheyco's Avatar
Recipes 
 
Join Date: Dec 2005
Location: Calgary
Posts: 3,274
Liked 9 Times on 9 Posts

Default

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.

Chairman Cheyco is offline
 
Reply With Quote Quick reply to this message
Old 02-01-2007, 08:30 PM   #9
Walker
I use secondaries. :p
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Walker's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cary, NC
Posts: 11,236
Liked 89 Times on 79 Posts
Likes Given: 11

Default

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.
Walker is offline
 
Reply With Quote Quick reply to this message
Old 02-01-2007, 11:13 PM   #10
Lazarus Long
Feedback Score: 0 reviews
Recipes 
 
Join Date: Nov 2006
Location: Charlotte, NC
Posts: 30
Default

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.
Lazarus Long 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
Brewing Spreadsheet albannach Brewing Software 7 08-22-2013 07:07 AM
how to use spreadsheet Stubbs5150 Brew Science 2 08-30-2009 09:26 PM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 08: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



Newest Threads

LATEST SPONSOR DEALS