To Irene and all who want scratch conversions - I have done a few that I have listed below. Converting ingredients is a little harder than liquids because 8oz of weight doesn't always (or ever) equal 1 cup. I found a good link at http://www.onlineconversion.com/weight_volume_cooking.htm. What is nice about this site as compared to others I looked at, is that it has lots of ingredients, and converts both US and UK measures - whichever you prefer.
Here is the way you use it to do conversions for the matrix: For example let's do all purpose flour. In the top box you select your ingredient - so choose flour, US, all purpose. In the next box you put the quantity you want and in the From This box, the weight you want - I buy 5 pounds so 5 goes in quantity and pounds in the From this box. Then in the To this box I select cups [US] and hit recalculate. In the bottom box you get 5lb=22.824 cups. Then divide 22.824 by the 5 and you get 4.56 which is the conversion factor for the matrix.
So here's a few I did
5 lbs AP flour to cups = 4.56
5 lbs granulated sugar to cups = 2.366
2 lbs brown sugar to cups = 2.27
2 lbs confectioners sugar [aka powdered, aka icing] to cups = 3.48
1 lb butter to cups = 2
1 lb butter to tablespoons = 32
Another note: if you are converting large quantity to small [like cup to tsp] then conversion factor should be GREATER than 0. If you are converting small to large [like cup to pound] then conversion factor should be LESS than 0.
Hope this helps - it seems complex but this will give you best answers for non liquid ingredients (sorry - I was a science major in college ) Make sure you put in the quantities you buy - you can ignore the density section - it's not necessary unless you have the densities for your ingredients (now that's a REAL science geek)!!!
This is amazing! I'm not that savvy in using Excel outside of just basic formulas and you did suchh an awesome job!!! THANK YOU SO MUCH for sharing! I'm downloading, saving, etc etc...WOW.
Links are not working for these downloads. Does n e one know why? Is there another place I can go to get the latest version of the matrix?
I'm not able to download this either, but I'd LOVE to!! Anyone have a way to get it??
I'm not able to download the matrix either. Could someone e-mail it to me Stacey(mod edited.) Thanks.
unable to download the latest matrix. what should i do? my email is (mod edited.) if anyone could email it to me. thanks so much
Just a quick question, do you use this pricing for all cakes or just wedding cakes? I make a lot of birthday and other special occasion cakes and I am having a hard time figuring out how much to charge.
Thanks
I can't seem to access the file either. Could I also get it sent to my email?
(mod edited.)
Thanks!
I'm not able to download either! Please e-mail with attachment, (mod edited.)
Thank you so much for your help!
I would like this excel file also Please send it (mod edited.) Thank you for your help
hi there, whenever I download it, it saysd READ ONLY.... and i cant change anything, would love to use it tho!
I am trying to download this so I can look at it and possible use it but I do not see it anywhere!?
Wow! This is fantastic! Possibly more than I will ever completely learn to use, however, I really like the Quote and invoive sheets! Thanks a million!
I can't access the file either. Can someone please email it to me? Send to (mod edited.)
Thanks!!!
I can't download the newest file either, could you please email it to (mod edited.) Thank you!
I'm not able to download either. Please send me a copy if al possible at (mod edited.)
I would like the latest version of the Matrix...Please email to (mod edited.) ...the previous version is awesome!!!
I would also like to get the latest version of the matrix. If someone could please email it to me at (mod edited.) that would be great. Thanks so much for taking the time to create this and your willingness to share it. THANKS!
I would also like to get the latest version of the matrix. If someone could please email it to me at (mod edited.) that would be great. Thanks so much for taking the time to create this and your willingness to share it. THANKS!
Can someone please send the most recent matrix to me? I can't open the file?
Thanks!
Amanda
(mod edited.)
I can't access it either. =( Loved the earlier version, would someone please email the latest updated one? Thanks so much! (mod edited.)
Quote by @%username% on %date%
%body%