I have created an Excel spreadsheet that has several useful function fot playing the game. It is at https://drive.google.com/file/d/0Bzm...it?usp=sharing Each function is on a different tab. The functions are
- A Cooldown calculator where you enter the hours and minutes and it gives you the date and time when the cooldown will end for both the straight cooldowns and the Thursday ones.
- Another cooldown calculator where you can enter multiple cooldowns and it will add them up for both the straight cooldowns and the Thursday ones. Useful if you want to know when a series of cooldowns that you plan on using on a queue will end.
- A Lab guess a number aid. You enter the number you are going to use and then if it was high or low. It calculates the next set of high and low numbers, the mid point, the mid point + and - 10% an the number of possible values. It lets you know if the the number you are going to enter is outside the current range and also if it is too close to the top or bottom of the range.
- A WB calculator where you enter where the current damage is in millions (up t 2 decimal places) and it calculates how far ahead or behind you are to kill it with 4 minutes to spare for the last hit mode. It does it for both the 250 mil and 50 mil WB (for 50 mil to kill it before 45:00). Useful to see if boosting is needed.
- A lot of the formations that my 3 children and I have used to beat bosses, both in HR and quests. These are in no particular order.
There is one macro in the spreadsheet that is used to clear the values in the Lab tab. Because of these you may get a security message when you open it.
Once you have used it, feel free to post any suggestions of problems that you find.
November 27,2013
Uploaded a new version see http://bbs.tynon.com/showthread.php?...ll=1#post24641 for details.
November 28,2013
Fixed a problem with the server time stamp calculations.


Reply With Quote
