Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Druids

Reply
 
LinkBack Thread Tools
Old 03/01/11, 11:43 AM   #136
hamah
Glass Joe
 
Tauren Druid
 
Draka
Please forgive me if this is the incorrect thread to ask or if it has been asked and answered before. Searching this thread and others has not provided any info.

As a new user to WC I cannot seem to find a way to select no enchant for an item. While I can select a blank/null for a gem slot from the dropdown I cannot for the Enchant dropdown. I'm forced to use Manual Adjustments to remove the attributes improved by the Enchant.

I'm using WC 1102223 on Excel in Office for Mac 2011. Am I doing something incorrectly?

Offline
Reply With Quote
Old 03/01/11, 11:45 AM   #137
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Just select the cell with the dropdown menu and press delete. We should probably add a blank option at some point.


United States Offline
Reply With Quote
Old 03/01/11, 11:48 AM   #138
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Well, yeah, it would've made sense for me to add that when I was adding blanks elsewhere. It'll be in the next version. Updated version attached, let me know if it works ok (I'll doublecheck OpenOffice when I get home).
Attached Files
File Type: xls WrathCalcs 110301.xls (800.0 KB, 85 views)

Last edited by Tecton : 03/01/11 at 12:00 PM.

Scotland Offline
Reply With Quote
Old 03/01/11, 10:42 PM   #139
hamah
Glass Joe
 
Tauren Druid
 
Draka
Thanks for that. Yes, the blank selection on Enchant dropdown seems to work however profile export from WC110223 and into WC110301 gives me a "Run-time error '1004': Application-defined or object-defined error".

Another thing I'm struggling with is that I cannot seem to get any accuracy with Stats when compared to the character panel in WoW. I think I've done everything correctly as far as the gear setup and main tabs are concerned (basically insuring all glyphs/talents match and turning off all buffs). In contrast Rawr is spot on. i realize the later is using an Armory import while the former requires the far more error prone human input method but still it seems odd and is frustrating.

Any tips for a noob that I may have missed?

Offline
Reply With Quote
Old 03/02/11, 1:27 AM   #140
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
I'm pretty confident in the basic stat calcs. It is kind of pain to get all the gems/reforges right without Armory import I know, and I always have to scan through and find ones I missesd, but then end result always matches exactly. Note that the Armory gets some things wrong (like reforged Conclave items).


United States Offline
Reply With Quote
Old 03/02/11, 3:19 AM   #141
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
I'd imagine the macro failing is due to you being on Mac. I've not got access to a Mac to test/develop a fix, so there's not a lot I can really do to help out there unless anyone has any creative solutions. Also, as Hamlet says, the stats are spot on, any time I've noticed a discrepancy it's either been due to an item being updated and wrong on MMO-C's database or my error (i.e. 15 stats on chest versus 20 stats, etc).

Armory input is in the works at the moment, and I'll do some more homework to see if it's possible for me to get a version working for Mac.

Scotland Offline
Reply With Quote
Old 03/02/11, 7:17 PM   #142
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Got an interesting PM request--Chinese player wondering if I had the 3.3.5 WrathCalcs. Can't attach files to PM's so I'll just put it here. Think this is the last version before I started working on Cataclysm alpha mechanics. I'll throw the last WLK version of the guide up as well.
Attached Files
File Type: xls WrathCalcs 100715.xls (181.5 KB, 143 views)
File Type: xls WrathCalcs 100715 No Tables.xls (147.0 KB, 78 views)
File Type: rtf Moonkin TTT (WLK).rtf (46.9 KB, 136 views)


United States Offline
Reply With Quote
Old 03/04/11, 8:08 PM   #143
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Note to self and others since I have to run out right now--just noticed I lose DPS going from 2027 to 2028 haste rating. Must remember to figure out why. Curious if anyone else sees the same.


United States Offline
Reply With Quote
Old 03/05/11, 1:17 AM   #144
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Ok, got it. The pre-NG DPS iteration was hitting haste breakpoints (recall the sheet runs through one rotation time calc without NG, in order to compute NG uptime, then runs the full DPS calc). I'm just going to stop rounding DoT ticks in the first iteration, they have no physical significance anyway. This will eliminate occasional random fluctuations at certain haste values. Here's an update.

Also fixed a bug with caused DPS to be too low when you didn't have GoSF equipped.

e: that GoSF one was kind of significant, so I'll put this on the main guide.


United States Offline
Reply With Quote
Old 03/05/11, 5:41 AM   #145
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Quick reminder for anyone importing/exporting a profile:

It will only work for Excel on a PC, sorry Mac/OO users I've not used macros for your formats before (but am looking into it).
Open the new version, and select the profile you wish to update (i.e. select New from the dropdown and enter your character's name).
Go to the old spreadsheet, click export, choose the new spreadsheet and click import.
That *should* do it.

Obviously, any feedback is appreciated if it didnt' work for you. Thanks!

[edit] Working on a small bug atm. Thanks! [/edit]

[edit2] Fixed below, import should work correctly on all version of Excel now. [/edit2]
Attached Files
File Type: xls WrathCalcs 110305.xls (837.0 KB, 176 views)

Last edited by Tecton : 03/05/11 at 8:53 AM.

Scotland Offline
Reply With Quote
Old 03/05/11, 11:29 PM   #146
aceofsween
Don Flamenco
 
aceofsween's Avatar
 
Troll Druid
 
Lightning's Blade
I'm a little bit confused about how WrathCalcs handles Starfall (both with and without the Starsurge Glyph).

For starters, I set Starfall to unused. That gives me an overall value of 19108.29 DPS.

Then I went about trying to figure out how Starfall impacts my damage. With my gear, Starfall is doing an average of 48172 seconds and with the appropriate Glyphs, it's cooldown is reduced to an average of about 43 seconds. Conveniently, my rotation length is about 43 seconds as well (as calculated by WrathCalcs). This means I can line up every Starfall with Eclipse perfectly. My Eclipse bonus is at 48.52%, so that would buff Starfall's damage up to 71545 damage per cast. However, it's cooldown is no longer constrained by Starfall's cooldown, but by a combination of my Rotation length and my cooldown. Luckily, they are (roughly) equal, so we can treat them as if they are the same. Therefore, switching from "Unused" to "During Lunar Only" should add contribute roughly 1663 DPS. Again, it doesn't and the result is rather drastic. It should be about 20300 DPS, however Wrathcalcs is only showing a total DPS of 20100.

Also, I really think that a note should be added in for the Starfall options. If you select "During Lunar" WrathCalcs assumes that you are going to cast Starfall every time for every Lunar Eclipse, regardless of whether or not you are even capable of doing that. I'm going to guess that it does this by assuming a Starfall cooldown equal to your rotation length, which is only possible if your cooldown is lower than your rotation length (and only possible with the Glyph of Starsurge). If your cooldown on Starfall is great than that of your Rotation length, it should really assume that your cooldown is twice the rotation length, with a slight amount of wiggle room for triggering it during Lunar Eclipse instead of the beginning.

United States Offline
Reply With Quote
Old 03/06/11, 12:49 AM   #147
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
You're right about the "During Lunar" option. It just blindly assumes you cast exactly one Lunar Starfall each cycle, independently of anything else. I should probably add a note at least--it's really only meant to be used with GoSS.

As to the first part, remember you lose from DPS from the GCD's spent actually casting Starfall--from a base of 20k DPS you'd lose about 500 just from that before you add in the damage done by Starfall.


United States Offline
Reply With Quote
Old 03/07/11, 10:10 PM   #148
aceofsween
Don Flamenco
 
aceofsween's Avatar
 
Troll Druid
 
Lightning's Blade
I factored that into my initial calculations.

I took the the overall DPS without Starfall, multiplied it by the rotation length, added in the damage from Starfall, then divided by the rotation length plus one GCD for Starfall. The results are what I posted above.

Here's a more exact look (taking numbers straight from WC):

Total Damage (w/o Starfall): 818504.0412
Rotation Length (w/o Starfall): 42.97454043
DPS (w/o Starfall):
Starfall (w/o Eclipse): 48172.70482
Eclipse Bonus: 48.52%
Starfall (w/ Eclipse): 71546.60633
Mean instant GCD: 1.0645

WrathCalcs Totals:
Total Damage: 887408.3041
Rotation Length: 44.28553562
DPS: 20100.36786

Calculated Totals:
Total damage (w/ Eclipse): 890050.64753
Rotation Length (w/ Starfall): 44.03904 seconds
Total DPS (w/ Starfall): 20210.49139

It's honestly not as big of a difference as I originally predicted (110 DPS instead of ~200), but I'm still curious as to why there is a difference at all.

Last edited by aceofsween : 03/07/11 at 10:24 PM.

United States Offline
Reply With Quote
Old 03/08/11, 1:04 PM   #149
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Oh, that's a very small disparity though. I mean, half a percent of DPS is smaller than I'd ever claim the errors in the sheet are anyway. When you change the rotation length, little things change like DoT refresh times and NG uptime that will all affect DPS slightly.


United States Offline
Reply With Quote
Old 03/08/11, 2:10 PM   #150
aceofsween
Don Flamenco
 
aceofsween's Avatar
 
Troll Druid
 
Lightning's Blade
Right.

The first time I started wondering about this, I was getting a difference of roughly 800 DPS, but that was before I accounted for the change in rotation length. The reason I was asking is s because I'm beginning to look beyond our current 4.0 model, where the Starfire glyph fits nicely with the 4t11 bonus. As soon as you introduce a 2nd target, Starsurge becomes the best glyph we have by far, and I'm sure there are many fights where this will be commonplace.

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