| Author |
Message |
MessiET
Frequent Member


Joined: May 01, 2006
Posts: 487
Location: Katy, Texas
Birthday: Jan 17
|
Posted:
Wed Jun 25, 2008 2:14 pm |
  |
Hi Alice,
Wow!!! What an excellent spreadsheet you have there! I just downloaded it and will be playing with it to get more familiar and comfortable using it. Thank you for all the work that you put into it and also for sharing it with us.
One suggestion, and I am not sure if this is already in the spreadsheet, would be to have one place where you input the price of the ingredients for all the recipes. This way, if the price of an ingredient goes up or down, you just change it in one place instead of changing every recipe that uses that ingredient. Does that make sense? Like I said, I need to play with the spreadsheet more, I am not sure if this is already a feature in there.
Thank you again for your generosity in sharing this! I know it will help a lot of people! |
|
|
|
    |
 |
 |
|
|
alicegop
Forum Addict


Joined: May 03, 2006
Posts: 984
Location: Fresno, CA
Birthday: Oct 06
|
Posted:
Wed Jun 25, 2008 2:58 pm |
  |
There is a place for your ingredients pricing. That is crucial to the spreadsheet to be able to accurately tell you your costs. It is on the recipes tab.
I'll attach version S here if I haven't attached it before. |
| Description: |
|
 Download |
| Filename: |
Alices Cake Matrix S.xls |
| Filesize: |
472.5 KB |
| Downloaded: |
258 Time(s) |
|
|
     |
 |
 |
junebuggey
Regular Member


Joined: Dec 03, 2004
Posts: 139
Location: NJ
Birthday: Jun 27
|
Posted:
Wed Jun 25, 2008 4:54 pm |
  |
Thanks for posting version S. I cannot wait to check it out!
Junebuggey |
|
|
|
   |
 |
 |
Shanille21
Junior Member


Joined: May 22, 2008
Posts: 69
Location: Rhode Island, USA
Birthday: Mar 30
|
Posted:
Wed Jun 25, 2008 6:24 pm |
  |
Is it just me or is anyone else having a problem opening it?
TIA
Shannon |
|
|
|
   |
 |
 |
junebuggey
Regular Member


Joined: Dec 03, 2004
Posts: 139
Location: NJ
Birthday: Jun 27
|
Posted:
Wed Jun 25, 2008 9:51 pm |
  |
Seems to be a corrupted file. It needs to be reloaded.
Thanks Alice!
Junebuggey |
|
|
|
   |
 |
 |
laynie72
Junior Member


Joined: Apr 26, 2008
Posts: 74
Location: Nashville, TN
Birthday: Dec 09
|
Posted:
Wed Jul 02, 2008 8:39 pm |
  |
Hi Alice,
Thank you very much for sharing, Iknow this work takes so much time to do... am new at this and now that I can see all this informaion I have realized i have not been charging enough
Thank you again !  |
|
|
|
   |
 |
 |
sweettoothmom
Frequent Member


Joined: Jun 10, 2008
Posts: 373
Location: 9 months of Frozen Tundra
Birthday: Nov 18
|
Posted:
Mon Jul 14, 2008 10:58 am |
  |
I have Windows Vista and it will not open this older version of excel in a readable manner. It goes to compatible mode and it jumbles the columns.
I also got the corruption errors as well.
If anyone has one in a more recent excel format (Vista) Can you please email it to me at carolynwindley@hotmail.com.
Thank you! |
|
|
|
    |
 |
 |
Tashablueyes
Frequent Member


Joined: Dec 04, 2007
Posts: 216
Birthday: Aug 30
|
Posted:
Sun Jul 20, 2008 10:11 pm |
  |
Thanks so much for posting this, I have been unable to use it as well, and since I have Vista, I am assuming that's the problem, if anyone figures out how to make this rockin' spreadsheet to work on Vista, please, please, please, could you let me know? Thanks! sunmoonstarlight@yahoo.com |
|
|
|
     |
 |
 |
monica7
Newbie


Joined: Apr 22, 2008
Posts: 17
Location: Bronx, NY
Birthday: Aug 07
|
Posted:
Sun Jul 27, 2008 1:42 pm |
  |
Never really used excel but this spreadsheet looks great, hopefully I'll figure it out soon. Thanks for sharing.  |
|
|
|
   |
 |
 |
bsanders12
Junior Member


Joined: Jun 16, 2008
Posts: 26
Location: San Diego
|
Posted:
Tue Aug 05, 2008 11:14 am |
  |
I downloaded your newest version of the matrix, but when I enter 2 for the number of layers in my cake; the matrix does not add up the costs. I was wondering if I was doing something wrong...thank you
Becca |
|
|
|
   |
 |
 |
psyndi
Newbie


Joined: Aug 18, 2008
Posts: 3
Location: Columbus, Ohio
Birthday: Jul 14
|
Posted:
Fri Aug 22, 2008 9:52 am |
  |
Thank you for all your hard work on this spreedsheet, you did a great job. I am just starting a new business and you have really given me a great start on the business side. The only problem I am having is that I don't use cake mixes and I seem to figure out how to insert my recipes. Do you have a tutoral or a post to referr to. Again thank you for sharing you hard work. |
|
|
|
   |
 |
 |
naz1905
Regular Member


Joined: Sep 10, 2005
Posts: 118
Location: United Kingdom
Birthday: May 19
Gallery Supporter Member
|
Posted:
Fri Aug 29, 2008 2:23 pm |
  |
Hiya all, Alice, Thank you for uploading newest version, I'm trying to put my own recipe in the cake recipes tab, but i'm not understanding what each column is for. What is amount unit amount and price refer to.? How do you work out how many cups you get from one batch. Or more easily, how many serving you get from 1 cup? The cup problem i'v sloved, i have converted my grams measurements to cups. Ie: i know that 1 cup butter is 227g, 1 cup sugar/flour is 128g. On the fillings tab, do you use ready made filling? Thank you for any help at all. |
|
|
|
     |
 |
 |
Tashablueyes
Frequent Member


Joined: Dec 04, 2007
Posts: 216
Birthday: Aug 30
|
Posted:
Wed Sep 03, 2008 9:38 pm |
  |
So I uploaded Alice's cake pricing matrix and let me tell you I LOVED it! I used it twice and it's awesome. But for some reason, now I can't edit any of the fields! Anyone know what happened? I can pull it up and there is my wonderful pricing matrix, but I can't do anything with it.  |
|
|
|
     |
 |
 |
mrsfirebug
Newbie


Joined: Jul 24, 2008
Posts: 15
|
Posted:
Tue Sep 09, 2008 12:31 pm |
  |
are 3 d cakes in this matrix? I looked but not sure I am looking in the right spot... Thank you |
|
|
|
 |
 |
 |
kakbarker
Newbie


Joined: Aug 21, 2008
Posts: 5
|
Posted:
Sat Sep 13, 2008 8:01 pm |
  |
I feel very stupid. I am new to this site and have searched and searched. I am sure it is right in front of my face but I cannot find the matrix. I am so embarrassed! |
|
|
|
 |
 |
 |
|
|