Another minor new release, version 1.2.3 doesn’t feature any maths changes but does include a couple of new things that folks have requested. Two features I want to highlight are the new Gem Suggester and Profile thingies, as well as the optimisation which should make the spreadsheet faster and “lighter”.
On the Calculators tab below the Compare Things Thingy, this tool will use DEP values to automatically optimise gem selection.
- Choose the socket colours from the drop-down Colour menu. “None” is no socket and “Any” is a prismatic socket such as you get from using a Belt Buckle.
- Below that, choose the socket bonus type from the drop-down menu and enter the number of the bonus stat.
- The suggester will list the names of its recommended gems for each socket and a description of what stats they provide, as well as the total DEP of its choices and whether the socket bonus is being “Used” or “Ignored”.
By default the suggester will ignore hit rating because of the artificially high value of hit in a spreadsheet (see Q2 under “Specifics”). However, you can turn hit rating use on if you really want.
At present, the suggester ignores meta gem activation requirements. The only way such a feature would be useful is if it was part of a full gearset gem optimiser… which is somewhat beyond what I’m doing right now. However the working can easily scale to that task if there is any call for it in the future.
Back to the Main tab, you’ll notice a small addition to the big “START HERE” box. On the bottom right of this area are two new buttons: > Store < and > Retrieve <.
- Clicking > Store < will store within the current spreadsheet your stats, glyphs, items (that is, relics, set bonuses and trinkets) and buffs/debuffs.
- Clicking > Retrieve < will overwrite whatever settings you’re currently using with the ones previously stored.
The > Store < button also stores your current DPS figure, which you can see beneath the main DPS readout. As you change your stats, settings, etc, your stored DPS will continue to be displayed and compared to the current readout.
This should make it easier to see the result of fiddling around with stats and settings as well as to restore original settings after such a period of fiddling – but note that at present things like talents, encounter options and advanced settings aren’t stored.
You can totally ignore the profile feature if you want, it’s just there to make the spreadsheet more convenient for those who want to use it! Note that it will only work with macros enabled.
My priority for version 1.2.0 was getting the new formulator working and releasing on time for patch 3.3.2. The next couple of versions were mostly small tweaks and fixes. This time around I’ve had a chance to go through and reduce the amount of unnecessary maths the spreadsheet does by “piggybacking” many of the DEP rotation formulators onto other formulators.
This means that the file size is smaller, CPU and memory usage is smaller, and the spreadsheet should be faster to use as a result.
There’s still a lot more I could do to make it smaller and faster, but that was never an issue before 1.2.0 so it wasn’t designed with that in mind.
The User Guide is now almost entirely up to date, including the FAQ. However, with the removal of the Sandbox rendering that page obsolete, I will (sooner or later) change it to a page on use of encounter settings, advanced options and some of the new tools such as those featured above.
Full changelog & Download
As always, a full list of changes with some more explanation is in the EJ thread.