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
Tracy - sounds so useful. can you send to me please? jennylohcp2709@yahoo.com
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
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
Tracy,
I would appreciate receiving a copy of your spreadsheet.
stafford8926@sbcglobal.net
Thank you so much
I'll take a copy: jkr_shr@yahoo.com Thanks
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
Sounds very useful, I'd love a copy.
Thanks to you both
Hello,
I'd love a copy of the spreadsheet. jcorlando@mail.com
Thank you,
John,
in Annapolis, MD
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
I would love a copy also, if it's available?
jojos.amazing.circus@gmail.com
Thanks!
Joanne
I would a copy of your excel file for bakers percentages.
Best Regards
Tom tom10126@yahoo.com
hi tracy
i would really appreciate a copy of the worksheet
thanks, claudia
cgmeyer2@cox.net
I is amusing seeing all of these requests for this spread sheet. Does it exist? Has anyone received one ?
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.
Thanks Dolf. THis is the best I have seen.
I would also love a copy. Thanks.
naschol @ comcast . net
Could I get a copy as well please?
ttcat96@hotmail.com
I would love a copy too please! michael.rosen@live.com
Thanks!
Good Morning, I would love a copy as well!
cubfan4ever@gmail.com
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!
Hi:
I would like a copy of the spreadsheet. Thanks in advance.
jayelde@hotmail.com
Tracy,
I'd appreciate a copy of the Dough Spreadsheet as well.
Thanks,
Kevin McAdam
ksmcadam@gmail.com
i would love to take a look at this!!
so much appreciated
Tracy,
Thanks so much for sharing and please thank your husband for us all!
Ryan
r_propst@hotmail.com
May I have a copy, too, please?
katlue@gmail.com
Thanks in advance.
kat.
Thanks Tracy for the generous offer! I would love a copy of the spreadsheet too, thanks.
David
www.breadmantalking.blogspot.com
breadmantalking@gmail.com
Hello,
Thank you for offering the spreadsheet. Would you please send a copy to jallred4956@yahoo.com. Thank You!
Jim
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.
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
I would love a copy too please! michael.rosen@live.com
Thanks!
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.
I have not received the spreadsheet. Has anyone received it??
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
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/
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
What engineering school could she be referring to ?
Oh please, oh please, though i have to do conversions for both metric and lbs.
If you aren't exhausted from sending out your spreadsheet, I would like a copy
jmntfse@yahoo.com
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.
this looks like an incredible conversion spreadsheet. Thanks so much
David
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.
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.
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???
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????
But recently, it's probably a stroke or two higher. That picture is about 15 years old.
Hi,
I would also love a copy.
Betsy
Your post is not clear. Are you addressing me?? If so, I need youremail address.
Hi,
Yes, it would help if I provided my email address.
Thanks,
NJBetsy@aol.com
I would appreciate a copy.
jdrusinko@comcast.net
OK, did all who requested a copy of my Excel spread sheet receive it ??
Pages