The Math Behind the Baker's Percentages
A baking worksheet is just a structured way to convert recipe ingredients into baker's percentages. Every ingredient is expressed as a ratio relative to flour weight, which sits at 100%. This format is standard across professional kitchens because it lets you scale recipes up or down without recalculating each ingredient manually. The basic structure is straightforward. You have columns for ingredient name, weight in grams, baker's percentage, and sometimes a notes column. Flour always goes in first since every other percentage is calculated from it. Here is how you fill it out in practice. Let's say you have a white bread formula and need to figure out the percentages. Your recipe calls for 1000 grams of bread flour, 650 grams of water, 18 grams of salt, 20 grams of instant yeast, and 40 grams of olive oil. The flour is your baseline, so you divide each ingredient by 1000 and multiply by 100. Water becomes 65%, salt is 1.8%, yeast is 2%, and olive oil comes to 4%. These numbers stay consistent no matter what batch size you are working with.
Once you have those percentages locked in, scaling is arithmetic. Multiply every percentage by whatever flour weight you need. If a batch requires 3000 grams of flour instead of 1000, you multiply 65 by 3, 1.8 by 3, 2 by 3, and 4 by 3. The worksheet handles this because the percentages do not change. Only the final weights do. I spent years building formulas by hand in spreadsheets before I standardized my approach. The first time I set one up, I mixed up the hydration calculation and ended up with 120% hydration bread because I accidentally used the total dough weight as the denominator instead of the flour weight alone. That batch was unworkable. Since then, I always double-check that the flour row equals exactly 100% before proceeding to scale anything. It takes two extra seconds and prevents a lot of wasted dough. There is one edge case that catches people off guard. When a recipe includes multiple flours — say, a blend of bread flour and whole wheat — the combined total of all flours should equal 100%, not any single flour. I had a customer who asked me to convert their sourdough formula where 700 grams was bread flour and 300 grams was rye. She wanted everything based on the bread flour alone. That approach inflated the rye percentage to 43% and made the math unreadable. The correct move is to add both flours together for 1000 grams total, then calculate every other ingredient against that combined weight. Rye becomes 30%, not 43%.
Hydration Calculation Nuances
Hydration is the most commonly misunderstood part of a baking worksheet. It is strictly water weight divided by total flour weight. Vegetables, dairy, eggs, and other wet ingredients do not count toward hydration unless you are specifically tracking equivalent water content. A beginner will often throw whole eggs into the hydration number and wonder why the dough feels wrong. Eggs are roughly 75% water by weight, but treating them as pure water throws off the formula. Stick to plain water and milk for hydration math, or calculate the actual water contribution if you need precision. Levain or starter is another area where the math gets messy. If your recipe calls for 20% levain, that levain itself contains flour and water. A properly fed starter is usually 100% hydration, meaning half the weight is flour and half is water. That flour and water should technically be subtracted from the main dough's flour and water totals to get accurate overall hydration. Most home bakers skip this adjustment because the difference is small. In a 5-kilo batch with 20% levain, not accounting for it changes your true hydration by roughly 4%. Professional bakers doing high-hydration doughs cannot afford that kind of drift, so they recalculate everything.
Get the Full Details
Building a Worksheet from Scratch
You do not need special software for this. A simple spreadsheet or even a printed grid works fine. Set up four columns: Ingredient, Weight in Grams, Baker's Percentage, and Notes. Fill in the known weights first, then calculate percentages. Leave the Notes column for things like temperature, souring time, or altitude adjustments. Over time those notes become your personal reference library. If you want to work digitally, Google Sheets or Excel will handle this without any plugins. Create a row for each ingredient. In the percentage column, use a formula that divides the weight by the flour weight cell. When you change the target flour weight at the top of the sheet, every ingredient recalculates automatically. I keep a template with named cells for flour weight and hydration target so I can adjust both with a single edit and get the full ingredient list back instantly. One thing most tutorials leave out is the cost column. Adding a unit price per gram and letting the spreadsheet multiply it by the scaled weight tells you exactly what each batch costs in ingredients. This is not glamorous, but it is the difference between guessing your food cost and actually knowing it. A bakery that bakes the same sourdough loaf every day without tracking ingredient cost per unit is leaving money on the table. The worksheet itself takes ten seconds to add a price column and five minutes to set up the formula.
Common Pitfalls
The biggest mistake I see is treating baker's percentages as if they are the same as recipe ratios. They are not. Ratios compare one ingredient to another directly. Baker's percentages always compare every ingredient to flour weight only. Mixing the two systems produces broken formulas. Another frequent error is forgetting that percentages are by weight, not volume. Cup measurements do not translate into baker's percentages without converting to grams first. This is not optional. Density varies between flours, and a cup of bread flour can weigh anywhere from 120 to 140 grams depending on how it is packed. Baking worksheets also have a real limitation when it comes to leavening agents in non-standard amounts. If a recipe uses a fixed quantity of yeast regardless of batch size — which some bakers do for small batches — the percentage model breaks down because the yeast does not scale proportionally. In those cases, you need a separate scaling rule or you accept that the formula loses precision at very small or very large batch sizes. There is no clean workaround other than testing at the target batch size and adjusting empirically. Another blind spot is environmental factors. A worksheet will tell you the hydration percentage, but it will not account for humidity, flour moisture content, or ambient temperature. The same formula can produce two completely different doughs on a dry winter morning versus a humid summer afternoon. I track weather adjustments in my Notes column so I can reference what worked when conditions were similar. The worksheet gives you the starting point. Experience fills in the rest.
