ABOUT

The DragonVale Gold Optimization spreadsheet was created with objective of helping me quickly decide which were the best gold generating dragons in each habitat, and as such, which one to keep and delete based on their gpm.

 It is mostly aimed at medium and hardcore players, since you will have lots of habitats and dragons to choose from … but there’s nothing wrong for beginners to plan early :-)

The spreadsheet use a wide array of MS Excel functions, several tabs (8 visible, the rest are hidden), 36 pivot tables and over 6300+ formulas! To keep the file low and fast, there are no pictures – if you want to see what an egg or dragon look like, check dragonvaledb.com or the wikia. Also, to ensure optimal compatibility with various versions of Excel and lookalike (tested on MS Excel 2010), it contains ZERO macros!

LIMITS
  • When selecting the size of an habitat on ISLAND, nothing is preventing you from adding more dragon than allowed.
  • You’re limited to 10 habitats per island. I have found that more is difficult to place when habitats are large or giant, and still keep it “pretty”.
  • 5 boosters max per island. But then, why would you want to put all of them on one lol!
  • Though gemstone dragon are listed in MASTER, they are not taken into account … yet.
  • Excel won’t update automatically the pivot tables where most of the calculations are made. So after any changes to MASTER, either save then close and re-open the file, or go to data >> refresh all to update the pivots with your new information.

No comments:

Post a Comment