Bread Making Workbook Comprehensive

Why you need a spreadsheet that actually does the math for you

I stopped baking by guesswork around 2019 after burning three loaves in a row because I rounded hydrations like an idiot. The real problem isn't reading a recipe. It's when you want to scale from 500g of flour to 2kg and your brain decides to shut down halfway through the multiplication. That's where a proper bread making workbook changes your life. Not dramatically. Just enough that you stop second-guessing your percentages every time you change a batch size. It's a spreadsheet — usually Google Sheets or Excel — that lists every ingredient as a baker's percentage of the flour weight, then lets you input any flour amount and auto-calculates everything else. Water, salt, starter, whatever goes in gets a cell. The formula never lies to you because the formula is just math doing its job. You can bake from it at 2am and still get the right hydration. The "comprehensive" part usually means it handles multiple dough types in one sheet, tracks fermentation notes, and sometimes even predicts bulk fermentation time based on your kitchen temperature. Mine lives in a folder labeled "BREAD WORKBOOKS" next to a collection of half-finished sourdough recipes I imported from Instagram. I wish I'd known about this system five years ago.

How the math actually works in practice

Open any blank sheet. In row one, label your columns: Ingredient, Grams, Baker's Percentage. Row two becomes your flour — that's your anchor. If you put 750g of flour in, you set that cell to 100%. Every other ingredient divides by 750 and multiplies by 100. Water at 75%? That's 562.5g. Salt at 2%? 15g. The rest follows automatically. The trick most people miss is setting up a single input cell for total flour weight and having every other gram value reference that one cell. Change 750 to 1200, hit enter, and suddenly your entire recipe recalculates. I spent six months building a workbook where I had to manually recalculate every ingredient because I didn't know about relative references. Don't make my mistake. Learn what the dollar sign does in a formula before you waste two weekends. Here's the part nobody tells you about hydration calculations: your starter counts toward total water and total flour. If you're feeding a 100% hydration starter at 20% of your flour weight, that starter's water and flour both need to be subtracted from your added water and flour if you want the true final hydration. Most beginner spreadsheets ignore this and you end up with dough that's wetter than your numbers say. I learned this the hard way when my 78% hydration spelt loaf turned into soup because the spreadsheet didn't account for the levain's moisture. Now I have a separate section in my workbook that subtracts starter contributions before showing the final hydration number.

Setting up the sections you'll actually use

My current workbook has four tabs. The main one is the master recipe calculator. Tab two is a bulk fermentation tracker where I log ambient temperature and note when the dough passed the windowpane test. Tab three is a scaling log so I can look back and see that my 14-hour cold ferment at 4°C in December produces significantly better crumb than an 8-hour one. Tab four is a cost-per-loaf calculator that surprised me — bread I thought was cheap because it's just flour and water actually costs $2.87 per 800g loaf when you factor in the starter maintenance and electricity. That number changed how I price my bakery orders. For the fermentation tracker, just log temperature and time. The insight comes later when you notice patterns. My house sits at roughly 21°C in summer and 18°C in winter. At 21°C, bulk takes about 4 hours. At 18°C, it stretches to 6. The spreadsheet itself doesn't predict this for you — you have to feed it the data and then read it back. But once you've logged ten or twelve batches, your brain starts connecting the dots without trying.

Bread Making Workbook Comprehensive Template Walkthrough

If you're building from scratch, start with this structure. Column A: ingredient name. Column B: grams. Column C: baker's percentage relative to flour. Column D: running notes. Row 1 headers, row 2 your first recipe. Lock the flour percentage at 100% in column C row 2 using a conditional format so it never accidentally gets overwritten. Add a section below for starter calculations if you use preferments — autolyse, biga, poolish, levain. Each one needs its own row because they each contribute different amounts of flour and water to the final dough. I also recommend adding a column for mixing method. Straight dough versus extended autolyse versus no-knead changes your timing by 90 minutes minimum. When I switched my whole wheat recipes to a 45-minute autolyse before adding salt and starter, the dough became less sticky and the crust improved noticeably. The workbook made that adjustment obvious because the timing notes sat right next to the ingredient list instead of being buried in a blog post I'd printed out and lost.

The edge case that broke my spreadsheet and how I fixed it

