How To Create A Last Man Standing Spreadsheet

Damien

Self-Aware RedCafe Database (and Admin)

Rules

Select one team to win from the Premier League fixtures (if you can't post, PM me your entry).
If they win or draw, you are through to the next round. If they lose, you are eliminated.
You cannot pick the same team twice unless you have already picked every team.
You can pick as many weeks in advance as you like.
If you fail to pick a team, then the team with the highest league standing from the previous season which you have not yet picked will be automatically chosen for you.
If you miss three weeks of fixtures, then you are eliminated. Autopicks will be highlighted yellow in this spreadsheet
If in the final round, all remaining players are eliminated, then nobody wins Last Man Standing and those players get the tagline "Last Man Standing finalist 2020/21". If one person wins then they alone will get the tagline "Last Man Standing champion 2020/21".
No new entrants will be allowed for the second set of fixtures. If you don't enter this before 12th September at 3:00pm (this WILL change as TV fixtures are announced), you are out of luck until the next LMS competition starts.

NOTE: If you change your mind on a pick, make a new post and tag Damien.

Previous Last Man Standing Competitions

Last Man Standing 2019/20 (176 entrants): GW01-10 (Losing finalists: Broad Street Bullies, jymufc20, V.O.)
Last Man Standing 2 2019/20 (238 entrants): GW12-24 (Winner: bond19821982)
Last Man Standing 3 2019/20 (312 entrants) GW24-04 (Winner: Maluco)

Spreadsheet to keep track of your predictions

Last edited: Oct 4, 2020

Damien

Self-Aware RedCafe Database (and Admin)

Note: The times for the fixtures in some weeks will change as TV fixtures are announced. I'll update these when they're announced (if someone can tag me, it'd be appreciated).

Week 01

12/09/2020 12:30 Fulham v Arsenal
12/09/2020 15:00 Crystal Palace v Southampton
12/09/2020 17:30 Liverpool v Leeds Utd
12/09/2020 20:00 West Ham v Newcastle
13/09/2020 14:00 West Brom v Leicester
13/09/2020 16:30 Tottenham v Everton
14/09/2020 18:00 Sheffield Utd v Wolves
14/09/2020 20:15 Brighton v Chelsea

Week 02

19/09/2020 12:30 Everton v West Brom
19/09/2020 15:00 Leeds Utd v Fulham
19/09/2020 17:30 Man Utd v Crystal Palace
19/09/2020 20:00 Arsenal v West Ham
20/09/2020 12:00 Southampton v Tottenham
20/09/2020 14:00 Newcastle v Brighton
20/09/2020 16:30 Chelsea v Liverpool
20/09/2020 19:00 Leicester v Burnley
21/09/2020 18:00 Aston Villa v Sheffield Utd
21/09/2020 20:15 Wolves v Man City

Week 03

26/09/2020 12:30 Brighton v Man Utd
26/09/2020 15:00 Burnley v Southampton
26/09/2020 15:00 Crystal Palace v Everton
26/09/2020 15:00 Tottenham v Newcastle
26/09/2020 15:00 West Ham v Wolves
26/09/2020 17:30 West Brom v Chelsea
27/09/2020 12:00 Sheffield Utd v Leeds Utd
27/09/2020 14:00 Fulham v Aston Villa
27/09/2020 16:30 Man City v Leicester
28/09/2020 20:00 Liverpool v Arsenal

Week 4

03/10/2020 12:30 Chelsea v Crystal Palace
03/10/2020 15:00 Everton v Brighton
03/10/2020 17:30 Leeds Utd v Man City
03/10/2020 20:00 Newcastle v Burnley
04/10/2020 12:00 Leicester v West Ham
04/10/2020 12:00 Southampton v West Brom
04/10/2020 14:00 Arsenal v Sheffield Utd
04/10/2020 14:00 Wolves v Fulham
04/10/2020 16:30 Man Utd v Tottenham
04/10/2020 19:15 Aston Villa v Liverpool

Week 5

17/10/2020 12:30 Everton v Liverpool
17/10/2020 15:00 Chelsea v Southampton
17/10/2020 17:30 Man City v Arsenal
17/10/2020 20:00 Newcastle v Man Utd
18/10/2020 12:00 Sheffield Utd v Fulham
18/10/2020 14:00 Crystal Palace v Brighton
18/10/2020 16:30 Tottenham v West Ham
18/10/2020 19:15 Leicester City v Aston Villa
19/10/2020 17:30 West Brom v Burnley
19/10/2020 20:00 Leeds Utd v Wolves

Week 6

23/10/2020 20:00 Aston Villa v Leeds Utd
24/10/2020 12:30 West Ham v Man City
24/10/2020 15:00 Fulham v Crystal Palace
24/10/2020 17:30 Man Utd v Chelsea
24/10/2020 20:00 Liverpool v Sheffield Utd
25/10/2020 14:00 Southampton v Everton
25/10/2020 16:30 Wolves v Newcastle
25/10/2020 19:15 Arsenal v Leicester
26/10/2020 17:30 Brighton v West Brom
26/10/2020 20:00 Burnley v Tottenham

Week 7

30/10/2020 20:00 Wolves v Crystal Palace
31/10/2020 12:30 Sheffield Utd v Man City
31/10/2020 15:00 Burnley v Chelsea
31/10/2020 17:30 Liverpool v West Ham
01/11/2020 12:00 Aston Villa v Southampton
01/11/2020 14:00 Newcastle v Everton
01/11/2020 16:30 Man Utd v Arsenal
01/11/2020 19:15 Tottenham v Brighton
02/11/2020 17:30 Fulham v West Brom
02/11/2020 20:00 Leeds Utd v Leicester

Week 8

06/11/2020 17:30 Brighton v Burnley
06/11/2020 20:00 Southampton v Newcastle
07/11/2020 --:-- Arsenal v Aston Villa
07/11/2020 15:00 Crystal Palace v Leeds Utd
07/11/2020 15:00 Everton v Man Utd
07/11/2020 15:00 West Brom v Tottenham
07/11/2020 15:00 West Ham v Fulham
07/11/2020 17:30 Chelsea v Sheffield Utd
08/11/2020 14:00 Leicester v Wolves
08/11/2020 16:30 Man City v Liverpool

Week 9

21/11/2020 12:30 Newcastle v Chelsea
21/11/2020 15:00 Aston Villa v Brighton
21/11/2020 15:00 Burnley v Crystal Palace
21/11/2020 15:00 Fulham v Everton
21/11/2020 15:00 Liverpool v Leicester
21/11/2020 15:00 Man Utd v West Bro
21/11/2020 15:00 Wolves v Southampton
21/11/2020 17:30 Tottenham v Man City
22/11/2020 14:00 Sheffield Utd v West Ham
22/11/2020 16:30 Leeds Utd v Arsenal

Week 10

28/11/2020 --:-- Arsenal v Wolves
28/11/2020 --:-- Leicester v Fulham
28/11/2020 12:30 Brighton v Liverpool
28/11/2020 15:00 Crystal Palace v Newcastle
28/11/2020 15:00 Man City v Burnley
28/11/2020 15:00 West Brom v Sheffield Utd
28/11/2020 17:30 Everton v Leeds Utd
29/11/2020 14:00 Southampton v Man Utd
29/11/2020 16:30 Chelsea v Tottenham
30/11/2020 20:00 West Ham v Aston Villa

Week 11

05/12/2020 12:30 Burnley v Everton
05/12/2020 15:00 Man City v Fulham
05/12/2020 17:30 West Ham v Man Utd
05/12/2020 20:00 Chelsea v Leeds Utd
06/12/2020 12:00 West Brom v Crystal Palace
06/12/2020 14:15 Sheffield Utd v Leicester
06/12/2020 16:30 Tottenham v Arsenal
06/12/2020 19:15 Liverpool v Wolves
07/12/2020 20:00 Brighton v Southampton

Week 12

11/12/2020 20:00 Leeds Utd v West Ham
12/12/2020 12:30 Wolves v Aston Villa
12/12/2020 15:00 Newcastle v West Brom
12/12/2020 17:30 Man Utd v Man City
12/12/2020 20:00 Everton v Chelsea
13/12/2020 12:00 Southampton v Sheffield Utd
13/12/2020 14:15 Crystal Palace v Tottenham
13/12/2020 16:30 Fulham v Liverpool
13/12/2020 19:15 Arsenal v Burnley
13/12/2020 19:15 Leicester v Brighton

Week 13

15/12/2020 18:00 Wolves v Chelsea
15/12/2020 20:00 Man City v West Brom
16/12/2020 18:00 Arsenal v Southampton
16/12/2020 18:00 Leeds Utd v Newcastle
16/12/2020 18:00 Leicester v Everton
16/12/2020 20:00 Fulham v Brighton
16/12/2020 20:00 West Ham v Crystal Palace
16/12/2020 20:00 Liverpool v Tottenham
17/12/2020 18:00 Aston Villa v Burnley
17/12/2020 20:00 Sheffield Utd v Man Utd

Week 14

19/12/2020 12:30 Crystal Palace v Liverpool
19/12/2020 15:00 Southampton v Man City
19/12/2020 17:30 Everton v Arsenal
19/12/2020 20:00 Newcastle v Fulham
20/12/2020 12:00 Brighton v Sheffield Utd
20/12/2020 14:15 Tottenham v Leicester
20/12/2020 16:30 Man Utd v Leeds Utd
20/12/2020 19:15 West Brom v Aston Villa
21/12/2020 17:30 Burnley v Wolves
21/12/2020 20:00 Chelsea v West Ham

Week 15

26/12/2020 12:30 Leicester v Man Utd
26/12/2020 15:00 Aston Villa v Crysal Palace
26/12/2020 15:00 Fulham v Southampton
26/12/2020 17:30 Arsenal v Chelsea
26/12/2020 20:00 Man City v Newcastle
26/12/2020 20:00 Sheffield Utd v Everton
27/12/2020 12:00 Leeds Utd v Burnley
27/12/2020 14:15 West Ham v Brighton
27/12/2020 16:30 Liverpool v West Brom
27/12/2020 19:15 Wolves v Tottenham

Week 16

28/12/2020 15:00 Crystal Palace v Leicester
28/12/2020 17:30 Chelsea v Aston Villa
28/12/2020 20:00 Everton v Man City
29/12/2020 18:00 Brighton v Arsenal
29/12/2020 18:00 Burnley v Sheffield Utd
29/12/2020 18:00 Southampton v West Ham
29/12/2020 18:00 West Brom v Leeds Utd
29/12/2020 20:00 Man Utd v Wolves
30/12/2020 18:00 Tottenham v Fulham
30/12/2020 20:00 Newcastle v Liverpool

Week 17

01/01/2021 17:30 Everton v West Ham
01/01/2021 20:00 Man Utd v Aston Villa
02/01/2021 12:30 Tottenham v Leeds Utd
02/01/2021 15:00 Crystal Palace v Sheffield Utd
02/01/2021 17:30 Brighton v Wolves
02/01/2021 20:00 West Brom v Arsenal
03/01/2021 12:00 Burnley v Fulham
03/01/2021 14:15 Newcastle v Leicester
03/01/2021 16:30 Chelsea v Man City
04/01/2021 20:00 Southampton v Liverpool

Week 18

12/01/2021 18:00 Sheffield Utd v Newcastle
12/01/2021 20:15 Wolves v Everton
13/01/2021 18:00 Man City v Brighton
13/01/2021 20:15 Aston Villa v Tottenham
14/01/2021 20:00 Arsenal v Crystal Palace
19/01/2021 18:00 West Ham v West Brom
19/01/2021 20:15 Leicester v Chelsea
20/01/2021 18:00 Leeds Utd v Southampton
20/01/2021 20:15 Fulham v Man Utd
21/01/2021 20:00 Liverpool v Burnley

Week 19

15/01/2021 20:00 Fulham v Chelsea
16/01/2021 12:30 Wolves v West Brom
16/01/2021 15:00 Leeds Utd v Brighton
16/01/2021 15:00 West Ham v Burnley
16/01/2021 17:30 Aston Villa v Everton
16/01/2021 20:00 Leicester v Southampton
17/01/2021 14:00 Sheffield Utd v Tottenham
17/01/2021 16:30 Liverpool v Man Utd
17/01/2021 19:15 Man City v Crystal Palace
18/01/2021 20:00 Arsenal v Newcastle

Week 20

26/01/2021 18:00 Brighton v Fulham
26/01/2021 18:00 Newcastle v Leeds Utd
26/01/2021 20:15 West Brom v Man City
26/01/2021 20:15 Southampton v Arsenal
27/01/2021 18:00 Burnley v Aston Villa
27/01/2021 18:00 Chelsea v Wolves
27/01/2021 19:30 Crystal Palace v West Ham
27/01/2021 20:15 Everton v Leicester
27/01/2021 20:15 Man Utd v Sheffield Utd
28/01/2021 20:00 Tottenham v Liverpool

Week 21

30/01/2021 12:30 Everton v Newcastle
30/01/2021 15:00 Chelsea v Burnley
30/01/2021 15:00 Crystal Palace v Wolves
30/01/2021 15:00 Man City v Sheffield Utd
30/01/2021 15:00 West Brom v Fulham
30/01/2021 17:30 Arsenal v Man Utd
30/01/2021 20:00 Southampton v Aston Villa
31/01/2021 14:00 Brighton v Tottenham
31/01/2021 14:00 Leicester v Leeds Utd
31/01/2021 16:30 West Ham v Liverpool

Week 22

02/02/2021 19:45 Aston Villa v West Ham
02/02/2021 19:45 Burnley v Man City
02/02/2021 19:45 Fulham v Leicester
02/02/2021 19:45 Leeds Utd v Everton
02/02/2021 19:45 Sheffield Utd v West Brom
02/02/2021 19:45 Wolves v Arsenal
02/02/2021 20:00 Man Utd v Southampton
02/02/2021 20:00 Newcastle v Crystal Palace
03/02/2021 19:45 Tottenham v Chelsea
03/02/2021 20:00 Liverpool v Brighton

Last edited: Jan 18, 2021

The Cat

Will drink milk from your hands

In please

Week 1 - Chelsea

Damien

Self-Aware RedCafe Database (and Admin)

Be sure to post your prediction for the first week or it won't be counted.

Vidyoyo

Self-confessed coffee shop chat-up expert

Last edited: Sep 13, 2020

Last edited: Aug 30, 2020

As there is an exclamation mark already at the end of my name, the banner currently says "Hello, Annihilate Now!!" ... which frankly is a little too excitable for me and thus makes me a bit uncomfortable.

Having said all that,

Week 1, Liverpool please.

W1 : Crystal Palace
W2 : Newcastle
W3 : Burnley

RobinLFC

Cries when Liverpool doesn't get praised

BD

technologically challenged

1. West ham

Tough first week

Samid

follows Pogue around, fixing his images

Paxi

Dagestani MMA Boiled Egg Expert

GW1: Arsenal

Come on Gunners, just this once.

Damien

Self-Aware RedCafe Database (and Admin)

If you look at the first two competitions in the OP you can see reoccurring patterns. There's a common mistake people make in the first three weeks. For this reason, I already know which posters will still be involved by Week 11. It's just a case now of making sure I'm there alongside them.

Yeah, don't copy @RedSky and you'll make it past week 2.

Yeah, don't copy @RedSky and you'll make it past week 2.

Brighton please.

ha_rooney

Correctly predicted France to win World Cup 2018