Home Brew Forums

Home Brew Forums (http://www.homebrewtalk.com/forum.php)
-   Brewing Software (http://www.homebrewtalk.com/f84/)
-   -   I use my Excel Spreadsheet (http://www.homebrewtalk.com/f84/i-use-my-excel-spreadsheet-118399/)

LS_Grimmy 05-10-2009 01:33 AM

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


KYB 05-10-2009 03:34 AM

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

LS_Grimmy 05-10-2009 04:15 AM

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


Gremlyn 05-10-2009 06:20 AM

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

wendelgee2 05-10-2009 06:20 AM

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.

LS_Grimmy 05-27-2009 03:33 AM

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.

wscott823 06-04-2009 08:47 PM

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 :drunk:.

MMW 06-04-2009 08:57 PM

I like the site! Thanks and bookmarked :mug:

MMW 06-05-2009 03:04 PM

OK...confused here:


Standard Reference Method (SRM ):


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


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:

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?

LS_Grimmy 06-12-2009 12:35 AM

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,

All times are GMT. The time now is 07:40 AM.

Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.