Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Rogues

Closed Thread
 
LinkBack Thread Tools
Old 08/06/09, 2:24 PM   #976
Xaoc
Piston Honda
 
Orc Rogue
 
Eitrigg
Its not really helpful at all to have all three weapon specs selected in the spreadsheet. Having them all active is going to give you erroneous data based on information that will never be accurate.

Offline
Old 08/06/09, 2:26 PM   #977
Lokar
Von Kaiser
 
Human Rogue
 
Black Dragonflight
If you do a search on the Armory, you seem to be able to view mostly (if not fully) completed loot lists.

The World of Warcraft Armory

This may help for getting things added to spreadsheets sooner.

Offline
Old 08/06/09, 2:35 PM   #978
mpiemont
Glass Joe
 
Troll Rogue
 
Mannoroth
Originally Posted by Xaoc View Post
Its not really helpful at all to have all three weapon specs selected in the spreadsheet. Having them all active is going to give you erroneous data based on information that will never be accurate.
I agree however having all three selected doesn't actually change the calculated DPS as long as you dont screw up and start wearing a Mace/Sword, Sword/Dagger, etc. As long as you equip weapons of the same spec it will be accurate. That being said, if you aren't sure what you are doing this is a great point and please just only have 1 spec up at a time. I just have them all active so I can quickly evaluate if switching to sword spec or CQC is better based on item drops without having to click the button 100 times.

Offline
Old 08/06/09, 5:34 PM   #979
Ruohttas
Glass Joe
 
Troll Rogue
 
Kilrogg
I've been trying to modify the sheets, but with little success. I think it may be more of an issue with Open Office then anything else. I can understand if you are busy right now Ald, but do you think you will be able to update with the new gear, and get Axes added? Thanks a bunch!

Offline
Old 08/07/09, 4:43 AM   #980
Istarian
Glass Joe
 
Human Rogue
 
Lightninghoof
Originally Posted by Ruohttas View Post
I've been trying to modify the sheets, but with little success. I think it may be more of an issue with Open Office then anything else. I can understand if you are busy right now Ald, but do you think you will be able to update with the new gear, and get Axes added? Thanks a bunch!
When you do, could you also leave the sheets in which you have item / gem data stored unlocked? It could be something to do with the fact that I use Openoffice, but if they were open like in Mpiemont's sheet I'd greatly appreciate it. It will allow me to add any new pieces of gear and test raw values like I can do with your Mutilate Spreadsheet.

It's probably harder to do now that you've already formatted your Combat sheet as it is, but if somehow the new one could be modeled just like your Mutilate spreadsheet is that would be perfect for me. Yes I realize the sheet isn't being formatted for me, but if you were thinking of changing it in that way, you have my thumbs up! Keeping it as is is also just as good, so long as there's an update.

On a sidenote: Regarding T9, has anyone extensively tested and seen results as to how high the proc chance of the 2 pc bonus is? How does it compare to dropping 4 pc t8.5? (Obviously depends on the pieces under discussion and which off pieces are being used) If the set bonus (with its procrate) were to be isolated, how does it fare?

Offline
Old 08/07/09, 6:01 AM   #981
ekval
Piston Honda
 
Worgen Rogue
 
Stormreaver (EU)
Originally Posted by mpiemont View Post
EDIT: Added crafted chest & wrists!

Combat_3.2_v4.zip
Thanks for this. You missed [Rigid Dragon's Eye], [Smooth Dragon's Eye], [Quick Dragon's Eye] and also [Bright Dragon's Eye] didn't have correct value. Easily fixed by myself but might want to add those for yourself. Of course these are inferior to [Delicate Dragon's Eye].

Also missing epic gems but that is probably on purpose.

Last edited by ekval : 08/07/09 at 6:12 AM.

Offline
Old 08/07/09, 7:51 AM   #982
Hallie
Glass Joe
 
Human Rogue
 
Aszune (EU)
Originally Posted by mpiemont View Post


EDIT: Added crafted chest & wrists!

Combat_3.2_v4.zip
The sheet breaks whenever I select a mainhand weapon with a gemsocket. Thanks for investing time into updating the sheet!

Offline
Old 08/07/09, 7:57 AM   #983
ekval
Piston Honda
 
Worgen Rogue
 
Stormreaver (EU)
Originally Posted by Hallie View Post
The sheet breaks whenever I select a mainhand weapon with a gemsocket. Thanks for investing time into updating the sheet!
Re-adding gems to item that broke the sheet fixes it.

Offline
Old 08/07/09, 11:27 AM   #984
mpiemont
Glass Joe
 
Troll Rogue
 
Mannoroth
Thank everyone for their comments!

I have made an updated combat spreadsheet due to a significant number of new items that have been discovered! I also incorporated a lot of the comments and feedback, thanks

