Challenge League Homepage V

by **Afro** Mon 26 Mar 2018, 11:29 am

First topic message reminder :

Welcome to the Miky Challenge League

This Week's Fixtures

Week 6
Brisbane Roar v Perth Morning Glory
Melbourne Victory v Newcastle Jets
Melbourne City v Western Sydney Wanderers
Sydney FC v Central Coast Mariners
Adelaide United v Wellington Phoenix

This Week's Key Deadlines

- 2 new Lawyers drawn on Tuesday
- Injuries drawn Wednesday
- 2 releases per week max
- Tactics due Friday

Links

https://www.twitch.tv/hero606v2

https://docs.google.com/spreadsheets/d/1VM9eIonYMyXCXpQOBjAJylh3wihazcw8RKtLLHiD8HI/htmlview#gid=1996389080

Team	_________	Manager
Adelaide United	_________	Hero
Brisbane Roar	_________	Miky
Central Coast Mariners	_________	Olly
Melbourne City	_________	Twist
Melbourne Victory	_________	Afro
Newcastle Jets	_________	Nadz
Perth Glory	_________	Marky
Sid Knee CF	_________	Nando
Wellington Phoenix	_________	Bam
WS Wanderers	_________	Tino

Match	_________	Transfer	_________	Other
Fixtures/Results	_________	Lawyers	_________	Rules
Table	_________	Foreigns	_________	Youth Rules
Injuries	_________	Releases	_________	Press Conferences
Tactics	_________	Confirmation	_________
	_________	Loans	_________

by Brooksey79 Fri 13 Apr 2018, 4:07 pm

ya'll look the same to me

woohoo upto 42.5m, Ronaldo fund coming along nicely

by **Afro** Fri 13 Apr 2018, 4:19 pm

Brooksey79 wrote:ya'll look the same to me

woohoo upto 42.5m, Ronaldo fund coming along nicely

Nadz??? - have you hacked Tino's account?

by Brooksey79 Fri 13 Apr 2018, 4:26 pm

I wanted to keep Chiesa but pretty much 35m for a player rated 77 (I think) is too good to turn down

by **Hero** Fri 13 Apr 2018, 4:26 pm

Miky still needs to bring in a freebie player for the bench.

by **Hero** Fri 13 Apr 2018, 4:31 pm

As it's past cut off for this week I've assigned a makeshift 51 rated GK on the bench for Miky. If he gets subbed on then that's how I roll.

by Brooksey79 Fri 13 Apr 2018, 4:32 pm

wishing I'd have kept Leon Bailey now rather than just binning him off

by **Hero** Fri 13 Apr 2018, 5:23 pm

Results from the 3 remaining games...

WELLINGTON v PERTH

BRISBANE V MELBOURNE VICTORY

WANDERERS V SYDNEY

by Holymiky Fri 13 Apr 2018, 6:45 pm

Everyone can add £1.5m, thanks Hero.

by Brooksey79 Fri 13 Apr 2018, 7:44 pm

Thanks for that hero

Might be sacrificing belotti too

by **Hero** Sun 15 Apr 2018, 9:41 pm

Just finishing off the spreadsheets.
Noticed it's not updating the weekly performance for some results and it's changed the team of the week. Any ideas?
Also rather than add in the players each week, takes a fair while to type in every player, would there be a way to have a team sheet for each team with Player names on the left, the weeks across the top and then just add in the ratings which then populate results, totw etc?

by BamBam Sun 15 Apr 2018, 9:51 pm

Probably the pivot tables for the weekly performance thing, just need to select relevant week

I'll have a think on the second part, any other excel whizzes feel free to have a go!

by **Hero** Sun 15 Apr 2018, 9:52 pm

Cheers, think then as well it retains player standard positions and spellings etc to avoid any deviance

by BamBam Mon 16 Apr 2018, 9:25 am

Yeah, the standard format is important

To keep it consistent, players need to be categorised as the same position every week, ie Leon Bailey should be put down as either a MID or FWD weekly

I also think everyone should be responsible for filling in their own bits on the Google Doc rather than it being up to one person, would help with consistency

by BamBam Mon 16 Apr 2018, 9:49 am

Fixed the issues in the week 2 tabs that were breaking the file - will need to recreate all the other weekly tabs this week or we'll have the same issue next week

Team of the Week

Handanovic

Lenglet Sanchez Bailly Shaw

Asensio Ozyakup Almiron Bailey

Mertens Malcolm

