excel formula/calculator for desired dough temp with weighted averages
hello
Does anyone have an excel formula or calculator for getting the desired dough temp with weighted averaged. Preferably with a pre-ferment column, but i understand beggars can't be choosers!!
Thanks for sharing. This unfortunately is not a calculator with weighted averages (but the same thing I am currently using). A calculator with weighted averages would factor in that 20% of the heat is coming from starter, 65% water etc. The current calculator posted does not care about the amount of each ingredient only their temperatures. It does pretty well but a calculator with weighted averages would be even more accurate!
Yes, correct. Weighted averages are not taken into account. Hamelman states that it's not exactly scientific, but works reasonably well. I use this across many formulas and find it's within 1 degree C. I made the 5-grain levain the other day that has a fifth element to consider, the soaker. I pre-weigh the flour for the final dough and sit it on the counter at room temperature the night before. Likewise, the soaker is left on the counter and was at room temperature by morning. The calculator worked out exactly. I just ignored the soaker in the calculation. I would be interested in seeing the difference when you take into account the weights. Let us know when you find or create one.
Very easy to set it up yourself. This is C but just change the values to F if you need.
Thanks for sharing. This unfortunately is not a calculator with weighted averages (but the same thing I am currently using). A calculator with weighted averages would factor in that 20% of the heat is coming from starter, 65% water etc. The current calculator posted does not care about the amount of each ingredient only their temperatures. It does pretty well but a calculator with weighted averages would be even more accurate!
Yes, correct. Weighted averages are not taken into account. Hamelman states that it's not exactly scientific, but works reasonably well. I use this across many formulas and find it's within 1 degree C. I made the 5-grain levain the other day that has a fifth element to consider, the soaker. I pre-weigh the flour for the final dough and sit it on the counter at room temperature the night before. Likewise, the soaker is left on the counter and was at room temperature by morning. The calculator worked out exactly. I just ignored the soaker in the calculation. I would be interested in seeing the difference when you take into account the weights. Let us know when you find or create one.
Here's a link to an in depth inquiry and an interactive program for your inspection.
https://blog.madebywindmill.com/reinventing-the-bread-bakers-ddt-formula-pt-1-7dde87fd2d4