Tuesday, February 27, 2018

DragonVale Gold Optimization 5.1!

Greetings Valers,

It has been quite some time since I updated the file, but so many changes to happen both inside and outside the game, that time was difficult to find. Thank you for your patience, to all with whom I exchanged in the past few weeks and espacially to Laura JC for her donation, that pushed me to find time again for this and here we are with an updated file!

The spreadsheet has been updated:
 - all the dragons: including the latest event dragons
 - Eggs section updated
 - MASTER updated
 - ISLAND: added island 22, 23 & 24
 - ISLAND INPUT: new worksheet to make it easier to transfer your data from one version of the spreadsheet to the next (copy /paste)
 - Various bugs fix  and improvements

Please note that the Rift features are not fully operational:
- not listed in "MY DRAGONS" yet
- not listed in "RANKINGS" yet

Also, I don't have Island 23 & 24 yet, so couldn't update the image file with the map (I also usually do the one on the wikia but that hasn't been updated yet), so it only shows up to 22. If you own the last two, feel free to drop a comment with their location and I will update asap.


Keep your feedback going, you can reach me via the comments here, on facebook or by my email.
Donations always welcome if you use and appreciate the spreadsheet!


Monday, November 6, 2017

DragonVale Gold Optimization 5.0!

Greetings Valers,

A major release today, thanks to all the beta testers of the pas few months!
The spreadsheet has been updated:
 - all the dragons: including the latest rift dragons
 - Eggs section updated
 - added the Rift habitat / islands
 - MASTER updated
 - ISLAND: added island 20, 21 & Rift Islands
 - DASHBOARD: added a box to etherium generated by your rift dragons
 - ISLAND INPUT: new worksheet to make it easier to transefr your data from one version of the spreadsheet to the next (copy /paste)
 - Various bugs fix (Ornamental) and improvements (dropdown list for levels now in descending order)

Please note that the Rift features are not fully operational:
- not listed in "MY DRAGONS" yet
- not listed in "RANKINGS" yet
- some rift dragons do not have complete GPM data on MASTER tab

Unfortunately, I'm missing one egg in the collection and I haven't been able to figure out which one. If you can find the missing egg, let me know! I checked the formula and all seems correct).

Keep your feedback going, you can reach me via the comments here, on facebook or by my email.
Donations always welcome if you use and appreciate the spreadsheet!





Saturday, September 2, 2017

Gold Optimization Spreadsheet 4.6

Greetings Valers,

The spreadsheet has been updated:
 - all the dragons: adding all the Dragons from the Pentournament
 - Eggs section updated
 - added the Rift habitat
 - MASTER updated
 - ISLAND: added island 19 & Guargantian Island (40 habitats!)
 - DASHBOARD: added a box to track Kairos level, and the max amount of gold you can get when activated!
 - DASHBOARD : added a box to track your Elder progress (was available on MY DRAGONS but not very clear)
 - Corrected a few spelling mistakes(thanks Ricky Patel!)
 - Various bugs fix (Ornamental) and improvements (dropdown list for levels now in descending order)

A massive THANK YOU TO SHARON F. Your third donation is a big incentive for me to a carry on developping and updating this.

Keep your feedback going, you can reach me via the comments here, on facebook or by my email.
Donations always welcome if you use and appreciate the spreadsheet!




Finally, pleaes note this is most likely the latest release of the 4.X serie. I have been working on 5.0 for quite some time, and I'm still looking for a few testers to ensure all the nex feature work properly.
Let me know if you want to try it early!

Wednesday, August 9, 2017

Testers for 5.0 needed

Hello Valers,

I have been working in the past few weeks on 4.6, and I'm happy to say it's nearly complete: I just need to input the final new data once the event is over and I'll release it. Most of your comments and feedback have been implemented as well, so stay tune!

