WotLK DPS spreadsheet - Page 102

Enishi · 02/04/09, 2:40 AM

I am not sure if this has been addressed (and sorry if it has), but is there a reason why aimed shot does not change the hunter's dps when chosen as a talent point or is this something that might be wrong on my end?

Glodd · 02/04/09, 2:42 AM

Is there a version of the sheet that is fully compatible with OpenOffice.org Calc? I have no access to Excel.

Rezdan · 02/04/09, 2:43 AM

Originally Posted by Enishi

I am not sure if this has been addressed (and sorry if it has), but is there a reason why aimed shot does not change the hunter's dps when chosen as a talent point or is this something that might be wrong on my end?

You have to include Aimed Shot in your Shot Rotation tab as well to get its full affect on your rotation.

Vitaro · 02/04/09, 2:43 AM

It is my experience that the spreadsheet does not check whether you properly specced into Aimed Shot the moment you put it into your rotation.

Edit: As a techy; saying you do not have Access to Excel is funny. Also, you must have missed the BIG FAT BOLD WARNING in the OP not to ask for an OO version.

Bechamel · 02/04/09, 7:14 AM

I am using the spreadsheet very often and I love it. Thank You, Shandara, great work.

Most questions got answered by thinking it over and reading the thread. A few left.

In the Gear Planner I got these values for my equipped rings (after pressing CalcAttributes, RangedWeapons and Sort):

Strong-Handed Ring 0 / -4,36
Ring of Invincibility -25,85 / 0

each worse than the other?

In the Overview I got these values for haste (after pressing CalcAttributes):

Haste + 1 0,363 0,363
Haste Cap+1: 0,385 Haste to Cap 79

Haste valued higher after it is capped?
I have 334 haste from gear, that shows as 10.19% Haste in the Charscreen. Together with the 15% Haste from my quiver I have more than 25% Haste. Isn´t it enough to cap my steady shots (75% of 2 sec is 1.5 sec)? Why is there still 79 Haste to cap?

After these questions I have a big wish!
Handling the Spreadsheet is very easy, exept the regemming (as often noted before). I am German and have to translate each time - it´s a pain. Everything would help a lot:
- coloring the names of the gems in the list
- sorting colors
- sorting attributes
- option in the Settings to reduce the gems to show only the best

I hope I did not frustrate You with childish wishes.
Bechamel

Lactose · 02/04/09, 7:25 AM

Originally Posted by Bechamel

Haste valued higher after it is capped?
I have 334 haste from gear, that shows as 10.19% Haste in the Charscreen. Together with the 15% Haste from my quiver I have more than 25% Haste. Isn´t it enough to cap my steady shots (75% of 2 sec is 1.5 sec)? Why is there still 79 Haste to cap?

You're doing Haste math wrong.

Steady Shot cast time with 10.19% Haste from gear and 15% quiver Haste:
2/(1.1019*1.15) = 1.58.
With your amount of Haste, Steady Shot still takes longer than the global cooldown to cast (almost 0.1 seconds longer).

Mr.Tusks · 02/04/09, 8:05 AM

