DPS Spreadsheet - Page 50

Valaran · 04/01/08, 10:46 PM

I'm experiencing something odd with this spreadsheet. It seems like it HAS to be a bug, but I need to post here to be sure.

I'm configuring the spreadsheet for my alt rogue and I'm concerned with gemming my S3 chest. Initially, it showed the S3 chest with 2x Glinting gems & 1x Shifting gem as being 9 DPS above the Tunic of the Dark Hour. So, naturally I decided to save my 100 badges and a month of waiting, and replace my crappy blue chest thinking S3 was a good PVE upgrade as well.

However now that I've got it, I'm plugging gems into the spreadsheet and this makes NO sense.

Without gems, it shows 1252.15 buffed DPS (yes, my gear does suck).
With 1 Glinting Noble Topaz, it shows 1256.81 DPS.
With 2 Glinting Noble Topaz, it shows 1261.48 DPS.

When I add the Shifting Nightseye, the DPS jumps up to 1290.18 DPS.

Now, I have a hard time believing that 4 Agility and 4 Crit Rating is capable of increasing my buffed DPS by almost 30.

Have I just found a really weird bug, or am I missing something very obvious?

Respectfully,
Val

EDIT: On another note, I tried removing all of my gear in the spreadsheet except for the weapons, and the chestpiece. I tried adding these gems again, and the 30 DPS jump did NOT happen this time; in fact, it was pretty much similar DPS no matter what gems I equipped.

Cyn · 04/01/08, 11:12 PM

Metagem requirements.

Feist-Mok · 04/02/08, 12:05 AM

Originally Posted by Aaberg

According to Wowhead, the setbonus has a 100% proc chance, but would need further testing.
Wowhead - Fists of Fury

Not true. Don't know the procrate for sure, but it is WAAAY less than 100%

• Vulajin · 04/02/08, 12:06 AM

Originally Posted by Aaberg

As far as I could tell, I've set every setting as I should, but can't seem to find the fist weapons that drops in Mount Hyjal from trash, which was added in 2.4. I ofc. modelled them myself, just want you to know.
MH:
[Claw of Molten Fury]
And its counterpart, OH:
[Fist of Molten Fury]

According to Wowhead, the setbonus has a 100% proc chance, but would need further testing.
Wowhead - Fists of Fury

100% proc chance on Wowhead almost always indicates a PPM effect.

Valaran · 04/02/08, 12:20 AM

Originally Posted by Cyn

Metagem requirements.

I don't see how that can be it. The requirements for my meta gem are met by my other slots, before the chest is even considered. My current blue chest (Hauberk of Karabor) has zero gem slots; so adding more gems should not be affecting the numbers in such a way!

My 2 blue gem requirements are met by Shifting Nightseye's 1 in my belt and 1 in my pants.

EDIT: Nevermind, I feel stupid and I thank you for making me look at something different here. A gem in my belt wasn't entered correctly so it was thinking I wasn't meeting my metagem requirements, as you said.

Apologies for wasting your time.

sp00n · 04/02/08, 4:17 AM