Last winter I tried a high-hydration olive oil focaccia at 85% total hydration with 30% whole wheat flour and a long cold retard. My workbook showed the numbers as correct. The dough was unworkable. Turns out whole wheat flour absorbs about 8-12% more water than white flour by weight, and my hydration calculator treated them identically. The spreadsheet didn't flag it because it only knew one number for flour weight, not the protein composition or bran content. The fix was simple but took me three failed batches to figure out. I added a "hydration adjustment" column where I manually subtract 3-5% from the target hydration for every 25% of whole grain flour in the blend. So 50% whole wheat gets a 6% reduction applied to the displayed hydration number. Now the dough feels right on the first try instead of requiring a water correction mid-mix. The workbook still calculates everything correctly; I just feed it an adjusted target instead of the raw percentage.

Limitations you should know before you commit to this system

A spreadsheet won't tell you if your starter is hungry. It won't warn you that your kitchen is drafty or that your scale drifted by 3 grams last week. It also fails completely with recipes that don't use baker's percentages — like some en sourdough formulas that list ingredients by volume or by a fixed ratio that doesn't reference flour weight. I have one tab for those rare cases where I just write the absolute weights down and skip the percentage math entirely. The biggest bottleneck is data entry. Your workbook is only as good as the recipes you put into it. If you import a recipe from a blog that lists "a pinch of salt" instead of a gram weight, you're stuck. I've seen people spend more time formatting other people's recipes than they'd spend just weighing everything out. The workaround is to build your own recipes first, properly measured, and only import external ones after you've converted them to grams and percentages yourself. It takes about 4 minutes per recipe and saves you from debugging someone else's ambiguous measurements later. Another honest flaw: spreadsheets don't handle live feedback loops. If your dough is drier than expected after mixing, the sheet won't tell you to add water. You have to watch the dough, not the screen. I've lost count of the batches where I trusted the numbers and ignored what my hands were telling me. The workbook is a planning tool, not a baking autopilot. Use it for preparation and record-keeping. Trust your senses during the actual mix and fold.

What to track that most people skip

Most hobby bakers track flour, water, salt, and starter weight. They stop there. The difference between a decent loaf and a great one often comes down to data most people never record. Track your dough temperature after mixing. Track your ambient humidity if you live somewhere that swings between dry winter and humid summer. Track how long each stretch and fold took. Track the exact minute you put the loaf in the oven and the minute you pull it out. Track crust color on a 1-5 scale. After recording fifteen batches, these data points start revealing things your eyes miss. I noticed my summer batches consistently over-proofed by about 45 minutes compared to winter batches at the same visual stage. The spreadsheet made the pattern visible because I could sort by dough temperature and see the correlation immediately. Without the log, I would have kept blaming my starter strength and wasted another month adjusting feed ratios that weren't the problem. One more thing that matters more than you'd think: weigh your flour every time, not just your water. Sifting changes density. Scooping from the bag packs it differently than spooning. A cup of bread flour can vary by 15 grams depending on how you handle the bag. Your workbook assumes consistent gram weights. If your inputs are inconsistent, your percentages drift and your results become unpredictable. Buy a scale that goes to 0.1g resolution and calibrate it with a known weight once a month. I use a 100g stainless steel calibration weight and check it every Sunday morning before I start baking.

Where to find or build your own

There are several free templates online under the name Bread Making Workbook Comprehensive, mostly shared on Reddit threads and bakery forums. The ones I've tried range from functional to dangerously overcomplicated. Some include unnecessary charts about yeast activity rates that look scientific but don't affect your daily baking. The simplest version is usually the best — flour weight input, ingredient rows with percentage formulas, a notes column, and a fermentation log. That's it. Everything else is decoration. If you're technical, build it yourself in Google Sheets. It takes about 20 minutes. If you're not, download a basic template, strip out the fancy graphs, and keep the calculation engine. Your final workbook should fit on one screen without scrolling. If you need three tabs just to find the water amount, you've overbuilt it. The goal is to open the sheet, see your recipe, and bake. Nothing more. I keep mine backed up in two places — Google Drive for cloud access and a local Excel copy on my laptop because I've learned to trust nothing that lives only on the internet. Power goes out during storm season where I live and Google Sheets goes with it. Local file survived every blackout I've had. Your workbook is your recipe archive. Treat it like something worth preserving twice.

Bottom line

A bread making workbook comprehensive is not magic. It's accounting for flour. It removes the mental load of manual calculations so you can focus on observing the dough instead of doing arithmetic in your head. It becomes genuinely powerful when you start logging fermentation data and looking back at it months later. The system has real limits — it can't replace feel, it can't fix bad ingredients, and it won't compensate for sloppy measurement. But for anyone who bakes more than once a month, the time saved and the consistency gained make it worth the initial setup effort. Just don't build something so complicated that you spend more time maintaining the spreadsheet than baking the bread.