HopRodGR
Well-Known Member
Hi All,
I'm looking for the equation that calculates the temperature you should heat your batch sparge water to, based on the temperature of the soaked grain remaining after the first runnings are drained.
I'm currently attempting to put together an Excel spreadsheet that will give me a table of temperatures, since predicting what temperature the grain will be after draining the mash is difficult to predict. Having a range of values allows me to easily reference the right sparge water temperature to heat to.
My initial thought is calculating the weight of the grain, which would be the dry weight plus the weight of the water absorbed, against the weight of the sparge water, factoring in temperatures, would get me there. However, this doesn't take into account the density differences in a pile of wet grain vs. just water.
Here is my simple calc:
(Weight of wet grain/(Weight of grain + sparge water))*Grain Temp + (Weight of Sparge Water/(Weight of grain + sparge water))*Sparge Water Temp = Temperature of Batch Sparge.
Since the weight of water is 8.35lb/gal and the generally accepted absorption of grain is 0.13gal/lb, it should be easy enough to plug these values in.
Have I over-simplified and missed an important variable or this or does this look right?
I'm looking for the equation that calculates the temperature you should heat your batch sparge water to, based on the temperature of the soaked grain remaining after the first runnings are drained.
I'm currently attempting to put together an Excel spreadsheet that will give me a table of temperatures, since predicting what temperature the grain will be after draining the mash is difficult to predict. Having a range of values allows me to easily reference the right sparge water temperature to heat to.
My initial thought is calculating the weight of the grain, which would be the dry weight plus the weight of the water absorbed, against the weight of the sparge water, factoring in temperatures, would get me there. However, this doesn't take into account the density differences in a pile of wet grain vs. just water.
Here is my simple calc:
(Weight of wet grain/(Weight of grain + sparge water))*Grain Temp + (Weight of Sparge Water/(Weight of grain + sparge water))*Sparge Water Temp = Temperature of Batch Sparge.
Since the weight of water is 8.35lb/gal and the generally accepted absorption of grain is 0.13gal/lb, it should be easy enough to plug these values in.
Have I over-simplified and missed an important variable or this or does this look right?