Originally Posted by Darlal
Would you mind if I threw together a front page that made equipment selection a bit easier? I aldready did it so that I could test some of your numbers, but I will keep it to myself if you'd like.
I'd also find this to be much more helpful if it had some predictive functions.
I'd like to see:
a)relative value of stats based on current equipment (to help pick enchants/gems)
b)ranked list of possible upgrades for specific slots (user chooses)
c)optimal gear composition based on a set of possibilities
with these three things I think this spreadsheet could really add something that the dps calculator is used to do, but does very poorly/clunkily.
I'd be happy to help put any of these things together, but I'd like your premission before I do anything beyond make changes for my own personal use.
|
If you'd like to clean up the UI, that would be fantastic; I've known since about the 2nd day I started working on this sheet that it desparately needed a new UI, but I'm a relative Excel novice so had to settle for strictly functional to start with. The changes you propose defenitely sounds like they would help.e pie
With regards to your point c in particular, I think the ideal would be to have a column in the gear sheets that marks where the given item drops, and then generate a "largest upgrades from each location" chart somewhere - i.e., "these are the largest upgrades from heroics", "these are the largest upgrades from karazhan" and so on - then you could just look at which instances are available to you (given current guild progression) and figure out your priority list. In a totally ideal world it might even specify which boss within the instance drops it, although that might be fancier than is needed.
I think the talents could also use drop-down boxes to specify your current build rather than the current "fill in a number" system - and, honestly, replacing the "put a 1 in this column if you have it" mechanic with checkboxes might be a good idea too.
Also, there are some paramaters that are currently hard-coded that could probably use a selection screen somewhere, notably:
*Character Race (currently hardcoded to NE)
*Boss Armor Value (currently hardcoded to 5k)
*Offense-to-Defense ratio (i.e., how much effective stamina is worth relative to effective AP - it's currently hardcoded to 1 sta = .6 AP, but that should ultimately be tweakable so people who want more or less stamina can do so)
*Avoidable and Mitigable attacks (from the defense sheet; what portion of attacks coming at you can be avoided (dodged) or mitigated (via armor). I made up numbers, but it might be worth making those adjustable.)
Another thing that would be worth having is a display somewhere that indicates if the current gear input is over the hit cap, and by how much; I specifically coded the sheet so that it doesn't immediately drop the score of all your gear with hit rating just because you're at the hit cap; but because of this, you can't easily tell if you're above the hit cap. As such, there probably should be a warning button for it.
For that matter, having a display that indicates what cycle it is using for combat swords would probably make sense.
Basically, in needs a summary screen at the front that gives easy access to most important features and information, such that people don't need to much around in the bowels of the sheet to get useful information out of the sheet.
...I just realized I named off an awful lot of features that I'd like to see. Don't feel obligated to do all this - I'm just sort of making a wish list. But any help you (or anyone) wishes to provide with improving the usability of the sheet would be appreciated, as if you wait for me to figure out enough Excel to get it running, you're gonna be in for a long wait
.