ABCDEFGHIJKLMNOPQRSTUVWXY
1
Periodic Table Challenge v1.04 Feb 2024 www.tinyurl.com/PeriodicTableChallenge don't forget the hashtag when you post: #periodictablechallenge
2
Objective/Rules
3
The Periodic Table is made up of 118 elements. The objective is to complete the table by running at venues which meet the criteria:
4
The first letter of the element needs to be the same as the first letter of the venue name
5
The second letter of the element can appear anywhere else in the venue name
6
There is just 1 eXception - Xe (Xenon) - there are currently no parkruns starting with X, therefore a venue containing an x (and an e anywhere after the x) in the venue name is acceptable e.g. Bexley
7
Instructions
8
PLEASE MAKE YOUR OWN COPY OF THIS TEMPLATE: Click on File then Make a copy then rename it then Make a copy
9
1. On the input tab, copy/paste the Tourism section of your stats from https://www.parkrun.org.uk/parkrunner/XXXXXXX/all/
(XXXXXXX should be your athlete number without the A). You'll need to do this from Chrome, with the Running Challenges extension installed
10
2. On the assign elements to venues tab, enter your athlete number e.g. A1234567 into cell H2 (this is just for display on the output)
11
3. Then in column H, manually assign (up to 118) elements to venues completed - the quickest way is as follows:
12
a) Filter on column E for each letter, one at a time - venues completed are shaded blue and the total list of venues is in red text
13
b) In columns I-DV, the elements which match to venues are shown. Starting from the top, in column H, enter a matching element for each completed venue. If it is a correct match, the corresponding cells in row 4 and column G will turn green and the running total in cell G1 will update
14
Note that there choices you can make regarding the element associated with a venue, but an element can't be used more than once. It's better to choose elements with fewer venues to make the challenge easier to complete, but it's possible (and encouraged) to re-assign elements to venues during completion
15
c) Repeat for all letters (it doesn't take as long as you think!)
16
If you have completed a venue that works for Xe (see Xe tab), there won't be any matches in column DR, but allocate in column H as above and the venue will count as completed and show in the output
17
Note that some venues don't match to any element e.g. Didcot; a small number of venues don't start with A-Z and don't match to any elements e.g. Żary; and a small number of venues contain letters other than a-z but other letters may match to elements e.g. Tøyen
18
To view all venues in order to choose future venues to complete the challenge, scroll down to row 700, or filter on column G then clear and select specific countries. Column C can be used to filter out Restricted or Closed venues. Filters on row 4 (columns I-DV) can be used to remove blanks and see venues which match each element. Also, the "parkrunner 5k" app can be filtered to find events starting with a certain letter and containing a second letter
19
4. Your Periodic Table Challenge as it stands will appear on the output tab. The colours are arbitrary. To take a copy, choose File then Download then pdf; or use the Snipping Tool and save as a (low-res) jpg e.g. for a Facebook post. When it's completed, go to the creating an A2 poster tab
20
FINALLY, if a later version of the template is created, take a copy of the new template and copy/paste the Tourism section as above and also copy across column H
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100