The Fresh Loaf

News & Information for Amateur Bakers and Artisan Bread Enthusiasts

Baker's percentage Spreadsheet

Doc Tracy's picture
Doc Tracy

Baker's percentage Spreadsheet

My wonderful engineering husband was watching me do calculations by hand yesterday. He does everything on the computer.  Anyway, he was kind enough to write a small program on an excel spreadsheet that does my calculations for me. I can share it with anyone that would like, if you'd like to send me a message for a request. It's so simple! You can input the total amount of either dough or flour that you want and the percent of the different ingredients, the calculator will fill in the number of grams for each ingredient for you.

Say you have the baker's percentage for something out of Hamelman's Bread, which gives you the percentage and for some crazy reason has the metric for "36" loaves, US measurements and  volumes for the home baker and still gives me the amount for "3" loaves which is too much. I want to bake only one loaf. So,  I fill in the amount of dough, say for sake of this exercise 1,000 grams. Fill in the percentages of each ingredient and I know exactly how much I need, in grams to use. It is so slick!

No more conversion charts for me!

Comments

jennyloh's picture
jennyloh

Tracy - sounds so useful.  can you send to me please?   jennylohcp2709@yahoo.com

 

frenchcreek baker's picture
frenchcreek baker

Hello there Tracy,

 

Thanks for your generosity! As an artist I find my brain starts to ache just thinking of doing the conversions. This will be soooo helpful for Hamelman's book. 

 

My email is rasabasart@gmail.com

 

Oh and be sure to tell your husband I send a big thanks to him as well.

Happy baking,

Anne

HMerlitti's picture
HMerlitti

I also did an Excel version of the formulas in  Advanced Bread Baking and Pasrty by Michel Suas after I returned from their Artisan II class.   I also am an engineer.

Send his to me and I will get back to you on how they compare. 

email:   Hmerlitti@aol.com

selmaswede's picture
selmaswede

Tracy,

I would appreciate receiving a copy of your spreadsheet.

stafford8926@sbcglobal.net

Thank you so much

 

judyinnm's picture
judyinnm

I'll take a copy:  jkr_shr@yahoo.com  Thanks

bobdrob's picture
bobdrob

pls add me to the ever-growing list for a copy! on behalf of the mathematically challenged,  thanx & regards,    bob

rdrobneck@medford.k12.ma.us

shizont's picture
shizont

Sounds very useful, I'd love a copy.

 

Thanks to you both

jcorlando's picture
jcorlando

Hello,

I'd love a copy of the spreadsheet. jcorlando@mail.com

Thank you,

John,
in Annapolis, MD

njbetsy's picture
njbetsy

Dear Tracy,

I'd like to join the bandwagon, and request a copy of the spreadsheet.  It sounds like it would be a useful tool.

Thanks in advance.

NJBetsy@aol.com

 

Jo_Jo_'s picture
Jo_Jo_

I would love a copy also, if it's available?

jojos.amazing.circus@gmail.com

Thanks!

Joanne

topcat's picture
topcat

I would a copy of your excel file for bakers percentages.

Best Regards

Tom    tom10126@yahoo.com

cgmeyer2's picture
cgmeyer2

hi tracy

i would really appreciate a copy of the worksheet

thanks, claudia

cgmeyer2@cox.net

HMerlitti's picture
HMerlitti

I is amusing seeing all of these requests for this spread sheet.  Does it exist?  Has anyone received one ? 

Tommy gram's picture
Tommy gram

Dolf  S. made a bread calc spreadsheet so powerful the lights go dim in my house when I use it.

He posted it on Fresh loaf, here is the link:

http://www.starreveld.com/Baking/


He answered a lot of questions on Fresh loaf so I if you have problems you might find an answer by putting Dolf in the Fresh loaf search box.

Alas, it will not work on Mac and you must enable macros to unleash its mind boggling power.

 

HMerlitti's picture
HMerlitti

