## Two Excel Tools for Sourdough

Two new tools:

Sourdough Spreadsheet

Sourdough Rye Spreadsheet

Lately, I've been playing around with my sourdough quite a bit. In particular, I've started keeping a very small amount of starter in the fridge -- about 30 grams or so -- and then building the starter I need from just few grams of "mother" starter over several builds or stages.

Doing the math is a pain. Especially when you're not only mucking about with builds, but also playing around with how much pre-fermented flour you want to use: 20% vs 30% makes a difference in terms of flavor and length of rise.

And then, if you get **really** nuts, you can start playing around with the Detmold three-stage process for making hearty rye breads, a fairly complicated arrangement that drastically changes how much flour you add and the hydration of each stage.

I got tired of searching for scratch pads and pencils to do all the math required to figure out how much flour I needed and when. So I build these two spreadsheets.

The first is for plain sourdough. Floyd was kind enough to upload it for your downloading pleasure HERE.

If you're using volumetric measurements (cups), I'm afraid this won't be much use to you. There's already a ton of variation in the weight of one cup (In *The Laurel's Kitchen Bread Book*, for example, a cup is roughly 5.25 ounces! 3 cups = 1 pound!), and with sourdough starter, all bets are off due to all the pretty bubbles.

Any generic weight units will do, so long as they're all the same. Grams are easiest, because they're more precise. As such, I've set the default for most cells to round off to the nearest whole number. But if you'd like to change the defaults to enable decimals so you can use ounces, I'll be glad to show you how to do it.

A few points:

The second spreadsheet is for rye breads, and it's almost exactly the same, except that it allows you to determine the percentage of rye you want in your bread. Download it HERE.

I'm using this spreadsheet to build my first 70% Detmolder rye with whole wheat. Hee hee! I'll post the results next week. Saturday is baking day. Can't wait!

Hope you enjoy these tools and find them useful!

I didn't have time to look at these super closely, but the idea is great!

I too have my bread formulas in excel :)

One time figuring out the baker's percentage formula, and now I just cut/paste it as needed. It's handy just to plug in the final dough weight and have the proportions all ready for you.

Thanks!

- breadnerd

JMonkey,

I've built some similar Excel spreadsheets. The SD Starter Calculator works on a similar premise: It calculates the seed starter (your term: mother), and the flour and water quantities for a three-build approach given a target starter quantity, and a target starter hydration. The fundemental approach is to increase the seed starter's or intermediate build's mass 3x each build, and increase or decrease the seed starter's hydration by 1/3 each build. Thus Build-three yields the target starter mass (27x the seed starter mass), at the target starter hydration. Like you, I built them to avoid the PTA math each time I want to bake.

The second spread sheet (two versions: oz. to gms, gms to oz.) helps me formulate my own bread formulae, or convert straight dough recipes to SD, poolish, or sponge formula. It does a lot of the routine math to make it easier, but still gives the user control on what flours and how much of each to use, the final dough quantity and hydration, starter quantity and hydration, calculates salt needed with a 2%, and provides for flavor additions, e.g., fruit, nuts, cheese.

If you're interested they are available on my wife's web site ( I don't have one) at:

http://glitzandglitterboutique.com/davidg618/spreadsheets.html

David G.

I just downloaded your starter and bread sheets.. How would one know what the target weight is going to be?

Thanks by the way. Hopefully, I'll get or need to use them~ but thanks for doing the work

photojess,

How much bread do you want to make?

Let's take an example: Suppose you want to make 4 500g loaves (that's 1.1 lbs). total dough weight would be 2000g. But dough loses about 20% of its weight during baking, so if you want your finished loaves to weigh 500g, add 20% of 2000g (=400g). So your target dough weight would be 2400g.

David G

um....I didnt' know a ~lb loaf weighed 500 gms. So now I know! There are so many basic stuffs that I seem to keep finding out I don't know!

And this metric stuff is hard getting used to. I was always a volumetric person. "Seeing" what 10 or 50 or 100gms looks like is a learning process too.

are outstanding and I'm sure I'll use them often. Adding eggs as an ingredient to the bread formula would be a big plus.

Larry

Larry,

Under "

Fluids"there are three blank cells for things like eggs, orange juice, heavy cream, etc. just enter their name and weight, and the weight will be taken into account in the hydration and total dough weight calculation.David G

I use David G's spreadsheets. Works great!

The page with the spreadsheets seems to be gone. Has anyone these sheets they could re-upload somewhere?

Thanks,

Tom C

As mentioned below, both links seem to be working... if you're still having issues, post back, and I can upload them to my server for you.

- Keith

Download it from the top links and it should work. I was able to do it.

Sheesh. I got lost in the narrative. Hence, the head banging on the right.

Thanks,

Tom C

The link that doesn't work is from davidg618-it used to be posted on his wife's site but that was a few years ago, now.

"Page Not Found" link:http://glitzandglitterboutique.com/davidg618/spreadsheets.htmlThank you!