| Author |
Message |
umfalcon
Junior Member
Joined: Jun 28, 2005
Posts: 85
Location: Birmingham, AL
|
 Posted:
Fri Oct 07, 2005 12:16 pm |
  |
| jelacop wrote: | | 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
Frequent Member
Joined: Aug 22, 2005
Posts: 306
Location: Sugar Land, TX
Birthday: May 31
|
| Posted:
Fri Oct 07, 2005 12:49 pm |
|
Wow!  This is incredible and invaluable to newbies like me! Thanks for sharing!  |
|
|
 |
|
|
BUNCHY
Junior Member
Joined: Aug 01, 2005
Posts: 89
Location: Metro-Detroit, Michigan
Birthday: Jul 12
|
| Posted:
Mon Oct 10, 2005 6:37 pm |
|
WOW. Thanks for sharing.
Bunchy |
|
|
| |
|
|
jordsl01
Newbie
Joined: Nov 02, 2005
Posts: 1
|
| Posted:
Mon Nov 07, 2005 7:23 am |
|
I can't download the attachment. I get a message that the page does'nt exist. Help. |
|
|
| |
|
|
charleydog
Frequent Member
Joined: Oct 18, 2005
Posts: 411
Location: Winnipeg, Manitoba
Birthday: Sep 09
|
| Posted:
Mon Nov 07, 2005 7:28 am |
|
| jordsl01 wrote: | | 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...
 |
|
|
 |
|
|
thyterrell
Frequent Member
Joined: Apr 24, 2005
Posts: 301
Location: Union City, TN
Birthday: Oct 13
|
| Posted:
Mon Nov 07, 2005 7:37 am |
|
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
Forum Addict
Joined: Mar 31, 2005
Posts: 542
Location: Alabama
Birthday: Mar 27
|
| Posted:
Mon Nov 07, 2005 8:20 am |
|
"File does not exist"...I got this too. |
|
|
| |
|
|
MontiBellesBakery
Regular Member
Joined: Nov 02, 2005
Posts: 161
Location: North Carolina
|
| Posted:
Fri Nov 11, 2005 4:21 pm |
|
i received the same message Can someone upload it again?
Thanks... |
|
|
| |
|
|
Jackie
Site Admin
Joined: May 11, 2004
Posts: 1127
Location: Tacoma, WA
Birthday: Oct 20
|
| Posted:
Fri Nov 11, 2005 4:37 pm |
|
There was a problem with the download script, which should now be fixed.
Go ahead and give it another try |
|
|
| |
|
|
charleydog
Frequent Member
Joined: Oct 18, 2005
Posts: 411
Location: Winnipeg, Manitoba
Birthday: Sep 09
|
| Posted:
Fri Nov 11, 2005 4:40 pm |
|
|
| |
|
|
MontiBellesBakery
Regular Member
Joined: Nov 02, 2005
Posts: 161
Location: North Carolina
|
| Posted:
Sat Nov 12, 2005 5:47 am |
|
It worked beatifully! Thanks Jackie.
This is an awesome program...Kudos to the creator! |
|
|
| |
|
|
GrandmaSweetiePie
Junior Member
Joined: Aug 26, 2004
Posts: 55
Location: Maryland
Birthday: Feb 04
|
| Posted:
Sat Nov 12, 2005 7:13 am |
|
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 |
Last edited by GrandmaSweetiePie on Sat Nov 12, 2005 8:08 am; edited 1 time in total |
|
| |
|
|
gma1956
Forum Addict
Joined: May 23, 2005
Posts: 641
Location: Kerrville, TX
Birthday: Aug 02
|
| Posted:
Sat Nov 12, 2005 7:43 am |
|
jelacopsaid
| 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: | | 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
Forum Addict
Joined: May 23, 2005
Posts: 641
Location: Kerrville, TX
Birthday: Aug 02
|
| Posted:
Sat Nov 12, 2005 7:48 am |
|
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.  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!!!!! |
|
|
| |
|
|
chaptlps
Forum Fanatic
Joined: Oct 25, 2005
Posts: 1830
Location: Colorado
|
| Posted:
Sat Nov 12, 2005 7:59 am |
|
I can't seem to get the file to open. I have ms office but still won't open the file.
Help!!! |
|
|
| |
|
|
|
|
