Forum Discussion
Mike Schlodder
Jun 30, 2018Copper Contributor
Looking for help developing data spreadsheet for Premier League
I am wanting to develop a Premier League table movement spreadsheet for using as an office pool where it can do the following: 1. Reference (controlled) table has the listing of the 20 Premier League...
Matt Mickle
Jul 01, 2018Bronze Contributor
Yes this is definitely possible. A friend of mine used to run a weekly NFL Pool for bragging rights and he came up with this spreadsheet. It's nothing fancy but it seemed to get the job done. It's pretty basic.... it looks at the match ups for each week and if the team in Row 5 matches the team for the individual it will give them points (Column T) . It sounds like what you want to do is the opposite. If you look at this spreadsheet you can get your bearings and simply adjust it.
Please see attached for reference....