• Viper

I'm pretty sure there have been at least a dozen posts on this exact issue already so I'll say it again in the hopes that someone reads the thread before posting.

The dropdown menus for gear only have a certain length to them. If you turn on every subset of gear from 5 mans to Hyjal and Black Temple, there will be too many items in the list so the things at the end of the alphabet will be cut off. Just turn off the sections that aren't applicable to you and you can find whatever items you want.

[e] As far as Insignia of the Mag'hari Hero goes... just get a Choker of Vile Intent? No worries about random luck on that one.

 

tucciim

Thanks for the response. I have been reading the thread and did see the posts about the check boxes on the side. That is why I have the appropiate boxes checked for my guilds progression (5man, heroic, kara) as well as the set above (rep, quest, boe, ..). the insignia is not in the drop down box as it should be. This seems especially odd considing the tunic from the same quest line IS avail with those same boxes checked.

I guess I was trying to determine if it had been removed, or if it was a tiny bug.

Thanks also for the tip on the choker. I'm going to aim for the bloodlust brooch first unless romeo decides to drop the vial for me.

 

Radmsc

well, that's not my point, I currently have a relentless earthstorm diamon, but have 2 shifting nightseye. Now when I push on the "upgrade gem" is says the shifting nightseye can be upgraded by many gems, which is not the case, coz if I do, I nerf myself by disabling the meta gem. So what I basicly suggest is that then u push that button, the comment on the gems cells is being adapted with keeping the meta gem in mind.

 

• Rerox

Seems like it has been removed.
There are only 19 Neck-Pieces in the sheet at the moment:

Bone Chain Necklace, Braided Eternium Chain (w/ +28crit), Braided Eternium Chain (w/o +28crit), Choker of Animalistic Fury, Choker of Endless Nightmares, Choker of Serrated Blades, Choker of Vile Intent, Earthen Mark of Razing, Natasha's Choker, Necklace of the Deep, Pendant of Triumph, Prestor's Talisman of Connivery, Saberclaw Talisman, Talon Lord's Collar, Telonicus's Pendant of Mayhem, Traitor's Noose, Veteran's Pendant of Triumph, Worgen Claw Necklace.

You can easily check and edit the items in the sheet yourself. Ellos explained in Post #128 how to do it. Before you can edit the List you must first "unhide" the Table by klicking "Format"/ "Sheet" / "Unhide" and then select the appropriate Item-Location Sheet (in your case "neck").

To be honest I would stick to the "Chocker of vile intent" first, if "Worgen Claw Necklace" still decides not to drop for you (they are quite equal in stats). You'll keep one of the two Neck-pieces for a very very long time. There are still several extremely good Trinkets besides BLB so waiting on that one for some time longer will not hurt much (depending on what trinkets you have).

 

Keviel

Thanks mate - I actually knew, and didn't realize how stupid that question was until you answered. Must've had a real brain dead day yesterday. Let's see if today gets better ^^ Considering spending some time at work looking at that Mutilate cycle formula, since there seems to be jack all to do today.

Does the sheet actually calculate with average attack values, or does it derive average from end calculations of max/min? I.e. should the formula be using Max and Min, as two separates, or making a single formula based on average?

 

Rinced

When trying to import with version 2.2.07 :

When trying to export with version 2.2.05 :
Excel completly freezes.

OSX 10.4.10
Microsoft Excel 2004 for Mac
Version 11.3 (060914)

*fixed link

 

sp00n

While basically it's a good idea to post thumbnails instead of the original screenshot, not providing the link to the original screenshot it not such a good idea. Makes it kind of hard to actually see what you wanted us to see.

Here we go:
http://img513.imageshack.us/img513/6599/rdpsed0.png

 

Zurgat

OK, we have DPS now.
Just as a thought, might it be nice to have TPS listed in the same spreadsheet? (Threat)
It would seem a small step from 1 to the next, since threat shouldn't be a huge calculation once you know your DPS.

