Hello all =)
The Hunter Item Comparison Spreadsheet (HICS) is available for download!
Current version uploaded 29.08.06
To view this file you need Microsoft Excel, or a similar program (for example Star Office).
I have made a spreadsheet to compare items / weapons for hunters in terms of damage in a PvE (raid) setting.
You can also compare different talent builds.
It shows your damage while using the Aimed + Multi cycle.
It also shows you how crit, agility and Ranged Attack Power compare to each other based on your gear and build.
It even includes buffs!
Basically everything you want to know when selecting gear for a PvE (raid) encounter, no? :)
Note: Due to not knowing how to calculate crit% based on agility for levels lower than 60, this will only be correct for level 60 hunters.
WHAT'S TAKEN INTO CONSIDERATION:
Ranged Attack Power
Ranged weapon damage
Ranged weapon speed
Multi Shot rank (including rank 5, found in AQ)
Aimed Shot rank
Talents: Ranged Weapon Specialization, Trueshot Aura, Killer Instincts, Lethal Shots, Mortal Shots, Lightning Reflexes, Barrage, Improved Aspect of the Hawk, Slaying talents and Surefooted.
Giantstalker 8/8 bonus
PvP gloves Multi-Shot bonus
For all stats: Use the number you see in the character sheet. For RAP, have Aspect of the Hawk active. If you have Trueshot Aura, write down the RAP without it active.
For crit%, take the number from hovering 'Attack' in the spellbook.
Input your agility, RAP, crit%, + weapon skill, +hit%, weapon stats, skill ranks, talent points, yes/no on Giantstalker 8/8, scope, quiver, ammo DPS and mob level. Then input stats on your current item(s), then the same with the new item(s).
To toggle using the new item(s), use the 'Use New (Yes = 1)' field.
You want to see if your damage output potential is higher with 2x Dawn's Edge or 1x Barbarous Blade.
In the 'Current item(s)' you input:
Agility: 30 (0 + 30 from enchants)
In the 'New item(s)' you input:
Agility: 25 (0 + 25 from enchants)
Use New: 1
Note: You can compare items (melee weapons, rings, necks, etc) or ranged weapons easily, but also a combination! Striker's Mark combined with Mark of Fordring vs Ashjre'thul combined with Prestor's Talisman of Connivery, Ancient Bone Bow vs Carapace Spine Crossbow. It's all up to you.
COMPARING TALENT BUILDS:
Instead of inputting items, you can see the difference in damage potential by changing talents (most common example would be a Marksman build vs a LR-build).
For comparing build only: Clear current and new items, clear new weapon. Put a 1 in the 'Use new' next to the talents you want to compare.
So going from a 5/31/15 to a 21/30 build, you'll type in something similar to this:
Talent Current New Use new? RWS..............5 0 1 TSA..............1 0 1 Killer I.........0 3 1 Lethal Shots.....5 5 1 Mortal Shots.....5 5 1 LR...............0 5 1 Barrage..........3 0 1 iAotH............5 0 1 Slaying..........3 3 1 Surefooted.......0 3 1Not only can you compare weapons / items or talent builds, you can do both! Ancient Bone Bow combined with 2x Dawn's Edge and a 0/31/20 build compared to Rhok'delar combined with Ice Barbed Spear and 0/21/30 build.
WHAT YOU GET:
Current and new:
Auto Shot DPS with Slaying and crit & hit added
Aimed + Multi cycle with Slaying, with crit and hit factored in, with iAotH.
Damage change per cycle, in both percent and pure damage.
A comparison for crit, agility and Ranged Attack Power.
Auto Shot DPS change: DPS change if you used *only* Auto Shot (with crits and hit added in). If you had 200 Auto Shot DPS (before armor) currently, and new was 210, Auto Shot DPS change would be 10.
Auto Shot DPS change in %: Same as above, but converted into percentage. 200 --> 210 would be a 5% increase.
Change in total DPS: DPS change using the best cycle for that weapon (Aimed Shot + Multi-Shot).
Change in total DPS (in %): Same as above, converted to percentage.
These 2 are the values you'll be most interested in.
The change in total DPS is listed for 2 cycle types; clipped and full. Depending on your weapon's speed, one of them will be optimal, and this is the cycle you should try to achieve. As a tool for comparing weapons, I've also included the sub-optimal cycles, to show which weapon would have the highest damage potential if you for example have lag, or just aren't able to time it as good as you'd like.
Note that using the DPS from both cycles is not a good idea for comparing weapons. For example, if you know the best cycle for The Milk MakerÃ¢â€žÂ¢ is clipped, you shouldn't make half your cycles full; you should try to use the best cycle whenever possible.
Should you clip your cycle (discard the Auto Shot currently cooling down and fire Aimed Shot immediately)? Or should you use a full cycle (wait for the Auto Shot to fire before using Aimed Shot? There's the answer ;)
For a more detailed post regarding cycles, feel free to check http://forums.wow-eu...opicId=15211926
I will continue updating this if people are interested.
Please, feel free to comment, come with suggestions, questions, corrections if anything seems wrong, etc. I can be reached either in this thread / on this forum, or in-game. Send a whisper to Lactose on Talnivarr (EU) server if you want to say hello =)
If I'm not online on Lactose, I might be on my alt; Label.
Please respect if I don't have time to answer though =)
(Horde only, I'm afraid :P)
Thanks for reading.
CURRENTLY RESEARCHING / UPDATING:
Implement better Improved Aspect of the Hawk formula