**Rogue DPS Simulation Spreadsheet**

**Requirements:**Excel 2003 or later. Only tested in Windows OS. Prior versions of Excel are not advisable due to deficient RNG.

If you are using release version of Excel 2003, you might have to run a hotfix to RNG available here: The RAND function returns negative numbers in Excel 2003.

**The file does not work in Standard Open Office, but may work in GO Open Office with some additional changes.**

**File Description:**

*- enter your gear, socket bonuses, gems, enchants etc. Only close to best in slot items are included.*

**Gear***- enter buffs, choose food buffs and flasks, choose the number of iterations (max 1000), choose fight duration (max 300sec)*

**Inputs***- choose the rules that govern your choice of abiltities, choose the combo point builder, MH and OH poison - more on DPS rules below*

**DPS Strat***- choose talents and glyphs, feel free to use the presets*

**TalentsGlyphs****DPS Results and Statistical Significance**

You operate the simulation from the Inputs tab, using the provided macros. Because this is a simulation, your dps is determined as a result of using RNG to simulate combat a set number of times. At the end of the simulation, the spreadsheet displays the average DPS value over those tries in the field called Latest DPS. In order to compare DPS under two different setups, first run the simulation with setup A and Save it as Baseline. Then run it with setup B. You can now compare the dps of the Baseline DPS and Latest DPS to determine which one is higher. However, keep in mind that it is a simulation and you need to take into account not only the average DPS, but also the statistical significance of the results. Below the DPS values in the Inputs tab you can see percent difference in dps and a statistical p-value which serves as a measure of confidence in the results. Sometimes, Baseline and Latest DPS will be different only because of RNG and not because one setup is superior to the other. In that case, the p-value is large and is colored in grey. In statistical language, the difference between the two dps values is said to be not statistically significant. However if the p-value is small enough, it will be colored in bright orange. If the p-value is 5%, it means you can be 95% sure that the setup you just determined as superior will indeed produce higher DPS, i.e. the outcome cannot be explained by mere RNG. To find out more about the t-test of statistical significance visit this wikipedia webpage.

**A guide to DPS rules:**

The rules can be roughly split into restrictions, exceptions and other rules.

- Restrictions limit when you use a particular ability based on your energy and combo points. They can be used to imitate rotations and implement energy pooling. For instance setting "do not use if combo points are below" values at 3, 5, 5 imitates a 3+/5/5 Xs/Yr/Zt cycle familiar to Combat spec users. If you want to pool energy to 60 before eviscerate, set "Do not use if energy is below" at 60 for eviscerate. Envenom also has a restriction based on DP stacks.

- Exceptions are special rules that override the restrictions when certain conditions apply. For instance, for HaT build, you may normally want not to use eviscerate below 4 combo points, but if energy is capped, you may want to allow to use eviscerate anyway, even if you have fewer than 4 combo points. The best way to do that is to set "Override if energy capped (overrides combo point check)" to 1 for eviscerate. Other overrides are used for situations when you are combo point capped and when your envenom, snd and rupture timers are about to drop.

- Priority governs which ability is going to be used if conditions for more than one ability are satisfied. For instance, if based on your restrictions and exceptions you can use both eviscerate and rupture, you can give more priority to rupture by setting its number to a lower value. Make sure that every ability is ranked the way you want it to. Note that most of the time, which ability you use is going to be governed by your restrictions and exceptions, and only in limited cases it will come down to this priority list to decide which ability to use.

- Refresh timer allows you to refresh snd, rupture and envenom before it runs out to avoid a situation when you are stuck without SND for a second during a global cooldown.

- other special rules govern the timing of finishers: you can choose to time envenoms to DP ticks, and you can also choose to put other finishers on hold when rupture is about to expire. You can also refresh SND early if it's due to expire at the same time as rupture.

You can think about all these rules in two ways: a) if you want to model your personal dps, choose the rules that best describe your own combat style; following the discussion in this thread, learn which DPS rules tend to increase your dps and adopt them in your own rotation.

You can find templates of rules for each spec at the bottom of DPS Strat tab, but I strongly encourage you to play with these restrictions to find an optimal rule for your playstyle and gear.

**Gear Selection Q&A:**

**How do I add a new piece of gear?**

- go to the section that matches the type of your new item. Select a row with an existing item that has the same or close item level as the item you want to add. Copy an entire row and insert it below. Then change the item name, stats, number of sockets, socket colors and socket bonuses.

**How do I add a new trinket?**

- you can only add a trinket if there already exists one with similar proc characteristics in the sheet by changing the stats and proc values of that trinket. The template trinket has to proc the same stat, the proc has to have same duration, internal cooldown and proc rate. The template trinket also has to proc from same attacks. Generally there are three main types of proc mechanics: 1) autoattack hits and applications of special abilities (e.g. Mjolnir Runestone), 2) autoattack and special crits (e.g. Needle-Encrusted Scorpion), and 3) autoattack hits, applications of special abilities, poison hits, poison dot ticks and rupture dot ticks, basically all damage (e.g. Whispering Fanged Skull). If the new trinket has the same characteristics as the template one, then you can change the stats and proc value and start using it.

**How do I choose gear based on the simsheet?**

- The best way to compare two items is to run the simsheet once with one item on, save DPS, then change the item and run the simulation again. You can now compare the DPS and determine the statistical significance of the result. See a note above statistical significance in "DPS Results and Statistical Significance" section above.

- If you want to determine several potential upgrades, I can also recommend running the EP value macro and apply the dps/point values to gear stats. To do that, after running the EP macro, find DPS/point values in row 10016 of DPS Output, copy them and paste as values into the appropriate range at the top of the Gear tab. The DPS values of each item in the Custom column will then reflect your dps/point stats, so you can select gear with highest stats. You can also see the EP values that correspond to dps/point stats in the EP Value section of the Gear Tab in the row labeled "Custom." Keep in mind that dps/point estimates also have RNG variance embedded in them, so after you do yout preliminary selection, you need to run the simsheet with the items you selected to confirm your choice by swapping in some close alternatives. Also items with procs cannot be selected by this method. Finally you cannot choose between weapons with different dps because this method only evaluates the stats not the weapon dps.

**What does replacing capped stats do?**

- If you keep your expertise at the expertise cap by gemming, then selecting a new item with more expertise will not add more expertise to your gear, but will instead allow you to regem your gear with another stat. The best alternative for expertise right now is AP, so by choosing this option, expertise will be valued as AP in the "DPS value of Gear" section. The same can be done with hit by replacing its DPS value inflated by crit capping and spell-hit capping with that of Haste.

**The latest version of the Simulation Spreadsheet:**

Simsheet 3.3.3a - changed for patch 3.3.3a, with HAT support, including shadow dance.

Filefront mirror