2020 Challenge Series and Awards

[maxwelldeux]

Welcome to the 2020 Official Challenge Series!

This is a fun and friendly competition based on the official challenges for 2020. Everyone is encouraged to participate as much (or as little) as they wish. We'll have an overall challenge competition for this year, as well as several awards you can earn along the way based on your participation in challenges. The overarching goal of this is to have fun and encourage everyone to expand their film knowledge by participating in the various official challenges.

There are a few changes from last year (details below). The first major change is to eliminate the custom writing, and report tables for folks to peruse at their leisure. The second major change is to drop some of the redundant awards that can be gleaned from the OP. If you have questions on the awards, just ask. Discussion thread.

How Does It Work?

Very simply, earn points by participating in challenges. Points are based on your rank for the challenge, and totaled across all challenges you've participated in. (Full details of the scoring can be found in the Official Challenges Leaderboard.) In addition, there will be various awards you can earn along the way for achieving certain milestones. Other advice:

• Record your watches that fit each challenge, even if it's only 1 or 2
• Scoring tends to reward breadth; 5 watches each in 3 challenges tends to be better than 15 watches in a single challenge
• Pay attention to films that count for multiple challenges
• Most importantly, HAVE FUN!

Awards

Yes - there will be awards! Awards are based on participation in the challenges this year and achieving various milestones along the way. Just keep participating in challenges, and it's likely you'll earn quite a few of these along the way. Here are the awards:

• Participation (AKA the "Christopher Lee") Award: How many challenges did you participate in*? Awarded in six levels, for participating in 1, 4, 9, 16, 25, and 36 challenges.
  *5 films/challenge counts as participation.
• X/X (AKA the "Beautiful Mind") Award: Awarded for watching X movies in X official challenges. There are 36 potential levels with this badge. Every challenge participant will earn at least the 1/1 level. But if you want to earn the highest level, you'd have to watch at least 36 movies in all 36 official challenges.
• Top 5 Performance (AKA the "Oscar Nominees") Award: For placing in the top 5 of a challenge. Level up each time you achieve this (Max 36).
• Obsessed Much? (AKA the "Adrian Monk") Award: For reaching the given threshold in a challenge. Level up each time you exceed the threshold (Max 36). Lower threshold: 36 watches in a single challenge. Upper threshold: 100 watches in a single challenge.
• Triple/Double (AKA "Space Jam") Awards: Watch the most triples in a month? Award. Most doubles in a month? Another award. Level up to 12. Note: This is an "opt-in" award/challenge - to qualify, you must post your doubles and triples in The Triple Challenge - 2020 thread. No thresholds on this one.

---

2020 Official Challenge Leaderboard

