[Balance] WrathCalcs - Page 14

Stommped · 06/21/11, 9:00 PM

A minor error with the spreadsheet, but appears the Leatherworking Bracer Enchant (130 int) is not included in the spreadsheet, even after selecting it as a profession.

♦ Tecton · 06/23/11, 6:54 PM

Originally Posted by Stommped

A minor error with the spreadsheet, but appears the Leatherworking Bracer Enchant (130 int) is not included in the spreadsheet, even after selecting it as a profession.

Just checked, it's in there in every version I can see going back for some time. You probably need to scroll up.

fountaiin · 06/24/11, 3:25 AM

So I've been using WC for a while now, but I've never taken the time to ask.

A) Is there a way to prevent the distortion of stats when I change a buff, for example DI to 'No' makes all my numbers go into the -3000s.

B) Are profiles/armory actually loadable? I've always just changed the items one by one because Load gives me an error (I'm probably using a wrong version: Excel 07 free DL :p). Whenever I change an item here it distorts the stats too.

Thanks in advanced. Sorry for the goofy questions.

♦ Tecton · 06/24/11, 4:21 AM

As far as the stats question, that's because we disable automatic calculation to avoid the tables recalcing every time you change any option at all. If you hit F9, it'll recalc all of the data tables and give you the figures you need (as noted on the main sheet). Data tables can take a long time to run, which is why we do this.

Profiles are working fine for me on several version on Excel, can you give me the error you're receiving (and have you enabled macros?).

• Hamlet · 06/27/11, 6:52 PM

Here's what I have right now, don't actually remember if anything changed. Make any changes you need to and I'll move it to the OP during patch time tomorrow.

♦ Tecton · 06/28/11, 12:34 PM

OpenOffice should be working now, let me know if there are any issues with the fix.

I've updated the profiles function for the layout changes, I'm fairly sure that I got all of them. If anyone spots anything not copying over properly, please PM me!

[edit] Spotted a bug, updating! [/edit]

[edit2] Hmm, I've got the Gear Setup sheet working fine in OpenOffice, but there's been something introduced elsewhere that it's not liking. I'm trying to track it down now. [/edit2]

[edit3] Ok, tracked down the NEW problem and fixed it. Apparently OpenOffice doesn't like the way Excel fills in TRUE/FALSE via macro. Updated version attached. [/edit]

♦ Tecton · 06/29/11, 7:33 PM

Moonwhisper, can you check if this is working for you:

Moonwhisper · 06/30/11, 5:04 AM

Hi Tecton:
I tested the sheet now with my gear and it is working.
The broken dps/damage calculations are ok now. I didnt find any further errors.
Thanks!

• Hamlet · 07/04/11, 1:36 AM

Was there a bug fix here that I should update to the main sheet?

♦ Tecton · 07/04/11, 2:39 AM

A small OO fix, couldn't hurt to copy it over.

Moonwhisper · 07/07/11, 1:42 PM

I found a small bug in the gear stats of a belt item:
gale rouser belt of the undertow (normal) is wrong, it shows the same value as the heroic version.

♦ Tecton · 07/07/11, 2:09 PM

Nice catch, I'll fix that in the next update. If you need to fix it now, go to 'Gear List', Row 521 and change "galerouserbeltheroic" to "galerouserbelt" in each of the stat cells.

• Hamlet · 07/08/11, 5:36 AM

WC on the main thread with the above OO fix, Gale Rouser fix, the Flickering items listed in TreeCalcs thread, and Wild Mushroom change.

Alexsiss · 07/08/11, 12:04 PM

I seem to be having an issue in the newest version(7/7) of Wrathcalcs. When I import gear from a previous version(6/28) I seem to be gaining hit rating magically. The 6/28 version seems to be accurate with both in game and armory tool tips so I am thinking it is a bug with the newest version. I looked briefly but couldn't find the issue but I will spend some more time looking later. I can also pm you my 2 copies of the sheet if you would like.

So I finally found the issue. Seem that when you import gearsets with random enchants it defaults them to of Flameblaze rather than preserving the random enchant name from before. I had a ring of Feverflare that this happened to. Hence the gain of hit.

♦ Tecton · 07/09/11, 6:30 PM

Originally Posted by Hamlet

That's an option that has to commented better in WC. Right now it assumes you cast exactly one Starfall every Lunar Eclipse. You should really only use it if you're using Glyph of Starsurge in a normal-length cycle. The main reason it exists is to help evaluate Glyph of Starsurge.

From the other thread:

Do you want me to remove it from the dropdown unless GoSS is selected?