So, to recap, lots of time on my hands. Developing a model to predict champs league draw - bordering on obsession.
I added a random 'football' factor into the draws to mix up the teams who come through each qualifying round. Previously this has been based purely on UEFA coefficients.
The teams with the higher co-efficients are still more likely to get through however this does throw up some more random (and fun) outputs.
I ran the model about 50 times before the right set of results came out for City to sneak into POT2. This involves a lot of low coefficient teams coming through qualifying. We ended up with
Group 6 Team Country COEF
POT16 Barcelona Spain 157.605
POT26 Man City England 70.535
POT36 FC Basel Switzerland 59.785
POT46 Steaua Bucharest Romania 35.604
In other more fun news, we have had some teams who have no right to get into the group phases sneak through,
Group 8 Team Country COEF
POT18 Barcelona Spain 157.605
POT28 Marseille France 78.8
POT37 Man City England 70.535
POT48 Sutjeska Niksic Montenegro 1.3
In one running, EB Strymur, who enter in the first qualifying round made it through to the Play-Off round.
If anyone else wants to geek out at some excel modelling PM me and ill send it over.