Rogue DPS Spreadsheet

Forum discussion:
EJ Forum
old2 (closed)
old (closed)

Download:
2.4.2.2
(MSXML required)

2.4.2.2NA
no armory import
2.4.2.2OO
no macro buttons


Changelog

Changed Version Number to 2.4.0.1. Migration with the WoW Patch (2.4.0 stands for the WoW Version. 1 for Spreadsheed Version in this Patch)

2.4.2.2
Added
Defense to the (Unmodeled) items section.
Unused talent point counter.
Integrated talents, defense and boss level into parry rate.
Integrated defense into miss rate and dodge chance.
Defense rating conversion.
Dodge details.
Mob option attacking from front/back.
Cloak of Unforgivable Sin
Defense to Chest enchant
Delicate Eternium Ring
Elementium Band of the Sentry
Glyph of the Defender
Greater Inscription of Warding
Hand of the Deceiver
Major Defense to Bracers enchant
Moroes' Lucky Pocket Watch
Nimble-foot treads
Slikk's Cloak of Placation
Shard of Azzinoth proc effect (as 45 DPS)

Fixed
Cold Blood for Instants
Helm list to include Wastewalker Helm and (Unmodeled) when all items options checked.
Issue with DPS details difference (was reporting difference with opposite sign).
Removal of more unbuffed references, hopefully resolving open Office issues.
Ghostly Strike option no longer increases damage done.
Buffed DPS no longer shows average Eviscerate damage if no Eviscerates are used.
Gem upgrades are again affected by metagem requirements.
Correct item ID for Figurine Shadowsong Panther
Elixir of Demonslaying now correctly only applies damage to Demons.
Importation issue with +4 stats enchant to bracers.
Importation issue with Heavy Knothide Armor on boots.

2.4.2.1

Added
Season 4 PvP gear.
Some ZA and Sunwell boss armor estimates.
SnD and Rupture uptimes to stat block.
Some 5-man helms.

Changed
Boss Armor Estimates fonts changed back to 9 pt.
Twin Blades now based on proc mechanics (1 PPM - 45 second cooldown).
With the upcoming availability of gems from badges, default fill-in gem changed to Glinting Pyrestone.
Brand new cycle model (Thanks Left and Todemax!)
All previously 15% procs now 16.67% (or 1/6th).
Blackened Naaru Sliver estimated as 45 sec cooldown - 10% proc rate.
Deathmantle 4-piece modeled as a 1 PPM effect, no cooldown.
Ashtongue Trinket of Lethality proc moved to Optimize routine for increased accuracy.
Heartrazor now on proc mechanics (currently modeled as 1 PPM).

Fixed
Bug with gems from Armory Import.
Sunder Armor/Expose Armor formulas.
Saved Builds issue overwriting first name in list.
Stat block % changes to be compatible with Open Office.
Incorrect references in Extra Attacks block.
Corrected AR pro-rating model.
Energy expansion SnD formula (missing racials).
Division by zero errors for cycles without finisher damage.
Error in the Delete Options Build Macro.
Selecting the German "Blutelf" now correctly applies the racial bonus.
Boss Level is now correctly applying to crit rate.
Offhand Executioner armor penetration.
Mutilate proc mechanics (procing off both hands).
Twinblade of Mastery Item ID code.
Weapon lists.
Formula for Agility (small overage when Sinister Calling or Vitality active).

2.4.0.9 dmm

Note: Extensive changes have been made. There could be bugs, please report such
on the Elitist Jerks forums in the Class Mechanics - Rogue DPS Spreadsheet thread.
2.4.0.7 is left available just in case as a pretty stable version.

As an aside, the import from another sheet should work from 2.4.0.8 for talents and
options but not from previous versions. You are better off reloading them through the Combo boxes.

Added
Expose Armor

Changed
Stat block font changed to Arial (Verdana unsupported on Macs)
Conditional coloring of DPS changes
Default gear sets
Syphon of the Nathrezim using proc mechanics (1 PPM)
Rod of the Sun King using proc mechanics (1 PPM)
Hit % in stat box fixed

Fixed
Optimization formulas for procs with cooldowns.
Crimson Sun with it's in-game effect (32 attack power instead of the tooltip's 24)
Hourglass of the Unraveller proc duration fixed to 10 secs and spelled correctly on the Optimize sheet
Romulo's Poison Vial proc (referred to a deleted cell)

