theplayer11 wrote:I would suggest you go back to color coding the MDP Rank tab. In my mocks, I used the MDP tiers tab to identify a player and then would try to find his MDP or stats by using the MDP Rank tab. Having BOTH color coded made this fairly easy. For example, say I wanted to see Carlos Lee's MDP or stats. I see he is a Tier 3 OF and coded in green on the MDP Tiers tab. With both coded, I would quickly scan the green in the MDP Rank tab and easily find him. Without the color coding now, it makes it extremely hard to quickly find players. Again, I would strongly suggest you bring back the color coding. What was the reason you took it away?
We had to take the color coding away in order to accomodate proper stat sorting. Initially we had formulas in each stat cell that would show blanks in the hitting stats if the player was a pitcher and vice versa for hitters. The problem though with having blanks was that if you go to sort say HRs in descending order so that you could see the top HR hitters, it was putting the blanks at the top - meaning that it was listing all of the pitchers first so you would have to scroll down 300+ rows just to see the hitters which isn't very intuitive.
So, instead of using blanks we put either 0, -1, or 999.99 in the case where the stat didn't apply in order to preserve the sorting. And then we did some conditional formatting to make the font color match the cell background color. That worked all well and good if you didn't do any sorting. But, if you then wanted to sort, the font color stays the same even though the background changes which was exposing those dummy values and making it more disruptive.
So, it came down to us having to sacrifice looks for functionality.
One thing that we might try doing and I need to test would be to add the rank number to the tier sheet so that you could then have a reference between the cells. But again, I would need to test that.