Challenge League Homepage V

First topic message reminder :

---

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	_________

ya'll look the same to me

woohoo upto 42.5m, Ronaldo fund coming along nicely

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?

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

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

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.

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

Results from the 3 remaining games...

WELLINGTON v PERTH

BRISBANE V MELBOURNE VICTORY

WANDERERS V SYDNEY

Everyone can add £1.5m, thanks Hero.

Thanks for that hero

Might be sacrificing belotti too

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?

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!

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

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

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

as if Niang doesn't make team of the week

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]

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

Yep

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

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.

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?

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.

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

Can we go back to Bam drawing my injuries so thats Lenglet, Koulibaly and Abdennour right?

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?

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.

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

Morning all

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

Going to regret saying this but go on then.

yo

word up

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

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

we cool, I need you to be cool

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)

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

Anyone want Davies or Dolberg?

Caldara is interesting

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

Dealings done. Doing tactics at lunch. Good luck afro

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

You decimated my back four

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

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

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

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

I don't know who to sign

One of my players!

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

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.

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

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