Recipe maker (Excel) - Trying to combine different units ?
As a newbie in bread baking but having a decent knowledge in coding and computers (my main job) I've tried a while ago to create a way to solve a problem (for me) related to the many and different ways of a recipe's measuring units.
I've seen in recipes sometimes listed together, weight units along with volume units and some "weird" units invented "on the fly". Of course the experienced people, they smile now with me, but maybe some useful can be come out at the end.
I give to anyone (freely of course) the following spreadsheet for downloading :
I made it to look like a "real" recipe notebook, allowing me to enter quantities, choose measuring units from a list (both weight and volume intermixed) selecting the ingredients also from a list and finally, select the "convert to" unit for everything.
I've using two lists for keeping the spreadsheet's data, one for the ingredients and one for units. The ingredients list, contains a "density" number which is the weight in grams of each milliliter of volume. I'm not sure if the numbers are correct and the accuracy of the conversions is highly based on this number, so if you have any source to find these numbers, that's great !!
The list of weight & volume units I believe that is correct, I've copied from a online converter.
Any idea, advice, information is welcome.