The inputting is taking a bit long right now, I must agree. It's definitely longer than a minute when doing a fresh download of a new version. Things you could do to speed it up include:

1) Link socket bonuses to the item entries, and automatically determine whether the bonus is matched. You'll need to change the gem entry around a bit for this, since right now it's not even showing the sockets on the main item page.
2) Sort the gems better in some way. Perhaps quality first, then alphabetical. This is definitely slowing me down.

Well, for me, I will be honest and say it was kinda annoying. The spreadsheet does not auto-adjust based on the gear piece...so when you switch from one piece of armor that has 3 sockets, to a piece of armor that has 0 sockets, you have to go in and manually switch each of those 3 socket pieces to "None" (instead of the spreadsheet knowing that the piece has 0 sockets and auto-adjusting).

Again, I am coming from the Hunter spreadsheet. And while I can agree that not everyone logs out in the exact armor set they use all the time, I would say the majority of the time people do. Having the ability to load your profile on the fly is a REALLY nice feature. Im not sure how "buggy" you think it would be. I would suggest maybe looking at the codeing for the Hunter Spreadsheet and see how they did it, because it can read the armory page and update all the spreadsheet information in a matter of seconds. This includes gem slots, enchants and things like if you have a certain set bonus from your gear.

Another good feature is the "Gear Planner". What this feature does is shows you what piece of gear you are using, ranks it (based on your current stats), and then shows you what pieces would be better. I like being able to see how my gear ranks on teh screen, instead of having to click on the drop down scroll box. Maybe if you made a small box for each slot that showed 10 gear pieces in it (the piece you are wearing in the middle, and the 5 ranked higher pieces above, and the 4 ranked lower pieces below).

Anyways, I really do like your spreadsheet...I guess I have just been using the Hunter one for so long, I am just more used to that one. I know these things are not easy to do (and I know for a fact that I could never do one of these things), so again, just really want to thank you for the time and effort you have put into making this. You might get a better idea of some of the things I am talking about and the format I am referring to if you look at the Hunter spreadsheet here -> WotLK DPS spreadsheet

This caught my attention, as the people over a Rawr have been looking for someone to code their spreadsheet into their interface. I have no idea how detailed that is, but perhaps worth looking into?

When making something like this, its best to try and think as simplistic as you can. The goal should be to make it so someone who has very little knowledge in how specific numbers work, can easily download your spreadsheet, input their info and get a result quickly.

Different tabs for different information is VERY helpful. Certain features or information can easily get lost in the clutter of things when you have 10 different things on just 1 page. These spreadsheets do not need to be fancy - and in many ways, the less fancy they are, the better. I should be able to load my information into the spreadsheet and see what my projected DPS output is right away...both with raid buffs and without.

In the end, you wont appeal to everyone. Some people will like things differently than others. But I think the key is to try and make the spreadsheet usable by a wide variety of people (casuals, hard-core raiders, the computer smart and the people who only know the basics). In my opinion, you can reach all those people through simplicity and ease of use.

Just remember, what may be easy for you, may not be so obvious or easy to someone else. The goal should be to make it obvious and user friendly as possible, so everyone can benefit from it.

Well, the Hunter spreadsheet has a lot of pages because of the different rotations and such. Several pages are dedicated to that and pets and such. Doing something along the same lines for Warriors would be much less in terms of pages needed, but I really do think separating different things on different pages makes a huge difference. Ill tell you right now, the way the Warrior spreadsheet is set up right now can be very confusing. While the Hunter spreadsheet may seem like a lot, it is very easy to see what does what and how to do it.

