Ss Brewing Technologies Giveaway!

Home Brew Forums > Home Brewing Beer > General Beer Discussion > Christmas in September
Reply
 
LinkBack Thread Tools
Old 09-28-2006, 06:03 AM   #1
Dude
Will work for beer
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Dude's Avatar
Recipes 
 
Join Date: Jan 2005
Location: Knob Noster, Missouri
Posts: 8,843
Liked 55 Times on 45 Posts
Likes Given: 5

Default Christmas in September

Hey all, I figured I'd FINALLY share an extremely important facet of my brew day, my brew worksheet.

I've been tweaking this for about a year, and have added many new features to it. I compile all of the data a day or two before brew day and then print it out and place it on a clipboard and keep track as the brew day progresses. It has spaces to keep track of recipe specs, mashing specs, checkmark boxes to keep track of hop (and other ingredients) additions, and formulas that will figure out BU:GU ratio, how much strike water you'll need, % of yeast attenuation, alcohol %, approximate boil-off rate, efficiency, and even a gravity to ° plato conversion.

It is tweaked towards an AG brewer, but could easily be used for extract brewers as well. I mainly created it so I could go back a year from now and see every little detail about a brew from start to finish (recipe planning-brew day-tasting).

I've made it available to download, please feel free to edit it as you feel the need. If you figure out anything cool to add or whatever, let me know! I figure it will always be a work in progress!

Couple of notes if you want to use it--the gray fields have formulas in them, so don't type anything in these boxes. As you add info in other places, the gray boxes will fill in themselves.

I am an excel novice, so I went with the flow the best I could. If anyone has any questions on how to use it, I'll try to answer them in this thread.

Here it is (I even included a filled in version with a recipe for Lake Walk Pale Ale!):


Brew Worksheet

__________________
On Tap: Lake Walk Pale Ale -- Eternity (Raspberry Stout) -- Nutrocker -- Donnybrook Dark
Primary: Lake Walk Pale Ale
Secondary: Summit IPA
Up Next: Smoked Porter -- Pub Ale -- Watermelon Wheat
Planning:
Gone But Not Forgotten:

www.IronOrrBrewery.com
Dude is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 12:28 PM   #2
Toilet Rocker
Feedback Score: 0 reviews
 
Toilet Rocker's Avatar
Recipes 
 
Join Date: Jul 2005
Location: Asbury Park, NJ
Posts: 818
Liked 9 Times on 9 Posts
Likes Given: 1

Default

Hey that's an impressive spreadsheet. I'll have to save a copy for use when I go AG. Nice work!

__________________

When people ask what I do for a living, I say I brew beer. No, not as a profession, but to live.

Toilet Rocker is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 12:41 PM   #3
Glibbidy
Feedback Score: 0 reviews
 
Glibbidy's Avatar
Recipes 
 
Join Date: Oct 2005
Location: Sunny Southern Vermont
Posts: 2,399
Liked 12 Times on 11 Posts
Likes Given: 2

Default

That beats the living snot out of my lame brewlogs in excel format.

Good job, that reminds me I need get my act together and start keeping better records. Mine does include a forumla (dechiperable only by me) for calculating IBU's for hop additions.

__________________

Last edited by Glibbidy; 09-28-2006 at 12:44 PM.
Glibbidy is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 12:45 PM   #4
sonvolt
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2006
Posts: 902
Liked 8 Times on 6 Posts

Default

Yeah . . .that's cool. Thanks! Do you have a handy resource nearby from which you get all of your numbers? For instance, when you add grains to your grain bill, your spreadsheet contains gravity readings for them. Where do you get that information? My bags of grain don't have it, but I do get it automatically with Promash.

I would prefer to use your spreadsheet. I think that I may add a section on Sheet 2 that contains all the information about the grains I have in stock, etc. I just need to know where I can get the info without fishing through Promash for hours.

Any ideas?

Right now, I just use the Eval copy of Promash - seeking a cheaper alternative.

__________________
sonvolt is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 12:53 PM   #5
disaffected
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2006
Posts: 829
Liked 3 Times on 3 Posts

Default

That's really well-layed out and organized, Dude. I don't have Excel. It displays on my Linux system, but I'm not sure all the calculations work.

