If you put "Assume 100% hit" to yes, the amount of hit needed to cap is completely disregarded. It is assumed you can use all of the +hit on an item. The value of hit is put 0 DPS so it doesn't interfere with comparisons any more.

I note how you are over the hit-cap (285 hit rating), so once you set "Assume 100% hit" to NO, items with a lot of hit lose DPS (since the gear planner now values only the part of their hit over the hit-cap as 0 DPS) compared to items without hit (which can use utilise all their dps stats).

The spreadsheet is correct. The other helms are better if you can get the hit somewhere else. The spreadsheet has historically been dodgy about dancing around the hit cap and goes nuts for a single item with alot of hit.

Also it is possible to create situations where you are near cap (especally for MM/SV where pet damage is a lower % of total) and have crit/AP overcompensate for the lost damage from estimated missed shots.

If you have she cash, I'd keep the Assume 100% to Yes and regem everything to and from +hit. In a related note the spreadsheet hates the Titan Forged Rune of Accuracy (+95 hit) the procs from any trinket seem to be worth more even when Assume 100% hit is No and I'm down 2.2% hit [from Black Ice]

New to the forum and appologize if this has been discussed before, but I could not find it in the thread. I'm using the May 12, 2009 version of the (incredible - thank you!) spreadsheet and have found an oddity.

In the gear planner, it shows Mirror of Truth being a 16.22 DPS upgrade over Darkmoon Card: Death with full buffs loaded and 12.10 DPS with no buffs. However, when I equip the Mirror of Truth, projected DPS in overview drops by 14.94 with full buffs and 10.17 with no buffs.

Thoughts?

Most of the time, when you load "BIS" it will not display everything as tops, but if you substitute one item for the other (most of the time), it will result in a dps loss.

At 8.69% you are over the hit cap (what ever is over the hit cap will not increase your dps), by the way, and it could very be a reason why it does not show certain items at being tops (drop some of that hit rating).

@doktorD: the gear planner is just another part of the spreadsheet to help you make selections, but I would recommend always plugging in the items themselves first, and seeing what the results are. Mirror procs often, but it is based on your crit rating to begin with, while death is on any attacks, regardless of crits or non crits.

I'm confused by this. If its assumed that you can use all of the +hit, why would the value of hit be set to 0 DPS? Wouldn't that equate to assuming that you can use *none* of the +hit? (Although this is how I assumed this feature worked, so perhaps its just a typo in your post)

And I know I already posited the idea, but just a bump, could we get an "Assume 0% hit" feature, that would behave this way (i.e. would ignore the hit cap and use full value of hit for all hit rating, including rating that would put you over the cap)?

To really determine the difference in how different priorities affect your dps, you have to go to the settings and make sure that the Use Rotation Test Results Instead of Frequencies setting is set to Yes. Next you would choose your priority, and go to the Rotations Test tab and hit Test Rotation. You would have to retest and note down the dps difference if you change the priority.

There is also a setting to automatically rerun the Rotations Test after any change. The functionality is there to automatically do most of the shot rotation testing work, its just a matter of whether or not we turn on the setting.

Thanks for the response everyone, but I am still a bit confused… What I have noticed now, only the tabs where my gear has “hit” will change, the gear that doesn’t have hit will not change, does that gear “Assume YES to 100% hit”? Curious to why it works this way? If I want to find out what hands have the most hit using the spreadsheet I now need to equip hands with hit and load it to the spreadsheet in order to see it change whan going from yes to no or no to yes in "Assume 100% hit" ???

Also as I mentioned before when I had the t7.5 head, the BIS item was “Circlet of True Sight” (Assuming NO is 100% hit cap), the difference in Delta was about 14.5, once I equiped “Circlet of True Sight”, its now saying that “Conquerors Scourgestalker Headpiece” is BIS, (Assuming NO in 100% hit), funny thing is Scourgestalker Headpiece has no hit what’s so ever… and the dela difference in "T7.5 Head" VS “Circlet of True Sight” is now over 72 Delta!!! (make me think if im better having 3/3 in FA now and puting t7.t back... should I? )

