Warrior DPS Calculation Spreadsheet - Page 42

landsoul · 04/21/09, 5:33 AM

Im gonna take it down for a minute, its not adding the cape right.

Edit: Okay now it's fixed please redownload!

To get EU armory, you must put eu.wowarmory.com in the server box.

Edit again: found another bug with penetration permutations, fixing and uploading now

Murderizer · 04/21/09, 6:24 AM

Orcs don't get 5 expertise for having a polearm equipped. Seems like your sheet adds in our 5 expertise for both axes and polearms for some reason?

Anduryondon · 04/21/09, 7:15 AM

Sorry if this has already been asked, but i used the search function and didnt find any results. Is Open Office able to handle the Spreadsheet? Because i only get #### Values und Errors for Armory Support. Tried Google Docs as well, but they dont support xmls files -_-

landsoul · 04/21/09, 7:20 AM

Ok I'll update again, found more bugs.

Bersi · 04/21/09, 8:21 AM

Landsoul, the ranged slot is missing in your BiS List in the first post.

Originally Posted by Anduryondon

Sorry if this has already been asked, but i used the search function and didnt find any results. Is Open Office able to handle the Spreadsheet?

No, OO support stopped some versions ago. First post statement:

Please do not try to use them with Google Docs, Open Office, or any other spreadsheet program for they will not work.

Anduryondon · 04/21/09, 8:43 AM

Was the first statement edited some minutes ago or was i just blind? Thanks anyway, i'll get Excel then.

Jordybe · 04/21/09, 9:11 AM

Hi Landsoul.

Im a big fan of your spreadsheet. But since 3.1 I have some problemms with it.
It doens't change the DPS....

I open the spreadsheet en go to arms/fury change an item. But the DPS keeps the same at the top.

Pixen · 04/21/09, 10:16 AM

So is the current valuation of ArP in the spreadsheet accurate? If so I can't see why anyone would gear/gem for ArP on purpose. The sheet puts GT at a disadvantage to something like the Greatness card, which would be a shame when there was speculation it would be BiS coming out of Naxx with the ArP changes.

Anduryondon · 04/21/09, 11:09 AM

I just tested out the Spreadsheet and it says its no difference if i gem str or hit, when iam 1% away from hit cap. Actually I thought hit cap is more important than other stats, or am I wrong?

Schiwing · 04/21/09, 12:04 PM

As for BiS, Human Warriors should switch a few gems around; best I can come up with so far is an additional 50 dps on top of the default gear load; this is also assuming the use of a [Bold Stormjewel] too.

Landsoul, in previous builds (excel '97 version), Anger Management and Unbridled Wrath added dps but this no longer seems to be the case in the 3.1+ versions of the sheet. They were minor gains, 10-30 dps, but were still gains. Any reason they are 'inactive' now?

Vitalstatistix · 04/21/09, 12:29 PM

Originally Posted by Schiwing

...Anger Management and Unbridled Wrath added dps but this no longer seems to be the case in the 3.1+ versions of the sheet. They were minor gains, 10-30 dps, but were still gains. Any reason they are 'inactive' now?

They are not inactive, the sheet is probably just calculating that you are generating enough rage from white hits plus any other rage-management talents/procs. I might be mistaken, but basically if cell AG47 is orange you don't need more rage to sustain your rotation and HS almost all MH hits. AG47 is the HS frequency and is approximately 1-(chance of rage-starvation). You can check the formulas.
With my stats these talents don't reflect a dps-increase either. I'm basically maxed out if I have one of Anger Management, 3/5 Unbridled Wrath, or the 4-set T7 bonus. This is definitely NOT my raiding experience. I'm probably getting all these plus Imp Zerker Rage after the talent point reset tonight.

callion · 04/21/09, 12:58 PM

Originally Posted by Pixen

So is the current valuation of ArP in the spreadsheet accurate? If so I can't see why anyone would gear/gem for ArP on purpose. The sheet puts GT at a disadvantage to something like the Greatness card, which would be a shame when there was speculation it would be BiS coming out of Naxx with the ArP changes.

Yeah I noticed the same thing, I tried changing GT with MoT and changed some ArP gems for STR but my DPS (on boss dummy) went down instead of up like the sheet was showing. I'm gonna go with my gut instinct on this one and keep my ArP gems + GT.

Pixen · 04/21/09, 1:18 PM

Originally Posted by callion

Yeah I noticed the same thing, I tried changing GT with MoT and changed some ArP gems for STR but my DPS (on boss dummy) went down instead of up like the sheet was showing. I'm gonna go with my gut instinct on this one and keep my ArP gems + GT.

In my case it was because I didn't have enough ArP to push the SEP above 1 according to the spreadsheet. After playing around I determined I'd need ~360 more ArP from gear (assuming ArP food) before it crosses that threshhold. Unfortunately, scarlet rubies are a bit expensive to be playing around with for experimenting.

stompingbull · 04/21/09, 1:51 PM

Question, Why is it that you have runestone over mirror of truth as bis for arms? on the spreadsheet mirror comes out way ahead of it.

landsoul · 04/21/09, 4:02 PM

That's because Blood of the Old God's proc is is acidentally counted with MoT's I'll fix it.