Warning for Grays: Post Signing

Kaubel · 02/18/08, 5:43 PM

Post: [Shaman] How to Heal like a Pro
User: Grays
Infraction: Post Signing
Points: 0

Administrative Note:

Message to User:

I can't understand how all these "long time lurkers" wouldn't know that they're not supposed to sign their posts.

Original Post:

Hi--I'm a long time lurker, first time poster. Posting this as a test balloon. I'd like to know if you find this useful, and when I continue development on this application whether you would want me to post revised versions here.

Using a series of Ruby scripts I've been working on for about two weeks, I wrote an application to automatically parse live data out of Wowhead and into a spreadsheet. I do have written permission from Wowhead to do this, so don't jump my case on that. >_> As for taking two weeks, I wrote a comprehensive library for building this spreadsheet and didn't just hack together a script; as a result, I have a durable application that can generate almost any class/spec a gear spreadsheet from live Wowhead data.

The spreadsheet format is OpenOffice Calc. If you don't have OpenOffice, get it. It's free.

This is an early iteration of the spreadsheet, with all data intact but very little "polish". Later I'll add things like coloration, links to items, full tooltips on mouseover, etc. For now, it works, and I just wanted to get it out there. It does include gear from patch 2.4.

Resto Shaman Gear Spreadsheet (Including 2.4 Loot)

A brief FAQ:

What is 10MM?
This is a stat I developed called "10 minute mana". Most fights in raids are between 5 and 15 minutes, with most enrage timers being 10 minutes or so. So, the 10MM stat takes into account your int, mp5, and two mana tide totems (one at 2m30s, one at 7m30s) for total mana provided during a 10 minute fight. (You can adjust the length of the fight on the Control tab. The stat is still called "10 minute mana" but will reflect the mana gained from the piece for whatever fight length you choose.)

What about the other stats?
Columns B through K are pure stats pulled off of the gear. 10MM, Heal, Haste, and Sta are derived stats based on the gear itself and any gems you have socketed. You can control what your gems are worth on the Control tab. Note that the Heal stat also accounts for the 10% bonus that the priest spirit buff provides from Spirit, but otherwise spirit is not counted.

What is Ranking?
Item level calculation is based on modifiers, stats, and powers of stats, etc. etc., in a complicated formula. Ranking is simply an expression of the calculated stats (10MM, Heal, Haste, Sta) that roughly mirrors item level calculations. It does not take powers or any other nonsense; it's a pure expression of what the item is "worth" to a resto shaman at flat value. 10MM is counted as though entirely made up of MP5 for more accurate rankings. Important: Ranking is NOT an official stat or a hard-line rule of any kind. It is a value used to approximately rank gear that transcends item level, and items of similar rank should be examined heavily for various advantages on the derived stats.

What happened to Int?
Int is a dumb stat. When you get a point of int, you actually get a little crit, a little mana, and a little healing. You also get a little more mana if you mana tide. Int (including tides) has been broken up and shuffled off into the calculated stats so that it will mix with healing and 10MM for more abstract comparison.

What happened to spell crit?
While shamans do get some benefit from spell crit via talents, it's not significant enough to focus on for PvE itemization. Furthermore, the PvP gear has all the crit you really need if you really want to focus on it. So, I did not parse it at all.

What about trinkets and relics?
These are a small, well-defined subset of gear pieces with very few distributed stats. A spreadsheet will do very little good when comparing them. When choosing trinkets and a relic, consult Wowhead comments for guidance.

Does the sheet account for socket bonuses?
No. The formulas required to account for all socket bonuses would be unbelievably long. Sorry, you'll have to work on that yourself.

If you want to see what a piece of gear would be like if you don't socket the correct gems, just change the count for other gems in the item.

You're not counting set bonuses / procs / sexy graphics!
No, I'm not. This is for broad-base pure stat analysis for quick calculations without having to crunch the math yourself on every item you want to compare. When weighing two pieces of gear that are about the same tier, you will have to judge a lot more than what's simply on this spreadsheet. My goal is that the spreadsheet will make this math easier.

Enjoy.

Frakir*
Resto Shaman, Eredar