[Balance] WrathCalcs - Page 8

Derinim · 02/09/11, 9:31 PM

There is something I want to understand. When i put spirit instead of hit in the wrathcalcs hit seems to overtake spirit while Spirit = Hit in term of chance to hit.

The way I understand is more spirit = more time to be OOM. And the dps seems to be my total damage divided by my total time in combat which is the time to be OOM. Problem is : To calculate correctly, i would have to set a fixed combat duration.

Is there a way to do that?

aceofsween · 02/09/11, 11:09 PM

Originally Posted by Derinim

The way I understand is more spirit = more time to be OOM.

This statement is false. Mana Regen is split into Combat Regen and Non-Combat Regen. Only healers (Specs with the Meditation specialization) get Combat Regen from Spirit. ALL other specs get a base Combat Regen of 900-some odd.

Calmwind · 02/10/11, 1:03 AM

Just stopping buy to update, not that most wouldn't find this themselves: The 110208 version for OpenOffice has no issues of 502 errors anywhere. I was able to change the gear, regem, reforge all without issue. As far as where the 502 errors are showing up in the NON-OO version its nearly everywhere, on each piece of gear on the first page column C has 502 in nearly every piece or gears stat locations, also in most gem or reforge boxes.
In short, the newest "OO" version seems to be without issue and the non-OO version is not usable by anyone with OO. Sorry for the confusion if there was any. Thanks for the spreadsheets.

• Hamlet · 02/10/11, 1:40 AM

Tested Thorns, it's not affected by any of your personal buffs when you cast it on another person (not even Moonfury). So really you need around 15 procs from a cast to make it worthwhile.

Reminder to self to change Thorns to only be affected by raid damage buffs when I get next sheet version.

Berthold · 02/10/11, 4:41 AM

Originally Posted by Irvqwa

In game I can pull 12k - 13k on the training dummy

Is your starfall hitting the dummy? mine do not right now (dummy has no aggro table) and that's another big chunk of damage lost.

Derinim · 02/10/11, 7:54 PM

Originally Posted by aceofsween

Originally Posted by Derinim

There is something I want to understand. When i put spirit instead of hit in the wrathcalcs hit seems to overtake spirit while Spirit = Hit in term of chance to hit.

The way I understand is more spirit = more time to be OOM. And the dps seems to be my total damage divided by my total time in combat which is the time to be OOM. Problem is : To calculate correctly, i would have to set a fixed combat duration.

Is there a way to do that?

This statement is false. Mana Regen is split into Combat Regen and Non-Combat Regen. Only healers (Specs with the Meditation specialization) get Combat Regen from Spirit. ALL other specs get a base Combat Regen of 900-some odd.

Then why does spirit affect my dps differently from hit rating?

• Hamlet · 02/10/11, 7:55 PM

We still haven't figured out exactly how the Treants' hit chance works. Right now the sheet is giving a small advantage to hit rating because of how it models them.

• Hamlet · 02/11/11, 12:52 AM

Fixed Thorns, reverted Starfall, couple other minor things.

• Hamlet · 02/11/11, 10:39 PM

Today's posted nerf (not live yet). Due to my poor coding habits, all the "1.15"'s were hardcoded, but I think I found them all.

I also turned down the NG uptime for Moonfire when you have GoSF equipped, based on Starfox's findings in the other thread. 50% is kind of a guess for now, but I figure the Lunar Moonfire spends most of its time without NG since you're forced to refresh on the way over, and the Solar Sunfire spends most of its time with NG for the opposite reason.

Irvqwa · 02/14/11, 1:44 PM

I did some quick and dirty formulas for the Mastery breakpoints (assuming the breakpoint is at each 1% or 89.64 rating)

I am not sure if you need to, but I put these on the Main Worksheet, I'm not sure if the variables will hop sheets

This will return the percentage of your current eclipse proc:

=Round(Mastery/89.64) + 41

and this will return how much mastery you would need to get to the next soft cap:

=89.64 - Mod(Mastery/89.64)

This works for my current gear setup because I don't have any mastery procs, but since the spreadsheet handles them as an average vs. uptime I know that would break the above formulas, I just don't know how to handle that.

• Hamlet · 02/14/11, 1:47 PM

Yeah. Not only that, but scaling factors would become much messier to handle if it were rounded (although I guess I could compute the scaling for 1% mastery and divide by 89.6). All in all I'm not I'm sure if it's a big enough issue to worry about. Very advanced players can see how close they are to a breakpoint every time the modify their setup and simply reforge one piece if necessary.

Palé · 02/17/11, 8:47 PM

Issues with Open Office still, getting Err:502 almost everywhere. Is there a way to get wrathcalcs to work on mac(microsoft office for mac doesn't use macros so OO is only software)?

• Hamlet · 02/17/11, 10:00 PM

It should work in Excel for Mac. None of the main functionality uses macros, just profiles and some other miscellaneous things. I think Tecton posted a working OO version as well, a bit up in this thread, I may have forgotten to put it in the OP.

• Hamlet · 02/21/11, 6:52 PM

First attempt at full handling of temporary haste. This is adapted from a sheet that Erdluf posted a few weeks ago. Look at the new "Haste" tab to see how it works.

There should no longer be any weird bumps in the value of haste at the wrong places, or unusual benefits from proc trinkets and the like. It will lead to even longer computation time for the data tables, but that's probably not a big deal at this point.

If it all seems to be working fine I'll probably put it on the main page soon.

♦ Tecton · 02/22/11, 12:05 PM

I didn't notice any great increase in calculation time, that's a solid addition. I've added import/export buttons for profiles. This should allow you to transfer profiles between any future version of the worksheet (export from the old version and either create a new profile or overwrite an existing profile in the same way saving currently works). It does use your clipboard, as an FYI.

Obviously: this won't work for OO, but I've attached a version that should I think should work for OO (I'll double check this when I get home in an hour or so) so people using it can use the new additions. I have a very rare night off tonight, so if there are any issues with this, flag them up and I'll get onto them ASAP.

Edit, will fix shortly.