Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Warriors

Closed Thread
 
LinkBack Thread Tools
Old 06/16/09, 2:41 PM   #1176
StaxRexx
Glass Joe
 
StaxRexx's Avatar
 
Night Elf Warrior
 
Rexxar
Select the Cell and Type same thing for your server

Offline
Old 06/16/09, 9:23 PM   #1177
dotor
Glass Joe
 
dotor's Avatar
 
Tauren Warrior
 
Вечная Песня (EU)
Originally Posted by StaxRexx View Post
The Div/0 with the windfury totem seems to be fixed. I figured I'd mention it since it's not in the notes I'm guessing since its a minor detail.

I still cant download in the Arms sheet I'm wondering if this is related to my Armory being saved to my Fury build once the servers come back up I'll flip over to my Arms setup exit and see if it makes a difference. If thats the case I'm wondering how hard it would be to only download gear & skip talents and if needed skip that offhand weapon as well?
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.

Offline
Old 06/17/09, 1:36 AM   #1178
Machinator
Don Flamenco
 
Troll Warrior
 
Aggramar
Originally Posted by landsoul View Post
Great points. I'm adding in the case of no slams, and I am fixing #3. Don't know what to do about #4.
#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."

Offline
Old 06/17/09, 3:31 AM   #1179
Gurlock
Von Kaiser
 
Orc Warrior
 
Nathrezim
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?

Offline
Old 06/17/09, 3:45 AM   #1180
Xabrophazon
Von Kaiser
 
Xabrophazon's Avatar
 
Dwarf Warrior
 
Garona
Originally Posted by Gurlock View Post
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?
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.

Offline
Old 06/17/09, 5:20 AM   #1181
Taralash
Glass Joe
 
Undead Warrior
 
Khaz'goroth (EU)
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)

Offline
Old 06/17/09, 6:22 AM   #1182
Tupsi
Glass Joe
 
Tauren Druid
 
Stormrage (EU)
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.

Offline
Old 06/17/09, 6:32 AM   #1183
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
Did you get any new gear since last?

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Online
Old 06/17/09, 6:40 AM   #1184
Taralash
Glass Joe
 
Undead Warrior
 
Khaz'goroth (EU)
Originally Posted by landsoul View Post
Did you get any new gear since last?
*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

Last edited by Taralash : 06/17/09 at 11:51 AM.

Offline
Old 06/17/09, 12:05 PM   #1185
catch22atplay
Piston Honda
 
Tauren Warrior
 
Proudmoore
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.

Offline
Old 06/17/09, 12:09 PM   #1186
Sprayhead
Glass Joe
 
Dwarf Warrior
 
Krag'jin (EU)
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).

Offline
Old 06/17/09, 12:44 PM   #1187
Nyel
Von Kaiser
 
Undead Warrior
 
Lightning's Blade
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)

Offline
Old 06/17/09, 7:14 PM   #1188
Schiwing
Glass Joe
 
Human Warrior
 
Bonechewer
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.

Offline
Old 06/17/09, 7:40 PM   #1189
markabey
Glass Joe
 
Orc Warrior
 
Frostwhisper (EU)
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)

Offline
Old 06/17/09, 9:59 PM   #1190
skurvu
Glass Joe
 
Orc Warrior
 
Mug'thol
extract of necromantic power

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.

Offline
Old 06/17/09, 10:58 PM   #1191
StaxRexx
Glass Joe
 
StaxRexx's Avatar
 
Night Elf Warrior
 
Rexxar
Originally Posted by dotor View Post
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.
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.

Offline
Old 06/18/09, 2:40 AM   #1192
AeonicVortex
Glass Joe
 
Human Warrior
 
Feathermoon
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!

Offline
Old 06/18/09, 3:26 AM   #1193
Gustave
Glass Joe
 
Gustave's Avatar
 
Night Elf Warrior
 
Azgalor
Originally Posted by AeonicVortex View Post
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!

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.

Offline
Old 06/18/09, 7:19 AM   #1194
Smokingwolf
Glass Joe
 
Tauren Warrior
 
Al'Akir (EU)
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.

Offline
Old 06/18/09, 11:13 AM   #1195
Badwin
Glass Joe
 
Draenei Warrior
 
Гордунни (EU)
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 .

Offline
Old 06/18/09, 11:22 AM   #1196
Liar
VROOM VROOM
 
Liar's Avatar
 
Human Death Knight
 
Turalyon (EU)
Originally Posted by Smokingwolf View Post
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.
Did you check the instructions on the first page of the actual spreadsheet itself?


Offline
Old 06/19/09, 3:35 AM   #1197
Daind
Glass Joe
 
Daind's Avatar
 
Orc Warrior
 
Silvermoon
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.

Offline
Old 06/19/09, 8:44 AM   #1198
MichRa
Glass Joe
 
Tauren Warrior
 
Das Syndikat (EU)
Hello all,

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

Originally Posted by belth View Post
I have a problem with the excel 2007 spreadsheet that perhaps someone can help me with.

When I open the file, obviously with excel 2007, I get the message:
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))

To clarify, I have done everything said in the Intro page of the file.
Such as enabling macros etc.
But the macros still won't work.

Is there anyone who could have an idea what I need to do to get it running?
If I need any specific download from microsoft perhaps?

Thanks in advance anyway, please send a pm to me with the solution if you have one!
Really need to get those SEP values working.
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

Offline
Old 06/19/09, 9:06 AM   #1199
Kaoo
Glass Joe
 
Undead Warrior
 
Teldrassil (EU)
You have to install the VBA Runtimes provided by the Office Setup.

I´ve had exactly the same Problem

Offline
Old 06/19/09, 12:00 PM   #1200
bchorn
Von Kaiser
 
Night Elf Warrior
 
Icecrown
Originally Posted by Daind View Post
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.
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.

Offline
Closed Thread

Go Back   Elitist Jerks » Warriors

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mongoose calculation or simulation? sag_ich_nicht Public Discussion 1 08/05/08 10:59 AM
[Rogue] Backstab damage calculation Karmon Class Mechanics 5 11/04/07 6:22 PM
Range Calculation Nite_Moogle Theorycrafting Think Tank 0 09/21/07 1:02 PM
Ilvl calculation Drauk Public Discussion 9 03/24/06 5:30 PM