Ss Brewing Technologies Giveaway!

Home Brew Forums > Home Brewing Beer > Extract Brewing > A helpful little file for basic extract brewing
Reply
 
LinkBack Thread Tools
Old 07-29-2010, 04:06 AM   #1
erockomania
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2010
Location: SF CA
Posts: 307
Liked 5 Times on 5 Posts
Likes Given: 7

Default A helpful little file for basic extract brewing

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)

__________________

Last edited by erockomania; 07-29-2010 at 11:58 PM.
erockomania is offline
 
Reply With Quote Quick reply to this message
Old 07-29-2010, 11:55 AM   #2
ScrewyBrewer
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
ScrewyBrewer's Avatar
Recipes 
 
Join Date: Jun 2010
Location: New Jersey, Monmouth, New Jersey
Posts: 265
Liked 3 Times on 3 Posts
Likes Given: 2

Default

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

ScrewyBrewer is offline
 
Reply With Quote Quick reply to this message
Old 07-29-2010, 12:26 PM   #3
modobrew
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
modobrew's Avatar
Recipes 
 
Join Date: Aug 2007
Location: Raleigh, NC
Posts: 235
Liked 9 Times on 7 Posts
Likes Given: 6

Default

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
modobrew is offline
 
Reply With Quote Quick reply to this message
Old 07-29-2010, 04:24 PM   #4
JJL
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2010
Location: , WI
Posts: 1,279
Liked 30 Times on 23 Posts
Likes Given: 2

Default

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.

__________________
JJL is offline
 
Reply With Quote Quick reply to this message
Old 07-29-2010, 05:25 PM   #5
erockomania
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2010
Location: SF CA
Posts: 307
Liked 5 Times on 5 Posts
Likes Given: 7

Default

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.

__________________
erockomania is offline
 
Reply With Quote Quick reply to this message
Old 07-29-2010, 10:07 PM   #6
RavenChief
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2010
Location: Dover
Posts: 108
Liked 2 Times on 2 Posts
Likes Given: 4

Default

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

__________________
RavenChief is offline
 
Reply With Quote Quick reply to this message
Old 07-29-2010, 10:20 PM   #7
erockomania
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2010
Location: SF CA
Posts: 307
Liked 5 Times on 5 Posts
Likes Given: 7

Default

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?

__________________

Last edited by erockomania; 07-30-2010 at 12:01 AM.
erockomania is offline
 
Reply With Quote Quick reply to this message
Old 07-30-2010, 04:58 PM   #8
erockomania
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2010
Location: SF CA
Posts: 307
Liked 5 Times on 5 Posts
Likes Given: 7

Default

Added DME as an option as well

__________________
erockomania is offline
 
Reply With Quote Quick reply to this message
Old 07-31-2010, 11:38 AM   #9
RavenChief
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2010
Location: Dover
Posts: 108
Liked 2 Times on 2 Posts
Likes Given: 4

Default

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

__________________
RavenChief is offline
 
Reply With Quote Quick reply to this message
Old 07-31-2010, 06:59 PM   #10
erockomania
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2010
Location: SF CA
Posts: 307
Liked 5 Times on 5 Posts
Likes Given: 7

Default

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.

__________________

Last edited by erockomania; 07-31-2010 at 07:03 PM.
erockomania 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
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