[Balance] WrathCalcs - Page 27

• Hamlet · 01/03/12, 8:50 PM

New Starsurge bonus.

♦ Tecton · 01/10/12, 3:40 AM

Small fix for belt gems when importing from battle.net:

nasapunk88 · 01/18/12, 7:34 PM

Hey Tecton thank you for keeping wratchcalcs up to date. I read that a lot are having issues on 64bit and thought I'd post a simple fix for you to add into the future updates. This allows me to use your WratchCalcs on 64bit, I do not have a 32bit computer to double check that it doesn't affect it in any way; it shouldn't though.

Open program in debugger and inside Module4 on the top, replace the Private Declare Function WideCharToMultiByte with:

#If Win64 Then
    Private Declare PtrSafe Function WideCharToMultiByte Lib "Kernel32" (ByVal CodePage As LongLong, ByVal dwflags As LongLong, ByVal lpWideCharStr As LongLong, ByVal cchWideChar As LongLong, ByVal lpMultiByteStr As LongLong, ByVal cchMultiByte As LongLong, ByVal lpDefaultChar As LongLong, ByVal lpUsedDefaultChar As LongLong) As Long
#Else
    Private Declare Function WideCharToMultiByte Lib "Kernel32" (ByVal CodePage As Long, ByVal dwflags As Long, ByVal lpWideCharStr As LongPtr, ByVal cchWideChar As Long, ByVal lpMultiByteStr As LongPtr, ByVal cchMultiByte As Long, ByVal lpDefaultChar As Long, ByVal lpUsedDefaultChar As Long) As Long
#End If

I'm still working on trying to get Import from Battle.net working. It used to work for me however now it is broken. Does this feature work for 32bit office?

♦ Tecton · 01/18/12, 7:39 PM

It's just 64 bit Excel that's the problem, not 64 bit computers. If you can find a working solution that doesn't need 32 bit users to install addins, I'm all ears, I don't have much available time for the project currently.

nasapunk88 · 01/18/12, 8:08 PM

Originally Posted by Tecton

It's just 64 bit Excel that's the problem, not 64 bit computers. If you can find a working solution that doesn't need 32 bit users to install addins, I'm all ears, I don't have much available time for the project currently.

there are no addins needed to be installed to incorporate the code I posted. Just hit Alt F11 when you have the workbook open to go into editor mode, change the line of code and save. =)

Tagartou · 01/18/12, 11:40 PM

Has Rathrak's proc been implemented yet?

♦ Tecton · 01/19/12, 2:13 AM

Originally Posted by nasapunk88

there are no addins needed to be installed to incorporate the code I posted. Just hit Alt F11 when you have the workbook open to go into editor mode, change the line of code and save. =)

Yeah, I'm talking about armory import. I posted the workaround for 64 bit users a while ago.

Originally Posted by Tagartou

Has Rathrak's proc been implemented yet?

Nope.

♦ Tecton · 01/26/12, 7:31 AM

Ok, I made a stab at implementing Rathrak since there have been tons of requests for it. If anyone can see any obvious mistakes in the implementation, shout up, it was a quick hack copying some of the other proc calcs. I'm getting ~570 DPS for mine, which seems about right?

I've unmarked this as PTR as the patch is either going live tonight/tomorrow or next reset. Hamlet's update RE: 4t13 set bonus is included.

I also tried the code snippet above, it causes errors on both of the non-64 bit version of Excel I tested it on. Anyone with 64 bit Excel can replace it manually if needed.

thedopefishlives · 01/29/12, 11:59 AM

Regarding Glyph of Starfire, in WrathCalcs, this is treated by simply adding 6 ticks to the duration of Moonfire. This is actually not strictly correct. I did a fair amount of in-game testing with the glyph on my moonkin druid to determine the exact mechanic. When a Starfire hits and procs an extension, it adds 3 seconds _plus the time before the next tick_ to the duration of the Moonfire effect. The number of ticks is then recalculated and any partial ticks dropped off the end; basically, the behavior can be considered similar to if you had recast your Moonfire at that exact point in time, only the spell lasted an additional 3 base seconds. This actually results in an extension that is rather longer than 9 seconds, and at certain haste levels and timing, can result in 7-8 additional ticks.

Alash · 01/31/12, 7:29 AM

