Jump to content

Best 18

old55
in Melbourne Demons

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.

  • Quote
    •  

    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? :)

  • Quote

    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 :))

  • Quote
    •  

    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)

  • Quote

    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.

  • Quote

    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.

  • Quote

    That's excellent.

    Great work Eth, appreciate the effort.

  • Quote

    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?

  • Quote
    •  

    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.

  • Quote

    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.

  • Quote

    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 ?

  • Quote

    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.

  • Quote
    • 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

  • Quote

    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.

  • Quote

    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.

  • Quote

    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:

  • Quote

    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:

  • Quote

    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....

  • Quote

    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!

  • Quote

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

    Hence..High Tower DA. :P

  • Quote

    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 ...

    Edited by Range Rover

  • Quote

    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 :)

  • Quote
    •  

    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.

  • Quote
    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 :)

  • Quote

    • Archived

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

    Go to topic listing

    Featured Content

    • GAMEDAY: St. Kilda

      It's Game Day and there are only 5 games to go. Can the Demons find some consistency and form as they stagger towards the finish line of another uninspiring season?

        • Haha
        • Like
      • 566 replies
      Demonland

    • PREVIEW: St. Kilda

      It seems like only yesterday that these two sides faced off against each other in the centre of the continent. It was when Melbourne was experiencing a rare period of success with five wins from its previous six matches including victories over both of last year’s grand finalists.  Well, it wasn’t yesterday but it was early last month and it remains etched clearly in the memory. The Saints were going through a slump and the predicted outcome of their encounter at TIO Traeger Park was a virtual no-brainer. A Melbourne victory and another step closer to a possible rise into finals contention. Something that was unthinkable after opening the season with five straight defeats.

      • 5 replies
      Demonland

    • REPORT: Carlton

      I am now certain that the decline in fortunes of the Melbourne Football Club from a premiership power with the potential for more success to come in the future, started when the team ran out for their Round 9 match up against Carlton last year. After knocking over the Cats in a fierce contest the week before, the Demons looked uninterested at the start of play and gave the Blues a six goal start. They recovered to almost snatch victory but lost narrowly with a score of 11.10.76 to 12.5.77. Yesterday, they revisited the scene and provided their fans with a similar display of ineptitude early in the proceedings. Their attitude at the start was poor, given that the game was so winnable. Unsurprisingly, the resulting score was almost identical to that of last year and for the fourth time in succession, the club has lost a game against Carlton despite having more scoring opportunities. 

      • 3 replies
      Demonland

    • CASEY: Carlton

      The Casey Demons smashed the Carlton Reserves off the park at Casey Fields on Sunday to retain a hold on an end of season wild card place. It was a comprehensive 108 point victory in which the home side was dominant and several of its players stood out but, in spite of the positivity of such a display, we need to place an asterisk over the outcome which saw a net 100 point advantage to the combined scores in the two contests between Demons and Blues over the weekend.

      • 0 replies
      Demonland

    • PREGAME: St. Kilda

      The Demons come face to face with St. Kilda for the second time this season for their return clash at Marvel Stadium on Sunday. Who comes in and who goes out?

        • Like
      • 310 replies
      Demonland

    • PODCAST: Carlton

      The Demonland Podcast will air LIVE on Tuesday, 22nd July @ 8:00pm. Join Binman & I as we dissect the Dees disappointing loss to Carlton at the MCG.
      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.
      Listen LIVE: https://demonland.com/

        • Haha
        • Love
        • Like
      • 40 replies
      Demonland
    View All