WotLK DPS spreadsheet - Page 161

Shandara · 05/12/09, 5:02 PM

Update:

- Fixed Pawn gem dps for crit/hit
- Wowhead talent import now also gets the glyphs
- Pet Armor reduction debuffs now get added properly to the hunter's again
- Effective Armor can now be negative
- Changed Calculate Attributes to be faster concerning haste
- Fixed bug with gear planner's 2nd trinket slot reading dps values from the wrong column
- CS serpent not affected by 2t8
- Socket bonus on Dreambinder
- Silencing Shot displays average non-crit/crit damage on the shot rotation tab now
- Rotation Test now is able to wait on ES/CS, set value to how long you'd wait at the most

Grimgagorim · 05/12/09, 5:19 PM

Hi,

first, thanks for the work. Even if i can´t use the spreedsheet completly (i use openoffice ) it helps alot.

I found in the newest version 2 missing items. The board search function told me, they haven´t been posted yet as missing:

First one is Iron-studded Mantle [Iron-studded Mantle]
Second is Twisted Visage [Twisted Visage]

Shandara · 05/12/09, 5:41 PM

Originally Posted by Grimgagorim

Hi,

first, thanks for the work. Even if i can´t use the spreedsheet completly (i use openoffice ) it helps alot.

I found in the newest version 2 missing items. The board search function told me, they haven´t been posted yet as missing:

First one is Iron-studded Mantle [Iron-studded Mantle]
Second is Twisted Visage [Twisted Visage]

These should be in the sheet (and have been since a version or 2 ago).

Esoth · 05/12/09, 6:16 PM

Thanks Shandara, this confirms a couple of questions I've been pondering about ArP.

1. With these assumed mechanics, at least without shattering throw, SS/FF is never a DPS loss even if we're hit capped, as some have argued.
2. At around 3650 armor pen, this formula simply breaks down. This is because the value of (1-armor/(armor-22167.5 + 37400)) is going into the negative. Not only do you have negative armor, it is so negative that the denominator is negative. 37400-22167.5 = 15232.5, the constant for level 80 used in the ArP formulas. I'm wondering if something is missing or if this really would be theoretically possible, but we just don't have 3650 available so it's moot.

I came up with this little plot graph using the formulas in the spreadsheet: http://spreadsheets.google.com/ccc?k...1Z8P6cXU2GGa1g

Daymaker · 05/12/09, 7:49 PM

Setting "hide downgrades" to "yes" seems to hide everything in second ring, both trinket and both melee weapon tables (two-hander equipped), no matter what their DPS delta is.

DoomSpirit · 05/12/09, 9:22 PM

Coul you please fix "glyph of aimed shot" (-2s CD on aimed shot)
and maybe an option to have the choice of using aimed shot every 9s then (and not 8)

It just writes a non available symbol

thx

edit : wtf, I was changing some stuff and the glyph just worfed then O_o

maybe some bug or I don't know :o

myuu · 05/12/09, 11:02 PM

Originally Posted by Shandara

@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?

Actually I did that as well, but after the calculations it still ends up 0. I'm using a green quest item Bow of Bone and Sinew - Item - World of Warcraft.

