Thanks for any advice in advance, even if you just point me in the direction of some help.
I have a bit of an issue.
I run a soccer forum online and part of that is a game where everybody guesses the scores of games and scores points for correct results.
The problem i have is it takes forever because I do all the calculations manually in my head and then type them into excel.
I need a way to automate it as it really should be a simple task, anyone know what i can do?
here is a link to the table so you know what i mean...
http://bwfcboard.sen...rboard-t270.htm
example of what we do...
we each guess the scores (17 of us) , so for example...
Bolton V Man Utd 4 - 0
Arsenal V Chelsea 2 - 1
Liverpool V Man City 3 - 2
(but there are 17 sets of results and 10 matches per set)
see here for example http://bwfcboard.sen...week-4-t257.htm
and then we wait for the results which might be in reality
Bolton V Man Utd 1 - 3
Arsenal V Chelsea 2 - 1
Liverpool V Man City 1 - 0
so i then have to go through the list and manually compare each persons predicted score to the real score and allocate points (5 points exactly right, 3 points correct result and goal difference and 1 point correct winner)then I have to add all that up write it all down into a table and redraw the finished table each time in execel.
Prediction
Bolton V Man Utd 4 - 0
Arsenal V Chelsea 2 - 1
Liverpool V Man City 3 - 2
Actual Results
Bolton V Man Utd 1 - 3 0points
Arsenal V Chelsea 2 - 1 5points
Liverpool V Man City 1 - 0 3points
But I have to do it for 17 sets of at least ten matches. Takes 2 hours minimum!
Then do the table.
I am sure I could have something such as a little form for putting the scores into and get the computer to allocate the points and even arrange the table in order of most points first? no?
Thanks for any advice, even if you just point me in the direction of some help.
Edited by jayjay23, 09 December 2009 - 05:33 AM.