Need help with baker's math in spreadsheet!
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:
My spreadsheet calculates the amount of levain I need and how I should feed it. Another part of the spreadsheet calculates the amounts needed of each ingredient, including the levain. These two calculations of the levain amount are yielding different answers. I can't figure out why.
Can anyone explain why the Final Dough says I need 210.53 gms of levain, while the Levain calculations says I need 240 gms of levain?
Thanks in advance.
David
Hi David
It might assist someone help if you show the formula you are using in the spreadsheet cells.
My eye is drawn to hydration. Although you've indicated levain hydration at 50% in the desired parameters, in the lower calculation it appears to be 100% hydration.
I'm also unsure how the contribution of the water in the levain in the final dough contributes to the overall hydration in your calculations. If you seek a 78% hydration dough, and have a levain of a different hydration (is it 50%, is it 100%), do you need to be adding more/less water to make up for the fact the levain is not at 78%.....?
Regards, Robyn
You caught one error. The % water in the levain should be 50.
At the moment, I'm still stymied by your point regarding the final dough hydration.
David
Hi David,
I don't pretend to be a math expert, but I hope I can help.
My approach to calculating levains is to start with what I need. In your case, you need 210 grams of levain, which would be 48% of the final dough. Assuming you need to make some compensations for any levain sticking to the side of the bowl, let's say 215 grams to be safe.
According to your calculations, you want a 100% hydration, (100 grams each of flour and water) which, when added to the starter gives you 247 grams. 215/247 gives me a .87 conversion factor.
.87 x 100 = 87 grams of flour
.87 x 100 = 87 grams of water
.87 x 47 = 41 grams of starter
for a total of 215 units.
You are right, but based on my incorrect entry of the water. The levain is supposed to be 50% hydration, and I entered 100.
David
I have a formula designer spreadsheet that does exactly what you seem to be describing. It allows the design of 4 different loaves at a time (up to 4 different flours), combines the levain build, and creates a worksheet. Seriously handy
I'm not adverse to sending it to you and you can examine the formulas - if you want to message me an email address. No sense repeating the work. I don't have enough brain right now to thoroughly analyze your formulas...
I'm about to "go dark" prior to extended travel - but I will return your message when I can.
Let me know.
Pat
Hi David,
I'm not sure what formulas you've put in your spreadsheet, but here's my figures based on your input:
There are some things in your spreadsheet I don't understand. With a total dough yield of 180% and total dough weight 1000gr., the weight of prefermented flour should certainly be 133gr. Also, how come you mix the levain at 100% hydration when your input dictates 50%?
Hansjoakin,
Thank you I was starting to question my math. I calculuated the same as you and our numbers agree. I can bake with confidiance again.
Faith
Where our calculations differ is in the ingredient weights for the Levain. Since the baker's %'s are the same, the difference must be in how we calculated the conversion factor. We agree on on total flour weight in the formula, and .24 x total flour weight is indeed 133.3 gms.
I don't get how to calculate the baker's %'s for the final dough. You got results like Yippee's. I'm missing something.
My calculation was incorrect. Can you share the formula you used to calculate the Conversion factor for the Levain? I'm stuck at the moment.
David
I follow Suas' formulas regarding baker's % for the final dough: Assume that the flour weight (not counting any "flour contributions" coming from the levain) of the final dough is 100%, and then calculate the remaining percentages based on that. Although it really is the total formula percentages that are the important ones, I feel it can be useful to sometimes list those for the final dough as well (especially when you're considering autolyse etc.).
To calculate the total weight of the levain build, I first calculate the weight of prefermented flour (133.3 gr.). Then I calculate the dough yield of the levain: Flour 100% + Water 50% + Starter 47% = 197%. So the total weight of the levain build should then be:
Levain weight = Flour weight x Total dough yield for levain / 100% = 133.3 * 197/100 = 262.7 gr.
Finally use the total levain weight to calculate the weight of water and starter:
Water weight = Total levain weight * Hydration / Total dough yield for levain = 262.7 * 50/197 = 66.7 gr.,
and starter weight:
Starter weight = Total levain weight * Starter percentage / Total dough yield for levain = 262.7 * 47/197 = 62.7 gr.
In the final dough, I assume that you use all of the levain except for the starter weight (which you mix with flour and water to keep your culture going). Hope this helps :)
When I finally got my head on straight, I was able to understand how to calculate the needed percentages and quantities. It's interesting that I used a slightly different approach and ended up with the same result. My formulas for the Levain were:
Levain:
Baker's %
Weight
Formula
Flour
100
133.33
Total flour x fermented flour% (555.56x.24)
Water
50
66.67
Tot. flour x fermented flour% x levain hydration% (555.56 x .24 x .50)
Salt
0
0
Yeast
0
0
Starter
47
62.67
Tot. levain flour x starter % (133.33 x .47)
Total
262.67
Add up the ingredients. (133.33+66.67+62.67)
Thanks so much for your help!
David
Hi David,
I'm glad it worked out!
As a matter of fact, we use the exact same way of calculating the levain, just different sets of numbers. The key is to figure out the connection between baker's percentages and weight: How many grams are contained in 1%?
We know the total flour weight in the levain and we know the total levain weight. So to figure out how many grams there are in 1%, either do what you did (133.3gr / 100% = 1.333 gr/ 1%) or what I sketched out (262.7gr / 197% = 1.333gr / 1%).
So, to figure out the weight of e.g. water, which is listed at 50%, you do: 50% * 1.333gr = 66.7gr.
By the way, it doesn't seem to me like you're a spreadsheet newbie: You even got colours and borders and stuff going on! Sophisticated! :)
Just wondering if the spreadsheet that i sent you helped at all?
Hi,
I never received the spreadsheet.
David
David, Let me guess you're an engineer! LOL only joking.
I tried to figure where your math issues are but I did not find a specific location of your error. If you are an engineer you know (KISS) Keep It Simple Silly. I feel your conversion factor is messing up your calculations and I wonder if any of your formulas use either of the conversion factors as a factor. I would try again but this time only use simple math,+,-,*,/.
I bake just a little different so my spread sheets are looking for a different number in relation to things. I feed my starter twice a day and save all the discards in the fridge. I feed the first bit in the tub then just keep adding the discards to an and give it a nice stir. Within a few days I have a big amount of starter that has been working in the fridge for a number of days. My dough's use lots of pre-fermented starter in fact the pre-fermented flour is for the most part 50% of total flour. I find this also give me a nicer sourdough flavor. So my spreadsheets converts my total amount of starter into a bakers percentage and gives me a list of what and how much to add.
Nathan, I'm new to this bakers percentages but there is something about your calculations I don't understand. I don't know if it's my limited understanding so I will just ask.
If the Prefermented flour is 133g
In your Levan build you have flour @101g and flour in the starter @23.75g =124.75g is there a reason why this does not add up to 133g's or is my understanding of prefermented flour off?
Also the Starter is 47% of what that ='s 47.5g's
Thanks Faith
David:
I recalculated your formula based on my understanding that you are aiming for a final dough with 24% pre-fermented flour and 78% hydration. If my interpretation is incorrect, please let me know. My numbers are as follows for your reference:
Hope it helps.
Yippee
Where I see our calculations differing is in the water in the Final dough and in the Levain.
Your total Levain weight = 200 gms, as I read it. And I don't understand the numbers in your "Final Dough."
David
David:
The numbers in my Final Dough are just a different presentation of Hans' "Final Dough" percentages. He's expressing them in terms of 'Flour' while I was expressing them as the respective %s of ingredients in the final dough, as you will see below:
Using either approach (180% or 236.84%) will yield the same weight of ingredients. Hope this explains.
Yippee
After reading and re-reading all your helpful comments and re-re-re-reading Hamelman, Suas and DeMuzio's sections on Baker's Math, I saw all my errors.
What I needed to do was:
1. Calculate the total baker's % and the ingredient weights for the Total Dough.
2. Calculate the ingredient amounts for the Levain and for the Final Dough using the Total Dough ingredient amounts. (The total baker's % for the Levain and Final Dough are not used in any calculations. Using them was my biggest error.)
3. Adjust the baker's % for water in the Final Dough (although that number is not used in any further calculations).
4. Substract out the initial Levain amount that is fed (the 47% of the Levain flour weight number) from the Levain used in the Final Dough.
If I do it this way, my numbers all come out to be exactly the same as hansjoakim's!
This whole exercise was a mind bender for me.
Faith - I'm not only not an engineer but I don't regard myself as much of a mathematician. I've also no prior spreadsheet experience beyond adding up columns of numbers.
Pat - Thanks for your offer, but it was important to me to "walk that lonesome highway by myself." Having to derive the formulas to do the calculations taught me more about baker's math and bread formula construction than any number of uses of an "off the shelf" spreadsheet or any number of re-readings of the best books could ever do.
This reminds me somewhat of my classical mechanics final exam in college physics. I'd studied formulas for lever and pulley problems, etc. for weeks. When I got the exam, I had a classic brain freeze. I couldn't remember any of them. After a half minute of panic, I reminded myself that all those special formulas were derived from Newton's laws. I knew and understood those. So, I derived the necessary formulas from basic principles, solved the exam problems and got 100% on the test. (The only one in my class to do so.) I value understanding more than knowledge. The latter is only a means to the former.
Thanks again to everyone who offered help. It really did the job to get me un-stuck.
Now, I can go feed my starter and get back to baking!
David
David, Now that I know your not an engineer we can continue to talk....LOL I work with excell spread sheets all the time. In time you will find how much you can do with it. It's quite a powerfull tool. I made some sheets that use the pythagorean theorem for quick calculations. Sounds easy but try it some time.
It's good to know you got your spread sheet working.
Faith
the way I worked through it on my spreadsheet was to write out equations like:
Total wt of dough = total wt of flour + total weight of water
Total weight of water = weight of water in leavin build + weight of water in final mix
Wt of flour pre fermented = total wt of flour * % pre-fermented,
Total dough hydration = (Water in levain build + water in final mix) / (flour in levain build + flour in final mix)
etc
and then solved the simultaneous equations so that I could use total dough weight, overall hydration, mother starter hydration, levain build hydration, innoculation rate, and % flour prefermented as inputs.
Now there's an exercize best left to the reader.
I just didn't have enough brain to explain it all last Friday (and am not sure I have enough just today) and thought that seeing the actual formulas in a spreadsheet would be useful to you...
Glad it all worked out.
Pat
We all know you get it when it comes to practical baking!
Cheers, Robyn
What does this symbol mean in the context of a reply like "@David" ? Does it mean "Answers"?
Thanks
Yippee
The character @ is called at-sign or at-character. In online forums, it's often used to indicate a reply to a previous post or question in the thread.
For more on the mysterious life of @, click here :)
for your reply. There's always something new to learn here at the forum.
Yippee
I like the use of @ to represent an amphora of wine best. :-)
David
I can upload the one I use if I can figure that out
I was able to get my questions answered, although it seems there are always new questions.
I don't think there is a way to upload files (other than photos) to TFL. You can post a link to someplace else from which a file can be downloaded. At least, that's my understanding. I use DropBox for this.
David