Jump to content

  • Curse Sites
Help

Veev's Warrior PvP Spreadsheet


  • Please log in to reply
16 replies to this topic

#1 Veev

Veev
  • Premium Junkies
  • Curse Premium
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 236
  • Talents: Arms 0/1/2/1/1/0
  • RBG: 1928

Posted 17 October 2012 - 09:31 AM

Primary link: http://www.veevsvaul...pvppower_ss.xls (.xls file, requires Excel, recommended)
Secondary link: http://www.editgrid....arr_pvppower_ss (does not support drop down functionality, not recommended)

This is a simple spreadsheet I've made to help determine the relative value of PvP power for warriors.  It is also useful for helping you determine how to gem, which socket bonuses to use or ignore, which honor/conquest pieces to purchase, and which stats to reforge.

If you're not familiar with WoW spreadsheets, then I'll do my best to try to give a quick explanation of how it works.  I use a popular tool called SimCraft to generate values for how much one point of every stat gives in DPS.  This is mainly a PvE tool, but I try to configure it to more closely resemble a PvP fight.  For me (personally), this means: setting enemy level to 90, using "helter skelter" combat mode (chaotic and PvP-like movement/uptime), average fight length to 200 seconds, only using the buffs and debuffs that my 3v3 has available (10% attack power, 5% stats, and 4% physical vulnerability), using defensive stance, and removing all food/flask/potion buffs, etc.  SimCraft is responsible for the bulk of the math actually going on here, I am just taking the values that it spits out and incorporating some PvP stats into it.  Please note that if your gear differs from mine, or if your arena team's buffs/debuffs differ from mine, your stat values will be different.  How different?  It's hard to say without fully simulating it.  You can either use my stat values and hope they're relatively close to yours, or you can import your own character into SimCraft and run your own simulation.

The primary goal of this entire spreadsheet is mainly the Wowhead link that it provides at the bottom.  This link is setup to rank gear in ascending order, while showing you which gems would work best in them (note that the recommended helm gem seems buggy, but the rest should be accurate).  And one of the more valuable purposes of these stat weights is to see how PvP power currently compares to your other stats.  Increase your current PvP power and you will notice that its value (or stat weight) will decrease in comparison to others.  (But remember that both strength and PvP power scale off of each other, so as you get future gear upgrades you will need to re-simulate.  I will be updating the spreadsheet with my own values every so often.)  No more wondering, or just assuming, how PvP power stacks up against strength or crit gems!

Another interesting stat is resilience.  Since resilience is a defensive stat, it is difficult to put an exact value on it when compared to offensive stats.  I created a drop down menu for you to choose how much you value resilience (which is going to depend entirely on your comp, play style, and personal preference).  By default I have chosen to make it equal to crit (for a balanced build), but if you change it to be equal to mastery (glass cannon), you will notice that it will advise you to skip over many of the resilience socket bonuses.  If you set it back to be crit, you should notice the Wowhead link telling you to utilize more of the socket bonuses again.

The rest of the spreadsheet is pretty self-explanatory.  I have set expertise to be worth zero since I am currently expertise capped while reforging entirely out of it.  Hit I have set equal to mastery, since those are the two stats that are interchangeable when it comes to reforging and trying to get close to 3.00%.  Don't be afraid to play around with manually adjusting any of these values.  If you don't have Excel, you will probably need to upload the .xls file on your own EditGrid account (to actually be able to edit the cell contents).

Questions/comments/feedback welcome.

#2 Hyuru

Hyuru
  • Junkies
  • Humanclass_name
  • EU-Outland
  • Misery
  • Posts: 9219
  • Talents: Subtlety 1/2/2/0/0/0
  • RBG: 2237
  • LocationNOT EVEN EU

Posted 17 October 2012 - 10:17 AM

First, and I love you.

#3 hirtqt

hirtqt
  • Junkies
  • Undeadclass_name
  • US-Bleeding Hollow
  • Ruin
  • Posts: 994
  • Talents: Discipline 2/0/1/1/1/1
  • RBG: 732

Posted 17 October 2012 - 12:18 PM

Second, and I love you all.
Posted Image
Posted Image

#4 Braindance

Braindance
  • Junkies
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 3673
  • Talents: Arms 1/1/1/1/1/2
  • 2v2: 1638
  • 3v3: 2172
  • RBG: 576
  • LocationAtlanta

Posted 17 October 2012 - 03:44 PM

I don't want to get into specific math here (due the very limited time I have right now), but in order to get a more educated guess on how stats compare to each other, it would be wise to run different combat scenarios ranging from 10% uptime to 90% uptime with different combat times. I am confident that you will get different numbers for each scenario, since, given the probabilistic nature of crit; changing the above variables will result in a different relative crit value, which in turn will change the relative values of all the other stats.

