Register
  • Latest Shuffling Spreadsheet for the Masses

    It's been awhile since I made an OP here, and while going through and updating my ore-shuffling spreadsheet, I figured I'd just go ahead and clean it up and put it out here for everyone. You'll need Excel 2003 or later. No, you won't get a google docs version - there are VB Macros embedded (make sure you enable them) that I have no plans to port to google's platform.

    Here's the Link - Just go there and download it and open it in Excel - it won't work in google docs.

    Features:
    • Setup to pull in current market prices via TUJ XML data, after following some simple steps
    • Manual Allocation of uncommon gems to: SSD or Rare Transmutes, Vendor, DE, Bank
    • Analysis of all options for uncommon gems
    • Cut Gem Profits calculated from actual Market Prices
    • Full accounting of all materials, prospecting, cut, crafted, disenchanted, and finally - listed on the AH
    • Loot tables presented (not behind-the-scenes)
    • Full time accounting of the entire crafting process and GPH
    • Total Revenue, Profit, Average Profit per Stack, and Cost


    I originally took Sterling's Ore shuffler seven months ago and started some heavy modding. Our spreadsheets have grown very far apart in that time. I want to give that credit to him, but also exoneration for any mistakes you guys may find. Please let me know about any mistakes or inaccuracies you may find so that I can make corrections - they're all mine and mine to fix. Just don't be a dweeb - this stuff is advanced goblinism - you're gonna have to read and understand the instructions before you run off and break things. They're in the first worksheet.

    Enjoy!

    EDIT: BE SURE TO ZERO OUT THE GEMS ALLOCATIONS WHENEVER YOU CHANGE THE NUMBER OF STACKS OF ORE YOU ARE BUYING.

    Also - I just now uploaded a new version that fixed the loot tables.