WotLK DPS spreadsheet - Page 111

Jerem · 02/20/09, 7:41 AM

You don't meet the requirements for your metagem anymore, without the Deadly Topaz.
Replace one of your Perfect green gems by an enchanted Tear, and you should see better numbers.

Ingmar · 02/20/09, 7:46 AM

Hmm I'm thinking it's the meta since you're not using the Valorous gloves / Grotesque Handgrips. You're also using arrows with Envoy of Mortality, not sure if that matters for the spreadsheet but it can't be correct.

Just as a tip, you might want to use less purple gems and just miss out on some socket bonusses.

edit: beaten

Shandara · 02/20/09, 7:51 AM

Also, have you hit the 'Calculate Attributes' button after changing your gear/spec?

OJey · 02/20/09, 8:50 AM

Originally Posted by Jerem

You don't meet the requirements for your metagem anymore, without the Deadly Topaz.
Replace one of your Perfect green gems by an enchanted Tear, and you should see better numbers.

aaaaaaargh ! thx a lot^^ i knew the sheet ist perfect ! the mistake had to be mine ...

i will use an vivid forest emerald to get to the hit cap, so my meta is active again and the Crippled Treads are the boots of choice.

Sapphique · 02/20/09, 3:04 PM

It appears that the spreadsheet isn't factoring in the increased miss chance of Spirit Strike, which seems (from others' and my testing) to use Spell Hit. Versus a level 83 boss, a level 80 pet would need 17% spell hit to never miss, so a hit-capped Hunter's Spirit Beast would miss with Spirit Strike 7% of the time.

It's not an enormous DPS decrease, and in fact the Spirit Beast's ranking in comparison to other Ferocity pets doesn't seem to change with this corrected, but I think it's worth fixing nonetheless.

Please let me know if my analysis is erroneous or if I missed something.

alarge · 02/20/09, 3:19 PM

Originally Posted by Sapphique

It appears that the spreadsheet isn't factoring in the increased miss chance of Spirit Strike, which seems (from others' and my testing) to use Spell Hit. Versus a level 83 boss, a level 80 pet would need 17% spell hit to never miss, so a hit-capped Hunter's Spirit Beast would miss with Spirit Strike 9% of the time.

It's not an enormous DPS decrease, and in fact the Spirit Beast's ranking in comparison to other Ferocity pets doesn't seem to change with this corrected, but I think it's worth fixing nonetheless.

Please let me know if my analysis is erroneous or if I missed something.

I can't speak to Spirit Strike directly. However, hit rating converts differently to physical and spell hit. At 263 hit rating, you have 263/26.23 = 10% spell hit (not 8%). So your pet should only miss 7% of the time.

Sapphique · 02/20/09, 3:49 PM

Originally Posted by alarge

I can't speak to Spirit Strike directly. However, hit rating converts differently to physical and spell hit. At 263 hit rating, you have 263/26.23 = 10% spell hit (not 8%). So your pet should only miss 7% of the time.

Good catch. I corrected my post accordingly.

I've tested in-game and confirmed that Spirit Strike misses when hit-capped. I can think of no other plausible explanation besides the ability using spell hit instead of physical hit.

Argg0 · 02/21/09, 2:05 AM

Any chance we get SP Buffs for pets? As some of them use SP (and Totem of Wrath could maybe change stuff).

Also, I'm not sure, but I think that Moonkin/SPriest/Totem can help with some pet hit (WS, Spirit Beast) and Crit.

Ikuzo · 02/22/09, 6:29 AM

There are a couple of errors in the spreadsheet for PVPers that use it.
Arcanum of the Savage Gladiator is listed on wowhead as 25 resilience, but the spreadsheet has only 20 resilience on it.

Also, Titan-forged Sabatons of Triumph has a yellow socket on it, but the spreadsheet does not reflect this.

Shandara · 02/22/09, 3:49 PM

In anticipation of Uldaur going onto the PTR soon (tm) and hopefully with a slew of hunter changes to go with it, I've just uplodaded a new version of my spreadsheet. It includes a lot of experimental stuff and changes, mostly cosmetic or user-friendliness and I would like to have some feedback on them (and bugs).

The previous version (v84) is available from a link on the first page.

