|
|
|
|
|
SearchUser loginBread BooksFavorite Recipes
|
Submitted by sf mountain on September 17, 2010 - 10:22am Spreadsheet translator--volumetric recipe to gram wgts recipeDoes anyone know of an Excel spreadsheet type translation program that will turn a standard (American-style) volumetric recipe into a gram weight recipe? Being unable to find one, I have been working on a simple version: a spreadsheet that translates the whole recipe at once. Most conversion systems i've seen on the internet work on a one-ingredient-at-a-time basis; i like being able to translate the whole recipe at one fell swoop..
|
RSS Feed
Bookmark/Search this postAdvertisement |
del.icio.us
Twitter
Facebook
StumbleUpon
Favorite
nope.
there's a couple recent threads that point out no one can agree even on how much a cup of flour weighs - in ounces or grams - much less how things should be abbreviated or formatted.
Can't knead bread with a computer
I struggled with this for a few months until someone simply encouraged me to buy a scale. They cost $20-$30 and really make the differenace. Flours are just too different in their moisture level and grind to make any formula work accurately. I'm glad I got one.
Computers have many uses, but making bread is not necessarily one of them.
Jerry
I too made the decision to
I too made the decision to use a scale for all but the smallest amounts of ingredients. The Soehnle I own can switch from ounces to grams (albeit, not that easily), but even living in the US, I find it much easier to use grams for making bread, especially since Van Over's book lists both.
Volume Scale
There is an Escali scale that will measure in volume, oz or grams. I use it to translate recipes. I don't believe it is too expensive...I think I got it from KIng Arthur. It really is a great bridge from volume to weight. pam
Scale
Escali is what I have too, but shop locally, support local business, and save the shipping.
Recipe Spreadsheet
http://dl.dropbox.com/u/1952064/Sourdough%202%20builds%20copy.xls
This spreadsheet has both gram and ounce conversions.
Knowing how to use the bakers formula lets you convert any recipe.
By entering 4 values in the red cells the spreadsheet converts all quantities.
Buy some digital scales. They are a must to get consistancy from one bake to another.
Online ingredient converter can be found at
http://www.onlineconversion.com/weight_volume_cooking.htm
sample from my spreadsheet
I cut and pasted the following from a spreadsheet I use for converting volume. If you are interested in making it more general purpose, the ingedient list could be expanded. The other thing I thought about would be building a template/form where the user could enter the volume of each ingredient in one cell and select the volume units from a list in the next cell. I just used the units (tsp vs Tbs, etc) that seemed likely to me. I also compute Bakers Percentage, but didn't show it here.
Would be happy to discuss further or try out anything you have if you are interested in persuing this further.
wayne