How to use Excel to win your soccer pool
This video shows how I used the English Premier League match predictions from fivethirtyeight.com to make my picks for my EPL pool. Hooary for open data! : )
00:00 Introduction
02:36 538 data
08:08 Data clean-up (adding the match week)
13:14 Calculating expected points
19:30 Optimizing score with Solver