- 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.
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;
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
' The item name didn't validate for this cell
MsgBox "Item " & bit & " is not a valid choice for your " & list & "."
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.
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.
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.
"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. "
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.
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.