[Balance] WrathCalcs - Page 39

• Hamlet · 10/16/12, 4:13 PM

Windsong and EF.

For people interested in the math that went into it, I wrote up a bit about modeling the new enchants:
Theorycraft 101: How to Compute Uptime of a Proc-based Buff | It's Dangerous to Go Alone

Stommped · 10/16/12, 7:49 PM

Bit puzzled by this one. According to the stat calcs on the Main sheet, Haste for me is worth 1.86 dps (crit is only 1.56 which is another strange thing since Im over the bp), and Intellect is worth 3.31 dps. Now I had a Quick gem in my gloves in order to reach the bp, which I now no longer needed, I could get there by simply using a Reckless.

According to my stats though since Haste is worth more than half of Intellect, the Quick gem should still be better. I decided to test it anyway and the Reckless gem actually spit back higher DPS than the Quick gem. Am I missing something here?

♦ Tecton · 10/16/12, 8:26 PM

If I remember correctly, the value given for +1 point of haste is the average over the next 1%?

• Hamlet · 10/16/12, 8:26 PM

Yes. Maybe I should change that now that breakpoints are better understood.

Sharahiah · 10/17/12, 3:46 PM

I'm not seeing any of the energized green gems on the sheet. Is that by design or just an oversight? Can I add them into your lookup table myself if you're busy?

Edit: After thinking about it, I'm guessing it's because lightning gems are functionally equivalent.

Thanks for your time, and for the spreadsheet! Now to find out why I'm only averaging about 46k dps unbuffed...

♦ Tecton · 10/17/12, 8:01 PM

Originally Posted by Sharahiah

I'm not seeing any of the energized green gems on the sheet. Is that by design or just an oversight? Can I add them into your lookup table myself if you're busy?

Edit: After thinking about it, I'm guessing it's because lightning gems are functionally equivalent.

Thanks for your time, and for the spreadsheet! Now to find out why I'm only averaging about 46k dps unbuffed...

Energized gems are on the sheet, in the green section of the gem dropdown.

gannonjf · 10/18/12, 6:38 AM

Any chance this is going to work with 64bit any time soon or should I give up that hope and go install open office?

♦ Tecton · 10/18/12, 7:26 AM

Just install 32-bit Excel, if you have 64-bit you have the installer for that too. Armory import only works with 32-bit Excel as I've not found any solutions which work for both and I'm not going to maintain two versions. Everything else will work on 64-bit if you use the fix I posted a few pages ago (I've not included it in the main release as it apparently freaks out older versions of Excel 32-bit).

There are really very, very few benefits to using 64-bit Excel, unless you're using spreadsheets that are over 2 GB you're just limiting yourself as to the 3rd party stuff you can use as Microsoft haven't (and won't) port the ActiveX controls over.

damonsgame · 10/18/12, 1:10 PM

WHAT IS ERROR 514??

I am using this with OpenOffice

Jibini · 10/18/12, 1:51 PM

The stats on the BoA inscription staves don't appear to be correct. They're both listed on the gear tab as having haste and mastery, where the Crane staff has spirit and mastery and the Serpent staff has hit and mastery.

♦ Tecton · 10/18/12, 4:17 PM

Originally Posted by Jibini

The stats on the BoA inscription staves don't appear to be correct. They're both listed on the gear tab as having haste and mastery, where the Crane staff has spirit and mastery and the Serpent staff has hit and mastery.

They must've changed since they were originally added. You can either input them yourself on the WoWhead input tab or I'll update in the next version.

Regarding OpenOffice: I'll reinstall it and check out any errors that are appearing.

Sharahiah · 10/18/12, 5:25 PM

Originally Posted by Tecton

Energized gems are on the sheet, in the green section of the gem dropdown.

I'm looking in the gem dropdown and I only see zen, lightning, sensei's, and piercing. Am I missing something? Also, the spirit and crit effect meta isn't selectable.

Currently using 120923 as that's the version on the balance thread.

Edit: Okay, I got the new version and see both energized and the spirit meta gems. However, the import/export function doesn't appear to be working. How do I check if I have x64 office? I'm looking in the "about" section of the excel 2007 options and I don't see anything that would indicate x64 vs x86. It did install itself in the x86 program files folder, which would lean me toward it being the x86 edition.

Thanks!

Stommped · 10/18/12, 6:58 PM

For next version, Feng's Ring of Dreams needs to be added. The LFR version is there but the normal/heroic versions are missing.

Thanks.

♦ Tecton · 10/22/12, 7:39 AM

Updated Feng's rings and Inscription staves, thanks for catching those.

BiS list updated again.

Regarding the import/export, if you're trying to use it from a version prior to it being fixed it won't work (as it wasn't fixed yet for the new layout/etc).

nephyron · 10/23/12, 6:36 AM

Missing Item: Burning Necklace of the Golden Lotus - Item - World of Warcraft
Burning Necklace of the Golden Lotus
Binds when picked up
Neck
+958 Stamina
+638 Intellect
Requires Level 90
Item Level 489
Equip: Increases your hit rating by 394 (1.16% @ L90).
Equip: Increases your critical strike rating by 444 (0.74% @ L90).