Well, the original has changed enough that it’s time for a redo of my guide to the DPS spreadsheet (download link). New screenshots, new features, more awesomeness!
Opening the spreadsheet
When you start up, you might get this (or some variation of it):
If you do, you need to go into your “tools” menu, click on “macros”, and then “security”.
Then you’ll see this. Change your security settings to medium, and click ok. This means that from now on, Excel will always ask you before executing a macro. Don’t ever say yes to this if you don’t know the file or there’s any possibility that there’s a virus in it.
Now close the file, and reopen it. You’ll now be greeted with something like this message asking if you want to allow the spreadsheet to run macros. The answer is “Enable macros”.
Using the spreadsheet
Now we go to the “overview” tab and we’re presented with this. You want to take a look at the stuff I’ve highlighted in red- specifically character name and realm, and profiles. If you want multiple profiles, you just name them all here. Also, verify your glyphs (not saved per profile), and change one (or more) of the names of the specs you plan to use.
Next up we go to the “Gear” tab and select the profile we’ll be importing first. I picked the one named “Euripides SV”.
Over to the right of the same tab (Gear), we’ll want to click on “import”. This should pull all your gear in from the armory. If you have gear on that Shandara has not yet put into the spreadsheet, it will not show up.
Now you should go down the list and add stuff you are missing. In my case, I have the mats for my massacre 2-hander enchant, but I’m waiting for my guild enchanter and I to cross paths. I added it in manually. You might have gear on that doesn’t import from the armory (some caster stuff and greens, mostly). If there’s holes from the import, select “custom” and we’ll go and add the stats manually later. Once that’s done, click “save profile”
Now we go to the next tab, “Talents”. Here we will start off with clicking the “read from armory” button to bring in your current talent tree. Then you go over to that little thing almost off the side of my screen and select the name you chose for you spec. I picked a boring descriptive one, but you could have named it “MM spec of impending doom!!!!” instead. Once your spec is the way you want it and your spec name has been selected, click on “save spec”. Also, note that if you want to use a different spec than the one your character currently has on, you can copy-paste a link from wowhead or the blizzard talent calculator in a little area near the bottom of the talents tab.
Next up, the Buffs tab. This is where you tell the DPS calculator which buffs you have and debuffs your target has. Again, everything here has a name that you specified in the overview tab. The default is 25 man buffs, which is basically everything. That’s not actually feasable in real life- I suggest that you run your standard raid comp through mmo-champion’s raid composition tool and see what you really get. This tab is where you specify the food and flasks you use too- if you’re using hit food to get capped, make sure you specify that or it will assume you’re using agility food.
Now we’re off to the Shot Rotation tab. Here you simply adjust it to the rotation you use. The one I picked is the highest DPS for survival (I think), but since this is not attached to a profile, you’ll have to manually switch this around to compare two profiles with different secs.
Now to the Pet tab! Here we pick the pet we use (a wolf is the most DPS for all but beast masters), and then enter the spec in. The default is the most DPS, but I have mine customized a little. Also, verify that the ability priority is what you want. Special before focus dump.
The next tab is where we go back to that custom gear I mentioned you’ll need if some of the gear you wear isn’t in the database. Look up the missing gear on wowhead or something and manually enter in all the stats. They will only be applied to slots you selected “custom” for in the gear tab.
Lastly, we go back to the overview tab, and click on the “CalcAttributes” button to the right. This will update the DPS value per point of all the stats we get. You see that hit is worth 1.64 DPS for me, and agility is worth 1.52 DPS. Your numbers will be different.
Now you can do things like look at best in slot lists from the gear planner. The yellow below and red in the list is what you have. Delta means how much DPS you gain or lose. The top allows you to exclude content you don’t have access to.
There you have it! Easy peasy, and updated to boot! Ask questions here if you have them!