The Joy of Spreadsheeting


This is not gonna be a fun post for me because, well, I goofed. I made some seemingly innocuous changes to the spreadsheet a while ago that caused it to be less accurate than it normally is (which, for the record, has never been anywhere near 100%), and it’s taken me a while to figure out that there was a problem and then finally fix it.

The short answer is that the spreadsheet has been overvaluing crit since 7.1 was released. In this updated version, you’ll see stat weights that look way off. Specifically, crit is much lower and haste is much higher; this is due to several reasons. The first is the previously mentioned changes that caused crit to be inflated. Second, I had been manually reducing the weight of haste by 10% because of its adverse relationship with mana; I’m no longer doing that. Last, stat weights are going back to what appear to be much more reasonable values, but everyone has been under the impression that crit was so powerful, so they have gravitated toward gear with lots and lots of crit. This makes crit look weaker than you would expect simply by virtue of having so much of it and so little of everything else. By comparison, the other stats will be higher than expected until stat distribution evens out a little more.

Continue reading

The Artifact Power Grind

There’s been a lot of talk lately on twitter and on the WoW forums about Mythic raiders being burned out by having to endlessly grind Mythic+ dungeons for Artifact Power (AP). There are other factors that have led to the feeling of burnout for several veteran raiders, but the specific problem of feeling like you have to spend your available time getting more AP for more Artifact Traits is what is complained about the most, so I’m going to talk about that.

I should preface by saying that my perspective is of a semi-hardcore Mythic raider, and that I’m absolutely in favor of an uncapped system for acquiring AP. I think that if a cap was added to AP there would still be people who feel like the cap is either too high or too low, and the cap would just be moving the problem to a different set of people. I also think the expectation for how quickly you acquire AP should be set by you or your raiding group and not by Blizzard.

Setting a Cap on Artifact Power

I’ve been playing WoW since 2005 and have seen multiple different systems for capped and uncapped resources. From uncapped Honor grinding in Vanilla to seemingly uncapped Badges of Justice in Burning Crusade to the weekly Valor cap in Mists of Pandaria. The Badge system in Burning Crusade was capped in the sense that there were only a set number of dungeons and raids you could do per day/week, but that cap was so high that it was almost never achieved every day; very few people did all 16 Heroic dungeons in a single day.

Regardless of my opinions on the systems themselves, I was always in favor of an uncapped system because a cap was either too high for me to care about or too low and made me not care about the content. Obviously this is specific to my own determination, but that’s also my point: it’s virtually impossible for the arbitrary cap to be exactly how much content you want to participate in.

Continue reading