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
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
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
WOW. Thanks for sharing.


Bunchy
post #19 of 260
I can't download the attachment. I get a message that the page does'nt exist. Help.
post #20 of 260
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
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
"File does not exist"...I got this too.
post #23 of 260
i received the same message icon_sad.gif Can someone upload it again?

Thanks...
post #24 of 260
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
Worked like a charm!!!

Thanks so much Jackie!!!

thumbs_up.gificon_biggrin.gifthumbs_up.gif
post #26 of 260
It worked beatifully! Thanks Jackie.

This is an awesome program...Kudos to the creator!
post #27 of 260
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
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
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
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