Obvious modifiers would be:
* Use feint? (-x)
* Prism of Inner calm (?)
* Tranquil Air totem (20%)
* Blessing of Salvation (30%)
* -29% threat by default

It's just a random idea, and it'd assume you're not using "vanish" to completely clear your threat.
I'm still curious though, for instance what effect the prism would have on your actual threat output.

In a way your actual damage is always linked to the threat that the main tank can produce.
If the spreadsheet could show our estimated TPS, then we'd be able to compare that to the TPS of the tanks.

-= Random Ravings - RSS Feed =- Rogue and Hunter stuff here. As well as guides to get you trough your spare time.

 

Sneakerpimp

Indeed, this would be very helpful.

Other potential modifiers:
* Shrouding Potion
* Sublety cloak enchant

 

Wodahs

I believe you get that import error when the export file is not open. Not sure on your export error though.

 

Radmsc

There are several trinkets as well which have a use which reduces your threat.

 

Ellos

Thinks like tps are thinks I'll make maybe later. At the moment there are enough bugs in the current version I have to fix, but I need time that I haven't at the moment. When I got more time, then I'll fix the bugs first, and then see whats next. There are huge things that should be change.

- procs have to work different, there not very well at the moment
- better cycles, I have a idea how they could be at the end, but it needs much time to make this

and well, maybe tps.

I'll see when I got time to make this.

 

Andeh

As of version 2.2.0.7, I get a Compile error: Sub or Function not defined, using Microsoft Office 2004 on my Mac.

It looks like it is happening in Modul3, on the line "Public Sub UpgradeCheck(ByVal TargetRow As Integer)" or "Listname = Replace(ItemCell.Validation.Formula1, "=", "")". (I'm not sure what the highlighting colors mean in the debugger... the first line was highlighted in yellow with an arrow next to it, the other one just had Replace highlighted blue.

This happens for any of the upgrade checks. Unfortunately, I don't have a copy of Office on my PC, so the only way for me to use any of the macros is on my old laptop.

Thanks for the cool features you've been implementing.

 

Oscarvil

Is adding threat really relevant to this sheet? It is supposed to calculate a theoretical maximum dps and help you compare items and talents to help improve your dps. It is widely accepted that no fight in the current game matches the conditions of this spreadsheet and that you'll never reach the dps that it calculates. Therefore having another number which is far removed from the reality of the game may only add confusion and not give any real insight.

Surely in the theoretical situation of maximum dps the threat you put out per second is DPS*0.71*(modifiers)? Does this number mean anything at all? In any real situation threat fluctuates with dps which in turn fluctuates with the amount of time on the target, the precision of your cycles and the RNG. Will adding another number really be useful and/or relevant?

I can see value however in adding a feint button. How does spamming feint (-10 energy per 10 seconds and -1gcd) affect my cycles?

With reguard to -threat trinkets, they seem to me to be an inefficient use of a trinket slot when a vanish clears aggro completely. Similarly tranquil air totem vs. windfury, similarly subtlety to cloak now that we have better than +3agi as an alternative. Any fight where tank threat is the limiting factor seems to me to be out of the scope of this spreadsheet.

 

gakutomagnum

A lot of this stuff isn't working with OpenOffice for some reason. I can only pick out daggers in the drop down? Gems don't show up? Hm?

 

Kytrarewn

This has gone on so long it's getting silly. When you have Blessing of Kings, Strength is worth 10% more than AP. Is it really that difficult a fix?

ΜΟΛΩΝ ΛΑΒΕ


Jesus don't want me in a sunbeam
Sunbeams are always made on me
Don't expect me to cry, for all the reasons I'm gonna die
Don't ever ask your kick of me.

 

Maurice2u

Agreed. No need to add extra complication to an already complicated thing. This is "vs. a attack dummy w/ unlimited hitpoints and no damage given back" kind of calculator.

 

Backgoode

One thing that should be noted is tranq air and salvation don't stack. Since all rogues will have salvation for any bossfight that really matters, multiplying your theoretical DPS by .497 will give you your theoretical threat generation. Considering vanish is a complete agro wipe, with any tank in equivalent gear to yours should be able to keep threat if the rogue uses vanish properly.

 

Ellos

To fix this I had added extra AEP for Strenght some time ago. Withtout Kings AP = Strength, with Kings Strength > AP.

So where should be an error?
Works for me.

 

Karmon

Yes anything that is done with macros will not work
Look at cells Y44 Y45 in the gear sheet. There is now a dropdown box to select weapon type
Hm yup.
This error seems to have itself introduced again.
If you want to fix it for yourself, mulitselect all the greyed out gemcells, then
open in the menu "Format->Conditional format".
In the dialog that pops up you will find a cell that looks like 'Gear _ Buffs'.$D12.
Change the D to a C and hit OK your set

 

Rinced

Manually put in my data.

Clicked on the "Items" button, waited a few seconds and the debugger popped up telling me
"Sub or Function not defined"

The debugger showed me this this window (along with others):


In the line "Listname = Replace(blabla)" "Replace" was beeing highlighted.

Again

OSX 10.4.10
Microsoft Excel 2004 for Mac
Version 11.3 (060914)
RogueDPS_2_2_0_7.xls

EDIT : Same thing is happening for Enchants & Gems.
EDIT 2: AEP works but buffed AEP for AP and STR are different, what doesn't make sense to me.

 

sp00n

Strengths is affected by Blessing of Kings in the buffed AEP, therefore yielding more AEP than pure AP, which is not affected.

This is of course, if Strength was higher rated than AP in your sheet. Otherwise, it'd be a bug.

 

Sneakerpimp

You're right that 1) TPS isn't relevant if the sheet's only goal is to model DPS, 2) the TPS estimate (like the DPS estimate) would simply give a rough approximation that you're unlikely to ever actually replicate in game, and 3) TPS is less relevant for rogues who have an aggro wipe than, say, DPS warriors who don't.

