Hi, I am trying to put together an Excel spreadsheet for a football compitition I am running at work but quite honestly really do not know where to start. I will try and give you a brief outline of how the compition works Simply predict the final position of every team in the Premiership, plus the top three in the Championship, League One and League Two. Also, predict the winners and runners-up in the FA Cup and League Cup.
Scoring System
You score points based on the difference between your predictions and their actual positions. For example, if you were to predict Reading to end 13th and they end 19th, then you score 6 points. Similarly, if you were to predict West Ham to end 1st and they end 9th, then you score 8 points. In the FA Cup and League Cup, points are scored based on which round your prediction is knocked out of the competition.
what I am after is a spreadsheet that I can enter scores throughout the season and that works out where the people in the compition currently stand
any help very very gratefully recieved
Ash
Scoring System
You score points based on the difference between your predictions and their actual positions. For example, if you were to predict Reading to end 13th and they end 19th, then you score 6 points. Similarly, if you were to predict West Ham to end 1st and they end 9th, then you score 8 points. In the FA Cup and League Cup, points are scored based on which round your prediction is knocked out of the competition.
what I am after is a spreadsheet that I can enter scores throughout the season and that works out where the people in the compition currently stand
any help very very gratefully recieved
Ash