2015 premier league predictions Excel spreadsheet
We have created a 2015 Premier League predictions spreadsheet to use in an office pool or sweepstakes. So when the know-it-all claims that they can predict who will win what you can get them to put there money where their mouth is.
Related: Try out the 2015 Rugby World Cup Sweepstakes spreadsheet
Do you think Manchester United will recovery or will Manchester City win again. Will Chelsea be the one to beat or have Arsenal finally got it right? What about a Liverpool without their bite! Now you can document everyone’s opinions and see who actually knows what they are talking about.
Using some clever Excel techniques we have made it possible to run a sweepstakes where people can make there predictions (easily) and then sit back and watch the results roll in.
To avoid the problem of people not wanting to enter all the results we have included a ‘Guess the Rest’ feature. So you can predict the results for the matches of your favourite teams (e.g. Manchester United, Liverpool, Chelsea and Manchester City) match by match. Then you can rank the teams and specify what the benefit of each team playing at home is. Then, using Excel’s RANDBETWEEN function you can guess the rest of the results and choose the final league table that makes most sense to you (watch the video clip to see how this works).
Once you have your specific predictions and the ‘Guess the Rest’ predictions you can go back and change the predictions with a Hyperlink that takes you to the correct spot.
The organiser of the spreadsheet has a master file that makes it easier to update the results and see who is leading the sweepstakes.