The Beer Recipator


The BreweryHomeSpreadsheetRecipesDiscussion

Summary

The finished volume is: 5.0 gallons  Low  High 
The original gravity is: 1.047
1.0301.050
The alcohol is: 5.0% v/v (3.9% w/w) 3.5%4.5% v/v
The color is: 15 HCU (~10 SRM)
28 SRM
The bitterness is: 23 IBU
517 IBU

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

All sections Description Batch Size Mash Boil Bitterness

Description

Enter a brief description of the beer for this recipe.

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

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.

Mash

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 kg g % Extract
(p/p/g)
Points Color
(°L)
HCU
31% 12.6 1.1
62% 25.1 1.8
7.7% 2.7 11.6
- - -
- - -
3.25kg 40.4 14.4

Error: Specify the sparge runoff (under "Batch Size") to calculate its SG!

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

Boil

Enter any malt extracts or sugar added to the boil.

Ingredient kg g % Extract
(p/p/g)
Points Color
(°L)
HCU
100% 6.5 1.1
- - -
- - -
- - -
6.5 1.1

The starting boil volume is: 6.0 gallons
The specific gravity for the boil is: 1.039

Bitterness

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 60403010
12.6 - - -
- 4.2 - 3.4
- - - 2.8
- - - -
Utilization (%):
25% 22% 20% 9.2% 12.64.20.06.3

The estimated bitterness is: 23 IBU

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

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

Please direct any comments to markril@rcsis.com.