[Balance] WrathCalcs - Page 18

♦ Tecton · 08/08/11, 3:39 AM

I think I have a solution for it, I'll upload a fix later today. I'm working on UTF-8 encoding to catch some of the more unusual character names too.

As far as 64 bit versions of Excel being unable to use the battle.net query, I'm afraid that's not going to be avoidable unless anyone can recommend a different way of getting the info. Microsoft haven't translated the function I use here over to their 64 bit version yet, sorry!

♦ Tecton · 08/08/11, 5:35 AM

Ok, new version:

took a stab at the UTF encoding. If anyone has some weird character in their name that's still breaking things, let me know.
had a quick sweep over the gear list, fixed the name on Mindweb Staff/Lightwing Cloak to Funeral Pyre/Wings of Flame respectively. Also removed some heroic items that aren't available in-game.
changed some of the profile code, hopefully it translates properly to other languages this way. Let me know if any of them are still coming over incorrectly, obviously I can't test this myself.

If these changes work I'll get Treecalcs updated shortly too, didn't want to fix big things like that in two places at once.

Ishvan · 08/08/11, 10:43 AM

I am still getting bugs in OpenOffice where when I got to reforge or gem instead of the appropriate stats I just see "ERR: 502" and when I go to check my stat weights I see "ERR: 522".

LordAnxiety · 08/08/11, 11:18 AM

Wonderful Tecton. I love your hard fast good work, so very very much.

Translation of booleans work now.
One thing I found. Boolean for Astral Leather (Main!K23) is still not translated. In "Profiles" sheet to.

The UTF changes are working good. Tested only with �* .

Thanks for that work.

♦ Tecton · 08/08/11, 11:42 AM

Originally Posted by Ishvan

I am still getting bugs in OpenOffice where when I got to reforge or gem instead of the appropriate stats I just see "ERR: 502" and when I go to check my stat weights I see "ERR: 522".

Was this in OpenOffice?

I'll get the Astral Leather fix in the next build, for now if you guys can just reselect it from the menus.

Akutsito · 08/08/11, 4:42 PM

Importing from the Armory on Office 2011 (Mac Version) i get Runtime Error 13.

♦ Tecton · 08/08/11, 5:07 PM

Yeah, Macs don't play nice with macros, so you won't be able to use it.

Akutsito · 08/09/11, 3:22 PM

Just for the record, the rest works just fine, so at least we have the chance to input stuff manually.

markos82 · 08/11/11, 10:57 AM

I'm having a problem with Stump of time trinket, there is nothing to select when I wanna change reforge stats on him..

♦ Tecton · 08/11/11, 1:05 PM

Originally Posted by markos82

I'm having a problem with Stump of time trinket, there is nothing to select when I wanna change reforge stats on him..

Will put up a version correcting this tonight, thanks for the report.

♦ Tecton · 08/11/11, 5:44 PM

Originally Posted by markos82

I'm having a problem with Stump of time trinket, there is nothing to select when I wanna change reforge stats on him..

Originally Posted by LordAnxiety

Boolean for Astral Leather (Main!K23) is still not translated. In "Profiles" sheet to.

Both issues should be fixed, and I've updated Necromantic Focus with the amended stats. Also removed the heroic versions of the VP rings and fixed the normal version's names.

♦ Tecton · 08/12/11, 8:10 AM

Small update:

Stats on Dragonwrath, Tarecgosa's Wrath updated. What was on the item databases a couple of weeks back was incorrect.
Small fix to enchant importing too.

Lauriel002009 · 08/12/11, 10:18 PM

Hi there!

WrathCalc is a really mighty tool, lots of thanks for it! I didn't used it for some weeks and now I downloaded the newest version and tried to import my current character from armory, because lots of things have changed due to 4.2.

I have a German Vista 64-bit and a German Microsoft Excel 2003. When I click on the button, unfortunately I get a runtime error 380 (A script engine for the specified language can not be created.) and I can only debug or close it. Do ya have any idea what can I do?

Kindly regards,
Lauriel

♦ Tecton · 08/13/11, 5:50 AM

Unfortunately Microsoft haven't ported all of the functions to 64 bit Excel, I'm afraid unless anyone knows a different method of grabbing the information from battle.net I can't work around that.

• Hamlet · 08/13/11, 9:24 AM

Necromantic Focus mastery needs to be adjusted. Normal is 39/stack, not sure about Heroic.