PDA

View Full Version : Provisioner Recipe & Ingredient Database 1.7 (Last Update: 24th Nov 2005)


Azzer_007
12-07-2004, 12:30 AM
<div></div><div></div><b><u><font color="purple" size="4">Last Updated: 24th November 2005 13:50 GMT</font></u></b>Introducing the latest Provisioner Recipe & Ingedient Database 1.7:<a href="http://www.bushtarion.com/everquest/" target="_blank">www.bushtarion.com/everquest/</a>Please feel free to pass this link around, and suggestions, comments and data submissions are always more than welcome.<b><u>Some Key Features:</u></b><b><font color="red">*</font></b> Every single standard provisioner recipe available, even for level 60 provisioners.<b><font color="red">*</font></b> Durations on every single food and drink in the game! These durations are for "Savory" or "Chilled" items - quality level 2.<b><font color="red">*</font></b> "Shopping List" - want to create 20 of a specific item? No problem - quickly find out exactly how many of each item you need to have befor eyou start your crafting!<b><font color="red">*</font></b> "Raws" on all items, stating exactly how many "Raw Resources" a recipe will "consume" in its creation - eg "Wild Apple Tea" uses 2 raws - Green Tea Leaf and Wild Apple.<b><font color="red">*</font></b> Interactively browse through recipes, quickly view the ingredients they need, how complex the items are to craft, how much the average build cost is, what recommend broker sale and buy prices are etc. etc. - all the information you should need on any recipe.<b><font color="red">*</font></b> "Explode" or "Implode" recipes, to see a tree-like diagram of how to construct complex recipes or view an item "flat"... exploded tree is perfect for checking just how many of each component you need to make a complex item from scratch.<b><font color="red">*</font></b> Quickly and easily search the database by name using wildcards, such as "*pie*" to find any tasty pies you might be able to craft for instance!<b><font color="red">*</font></b> Search by numerous criteria, for example if you were level 24 and wanted to find the easiest items you could craft that would still provide experience, you may search for "minimum craft level 14" with "maximum complexity 0".<b><font color="red">*</font></b> Enter a list of some components/items/ingredients you have, and quickly have the site list all recipes you can currently create from your inventory. It will even assume you automatically have any items available from the wholesaler, so no need to enter basics like packets of spice, coal, liquid etc.!<b><font color="red">*</font></b> Easily find items good for grinding and profit, by quickly identifying data such as average build cost, recommend broker sales price, whether the items can be crafted purely from wholeseller available ingredients etc.<b><font color="red">*</font></b> Quick listing of the latest database entries and updates rather than having to spend a while searching for any newly entered recipes.<b><font color="red">*</font></b> A tool to help decide what price to set - for example say you want to sell an item and have potential customers see it listed on a broker for a price of 21.5 silver - the tool will instantly tell you you must set a price of 1,792 copper.<b><font color="red">*</font></b> Select your own "Colour Scheme" to use while using the site, just to personalise your experience a little and help suit your tastes a little more from the "Site Settings" page. This requires the use of cookies.Of course there are no doubt many other uses people can find from the data and nature of the database & site not listed above, I'm merely listing what I consider the main features or what features I personally consider the most useful... have a play with it for yourself and you'll find your own uses!<b><u>Some things that might not be immediately obvious:</u></b><b><font color="green">*</font></b> You can click column titles to sort by that column, and click again to change sort order.<b><font color="green">*</font></b> Click on any item/ingredient whenever it is in the link colour to view details for that item, such as what recipes require that item, what the recipe to craft it is etc - you can go through the directory this way, clicking item within item within item.<b><font color="green">*</font></b> "Craft Level" is the craft level of that recipe (if there is any recipe involved).<b><font color="green">*</font></b> "Merc. Sell" is whether or not the wholesaler merchant sells this ingredient/product. Handy if you're grinding or trying to avoid buying from players/gathering.<b><font color="green">*</font></b> "Merc. Craftable" is whether this item is, ultimately, available to craft purely from original ingredients available from the wholesaler - so whether or not you need to gather any resources/buy any resources from another player at all.<b><font color="green">*</font></b> "Complexity" is how complex the item is to craft - how many items you must personally craft before you can craft the final recipe.<b><font color="green">*</font></b> The "Ing" column is number of ingredients involved in that recipe.<b><font color="green">*</font></b> The "Dur" column is the duration of the finished item at quality level 2, in minutes.<b><font color="green">*</font></b> "Cost" is either the cost to buy from the wholesaler (if "Merc. Sell" is "Yes"), or what I consider a fair price to pay on the market (note sellers: this price includes the brokers 20% - if you charge the same price I list, the brokers will add 20% to the cost and you will be charging more than my guidelines).<b><font color="green">*</font></b> "Build Cost" is the total cost of all the ingredients found.<b><font color="green">*</font></b> "Sell Value" is what it sells to the wholesaler merchant for (at least as far as I have found...)<b><font color="green">*</font></b> "RRP" is a Recommended Retail Price - just a vague price suggestion to sell to players for.<b><font color="green">*</font></b> "Profit" is "Sell Value" minus "Cost", or if no "Cost" is set, then "Sell Value" minus "Build Cost".Suggestions, comments and missing ingredients/recipes/data are more than welcome. Enjoy! <img src="/smilies/283a16da79f3aa23fe1025c96295f04f.gif" border="0" alt="SMILEY" /><p>Message Edited by Azzer_007 on <span class=date_text>11-24-2005</span> <span class=time_text>01:55 PM</span>