Rank	Participant	Total Score	# Challenges Competed In	Total Number of films Watched for Official Challenges	Average Rank in Challenges	Number of Challenge Wins
1	blueboybob	952	36	2872	4.50	6
2	flavo5000	933	36	3488	4.92	10
3	jdidaco	902.5	36	1834	5.83	2
4	sol	898.5	36	1728	5.97	1
5	OldAle1	611.5	32	872	11.91	0
6	AB537	565.5	32	799	13.97	1
7	maxwelldeux	560	35	764	14.97	0
8	ororama	521	34	606	15.35	0
9	cinephage	513	35	528	16.37	0
10	allisoncm	495.5	36	860	16.72	0
11	hurluberlu	466	35	571	17.69	0
12	Obgeoff	448.5	26	853	14.62	2
13	RogerTheMovieManiac88	446.5	28	651	16.32	0
14	Lonewolf2003	404	19	527	13.00	0
15	blocho	374.5	36	368	20.06	0
16	jeroeno	356.5	17	647	9.88	1
17	psychotronicbeatnik	354	11	1284	2.73	4
18	Traveller	337	12	1135	2.67	1
19	peeptoad	323.5	20	386	14.20	0
20	sebby	320.5	25	446	19.24	0
21	frbrown	286.5	23	433	20.52	0
22	vortexsurfer	284.5	23	395	20.52	0
23	VincentPrice	280	16	397	17.75	0
24	AssOnFire	278	13	541	12.62	0
25	zzzorf	265.5	27	389	22.00	0
26	shugs	244.5	21	272	22.05	0
27	Mario Gaborović	239	12	401	4.42	1
28	72aicm	219.5	11	423	15.55	1
29	St. Gloede	211	11	310	9.00	0
30	Melvelet	209	19	200	20.79	0
31	morrison-dylan-fan	180.5	17	182	20.59	0
32	PUNQ	168	7	499	9.86	2
33	Onderhond	165.5	14	221	20.00	0
34	klaus78	162	10	197	20.50	0
35	adwest	157	5	508	7.00	0
36	Daviddoes	140.5	8	245	20.00	0
37	ChrisReynolds	133	9	175	22.11	0
38	weirdboy	132	9	210	18.44	0
39	burneyfan	130.5	8	170	17.00	0
40	nimimerkillinen	129.5	18	129	24.00	0
41	Lu-Chin	127	6	318	10.17	2
42	DudeLanez	111.5	4	197	13.00	0
43	Kublai Khan	106	4	179	13.00	0
44	albajos	101.5	8	163	20.00	0
45	Mochard	95.5	9	116	24.78	0
46	India Istanbul	94	6	121	21.00	0
47	lineuphere	83	5	166	18.20	0
47	1SO	83	3	173	14.67	0
49	filmbantha	75	3	111	14.00	0
50	mightysparks	74	7	95	26.00	0
50	connordenney	74	20	87	29.95	0
52	Lilarcor	70.5	7	60	20.43	0
53	Cinepolis	68	12	56	24.50	0
54	mathiasa	66.5	6	90	22.83	0
55	funkybusiness	64.5	3	91	8.67	0
56	Knaldskalle	59.5	9	58	30.22	0
57	Coryn	57.5	7	64	26.00	0
58	Prat	54	2	141	5.50	0
59	mjf314	53.5	4	53	13.25	0
59	tourdesb	53.5	2	159	5.50	0
61	zuma	50	2	110	6.00	0
62	sheikofhyrule	48.5	2	49	16.00	0
63	pitchorneirda	48	3	47	14.00	0
63	beavis	48	2	85	13.00	0
65	Mate_cosido	47.5	2	68	9.50	0
66	jal90	46	6	32	25.83	0
66	drayton_cross	46	2	74	22.50	0
68	Teproc	42.5	7	37	25.43	0
69	Straka	40.5	3	41	16.67	0
70	Leopardi	40	1	87	13.00	0
70	erde	40	2	66	9.50	0
72	Good_Will_Harding	39	1	85	14.00	0
73	WalterNeff	38	1	156	1.00	1
73	kingink	38	2	58	22.50	0
75	wasabi	36	2	34	12.50	0
76	redcard29	35	1	60	3.00	0
77	Tarris1	31.5	2	28	21.00	0
78	insomnius	31	2	21	18.50	0
78	Ebbywebby	31	4	29	20.50	0
80	jajusu	30	1	100	1.00	1
80	max-scl	30	3	29	20.67	0
82	3eyes	28.5	5	22	23.20	0
82	Fergenaprido	28.5	2	46	9.00	0
84	clemmetarey	27.5	2	43	23.50	0
85	sortile9io	26	1	41	4.00	0
86	Perception de Ambiguity	25.5	1	36	10.00	0
87	Hunziker	19	3	34	28.00	0
87	greenhorg	19	1	38	34.00	0
87	RBG	19	2	15	21.50	0
90	AdamH	17	1	23	20.00	0
90	outdoorcats	17	1	35	36.00	0
92	Harco	16	1	34	37.00	0
93	Local Hero	15.5	2	9	19.50	0
93	kongs_speech	15.5	2	31	26.00	0
95	rnilsson19	13.5	1	15	22.00	0
96	fear of 13	12.5	2	4	12.00	0
97	John Milton	12	1	12	22.00	0
98	GruesomeTwosome	11.5	1	24	41.00	0
99	explorer95	11	2	12	35.50	0
100	Lammetje	10	1	7	29.00	0
101	jocularities	9.5	3	7	25.67	0
102	sacmersault	9	1	6	29.00	0
103	Samar	7	1	3	18.00	0
103	Nathan Treadway	7	1	5	30.00	0
105	bentoga	5.5	1	2	24.00	0
106	DareDaniel	5	1	6	38.00	0
107	sennaho	3.5	1	7	49.00	0
108	matthewscott8	3	1	1	22.00	0
108	Lakigigar	3	1	1	24.00	0
110	SeVKiTT	1	1	1	52.00	0

[albajos]

Some high scores to beat(?) in 2020

Most points across all challenges in a year
flavo5000 - 2196
psychotronicbeatnik - 2190
albajos - 1955
jeroeno - 1955

Most points across all challenges in a month
albajos - 425
flavo5000 - 308
albajos - 303

Most points in one challenge in a month
mightysparks - 301
albajos - 222
albajos - 211

[maxwelldeux]

2020 Oscar Nominees*


*I mean, not really - it's just a title. Please don't sue me.

This award is for finishing in the Top 5 of one of the official challenges. Level up for each Top 5 finish this year.

After January:

Person	Oscar Noms	Change
jdidaco	2	+2
sol	2	+2
72aicm	1	+1
AB537	1	+1
albajos	1	+1
blueboybob	1	+1
flavo5000	1	+1
jeroeno	1	+1
Mario Gaborović	1	+1
OldAle1	1	+1
ororama	1	+1
psychotronicbeatnik	1	+1
Traveller	1	+1

[maxwelldeux]

2020's Obsessed Much? Awards



This threshold is for those slightly obsessive people who managed to watch 36 films for a single challenge, pacing over 1 film/day.

After January:

Person	Count 36+	Change
sol	3	+3
blueboybob	2	+2
72aicm	1	+1
AB537	1	+1
albajos	1	+1
flavo5000	1	+1
funkybusiness	1	+1
hurluberlu	1	+1
jdidaco	1	+1
jeroeno	1	+1
Lonewolf2003	1	+1
Mario Gaborović	1	+1
Mate_cosido	1	+1
OldAle1	1	+1
peeptoad	1	+1
psychotronicbeatnik	1	+1
sebby	1	+1
Traveller	1	+1
VincentPrice	1	+1
vortexsurfer	1	+1

---

This threshold is for those very obsessive people who managed to watch 100 films for a single challenge, pacing well over 3 films/day.

After January:

Person	Count 100+	Change
72aicm	1	+1
albajos	1	+1
flavo5000	1	+1
psychotronicbeatnik	1	+1

[maxwelldeux]

2020's Space Jam Awards



These awards are for those strategic individuals who watched films counting for more than one challenge (and reported them in the Triples Challenge thread). Level up each time you earn this award (max 12 each).

After January:

Person	Triple	Change
sol	1	+1

Person	Double	Change
sol	1	+1

[maxwelldeux]

2020's X/X Awards



This award is for those people who have watched X movies for X official challenges. The first level is easy to obtain - every challenge participant will have watched at least 1 film for 1 official challenge. But each subsequent level is harder to achieve - Level Two is 2 films in each of 2 official challenges, Level Three is 3 films in each of 3 official challenges, Level Ten is 10 films watched in each of 10 official challenges, and so on.

This is my personal favorite award. It's hard to achieve some of those higher levels, and it's only going to get more interesting as the year goes on. Level 3 is the maximum possible award currently.

After January:

Person	Level	Change
blocho	3	+3
blueboybob	3	+3
cinephage	3	+3
flavo5000	3	+3
jdidaco	3	+3
jeroeno	3	+3
maxwelldeux	3	+3
nimimerkillinen	3	+3
OldAle1	3	+3
ororama	3	+3
sol	3	+3
72aicm	2	+2
AB537	2	+2
albajos	2	+2
Coryn	2	+2
hurluberlu	2	+2
klaus78	2	+2
Obgeoff	2	+2
peeptoad	2	+2
RogerTheMovieManiac88	2	+2
sebby	2	+2
allisoncm	1	+1
ChrisReynolds	1	+1
Cinepolis	1	+1
connordenney	1	+1
DareDaniel	1	+1
Daviddoes	1	+1
fear of 13	1	+1
filmbantha	1	+1
frbrown	1	+1
funkybusiness	1	+1
India Instanbul	1	+1
Knaldskalle	1	+1
Lakigigar	1	+1
Lonewolf2003	1	+1
Mario Gaborović	1	+1
Mate_cosido	1	+1
mightysparks	1	+1
Mochard	1	+1
morrison-dylan-fan	1	+1
psychotronicbeatnik	1	+1
sheikofhyrule	1	+1
shugs	1	+1
Teproc	1	+1
Traveller	1	+1
VincentPrice	1	+1
vortexsurfer	1	+1
weirdboy	1	+1
zzzorf	1	+1

[maxwelldeux]

2020's Participation Awards



This award is for those who have participated in a wide variety of challenges, powering through to watch at least five films in the challenge.

After January:

Person	Triple	Change
blueboybob	3	+3
jdidaco	3	+3
jeroeno	3	+3
maxwelldeux	3	+3
nimimerkillinen	3	+3
OldAle1	3	+3
sol	3	+3
72aicm	2	+2
AB537	2	+2
albajos	2	+2
blocho	2	+2
flavo5000	2	+2
hurluberlu	2	+2
klaus78	2	+2
ororama	2	+2
RogerTheMovieManiac88	2	+2
sebby	2	+2
allisoncm	1	+1
ChrisReynolds	1	+1
cinephage	1	+1
Coryn	1	+1
DareDaniel	1	+1
Daviddoes	1	+1
filmbantha	1	+1
frbrown	1	+1
funkybusiness	1	+1
India Instanbul	1	+1
Knaldskalle	1	+1
Lonewolf2003	1	+1
Mario Gaborović	1	+1
Mate_cosido	1	+1
mightysparks	1	+1
Mochard	1	+1
morrison-dylan-fan	1	+1
Obgeoff	1	+1
peeptoad	1	+1
psychotronicbeatnik	1	+1
sheikofhyrule	1	+1
shugs	1	+1
Teproc	1	+1
Traveller	1	+1
VincentPrice	1	+1
vortexsurfer	1	+1
weirdboy	1	+1
zzzorf	1	+1

[maxwelldeux]

Updated 2020 Leaderboard

For the 2020 Official Challenge Leaderboard, the full results are below and will be duplicated in the first post. Last month's results were in another year. The Top 25 + winners are below; full results in the OP.

2020 Official Challenge Leaderboard

