WotLK DPS spreadsheet - Page 119

Shandara · 03/02/09, 8:31 AM

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.

Bokomatic · 03/02/09, 9:44 AM

Originally Posted by Shandara

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

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.

Shandara · 03/02/09, 9:56 AM

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;

Bokomatic · 03/02/09, 10:12 AM

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.

Shandara · 03/02/09, 10:14 AM

Originally Posted by Bokomatic

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

Bokomatic · 03/02/09, 12:00 PM

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.

Shandara · 03/02/09, 12:09 PM

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.

Bokomatic · 03/02/09, 1:14 PM

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"

Sylvand · 03/02/09, 1:36 PM

Originally Posted by Rezdan

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.

baklava · 03/02/09, 4:21 PM

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

Shandara · 03/02/09, 5:11 PM

Small update:

- Wild Hunt now 10/20% extra AP
- Fixed INDIRECT referencing for non-english locale with the gear string import

Tsook · 03/02/09, 8:08 PM

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

Rezdan · 03/02/09, 8:45 PM

Originally Posted by Sylvand

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.

Sylvand · 03/02/09, 10:00 PM

Originally Posted by Rezdan

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.

baklava · 03/03/09, 5:46 AM

Shandara, Why does Resourcefulness increase the dps? We assume we use traps or it is about something else?