Termînator

I'm looking at using 8.5 Head, Chest, Legs, Hands and Shoulderplates of the Celestial Watch from 10 man Algalon.

I like it better than the setup with Legguards of Cunning Deception.

Right now my 10m group is a little shaky, so my 10m loot is really lacking.

The rest of my gear I want to setup like this:

Neck: Frigid Str of Hodir
Back: Drape of the Faceless General
Belt: Soul Devouring Cinch or Starfall Girdle?
Wrist: Bitter Cold Armgaurds
Feet: Melancholy Sabatons
Ring: Sifs Promise or Godbane Signet for more crit?
Ring: Strength of the Automaton (or Brann's Signet Ring if we ever get that far, or Seal of the Betrayed King?)
Trink: Mjolnir Runestone
Trink: Dark Moon Card Greatness
Thrown: Twirling Blades
Weapons: Voldrethar x 2

With this setup I try to keep my crit up as high as I can without really sacrificing other stats.
As of now I get a huge chunk of my crit from the dual Rune Edge. With Voldrethar I'll lost about 4% crit with a double swap. With this setup I'm looking at about 36% crit which I find manageable.

My current gear is really gimp and out of order due to the lack of 10m loot drops.

 

junkpriest

The spreadsheet lists Guise of the Midgard Serpent having a socket bonus of +16ap when it's really +32ap.

 

Grimlii

It has it included in its base ap. Im sure theres a note on the spreadsheet confirming this.

 

damagedgoods

2 probably stupid questions:

Replacing my current gauntlets with bladebreaker's i lose a lot of expertise. It puts me at 19 expertise yet shows a dps increase from this. Trying to swap a strength gem to expertise shows a decrease of dps as well. Am i missing something here or just really valuing expertise to high in my thinking?

There is no model for trauma on the sheet and I'm not sure why this is. Obviously I have guesses but if we make the assumption that I happen to be in a raid w/o any other form of bleed improvement, what is the value of this versus say weapon mastery?

 

Liar

Are you Arms? Expertise isn't that good for them because of Overpower.

To figure out how much you gain from speccing Trauma, uncheck Mangle/Trauma under the "Bleed Debuff" box and compare that to your DPS with Mangle/Trauma.

If you want to compare it to 2/2 Weapon Mastery, uncheck Mangle again and spec WM. Compare DPS again.

Just to give you an idea: I lose 300 DPS without any bleed debuff and around 70 DPS without WM.

Unexpected TankPoints error Clearly someone doesn't understand how EH works. That, or upgrading from T8 to T9 is optional in beating Arthas. Clearly.

 

Graul

What do you think the implications of changing Execute to (1456 + 5% AP) * weapon speed would be? This would normalize weapons as far as 20% PvE DPS goes, make it actually worth using again as a staple ability and would also be a boost to PvP as well as Arms DPS. Would this lead to "too much burst" for PvP due to Sudden Death?

 

Speeder

A far as PVP goes and new resilence changes I dont think so it'd be too bursty.

peace MK

 

Eliminate2

Anyone know which cell has the info for the armor to the teeth value? so i can try out the new 108 proposed change?

EDIT:
I found the one to adjust for the ap, but that doesnt get used in the dps calculation.

Chaning the value in B3 will only reflect the AP change, won't change the dps calculation.

Still looking for the dps calculation one.

 

catch22atplay

Average AP cell Z55. Second line right side look for 180*Z7 and change to 108*Z7.

 

Eliminate2

(B139*2+(285*C28+200*C36)*IF(C24="Demon",1,0)+(140)*IF(C24="Undead",1,0)*(IF(C19="Sco urgebane",1,0)+IF(C21="Scourgebane",1,0))+400*(X94+Z94)-0+AB83+AB102+IF(A30="Food: AP",C30,0)+C46+AB90+AB107+AB109+AB106+AB88+AB86+AB81+AB89+AB92+AB84+AB93+AB99+C27+MAX (550*J25*(1+0.05*K25),J27*550*(1+0.125*K27))+C135+Z54/180*AL7)*MAX(1+0.02*U49*V49/100,1+0.1*U51*V51/100,1+0.1*V53)

I'm assuming the 180 is the one you're refering to?

 

catch22atplay

That's the one yes. For me that's a 196ap gain with full raid buffs.

 

Ryo Saeba

*edit*

 

morimacil

Do you think that you could add resilience to the spreadsheet?

I am fully aware of the fact that the spreadsheet is there primarily for pve purposes, and that it is near impossible to create an accurate spreadsheet to calculate PvP damage, due to multiple factors, such as not being in melee range all the time.
But it is already possible to modify the target armor in the spreadsheet, and it should not be that difficult to add a resilience cell for the target, I wish I knew how.
The DPS would probably not be accurate at all, but I am very interested in what the SEP would look like when fighting a target with 1000 resilience for example, in particular how much it would affect crit.

If you find the time to implement it in the spreadsheet, it would be really nice.

 

Coeus

Cell C41 has what you want. The note says to make sure you have "Player" selected in C27, but it should read C23.

 

LongneckExo

I am having a problem with the dps spreadsheet. I have put in all the gear I have on currently (that is available on the spreadsheet). But one field is #N/A which is messing up all the calculations. I have absolutely no idea how to fix this field.

 

Gothaur

I usually see the N/A thing when I my Excel forgets to have Iterative Calculations on (as explained on the first tab).

 

Gazelem

Delete the spreadsheet and re-download it. Don't mess with the fields you don't understand.

Merciless Champion of Reality, ROFLPWNR of Dreams

 

Wymorence

I just today started getting the #DIV/0 problem as well after changing my helm from the Dragonsteel Faceplace off 10man Razorscale to the T8.5 helm. Followed the instructions on the first page of the spreadsheet for the iterations, but either Excel 2007 is different in its configuration for iterations, or the instructions have a small typo. Excel '97's options have a Max. Iterations and Max. Change, not Minimum Change.

 

• ebs2002

I found a bug: Sanctified Retribution is only giving a 2% DIM, it should be 3% (it used to be 2% back pre-WotLK).

Work-around for now is to just use Freocious Inspiration 3/3 even if you have Sanctified Retribution. Or, you could change cell AB54 from "=MAX(1+0.02*K35,1+0.01*J37*K37/100)..." to "=MAX(1+0.03*K35,1+0.01*J37*K37/100)..."

Edit: found another potential bug. Regardless of the level of your target, you have Armor Penetration's effective cap calculated using the numbers for a LVL80. I am of the understanding that C is calculated based on the target's level, and not the player's level.

C56: "=IF(((1-C57)*C25+15232.5)/3>(1-C57)*C25,(1-C57)*C25,((1-C57)*C25+15232.5)/3)"
C59: "=IF(((1-C58)*C25+15232.5)/3>(1-C58)*C25,(1-C58)*C25,((1-C58)*C25+15232.5)/3)"
C64: it's all over the place. I won't copy-paste it here, but you use 15232.5 a lot

Quote from GC:

 

• landsoul

It's been stated a bunch of times that GC misquoted that statement and C actually works off of player level, remaining at 15232.5. I'm pretty sure it's been tested a bunch by various players myself included. Did you try looking in the combat ratings at level 80 thread?

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

elzilcho

Fluxing Energy Coils are listed with an 8 Agility socket bonus, when it is actually a 4 Agility socket bonus.

 

• ebs2002

/facepalm. I had read through a large chunk of that thread a few weeks back, and completely missed that part.

The other bug still stands, though

 

Wymorence

After playing around with some of the older spreadsheets in turning off all buffs/debuffs except those that I do myself, I think I found the problem (at least on my end) for the #DIV/0 error I kept getting. Whenever I switched Windfury to anything but '1', it throws up the error. Went back and tried it on the current version and got the same result.

 

StaxRexx

I reported a problem with the windfury in the last version but with 406a its disappeared for me. I've tried different combinations all followed by running Sep again and can't duplicate your result. Are you using the '03 or '07 version.

Update: For shits and giggles I downloaded your gear into my sheet and ran Sep without updating any settings... and got the Div/0 I'm looking at the sheet and what's different and the same etc... I want to blame the Mirror of Truth... I'm gonna guess that Trinkets are processed at the same time... Fury shows 100% while Mirror has a Div/0. I had Mirror a short while ago and then picked up my greatness card so now I'm using Grim Toll and Greatness. So I'm leaning towards their being a problem with the Mirror and how it interacts with Windfury maybe.... someone that knows the code for the sheet might be able to find something more solid but its a guess.

 

Wymorence

I'm still using my old trusty '97 version of Office. I'll thankfully be getting my Greatness card come about a week from now when the faire comes back into Mulgore, but for now I'm stuck with Mirror until I can either get some cooperation from Naxx25 bosses to drop GT or my guild finally downs Thorim10 on hard mode (which we've gotten down to around 50% on the first night of attempts).