Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Druids

Reply
 
LinkBack Thread Tools
Old 07/11/11, 12:35 PM   #211
Fonzey
Von Kaiser
 
Troll Druid
 
Stormreaver (EU)
Originally Posted by Tecton View Post
From the other thread:

Do you want me to remove it from the dropdown unless GoSS is selected?
Hi Tecton, since it was I who got so confused by this spell usage drop down - that validation certainly gets my vote.

On a similar note, I'd be curious to see an option which indicates no GoSS but still Starfall during Lunar only (hence significantly reducing number of starfalls per fight). I would be interested to see what levels of Mastery would be required to make this option worthwhile in our rotation.

Offline
Reply With Quote
Old 07/11/11, 3:39 PM   #212
Erdluf
Great Tiger
 
Night Elf Druid
 
Echo Isles
Fonzey, If your rotation takes 40-50s, and you aren't using GoSS, the optimal Patchwerk use is almost certainly to use every second Starfall during Lunar. If you have 60% mastery:

Sfall only during Eclipse is 1.6 damage/2 cycles or 0.80 damage/cycle.
Every other Sfall during Eclipse is 2.6 damage/3 cycles or 0.87 damage/cycle.

Obviously you could consider doing something to extend the cycle to sixty seconds (lots of WM, Thorns, etc.) but that will be painful unless your cycle is already near 60s.

United States Offline
Reply With Quote
Old 07/18/11, 3:04 PM   #213
TricksAnthem
Glass Joe
 
Dwarf Paladin
 
Alterac Mountains
Just some minor issues I have found. In the gear list. [Sho'ravon, Greatstaff of Annihilation] has the same ilvl as the Heroic one. They are both ilvl 397 in the gear list. Not sure if it makes a difference, but i got a little confused for a sec. Also, is there any way to allow wrathcalc to use [Volcanic Potion]. I tried entering it into the item list, but it's telling me that druids cannot use that item type.

Offline
Reply With Quote
Old 07/18/11, 5:06 PM   #214
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
I'll fix the ilvl on the next update, I entered those manually as they weren't on the databases when they were first reported from PTR.

As far as Volcanic Potion, the items list is only for gear and you can't wear a potion! Adding Volcanic Potion would be up to Hamlet, but I'm not sure of the value of doing so.

Scotland Offline
Reply With Quote
Old 07/18/11, 5:50 PM   #215
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
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.


United States Online
Reply With Quote
Old 07/22/11, 8:13 AM   #216
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Hell has officially frozen over, and there's now an armory import in Wrathcalcs. The new API was released a short while ago, and thanks to a bit of a helping hand from Landsoul (huge thanks, very much appreciated) and staying up rather late last night, here it is! Once again, OpenOffice/Mac users are out of luck, sorry (OO users probably don't want to use this version quite yet either, use the version in the main thread). If anyone has any information about macro-ing for those platforms, I'm all ears to transferring everything over.

Hamlet: if you've got any updates on your personal version (this is based on the most recent posted Wrathcalcs in the main thread, from memory 110707) let me know when you're ready to put it into the wild and I'll copy and paste this stuff over.

A few caveats:

I've implemented internet encoding for names, I think. I do need some of you guys with accented letters/etc to ensure that this is functioning correctly for me. I might need to do another run over this, if you can tell me exactly what your character name is if it freaks out that'd be awesome.

You'll see an extra box in the sidebar. Select your region (EU, US, TW, KR) and enter your server. The box below for Force 2nd Spec is not yet implemented, but it'll let those of you with two balance specs force the spreadsheet to grab the second once it's working. For now, it'll just grab the first moonkin spec it comes across.

If you're wearing an item not recognised by the sheet (obviously, ignoring shirt/tabard slots) you'll need to add this on the MMO-C Input sheet. Enter the item's ID in the highlighted box, the sheet should automatically pull the item details from db.mmo-champion.com and then hit the button below. Then you can either input the missing item by hand or re-run the import macro on the front page. I'm 99% sure I've got all moonkin items from this expansion in the sheet, but if something is missing please let me know. I'm planning to add a function in automatically input any unknown items as they are found, but it's not a priority.

Because the API is being awkward, I've not put any checks to make sure you've input a druid's name into the macro. I'll do this later, but for now if you input a non-druid, you should just close down and reopen the sheet or you can expect unusual results. As I said, will be fixed later.

I'll port this over to Treecalcs once the inevitable bugs are ironed out here.
Attached Files
File Type: xls WrathCalcs 110722.xls (1.02 MB, 225 views)

Last edited by Tecton : 07/22/11 at 8:54 AM.

Scotland Offline
Reply With Quote
Old 07/22/11, 12:26 PM   #217
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Awesome. I don't think I had changed anything, so we can go with this one. I'll tell people to try it out.


United States Online
Reply With Quote
Old 07/23/11, 2:30 AM   #218
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
One bugfix (thanks Rarebeast) with regard to the random stat items which should be working in this build:
Attached Files
File Type: xls WrathCalcs 110723.xls (1.02 MB, 138 views)