Rank	Participant	Total Score	# Challenges Competed In	Total Number of films Watched for Official Challenges	Average Rank in Challenges	Number of Challenge Wins
1	sol	78	3	154	4.33	0
2	jdidaco	74	3	140	5.33	0
3	flavo5000	70.5	3	226	6.33	0
4	blueboybob	67	3	99	7.67	0
5	OldAle1	61	3	65	10.00	0
6	AB537	59	2	111	6.00	0
7	jeroeno	55	3	72	11.67	0
8	hurluberlu	50	3	61	12.67	0
9	albajos	48	2	105	11.50	0
10	sebby	47	2	68	11.00	0
11	maxwelldeux	45	3	38	14.67	0
12	nimimerkillinen	43.5	3	41	15.67	0
13	ororama	42	3	38	16.00	0
13	psychotronicbeatnik	42	1	211	1.00	1
15	peeptoad	40	2	49	10.50	0
16	cinephage	39.5	3	36	16.67	0
17	vortexsurfer	37	1	66	6.00	0
17	72aicm	37	2	111	17.00	1
19	Lonewolf2003	34	1	58	9.00	0
20	RogerTheMovieManiac88	33	2	31	18.50	0
20	Mate_cosido	33	1	55	10.00	0
22	VincentPrice	28	1	36	15.00	0
23	klaus78	27	2	25	22.00	0
23	shugs	27	1	35	16.00	0
25	Traveller	26	1	62	2.00	0
25	sheikofhyrule	26	1	31	17.00	0
32	Mario Gaborović	19	1	54	1.00	1

And for those interested stats-y people, here is the scoring breakdown for the [month] challenges:

MONTH-only Leaderboard

[sol]

And there I was planning to ping you on Monday if you hadn't gotten around to this yet. It looks like this new approach is a lot less work for you (without the individual write-ups, etc), so I think this is indeed the best way going forward. Something interesting though, which might be a first - none of the January Challenge winners are in the top 10 on the leaderboard.

Oh, and let me just momentarily bask in the glory while quoting...

Rank	Participant	Total Score	# Challenges Competed In	Total Number of films Watched for Official Challenges	Average Rank in Challenges	Number of Challenge Wins
1	sol	78	3	154	4.33	0

...since there's no way that I will be able to maintain a lead throughout the year.

[maxwelldeux]

And there I was planning to ping you on Monday if you hadn't gotten around to this yet. It looks like this new approach is a lot less work for you (without the individual write-ups, etc), so I think this is indeed the best way going forward.

This is quite a bit less work. By ignoring "levels" and avoiding call attention to people who actually moved up in favor of the "change" column, it'll be a lot more streamlined going forward, for sure.

And yeah, this is the breadth vs. depth issue. The tie at 13th place is really telling - psychotronicbeatnik, who had one of the all-time best single challenge performances of all time, is tied with ororama, who has less than 20% of psycho's total, but did it in three challenges.

[sol]

Breadth indeed; I knew full well that I was the only user who got to 36 in three challenges by spreading my viewings across them in January. I had no idea that I was one of only two who had achieved more than one "Level 36" in January (and no, that's not going to happen this month, maybe not in any of the February Challenges, but I'll see what I can squeeze in).

[sol]

This is quite a bit less work. By ignoring "levels" and avoiding call attention to people who actually moved up in favor of the "change" column, it'll be a lot more streamlined going forward, for sure.

Looking forward to the update for February. Please sing out if you need any help throwing things together. I'm back at work on Monday since the government here is adamant that schools will remain open no matter what, but nothing much else is open or viable with all the Covid-19 stuff, so I am pretty free this weekend if you need any help or assistance.

[maxwelldeux]

This is quite a bit less work. By ignoring "levels" and avoiding call attention to people who actually moved up in favor of the "change" column, it'll be a lot more streamlined going forward, for sure.

Looking forward to the update for February. Please sing out if you need any help throwing things together. I'm back at work on Monday since the government here is adamant that schools will remain open no matter what, but nothing much else is open or viable with all the Covid-19 stuff, so I am pretty free this weekend if you need any help or assistance.

Honestly, I'm probably not going to have time/energy - life is... different now, and I need to focus efforts on things that will keep my wife and I a) alive, and b) employed.

Here is the spreadsheet if you want to take a whack at it: https://we.tl/t-3pjdzgJfRC

[sol]

Looking forward to the update for February. Please sing out if you need any help throwing things together. I'm back at work on Monday since the government here is adamant that schools will remain open no matter what, but nothing much else is open or viable with all the Covid-19 stuff, so I am pretty free this weekend if you need any help or assistance.

Honestly, I'm probably not going to have time/energy - life is... different now, and I need to focus efforts on things that will keep my wife and I a) alive, and b) employed.

Here is the spreadsheet if you want to take a whack at it: https://we.tl/t-3pjdzgJfRC

Thanks, max. I'm a bit slow when it comes to excel, however, I finished inputting all of the data for the African Challenge and everything looks okay, so once I get around to entering the data for the other two busier challenges, I should be hopefully able to get something up here.

Hope everything's going for you and your wife. I guess I'm lucky to be an "essential services" field that will remain open even if the country technically goes into lockdown (sounds crazy but true). I have no idea how bad things are in Seattle, but here's to hoping that things improve some time soon.

[sol]