2.4.0.8 dmm
Added
Beaming Fire Opal
Bright Crimson Spinel (Quest ID)
Champion's Fire Opal
Defender's Tanzanite
Enduring Chrysoprase
Enduring Deep Peridot
Enduring Seaspray Emerald
Enduring Talasite
Eye of the Sea
Facet of Eternity
Flashing Crimson Spinel
Flashing Living Ruby
Glimmering Fire Opal
Glistening Fire Opal
Regal Nightseye
Resplendent Fire Opal
Splendid Fire Opal
Stalwart Fire Opal
Steady Seaspray Emerald
Thick Dawnstone
Thick Golden Draenite
Thick Lionseye
Option button on the Talent page to turn off Buffs.
Option button on Gear _ Buffs page to turn off defensive items from the lists (only works for gems right now)
Proc Optimization routine added to AEP button.
Instructions for Open Office "self" macro on Optimization page.
Righteous Weapon Coating (as 15% proc rate, 45 sec hidden cooldown)
Inspiring Presence (Draenei buff)
Heroic Presence (Draenei buff)
Changed
Row 75 now labeled "Talents" to hopefully help avoid confusion.
Proc mechanics now implemented and/or improved for many proc effects (see optimization page)
Remodeled Talent sheet
Tier 4 sample gear set
Remodeled Stat block
Improved Combobox functionality (Talents/Options)
Shattered Sun Pendant of Might (Scryer) now has increased damage with spell damage buffs
Mutilate now considered two instants for proc mechanics
Windfury now has a buff component (except finishers)
Ferocious Inspiration reduced to 94% uptime from 100%
Fixed
Crimson Sun gem now spelled correctly
Fixed bug in Leg socket fit formulas regarding 3 sockets where 3rd socket was checked twice instead of 1st.
Fixed various mislabeled gems in terms of quality.
Consecrated Sharpening Stone now spelled correctly on linked to mobtype.
Removed
Delicate Fire Ruby

2.4.0.7a dmm
Changed
Fists of Fury proc now correctly applying resist mechanics
Options unchecked from importing as they no longer import correctly from prior versions.
Workaround is to save them as an Option set, import the options and load your option set from the pull down box on the Talent page.
Fixed
Shattered Sun Pendant of Might (Scryer) crit rating removed
Saved Options now pointing to correct cells
Expertise AEP now also considering Offhand
Ring Stats list now includes Angelista's Revenge

2.4.0.7 dmm
Added
Claw of Molten Fury
Fist of Molten Fury
Brutallus to the Boss Armor list with 7685 armor.
Fists of Fury bonus modeled as 10% proc rate no cooldown.
Changed
Angelista's Revenge (renamed from Sunwell Badge Loot - Melee Ring and listed as Heroic)
Unmodelled items now linked to the Heroic checkbox instead of Sunwell.
Shattered Sun Pendant of Might (Scryer) proc (rough estimate)
Fixed
2nd Unmodeled ring now shows in the Ring List (instead of 2 Sunwell rings)
Unbuffed DPS is now correctly working without the Murder talent.
Fixed issued with Mutilate gaining undeserved eviscerate damage
Fixed bug with Eviscerate cycles resulting in higher than correct finisher dps.
Saving a build will now correctly set the combobox to the newly saved build
JC gems now correctly tagged as Unique.
New badge loot now attributed to Heroic.
Expertise is now correctly applying seperately for MH and OH weapons.
Hemo debuff no longer adds to Rupture damage
Removed
Sunrage Shoulderpads (changed to boots during the patch)

2.4.0.6 dmm
Changed
Glancing rates fixed for 70-72; 73 is now a 25% reduction at a 24% rate (from 24%/25%)
Meta Require is now automatically turned off during Upgrade checks to more accurately compare items.
(Although one will still need to adjust gems to meet the requirements for the suggested item to actually be such an upgrade)
Fixed
Hemo/Backstab formulas (broke in 2.4.0.4)
Slayer 4-pc bonus is now additive with Surprise Attacks, Aggression and Opportunity
Sword Spec can proc from specials

2.4.0.5a dmm

