Top 4 baby!!!
Lots of variance in the ladders! I like it.
Honestly found this year harder to pick than last year. I could be a genius… the more likely scenario is that I’ll be somewhere down the bottom of the ladder haha
Best of luck to everyone!
Predicted Ladder
Selection
Brisbane Lions 21
Geelong Cats 21
Melbourne 20
Richmond 17
Sydney Swans 16
Port Adelaide 16
Carlton 14
Fremantle 13
Essendon 12
Western Bulldogs 11
GWS Giants 9
Adelaide Crows 8
Gold Coast Suns 8
Collingwood 7
West Coast Eagles 6
St Kilda 5
Hawthorn 2
North Melbourne 1
That is pure evil!
Unless of course they go out in straight sets.
Bump.
Not long left to get those entries in!!!
All done! Thanks again for organising!
Club | Wins |
---|---|
Brisbane Lions | 19 |
Geelong Cats | 18 |
Melbourne | 18 |
Sydney Swans | 18 |
Richmond | 16 |
Western Bulldogs | 16 |
Port Adelaide | 15 |
Carlton | 15 |
Essendon | 14 |
Fremantle | 13 |
Collingwood | 11 |
Adelaide Crows | 8 |
Gold Coast Suns | 7 |
St Kilda | 5 |
West Coast Eagles | 5 |
North Melbourne | 4 |
GWS Giants | 3 |
Hawthorn | 2 |
Alot of the ladders that I’ve seen are quite similar. Could be a crowded leaders board heading into the final rounds. I’m looking forward it. I hate to say it but I need Brisbane to have a brilliant season, I think I may have gone too hard on them but it’s too late now. On with the show.
I am useless with Excel - how do you do that, add up the wins for each team on Excel?
I’m probably not much better…I just manually counted the wins on a piece of paper…and then put the details into a Excel with borders around the data.
Thank the lord. I wanted to ask the same question but didn’t want you to show me up with your elite Excel skills.
You should get emailed a ladder from me after your entry is processed.
Genuine lols
Ahh, I wanted to do the ladder before I send it - all good, I just emailed you and thanks!
Use the COUNTIF function
I went for a super simple formula this year - instead of picking game by game I just did my predicted ladder first, then chose the winner of each game automatically based on who was higher on the ladder. Could be hilariously bad.
As a former winner (gloat, gloat), be very afraid as this is clearly the only ladder compiled with a genuine lack of thought and foresight, so should win comfortably.
Sydney Swans | 19 |
---|---|
Geelong Cats | 19 |
Melbourne | 17 |
Carlton | 17 |
Richmond | 16 |
Brisbane Lions | 16 |
Port Adelaide | 15 |
Fremantle | 14 |
Collingwood | 13 |
Western Bulldogs | 12 |
Essendon | 11 |
Gold Coast Suns | 10 |
West Coast Eagles | 6 |
St Kilda | 6 |
GWS Giants | 5 |
Hawthorn | 4 |
Adelaide Crows | 3 |
North Melbourne | 3 |
Draw | 1 |
11 wins for us. Looks legit.
Selection | Tips |
---|---|
Melbourne | 21 |
Brisbane Lions | 20 |
Geelong Cats | 19 |
Collingwood | 18 |
Richmond | 17 |
Fremantle | 16 |
Sydney Swans | 15 |
Carlton | 14 |
Port Adelaide | 13 |
Western Bulldogs | 12 |
Adelaide Crows | 8 |
Essendon | 8 |
GWS Giants | 7 |
St Kilda | 5 |
North Melbourne | 5 |
West Coast Eagles | 5 |
Gold Coast Suns | 3 |
Hawthorn | 1 |
Damn it, i clearly farked up if Carlton are making the 8