Author Topic: Using Percentages to create a grain bill  (Read 1939 times)

Offline irob1992

  • 1st Kit
  • *
  • Posts: 10
    • View Profile
Using Percentages to create a grain bill
« on: June 09, 2015, 03:22:46 AM »
Hi all! I'm trying to put together a recipe for Stone's Sublimely Self Righteous Ale using Mitch Steele's book on IPA's. I'm pretty new at this, so any help or insight you could provide would be awesome, my main problem is that I don't know how to use the percentages given to create a grain bill. The recipe calls for

Pale Malt 90.6%
Crystal Malt 4.5%
Carafa Special III malt dehusked 4.9%

The water to grain ratio for mashing is 1.36 qt/lb

It's a 90 minute boil with the following analytic targets:

OG: 1.080 SG
TG: 1.014 SG
ADF: 82.5%
IBU: 85
ABV: 8.7%
Color: 110 L

I'd like to make a 10 gallon batch.
Dreaming of my own solar powered brewery

Offline Stevie

  • Official Poobah of No Life.
  • *
  • Posts: 6858
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #1 on: June 09, 2015, 03:53:46 AM »
Easiest method is to use software. Most allow for entering grain as a percentage. You would then adjust the weights to hit the target OG. If a given application does not allow percentages, move the decimal one place to the left and enter as pounds (9.06 lbs, .45lbs, .49lbs) and adjust from there.

It wouldn't hurt to learn how to figure it out by hand. How to brew has he formulas needed.

Offline hopfenundmalz

  • Global Moderator
  • I must live here
  • *****
  • Posts: 8980
  • Milford, MI
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #2 on: June 09, 2015, 04:18:03 AM »
You need to know your system efficiency, if it already in the software do what Steve said.
Jeff Rankert
Ann Arbor Brewers Guild
AHA Governing Committee
BJCP National
Home-brewing, not just a hobby, it is a lifestyle!

Offline irob1992

  • 1st Kit
  • *
  • Posts: 10
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #3 on: June 09, 2015, 05:10:43 AM »
I'm not sure what my efficiency is, but I've been reading that about 70% is a fair guess.

Any software in paticular  you can recommend?

Or do you have a link to the article with the formula's?
Dreaming of my own solar powered brewery

Offline MDixon

  • Senior Brewmaster
  • ******
  • Posts: 1940
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #4 on: June 09, 2015, 10:53:29 AM »
It's simple once you figure it out, you want an OG of 1.080 so call that 80. Assuming your final volume is 5 gallons then 80 x 5 = 400 points. Now your efficiency comes into play, 400 / 0.7 = ~570 pts so that is what you need to get from your grain. I always default that grain yields 36 points per pound per gallon, ppg. So 570 / 36 = 15.8 lb, since you don't know your efficiency, call it 16.

16 x 90.6% = ~14.5 lb
16 x 4.5% = ~3/4 lb
16 x 4.9% = ~0.8 lb

If you get a higher OG then expected your efficiency was higher than expected. You can water down the beer to the gravity post boil to achieve the gravity you want and have more beer. Also you can boil off less, boil shorter if you determine your runoff gravity is higher than expected. I run my calcs using The Recipator, but calculate using a calculator during brew day. Most use the commercial programs.
http://hbd.org/recipator/
It's not a popularity contest, it's beer!

Offline curtism1234

  • Assistant Brewer
  • ***
  • Posts: 200
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #5 on: June 09, 2015, 03:08:35 PM »
https://brewgr.com/homebrew-recipe-calculator

I normally use this website. It has most of the popular grains and hops (though the alpha on the hops may have to be tweaked a bit). It does what I need it to do.

Offline erockrph

  • Official Poobah of No Life.
  • *
  • Posts: 6229
  • Chepachet, RI
    • View Profile
    • The Hop WHisperer
Re: Using Percentages to create a grain bill
« Reply #6 on: June 09, 2015, 03:15:48 PM »
I use Brewers Friend for my software, and this is how I scale recipes from percentage:
  • I enter all the percents as pounds for each ingredient. So 90.6% of Pale Malt would get entered as 90.6 pounds (and so on).
  • Then I adjust the batch size (through trial and error) until the OG matches the listed OG for the recipe.
  • Then I use the "Scale" function to scale the recipe to my batch size.
This results in a recipe scaled to my system and batch size.
Eric B.

Finally got around to starting a homebrewing blog: The Hop Whisperer

Derek

  • Guest
Re: Using Percentages to create a grain bill
« Reply #7 on: June 09, 2015, 04:38:53 PM »
I have a column in my excel sheet for percentages. I just plug and chug until the OG fits what I desire for a certain volume.

