Level 60 Hunter Spreadsheet (using LactoseÃ¢â‚¬â„¢s cycle formulae)
Posted 03 September 2006 - 08:52 AM
(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
Burning Crusade Spreadsheet: Version 3.2 Alpha
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-eu...=15211926&sid=1
Posted 03 September 2006 - 11:27 PM
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.
Posted 04 September 2006 - 12:47 AM
For fun you could add the new Naxx shoulder enchant, 26 AP 1 crit.
Posted 04 September 2006 - 12:49 AM
Posted 04 September 2006 - 02:13 AM
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.
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.
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.
Posted 05 September 2006 - 10:03 PM
Posted 05 September 2006 - 10:09 PM
Edit: how long did this take cuz it's amazing.
Raiding music that gets things done.
The best Theorycraft and Mathcraft happens after a raid and before the sun comes up.
Posted 05 September 2006 - 10:56 PM
QFT QFT QFT
Well I haven't had a chance to go over it thoroughly, but let me just say: you're an excel god
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!
Posted 05 September 2006 - 10:59 PM
Posted 05 September 2006 - 11:43 PM
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!
It probably shouldn't surprise me that the first applications of one of the coolest creature designers ever made is going to be cockmonsters and titwalkers.
I mean christ, cunnilingus is much like being a resto shaman, you spam the button and let it do the work. So long as you change targets as appropriate you don't need to put any thought into it.
Posted 06 September 2006 - 01:27 AM
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:
Posted 06 September 2006 - 05:27 AM
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.
Posted 06 September 2006 - 06:58 AM
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 firstname.lastname@example.org, thanks in advanced.
Posted 06 September 2006 - 11:32 AM
Posted 06 September 2006 - 03:49 PM
Edit: Never mind, I found it with some more digging around, thanks anyways!
Posted 06 September 2006 - 05:56 PM
A couple bugs :
1.) On the Comparison Page, the set b stat damage ratio box seems to be malfunctioning. Even with the same gear, the values are way off from set a -> set b. Aside from the malfunction, the custom buffed section appears to be reporting false values as well. Agility is worth less AP with kings than it is without it according to that line. It also reports some crazy random numbers on occasion.
2.) (not positive about this one) It's reporting the cycle rotation time for Nerubian Slavemaker as 11.33 seconds, which I "think" is incorrect. I can't get Lactose's thread to load atm, so I could be wrong. I was thinking the optimal cycle for that bow (assuming 3.2 speed) would be closer to 9 seconds. I guess it's not a big deal since we don't actually know the correct values for it.
Again, though, thanks very much for the hard work. This thing looks great, and I eagerly await it's completion! :D
Posted 06 September 2006 - 06:51 PM
Posted 06 September 2006 - 07:42 PM
Get you some purple drank and slow yo roll.
Posted 06 September 2006 - 07:45 PM
1.) I believe I may have forgotten to add kings to the agility ratio but even so, I donÃ¢â‚¬â„¢t seem to be getting any crazy numbers. Can you please show me an example? Also, note that there is a level and armor rating for both Set-A and B, make sure they are the same. I will work on adding kings to the agility some time soon.
2.) The problem with the Nerubian Slavemaker is that it is currently listed as 3.0 (older stats I have seen). I will be uploading an update in a few minutes which will include the 3.2 speed version. I wasnÃ¢â‚¬â„¢t really sure of the real stats since there is no physical proof of the crossbow yet since KelÃ¢â‚¬â„¢Thuzad has not been killed on live servers yet.
Twid: You probably did not include the 5 second delay on the free Autoshot after Aimed shot was fired. Hope that helped :)
Posted 06 September 2006 - 09:22 PM
My spreadsheet says the following:
Set A (Stat = +1 Crit and the values are from the AP column) :
Self Buffed: 32.53
Custom Buffed: 32.36
Set B (Stat = +1 Crit and the values are from the AP column) :
Self Buffed: 0.27
Custom Buffed: 0.22
**Note : The values in the agility column are different as well.
Is there something else I need to do? All of the various damage squares are very close to the same due to the small difference in AP given by the crest, but these values appear to be way off.
Thanks in advance!
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users