That's exactly what i did, i pressed the use default glyph button. I thought it was working last night, and it appears it was.

I did re-check, and apparently the problem is with Tab:Main cells B15 and B21, not the actual DPS calculations. Those 2 cells seem to pull from the Alt Gearset hit rating.


As for rotations, i swapped to 3000 seconds and it's showing Judgement, DS, CS, Consecration, HoW, Exorcism as my ideal rotation at 7927 dps. My next best rotation is HoW, Judgement DS, CS, Cons, Exo at 7923. That said I trust your spreadsheet, but it seems counter-intuitive to have HoW so low, do you have any thoughts?


Here is a copy paste of my gears Stats, I'm not sure copy and paste will work very well, but just in case i will include it.

140 107 148 86 107 87 139 86 0 82 0 57 190 148
88 76 0
95 67 96 50 67 60 90 38 57 52 36 84 0
59 0 59 49 0 0 57 0 48
68 0 80 74 0 28
0 59 47 0 0 83
0 123 96 0 220
50 0 0 0 51 91
3.5
267.3
Relentless Str Str - Str/Crit Str Str Str/Crit - Str - - - - Str
Str/Sta - Str - - - Str - - - - - - - Str
- - - - - - - - - - - - - - -
8 Crit 4 Str - - 4 Str - - 4 Str - - - - - - -

Okay, so here is the solution:

All of the numbers on the Main page reflect the Alternate gearset. Whether or not they should reflect the Main or Alternate gearset is certainly a good question, but since it is consistent it seems ok to me. I figured having it show the stats you are testing is more useful than the stats you are assumed to have normally was the way to go.

If that is confusing or you think it should be otherwise, let me know, but this is a 'feature' not a bug.

Any time you include 2pt10 in your rotation it seems that the choices you make are almost irrelevant. The only consistent thing I noticed was that Judgement needs to be early to get the highest damage and Judgement first was universally the best. The only reason you would see HoW coming ahead of it is that HoW is used for a fairly small part of the fight so its location in the rotation is going to be a lot more random than the other abilities. If you are curious how much HoW actually hits for when seals, RV, etc. are counted in look at the Ability Use Information page. You can see that HoW is actually one of our lower damage abilities at high gear levels, which is why it generally ends up low in priority.

Remember, HoW was huge at ilvl 200, but it does not scale at all with ArPen, Haste or weapon damage and scales TERRIBLY with crit. It also scales weakly with str/AP due to having weak coefficients and high base damage. We actually get very little from the Execute phase now because our GCDs are so much more full and HoW is no longer a heavy hitter. It ends up right in the pack with Consecrate/Exorcism (which have drastically shorter GCDs, so are more effective) and CS while DS and Judgement are the big hitters. When you are completely jammed for GCDs the abilities that hit hardest and have the lowest effective cast times are going to shine.

On 4.1 I'm not able to change my rotation after changing my latency. It gives me an error (error 13 i think) and the spreadsheet becomes unusable after that.
I'm using excel 2007, windows vista business.
Also, if I try to set the latency manually it says I can't, cause the author did not allow for manual overrides.

I don't know what to tell you. I have altered the latency on the 4.1 version myself and nothing ever went wrong; I just can't reproduce this bug. Does it always occur any time you change the latency? Has anything else in the sheet gone buggy for you?

Got it, it was because I use ',' as decimal separator and your possible latency choices used '.' After changing my settings on Excel it worked perfectly.

I am looking for input on the next iteration of my spreadsheet. Specifically I am looking at changing some of the ways I calculate DPS to simplify updates and errorchecking and I want feedback. Please do not fill this thread with replies unless you have something you feel everyone needs to see/comment on, just PM me your thoughts.

Firstly I am looking at eliminating the two categories of Above 20% and Below 20% and having all the DPS numbers just show for the whole fight. Does anyone actually make use of them as they are?

Second, does anyone care about having specific stats for each race be available, or is that level of precision just unnecessary?

Lastly, this is the time to request specific features if you want them or just let me know if you have complaints. The next version is going out this week I hope and it will have a ton of updates, hopefully the last updates needed this xpac.

Just wondering. But given with the discovery that the 4set increases seal tick damage does the vengeance dot scale with AP?

Since the dot is incapable of critting, i would think that would make strength slightly more valuable or maybe just widen the gap between strength and crit. I realize that the 4set also increases seal damage and judgment damage, which are capable of critting. Has any consideration been given to the effects of the 4set to crit rating given that it does in fact increase the seal tick? A little light bulb in the back of my mind just has an implication that it would change stat weights. Possibly making crit less valuable even if only slightly.

The sheet takes all these things into consideration already.

Whether or not I make an import gear feature is unclear. It would be a bunch of work and rewriting so I don't know if I will go there.

Version 4.2 is now live. Major changes:

Added support for Eng Rockets, Bryntroll, TAiaJ.

Substantial layout revamp.

Fixed mechanics for % damage modifier stacking for seals and strikes.

A number of small improvements to haste modelling and 2t10 modelling.