For those of you interested, I've put a version of my vote modeler spreadsheet on Google docs. I figured this was better for keeping track of my votes at work too :)
You can find it here.
If you haven't seen it before, the spreadsheet is designed to show you how many votes of a given value you will need to reach a particular score.
To use it just keep track of your number of votes in column A and your score in column B, it will calculate the rest for you. Column E will show the average of the votes received since your last update, column F (and Q) show the number of future votes, and columns G to P show what your score would be if the votes were of a particular value.
To give an example, if I wanted to see what would happen if my next 10 votes received were 9's (or averaged 9 overall), I would look down column F to find "10", then across from there to column O (the "9 vote" column), and that would show me what my score would be with ten "9" votes. Alternatively, if I wanted to see what my score will be given any possible next vote, I just look at column F for "1" and then look across at each column to see what the score will be if I get that vote.
Unfortunately there's a couple of limitations of the Google Docs version. It's impossible to format a cell based on the value of another cell so the values in R2 and S2 don't actually do anything yet, hopefully they add that in future. Instead, to use the conditional formatting on the scores so that your target scores show up in different colours, select columns G through to P, go to Format menu and select "Change colours with rules..." and enter your target high and target low values in there. Make sure if doing this that you enter the target low and high in the "less than" and "greater than" boxes as well as the "is between" boxes.
I've shared the doc but to actually use it you will need to be signed into Google and then select "Make a copy" from the file menu.
That's all, hope any of you as score obsessive as me enjoy :) |
