Chef Archive
Thread: Yet another new tool
Page 1 of 3
MaliaMing
Mon Jan 24, 2005 2:40 am
#1
Wow, that's a great spreadsheet! I actually managed to figure out how to use it too, which is a feat in and of itself. The only thing I'm puzzled by is why our most popular additives aren't listed on the drop down menu under the "more tools" tab. I already know what's needed for those and what the percentages are, but it might still be useful to include them, unless I'm missing something and they're already there.
sciguyCO
Mon Jan 24, 2005 2:44 am
#2
MaliaMing wrote:
The only thing I'm puzzled by is why our most popular additives aren't listed on the drop down menu under the "more tools" tab. I already know what's needed for those and what the percentages are, but it might still be useful to include them, unless I'm missing something and they're already there.
Because.....ummm.....
HEY! WHAT'S THAT BEHIND YOU???!!!!???
...
...
Sorry about that, I did some adjustmentsto the additive data, and the lookup got screwed up. It's fixed now, re-download the updated one.
Okram2k
Mon Jan 24, 2005 4:10 am
#3
oh goody something to give my friend who's going chef to try out
Kansalis
Mon Jan 24, 2005 4:50 am
#4
Great tool 
I was starting to make one of these myself, but never quite got around to it... lol
The ability to add resources with check-boxes to choose which to use would be great. I have a list of my stock obviously, but having it in the sheet somewhere so we could mix & match for the best results would make this my most valuable tool for crafting
Wengel
Mon Jan 24, 2005 6:30 am
#6
The factory time calculator forgot 1 important thing... didn't take into consideration with bugged factories...
BarakKuzar
Mon Jan 24, 2005 11:04 am
#7
Very, very nice. I was toying with the idea to create an Access database to do all of this (plus track store inventory, customer purchases, etc.), but you just saved me a bunch of work.
Thanks,
Dular
sciguyCO
Mon Jan 24, 2005 11:44 am
#8
Thanks for the feedback, glad you like it. Filling in that data chart almost made my eyes bleed (especially the experimental percentages).
I am still working on some additions on this, but if I waited until it was "perfect", it'd never get off my PC. Next step: Organizing the foods by buff type (along the lines of this), and for each food's stat category have two rows: one enhanced and one unenhanced. Possibly some editable fields to set experimental percentages for each category and the additive (along with suggested ranges for "mediocre", "good", "great", "uber") as reference for those "are these stats any good" threads.
Next step: Organizing the foods by buff type (along the lines of this), and for each food's stat category have two rows: one enhanced and one unenhanced. Possibly some editable fields to set experimental percentages for each category and the additive (along with suggested ranges for "mediocre", "good", "great", "uber") as reference for those "are these stats any good" threads.Wengel: are you talking about the bug where the factory run stops when the hoppers get too full (but before output hopper hits 100), or something else? The reason I ask is that I noticed last night my Vasarian factory was taking 104s per item, when I could've swore I only did two experiments (which should put it at 96s per). I was going to do some more testing tonight, but figured I'd ask if you were referring to something similar.
Osrid
Mon Jan 24, 2005 11:51 am
#9
One thing that caught my eye and I'm not sure if I'm wrong here but in the food calc if you put in a filling be add shouldn't the number go down by that % and not up?
sciguyCO
Mon Jan 24, 2005 12:03 pm
#10
Stupid signs.....
Yeah, I had the filling additive multiply the filling by (1 + Bonus/100) instead of (1 - Bonus/100). Fixed now.
Osrid
Mon Jan 24, 2005 12:10 pm
#11
Isn't that kinda sad that I would rather try and figure out things in this then acutally programming the games I'm supposed to be?
Eh software development always takes a long time hahaha.
Eh software development always takes a long time hahaha.
sciguyCO
Mon Jan 24, 2005 1:56 pm
#12
Ok, I swear this has been in progress for a while (I think that'll be evident when you look at it), but those other posters just beat me to the punch.
I don't know about you, but I have three or four different spreadsheets or web tools (maybe more, I've lost count) I use in my day-to-day crafting business.
Well, I have combined all those into one spreadsheet to rule them all, and in the darkness bind them!
By the way, pleaseright-click and "save as" rather than running in your browser.I'm still not sure whether or not my ISP's web hosting has a download limit, but I'd rather not find out.
It was created in MS Excel 2000, so you'll need compatible software. I'm not sure how backwards-compatible it is, so older versions of Office may not work.
Major features:
- The food chart we've come to know and love (but with new lookup functionality to synch it with a back-end table).
- Experimentation calculator: punch in resource stats and it'll tell you where your food will max out. You can also do some "test experiments" to figure out where you'll end up after spending experimentation points, without having to use up resources or components.
- Price calculator, taking into account resource cpu, subcomponents, and factory maintenance.
- Misc tools to figure out foods' min/max stats based on experimentation percentages, tissue stats based on resource quality, and harvester CPU.
- A single back-end data table for all food data, hopefully simplifying any updates.
Let me know what you think.
I'm not quite sure where to take it for the next step. One idea I've had is to integrate it with the Jenner/Fooman/Sloejack crafting tool (search the swgcraft.com forums for Sloejack, check the link in his sig), allowing you to select resources (including stats and cpu) from that spreadsheet. Another is to somehow organize the food effects to show both unenhanced and enhanced values.
Message Edited by sciguyCO on 01-24-2005 11:33 AM
CaraAnam
Mon Jan 24, 2005 4:07 pm
#13
yah
i saved it but it doesn't do anything for me 
just posts the credits and 2 lil boxes but there is no workable spreadsheet.....hmmmm
I wanna see it *cries*
Page 1 of 3