Thanks Dolf.   THis is the best I have seen.  

naschol's picture
naschol

I would also love a copy.  Thanks.

naschol @ comcast . net

FoodHacker's picture
FoodHacker

Could I get a copy as well please?

 

ttcat96@hotmail.com

mrosen814's picture
mrosen814

I would love a copy too please! michael.rosen@live.com

 

Thanks!

cubfan4ever's picture
cubfan4ever

Good Morning, I would love a copy as well!

cubfan4ever@gmail.com

 

catlick's picture
catlick

This spreadsheet would save me!  I would love to have one...Thank you and your husband!

catlick@sbcglobal.net

ps cute pup in your pic!

jayelde's picture
jayelde

Hi:

I would like a copy of the spreadsheet. Thanks in advance.

jayelde@hotmail.com

bigcrusty's picture
bigcrusty

Tracy,

I'd appreciate a copy of the Dough Spreadsheet as well.

 

Thanks,

 

Kevin McAdam

ksmcadam@gmail.com

snihan's picture
snihan

i would love to take a look at this!!

so much appreciated

 

ryaninoz's picture
ryaninoz

Tracy,

 

Thanks so much for sharing and please thank your husband for us all!

 

Ryan

r_propst@hotmail.com

 

kat.'s picture
kat.

May I have a copy, too, please?

 

katlue@gmail.com

 

Thanks in advance.

 

kat.

breadmantalking's picture
breadmantalking

Thanks Tracy for the generous offer! I would love a copy of the spreadsheet too, thanks.

David

 www.breadmantalking.blogspot.com

 

breadmantalking@gmail.com

Feelin Crumby's picture
Feelin Crumby

Hello,

Thank you for offering the spreadsheet. Would you please send a copy to jallred4956@yahoo.com. Thank You!

Jim

wmtimm627's picture
wmtimm627

As an alternative to having everyone posting their email addresses on a public forum like this, there is an application available called Dropbox which makes it possible to post a link to a file quite easily. It's available for all operating systems, and they provide a very good tutorial when you start.

Junketlady's picture
Junketlady

I work at my niece's bakery,  Rossers' Bakery in Red Bluff, CA,  I would love to have a copy of your spreadsheet.  Thank you very much, and have a wonderful day.  Jacki     jacki56@msn.com

mrosen814's picture
mrosen814

I would love a copy too please! michael.rosen@live.com

 

Thanks!

larryparis10's picture
larryparis10

Just curious, I asked for a copy--maybe last year--and continue to see this thread with requests for a copy. Has anyone received one? Again, this isn't meant to be offensive, just curious.

mrosen814's picture
mrosen814

I have not received the spreadsheet. Has anyone received it??

Franko's picture
Franko

I'm in the process of making a basic spreadsheet for typical baking formulae. It needs a bit more work, but when I have it ready I'd be happy to distribute it to anyone who'd like to use it. If anyone out there has a suggestion as to how I can make it down-loadable without me having to respond to every individual e-mail address that wants it, I'd certainly appreciate it.

Franko

wmtimm627's picture
wmtimm627

There's an application available for all operating systems called Dropbox that allows you to place files in a folder called "Public" and you can place a link in your message here on TFL that will let users access it instantly. There are sufficient instructions on the site to get you started. The best part is that basic use is absolutely free.

https://www.dropbox.com/

 

Franko's picture
Franko

Thanks for the the link, this is exactly what I was looking for. If all goes well I should have the file available for anyone who wants it by the weekend. Maybe then this neglected original post can finally be put to rest.

Franko

HMerlitti's picture
HMerlitti

What engineering school could she be referring to ?

heidet's picture
heidet

Oh please, oh please, though i have to do conversions for both metric and lbs.

joem6112's picture
joem6112

If you aren't exhausted from sending out your spreadsheet, I would like a copy

jmntfse@yahoo.com

HMerlitti's picture
HMerlitti

