Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Druids

Reply
 
LinkBack Thread Tools
Old 10/16/12, 4:13 PM   #571
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
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
Attached Files
File Type: xls WrathCalcs 121016b.xls (911.0 KB, 240 views)


United States Offline
Reply With Quote
Old 10/16/12, 7:49 PM   #572
Stommped
Piston Honda
 
Troll Druid
 
Magtheridon
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?

Offline
Reply With Quote
Old 10/16/12, 8:26 PM   #573
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
If I remember correctly, the value given for +1 point of haste is the average over the next 1%?


Scotland Offline
Reply With Quote
Old 10/16/12, 8:26 PM   #574
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Yes. Maybe I should change that now that breakpoints are better understood.


United States Offline
Reply With Quote
Old 10/17/12, 3:46 PM   #575
Sharahiah
Glass Joe
 
Tauren Druid
 
Thrall
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...

Last edited by Sharahiah : 10/17/12 at 3:53 PM.

Offline
Reply With Quote
Old 10/17/12, 8:01 PM   #576
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Originally Posted by Sharahiah View Post
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.


Scotland Offline
Reply With Quote
Old 10/18/12, 6:38 AM   #577
gannonjf
Piston Honda
 
Worgen Druid
 
Korgath
Any chance this is going to work with 64bit any time soon or should I give up that hope and go install open office?

Offline
Reply With Quote
Old 10/18/12, 7:26 AM   #578
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
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.


Scotland Offline
Reply With Quote
Old 10/18/12, 1:10 PM   #579
damonsgame
Glass Joe
 
一個累全家
Night Elf Druid
 
Non-US/EU Server
WHAT IS ERROR 514??

I am using this with OpenOffice

Hong Kong Offline
Reply With Quote
Old 10/18/12, 1:51 PM   #580
Jibini
Glass Joe
 
Night Elf Druid
 
Bronzebeard
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.

United States Offline
Reply With Quote
Old 10/18/12, 4:17 PM   #581
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Originally Posted by Jibini View Post
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.


Scotland Offline
Reply With Quote
Old 10/18/12, 5:25 PM   #582
Sharahiah
Glass Joe
 
Tauren Druid
 
Thrall
Originally Posted by Tecton View Post
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!

Last edited by Sharahiah : 10/18/12 at 5:33 PM.

Offline
Reply With Quote
Old 10/18/12, 6:58 PM   #583
Stommped
Piston Honda
 
Troll Druid
 
Magtheridon
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.

Offline
Reply With Quote
Old 10/22/12, 7:39 AM   #584
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
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).
Attached Files
File Type: xls WrathCalcs 121022.xls (920.0 KB, 451 views)


Scotland Offline
Reply With Quote
Old 10/23/12, 6:36 AM   #585
nephyron
Von Kaiser
 
Troll Druid
 
Nemesis (EU)
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).

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