Chef Archive
Thread: Anyone have some Spreadheat that calculates the Experiment % depending on resources used?
Page 1 of 2
Djferio
Thu May 20, 2004 2:22 pm
#1
Is there some spreadhead out there that calculates the Experiment % depending on which resourced you used?
kelela
Fri May 21, 2004 10:52 am
#2
Not that I know of but....SciGuyCo, weren't you working on something? (hehe, sorry to put you on the spot)
http://forums.station.sony.com/swg/board/message?board.id=chef&message.id=33620&highlight=calculator#M33620
" target=_blank>SciGuyCo post
" target=_blank>SciGuyCo post
(The "Food 101" posts list vendors in which to buy the perspective foods targeted by the post. If you object to this post being here on the trade forums - please reply...I do not wish to be a "spammer" of the boards and will comply if the community sees this as "spam".)
Mace33
Tue May 25, 2004 4:00 pm
#4
Funny you should mention this.
When I read some of the postings today I was thinking the same.
in the FAQ there is a breakdown of how to do this. If has something done already I would appreciate the help as well.
Thanks!
sciguyCO
Tue May 25, 2004 4:26 pm
#5
/shifty-eyes
I've...uh....been busy. Yeah, that's it.
I'm thinking my initial plan was a bit too overwhelming. I'm going to see what kind of stuff I can set up in excel.
sciguyCO
Tue May 25, 2004 9:33 pm
#6
I'm such a geek. I'm actually really really impressed with myself for this:
It's an Excel 2000 spreadsheet. Everything in blue is calculated, those cells aren't editable (just so you don't have to worry about losing the formulas). If you feel like tweaking, there's no password to unprotect the worksheet.
This does properly take into account missing stats. So if you're making something like Cho-nor-hoola, the lack of PE and Flavor on the Bone will not drag down the calculated percentages, matching what's in the game. That's what the "units with stat" row is for.
I'm pretty sure there aren't any recipes that require more than four non-component resources, but I might have missed one.
I'm not sure what kind of bandwidth limit there is on my personal web space (and with the food chart and FAQ, it's starting to worry me), so if you're planning on using this at all, please make a local copy (right click the link anduse"save as")rather than going to the link everytime.
TyfoE
Wed May 26, 2004 4:32 am
#8
I could include something like this as my next feature in Tyfo's Chef Calculator 
I just have to think it through.
What about assembly?
svin
Wed May 26, 2004 7:56 am
#9
Tyfo - You sharing that Food Calc anywhere? I would love to get a copy of it. I use Bilbho's a lot, but he hasn't posted a message since 3/31/04 - I think he is taking a break.
TyfoE
Wed May 26, 2004 8:51 am
#10
I've just posted it some hours ago, it is still on page one in the Chef forum.
It's still in version 0.10 though
kelela
Wed May 26, 2004 11:48 am
#12
Thanks Sci...didn't mean to put you on the spot there. 
but as always, you are the uber chef who always comes through. (hehe, no pressure)
I tried to look at the other calculator...but swgchef site is underconstruction 
Message Edited by kelela on 05-26-2004 11:49 AM
Elmmx-5
Wed May 26, 2004 1:36 pm
#13
Close... but these formulas still need work it seems. I made a very similar spreadsheet myself. In the end, the formulas I used were just as inaccurate at trying to predict initial food values as Sciguy's are. These are very close, but something is definitely off. Here is what I used as test resources for a test glass of brandy.
Resource A: DR 607 FL 823 PE 847 OQ 918
Resource B: DR 640 FL 780 PE 869 OQ 789
When I combine these to make a glass of brandy, I get a product that is 50 filling, 6 uses, 36m30s duration and +170. The values that both my own efforts and Sciguy's spreadsheet predict are, 51 filling, 6 uses, 36m30s and +171. I know they are close but if I can't even predict if a combination will be 50 filling or not these formulas are not terribly useful to me. I do realize my formulas to predict these numbers me be at fault as well. Here is what I used(in excel terms).
Filling =ROUNDDOWN(55-22*(initial percent),0)
Quantity =ROUNDDOWN(4*(initial percent)+6,0)
Duration =FLOOR(30*(initial percent)+30,0.5)/1440
Nutrition =ROUNDDOWN(90*(initial percent)+150,0)
Resource A: DR 607 FL 823 PE 847 OQ 918
Resource B: DR 640 FL 780 PE 869 OQ 789
When I combine these to make a glass of brandy, I get a product that is 50 filling, 6 uses, 36m30s duration and +170. The values that both my own efforts and Sciguy's spreadsheet predict are, 51 filling, 6 uses, 36m30s and +171. I know they are close but if I can't even predict if a combination will be 50 filling or not these formulas are not terribly useful to me. I do realize my formulas to predict these numbers me be at fault as well. Here is what I used(in excel terms).
Filling =ROUNDDOWN(55-22*(initial percent),0)
Quantity =ROUNDDOWN(4*(initial percent)+6,0)
Duration =FLOOR(30*(initial percent)+30,0.5)/1440
Nutrition =ROUNDDOWN(90*(initial percent)+150,0)
Page 1 of 2