by Brooksey79 Mon 16 Apr 2018, 9:53 am

as if Niang doesn't make team of the week

by **Hero** Mon 16 Apr 2018, 10:43 am

Flop of the week was Ricardo Quaresma with a 5.5 rating.

[ltr]Ricardo Quaresma[/ltr]

[ltr]5.5[/ltr]

[ltr]Ricardo Quaresma[/ltr]

[ltr]5.5
[/ltr]

by **Good Golly I'm Olly** Mon 16 Apr 2018, 12:22 pm

do we all get £1.5m for week 2 tactics etc?

by BamBam Mon 16 Apr 2018, 12:24 pm

by nadeem2099 Mon 16 Apr 2018, 12:51 pm

Hero wrote:Flop of the week was Ricardo Quaresma with a 5.5 rating.

2 weeks in a row for my players Challenge League Homepage V - Page 11 3559488474

At least Bailey redeemed himself from being the flop last week to making the totw this week. The dumb subs the AI makes is doing my head in. Takes off my best player Isco and put on Harry Winkstain furious

by **Hero** Mon 16 Apr 2018, 1:02 pm

nadeem2099 wrote:
Hero wrote:Flop of the week was Ricardo Quaresma with a 5.5 rating.
2 weeks in a row for my players At least Bailey redeemed himself from being the flop last week to making the totw this week. The dumb subs the AI makes is doing my head in. Takes off my best player Isco and put on Harry Winkstain

TBF Isco did only have a 5.8 rating. Subs fecked me a lot more from bossing the first half to then taking off Asensio and Hamsik (8.8 & 7.7 rated) for Under and Bentancur.

by **Good Golly I'm Olly** Mon 16 Apr 2018, 1:04 pm

if someone can draw my injuries early, i'll get my tactics into hero today - i have no money and wont be doing anymore transactions until the weekend - and could do with doing tactics earlier than weds as im not really around much later in the week - if that is ok?

by **Hero** Mon 16 Apr 2018, 1:05 pm

Is it possible on the Season Summary page to have columns for number of games played? Just thinking that as the season goes on it should get skewered by a player who's had one game with a 9.5 rating getting POTY.

by **Hero** Mon 16 Apr 2018, 1:07 pm

There were 33 items in your list. Here they are in random order:
[list="color: rgb(0, 0, 0); font-family: tahoma, sans-serif; font-size: 12.8px; background-color: rgb(255, 255, 255);"]
[*]Clement Lenglet - £13.5m - Fifa rating = 78

[*]Kalidou Koulibaly - £36m - Fifa rating = 84

[*]Aymen Abdennour - £3.6m - Fifa rating = 77

[*]Heung-Min Son - £31.5m - Fifa rating = 87

[*]Left backs

[*]Dries Mertens - £28.8m - Fifa rating = 86

[*]Terence Kongolo - £9m - Fifa rating = 77

[*]Mario Lemina - £13.5m - Fifa rating = 77

[*]Edin Dzeko - £198m - Fifa rating = 84

[*]Amadou Diawara - £18m - Fifa rating = 77

[*]Centre backs

[*]Gervinho - £7.65m - Fifa rating = 80

[*]Sead Kolasinac - £16.2m - Fifa rating = 83

[*]Oguzhan Ozyakup - £9m - Fifa rating = 80

[*]James Maddison - £9m - Fifa rating = 74

[*]Roman Burki - £7.2m - Fifa rating = 84

[*]Sime Vrsaljko - £18m - Fifa rating = 84

[*]Jorge - £13.5m - Fifa rating = 74

[*]Giannelli Imbula - £7.2m - Fifa rating = 77

[*]Attackers

[*]Davinson Sanchez - £31.5m - Fifa rating = 81

[*]Right backs

[*]Gabriel Mercado - £4.5m - Fifa rating = 76

[*]Patrick Roberts - £6.75m - Fifa rating = 73

[*]Goalkeepers

[*]Bartosz Bialkowski - 500k - Fifa rating = 75

[*]Midfielders

[*]Malcom - £27m - Fifa rating = 82

[/list]
IP: 195.62.222.38
Timestamp: 2018-04-16 12:07:02 UTC

SORRY!!

by **Good Golly I'm Olly** Mon 16 Apr 2018, 1:09 pm

Can we go back to Bam drawing my injuries Laugh

so thats Lenglet, Koulibaly and Abdennour right?

by BamBam Mon 16 Apr 2018, 1:15 pm