I still do not have T9 or trinkets in here as I don't have experience with modeling them. I hope to update the Mutilate spreadsheet soon as all I have to do is copy and paste the new gear/gem tables.

Additions:
1. Changed spec to 1 spec active instead of "all active" to avoid confusion with people incorrectly using it.
2. Added new epic gems
3. The sword with gems that "broke" the spreadsheet shouldn't do it anymore. To fix similar problems simply reselect the gem and it should fix itself.
4. Added all newly discovered loot and crafted wrist/chest
5. Updated Twirling Blades with correct stats
6. Added a section where you manually enter your old DPS and it calculates +/- % change
7. Added Coliseum filters


Many thanks to the creator's of the original spreadsheet and theory-crafters! I hope you can use my gear additions to make it easier to update the new "official" spreadsheet when it comes out instead of manually re-entering everything from scratch.


Combat_3.2_v5.zip

Offline
Old 08/07/09, 11:36 AM   #985
sarGz
Glass Joe
 
Human Rogue
 
Kazzak (EU)
Originally Posted by mpiemont View Post
I'll share my edited version of the spreadsheet with new gem info, gear, and some other goodies for all who want to save some time.

Combat_3.2_v4.zip
When I fill in the same items and gems in this and the original version I get totally different outputs.

Check my armory, the current thing I'm trying to figure out is if I should stick with the [Furious Gladiator's Longblade] or switch to the [Serilas, Blood Blade of Invar One-Arm], which I of course recieved the day I bought the arena one.
Also there were different outputs concerning the offhand, [Rune-Etched Nightblade] vs. [Void Sabre].
The original version gives me highest DPS with my current setup equiped, while this modified one gives me best with the Serilas and Void Sabre.
I'm normally using the Grim Toll instead of the Banner of Victory, but due to the higher values stat-wise on the Banner I decided to test it out a bit, but it puts me quite low on hit rating, which I don't like.

Since I can still save 3000 arena points and refund the arena sword if it turns out that Serilas combo is actually better, I would really appreciate some inputs about this if anyone got something they'd like to share.

Which of the spreadsheets is the most accurate? (PS: I did edit the 16 agi into 20 agi gems on the original too)

Offline
Old 08/07/09, 12:00 PM   #986
mpiemont
Glass Joe
 
Troll Rogue
 
Mannoroth
sarGz:

I just added the new gear and changed the gem properties (especially Prismatic from R/Y/B to R mostly) which may affect DPS output due to the properties change and socket bonuses. I didn't modify anything in the calc section (I'm too scared too).

I loaded up the original before I made the edits and I get the same results you are getting now (you confusing it with remorse or have the wrong spec equipped in the sheet?):
Void Sabre > Rune-Etched Nightblade
Serilas > Furious

The Serilas looks like it has a lot more bang for the buck in terms of stats when compared to Furious, but that's just me looking at it.



EDIT: I looked at your sheet and you did a lot of editing on your own, I have no idea what is right or wrong. Only way for you to check is to download the original one on page 1 and compare your results to see if you changed something accidentally. Also 20agi gems are unique equipped, only 1 bro

Last edited by mpiemont : 08/07/09 at 12:27 PM.

Offline
Old 08/07/09, 12:07 PM   #987
sarGz
Glass Joe
 
Human Rogue
 
Kazzak (EU)
With my shizzle added: Combat.xls (I edited gems value, but not the names)

I don't understand the calculations when the suggested upgrades makes my calculated DPS go down. What am I missing?

(Oh and ignore the trinket, put on a normal one - I probably failed when I tried to add it myself)

Offline
Old 08/07/09, 12:22 PM   #988
evoslayer
Von Kaiser
 
Orc Rogue
 
Azjol-Nerub
Seralis is better, no question about it, for rogues at least the arena weapons are largely sub par for dps, maybe if you are at the expertise cap without Seralis the PvP weapon could be better.

Offline
Old 08/07/09, 1:14 PM   #989
sarGz
Glass Joe
 
Human Rogue
 
Kazzak (EU)
I seem to have mixed in some old version of the spreadsheet and kept updating that instead or something, quite stupid, but when I downloaded a fresh one and added in the items it turned out similiar to yours (mpiemont).
Although it seems like I should've sticked with Masticator\Bootblade in the first place, but what can I say.. I'm weak for sword procs!

Originally Posted by mpiemont View Post
Also 20agi gems are unique equipped, only 1 bro
I hope you realize that's a wrong statement (ps delicate cardinal rubies), but thanks for all the help anyways! Keep updating your spreadsheet with more items

Offline
Old 08/07/09, 1:20 PM   #990
mpiemont
Glass Joe
 
Troll Rogue
 
Mannoroth
Ah you are right! I didn't realize they removed that requirement too, ridiculously nice. I'll try to keep on it as I see more things, I'm sure given enough time the new official version will come out with T9 procs and new trinkets

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Rogues

Thread Tools