DPS Warrior Spreadsheet - Page 11

Deathwing · 08/03/06, 7:05 AM

Skill is capped for the affect on glancing blow's damage. 0 for 61's, and +5 for each level up. However, that's the only cap I implement. If you have +12 skills, you still get the full bonus from it's affects on +hit/crit and -enemy dodge

orgasmatron · 08/03/06, 7:31 AM

Yeah no effect on glancing blows after 10 skill I understand, its just that the 0.08 crit and I guess 0.08 less chance to dodge for +2skill giving me 7 more dps seems a lot :) Since I typed in weapon skill manually(both in the final field and in the weapon skill field on top) I migth have messed soemthing up.

sp00n · 08/03/06, 7:50 AM

Most likely the calculation for the glancing blows.

Celandro · 08/03/06, 11:59 AM

I added some threat numbers to my heroic strike sheet.

I think that adding threat numbers would be useful. Both for knowing how much threat a certain style of play (heavy heroic strikes) will generate and how much threat you can generate when tanking. The same type of methodology can be used but you have to add tank gear, agro per attack and defensive attacks such as sunder armors/shield bashes/revenges/shield blocks. You can get agro per attack from KTM in the KTM_Data.lua file.

Deathwing · 08/03/06, 12:14 PM

I was thinking about adding that Celandro. I'm almost done with my next release, just gotta finish up the execution cooldown field.

Celandro · 08/03/06, 12:45 PM

I was also thinking that you should be able to do the total dps numbers by adding up the dps from all the individual attacks. All that you are missing is an execute spam row to go with your 100 rage execute number.

Khalim · 08/04/06, 2:57 AM

WTB next version and deathwing's simulator :)

link to new version of hs spreadsheet celandro

Celandro · 08/04/06, 3:22 PM

Originally Posted by Khalim

WTB next version and deathwing's simulator :)

link to new version of hs spreadsheet celandro

new sheet same as the old sheet

http://www.rcsolid.com/poseidonguild/HeroicStrike.xls

The threat per rage numbers are pretty interesting.

Deathwing · 08/04/06, 3:36 PM

New version of the spreadsheet before I go out of town tomorrow.

More item fixes
Added cooldown field for trinkets
Modeled MSA, estimated at 3.5PPM
Added MS and SS modeling
Fixed "DSP sans execute" field, was multiplying yellow damage by .8
Changed flurry calcs to take into account DW weapons of the same speed

http://www.savefile.com/files/7291559

Celandro, take a look at the Final Flurry calcs, it's different than what you suggested, but I think this is more accurate.

Execute spamming isn't 100% accurate. I still need to work in the case of Fast MH/Slow OH/No Imp Exe.

I'll try to put in the threat numbers for next release. Also, radiante suggested I use checkboxes for the ability cooldowns. Anyone know how to use those?

Walsk · 08/04/06, 3:59 PM

Since I'm in love with this spreadsheet, I'm trying to make this sheet more of a general Warrior sheet instead of being so Fury focused. Deathwing has already done all the hard work. :)

In the future I'd also like to take the info from ThreatMeter and calculate a "Threat Per Second" value. Again most of the groundwork is already there.

I went through and fleshed out Arms a little (I won't touch Deep Wounds unless I'm really bored). I put in super quick 1h Spec and Shield Slam as well. I've though of going through the armor to include +block value. Right now it's just done as a couple fields where the user enters their Strength and +block value from gear. Where did all the gear data come from? I sure hope it was imported from somewhere. Then again shields shouldn't be too hard to manually add since there aren't very many raid quality shield choices.

Sword Spec is the only fun one to calculate. I'm cheating and basically stole the HoJ calcs. I haven't yet accounted for Sword Spec and HoJ not being able to proc off each other so it isn't entirely accurate. From the patch notes sometimes I don't think even Blizzard knows how Sword Spec, HoJ, Windfury, weapon procs, and on equip procs really interact with each other.

Sword Spec is my personal "jboots are slower this patch!" of WoW.

One question since I haven't audited any formulas too closely. In the DPS sheet is there a cap on the number of Overpowers that can be performed, based on your attack rate and the dodge chance in your hit tables, or is it all based on the user's OverpowerCD estimate?

You have all the necessary info in the Calcs sheet to calculate frequency of your target's dodges and thus the average limit for OverpowerCD based on your attack rate. Over a 5 min fight that should be pretty accurate.

I'll probably wait till the next version of Deathwing's sheet to start adding things in as clean as possible, using the same schema (and changes tracked). Adding in a couple Arms abilities didn't take long at all. This is a very solid sheet!

I don't mean to step on anyone's toes, but this is by far the best Warrior combat model I've ever seen.