@ankah, I had just re gemed my hit to 263, but the spreadsheet doesnt have the "Rigid Lionseye" gem or any +10 hit gems, so i cant really have an accurate test here. I did manage to test it with 261 hit and 267 hit, but the results were the same the “Circlet of True Sight” is still not BIS.

That's convenient but not what I am getting at, what I am trying to say is it would be nice if the shot rotation selector would somehow be tied to talents and a list were kept of available shots and a priority on them such that at all times the shot rotation was kept updated. I'm not asking for a 100% optimal thing here, just something that would fill in the shots properly so you don't have to first select talents then go re-arrange the shot rotation. It can be quite cumbersome at times switching between rotations.

This isn't a bug, more of an annoyance, but when I have 'Hide Downgrades' set to yes it hides my current second ring in the second ring section since its a downgrade from my first ring.

Any way to not have that?

Fury of the Five Flights has always been a few dps higher than Mirror of Truth until the latest version (+7.67 delta for the Mirror currently); what could possibly change that? Was the calculation for FotFF changed?

Well, ES will proc GftT in the next patch, so either way I have a feeling Mirror of Truth will be slightly better then anyway.

Hi,

Been playing with the spreadsheet for the first time, great work btw.
Was wondering about the effect - or no effect - i noticed of hunter mark improvements from talent and glyphs.

-I took out 'Glyphe of the Serpent Sting' (set to none), and indeed saw the DPS drop from 6200 to 6148
-Now i took 'Glyphe of Hunters Mark' instead and it had no effect at all - the Total DPS remained unchaned (6148)
? Is that ok? is there any chance it actually has no DPS contribution?

I tried the same with the 'Improved Hunters Mark' talent on top of that - I took out 1 point from 'Lock and Load' and that further dropped the DPS to 6077. Now adding that 1 point to 'Improved Hunters Mark' had no effect over the DPS.

Just in case i also let the "calcAttributes" run. I didnt find any posts over this so just wanted to ask - Do these really have no effect? that sounds odd.

What am i missing here?

The default debuffs include a glyphed and specced Hunter's Mark, so you'll probably want to disable those if you'd like to see the contribution of the talents points and/or glyph.

Thanks Justinian,

Right on the spot - very basic, but i didnt notice it. Thanks.

I cannot find "Custom" option for weapons, is there one?

According to the spreadsheet, my pet (cat) dps should be 1000. However when i run naxx25 and os25, recounts reports my pet dps usually at around 500. I'm cookie cutter MM spec. Why might this be?

There are many possible reasons for this dexx. First and foremost, while your pet is travelling to and from targets its of course not dpsing. Depending on whether or not you're looking at DPS from the whole run or even a single boss fight that has adds, your pet's DPS time will often be interrupted. Also remember that if you've stopped DPS for whatever reason that your pet won't be getting focus procs from GftT which may result in focus starvation. Secondly, your pet may be missing some essential buffs, possibly because it died on trash previous to a bossfight and just hasn't been rebuffed. There's also the third possibility of certain pet skills being turned on/off. Basically, whenever a pet is "summoned" (calling pet or dismounting included) some pet skills may turn on/off. Make sure you check before each fight that the proper pet spells are on autocast (or use a Macro).

I tried to simulate Dark Matter (Trinket off Algalon-10) in the spreadsheet.
When I enter all the stats (assuming 45 sec internal cd) and press Sort on Gear Planner tab, it gives me an error and debugging option.
It gives me error on "dps = Worksheets("Trinket").Cells(Cell.row, Cell.column + 37).value"
Can other people confirm this?

Is what I used for the Dark Matter trinket, didn't receive any errors.

Edit: As far as the proc chance, I just used what was already defaulted in the cell. It is possible that it could have a higher/lower proc chance.

Also didn't work for me, any ideas?

Now that we can choose to pick 100% hit assumption would it be possible to choose 100% mana too?
To be more specific.. Would it be of any use?

The reasoning behind this is that I would like to test out different talentbuilds with a minimal replenishment by talents.
I'd like to compare the difference of using 1 or 2 Viper Stings for mana regen instead of Aspect of the Viper.
I can't seem to model the dps loss of using 8 - 16 seconds Viper instead of Serpent Sting versus x seconds of
Aspect.