The Fresh Loaf

A Community of Amateur Bakers and Artisan Bread Enthusiasts.

excel formula/calculator for desired dough temp with weighted averages

krause's picture
krause

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!!

gavinc's picture
gavinc

Very easy to set it up yourself. This is C but just change the values to F if you need.

 

Desired Dough Temperature 25
Multiplier (3 no preferment, 4 preferment)4
Total Temperature Factor 100
Flour Temperature  21.1
Room Temperature  20.4
Levain Temperature  22.6
Mixer Friction Factor  2
  Water Temperature33.9
krause's picture
krause

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!

 

 

gavinc's picture
gavinc

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. 

anton's picture
anton

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