Yes, the import checks for the
header and it's an easy enough change to implement.

are there any changes in Hit raiting since v.86d ?

in v.86e i have 100,05% Hit against lv83 with a Hit rating of 230.

in v.86d it is 99.05 against lvl83 with a Hit raiting of 230.


no, there are no points in focused aim

You probably have heroic presence on to give you 1% extra hit.

loaded buffs "none", then loeaded "lvl 80 Buffs"

now it works fine and i'm on 99,02

I'm having a problem with the spreadsheet on Excel:mac 2008. Every time I try to change anything I get the error 'Microsoft Excel cannot calculate a formula.' I believe, but am not sure, that this is due to Microsoft's self-admitted idiotic decision to remove VBA from Mac Office 2008 (they're putting it back in the next incarnation, but who knows when that will be). When Cheeky did the spreadsheet this wasn't much of a problem as he only used macros for automation - I couldn't download from armory, or hit any of the 'auto-rotation' buttons, but I could just input everything manually and it would work, as all the actual dps computations were simply formulas. It was more work than if I had macros, but nevertheless I could use the spreadsheet.

Correct me if I'm wrong, but I believe your version uses macros much more pervasively and actually in the computations, not just for ease of use. I obviously don't expect you to go back and remove the macros and replace them with formulas, as you've added a lot of functionality that didn't exist before and asking you to create a gimped version for a small userbase isn't really something I'd want. Can you, however, confirm that this is my problem, and I'm not missing something completely obvious? If it is a macro problem a note in the FAQ for Mac users might also be nice.

(Apologies if this has been addressed before, unfortunately 'mac' is too small a search term for the forum.)

What are you trying to change? I can swap gear and talents in Excel 2008, just stuff like the armory import doesn't work.

Everything. I change a piece of gear, a gem, a talent point, an enchant, anything at all that will affect my stats and I get 'Microsoft Excel Cannot Calculate a Formula'. I have also realized since I posted that it is only the PTR spreadsheet (v86) giving me this problem, the Live speadsheet (v84) works perfectly. Can you confirm that the PTR spreadsheet works on your Excel 2008?

Here is a screenshot of the exact error I'm getting:

Hello everyone,

I'm hoping someone can help me with a problem.

I have Windows Excel Mobile on my PDA, but no Excel on my desktop (I'm currently away from my usual desktop).

The Hunter_DPS.xls file can't be opened by my PDA's Excel Mobile. The exact error message I'm getting is "Cannot open password protected Microspft Excel workbooks."

Any suggestions on how I can view this spreadsheet? My current tools available are:-
1) PDA with Windows Excel Mobile
2) Desktop with NO Excel
3) Working internet connection

So far I've tried looking for a free xls viewer in the internet, but the ones I've found can't seem to view the workbook well enough (I can't play with talents, gear or specs!)

I'd appreciate any help - my email is ghostroc@yahoo.com

Good hunting!

I've used both versions without issue. Not sure what's causing that error message.

I'll verify tonight in case something changed.

Update: Works fine for me. Not sure why yours is bugged.

Microsoft offers a fully functional 60 day (I think) trial of Excel. No credit card or anything required (I don't remember even being asked for my email address, but I may be wrong about that).

It'll get you through the next 60 days, at least.

It seems Icewalker is now called "+12 hit rating and +12 crit rating" which makes it fail on reading from the armory. I'm guessing the same is true for the other boot enchants.

Can the sheet's armor pen calculations be updated to match the ones in the combat ratings at 80 thread? People in that thread have confirmed it's live as described (including .81 multiplier to ArP from gear).

edit: doing the math, I get a boss having about 460 more armor using that formula vs the sheet, for my gear, so while it's not a huge difference I expect it would change the relative values of several items.

so any1 can confirm that 6/14/51 ( Talent Calculator - World of Warcraft ) spec is best DPS spec atm ?

Is there an ETA on a final live version of the sheet? The latest one gives a runtime error 13 each time I change something in the shot rotation, and loading profiles created with the sheet causes another runtime error and changes none of the settings.

Also seems wowhead's talent string has changed again to

@Khunad with my quick go on the sheet I used 6/14/51 and it was quite a way ahead of the BM and MM specs I tried.

Hey,

I've downloaded the spreadsheet now on both my Mac and my work Windows PC and I can't get either to work! Everytime I follow the instructions here (How to use the DPS Spreadsheet! � OutDPS!) when I get to the "Load Gear from Armory" I get an error message saying "There is no Valilor of Chromaggus on the EU Servers."

There is! It's me! http://armorylite.com/eu/Chromaggus/valilor

Any ideas?

99% of the time (making up statistics ftw) that's because the armory website is down. It may also occur (I'm not sure) if the armory takes too long to respond. There is always a high correlation between armory slowness/breakage and patch day.

Just try again later - check the official armory site and make sure you can pull up your profile first.

edit: Yeah, it just took me ~4 minutes to load your armory page.

Hello,

The pet abilities Wolverine Bite/RoR for Cunning pets aren't available in the dropdown after picking them up with the pet talents. Also Feeding Frenzy doesn't appear to be granting the cunning pet any additional damage.

Thanks

I tested your link and the glyps appear to be wrong...explosive trap? I thought the consensus here was for Explosive Shot? Also, The pack? I think something has gone wrong somewhere....

Talents seems to be correct, it should be Explosive Shot and not Trap ofc, minors are irrelevant anyways, Revive Pet or the pack, your choice, DPS isn't affected.
If you have low haste (sub-290), change serpent glyph with Hawk and remove a point in Hunting Party and put it in IAotH.

EDIT: Talent Calculator - World of Warcraft
EDIT2: updated original post.

These abilities are automatically averaged when you select the talent. Feeding Frenzy only works currently if you set the boss hp % to lower than 35% on the settings tab.

The engineering tinker Hand-mounted Pyro Rocket doesn't seem to be doing the correct amount of damage on 3.1 live. It was only hitting for around 900 (it's old damage) but it does have the updated 45 sec cooldown and it's off the GCD. I'm guessing its less or equal DPS to the Crusher enchant like this. Spreadsheet shows it as better than Crusher w/ the tool tip numbers.

Hello,

The Wolf talent spec in the 0/15/56 profile on the sheet doesn't seem to work. It has 1 point in Rabid and 1 point in Wild Hunt. On live 1 point of Call of the Wild is required for Wild Hunt - the profile seems to have an impossible spec.

I added the point to Shark Attack instead, and the dps loss was marginal. It appears that Call of the Wild/Wild Hunt is lower dps than Rabid/Shark Attack.

Thanks for all your work!