Scotland Offline
Reply With Quote
Old 07/23/11, 10:20 AM   #219
Erdluf
Great Tiger
 
Night Elf Druid
 
Echo Isles
Character download is great.

One request: Highlight in red, unrecognized gems. I somehow had a Brilliant Cardinal (+20 Int) in one slot.

United States Offline
Reply With Quote
Old 07/23/11, 12:16 PM   #220
Sylethis
Glass Joe
 
Tauren Druid
 
Eredar
Idea:

Say a character is below hit or could utilize a stat to better DPS throughput.

If hit is less than TotalHitRating ~20 then prioritize a select piece of gear that could reforge to compensate for that stat as long as it doesn't adversely affect DPS.

Same for Haste, Crit etc etc.

It might be manageable with a nested IF statement. Though I haven't looked into the structure of the document. An additional page could calculate each piece of gear and it's reforging/enchants/gems and the most efficient combination could be output onto the Gear Setup page. So the two best gear optimizations could be included at the end of the item on Gear Setup or an additional page "Optimizations" could be implemented for that purpose.

Offline
Reply With Quote
Old 07/24/11, 4:47 PM   #221
fountaiin
Von Kaiser
 
Troll Druid
 
Deathwing
The Branch of Nordrassil seems to have weird stats. Hit/Crit, instead of the 271 hit & 250 haste.

Canada Offline
Reply With Quote
Old 07/24/11, 9:22 PM   #222
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Those are the stats in the MMO-C database, annoyingly. Updated it and the next step, and changed the name of the Incendic Chestguard.

I'll look into the suggestions above, too.
Attached Files
File Type: xls WrathCalcs 110725.xls (998.5 KB, 221 views)

Last edited by Tecton : 07/25/11 at 3:50 AM.

Scotland Offline
Reply With Quote
Old 07/25/11, 12:07 AM   #223
Erdluf
Great Tiger
 
Night Elf Druid
 
Echo Isles
WC: Basic Calcs: OoC Proc Chance says 2%.

With some target dummy testing that may be about right for nukes. Using a nukes-only (SF,Wr,SS) rotation for several minutes, I was seeing it take from 23 to 64 casts for a proc.

However MF has a very high proc rate (tested with LS). I got eight OoC procs in a total of 26 casts (MF-spam).

Testing was done with no gear procs (no weapon, no trinkets). The only aura's I got during the test were Shooting Stars, Lunar Shower, Clearcasting, NG, and both Eclipses.

Speculation: High MF OoC rate is intended to compensate for how difficult/expensive LS is to stack, compared to Scorch, which is always free and full strength (when that setup is selected).

United States Offline
Reply With Quote
Old 07/25/11, 9:11 AM   #224
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
I've just noticed that the armory output isn't outputting the Ebonsteel Belt Buckle as an enchant for some reason, I'll put up a new version tonight that automatically fills it in and repopulates the gem from that socket. I think it's safe to assume everyone uses one?

[edit] Also, do you want the Starfall dropdown to only give the option of "During Lunar" if GoSS is selected, Hamlet? [/edit]

Scotland Offline
Reply With Quote
Old 07/25/11, 3:04 PM   #225
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Originally Posted by Erdluf View Post
WC: Basic Calcs: OoC Proc Chance says 2%.

With some target dummy testing that may be about right for nukes. Using a nukes-only (SF,Wr,SS) rotation for several minutes, I was seeing it take from 23 to 64 casts for a proc.

However MF has a very high proc rate (tested with LS). I got eight OoC procs in a total of 26 casts (MF-spam).

Testing was done with no gear procs (no weapon, no trinkets). The only aura's I got during the test were Shooting Stars, Lunar Shower, Clearcasting, NG, and both Eclipses.

Speculation: High MF OoC rate is intended to compensate for how difficult/expensive LS is to stack, compared to Scorch, which is always free and full strength (when that setup is selected).
The OoC model has always been problematic since Cataclysm since OoC no longer affects instants. I pretty much just haven't bothered fixing it in the sheet since mana economy is such a minor issue for Moonkin and the current model gives a decent ballpark anyway.

Now that I think about it, it wouldn't be terribly hard to come up with something better--just compute on average how many OoC procs you get per cycle and then apply them uniformly to the nukes only. That would require figuring out all the proc rates in more detail though.

Originally Posted by Tecton View Post
I've just noticed that the armory output isn't outputting the Ebonsteel Belt Buckle as an enchant for some reason, I'll put up a new version tonight that automatically fills it in and repopulates the gem from that socket. I think it's safe to assume everyone uses one?

[edit] Also, do you want the Starfall dropdown to only give the option of "During Lunar" if GoSS is selected, Hamlet? [/edit]
You can check for the Prismatic socket in the belt to look for a buckle (you can also see if the belt has one more total socket than it's supposed to, but that might be a pain).

Starfall: why not, I guess. Although given the way Excel works, this means that if you have "During Lunar" selected, and then remove GoSS, it will remain selected and merely vanish from the dropdown. Still, I guess it's better than nothing.


United States Online
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