Download The Golden Crusade Shuffler
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