Having just dinged 85 I'm currently kitted in Vicious Wyrmhide armour to be eligible for LFR, when I noticed it's not included in WrathCalcs. I would have disregarded this as irrelevant gear, but seeing as its two predecessors - Bloodied and Bloodthirsty - are both there, it seems like this should be too.

Slippykins · 01/31/12, 10:40 PM

I was fiddling with my current gear set-up on WrathCalcs earlier, and I noticed something peculiar in regards to DPS increases and haste breakpoints. I loaded my armory, changed 3 of my pieces (shoulders to 397 boomkin, chest to 397 resto, pants to 397 boomkin), and got 33511 DPS. However, when I manually changed my haste values from 2763 to the non-NG, non-DI haste breakpoint 2776, DPS jumps to 33740 (230 DPS increase).

Should the non-NG haste breakpoint, either with or without DI, even be applicable to our DPS anymore? As far as I know, we should practically never cast dots that aren't buffed with eclipse and consequently NG, or am I missing some underlying factor here? Since 13 haste is a relatively low amount of haste, it's a bit difficult for it to account for all the extra DPS.

Marcis · 02/01/12, 2:02 AM

All other potions except Mythical Mana are missing in Consumables section potion dropdown list.

♦ Tecton · 02/01/12, 4:20 AM

Originally Posted by Marcis

All other potions except Mythical Mana are missing in Consumables section potion dropdown list.

To quote Hamlet from last time the question was raised:

Originally Posted by Hamlet

The issue with Volcanic Potion is that the sheet is a steady-state model of DPS and doesn't take into account any particular fight length. So it doesn't include one-time effects like Potions. Also, averaging the Volcanic Int over a whole fight would defeat the purpose anyway, since the only interesting question surrounding the potion is how much you gain by stacking with certain timers. The spreadsheet's main DPS model isn't well-equipped to handle questions like that. You can still learn something by examining the scaling factors of various spells, but it's generally not worth the trouble since it's not that hard to figure out when to use your potion in the first place.

Basically: mana pots are only still in the sheet as a bit of a vestigial organ from when we could actually run out of mana, and even then it wasn't overly useful. Don't worry about pots too much, the right answer is always to pre-pot Volcanic and use Volcanic again with Heroism/Bloodlust/high damage phase.

Originally Posted by Slippykins

I was fiddling with my current gear set-up on WrathCalcs earlier, and I noticed something peculiar in regards to DPS increases and haste breakpoints. I loaded my armory, changed 3 of my pieces (shoulders to 397 boomkin, chest to 397 resto, pants to 397 boomkin), and got 33511 DPS. However, when I manually changed my haste values from 2763 to the non-NG, non-DI haste breakpoint 2776, DPS jumps to 33740 (230 DPS increase).

Should the non-NG haste breakpoint, either with or without DI, even be applicable to our DPS anymore? As far as I know, we should practically never cast dots that aren't buffed with eclipse and consequently NG, or am I missing some underlying factor here? Since 13 haste is a relatively low amount of haste, it's a bit difficult for it to account for all the extra DPS.

That's coming from the Haste module that Erdluf/Hamlet added on, I'm not really sure on the mechanics of that so will let one of them comment if they're keeping up with the thread. It looks like Insect Swarm damage is the problem, possibly from the tick calculations on the Haste sheet.

As always, a bit of common sense in relation to haste breakpoints is required as this is a spreadsheet not a sim.

Originally Posted by Alash

Having just dinged 85 I'm currently kitted in Vicious Wyrmhide armour to be eligible for LFR, when I noticed it's not included in WrathCalcs. I would have disregarded this as irrelevant gear, but seeing as its two predecessors - Bloodied and Bloodthirsty - are both there, it seems like this should be too.

I've simply not got time at the moment to go through and add them all for the limited benefit they give. If you have Excel you can use the Import sheet to grab them from the MMO-C database, although you might need to edit their name in the gear sheet due to several items sharing the same name (I normally just append the ilvl to the name in that situation).

• Hamlet · 03/27/12, 2:19 AM

Well, I've got something somewhat coherent in place. When all was said and done I basically rebuilt the rotation model. As you can see a bunch of things aren't in yet (mana, damage breakdowns, most updated spell info), but the basic setup should be working. This is more for the people who were familiar enough with WC to want to look at the new rotation setup than for general use, although anyone can look and see how the talents and things seem to be shaping up. I'll add more commentary sometime, but just leaving here for now.

♦ Tecton · 03/27/12, 4:41 AM

Do you want me to start populating this with any gear that shows up from beta?