I must have done something wrong:

I load all my gear.
I click the macro.
I get div/0 errors in all the fields.
I go to the nextstat2 tab and the difference values of agility and AP, buffed an unbuffed are all zero. The values in cells B3,B4 and C3,C4 match the respective values in cells B1 and C1.

I ran some test sets, had no problems.
Somehow your problem sounds, like the "all formulas +1" and back to normal didn't work correctly.
You might check wether line 77 formulas (Gear _ Buffs) have +1 in some fields.

Maybe we should better use the real formulas in the macro instead of temp Strings. This would include a standard default setting everytime the macro is used. Negative aspect: As pf mentioned, everytime line 77 is changed, the macro has to be changed, too.

I found what I'd done wrong.

I had inserted 2 lines on the gear_buffs sheet just above the gear area (so I could display total hit and miss %).

Sorry for the false alarm.

Small error in the sheet:
Fool's Bane shows +24 Sta, should be +24 Crit Rating.

Nit-picking:
Trolls show 160 base agility at level 70, should be 159.


Other than that; thanks for the amazing work!

Is there anyway to automatically load in your gear and talents with macros or something? I find it tiring to have to manually put them in each time an update is made.

Also, for the AEP values. Does crit represent 1% critical strike or 1 critical strike rating, same for the weapon skill and hit.

Appreciate the work!

If there are no new lines in the "Gear _ Buff" Section, it seems you can just copy column B and C, line 9 to 127 to a newer version. I didn't see any complications, but can't guarantee there won't be any problems. If you do so, there will pop up an error, just press the enter button and hold down till all errors are gone, hope that kills nothing important.

Thanks, worked perfectly. Now does the crit in the AEP values represent 1% crit or 1 crit rating?

crit rating

I think Mace-spec isn't giving the dps it should in the sheet.

If I set following values for weapon expertice and for mace-spec, I get the folllowing "Values" in the right collumn:
Mace 5 --> Value 5
WEx 2 --> Value 10
Seems like Weapons expertice is rated higher then mace-spec, but both gives same weapon skill (10)?

It also gives different resulting dps, using a spec with mace+wex I get lower dps with a gladiator's bonecracker compared to a gladiator's quickblade. Both have exactly the same stats and I should have same weapon skill on them with mace+wex spec.

In the Sheet Buffed DPS cell F4 has the wrong formula, should read

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

2.2.7f
added
Shadowmaster's Boots
Hit/Miss display @ Talents/Gear_Buffs

fixed
Fool's Bane 24 stamina -> crit
Mace spec @ Talents

changed
Madness of the Betrayer 2ppm

Good would be comparative. What are your other options? You'd be better off with an Abacus of Violent Odds, or a Hourglass of the Unraveler, if you can get them.

I'm curious to see the DPS increase of Survival hunters using Find Weakness to buffed DPS. Is there a way this can get modeled into a future release? Anyone have any knowledge off the top of their heads of how this contributes to our DPS?

Well I have abacus, houreglass, romelus and the icon. so it's not the best I can get
just woundering.
But i did have some time to swing in blasted lands , only 1000swings and 10min. with basicly mindless ss spam w renewing snd , giving me a 19 procs (and 38 swordspec procs) so i would say that it's half a sword spec. Did allsow notice two procs within 3sec so proably not a hidencooldown.

It's typically about another battleshout/blessing of might in terms of total buffage. Really quite nice, and very noticeable.

So on my last Magtheridon kill, I glanced at the debuffs to see how long my Rupture had up and watched my 5stack of DP fall off the target. For this reason, I'm wanting to pick up at least 1 point in improved poisons, but this may have been a stupidly bad streak of DP proc rolls.

Anyone have an idea as to how much of an impact losing a stack of DP has on my damage output, and if that's very uncommon, or something to be expected with 0 in imp poisons?

I have 3 in imp evisc that I don't necessarily need there for anything other than farming/pvp, so dropping a point there for imp poisons may be a good way to go. Also might get Murder instead of imp evisc as well, so I could relocate all 3 of those points. :P

Thoughts on this? I don't think the spreadsheet models the possibility of losing a stack of DP to bad luck, does it?

Any idea why as 20/41 COmbat Fists, the recommended cycles for me (i have 2 pc NB) go from 1s/5r (cut) unbuffed to 2s/5r (cut) buffed?

The buffs mean your white damage crosses the threshold where losing the haste for a second or two(which happens even with 2pc T4 when doing 1s/5r cut) ends up costing you more than the increased rupture uptime gives you. 2s/5r cut won't lose SnD, so you stay permahasted.

I am trying to user stand a dps issue I am having… Trying to figure out if it is lag or something I am doing (or not doing). I figure some of you experts might see the issue or if it is an issue with the sheet.

The sheet suggest 3s/5s/5r for me (combat dagger build)

On boss fight (that I can stay in on)

I run in, get 3cp via Ambush, BS then Slice N Dice
I then BS until I have 5 CP and then Slice N Dice again
Then BS until 5 CP and Rupture…

My issue is Slice N Dice runs out after 4cp, but before 5 so while I wait for the last point for rupture I am loosing white dmg, and then I need to build back cp back up again so I have a LOT of slice n dice down time.

Only think I have come up with is I only have 226 hit. I am wondering it that last 80 or so hit is what makes it work. (Am I just missing so not getting the points, or is something off on the sheet?)

Only solution I have come up with is 3s/3r – that will stay on path, but really seems to hurt the over all dmg.

Question: in all the Rogue spreadsheets I've seen, the Deathmantle 4-pc set bonus is not implemented. I'm currently running with Combat Mutilate and the 4-pc Deathmantle could be phenomenal, depending on the proc rate.

Does anyone know the proc rate of the Deathmantle 4-pc set bonus?

Why are you ambushing? Without Talents, Backstab is a better ability for you. Just take Ambush off your bar and replace it with Backstab. Trust me running in unstealth and Backstabbing is going to be more benefitical to you.

And to answer your question... yes for some reason you aren't building up Combo points fast enough i am assuming it is your hit, but sometimes you get on unlucky streaks and just don't get any CP procs.

I see Darkmoon Card: Crusade still on the ToDo list.

Seems to me that this card should be added as a flat 120 AP.

But, reading from thottbot, I believe that this AP is also added to the whole party. Anyone who can confirm this? ... Would kind of make it in line with the cost of the trinket, aswell as go in line with probably things that the dev-team would be developing.

Anyway, if this is true, then it should still be considered a very good trinket, also giving us rogues some extra usefulness apart from dishing the dmg.