Football prediction spreadsheet

[skully43]

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

 

[PGuru]

OK, that's done, I can't upload from work so will try and do it tonight after college.

If you have a specific number of contestants let me know & I'll add the sheets and re-do the table.

 

[skully43]

Formula

thank for that, really appreceate it, I am currently running two competitions, one with 7 people in it and another with 45!

drop us an email at ashley_37uk@hotmail.com if your ever looking for work we always have openings here for good staff

 

[PGuru]

OK, two custom sheets, now with negative scoring and a table that has the leader at the top (!)

Thanks for the kind words, although I'm not sure making these qualifies me as "good staff"!!

http://www.sendspace.com/file/o5bre9 (7 contestants)

http://www.sendspace.com/file/fn06u5 (45 contestants)

 

[skully43]

Spread Sheets

These two spread sheets are exactly what I need, thanks very much for doing this, really appreceated

Ash