Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Druids

Reply
 
LinkBack Thread Tools
Old 03/27/12, 9:47 AM   #406
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Went ahead and edited some in, if you've done extra work since posting the above, Hamlet, just carry on with that version and I can copy/paste this back in later. Was mostly just to let me get started on all the level 90 stuff.

To do:

Zen Alchemist Stone proc.
New Cogwheel values.
Weapon Enchant Proc values.
Food values updated to 250/275/300.
Flask values updated to 1000.
Determine new gem values/types.
Enchant/gem IDs.
Most profession perks.

Notes:

Import & profiles are currently broken for obvious reasons, I'll update these shortly.
Relics removed.
Most procs from level 85 gear have been removed by Hamlet as he preps the sheet for MoP stuff, before anyone asks!
I've added all the unique items I could see with stats from ilvl 399 and up. Once we start getting more information on end game gear, I'll start removing lower level items.
Interestingly, it appears that all caster trinkets are being merged (i.e. DPS and healing). Great news for those of us who perform both roles. The higher level trinkets are still in placeholder form, though.
Might be an idea to put the Dragonwrath proc back in, incidentally? I know it's likely to come up early in the expansion how the proc weighs up (although the new weapons have so much spellpower I think it's unlikely to be useful).
Attached Files
File Type: xls WrathCalcs 120327b MoP Beta L85.xls (975.5 KB, 111 views)

Last edited by Tecton : 03/27/12 at 9:56 AM.


Scotland Offline
Reply With Quote
Old 03/27/12, 10:16 AM   #407
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Yeah, nice--I haven't done anything since then so that's good. I don't think you have to get into anything terribly detailed right now (nobody's going to care about gear too much until the L90 premades are around), but basically whatever you feel like. Updating all those misc bonuses like professions is good. Otherwise I'd say just clean out all the 85 items (except for the highest levels at least) and populate it with a simple list of L90 things just so there's something there.


United States Offline
Reply With Quote
Old 04/13/12, 1:24 AM   #408
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
New Incarnation. Buffs 1 Eclipse per cooldown by 25%, and buffs all output during CA by 25%.
Attached Files
File Type: xls WrathCalcs 120412 MoP Beta L85.xls (969.0 KB, 93 views)


United States Offline
Reply With Quote
Old 04/24/12, 7:10 PM   #409
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
I changed an 18 to a 12 and assumed I'd done everything correctly. So far casting DoT's twice per cycle still doesn't seem very good.
Attached Files
File Type: xls WrathCalcs 120424 MoP Beta L85.xls (969.0 KB, 43 views)


United States Offline
Reply With Quote
Old 04/24/12, 9:59 PM   #410
Erdluf
Great Tiger
 
Night Elf Druid
 
Echo Isles
Originally Posted by Hamlet View Post
So far casting DoT's twice per cycle still doesn't seem very good.
If I'm reading it right, an MF cast outside of Eclipse and NG, should have a DPET (in spreadsheet terms) of

(MFDDAver + MFMeanNUMTicks * MFTickDamage) / GCD

When I plug that in, I see a number slightly less than SelectedDPS. Of course my calculation ignores the fact that all non-cooldown DPS is a bit less than averge DPS, but still, it supports your statement.

United States Online
Reply With Quote
Old 04/25/12, 2:00 AM   #411
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Eh, threw in T14 set bonuses.
Attached Files
File Type: xls WrathCalcs 120425 MoP Beta L85.xls (969.0 KB, 70 views)


United States Offline
Reply With Quote
Old 04/25/12, 6:42 AM   #412
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Updated with new gear, gems, enchants and some profession bonuses.

Please note:

Armory Import *will not work*.
DPS values greatly exaggerated due to using level 85 ratings.

Not done:

Food/Flask/Elixir updated bonuses.
Most trinkets have placeholder values still.
Weapon Enchant - Windsong.
Weapon Enchant - Elemental Force.
Engineering Glove enchants.
Engineering Cogwheels.
Tailoring cloak enchants.
Inscription shoulder enchant.
Herbalism (Lifeblood) value. I think this needs to be moved over to the Haste module too?
Leatherworking wrist enchants.
Mining stamina value.
Rep Shoulder/Head enchants.

Things that will need to be looked at:

