Warrior DPS Calculation Spreadsheet - Page 121

Tzorcelan · 09/26/09, 6:04 AM

Originally Posted by Gregor

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

Fameee · 09/26/09, 11:58 AM

Can anyone tell me, how to change talents? e.g from Poleaxe Spec. to mace spec.?

Ryo Saeba · 09/26/09, 12:48 PM

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.

Alexxcri · 09/26/09, 1:24 PM

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?

Cryof · 09/26/09, 3:46 PM

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?

Anduryondon · 09/26/09, 5:05 PM

It doesn't put the heroic one on cooldown.
€: http://img21.imageshack.us/img21/9683/dualproc.jpg

ZeTodu · 09/26/09, 5:09 PM

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

StaxRexx · 09/26/09, 6:53 PM

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...

junkpriest · 09/26/09, 11:42 PM

It's a renamed Mirror of Truth, just use that.

catch22atplay · 09/27/09, 7:39 AM

Originally Posted by ZeTodu

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.

Twicks · 09/27/09, 5:53 PM

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

Qwusa · 09/28/09, 7:51 AM

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.

Thorhammar · 09/28/09, 8:25 AM

Originally Posted by Qwusa

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.

Jakoemanou · 09/28/09, 1:05 PM

Originally Posted by Twicks

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.

Twicks · 09/28/09, 1:19 PM

Originally Posted by Jakoemanou

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?