I use my Excel Spreadsheet - Home Brew Forums

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

Reply
 
Thread Tools
Old 05-10-2009, 01:33 AM   #1
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts



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


 
Reply With Quote
Old 05-10-2009, 03:34 AM   #2
KYB
Recipes 
 
Jan 2009
Posts: 1,556
Liked 45 Times on 29 Posts


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

 
Reply With Quote
Old 05-10-2009, 04:15 AM   #3
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts


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

Cheers
Grimmy
__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com


 
Reply With Quote
Old 05-10-2009, 06:20 AM   #4
Gremlyn
 
Gremlyn's Avatar
Recipes 
 
Mar 2009
San Diego, CA
Posts: 2,358
Liked 29 Times on 19 Posts


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"!

 
Reply With Quote
Old 05-10-2009, 06:20 AM   #5
wendelgee2
Recipes 
 
Dec 2008
New York, NY
Posts: 324
Liked 3 Times on 2 Posts


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.

 
Reply With Quote
Old 05-27-2009, 03:33 AM   #6
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts


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


 
Reply With Quote
Old 06-04-2009, 08:47 PM   #7
wscott823
Recipes 
 
May 2009
Baltimore, Maryland
Posts: 484
Liked 7 Times on 6 Posts


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

 
Reply With Quote
Old 06-04-2009, 08:57 PM   #8
MMW
Recipes 
 
Apr 2009
Longview, TX
Posts: 529
Liked 4 Times on 4 Posts


I like the site! Thanks and bookmarked

 
Reply With Quote
Old 06-05-2009, 03:04 PM   #9
MMW
Recipes 
 
Apr 2009
Longview, TX
Posts: 529
Liked 4 Times on 4 Posts


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?

 
Reply With Quote
Old 06-12-2009, 12:35 AM   #10
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts


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


 
Reply With Quote
Reply
Thread Tools


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
Any Excel genuises out there? RIBeer General Chit Chat 7 09-16-2009 06:43 PM
Fun with excel uwjester General Beer Discussion 5 02-14-2009 12:14 AM


Forum Jump