Hunter Spreadsheets -- In development - Page 55

lmk · 09/27/07, 7:54 PM

Originally Posted by Cheeky

No option to save as a Mac-specific format. I have no idea why it wouldn't find the VB parts - I haven't done anything different in the way I save it.

It's okay, the macros just make things easier, but I can still do it manually, the sheet is already so fantastic I really don't mind. It may also just be my copy of Excel acting up.

liquidf · 09/27/07, 11:02 PM

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 :/.

Xeno · 09/28/07, 6:27 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.
Autoshots: 7843
Procs: 527
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

Zomghuntar · 09/28/07, 9:47 AM

[Band of the Eternal Champion] Needs to be updated in the spreadsheet. It is showing as 24agi 28stam 58ap.

Fendryl · 09/28/07, 10:46 AM

Originally Posted by Zomghuntar

[Band of the Eternal Champion] Needs to be updated in the spreadsheet. It is showing as 24agi 28stam 58ap.

Speaking of that ring, it looks like the proc isn't modeled, correct?

Cheeky · 09/28/07, 11:30 AM

Originally Posted by Fendryl

Speaking of that ring, it looks like the proc isn't modeled, correct?

If you can get me ppm/cooldown numbers I can add the proc in. I'm nowhere close in progression to getting it myself. Right now it isn't modeled at all.

Zomghuntar · 09/28/07, 10:15 PM

Originally Posted by Fendryl

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.

Marthel · 09/29/07, 9:22 PM

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.

Ayoria · 09/30/07, 12:37 AM

Hello

thx a lot for the work but i found an error about this item: Dragonstalker's Belt

the stats are not good in the hunter dps calc v31.

like you see:

the good stats:

Allakhazam.com: World of Warcraft: Item: Dragonstalker\'s Belt

The wrong stats in the calculator:

Dragonstalker's Belt 249 0 29 37 0 0 76 0 19

And in the end of the gear page he found me just 1 item set "Dragonstalker Armor" (i have 2: chest & belt hehe)

PS: I use Excel 2007 and i cant push the buttons of the calculator (like CalcAttributes, Save, Load, Reset etc..) maybe some one answear about this... but sincerly i cant read 819 replys

Cheeky · 09/30/07, 2:01 AM

Originally Posted by Ayoria

PS: I use Excel 2007 and i cant push the buttons of the calculator (like CalcAttributes, Save, Load, Reset etc..) maybe some one answear about this... but sincerly i cant read 819 replys

I'll check the Dragonstalker stuff, but I can't be bothered to answer a question for the Xth time because you don't feel like using the search feature.

Xenoborg · 10/01/07, 1:49 AM

Not a huge thing, but you could add [Elixer of Demonslaying] to the battle elixers Elixir of Demonslaying - Items - World of Warcraft

intressepil · 10/02/07, 11:44 AM

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.

Lactose · 10/02/07, 11:50 AM

That link is outdated in terms of Weapon Skill, I'll get it fixed later today (if I have the time). The spreadsheet is using the correct Weapon Skill calculations.
Oh, and it's Lactose, not Lacoste.

intressepil · 10/02/07, 11:58 AM

Originally Posted by Lactose

That link is outdated in terms of Weapon Skill, I'll get it fixed later today (if I have the time). The spreadsheet is using the correct Weapon Skill calculations.
Oh, and it's Lactose, not Lacoste.

Oh sorry, I'm all about name-brands. And thanks

.

EDIT: If Lactose doesn't find the time to update the site, could anyone maybe direct me to info regarding how weapon skill works?

Shandara · 10/03/07, 5:48 AM

Was just fiddling with the spreadsheet when I noticed the Spiteblade from KZ has the wrong stats (pre-buff I think).

It should be 14 agility, 16 stamina, 46 AP