Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Druids

Reply
 
LinkBack Thread Tools
Old 08/13/11, 12:56 PM   #271
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Yup, that's already been changed.

Scotland Offline
Reply With Quote
Old 08/16/11, 4:22 PM   #272
Erdluf
Great Tiger
 
Night Elf Druid
 
Echo Isles
WC is slightly optimistic on its GCD and GCDNG values. It averages in haste values that are over 50% (such as during Bloodlust). The error is small (about 55 DPS on the 110812 download), but will cause haste scaling to be a bit off for better gear (Legendary will have very high NG uptime).

I'm attaching a fix. New/changed formulas are highlighted in light gray (2 cells on Basic Calcs tab, a few new columns on the Haste tab).

This is based on the 110812.xls download, and the name reflects that.

Treecalcs probably has the same error, but Haste is so terrible outside the breakpoints that it probably matters even less.
Attached Files
File Type: xls WrathCalcs 110812 GCD fix.xls (1,004.0 KB, 77 views)

United States Offline
Reply With Quote
Old 08/16/11, 5:37 PM   #273
Lauriel002009
Glass Joe
 
Troll Druid
 
Die Todeskrallen (EU)
Originally Posted by Tecton View Post
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.
Update: I have a German Vista 64-bit, but a German Excel 2003 (I assume 32-bit due to the software info; 64-bit is not mentioned there). But I still get the same error code. Any idea? I wrote "Die Todeskrallen" in the realm field (that's the german name for the server).

Austria Offline
Reply With Quote
Old 08/16/11, 6:47 PM   #274
Latas
Don Flamenco
 
Night Elf Druid
 
Uther
Is there any easy way to make the text more readable without screwing up the cells? Ever since the battle.net import feature the text has been very hard to read.

Offline
Reply With Quote
Old 08/16/11, 10:17 PM   #275
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Originally Posted by Erdluf View Post
WC is slightly optimistic on its GCD and GCDNG values. It averages in haste values that are over 50% (such as during Bloodlust). The error is small (about 55 DPS on the 110812 download), but will cause haste scaling to be a bit off for better gear (Legendary will have very high NG uptime).

I'm attaching a fix. New/changed formulas are highlighted in light gray (2 cells on Basic Calcs tab, a few new columns on the Haste tab).

This is based on the 110812.xls download, and the name reflects that.

Treecalcs probably has the same error, but Haste is so terrible outside the breakpoints that it probably matters even less.
This works. It's even more computation-intensive for a small fix, but I haven't worried about that too much yet; it probably doesn't matter on most people's computers. If I really cared about making the scaling factors compute faster I could probably remove a bunch of tables for really irrelevant things.

Originally Posted by Latas View Post
Is there any easy way to make the text more readable without screwing up the cells? Ever since the battle.net import feature the text has been very hard to read.
I think Tecton just likes to save it with the zoom at 70%; check your zoom.

----------

Here's a version with a really simple Dragonwrath model. Just multiplies damage of all spells up by the proc rate, and also all energy gains. If it works the way people say above, that should actually be pretty solid except for a couple details. I have no idea what the proc rate is so I arbitrarily put in 5% for now. This makes it worth about 5.5% DPS due to increased NG uptime, which should give an idea of how it will work whenever we find out the real proc rate.
Attached Files
File Type: xls WrathCalcs 110816.xls (955.5 KB, 196 views)


United States Offline
Reply With Quote
Old 08/17/11, 2:17 AM   #276
Stommped
Piston Honda
 
Troll Druid
 
Magtheridon
Originally Posted by Hamlet View Post
Necromantic Focus mastery needs to be adjusted. Normal is 39/stack, not sure about Heroic.
This isn't in the game yet? Or is the tooltip on the item/buff just not showing correctly?

Offline
Reply With Quote
Old 08/17/11, 3:42 AM   #277
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Yeah, the tooltip is wrong. Use it at a dummy and watch your mastery.


United States Offline
Reply With Quote
Old 08/17/11, 8:54 AM   #278
thedopefishlives
Don Flamenco
 
Dwarf Paladin
 
Baelgun
Originally Posted by Hamlet View Post
This works. It's even more computation-intensive for a small fix, but I haven't worried about that too much yet; it probably doesn't matter on most people's computers. If I really cared about making the scaling factors compute faster I could probably remove a bunch of tables for really irrelevant things.



I think Tecton just likes to save it with the zoom at 70%; check your zoom.

----------

Here's a version with a really simple Dragonwrath model. Just multiplies damage of all spells up by the proc rate, and also all energy gains. If it works the way people say above, that should actually be pretty solid except for a couple details. I have no idea what the proc rate is so I arbitrarily put in 5% for now. This makes it worth about 5.5% DPS due to increased NG uptime, which should give an idea of how it will work whenever we find out the real proc rate.
The current estimated proc rate for Moonkin is 11%. There has also been some speculation on the Rawr team that Dragonwrath has a different proc rate per spell. It'd be nice to get ahold of a few combat logs with the staff to find out.

United States Offline
Reply With Quote
Old 08/17/11, 10:25 AM   #279
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Originally Posted by Lauriel002009
Update: I have a German Vista 64-bit, but a German Excel 2003 (I assume 32-bit due to the software info; 64-bit is not mentioned there). But I still get the same error code. Any idea? I wrote "Die Todeskrallen" in the realm field (that's the german name for the server).
Yeah, that appears to be the same issue (64 bit versions of Windows prior to Windows 7 are extremely poorly supported). Apologies, but I'm unaware of anything I could do to get around that.

Originally Posted by Latas
Is there any easy way to make the text more readable without screwing up the cells? Ever since the battle.net import feature the text has been very hard to read.
As Hamlet says, this is my fault. I zoom it out while working on some of the hidden columns and keep forgetting to fix it back to 100% before uploading. Amending the zoom level will sort it, and I'll do my best not to forget!

Originally Posted by thedopefishlives
The current estimated proc rate for Moonkin is 11%. There has also been some speculation on the Rawr team that Dragonwrath has a different proc rate per spell. It'd be nice to get ahold of a few combat logs with the staff to find out.
That's going to be a quite astonishing amount of DPS then, from doing a quick edit. In the roughly BiS profile I have saved in the sheet, you're looking at ~5.3k DPS from the proc alone? How confident are we in these figures?

Scotland Offline
Reply With Quote
Old 08/17/11, 10:34 AM   #280
Lauriel002009
Glass Joe
 
Troll Druid
 
Die Todeskrallen (EU)
Ok thanks. At this point I just want to say, that it seems to be that 64-bit systems are the future. So I think you reflect about this to solve this problem eventually. e.g. I have a notebook too, with Win7, but it's also a 64-bit system.

Austria Offline
Reply With Quote
Old 08/17/11, 11:19 AM   #281
thedopefishlives
Don Flamenco
 
Dwarf Paladin
 
Baelgun
Originally Posted by Tecton View Post
That's going to be a quite astonishing amount of DPS then, from doing a quick edit. In the roughly BiS profile I have saved in the sheet, you're looking at ~5.3k DPS from the proc alone? How confident are we in these figures?
I'm not 100% sure. This info came from Hinalover, who gleaned it from the Mage and Moonkin threads in the official forums. He said the initial proc rates were estimated at 10% for mages and 11% for moonkin.

United States Offline
Reply With Quote
Old 08/19/11, 5:19 PM   #282
Erdluf
Great Tiger
 
Night Elf Druid
 
Echo Isles
TLDR: Discussion about how WC computes some rotation numbers.

Rotation page, Nukes cast per phase. I think the right equation is

NumberOfNukeCasts = EnergyGeneratedDuringPhase / EnergyPerNukeCast

For eclipse phases, WC uses

EnergyGeneratedDuringPhase = 100 + NukeEnergy/2

which says that on average, you'll go about a half-nuke past zero when leaving Eclipse. That seems reasonable. Perhaps a bit pessimistic.

For pre-eclipse phases, WC uses (ignoring gory Euphoria details):

EnergyGeneratedDuringPhase = 100 - NukeEnergy/2

the idea being you get to use that extra energy from the eclipse phase to help reach the next eclipse. That is true, but it is also true that you'll end up wasting about half of your last nuke. 4t12 means that you actually end up wasting half of a bigger energy amount. I think this should be changed to something closer to

EnergyGeneratedDuringPhase = 100 # Possibly add 4t12Energy / 2

WC uses:

EnergyPerNukeCast = EnergyFromNuke / (1 - StarsurgeEnergyRate / NukeSpamEnergyRate)

which has the right general form of giving fewer nuke casts when you get more SS energy. However I think it has some problems (for instance if I had a glyph that caused Wrath to generate only 1 energy, this formula would give a negative number). I think the correct formula is along the lines of

EnergyPerNukeCast = EnergyFromNuke * (1 + StarsurgeEnergyRate / (NukeSpamEnergyRate * NukeUptimeRatio))

Using NukeUptimeRatio might cause a circular dependency, in which case just pick a reasonable number around 0.7s.
Even this is a bit optimistic, because it ignores the fact that most Moonkin would rather not enter Eclipse with the energy from a StarSurge.

Current WC, using the Legendary with a 11% proc rate says there are ~2.5 Starfires cast during pre-solar. To get an average that low with a discrete simulator, you'd need a rotation along the lines of (SF SS)* and that just isn't going to happen. A more reasonable average number is about 3 SF casts, and I think my suggested changes get you closer.

United States Offline
Reply With Quote
Old 08/22/11, 5:01 PM   #283
Zephn
Glass Joe
 
Troll Druid
 
Laughing Skull
I read through the pages and wanted to make sure it wasn't something that somebody had already brought up, but it appears that the first and second versions of the legendary staff (being branch of nordrassil, and runestaff of nordrassil, respectively) are showing as having crit in wrathcalcs, when they actually have haste instead of crit.

EDIT: My mistake, someone did point this out for the branch. However, it is also this way with the runestaff of nordrassil, it could just be like this for the main page version of WC though. I'm an OO user so I haven't picked up the latest version from this particular thread.

Last edited by Zephn : 08/22/11 at 5:06 PM.

United States Offline
Reply With Quote
Old 08/24/11, 6:22 PM   #284
Erdluf
Great Tiger
 
Night Elf Druid
 
Echo Isles
E&M tooltip (and WC "Basic Calcs") says the personal bonus is 2%. I seem to be getting 4%, unless I'm missing another buff someplace.

Resto spec 7308 SP: IS ticks for 1086. Thorns (self or NPC) hit for 1407.

Balance spec 7308 SP:
Thorns on NPC hit for 1548 (1407*110% from Moonfury)
Thorns on self (caster form) hit for 1610 (1548*104% E&M ???)
Thorns on self (Moonkin form) hit for 1841 (1610*110%*104% (MkF and MSS))
Add OF and they hit for 2026 (1841*110%)

Insect Swarm follows a similar progression:
Resto: 1086
Balance Caster: 1582 (1086*140%*104% (Moonfury+Glyph)*(E&M???))
Moonkin: 1810 (1582*110%*104% (MkF+MSS))

I haven't tried speccing without E&M to see if it is really 4%.

Edit:
Originally Posted by Hamlet
Forgot Balance of Power.

Last edited by Erdluf : 08/25/11 at 4:18 PM.

United States Offline
Reply With Quote
Old 08/24/11, 10:29 PM   #285
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Forgot Balance of Power.


United States Offline
Reply With Quote
Reply

Go Back   Elitist Jerks » Class Mechanics » Druids

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Balance] Theorycraft / Spreadsheet Thread (WrathCalcs) Hamlet Druids 0 06/30/10 7:36 PM
TreeCalcs: WrathCalcs, respecced Hamlet Druids 42 02/04/10 3:31 PM
WrathCalcs - Moonkin DPS Spreadsheet Adoriele Druids 93 06/09/09 6:37 PM