Chef Archive

Thread: Sciguy Dont back out now!

Meskall
Thu May 27, 2004 1:47 pm
#1

Cmon I think we could really make a nice chef calculator site... I brought this up a while ago and you seemed fairly interested.



I think we could create a very useful site...


PhP, SQL in order to create the forms via selected schematics, from there its a simple form and some math... If someone actually has some web space where PhP, and MySQL can be set up I would be willing to develope this site.



We could even expand it to the point of individual logins, and resource managers. I really find excel spreadsheets more cumbersome and anoying than an actual site...



Mesk
Pike/Doc
Mesk's Fine Foods (-6555, -4677 VoD on Tat)
Bloodfins #1 PvPer
Bloodfin's Ladder
Making entire PA's log off in the cloner is the only way to PvP
sciguyCO
Thu May 27, 2004 3:18 pm
#2

Geeze, you give people an appetizer and they want a 5 course meal!


With the holiday weekend coming up (plus taking next week completely off from work for a break and so I can hit Fan Fest) I was planning on finally buckling down and getting this done (at least in prototype form). Right now, my plans are to include:


  • Schematic lookup (displays required resources/components when selecting a food/drink name). Not really glamorous, but the data is going to be needed for other pieces, so I figured it wouldn't be too difficult to add.

  • Experimental percentage calculations (basically what that last spreadsheet does). It would have the food stats in addition to the raw percentages. This might even include a "crafting simulator" where you can allocate points into the different categories and see what the final result would be (although dealing with different success types might be a bit difficult).

  • Resource comparison. Similar to the percentage calculations, but allowing the user to enter multiple types of a resource to see how that effects the final product. This would probably be limited to a single schematic slot, comparing the various results of combining 3 different berries with 4 different fruits would get a bit daunting.

  • Some sort of price calculator. I'm trying to lay something out so subcomponents are easier to include.

I've got a rough design sketched out, although I'm still up in the air on the data storage. A database might be overkill, maybe something along the lines of an XML document would be enough. Although that would probably require loading all the data into memory at once, as opposed to getting it as needed from the database...


I will check back in later with a progress report.






Kriles Ch'artoff , Chilastra server
Master Chef (retired)
Currently doing....stuff
Meskall
Thu May 27, 2004 4:02 pm
#3






sciguyCO wrote:

Geeze, you give people an appetizer and they want a 5 course meal!


With the holiday weekend coming up (plus taking next week completely off from work for a break and so I can hit Fan Fest) I was planning on finally buckling down and getting this done (at least in prototype form). Right now, my plans are to include:


  • Schematic lookup (displays required resources/components when selecting a food/drink name). Not really glamorous, but the data is going to be needed for other pieces, so I figured it wouldn't be too difficult to add.

  • Experimental percentage calculations (basically what that last spreadsheet does). It would have the food stats in addition to the raw percentages. This might even include a "crafting simulator" where you can allocate points into the different categories and see what the final result would be (although dealing with different success types might be a bit difficult).

  • Resource comparison. Similar to the percentage calculations, but allowing the user to enter multiple types of a resource to see how that effects the final product. This would probably be limited to a single schematic slot, comparing the various results of combining 3 different berries with 4 different fruits would get a bit daunting.

  • Some sort of price calculator. I'm trying to lay something out so subcomponents are easier to include.

I've got a rough design sketched out, although I'm still up in the air on the data storage. A database might be overkill, maybe something along the lines of an XML document would be enough. Although that would probably require loading all the data into memory at once, as opposed to getting it as needed from the database...


I will check back in later with a progress report.








I think doing the application via database, would lend for future use towards other crafting trees... Once all the code is in, and if its generic enuff to be controlled by the database... adding say doctor crafting to the application would be easy.



Schematic lookup (displays required resources/components when selecting a food/drink name). Not really glamorous, but the data is going to be needed for other pieces, so I figured it wouldn't be too difficult to add.


Pretty easily done with database queries, plus the same database could be used to create the "forms" for filling in resource stats.



Experimental percentage calculations (basically what that last spreadsheet does). It would have the food stats in addition to the raw percentages. This might even include a "crafting simulator" where you can allocate points into the different categories and see what the final result would be (although dealing with different success types might be a bit difficult).


