Perfect SuperCoach

Joined
21 Apr 2018
Messages
12
Likes
48
#61
Answering my own question I just checked the weekly overall rankings for the GHOST team, they seem to have cracked the top ten 4 times (3 times before the bye)

Rd Pts Total Overall Rank
1 2413 2413 ??
2 2324 4737 ??
3 2322 7059 eq560th
4 2249 9308 eq89th
5 2196 11504 eq234th (lowest rank post the early rounds)
6 2369 13873 10th (9=13876)
7 2280 16153 25th (24=16155)
8 2324 18477 8th (7=18479)
9 2348 20825 3rd (2=20945) season high overall rank
10 2368 23193 22nd (21 = 23195)
11 2221 25414 10th (9th = 25421)

12 1467 26881 eq33rd
13 1731 28612 81st (eq79 = 28616) a big fall over the first 2 bye rounds
14 1992 30604 67th (66=30606)

15 2527 33131 20th(19=33134)
16 2519 35650 10th (9=35658)
17 2354 38004 30th (29=38008)
18 2365 40369 58th (57=40373)
19 2480 42849 52nd (51=42852)
20 2548 45397 65th (64=45404)
21 2299 47696 103rd (102=47699) big weekly fall
22 2754 50450 39th (37=50464) massive 1 week jump
23 2485 52935 eq77th another big weekly fall
This is amazing. Good work!
 

Beg2Differ

Rising Star Winner
Joined
22 Oct 2014
Messages
371
Likes
141
AFL Club
North Melb.
#62
Hi @IDIG,

1. How do you actually do it?

As I say in the article I use a branch of maths calling Mixed Integer Programming (MIP). I am trying to throw together an academic paper on it so I'll share that if I ever get around to it / if it ever gets published.

2. How long does it take you?

The optimal team one was reasonably straight forward so maybe a weekend to work out and code all of it up. I did that one last year and the rules didn't change so this year it took me maybe an hour to get everything set up again and then it took the computer about 12 hours to solve. The ghost team one was a lot trickier to model because of the emergencies so was thinking about it for a while but once I worked it out it took maybe 2-3 hours to code up and the computer 19 hours to solve. But yeah now I have it so next year I can just run it.

3. How did this all come about?

Like most obscure things, I bet a mate at the pub that I could work it out. Also came at a point during my PhD were nothing was working so needed to prove to myself that I could at least work this stuff out.

4. What else could this type of works be beneficial for in the 'real world' (ie. business, etc)

An example that might interest the users on this site is sport scheduling. So my colleagues at Monash are currently working with the Indian Premier League (IPL) to come up with the schedules that are fair on all the teams but also take into account stuff like ensuring players aren't away from home for too, popular matches are played during prime time, etc. My PhD is trying to apply it to schedule lab robotics more efficiently.

5. Can you put together next year's winning team for me and i'll split the $10k first prize with you?

That is essentially what happened with my brother. He got off to a ripper start so we decided to start plugging in the projections. The projections were pretty rubbish but still helped balance the side before byes and also recommended Angus Brayshaw pretty early on which was cool.


I am going to go with 9 :)
Hi Stevedwards

I am very impressed by your work here and am very interested in understanding more about it in regard to a specific applications I have grappled with for some time. I have sent you a private message in that regard and would appreciate any thoughts you may have.
 

chels

Rising Star Winner
Joined
8 Jan 2015
Messages
287
Likes
59
AFL Club
Sydney
#63
Hi @IDIG,

1. How do you actually do it?

As I say in the article I use a branch of maths calling Mixed Integer Programming (MIP). I am trying to throw together an academic paper on it so I'll share that if I ever get around to it / if it ever gets published.
Steve, I assume you have looked at the literature on cabin and flight crew rostering? It goes back to at least the '80's and (now) utilises MIP. Prof David Ryan at the University of Auckland's Department of Engineering Science has done excellent work both practical and published. He is a very approachable guy.

I always get a laugh when the afl tells us how dfficult it is to produce the fixture list. The constraints at (large) airlines are IMO somewhat more complex.
 
Joined
21 Apr 2018
Messages
12
Likes
48
#65
Steve, I assume you have looked at the literature on cabin and flight crew rostering? It goes back to at least the '80's and (now) utilises MIP. Prof David Ryan at the University of Auckland's Department of Engineering Science has done excellent work both practical and published. He is a very approachable guy.

I always get a laugh when the afl tells us how difficult it is to produce the fixture list. The constraints at (large) airlines are IMO somewhat more complex.
Not familiar with Prof David Ryan but am familiar with applying MIP to rostering and have seen some pretty amazing stuff being doing by the big airlines on that as well as flight planning. Will look into him. Yeah agree the fixture list for the AFL shouldn't be too hard to do fairly.
 

randomcliche

Rising Star Nominee
Joined
3 May 2017
Messages
118
Likes
59
AFL Club
Hawthorn
#66
This is amazing. Good work!
I second your thoughts, but about your work!

Hi Steve

I've got a question that I'd like to solve. 'What is the best starting structure?' If we could mix various phantom premiums, mid pricers, rookies with expected returns, would it be better to start a 0-22-8 or say a 13-0-17 type structure, or something in between like what I'm looking at 10-6-14 (premo-midP-rookie).

Def/Fwd premiums avg 110, mid ruck premiums 120, use the magic number (5428.64) for their prices.
Rookies, say average 60, a magic number of about 1.900 s.t price.
Mid-pricers, have say a magic number of say 3,333. (300kish)

It's a question I'd dearly love answered.

Regards
Andrew
 
Last edited:
Top