How To Formulate Recipes / A Handy Brewlog

I have devised a fill-in-the-blank form that I find quite handy for planning the recipe for a batch of beer and also for keeping track of what I do when I actually make that beer. It is most useful for all- (or mostly-) grain recipes, but extract brewers may find it and this discussion useful. Here is the form with a brief primer on formulating recipes with it. You need to know three things to use this form that I won't be explaining: 1) math, 2) how to make beer, and 3) what type of ingredients your desired beer style uses. This form helps you calculate amounts but the types are up to you. I find that this and a calculator are much more useful (and portable) than those spreadsheet recipe formulators. (I apologize for the rampant unit switching. These are the units I usually use, for whatever reasons.)

At the top of the form is a space to number and name your masterpiece, and record the date of its creation for posterity. The bulk of the form is arranged in two columns. Reading down the left column you will find the parts that pertain to the first brew day. The second column contains an area for general notes about the batch and boxes for information about the transfer to secondary and bottling. I keep my filled-in forms in a 3-ring binder and record my tasting notes on the backs. Let's go through the form in order, pretending to formulate and brew 5 gallons of oatmeal stout as we go.

First we come to the MALT section. We need to know the following things to fill this out:

  1. What specialty grains we will use. I want to use .5 lbs of dark crystal malt (90 L), 1 lb of roasted barley, and 1 lb of flaked oatmeal (this is regular breakfast oatmeal, don't waste your money on the stuff at the brew store).
  2. What OG we want. I want the OG to be 1.050.
  3. What color we want the beer to be. See the color chart for guidelines. This beer will be >100(L.
  4. What our mashing yield will be. What does this mean? Mashing yield refers to how much soluble material one is able to extract from the grains. This is usually measured in specific gravity points, typically, the number of thousandths of a unit of specific gravity in one gallon of water. For example, if you start with 5 gallons of plain water (SG=1.000) and end up with 5 gallons at SG=1.010, you added 10 points per gallon x 5 gallons = 50 points. I have included a table of the maximum number of points provided by a pound of various grains. These figures are rarely achieved. However, with care and good water treatment, 90% of these values is not hard to realize. To figure what your yield was you compute the maximum you might have obtained using the table (see below on filling in the form). You then figure how much you really obtained as in the example above. Divide the latter by the former and you have your yield. If this is unclear, read on.
Unless you know Jeane Dixon's phone number you will have to do some predicting to fill in your yield before you start. This form has you calculate your yield after the fact and if you don't change your procedure your yield should stay pretty constant. Therefore, after you have made a few all-grain beers you will have a pretty good guess. If you are on your first all-grain batch, guess 70%.

Here is a hint for making things go well: If you underestimate your efficiency you are in a bit of trouble; you either need to dilute the wort to get the right OG, diluting out the effects of your specialty grains, or you can just live with the too-high OG. If you over estimate your efficiency, you can add a little pale malt extract, or even a little table sugar (sucrose) to make up the difference. If you keep the sucrose addition below 10% of all sugars added (<10% of the total points are from refined sugar) you will suffer no problems except a slight decrease in body. So guess a little (3%?) on the high side for your yield. If you are right--hooray! If not, jack up the OG with malt or sugar.
OK, now we are ready to go! On the first line for the type of malt, write "British Pale." Now fill in the maximum extract per pound (from the table: 35) under the "Extr/lb" and the color (from the table or your supplier: 3) under where it says L(. On the next lines fill in Crystal 90 (24,90), Roasted Barley (24,500), and Flaked Oats (30,0). Now fill in the amounts for these specialty grains under "Pounds" and do the multiplication for the "Extract" and "Color" columns. Now fill in the desired OG (50) where it says "Exp. extr/gal: ____ (OG)." To the left fill in the final volume (5.5 gallons so we can siphon 5 gallons off the trub). Above this fill in the expected yield (90%) and to the right, the expected extract, which is the final volume x the desired OG (5.5 x 50 = 275). Now go up and fill in the theoretical extract you need to provide to get your desired extract by dividing the expected extract by the expected yield (275 / .9 = 305). (Note that there are little arrows that show you what numbers plug in where.) You will see that we have already provided 12 + 24 + 30 = 66 points of extract from the specialty malts. The pale malt must therefore provide 305 - 66 = 239 points. Since it provides 35/pound, we need 6.8 pounds. Now that you know the amount of pale malt you will use, fill out the rest of the table: "Total Grist", "Total Color" (add up the values above--565), and "Color/gal" (divide the latter by the final volume--103).

Although the color/gal doesn't directly impact how much of anything you use, if you find that you predict something way too dark or light for the style it is a good bet you have not formulated the recipe very well. Note that the lovibond measure is highly nonlinear and that this method only produces a rough estimate of the final color. I find that it is about 10% too high in the 10's and 20% too high in the 20's. See the final color table to compare your answer to some commercial beers. (If you see color listed as EBC you can convert to lovibond (which is the same as SRM): L=.37 EBC + .46)

But wait! I want to use up this can of Alexander's Light extract I got for Christmas. Looking at the table I see that it will provide 3.3 pounds x 36 points/pound = 119 points. Since this will always be at 100% yield, this should be subtracted from the "Exp. extract" blank, leaving 156. Now subtract 66 to get 90, divide by 35, and find that you need to add only 2.6 pounds of pale malt. The extract syrup gets recorded as a "Kettle adjunct" below in the BOIL box (since this is where it will actually be used) and its 119 points of extract gets recorded in "Extract extract" in the PITCH box. Using darker extracts is more complicated as you must reduce the specialty malts somewhat.

Grain Extract Table

SourceMaximum points/lbColor ((L)Enzymes
2-row1351.5-3Moderate to High
6-row331-2 High
Vienna333-7 Low
Munich335-20 Low
US Munich245-20No or Low
Aromatic3025Low to Moderate
US Cara-Pils/Dextrine301-10 No
Crystal22410-120 No
Special B24150-250 No
Toasted Malts324-304-75No
Chocolate24350-400 No
Black Patent24450-550 No
Roasted Barley24500-550 No
Malted Wheat381-2 No
Flaked Barley/Oats30<1 No
Flaked Wheat35<1No
Flaked Corn/Rice40<1No
Sucrose45<1 No
Glucose40<1 No
Honey~35<1 No
Malt Extract,Liq~36?Sometimes4
" " Dry~45?No

Notes to table:

  1. Includes US and UK, lager and ale malts, which are quite different from one another.

  2. Includes malts known as caramel; cara-pils, -vienne, and -munich (Belgian crystals (~15, 22, and 75šL respectively)); and light carastan, carastan, and Scottish crystal (UK crystals (~20, 40, and 90šL respectively)).

  3. Includes, in roughly increasing order of color, Victory, Biscuit, Amber, Brown, Special Roast. Different maltsters name these differently. Ignore the name and look at the color with lighter ones adding body, warmth, and complexity and darker ones adding complexity, color, and toastiness to burnt toastiness.

  4. Diastatic malt extract has amylase enzymes (not to be confused with DME=Dry malt extract).

Final Color Table:

šLColorDegreeExample
0-2.5YellowLightBudweiser=2.0
2.5-3.5YellowPale
3.5-5.5YellowDeep Straw-GoldMolson Export Ale=4.0
5.5-10AmberLightBass=10
10-14AmberMedium
14-20AmberDeepMichelob Classic Dark=17
>20BlackPaulaner Salvator=21
Now that we know what malt we will use for our oatmeal stout, it's time to mash it. In the WATER box I record what kind of water I used, what I did to it, what the resulting pH was, and how much I used (1/3 of a gallon per pound of grain, from the MALT box). The TEMPERATURE PROGRAM box violates the nice columns of my sheet to contain a graph of the temperature and specific gravity of the mash as a function of time. I record the time of dough-in (the mixing of the grains and the water) in the "Clock Start Time" spot or else I will forget how long it has been. I label the SG axis based on the type of mashing I will do, usually 10 higher than the temperature axis. (I use the SG of the mash as a measure of completion. At 1/3 gal/lb the SG ~ the percent yield.)

Now it is time for the BOIL. I boil for 90 minutes, adding hops 60 minutes before the end and at various times later on. I like to try to hit my desired final volume at the end of the boil, so I like to know how much I generally boil off. For this reason I record the starting volume. I record the clock time that the boil actually starts, which I use to calculate the remaining times. The preboil is the time of boil before the first hops addition (this is simply to allow me to figure the total boil time after the fact). I list any salts, sugar, flavorings, fruit, malt extract etc. I add during the boil in the "Kettle adjuncts" space.

Now for the fun part: the hops. Each line contains the information about 1 hop per addition. This is easiest to see by looking at the sample form. The w/p refers to the form of the hops: whole or pellets. The times are recorded next to the first hop of that addition. The Type, Ounces, and % Alpha columns are self-explanatory. See below for the last two columns.

To design the hopping schedule I start with the late hops. I choose the type, time, and amount of the late addition by the amount and type of hop character that I want. Any amount of hops from 1/4 of an ounce to 2 ounces added five minutes before the end of the boil will give me good hop aroma. Hops added at 15 before the end will still give that unmistakable hop flavor if at least 1/2 an ounce is used, and I sometimes will also add 1/2 to 1 ounce at 25 minutes for that subtle, mellow hop character that seems to get lost with lots of late hopping. As a very rough guideline for late additions (15 minute boil or less), 1/3 oz in a light beer or 1/2 oz in a stronger beer will just be noticeable. 1/2 oz and 3/4 oz respectively will be present but not strong, and twice these amounts will get you to quite hoppy. Additions at 25 minutes have about half the effect (a crude statement considering the great difference in character) of these later additions.

Once the late additions have been worked out, their contribution to bitterness is computed. Bitterness in beer is measured in international bitterness units, or IBU's. An IBU is a measured quantity of a beer. When homebrewers refer to the IBU's of their beer, they are usually only guessing. The fundamental uncertainty here is how much bitterness is extracted in the boil (this is called utilization). Many people have tried to quantify this for homebrewers, but the effort is really wasted. With different equipment and procedures, everyone's utilization will different. I have given a copy of the utilization curve I use. It seems to have good predictive power for my beers. If you don't have one already, try mine and modify it if it doesn't work for you. If you read the curve at the time of the hop addition you will get the utilization with some constants included. This number is what I call the "Time factor" on the sheet. If you fill this in, multiply by the weight in ounces and the % alpha acid (multiply by 5, not 0.05, for 5%), you will get an estimate of the IBU's contributed to 1 gallon.

If you know how many IBU's you are shooting for you can fill that in at the bottom. Various books, including Michael Jackson's, have IBU figures for various beers. I have included a short list spanning much of the range below. Note that bitterness will be more perceptible in weaker, less flavorful beers. Multiply your IBU's by your final boil volume to get a figure for how much bitterness you need to add. If you subtract the bitterness contributed by your late hops (which will probably be a small fraction of the total) you get how much needs to be added by the early addition.

Bitterness Examples Table:

IBU'sExample
10Human Threshold
12Budweiser
17Heineken
23Beck's
30Sierra Nevada Pale Ale
35Ballard Bitter
40Sierra Nevada Stout
45 Grant's Scottish Ale
50Bottled Guiness
54Anchor Liberty Ale