I wish was better at Excel. I've managed to update the leaderboard for the end of February by changing the data in max's first sheet then doing a "Refresh All" in the second sheet. Doing such a refresh in the other sheets doesn't change the data though, so I haven't been able to update any of the other awards (though stuff like Oscar nominations I could do manually at a pinch). Anyway, here's the leaderboard for the first two months of 2020:

Updated 2020 Leaderboard

2020 Official Challenge Leaderboard

Rank	Participant	Total Score	# Challenges Competed In	Total Number of films Watched for Official Challenges	Average Rank in Challenges	Number of Challenge Wins
1	sol	149	6	256	4.33	0
2	jdidaco	148	6	256	4.33	1
3	flavo5000	137.5	6	384	5.83	1
4	blueboybob	130.5	6	186	7.17	0
5	jeroeno	112.5	6	134	10.17	0
6	OldAle1	111	6	106	10.50	0
7	AB537	97	5	154	11.20	0
8	maxwelldeux	93	6	77	13.17	0
9	sebby	91	5	105	12.40	0
10	RogerTheMovieManiac88	89	5	87	12.80	0
11	hurluberlu	81.5	6	83	14.83	0
12	albajos	78	4	138	13.75	0
13	ororama	77.5	6	60	16.00	0
14	cinephage	75.5	6	61	16.17	0
15	nimimerkillinen	72.5	4	72	14.00	0
16	psychotronicbeatnik	66	2	292	1.00	2
17	blocho	64	6	44	18.00	0
18	Traveller	62	2	144	2.00	0
18	Lonewolf2003	62	2	87	9.50	0
20	VincentPrice	52.5	2	57	14.00	0
21	vortexsurfer	50.5	3	74	18.00	0
22	sheikofhyrule	48.5	2	49	16.00	0
23	shugs	47.5	3	50	19.00	0
24	peeptoad	47	3	52	11.33	0
25	allisoncm	44	6	41	21.17	0
26	India Istanbul	43	2	57	12.50	0
27	Mario Gaborović	38	2	88	1.50	1
27	klaus78	38	3	32	23.33	0
29	72aicm	37	2	111	17.00	1
30	redcard29	35	1	60	3.00	0
31	Mate_cosido	33	1	55	10.00	0
32	Obgeoff	31.5	4	21	23.75	0
33	Tarris1	27	1	26	11.00	0
34	zzzorf	26	4	28	25.75	0
35	ChrisReynolds	25.5	2	27	27.00	0
35	Teproc	25.5	4	18	24.00	0
37	mightysparks	25	1	30	18.00	0
38	funkybusiness	22	1	40	6.00	0
39	Cinepolis	20.5	4	15	24.75	0
40	filmbantha	17	1	14	11.00	0
40	jal90	17	1	12	21.00	0
42	frbrown	16.5	1	21	26.00	0
43	Coryn	16	2	15	27.50	0
44	Mochard	14	2	12	32.50	0
45	morrison-dylan-fan	12.5	2	9	25.50	0
46	Daviddoes	12	1	17	31.00	0
47	weirdboy	11.5	2	7	19.00	0
48	3eyes	10.5	3	5	23.67	0
49	sacmersault	9	1	6	29.00	0
50	Knaldskalle	7	1	7	35.00	0
50	Nathan Treadway	7	1	5	30.00	0
52	connordenney	6	2	6	37.00	0
53	fear of 13	5.5	1	2	14.00	0
54	DareDaniel	5	1	6	38.00	0
55	Lakigigar	3	1	1	24.00	0

Any mistakes, let me know. This is my first time doing this...

[jeroeno]

How wonderful. jdidaco has exactly the same number of films watched and average ranking and has even won a challenge but is still trailing sol by 1 point. This scoring system is awesome

O yeah, thanks sol for taking over for now

[sol]

How wonderful. jdidaco has exactly the same number of films watched and average ranking and has even won a challenge but is still trailing sol by 1 point. This scoring system is awesome

Yeah, I noticed that. It doesn't matter much anyway since flavo is set to overtake both of us this month.

O yeah, thanks sol for taking over for now

It didn't take me that long to enter in all the data (less than 90 minutes) so I can definitely keep doing this while maxwelldeux has other stuff going on. Not looking forward to November though when I might have to input data from the Horror Challenge. Hopefully things will smooth out for max by then!

I'll see what I can do with the rest of the awards. If max can point me in the right direction in terms of what is not working, I might be able to post the rest. If I'm doing things manually though, I think the only thing that I will be able to track without onerous extra work is Oscar Nominees.

[maxwelldeux]

How wonderful. jdidaco has exactly the same number of films watched and average ranking and has even won a challenge but is still trailing sol by 1 point. This scoring system is awesome

Yeah, I noticed that. It doesn't matter much anyway since flavo is set to overtake both of us this month.

O yeah, thanks sol for taking over for now

It didn't take me that long to enter in all the data (less than 90 minutes) so I can definitely keep doing this while maxwelldeux has other stuff going on. Not looking forward to November though when I might have to input data from the Horror Challenge. Hopefully things will smooth out for max by then!