Meanwhile, I'm also trying to prepare the next major release: 5.0!
One of the most popular request I get is how to transfer data from one spreadsheet to the newest version. This is a tricky one for many reasons. I kept on postponing hoping a developer would help me code a website or an app with all the good stuff on this tracker, but so far no luck.
So I have found (I think), a good workaround that would allow you to copy / paste entire islands data from one sheet to the next (for example 5.0 to 5.1).

While the appearance will not change much, there is a lot of new formulas, changes, moving stuff around and so I need some help to test it all.
We'll be communicating through emails, the idea being not only to help report bugs, but also feedback to me so I can improve the sheet and make it useful for everyone.





If you are interested, drop me an email and I'll send you the beta file shortly after.

Thanks!

Thursday, May 11, 2017

Gold Optimization Spreadsheet 4.5

Greetings Valers,

The spreadsheet has been updated:
 - all the dragons: adding the 2 new Galaxy Dragons
 - Eggs section updated
 - MASTER updated
 - OPTIMIZE HABITATS: updated
 - DASHBOARD: added a box to show the treats statistics. Very useful if you want to know how much treats you need to get your dragons to max level, and how much gold you need based on the crop you grow.

The treats statistics box has been added based on your feedback from a recent poll. Some of you also wished to be able to add more habitats per island as 10 was too few. However the feedback I received was not enough to do that work *just now*, but I'm exploring the idea for the next major update (5.0) along with new ideas.

Keep your feedback going, you can reach me via the comments here, on facebook or by my email.
Donations always welcome if you use and appreciate the spreadsheet!




Wednesday, April 26, 2017

How to clear existing data

Hello Valers,

As some of you noticed, I tend, with a few exceptions, to publish every new release of the spreadsheet with my own data.
The reasons are threefold:
 1. I test as much as possible the spreadsheet before releasing it: entering my own data helps me troubleshoot it.
 2. Some users have asked to leave my data and not remove it as it explains and serves as a guide as to what to fill and where.
 3. To be honest, I'm lazy :-) It takes time to upload the file, write a post, list all that has changed, and I'm not even counting the time it tales to implement new features, correct bugs, search forums for help on unusual formulaes and test it all. Removing my data takes a little bit too much of time.

I'll be publishing a poll after the current one to ask what you think and take action based on that.
One of the options will be to put a button to "clear all", but that will involve a macro and I really don't want to go that way for many reasons (including but not limited to security - people tend to avoid excel files with macros because of potential viruses - and the time it requires to troubleshoot it as macros are not universal and may not work on all versions of excel)

Meanwhile, I have found this tutorial that explains quite well how to erase all the data:
http://smallbusiness.chron.com/delete-unprotected-cells-excel-spreadsheet-42189.html

I have tried it and it works. It takes a couple of minutes, but you'll be with a fresh sheet in no time.

Hope this helps and thank you for your understanding

Thursday, April 20, 2017

Gold Optimization Spreadsheet 4.4

Greetings Valers,

Wow what an event BFS threw at us for Easter! Lots of new stuff, with a new booster, a new island and the very first habitat that can accomodate 6 dragons!

The spreadsheet has been updated:
 - all the dragons: all the ones from the event, plus the few that came along like Sumi and Plateau!
 - Eggs section updated
 - MASTER updated
 - ISLANDS: major update there, had to rework quite a few things for that Chrysalis habitat upgrade and its 6 dragons
 - RANKINGS: all the habitats (I think) are now listed
 - ISLANDS: new monolith booster
 - OPTIMIZE HABITATS: updated
 - LEVELLING UP: now indicate if that dragons can be upgraded by Tiamat, Bahamut or either one. Usefu so you don't waste your treats when you have one of both of the Mythics dragons.
 - DASHBOARD: added a box to see how many dragons can be upgraded by Tiamat, bahamut or both, and how many remaining dragons you can upgrade through the Mythics dragons feature.


Keep your feedback going, you can reach me via the comments here, on facebook or by my email.
Thanks to Christopher L. W. for his support and feedback, lots of things comes from our exchanges.
Donations always welcome if you use and appreciate the spreadsheet!