Excel locale is US (not sure where to check this but everything's in English :P). Version is Office Excel 2007 12.0.6341.5001 SP1 MSO 12.0.6230.5000. OS regional setting is also English (US).

I tried to see if it could be anything to do with my security settings, so I chucked the spreadsheet into a trusted location but i still get the same issues.

Edit:
I might've misread your response. Ranged weapon DPS in Gear Planner is static, and therefore custom weapons will always be zero, is that what you mean?

Luk · 05/13/09, 4:01 AM

Would it be possible to link shot priorities to different specs rather than changing the shots manually every time I switch specs in the spreadsheets?

Snaile · 05/13/09, 5:04 AM

Originally Posted by Luk

Would it be possible to link shot priorities to different specs rather than changing the shots manually every time I switch specs in the spreadsheets?

I'm sure this works if you save a profile for each spec

KraxisSingular · 05/13/09, 6:37 AM

I'm an avid user of the spreadsheet, so once more I'll thank you for taking teh time to manage it Shandara.

I have a small request. Could you make it so we can somehow untick setbonusses? I am currently using two pieces of T7, shoulders and chest. The new T8 chest is vastly better so it defeats not only the original T7 chest but also the T7 bonus (for Survival). However the T8 shoulders do not (unless you are not hitcapped), and neither does any other shoulder in the game atm. This makes shoulder upgrade planning somewhat heavyhanded in that I need to change my chest to something else to see which shoulders would technically be an upgrade outside the set. I need to break it at some point.

Whitemane · 05/13/09, 7:33 AM

Originally Posted by KraxisSingular

I'm an avid user of the spreadsheet, so once more I'll thank you for taking teh time to manage it Shandara.

I have a small request. Could you make it so we can somehow untick setbonusses? I am currently using two pieces of T7, shoulders and chest. The new T8 chest is vastly better so it defeats not only the original T7 chest but also the T7 bonus (for Survival). However the T8 shoulders do not (unless you are not hitcapped), and neither does any other shoulder in the game atm. This makes shoulder upgrade planning somewhat heavyhanded in that I need to change my chest to something else to see which shoulders would technically be an upgrade outside the set. I need to break it at some point.

Does that really interfere with picking another upgrade? The set bonus should not shift the ordering of the other items in the gear planner, so it should still be perfectly usable?

KraxisSingular · 05/13/09, 7:50 AM

Well, considering I'm looking at downgrades of about 40 DPS for each of the highest shoulders it becomes a little muddy what is what really. Just because the ranking might be the same doesn't mean they are actually upgrades. Just look at the rings and weapons. There you can find negatives easily ranked above your current gear.
Ah, but then the logical reply would be to tick the Hitbox, which is true enough, but this is the same really. If one is needed then I can't see why the second isn't at least comparably useful.

[EDIT]
Apparently the wording on Piercing Shots is so poor that most of us managed to misunderstand it. Two sources (one test by Rilgon an MM blogger and confirmed in the MM thread) now claim that the Mangle debuff does in fact boost the bleed.

Whitemane · 05/13/09, 12:45 PM

Originally Posted by KraxisSingular

Apparently the wording on Piercing Shots is so poor that most of us managed to misunderstand it. Two sources (one test by Rilgon an MM blogger and confirmed in the MM thread) now claim that the Mangle debuff does in fact boost the bleed.

And if I understood how the spreadsheet works, this is currently not modeled. Trauma/Mangle debuff does not modify the piercing shot calculations at the moment. This needs to be fixed. Can you confirm Shandara?

tict · 05/13/09, 1:50 PM

Shandara, I read thru the thread and maybe I missed comments on the t7 2pc bonus changes (I just saw your comment about the PTR). But when I change out 2pct7 (as an example) in game my pets AP goes down by 95 (2336 to 2241 for example). The piece I am replacing (legs) with is the saronite mesh legs which are definitely no slouch for pet stats.

On the spreadsheet my pets base AP with the same 2pct7 is 23AP LESS then with the same saronite mesh legs. Of course buffs are involved on the spreadsheet versus on live when I tested. But you mentioned the 5% AP PTR buff (removed from the spreadsheet) with the bonus and it seems like I am seeing it on live unless I am missing something simple. Obviously it would seem like a bug but IDK.

Thoughts? Obviously this comes up because the spreadsheet says I can break my 2pct7 for the saronite mesh legs....but can I....

Thanks again for all the work on the sheet

Kurianna · 05/13/09, 1:53 PM

Originally Posted by tict

Shandara, I read thru the thread and maybe I missed comments on the t7 2pc bonus changes (I just saw your comment about the PTR). But when I change out 2pct7 (as an example) in game my pets AP goes down by 95 (2336 to 2241 for example). The piece I am replacing (legs) with is the saronite mesh legs which are definitely no slouch for pet stats.

On the spreadsheet my pets base AP with the same 2pct7 is 23AP LESS then with the same saronite mesh legs. Of course buffs are involved on the spreadsheet versus on live when I tested. But you mentioned the 5% AP PTR buff (removed from the spreadsheet) with the bonus and it seems like I am seeing it on live unless I am missing something simple. Obviously it would seem like a bug but IDK.

Thoughts? Obviously this comes up because the spreadsheet says I can break my 2pct7 for the saronite mesh legs....but can I....

Thanks again for all the work on the sheet

I had to try this, just to see, and for MM, if I replace my t7 leggings with the Saronite Mesh Leggings, leaving myself with 1 pc t7, I still gain over 20 spread sheet dps. I'd also love to know if this is really ok, since I thought the 2pc bonus would still be great for MM and SV.