I'm putting together my own brewing calculations spreadsheet to develop a good understanding of the ins and outs of building a beer recipe. For my malt/mash calculations, I've chosen to use the degrees Plato scale because it makes sense to me.
Can someone smarter than I please check my assumptions/calculations? They are as follows:
Degrees Plato = Extract Weight (in kg) / Total Wort Weight (in kg) * 100
Where, Total Wort Weight = Total Extract Weight (in kg) + Water Weight (in kg)
Brewhouse Efficiency: 75%
Wort Volume = 32.4 l
Water Weight ~ 32.4 kg (approximation, good enough here)
Malt 1 - Bestmalz Pilsner
Extract Fine Grind 80.5%
Weight Used: 5 kg
Extract Weight = 5 kg * 80.5% * 75% = 3.02 kg
Malt 2 - Bestmalz Caramel Hell
Extract Fine Grind 75%
Weight Used: 1.5 kg
Extract Weight = 1.5 kg * 75% * 75% = 0.84 kg
Extract Weight Total = 3.02 kg + 0.84 kg = 3.86 kg
Water Weight = 32.4 kg
Total Wort Weight = 3.86 kg + 32.4 kg = 36.26 kg
Therefore, Degrees Plato = 3.86 kg / 36.26 kg * 100 = 10.65 deg P ~ 1.043 SG...
Does this sound right? Any help is much appreciated!