The Fresh Loaf

News & Information for Amateur Bakers and Artisan Bread Enthusiasts

Baker's percentage Spreadsheet

  • Pin It
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

Falsehat's picture
Falsehat

I would appreciate a copy of the spread sheet program.


Thanks,


Jim Roe


jim_roe@sympatico.ca

jennyloh's picture
jennyloh

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


 

Luciana_DTT's picture
Luciana_DTT

Tracy,I'd love to have it too :)
Thank's

lucyweb@hotmail.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

AlanTheBreadGuy's picture
AlanTheBreadGuy


I would appreciate a copy of the spread sheet program.


Thanks,


Alan


pannifers@gmail.com


 


SimplyDenise's picture
SimplyDenise

Hi Tracy,


What a wonderful man you have there. I would love to have one of those spreadsheets. Those nasty calculations have been a thorn in my side.


Thank you so much!  simplydenise1@gmail.com


Denise

ChadCroft's picture
ChadCroft

Thank you for offering.  Yes I would like to have a copy of your spreadsheet covering baker's percentages.  My email address is: chadfarm@consolidated.net

sfordstark's picture
sfordstark

Tracy,


Please send it to me also.


e-mail: ford@writeme.com


Thanks very much,


Susan

ChadCroft's picture
ChadCroft

1/2410


Hi Again Tracy.  I asked for the spreadsheet before but it didn't come through.  Perhaps my email address was the one rejected.  I'd appreciate it if you would try again.  Please send to:  <  chadfarm@consolidated.net  >   Thanks.  ChadCroft

peterbl's picture
peterbl

Hello Tracy,


I wonder, if you could send me the procentages spreadsheet to try. Thanks in advance.


Peter


 My mail: peterbl12@gmail.com


 

firstfloorfront's picture
firstfloorfront

Tracy


 


Can I have a copy please.


 


Thanks


Peter


peterbrown@manwat.co.uk

mtheele's picture
mtheele

Tracy,


Would appreciate a copy of spreadsheet.


Thanks,


Michael


mtheele@yahoo.com

ericdeeter's picture
ericdeeter

So I've not paid attention to who and how to request a copy of this.  I think I finally am asking the right person.  If you still have a copy I'd appreciate it.


 


Thanks,


Eric Deeter


ericdeeter@gmail.com

nancy58's picture
nancy58

Hi Doc,


Happy New Year! I would really appreciate a copy of the Baker's Spread Sheet that you and your husband made up. I'm weak on Baker's Math and is THE major thing I plan on tackling this year.


My email is NMICHEL@rochester.rr.com.


Thank you very much.


Happy Baking!!


Nancy


 


 


 

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

JamieK's picture
JamieK

Tracy, I would love a copy of the spreadsheet.  Very generous of you and your husband to share with us!


Jamie


jamiek32000@yahoo.com

Joe_K's picture
Joe_K

Tracy,


I would love a copy of the spreadsheet


joek6176@yahoo.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

mwagoner's picture
mwagoner

Please send copy of Baker's percentage Spreadsheet.


 


Thanks - michaelwagoner@msn.com

Kato's picture
Kato

Hi can i also have a copy of your spreadsheet. Thanks Kate iainkate@gmail.com

topcat's picture
topcat

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


Best Regards


Tom    tom10126@yahoo.com

ml20's picture
ml20

I also would love a copy of the spreadsheet.


Thanks.


ML


ml20.smith@gmail.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.  

Harold.Garcia's picture
Harold.Garcia

 I would love to have a copy of your spreadsheet.


Thank you  Pastry Chef and Amateur Baker.


send to hagadama@aol.com

campman's picture
campman

 I would love to have a copy of your spreadsheet.


send to camp1942@gmail.com



realcasual's picture
realcasual

I too would really appreciate a copy of your spreadsheat


send to wayne9817@gmail.com

campman's picture
campman

I received your email about the spreadsheet but there is no link to the spreadsheet itself. 


Thanks,


Campman

Liliana Klass's picture
Liliana Klass

I'd love to have a copy of your spreadsheet. Thanks for sharing this with us all. My email: lgklass@yahoo.com


 


Liliana

Sunshinemom's picture
Sunshinemom

I would love to have a copy too.  Could you please send it to sunshinemomsblog@gmail.com?


TFS!


 


Harini

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!

kathleen stocks's picture
kathleen stocks

Tracy, I would like a copy of the spread sheet your husband made for you. Please email a copy to me at


klstocks@gmx.com


Thank you and your husband for your generosity.

Arden's picture
Arden

Hello Tracy, I would like a copy of the spread sheet :-).


uitdekeukenvanarden@mac.com


Thank you!

sandy22's picture
sandy22

I would very much appreciate a copy of the spreadsheet. Thank you to you and your husband; you are both very kind.   sandy_black22@yahoo.co.uk

jayelde's picture
jayelde

Hi:


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


jayelde@hotmail.com

robqc's picture
robqc

I would like to have a copy of the spreadsheet.


Thanks!!!


robqc@dr.com

bigcrusty's picture
bigcrusty

Tracy,


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


 


Thanks,


 


Kevin McAdam


ksmcadam@gmail.com

campman's picture
campman

Tracy,


I don't want to sound stupid but I can't seem to find the link on your


web page.  


Thanks for your patience and spreadsheet,


Bob Camp

Pages