[Spreadsheet] Warrior NAXX/AQ BiS.

[Skitter 0]

I've tried using the spreadsheet, but get a bunch of boxes with "NA" and error codes. Has anyone else had this issue?

[Storfan 24]

1 hour ago, Skitter said:

I've tried using the spreadsheet, but get a bunch of boxes with "NA" and error codes. Has anyone else had this issue?

Then there's a circle-error and/or loop somewhere. 

u done brok eet!

Fix: Reverse and changes you've made or re-down the sheet and start from the begining. Also, always save after each change you make so you easily can reverse it if shit gets fakd.

[Omakaroni 1]

Updated main thread, now includes Human BiS and non-orc/human BiS. 

[Storfan 24]

4 hours ago, Omakaroni said:

Updated main thread, now includes Human BiS and non-orc/human BiS. 

Prestors should be removed from the list and get its stats altered. Currently it has Feenix-TBC stats, (where the sheet originated). Prestors with the correct stats of 30agi and 1% hit will not compete with Eye of hakkar, Onyxia, or Fankris-neck.

[Knife 2]

2 hours ago, Storfan said:

Prestors should be removed from the list and get its stats altered. Currently it has Feenix-TBC stats, (where the sheet originated). Prestors with the correct stats of 30agi and 1% hit will not compete with Eye of hakkar, Onyxia, or Fankris-neck.

1000g it will?

[Storfan 24]

24 minutes ago, Knife said:

1000g it will?

Onyxia Tooth pendant:

1% hit

1.6% crit.

Prestors:

1% hit

1.5% crit.

 

Seems like an easy choice no?

[Knife 2]

Prestors w/ ZG buff (and no BoK):

34.5 agi = 1.725 crit

1 hit

Onyxia w/ ZG buff (and no BoK)

13.8 agi = 0.69 crit

1 crit

1 hit

 

Overall: Prestors is 0.035% crit upgrade on onyxia on horde in current patch (depending on how your stats end up rounding)

[Omakaroni 1]

16 hours ago, Storfan said:

Prestors should be removed from the list and get its stats altered. Currently it has Feenix-TBC stats, (where the sheet originated). Prestors with the correct stats of 30agi and 1% hit will not compete with Eye of hakkar, Onyxia, or Fankris-neck.

Prestors have the correct stats of 1% hit and 30 agi in the sheet, and are better than the trinkets you mentioned for alliance because of kings and for horde they are better fullly buffed.

You should take a look at the last lines in the main thread, under the bis lists :)

[Omakaroni 1]

 Updated main thread, now includes Badge of the Swarmguard.

[Omakaroni 1]

Changes to Wep Skill and base Miss is added to the sheet as well as the main post + updated BiS-list to follow the change.

follow updates at: https://discord.gg/Ds85MeR

[Brynja 1]

The spreadsheet doesn't work right below 9% hit, does it?

Going from 10% to 9% hit seems to be the same DPS loss as going from 8% to 7%, although the second one should be much higher (since you are also losing 1% of your yellow hits as well). Or am I seeing this wrong?

[Undertanker 88]

Weapon skill making up  for the hit?

[Cetus 0]

Does the change you made on august 8th mean that +4 weapon skill is actually now the most useful number in terms of decreasing misschance, instead of +5 weapon skill as it was before?

[Omakaroni 1]

The Blue line is how the spreadsheet is now, the red line is how it was before.

[getintouch 0]

19 hours ago, Omakaroni said:

The Blue line is how the spreadsheet is now, the red line is how it was before.

So weapon skill is definetly effecting yellow hits as well and not only white hits?

[Brynja 1]

1 hour ago, getintouch said:

So weapon skill is definetly effecting yellow hits as well and not only white hits?

It shouldn't affect yellow hits. If you dual-wield you have to add +15% misschance on top of these values for your white hit miss percentage.

And I am not sure if the changes to weapon skill are even live tbh.

[Nirinia 0]

weapon skill should definitely be affecting yellow hits but only those that require a weapon to use

[Omakaroni 1]

2 hours ago, Brynja said:

It shouldn't affect yellow hits. If you dual-wield you have to add +15% misschance on top of these values for your white hit miss percentage.

And I am not sure if the changes to weapon skill are even live tbh.

+19% not 15%

 

2 hours ago, Nirinia said:

weapon skill should definitely be affecting yellow hits but only those that require a weapon to use

correct, also execute wont get affected even tho the spell requires melee weapon. The spell is just a trigger to check if you have enough rage to use execute then a second spell is cast, this spell is what takes damage at the mob, this does not require melee weapon.

So even tho the weapon skill gives hit you should still have 9%.

Does this make weapon skill bad?

no, its still good cause the decrease in miss chance also make your crit cap higher with whites, and it also reduces glancing blows damage reduction.

[Omakaroni 1]

Changed proccrate for MSA in the sheet to 3ppm and changed it to equip type of procc instead of chance on hit.
Meaning it can procc from WhiteMHConnects/YellowConnects/WindfuryConnects/HoJConnects/SSConnects/WhiteOHConnects

Main post is updated. 29.08.2017

[Agrillos 0]

Would be nice if you could keep the AQ/BWL BiS gears in some kind of 'Spoiler' tab.

[Omakaroni 1]

1 hour ago, Agrillos said:

Would be nice if you could keep the AQ/BWL BiS gears in some kind of 'Spoiler' tab.

Ok should be there now :)

[Omakaroni 1]

New updated sheet for naxx added to main post link: 21:09:2017

[Storfan 24]

On 2017-08-29 at 2:58 PM, Omakaroni said:

Changed proccrate for MSA in the sheet to 3ppm and changed it to equip type of procc instead of chance on hit.
Meaning it can procc from WhiteMHConnects/YellowConnects/WindfuryConnects/HoJConnects/SSConnects/WhiteOHConnects

Main post is updated. 29.08.2017

Does this mean that using MSA in your OH can proc MSA lightning from the Proc of Ironfoe proc in your MH?

[Omakaroni 1]

yes it can proc of basically everything, have not tested with ironfoe tho, but it proccs of WF extra hits, so i guess ironfoe aswell :)

[Omakaroni 1]

Updated: 24.09.2017