Quote:
Originally Posted by sangaman
Curtains I'm interested in sprucing up the spreadsheet before next season since this is getting so big. Some things will be strictly aesthetic, but two things I'd like to discuss with you and get feedback from others.
1) I'm afraid of changing the results entries since people are used to it but I have an idea that might be easier. Instead of two matrices side by side, one for each game played, we could fit everything into one matrix so all info can be seen without scrolling over. And it would require half as much data entry.
Every game results in 5 points total. One player's score is 5 - the other's. It follows that we only need one cell to contain both scores.
We could have 1 cell for each game. Game 1 is entered in the bottom left half of the matrix. Game 2 is entered in the upper right. We follow the long-standing convention that a player enters his/her own score in their row and their opponent's column.
So let's say player A beats Player B 3-2 and then A loses 1-4. Here's how it would look.
The spreadsheet can figure this out with a simple tweak that I could handle.
I think it's cleaner and a little easier BUT it might confuse people. So I'm just throwing it out there to see if people think its worth it.
2) Less controversial, but personally I'd like to see the standings sort by points instead of %. I think early in the season it's more meaningful than having someone with 0 or 1 games at the top of the standing, and I think ultimately points is what players should be ranked by. It's all the same when everyone in a group plays their game, but on the rare instances where a few games are missing I think it's fairer to rank by points. The people with games missing shouldn't rank above players who've played all their games solely based on %.
For point 2 I'm opposed, I think that in general % does a much better job of showing who is in the race to win the group and who is in the bottom. I can look at the standings right now and see a ton of groups where if it was done by points it would be completely misleading. A very simple example is in group 4, where right now monkeyrunbad would be in first above Plumbst, when I think it's pretty obvious that shouldn't be the case. That kind of erroneous placement seems a lot more important than any kind of issue where someone who played 2 games and has a high percentage happens to be at the top for a little bit.
Another example would be in Group 1 where chronick would be in first, and I'd be in second place. That's just completely ridiculous as it's obvious to anyone that my chances to win the group are monstrously lower than thegroupie's right now. To have any system where I'm currently ahead of her is just wrong in my view, and I'm not in favor of it at all. One last silly result that it would create is that JamesonPainter would be in third place right now, which makes no sense at all. Basically the point of having them ranked is so that we can get a relatively objective look at how they are doing without having to do much math. If we put them in order of points, everything will be ****ed.
As far as I can tell the current system is the most accurate way of doing things. The only other possibility would be to have some kind of combination of games played/points, but that seems overly complex and annoying.
For point 1 I'm certainly fine with any change. I'd recommend any change though be made on a test page, so I can see how easy it is to make it work. Also it's imperative that I be able to set this up every season with no more effort than what I do now. I pretty much have it down where I can setup a new season in 20-30 minutes tops, and if that number goes up to like 45-60 it will be a problem. However in general if it's something that will be easier for people to use, won't create any more work for me, is something that I'll be able to maintain each season and looks better then I'm for it. However forgive me as I am having a hard time envisioning how it will look in practice without seeing a test page first. I'm not a big google docs champion.
Thanks.
Last edited by curtains; 08-23-2012 at 11:36 PM.