WotLK DPS spreadsheet - Page 16

vith · 09/27/08, 1:02 AM

Import/Export isn't working for me on Vista64 with Office 2007. Probably a permissions problem with "C:\Hunter_DPS_export.bin"?

"Run-time error '75': Path/File access error"

The rogue spreadsheet's import works, but that one just has you select the old spreadsheet directly instead of using an intermediary file.

Shandara · 09/27/08, 3:06 AM

@Midnight
Thanks for uploading. It confirmed what I was suspecting. Latency is in seconds, not milliseconds. So putting the value '10' in there means you have 10 seconds of latency. Maybe I should put a note with it.

The Gem was indeed yellow, it's not surprising one or two gems got in faulty since it was a huge batch of 300+ gems added in WotLK.

@Vith
I don't have Vista myself, so I can't really check it. But yes, it's probably related to the permissions of the file. If anyone has an elegant solution for it, I'll be happy to use it.

Update:

- Pets now benefit from Hunter's +hit
- Reworked Glancing blows mechanism for pets
- Fixed bug in profile saving if you had no shots in your shot rotation queue
- Bright Scarlet Ruby is now a Red gem (instead of yellow)
- Hunting Party now has a proper range from 0/5 to 5/5 talent points
- Pet hit now affects pet spells as well

Fuulish · 09/28/08, 10:07 AM

Originally Posted by vith

Import/Export isn't working for me on Vista64 with Office 2007. Probably a permissions problem with "C:\Hunter_DPS_export.bin"?

"Run-time error '75': Path/File access error"

The rogue spreadsheet's import works, but that one just has you select the old spreadsheet directly instead of using an intermediary file.

Is it possible to have the path not be hardcoded and simply be a field on the Settings tab? I don't have a C: drive, so I have to manually upate the VB macro everytime a new version comes down.

Also, was something changed with the Import/Export process such that exporting from version 69 and importing into version 72 could possible stop working? I tried to do an export of my set up in v69, but when I import to v72a the data references on the Settings/Results tab are incorrect?

I can try to post a screenshot if necessary.

Shandara · 09/28/08, 10:24 AM

Good point, I removed the Glyph Mastery glyph somewhere in between so that probably broke it.

As for the file name, there's no particular reason why it's hardcoded, except that's how Cheeky did it. I'll add an option for it next release.

samfisher · 09/30/08, 2:55 AM

Hmm, the Gear Planner says there is an included option on how to apply hit? I can't seem to find the dropdown menu =P

Shandara · 09/30/08, 5:51 AM

Originally Posted by samfisher

Hmm, the Gear Planner says there is an included option on how to apply hit? I can't seem to find the dropdown menu =P

That option was removed, I just forgot to change the text explaining the gear planner.

Griffen · 09/30/08, 6:07 AM

The change to pet's hit has been confirmed by GC now.

MMO-Champion BlueTracker - GC questions - big big list cuz we're scared

A bit down in the post:

All pets should inherit the hit of the master now.

samfisher · 09/30/08, 9:07 AM

Yeah, I have a Recount screenshot showing 0 pet misses on the PTR. Glad to see the change.

@Shandara - So I assume it selects gear based on current hit then? =)

Shandara · 09/30/08, 11:53 AM

Originally Posted by samfisher

Yeah, I have a Recount screenshot showing 0 pet misses on the PTR. Glad to see the change.

@Shandara - So I assume it selects gear based on current hit then? =)

I tweaked the logic so it bases the DPS boost based on the hit that would be used if you replaced the item currently equipped with the one being compared, which is the logical way to do it really. It also counts gem sockets/socket bonus.

E.g. If you're at the hitcap and your current belt has no hit then all compared waist items' hit is useless and thus worth 0 DPS.

Conversely, if you're 4 rating below the cap then any item with more than +4 (+current hit on the item) to-hit will waste part of it.

