Squarepushr

Hmm, what's the logic behind midnight chestguard loosing vs slayer's chestguard for me while accoarding to calcualted AEP midnight should win?

 

koaschten

The 2 or 4pc set bonus?

 

Professor Hurt

You will either get flamed or ignored for posts like these and I really want to do both. Unfortunately that means you'd troll longer so instead I suggest you change the security settings of Office to allow macros.

 

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.

 

Jakani

Sorry, I missed your reply and no one else picked up the discussion. I assume you mean to say that if you know your own dodge/resist rate, that you should able to quantify how many extra CPs the talent will yield for you. Like I said, you need to know the number of attacks coming in, and since this number changes for every single encounter (and really isn't consistent from fight to fight for most encounters), you can't model it effectively.

 

Dontmindme

I know a number of people have reported issues with Excel 2007 and get that error. I do not run 2007 myself so its hard to diagnose although others on this board have gotten it to work somehow.

I suspect it to be one of the following (speaking in general - not necessarily your particular case):
1) You do not have the MSXML6 library installed (also linked on the download page)
2) Your security settings are too high. (Although in your case it appears you have resolved that).
3) Some other Anti-virus/Anti-Spyware program is preventing Macros from running or otherwise stripping them from the spreadsheet automatically.

One thing I can add. Once you make changes to your security settings (or anything else), you need to close the sheet and Excel and reopen it to make it work again or else you get the same error (despite fixing the issue). 2003 forced me to do this, I suspect it will be the same for 2007.

In terms of Mac compatibility, the ONLY difference in functionality right now should be the Armory Import. All other Macros should work just as well on a Mac. One reason the saved builds is so useful, especially for Mac users, is that
once your gear is in the spreadsheet, you should be able to use all functions of the sheet even without the Import functionality.

As on the moment, that's all I know. Maybe someone who has gotten it to work with Excel 2007 can provide more information.

 

drumbum

I use Excel 2007 under Windows Vista and haven't ever had a problem with the spreadsheet's macros. Even with the default macro security settings, when I load the sheet, it just gives me a message that macros are disabled and to click a button to enable them. I certainly don't get the error that Blankstar (and some others) have gotten, and once I enable the macros, it works just fine.

Personally I suggest making sure your Office suite is fully updated. The easiest way is to allow Windows Update to update other Microsoft products, which includes the Office suite. There is a service pack for Office 2007 (which I have installed), which perhaps fixed this issue, although I really can't say.

Another possibility is that Office 2007 behaves differently under Windows XP, but I can't really help with that.

 

Professor Hurt

I'm sorry for my sarcasm, but the feeling of "tell me what to do, I don't want to spend any time figuring it out myself" in your first post wasn't helpful. I know from experience (and inexperience) that those types of posts hold no merit and rarely earn a reply, and despite the tone, I still gave you as much input as I could - that being the typical fix for the problem you're having. Regardless, your second post clearly showed you put more work into it now, which is something I recommend anyone does before they post here with questions.

As far as additional input beyond what DMM just posted, I only suggest you head off to office.microsoft.com and verify you have all office-specific updates installed (there are likely to be several service packs available, plus more patches). You may even need to bring your windows installation fully up to date as well.

 

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

 

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

 

Valaran

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

Metagem requirements.

 

• Feist-Mok

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

 

• Vulajin

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

 

Valaran

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

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

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

Nope!


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

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

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

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

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

Misread a post. Please delete.

 

Casterbridge

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

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.