Warrior DPS Calculation Spreadsheet - Page 41

remix1 · 04/20/09, 6:36 AM

Yeah for Arms it's a bit more unclear. It's hard to hit all the right caps without going 5/5 or wasting dps with gems/enchants. But it seems there's a couple setups just loading on as much ArP as possible and using leather/mail that are slightly higher when ArP SEP gets high enough and just says screw everything else. Still messing with it.

premed · 04/20/09, 9:14 AM

Originally Posted by IggyMac

Is the code for importing a character working?
I can't seem to make the function work, and it tells me that

"Could not find http://www.wowarmory.com/character-talents.xml?r=Eldre'Thalas&n=IggyMcMuffen&lang=en_us"

I suspected maybe it was because the apostrophe in Eldre'Thalas wasn't URL encoded, but that doesn't seem to be the issue.

i got a similar error. The sheet is trying to read "http://www.wowarmory.com/character-sheet.xml?r=Quel%27dorei&n=Premed&lang=en_us", but the real link to the armory is "http://www.wowarmory.com/character-sheet.xml?r=Quel%27dorei&n=Premed"

Im not sure if this changed in the patch or "&lang=en_us" is just different link that is more spreadsheet friendly

If the change is due to armory url changes, then the fix would be pretty simple, i just cant find the code used for the"click for armory input"

DarkS · 04/20/09, 10:24 AM

Reporting:

[Gauntlets of Ruthless Reprisal] has wrong stats on the sheet.

85 Str -> 98 Str
62 Crit -> 60 Crit
129 Sta -> 96 Sta

Machinator · 04/20/09, 10:59 AM

Is there a good way to appropriately account for using a trinket such as [Loatheb's Shadow] in sync with Deathwish? I just want to approximate it as 20% more AP for the use: and be done with it but my analytical side won't let me.

Would 2 sheets, one representing DW up and the other not, be a more accurate model?

landsoul · 04/20/09, 12:01 PM

Yes, you can use two sheets, both without the trinket equipped or deathwish in talents.

Rig one sheet with the added stats of the trinket procced and with 20% in the DIM box. Multiply by 20/120
Rig another sheet with only the base stats of the trinket, no proc, and without the phoney 20% Multiply by 100/120

Harpo · 04/20/09, 1:15 PM

Originally Posted by remix1

Yeah for Arms it's a bit more unclear. It's hard to hit all the right caps without going 5/5 or wasting dps with gems/enchants. But it seems there's a couple setups just loading on as much ArP as possible and using leather/mail that are slightly higher when ArP SEP gets high enough and just says screw everything else. Still messing with it.

Hrm, that seems interesting. I only recall a few slots where mail/leather were BiS, I would be suprised to see a setup like that manage to outweigh the two set bonuses, which is roughly 135 dps or so. I am also worried that Blizz may re-itemize a few of the plate items to contain higher DPS values at a loss of stamina on plate items, since they did it for quite a few items, but not all of them. I am also really hoping for an STR ring to replace the AP ring. I posted my arms setup on my previous post, which is on the previous page.

Also, I have a minor suggestion. Perhaps in the lookup you could indicate a boss location/difficutly. Obviously this is me being extremely lazy, but it would be very nice to see where the items drop from. I know I am making a side grade-ish list of gear I want that is easily obtainable, and it has been a lot of tabbing/wowdb or wowheading to figure out where the loot drops from.

Machinator · 04/20/09, 1:19 PM

Originally Posted by landsoul

Yes, you can use two sheets, both without the trinket equipped or deathwish in talents.

Rig one sheet with the added stats of the trinket procced and with 20% in the DIM box. Multiply by 20/120
Rig another sheet with only the base stats of the trinket, no proc, and without the phoney 20% Multiply by 100/120

Don't those numbers miss the 10/120 that DW is up but the trinket isn't?

Ferboten · 04/20/09, 1:52 PM

Forgive me if I'm wrong but I think it would be

Rig one sheet with the added stats of the trinket procced and with 20% in the DIM box. Multiply by 20/120
Rig another sheet with only the base stats of the trinket, no proc, and with 20% in the DIM box. Multiply by 10/120
Rig another sheet with only the base stats of the trinket, no proc, and without the phoney 20% Multiply by 90/120

landsoul · 04/20/09, 3:12 PM

Yeah something like that. I didn't sleep last night so I thought that Death wish was 20s long for some reason. Also, There's no more space for any more columns in the lookup page. If I put anymore it wouldn't work with '97 and the whole project would be locked out to half of it's users. So it's nice to have wowhead or something in the background for reference to item location and such.

rea123 · 04/20/09, 7:22 PM

Originally Posted by IggyMac

Is the code for importing a character working?
I can't seem to make the function work, and it tells me that

"Could not find http://www.wowarmory.com/character-talents.xml?r=Eldre'Thalas&n=IggyMcMuffen&lang=en_us"

I suspected maybe it was because the apostrophe in Eldre'Thalas wasn't URL encoded, but that doesn't seem to be the issue.

The issue is not the url; see my previous post regarding the changes to the Armory XML document format since Dual-spec came along.

@premed, the "&lang=en_us" is not a problem. The code for Armory Input is a macro called "ArmoryInput". But the URL you posted here that the sheet is requesting is correct. If you get a problem with the character-talents.xml URL (as in the message quoted above), that is due to the sheet incorrectly parsing the response - indeed as far as I can tell you should get an error parsing the talents, as the Armory response has completely changed. If, however, you get a fault with character-sheet.xml (as you posted), this is more likely to be due to the armory being a little flaky at the moment; again this carries the caveat "as far as I can tell".

Hope this makes sense.

Anklebreaker · 04/20/09, 8:53 PM

I spent a few hours playing with current BiS gear for arms and fury with this spreadsheet, and found that fury has over a 200 dps advantage. Is this correct or could I be doing something wrong? I assumed that fury would overtake arms with gear but should there really that big of a gap between them?

callion · 04/20/09, 11:04 PM

So the proc on [Mjolnir Runestone] is identical to [Grim Toll], yet if you replace GT with MR the overall DPS goes down, why? Shouldn't the DPS be way higher with that much crit instead of hit? (assuming hit capped). Even after adding +83 hit rating to phony stats while using MR the DPS is way lower than with GT equipped.

edit: just noticed, this seems to only apply to the arms sheet, the proc on MR is missing?

Grayson Carlyle · 04/21/09, 3:42 AM

Originally Posted by callion

edit: just noticed, this seems to only apply to the arms sheet, the proc on MR is missing?

I explained in my bug list above why this is happening.

landsoul · 04/21/09, 4:00 AM

Updated. Check the front page.

Thairne · 04/21/09, 5:29 AM

Well i gotta risk being called out as a stupid buffon, but I still can´t get the armory import to work with the newest version. Since I´m from EU, I modify the link in the spreadsheet to

http://eu.wowarmory.com/

The link is correct as far as I know, it opens the EU armory frontpage. But the spreadsheet crashes, telling me "The server name or adress could not be resolved".
Even if this works, I can forsee some problems with being autodirected to the german version of the armory due to IP origins...