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 2  

post #16 of 260
10/7/05 at 12:16pm
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?



That cell should read "=C10/matrixB!72". This formula is reading from 2 places 1. C10 is the total for that page... You need to make sure all of the formulas in cells C2-C9 are correct. 2. Matris is the first sheet in the spreadsheet and B72 is the cell it's reading (which happens to be the number of servings).

The hourly wage is calculated in cell C8 (time) and is inclued in the total line.
Let me now if you need more help. I work with spreadsheets alot.
post #17 of 260
10/7/05 at 12:49pm
Wow! icon_eek.gif This is incredible and invaluable to newbies like me! Thanks for sharing! icon_smile.gif
Carpiebo Diem Secundam...I'll seize tomorrow if it's a good day...
Carpiebo Diem Secundam...I'll seize tomorrow if it's a good day...
post #18 of 260
10/10/05 at 6:37pm
WOW. Thanks for sharing.


Bunchy
post #19 of 260
11/7/05 at 7:23am
I can't download the attachment. I get a message that the page does'nt exist. Help.
post #20 of 260
11/7/05 at 7:28am
Quote:
Originally Posted by jordsl01

I can't download the attachment. I get a message that the page does'nt exist. Help.



Same thing happened to me.... not sure whats wrong...

icon_sad.gif
post #21 of 260
11/7/05 at 7:37am
The same thing happened to me - I am so computer illiterate. I'll have my husband figure it out when he gets home tonight. Thanks for posting this!
post #22 of 260
11/7/05 at 8:20am
"File does not exist"...I got this too.
post #23 of 260
11/11/05 at 4:21pm
i received the same message icon_sad.gif Can someone upload it again?

Thanks...
post #24 of 260
11/11/05 at 4:37pm
There was a problem with the download script, which should now be fixed.
Go ahead and give it another try

birthday.gif Jackie

birthday.gif Jackie

post #25 of 260
11/11/05 at 4:40pm
Worked like a charm!!!

Thanks so much Jackie!!!

thumbs_up.gificon_biggrin.gifthumbs_up.gif
post #26 of 260
11/12/05 at 5:47am
It worked beatifully! Thanks Jackie.

This is an awesome program...Kudos to the creator!
post #27 of 260
11/12/05 at 7:13am
I successfully downloaded the Cake Matrix. But, I have a question. I usually make a 9x13x3 or 12x18x3 sheet cakes. Can I add those sizes to the Cake Matrix and it will calculate without any problems?

Thanks,
Grandma Sweetie Pie
post #28 of 260
11/12/05 at 7:43am
jelacopsaid
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?




To answer your question: There is nothing wrong with that formula. Leave it alone. This will happen with a spreadsheet that is empty of data with some formulas, because you can't divide by zero. Start entering some cake info on the first page and then go look at it.

GrandmaSweetiePie Said
Quote:
Quote:

I successfully downloaded the Cake Matrix. Buit, I have a question. I usually make a 9x13x3 or 12x18x3 sheet cakes. Can I add those sizes to the Cake Matrix and it will calculate without any problems?



Before I can help you with your question, let me ask you one. What do you mean by 9x13x3 or 12x18x3 sheet cakes, do you have 3" cake pans or do you make 3 layers?
post #29 of 260
11/12/05 at 7:48am
I am an assistant professor at a private university and one of the classes I assist with is Excel. I can try to help anybody with their questions on this spreadsheet, add things to it etc.

This is an excellent spreadsheet. thumbs_up.gif She has taken alot of time putting this together. It was not just an evening or two. I have a spreadsheet that has 34 pages that has taken me 8 years to develop. (it is not anything to do with cakes however) I have not had time, since I started decorating cakes again to create a spreadsheet. I had started working on one though, but I will start using this one and developing it for my own needs as I go.

I would like to know who did this as well, I want to tell her job well done and thanks for sharing.

Thanks MarinersFan!!!!!
post #30 of 260
11/12/05 at 7:59am
I can't seem to get the file to open. I have ms office but still won't open the file.
Help!!!
Look twice, save a life. Motorcylcles are
Everywhere!
ABATE of Colorado
Look twice, save a life. Motorcylcles are
Everywhere!
ABATE of Colorado
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