Sonya Posted 27 Jan 2006 , 6:16pm
post #1 of

Ok let me first start out by saying I have no clue about spreadsheets, lol . Anyways I downloaded the pricing matrix and I am trying to customize it to fit my needs. This looks like it will be a great program once I learn how to customize it the way I need. Here is my problem, and since I dont know anything about spreadsheets I hope I explain it without confusing anyone, icon_biggrin.gif .

Under the "Shopping List" tab where it says "Cake" and "White frosting" everything is working perfect (I got that figured out, lol). Under where it says "Regular frosting" I can plug a number in, take for example where it says "Cups of Shortening" I can say I need 5 cups, then I go to the "Groceries" tab and it calculates fine, but when I go to the "Calculate Price" tab nothing is calculated. icon_confused.gif The whole section under "Regular Frosting" will not calculate anything on the "Calculate Price" tab. How do I get it to calculate?

I originally want to instead of using the "White frosting" section use it as my "Filling" section where I can calculate the amount of filling for the cake.
So sorry this was soooo long but I am about to give up on the matrix icon_rolleyes.gif . Thanks for any help!

~Sonya

41 replies
JennT Posted 27 Jan 2006 , 6:46pm
post #2 of

Sonya - I can't offer any insight, as I am totally confused by the matrix as well! lol icon_razz.gif I get what it's supposed to do for you, but I ran into some of the same problems as what you stated. I sure hope someone more experienced with this matrix can offer some pointers. My husband is dying for me to get mine finished out so that HE can be clear on what it's costing me and what I'm charging, so HE can be sure I'm charging enough!! Gotta love a husband who looks out for ya, huh? lol icon_rolleyes.gif Thanks for posting your question & I hope someone answers with a resolution soon! icon_smile.gif

chefdot Posted 27 Jan 2006 , 6:52pm
post #3 of

what is this matrix that everyone speaks of?

JennT Posted 27 Jan 2006 , 7:01pm
post #4 of

chefdot - look at the very first topic in the Cake Business forum...there's a topic there titled "get your price matrix here" or something like that. The matrix is a spreadsheet type thing that helps you cost out your ingredients and everything so that you can better price your cakes. It's customizable in the way of letting you put in the prices of what you pay for your ingredients, etc. since that's a little different wherever you are.

JennT Posted 27 Jan 2006 , 7:01pm
post #5 of

chefdot - look at the very first topic in the Cake Business forum...there's a topic there titled "get your price matrix here" or something like that. The matrix is a spreadsheet type thing that helps you cost out your ingredients and everything so that you can better price your cakes. It's customizable in the way of letting you put in the prices of what you pay for your ingredients, etc. since that's a little different wherever you are.

BayouGatorFan Posted 27 Jan 2006 , 7:03pm
post #6 of

I think I have a different Matrix. My shopping list tab self-calculates based on what I enter on the Matrix tab. Sorry, I can't help you either! Where did you get the matrix you have? I can look at it and try to trace the formula for you.

BayouGatorFan Posted 27 Jan 2006 , 7:11pm
post #7 of

What did you plug in on the Matrix tab? I'll play with it and see if it does the same thing to me. I looked at the spreadsheet available on this site and it looks like the formulas are good. I'll let you know.

BTW: Is the "Regular Frosting" considered crumb coat frosting? Can someone explain why it's broken out?

AuntAndrea Posted 27 Jan 2006 , 7:23pm
post #8 of

Okay, I think I've figured out the problem. I'm not sure that I can explain it without getting too technical, though... but let's see... icon_twisted.gif

In the sections that are working, the "white frosting" section on the "Shopping List" tab is connected to the "white frosting" section on the "Groceries" tab, and the "cake" section on the "Shopping List" tab is connected to the "Pillsbury Cake Mix" section on the "Groceries" tab. This means the right data is going to the right place, and the rest of the connections follow along to make the calculated price work properly. However, the "regular frosting" section on the "Shopping List" tab is connected to the "chocolate frosting" section on the "Groceries" tab, which is probably incorrect. I'm not sure what the spreadsheet creator's original idea was for where the "regular frosting" data would go, but it IS going to the chocolate area. Moreover, the "chocolate frosting" area is missing the almond, meringue and cocoa data from that tab, too!

I don't know who created the spreadsheet, and don't know if they are able to fix it for us... but if I have time to figure out the fix for this problem, I will let you know. Right now, my eyes are crossed from figuring OUT the problem in the first place!!

Whew! I love Excel, but I've got a headache now!! icon_eek.gif

...Andrea

JennT Posted 27 Jan 2006 , 7:55pm
post #9 of

Thanks so much, Andrea for taking the time to figure that out! I know what you mean about getting crossed eyes when working with that thing...lol icon_lol.gif

Sonya Posted 27 Jan 2006 , 10:44pm

Here is what I have so far. On the "shopping list" and "groceries" tab anything down from the Marshmallow fluff, I havent customized, so that part is the same as the origingal matrix that I downloaded. Also the prices I have plugged in is just random numbers.

I have it working when I plug a number into the "shopping list" tab it does calculate on the "groceries" tab, however it does not calulcate on the "calculate price" tab.

So basically what I need is the whole "shopping list" tab to work just like the section under the white frosting(on the original martix) or work just like the section under "White Viva Frosting" on the matrix I have customized and I need it to calulcate on the "groceries" tab and the "calulcate price" tab.

Thanks for the help!
My head hurts, lol icon_rolleyes.gif
~Sonya

gma1956 Posted 28 Jan 2006 , 1:09am

What exactly are you trying to do with the matrix? Do you want to put in how many cake layers you are making and have it calculate how much of each ingredient you should purchase then have the calculate price combine all that?

