Author Topic: figuring out grain bill %'s  (Read 3835 times)

Offline dzlater

  • Brewer
  • ****
  • Posts: 376
  • New Jersey
    • View Profile
figuring out grain bill %'s
« on: February 24, 2010, 05:24:22 PM »
  I know the percentages of grain I want,
but have to adjust them for efficiency.
  I tried using the method in Designing Great Beers to figure out
my grain bill. What this did was screw up my percents by weight.
I believe the book is giving me %'s by gravity per lb. ?
  So what I did was use the gravity per lb of the base malt
for all the other grains, so the weight %'s would stay constant.
  This seemed to work but I'm not sure it's the correct way to
go about it. Are there any easier way to scale grain bills for efficiency?

I can put all #'s up if any one cares???

Thanks

Offline hokerer

  • I spend way too much time on the AHA forum
  • ********
  • Posts: 2634
  • Manassas, VA
    • View Profile
Re: figuring out grain bill %'s
« Reply #1 on: February 24, 2010, 05:34:17 PM »
Go ahead and put the numbers up if you want but then you really ought to look into some homebrew software.  Beersmith has a downloadable free trial version and it'll let you scale recipes to your hearts content.
Joe

Offline blatz

  • Brewmaster General
  • *******
  • Posts: 2464
  • Paul Blatz - Jupiter, FL
    • View Profile
Re: figuring out grain bill %'s
« Reply #2 on: February 24, 2010, 05:35:54 PM »
Go ahead and put the numbers up if you want but then you really ought to look into some homebrew software.  Beersmith has a downloadable free trial version and it'll let you scale recipes to your hearts content.

+1 - its like 25 clams - well spent, IMO.
The happiest people don’t necessarily have the best of everything; they just make the best of everything they have.

BJCP National: F0281

Offline bluesman

  • Global Moderator
  • I must live here
  • *****
  • Posts: 8687
  • Delaware
    • View Profile
Re: figuring out grain bill %'s
« Reply #3 on: February 24, 2010, 05:41:17 PM »
+2

High mileage on that there beersmith model. Have it and love it.  8)
Ron Price

Offline dbeechum

  • Administrator
  • Brewmaster General
  • *****
  • Posts: 2311
  • Pasadena, CA
    • View Profile
    • Experimental Brewing
Re: figuring out grain bill %'s
« Reply #4 on: February 24, 2010, 05:41:47 PM »
Drew Beechum - Maltosefalcons.com
- Vote in the AHA GC Election! - http://bit.ly/1aV9GVd  -
-----
Burbling:
Gnome is in the Details
*Experimental Brewing - The Book*
Tap:
Peanut Butter Jelly Time
Tupelo Mead
Farmhouse Brett Saison

Offline beerocd

  • Senior Brewmaster
  • ******
  • Posts: 1400
    • View Profile
Re: figuring out grain bill %'s
« Reply #5 on: February 24, 2010, 06:33:34 PM »
Here you go, good for starts - and it's free....

http://sourceforge.net/projects/brewtarget/
The moral majority, is neither.

Offline dzlater

  • Brewer
  • ****
  • Posts: 376
  • New Jersey
    • View Profile
Re: figuring out grain bill %'s
« Reply #6 on: February 24, 2010, 08:12:06 PM »
Here you go, good for starts - and it's free....

http://sourceforge.net/projects/brewtarget/

I have brewtarget , but how do you go about resizing a batch
for efficiencies with it?

Offline dzlater

  • Brewer
  • ****
  • Posts: 376
  • New Jersey
    • View Profile
Re: figuring out grain bill %'s
« Reply #7 on: February 25, 2010, 04:48:41 AM »
See if this works for you.

http://maltosefalcons.com/tech/malt-bill-percentage-pound-calculator

Thanks
The spreadsheet gave me the same #'s that I calculated by hand.
So I did something right.

Offline dbeechum

  • Administrator
  • Brewmaster General
  • *****
  • Posts: 2311
  • Pasadena, CA
    • View Profile
    • Experimental Brewing