Therefore my suggestion to anyone using the modified SimCraft, is to tun it more than once, by changing stats one at a time, in different time windows, in order to generate a "bulk" of results that will give you a better idea of what stat is superior in which case. This way, you will be able to more effectively gauge what is best for you.

View Postjustchecking, on 10 November 2014 - 11:58 PM, said:

Going to blizzcon looking for a fight is like going to the official wow arena forums for pvp advice :)

View PostRenaissance_Man, on 31 July 2013 - 04:31 AM, said:

If I had a gun with two bullets and I was in a room with Hitler, bin Laden, and you, I would shoot you twice.

View Postsimonfra1234, on 25 August 2011 - 08:46 PM, said:

bro you got +rep'd by rapture...

#5 Veev

Veev
  • Premium Junkies
  • Curse Premium
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 236
  • Talents: Arms 0/1/2/1/1/0
  • RBG: 1928

Posted 17 October 2012 - 09:41 PM

View PostBraindance, on 17 October 2012 - 03:44 PM, said:

I don't want to get into specific math here (due the very limited time I have right now), but in order to get a more educated guess on how stats compare to each other, it would be wise to run different combat scenarios ranging from 10% uptime to 90% uptime with different combat times. I am confident that you will get different numbers for each scenario, since, given the probabilistic nature of crit; changing the above variables will result in a different relative crit value, which in turn will change the relative values of all the other stats.

Therefore my suggestion to anyone using the modified SimCraft, is to tun it more than once, by changing stats one at a time, in different time windows, in order to generate a "bulk" of results that will give you a better idea of what stat is superior in which case. This way, you will be able to more effectively gauge what is best for you.