Hero wrote:Is it possible on the Season Summary page to have columns for number of games played? Just thinking that as the season goes on it should get skewered by a player who's had one game with a 9.5 rating getting POTY.

Had the same thought earlier when selling Tah .. I was thinking of trying to make it so it only factored in a minimum number of games played?

by **Hero** Mon 16 Apr 2018, 1:24 pm

Good Golly I'm Olly wrote:Can we go back to Bam drawing my injuries so thats Lenglet, Koulibaly and Abdennour right?

Yep. Fortunately you do have 5 pretty decent CBs.

by **Good Golly I'm Olly** Mon 16 Apr 2018, 1:31 pm

Hero wrote:
Good Golly I'm Olly wrote:Can we go back to Bam drawing my injuries so thats Lenglet, Koulibaly and Abdennour right?

Yep. Fortunately you do have 5 pretty decent CBs.

Yeah I'm well stocked albeit it has meant I've had to change what I was planning to do this week which is a shame - tactics are sent in now Smile

by BamBam Tue 17 Apr 2018, 9:09 am

Morning all

I've got time to do injuries/lawyers today if you fancy running the gauntlet Very Happy

by **Hero** Tue 17 Apr 2018, 9:15 am

Going to regret saying this but go on then.

by Brooksey79 Tue 17 Apr 2018, 9:38 am

by **Hero** Tue 17 Apr 2018, 9:45 am

word up

by BamBam Tue 17 Apr 2018, 9:45 am

Hero wrote:Going to regret saying this but go on then.

Will do this morning, can someone draw my lawyers and injuries please

by Brooksey79 Tue 17 Apr 2018, 9:50 am

we cool, I need you to be cool

by **Hero** Tue 17 Apr 2018, 9:57 am

Bam...

Lawyers:

Ben Davies - £17.8m - 81 (Spurs)

Kasper Dolberg - £13.9m - 76 (Ajax)

Injuries:

Lukasz Piszczek - £3.6m - 83 (Dortmund)

Ben Davies - £16.2m - 81 (Spurs)

Adrien Rabiot - £40.5m - 82 (PSG)

by BamBam Tue 17 Apr 2018, 10:04 am

Injuries and lawyers up .. injuries will leave you all suitably pleased I'm sure

by BamBam Tue 17 Apr 2018, 10:18 am

Anyone want Davies or Dolberg?

by Brooksey79 Tue 17 Apr 2018, 10:22 am

Caldara is interesting

by Brooksey79 Tue 17 Apr 2018, 10:25 am

if I accept my lawyers I get upto £69m hhhmmmmm

by TwisT Tue 17 Apr 2018, 10:37 am

Dealings done. Doing tactics at lunch. Good luck afro

by Marky Tue 17 Apr 2018, 10:43 am

BamBam wrote:Injuries and lawyers up .. injuries will leave you all suitably pleased I'm sure

You decimated my back four Laugh

by BamBam Tue 17 Apr 2018, 10:44 am

My randomiser clearly thought it needed livening up after the bore draws last week

by BamBam Tue 17 Apr 2018, 10:50 am

Tino, can do tactics whenever you're done with transfers, let me know bud

by Brooksey79 Tue 17 Apr 2018, 10:50 am

VVD and Barz injured that's just nasty...looks like with my departures I've got 4 CB's out

by Brooksey79 Tue 17 Apr 2018, 10:50 am

Bam they'll be in today then, does anyone wanna buy Belotti for cashola so I can buy CR7

by Brooksey79 Tue 17 Apr 2018, 11:19 am

I don't know who to sign

by **Hero** Tue 17 Apr 2018, 11:20 am

One of my players!

by Brooksey79 Tue 17 Apr 2018, 11:30 am

stupid date for a cut off when ive had more increases after that date

by **Hero** Tue 17 Apr 2018, 11:49 am

Yep already half my team I'm taking losses on if I accept lawyers. Guarantee it'll stagnate the market halfway through the season again.

by Brooksey79 Tue 17 Apr 2018, 11:59 am

took the hit now to improve, never mind it's only about 8m in my case, granted Ceballos dropping after the cut-off helped my signings today.

does promoting a youth player count towards my weekly signings

by **Hero** Tue 17 Apr 2018, 12:18 pm

Brooksey79 wrote:took the hit now to improve, never mind it's only about 8m in my case, granted Ceballos dropping after the cut-off helped my signings today.

does promoting a youth player count towards my weekly signings

Nope

by Sponsored content