Added
Support for all level mobs
Selection box for Sayge's Dark Fortune of Damage (1-10%)
Changed
Assassin's Alchemist Stone (new stats)
Adrenaline Rush - out of the energy equation. Now adds a prorated portion of a 5-pt Eviscerate every 5 minutes.
Accurate Extra Attack modeling (takes into account procs off procs of different type)
Improved Windfury modeling (based off the Extra Attack improvements)
Improved Unbuffed/Buffed DPS chart (work in progress)
Blinkstrike increased to a 5% proc rate and treated as a same hand extra attack.
Expose Weakness is now considered to have a 90% uptime
Slice and Dice damage is now considered part of "white" damage (to match up better with WWS parses)
Blade of Serration (new damage and speed)
The Mutilator (new damage and speed)
Default Mutilate now has Puncturing Wounds instead of Improved Poisons
Fixed
NextStat calc work (in progress)
Pawn string (hopefully)
Vengeful Gladiator's Leather Gloves (crit rating)
Mace Spec crit multiplier no longer applies to offhand attacks when a Mace isn't equipped.
Slayer 2-pc cycle fixes
Removed
Most "other" buffs. No longer affects characters above level 63.

2.4.0.4a dmm

Added
Assassin's Alchemist Stone
Golden Bow of Quel'Thalas (fixed a)
Ravager's Wrist-wraps of the Bandit
The Frost Lord's War Cloak
Changed
Improved Backstab is now called Puncturing Wounds and gives a crit bonus to Mutilate
Shard of Contempt - higher uptime due to 10% proc chance
Shifting Tanzanite - new stats
Slayer's Belt - new stats
Slayer's Boots - new stats
Slayer's Bracers - new stats
Fixed
Buffed cycle sheet reference to Unbuffed Dodge rate (did not affect calcs since there is currently no buffed Expertise).
Expertise now applies to Buffed finisher dodge rate when one does not have Surprise Attacks.
Upgrade Macro now does not skip some rings, trinkets or gems (error re-introduced in 2.4.0.3).
Removed junk variable references.
Set WordWrap to False to fix Mac Comment issues.
Slice and Dice and Blade Flurry were double multiplying global damage multipliers like Murder.
Slayer 2 piece bonus was not applying to Mutilate cycles.
Windfury improvements (some reverted a)
Removed
General's Leather Bracers (no longer obtainable)
Marshal's Leather Bracers (no longer obtainable)

2.4.0.3 dmm

Added
Band of Celerity
Band of Determination
Band of Ruinous Delight
Belt of the Silent Path
Blackened Leather Spaulders
Blade of Life's Inevitability
Blade of Serration
Cloak of the Coming Night
Clutch of Demise
Collar of the Pit Lord
Crossbow of Relentless Strikes
Distracting Blades
Edge of Oppression
Embrace of Everlasting Prowess
Figurine - Khorium Boar
Figurine - Shadowsong Panther
Grip of Mannoroth
Handwraps of the Aggressor
Leggings of the Betrayed
Mounting Vengeance
Nightstrike
Quickening Blade of the Prince
Shoulderpads of the Silvermoon Retainer
Sunrage Shoulderpads
Sunrage Treads
Sunwell Badge Loot - Melee Ring
Swift Blade of Uncertainty
Tameless Breeches
The 2 Ring
The Mutilator
Trousers of the Scryers' Retainer
Tunic of the Dark Hour
Vanir's Left Fist of Brutality
Vanir's Left Fist of Savagery
Vanir's Right Fist of Brutality

Fixed
Shoulder enchant works as none again
Drop locations for Deadly Cuffs and Insidious Bands
Ashtongue Talisman of Lethality formula
Ashtongue Estimated Crit now carries into cycle formula for improved Seal Fate calculation
Hemo personal DPS
Macro performance improved (Upgrades thanks to Arioche!)

New
Interface to add unmodeled items
Checkbox to disable Set Bonuses
German race name support for Armory Import


2.4.0.2 dmm

Added
Blackened Naaru Sliver
Bladed Chaos Tunic
Bombardier's Blade
Brooch of Deftness
Carapace of Sun and Shadow
Crux of the Apocalypse
Demontooth Shoulderpads
Dragonscale-Encrusted Longblade
Duplicitous Guise
Fang of Kalecgos
Gloves of Immortal Dusk
Gloves of the Forest Drifter
Hard Khorium Band
Hard Khorium Choker
Harness of Carnal Instinct
Inuuro's Blade
Latro's Dancing Blade
Leggings of the Immortal Beast
Leggings of the Immortal Night
Mask of the Furry Hunter
Muramosa
Opportunist's Leather Gloves
Opportunist's Leather Helm
Opportunist's Leather Legguards
Opportunist's Leather Spaulders
Opportunist's Leather Tunic
Quad Deathblow X44 Goggles
Shadowed Gauntlets of Paroxysm
Shard of Contempt
Shattered Sun Pendant of Might
Shattered Sun Pendant of Resolve
Shiv of Exsanguination
Shoulderpads of Vehemence
Slayer's Belt
Slayer's Boots
Slayer's Bracers
Steely Naaru Sliver
The Sunbreaker
Thori'dal, the Stars' Fury
Truestrike Crossbow
Many more cycles. (Thanks to Todemax!)

