Chef Archive
Thread: Tyfo's Chef Calculator!
Page 1 of 1
TyfoE
Thu Oct 14, 2004 11:55 am
#1
.. is currently in version 0.12. It's still in beta (woohoo, spreadsheet beta!), so if you find any errors, please post in here
I especially need correction on effects.
Also, if you have suggestions, if you find spelling mistakes, other mistakes, just post in here.
(If it looks alot like Eila's Architecht Calculator, it's because it's the same basic design).
Remember to read the readme.
In fact, to promote finding bugs, after finding a bug (or 5 spelling/grammar mistakes) you will go in the credits section as a "Bugfinder" or "Speller" or something, and you will get the option to have a shop waypoint, or something like that.
Also, keep the constructive critique comming!
It is meant to be used as a way to easily calculate salesprices, but can also (easily) be used to calculate production costs.
History:
08-10-2004 0.12 Additives revamped!
02-06-2004 0.11 Additives added!
25-05-2004 0.10 Spreadsheet launched!
So here it is; http://www.frip.dk/tyfo/tcc012.zip
Message Edited by TyfoE on 10-14-2004 09:09 PM
Message Edited by TyfoE on 10-14-2004 09:09 PM
TyfoE
Wed Nov 17, 2004 10:22 am
#4
Currently working on version 0.13 (inactive for a month, I'll guess I may finish it tomorrow).
Ykai
Wed Nov 17, 2004 12:26 pm
#5
Looks real good.
A few comments if I may.
Casks: In my opinion, the trim should be part of the raw resource cost in the same way the organic, creature food, and flora are. This way when someone puts in 2 Vas Brandies, Excell will know to auto-calculate two casks, which in turn will auto calculate 4 trim and 300 gemstone (Which should also be part of the raw resource line at the top).
The addatives: This section, there is a spot to input your cost. While I think this may be good for a Chef who buys addatives to use, I think you should auto-add what resources it takes to make it, and if a chef wants to override the raw cost by plugging in what he pays for it, he can do that.
Schematics: I think this could be placed right along the side of Creature food and meat in the addative section. The only difference is it would have to be set a bit aside and also have a slot for schematic quantity AND cost for the schematic. This would tel excell to do the simple division and the carry-over addition part of the program would do the rest and add schematic cost, meat, and organics needed to make the addative. If no number is inputted, then it would mean either a BE is using the tool or a Chef overrid the carry-over calculation and just plugged inn a raw cost.
I really like the potention of this program. Since I do alot of Excell work myself, I would be happy to help anyway I can. Once you get the basics ironed out, I think it would be cool to wrap this in a nice simple package. I may know someone who could write a nice program to make this VERY user friendly. Since you wrote it, you know how easy it would be for someone who doesn't work with Excell to mess up something simple.
Just my thoughts....PLEASE don't take this as a flame!! LOL
TyfoE
Thu Nov 18, 2004 5:34 am
#6
Thanks for the feedback.
The problem with casks, is that - unlikely as it is - not everyone uses casks all the time. So you can't JUST make the spreadsheet auto-add casks, and there really isn't space to put in a dropdown box where you can choose if you would like to add small glass, large glass or casks.
If I could get alot of the users of this spreadsheet to vote if they only use casks in the spreadsheet, I could make an auto-add function.
The 300 (crystalline) gemstone is part of the raw resources - the trims are also calculated into raw resources.
The problem with casks, is that - unlikely as it is - not everyone uses casks all the time. So you can't JUST make the spreadsheet auto-add casks, and there really isn't space to put in a dropdown box where you can choose if you would like to add small glass, large glass or casks.
If I could get alot of the users of this spreadsheet to vote if they only use casks in the spreadsheet, I could make an auto-add function.
The 300 (crystalline) gemstone is part of the raw resources - the trims are also calculated into raw resources.
Page 1 of 1