SRM Formula - Home Brew Forums

Register Now!
Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > SRM Formula

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



Hey Fellas,

Ok I'm creating my Excel sheet for my mini mashes and I'm adding the SRM calculations. (šL x lbs grain)/gallons of brew)

My question is how do also add in the SRM from my liquid extract (8.1) and the DME SRM (8). Do I use the same formula with the SRM value and the quantity in pounds as I would use with the grain then add them all up?

Thanks,
LS_Grimmy

I have the link in my signature for my Excel sheet if you wanna look at it
__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com


 
Reply With Quote
Old 01-07-2007, 12:45 PM   #2
boo boo
Recipes 
 
Jun 2005
Hearts's Delight, Newfoundland
Posts: 4,165
Liked 35 Times on 30 Posts


Don't know if I can be of much help to you. Have you tried downloading
a program such as Strangebrew or promash or beersmith. All have trial
versions, and will tell you your SRM if you input your ingredients.
__________________
How do you BBQ an elephant....first you get your elephant....

 
Reply With Quote
Old 01-08-2007, 06:18 AM   #3
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts


Ya Im trying to stay away from the calculators and make my own but I guess I can check my results via the calculators

Thanks,
Marc
__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com


 
Reply With Quote
Old 01-08-2007, 10:29 AM   #4
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
 
Orfy's Avatar
Recipes 
 
Sep 2005
Cheshire, England
Posts: 11,732
Liked 94 Times on 62 Posts


SRM=((Efficiency*0.8)*Grain weight in LBS *º Lovibond)/Gallons


I use a look up table to do it.

My sheets messed up at present because I'm changing so many things but I'll email you the latest with the SRM stuff and look up tables.

The sheets coming along nicely Grimmy.
__________________
GET THE GOBLIN
Have a beer on me.


 
Reply With Quote
Old 01-08-2007, 12:20 PM   #5
zoebisch01
 
zoebisch01's Avatar
Recipes 
 
Nov 2006
Central PA
Posts: 5,182
Liked 10 Times on 10 Posts


I believe this is correct. Just substitute the LOV rating which is in lb/gal. I did one conversion (my first recipe was an extract) and recalled using that. The conversion came out so very close and it was a calculated blend of crystal malts...and I am fairly certain that is all I did. The real problem was finding the LOV rating of the DME!

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


Cool thanks orfy I would love to see that email from you for sure. I'll have to see were I missed the Efficiency*0.8 part of the equations but thanks for the help.

I've been working on my sheet for a while now. I want a better understanding of the formula's so I can better understand everything that is going on. Plus I like formula's and excel

Anyone else done this before?

Thanks,
LS_Grimmy
__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com


 
Reply With Quote
Old 01-11-2007, 06:21 AM   #7
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts


got another question

My coopers real ale kit is 8.1 Srm's

Now do I just add this value to the calculated Srm's from the grain and Dme or do I use the formula and add the results to the grand total:
lbs x Deg Lovibond / gallons of wort = ____

All my grain/Dme addes up to about 6 srm's so would I add the 8 srm's to this for a total of 14 Srm's?

Other than that Im good to go. Any Idea? If your confused on what I mean take a look at MY BEER LOG in on the link in my signature

Thanks for the help,
LS_Grimmy
__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com


 
Reply With Quote
Old 01-11-2007, 07:25 AM   #8
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
 
Orfy's Avatar
Recipes 
 
Sep 2005
Cheshire, England
Posts: 11,732
Liked 94 Times on 62 Posts


Obviously the SRM of the kit would be only accurate for a certain weight/volume of wort. So it needs plugging into the formula but the effieciency does not effect it.
__________________
GET THE GOBLIN
Have a beer on me.

 
Reply With Quote
Old 01-11-2007, 01:14 PM   #9
zoebisch01
 
zoebisch01's Avatar
Recipes 
 
Nov 2006
Central PA
Posts: 5,182
Liked 10 Times on 10 Posts


Quote:
Originally Posted by LS_Grimmy
Cool thanks orfy I would love to see that email from you for sure. I'll have to see were I missed the Efficiency*0.8 part of the equations but thanks for the help.

I've been working on my sheet for a while now. I want a better understanding of the formula's so I can better understand everything that is going on. Plus I like formula's and excel

Anyone else done this before?

Thanks,
LS_Grimmy

I have done it, just used the formula that brewsmith uses. I did come across an article about the color measurements, and like much in brewing it is not an exact measurement but a close approximation. I am still working on my spreadsheet as well.


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


Thanks for all the info:

What I did is just reverse the formula and figure out the Lovibond per gallon and then add it into the formula

So I pretty much think I have it all good to go

Thanks for the info all.... Cheers,
Marc
__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com


 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a formula abeeraday General Techniques 8 02-06-2009 04:07 PM
Does someone have an efficiency formula? impatient Beginners Beer Brewing Forum 10 02-01-2009 05:48 AM
Formula No.5 ericd Recipes/Ingredients 3 02-21-2008 06:50 PM
Which Hop IBU formula do you use? Bromley General Techniques 13 01-10-2008 12:48 AM
Anyone Else a Formula 1 Fan?? Rook General Chit Chat 1 03-04-2007 09:17 AM


Forum Jump