WotLK DPS spreadsheet - Page 199

alienangel · 07/03/09, 2:16 AM

I know base stats have been mentioned and fixed recently, but I'm still getting some strange inconsistencies with them in the latest live version of the sheet (revision g).

As a level 80 night elf, with maxed mining and engineering, completely naked, I show the following stats:

Character Sheet Values
Survival with 5/5 Lightning Reflexes, 5/5 Survivalist, 2/3 Hunting Party 3/3 Careful Aim, Trueshot off, Hawk on:

Agility 218 (213 + 5)
Stamina 194
Int 90
RAP 816

MM with 2/2 Combat Experience 3/3 Careful Aim Trueshot Off, Hawk On:
Agility 193
Stamina 177
Int 93
RAP 736

Spreadsheet Values when Survival
The racial line at the top of the gear planner reads 213 agi - this appears be my base modified by 15% from Lightning reflexes, which should be 213.9
The Multiplicative Talents line at the bottom says 16.15% - the formula looks correct (multiplying LR, CE and HP together) but 1.15 x 1.02 should be 17.3%
The In-game Character Tab (without procs) line at the bottom (wearing no gear) says 215 (213 + 2).

So on my charactersheet I have 3 extra agi somehow - I would guess that if my base is 186, it's doing 186 x 1.15 x 1.02 = 218.178. This would match the spreadsheet if it were calculating my multiplicative talents as 17.3% instead of 16.15% (however looking at the MM results below, I'm not convinced this % is being directly used in the calculations at all).

The sheet also does some strange things on the calculations tab, claiming Aspect of the hawk is -298 RAP, but in the end it comes up with a reasonable tooltip of 813 RAP (3 RAP short).

Spreadsheet Values when MM
The racial line at the top of the gear planner reads 186 agi - this appears be just my base, since for whatever reasons this line includes lightning reflexes, but not Combat Experience or Hunting Party
The Multiplicative Talents line at the bottom says 4% - this appears to be correct
The In-game Character Tab (without procs) line at the bottom (wearing no gear) says 186 + 0. This is incorrect, since the 4% from Combat Experience hasn't been included yet - it should read 193 like my character sheet does.

The calculations tab claims I should have 726 tooltip RAP, which is 10 rap short

Now, scaling up to wearing full gear (but still no buffs):
As MM I have 1252 agi in game, but 1246 agi according to the character sheet (I took off greatness to avoid the averaging of its proc)

As SV I have 1412 agi in game, but 1440 agi according the spreadsheet (again, took off greatness)

In all the above cases I also set Pet type to none to avoid call of the wild affecting the rap values and removed the point in TSA.

So looking at the deltas above, I think for MM it's just missing ~6 agi from not applying talents to base racial agi. However for Survival it's apparently screwing up the stacking of LR and HP somehow and going from being short 3 agi naked to being short 28 agi geared (and likely a lot more buffed and with greatness on) - can anyone else confirm a hefty difference between predicted and actual unbuffed agi values?

• VRoscioli · 07/03/09, 10:06 AM

Originally Posted by R00k!3

Hey,

I have a big problem in figuring out why my pet does not nearly as much damage as calculated by the spreadsheet.
My hunter also does not reach the calculated ammount of damage, but I guess this is based on ping and my
antiquated PC which delivers about 8FPS in raid situations.

Anyhow, spreadsheet says that my Wolf should do about 1017dps (No Faerie Fire/Mangle/Leader of the Pack and no Rampage, because we have no feral and our fury is not attendant that often).
In reality it is between 600 and 800 dps in the most cases. I have turned of any nondamage abillities and therefore I have no idea where the problem is.

I am not sure if it is a problem of the spreadsheet or if it is my fault, however this is our log of today. Perhaps you can help in figuring out where the problem is.

World of Logs - Real Time Raid Analysis

ps: I hope I did not do too much mistakes, my english is not that good.

"Active Time: 80.4%"

Your pet was only attacking for 80% of the time. Whether this is from not having your pet attack or do to having it avoid aoe damage or just from switching targets, this is why your pet's DPS is about 80% of what it should be. The spreadsheet represents DPS in a stand-up-and-tank-and-spank fight, where your pet's DPS uptime should be (nearly) 100%. Since this is not achievable on most fights, we should not expect the DPS from the spreadsheet on most fights.

As an example, though, if you look at your XT-002 kill, your pet has much higher attack uptime and shows 1002 DPS.

R00k!3 · 07/03/09, 10:30 AM

Ok,

this seems to be an explanation for the overall statistics. So let's look at the fight against Ignis where the active dps-time is at about 96% and dps is at 812 dps.
Does this encounter have any special armor values?

edit: Ah I think I figured the problem out. I didn't take the Dodges/Glances... in to account.

Thank you.

• VRoscioli · 07/03/09, 12:26 PM

Originally Posted by R00k!3

Ok,

this seems to be an explanation for the overall statistics. So let's look at the fight against Ignis where the active dps-time is at about 96% and dps is at 812 dps.
Does this encounter have any special armor values?

edit: Ah I think I figured the problem out. I didn't take the Dodges/Glances... in to account.

Thank you.

The spreadsheet should take things like dodges/glances into account. My guess would be that flame jets are the culprit on this fight. They interrupt DPS but your pet would still be considered "active" while running back after jets.

Rivkah · 07/03/09, 11:09 PM

My web based adaptation of Shandara's spreadsheet is now in public beta for anyone who'd like to try it out (should be especially useful to those without Excel).

It's at Zeherah's Hunter DPS Analyzer

• VRoscioli · 07/04/09, 3:01 AM