It's my hope this will make the gear planner more accurate, in that an item that's listed above the one you have currently equipped will always increase your DPS (rather than the old spreadsheet where you'd have to fiddle with the settings in an all-or-nothing setting).

lairpie · 09/30/08, 6:11 PM

A simple "ignore hit cap" check box and a resort would be pretty helpful. While that's not 100% accurate, as your dps will fluctuate a bit as you change gems around, most of the time if I'm hit capped and an item would put me 10 hit over, I still want it, its still better, and I just need to change some gems or something around after I get it. The dps difference between different gemming setups is fairly minimal to where just ignoring the hit cap when you have that checked seems like it would provide a much better idea of what is and isn't an upgrade. People will still be able to uncheck it, and tweak their gems around to get the exact numbers.

Shandara · 10/01/08, 6:58 AM

Update:

- Aimed Shot is now 8% mana (12% for sub-70 ranks)
- Kill Shot now deals 200% weapon damage + 0% RAP + 410/500/650 damage for rank 1/2/3
- Multi-Shot now costs 9% base mana (13% for sub-70 ranks)
- Focused Aim now gives 1/2/3% to-hit
- Surefooted and T.N.T. swapped places
- Scatter Shot moved to SV tree, Trap Mastery as 41pt talent, Readiness to MM tree
- Point of no Escape has now only 2 ranks
- Implemented Readiness to work with either The Beast Within or Rapid Fire (select which on Talents tab, not saved in profiles yet)

Chul · 10/01/08, 9:52 AM

You should probably add:

Spell Critical Strike Chance Debuff: Improved Scorch, Winter's Chill

EDIT: Why choose which spell is affected by Readiness? Shouldn't it reset both?

Shandara · 10/01/08, 10:15 AM

Originally Posted by Chul

You should probably add:

Spell Critical Strike Chance Debuff: Improved Scorch, Winter's Chill

EDIT: Why choose which spell is affected by Readiness? Shouldn't it reset both?

Good point. I should wake up properly before I make changes.

Edit:
On the subject of Scorch and Winter's Chill, what of our shots are affected by this? Same goes for our pets.

Arcane Shot works of our ranged crit chance, but is affected by, say, Curse of Elements. Does it gain extra crit from the mage debuffs too?
Explosive Shot the same, but also has ticks. Do the ticks benefit as well?

I'll try to test those questions today.

Fuulish · 10/01/08, 12:03 PM

Originally Posted by Fuulish

Is it possible to have the path not be hardcoded and simply be a field on the Settings tab? I don't have a C: drive, so I have to manually upate the VB macro everytime a new version comes down.

Also, was something changed with the Import/Export process such that exporting from version 69 and importing into version 72 could possible stop working? I tried to do an export of my set up in v69, but when I import to v72a the data references on the Settings/Results tab are incorrect?

I can try to post a screenshot if necessary.

Following up on this, I tried to do the import with the latest v73 and got this. I wasn't sure if your reference to the removal of the Glyph section was in response to me or not, but I'll assume so. For now I'll just manually key it in like normal folks =P

http://i203.photobucket.com/albums/a...import_odd.jpg

Shandara · 10/01/08, 12:30 PM

Originally Posted by Fuulish

Following up on this, I tried to do the import with the latest v73 and got this. I wasn't sure if your reference to the removal of the Glyph section was in response to me or not, but I'll assume so. For now I'll just manually key it in like normal folks =P

http://i203.photobucket.com/albums/a...import_odd.jpg

Yes, it was in response to you. Anything pre-Glyph Mastery removal won't import properly. You can fix it by hand by editing the profiles tab, though.

Providing conversion in these cases hasn't been very high on my priorities, I'm afraid. Once WotLK hits and updates/major changes are less frequent I'll probably consider it. One down side by the way I save profiles and import/export stuff now is that it's done in blocks of data, rather than each cell one-by-one. So correcting changes is slightly more iffy. It's a lot faster though.