Working With Baker's Percentages
Most people who get into baking at home end up frustrated by recipes that don't scale. You make a batch of bread, decide you want twice as much dough, and suddenly you're guessing weights or just dividing everything by two and hoping it works. That approach works for some things. It breaks down fast when you start dealing with hydration levels, fermentation timing, or when you need to adjust a recipe for a different flour type. Worksheet For Baking Simple is a tool that lays out every ingredient as a percentage of the flour weight. The flour is always 100%. Everything else is calculated relative to that number. So if your recipe calls for 500 grams of flour and 350 grams of water, the water is 70% hydration. That is the whole system. It takes about five minutes to set up once you understand the layout, and then any recipe becomes infinitely adjustable without pulling out a calculator every time you change the batch size. I ran into a real problem last year with a high-hydration focaccia recipe. The original called for 75% water, but my flour had a different absorption rate than what the recipe assumed. I had already mixed the dough and realized it was way too wet. Because I had everything laid out in percentage form, I was able to quickly recalculate how much additional flour to add — about 40 grams — and adjust the salt and starter percentages proportionally. The dough came out fine. Without the percentage breakdown in front of me, I would have just kept adding flour blindly until it felt right, which usually means overcorrecting.
How to Set Up a Worksheet For Baking Simple
Open a spreadsheet application. You can use Google Sheets, Excel, or anything with basic formula support. Create columns for ingredient name, weight in grams, percentage, and notes. Leave the first row as headers. Row two will be your flour, since flour is always 100% by definition. Type your flour weight in the grams column. Then for every other ingredient, type its weight in grams and set up a formula that divides that weight by the flour weight and multiplies by 100. In Google Sheets that looks like =B3/$B$2*100 where B2 is your flour weight. Lock that cell reference with dollar signs so when you change the flour amount later, all the percentages update automatically. Standard baking ingredients and their typical percentage ranges: bread flour 100%, water 60-80%, salt 1.8-2.2%, yeast or sourdough starter varies widely depending on your method. Olive oil in enriched doughs runs 5-10%. Sugar in brioche or sweet doughs can go from 10% to 30%. Getting these baselines in your worksheet lets you compare new recipes against known good formulations instantly.
The actual math is not complicated, but the discipline of recording everything matters more than most bakers admit. I used to skip writing down the exact weights and just estimate percentages in my head. My breads became inconsistent because small variations in hydration and salt were compounding over weeks without me noticing. Once I started maintaining the worksheet religiously, batch-to-batch consistency improved dramatically within a month.
Get the Full Details
Common Mistakes and What to Do Instead
The biggest error people make is forgetting that the percentages only work when flour is the base. If you try to set the water as 100% or the total dough weight as 100%, the whole system becomes harder to use rather than easier. Stick to flour as the anchor. Always. Another issue is not accounting for the water content in ingredients like butter, milk, eggs, or sourdough starter. If your recipe uses 20% butter and you treat it as a dry ingredient, your hydration calculation will be off by roughly 16 percentage points because butter is about 16% water. The fix is to separate out the water contribution. Butter contributes roughly 16% of its weight in water. Eggs are about 74% water. Milk is about 87% water. Factor those into your total hydration number and your dough behavior becomes much more predictable. Here is something most beginner bakers miss: the percentage system does not tell you anything about mixing time, temperature, or fermentation schedule. Those variables are independent of the formula. A 70% hydration dough and an 80% hydration dough might use the same amount of salt and yeast percentage-wise, but they will behave completely differently in terms of handling and rise time. The worksheet gives you the recipe structure, not the technique. You still need to learn how to read the dough.
The system also has real limitations. It does not work well for no-knead methods where the hydration and fermentation are the primary variables being controlled, because the ingredient proportions are often so loose that precise percentages feel forced. It is awkward for recipes that use variable hydration based on ambient humidity, which is common in sourdough baking during seasonal transitions. And it becomes nearly useless for recipes that do not use flour as the primary ingredient, like meringues or certain pastry doughs. In those cases, a simple weight-based recipe list works just as well and is less work to maintain. Don't force the percentage system into situations where it adds complexity without adding clarity. If you want a starting point, a basic Worksheet For Baking Simple structure with pre-formatted columns and example formulas is available online through most baking resource sites. Search for baker's percentage template or baker's worksheet spreadsheet to find ones that are ready to download. Look for something that has the percentage formulas pre-built so you are just filling in gram weights rather than setting up calculations from scratch. A properly set up template saves you maybe ten minutes of setup time and prevents formula errors that can throw off every percentage in your sheet.
The long-term value is in the data you accumulate. After a year of maintaining your worksheet, you will have a reference library of successful formulas that you can modify with confidence. You will know that a particular flour at 68% hydration works for your sandwich loaves, and that the same flour needs 74% for an open-crumb artisan loaf. That kind of knowledge only comes from recording the numbers consistently.
