Level 60 Hunter Spreadsheet (using Lactose’s cycle formulae)
(September 19, 2006)

Hey guys, here is a spreadsheet I made to help compare specs and armor sets for survival and marksmanship hunters to compare raid damage. Most of the spreadsheets I have seen were too complicated or didn't work correctly so I tried to make this simple. Tell me what you guys think. This is still a work in progress, any ideas, fixes or help would be appreciated.

Level 60 Hunter Spreadsheet: Version 3.2
Quickdump
Filefront

Burning Crusade Spreadsheet: Version 3.2 Alpha
Quickdump
Filefront

Spreadsheet includes:
Full and clipped cycle damage comparisons using Lactose’s formulae
Un-buffed, self-buffed and raid-buffed statistics
Two sets of talents and armor sets to compare with
Drop down armor menus and selectable buffs
Average and maximum burst damage for PvP
Mana longevity (Spirit not included, sorry T_T)
Damage per mana ratio
And a few other goodies…!


Read more about Lactose’s formulae at http://forums.wow-europe.com/thread....15211926&sid=1

Updates:
3.2 September 19 Added ranged weapon classifications and +Ranged racials. Renamed “Other†to “Misc†in Set-A/B. Renamed “Necklace of Kel’Thuzad†to “Stormrage’s Talisman of Seething.†New spell and buff ranks added to Burning Crusade Spreadsheet.
3.13 September 14 Fixed a few errors in how stat comparisons were calculated. Changed Weapons to 20% for expansion spread sheet.
3.12 September 13 Small change in the +Ranged skill & started expansion version.
3.11 September 08 Fixed an error in Set-B’s comparison where it was using Set-A’s item stat for on “Use" trinkets.
3.1 September 06 Renamed Bow of the Four Horsemen to Soulstring and changed Slavemaker to 3.2 (from 3.0). Added Horde totems and Onyxia chain buff. Added Barrage Shoulders to item list. Fixed a bug in Set-B Comparison’s AC calculation.

Looked decent overall. The comparison of A vs. B was confusing, I wasn't sure where you got your comparison calcs from. I would have liked to have seen a Raptor strikes calc for A and B.

For fun you could add the new Naxx shoulder enchant, 26 AP 1 crit.

Well I haven't had a chance to go over it thoroughly, but let me just say: you're an excel god

Sorry, I guess I should have explained some of it a bit more. On the comparison page, there are individual stats for both sets, A & B. At the bottom is where you find the comparison of which is better or worse. For raiding, the main item to look at would be the “Optimal DPS†in the bottom box which would be the “Custom Buffed†cycle DPS comparison. There is also note at the bottom which says, “Positive values show that Set B is better than Set A.†So obviously, negative would mean the opposite.

About Raptor Strike, I already have it on the maximum and burst damage. And uh... hmm… if you really want to see average damage for raptor strike, it should be in the hidden sheet called “Math." Set is should be in between K75-K77 and Set-B should be between Y75-77.

I have also already added the shoulder enchant. It is called “Might of the Scourge†and can be found using the drop down menu for the shoulder enchant slot.

Very impressive Sarana. Nice clean interface while still giving you tons of information.

Holy crap... Beautiful.

Edit: how long did this take cuz it's amazing.

QFT QFT QFT

I've whiled away more than one hour on your spreadsheets :)

OMG, I can't wait to see the expac version with all those shammy buffs!

very cool. still trying to figure out all the neat things it can do :)

Not sure if they were in there, but I didn't find any Horde buffs. =[

Also is the mana regen from Black Grasp considered based on weapon speed + rotation?

edit: Otherwise beautiful spreadsheet. I can actually use this one without getting confused!

Cazypie: I have been working on the spreadsheet for a while, but on and off. I added bits at a time during my breaks in between classes, haha. I just recently switched to different formulas and tried to make it look more attractive.

Groglox: Oops! Being in an Alliance guild, Horde buffs seem to have slipped my mind. Can some one please tell me what buffs the Horde have that effect hunters (and maybe their values ^_^)?
To show Black Grasp’s mana regeneration, I used the number of shots per cycle.


Nasq reported an error in Set-B comparison where it was not taking AC debuffs into account (thanks ^_^). I will post an updated version with the fix and horde buffs when I get the values.


Thanks for the comments so far! :kaubel:

Horde raid buffs:
Warchief's Blessing - http://www.thottbot.com/?sp=16609

Horde party buffs:
Grace of Air (Rank 1) - +43 Agi
Grace of Air (Rank 2) - +67 Agi
Grace of Air (Rank 3) - +77 Agi

Strength of Earth (Rank 1) - +10 Str
Strength of Earth (Rank 2) - +20 Str
Strength of Earth (Rank 3) - +36 Str
Strength of Earth (Rank 4) - +61 Str
Strength of Earth (Rank 5) - +77 Str

Enhancing Totems [Tier 3 Enhancement Talent]
(1/2) - Increases the effect of your Strength of Earth and Grace of Air Totems by 8%
(2/2) - Increases the effect of your Strength of Earth and Grace of Air Totems by 15%

Bow of the Four Horsemen is actually called Soulstring now.

There was an older hunter spreadsheet made by Stony from the EU forums that has some slighter better user friendly options as well as some visuals that you could incorporate, if you'd like to check it out I could email it.

DarkChylde: Wow, how come there is a Horde only buff -.-, does that haste effect ranged attacks?
Just making sure, that 77 Agility is before talents right? So it would be about 88 Agility after talents?

I will change Soulstring and I believe Slavemaker is 3.2 now… so I’ll change that too.

I’d be glad to take a look at that spreadsheet, just send it to me at italiasan2k5@yahoo.com, thanks in advanced.

It's part of our Onyxia quest chain. It does not effect ranged. Not sure how Blizzard does rounding, but 15% of 77 is 88.55.

Very nicely done Sarana, one question where are you hiding the gear data? I'd like to add Barrage shoulders, but can't seem to find where to put it =)

Edit: Never mind, I found it with some more digging around, thanks anyways!