Rather than just simulating extremes (from 10% uptime to 100%), I think it is best to simply simulate what your average uptime is.  Considering I never have 10% uptime (and it's usually something probably closer to 75% or 80%), those 10% statistics would really carry no significance, and would actually only distort the real stat values.  Now you could argue that you should simulate 75% uptime, 80% uptime, and then combine the two, which may give slightly different results from just simming 77.5%, but that's probably being a little too picky for this project.

Another known "flaw" with these stats is that as game duration changes, stat values will change.  If all of your games are over in 20 second because of lolavatar, then crit would be worth quite a bit less than what is shown here.  But I took the fact that most of my games seem to end around when my second avatar comes up, so using 200 seconds with a built-in 20% variance should be fairly accurate for everything except the 5 second faceroll matches (which I'm not going to build my stats around anyway).

And regardless of all of this, the spreadsheet was designed to allow users to easily submit their own SimCraft values.  So if someone wants to mess around with uptime/game duration/etc., they absolutely should, and they should share their results.

#6 Hackattack3

Hackattack3
  • Junkies
  • Undeadclass_name
  • US-Darkspear
  • Cyclone
  • Posts: 985
  • Talents: Destruction 1/2/0/1/0/0
  • 2v2: 1609
  • 3v3: 1792
  • RBG: 2050

Posted 17 October 2012 - 10:04 PM

View PostGodx, on 17 October 2012 - 02:12 PM, said:

third, and you just put way to much extra thought into a one shot macro class.

+rep

#7 Braindance

Braindance
  • Junkies
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 3673
  • Talents: Arms 1/1/1/1/1/2
  • 2v2: 1638
  • 3v3: 2172
  • RBG: 576
  • LocationAtlanta

Posted 17 October 2012 - 10:09 PM

View PostVeev, on 17 October 2012 - 09:41 PM, said:

Rather than just simulating extremes (from 10% uptime to 100%), I think it is best to simply simulate what your average uptime is.  Considering I never have 10% uptime (and it's usually something probably closer to 75% or 80%), those 10% statistics would really carry no significance, and would actually only distort the real stat values.  Now you could argue that you should simulate 75% uptime, 80% uptime, and then combine the two, which may give slightly different results from just simming 77.5%, but that's probably being a little too picky for this project.

Another known "flaw" with these stats is that as game duration changes, stat values will change.  If all of your games are over in 20 second because of lolavatar, then crit would be worth quite a bit less than what is shown here.  But I took the fact that most of my games seem to end around when my second avatar comes up, so using 200 seconds with a built-in 20% variance should be fairly accurate for everything except the 5 second faceroll matches (which I'm not going to build my stats around anyway).

And regardless of all of this, the spreadsheet was designed to allow users to easily submit their own SimCraft values.  So if someone wants to mess around with uptime/game duration/etc., they absolutely should, and they should share their results.

My point was referring exactly on extremes like the 20-second win (which from what I hear is not a rare occurrence these days).

PS: I was quoted by Veev - I feel somebody

View Postjustchecking, on 10 November 2014 - 11:58 PM, said:

Going to blizzcon looking for a fight is like going to the official wow arena forums for pvp advice :)

View PostRenaissance_Man, on 31 July 2013 - 04:31 AM, said:

If I had a gun with two bullets and I was in a room with Hitler, bin Laden, and you, I would shoot you twice.

View Postsimonfra1234, on 25 August 2011 - 08:46 PM, said:

bro you got +rep'd by rapture...

#8 Veev

Veev
  • Premium Junkies
  • Curse Premium
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 236
  • Talents: Arms 0/1/2/1/1/0
  • RBG: 1928

Posted 18 October 2012 - 09:21 AM

Also I ran some numbers and apparently the 2200 Malevolent weapons are only about 92% as good as Shin'ka, Execution of Dominion (which is actually a pretty significant, and disappointing, difference).

#9 Stretchmarks

Stretchmarks

Posted 20 October 2012 - 11:45 AM

is that counting the gem?

#10 Veev

Veev
  • Premium Junkies
  • Curse Premium
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 236
  • Talents: Arms 0/1/2/1/1/0
  • RBG: 1928

Posted 21 October 2012 - 10:42 AM

View PostStretchmarks, on 20 October 2012 - 11:45 AM, said:

is that counting the gem?

Yes, it is.  I updated the spreadsheet (near the bottom) to show the expected gains going from T1 PvP -> T2 PvP, and T1 PvP -> Heroic PvE.

#11 Deew

Deew
  • Junkies
  • Undeadclass_name
  • EU-Ravenholdt
  • Misery
  • Posts: 249
  • Talents:

Posted 26 October 2012 - 09:54 AM

View PostVeev, on 21 October 2012 - 10:42 AM, said:

Yes, it is.  I updated the spreadsheet (near the bottom) to show the expected gains going from T1 PvP -> T2 PvP, and T1 PvP -> Heroic PvE.

Does this include making up for the resilience you lose from PvP weapon or is this a glass cannon build?

#12 Veev

Veev
  • Premium Junkies
  • Curse Premium
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 236
  • Talents: Arms 0/1/2/1/1/0
  • RBG: 1928

Posted 26 October 2012 - 10:00 AM

It just uses whatever value you have specified for resilience.  With the current version of the spreadsheet, that means setting resil to be worth 90% of PvP power (which is more than crit).  If you set resil to zero you will notice the gap widen between the two weapons.

#13 Deew

Deew
  • Junkies
  • Undeadclass_name
  • EU-Ravenholdt
  • Misery
  • Posts: 249
  • Talents:

Posted 26 October 2012 - 10:27 AM

The equations don't work in OO and I can't install excel on on my computer (work) so I can't change anything, that's why I asked.

I really appreciate all the work you've put into this, thank you.

#14 Wexlike

Wexlike
  • Junkies
  • Undeadclass_name
  • EU-Eredar
  • Blutdurst
  • Posts: 387
  • Talents: Arms

Posted 29 October 2012 - 03:38 PM

i find it stupid, that starshatter (normal mode) has 200 more scorepoints than the 470 ilvl pvp weapon.. -.-

http://www.wowhead.c...0;gb=1#two-hand

#15 Veev

Veev
  • Premium Junkies
  • Curse Premium
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 236
  • Talents: Arms 0/1/2/1/1/0
  • RBG: 1928

Posted 29 October 2012 - 04:32 PM

View PostWexlike, on 29 October 2012 - 03:38 PM, said:

i find it stupid, that starshatter (normal mode) has 200 more scorepoints than the 470 ilvl pvp weapon.. -.-

http://www.wowhead.c...0;gb=1#two-hand
I think this is because Wowhead is currently bugged and is displaying those PvP weapons as having only 1 PvP power.  I've asked them to fix this but looks like they still haven't.

You'd have to manually enter the stats for both weapons into the spreadsheet, similar to how I did to compare 2200 PvP against 509 PvE.

#16 Jækop

Jækop
  • Junkies
  • Undeadclass_name
  • EU-Al'Akir
  • Blackout
  • Posts: 54
  • Talents: Arms 1/1/2/1/0/0
  • RBG: 2182

Posted 31 October 2012 - 12:29 AM

Well done, thanks a lot!
Posted Image

#17 Veev

Veev
  • Premium Junkies
  • Curse Premium
  • Orcclass_name
  • US-Tichondrius
  • Bloodlust
  • Posts: 236
  • Talents: Arms 0/1/2/1/1/0
  • RBG: 1928

Posted 11 November 2012 - 04:06 AM

Updated with stat weights for 2200 weapons, also updated to show exact DPS increase going from 2200 PvP to heroic PvE.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

<