I'll see what I can do with the rest of the awards. If max can point me in the right direction in terms of what is not working, I might be able to post the rest. If I'm doing things manually though, I think the only thing that I will be able to track without onerous extra work is Oscar Nominees.

Yay the scoring system!

On the spreadsheet, a couple things:
- Copying/pasting is your friend - as is the function "Text to Columns" on the Data tab in Excel (if you want to improve Excel skills, that's where I'd start) and will reduce the time you spend entering data.
- And I actually think things are working in the spreadsheet... the reason you didn't see things update in the other tabs is because a) when you hit "Refresh" on one table, they all update since they're all linked to the same data, and b) everything else is formula-based, so those numbers update automatically as new data are included. Go to the X-X tab and see if columns B-G have a 1 in them next to your name - if they do, all is well and you're updated.

You've actually done the hard part - most of the rest is just copying/pasting. For example, for OscarNom, copy columns A:C, paste them (as values) in K:M, sort by L (i.e., "Current") Descending, and you're ready to go - copy the table code in columns O:U and paste it on the forum (you may have to copy that table down a few extra rows). As a final step, copy columns K:M and paste them in F:H (this sets you up for next time, as the formula in column C looks in column G for that person's prior score). [The process is pretty similar for the other sheets; only Triple-Double is manual.]

That said, PM me with other questions. (and thanks for taking the lead on this!)

[jeroeno]

If it's not too much trouble sol, could you also post the rankings for just the three challenges in February. Pretty please

[sol]

Yeah, I don't know if I can. As in, I'm not sure how to do that without ruining the formula set-up in max's spreadsheet.

For the record, I am currently in a back-and-forth PM swap with max at the moment, sending him screenshots of the parts of the spreadsheet that I'm not sure about. Maybe I should hand this over to someone with better Excel skills than me (shugs comes to mind, but I wouldn't want to pressure him into it). Or maybe max can do all the rest if he has the free time since I have done the hard yakka of entering in the new data. But similarly, I don't want to pressure him.

If I can't figure out this Excel stuff, I'll post the Oscar nominees at least within 48 hours.

[shugs]

Yeah, I don't know if I can. As in, I'm not sure how to do that without ruining the formula set-up in max's spreadsheet.

For the record, I am currently in a back-and-forth PM swap with max at the moment, sending him screenshots of the parts of the spreadsheet that I'm not sure about. Maybe I should hand this over to someone with better Excel skills than me (shugs comes to mind, but I wouldn't want to pressure him into it). Or maybe max can do all the rest if he has the free time since I have done the hard yakka of entering in the new data. But similarly, I don't want to pressure him.

If I can't figure out this Excel stuff, I'll post the Oscar nominees at least within 48 hours.

I have zero Excel skills. I use some scripts I wrote to generate challenge stats. I'll take a look at max's spreadsheet to see if I can code something up quick this week.

[sol]

I have zero Excel skills. I use some scripts I wrote to generate challenge stats.

Whoops. Sorry for calling you out.

Haven't heard back from max in a while. This is the latest file including data added for February if anybody wishes to take a whirl at generating the other awards:

https://we.tl/t-zChSdwxJVw

[sol]

Trying to get this show back on the road. Many thanks to max for helping me out behind the scenes.


2020's Participation Awards



This award is for those who have participated in a wide variety of challenges, powering through to watch at least five films in the challenge.

After February:

Person	Challenges	Change
blueboybob	6	+3
jdidaco	6	+3
jeroeno	6	+3
maxwelldeux	6	+3
OldAle1	6	+3
sol	6	+3
blocho	5	+3
ororama	5	+3
RogerTheMovieManiac88	5	+3
albajos	4	+2
flavo5000	4	+2
nimimerkillinen	4	+1
sebby	4	+2
AB537	3	+1
cinephage	3	+2
hurluberlu	3	+1
klaus78	3	+1
72aicm	2	+0
allisoncm	2	+1
ChrisReynolds	2	+1
India Istanbul	2	+1
Lonewolf2003	2	+1
Mario Gaborović	2	+1
Mochard	2	+1
Obgeoff	2	+1
sheikofhyrule	2	+1
shugs	2	+1
Teproc	2	+1
Traveller	2	+1
VincentPrice	2	+1
vortexsurfer	2	+1
Cinepolis	1	+1
Coryn	1	+0
DareDaniel	1	+0
Daviddoes	1	+0
filmbantha	1	+0
frbrown	1	+0
funkybusiness	1	+0
jal90	1	+1
Knaldskalle	1	+0
Mate_cosido	1	+0
mightysparks	1	+0
morrison-dylan-fan	1	+0
Nathan Treadway	1	+1
peeptoad	1	+0
psychotronicbeatnik	1	+0
redcard29	1	+1
sacmersault	1	+1
Tarris1	1	+1
weirdboy	1	+0
zzzorf	1	+0

[sol]

2020's X/X Awards



This award is for those people who have watched X movies for X official challenges. The first level is easy to obtain - every challenge participant will have watched at least 1 film for 1 official challenge. But each subsequent level is harder to achieve - Level Two is 2 films in each of 2 official challenges, Level Three is 3 films in each of 3 official challenges, Level Ten is 10 films watched in each of 10 official challenges, and so on.