gma1956 Posted 28 Jan 2006 , 1:10am

can you give me your ingredients and how many cups the yeild is for each recipe. If you can I can fix this problem for you.

gma1956 Posted 28 Jan 2006 , 1:11am

You deleted some formulas from the original matrix. they just need to be put back in place.

gma1956 Posted 28 Jan 2006 , 4:00am

Here is the corrected matrix. PM me with any questions. I will be happy to help with it in anyway I can.

MsTamara Posted 28 Jan 2006 , 1:20pm

I am so happy to know I wasn't the only one who didn't understand this. I was feeling so dumb.

Sonya Posted 29 Jan 2006 , 12:51am

Thank you sooooo much for your help GMA1956!! This is a lot better than the matrix I tried to customize, lol. thumbs_up.gif . Anyways I will look over it and if I need anything changed I will let you know.

Thank you!!!

~Sonya

gma1956 Posted 29 Jan 2006 , 7:16am

No problem at all. I love working with Excel files. It is part of my degree.

Sonya Posted 30 Jan 2006 , 2:25am

Ok GMA1956, I have still been trying to customize this matrix the way I need it and I have learned a lot about spreadsheets, cause when I first started trying to customize it I had noooooo clue what I was doing, lol icon_biggrin.gif . Anyways I am still working on it but I am having a problem under the "Pre-Made Fondant" area..... I cant seem to get it to calculate anything icon_confused.gif . What am I doing wrong?

Thank you again for your help!!!
~Sonya

Here is what I have so far...........

gma1956 Posted 30 Jan 2006 , 4:43am

It was nothing you were doing wrong, I just had not finished my statement in a formula. Try it now.


I had to reload it after I posted it just a little while ago. Now try.

gma1956 Posted 30 Jan 2006 , 4:45am

You also want to be careful when you erase or delete across rows and columns that contain a 0 in it. They usually have a formula in them and you erase the formula it it when you delete that field. These fields could be protected from erasure, but you would not be able to change them then.

cookielady1 Posted 8 Feb 2006 , 5:19pm

GMA1956 - Great Job! I actually was able to taylor that to my costs, and it works out perfect. Think you could design one for things like cookies, brownies, etc.? That would be a great one to have.

gma1956 Posted 9 Feb 2006 , 4:26am
Quote:
Originally Posted by cookielady1

GMA1956 - Great Job! I actually was able to taylor that to my costs, and it works out perfect. Think you could design one for things like cookies, brownies, etc.? That would be a great one to have.




Actually I can't take credit for the creation of this matrix. I was just helping Sonya with some problems. I have actually started planning one to include that kind of data. But I have had to put it off for the present. I am a Senior and this is my last semester, I have started my internship and have very little spare time. You see where I am right now, For at least 5 or 10 minutes anyway. I will contact you when I have one set up and you can check it out.

Sonya Posted 9 Feb 2006 , 12:51pm

GMA1956 thank you so much once again for your help! I think I have the matrix pretty much set the way I want it now, untill I find something else to change, LOL. When you finish with the one you are working on please let me know because I know it will be great!!

Cookielady1 I am glad you can make since out of the matrix I tried to customize, LOL anyways I could NOT have done it without GMA1956's help at all because when I first started messing around with the matrix I had noooo clue about spreadsheets, LOL but I learned some things very quickly by looking at the formulas GMA had put into the spreadsheet to get it to work!
Thanks for all the help!!!!!!!!

~Sonya

SHenyd Posted 15 Feb 2006 , 10:30pm

enter info into "matrix" sheet first, the others should fill in. don't try and enter on other sheets or you'll erase the formulas.

steph95 Posted 18 Feb 2006 , 3:49pm

gma1956- The matrix you worked on for Sonya made more sense to me. I was missing a page from the other one I downloaded. Could you tell me how to clear the columns so that I don't delete the formula accidentally?

gma1956 Posted 18 Feb 2006 , 4:27pm
Quote:
Originally Posted by steph95

gma1956- The matrix you worked on for Sonya made more sense to me. I was missing a page from the other one I downloaded. Could you tell me how to clear the columns so that I don't delete the formula accidentally?




I am leaving for work in just a minute. I will be back later today. What columns do you want to clear? If you want I can protect the formulas for you, but if I do that you won't be able to change the protected fields until they are unlocked. I will pm you when I can talk more......

steph95 Posted 18 Feb 2006 , 4:49pm

I am computer illiterate (sp) It was just a generic question. So I just close out everytime I use it without saving? I thought about saving it twice, once under the name "matrix template" and once under "matrix" that way if I inadvertantly screw something up, I have the main matrix. I'll always keep 2 on the computer, for safety's sake.

gma1956 Posted 18 Feb 2006 , 9:09pm
Quote:
Originally Posted by steph95

I am computer illiterate (sp) It was just a generic question. So I just close out everytime I use it without saving? I thought about saving it twice, once under the name "matrix template" and once under "matrix" that way if I inadvertantly screw something up, I have the main matrix. I'll always keep 2 on the computer, for safety's sake.




That will work!!

eriksmom Posted 4 May 2006 , 3:55am

Would someone please send me a link to this matrix? So many people asking for it, but i can't find a link. I googled it, and got lots of the matrix movie, but no links to a pricing matrix.
send to bensmom@cfl.rr.com

Thanks to anyone who can help!

Becky L.

gma1956 Posted 5 May 2006 , 4:32am

There is a downloadable file of the matrix in the 10th reply above your last reply.

I attached it there. If you still can't get it PM me and I will send it to you.

Quote by @%username% on %date%

%body%