Friday, December 17, 2010

A Cataclysm crafting price database

A project I've been working on for the last couple of days is a crafting spreadsheet with popular items and what materials are used to make them. It's fairly simple, you plug in the costs of each material and it spits out a total cost to make the item. So far it includes blacksmithing, tailoring, leatherworking, alchemy, and a nice little prospecting spreadsheet. I've found it to be really helpful, and now it's at a stage where I feel like I can share it.



Xandamere's magical crafting spreadsheet

A few notes: This is a public Google document, but only I can edit it. So what you need to do is go to Google docs, create your own spreadsheet, then copy/paste the pages you want from mine into yours. That will let you edit the sheet to plug in prices from your server. Or, you can go to the file menu and save or download the entire spreadsheet that way. Thanks to Lavache of the JMTC forums for pointing that out. :)

I've included the popular level 85 stuff, which at this point is basically PvP gear and epic items. If you want to add in anything else, like say the lower-level blacksmithing stuff, the format is there and all you need to do is plug in the materials used. A few other notes:
  • Chaos orbs and dreamcloth are not included in cost. You have to decide for yourself what you want to charge for these.
  • The prospecting spreadsheet is a work in progress. Right now it's using Wowhead prospecting data, which is fairly complete for obsidium and elementium, but less so for pyrite.
  • I plan to update the prospecting spreadsheet to take the full shuffle into account, such as including the possibilty of crafting jasper rings and disenchanting them, or transmuting green-quality gems to blue or meta. That'll happen in the next few days.
Personally I've found this more useful than Lilsparky's Workshop so far in Cataclysm, because the auction data has been fluctuating so quickly. So, I hope somebody else finds it useful as well. :)

2 comments:

  1. Hello Nice spreadsheet

    can you drop me a email sam.mottram@googlemail.com as i want to ask you a few questions about it

    Cheers
    Zoxy

    ReplyDelete
  2. Great spreadsheet, was going to make one of these up for myself but you have saved me the trouble.

    Thanks
    Chris

    P.S. Great blog, just made a ton of money off of frostweave bags, not one other person selling them and they were selling as fast as I could make them.

    ReplyDelete