Here’s the link to the spreadsheet. You can’t edit it, but you can copy it to your own Google Sheets.
Being a software engineer by trade, I have a penchant for using technology to aid in automating manual tasks and baking is no exception. One thing I did early on was to create spreadsheets for calculating ingredient amounts based on my desired yield and a baker’s formula. I actually created a bunch over time, but there’s one dough calculator I created in particular that I seem to use the most. It’s displayed a the top. If you’re interested, click on the link above and copy it!
The calculator is split into 5 major sections:
- Loaf Calculation
- Flour Blend
- Final Dough
One of the reasons I started building my dough calculators was that I wanted to bake bread to a certain, specific yield like 4 loaves at 335g apiece, then calculate the ingredients I’d need based on the target yield and the baker’s formula. This is in contrast to recipes you’d normally find in books and online where the ingredients are listed out and you have no idea about the yield other than, “Divide the dough into two equal pieces.”
That has always rubbed the more exacting side of my personality the wrong way. And especially when I started baking at higher volumes, I needed to know how much I was going to bake first. Then I’d figure out ingredient amounts based on that. Thus, I started creating dough calculators.
I use this calculator when I’m experimenting with different flour blends or different kinds of preferments. It takes all the guesswork out of figuring out what I need. Note that it is specifically meant for basic loaves that have no inclusions. This accounts for about 95% of what I bake such as sourdough boules and batards and baguettes.
Let’s step through the various sections:
The first two sections of the spreadsheet deal with the yield I’m after and the base baker’s formula. Just these two elements can drive all the ingredient amount calculations as the total flour can be obtained by simply dividing the target dough weight by the Total %. The Process Loss % field is a fudge factor for the total yield. There will always be some dough weight loss in processing, so adding a 1% or 2% fudge factor ensures that you can create all the loaves based on the dough weight.
Note that Yeast is included as an entry. If you’re making naturally leavened bread, this should be set to “0.”
The next section deals specifically with the preferment. You will provide the percentage of the total flour you’d like your starter to be, then set the hydration of your starter. A typical liquid starter is 100% hydration. A biga, on the other hand, will be around 75% to 80% hydration. Once you enter those things, the flour and water you’ll need to produce the starter, along with mature starter OR yeast will be calculated. Note that these calculations will produce more starter than you actually need for the recipe, but this is something that should be done anyway to account for process loss or starter sticking to the container.
The starter amount is meant to create a 1:5 ratio starter, the starter weight being 20% of the combined weight of the flour and water. But note that this is merely a guideline. If you’d rather do a 1:3:3 or whatever, that’s entirely up to you. You’ll just have to provide the amount of starter required in the ingredients list.
If you’re creating a poolish, the yeast you’d use is listed. I personally base the amount of instant yeast I’ll use for a poolish to 0.3%. You can change this in the cell formula if you use a different amount.
The last two sections of the calculator deal with the flour blend and the ingredients which really go hand-in-hand. This provides an easy way to figure out how much of a particular flour you want contributing the flour blend as a function of percentage. The grey line labeled “Preferment” is the percentage of the total flour that is already spoken for by the preferment. All the numbers should add up to 100%. The cell will be colored red if there is any variance.
Finally, we have the Final Dough ingredient list and the amounts required. The flour blend amounts are provided. The Total Yield is provided as an accounting measure to ensure everything adds up to what we expect. Though not shown, Total Flour and Total Water are displayed below the ingredient list and yet another check.
I invite you to copy the calculator. It has proven an invaluable tool for me!