Edit: Oh snap, new version posted!

Deathwing · 08/04/06, 4:11 PM

Overpower is just based on what they put for the cooldown.

I'm more than willing to implement any suggestions you have, as long as they are reasonable. I'm not going to make a DPS spreadsheet for level 30.

You can alter the spreadsheet however you feel, but I feel it's a sticky situation if you release your alterations as well. In itself, I really don't have a problem with people releasing their own versions, but that can lead to a lot of other situations, and then people might have their toes stepped on. I feel keeping the spreadsheet releases under one person will avoid a lot of trouble.

I added a small thanks to the EJ forums this latest release, but I've never done something like this, so I'm not sure what's appropriate. Should I put player's names next to suggestions that were their's?

Vanick · 08/04/06, 5:31 PM

Currently if you do not select an offhand weapon (i.e. you are trying to model DPS with a 2H weapon) many #DIV/0! errors occur. Not sure what's causing this, as I just downloaded the new version.

Edit: It may be coming from the YellowConnects field.

Walsk · 08/04/06, 5:39 PM

This was for my own messing around basically. I don't intend to release it as this is your baby.

Once I got really into the spreadsheet, I realized you accurately modeled the vast majority of Warrior combat including all of the trickiest calculations (Flurry, HoJ, Windfury). Almost anything else can be added on top of your core calculations without too much difficulty.

I just started by thinking "How does 31/5/15 with Sword Spec hold up at various gear levels?", "What kind of DPS can a prot build do?", "How often can you actually use Overpower and what kind of realistic DPS do you get from Improved Overpower?", etc.

Thorb · 08/04/06, 5:42 PM

Yeah please add mortal strike. It's trivial to add, it's ton easier then execute/flurry that are in it already. Axe spec is a no brainer, sword spec is like hoj, should literally take 10 min.

Other thing that would be nice is a box where you can specify your stats without having to select all the gear, maybe pre-buff. I have 1000 atk power, 25% crit, how much should I do with those buffs and those talents? Etc.

Celandro · 08/04/06, 6:20 PM

Originally Posted by Deathwing

Overpower is just based on what they put for the cooldown.

I'm more than willing to implement any suggestions you have, as long as they are reasonable. I'm not going to make a DPS spreadsheet for level 30.

You can alter the spreadsheet however you feel, but I feel it's a sticky situation if you release your alterations as well. In itself, I really don't have a problem with people releasing their own versions, but that can lead to a lot of other situations, and then people might have their toes stepped on. I feel keeping the spreadsheet releases under one person will avoid a lot of trouble.

I added a small thanks to the EJ forums this latest release, but I've never done something like this, so I'm not sure what's appropriate. Should I put player's names next to suggestions that were their's?

Some fixes/changes/additions for you
Insert Row at line 61 (Total RPS will move to line 62)
Insert Row at line 66 (Rage Generated will move to line 67)
Insert Row at line 68 (Fight Duration? will move to line 69)

Heroic strike changes to optimize rage usage:
E55 =MAX(FinalSpeed,(15-D76+(1-MobMitigation)*WhiteHitMod*(BaseDamage+NetAP/14*BaseSpeed)/30)/
MAX(0.0000000001,(RagePS-D52-D53-D56-D59-D57-D60-100/(FightDuration*0.8))))
F55 <----Equation here, look before changing

100 rage Execute chages
A58 Big Execute
D58 = 100/E58
E58 = 1.5
F58 moved to F61

Execute spam changes
A61 Execute Spam
B61 =(600+15*(D61*E61-15+2.5*B83))*YellowHitMod/(D61*E61-15+2.5*B83)
C61 =(600+15*(D61*E61-15+2.5*B83))*YellowHitMod/E61
D61 =RagePS
E61 =MAX(MAX(1.5,FinalSpeed),(15-2.5*ImpExe)/RagePS)

Total dps changes
B64 =0.8*B65 + 0.2*B66 +
A66 DPS execute spam
B66 =MHWeaponProcDPS+OHWeaponProcDPS
+THWeaponProcDPS+Trinket1DPS+THEnchantDPS+OHEnchantDPS+MHEnchantDPS+WhiteDPS+C61

Rage Used Calc
A67 Rage Used
B67 =D62*0.8*FightDuration + D58*E58 + D61*0.2*FightDuration

This should make it far easier to understand what is going on. You get 1 100 rage execute which you have saved up rage for by modifying your heroic strike spam and then you spam execute

I still need to work on a fix for trinkets, deathwish and recklessness. Basically what I would like to do is model the stacking of deathwish + recklessness + any trinkets to maximize the RagePS available for execute spam and increase the yellow hit mod for execute spam.