Hunter Spreadsheets -- In development - Page 60

Kaber · 10/16/07, 6:49 AM

Originally Posted by Cheeky

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.

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?

Cheeky · 10/16/07, 9:45 AM

Originally Posted by Sumpfmolch

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

I do not understand what you are trying to say.

Abbichum · 10/16/07, 9:57 AM

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.

i had this pattern drop off a summoned boss(35 apexis shards one) in blades edge, so it does indeed exist in game

Vaxum · 10/16/07, 3:52 PM

Originally Posted by Abbichum

i had this pattern drop off a summoned boss(35 apexis shards one) in blades edge, so it does indeed exist in game

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.

Zomghuntar · 10/17/07, 8:27 AM

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

Exhaler · 10/17/07, 8:53 AM

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

Cheeky · 10/17/07, 10:57 AM

Originally Posted by Zomghuntar

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

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

Originally Posted by Exhaler

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

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.)

Zomghuntar · 10/17/07, 1:01 PM

Originally Posted by Cheeky

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

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.

Cheeky · 10/17/07, 2:51 PM

Originally Posted by Zomghuntar

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.

Ok, that cell is only the total from your gear and buffs. If you look at the top of the 'Gear' tab (or on the 'Settings and Results' tab) that total includes everything.

Zomghuntar · 10/17/07, 2:56 PM

Originally Posted by Cheeky

Ok, that cell is only the total from your gear and buffs. If you look at the top of the 'Gear' tab (or on the 'Settings and Results' tab) that total includes everything.

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.

Fuulish · 10/17/07, 7:52 PM

Originally Posted by Cheeky

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.)

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.

Cheeky · 10/18/07, 12:33 AM

Originally Posted by Fuulish

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.

Sumpfmolch · 10/19/07, 7:39 AM

Originally Posted by Cheeky

I do not understand what you are trying to say.

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 ?

Lactose · 10/19/07, 8:58 AM

WoWWiki is wrong.

Dhirken · 10/19/07, 12:09 PM

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.