WotLK DPS spreadsheet - Page 160

myuu · 05/11/09, 9:31 PM

Hi. Sorry if this has been mentioned before:-

- Custom gear import from Armory for Ranged Weapon speed seems incorrect, e.g. 2.80 becomes 0.28. It doesn't update the weapon type either, but that doesn't seem to affect anything.
- Custom ranged weapon in the Gear Planner shows as 0 dps when equipped.

sihyunie · 05/12/09, 12:23 AM

Does the spreadsheet add T8 2pc serpent sting bonus to Chimera Shot - Serpent?
There seems to be a discussion in Marks thread suggesting that it doesn't increase Chimera Shot - Serpent damage.

Also, Dreambinder doesn't seem to have socket bonus implemented.

Flexal · 05/12/09, 2:13 AM

Originally Posted by Tsook

I was thinking about how to design the UI so that it would be easier to make decisions around hit cap. The way the gear planner works currently, (assuming you are capped), it will nearly always recommend a new piece with hit for any slot that has hit in it already, and discourage a new piece with hit for any slot without hit in it already (because it simply looks at the DPS delta of subtracting the value of the stats on the current item and adding the stats of the new item). This makes it more difficult to make decisions that involve swapping more than one piece in order to stay hitcapped, or evaluate which of several hit-containing items is better in situations where you know you can maintain hit capped regardless with various banked items or gems.

"Assume 100% hit" is useful, and as was just suggested, "Assume 0% hit" could also be useful, but maybe we're thinking about the problem wrong. It doesn't matter where we get the hit from -- in some sense the dps value of hit on an item is interchangeable between items: 10 hit rating on your helm is the same DPS as 10 hit rating on your legs.

It seems like, in the gear planner, a breakdown could make this clearer: have two DPS numbers for each item. One number is how much DPS the item represents excluding the effect of hit, and the second number is just the amount of DPS that the hit on the item represents by itself (I suppose you might also want a third number which is just the total that we see today). So in a slot where you have a hit piece equipped, you can see at a glance that (e.g.) 20 of its DPS value is from the hit on it, and that other option that's 5 slots down in the list is actually much more DPS (if you can get hit capped elsewhere). I think it would still make sense to sort by the total DPS delta, just as it is today, as that's still an accurate representation of what would happen if you made that exact swap and only that swap.

Thank you for pointing this out. I have noticed the same thing also but was reluctant to post about it until I found a solution. What I have been doing lately is taking the calculated attributes values and using them as weights in wowhead. It works quite nicely but it would be great if it could be done directly in the spreadsheet itself.

Brilliant spreadsheet. Keep up the excellent work.

Shandara · 05/12/09, 2:59 AM

Originally Posted by sihyunie

Does the spreadsheet add T8 2pc serpent sting bonus to Chimera Shot - Serpent?
There seems to be a discussion in Marks thread suggesting that it doesn't increase Chimera Shot - Serpent damage.

Also, Dreambinder doesn't seem to have socket bonus implemented.

Originally Posted by myuu

Hi. Sorry if this has been mentioned before:-

- Custom gear import from Armory for Ranged Weapon speed seems incorrect, e.g. 2.80 becomes 0.28. It doesn't update the weapon type either, but that doesn't seem to affect anything.
- Custom ranged weapon in the Gear Planner shows as 0 dps when equipped.

@Shilyunie: It currently applies the bonus to both the main CS damage and the -serpent part. I'm following the discussion and will probably have to make adjustments soon (unless a blizzard dev comes out and tells us it's a bug).

@Myuu:
Run the "ranged weapons" macro button on the Gear Planner after putting in the stats for the custom weapon. The linked dps values on the gear planner for ranged weapons are static and dynamically computed like other slots.
As for the gear import from the Armory, I suspect it is some sort of localisation problem. What locale of Excel are you using?

Thuor · 05/12/09, 5:27 AM

Originally Posted by KraxisSingular

It's rather simple. It is the bane of BM being so petcentric and not having enough stats that gets transfered to the pet.
Agility is a better scaling stat, however it doesn't beat AP initially due to the amount of damage the pet does in relation to the Hunter.

