Happy HolidaySs Giveaway - Last Sponsor Giveaway of the Year!

Come Enter the BrewDeals/FastFerment Giveaway!

 Home Brew Forums > I use my Excel Spreadsheet
05-10-2009, 02:33 AM   #1
LS_Grimmy
Feedback Score: 0 reviews

Recipes

Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
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

05-10-2009, 04:34 AM   #2
KYB
Feedback Score: 0 reviews
Recipes

Join Date: Jan 2009
Posts: 1,566
Liked 41 Times on 25 Posts
Likes Given: 6

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

__________________

05-10-2009, 05:15 AM   #3
LS_Grimmy
Feedback Score: 0 reviews

Recipes

Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
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

05-10-2009, 07:20 AM   #4
Gremlyn
Feedback Score: 0 reviews
Recipes

Join Date: Mar 2009
Location: San Diego, CA
Posts: 2,524
Liked 24 Times on 16 Posts
Likes Given: 5

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

__________________
Quote:
 Originally Posted by Yooper I'm a fan of "getting it in the can"!

05-10-2009, 07:20 AM   #5
wendelgee2
Feedback Score: 0 reviews
Recipes

Join Date: Dec 2008
Location: 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.

__________________

05-27-2009, 04:33 AM   #6
LS_Grimmy
Feedback Score: 0 reviews

Recipes

Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
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

06-04-2009, 09: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

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 .

__________________
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

06-04-2009, 09:57 PM   #8
MMW
Feedback Score: 0 reviews
Recipes

Join Date: Apr 2009
Location: Longview, TX
Posts: 529
Liked 3 Times on 3 Posts

I like the site! Thanks and bookmarked

__________________

06-05-2009, 04:04 PM   #9
MMW
Feedback Score: 0 reviews
Recipes

Join Date: Apr 2009
Location: Longview, TX
Posts: 529
Liked 3 Times on 3 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?
__________________

06-12-2009, 01:35 AM   #10
LS_Grimmy
Feedback Score: 0 reviews

Recipes

Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
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