Warrior DPS Calculation Spreadsheet - Page 10

ebs2002 · 12/29/08, 3:58 PM

I take the full white damage without heroic strikes, and then add the amount of DPS doing heroic strikes on the calculated frequency of main hand attacks does. What's wrong with doing that?

The problem is that the damage you're reporting to your 'total dps' (and also, the percentage break-downs...ie, white damage doing X%, deep wounds doing Y%), is off. I'm seeing 1400dps in white hits alone; comparing it to a WWS that has 900dps in white hits. All the other numbers are close enough to make me believe the calcs are correct, except that white damage is far too high. This also makes the damage breakdowns (ie, "how much of my DPS would be from Deep Wounds?") off, because there's an extra 500dps in white damage floating there that shouldn't be (as an example). This double-counting of white damage could also be affecting SEPs (the whole reason I even started looking at this was to determine haste-vs-hit-vs-ArP at various gear levels, to help in a fury guide being written at TankSpot)

The method you are taking to calculate how much DPS you gain from Heroic Strikes seems correct to me. The final damage for your HS damage looks right. The final value for your white damage is not. If you change the white damage number, though, it causes your heroic strike damage to change. Therefore, my solution is to store two values: one is WhiteDPSNoHS, and one is WhiteDPSWithHS. Your heroic strike calcs read off of NoHS, but everything else should read off of WithHS.

yojoe · 12/29/08, 5:57 PM

Maybe I'm blind but I can't seem to find the total unbuffed AP column on the spreadsheat? The only unbuffed stats I see are Haste, Hit, Crit, ArP and ExP.

landsoul · 12/29/08, 6:05 PM

ebs2002, what you are seeing is the effective DPS heroic strikes add onto the white DPS, not the actual full heroic strike damage itself. This is where I think you are confused. There is not extra damage floating around. I reverse engineered the percentages in the damage spread to correctly display like it does in a recount.

On another note, you did spark me to look at those calculations more deeply again. I did see that I failed to divide the heroic addition dps by the average main hand speed, which made it too high. I also did not find the difference in crit damages between white and heroic correctly. This I am fixing. There's just too much going on sometimes and It's hard to notice when I make a mistake sometimes, and it can go unnoticed for a long time. For this I apologize.

I am also trying to find a way to do what you mentioned ebs2002, however to do this all the numbers must line up correctly. That is what I am doing now.

landsoul · 12/29/08, 11:51 PM

New update linked on filefront. Check the front page for updates.

Grayson Carlyle · 12/30/08, 4:33 PM

Mucho gracias. Hit is considerably higher on SEP now after the soft-cap, but not so high to warrant socketing/enchanting for it. The TG miss rate change considerably alters the item choices though.

polocabbit · 12/30/08, 11:30 PM

Found a missing socket bonus: 4 Armor Pen.

I attempted to add this in myself, but when I did and ran the SEP button all values turned into an error.

landsoul · 12/31/08, 1:15 AM

Ok, thanks I'll add that in the next version

Sami · 12/31/08, 5:13 AM

Base stats for lvl 80 Draenei

9521 hp

570 ap (3 ap with AttT included)

175 str
110 agi
158 sta
220 ac

Edited for clarification

Pogues · 12/31/08, 5:20 PM

I just downloaded the new version and when I tried to use the sort button on the lookup page a receive an error saying "Run-time error 438 Object doesn't support this property or method". Is there something I have done wrong? I recall using this feature before and not having this problem.

• Darkmyst · 01/02/09, 12:19 AM

It would be nice if there was a "what if" section that let me manually adjust stats for calculations (e.g +XX hit, -XX str, etc...)

This occurred to me the other night when Bandit's Insignia dropped and I wanted to see how much of an upgrade over Grim Toll it was. Just swapping them out was a wash in DPS because of the 83 Hit rating I was losing. In cases like that it would be nice to be able to manually fudge stats so that you can get a better judge on what kind of upgrade a piece of gear is.

80 Troll stats (with ATT)

175 Str
115 Agi
160 Sta
230 AC
573 AP

ebs2002 · 01/02/09, 12:58 PM

ebs2002, what you are seeing is the effective DPS heroic strikes add onto the white DPS, not the actual full heroic strike damage itself. This is where I think you are confused. There is not extra damage floating around. I reverse engineered the percentages in the damage spread to correctly display like it does in a recount.

This confuses me a little bit. If I understand you correctly, the heroic strike damage (and percentages displayed) is actually the heroic strike ADDITION, and not the actual DPS you get from using Heroic Strike. In other words:

Assumptions (I know these numbers are made up and not actual, it's just for modeling)
- White swing does 3k base
- Heroic Strike adds 1k dmg to a white swing
- Swing timer is 3secs

If I have no rage for heroic strikes, I'd do 1k DPS white, and 0 DPS heroic strike
If I can HS on 50% of my swings, I'd do 500 DPS white, and 667 DPS heroic strike
If I can HS on every swing, I'd do 0 DPS white, and 1333 DPS heroic strike

Recount and WWS would show me doing those values.

However, what you're displaying is that you do 1k DPS white regardless, and then either 0, 167, 333 DPS heroic addition?

If that's true, then it seems like everything that you're doing is correct, just displaying the White/HS DPS differently, which would indeed account for the discrepancies I'm seeing when comparing your sheet's results to a WWS report.

I did see that I failed to divide the heroic addition dps by the average main hand speed, which made it too high. I also did not find the difference in crit damages between white and heroic correctly. This I am fixing. There's just too much going on sometimes and It's hard to notice when I make a mistake sometimes, and it can go unnoticed for a long time. For this I apologize.

No need to apologize at all. I'm glad that at least my efforts are helping somewhere.

I apologize if it seems like I'm criticizing your work. I appreciate all the hard work you've done here. I'm just a Test Engineer professionally and, as I really love the utility this sheet provides to me personally, I want to do whatever I can to help make it the best tool I can.

If you want me to back off, feel free to let me know and I'll stop. Consequently, if you want me to give you a second set of eyes on anything that you're doing here or in the future, please feel free to ask.

It would be nice if there was a "what if" section that let me manually adjust stats for calculations (e.g +XX hit, -XX str, etc...)

Just want to second this. The "manual additions" was a feature in the 2.4 sheet, and it was great for quick calcs (just inputting someone's unbuffed stats, weapons, and proc effects like weapon enchants/trinkets). Rather than going through the hassle of selecting each individual piece of gear/gem/enchant.

I used it a lot to find out what SEPs are like at different gear configurations (too much hit, low crit, high haste, high ArP, etc).

Unfortunately, it's not a quick 5min fix because of the way the SEP macro works presently, although I'm sure landsoul's Excel-fu is better than mine

ebs2002 · 01/02/09, 1:06 PM

oops double post.

Sore82 · 01/03/09, 12:53 AM

Very nice spreadsheet!

I was wondering if you could add a feature that auto looked up your gear/talents from using the armory? I use the Hunter DPS Spreadsheet (its on EJ as well) for much the same reason as im sure many Warriors use this one - and it has that feature. Its just an extra feature that makes using the spreadsheet that much easier.

Thanks for the time and effort you put into making this.

aylene · 01/03/09, 2:28 AM

Thanks for your efforts Landsoul.

However, I would advice you to make a dropdown-box for the racial expertise activator for people like me who aren't used to Excel except for the occasional spreadsheet. I'm assuming the value in the mainhand and offhand cells should always be binary after taking a look at the I73 and I74 cells; 3*L24 in I73 and 3*L25 in I74 to make up for the "1" (or 0 for that matter) chosen in the already mentioned main- and offhand activator. Only reason to why I looked that up was that I was inserting a "3" in both the mainhand and offhand racial activator since the racial is indeed worth 3 expertise. I was then obviously getting extremely low values of SEP on expertise since the racial was multiplied 3 times over its value.

Or perhaps just make a note somewhere that the number inserted should be either 0 or 1.

landsoul · 01/03/09, 3:02 AM

Actually, I do that a lot for internal testing for this. I go in and fudge stats in random places to see what happens and to see if the sheet doesn't break. Adding a box for people who don't have Excel-fu would be easy. I'd go in and add like 10k attack power and see how crit or arp or SEP goes to. As far as armory input goes, I don't really know, it would be buggy a lot (at least when I would set it up) and you aren't always logged out in Armor on the set you want to look at. Does it take you more than 1 minute to input your items/gems?

About second eyes, I really don't mind them, because there isn't really anyone to watch my back when I make errors. It also forces me to think that maybe I'm not 100% right all the time, which is a very good thing. I may be able to understand or breakdown one feature personally, but someone else might not be able to get it. Things like this just make the tool better.

Also, I think I'm to the point to redo the layout of this thing, because its getting very cluttered. How would you like to see this layed out? What colors or tones would you like to see? How would you like all of the options arranged? Is having everything on one page useful or not useful? Is it annoying to scroll around everywhere to find a box you need because your screen is too small? Do you want a subtle background backdrop again? Input like this helps me.

I also need someone to help me figure out how to fix the sort macro for Excel 97 users. That would be awesome and I could take it out of beta.