Hello all I've added a few changes to my excel spread sheet. Here are the changes and brief explanations.
How I set prices
I find a crafted item that has the best drop to cost ratio for a certain magical component. I then figure out the total cost to craft that item using AH prices for each ingridient. I then devide the total cost by the chance a component drops ( percentages are from thott).
Example: Crafted item costs 1.45g to make and has a 236% chance to drop a dream dust. So I devide 1.45g by 2.36 to get cost per dust.
New Price Colums
VBP- Vendor Base price- Is the cost per component if the crafted item it was disenchanted from were to be sold to the vendor.
AHP- Auction House Price- Same as above but with this calulaction the prices of components are based on the average AH buyout price.
MUP-Marked Up Price- What you add on top of the cost of components for your services.
GDP-Guild Discount Price- What you charge your guild members after discount.
New Worksheets
Formulas
This is the worksheet that has all 150 or so enchanting formulas. If you high light the area and apply a filter you can sort through all the formulas by item slot, stat bonus, or anything else you like (skill, price, etc..)
This was made with the intention to be used by enchanters to quickly sort through their formulas and a get a price, but it can also be used by potential customers who want to know what is available to them. The prices used are from the Laughing Skull Horde Server, so they shouldn’t be strictly applied to another server’s unique economy.
Component Prices
This section is where you can change each components price and percentages to what fits your server and your playing style, the prices will be reflected in all the formulas. Just change the AHP value since the VDP is the same across all servers and the MUP and GDP are percentages of the AHP.
By most components there is also an item that has either the best cost to drop ratio or has a 100% drop ratio. Not all components have an item by them, so if you have an item that DE's into a component that I haven't listed yet, let me know.
AH Values
This worksheet is just a running tally of what the average cost of crafting ingredients on the auction house are. Again this is only accurate on the Laughing Skull Horde Server.
Customer Credit
This is a new thing I’m trying out. Anyone who brings me items to disenchant will get the dropped component’s value subtracted from their next purchase. If they bring me more items then they can use at once I’ll save their credit on their next visit.
Disenchanting
Just data I gather about what drops from my own disenchants, will probably add %’s and costs later on.
Download
Enchanting Helper v2.0
If you have any questions or find some errors in the spread sheet post them here and I’ll try to answer.
Edited, Wed Jan 5 06:17:40 2005 by SoIitude