Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Rogues

Reply
 
LinkBack Thread Tools
Old 01/05/11, 6:39 PM   #31
mrdirtt
Glass Joe
 
Troll Rogue
 
Kilrogg
Yet another thank you for another very pleased user.

I have been adding a few custom items to my spreadsheet but have run into a problem.
I wanted to evaluate the PVP set on this sheet since it has such an excellent 4 piece bonus.
Do you have any tips on how I would try to enter this bonus on the spreadsheet so that the pieces can be evaluated?
I am giving Resilience an EP Value of 0 since it has no effect on PVE.

Offline
Reply With Quote
Old 01/05/11, 8:04 PM   #32
Syncness
Von Kaiser
 
Night Elf Hunter
 
Caelestrasz
Originally Posted by mrdirtt View Post
Yet another thank you for another very pleased user.

I have been adding a few custom items to my spreadsheet but have run into a problem.
I wanted to evaluate the PVP set on this sheet since it has such an excellent 4 piece bonus.
Do you have any tips on how I would try to enter this bonus on the spreadsheet so that the pieces can be evaluated?
I am giving Resilience an EP Value of 0 since it has no effect on PVE.
Only the mainhand and 2pc Viscous (Legs and Shoulders) are PvE upgrades, the latter being a very small upgrade (like 20ish EP).

This was posted somewhere around here before.

[e] this is for Assassination
[e] Source for weapons: http://elitistjerks.com/f78/t110134-...5/#post1823629

Australia Offline
Reply With Quote
Old 01/06/11, 5:15 AM   #33
Fae
Von Kaiser
 
Human Rogue
 
Argent Dawn (EU)
Originally Posted by mrdirtt
Do you have any tips on how I would try to enter this bonus on the spreadsheet so that the pieces can be evaluated?
I commented 2-set bonus for combat here.

As the sheet doesn't support set bonuses, I tried to evaluate 2-set bonus this way: I picked 2 pieces with the best stats for combat and added +35 agility as a socket bonus on both of them. I also had to change blue socket on leggings to be red socket, because in reality, we'll put red gem in there.

I guess you can do the same with 4-set bonus. But always keep in mind that items are as good as they show only if you equip all of them at once.