It has to be obvious by now that this lady is in never never land.   I hate to break it to you but she is not going to send you a spreadsheet. 

I am an engineer and my friends are engineers and some of them married ditzy women.

 

I downloaded this one from Dolph.  It looks great.

 

http://www.starreveld.com/Baking/T&C.html


Dolf S. made a bread calc spreadsheet so powerful the lights go dim in my house when I use it.

He posted it on Fresh loaf, here is the link:

http://www.starreveld.com/Baking/

He answered a lot of questions on Fresh loaf so I if you have problems you might find an answer by putting Dolf in the Fresh loaf search box.

Alas, it will not work on Mac and you must enable macros to unleash its mind boggling power.

 

breadmantalking's picture
breadmantalking

this looks like an incredible conversion spreadsheet. Thanks so much

David

wmtimm627's picture
wmtimm627

But I play one in my head. Seriously though, I would hope that Dolph would have tried developing his spreadsheet using an Open Source program like Libre or Open Office. Yes, I'm a Linux dork, if your wondering, but I've only been doing it for a couple years now.

wmtimm627's picture
wmtimm627

After looking at the spreadsheet, I'm convinced it's pretty much useless to the casual user here on TFL. Why would anyone try to confound bakers with something like this? I'm pretty technically savvy and, although I can understand and use it, it's a complete waste to most others.

HMerlitti's picture
HMerlitti

You all are correct.   I responded to quickly to your request without any explaination.   Let me through out a couple pointers that would help.  

This formula is specifically for a mix that uses 70% levain per cell C34.   I have other formulas for other types of bread.   I get those other formulas by changing this formula.  I change  column C, the percentage column, to fit the bread I wish to bake.   I can send you the most complicated formula, the multigrain formula, and you can downsize it to fit what you want.

There are 2 key cells.  A2 and B4.  The whole spreadsheet is based on a 500g loaf per cell B4.

A2 is the number of loaves.   I usually change it to 6 since that is all my mixer can handle, about 3Kg.  Change the 22 to a 6 and you will see the formula adjust and cell E36 will read 3000g.

You can set it to how many loaves you wish to bake.  You just need to pay atention to cell E36 since that is the weight your mixer will needs to handle.

Cell B4 show 500*A2/1000.    This specifies a 500g loaf.   Change it to 350*A2/1000 and the formula will adjust to a 350g loaf.  Again, cell E36 is the weight your mixer will need to handle. 

For example, today I set A2 to 8 and B4 to 350*A2.1000 and baked 8 350g loaves.   My mixer held 2800 grams, manageable for my mixer.

You need to know Excel. This is not meant for everyone but neither is Dolph's formula mentioned in a previous post.

So, what did I leave out???

HMerlitti's picture
HMerlitti

For further reference, my mixer is a 5 qt Kitchenaid.   If I feed it more that 3000g it pulls a groin muscle and will actually start rejecting flour and water by throwing them all over the counter top.

And wmtimm627, the easily confoundable should not try this at home.

What is your handicap??   No, no, let me guess.   I would put it at 14. 

dmiller3, I miscommunicated.   I wanted to know if you received the spreadsheet.  I was not inquiring if you understood it.

Ask any questions????

 

wmtimm627's picture
wmtimm627

But recently, it's probably a stroke or two higher. That picture is about 15 years old.

njbetsy's picture
njbetsy

Hi,

I would also love a copy.

Betsy

HMerlitti's picture
HMerlitti

Your post is not clear.  Are you addressing me??  If so, I need youremail address.

njbetsy's picture
njbetsy

Hi,

Yes, it would help if I provided my email address. 

Thanks,

NJBetsy@aol.com

 

jrus's picture
jrus

I would appreciate a copy.

 

jdrusinko@comcast.net

HMerlitti's picture
HMerlitti

OK, did all who requested a copy of my Excel spread sheet receive it ??

Pages