StaxRexx

Select the Cell and Type same thing for your server

 

dotor

Downloaded the latest version and I got Div/0 if I change the Sunder Armor stacks to anything else but 5 or its uptime to anything but 100%. Didn't have that kind of trouble in the previous releases.
Same thing downloading in the Arms sheet.

 

Machinator

#4 isn't so much something wrong with the sheet, but a reiteration of what I said earlier about giving the user a choice of rotations. The dynamic rotation may be the 'best' rotation (it seems to be better than static, but no idea if what the sheet uses is the best possible dynamic rotation), but others are very close and more realistic to use. I can see how the 'best' rotation might change per person. The static rotations are easy to add, but adding other dynamic rotations is a lot of work.

#5 Another source of error for the way the rotations are currently calculated is that the chance of a slam happening on the 2nd GCD does not take into account any cooldowns or HS that happened before the first BT.

"Information is ammunition."

 

Gurlock

Ran across something strange with the sheet. In my fury build I'm sitting at 94.8% ArP with Grim Toll up (this is as Fury) and yet my ArP SEP is 0.976. In fact, everything (except Str obviously) is under 1.00.

Something off with some calcs, or did I just hit a really weird spot of stat combination?

 

Xabrophazon

No. Due to the extreme percentage gains you get for strength due to Improved Berserker Stance and Blessing of Kings, and the fact that Blood Thirst's cooldown has been lowered and it's so dependant on your AP, strength is just ridiculously high on SEP values for Fury Warriors. It's even better than Expertise and Hit below their respective caps, as crazy as that may sound.

 

Taralash

Just a quick note, in the newest version off the spreadsheet my critical strike change is 0,13% higher in the sheet compared to my ingame stats. In the older versions of the sheet the unbuffed stats for crit, arp, haste etc. were always exactly. (race: undead)

 

Tupsi

a minor bug in the Lookup Table:

Belt of the Titans - switch the Blue and Red socket order, otherwise the sheet does not import properly.

 

• landsoul

Did you get any new gear since last?

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

Taralash

*edit*

i change 2 sockets, i used 21agi/crit meta gem and double str in my breastplate. now i use 1 tear in my plate to activate the 21crit/crit meta gem. (for a 5dps increase)

i compared my equip etc. once again i dont see any difference between ingame and the sheet.

alls fits except these two little things:
ingame unbuffed: 4394 ap and 38,16% crit
spreadsheet: 4395 ap and 38,29% crit

 

catch22atplay

Taralash i thought i had the same problem. I then double checked my gear and found a mistake i made. Crit matching up perfectly now. Maybe one of the items you use have updated stats or you missed something.

 

Sprayhead

Don't know if it's been reported yet, but in the arms section you can still choose, if the blessing of kings is being talented (from 0 to 5).
At the furys section it's correct with being only 0 or 1 (active or not).

 

Nyel

To add to Sprayhead's post:

Acid Spit shows as 5 stacks (when it was changed to 2 for same effect)
Unleashed Rage shows as 5 (it is now 3 talents for same effect)

 

Schiwing

Another correction:

Cat's Swiftness in the sheet is listed as "Minor Run Speed +6 Agility" but the Armory lists it as "Minor Speed and +6 Agility"; as you can imagine, this causes a character import error to display.

 

markabey

Please can you add one of the best feet enchants available (for engys) -

Nitro Boosts (they give +16 crit rating and that sweet sweet boost)

 

skurvu

Extract of Necromantic Power (off 25m sapphiron)

Is this purposefully left off the spreadsheet because its just crappy? I know it works with rend/deep wounds, and I got one the other day, just trying to see how it performs on the spreadsheet.

 

StaxRexx

Without changing anything else on mine...

5 - Good
4 - Good
3 - Good
2 - Good
1 - Good
0 - Good

Then at zero I changed uptime...

0% - Good
25% - Good

Since I can't validate your results I'm gonna say you should post more details about the settings or redownload and start over... keep in mind once you get a Div/0 you need to close the spreadsheet without saving or redownload and start from scratch. A Div/0 on the page as I understand it breaks the spreadsheet and its unrepairable.

 

AeonicVortex

May I also request a non-hardmode BiS? My guild hasn't started hardmode yet as we are still trying to get General and Yogg down.

The current list is still nice though. I'm glad I found it.

Thank you!

 

Gustave

Check out the various non hard-mode sets for Fury/Arms put together by members from testing the gear on the spread sheet starting on page 32, it should be of some assistance

I believe the next 4-5 pages from page 32 have a good collection of information regarding the 2 specs and gear differences for at least human (expertise rating) and I think there was a Nightelf post and Tauren.

 

Smokingwolf

i too get the Div/0 error, i restarted the spreadsheet - same. I downloaded the new version - same. Cant figure out what seems to be the problem.

 

Badwin

The ranks for blessing of kings are removed for fury, but there are still 5 of them for the arms. Not that it matters much, just for the spreadsheet to look neat .

 

Liar

Did you check the instructions on the first page of the actual spreadsheet itself?

Unexpected TankPoints error Clearly someone doesn't understand how EH works. That, or upgrading from T8 to T9 is optional in beating Arthas. Clearly.

 

Daind

Am I doing something wrong here or are T7 legs really this good?

Legguards of Cunning Deception (leather) SEP: 322.5
Proto-hide Leggings (leather) SEP: 287.3
Valorous Dreadnaught Legplates (plate) SEP: 278.8 - T7.5... wat
Saronite Mesh Legguards (mail) SEP: 276.7
Clockwork Legplates (plate) SEP: 271.5

This is with the SEP calc cell changed to use the 108 armored to the teeth instead of 180.

Edit: This is fury by the way, not arms.

 

MichRa

Hello all,

I post here, because I have excact the same problem as belth:

I have no idea how to get the spreadsheet running. I would be really thankful, if anyone could help me.
I have downloaded the free trial-version of Excel 2007 from microsoft.com and updatet it with all updates.

Greetings, Michra

PS: Sorry for my poor english, but I'm not a nativ speaker

 

Kaoo

You have to install the VBA Runtimes provided by the Office Setup.

I´ve had exactly the same Problem

 

bchorn

Crit is always really good and Expertise is really good if you are under the expertise cap. The clockwork legs have a lot of strength but lack crit. The hit on the legs are nice but not as good as crit. So that's why the two are only marginally different.

If I had both legs, I would use the legs that help me reach my caps. If I'm lacking expertise, I'll put on the T7.5 legs. If I'm lacking hit, I'll put the clockwork legs on instead and try to make up the crit elsewhere.