Jump to content

Best 18

Featured Replies

I've already got that in. And I'm using your final 6 method.

Thing is, should we do 18 rounds (2 games against each team) or 21 (same as 18 with three extra random games)?

Play each other twice in my opinion if you want to run with a fixture.

 

Play each other twice in my opinion if you want to run with a fixture.

Think that's the way to go, 18 rounds then start our finals.

Did I accidentally type Malceski?? I meant to type Gary Rohan, we can fix that up, right? :)

Think that's the way to go, 18 rounds then start our finals.

I've already typed all the formulas for 21 rounds though. Besides, with 18 rounds and 3 week finals, there's 3 weeks missing.

Talking about the formulas, the spreadsheet's nearly done. I'm going to make the captains worth double points too - if you didn't select a captain I chose the player with the best leadership experience - for example, with Deez Nutz I chose Sam Mitchell, because he has been the longest reigning captain out of the 18. (I picked him over Gary Ablett, mind you :))

 

I've already typed all the formulas for 21 rounds though. Besides, with 18 rounds and 3 week finals, there's 3 weeks missing.

Talking about the formulas, the spreadsheet's nearly done. I'm going to make the captains worth double points too - if you didn't select a captain I chose the player with the best leadership experience - for example, with Deez Nutz I chose Sam Mitchell, because he has been the longest reigning captain out of the 18. (I picked him over Gary Ablett, mind you :))

Nice work eth. Would it be difficult to run both systems. Ie. DA's team v team and an overall points system? My understanding is that both require the same info (points per player)

Nice work eth. Would it be difficult to run both systems. Ie. DA's team v team and an overall points system? My understanding is that both require the same info (points per player)

I'm already running both, the ladder features a 'points for' category - I had to include that to do the percentage.

Will post screenshots when I'm completely finished.


Double post...

fixture.jpg

Here's a little bit of the fixture. Each of those zeroes redirects to...

90543006.jpg

...this. The weekly scores are added up here in different sheets (R1, R2, R3 etc.) and the formulas shown in the top of the first image grab that and put it in the fixture.

ladderbg.jpg

Finally, the ladder. It says #DIV/0! because there's no scores in yet :P

I should give this to my IT teacher for bonus marks...somewhere.

That's excellent.

Great work Eth, appreciate the effort.

A lot of effort put in, which is great...

But what is the point?

My understanding is that most teams will miss players accruing points due to injury, & with no emergencies, this will create an imbalance.

The best performed team could get that mantle purely by the luck of having the least injuries, even if it is the "worst" team.

No?

 

The point is that considering there's no way to actually get these players to compete in a 10 team league, Supercoach s as close as we're going to get.

And injuries are bad luck and will happen to everybody, some worse than others. It happens in the AFL as well.

Anyway, I'm computer savvy, so it didn't take too long. Most of my time was spent on Facebook.

A lot of effort put in, which is great...

But what is the point?

My understanding is that most teams will miss players accruing points due to injury, & with no emergencies, this will create an imbalance.

The best performed team could get that mantle purely by the luck of having the least injuries, even if it is the "worst" team.

No?

You need luck to win a flag, this is no different.

It's just for a bit of fun and bragging rights. Except if I win, then it was totally serious and proves how awesome I am.


A lot of effort put in, which is great...

But what is the point?

My understanding is that most teams will miss players accruing points due to injury, & with no emergencies, this will create an imbalance.

The best performed team could get that mantle purely by the luck of having the least injuries, even if it is the "worst" team.

No?

Just a bit of fun KS. Besides, I'm sure e25 will be 100% supportive of it. He may even get bragging rights if his side is any good. ;)

Great job eth38.

DA, is this what you had in mind much earlier in the thread ?

DA, is this what you had in mind much earlier in the thread ?

What, winning and proving how awesome I am? Absolutely!

Oh, the season format... Yep pretty much spot on. Should be interesting.

Loving eth38's work.

  • 2 weeks later...

So whats the go with this Eth?

All I know is that my players from the first 2 games have dominated with their supercoach scores!

Taylor - 130

Enright - 120

N.Riewoldt - 83

J. Riewoldt - 122

R. Warnock - 117

So whats the go with this Eth?

All I know is that my players from the first 2 games have dominated with their supercoach scores!

Taylor - 130

Enright - 120

N.Riewoldt - 83

J. Riewoldt - 122

