by Martin Lersch / The month of january 23rd, 2014
Even though the U.S. Metric Association have recommended metrication for pretty much a century, many cookbooks still use US customary weights and volume measures. When carrying out a recipe with teaspoons, tablespoons, fluid ounces, cups, pints, quarts or perhaps gallons, I’ve frequently found myself using conversion websites for example Convert-me. picking ingredients from the list and entering the quantity and unit. This works Suitable for single ingredients, but is less practical when converting an entire recipe. I therefore designed a calculator to transform volumetric units to grams according to densities of a variety of common ingredients. It's greatly simplified the job for me personally, and possibly you’ll think it is helpful too?
Download calculator
volume-weight-conversion-v2.xlsm (Stand out 2007 file, 82 KB) UPDATED!
(Please be aware that the autocomplete function mandates that you let the macro. Should you experienced issues with the xlsm file being downloaded in zip format, please repeat the process now. A little server update continues to be carried out to repair the problem.)
Features
Includes densities of approximately 200 275 ingredients.
Easy entering of information with autocomplete function and drop-lower list.
Dynamic rounding of leads to yield more realistic recipes (&"120 g&" water will work better than &"118.29 g&" which will be a more exact, but less practical conversion of just oneOr2 cup).
Optional scaling from the recipe
Permitted units
US volume units: t, T, floz, c, pt, qt, woman
US weight units: oz, lb
Metric volume units: ml, dl, l
Metric weight units: g, kg
For eggs, egg-whites, egg yolks along with a stick of butter the system field remains blank. Average weights of huge and Medium-sized eggs, whites and yolks are incorporated.
Navigation
Use tab or left/right arrow to navigate in/from ingredients
Autocomplete feature in component field requires macros to become enabled
ConsumeOrlower arrows to navigate up/lower in drop lower listing of ingredients
References
Densities mainly obtained from rec.food.cooking’s FAQ and conversion file (observe that this is actually the same source as Convert use is built upon) and USDA National Nutrient Database .
Extra data from world wide web.aqua-calc.com (which apparently can also be in line with the USDA database)
Some densities added/remedied by Martin Lersch (particularly flour densities within the rec.food.cooking appear to become off).
You are able to follow any responses for this entry with the RSS 2. feed. Both comments and pings are presently closed, however, you can achieve me using the contact page around the dropdown menu under "About Khymos".
Comments
Should you’re searching for additional data, the USDA nutrient database has &"household weights&" data for several products: e.g. a pat of butter, a clove of garlic clove, a mug of garlic clove, a mug of chopped onion (160g), a mug of sliced onion (115g).
It appears as though this database was the origin for aqua-calc.com, however they don’t appear to become exposing all the weight data via their web UI.
The raw flat file data obtainable here:
They offer flat files, an access database, as well as an &"abbreviated&" single-table version (text or stand out) which includes a subset of nutrients and also the first three weight records for every item.
If you like, a duplicate from the full data which i have imported into an sqlite3 database are available here:
Excellent tool! Thanks.
Incidentally, I observed an equation error in column X.
The right formula, beginning at row 4:
Great. Someone should make an Application from it&...
Steve: Wow an excellent resource. I’ll observe how I'm able to incorporate a few of the data.
Brandon: A great observation, but no this really is intentional and also the formula is true! The reason behind this really is that oz (ounce) is really a unit of mass, so 1 oz = 28.3 g whatever the density. Note however that floz (fluid ounce) that is a unit of volume takes density into account.
isaia: You can do this! But typing ingredients/amounts on the table/phone is really cumbersome which i’d personally should you prefer a PC having a keyboard. I Then may also print the outcomes and produce that in to the kitchen. But maybe it’s only me being old fashined?
Awesome! Thank you for this excellent tool!
Martin this really is amazing, along with a resource I'll use within the hastily put together conversions I’ve labored out myself through the years. Like a chef who's regrettably made to express my very own metric recipes in volume measurements, I would like to see someone produce a ‘metric to volume’ calculator in order to save much more time!
Steve: Calculator updated about 70 extra records in the USDA database.
Some might have observed the .xlsm file turning out to be b .squat file when installing (see further description of problem here ).
I’ve done some server updates therefore the problem ought to be resolved now. Please retry the download now.
This can be a beautiful factor, forget about attempting to measure tablespoons butter. Easy recipe scaling too, many thanks for creating and discussing this.
Best to hear the calculator has been used!
My Linux &"Calc&" warns of potential viri or adware and spyware as POSSIBLY being present. I’m sure that this isn't the situation here. (I’m disregarding man-in-the-middle attacks). None the less, it might be nice if your checksum were available. Towards the end of the: https://en.wikipedia.org/wiki/Checksum exist several free applets for MS, MAC and Linux/Unix. Most free.
I call at your point. The MD5 checksum of volume-weight-conversion-v2.xlsm is &"82e526f2302096746ba6de7c9510ce5a&".
Hi, Martin,
Any hope of incorporating imperial measures?
I’m by using this for any cookery course for that Department of your practice of eire. We mostly use imperial.
I’ll try to edit it myself basically could possibly get some free time!
Regards and thanks
Nick
I'm attempting to connect to the file on OSX. Anybody experiencing any troubles attempting to run the file on Stand out for Mac?
It requires me to VB and trys to debug a few of the code.
Sorry I don’t have OSX and am unable to trobleshoot and fix this. Possibly other readers might help?
Sure which measures must i include? Wikipedia suggests these:
Imperial gallon = 4,546.09 mL
Quart = 1,136.5225 mL
Pints = 568.26125 mL
Fluid ounce = 28.4130625 mL
Are these sufficient?
Hi, Martin,
Appreciate your reply.
Yes, individuals measures could be good along with the imperial teaspoon (teaspoon) and also the imperial tablespoon (tablespoons of).
It’s an excellent resource I’ve (slightly) amended it and tried on the extender within the classroom to calculate cost prices for recipes. The ‘scale’ button is a very helpful idea.
Regards,
Nick Caffrey
I don’t have stand out for OSX, in order to’t debug that issue.
I discovered that Figures.application doesn’t such as the formula in column E (it doesn’t offer the &"Array&" stuff). Should you switch the column E formula using the one proven below and employ teaspoon/tablespoons of rather of t/T (the lookup is situation-insensitive), it'll work. (The obvious button and autocomplete fail to work, however.)
Show column E, place this in E7, and duplicateOrpull E7 into all of those other E cells:
The figures adaptation of v.2 are available at:
This works around the iPad form of Figures, too, but you need to type a precise match for that component without the assistance of autocomplete.
OpenOffice on OSX doesn’t such as the IFERROR() function, however it does handle the array formula in column E. (I didn’t test the autocomplete.)
Microsoft has become making Office Online readily available for free now at https://world wide web.office.com/start/default.aspx The spreadsheet and autocomplete focus on OSX/Chrome, however it the &"Obvious&" button isn’t supported.
Steve: Just update. The programing (using VB elements on the top of the drop box) may not be nice&... I’m glad you’ve found a workaround for that Figures application.
Fantastic, I'm able to’t thanks enough! I’m attempting to roll this to Google Docs so will be able to apply it to our Chromebook in the kitchen area.
[&...] around the Volume-to-weight calculator spreadsheet by Martin Lersch, who runs the great Khymos [&...]
Martin, interesting fantastic focus on this! I had been inspired after utilizing it and required the freedom of converting it to some free web application.
All feedback is welcomed, this is really a piece-in-progress. It’s also free: https://github.com/greenham/volume2weight
Planned features include permitting conversion of multiple ingredients, importing from various formats (csv, hRecipe), and user recipe creation/storage/publishing, perhaps a mobile application.
