Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Pricing matrix...get it here
New Posts  All Forums:Forum Nav:

Pricing matrix...get it here - Page 4  

post #46 of 260
1/29/06 at 6:09pm
The one for cake prices is just on that has the prices only per pan, you canadjust it to your prices very different to the price matrix.
What a priceless gift, undeserved life Have I been given.Through Christ crucified You have called me out of death.You have called me into life And I was under Your wrath.Now through the cross Im reconciled
What a priceless gift, undeserved life Have I been given.Through Christ crucified You have called me out of death.You have called me into life And I was under Your wrath.Now through the cross Im reconciled
post #47 of 260
1/29/06 at 9:08pm
Quote:
Originally Posted by JennT

I've had the matrix for a while, but just recently started to use it. The problem I'm having is that when I go to open it, it asks me which worksheet I want to import? Then lists: matrix, shopping list, groceries, rent-inventory, purchase-inventory, calculate price. Is it supposed to be this way - that I have to choose which one to open each time, instead of them all opening together at once? And I have to close the one I'm in before it will let me open another worksheet.

Second problem - With each time it opens one of the work sheets, it tells me that errors were found. It gives me the options to show each error and where it's located within that worksheet, to ignore it and continue opening it, or to cancel. If I choose ignore it tells me how may errors there are in that worksheet....In one it's 66 erros, another 254, etc etc.

If there are these errors there, then will my calculations be correct? If not, then I don't want to continue working on it. Is there another version of the matrix that I can download or can it be fixed??

HELP! icon_redface.gif



Can you attach the exact matrix you are using to this forum and let me look at it. You might need to give it a different name than the matrix already attached to this forum.
post #48 of 260
1/29/06 at 9:10pm
I'll give it a try, at least....it's the same matrix that is posted at the beginning of this forum, if that helps. I hope it attaches ok...here goes....


***Edited to add: I just noticed the _764 in the file name...it's not what's listed as the filename at the beginning of this forum, but that's the one I clicked on and saved...I didn't change the filename when it saved...but that's how it saved it... icon_rolleyes.gif
Come let your hair down!
www.thebakersbar.com
Come let your hair down!
www.thebakersbar.com
post #49 of 260
1/29/06 at 9:30pm
What software are you using this file in? It opens just fine for me. It is an excel file. If you use it in other software, that might be causing the problem.
post #50 of 260
1/29/06 at 9:31pm
Excel
Come let your hair down!
www.thebakersbar.com
Come let your hair down!
www.thebakersbar.com
post #51 of 260
1/29/06 at 9:44pm
Do you know what version?
post #52 of 260
2/14/06 at 11:26am
Wow I love it!
post #53 of 260
2/14/06 at 1:41pm
This is GREAT! I wish we could thank the author of this spreadsheet. She's my hero!!!
Liberty University '99

Mommy to Lauren (4 years), Jonathan (3 years) and Andrew (1 month)
Liberty University '99

Mommy to Lauren (4 years), Jonathan (3 years) and Andrew (1 month)
post #54 of 260
2/15/06 at 6:46am
Are there instructions on CC somewhere that someone could guide me to as to how to use the pricing matrix?
Nobody can make you feel inferior without your permission.
-Eleanor Roosevelt-
Nobody can make you feel inferior without your permission.
-Eleanor Roosevelt-
post #55 of 260
2/17/06 at 6:29pm
Quote:
Quote:

I am not computer savy. Please help. In the cake pricing matrix under the calculate price cost per slice has a function of#DIV/O. This is an error in the fomula. How can I correct this and when does the hourly wage get added in to the total cost?



It is telling you that you can't divide by Zero. So as soon as there is a number of servings in the cell B76 on the first sheet titled "Matrix" , you should be corrected. And the hourly wage is already included in the formula for the total-you just need to input the number of hours.
post #56 of 260
2/18/06 at 3:02pm
Just to let everyone know, the pricing matrix is from Dawn and her website is www.dawnscake.com. She is amazing and if you need any help I am sure she would be more than willing.
post #57 of 260
2/18/06 at 3:56pm
Quote:
Originally Posted by icelady

Just to let everyone know, the pricing matrix is from Dawn and her website is www.dawnscake.com. She is amazing and if you need any help I am sure she would be more than willing.



thanks everyone for the compliments! I can't take full credit for this matrix. I received a basic set-up from a woman on the Wilton boards and have tweeked it quite a bit and continue to do so. The new one I am using is a colaboration of the original, what I added and another decorator named Donna. I have a basic for scratch cakes also that I made up for icelady. You can add and change any information in it. Everyone does their sizes different. Mine are based on a 2" x 1" x 4" slice. I will attach the newest one. If you have any questions, please let me know! I will try to help any way I can!
Happy Baking!
Dawn
Dawn
My Cake Website:
www.dawnscake.com
Ramblin Roads
www.geocities.com/ramblinroadsdj
Dawn
My Cake Website:
www.dawnscake.com
Ramblin Roads
www.geocities.com/ramblinroadsdj
post #58 of 260
2/24/06 at 10:14am
Quote:
Originally Posted by jelacop

I am not computer savy. Please help. In the cake pricing matrix under the calculate price cost per slice has a function of#DIV/O. This is an error in the fomula. How can I correct this and when does the hourly wage get added in to the total cost?



I just downloaded the spreadsheet.
It also had the #DIV/0
I enter some data into the other tabs
like I would when making a cake and it worked fine
Try it and see it yours works.

oops i guess this was a little late icon_wink.gif
post #59 of 260
2/26/06 at 8:08pm
I am not real smart with the computer stuff, but I cant get it to change the icing amounts from the very first cake I tried it with. (12X18 size) now all the icing amount are for that size cake? Am I doing something wrong? any help would be greatly appreciated.
Knowledge is a candle that when shared, doubles the light, but the insecure person believes knowledge is a candle that is diminished when it is split between two wicks.
Knowledge is a candle that when shared, doubles the light, but the insecure person believes knowledge is a candle that is diminished when it is split between two wicks.
post #60 of 260
2/28/06 at 6:51am
jelacop,

That error means that you are trying to divide something by 0. Somewhere along the way the formula must have been corrupted. I would delete the file you have and re-download it if you are not familiar enought with excel to fix it.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Cake Decorating Business
This thread is locked  
Cake Central › Cake Forums › Cake Talk › Cake Decorating Business › Pricing matrix...get it here