__________________
disaffected is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 12:55 PM   #6
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,507
Liked 373 Times on 308 Posts
Likes Given: 98

Default

Quote:
Originally Posted by beer4breakfast
That's really well-layed out and organized, Dude. I don't have Excel. It displays on my Linux system, but I'm not sure all the calculations work.
Can you somehow load that spreadsheet into the new Google spreadsheet program? I thought that was supposed to be Excel-compatible (haven't used it myself, just a thought).

EDIT: That seems to work, if you don't have Excel.
__________________
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.

Last edited by the_bird; 09-28-2006 at 01:01 PM.
the_bird is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 01:20 PM   #7
Ol' Grog
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2006
Location: Chickasha, OK.
Posts: 1,037
Liked 2 Times on 2 Posts

Default

Geesh, when I think I get a good hold on extract/mini mashing, I read something like Dudes spreadsheet and already, I start worrying because I know that at some point, I will go AG. It's just a matter of time. But after reading all that info, it's like sensory overload, but a challenge as well. Nice flow on the spreadsheet. Good, easy layout. Boy, going AG is, well, a lot of work. But, nothing comes cheap these days and you have to work at it to perfect the craft. After being on this site, I have even more respect for brewers. It ain't like Mr. Beer, which, I almost bought until doing some searches on the 'net.

__________________
Ol' Grog is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 02:00 PM   #8
Orpheus
Feedback Score: 0 reviews
 
Orpheus's Avatar
Recipes 
 
Join Date: Jul 2006
Location: Maryland 'burbs of Washington, D.C.
Posts: 2,364
Liked 13 Times on 10 Posts

Default For all those without Excel

You can download a free openoffice software program that will work with Microsoft Word, PowerPoint, Excel, etc. documents.

http://www.openoffice.org/

__________________


Orpheus is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 02:04 PM   #9
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 7 Times on 7 Posts

Default

Thanks a lot Dude! Now I have to brew again right away to try this bad boy out. You suck.

__________________

Once the wind has been broken, it cannot be fixed.

Chairman Cheyco is offline
 
Reply With Quote Quick reply to this message
Old 09-28-2006, 04:23 PM   #10
Dude
Will work for beer
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Dude's Avatar
Recipes 
 
Join Date: Jan 2005
Location: Knob Noster, Missouri
Posts: 8,843
Liked 55 Times on 45 Posts
Likes Given: 5

Default

Quote:
Originally Posted by sonvolt
Yeah . . .that's cool. Thanks! Do you have a handy resource nearby from which you get all of your numbers? For instance, when you add grains to your grain bill, your spreadsheet contains gravity readings for them. Where do you get that information? My bags of grain don't have it, but I do get it automatically with Promash.

I would prefer to use your spreadsheet. I think that I may add a section on Sheet 2 that contains all the information about the grains I have in stock, etc. I just need to know where I can get the info without fishing through Promash for hours.

Any ideas?

Right now, I just use the Eval copy of Promash - seeking a cheaper alternative.
Like you, I get all of my numbers from Promash. For a few of the entries where it isn't given, I guesstimate it. For example, I had to find a value for Mt. Dew once. I used my refractometer.

I use the spreadsheet as just another tool to help me become a better brewer. Sometimes it is a lot of work to input all of that data, but planning beers is sometimes half the fun. Making geeky spreadsheets is fun as well.
__________________
On Tap: Lake Walk Pale Ale -- Eternity (Raspberry Stout) -- Nutrocker -- Donnybrook Dark
Primary: Lake Walk Pale Ale
Secondary: Summit IPA
Up Next: Smoked Porter -- Pub Ale -- Watermelon Wheat
Planning:
Gone But Not Forgotten:

www.IronOrrBrewery.com
Dude 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
2009 GABF, September 24-26 jds Colorado HomeBrew Forum 90 09-30-2009 08:45 PM
Sheboygan, Wisconsin on September 29, 2009? Yooper Wisconsin HomeBrew Forum 3 09-26-2009 12:30 AM
It's september! Joos General Beer Discussion 17 09-03-2009 02:56 AM
Brew Calendar -- SEPTEMBER Dude General Beer Discussion 0 01-17-2006 04:12 PM