I don't know if this is related to the DLL loading error previously posted about, but running versions 30 and 31 on Excel:Mac 04 none of the buttons do anything -> Shot rotation buttons don't change the shot rotation, saving/loading sets doesn't work, etc. I think it might be a macro problem, but don't know enough about macros to really look into it. Also haven't tested versions earlier than 30.

Edit: I can do any testing, if you tell me what to do.

I was wondering if I am looking at this all wrong or if the Pet Damage isn't completely flushed out in the spread sheet?

I see the following...

Please forgive me if I am missing something obvious.

I think I left some ranks in Screech (I was testing something) when I saved it last. That table is filled out based on the ranks specified for the abilities. Some aren't modeled yet, they are in red in the Pet Training matrix.

Regarding Mac Excel, I have no idea how to even begin debugging what is wrong. Do you get a Visual Basic error and access to the built-in debugger? I have no way to testing this on Mac, and no idea what it's limitations are compared to Windows.

Okay I see how it works now... Pick a pet.. train it... pick it's abilities.. catch your DPS.

Also, it's still using the Scorpid pre-patch if I am correct.. so I can just go ahead and discount it.

I really appreciate all your work Cheeky, I honestly have no idea how you do it!

Looks like Ravager and Wind Serpent are the highest DPS pets but I worry about pathing and certain encounters such as Void Reaver for the Wind Serpent...

Now it's time to start searching on the appropriate way to spec a pet. I here some saying get 3 of the same pet and have 2 of them with certain resistances.. and the other with none. Want to find some data to help me make a decision on what to do.

I'm hoping to do some testing this weekend to see what the new spell coefficient is. I did all that work to build the model for it, might as well spend an hour seeing exactly what Blizzard changed about it.

mark of conquest.xls The logs are pretty scattered I don't think I can possibly find them. This wasn't designed to find the proc chance just the internal cooldown, the problem is I took mana breaks and didn't record them so 13% is kinda sketchy. The internal cooldown I think is pretty clearly 17 secs. A few hours at dr. boom with procwatch using just autoshot should do the trick for the proc chance.

I can do that, but it's a low priority for me. I have a few more PvE changes I'd like to add first. I'll keep it in mind.

Regarding Mac Excel - it appears the buttons themselves are doing absolutely nothing, they don't cause anything to run. If I manually view the macros available in the workbook I get only two total for the whole workbook: 'SteadyRotation' and 'ResetRotation'. Running either one causes an error and sends me to the debugger.

Running 'SteadyRotation' causes "Compile Error: Object required" and sends me to the debugger with the first line of the function (method? macro? I never used VB) highlighted: Sub SteadyRotation().

Running 'ResetRotation' causes "Run-time error 1004: Method 'Range' of object '_Global' failed", and highlights the following line in the macro: For Each cell In Range("SelectedShots").

It looks to me, never having used VB, that there is a considerable amount missing that might have to do with the DLL loading problem another person reported. It's possible Mac Excel just does things completely differently. Is there an option to export the spreadsheet in Excel:Mac 2004 format?

If not, it's not a huge deal, I can save separate copies for different gear sets and manually change my shot rotation. Also, Mac Office '08 is out in January and may fix all this.

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.

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

[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?

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.

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.

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.

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

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.

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?

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