- Spiced Wyrm Burger now +40 Crit Rating
- Fixed Furious Howl not stacking with food and other +AP buffs (i.e. not Bshout/BoM)
- Fixed Arcanum of the Savage Gladiator (now +25 resilience)
- Added yellow socket to titan-forged sabatons of triumph and corrected resilience on shoulder enchant to show up on the gear tab
- Changing pet family will not automatically fill in the family skill and focus dump
- Fixed Boar's Gore to work with Charge (you'll need to put charge in the pet rotation). Charge is assumed to be used every time it's up (not really realistic unless for multi-mob boss fights).
- Made a fix to the rotation test tab not always adjusting the dps on the shot rotation tab if the "Use Shot Rotation Test results" is used.
- You can now sort gems on the settings tab
- Added melee weapon enchants to the gear planner. You can select which enchant is used to compare items. Comparisons between 2-handers and dual-wield are not intended.
- Small fix to PAWN string
- Added setting to not interleave other shots with L&L Explosive Shots on the rotation test tab (exported Settings tab changes won't import for this version)
- Small fixes to base stats calculations and rounding. Also added an 'in-game tooltip' value to the Calculations tab for Hunter RAP to make it easier to verify.

Some notes:
* First of all, selecting different pet families should automatically fill in the correct skills now. Only exceptions are pets that have more than 2 usuable skills. I was considering just removing the whole pet priority queue but it provides a fallback whenever blizzard adds more abilities to pets. Currently the code just fills in the family skills (i.e. Gore for boars) and the focus dump (i.e. Bite/Claw/Smack).
* I've changed the Shot Rotation test tab to mimic actual real behaviour more closely when it comes to Lock&Load and Explosive Shot tick waiting. There's a new setting on the settings tab to toggle this.
* There's a filter option for gems now. You can toggle various things. You can set sorting order with a total of three priorities. You can sort on Color, Alphabetically, Agility, AP, Hit, Crit and Quality. Try it out. I'm not sure myself yet if it actually works how I want it to work.

alienangel · 02/22/09, 4:31 PM

Originally Posted by Shandara

* There's a filter option for gems now. You can toggle various things. You can set sorting order with a total of three priorities. You can sort on Color, Alphabetically, Agility, AP, Hit, Crit and Quality. Try it out. I'm not sure myself yet if it actually works how I want it to work.

The ideal sorting order option would IMHO be sorting by the DPS values worked out by the CalcAttribute button. So if that table works out +1agi is worth 1.5dps, while +1crit is worth 0.5 dps, a 10 agi gem would sort higher (15dps) than a 10 crit gem (5dps).

I'm generally not trying to maximize ap or hit or crit anything, I'm just trying to maximize DPS - so when selecting a gem I'd usually want to pick the one at the top of the list with the highest dps value, and if it's not the right color for the socket bonus, note down how much dps it yields then try the next highest gem on the list that is the right color and compare.

Shandara · 02/22/09, 5:10 PM

Originally Posted by alienangel

The ideal sorting order option would IMHO be sorting by the DPS values worked out by the CalcAttribute button. So if that table works out +1agi is worth 1.5dps, while +1crit is worth 0.5 dps, a 10 agi gem would sort higher (15dps) than a 10 crit gem (5dps).

I'm generally not trying to maximize ap or hit or crit anything, I'm just trying to maximize DPS - so when selecting a gem I'd usually want to pick the one at the top of the list with the highest dps value, and if it's not the right color for the socket bonus, note down how much dps it yields then try the next highest gem on the list that is the right color and compare.

Hmm, good idea.

One problem is that it's not really easy to see whether a gem will satisfy the socket bonus, since that would require generating individual lists for each gem socket on the gear tab.

Sylvand · 02/22/09, 6:16 PM

Alpha sorting for gems sorts them in descending order, in contrast to the initial state which is ascending alpha sort.

The sorting is a good start; I think I agree with alienangel on the calc attributes. However I think an alternative would be to add filtering options such as hiding TBC gems, uncommon gems and purple gems. With those options I think sorting by agility/AP and then hit would be pretty close to the ideal for most folks.

alienangel · 02/22/09, 8:05 PM

Originally Posted by Shandara

Hmm, good idea.

One problem is that it's not really easy to see whether a gem will satisfy the socket bonus, since that would require generating individual lists for each gem socket on the gear tab.

Well I don't think the sort needs to consider socket bonuses if that's what you're saying - just let the sort sort by DPS value of the gem's stats, and leave it up to the user to experiment with different colors to see if any of them can get a socket bonus of greater value than the extra dps from using a better gem.

trunghung · 02/22/09, 11:44 PM

Does anyone else notice a big difference between the estimate that the spreadsheet provides versus the actual dps. The spreadsheet says my dps should be 6400 dps, but the my H naxx dps is typically around 4500dps. I don't think I am missing too many raid buff. The damage by each of the shot are pretty close to what the spreadsheet describe but for some reason I just never been able to come with 500 dps of the theoretical dps from the spreadsheet. It used to be a lot closer in TBC when it comes to my actual dps and estimate.