Final edit may 20 2009– got the new version screenshotted and updated here. I won’t be keeping this one up to date any more- follow the above link for the most recent version.
I’ve talked about this before and mentioned that it can be a little daunting to use, so here’s how to use the elitist jerks dps spreadsheet.
First off, what it will do. This spreadsheet allows you to import your character from the armory, and calculate your theoretical maximum dps. Since this is modeled data, don’t be surprised if you don’t actually see that dps in game. This is a benchmark you can use to compare various choices you have to make.
All the screenshots here are taken on a 5 year old laptop with an attitude problem, so some of the things that probably show up on a single page for you will be off the side of my screen, and thus pictured on their own. If anything’s unclear, ask in the comments.
To get started, go to the first post in this thread and download the latest version. When you open it, enable macros. You will be on the first tab. You need to click on the second tab called “overview”. You’ll see this:
Now you need to enter your character name, realm, server set, and glyphs. Also, if you have a gathering profession with some sort of pve bonus, enter it in the marked space. Lastly, rename the first profile (the one we’ll be using) to something that describes your spec and pet.
Last part of this page is to the bottom right- you need to enter a name for the spec you use.
Next, go to the gear tab. You’ll first want to change the profile name to the one we created in the overview tab.
And then click on “load gear from armory”.
Next up, if your import contained gear that does not show up properly (like greens), you need to set those pieces to custom. Skip this step if all your gear imported properly.
Next, again only if you have some pieces of custom gear, you need to enter the stats and stuff for the gear you selected “custom” for on the custom gear tab.
Now, once your gear is ready, we click on the talents tab and then set the talent profile to the one we chose in the first step. Mine is called “sv 5/15/51 spec”
After that, you click on “read from armory”
Now we click on the buffs tab. I usually leave this to the default “level 80 raid” that Shandara has been kind enough to create, but if you have your own buff composition, you can create a profile on the overview tab and edit it and save it here.
Now you go to the shot rotation tab, enter in your latency (the default is fine for most), and start to choose your rotation priority. This is unfortunately not going to be perfect for survival hunters, but it’s close enough.
Next we go to the pet tab. You can build your pet’s talents on wowhead to make sure you’re not forgetting anything. On this tab, you have to select your pet type, clear the talents, and enter them back in the way you have yours set up. You also need to enter in the abilities it will use.
Now that all the data’s entered, go back to the gear tab and click on save profile.
Edit: Then you go back to the overview tab and click “calc attributes”
Once you’ve done that, the overview tab will give you your dps and statistics.
You can use the gear planner tab to see how much dps an upgrade would be, and you can play around with your spec to see what it would do to your dps.
So, there you have it. A step by step guide to using the elitist jerks hunter DPS spreadsheet. Now you can really compare multiple items to see which will give you the best dps. Just make the change you’re checking on, and see if your DPS goes higher or lower. For example- if you get something with a lot of hit, and you want to test whether that with regemming and reenchanting all your hit to agility would be more DPS, input your live character, then make the changes, and see if your DPS went up :)