This is max's personal favorite favourite award. It's hard to achieve some of those higher levels, and it's only going to get more interesting as the year goes on. Level 6 is the maximum possible award currently.

After February:

Person	Level	Change
blueboybob	6	+3
jdidaco	6	+3
jeroeno	6	+3
maxwelldeux	6	+3
OldAle1	6	+3
sol	6	+3
blocho	5	+2
ororama	5	+2
RogerTheMovieManiac88	5	+3
albajos	4	+2
cinephage	4	+1
flavo5000	4	+1
hurluberlu	4	+2
nimimerkillinen	4	+1
sebby	4	+2
AB537	3	+1
allisoncm	3	+2
klaus78	3	+1
peeptoad	3	+1
vortexsurfer	3	+2
72aicm	2	+0
ChrisReynolds	2	+1
Cinepolis	2	+1
connordenney	2	+1
Coryn	2	+0
India Istanbul	2	+2
Lonewolf2003	2	+1
Mario Gaborović	2	+1
Mochard	2	+1
morrison-dylan-fan	2	+1
Obgeoff	2	+0
psychotronicbeatnik	2	+1
sheikofhyrule	2	+1
shugs	2	+1
Teproc	2	+1
Traveller	2	+1
VincentPrice	2	+1
zzzorf	2	+1
3eyes	1	+1
DareDaniel	1	+0
Daviddoes	1	+0
fear of 13	1	+0
filmbantha	1	+0
frbrown	1	+0
funkybusiness	1	+0
jal90	1	+1
Knaldskalle	1	+0
Lakigigar	1	+0
Mate_cosido	1	+0
mightysparks	1	+0
Nathan Treadway	1	+1
redcard29	1	+1
sacmersault	1	+1
Tarris1	1	+1
weirdboy	1	+0

[sol]

2020's Obsessed Much? Awards



This threshold is for those slightly obsessive people who managed to watch 36 films for a single challenge, pacing over 1 film/day.

After February:

Person	Count 36+
sol	5
jdidaco	4
albajos	3
psychotronicbeatnik	3
3eyes	2
AB537	2
jeroeno	2
Traveller	2
blueboybob	1
ChrisReynolds	1
cinephage	1
hurluberlu	1
Lonewolf2003	1
Mario Gaborović	1
Mate_cosido	1
OldAle1	1
peeptoad	1
redcard29	1
sebby	1
VincentPrice	1
vortexsurfer	1

---

This threshold is for those very obsessive people who managed to watch 100 films for a single challenge, pacing well over 3 films/day.

After February:

Person	Count 100+
flavo5000	2
72aicm	1
albajos	1
psychotronicbeatnik	1

[sol]

2020 Oscar Nominees*


*I mean, not really - it's just a title. Please don't sue me. Maybe sue maxwell.

This award is for finishing in the Top 5 of one of the official challenges. Level up for each Top 5 finish this year.

After February:

Person	Oscar Noms
jdidaco	5
sol	4
blueboybob	3
flavo5000	3
Mario Gaborović	2
psychotronicbeatnik	2
Traveller	2
72aicm	1
AB537	1
albajos	1
India Istanbul	1
jeroeno	1
OldAle1	1
ororama	1
redcard29	1
RogerTheMovieManiac88	1

And that will have to do us for now. Any mistakes let me know...

[blocho]

I've participated in all six challenges. Sorry to be a pain.

[sol]

I've participated in all six challenges. Sorry to be a pain.

According to max's spreadsheet, you only saw 3 films for the Balkans Challenge.

The Participation Award for 2020 is for participants who have seen 5+ films in a given challenge (see the paragraph I copy and pasted from max above).

[blocho]

I've participated in all six challenges. Sorry to be a pain.

According to max's spreadsheet, you only saw 3 films for the Balkans Challenge.

The Participation Award for 2020 is for participants who have seen 5+ films in a given challenge (see the paragraph I copy and pasted from max above).

My mistake.

[72aicm]

And that will have to do us for now. Any mistakes let me know...

I’m on the +100 scoreboard, but not the +36.
Thanks for doing this though.

[sol]

And that will have to do us for now. Any mistakes let me know...

I’m on the +100 scoreboard, but not the +36.
Thanks for doing this though.

Hmm. I'll investigate this tomorrow after work (and correct it manually if need be). Yes, I still have to go to work in this time of mass self-isolation.

[albajos]

I don't have 3 36+, still only at 1.

[maxwelldeux]

My mistake - I forgot to communicate a step in the process for that award.

[sol]

And that will have to do us for now. Any mistakes let me know...

I’m on the +100 scoreboard, but not the +36.
Thanks for doing this though.

Hmm. I'll investigate this tomorrow after work (and correct it manually if need be). Yes, I still have to go to work in this time of mass self-isolation.

Sorry, I can't do this.