Changed
Ashtongue Talisman of Lethality formula (dps increase)
Twinblade bonus (estimate accounts for 45 second cooldown)
Band of the Eternal Champion (added 4 ap to proc based on better estimate)
Grayed gems sockets now fill with Glinting Noble Topazes on Armory Import to somewhat improve upgrade determinations.

Fixed
Item names no longer shrink to fit to resolve visiblity issues on Macs.
Macro boxes larger to hopefully resolve text issues on a Mac.
Macro box margins reduced to 0 to hopefully reduce text issues.
Set Font size for comments in Upgrade Macro to resolve display issue on Macs.
Formerly named T5 set properly renamed T6.
Shadowstep energy now correctly deducted from buffed cycles.

Readded
Grand Marshal and High Warlord Weapons
Thunderfury
Gyro-Balanced Khorium Destroyer
Legionkiller
Shuriken of Negation
2.4.0.1 dmm
Added
All enchants modeled (like Heavy Knothide Armor Kit) are now properly identified for all slots they can be used in, resolving Armory Import issues.
All modeled weapons that can be equipped in either hand are modeled for either hand, resolving Armory Import issues.
Mallet of the Tides; Terrok's Gavel; Andonisus, Reaper of Souls; Twinblade of Mastery; Crystal-Infused Shiv; and Talon of Anzu.
Adamantine Repeater and Crystalline Crossbow
Attack Power Equivalences along side the Agility Equivalences on the Talents page.

Changed
Shaman buffs now colored light blue for reability given the lack of Mage buffs that help Rogues.
Many Macro buttons enlarged.
Heroic gems no longer Unique-Equipped.
Poisons are now disabled based on the Option on the Talent sheet.
Altered % uptime estimates for suspected ~1 ppm weapon procs based on 1/3 uptime for 10 second MH procs and 1/2 uptime for 15 seconds.
Offhand procs estimated at 1/6 for 10 seconds and 1/4 for 15 seconds. Both done to provide consistency.
All ~1 ppm entered as 1.2 ppm based on the Mongoose/Executioner research.
Mongoose as an estimate so that it should compare better to Executioner at different build levels.
All this as a temporary measure prior to implementation of new improved ppm modeling.
Illdari-Bane Broadsword and Illdari-Bane Dagger now linked to mob type for Demon bonus.
Weapon list has been reviewed and adjusted to only include weapons with 69.67+ DPS.
Blackout Truncheon chosen as the bottom point due to the lack of fast Maces in early itemization.
Ranged weapon list has been reviewed. Those items not close enough to quest accessible items removed.
Importing Options also imports the options on the Gear Buffs sheet.

Fixed
Mob Armor can no longer be reduced below zero.
AEP Macro now working again if certain items equipped or bonuses active.
Doubled Copy buttons removed.
Upgrade Macro should now correctly search the 2nd Ring or Trinket on the list.
Fury was missing socket.
Demonblood Eviscerator was missing Expertise rating.
High Warlord's Left Ripper and Grand Marshal's Left Ripper had incorrect damage and speed.
The Unbreakable Will, Honor's Call and Warp-Storm Warblade were missing Defense rating.
Offhand Talon of Azshara and offhand King's Defender had old stats.

Removed
Thunderfury and Wastewalker Shiv as the dps output is worse than some unmodeled green items.
Gyro-Balanced Khorium Destroyer; Hemet's Elekk Gun; Huhuran's Stinger; Larvae of the Great Worm; Legion Blunderbuss; Legionkiller
Lohn'goron, Bow of the Torn-heart; Mark V's Throwing Star; Needle Shrike; Nerubian Slavemaker; Shuriken of Negation; Soulstring
Striker's Mark; The Sharp Cookie; Valanos' Longbow; and Wrathfire Hand-Cannon
All Grand Marshal's and High Warlord items given the availability of S1 for Honor.