Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Hunters

Closed Thread
 
LinkBack Thread Tools
Old 03/02/09, 8:31 AM   #1771
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Update:
- Made some changes to the Gear Planner 'Assume 100% hit' so it devalues all hit completely now
- Trap Mastery now affects Immolation Trap damage
- Tenacity/Cunning mobs now have proper 2 pts talents at the highest tier (Wild Hunt and Silverback/Graxce of the Mantis)
- Spelling corrected on Deadly Gladiator's Band of Victory
- Corrected Cunning pet talent tree to account for the new changes (addition of Roar of Sacrifice, moving of grace of mantis)
- Added a gear import/export string to the overview tab
Try out the gear import/export string feature. I cooked it up in about an hour, but it has a modicum of error-checking built-in to prevent invalid items and such. It's human-readable at the moment and I like that. Encoding it in some way (even if I could use ItemIDs) probably won't make it better.


Offline
Old 03/02/09, 9:44 AM   #1772
Bokomatic
Von Kaiser
 
Bokomatic's Avatar
 
Troll Hunter
 
Азурегос (EU)
Originally Posted by Shandara View Post
Try out the gear import/export string feature. I cooked it up in about an hour, but it has a modicum of error-checking built-in to prevent invalid items and such.
Doesn't work for me. I did export - successful. Next, import and...
Microsoft Visual Basic reports:
Run-time error '9':
Subscript out of range


Actually i even can't find export file.
I saw Hunter_dps.bin in %mydoc% folder, next i removed it because of thinking that old version may cause problem.
Now it even doesn't be created.

Is it possible to make second field where is possible 'Paste' string?
And button 'Parse' with the same function as 'Import'?

I just want to use copy/paste for import/export. It's easy and more intuitively.

Originally Posted by Shandara View Post
It's human-readable at the moment and I like that. Encoding it in some way (even if I could use ItemIDs) probably won't make it better.
If this string allow unequivocal parsing it's good. I think it is, at least you parse it.

Offline
Old 03/02/09, 9:56 AM   #1773
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Are you using the 2 buttons next the input field on the Overview tab?

You can copy the text in that field out and/or paste something else in there and then hit the 'Import Gear String' button to import it.

If you are using the 'Export to File'/'Import from File' buttons they have nothing to do with this, but are for exporting the whole sheet's settings to file. Likely I broke that because I made some corrections to the pet talents.

The basic idea is just copy and paste someone else's string into your sheet:

V1:Calamity's Grasp;Greater Potency (One Hand);None;None;None;Torment of the Banished;Accuracy;None;None;None;Hyaline Helm of the Sniper;Arcanum of Torment;Relentless Earthsiege Diamond (21 Agi);Rigid Autumn's Glow (16 Hit);None;Pendant of the Outcast Hero;None;None;Beast-tamer's Shoulders;Greater Inscription of the Axe;None;None;Hammerhead Sharkskin Cloak;None;None;Valorous Cryptstalker Tunic;Super Stats;Bright Scarlet Ruby (32 AP);Infused Twilight Opal (16 Ap, 3 Mp5);None;Bands of Anxiety;Fur Lining - Attack Power;None;None;Valorous Cryptstalker Handguards;Major Agility;Rigid Autumn's Glow (16 Hit);None;None;Vereesa's Silver Chain Belt;Belt-Clipped Spynoculars;Infused Twilight Opal (16 Ap, 3 Mp5);None;None;Leggings of Failed Escape;Icescale Leg Armor;Bright Scarlet Ruby (32 AP);Infused Twilight Opal (16 Ap, 3 Mp5);None;Trespasser's Boots;Icewalker;None;None;Mobius Band;None;None;Ring of Invincibility;None;None;Mirror of Truth;None;None;Loatheb's Shadow;None;None;Accursed Bow of the Elite;Heartseeker Scope;None;None;Netherscale Ammo Pouch;Terrorshaft Arrow;


Offline
Old 03/02/09, 10:12 AM   #1774
Bokomatic
Von Kaiser
 
Bokomatic's Avatar
 
Troll Hunter
 
Азурегос (EU)
Yeah, I use "Export Gear String" and "Import Gear String".

Sorry, I thought that it's implemented by .bin file.
Anyways VB reports about "Error 9". It doesn't work in my system.
I have no idea why
May be it's my excel2007. But all other features work.

Offline
Old 03/02/09, 10:14 AM   #1775
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Bokomatic View Post
Yeah, I use "Export Gear String" and "Import Gear String".

Sorry, I thought that it's implemented by .bin file.
Anyways VB reports about "Error 9". It doesn't work in my system.
I have no idea why
May be it's my excel2007. But all other features work.
Most odd. Can you upload your sheet somewhere?

Made a small re-upload which fixes a few things (like damn excel always wanting to do partial matching instead of EXACT matches).

Last edited by Shandara : 03/02/09 at 10:34 AM.


Offline
Old 03/02/09, 12:00 PM   #1776
Bokomatic
Von Kaiser
 
Bokomatic's Avatar
 
Troll Hunter
 
Азурегос (EU)
I clicked "Debug" - debugger said error in the first string of following (If).
                        If Not Worksheets(sheet).Range(list).Find(bit, , , xlWhole) Is Nothing Then
                            ' Ok, the item matches the validation list for the cell so let's change the cell's contents
                            Cell.value = bit
                        Else
                            ' The item name didn't validate for this cell
                            MsgBox "Item " & bit & " is not a valid choice for your " & list & "."
                        End If
I changed nothing in downloaded spreadsheet.
I'd only opened it, pressed "Import Gear String" and got VB error.
I saved it in my Excel (now 2003), and upload here: Hunter_DPS_v85d.zip.
I hope it will be useful for solving problem.

