Chef Archive
Thread: Chef Calculator spreadsheet available
I like the page alot. Great Job!!!
Anychance of adding a feature to enter the stats of the resources and it spits out the stats of the food. That would be really cool.
Justa suggestion.
Sammeria
hi Bihlbo,
Again, thank you for making this calculator available to the chef community - I cannot tell you how much it has begun to help me - I can get organized on my factory runs so much fast now! Anyway - a couple questions/suggestions:
The pricing is cool - but is there a way to input a profit percentage of our choice? An additional "yellow" field that we could enter a percentage in? Just seems that we're breaking even with the calculator the way it is. I try to enter profit by entering a little more per resource - but that gets tedious.
Bah- and a newbie question;you multiplied the complexity by 8 to get "time per item"...I'massuming this is "8 seconds", is this the base time to manufacture any item? Sorry, I searched the boards and for some reason could not find the answer.
The proposed button to clear/reset all yellow fields is cool - but even better would be to clear the fields everytime you select an item from the pull down. That is essentially when I want the fields cleared. Actuallymakingthe boxes match the base stats instead of clearing them completely for the "my stats" section only would be nice since I get some of the same numbers most of the time. However, leave the boxescleared completely in the resources section.
I like the factory "time" calculator; the"cost for full factory run" I don't really use. Most of that moneyhasalready been spent andat this time the informationis notuseful to me as far as inputing costs into my vendor for this item(does that make any sense?). Ofcourse, to run agood business - you might want this information to use forprojecting future costs.
I like the idea of making this list compatible with other importable spreadsheets. I would really like it to work with an inventory spreadsheet (is that asking too much?). This is so that when I select an item from the pulldown - not only will it tell me what items I need - but it can search my inventory sheet for the item with the highest stat. Wouldn't that be nice! haha - should we start paying you? Anyway - it's a WISH more than a suggestion. 
LOVE the resources need for factory run section. I use it ALL THE TIME.
Oh, one last thing - this one is cuz I'm just lazy...but so that I don't have to pull out my calculator for the recalculation, do you think it would be useful to have the recalculatedpricedue to the "Average Quality" percentage displayed also?
Okay - that's all I got for now. hehe...thanks so much for this tool!
kelela
Message Edited by kelela on 03-26-2004 05:44 PM
Kelela:
The pricing is cool - but is there a way to input a profit percentage of our choice? An additional "yellow" field that we could enter a percentage in? Just seems that we're breaking even with the calculator the way it is.
Great suggestion, that will be in the next version, I promise.
Bah- and a newbie question;you multiplied the complexity by 8 to get "time per item"...I'massuming this is "8 seconds", is this the base time to manufacture any item? Sorry, I searched the boards and for some reason could not find the answer.
This was answered in the previous thread on this topic. Link at the top of this thread.
The proposed button to clear/reset all yellow fields is cool - but even better would be to clear the fields everytime you select an item from the pull down. That is essentially when I want the fields cleared.
For instances where you might want to use the same wheat, for example, in multiple recipies, it needs to be a button instead of automatic.
I like the idea of making this list compatible with other importable spreadsheets. I would really like it to work with an inventory spreadsheet (is that asking too much?).
It most certainly is. Not only would this be amazingly difficult, but I think it would take away some of the control from the user. This calc isn't intended to be able to make judgement calls for you, it's intended to streamline getting to the bottom line.
LOVE the resources need for factory run section. I use it ALL THE TIME.
I'm glad you like that. It was tough to make and I learned a lot of Excel by making that.
Oh, one last thing - this one is cuz I'm just lazy...but so that I don't have to pull out my calculator for the recalculation, do you think it would be useful to have the recalculatedpricedue to the "Average Quality" percentage displayed also?
Ahh, I see. I've beenusing the calculator in a way that it wasn't intended to be used.
Bihlbo wrote:
Kelela:
I like the idea of making this list compatible with other importable spreadsheets. I would really like it to work with an inventory spreadsheet (is that asking too much?).
It most certainly is. Not only would this be amazingly difficult, but I think it would take away some of the control from the user. This calc isn't intended to be able to make judgement calls for you, it's intended to streamline getting to the bottom line.
I use it as a cost projector/bottom line price calculatoras well as a tool to prep my factory runs. But I guess it didn't hurt to ask right? I am not uber at excel at all - so I wasn't sure what was really possible. thanks for entertaining my question.Thanks for answering all my questions/comments Bihlbo - it all makes perfect sense.
Please keep up the good work and I'll be sure to keep testing it out.
I don't think that this feature has been asked for by anyone else...so with that in mind -please don't go breaking your back for my crazy and obviously monumental requested feature. I didn't know the amount of work and effort it truly involved and it is really a lot to ask. I think that your time is better spent working the issues that have been requested by the masses and not just by me.
Bihlbo wrote:
Ahh, I see. I've beenusing the calculator in a way that it wasn't intended to be used. I use it as a cost projector/bottom line price calculatoras well as a tool to prep my factory runs.
Well, that is how it's intended to be used. Maybe I misunderstood. My thoughts were, you'd start in the crafting tool, and then go to the ChefCalc after you've made all your decisions on how you were going to make the item, and after you'd found out what the stats were going to be.
The last thing I want to do is de-emphasize the actual crafting process.
I think though, that I could add a feature to this that would allow you to calculate the value of resources that you have on hand. You'd have to input all of the data for the resources yourself, but then you could chose the recipe you wish to make from the drop-down list and it would tell you how each resource rates for the recipe you chose.
That would take a tremendous amount of work. A monumental task. But it would be possible. (ugh)
Yes, though it's possible - it's not necessary and maybe not even worth the effort you'd have to put in. Tackle the higher priority items from the previous posts first I suggest. There is some work that we chefs need to do on our own...I have the opportunity to work with the spreadsheet on my own to do some tweaking for my own personal purposes.Basically you're providing us a tool for free, handing it to us on a silver platter...maybe it's about time we did some work on our own too. 
thanks B.
Ahh, I see. I've beenusing the calculator in a way that it wasn't intended to be used. I use it as a cost projector/bottom line price calculatoras well as a tool to prep my factory runs.
Well, that is how it's intended to be used. Maybe I misunderstood. My thoughts were, you'd start in the crafting tool, and then go to the ChefCalc after you've made all your decisions on how you were going to make the item, and after you'd found out what the stats were going to be.
The last thing I want to do is de-emphasize the actual crafting process.
I think though, that I could add a feature to this that would allow you to calculate the value of resources that you have on hand. You'd have to input all of the data for the resources yourself, but then you could chose the recipe you wish to make from the drop-down list and it would tell you how each resource rates for the recipe you chose.
That would take a tremendous amount of work. A monumental task. But it would be possible. (ugh)
Actually I made a modification to the spreadsheet for that. Maybe it's just my tired eyes, but it seems to work fine for me across the board. I explainedwhat I didin this thread http://forums.station.sony.com/swg/board/message?board.id=chef&message.id=34807#M34807
Bihlbo wrote:
Oh, one last thing - this one is cuz I'm just lazy...but so that I don't have to pull out my calculator for the recalculation, do you think it would be useful to have the recalculatedpricedue to the "Average Quality" percentage displayed also?
The only reason this wasn't in the very first version is because the percentages don't calculate the same for every recipe. For instance, if you make two different foods using the same resources, and an equal success rate in experimentation, you'll end up with different quality percentages. This is because some items don't have the same range of values for every feature of the product. A food with 2 uses that has a max of 6 uses is going to produce a lower quality value than a drink with 4 uses and a max of 46 uses.
In short, quality values are subjective and therefore shouldn't be calculated directly into the retail price of the item. If I can finda way to resolve the different values so the quality measurement takes into account the min and max stats for the recipe, then it could be used to help determine price. As it stands, it's not really of much use other than to tell you how much better one of your products is from another of your products of the same type.
If any of that makes sense.
Message Edited by Gaenjin on 03-30-2004 01:01 AM
Message Edited by Gaenjin on 03-30-2004 01:02 AM
Are you also able to put some feature in that calculates the experiment % for example ...
You need 33% pe , 66% dr and 33% OQ for whateverdelicouscake
Which needs Meat and Wheat
You have Wheat with 677 PE , 788 DR and 988 OQ
And Meat with 800 PE , 500 DR and 800 OQ
Are you able to make some calculator that calculates the experiment % when using these resources?
Thanks :-)
Message Edited by Djferio on 05-05-2004 01:41 PM