[BUG] On the Melee tab, there is an off-by-one error in the enchantment calculation section (A159:G162 in v90). The delta Agi is appearing (and being calculated as) the delta Int column. The delta AP is appearing (and being calculated as) the delta AP column, and so on.

[BUG] Also, on the Pet tab, in the focus starvation calculations in column S, I think that the second conditional should be "if(R##>0,..." instead of "if(Q##>0,..." ...Not that I see this making a huge difference anywhere, but I'm just saying.

Rhy · 07/04/09, 4:31 AM

Originally Posted by Rivkah

My web based adaptation of Shandara's spreadsheet is now in public beta for anyone who'd like to try it out (should be especially useful to those without Excel).

It's at Zeherah's Hunter DPS Analyzer

I just gave it a go. The first problem that I noticed is that it won't load gear/talents from the EU Armory. I am pretty sure it is because the EU armory still doesn't support the pet talents. The US armory works fine.
Now, the other thing that I saw is that for my gear, there is some 600 dps difference between the Excel spreadsheet and your adaptation. I checked everything a few times, and the only thing I noticed is that the stat values are a bit lower than the spreadsheet and also each shot has lower dps. The biggest difference is for Chimera shot - 1510,42 vs 1366,06.

On the bright side, I find it really easy to work with, especially the gem sorting and shot rotation are so nice. You have done quite a good job so far. Would be quite interesting to see further development.

Anindor · 07/04/09, 5:01 AM

Originally Posted by Rhy

I just gave it a go. The first problem that I noticed is that it won't load gear/talents from the EU Armory. I am pretty sure it is because the EU armory still doesn't support the pet talents. The US armory works fine.
Now, the other thing that I saw is that for my gear, there is some 600 dps difference between the Excel spreadsheet and your adaptation. I checked everything a few times, and the only thing I noticed is that the stat values are a bit lower than the spreadsheet and also each shot has lower dps. The biggest difference is for Chimera shot - 1510,42 vs 1366,06.

On the bright side, I find it really easy to work with, especially the gem sorting and shot rotation are so nice. You have done quite a good job so far. Would be quite interesting to see further development.

another bright side, even though overall DPS at the end seems to be lower, it seems to be in proportion to the excel spreadsheet (e.g.if something raises or lowers your DPS on the spreadsheet, it will have the same affect on the web version)

P.S.

I wonder what Shandara thinks about this....

elandriel · 07/04/09, 7:21 AM

Excellent work on the web version. As a poster before me already mentioned, there are some problems when attempting to import from European Servers. Other than that I believe the whole web project merits its own thread so we can beta test it and report errors, discuss additional features etc. without cluttering this one.

Kharthus · 07/04/09, 7:26 AM

Just tried v90 and I'm getting an Run-time error when trying to read my talents from the Armory. This is using the US armory which just added Pet Talents in case that affected something.

Also, finally figured out why MPE is always ranked below Giant's Bane in the Gear Planner. At least for weapons, the gear planner isn't factoring in sockets or using the new excess hit to agi calculations. Just adding a 16agi gem to MPE pushes it above Giant's Bane even without accounting for all the +hit.

Shandara · 07/04/09, 9:28 AM

Originally Posted by Kharthus

Just tried v90 and I'm getting an Run-time error when trying to read my talents from the Armory. This is using the US armory which just added Pet Talents in case that affected something.

Also, finally figured out why MPE is always ranked below Giant's Bane in the Gear Planner. At least for weapons, the gear planner isn't factoring in sockets or using the new excess hit to agi calculations. Just adding a 16agi gem to MPE pushes it above Giant's Bane even without accounting for all the +hit.

The changes to the Armory broke the import. I haven't had time to look at it yet.

Rivkah · 07/04/09, 3:01 PM

Thanks guys, I've fixed the EU armory import, hopefully EU will get their own pet talent support soon. Hellraza, if you save your settings and send me a PM of which they are I can try to track down the problem- I did make some bug fixes last night for chimera so doublecheck if they fixed your problem.

Shandara has been a great help with this project, sending me unlocked versions of the spreadsheet and answering my dumb questions about how calculations worked. I'm trying to keep it roughly in line with the spreadsheet version although there are bound to be some differences (such as I don't think Shandara has implemented pet expertise yet, I put an estimated version of it in my 3.2 settings).

I wasn't sure if I should start another thread since this is based off of the spreadsheet, but since there were multiple requests for it I went ahead and did so.

Aciara · 07/05/09, 3:12 AM

Sorry, found the Problem myself and omg do I feel stupid right now

Shandara · 07/05/09, 6:30 AM

Originally Posted by Rivkah

It looks like this latest PTR version added in support for the pet expertise inheriting from hit. I did some tests and it seemed to be working although I'm not sure of the scaling, but for now probably an estimated 3.25 expertise per 1% hit is probably a reasonable figure to work with if you want to include it in the spreadsheet.

My tests weren't very long but they indicated it's possible that they may have also fixed the pet hit rounding down issue that currently exists- I'll try to find some time to run tests for a longer period to see if it's really changed.

Does this include +hit gained from talents as well?

EDIT:
Update

- Nitro Boosts now +24 Crit Rating
- Talent import works with US Armory again
- You can swap between active/alternate specs more easily. Also moved glyphs to talents tab and made them swap at the same time.
- Fixed enchant calculations Melee tab
- small logic fix to pet starvation
- Pet inherit expertise for the hunter's +hit at 3.25 expertise for each 1% hit the hunter has (not counting talents as yet, NEEDS testing).
- Added setting to disable use of Kill Command
- Kill Command now consumes mana

Spamurai · 07/05/09, 10:42 AM

I noticed you didn't include the updated JC only gems when you made the updates to the other profession benefits. Here's the list, in case you just happened to forget them:

dragon's eye - Wowhead Search