Max has private messaged me with a possible fix to the problem with yourself and albajos but I really can't give any attention to this right now. It is getting more stressful by the day rocking up to work during this pandemic, especially given the shortages of hand santizer/soap and the impossibility of doing my job while remaining the recommended distance of 1.5m away from others.

[psychotronicbeatnik]

I’m on the +100 scoreboard, but not the +36.
Thanks for doing this though.

Hmm. I'll investigate this tomorrow after work (and correct it manually if need be). Yes, I still have to go to work in this time of mass self-isolation.

Sorry, I can't do this.

Max has private messaged me with a possible fix to the problem with yourself and albajos but I really can't give any attention to this right now. It is getting more stressful by the day rocking up to work during this pandemic, especially given the shortages of hand santizer/soap and the impossibility of doing my job while remaining the recommended distance of 1.5m away from others.

Hey sol - thanks for giving it a shot.

[AB537]

Thanks sol for stepping in. Always interesting to see the updated stats.

[sol]

Here's the leaderboard for the first three months of 2020. If I get some time later, I'll try to figure out again how to generate the other awards too, but at least I can post this relatively easily and in good time.


Updated 2020 Leaderboard - January to March

2020 Official Challenge Leaderboard

Rank	Participant	Total Score	# Challenges Competed In	Total Number of films Watched for Official Challenges	Average Rank in Challenges	Number of Challenge Wins
1	flavo5000	222.5	9	614	4.44	2
2	jdidaco	221	9	372	4.78	1
3	sol	219	9	364	5.22	0
4	blueboybob	199.5	9	305	7.11	0
5	jeroeno	180.5	9	235	9.22	0
6	OldAle1	173.5	9	210	10.00	0
7	AB537	145.5	8	237	11.88	1
7	maxwelldeux	145.5	9	142	12.78	0
9	sebby	135	8	154	13.25	0
10	RogerTheMovieManiac88	134.5	8	174	13.50	0
11	ororama	127.5	9	116	15.00	0
12	cinephage	125.5	9	117	15.22	0
13	hurluberlu	119.5	9	119	15.67	0
14	blocho	114.5	9	118	16.11	0
15	psychotronicbeatnik	99	3	403	1.00	3
16	Lonewolf2003	97	4	132	10.00	0
17	albajos	94	6	155	17.33	0
17	nimimerkillinen	94	7	88	17.57	0
19	72aicm	89.5	4	214	10.00	1
20	peeptoad	86	5	102	12.00	0
21	allisoncm	83	9	86	19.56	0
22	Traveller	81	3	186	3.33	0
23	VincentPrice	68.5	4	74	19.25	0
24	shugs	64.5	5	71	20.60	0
25	Obgeoff	64	7	65	21.57	0
26	India Istanbul	62.5	3	75	13.00	0
27	vortexsurfer	60.5	4	81	19.50	0
28	Mario Gaborović	59.5	3	132	2.00	1
29	sheikofhyrule	48.5	2	49	16.00	0
30	ChrisReynolds	42.5	3	50	22.67	0
31	Teproc	41	6	36	24.00	0
32	zzzorf	40.5	7	38	25.29	0
33	klaus78	38	3	32	23.33	0
34	redcard29	35	1	60	3.00	0
35	Mate_cosido	33	1	55	10.00	0
36	frbrown	28	2	38	22.50	0
37	Tarris1	27	1	26	11.00	0
37	Mochard	27	3	30	27.67	0
39	mightysparks	25	1	30	18.00	0
40	Cinepolis	23	5	16	25.80	0
41	Straka	22.5	2	26	20.50	0
42	funkybusiness	22	1	40	6.00	0
43	jal90	19.5	2	13	25.50	0
44	Daviddoes	18	2	19	29.00	0
45	AssOnFire	17	1	25	8.00	0
45	filmbantha	17	1	14	11.00	0
47	Coryn	16	2	15	27.50	0
48	morrison-dylan-fan	12.5	2	9	25.50	0
49	John Milton	12	1	12	22.00	0
50	weirdboy	11.5	2	7	19.00	0
51	connordenney	11	3	13	33.33	0
52	3eyes	10.5	3	5	23.67	0
53	sacmersault	9	1	6	29.00	0
54	Knaldskalle	8	2	9	32.50	0
55	Nathan Treadway	7	1	5	30.00	0
56	Melvelet	6.5	1	2	17.00	0
57	fear of 13	5.5	1	2	14.00	0
58	DareDaniel	5	1	6	38.00	0
59	Lakigigar	3	1	1	24.00	0
60	mathiasa	2.5	1	1	30.00	0

Any glaring errors, let me know...

[Traveller]

Thank you for continuing this, sol.

[sol]

No problem.

[psychotronicbeatnik]

Here's the leaderboard for the first three months of 2020. If I get some time later, I'll try to figure out again how to generate the other awards too, but at least I can post this relatively easily and in good time.

Thanks sol! I'm not doing any challenges this month so it looks like i will probably drop out of the top 20, maybe even the top 25. Oh well.

Do you think you could work your magic on the overall leader board as well? I don't think that's been updated for at least the last two months.