Great spreadsheet Deathwing, thanks for all the work you put into it.

The only issue I have found so far is with the Diamond Flask, it seems to add way more overall DPS then would be expected of a trinket of that level (currently adding about the same overall DPS as a Kiss of the Spider). I think the problem is with the cooldown field. I changed the number in that field from 60 (I figured it was in seconds) to 240 and that seemed to drop the DPS level back to what would be expected and changed the number in the strength field to 18.75 from 75.

Yes, the cooldown fields are in seconds. They reason you're seeing that is because setting Diamond Flask's cooldown to 60s cuts its original cooldown by 1/6, while for Kiss of the Spider that's only 1/2 the original cooldown. I put this feature in as a request, if you want to see how the trinket performs if you have to leave it equiped for a long fight, just put the cooldown field to 360. Most trinkets will beat it then.

yeah thats what I figured wasnt sure if you were aware of it or not. Thanks again for the awesome spreadsheet been playing with it for about a week now :D

It looked to me like HS was modeled correctly. I didnt look too close though.

Incoming damage per second should be a user specified input just like target level would be. Some fights (huhu) you are going to take a lot of incoming damage that will be converted to rage and others you wont. Then the HS equation would use up whatever excess rage you generate (I think its 60 incoming damage per 1 rage? or was it 90?)

There are a few other user inputs that would be potentially useful. Attacking from the back and mob block value. I'd also move the beserker stance into a user input where you put a drop down to select between the 3. It would be needed for tanking anyhow. Too many user inputs can get confusing though..

It shouldnt actually be that accurate. You didnt change the mob mitigation and I doubt Patchworks AC after debuffs comes out to exactly 20% mitigation. It also doesnt handle optimized trinket/Death Wish/recklessness usage or most importantly, imperfect ability usage due to lag/cooldowns coinciding. It seems that the errors happened to cancel out which is great but I don't want anyone to think the spreadsheet is accurate to 99.96% :)

I want to reiterate what Celandro is saying. This spreadsheet is in no way supposed to tell you what dps you should get. I think it's more coincedence that Sekdar's lines up so closely. Again, this is just a tool for comparing gear and playstyles(and pissing off rogues ;)). I could have just as easily used an arbitrary point system instead of total dps to accomplish the same goal.

Celandro, those are some good suggestions, I'll have to move around some stuff to make it fit nicely. I'm still not sure even the most astute person know off the top of their head the average dps for every boss in AQ40, let alone every other instance. I guess this can be used a more abstract agro ceiling. As in, if your ThreatPS is 20% higher, you should probably change your playstyle.

Finding incoming damage per second is not hard at all. All the damage trackers have it and if you look at the patchwork damage meters, if they changed that to incoming damage per second they could plug that into the field. Its actually harder to find mob ac mitigation since very few if any mods calculate it correctly.

Of course finding what your dps is on Huhu for example with the spreadsheet is going to be hard unless you add every nature resist item in the game.. It might be easier to add a simple tab where people could put their unbuffed AP, crit, +hit, +skill, weapons, etc without having to pick all the armor and gear. It wouldnt have to be as accurate as the main tab, just a rough guess for resist gear.

With my current gear, Ghoul Skin Tunic is a better option than Plated Abomination Ribcage. :O

I'm pretty sure the only coincidence here is the 20% mitigation, because I didn't coordinate any cooldowns (panicked when a tank bit it towards the end and completely forgot about trying to do that). Lag was minimal and I was mashing my attacks as they came up the whole time. Didn't do anything out of the norm or have/use anything other than passive buffs. Mitigation aside, there was no reason the spreadsheet shouldn't have been spot-on. I do see your point, though.

So the next logical thing to ask is, is there a reliable mod for determining mob AC? :)

For a rough guess you can just use 1 hamstring. It normally hits for 45. If it hits for 38 the ac migiation number to put in is (45-38)/45 = 15.5%
It will be somewhere between (45-38.5)/45 and (45-37.5)/45

Or you can use bloodthirst, and use (AP * .45 - bloodthirsthit)/(AP * .45) but you have to be really careful with crusader and other buffs.

I'm trying to get rid of this nasty #DIV/0! error whenever switching between 2H and DW. Anyone know if there is a way to check in excel if a referenced cell has an error before using it? I've tried:

[top]IF(B34

"#DIV/0!", 1, B34)

But all that returns is the #DIV/0 error

Ok, new upload, mainly to fix that pesky error:

http://www.savefile.com/files/3259544

Removed White Flurry Chance field, made the equation circular and upped the iterations
Added BoS and Tranquil Air Totem
Fixed #Div/0! error when switching from DW to 2H


Because of the circular nature of the spreadsheet, do not select a blank item from the pull down menus. If you happen to, just quit and reload the spreadsheet, don't save. Selecting those items will cause a #N/A error to propagate through the spreadsheet, and it's not easy to remove.

I noticed you have Juju Power listed, but not Juju Might.

That was one of things that I wasn't sure stacked(I play alliance, so we just got access to those), so I plain forgot about it. Thanks for reminding me.

Do all juju items stack?

Deathwing They stack. I also tend to use JuJu Flurry sometimes in a fight. Doesnt make much, but all buffs matter in a long run :)

Edit: The savefile download doesnt work. Could you put it up somewhere else?

Juju Power & Juju Might stack.. although Juju Might does not stack with Firewater.

I typically use Juju Power + firewater on longer fights, since Might doesn't last very long and is a little harder to get. Juju Power + Juju Might would be ideal for patchwerk though.

A question Deathwing. How is the Misplaced servoarm proc dps calculated? Since its no way near the 27.47 proc dps as it shows out to be in the spreadsheet.

I have it, and out of 12k hits its a 4 proc per minute. Avg dmg ~125. 4*125/60 = 8.333.... dps

So shouldnt it be 8.333... proc dps ?

Haha, 4PPM is higher than I have it now. Are you sure about that, have you used a mod to parse it?

When you use the PPM system, you get extra procs from haste and yellow hits. So, 1 PPM means unhasted, no yellow attack, the person will get 1 proc per minute. Also, with Servo Arm, offhand generates procs.

Im using procwatch.

This was when i grinded rep with bloodsail buccaneers. 10 hours of constant ww/cleave grinding made those numbers. I've no idea how procwatch run the numbers for PPM. But thats what i get it till, and it actually seems quite right.

I found something interesting...perhaps a bug?

This is the inital setup of the spreadsheet according to my gear
http://i104.photobucket.com/albums/m...ital_setup.jpg

Changed the 2nd trinket slot to DFT
http://i104.photobucket.com/albums/m...bit/step_1.jpg

Changed the 1st trinket slot to Blackhand's Breadth
http://i104.photobucket.com/albums/m...bit/step_2.jpg

Changed the 2nd trinket slot to Hand of Justive
http://i104.photobucket.com/albums/m...bit/step_3.jpg

Now the White DPS should be back to where it was on the inital setup as the gear hasn't actually changed, but if you loko at the actual white DPS in the last img and compare it with the first image you'll notice that they're not the same anymore.

Yeah, I do trinkets in a weird way because of Darkmoon Card: Maelstrom. Basically, if you're using Maelstrom, it should go in the first slot, and HoJ should always go in the second slot. Thanks for catching that, I forgot to mention that. I'll write up a fix for the next release.

Juju power (30str) doesn't stack with elixir of giants (25str)
Juju might (40ap) doesn't stack with winterfall water (35ap)