| A | B | |
|---|---|---|
1 | Brew In A Bag Calculator | |
2 | ||
3 | Directions | |
4 | Green cells are to fill in as necessary. Blue cells are calculated values. | |
5 | The directions section is calculated as well and puts all the numbers into sentence form. | |
6 | Plug in your numbers under "Beer Info" and go. | |
7 | You can adjust grain absorption rate and boil off rate, in the constants section, if you know your numbers or just leave the default values in place. | |
8 | ||
9 | Beer Info | |
10 | 5.75 | Final Batch Size (gallons) Add extra quart for kettle loss |
11 | 12.25 | Grain (lbs) |
12 | 1 | Boil Time (hours) |
13 | 152 | Desired Mash Temp (f) |
14 | 70 | Current Grain Temp (f) |
15 | ||
16 | Brew Day Directions | |
17 | 1 | Heat 7.62 gallons of water up to 158.6 degrees Fahrenheit |
18 | 2 | Add grain and stir |
19 | 3 | This should yield a total volume of 8.6 gallons at a temperature of 152 degrees Fahrenheit |
20 | ||
21 | Constants (tweak as desired) | |
22 | 1.25 | Boil off rate (gallons/hr) |
23 | 0.05 | Water absorption/lb grain (gallons) .08 |
24 | ||
25 | Calculate Required Volume | |
26 | 1.25 | Boil Loss (gallons) |
27 | 0.61 | Absorption Loss (gallons) |
28 | 7.61 | Volume Needed (gallons) |
29 | ||
30 | Mash Water Calculations | |
31 | 30.45 | Total Quarts Needed |
32 | 7.61 | Gallons |
33 | 2.49 | Ratio (qts/lb) |
34 | 158.6 | Calculated Strike Water Temp (f) |
35 | 8.59 | Total Mash Volume (gallons) |
36 | ||
37 | ||
38 | ||