Every single version of the Spread Sheet I have downloaded recently has been somehow corrupted and Excel tries to repair it (failing of course), and a number of features become completely unusable (shot rotations mainly).

I know I have used v32 in the past with no problems, but now for some reason it will not work correctly when I try to download it. Is there something wrong with my copy of Excel or are other people experiencing the same thing with the Spread Sheet? I always enable macros, so that definitely is not it. I cannot figure out why every version of the Spread Sheet is experiencing issues for me. I have not done anything with Excel since the last time I used the spread sheet.

For what it's worth, one of my guild's hunters, to whom I recommended the spreadsheet, has been experiencing the same for some revisions now.

I checked the usual with him, but could not determine what was causing this, since his configuration is seemingly the same I have.

Open Office is much pickier with having spaces in comparison strings. I'm working on fixing all of them so the buffs work properly.

I only have access to Microsoft Access 2002 (SP3), so I'm not sure if there are compatibility issues with later versions. And if there are, I'm not sure what I can do about it.

Don't see the following gem on the list...
Infused Shadow Draenite - Items - World of Warcraft

Also would it be possible to proceed the gems with the color.. or at least an acronym so they will be grouped together?

Purple - [Gem Name] (Bonus)

From what I understand the gem pattern does not drop in the game, making the gem impossible to actually socket.

I need to work out something with gem colors. The biggest problem is keeping all the text fitting on a line. Let me see what I can come up with.

Armor Penetration wasn't showing up in any slot for me. Not just waist/wrist

It's all pretty fucked up. I'll make sure all Armor Penetration stats on the 'Custom Gear' tab work correctly.

GCD for steady shot is set to 1,5s in the spreadsheet. is GCD not reset for spells >0,5s <1,5s ?
this would be a effective 1,3s GCD

Using Excel 2007 and quite a few columns are to narrow to show the value, meaning I get ##### as data.

Anyway to unlock or fix?

Edit: Found another little bug. Seems "Foreman's Reinforced Helmet" is missing 30 agi and 6 ap.

Hmmm. I'm using Excel 2003, it could be compatibility issues, but I had a 2005 version at the job I had over the summer that worked fine, and I'm confident it was working for me on this computer with 2003 no more than a few weeks ago. Maybe it was an earlier version of the spread sheet I'm thinking of (27-29?). Was there a big new feature added between the late 20's and the versions currently available?

I do not understand what you are trying to say.

IIRC this was added as in 2.2 as a drop in BEM, I got it off a friendly guildie. FWIW Cheeky had it in the spreadsheet well before 2.2, I reported it as not existing at that time so he removed it - bah!

The other new 2.2 patterns are: [Design: Great Golden Draenite], [Design: Balanced Shadow Draenite], [Design: Veiled Flame Spessarite], [Design: Wicked Flame Spessarite]. Apparently these also drop from BEM summoned mobs & dragons.

In version 34 armor from agility isn't being added in to total armor on the gear tab.

Will the new Items from patch 2.3 and Zulaman be added now, or will you wait until the realease of all content.

Cause pretty much all loot is already announced on wowhead

I'm seeing this work correctly. You can check in cells B66-B68 on the 'Calculations' tab to verify.

Generally I hold off until things have settled down, but based on the feedback I'm getting regards previously unknown bugs in the 'Custom Gear' tab people really want this soon. I'll try and get it all in for a new version this weekend. As you find things I've missed, just post them here (using Item Links saves me time.)

On the Calculations tab it does show me getting the 1707 armor from agility, but on the Gear tab the cell is =SUM(C87:C90)*(1+C91)*(1+C92) Which gives my base armor of 5233 because it isn't adding in the armor from agility on the Calculations tab.

Lol, I should probably refrain from looking at the spreadsheet while I'm in my 7am class and wait until I'm awake. :-) Thanks for the clarification.

Anything we can do to help you with that spreadsheet? I see a lot of gear changes in store for 2.3 so I don't envy you the task of having to update all those by yourself.

Eh, it's not so bad. WoWHead lists some ~75 items I need to worry about, and the Hunter community is pretty vocal and quick about letting me know when I've missed their favorite piece of gear.

I'm hoping to get something ready fro Sunday, but work's been rough this week.

in the spreadsheet shot rotation:
steady casttime with quiver is 1,3s but the next shot starts after 1,5s because of gcd = 1,5s


wowwiki states:
Global Cooldown is refreshed when the spell ends, for spells with a casting time less than 1.5 seconds, and greater than 0.5 seconds.


shouldn't the next shot start at 1,3s instead of 1,5s ?

WoWWiki is wrong.

I found a bug in the Beast Lord Helm, in version 34. The socket bonus is showing up as +2 Resilience rather than +2 mp5.