WotLK DPS spreadsheet - Page 131

Dralmoo · 03/30/09, 2:03 PM

I think the calculations for Armor Pen are not accurate, and result in a boss armor figure that is too low, possibly making ArP overvalued.

It looks like the 3.1 formula has been figured out here: http://elitistjerks.com/f31/t29453-c...6/#post1170842

Sartuk · 03/30/09, 4:14 PM

Originally Posted by Dralmoo

I think the calculations for Armor Pen are not accurate, and result in a boss armor figure that is too low, possibly making ArP overvalued.

It looks like the 3.1 formula has been figured out here: http://elitistjerks.com/f31/t29453-c...6/#post1170842

I'd hesitate to say they're not accurate, as they still seem to be accurate as to what the INTENTION of ArP is. From what I've read in that thread, ArP is currently broken on the PTR and not as effective as it should be. That would leave the Spreadsheet as listing the value of ArP "correctly".

Dralmoo · 03/30/09, 4:37 PM

From my reading of the thread, there are different things - first, there is 0.8 multiplier to ArP buffs (which basically seems to a lack of the promised 1.25x improvement) - but even if that is assumed to be a bug, the way that the multiplicative debuffs and the additive armor buffs combine is described by the formula, and produces a different result.

Sartuk · 03/30/09, 5:03 PM

Originally Posted by Dralmoo

From my reading of the thread, there are different things - first, there is 0.8 multiplier to ArP buffs (which basically seems to a lack of the promised 1.25x improvement) - but even if that is assumed to be a bug, the way that the multiplicative debuffs and the additive armor buffs combine is described by the formula, and produces a different result.

You're absolutely right, I had skipped over that.

Unfortunately I don't actually know how Shandara's spreadsheet is calculating it compared to how it appears to be calculated. If they are off, that could mean a rather large change in the value of quite a few Ulduar items.

Shandara · 03/30/09, 5:09 PM

What I did was take Blizzard's post that the effect of ArP was increased by 25% and apply it across the board.

While the formula devised matches the data gained from testing on the PTR, it is in my eyes doubtful that it is really supposed to work like that. Nevertheless I am keeping an eye on that thread, since what we the players find illogical often turns out to be what Blizzard actually implements.

Neruse · 03/31/09, 10:18 PM

I'm not sure if it matters anymore, but the coefficient for ExS on live is 16% (base damage is correct in spreadsheet).

Rezdan · 03/31/09, 11:28 PM

The latest spreadsheet is developed with the PTR changes. You can find a link to the latest Live version in the OP.

Neruse · 03/31/09, 11:55 PM

I am referring to the live spreadsheet. Version84 uses 14% coeff in the calculation for Explosive when it should be 16%.

In February shortly after 3.08, it was announced that a hotfix had reduced ExS to 14%. Which is in hindsight, incorrect. The coefficient was reduced to 16%, from presumably 18%. My guess is that the 16% coefficient was meant to go live with 3.08 but somehow didn't make it in.

Edit: Yeah, irrelevant.

Rezdan · 04/01/09, 2:50 AM

That version is no longer kept up to date mate. Any identified bugs won't get fixed on the Live version. Thats why the version is locked at v84.

Khallas · 04/02/09, 8:03 AM

I dont know if this has been reported or not, however, I have found sort of a bug in both the live realm spreadsheet and the PTR spreadsheet. For both spreadsheets, when you go to use the Blacksmithing only prismatic sockets in the gloves and wrists, it doesnt allow you to also have an enchant. It forces you to choose either an enchant or the prismatic socket for both slots. Since this is not how it actually works in-game, you can have both the prismatic socket and the enchant, I figured I would report this to hopefully get that updated in a future version of the sheet.

Finally, keep up the awesome work with the spreadsheet, I love it.

EDIT: I figured out a way to do it, but it becomes pretty tedious to continuously do it. If you select the prismatic socket for the enchant, then select the gem, then reselect the actual enchant for you item, it will properly display the gem in the extra socket as well as the actual enchant. It would be nice to have a slot reserved there for just the prismatic socket slot.

EDIT #2: PTR Spreadsheet: Just found that when trying to do the above to a wrist with a predefined socket, adding a prismatic socket brings up no selection box for an extra gem. This solution worked in the live realm version of the spreadsheet, so I am not quite sure what happened in the programming of the prismatic sockets between the live and PTR spreadsheets.

noglen · 04/02/09, 10:11 PM

After having played with the WWS spreadsheet alot recently, and having used the DPS spreadsheet for a long time, I was wondering if something like this would be possible.

- Add in a section to the settings page that lets us enter our efficency values that we get from the WWS sheet.
- Factor these values into the DPS calcs (the eaisest way I would think would be to just multiply the efficency value by the Spammed DPS value for each shot)

This would give us the option to build models with an essence of our own skill built into it, instead of just having a model based on what you can do in a perfect situation.

As an example of the sort of information i'd like to get from this...

From the WWS sheet, i seem to average about 85% efficiency on my ES. This comes down to my skill/lag/etc and isn't something I can eaisly change (obviously skill is something to work on, but we all have our own skill caps - not eveyone can be perfect).

So from that, what i'd like to be able to do is compare say an SV spec (assuming my less than perfect rotation), to say a BM spec (where I can get a rotation alot closer to perfect). In theory SV (with todays numbers) seems higher, but in reality, this may not be the case (for an individual).

Obviously applying a % to the DPS of each shot wouldn't be 100% accurate (eg. Having say 80% up time on serpent sting would (may) in reality affect LnL procs, and that isn't really something you can model - since it all depends on when serpent sting was up and when it was down) but imo it would help to create a more accurate model for the individual player.

RafUbi · 04/03/09, 4:44 AM

Question regarding Focused Aim:

Shouldn't points in FA only affect hunter dps?
When I increase points in FA the pet dps is also increased, but from what I've read hit % from FA isn't transferred to the pet.

Rezdan · 04/03/09, 4:56 AM

Hit from FA is carried over to pets on the PTR. The latest spreadsheet reflects the current PTR changes.

RafUbi · 04/03/09, 6:05 AM

Originally Posted by Rezdan

Hit from FA is carried over to pets on the PTR. The latest spreadsheet reflects the current PTR changes.

Ah, that's nice!

Must have missed that change. Any place this is documented/confirmed by Blizz? Can't find it in the 3.1 patch notes, but probably one of many hidden changes.

Desperada · 04/03/09, 10:28 PM

I'm messing around with the PTR version of the spreadsheet and noticed something odd. While adjusting my spec by speccing into rapid recuperation my pet dps increases in the top left hand box. Its a roughly 54dps increase for the first point and nothing for the second point, yet looking on the PTR version of the talent there is nothing there to actually affect pet dps. Is this potentially a bug in the coding?