Talent Interaction Analysis
March 10, 2017 Leave a comment
I’ve had this sitting in my goggle docs for a while but have only now bothered to write a post about it. As part of my on-going series of posts about using spreadsheets to set up & analyse SimulationCraft results I’ve made a “pairwise talent analysis” sheet.
Unlike my other sheets this requires a bit of user configuration before using. Going onto the SimSetup tab you can see cells in green & yellow. Green is my standard “you can change stuff here” colour, while yellow is the “copy this stuff into SimCraft” format.
- Select your data source (either an armory profile or a default simcraft profile) and enter corresponding values for either/both.
- Indicate which talent rows need to be considered in the analysis. By default it’s set up for Arcane Mages, so levels 30 & 75 are set to “No” as these are utility talents.
- Change the two character abbreviations for each talent level, which will be used for generating the result names.
- Copy the yellow cells (or the whole of column O) into SimulationCraft
- Start simulation and then go do something else for a while.
- Copy result headers into A2 on the Raw Data tab. See following image for example, and use the “Paste Special – Paste Values Only” option.
- Go onto the Analysis tab and it’ll show you something like this:
So now you can see the single talent results in that diagonal line of green cells where the row & column labels are for the same talent. The top right half of the table shows the gain or loss from the talent combo sim less the individual results for each talent. I’ve set up conditional formatting so if the difference is greater than 1% of the default DPS it is highlighted with a different green. So for example if you look at L45 RP (Rune of Power) vs L100 OP (Overpowered) you can see there is a 6,145 DPS increase as a combination of these two talents, which makes sense as these are two damage bonus cooldown talents. Combining Overpowered with something like Nether Tempest (L90 NT) results in a -2071 DPS change (ie: a decrease) when combined with Overpowered, which is most likely due to NT not having a large mana cost & OP having a reduced mana cost function.
Hopefully others will take this, refine it, and apply it to their chosen specs.