Ilvl boosting mechanism for VP upgrades.
Level 90 rating multiplier.
Target level dropdown changed.
Set bonus checks (doesn't matter until we actually get set gear).
Attached Files
File Type: xls WrathCalcs 120425b MoP Beta L85.xls (1.00 MB, 143 views)


Scotland Offline
Reply With Quote
Old 06/26/12, 8:02 AM   #413
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Caught up on some updates from recently. Big thanks to Starfox for the help with the ratings multipliers.

Please note:

Armory Import *will not work*.
Tailoring & Engineering benefits look very high at the moment, I'd imagine those will get tuned down.

Done:

Ratings updated to level 90 values.
Food/Flask/Elixir updated bonuses. Hamlet, I've sectioned these off into a table to make maintenance easier (rather than having to dig through the formulas for the values).
Head enchants removed.
Shoulder enchants updated to level 90 values (including Inscription-only versions).
Engineering - Synapse Springs updated.
Tailoring cloak enchant updated.
Leatherworking wrist enchants.
Target levels updated.
Crit Suppression (1% per target level) added.
Leg enchants updated to MoP values (cheap ones aren't in the files yet).

Not done:

Most trinkets have placeholder values still.
Weapon Enchant - Windsong.
Weapon Enchant - Elemental Force.
Engineering Glove enchant (potion/damage versions).
Engineering Cogwheels.
Herbalism (Lifeblood) value. I think this needs to be moved over to the Haste module too?
Mining stamina value.
Alchemy flask/elixir bonuses.

Things that will need to be looked at:

Int contribution to Crit values. Didn't touch this, but it looks quite high.
Scaling Factors/Data Tables on Main sheet for new ratings.
Ilvl boosting mechanism for VP upgrades. Suggestions welcome on how to handle this.
Set bonus checks (doesn't matter until we actually get set gear).
Recent mechanic changes (FE, SS procs, Starsurge damage, etc).
Are the changes to level 90 talents in?
Refresh gear list. Item input broken due to format change from MMO-C.
Attached Files
File Type: xls WrathCalcs 120626 MoP Beta.xls (1.01 MB, 174 views)

Last edited by Tecton : 06/29/12 at 9:01 AM.


Scotland Offline
Reply With Quote
Old 09/02/12, 5:00 PM   #414
Juvencus
Glass Joe
 
Tauren Druid
 
Doomhammer (EU)
Are there any updates coming to this wonderful piece of work? I understand Hamlet is no longer playing but the basic code is still there, right?

England Offline
Reply With Quote
Old 09/03/12, 3:45 PM   #415
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Yeah, it's all still there--the version Tecton linked above are additions to an update I did partway through the beta. I haven't looked at the DoT/talent changes that went in later in the beta. Hopefully they wouldn't take too long to update, but I don't have a specific plan yet as to when.

If Tecton is still planning on updating the item stuff, I can probably try to fix the backend for recent DoT changes--I don't think that should take too long. The other task would be all the numbers--coefficients for every spell, rating stuff, mana. If anyone's kept up enough to just have a list of those handy, would probably help overcome laziness from my end if all I had to do was the guts of the sheet.


United States Offline
Reply With Quote
Old 09/04/12, 4:05 AM   #416
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Yeah, I'll do a pass to update items/etc once you get a chance to update the actual workings of the sheet. I'll admit I've lost track of coefficients/etc with all of the small tweaks that have been going on recently, though.


Scotland Offline
Reply With Quote
Old 09/04/12, 10:50 AM   #417
thedopefishlives
Don Flamenco
 
Dwarf Paladin
 
Baelgun
See, this is what you guys keep me around for.

SpellBase DamageCoefficient
Starfire39621.759
Wrath2247.51.027
Starsurge44392.133
Starfall5770.33
Moonfire625.5.24
Moonfire DoT263.24

Starfall is per star, Moonfire DoT is per tick, and also applies to Sunfire.

United States Offline
Reply With Quote
Old 09/04/12, 12:36 PM   #418
Erdluf
Great Tiger
 
Night Elf Druid
 
Echo Isles
I believe that Druid base-damage scaling numbers from 85-90 are 986.626403808593750, 1007.808593750000000, 1029.211425781250000, 1050.834472656250000, 1072.677490234375000, 1094.739746093750000.

So if base damage for Wrath at 90 is 2247.5, then at 85 it is 2247.5 * 986.6 / 1094.7

I pulled those numbers from Simulationcraft

United States Online
Reply With Quote
Old 09/11/12, 2:44 PM   #419
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Tecton, did you double the strength of haste throughout the sheet at some point (i.e. change the rating->% conversion?)?


United States Offline
Reply With Quote
Old 09/11/12, 3:16 PM   #420
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
The only thing I can think of that I changed was editing the values for haste/crit/etc ratings for level 90 in the last version as per the numbers someone posted from Simcraft.


Scotland 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