A newly raiding BM will gain a lot more from AP than Agility because his pet does the amount of damage it does. But he gains new and better gear the pet will slowly lose relative DPS compared to the Hunter. And then at some point it becomes more worthwhile to boost hte Hunter's damage than the pet's.

While that might be the case but i do not touch my gear to get so diffrent results it chancges compared if I am hit capped or not. Basicly if i am missing 1 PT in hit cap the values are; Agility + 1 1,030 1,030
AP + 1 0,625 1,250
Over 1 dps per 1 aggi or 2 AP but when i get hit capped the vaues of aggi and ap fall down a lot to:
Agility + 1 0,791 0,791
AP + 1 0,384 0,767

Wich tells me that I gain a lot less from AP and Aggi before i am Hitcaped. I belive that is not the case and I wonder if that might be a bug.

My armory: The World of Warcraft Armory

Not a native speaker so sorry for misstypes

Bikiniwax · 05/12/09, 10:52 AM

Originally Posted by Thuor

Wich tells me that I gain a lot less from AP and Aggi before i am Hitcaped. I belive that is not the case and I wonder if that might be a bug.

My armory: The World of Warcraft Armory

Your armoury shows that you have just over 6.80% Hit (223 hit rating). This means that not only are you loosing a significant amount of DPS from lack of hit, your pet only has 6% hit rating (a 2% hit loss for your pet).

However, using +40 Hit food should bring you and your pt up to the hit cap (263).

Thuor · 05/12/09, 12:02 PM

Originally Posted by Bikiniwax

Your armoury shows that you have just over 6.80% Hit (223 hit rating). This means that not only are you loosing a significant amount of DPS from lack of hit, your pet only has 6% hit rating (a 2% hit loss for your pet).

However, using +40 Hit food should bring you and your pt up to the hit cap (263).

Yes i am using Hit food but still havent gotten a response whay do, when I use hit food or get hit capped by other means the value of AP and Aggi point per point fall down so much. Is that supposed to happen or is it a bug.

Spamurai · 05/12/09, 12:18 PM

First off, thank you for keeping the spreadsheet up-to-date and as accurate as possible for us. It's often a thankless job and I'm sure requires a lot more work than people think.

Anyways, I just wanted to point out that Improved Arcane Shot is not modeled in the spreadsheet.

Gorektar · 05/12/09, 1:00 PM

Originally Posted by Spamurai

Anyways, I just wanted to point out that Improved Arcane Shot is not modeled in the spreadsheet.

Not sure why you say that, it is in the calculations section of arcane shot, and you can easily check it by adding the talent points and watching the arcane shot damage change. Make sure you are actually using arcane shot in your rotation.

Spamurai · 05/12/09, 1:51 PM

You're correct. Somehow my macro security level got changed and it wasn't updating correctly in the calculations tab when updating the rotation.

My bad, thanks for the help!

Esoth · 05/12/09, 2:11 PM

Calculations!N21 has a check that effective armor is greater than 0, otherwise it just does a 0% armor mitigation. Current discussion suggests this isn't true; you can get a target to negative armor and have it act as a multiplier, meaning you do more damage than an unmitigated attack.

Kurianna · 05/12/09, 2:46 PM

Not to speak for anyone, but I believe Shandara stated that he/she was watching the discussion closely and would make the change when/if it was decided for sure, or if a blue comes out and says something specific about it. It will be interesting to see if that's the case, since our gear in Ulduar has so much ArP on it.

Shandara · 05/12/09, 2:49 PM

Originally Posted by lawjpbo

I'm working on the Rawr.Hunter update and am in need of the base stats for each race at level 80. There is some debate on the variance in base health values used on this sheet. If someone could point me to the source for these values or how they were arrived at that would be greatly appreciated.

They were mostly from in-game testing, values by myself and reports from others. They are in serious need of being re-checked, especially the lower levels.

Esoth · 05/12/09, 2:54 PM

Originally Posted by Kurianna

Not to speak for anyone, but I believe Shandara stated that he/she was watching the discussion closely and would make the change when/if it was decided for sure, or if a blue comes out and says something specific about it. It will be interesting to see if that's the case, since our gear in Ulduar has so much ArP on it.

Shandara already updated the mechanics to those expressed there, it just still has this 0 armor limit.