New Giveaway - Wort Monster Conical Fermenter!

Home Brew Forums > Home Brewing Beer > Brewing Software > I use my Excel Spreadsheet




Reply
 
LinkBack Thread Tools Display Modes
Old 05-10-2009, 01:33 AM   #1
LS_Grimmy
Feedback Score: 0 reviews
 
LS_Grimmy's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
Liked 3 Times on 1 Posts

Default I use my Excel Spreadsheet

I use my excel sheet mostly because Im on a mac and not crazy about the software.

Here is my site if you want to take a look
Homebrew Beer Math

Cheers
Grimmy



__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 05-10-2009, 03:34 AM   #2
KYB
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2009
Posts: 1,566
Liked 38 Times on 24 Posts
Likes Given: 6

Default

Great work. That spreadsheet is awesome. Looks like a lot of work, thanks for sharing.



__________________
KYB is offline
 
Reply With Quote Quick reply to this message
Old 05-10-2009, 04:15 AM   #3
LS_Grimmy
Feedback Score: 0 reviews
 
LS_Grimmy's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
Liked 3 Times on 1 Posts

Default

Thanks... ya it's been on the go since 2007. Glad you liked it

Cheers
Grimmy

__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 05-10-2009, 06:20 AM   #4
Gremlyn
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2009
Location: San Diego, CA
Posts: 2,525
Liked 22 Times on 15 Posts
Likes Given: 5

Default

Downloaded to have a look tomorrow Initial glances and it looks great!

__________________
Quote:
Originally Posted by Yooper View Post
I'm a fan of "getting it in the can"!
Gremlyn is offline
 
Reply With Quote Quick reply to this message
Old 05-10-2009, 06:20 AM   #5
wendelgee2
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2008
Location: New York, NY
Posts: 324
Liked 2 Times on 2 Posts

Default

I started out by putting together my own spreadsheet. I'd really recommend it to beginners. It gets you familiar with some of the formulas, and really familiar with some of the simple math (like p/p/g). It's like calculus: you learn it by doing it the hard way with algebra first, then you can cheat.

__________________
wendelgee2 is offline
 
Reply With Quote Quick reply to this message
Old 05-27-2009, 03:33 AM   #6
LS_Grimmy
Feedback Score: 0 reviews
 
LS_Grimmy's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
Liked 3 Times on 1 Posts

Default

ya i agree you do learn a lot... I've also been working on the beer math website as well it's close to being finished just working on the last of the formulas. I've also noticed some errors in my verison 3.1 and will be uploading version 3.2 in about a week.

__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 06-04-2009, 08:47 PM   #7
wscott823
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2009
Location: Baltimore, Maryland
Posts: 489
Liked 6 Times on 5 Posts
Likes Given: 1

Default

Thanks for sharing your spreadsheet. The SWMBO isn't really onboard with spending on beer programs (...yet). I like the simplistic idea of a spreadsheet doing the calcs for me though.

Totally agree on the Calculus analogy from wendel. Man that takes me back .

__________________
Primary: Nada
Lagering/Secondary: Nada
Micro Barrel Aging: H2O & Metabisulfite
Bottled: Sparkling Ambrosia, Chai Graff, Cerberus Barleywine, Jamil's Evil Twin, Chinook IPA
Planned Brews: Devil's Serum (Golden Strong Ale)

Make Your Own Belgian Candi Syrup
wscott823 is offline
 
Reply With Quote Quick reply to this message
Old 06-04-2009, 08:57 PM   #8
MMW
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Longview, TX
Posts: 530
Liked 3 Times on 3 Posts

Default

I like the site! Thanks and bookmarked

__________________
MMW is offline
 
Reply With Quote Quick reply to this message
Old 06-05-2009, 03:04 PM   #9
MMW
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Longview, TX
Posts: 530
Liked 3 Times on 3 Posts

Default

OK...confused here:

Quote:
Standard Reference Method (SRM ):

Formula:

SRM's = Lbs Grain x Deg Lovibond) / Total Volume in US Gallons

Example:

So if you used 10 pounds of 2 row grain that is 1.9 Lovibond then you would multiply lbs of grain by Lovibond to get your SRM. Then add all the SRM's and divided by total batch volume by total US Gallons. Here is an example below:

(10.00 Lbs Grain x 1.9 Lovibond) = 19.0 SRM's
(0.50 Lbs Grain x 10.0 Lovibond) = 5 SRM's
(19 + 5) / 5 gallons = 4.8 SRM's

Total SRM's = 19 + 5 + 4.8 = 28.9
Wouldn't that be MCU as defined here:
Quote:
A first iteration at estimating beer color involved simply calculating the Malt Color Units (MCUs) of a recipe.

* MCU = (Weight of grain in lbs) * (Color of grain in degrees lovibond) / (volume in gallons)

For multiple grain additions, you can simply calculate the MCU for each addition and add them together. MCU provides a good estimate of SRM color for light beers, but starts to diverge as beer color exceeds 6-8 SRM, because light absorbance is logarithmic and not linear. For a more accurate estimate that holds for darker beers up to about 50 SRM, we turn to the Morey equation:

* SRM color = 1.4922 * (MCU ** 0.6859)

The Morey equation provides an excellent estimate of beer color throughout the range from 1-50 SRM, and is the one used by most brewers today.
In this case the beer would have an MCU of 28.9 which gives a SRM color of 15. I noticed this when I saw the calculated color of a recipe vary widely from what qBrew, beercalculus, and the brew-builder at BMW were indicating. The 30 your sheet indicates for my recipe would actually be an 15 (which matches other calculators I have used).

Any chance of getting an unprotected copy for tinkering?
__________________
MMW is offline
 
Reply With Quote Quick reply to this message
Old 06-12-2009, 12:35 AM   #10
LS_Grimmy
Feedback Score: 0 reviews
 
LS_Grimmy's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
Liked 3 Times on 1 Posts

Default

yup looked into it and your right... thanks for the info I'll be changing the formula on my site this week sometime.

srm = 1.4922 * (MCU ** 0.6859)


cheers man,
Grimmy



__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lets see your brewing Excel Spreadsheets LS_Grimmy General Beer Discussion 19 03-22-2011 10:57 PM
Need Some Excel Formatting Help jescholler Brewing Software 7 10-18-2009 10:50 PM
Fun with excel uwjester General Beer Discussion 5 02-13-2009 11:14 PM