A helpful little file for basic extract brewing - Home Brew Forums
Register Now For Free!

Home Brew Forums > Home Brewing Beer > Extract Brewing > A helpful little file for basic extract brewing

Reply
 
Thread Tools
Old 07-29-2010, 04:06 AM   #1
erockomania
Recipes 
 
Jun 2010
SF CA
Posts: 307
Liked 6 Times on 6 Posts



Hey guys... this is what I use to do all my extract/specialty grain brewing. I made this basic brew calculator simply because I like to do random small batches for experimentation and if I find a recipe I like and want to do a larger batch, this will calculate everything for me. It also has a brewing log and a nice ABV calc with temp calibration. I hope you can use it as I find it very helpful for getting rough projections for ABV and such. All the yellow fields are where you input the data... the other fields are all set with formulas. I THINK it looks self explanatory but if you have questions on how it works please ask me.

New Excel
http://www.sendspace.com/file/2q7n6d

for Excel '97
http://www.sendspace.com/file/3i3ebv

*also, I added an "Original Batch Size" option to make things easier

If you can think of anything that might be helpful or looks wrong, please bring it to my attention. *Projected ABV% is based batch size and an 80% efficiency of LME. It tends to work out just about right every time if I use that %, so I worked it into the formula*

It should look exactly like this (for some reason some decimal points where in the wrong places on a system at work... file conversion issue, I guess)


 
Reply With Quote
Old 07-29-2010, 11:55 AM   #2
ScrewyBrewer
HBT_LIFETIMESUPPORTER.png
 
ScrewyBrewer's Avatar
Recipes 
 
Jun 2010
New Jersey, Monmouth, New Jersey
Posts: 853
Liked 101 Times on 86 Posts


Very nicely done I calculated 20 carbs and 218 calories per 12 oz serving for your example above with an 80% actual attenuation. I would prefer a way to enter the FG temperature separately as the pitching temperatures are usually higher than the post fermentation temperatures.

Screwy Brewer
__________________
'Give a man a beer and he'll waste an hour, teach him to brew beer and he'll waste a lifetime'.

The Screwy Brewer
www.thescrewybrewer.com
Screwy's On Facebook

 
Reply With Quote
Old 07-29-2010, 12:26 PM   #3
modobrew
 
modobrew's Avatar
Recipes 
 
Aug 2007
Raleigh, NC
Posts: 204
Liked 10 Times on 7 Posts


Can you save the file as the previous version of excel as my work computer does not have the newest office. Thanks and this looks pretty sweet.
__________________
Conical 1: Empty
Conical 2: Empty
Carboy 1: Empty
Carboy 2: Empty
Secondary: Vanilla Bourbon Porter
Bottle: Hibernation Ale Clone
Bottle: Houblonmonstre Tripel IPA
Keg 1: Southern Tier Pumking Clone
Keg 2: Kolsch
Keg 3: Angry Wolf IIPA

 
Reply With Quote
Old 07-29-2010, 04:24 PM   #4
JJL
 
JJL's Avatar
Recipes 
 
Feb 2010
, WI
Posts: 1,287
Liked 30 Times on 23 Posts


I've been meaning to do something like this for a while now. I just haven't had the time to gather all of the formulas together for the calculations. Looks pretty cool.

 
Reply With Quote
Old 07-29-2010, 05:25 PM   #5
erockomania
Recipes 
 
Jun 2010
SF CA
Posts: 307
Liked 6 Times on 6 Posts


Thanks guys... I hope you can get some use out of it!

I added an Original Batch Size option now as well... makes it even easier to down or upsize batches.

Simply start with your original batch size, add the ingredient amounts and you are good to go.

Not sure how to add in a final gravity temperature into the calc. If someone knows a formula, send 'er over!

I also added an Excel '97 file for you, modobrew.

 
Reply With Quote
Old 07-29-2010, 10:07 PM   #6
RavenChief
Recipes 
 
Feb 2010
Dover
Posts: 108
Liked 2 Times on 2 Posts


Looks great but your website will not let me download this file....

 
Reply With Quote
Old 07-29-2010, 10:20 PM   #7
erockomania
Recipes 
 
Jun 2010
SF CA
Posts: 307
Liked 6 Times on 6 Posts


So when you go to the link above (in the first post) do you see the "Download Link: Brew Calc 2.xlsx" at the bottom?


 
Reply With Quote
Old 07-30-2010, 04:58 PM   #8
erockomania
Recipes 
 
Jun 2010
SF CA
Posts: 307
Liked 6 Times on 6 Posts


Added DME as an option as well

 
Reply With Quote
Old 07-31-2010, 11:38 AM   #9
RavenChief
Recipes 
 
Feb 2010
Dover
Posts: 108
Liked 2 Times on 2 Posts


All I see is a website trying to sell me some kind of "upload/download" tool ???

 
Reply With Quote
Old 07-31-2010, 06:59 PM   #10
erockomania
Recipes 
 
Jun 2010
SF CA
Posts: 307
Liked 6 Times on 6 Posts


That's just a free file storage site with a confusing interface. Choose regular download and there shouldn't be a tool just a free download on the next page at the bottom. Click on the file name. If that doesn't work for you just PM me your email and I'll send it over.


 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract brewing, the step child of the brewing family blagoe Extract Brewing 0 04-13-2010 06:31 PM
first time extract brewing 400d Extract Brewing 1 04-07-2010 01:44 PM
Help for Better Extract Brewing Bonneville Extract Brewing 29 08-01-2008 03:02 AM
Brewing an old extract kit howlinowl Extract Brewing 6 07-27-2007 10:15 PM
honey and extract brewing help!!! sailman Extract Brewing 28 05-19-2006 01:45 AM


Forum Jump