Electric Brewing Supply 30A BCS Giveaway - Last Chance to Enter!


Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > SRM Formula
Reply
 
LinkBack Thread Tools
Old 01-07-2007, 04:51 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 SRM Formula

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

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 01-07-2007, 11:45 AM   #2
boo boo
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2005
Location: Hearts's Delight, Newfoundland
Posts: 4,171
Liked 30 Times on 26 Posts
Likes Given: 4

Default

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

boo boo is offline
 
Reply With Quote Quick reply to this message
Old 01-08-2007, 05:18 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

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

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 01-08-2007, 09:29 AM   #4
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Orfy's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cheshire, England
Posts: 11,853
Liked 69 Times on 52 Posts
Likes Given: 30

Default

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.


Orfy is offline
 
Reply With Quote Quick reply to this message
Old 01-08-2007, 11:20 AM   #5
zoebisch01
Feedback Score: 0 reviews
 
zoebisch01's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Central PA
Posts: 5,198
Liked 7 Times on 7 Posts

Default

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!

__________________
zoebisch01 is offline
 
Reply With Quote Quick reply to this message
Old 01-09-2007, 11:07 PM   #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

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

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 01-11-2007, 05:21 AM   #7
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 srm formula confusion

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

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 01-11-2007, 06:25 AM   #8
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Orfy's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cheshire, England
Posts: 11,853
Liked 69 Times on 52 Posts
Likes Given: 30

Default

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.
Orfy is offline
 
Reply With Quote Quick reply to this message
Old 01-11-2007, 12:14 PM   #9
zoebisch01
Feedback Score: 0 reviews
 
zoebisch01's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Central PA
Posts: 5,198
Liked 7 Times on 7 Posts

Default

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.
__________________

zoebisch01 is offline
 
Reply With Quote Quick reply to this message
Old 01-12-2007, 01:23 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

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

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



Quick Reply
Message:
Options
Thread Tools


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