Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Warriors

Closed Thread
 
LinkBack Thread Tools
Old 09/26/09, 6:04 AM   #1801
Tzorcelan
Glass Joe
 
Human Warrior
 
Ravenholdt (EU)
Originally Posted by Gregor View Post
Hey all,

Sorry but I need some help troubleshooting the new spreadsheet. I've been a huge fan of this tool for months now, but I just installed Excel 07 and the new program won't run very well for me.

Error message - When I try to get my profile from Armory, I get the following message: Microsoft Visual Basic Run-time Error 91. Object Variable or With Block Variable not set.

DPS Metric- is stuck to Landsoul's numbers, even after manually inputting all my gear/gems.

I think this program is invaluable, and I'd like to keep using it so any help at all would really be appreciated.

thanks very much!
Got same problem

Offline
Old 09/26/09, 11:58 AM   #1802
Fameee
Glass Joe
 
Draenei Shaman
 
Alexstrasza (EU)
Can anyone tell me, how to change talents? e.g from Poleaxe Spec. to mace spec.?

Offline
Old 09/26/09, 12:48 PM   #1803
Ryo Saeba
Glass Joe
 
Tauren Warrior
 
Darkspear (EU)
Why [Greaves of Ruthless Judgment] over [Icewalker Treads] in the BiS Fury list? The leather ones gives the same stats but more hit and one red red socket instead of one yellow.
I don't think the armor compensates for that, I get better results with the second option with all the BiS items with the last Spreadsheet.

Offline
Old 09/26/09, 1:24 PM   #1804
Alexxcri
Von Kaiser
 
Tauren Warrior
 
Jaedenar (EU)
I am really puzzled, while playing with the spreadsheet I wanted to see how mace spec improved with the recent Arp nerf since using a mace will get you capped pretty easy, so I plugged in the BiS gear I considered would be best suited with the best mace there is, the heroic Grievance, making even use of the expertise on it. So with the mace I had a pretty much ideal setup, 100% ArP, Expertise and hitcapped also of course. Thing is, when I switched to the equivalent axe, Heroic Dual Blade Butcher I was still 300 dps higher and not even botherning to change the STR gems with ArP. When I also changed gems to cap ArP too I got to a whopping 9665dps even though I was lacking EXP rating. By comparison the best setup with mace got to only 9228 dps. Is Axe spec still that good compared to mace spec? Anyone done some maths?

Offline
Old 09/26/09, 3:46 PM   #1805
Cryof
Glass Joe
 
Night Elf Warrior
 
Deathwing
So I had a question about double Death's Verdicts(heroic and non) being BiS. If the non-heroic version of it procs, it puts the heroic one on cooldown right? If so is this just about the static attack power and if it is wouldn't a battlemaster(256ap) be stronger so that you dont waste the Heroic Death's Verdicts cd?

Offline
Old 09/26/09, 5:05 PM   #1806
Anduryondon
Piston Honda
 
Undead Warrior
 
Blackrock (EU)
It doesn't put the heroic one on cooldown.
€: http://img21.imageshack.us/img21/9683/dualproc.jpg

Offline
Old 09/26/09, 5:09 PM   #1807
ZeTodu
Von Kaiser
 
Human Warrior
 
Neptulon (EU)
Buffs are difrent and they can proc at same time - one for 450 and other for 510....
Here in threads have a screenshot - Trokz - Rogue - Imbalanced - Jaedenar Eu

Offline
Old 09/26/09, 6:53 PM   #1808
StaxRexx
Glass Joe
 
StaxRexx's Avatar
 
Night Elf Warrior
 
Rexxar
Is there an easy way to determine the ProcSep for [Coren's Chromium Coaster] or is it one of those things where you need to stand in front of a Training Dummy for 3 hours and then parse logs etc...

I was Fury Before the Lich King Came... I was Fury before Titan's Grip... I was Fury Before it was cool...

Offline
Old 09/26/09, 11:42 PM   #1809
junkpriest
Glass Joe
 
Gnome Warrior
 
Shattered Hand
It's a renamed Mirror of Truth, just use that.

Offline
Old 09/27/09, 7:39 AM   #1810
catch22atplay
Piston Honda
 
Tauren Warrior
 
Proudmoore
Originally Posted by ZeTodu View Post
For furry BiS list: I have better results using Bracers of the Untold Massacre (Heroik), with Greaves of the 7th Legion(Heroik) and Bloodbath Belt (Heroik). Also Planestalker Band (Heroik) instead of Band of Violent Temperment (Heroik)!
All gems are ArP ones, exept 2 yellow slots with 10str+10crit and 10all stats in Head.
9855.265 DPS...
That's correct for Alliance as you get +1% to hit for Dranei. For us Horde we use the hit belt=Waistguard of Deathly Dominion (Heroic). exp gloves=Boneshatter Vambraces (Heroic), and Ring=Band of Violent temperament. So alliance gets a 35-37dps advantage approx. Not bad at all considering. But should always remember BIS may not be the same for alliance and horde. In this case they are not the same. But yes your way does look like BIS for alliance imo. So kudos for identifying it as such.

Offline
Old 09/27/09, 5:53 PM   #1811
Twicks
Banned
 
Undead Warrior
 
Al'Akir (EU)
Im an eu user , and i cant seem to update the sheet from my armory. I get an error window asking for me to debug or end

Offline
Old 09/28/09, 7:51 AM   #1812
Qwusa
Glass Joe
 
Boing
Undead Warrior
 
Non-US/EU Server (EU)
everytime i run an SEP calculation i get an #value error, no matter what race/faction i use and even if i just run it on the fresh downloaded sheet.
can anyone help me with this? the older sheet's work'd perfectly.

Offline
Old 09/28/09, 8:25 AM   #1813
Thorhammar
Glass Joe
 
Human Warrior
 
Ragnaros
Originally Posted by Qwusa View Post
everytime i run an SEP calculation i get an #value error, no matter what race/faction i use and even if i just run it on the fresh downloaded sheet.
can anyone help me with this? the older sheet's work'd perfectly.
Try changing the . in cells c102 and c104 (if my memory is not wrong those cells are the main hand / offhand weapon speed) for a ,

That should work.

Offline
Old 09/28/09, 1:05 PM   #1814
Jakoemanou
Glass Joe
 
Orc Warrior
 
Lightning's Blade (EU)
Originally Posted by Twicks View Post
Im an eu user , and i cant seem to update the sheet from my armory. I get an error window asking for me to debug or end

use eu.wowarmory.com and it will work.

Offline
Old 09/28/09, 1:19 PM   #1815
Twicks
Banned
 
Undead Warrior
 
Al'Akir (EU)
Originally Posted by Jakoemanou View Post
use eu.wowarmory.com and it will work.
Thanks dude , that got me round the 1st set of errors. Had the http:// infront on eu armory.

But now im getting another set of errors. ive provided em below

Runtime error "91"

Object variable or with block variable not set.


Any ideas?

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » 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 9:59 AM
[Rogue] Backstab damage calculation Karmon Class Mechanics 5 11/04/07 5:22 PM
Range Calculation Nite_Moogle Theorycrafting Think Tank 0 09/21/07 12:02 PM
Ilvl calculation Drauk Public Discussion 9 03/24/06 4:30 PM