Skip to content

Mists Pre-Raid Resto Druid Spreadsheet

August 16, 2012
by

Just the word “spreadsheet” can be an intimidating thing, not only to WoW players who are unfamiliar with using spreadsheets for theorycrafting, but also for anyone who isn’t totally comfortable with the wild world of Excel formulas.  For those who are comfortable maneuvering in Excel, though, a spreadsheet can be an extremely helpful way to make gear lists and figure out which pieces of gear will get you the amount of stats you want.

Excel Crash Course

So, what I’ve been working on over the last few weeks is a gear spreadsheet that will take some of the fear and confusion out of this word.  What I’ve come up with is an Excel document with two “sheets.”

A “sheet” is simply a page of information in Excel, which you can access by clicking on either of the tabs at the bottom left corner of your screen.  In this document, the “Database” sheet has a full listing of all Resto Druid pre-raid gear (not including Raid Finder gear) that can be obtained from quests, normal and heroic dungeons, and crafting.

The Database contains lots of information on each piece, including how you can obtain it and if it has an On Use / On Equip function.  You will notice that a few items still say “Unknown” for their sources (these are highlighted in red).  Unfortunately, since we are still in the beta for Mists, we don’t know where every piece of gear comes from yet.  I’ll be updating this sheet regularly and as soon as I find the sources for these items I will add them to the Database.

The second sheet is called “Choose Your Gear.”  This sheet has drop-down menus in Column A which allow you to pick an item for each gear slot from the items listed in the Database.

Once you pick your item, the other columns on the sheet that tell you that item’s iLevel and stats will automatically fill in.  At the bottom of this sheet there is a “Totals” row which will show you your average iLevel (helpful for knowing whether you are eligible to queue for heroics or Raid Finder) and your total stats (helpful for seeing whether you’ve reached the level of Spirit you want, or if you are close to a haste breakpoint).

Currently, this spreadsheet does not include functionality to add gems to an item or to specify whether you’ve taken a socket bonus.  This is something I’m considering adding in, but I was somewhat worried that it might make the spreadsheet seem too complex.  For now, if you would like to add in the stats from gems or socket bonuses (or enchants, for that matter), you can do so by editing the values for the stats on an item on the Database sheet.

Make Your Own

I love making gear lists but, sadly, I don’t have quite enough hours in the day to make one for every class in the game or even just for the classes I play the most.  If you are interested in using this Excel document to create something similar to host on your blog for the class you play, you are more than welcome to do so.  All I ask is that you provide a link back to this blog and provide credit for the original document.

Alternatively, if you would like to create something similar but aren’t proficient with Excel, I am willing to help out.  If you do the legwork for your class by looking up the items on WoWhead and filling in all of the information on the Database sheet, then I will set up the formulas for you to make the Choose Your Gear sheet work.  I’d be willing to do this if you intend to host the sheet on your blog for other players of your class to use.  If this is something you’d be interested in, please contact me through email or Twitter.

Just Give Me the Spreadsheet, Already!

I’ve uploaded the Spreadsheet to my blog, and you can download it here.

Once I have completed my Mists druid guides, it will find a permanent home there along with a change log.  I intend to continue updating it throughout the expansion.

Thank you to Alas, who generously did some beta testing on this sheet and who provided great feedback.

This is the first WoW-related project I’ve attempted like this, and I would absolutely love any additional feedback on it.  If you find an error in any of the information or have a suggestion about how to improve this spreadsheet, I would love to know!

Advertisements
No comments yet

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: