Best 18

[ox_5 163]

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.

[Deestroy All 14,262]

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?

[Eth 4]

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 )

[Roger Mellie 3,692]

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)

[Eth 4]

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.

[Eth 4]

Double post...

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

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

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

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

[Deestroy All 14,262]

That's excellent.

Great work Eth, appreciate the effort.

[Keyser Söze 0]

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?

[Eth 4]

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.

[Deestroy All 14,262]

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.

[H_T 2,941]

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 ?

[Deestroy All 14,262]

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.

[Roger Mellie 3,692]

Brilliant work eth

[ox_5 163]

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

[H_T 2,941]

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.

[Eth 4]

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.

[Eth 4]

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.

[Eth 4]

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.

[H_T 2,941]

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

[Deestroy All 14,262]

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!

[H_T 2,941]

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

Hence..High Tower DA.

[Range Rover 1,935]

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.

3 lousy points dang it!

Fev was not a great pick in hindsight ...

Edited March 27, 2011 by Range Rover

[Eth 4]

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

[Carlos Danger 380]

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 4]

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