P.S. Forgot to mention: Both of excel I use are localized (russified). However i have no problems with another features.

Last edited by Bokomatic : 03/02/09 at 12:10 PM.

Offline
Old 03/02/09, 12:09 PM   #1777
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Thanks for uploading. Strangely enough I downloaded it and tried to import the string and it worked!

This leads me to believe it is some sort of localization problem (I assume by your realm name you're playing in a non-English windows/excel?). I will investigate some more. Hopefully other people can try the import and see if it works for them.


Offline
Old 03/02/09, 1:14 PM   #1778
Bokomatic
Von Kaiser
 
Bokomatic's Avatar
 
Troll Hunter
 
Азурегос (EU)
I've debugged it ^^ kek
Russified XL translated name of "INDIRECT" function in russian, so next "If" didn't work.

Patch for russified XL:
If InStr(list, "INDIRECT") > 0 Or InStr(list, "ДВССЫЛ") > 0 Then
                            sheet = "Gems"
                            list = "GemStats"

Offline
Old 03/02/09, 1:36 PM   #1779
Sylvand
Piston Honda
 
Draenei Shaman
 
Spirestone
Originally Posted by Rezdan View Post
I haven't found any issues of items that aren't upgrades of the first slot (ring/1h,trinket) being overrated. It is sorted according to the first slot and was designed this way. Maybe what you'ld prefer is a separate Gear Planner thing for each ring/trinket/1H slot?

Here's the example given before:


As you can see, it is correctly sorted by the Delta of the First slot.
I'm not saying there's any bug in the implementation, and don't really see a need for a second list. It would just be nice I think for folks that happen to have their trinkets/rings/1H reversed so that they don't have to go in and swap them etc. Also in the case of dual wield it may make sense to have the items in the opposite sorting (i.e. better weapon in the MH) due to either the damage rating on the weapon itself, or one weapon being MH/OH only.

If it's a lot of trouble or there are other things to do and it doesn't get implemented, I'm sure it's fine. But if you're going to respond at least let me know why you think sorting by the max of delta 1 and delta 2 would not be better than sorting by only delta 1 always.

Offline
Old 03/02/09, 4:21 PM   #1780
baklava
Von Kaiser
 
Night Elf Hunter
 
Dunemaul (EU)
"Wild Hunt is being changed to 10/20% extra AP from the master. There was a bug where the talent was just applying the hunter's AP to the pet twice, which is too generous.

If you have 6000 attack power, your pet probably gains 1320 attack power from you. With 2 ranks of this talent, it should gain 1580 attack power instead. Your pet's attack power will be higher than this by a few hundred from other sources. "

World of Warcraft - English (NA) Forums -> 3.1 Hunter Patch Notes Confusion

Bad news for BM hunters... Probably u should change the things in Excel for BM now Shandara...

Offline
Old 03/02/09, 5:11 PM   #1781
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Small update:
- Wild Hunt now 10/20% extra AP
- Fixed INDIRECT referencing for non-english locale with the gear string import


Offline
Old 03/02/09, 8:08 PM   #1782
Tsook
chiefly comprised of water
 
Tsook's Avatar
 
Tsook
Troll Hunter
 
No WoW Account
The gem list is unsorted for prismatic gem slots regardless of the gem sort settings.

Incidentially, the Eternal Belt Buckle stacks with the engineering belt enchants, counter to how the sheet indicates it (but none of the engineering enchants add DPS, so it's a minor issue).

United States Offline
Old 03/02/09, 8:45 PM   #1783
Rezdan
Don Flamenco
 
Rezdan's Avatar
 
Dwarf Hunter
 
Nagrand
Originally Posted by Sylvand View Post
But if you're going to respond at least let me know why you think sorting by the max of delta 1 and delta 2 would not be better than sorting by only delta 1 always.
Well, in the example screenshot, sorting by the Max of Delta 1 and Delta 2 wouldn't change the sorting at all and in cases where one of the trinkets caps your hit, it would just end up sorting by best non-hit trinket. My main reason though is that it would just increase the complication and reduce the intuitiveness of the spreadsheet. As I stated earlier, maybe the best bet would be to have two diff gear planner selections for each trinket, or have a [Sort by 1st/2nd Trinket] button.

Offline
Old 03/02/09, 10:00 PM   #1784
Sylvand
Piston Honda
 
Draenei Shaman
 
Spirestone
Originally Posted by Rezdan View Post
Well, in the example screenshot, sorting by the Max of Delta 1 and Delta 2 wouldn't change the sorting at all and in cases where one of the trinkets caps your hit, it would just end up sorting by best non-hit trinket.
The max of delta 1 and delta 2 for the grim toll would be 0, so it would be sorted above incisor fragment.

Still, this is somewhat of a special case because the best +hit trinket is already equipped, so it's a moot point to talk about a +hit upgrade while being at or near hit cap.

However for the case where you have sphere of red dragon's blood in the second trinket, the only point upgrade for that slot might be grim toll. Depending on your first trinket, it might very well also be the best trinket upgrade for you, but because of the trinket ordering it shows up at the bottom, not to mention in some future patch with additional trinkets it might fall out of the top 10 all together.

Making a second planner would be fine, but I think sorting on max delta may be better, and it should be a much simpler change.

edit: This will be my last rant on the subject. I hope my point has got across and we can move on.

Offline
Old 03/03/09, 5:46 AM   #1785
baklava
Von Kaiser
 
Night Elf Hunter
 
Dunemaul (EU)
Shandara, Why does Resourcefulness increase the dps? We assume we use traps or it is about something else?

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Hunters

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Moonkin DPS Spreadsheet Efejel Druids 1925 11/04/08 2:34 PM
Hunter lvl 70 DPS spreadsheet Solaris Public Discussion 12 12/03/06 6:09 AM