Christmas in September - Home Brew Forums

Register Now!
Home Brew Forums > Home Brewing Beer > General Beer Discussion > Christmas in September

Reply
 
Thread Tools
Old 09-28-2006, 06:03 AM   #1
Dude
Will work for beer
HBT_LIFETIMESUPPORTER.png
 
Dude's Avatar
Recipes 
 
Jan 2005
Knob Noster, Missouri
Posts: 8,770
Liked 87 Times on 70 Posts



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

 
Reply With Quote
Old 09-28-2006, 12:28 PM   #2
Toilet Rocker
 
Toilet Rocker's Avatar
Recipes 
 
Jul 2005
near Asbury Park, NJ
Posts: 846
Liked 12 Times on 12 Posts


Hey that's an impressive spreadsheet. I'll have to save a copy for use when I go AG. Nice work!
__________________
I need to find time to brew more often.

 
Reply With Quote
Old 09-28-2006, 12:41 PM   #3
Glibbidy
 
Glibbidy's Avatar
Recipes 
 
Oct 2005
Sunny Southern Vermont
Posts: 2,369
Liked 15 Times on 14 Posts


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.


 
Reply With Quote
Old 09-28-2006, 12:45 PM   #4
sonvolt
Recipes 
 
Feb 2006
Posts: 901
Liked 10 Times on 6 Posts


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.

 
Reply With Quote
Old 09-28-2006, 12:53 PM   #5
disaffected
Recipes 
 
Aug 2006
Posts: 829
Liked 6 Times on 6 Posts


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.

 
Reply With Quote
Old 09-28-2006, 12:55 PM   #6
the_bird
10th-Level Beer Nerd
HBT_LIFETIMESUPPORTER.png
 
the_bird's Avatar
Recipes 
 
May 2006
Adams, MA
Posts: 20,883
Liked 523 Times on 420 Posts


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


 
Reply With Quote
Old 09-28-2006, 01:20 PM   #7
Ol' Grog
Recipes 
 
Sep 2006
Chickasha, OK.
Posts: 1,035
Liked 2 Times on 2 Posts


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.

 
Reply With Quote
Old 09-28-2006, 02:00 PM   #8
Orpheus
 
Orpheus's Avatar
Recipes 
 
Jul 2006
Maryland 'burbs of Washington, D.C.
Posts: 2,323
Liked 24 Times on 14 Posts


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

http://www.openoffice.org/
__________________



 
Reply With Quote
Old 09-28-2006, 02:04 PM   #9
Chairman Cheyco
***DRAMATIZATION***
HBT_LIFETIMESUPPORTER.png
 
Chairman Cheyco's Avatar
Recipes 
 
Dec 2005
Calgary
Posts: 3,246
Liked 11 Times on 11 Posts


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.

 
Reply With Quote
Old 09-28-2006, 04:23 PM   #10
Dude
Will work for beer
HBT_LIFETIMESUPPORTER.png
 
Dude's Avatar
Recipes 
 
Jan 2005
Knob Noster, Missouri
Posts: 8,770
Liked 87 Times on 70 Posts


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

 
Reply With Quote


Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
2009 GABF, September 24-26 jds North Central Homebrew Forum 90 09-30-2009 08:45 PM
Sheboygan, Wisconsin on September 29, 2009? Yooper Great Lakes 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 05:12 PM


Forum Jump