Pricing matrix...get it here

Business By MarinersFan Updated 23 Jan 2016 , 11:45pm by NettaMoBetta

MarinersFan Posted 8 Aug 2005 , 4:21am
post #1 of 262

hello! icon_biggrin.gif

This excel file works in MS Excel 2003 (and probably XP, and 2000)

261 replies
MarinersFan Posted 8 Aug 2005 , 4:22am
post #2 of 262

also i wanted to add that the gal made most of the excel funtions on her own, she must be crazy! the file is pretty complex so she obviously did a LOT! thumbs_up.gif

MomoRox Posted 10 Aug 2005 , 3:51pm
post #3 of 262

THANK YOU!

This is so awesome! If you do find her website please post! Please forward my thanks because I wish I could take credit for that spreadsheet...that's for sure. A lot of thought went into to that one knowing since I work a lot with excel myself.

SugarCreations Posted 5 Sep 2005 , 5:53pm
post #4 of 262

Hi
I downloaded it too. Hope thats alright.

meso_shy Posted 7 Sep 2005 , 1:18pm
post #5 of 262

I can't get it to download I have word pad and works xp

Jackie Posted 7 Sep 2005 , 8:09pm
post #6 of 262
Quote:
Originally Posted by meso_shy

I can't get it to download I have word pad and works xp




MS Works does not include the Excel program needed to open that document.

melony1976 Posted 15 Sep 2005 , 4:43am
post #7 of 262

So if I can't download it then am i out of luck? I'm not very computer savy

rball Posted 24 Sep 2005 , 3:00am
post #8 of 262

If you find her website, please email me and let me know.

cookielady Posted 27 Sep 2005 , 3:21am
post #9 of 262

You are a life saver I was like crazy looking for this you are a saint thanks so thumbs_up.gif

Newbie Posted 27 Sep 2005 , 3:34am
post #10 of 262

This is absolutely awesome! What a work of art.

Has anyone scanned it for viruses? I don't want to save it on my PC until I'm sure it's clean.

Diana

Jackie Posted 27 Sep 2005 , 3:43am
post #11 of 262

After it was originally uploaded we did a full gamut of virus scans, and assure any one that downloads directly from the above link that it will be virus free.

traci Posted 27 Sep 2005 , 3:46am
post #12 of 262

Thanks Jackie! thumbs_up.giftraci

culinarilyobsessed Posted 2 Oct 2005 , 3:22am
post #13 of 262

aww I unfortunately don't have a program that will open the file either icon_sad.gif

jelacop Posted 3 Oct 2005 , 3:35pm
post #14 of 262

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?

umfalcon Posted 7 Oct 2005 , 7:04pm
post #15 of 262

I have been using this matrix for a year, but there is one problem. The serving per pan have changed, so you will need to update that. Don't be afraid to customize it either. I have updated and added things to mine. It's great for pricing weddings.

umfalcon Posted 7 Oct 2005 , 7:16pm
post #16 of 262
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.

tanyap Posted 7 Oct 2005 , 7:49pm
post #17 of 262

Wow! icon_eek.gif

BUNCHY Posted 11 Oct 2005 , 1:37am
post #18 of 262

WOW. Thanks for sharing.


Bunchy

jordsl01 Posted 7 Nov 2005 , 3:23pm
post #19 of 262

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

charleydog Posted 7 Nov 2005 , 3:28pm
post #20 of 262
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

thyterrell Posted 7 Nov 2005 , 3:37pm
post #21 of 262

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!

fytar Posted 7 Nov 2005 , 4:20pm
post #22 of 262

"File does not exist"...I got this too.

MontiBellesBakery Posted 12 Nov 2005 , 12:21am
post #23 of 262

i received the same message icon_sad.gif
Thanks...

Jackie Posted 12 Nov 2005 , 12:37am
post #24 of 262

There was a problem with the download script, which should now be fixed.
Go ahead and give it another try

charleydog Posted 12 Nov 2005 , 12:40am
post #25 of 262

Worked like a charm!!!

Thanks so much Jackie!!!

thumbs_up.gif

MontiBellesBakery Posted 12 Nov 2005 , 1:47pm
post #26 of 262

It worked beatifully! Thanks Jackie.

This is an awesome program...Kudos to the creator!

GrandmaSweetiePie Posted 12 Nov 2005 , 3:13pm
post #27 of 262

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

gma1956 Posted 12 Nov 2005 , 3:43pm
post #28 of 262

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?

gma1956 Posted 12 Nov 2005 , 3:48pm
post #29 of 262

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
I would like to know who did this as well, I want to tell her job well done and thanks for sharing.

Thanks MarinersFan!!!!!

chaptlps Posted 12 Nov 2005 , 3:59pm
post #30 of 262

I can't seem to get the file to open. I have ms office but still won't open the file.
Help!!!

Quote by @%username% on %date%

%body%