Hi Cheeky, great work on the spreadsheets. I have a couple of suggestions:
You can easily use your model to create a really powerful gear searching tool tailored to the hunter. The basic concept is to work out the personalised relative value of each stat, and then create automated (for example) allakhazam search links from that; or just ordering the gear by relative value.
There are a few relatively easy (but kind of major) tweaks you need to make to allow this to happen.
- Create a simple macro that creates an array with the relative merit in terms of both DPS and "time till oom" for every stat. You do this by setting the base dps and time till oom, then increasing each stat by 1 in sequence and recording the impact on dps/time till oom. This is actually much easier than it sounds.
- from here, you have scores for each stat and can create weighted allakhazam searches (eg my personalised base search for dps armor would be this link which i automatically generated knowing agi is worth 0.6, AP 0.31 etc etc (with some assumptions about the best gems, and for me excluding raid drops due to current time zone constraints on my raiding). You can then make simple changes in allakhazam to sort by slot etc. The search for weapons is slightly different.
- you can then create a column on each of the gear sheets that has the same weighting, and use this to sort gear in terms of merit rather than alphabetical order. You could also include perhaps a "score" for the gear selected on the gear spreadsheet including both the dps score and "time till oom" score to make the new selection simpler.
- to allow this sorting to happen you have to use "vlookup" rather than "lookup". Lookup is quite limited in that your lists have to be alphabetical to find the linked value. vlookup just looks for matches - so your list can be sorted in any way. Basically this involves changing every lookup on the gear sheet - which sounds major, but only takes an hour or so with some smart search/replacing.
Like I said I've kind of had a dodgy go at this. If you want to see what I've done I can email my crappy version of the spreadsheet file to you. I have to admit and apologise up front that I've done a dodgy crack of your spreadsheet to make these changes myself - excel security sucks :/.
Last edited by liquidf : 09/28/07 at 1:09 AM.
Did some proc chance testing on dr boom today, just autoshotting with a final speed of 1.92. No misses. Internal cooldown assumed to be 17 secs. Serpents swiftness, 15% quiver, 2.7 speed weapon, 1.71% passive haste.
Total time: 7843*1.92=15058.86s
Time spend inside the internal cooldown: 527*17=8959s
Remaining time outside the internal cooldown: 15058.86-8959=6099.56s
Hits outside the internal cooldown: 6099.56/1.92=3176.854
Proc chance outside the internal cooldown: 527/3176.854=.165887
Speaking of that ring, it looks like the proc isn't modeled, correct?
Yeah it's not modeled correctly, I myself just got the revered one so it will be a while before i can get the Exalted one. But right now the base stats are wrong so even equipping it in the spreadsheet lowers my DPS.
With respect to the macros in Mac OSX, the problem with the buttons is that they are implemented using activeX controls, which are not available on the mac. It is possible to use a different type of button which works on both Mac and PC using the forms toolbar (so I understand). It would probably be a lot of work changing it over (and since I can't run the macros manually there are probably more problems than just the buttons). Anyway whilst some of the convenience of the spreadsheet isnt available to max excel users its still a fabulous tool.
If my question has been answered earlier in the thread, slap me, but here goes:
How does your spreadsheet calculate the hit cap? I was under the impression that a hunter's base hit cap against a boss is 9% (taken from the sticky in this forum) and according to Lacoste's info one point of weapon skill (not rating) gives 0.24% hit. That'd put a dwarf with a gun (or a troll with a bow, I suppose) at a cap of 7.8% or 123 hit rating. I have exactly 123 hit rating equipped and a gun, but yet when I unequip hit rating in your spreadsheet it still reports a 100% hit chance. According to your spreadsheet, the hit cap with specialization taken into account seems to be at 91 or 92 hit rating (and yes, I have set the mob lvl to 73 in the settings). What have I missed? Thanks in advance.