The Fresh Loaf

A Community of Amateur Bakers and Artisan Bread Enthusiasts.

Baker's spreadsheet

Need help with baker's math in spreadsheet!

Forums:

I am building a spreadsheet to help me develop formulas for breads. I'm gaining a much better understanding of baker's math in this process. However, I am getting some discrepancies in my calculations that I just can't seem to understand. I'm looking for help.

As an exercise, I'm working with a dough with the following parameters:

January 19, 2010 - 6:36pm

Doc Tracy

excel spreadsheet

Please let me know if you don't get your spreadsheet as requested. I sent out all requests and one was returned undeliverable. I'm not sure who's it was as I deleted messages while I was sending. Sounds like those who have tried it so far say it's working properly.

I would post the attachment here but I have no idea how to do that.

Tracy

January 19, 2010 - 2:06pm

Doc Tracy

Baker's percentage Spreadsheet

My wonderful engineering husband was watching me do calculations by hand yesterday. He does everything on the computer. Anyway, he was kind enough to write a small program on an excel spreadsheet that does my calculations for me. I can share it with anyone that would like, if you'd like to send me a message for a request. It's so simple! You can input the total amount of either dough or flour that you want and the percent of the different ingredients, the calculator will fill in the number of grams for each ingredient for you.

Say you have the baker's percentage for something out of Hamelman's Bread, which gives you the percentage and for some crazy reason has the metric for "36" loaves, US measurements and volumes for the home baker and still gives me the amount for "3" loaves which is too much. I want to bake only one loaf. So, I fill in the amount of dough, say for sake of this exercise 1,000 grams. Fill in the percentages of each ingredient and I know exactly how much I need, in grams to use. It is so slick!

No more conversion charts for me!