hello, first off I'd like too say that I've only recently started using the spreadsheet and I'm not sure if my question is moot due too inexperience , but here i go. I had been trying too see what if any Dps increase using Anvil of Titans over Mirror of truth would bring, but at first the listing in the gear tab wasn't applying any stats for the Anvil, so i went into the custom gear tab and entered the stats as best i could,( I had left the min/max dmg slots blank as i wasn't really sure if they were applicable or not). When i had the spread sheet calculate the dps with the anvil in place of the mirror, it showed a 30dps gain. Basically i was wondering if someone could verify this, just too be sure that the gain isn't due too an error on my part. Also, i had the anvil paired with the Fury of the Five flights, if that is of any help.

jmlsteele · 02/04/09, 10:01 AM

Mr Tusks: There is indeed a problem with the spreadsheet.

On the Trinkets page Anvil of The Titans should be renamed to Anvil of Titans

So when you modeled it in the custom tab you should be seeing the proper value, making it better for you than the mirror of Truth, assuming you modeled it correctly.

However, on proc effects aren't displayed on the gear page normally, but rather in their own section on the Calculations page.

Lactose · 02/04/09, 10:18 AM

Originally Posted by jmlsteele

So when you modeled it in the custom tab you should be seeing the proper value, making it better for you than the mirror of Truth, assuming you modeled it correctly.

EDIT: Seems I hastily misread the tooltips. Read later posts before commenting.

I doubt it was modeled correctly.
[Mirror of Truth] vs [Anvil of Titans].
Both have the same proc, so we can ignore it for easier comparing the items. [Mirror of Truth] has a DPS stat (Critical Strike Rating) while [Anvil of Titans] has a defensive/PvP stat (Resilience Rating).
Given the same proc rate and cooldown on the trinkets, there is no way for 84 Resilience Rating to to yield a higher DPS in the spreadsheet than 84 Critical Strike Rating.

Ufthak · 02/04/09, 10:30 AM

Originally Posted by Lactose

I doubt it was modeled correctly.
[Mirror of Truth] vs [Anvil of Titans].
Both have the same proc, so we can ignore it for easier comparing the items.

I beg to differ, unless the tooltips are wrong, the Mirror requires a crit whereas the anvil requires a hit. That could have implications I guess.

Xanathorn · 02/04/09, 10:32 AM

Originally Posted by Lactose

I doubt it was modeled correctly.
[Mirror of Truth] vs [Anvil of Titans].
Both have the same proc, so we can ignore it for easier comparing the items. [Mirror of Truth] has a DPS stat (Critical Strike Rating) while [Anvil of Titans] has a defensive/PvP stat (Resilience Rating).
Given the same proc rate and cooldown on the trinkets, there is no way for 84 Resilience Rating to to yield a higher DPS in the spreadsheet than 84 Critical Strike Rating.

Note that [Mirror of Truth] has a chance on crit and [Anvil of Titans] a chance on hit, which might have something to do with it.

Edit: Gah, Ufthak beat me to it.

jmlsteele · 02/04/09, 11:12 AM

Heres the thing both of you are failing to take into account. Yes one is on crit and one is on hit, but both have an internal CD of roughly 45s (still needs more proving, but seems to be that much) and a proc chance of 10% (also needs more proving).

That means in order for the Mirror to be significantly less useful you would have to not crit for something like 90 seconds (or more). Assuming 1 shot every 2 seconds (45 shots) you'd have to have < 2% crit rate. That just isn't possible with sane gear levels.

Yes, if you have 0 agility and 0 crit rating then the Anvil will be better, but that's not going to happen, so he likely modeled it wrong.

Lactose · 02/04/09, 11:53 AM

Seems I misread slightly in my haste. I remember doing some math on it a while back and coming to the conclusion it wasn't worth it at all.

Some quick napkin math with 1 shot per second, 10% chance to proc follows. Keep in mind that this is simplified a bit:
Anvil:
Proc frequency --> TimeToProc + InternalCooldown --> 10 + 45 = 55
Average RAP gain --> Uptime*RAPGain --> (10/55)*1000 = 182 RAP

Mirror, 30% crit rate:
Proc frequency --> TimeToProc + InternalCooldown --> 30 + 45 = 75
Average RAP gain --> Uptime*RAPGain --> (10/75)*1000 = 133 RAP

At this crit rate, the Anvil has 49 more RAP, but 84 less Crit Rating.
As crit rate increases to more realistic values (including buffs and what not), the Anvil loses out more and more.

Like jmlsteele, I can't really see any real situation where the Anvil would be worth using over Mirror for pure PvE DPS.

Shandara · 02/04/09, 12:04 PM

Double-checking the calculations for the Anvil and the Mirror I have not found any glaring bugs.

The Anvil's slightly higher uptime (faster proc after the ICD is over) gives it a slightly higher +AP effect overall, but the loss of 85 crit rating puts it squarely below the Mirror at a 60 dps loss.

It is currently spelled incorrectly in the sheet (which will be fixed next release) but if you use the custom trinket option be sure to input the stats of the Anvil correctly.

Special Type:		On Hit	
Duration:		10	
Cooldown:		45	
Proc Chance		10%	
Min Damage		0	
Max Damage		0	
Can Crit?		No	

And as the effect +1000 AP

EDIT:
In case the 'can crit?' option confuses someone, it's an option in the version v83d:

- Gronnstalker Boots added again
- Elixir of Accuracy added
- Added setting to have Shot Rotation Test automatically redone if you make changes to the shot priority queue (default=No)
- Custom Trinkets that deal damage now have an option to factor in your crit chance for extra damage.
- Corrected Anvil of Titans spelling

Thelastdeadmouse · 02/04/09, 12:18 PM

Another request from the silly tanking hunter, but could we get Devo Aura added to the hunter buffs, and Devo Aura, Fort, and Commanding Shout added to the pet buffs available?