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?
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).
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.
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).
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.
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.
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.
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!
 Working on a small bug atm. Thanks! [/edit]
[edit2] Fixed below, import should work correctly on all version of Excel now. [/edit2]
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.
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.
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):
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.
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.