R. Warnock - 117

Good start ox_5.


So whats the go with this Eth?

All I know is that my players from the first 2 games have dominated with their supercoach scores!

Taylor - 130

Enright - 120

N.Riewoldt - 83

J. Riewoldt - 122

R. Warnock - 117

Nice work.

I'll release the scores at the end of the round.

Okay, just re-doing some stuff that I missed since the last save, and I've got all the scores excluding the game currently in progress.

I can tell you guys two things - it's low scoring (1100 seems to be an average score) and my team's having an absolute shocker. I'm missing Harbrow, Drummond, Pears, Hodge, Gilbee and Byrnes. :wacko:

ROUND 1

Results

Trengove (1117) def by Ox_5 (1310)

Eth38 (1034) def by High Tower (1527)

Deez Nutz (1247) def Range Rover (1244)

Roger Mellie (1283) def The Master (1163)

E25 (1290) def by Deestroy All (1377)

Headlines

Ox's Oxen too good for Trengove

Injury-hit Eth38 thumped by the HT Highlanders

Deez Nutz snatch thriller from the Royals

RMCT victorious over The Master's Masters

DAFC defeat Enforcers in close encounter

Ladder

High Tower, 4, 147.68%

Ox_5, 4, 117.28%

Roger Mellie, 4, 110.32%

Deestroy All, 4, 106.74%

Deez Nutz, 4, 100.24%

Range Rover, 0, 99.76%

E25, 0, 93.68%

The Master, 0, 90.65%

Trengove, 0, 85.27%

Eth38, 0, 67.71%

The week ahead

High Tower vs Trengove

Range Rover vs Ox_5

The Master vs Eth38

Deestroy All vs Deez Nutz

E25 vs Roger Mellie

Anyway, that was a triple post. :blink:

Where's Baghdad Bob, e25 & Co. with their assumptions that Dean Cox has had it !? One of his best games ever! BOG.

Try some humble pie.

Thought my team could score a bit more than a paltry 1500-odd.

Will have to improve next week....

Where's Baghdad Bob, e25 & Co. with their assumptions that Dean Cox has had it !? One of his best games ever! BOG.

Big Cox and a big score, makes you the big Dick HT, well done!


Big Cox and a big score, makes you the big Dick HT, well done!

Hence..High Tower DA. :P

ROUND 1

Results

Trengove (1117) def by Ox_5 (1310)

Eth38 (1034) def by High Tower (1527)

Deez Nutz (1247) def Range Rover (1244)

Roger Mellie (1283) def The Master (1163)

E25 (1290) def by Deestroy All (1377)

Headlines

Ox's Oxen too good for Trengove

Injury-hit Eth38 thumped by the HT Highlanders

Deez Nutz snatch thriller from the Royals

RMCT victorious over The Master's Masters

DAFC defeat Enforcers in close encounter

Ladder

High Tower, 4, 147.68%

Ox_5, 4, 117.28%

Roger Mellie, 4, 110.32%

Deestroy All, 4, 106.74%

Deez Nutz, 4, 100.24%

Range Rover, 0, 99.76%

E25, 0, 93.68%

The Master, 0, 90.65%

Trengove, 0, 85.27%

Eth38, 0, 67.71%

The week ahead

High Tower vs Trengove

Range Rover vs Ox_5

The Master vs Eth38

Deestroy All vs Deez Nutz

E25 vs Roger Mellie

Anyway, that was a triple post. :blink:

3 lousy points dang it!

Fev was not a great pick in hindsight ...

3 lousy points dang it!

Fev was not a great pick in hindsight ...

It's alright, you get to play Nutz three times this season :)

 

3 lousy points dang it!

Fev was not a great pick in hindsight ...

No Chapman, no Ablett and team-mates taking each other out of the game early in Rance's hit on Waite, things could have gone down a lot differently. And Sherman as a sub for Footscray? Shocking call and can certainly say that was one of the many reasons why the Doggies got flogged today, the old 'Rocket' is certainly not synonymous with 'premiership'.

Eth, love your work, doing a great job. Are there captains in this thing? If so, Dane Swan is my guy.

Eth, love your work, doing a great job. Are there captains in this thing? If so, Dane Swan is my guy.

Thanks mate. I've got Sam Mitchell as your captain solely for the fact he's the most experienced in terms of leadership in your 18.