Originally Posted by ShadowStrk
Only the mainhand and 2pc Viscous (Legs and Shoulders) are PvE upgrades, the latter being a very small upgrade (like 20ish EP).
According to the sheet, [Vicious Gladiator's Shiv] is also best pre-raid offhand for combat.

Offline
Reply With Quote
Old 01/06/11, 8:29 PM   #34
sp00n
Bald Bull
 
Night Elf Rogue
 
Wrathbringer (EU)
As explained in the sheet, take the weapon recommendations with a grain of salt. While they are based on ShadowCraft's EP values, they are quite simplified to fit into the sheet (though they appeared to be more or less stable) and as well aren't necessarily correct for your gear (as always if you don't use personalized EP values).
The Shiv however is at least a decent off hand. And ridiculously easy to acquire.

That being said, I hope I'll be able to update the sheet tomorrow with some heroic gear etc. I'm making progress with my muted sound addon, so I can go back to item scraping. This and I really need an overview of heroic gear for myself by now.

Stopped Playing

Offline
Reply With Quote
Old 01/07/11, 10:41 AM   #35
sp00n
Bald Bull
 
Night Elf Rogue
 
Wrathbringer (EU)
Updated to r7.
It includes heroic gear now (and those nifty random enchanted legs from Al'akir). Also fixed the meta gem bug for C'thuns Helmet and added some PvP pieces (no blues though).

The most apparent change is probably that I added loot categories so that you can choose to not display e.g. heroic raid loot gear or questing/reputation items.*


* I hope that the dropdowns/checkboxes do work outside of a German Excel. Not so sure about this with Microsoft's policy to localize their formula function words (if anyone didn't understands what I was trying to say here: for example 'TRUE' becomes 'WAHR' in German Excel and I don't know if that's ok to use in a dropdown). Let me know if it doesn't work.


Also, OpenOffice users seems to suffer from a bug that the sorted list isn't updated correctly when you change your spec/EP values or loot categories. The EP calculation itself still seems to be correct, but it doesn't re-order (or hide) the items. You can manually force it do so if you remove one of numbers representing the position in the 'A' column and add it again. You only have to do this once - after that it updates the list just fine.
Again, let me know if you know why this behaviour occurs. Or how to fix it. I have no clue.


// Edit
Oh, and also, does anybody know what's the drop behaviour of the heroic tokens? Do they drop from all bosses on heroic mode or are they again split up amongst specific bosses?

Last edited by sp00n : 01/07/11 at 11:06 AM.

Stopped Playing

Offline
Reply With Quote
Old 01/07/11, 11:01 AM   #36
Stony
Von Kaiser
 
Orc Rogue
 
Mal'Ganis
forlorn vanquisher - Search - World of Warcraft
According to the armory, for heroic tokens
glove is from Magmaw + Atramedes
legs are from Magmaw + Maloriak
chest is from Halfus+Valiona+Council
shoulders from Chogall
hat from Nef

Al Akir seems to drop the essence of forlorn, that lets you get any token.

United States Offline
Reply With Quote
Old 01/07/11, 11:18 AM   #37
Fae
Von Kaiser
 
Human Rogue
 
Argent Dawn (EU)
Thanks for the update, I really like to use your sheet for browsing thru gear and planning possible upgrades.

I've got some feedback to the newest version:
  1. Dropdowns work (in english excel 2007), but they show german "WAHR" and "FALSH". Not a big deal.
  2. Although when I use the loot categories feature and uncheck any of them (for example "RaidHeroic") every single line in "Weapons incl. Speed & DPS" section goes blank, thats a bit annoying.
  3. When we have those random enchanted legs from Al'akir now, what about the random enchanted belts and rings from Conclave of Wind? I have no problem adding them myself (it seems that wowhead already has all relevant drops data), but it would be nice to have those included out-of-the-box.
  4. Regarding added Vicious armor pieces, did you consider implementing some kind of support of set bonuses? Again, it's not hard to add the extra agility manually, but in it's current state and without any comment about it, the value of those items may be a bit misleading for less experienced users.

Offline
Reply With Quote
Old 01/07/11, 1:34 PM   #38
sp00n
Bald Bull
 
Night Elf Rogue
 
Wrathbringer (EU)
Good catches all.
I added the missing waist/rings, updated the drop locations and the dropdown boxes should be working now as well (both in terms of language and functionality with the weapons).

Stopped Playing

Offline
Reply With Quote
Old 01/08/11, 4:41 PM   #39
koaschten
In the rear with the gear!
 
koaschten's Avatar
 
Troll Rogue
 
Khaz'goroth (EU)
Originally Posted by Fae View Post
Dropdowns work (in english excel 2007), but they show german "WAHR" and "FALSH". Not a big deal.
This is more of a way MS localizes stuff, the internal function of the booleans is the same but localized versions may display it differently according to the language settings of the viewer and/or spreadsheet creator. Take it like most MS, it's not a bug, it's a feature.

How to get an Android Authenticator on your PC. (updated feb'11)

Germany Offline
Reply With Quote
Old 02/01/11, 2:45 PM   #40
Valadar
Glass Joe
 
Orc Rogue
 
Illidan
I just wanted to mention that the stats for Don Rodrigo's Fabulous Necklace are incorrect. You currently have its stats set identical to that of the Necklace of Strife with 127 haste and 127 mastery. However, its actual stats are 96 haste and 145 mastery. This places it slightly worse than the double dragon neck, even pre-heroic.

Offline
Reply With Quote
Old 02/22/11, 11:31 PM   #41
Firnas
Glass Joe
 
Human Rogue
 
Draka
Cloak of Biting Chill and Viewless Wings have the stats kind of weird too. Not sure if they were recently changed and r8 hasn't been updated to reflect the changes.

United States Offline
Reply With Quote
Old 02/23/11, 10:02 AM   #42
Jodou
Von Kaiser
 
Jodou's Avatar
 
Worgen Rogue
 
Laughing Skull
Originally Posted by Firnas View Post
Cloak of Biting Chill and Viewless Wings have the stats kind of weird too. Not sure if they were recently changed and r8 hasn't been updated to reflect the changes.
How so? I just double-checked everything against wowhead and the stats in R8 match those on the site.

Keep in mind you can fix/add items to the spread. I fixed the two necks mentioned above and after reforge it puts Strife 15 EP ahead of Rodrigo's (which I don't necessarily agree with since I'm a mastery whore). Hornet-Sting Band is also on par with Mistral Circle of the Zephyr after adding it.

Last edited by Jodou : 02/23/11 at 10:09 AM.

United States Offline
Reply With Quote
Old 02/23/11, 7:57 PM   #43
Firnas
Glass Joe
 
Human Rogue
 
Draka
Originally Posted by Jodou View Post
How so? I just double-checked everything against wowhead and the stats in R8 match those on the site.

Keep in mind you can fix/add items to the spread. I fixed the two necks mentioned above and after reforge it puts Strife 15 EP ahead of Rodrigo's (which I don't necessarily agree with since I'm a mastery whore). Hornet-Sting Band is also on par with Mistral Circle of the Zephyr after adding it.
/me idiot.

Just now realized all the stats on their are reforged values. My bad.

United States Offline
Reply With Quote
Old 02/24/11, 10:55 AM   #44
Jodou
Von Kaiser
 
Jodou's Avatar
 
Worgen Rogue
 
Laughing Skull
New upcoming 4.1 changes just announced:
Originally Posted by MMO Champion
  • Leatherworking: Assassin's Chestplate now gives +321 Agility, down from 341. Now gives 173 Hit Rating, down from 183. Now gives 243 Critical Strike rating, down from 253. Now has a Red Socket (Socket Bonus: +10 Agility)
  • Leatherworking: Belt of Nefarious Whispers now gives +233 Agility, down from 253. Now gives 174 Hit Rating, down from 184. Now gives 134 Mastery Rating, down from 144. Now has a Red Socket (Socket Bonus: +10 Agility)
Given these hold true to release, Assassin's Chestplate picks up 54 EP making it just 37 EP behind Sark of the Unwatched, down from 91 below. Even more interesting is the change puts Belt of Nefarious Whispers up 52 EP (23 EP AHEAD of Wind Stalker Belt of the Zephyr), making it BiS pre-heroic.

FYI, R8 does not include 1 red and 1 blue gem slot for [Belt of the Fallen Brood], so please add that to the list of fixes for R9, sp00n.

United States Offline
Reply With Quote
Old 02/24/11, 1:20 PM   #45
• Aldriana
Mike Tyson
 
Night Elf Rogue
 
Doomhammer
It is worth noting that 4.1 will presumably come out with another tier of raid content, so how the crafted gear compares to current-tier epics is somewhat less relevant. Those would have been highly useful changes in 4.0.6 (when they changed (most of) the other crafted gear), but by 4.1 I'm not sure how much it'll still matter.

Offline
Reply With Quote
Reply

Go Back   Elitist Jerks » Class Mechanics » Rogues

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
DKTankCraft Spread Sheet Tantlin Death Knights 36 01/30/09 11:58 AM
[Warrior] Tanking TPS sheet. Punscho Class Mechanics 189 05/09/08 6:18 AM
Character sheet display addons Tasonir User Interface and AddOns 2 06/08/07 1:17 AM
Help with a paladin DPS sheet Thethiala Public Discussion 5 11/15/06 8:48 PM
DPS Warlock Sheet Auphi Public Discussion 3 08/20/06 5:36 PM