[Balance] WrathCalcs - Page 36

♦ Tecton · 10/04/12, 1:13 PM

Originally Posted by Bamfkinhero

After enabling content, this error pops up and it opens Microsoft Visual Basic. Refreshing (f9) brings this up, using any of the battle.net features brings this up. The load/save/import/export brings this up. This isn't any recent issue, I've had it for a long time.. when it was first added way back in the day it worked for me though.

If I don't "enable content", all calculations work fine as far as I can tell. I just have to manually input gear.

Try this:

Open Wrathcalcs, press Alt-F11.
Double click module 4 on the left hand part of the window.
This should open up a page of code. Replace the 2nd line with this:

Private Declare PtrSafe 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

Let me know if that fixes it for you. Please note, this won't make armory import work but should hopefully sort the rest of the sheet for you.

Stommped · 10/04/12, 2:30 PM

I understand the difference between WC and other DPS simming tools... But for the life of me I can't remember a time when there was such a discrepancy between stat weights. WC still shows haste barely ahead of Crit for me after the 5200 bp, where as in Rawr and WoWReforge haste is by the far the worst secondary stat, even below mastery. There is also he discrepancy in talents as WC favors FON/ HotW.

It's so expensive to re gem/enhant/forge everything to play with different stats so I guess you just have to pick one and hope for the best.

♦ Tecton · 10/04/12, 6:39 PM

FoN is only favoured because it has a hard 11 (from memory) casts put in for now until the mechanics are better understood as to when it has x/y/z stacks. At low haste levels, this is heavily overvaluing it.

Is WoWreforge a sim now? The last time I looked at it it purely calculated the optimal amount of stats depending on the weighting you gave it.

• Hamlet · 10/04/12, 7:11 PM

Oh, did you change it to 11? Just curious since I didn't remember that number. Until we find out anything better, whatever guess seems good based on the tests you'd done is good for now. Should probably have a note somewhere that we more or less have no idea what it's doing.

♦ Tecton · 10/04/12, 7:42 PM

I don't remember changing it to 11 in anything I've uploaded, but could've possibly started working on a copy after testing out what the cast number did DPS-wise if so. Sorry about that if so.

I've logged off for the evening, but can someone do a quick test of cast numbers at a variety of haste levels (my tests on beta were to a US server, and I don't know if my lag would impact pet casting/etc) and I'll plug in a quick lookup table for it? We can refine the values as we go on.

Seles · 10/04/12, 8:24 PM

Originally Posted by Tecton

Is WoWreforge a sim now? The last time I looked at it it purely calculated the optimal amount of stats depending on the weighting you gave it.

Pretty sure WoWreforge is just running every single combination (or an optimized search) of reforges possible (2 stats -> hit/crit/spirit/expertise/haste/mastery etc.) gives about 8 possible reforges per item, and with 16 or so items, you have a total of 8^16 possibilities, which is what's running I believe.

• Hamlet · 10/04/12, 8:52 PM

Right but what does it do with each one? i.e. whose stat values does it use?

Bamfkinhero · 10/05/12, 12:15 AM

That fixed the error popping up, Tec. However K1 (=urlencode(B1)) is not working. B1 is set to Bamfkinhero and it is returning #NAME?, same with K2.. so battle.net lookup isn't functional.

Latas · 10/05/12, 1:20 AM

Some of the items need to be updated, as some were bumped from 450 to 458 and some from 464 to 458.

♦ Tecton · 10/05/12, 3:43 AM

Originally Posted by Bamfkinhero

However K1 (=urlencode(B1)) is not working. B1 is set to Bamfkinhero and it is returning #NAME?, same with K2.. so battle.net lookup isn't functional.

Yeah, Excel 64 doesn't support what I'm using to get the Armory data (and most of what DOES work in 64 doesn't work in 32 bit). Once the base functionality of the sheet is working, I'll try again to come up with a workaround.

Originally Posted by Latas

Some of the items need to be updated, as some were bumped from 450 to 458 and some from 464 to 458.

Thanks for pointing that out, I was aware of the hotfix but it didn't occur to me that I'd need to update the item values. Oops! It's just the JP and Honour items that have been updated, correct?

Regarding FoN, I had a look at putting together a quick lookup but we'll need more info before that's useful. If some enterprising person can record the number of casts they have at different haste levels (with NG up, as the treants inherit it so it doesn't make sense to cast them without NG being up) that'd be useful. It's not just a case of duration/cast time to find the number because of their weird behaviour, so that's the only way I can think of to capture this for now. Remember to always test this with NG up, since that's a lot more DPS from them. I've resaved it with 6 casts for now, but if everyone can please be aware this will now undervalue it for higher levels of haste.

Here we are:

Latas · 10/05/12, 5:54 AM

I'm pretty sure it is just the jp and honor items. Might want to double check after updating those to be sure though.

Also one other thing I just found out. Wrathcalcs seems to be calculating the base int of at least worgen at 90 as 152 when my character is showing 183. Spirit should also be 187 and stamina 120. I don't know the correct values for the other races but it's something to look into.

CaseyTheRetard · 10/05/12, 11:09 AM

The trinket with Item ID 77530 has some incorrect info in the WrathCalcs gear database:
is: "Pandaren Dragonling" item level 457 with 801 Mastery.
should be: "Ghost Iron Dragonling" item level 450 with 0 Mastery.

nephyron · 10/07/12, 7:16 AM

Gem id: 76651
Energized Wild Jade
+160 Haste and +160 Spirit
Item Level 90
"Matches a Yellow or Blue Socket."
Sell Price: 4

Gem id: 76585
Perfect Energized Alexandrite
+160 Haste and +160 Spirit
Item Level 88
"Matches a Yellow or Blue Socket."

Those gems are missing and the Dreadful Gladiator items' stats need to be updated.

Stommped · 10/07/12, 8:26 PM

I think it would be cool if we could at button to lower the item level of our gear to 463. This way if we are attempting to do Challenge Modes, we know how to change our reforging to stay above the haste cap. Not sure if this is possible or not.

• Hamlet · 10/07/12, 8:53 PM

I think I want to do that eventually, but someone (I or someone else) has to reverse engineer the details of exactly how it all works.