I'm not going to change it unless your opponents think it's OK for me to change it - you didn't list a captain originally, I'm aware of that :)


Archived

This topic is now archived and is closed to further replies.

Featured Content

  • PREVIEW: Richmond

    A few years ago, the Melbourne Football Club produced a documentary about the decade in which it rose from its dystopic purgatory of regular thrashings to the euphoria of a premiership victory. That entire period could have been compressed in a fast motion version of the 2025 season to date as the Demons went from embarrassing basket case to glorious winner in an unexpected victory over the Dockers last Saturday. They transformed in a single week from a team that put in a pedestrian effort of predictably kicking the ball long down the line into attack that made a very ordinary Bombers outfit look like worldbeaters into a slick, fast moving side with urgency and a willingness to handball and create play with shorter kicks and by changing angles to generate an element of chaos that yielded six goals in each of the opening quarters against Freo. 

      • Thanks
      • Like
    • 0 replies
    Demonland
  • NON-MFC: Round 07

    Round 7 gets underway in iconic fashion with the traditional ANZAC Day blockbuster. The high-flying Magpies will be looking to solidify their spot atop the ladder, while the Bombers are desperate for a win to stay in touch with the top eight. Later that evening, Fremantle will be out to redeem themselves after a disappointing loss to the Demons, facing a hungry Adelaide side with eyes firmly set on breaking into the top four. Saturday serves up a triple-header of footy action. The Lions will be looking to consolidate their Top 2 spot as they head to Marvel Stadium to clash with the Saints. Over in Adelaide, Port Adelaide will be strong favourites at home against a struggling North Melbourne. The day wraps up with a fiery encounter in Canberra, where the Giants and Bulldogs renew their bitter rivalry. Sunday’s schedule kicks off with the Suns aiming to bounce back from their shock defeat to Richmond, taking on the out of form Swans.Then the Blues will be out to claim a major scalp when they battle the Cats at the MCG. The round finishes with a less-than-thrilling affair between Hawthorn and West Coast at Marvel. Who are you tipping and what are the best results for the Demons?

    • 3 replies
    Demonland
  • REPORT: Fremantle

    For this year’s Easter Saturday game at the MCG, Simon Goodwin and his Demons wound the clock back a few years to wipe out the horrible memories of last season’s twin thrashings at the hands of the Dockers. And it was about time! Melbourne’s indomitable skipper Max Gawn put in a mammoth performance in shutting out his immediate opponent Sean Darcy in the ruck and around the ground and was a colossus at the end when the game was there to be won or lost. It was won by 16.11.107 to 14.13.97. There was the battery-charged Easter Bunny in Kysaiah Pickett running anyone wearing purple ragged, whether at midfield stoppages or around the big sticks. He finish with a five goal haul.

      • Love
      • Thanks
    • 0 replies
    Demonland
  • CASEY: UWS Giants

    The Casey Demons took on an undefeated UWS Giants outfit at their own home ground on a beautiful autumn day but found themselves completely out of their depth going down by 53 points against a well-drilled and fair superior combination. Despite having 15 AFL listed players at their disposal - far more than in their earlier matches this season - the Demons were never really in the game and suffered their second defeat in a row after their bright start to the season when they drew with the Kangaroos, beat the Suns and matched the Cats for most of the day on their own dung heap at Corio Bay. The Giants were a different proposition altogether. They had a very slight wind advantage in the opening quarter but were too quick off the mark for the Demons, tearing the game apart by the half way mark of the term when they kicked the first five goals with clean and direct football.

      • Thanks
    • 0 replies
    Demonland
  • PREGAME: Richmond

    The Dees are back at the MCG on Thursday for the annual blockbuster ANZAC Eve game against the Tigers. Can the Demons win back to back games for the first time since Rounds 17 & 18 last season? Who comes in and who goes out?

      • Thanks
    • 238 replies
    Demonland
  • PODCAST: Fremantle

    The Demonland Podcast will air LIVE on TUESDAY, 22nd April @ 8:00pm. Join Binman, George & I as we analyse the Demons first win for the year against the Dockers. Your questions and comments are a huge part of our podcast so please post anything you want to ask or say below and we'll give you a shout out on the show. If you would like to leave us a voicemail please call 03 9016 3666 and don't worry no body answers so you don't have to talk to a human.

      • Thanks
    • 47 replies
    Demonland