Hello! I have recently started all grain brewing and I am trying to practice calculating efficiency of established recipes to see how close I am getting and hopes of creating my own recipes soon. Using info from HOW TO BREW, i did my first set of calculations, but I am getting results that seem far too good to be true. I will attach the excel sheet, but my calculations show a 96% efficiency with 34 PPG. That would be GREAT if I actually had that, but from what i read that does not seem feasible... I am using an anvil foundry 10 gallon system. Any feedback would be appreciated!
Type Amount (lbs) "Max Yield %
(from ref "PPG
(MY x 46)" Gallons Gravity Points
Pale 2 Row 10 81% 37.26 5.5 67.75
Oats 2 70% 32.20 5.5 11.71
Chocolate Malt 1 60% 27.60 5.5 5.02
Carmel/Crystal Malt 0.75 74% 34.04 5.5 4.64
Black Barley 0.75 55% 25.30 5.5 3.45
Chocolate Rye 0.5 65% 29.90 5.5 2.72
Black Patent 0.25 55% 25.30 5.5 1.15
D160 Syrup 1 100% 46.00 5.5 8.36
Dextrose 1 100% 46.00 5.5 8.36
Total 17.25
Total GP 113.16
SpGr Max 1.1132
Measured OG 1.074 Efficiency 96.48%
PPG 0.34