I think light on dark is usually better for long-time viewing. So either option 1 or option 3, though I really think that the color design is fine the way it is (option 1).


The sheet is based on 3.0.8 mechanics as far as they're currently known. Crit does therefore not influence Bloodsurge procs anymore.

I've asked this before and maybe I just missed the answer, but doesn't the game round down when doing checks, i.e. 1.5% hit = 1% hit for checks? If that's the case then wouldn't it still be better to add one hit gem to make it 2%? It's not like you would be getting absolutely nothing at all from the hit gem, but if the game rounds down you are definitely not getting anything from that 0.5% hit. You could always add 16 str instead and still have wasted stat points floating around I guess.

The game's rounding behavior is quite odd. I've found sometimes doing static bloodsurge damage as either one number or the number -1 on multiple occasions. I don't see how a computer program could do this unless it was deliberate and that there was an algorithm that determined the randomness. Much like the random playlist in a music player, it's not truely random because it's determined by that algorithm.

I always believed that that it only truncates display values in the character sheet, but doesn't actually round them. Of course, it really is difficult to know.

To answer your question Graul, I don't think the game rounds down any chances at all. The game can handle many decimal places very well. In programming there are different kinds of stored variables that take up a certain amount of space. For certain kinds of variables, the size is static no matter the size of the value assigned to the variable. It wouldn't make sense to take additional steps to round a very accurate number and restore it. You can however, easily manipulate the display of these variables without changing the actual value that is assigned to the variable.

I never really thought too much about it until WoTLK and I guess there still isn't any need now then if the game does actually use decimals for checks and not just whole numbers. I suppose if it didn't use decimals then something like 6.5% for the dodge cap wouldn't really make any sense.

Yes, they most likely do count, but with just under 9% hit and 3/3 Precision you should actually have just over 1% chance to miss specials as TG anyway, so it doesn't really show anything. (8% base miss + 5% from TG - 3% from Precision - 8.9966% from gear = 1.0034% to miss specials)

You need 10% hit for TG. When the miss rate was 9%, you needed 11% hit. After the patch comes out, you only need 5%.

A good idea, but there's not enough horizontal space to do this. In Excel 97 there's a limit to up to IV columns. I'm currently at column IP with this build. I'd have to replace total SEP with delta DPS or delta SEP if you wanted to do that. I just always thought it was easy to tell differences in numbers in an ordered list to see if it was a big upgrade or not.

Would you rather have Total SEP removed for a plus or minus value like this?

Blast Excel 97 and their lazy limits!

You're right, it's easy to tell if it's a big upgrade, but I'm an organizational freak when it comes to my gear planning. I have a spreadsheet with the top 3 upgrades for each slot, combined with how much of an upgrade they are, sorted by the size of the upgrade, so I know where to focus my efforts. We're not DKP, but with competition for plate I'll pass more freely if I have this sheet in front of me and know that it'll give me a better shot at suchandsuch item from the next boss.

I'd say that total SEP is more appropriate. I can just add them to each release, or write a macro I can run to update the sheet for each release or something.

Ooh, just a thought...could you maybe make it a dropdown box selection in the options? So you can switch between total SEP and delta SEP at a click? If that's not too tedious, that would be awesome. If it's a pain though, unless other people speak up on this subject I'd say it's not worth it for just me

First id like to say thanks for the sheet, been using the various versions of yours for a long time and it helped me loads.

Im not sure i feel qualified to make suggestions on the layout, but im going to give it a shot.

Back in your old models, designed for the "Pre 3.0" era, you had things spread out over many pages, which in my eyes made everything easy to keep track of. Now im not necessarily saying it should be exactly like that, not at all, however i did like that i had a seperate page where i could set buffs and another for the gear, where things looked more simplified and easy on the eye. Looking at a page full of numbers and boxes just seems quite daunting at first glance and im sure some people find themselves continuously scanning over the data to find what they are looking for amongst the mass of information. Keeping the simple and important information on 1 page (SEP/DPS values, gear choices and stats) with the more detailed information about buffs, proc rates and miss/hit/crit/dodge chances, along with all the rest of the "detailed" information on another would greatly increase the user friendlyness of the sheet in my opinion.

In a way, i think a sort of "declutter" by use of extra pages is what i'm suggesting. Now i may have restated what other people have said and for that i'm sorry. Otherwise it would be nice to have the gems in the way others have suggested to reduce time clicking through them (perhaps some kind of priority list that would show the last few gem choices as the first in sight when you click the pulldown menu, as im sure most people would only use a handful of gem types in their gear). That said, great work so far, and thanks alot.

Just so you know in the 3.0.8 patch, [Belabored Legplates] are being adjusted. They were WAY overbudget for a 213 item. They are losing the 78 ArPen come patch day.