The only part thats a challenge here for design is determining the exact formulas which I'm sure you already have, however also determining if the formula works for expanded applications (ie doc crafting).


The simulator was something I was thinking about today, it would be interesting to figure out the formulas for experimentation successes, and calculate the actual % you would have given inputed variables such as research center, bespin bonus, and soon FS crafting bonus to produce certain stats. So maybe rather than just a simulator, allow the user to allocate his points (10-12) and produce a chance of achieving certain stats. Or allow the user to just input desired stats... brandy for example:



nutrition 420


flavor 45 minutes


filling 49


uses 21


I would think code could be written to determine the % of achieving the stats, and possible the needed point allocation and needed success type.



Resource comparison. Similar to the percentage calculations, but allowing the user to enter multiple types of a resource to see how that effects the final product. This would probably be limited to a single schematic slot, comparing the various results of combining 3 different berries with 4 different fruits would get a bit daunting.


While I like the idea as possibly something to expand into, the app would/should allow the user to figure this out by possibly running it in say 3 seperate browsers.



Some sort of price calculator. I'm trying to lay something out so subcomponents are easier to include.


This would be fairly easy to do, you could always just allow for a CPU input on the resource input form, that is not required... and it produces a cost per item/crate.




Something that might be very useful as well when building this app, is to include the BE additive schematics in the database (if you descide to use a db) since I know alot of chef's either make thier own, or supply a BE with the resources and get a schematic made.




I read your post in where you linked to your excel spreadsheet, and was bummed it sounded like you no longer wanted to take on this project. I actually began to start designing it myself, but I'm glad you descided to stick with it... I think this would be extremly useful to chefs, and if it uses a database to generate its forms, and input I would think it could easily be expanded to other crafter types.




Mesk
Pike/Doc
Mesk's Fine Foods (-6555, -4677 VoD on Tat)
Bloodfins #1 PvPer
Bloodfin's Ladder
Making entire PA's log off in the cloner is the only way to PvP
HavocDroid
Thu May 27, 2004 4:16 pm
#4

Sounds like a good idea. In my opinion, PHP & MySQL would be the way to go. A database is expandable, once you have the basic system working, you can add data and make it work for other professions.Things like swgcraft data can also be loaded into a MySQL database through a simple parser script, allowing you to do whatever you need to it.
Meskall
Thu May 27, 2004 5:04 pm
#5






HavocDroid wrote:

Sounds like a good idea. In my opinion, PHP & MySQL would be the way to go. A database is expandable, once you have the basic system working, you can add data and make it work for other professions.Things like swgcraft data can also be loaded into a MySQL database through a simple parser script, allowing you to do whatever you need to it.






Yes another great idea if we wanted to think about exanding this into a great chef site is a script to parse thru all the swgcraft resources and display the ones that pertain to cef assigning them values based upon thier stats and how they relate to chef schematics.



Mesk
Pike/Doc
Mesk's Fine Foods (-6555, -4677 VoD on Tat)
Bloodfins #1 PvPer
Bloodfin's Ladder
Making entire PA's log off in the cloner is the only way to PvP
Deko
Fri May 28, 2004 3:19 am
#6

My webspace has plenty of MySQL databases and PHP support, let me know if you're interested.
Elmmx-5
Fri May 28, 2004 7:15 am
#7

I think we should all take a step back and put some effort into proving or disproving Sciguy's spreadsheet formulas. Before everyone jumps on some grandiose plan using those formulas as a cornerstone, it would be prudent to make sure they are correct. I know I still have a few questions that haven't been proven to my satisfaction. A couple would be, what happened to MuttonJedi's average rounding? He claimed the formulas are incorrect without doing that. Also what does SWG even use as weightings? Is nutrition generally 66% PE 33% OQ or is it 66.666..., 33.333... Sciguy's formula says it's 66.6, 33.3. How do we know that is correct? Maybe we should all decide on a good schematic and put some effort into testing this theory. I'm not quite sure what to use, but looking in my pack... veghash seems like a decent candidate since my last batch's Nutrition was calculated to 8 digit precision. It seems unfair to lay this all on Sciguy, how about we all put in a little effort and each test this out until we can all agree it will without a doubt predict the stats of a food. Then we can start planning a big PHP/MySQL site or something to utilize it.



_________________________________
Akiko' Saito
+25 Master Chef (14pt artisan, force experimentation)
Shop at -6009 -447 Corell Peaks, Corellia


