Results 1 to 3 of 3
  1. #1

    The Golden Crusade Shuffler - A Shuffling Spreadsheet for Mists of Pandaria


    This spreadsheet, created for Mists of Pandaria, is designed to help players get the most profit out of what has become known as the shuffle. Users can take market data from The Undermine Journal (all three data options are supported, XML, CSV, and IQY) and enter values for how much ore they're buying, at what price, how many gems they're transmuting etc. The Shuffler also includes a page for The Ironpaw Shuffle and for Spirit of Harmony Optimization.

    Note that while some tabs are hidden and any cells not used for data input are locked there are no passwords on the spreadsheet so users can tweak the formulas at their own risk if they so wish. Furthermore, the spreadsheet was designed to work with later versions of Microsoft Excel (using the .xlsx format) so support for other spreadsheet programs will be limited but I'll try to do my best within reason to accommodate support for other programs via the Google Docs version.

    Features

    • Estimates profit margins
    • Allows users to experiment with different amounts of transmuting, disenchanting, crafting, and more
    • Can be used as a stand alone calculator for enchanting profits
    • Fully customizable to a players needs including options for perfect gem cuts, disenchanting jewellery, guild perks and masteries, and customizable purchase prices
    • Spreadsheet advises users on what should be profitable and what won't
    • Allows taking enchants into consideration
    • Tells you the most profitable way to use your Spirit of Harmony
    • Tells you how to make gold with the Ironpaw Shuffle
    • And more

    Version History
    Code:
        Version 1.0.1
            Fixed Sparkling Shards not counting Trillium Ore
            Added the new Primal Diamond transmute to Spirit of Harmony Optimizer
        Version 1.0.0
            Added support for the Ironpaw Shuffle
            Added Spirit of Harmony Optimizer
            Added support for Trillium Ore (both Black Trillium Ore and White Trillium Ore)
            Changed how the spreadsheet uses your enchanting materials – the spreadsheet now assumes you will try to use up all your enchanting materials, and if you run out will buy what you are missing
            Minor bug fixes
        Version 0.3.4 (Unreleased)
            Fixed the material requirements on Enchant Chest – Glorious Stats
        Version 0.3.3
            Fixed a cell causing problems in Google Docs
            Fixed a typo preventing the spreadsheet from pulling sale stats for Enchant Chest – Glorious Stats
        Version 0.3.2
            Fixed issue when purchasing additional gems for transmute
            Information tab is now protected
        Version 0.3.1
            Cleaned up price fetching formulas
            Fixed compatibility issues with other spreadsheet software
        Version 0.3.0
            Now accounts for and displays Auction House cut and profit margin
            Added and updated Enchanting support
                Can now calculate profits when making scrolls
                Converts to most profitable materials to buy and sell
            Added option for perfect cuts
            Fixed errors collecting cut prices with CSV data
            Data collection now prioritizes IQY>CSV>XML
            Added/Fixed Advice
                Now recommends whether to sell or disenchant the rare procs from Ornate Bands and Shadowfire Necklaces
                Now advises on which Enchanting material conversions are profitable
                Transmutes and Serpent’sEye Jewellery now tells you if the crafts are profitable or not
            Now able to enter override purchase prices for Golden Lotus and enter a price manually (also applies to the new Enchanting materials section)
            Cost now includes vendor items (Settings and Vellums)
            Option to calculate for selling or disenchanting blue quality Ornate Bands and Shadowfire Necklace (advice has been added for this as well)
            Now accounts for extra Serpent’s Eyes you have to buy
            Fixed logic for how many Ornate Bands and Shadowfire Necklaces you can craft
            Improved Ghost Iron Ore prospecting table with data from larger sample size
            Housekeeping
                Removed sneaky pesky XML maps so you should no longer get XML errors
                Cleaned up a bunch of convoluted formulas
        Version 0.2.3
            Fixed enchanting materials having incorrect prices
            Added option to value on Sparkling Shards or Serpent’s Eye
        Version 0.2.2
            Fixed Golden Lotuses not being accounted for since 0.2.0
            Fixed bug with one of the advice options
        Version 0.2.1
            Fixed bugs with Enchanting material market values
            Fixed Primal Diamond not taking updated Transmute Mastery update from 0.2.0 into affect
        Version 0.2.0
            Added support for jewellery crafted with Serpent’s Eyes
            Added options for collecting market values from CSV and IQY from The Undermine Journal
            Rearranged and cleaned up several sections
            Changed transmute mastery bonus to 20% (up from 10%)
        Version 0.1.1
            Fixed rare gem totals not accounting for primal diamond transmutes
            Fixed transmutes not accounting for Transmute Master
        Version 0.1.0
            Release
    Last edited by Xsinthis; 09-17-2013 at 12:42 PM.

  2. #2
    Just a quick note that The Golden Crusade Shuffler has been updated to V1.0.1

    Changes in this update include:
    • Fixed Sparkling Shards not counting Trillium Ore
    • Added the new Primal Diamond transmute to Spirit of Harmony Optimizer

    If you find yourself using these features please consider updating.

    Download The Golden Crusade Shuffler - A Shuffling Spreadsheet for Mists of Pandaria
    Last edited by Xsinthis; 09-17-2013 at 12:42 PM.

  3. #3
    Junior Member RomanceOsborn's Avatar
    Join Date
    Jul 2015
    Faction
    Alliance
    Server
    Aggramar (US)
    Posts
    25
    Added the new Primal Diamond transmute to Spirit of Harmony Optimizer

    ทางเข้า จีคลับ

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •