View Single Post
Old 07-08-2010, 20:43   #70
Chimer
Senior Member+
 
Chimer's Avatar
 

Re: Prediction League Game 1; Aldershot (home)

Quote:
Originally Posted by Bagpuss View Post
If you want to save time just use Jimbo's format, he used Word, simple layout but it worked, it will give you some time to sort your own out.
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 ...
__________________
Zero Tolerance of Intolerance
Chimer is offline   Reply With Quote