Deko
Sat May 29, 2004 9:02 am
#8

/bump

I'd really like to see this happen.
Elmmx-5
Sat May 29, 2004 9:28 am
#9

It seems to me no one cares. Either that, or they all want Sciguy to do it all for them like his food chart. I've yet to see anyone offer to try to refine this formula by testing it. I'd happily test it out and try to pin down a more precise solution, but the lack of interest in disheartening to say the least.



_________________________________
Akiko' Saito
+25 Master Chef (14pt artisan, force experimentation)
Shop at -6009 -447 Corell Peaks, Corellia


Meskall
Sat May 29, 2004 1:03 pm
#10

I would be more than willing to post resource stats and results, however I do not have excell installed on the OS I run SWG off of. While I think its important to refine the formula, that is a very minor part of the actual code involved in developing a site like this. Also a part that can be changed even once the site is developed.



Mesk
Pike/Doc
Mesk's Fine Foods (-6555, -4677 VoD on Tat)
Bloodfins #1 PvPer
Bloodfin's Ladder
Making entire PA's log off in the cloner is the only way to PvP
Elmmx-5
Sat May 29, 2004 2:16 pm
#11

A small part of the code, yes. But if you never get that right what do you have? To me it seems you'd end up with another version of swgcraft. I apologize if I misunderstood the scope of this, but what exactly do you envision this doing? Even if you build the schematics in as a lookup, how will that be of help if you can't accurately see what the end result will be? How will you handle some chef's preferences to say make canape with max nutrition while others make 33 fill, just a standardized weighting system?



_________________________________
Akiko' Saito
+25 Master Chef (14pt artisan, force experimentation)
Shop at -6009 -447 Corell Peaks, Corellia


Meskall
Sat May 29, 2004 2:27 pm
#12






Elmmx-5 wrote:
A small part of the code, yes. But if you never get that right what do you have? To me it seems you'd end up with another version of swgcraft. I apologize if I misunderstood the scope of this, but what exactly do you envision this doing? Even if you build the schematics in as a lookup, how will that be of help if you can't accurately see what the end result will be? How will you handle some chef's preferences to say make canape with max nutrition while others make 33 fill, just a standardized weighting system?






Ok well lets all get together, and descide on 1 schematic... (something with decimal places is probably most accurate, bivoli, vegeparsin, pyro, something along those lines..) post our resource stats...initial assmelby... and maximum %. This wouldn't be very difficult to take 5+ results and test it against someone's formula.



As for chef's personal choices on filling vs nutrition etc it has been mentioned here to produce some sort of simulation crafting code... So instead of pointing fingers and accusing others of having a lack of intrest why dont you creat a post, heck link it in this post... and descide on a schematic or 2, and determine what variable and results you want/need to test against a formula and lets do it.Your attitude towards the entire thing does not seem to be as constructive, and positive as it could be... rather than blanket statements like people don't care, why don't you come up with a way to prove/disprove the formula and ask people for help with your theory.




Mesk
Pike/Doc
Mesk's Fine Foods (-6555, -4677 VoD on Tat)
Bloodfins #1 PvPer
Bloodfin's Ladder
Making entire PA's log off in the cloner is the only way to PvP
Elmmx-5
Sat May 29, 2004 2:49 pm
#13

I have posted an example, when this first came up I expressed concern that the spreadsheet wasn't accurately predicting the brandy I mentioned. I also posted the resources I used. Later, I even suggested using veghash to test this out since mine was displayed to 8 digits in game. I'm sorry if I offended people when I said it seemed like no one cared, but I don't know how to interpret no responses and only 4 people commenting but as a lack of interest. Will veghash work as a test?, does anyone have a better idea? I didn't want to just pick a schematic and run with it if this didn't seem like good idea to others. To me it seems we need to know for sure the the stat ranges of a schematic to make this work, do we agree on one? Also I was trying to bounce some ideas off the communtity like, what does the game use as a weighting?, I certainly don't know and I was hoping possibly someone else did... once again this recieved no response. By all means offer a suggestion, I'd really love to see this work.



_________________________________
Akiko' Saito
+25 Master Chef (14pt artisan, force experimentation)
Shop at -6009 -447 Corell Peaks, Corellia


Page 1 of 2
Previous Next