The Beer Recipator

The BreweryHomeSpreadsheetRecipesDiscussion


The finished volume is: 5.0 gallons  Low  High 
The original gravity is: 1.058
The alcohol is: 6.0% v/v (4.7% w/w) 4.5%8% v/v
The color is: 19 HCU (~11 SRM)
812 SRM
The bitterness is: 26 IBU
2530 IBU

Select which area of the recipe spreadsheet you wish to work on:

All sections Description Batch Size Mash Boil Bitterness


Enter a brief description of the beer for this recipe.

Beer Name:
All grain Partial mash Extract w/grain Extract
Enter the expected final gravity. (Style range: -)

Batch Size

Enter estimated volumes (in gallons). Important: Fill in these fields first so that the calculations in the tables below can be carried out properly.

Sparge runoff: Leave this blank if doing an extract only recipe.
Boil volume: Enter the volume of wort you will be boiling.
Final volume: Enter the total batch size.


Enter your typical mash efficiency for recipes of this type.

Mash efficiency (%):

Enter the grains to be used in the mash or use the "Add Grain" page to select the grains.

Grain Lb. Oz. % Extract
Points Color
42% 24.3 2.7
39% 22.7 6.0
4.7% 2.3 7.0
4.7% 2.6 2.3
7.5% 4.2 0.5
1.4% 0.7 0.1
- - -
10.7 lb. 56.8 18.7

Given the mash efficiency, the estimated runoff SG is: 1.276


Enter any malt extracts or sugar added to the boil.

Ingredient Lb. Oz. % Extract
Points Color
100% 0.7 0.0
- - -
- - -
0.7 0.0

The starting boil volume is: 7.1 gallons
The specific gravity for the boil is: 1.040


Enter hop varieties and alpha acid ratings or use the "Add Hops" page to select your hops. Place a "p" under the "PB" column for pellet hops and/or "b" when using a hop bag. Specify the quantity of hops (in ounces) under the column indicating the time (in minutes) boiled. Modify the minute fields if you use a different hopping schedule.

Hop Variety Alpha
PB Hop Additions IBU Contributions
Aroma 60453015
- - - 12.3
13.4 - - -
- - - -
- - - -
Utilization (%):
25% 23% 19% 12%

The estimated bitterness is: 26 IBU

Enter hops by: Weight IBU
Utilization method: Tinseth Rager Custom
Custom factor:

This web page copyright 1997-2019 by
All rights reserved.

Please direct any comments to