 |
02/09/11, 3:18 PM
|
#101
|
|
Glass Joe
Tauren Druid
Lightbringer
|
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?
|
|
|
|
|
02/09/11, 3:31 PM
|
#102
|
|
<Druid Trainer> Emeritus
|
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.
|
|
|
|
02/09/11, 3:37 PM
|
#103
|
|
Don Flamenco
|
Originally Posted by Hamlet
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.
|
|
|
|
02/09/11, 4:04 PM
|
#104
|
|
<Druid Trainer> Emeritus
|
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.
|
|
|
|
02/09/11, 4:42 PM
|
#105
|
|
Glass Joe
|
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)
Last edited by Irvqwa : 02/09/11 at 5:03 PM.
|
|
|
|
|
02/09/11, 9:31 PM
|
#106
|
|
Glass Joe
Undead Rogue
Lightninghoof
|
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?
|
|
|
|
|
02/09/11, 11:09 PM
|
#107
|
|
Don Flamenco
Troll Druid
Lightning's Blade
|
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.
|
|
|
|
|
02/10/11, 1:03 AM
|
#108
|
|
Glass Joe
|
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.
|
|
|
|
|
02/10/11, 1:40 AM
|
#109
|
|
<Druid Trainer> Emeritus
|
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.
|
|
|
|
02/10/11, 4:41 AM
|
#110
|
|
Piston Honda
Worgen Druid
Madmortem (EU)
|
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.
|
|
|
|
02/10/11, 7:54 PM
|
#111
|
|
Glass Joe
Undead Rogue
Lightninghoof
|
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?
|
|
|
|
|
02/10/11, 7:55 PM
|
#112
|
|
<Druid Trainer> Emeritus
|
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.
|
|
|
|
02/11/11, 12:52 AM
|
#113
|
|
<Druid Trainer> Emeritus
|
Fixed Thorns, reverted Starfall, couple other minor things.
|
|
|
|
02/11/11, 10:39 PM
|
#114
|
|
<Druid Trainer> Emeritus
|
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.
Last edited by Hamlet : 02/11/11 at 10:46 PM.
|
|
|
|
02/14/11, 1:44 PM
|
#115
|
|
Glass Joe
|
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.
|
|
|
|
|
02/14/11, 1:47 PM
|
#116
|
|
<Druid Trainer> Emeritus
|
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.
|
|
|
|
02/17/11, 8:47 PM
|
#117
|
|
Glass Joe
Tauren Druid
Trollbane (EU)
|
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)?
|
|
|
|
|
02/17/11, 10:00 PM
|
#118
|
|
<Druid Trainer> Emeritus
|
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.
|
|
|
|
02/21/11, 6:52 PM
|
#119
|
|
<Druid Trainer> Emeritus
|
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.
|
|
|
|
02/22/11, 12:05 PM
|
#120
|
|
Achievement Unlocked!
Worgen Druid
Argent Dawn (EU)
|
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.
Last edited by Tecton : 02/22/11 at 1:13 PM.
|
|
|
|
|
02/22/11, 1:10 PM
|
#121
|
|
<Druid Trainer> Emeritus
|
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 :/ .
|
|
|
|
02/22/11, 1:13 PM
|
#122
|
|
Achievement Unlocked!
Worgen Druid
Argent Dawn (EU)
|
Renamed the wrong file, I'll put it back up shortly.
|
|
|
|
|
02/22/11, 1:15 PM
|
#123
|
|
<Druid Trainer> Emeritus
|
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)?
|
|
|
|
02/22/11, 5:59 PM
|
#124
|
|
Achievement Unlocked!
Worgen Druid
Argent Dawn (EU)
|
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.
|
|
|
|
|
02/22/11, 6:20 PM
|
#125
|
|
<Druid Trainer> Emeritus
|
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.
|
|
|
|
|