07-08-2010, 20:46
|
#71
|
Senior Member+
Join Date: Sep 2008
Location: South(ish) Preston
Posts: 4,178
Liked: 1342 times
Rep Power: 2105040
|
Re: Prediction League Game 1; Aldershot (home)
Quote:
Originally Posted by Chimer
Hi Baggy
I probably will use Jimbo's format but what takes the time is working out how to compare the actual score with 60 odd guesses recorded over the previous week, score them according to the rules and produce a table covering all the weeks of the season to date, all automatically. Word doesn't do any of that for you.
It's easy to do it by hand as a one-off but over 46 games the effort to automate is well worth it. Excel can do what's needed, if I get it right, and the fun for me is in getting it right (I know, I should get out more). So far I've got to the stage where I can get your names and the total points out in the right order, but I also want to be able to add the extra columns Jimbo provided.
Which will take a little longer ...
|
Cart on Chimer! 
|
|
|