Aadar

I have put together two spreadsheets for evaluating kit for clothies; one for DPS and one for healing (see below).


The DPS Spreadsheet (http://www.fresle.co.uk/casterdpskit.zip)

I put this spreadsheet together primarily to help my wife's mage choose appropriate kit for her mage, then later added additional data to help my warlock alt choose kit, and thought while I am at it I would add a shadow priest to round it off for all DPS clothies.

This is how it works...

You use your DPS spreadsheet of choice; for mages I recommend Vontre's spreadsheet. Pop all your stats into Vontre's spreadsheet to discover your predicted optimum DPS (you can either look at burt DPS or damage over a 6 minute encounter, I prefer the 6 minute encounter damage for PVE).

Now comes the tricky part. Note down the damage obtained for the spreadsheet. Now note down the effect on you DPS by adding a fixed value to each stat in turn; e.g. try 10 to damage, 10 to int, 10 to spirit, 10 to hit, and 10 to crit. MP5 (and spirit to a certain extent) is a special case as 1 MP5 could either result in no more damage, or a big chunk of damage as it allowed you to get off 1 more spell in 6 minutes. So what I do with MP5 is keep subtracting 1 until the damage moves down a notch, and then keep increasing it until it moves up a notch, then I know how much MP5 is required to increase by the 'notch' of damage.

Armed with these figures you can use the 'Calc Factors' worksheet to calculate the relative effect of each stat. These relative effects are placed under the appropriate column (E to K) in the 'Params' worksheet, and you should select your spec in cell B3.

You can now view the ratings for various equipment on the 'Kit' worksheet (I suggest you sort column E descending and then column B ascending).

A word of caution. The 'Hit' rating is caped at different levels depending on your spec and will in all likelihood give very good returns up to that cap, but no returns after that. I leave it to the reader to work this out for themselves.

The equipment I have included goes up to the first few bosses of Kara at the moment (where we are in our guild atm), I will update the spreadsheet in time.


The Priest Healer Spreadsheet (http://www.fresle.co.uk/healkit.zip)

I put this spreadsheet together primarily to help me with choosing kit for my priest. It works by giving each piece of kit a calculated rating based on weightings given to different stats. These weightings I am constantly reviewing, but in this version healing=1.0, spi=2.57, mp5=5.14, int=1.33, crit=1.0, sta=0.0.

I came by these weightings firstly by using the Blizzard weightings on gems, then by some adjustment on reading the elitistjerk forums and finally by gut feel on my part. You may feel free to adjust them in any direction you feel for your own use as they are parameterised on the 'Params' worksheet.

My thoughts are that at early levels +healing should out weigh all other stats by a good margin as you rarely run out of mana. At later levels your healing style will reflect weightings given to other stats. If you are someone who spams a GHeal rank 1-3 then MP5 will be very important, if like me you usually cast-cancel GHeal rank 8 then Spirit will become important. I have given crit a nominal 1, it may be more important, but the lack of crit on the majority of healing gear means you can probably ignore it. I have ignored Stamina entirely, but of course, you need enough stamina to ensure you dont die, as death means zero healing.

 

Aadar

Note that some of the stat values on the items are pre-patch and so marginally incorrect. An update will be posted in the next day or two.

 

Kass

Interesting spreadsheets. As a healer, one of the things I feel like you aren't considering is stamina. It's probably the last stat looked at, but many times could IMO, cause me to choose one item over another. I believe your analysis is correct that early on, +healing is probably the most important, but as many threads have stated...balance in the end with the total set is essential

One issue I have is that you're mentioning some Kara loot, but not all Kara loot. I'm not sure if this is based on where your guild is at and what is currently attainable by your characters. Either way, I think if you're going to include some items from a zone, you should actually include all - b/c ideally those would hopefully be attainable in the near future.

Anyway, nice work, it was interesting to say the least. I'd suggest you take a look at threads like this for some other options you might have missed.
[Priest] Compensating for Tailor Envy?

 

Severed

These would be good for someone who doesn't raid at all. Unless you put in the loot from Karazhan onwards your target demographic would be trolling the Wow forums. I suggest you repost this there.

 

Aadar

Stamina is on the spreadsheet, you just need to give it a value if you want. My view is that if you have enough HPs to take a random attack/AOE you are good to go; therefore Stamina is very important until you reach a threshold after which it is of zero value.

The spreadsheet was put together whilst I was levelling, I've tidied it up and presented it to the guild to help others that are preparing to raid. When I have the time I will include higher level drops and repost.

 

Copernicus

Here are the posts I made for my quick Fire Mage DPS spreadsheet-

Vontre's Mage DPS Spreadsheet
Vontre's Mage DPS Spreadsheet

The direct links to the zip-file, zero-stam, and stam at 2/dmg versions- http://www.ainur-guild.org/stuff/

Also, a thread on an item spreadsheet generator using the allakhzahm (sp?) website - Item database project (for all these spreadsheets)

---

You can probably grab item values from my spreadsheet for post-Kara loot. If you feel comfortable manipulating excel spreadsheets or CSV files, go for the item spreadsheet generator.

 

Aadar

I have updated the spreadsheets and put them in zip files. The spreadsheets now have kit in them right up to Mount Hyjal including class sets. Hope you find them useful.

 

RpgWizard

Some items seem a bit weird.

I've used Vontre's DPS spreadsheet for a while, and I just saw this thing - which I think is an AWESOME idea- but some items seem a bit off.

For example, when I plugged in the values for my stats from Vontre's spreadsheet, when I look at offhands, the Flametongue Seal ranks below even the Master Dragonslayer's Orb.

Also, whenever I've done a straight comparison between the shadow labs neck piece and the Prince neck piece, the shadow labs neck piece has always come out ahead, yet just barely. However, in your spreadsheet it comes out a considerable distance ahead.

Other than those little discrepancies, can't really complain about anything.


Actually, this just came into my head, but maybe it has something to do with being hit capped that you rate +hit items lower? I can't think of any situation where the highborne spellcloak from Kazzak would be better than the Ruby Drape from Prince, unless hit capped.

Edit: Actually makes me pretty sad how much better tier 6 for priests is for mages than mages own tier set using this spreadsheet, atleast as individual pieces. =(

Edit2: Found another weird item, tier 5 chest piece is rated higher than tier 6 chest piece, which doesn't make sense really at all.

 

constantius

Where do I get Greater Heal (Rank 8)? /pedantic

Having said this: really neat idea, and from my inspections so far, it matches up roughly with reality. When it all comes down to it, an upgrade usually has to be theorycrafted in place with your other gear; this can help make the decision. Another tool = good to have. Thanks for the work. Some notes on things I noticed:

You should note for cloaks that you're missing the two highest-ranked cloaks in the game:
Shadowvine Cloak of Infusion (Illhoof): a gem that comes in at 130.9 points by your scheme
Sunshower Light Cloak (160.4 points).
Cloak of Suturing : 120.6 points

Some other missing things:

Enchant Weapon (Spellsurge) : works out to 9Mp5, so it can be modelled as this (makes it roughly equal to +spirit)
Boots of the Long Road : between Incorrupt and Soul-Strider, as you'd expect.

Lord Sanguinar's Claim : interestingly, worse than Teeth of Gruul (but has stam, so better as a stam option than anything else stam-y)

Coral Band of the Revived : shows as the best ring in the game, although by such a margin that I personally (and this is where the sheet comes in handy!) would tweak the values a bit, because I definitely don't consider it to be better than the Narru Light ring.

Band of Eternity : 136 score, very nice option.

Your set bonus for Primal Mooncloth is a bit weird, as with any reasonable build, you'll have 350 spirit raid buffed, which works out to 11 Mp5, or 3.6 Mp5 per piece, as compared to your recorded value of 2.3.

Trinkets: you missed 3 of the top 4 trinkets in the game.
Lifegiving Gem : 112.3, hands down the best trinket in the entire game (by score)
Shard of the Scale: score of 82.3
Fel Reaver's Piston: score of 82.3 ignoring the chance-on-cast

Naaru-Blessed Life Rod : another Kael'thas drop, best in the game (to date)

Talisman of the Sun-King : your stats are way off on this one, and the adjustments shows it to be the PoS we know it is (aside from having stam, there's nothing to recommend it as anything but a marginal upgrade over Aran).
Lightfathom Scepter: stats are off.

There's obviously Black Temple loot that isn't included in this list, but I haven't done enough research to see what's missing.

P.S. Honestly trying not to be critical, but to help build this up to be the most useful resource possible.

 

constantius

I see how the manual edits can be done to change gems, but would it make sense to have options for the gems somehow, so you can chose what every red/blue/yellow would be?

Additionally, with the math, the higher Heal Points meta is actually the 12 int/chance on spell cast to restore mana gem.

 

Aadar

Thaks for the feedback. I have updated the priest spreadsheet. "Lifegiving Gem" - this is a warrior trinket isn't it?

I will think about how I can incorporate specific Gem values whilst leaving it to remain flexible and still determine whether the gem bonus can be used or not.

Regarding the values used for spi/mp5/heal/int. They are a work in progress, and I am not sure one could ever reach a set of values that everyone would agree upon. You can of course change them on the second worksheet to whatever you like.

 

Aramul

I assume he means Rejuvenating Gem, the healing trinket that's also from BWL.


There's actually a site that does exactly that. www.lootzor.com uses allakhazam's item database and ranks items accordingly.
Link to a listing of stats with weighting you listed: http://www.lootzor.com/index.php?c=5...heau1habeu5.14