However, I still think TPS would be helpful for the same reason that the DPS estimate is helpful: for comparing various specs, gear, and buffs. For instance, it would be great to be able compare the impact on DPS and TPS of feinting every 10 seconds versus, say, using anesthetic instead of instant poison (as well as how points in imp talent influence this), running with subtlety instead of +12 agility, and running with salvation instead of might or kings if you don't have enough pallies to get all three. Doing any of these things reduces both DPS and TPS, and if it were modeled in the sheet one could compare the efficiency of each. As well, the fact that we have an aggro wipe does not make TPS irrelevant. Some boss fights are very aggro sensitive (such as those with rotating MTs), and wiping aggro once or even twice during the fight doesn't necessarily mean aggro is never an issue.

So in sum, I think TPS would be a great addition. But easy for me to say, since it's not me that would actually update the spreadsheet.

 

Oscarvil

TPS is just a multiplier of your dps, there are no complicated mechanics which require modeling in the sheet. Equipping gear with higher dps means you will be putting out higher threat, it's really that simple.

Got salv instead of kings? Click off kings buff. Got subtlety instead of 12agi? Click off your cloak enchant. The sheet will tell you your maximum dps in both of these situations. Less dps = less threat. (And who doesn't get salv if they have the choice? This means 30% more damage before having to vanish. Hm this is a discussion for another thread methinks.)

In an aggro sensitive fight even the dps part of the spreadsheet is irrelevant because you will not be keeping up a cycle anything like what is modeled in the sheet. In situations like this you need to do the maximum dps you can while staying under the MT's threat, having a number telling you your maximum TPS in a sustained dps situation won't help you here. I would suggest a threat meter, which will give you a realtime comparison of how your actual TPS compares to that of your MT. Learning how to play in these situations is up to you.

 

Malan

Do you rogue have a well defined value for Armor Penetration effects, such as the one on [Madness of the Betrayer]? We're a bit stumped in the Enhance Shaman thread on how to determine how much DPS that effect is worth. (the effect of -Armor, not the proc on that trinket itself)

Shitting up every single thread on EJ since '06