[Balance] WrathCalcs - Page 38

♦ Tecton · 10/12/12, 5:18 PM

Originally Posted by Latas

I am trying to export my profile from the 121005 version.

Oh, yeah, the import/export functionality probably hasn't caught up. I'll check that out.

Stommped · 10/12/12, 8:34 PM

Well according to the hotfix changes Windsong can proc from dot damage. I guess I just hadn't noticed one during the small amount of testing I did.

♦ Tecton · 10/13/12, 4:39 AM

Ok, first bash at import/export. Remember, older versions won't work as they'll be exporting in the wrong format, this is for use from this version and forward. If I get time I'll see if I can do a conversion, but no promises!

Fixed a few random bugs too. Cogwheels in trinkets should be working again, hopefully some of the conditional formatting gremlins should be ironed out (although I haven't tested in older versions of Excel yet, feedback would be appreciated!).

Removed some unused sheets and named a couple of modules, just housekeeping stuff if anyone wonders why.

Lilija · 10/13/12, 11:35 AM

I've started getting a runtime error while trying to import from armory with this version (121013). I did not have this error with previous version.

Error 13 (type mismatch)
Line:

Set Char = GetBattleNetJSON(Range("K1").Value, Range("K2").Value, Range("AI39").Value)

♦ Tecton · 10/13/12, 12:12 PM

Originally Posted by Lilija

I've started getting a runtime error while trying to import from armory with this version (121013). I did not have this error with previous version.

Error 13 (type mismatch)
Line:

Set Char = GetBattleNetJSON(Range("K1").Value, Range("K2").Value, Range("AI39").Value)

Updated above, let me know if that sorts it.

Lilija · 10/13/12, 2:31 PM

That error is gone but I'm back to "the old" one:

Error 438 (Object doesn't support this property or method)
Line:

Range("G1") = Application.WorksheetFunction.VLookup(Char.race, Range("racelookup"), 2, False)

♦ Tecton · 10/13/12, 3:43 PM

Originally Posted by Lilija

That error is gone but I'm back to "the old" one:

Error 438 (Object doesn't support this property or method)
Line:

Range("G1") = Application.WorksheetFunction.VLookup(Char.race, Range("racelookup"), 2, False)

Ok, that error normally means it can't find your character on the armory, but it's working ok for me when I try to import your character.

Can you:

Try it again to make sure it wasn't just the armory throwing blank data (which has happened a couple of times to me this week).
Redownload it and try again.
Confirm Excel version and platform?

Thanks!

Lilija · 10/13/12, 4:19 PM

It works now - must have been armory.

Sunfyre · 10/14/12, 4:46 PM

I'm not getting Cogwheels to show up as valid gems for the Ghost Iron Dragonling.

♦ Tecton · 10/14/12, 6:43 PM

Originally Posted by Sunfyre

I'm not getting Cogwheels to show up as valid gems for the Ghost Iron Dragonling.

This should fix that, I think:

[edit] Can everyone please note that the Armory is giving a lot of 503 errors/out of date info tonight. Thanks! [/edit]

Slippykins · 10/15/12, 9:03 PM

Any chance of putting the Misty (Spirit/Crit) gems in? Namely Perfectly Misty Alexandrite and Misty Wild Jade?

♦ Tecton · 10/16/12, 4:17 AM

Originally Posted by Slippykins

Any chance of putting the Misty (Spirit/Crit) gems in? Namely Perfectly Misty Alexandrite and Misty Wild Jade?

Done!

Regarding the BiS list, has any conclusion been reached on if there is a source for Pearlescent Butterfly Wristbands at all (as they're a trash drop, which normally means the Heroic/LFR versions go unused). Might need to tweak that.

Slippykins · 10/16/12, 10:01 AM

Originally Posted by Tecton

Done!

Regarding the BiS list, has any conclusion been reached on if there is a source for Pearlescent Butterfly Wristbands at all (as they're a trash drop, which normally means the Heroic/LFR versions go unused). Might need to tweak that.

I'm looking at it, and since the heroic version is shown to be BoE, I get the feeling it doesn't exist, purely because trash wouldn't drop a heroic-quality item (even more so as a BoE), and the BMAH only lists BoP versions of items. I'll need to revise what other options exist for the bracers later today, little disappointed about that though.

• Hamlet · 10/16/12, 10:09 AM

IIRC--exactly the same thing has happened in other recent tiers--item DB shows heroic versions of trash drops that don't wind up appearing anywhere.

Slippykins · 10/16/12, 2:12 PM

I'm in the process of updating the BiS list on mmo-champ, but I've gone and added a post on the balance discussion thread about stat weights and optimisation, as it's probably best to discuss it in there, rather than the WrathCalcs thread. :p

Edit: and yeah Hamlet, I remember the same issue with the VP cloak in DS, where there were RF/heroic versions in the database but no such items were attainable in-game. Rather disappointing, but we've got a similar situation this tier.