I noticed a bug when I switched the mob type to demon (as we're currently at Brutallus). The unbuffed Melee, Other and Total DPS now show N/A, Sinister Strike and Finisher DPS still show a number, and all % cells also show only N/A.
This happens for all mob types that are not affected by Murder (demon, elemental, undead, other), though changing Murder to 0 talent points didn't help.

The source seems to be Unbuffed DPS, cell B51.
In the Buffed DPS, it reads 100%, whereas Unbuffed it is 0%.

I changed the formula from =B50 to =1+B50 (is this correct, no other multipliers?), which fixed the N/A errors.

Dontmindme · 04/02/08, 9:11 AM

Originally Posted by sp00n

I noticed a bug when I switched the mob type to demon (as we're currently at Brutallus). The unbuffed Melee, Other and Total DPS now show N/A, Sinister Strike and Finisher DPS still show a number, and all % cells also show only N/A.
This happens for all mob types that are not affected by Murder (demon, elemental, undead, other), though changing Murder to 0 talent points didn't help.

The source seems to be Unbuffed DPS, cell B51.
In the Buffed DPS, it reads 100%, whereas Unbuffed it is 0%.

I changed the formula from =B50 to =1+B50 (is this correct, no other multipliers?), which fixed the N/A errors.

I'm pretty sure that is the only unbuffed global damage modifier, although I'm also very likely to move Dirty Deeds over to there as well.

As to the formula, that change will overstate the damage if the mob is murderable. Change it to =Talents!E18 for the time being. Or else do that change and go to Global Var, find tlMURfac and take out the 1+ there as well. The Global damage table is pretty much only partially finished. If you look at buffed, it doesn't even use Murder in that table.

Squarepushr · 04/02/08, 9:14 AM

Originally Posted by koaschten

The 2 or 4pc set bonus?

Nope!

Originally Posted by Ticia

Assuming you Gem Midnight with Glinting Pyrestone, Rigid Lionseye, and Shifting Shadowsong; and that you gem Slayers with 2x Rigid Pyrestone and a Shifting Shadowsong:

Using the EP Weights from the Roguecraft 101 Thread for T6 Level Gear (Combat Swords):

Slayer's:
50 Agi - 108 EP
35 Hit - 84 EP
28 Crit - 46.8 EP
100 AP - 100 EP
Total: 338.8 EP

vs.

Midnight:
10 Agi - 21.6 EP
44 Hit - 105.6 EP
46 Crit - 76.8 EP
114 AP - 114 EP
Total: 318 EP

So unless I'm missing something, the Slayer's comes out as being better in terms of base EP, not even taking into account the T6 Set Bonuses

Still, the spreadsheet's giving me higher aep (with armor/dodge e.t.c. as 0 value) for the midnight but higher dps for the slayer's, I thought aep was calculated by dps gains with the curent gear~

Also no I'm gemming full 10hit in both

Casterbridge · 04/02/08, 9:17 AM

Hey guys I was wondering if someone could verify something for me.

Here's my armory link: Dhargon

I downloaded it to the spreadsheet and switched my spec to combat swords and plugged in: Talon of Azshara

I then changed my spec to fist/sword combat and plugged in:Vanir's Right Fist of Brutality

I expected the fist to beat the sword however what I'm seeing on the spreadsheet is showing the opposite. Am I missing something or does this sound right?

Feist-Mok · 04/02/08, 9:42 AM

for a human rogue, any sword or mace can be considered to have ~ 20 passive expertise in additional stats. Its an extremely powerful racial, and, barring giant itemization gaps, effectively kills fist or fist/sword specs. Add in just how well itemized the talon is, and Vanir's just isn't very compelling.

Aarcani · 04/02/08, 9:52 AM

I'm getting the same result as a dwarf. I was planning to get the Vanir's fists to finally get out of combat daggers (heartrazor/merc), actually playing with mutilate right now which seems to be doing just as well or a little better than combat daggers was.

Back on point, planning to get fists, Azshara dropped last night, I had passed to another rogue the first time because he needed an upgrade more, no one else wanted it last night so I took it to save from sharding.

Plugged it into the spreadsheet with merciless quickblade and was very surprised to see it beating both dual vanir's and vanir / merciless quickblade.

Casterbridge · 04/02/08, 9:56 AM

Originally Posted by Feist-Mok

for a human rogue, any sword or mace can be considered to have ~ 20 passive expertise in additional stats. Its an extremely powerful racial, and, barring giant itemization gaps, effectively kills fist or fist/sword specs. Add in just how well itemized the talon is, and Vanir's just isn't very compelling.

Thanks that's the only thing I could think of, I know the sword/sword spec is more powerful, but I figured that fist was strong enough to counter it. I had figured the fist would still beat it, but not by as much which would mean that as long as I can get Tidewalker to drop that stupid sword in the next couple of weeks (before the badge vendor gets released) I won't worry about spending my badges on the fist.

Anyway, thanks again.

todemax · 04/02/08, 11:11 AM

Misread a post. Please delete.

Casterbridge · 04/02/08, 11:45 AM

Originally Posted by Aarcani

I'm getting the same result as a dwarf. I was planning to get the Vanir's fists to finally get out of combat daggers (heartrazor/merc), actually playing with mutilate right now which seems to be doing just as well or a little better than combat daggers was.

Back on point, planning to get fists, Azshara dropped last night, I had passed to another rogue the first time because he needed an upgrade more, no one else wanted it last night so I took it to save from sharding.

Plugged it into the spreadsheet with merciless quickblade and was very surprised to see it beating both dual vanir's and vanir / merciless quickblade.

Yeah I noticed this to, I plugged it in for a Night Elf rogue in my guild, and it to worked out in the Talon's favor, albeit not as much when compared with my human rogue.

Falkyrk · 04/02/08, 11:53 AM

Originally Posted by Blankstar

Well thank you for your 'slightly sarcastic help', but I Microsoft Software skills are just enough to know Windows Systems are a big security leak and thus all settings for code and auto-run stuff are disabled by default.

Yet, as a Mac User on a Windows System, I still feel like noob so to review: I chose these settings;

ActiveX Settings:
- Enable all controls without restrictions and without prompting (not recommended; potentially dangerours controls can run)
- No Safe Mode
Macro Settings:
- Enable all macros (not recommended; potentially dangerous code can run)
- Trust acces to the VBA project object model
External Content Settings:
- Enable all Data Connections (not recommended)

So in short: evil excel files can screw me over big time.

Yet when I open the file I still get this error;
"This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

Is there someone, unlike Professor Hurt, that really has a clue how to fix this?

Thanks for your help.

I don't have 2007 at work here to explain fully the steps, but I run it at home and fixed this very issue. You need to click on the Office icon in the upper left corner to open that menu. Somewhere in one of those menus is a checkbox for turning off the security thing. I found it by googling that error you quoted.

Also make sure you have Visual Basic installed. Alt-F11 in Excel brings up Visual Basic, so do that to know if you have it installed or not.

I'll see if I can dig up the article for you.

[edit]
Macro settings can be viewed or changed by pressing the Office button, clicking Excel Options (at bottom of the Office menu), selecting Trust Center from the list of Excel Options, clicking Trust Center Settings…

When in there, I changed the setting and the spreadsheet works correctly.