General Chat 2021/22

Cartman78 · 07-04-2022 3:43pm

https://www.boards.ie/discussion/comment/118894500#Comment_118894500

A team of Gary Breens would have been better than my squad this season.... hopefully getting all my bad luck out in one vile chunk this year

Lucas Hood · 07-04-2022 4:00pm

Some formula Cartman.

=IF(ISBLANK(VLOOKUP($D5,Fixtures!$A:$AS,36,FALSE)),"BLANK",VLOOKUP($D5,Fixtures!$A:$AS,36,FALSE))

Could replace the above with this and get same result minus your formatting.

=IFERROR(VLOOKUP($D5,Fixtures!$A:$AS,36,0),"BLANK")

Cartman78 · 07-04-2022 4:14pm

Haha...yeah...it's fairly verbose alright 😂

I thankfully don't really use Excel anymore....I think that bloated formula is one I've rolled over from the original version a few years ago.

It does the job anyway for the fixtures I guess but performance would be an issue on a bigger dataset

Miley Byrne · 27-04-2022 3:02pm

https://www.boards.ie/discussion/comment/118893589#Comment_118893589

I don't suppose you would have this updated by any chance? Main opponent in my mini league has all chips used and I still have wildcard and bench boost so would like to see what his side looks like when I enter it into the spreadsheet. If not, no hassle

Green&Red · 02-05-2022 12:02am

Big GW coming up. FH & BB galore

My FH is looking like

Ederson

VVD-James - Alonso - Pereira

Madison - Mane - Foden - KDB

Werner - Richy

Tavares - Delph - 4.4 forward

Ros1234 · 02-05-2022 8:34am

I don't think there's any 4.4 forwards in the game, 4.5 is the min. With the scheduling of the Chelsea games and the FA cup final on close after, rotation might be widespread in Chelsea's 2 fixtures, TAA and Salah both have got their rests now, Robbo will probably be rested in 1 of their next 3 games, CL or 2 league games. VVD is a nice pick then, as you have. Maddison and Ricky's minutes might be managed too, keep an eye on the pressers this week, I played my FH 2 weeks ago disaster, hope you have better luck.

Green&Red · 02-05-2022 8:00pm

https://www.boards.ie/discussion/comment/119004529#Comment_119004529

Richardson is 4.4

Ros1234 · 02-05-2022 9:25pm

He was 4.4 weeks ago, went back up in gw 29, unless you have him since then. The way you wrote it I thought you meant any 4.4 forward.

Green&Red · 02-05-2022 9:29pm

https://www.boards.ie/discussion/comment/119007407#Comment_119007407

Didn’t realise that. Ya have him since WC

Father Hernandez · 09-05-2022 10:42am

Haaland to City looking as good as done.

What do we think, 12.0 striker for the new season?

Fitz* · 09-05-2022 11:50am

12.5 maybe? Probably match up with Kane to give people a decision to make.

As an aside, does anyone wish that the starting prices were changed a bit to go in 0.2 increments instead of 0.5 only?

Lucas Hood · 09-05-2022 12:26pm

Lukaku came in 11.5m Ronaldo 12.5m this season.

In between those 2 prices i would say.

The Guru 123 · 10-05-2022 9:57am

After this seasons disaster with the forwards (although I must say I've had great joy with Ronaldo the last month) I think next season I'll be definitely starting with Haaland and Mitrovic and a 4.5. There's none of this years contingent I'd have any interest in getting again to be honest. Think Haaland will be 12.5.

Fitz* · 10-05-2022 1:09pm

I would assume that Jota gets moved to a forward next year. But his minutes are limited, and probably around 9.0 so not that attractive unless he becomes nailed on starter.

Maybe Antonio for the opening 6 GWs again!

Western Pomise · 10-05-2022 2:43pm

https://www.boards.ie/discussion/comment/119039866#Comment_119039866

I think a lot will depend on the opening few weeks fixtures for the likes of Mitrovic.....he didn't set the world alight when Fulham were last up and I'm not convinced they have a much stronger team for next year.

There will be a fear of not having Haaland initially and of course Kane is always a slow starter.

In a parallel universe Kane could be at Man Utd in August, Mane could be gone to Bayern (as he is very peeved that Salah is getting all the attention regarding his contract) and Antonio could be gone to any of Spurs,Utd or Arsenal.

Fitz* · 10-05-2022 3:02pm

Solanke may go under the radar a bit too, in the cheap striker category. He also hit 30 goals this season and seems to have finally found his feet in terms of what kind of player he is. Bournemouth were always good for a goal when they were in the league.

Cartman78 · 10-05-2022 3:46pm

Talk of Watkins going to West Ham as well for anyone who likes getting trolled every week

patmac · 23-05-2022 10:45pm

Going to have to pay more attention to my captain choices, I worked out that I could have finished in the top 20 if I had picked the right captains especially towards the end of the season. Despite having Son I never seemed to captain him at the right time. Not complaining just something to work on next season.