Offline duboman

  • Senior Brewmaster
  • ******
  • Posts: 1576
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #8 on: June 09, 2015, 09:29:01 PM »
It's simple once you figure it out, you want an OG of 1.080 so call that 80. Assuming your final volume is 5 gallons then 80 x 5 = 400 points. Now your efficiency comes into play, 400 / 0.7 = ~570 pts so that is what you need to get from your grain. I always default that grain yields 36 points per pound per gallon, ppg. So 570 / 36 = 15.8 lb, since you don't know your efficiency, call it 16.

16 x 90.6% = ~14.5 lb
16 x 4.5% = ~3/4 lb
16 x 4.9% = ~0.8 lb

If you get a higher OG then expected your efficiency was higher than expected. You can water down the beer to the gravity post boil to achieve the gravity you want and have more beer. Also you can boil off less, boil shorter if you determine your runoff gravity is higher than expected. I run my calcs using The Recipator, but calculate using a calculator during brew day. Most use the commercial programs.
http://hbd.org/recipator/

Software is most definitely the easiest way to do this but these calculations are great to know if you are getting started creating recipes. With this knowledge you can basically create recipes on the fly on a bar napkin to rough something out, easy peasy and then tweak when you get time and software:)
Peace....Love......Beer......

The Commune Brewing Company-Perfecting the craft of beer since 2010

Offline Frankenbrew

  • Brewmaster
  • *****
  • Posts: 677
  • South Shore Brew Club, SE Massachusetts
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #9 on: June 09, 2015, 09:35:33 PM »
I use Brewers Friend for my software, and this is how I scale recipes from percentage:
  • I enter all the percents as pounds for each ingredient. So 90.6% of Pale Malt would get entered as 90.6 pounds (and so on).
  • Then I adjust the batch size (through trial and error) until the OG matches the listed OG for the recipe.
  • Then I use the "Scale" function to scale the recipe to my batch size.
This results in a recipe scaled to my system and batch size.

I do the same thing, only with Brewsmith. Easy!
Frank C.

And thereof comes the proverb: 'Blessing of your
heart, you brew good ale.'

Offline irob1992

  • 1st Kit
  • *
  • Posts: 10
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #10 on: June 09, 2015, 10:27:09 PM »
Thanks! These are all great suggestions!
Dreaming of my own solar powered brewery

Offline 69franx

  • Official Poobah of No Life.
  • *
  • Posts: 3125
  • Bloatarian Brewing League
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #11 on: June 12, 2015, 04:33:16 PM »
I use Brewers Friend for my software, and this is how I scale recipes from percentage:
  • I enter all the percents as pounds for each ingredient. So 90.6% of Pale Malt would get entered as 90.6 pounds (and so on).
  • Then I adjust the batch size (through trial and error) until the OG matches the listed OG for the recipe.
  • Then I use the "Scale" function to scale the recipe to my batch size.
This results in a recipe scaled to my system and batch size.

I do the same thing, only with Brewsmith. Easy!
The way I do it in Beersmith is to add 1# of all grains listed, then use the grain percentages button to set them where I want them. I then use the adjust gravity button to hit the 1.080I want to hit. I already have my efficiency and batch size dialed into the software, so it accounts for those as well. Beersmith was one of my favorite brewing purchases, to me it really follows the KISS principle as well as the 6 Ps of success
Frank L.
Fermenting:
Conditioning:
In keg: Märzen
In Bottles:  
In the works:

Offline Brewbeerd

  • 1st Kit
  • *
  • Posts: 6
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #12 on: June 14, 2015, 09:09:56 PM »
+1 to good brewing software.  I prefer Beersmith.  Spend some time messing around with it and plugging in your grain weights to get a feel for your percentages.  Takes a little getting used to but once you do you'll be able to have an idea on grain percentages moving forward with future recipes.  The math formulas are great to know but I'm not very "mathy" and the brewing software cuts out the leg work in that regard.  Good luck!

Offline Phil_M

  • Senior Brewmaster
  • ******
  • Posts: 1703
  • Southern Maryland
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #13 on: June 15, 2015, 01:02:28 PM »
+1 on beersmith. To use percentages with it, as other have mentioned, input the percentages as pounds, then use the "adjust gravity" feature to scale it to the desired batch size.

As for the math, I'd use it more if someone collated all of them into a brewing formulas handbook of some sort.
Corn is a fine adjunct in beer.

And don't buy stale beer.

Offline Vogt52

  • 1st Kit
  • *
  • Posts: 8
    • View Profile
Re: Using Percentages to create a grain bill
« Reply #14 on: June 15, 2015, 02:41:30 PM »
When I write recipes I use the Brewersfriend.com free calculator. Very helpful and it allows you to play around with the grain until you hit your target OG