In regards to the Armory look up...im not a coder, so I have no idea where exactly the code is. However, I can tell you how it works. If you click on the "Overview" tab, and enter in the Name and server of the character you want to use (if you wanna try mine, just enter "Sore" in the name, "Alleria" in the Realm and then "US" for server-set. After you enter that, click on the Gear tab, and at the top you should see a button to click that says "Load Gear from Armory". Clicking this will auto load all my gear, gems and enchants into the table below. Next, if you click on the Gear Planner tab, and click "Sort" at the top, will will arrange your item with a point value system compared to other items (with the item you have equipped as the highlighted one).

I know you said you dont like the amount of tabs on the Hunter Spreadsheet, but it really does make things easier when looking at it from an all over perspective. Each tab is intertwined with eachother...so clicking on "Talents" tab and changing stuff on that will effect things in the "Overview" tab as well. But you will also notice that each tab has a very easy to see DPS section. So you can easily see what each thing does to your overall DPS based on that one specific thing. For example, maybe I want to see how changing my talent points around will mess with my DPS. I load my profile and click right on the "Talents" tab....right there, in my face is my DPS and my talents that I currently have. I can now easily change my talents around and see right away what it does to me DPS. I dont have to scroll around looking for where the DPS box is or anything like that...its all right their on my screen all at the same time. And you can do the same thing for gear, rotations, buffs, or in a Hunters case, different pets and their trees as well. Could you imagine all the information and data in the Hunter Spreadsheet being on 1 page? Thats almost the equivalent of what the Warrior one looks like now...its just too much different stuff all on the same page.

Last, if you have questions regarding the specifics of the Hunter spreadsheet, I would consider talking to the person who is actively editing it, Shandara. The spreadsheet was originally created by Cheeky, but they have since stopped updating it. Shandara took over the work and has been doing a great job.

Fantastic spreadsheet! I was wondering if you were planning on adding the Shoulderplates of Bloodshed or did I just miss them?

The [Shoulderplates of Bloodshed] are in the spreadsheet, however under the name Shoulderpads of Bloodshed.

While I think that dividing the sheet into tabs would help overall-accessibility and clarity of the spread-sheet, this would make creating several item-Sets a lot more complicated than it is now. Right now, I can simply copy the Set 1-tab and put in the Item-/Talent-Changes. With the sheet itself being spread over several tabs, this would mean that one would have to save a separate file for every set of equipment (unless there is a way to creatively incorporate a pre-defined number of sets into the sheet without actually cluttering up the sheet - I have yet to see a spread-sheet using tabs and offering a "slim" way to create several sets of equipment for easy comparison). This would of course not be the end of the world but it might offset the advantage of tabs.

Apart from this, three things come to my mind:

- I also like the idea of some form of "intelligent" gem-socket/-bonus managment as mentioned by Score82.
- The sorting of Items/Gems sometimes feels weird. This is probably easier to remedy for gems than it is for armor pieces. If I remember correctly, the sheet sorted armor pieces into leather/mail/plate-categories some time ago. Would it be possible to get this done again? (very minor issue)
- It would be nice to have a stat summary somewhere easy to spot, showing final hit/crit/haste, etc percentages.

Obviously, all these are not matters of necessity but rather convenience. I would rather have a sheet offering a little less comfort than sacrificing part of the flexibility it now offers.

I think it is better to leave all the gear together, instead of splitting it into leather, mail, plater. It is easier to see the actual best in slot this way. Adding perhaps a tag at the end of non-plate gear names would be the easiest and best way.

Gem look up could be easier simply becuase they are broken up so weird. Also if the spreadsheet knew if there were sockets, how many, bonus, that would be extremely helpful as it is really the only slow part of the process.

As far as tabs, leave the SEP, gear list and dps on the set1 tab then make another tab with all the information that appears below. Also if there was a way to list DPS without raid buffs and with. I find myself having to turn them off all the time when I want to see how my damage increased for heroics where I can't always count on the right buffs being present.

- Rearrange it so you can see all your unbuffed stats (what Armory would show) in one place, preferably somewhere easy to find
- Right below that, have it include any self-buffed stats (AP using Battle Shout/Commanding Presence, including trinkets and cooldowns that you are factoring in)
- Right below that, include raid buffed stats (possibly with and without cooldowns)
- SEP calculations...I seem to remember the 2.4 spreadsheet doing SEP calcs without using a macro. Our rotation and spec hasn't changed too much, how difficult would this be to re-incorporate? I know that there'd be a bit more guesswork because of your rage-starvation calcs and glyph of heroic strike, but in the end it really seems like it should be doable
- Hit table should be more prominent. Maybe put a small table somewhere that just shows what your hit table is when attacking from behind (two rows, one for MH one for OH?).
- Gems are really difficult to navigate right now, and I like the classification based on stats instead of just one huge dropdown
- A macro for armory lookup would be nice, but IMO isn't super necessary. Once you have it set the first time, and you're out of beta, people won't need to use that feature that much

Really, a lot of the stats that are displayed right below the gear/spec stuff isn't important to most people and can be hidden off somewhere out of sight. Everything that the typical user may want to see should be up top; things like heroic strike calcs and whatnot should be below all of that.

Separate tabs may be the way to go, but I have to agree that the option to include 3 different tabs for different gearsets (10man, 25man, heroic, etc) makes the one-tab feature good.

That's already there. Input your gear, run the SEP macro, then in the gear tab run sort. It sorts everything based on the item's SEP. Really handy feature.

I couldn't figure out if the spreadsheet took into consideration the two piece tier 7 set bonus in the SEP calculation. Because it affects Slam damage and that is based off crit, I thought it might bump up the SEP crit value a bit, but wasn't sure.