Re: figuring out grain bill %'s
« Reply #8 on: February 25, 2010, 10:26:40 AM »
Or I did something terribly wrong when I wrote it!   :D
Drew Beechum - Maltosefalcons.com
- Vote in the AHA GC Election! - http://bit.ly/1aV9GVd  -
-----
Burbling:
Gnome is in the Details
*Experimental Brewing - The Book*
Tap:
Peanut Butter Jelly Time
Tupelo Mead
Farmhouse Brett Saison

Offline Kaiser

  • Global Moderator
  • Senior Brewmaster
  • *****
  • Posts: 1797
  • Imperial Brewing Geek
    • View Profile
    • braukaiser.com
Re: figuring out grain bill %'s
« Reply #9 on: February 25, 2010, 11:24:20 AM »
Why don’t you just figure out how much grain you need by assuming a standard 36 ppg for example? For this you need to know the efficiency, target volume and target gravity. If you want to be really precise with the extract potential of the grist you can calculate the weighted average by considering the extract potential of each malt and its grain bill portion.

Once you have the total grist weight the individual grain weights are easy to calculate from their percentages.

That’s how I do it.

Kai


Offline dzlater

  • Brewer
  • ****
  • Posts: 376
  • New Jersey
    • View Profile
Re: figuring out grain bill %'s
« Reply #10 on: February 25, 2010, 02:55:28 PM »
Why don’t you just figure out how much grain you need by assuming a standard 36 ppg for example? For this you need to know the efficiency, target volume and target gravity. If you want to be really precise with the extract potential of the grist you can calculate the weighted average by considering the extract potential of each malt and its grain bill portion.

Once you have the total grist weight the individual grain weights are easy to calculate from their percentages.

That’s how I do it.

Kai

I think that is what I did by
using the gravity per lb of the base malt
for all the other grains, so the weight %'s would stay constant.
 ???


Offline Kaiser

  • Global Moderator
  • Senior Brewmaster
  • *****
  • Posts: 1797
  • Imperial Brewing Geek
    • View Profile
    • braukaiser.com
Re: figuring out grain bill %'s
« Reply #11 on: February 25, 2010, 03:43:16 PM »
I believe If you want to scale for efficiency you can simply do this for every grain weight:

new weight = (old weight * old efficiency) / new efficiency

Kai

Offline sladek

  • 1st Kit
  • *
  • Posts: 3
    • View Profile
Re: figuring out grain bill %'s
« Reply #12 on: March 01, 2010, 09:25:49 AM »
get Promash!

http://www.promash.com/

great software

Offline stownson

  • 1st Kit
  • *
  • Posts: 5
    • View Profile
Re: figuring out grain bill %'s
« Reply #13 on: March 01, 2010, 11:53:01 AM »
I'll second the usefulness of Promash when dealing with fluxuating batch sizes and effeciencies.

To accomplish your grain bill amounts from a base recipe, you simply enter your base recipe and then click the lock ingredients box.

You can now adjust your batch size up or down and maintain the same percentages of grainbill.

Offline redzim

  • Brewer
  • ****
  • Posts: 264
    • View Profile
Re: figuring out grain bill %'s
« Reply #14 on: March 09, 2010, 08:05:45 AM »
Why don’t you just figure out how much grain you need by assuming a standard 36 ppg for example? For this you need to know the efficiency, target volume and target gravity. If you want to be really precise with the extract potential of the grist you can calculate the weighted average by considering the extract potential of each malt and its grain bill portion.

Once you have the total grist weight the individual grain weights are easy to calculate from their percentages.

That’s how I do it.

Kai



Do you always go with the 36ppg when computing what efficiency you are hitting? Or do you try to use the extract potential of each individual malt? I've been trying to use exact numbers in my calculations but I am slowly learning that everyone's numbers fluctuate by a few points for just about every malt!  So if I would just use 36ppg, maybe that would simplify things.... but I don't want to lose too much accuracy.

-red