Submitted by HMerlitti on August 16, 2010 - 11:39am

Exel program to calculate actual weight requirements base on baker's percentages

Hi all,

I have been reading "The Bread Baker's Apprentice" amd "Advanced Breads and Pastry".   It came to me that I could make an Excel Spreadsheet where one could input  the bread baker's percentages from a formulalong with how many of what pound loaves were desired and have it calculate the grames, pounds/ounces, and US decimal.

This would eliminat the need for yield and test info.   You could make as many as you wish and test as many as you wish.

Does anyone know if such a Excel spreadsheet exists?? ??

I think someone posted one at

I think someone posted one at some point, but in reality it takes just a few minutes to make your own and adapt it to your specific requirements. Personally, I put every recipe I use in excel.

user icon

I, too, made my own, but

I have several variation of formula/recipes spreadsheets that I fine extremely useful. I have Excel, but prefer doing them in Sun Microsystem's free spreadsheet program.

 

user icon

I don't know if that

I don't know if that particular spreadsheet exists.  I have built several Excel spreadsheets for bread, but usually I'm inputting weight or volumes of ingredients and determining weights of ingredients and/or percentages.

I much prefer weights, so if I want to make a recipe where volumes are given, I'll convert to weights using my densities and see if the percent hydration makes sense and adjust liquids accordingly.  I also have starter components inputed to allow conversion between stiff and liquid starters.

user icon

I have three spreadsheets

I have three spreadsheets online that you can use if you like them.  They are located here.

user icon

I have some, too

I use all sorts of spreadsheets for my bread formulas.  I keep it simple, though - I just change the numbers in red (how much white baguette bread I want to make) here, and the ingredient weights all get sorted out for me.  It makes experimenting with juggling the ratios easy, too.

Hello foodslut

Thanks for the spreadsheet.   Now, I am not an Excel expert but it appears to me that your spreadsheet does not do any calculating, correct ?

None of the cells contain a typical Excel formula?????

 

 

Your Excel Spreadsheet

Hello LeadDog,

I see you Excel spreadsheeet but it is not in Excel format.   Does it do calculations ??

Excel

It's time I chime in, I have a different version which is not a Spreadsheet, but a web application located at

http://www.whatsthesequency.com/cakey.php

I am still testing everything, but it is easy to use

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.