Not how WC handles trinkets regarding uptime and usage, but similarly to Silveria's posting, have you modified Heart of Ignacious due to its slower stack rate?

The version I put up just now discounts HoI spellpower slightly; it gives it 5 seconds downtime every 2m. It should be in the main version soon.

Two dots up and chain casting Wrath (best case scenario) HoI takes about 10 seconds to fully stack.

Right, I checked and seems to be a 2s ICD. So 10s to stack (really 8 I suppose, but the proc times aren't perfect), or equlvalent to 5s downtime.

I am having an issue and I am not sure if its something I am doing wrong in the game or something I am doing wrong in WC. If I put my gear and spec in and hit F9, WC says I should be pulling 20k to 23k dps (depends on Training Dummy Mode).

In game I can pull 12k - 13k on the training dummy and 14k - 15k in raid, and I want to know if there are any settings that would cause an 8k difference between the two, or if I really need to rework how I play.

**EDIT**
I misunderstood what the Bloodlust Option did on the second page. Turning that off subtracts about 5.6k DPS, and puts the guessed overall DPS within 1.5k of what I am seeing, which I feel much more comfortable as a "Margin of Error" (aka lack of skill)

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?

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.

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.

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.

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

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.

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.

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:
and this will return how much mastery you would need to get to the next soft cap:
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.

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.

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)?

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.

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.

Wait, those aren't off the last one I posted--they don't have the haste tab. In fact, they're from before the Moonfury nerf :/ .

Renamed the wrong file, I'll put it back up shortly.

Ok, cool. And in general, when you say you've have an OO version--is this the big OO fix (i.e. the fix to the main version that lets me make a working OO version just by deleting tables and selecting OOMode)? Or are you still fixing something by hand to get it to work in OO each time (you can probably just tell me what it is)?

Sorry for the delay, I should have totally fixed the OO stuff now. At least, it's working for me. You should be able to just change the option and delete tables now. If you'd prefer to just keep it all as one version, we could put a conditional on the table values that show up on OpenOffice to hide them. Would save you editing them out all the time, I don't believe they cause any issues other than file size?

As above, you can now export and import profiles. Make sure you select a new profile/rename if you don't want to overwrite the existing profiles before you click export/import.

Would that work? I though the normal version of the sheet broke in OO because the tables are there are all. If all they do is throw an error that can be hidden by the OO mode option, that would be nicer. Could just move the OO option to the front page then, and have only one version.