Second order of business: How to score monthly points.
I know we've had a few conversations, but I've been working on a spreadsheet and I need a formula.
I think it was 3 points for correct scoreline, 1 for correct result, and nothing for being wrong?
Here is what I'm thinking. Each month someone duplicates the 'Month Template' sheet of the worksheet and names it the month in question. Postponed games get shifted to when they are played (I have a lot of space for extra games). We enter in who is playing for each match, and our picks. Then we publish the sheet for the current month so it shows up in the blog.
I think there is a feature that we can use to then protect the columns that have our predictions so they can't be changed. It probably isn't necessary to do so.
When the games are done, we enter in the scores and the points for each game and the month are automatically calculated.
I haven't been able to break it yet.
ReplyDeleteWe need a Totals Spreadsheet as well. Easier than this one.