The Brewery Home Spreadsheet Recipes Discussion

Summary

The finished volume is: 25 liters  Low  High 
The original gravity is: 1.040
1.0481.056
The alcohol is: 3.5% v/v (2.7% w/w) 5%6% v/v
The color is: 19 HCU (~11 SRM)
35 SRM
The bitterness is: 26 IBU
2329 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.010-1.014)

Batch Size

Enter estimated volumes (in liters). 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 Lb. Oz. % Extract
(p/p/g)
Points Color
(°L)
HCU
86% 31.4 1.9
3.1% 1.1 0.4
3.1% 1.0 4.5
6.2% 2.1 1.7
1.5% 0.4 9.5
- - -
8.12 lb. 35.9 18.0

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

Boil

Enter any malt extracts or sugar added to the boil.

Ingredient Lb. Oz. % Extract
(p/p/g)
Points Color
(°L)
HCU
100% 4.1 0.7
- - -
- - -
4.1 0.7

The starting boil volume is: 17 liters
The specific gravity for the boil is: 1.059

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 grams) 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 4525205
18.6 4.7 - -
- - 2.0 1.1
- - - -
- - - -
Utilization (%):
26% 13% 10.0% 5.5% 18.64.72.01.1

The estimated bitterness is: 26 IBU

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

The Beer Recipator - Copyright 1997-1998 Mark Riley - All Rights Reserved