Z
12-07-2004, 02:31 AM
<DIV>Kick butt...thanks for the database.</DIV>

Archae
12-07-2004, 03:38 AM
<DIV>Azzer, any chance you could do this for other professions, or share the code?</DIV> <DIV> </DIV> <DIV>This rocks, i would love to type in "rough turqoise" sometime and then poof, everythign i can make that uses it.</DIV> <DIV> </DIV> <DIV>Great DB for provisioners though.</DIV> <DIV> </DIV> <DIV>Prob would be one if i had to do over, sage stinks.</DIV>

Azzer_007
12-07-2004, 04:01 AM
[Edited out by Azzer]<p>Message Edited by Azzer_007 on <span class=date_text>01-31-2005</span> <span class=time_text>12:30 AM</span>

Azzer_007
01-31-2005, 05:31 AM
The site has now been updated fully to version 1.5. Amongst the new features are chiefly;* Every single recipe in the game is now in the database.* Every single finished item now has the duration listed wherever appropriate - this duration is in minutes at quality level 2 (Savoury/Chilled).* The "Recipe Finder" now uses some intelligence. Eg if you enter "Green Tea Leaf" and "Wild Apple" as ingredients you have, the Recipe Finder will even list "Wild Apple Tea" as a possible recipe, since you can ultimately create Wild Apple Tea starting with those 2 raw ingredients.* I have applied my own personal formula as to what I sell drinks for at the various tiers, and used a bit of sensible guess-work on food. As ever, everyone has personal experiences on prices, and I can do nothing but list my own prices that I find sell at a good rate for good profit.

Clawrift
02-01-2005, 04:34 AM
<DIV>I would like to see more link's. For newbie's, or anyone in need of help.</DIV> <DIV> </DIV> <DIV>Thank you very much for this info.  Well needed...    :smileywink:</DIV>

Manit
02-27-2005, 04:04 AM
bump

warm_machine
04-26-2005, 05:31 PM
<P>Sweet Azzer!!!  :smileyvery-happy:  Finding this post has made my day, and my toons life much easier!</P>

TheStranger
05-05-2005, 04:03 AM
Well, this is just awesome<img src="/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif" border="0" alt="SMILEY" /> thx a lot!! <div></div>

Stricken
05-30-2005, 07:32 AM
Great site!!!! :smileyhappy:

Manit
05-30-2005, 07:43 AM
<div></div><div></div><div></div><div></div>If you want a hard copy, then check out  <a href="http://eqiiforums.station.sony.com/eq2/board/message?board.id=a3&message.id=9667" target="_blank">Tarindel's Advanced Provisioner Spreadsheet (TAPS) v1.1.1</a>. Excel Spreadsheet. Quite elaborate and I have found very useful. <hr>---Tarindel <font color="#ffffcc"> </font><font color="#ffffcc"><b>Note</b></font><font color="#ffffcc">: You will need to have Excel installed (2000 or higher works, not sure about 97) and a way to unzip files.</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> ---</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> The primary capabilities of this worksheet:</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> * It's dynamic -- you can personalize it to fit exactly your situation, based on your inventory and prices you see on your server.  No one-size-fits-all here.</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> * See what levels recipes REALLY are if you make them from scratch (because subcombines are sometimes higher level than the final combine)</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> * See how long the recipe will ACTUALLY take to make (not based strictly on number of combines, but based on whether each combine is a refined, interim, or finished product, and what quality level you are producing).</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> * Can take into account which components only need to be produced at watery/bland level because they are not primary components.</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> * Can take into account your character's provisioner level (since lower leveled products are easier to make)  (Note: this is an "expert" level feature, as there is currently no solid data about how much of a benefit your level gives you -- hence, it is turned off by default)</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> * Takes into consideration both cost of raw materials and duration of finished product, to gage your profit potential more accurately.  (Note: To use economic features, you will have to spend a little bit of time tailoring the worksheet's prices to your server.  Explainations on how to do this are included in the provisioner.txt)</font><font color="#ffffcc"> </font> <font color="#ffffcc"> </font><font color="#ffffcc"> * Given an inventory of raw materials, use the solver to figure out what the best products are to make given those materials!</font> <hr><p>Message Edited by Manitos on <span class=date_text>05-29-2005</span> <span class=time_text>08:47 PM</span>

VettsVey
06-01-2005, 11:59 AM
Great work Azzer and Manitos!

KindredHeart
09-13-2005, 11:38 PM
Where'd it go <img src="/smilies/9d71f0541cff0a302a0309c5079e8dee.gif" border="0" alt="SMILEY" />  /cry

Erithorn
09-14-2005, 05:06 PM
<P>Was there really changes here as of September 13th?</P> <P>Erithorn</P>

Azzer_007
11-24-2005, 07:27 AM
The Provisioners Recipe-Database is back up and at a new location now! Expect to see the Tier 6 recipes added soon.<a href="http://www.bushtarion.com/everquest/" target="_blank">www.bushtarion.com/everquest/</a>Is the new URL. Enjoy! <img src="/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif" border="0" alt="SMILEY" />

Akira
11-27-2005, 12:25 AM
<DIV>Great website. Will mention it on this Tuesdays EQ2's-Day show on Online Gaming Radio.</DIV>