HLT Water Infusion Calculator

[gsutton]

I need some help with a formula that I know is possible, because POL sent me a spreadsheet when I built his first system. I usually fill my E-HLT to the full 15 gallons and heat my strike water to a given temperature. After dough in I need to add more water to the E-HLT for the sparge and to cover my HERMS coil for recirculation. I need to be able to figure out how much tap water at a given temperature I need to add to bring my strike water to my required mash temp.

So as an example, lets say I have 6 gallons of 167F water that I want to drop to 152F and lets say my tap water is 65F, how much 65F water do I need to add to the 6 gallons of 167F to get 152F?

If one of you knows of a formula for this I would greatly appreciate it.

 

[weirdboy]

Well assuming you are just mixing the liquids you can pretty much just scale & average the temperatures.

So just using basic algebra, something like:

6 * 167 + x * 65 = (6 + x) * 152
6 * 167 - 6 * 152 = x * 152 - x * 65
6 *(167 - 152) = x * (152 - 65)
6 * (167 - 152) / (152 - 65) = x

X would be around 1.03 gallons

 

[gsutton]

Wow, I should have paid more attention in school! Would there be a way for me to make an excel form to just plug in the given and expected temperatures?

 

[weirdboy]

I made a spreadsheet in google docs.

Try this link:

HLT Temp Correction Calculator

 

[gsutton]

weirdboy,


Sorry for the late response, I was away from the computer until now. Thank you very much! This is exactly what I was hoping for!