Spreadsheet: 878142d1725149395-limit-filter-list-to-unique-values-periodic-table-example-copy
Sheet: All Completed Runs - Period

MY parkruns - ALL COMPLETED RUNS - PERIODIC TABLE
Complete all Events (Venues) where the name contains letters related to the elements of the Periodic Table. i.e. The Event (Venue) name must start with the first letter of the element's Chemical Symbol, as well as (where applicable) containing (anywhere after), the second letter of the Chemical Symbol. Except for 'Xe' ('[NAME]'), as there are no 'X' Events (Venues). |  |  |  |  |  |  |  |  |  |  |  |  | Manually Inputted correct values
Atomic # | Chemical Symbol | Element Name | Metal - Metalloid - Non-Metal Trend Sub-Category | Metal - Metalloid - Non-Metal | State of Matter | Group | Period | Block | Block, by Period | Event (Venue) | Date Completed | # [NAME] | Event (Venue) | Date Completed | Does the current formula give the correct result?  i.e. K matches N
1 | H | Hydrogen | Non-Metal | Non-Metal | Gas | 1 | 1 | s | 1s |  |  |  | [NAME] parkrun | 2019-07-06 00:00:00
2 | He | Helium | Noble Gas | Non-Metal | Gas | 18 | 1 | s | 1s |  |  |  | Haverfordwest parkrun | 2020-02-08 00:00:00
3 | [NAME] | Lithium | Alkali Metal | Metal | Solid | 1 | 2 | s | 2s |  |  |  | [NAME] parkrun | 2020-02-22 00:00:00
4 | Be | Beryllium | Alkaline Earth Metal | Metal | Solid | 2 | 2 | s | 2s |  |  |  | Burnham and Highbridge parkrun | 2021-07-24 00:00:00
5 | B | [NAME] | Metalloid | Metalloid | Solid | 13 | 2 | p | 2p |  |  |  | Bryn Bach parkrun | 2018-07-07 00:00:00
6 | C | Carbon | Non-Metal | Non-Metal | Solid | 14 | 2 | p | 2p |  |  |  | Colby parkrun | 2017-05-20 00:00:00
7 | N | Nitrogen | Non-Metal | Non-Metal | Gas | 15 | 2 | p | 2p |  |  |  | Newent parkrun | 2019-11-02 00:00:00
8 | O | [NAME] | Non-Metal | Non-Metal | Gas | 16 | 2 | p | 2p |  |  |  | Oxford parkrun | 2021-07-31 00:00:00
9 | F | Fluorine | Halogen | Non-Metal | Gas | 17 | 2 | p | 2p |  |  |  | Fountains Abbey parkrun | 2024-07-13 00:00:00
10 | Ne | Neon | Noble Gas | Non-Metal | Gas | 18 | 2 | p | 2p
11 | Na | Sodium | Alkali Metal | Metal | Solid | 1 | 3 | s | 3s
12 | [NAME] | Magnesium | Alkaline Earth Metal | Metal | Solid | 2 | 3 | s | 3s |  |  |  | Maesteg parkrun | 2021-11-06 00:00:00
13 | Al | Aluminium | Post-Transition Metal | Metal | Solid | 13 | 3 | p | 3p |  |  |  | Arrow Valley parkrun | 2022-10-15 00:00:00
14 | Si | Silicon | Metalloid | Metalloid | Solid | 14 | 3 | p | 3p |  |  |  | Severn Bridge parkrun | 2018-08-11 00:00:00
15 | P | Phosphorus | Non-Metal | Non-Metal | Solid | 15 | 3 | p | 3p |  |  |  | Penallta parkrun | 2018-05-26 00:00:00
16 | S | Sulfur | Non-Metal | Non-Metal | Solid | 16 | 3 | p | 3p |  |  |  | Somerdale Pavilion parkrun | 2019-06-29 00:00:00
17 | Cl | Chlorine | Halogen | Non-Metal | Gas | 17 | 3 | p | 3p |  |  |  | Churchfields Farm parkrun | 2019-08-10 00:00:00
18 | Ar | Argon | Noble Gas | Non-Metal | Gas | 18 | 3 | p | 3p |  |  |  | Aberdare parkrun | 2019-09-21 00:00:00
19 | K | Potassium | Alkali Metal | Metal | Solid | 1 | 4 | s | 4s |  |  |  | parkrun [NAME] | 2018-12-08 00:00:00
20 | Ca | Calcium | Alkaline Earth Metal | Metal | Solid | 2 | 4 | s | 4s |  |  |  | Cwmbran parkrun | 2018-08-18 00:00:00
21 | Sc | Scandium | Transition Metal | Metal | Solid | 3 | 4 | d | 3d |  |  |  | Southwick Country parkrun | 2020-01-01 00:00:00
22 | Ti | Titanium | Transition Metal | Metal | Solid | 4 | 4 | d | 3d |  |  |  | Tokoinranta parkrun | 2019-12-07 00:00:00
23 | V | Vanadium | Transition Metal | Metal | Solid | 5 | 4 | d | 3d |  |  |  | [NAME] parkrun | 2022-05-07 00:00:00
24 | Cr | Chromium | Transition Metal | Metal | Solid | 6 | 4 | d | 3d |  |  |  | Chipping Sodbury parkrun | 2019-12-14 00:00:00
25 | Mn | Manganese | Transition Metal | Metal | Solid | 7 | 4 | d | 3d |  |  |  | parkrun [NAME] | 2016-06-04 00:00:00
26 | Fe | Iron | Transition Metal | Metal | Solid | 8 | 4 | d | 3d |  |  |  | Five Arches parkrun | 2023-10-14 00:00:00
27 | Co | Cobalt | Transition Metal | Metal | Solid | 9 | 4 | d | 3d |  |  |  | [NAME] parkrun | 2019-10-19 00:00:00
28 | Ni | Nickel | Transition Metal | Metal | Solid | 10 | 4 | d | 3d
29 | Cu | Copper | Transition Metal | Metal | Solid | 11 | 4 | d | 3d |  |  |  | Coed Cefn-pwll-du parkrun | 2020-01-18 00:00:00
30 | Zn | Zinc | Transition Metal | Metal | Solid | 12 | 4 | d | 3d
31 | Ga | Gallium | Post-Transition Metal | Metal | Solid | 13 | 4 | p | 4p |  |  |  | Grangemoor parkrun | 2019-02-02 00:00:00
32 | Ge | Germanium | Metalloid | Metalloid | Solid | 14 | 4 | p | 4p |  |  |  | Groe parkrun | 2019-06-01 00:00:00
33 | As | Arsenic | Metalloid | Metalloid | Solid | 15 | 4 | p | 4p |  |  |  | Aberfields parkrun | 2023-08-26 00:00:00
34 | Se | Selenium | Non-Metal | Non-Metal | Solid | 16 | 4 | p | 4p |  |  |  | Sandy Water parkrun | 2021-08-28 00:00:00
35 | Br | Bromine | Halogen | Non-Metal | Liquid | 17 | 4 | p | 4p |  |  |  | Bushy parkrun | 2019-08-24 00:00:00
36 | Kr | Krypton | Noble Gas | Non-Metal | Gas | 18 | 4 | p | 4p |  |  |  | King [NAME] parkrun, [NAME] | 2022-02-26 00:00:00
37 | Rb | Rubidium | Alkali Metal | Metal | Solid | 1 | 5 | s | 5s
38 | Sr | Strontium | Alkaline Earth Metal | Metal | Solid | 2 | 5 | s | 5s |  |  |  | [NAME] parkrun, [NAME] | 2022-01-08 00:00:00
39 | Y | Yttrium | Transition Metal | Metal | Solid | 3 | 5 | d | 4d |  |  |  | York parkrun | 2022-04-30 00:00:00
40 | Zr | Zirconium | Transition Metal | Metal | Solid | 4 | 5 | d | 4d |  |  |  | Zuiderpark parkrun, [NAME] | 2023-05-27 00:00:00
41 | Nb | Niobium | Transition Metal | Metal | Solid | 5 | 5 | d | 4d |  |  |  | Newbury parkrun | 2022-06-11 00:00:00
42 | Mo | Molybdenum | Transition Metal | Metal | Solid | 6 | 5 | d | 4d |  |  |  | Milford Waterfront parkrun | 2020-02-01 00:00:00
43 | Tc | Technetium | Transition Metal | Metal | Solid | 7 | 5 | d | 4d |  |  |  | Tooting Common parkrun | 2021-10-02 00:00:00
44 | Ru | Ruthenium | Transition Metal | Metal | Solid | 8 | 5 | d | 4d
45 | Rh | Rhodium | Transition Metal | Metal | Solid | 9 | 5 | d | 4d |  |  |  | Rheinpark parkrun | 2022-10-03 00:00:00
46 | Pd | Palladium | Transition Metal | Metal | Solid | 10 | 5 | d | 4d |  |  |  | Pontypridd parkrun | 2018-09-29 00:00:00
47 | Ag | Silver | Transition Metal | Metal | Solid | 11 | 5 | d | 4d |  |  |  | Aberbeeg parkrun | 2018-11-03 00:00:00
48 | Cd | Cadmium | Transition Metal | Metal | Solid | 12 | 5 | d | 4d |  |  |  | Cardiff parkrun | 2019-12-28 00:00:00
49 | In | Indium | Post-Transition Metal | Metal | Solid | 13 | 5 | p | 5p |  |  |  | Itchen Valley Country parkrun | 2022-11-05 00:00:00
50 | Sn | Tin | Post-Transition Metal | Metal | Solid | 14 | 5 | p | 5p |  |  |  | Swansea Bay parkrun | 2021-10-09 00:00:00
51 | Sb | Antimony | Metalloid | Metalloid | Solid | 15 | 5 | p | 5p |  |  |  | Salisbury parkrun | 2023-02-11 00:00:00
52 | Te | Tellurium | Metalloid | Metalloid | Solid | 16 | 5 | p | 5p |  |  |  | Tremorfa parkrun | 2019-11-23 00:00:00
53 | I | Iodine | Halogen | Non-Metal | Solid | 17 | 5 | p | 5p |  |  |  | Inis Meáin parkrun | 2023-09-30 00:00:00
55 | Cs | Caesium | Alkali Metal | Metal | Solid | 1 | 6 | s | 6s |  |  |  | Chipping Norton School parkrun | 2021-09-04 00:00:00
56 | Ba | Barium | Alkaline Earth Metal | Metal | Solid | 2 | 6 | s | 6s |  |  |  | Brynaman parkrun | 2020-03-07 00:00:00
57 | La | Lanthanum | Lanthanide | Metal | Solid | 3 | 6 | d | 5d |  |  |  | Llanerchaeron parkrun | 2021-11-13 00:00:00
58 | Ce | Cerium | Lanthanide | Metal | Solid | 4 | 6 | f | 4f |  |  |  | Chippenham parkrun | 2020-01-04 00:00:00
59 | Pr | Praseodymium | Lanthanide | Metal | Solid | 5 | 6 | f | 4f |  |  |  | [NAME] parkrun | 2019-07-13 00:00:00
60 | Nd | Neodymium | Lanthanide | Metal | Solid | 6 | 6 | f | 4f
61 | Pm | Promethium | Lanthanide | Metal | Solid | 7 | 6 | f | 4f |  |  |  | [NAME] parkrun | 2024-03-23 00:00:00
62 | Sm | Samarium | Lanthanide | Metal | Solid | 8 | 6 | f | 4f |  |  |  | [NAME] parkrun | 2022-03-05 00:00:00
63 | Eu | Europium | Lanthanide | Metal | Solid | 9 | 6 | f | 4f |  |  |  | Exmouth parkrun | 2023-07-15 00:00:00
64 | Gd | Gadolinium | Lanthanide | Metal | Solid | 10 | 6 | f | 4f |  |  |  | [NAME] parkrun | 2022-07-16 00:00:00
65 | Tb | Terbium | Lanthanide | Metal | Solid | 11 | 6 | f | 4f |  |  |  | Thornbury parkrun | 2021-08-14 00:00:00
66 | Dy | Dysprosium | Lanthanide | Metal | Solid | 12 | 6 | f | 4f |  |  |  | [NAME] parkrun | 2020-02-15 00:00:00
67 | [NAME] | Holmium | Lanthanide | Metal | Solid | 13 | 6 | f | 4f |  |  |  | Harcourt Hill parkrun | 2022-06-25 00:00:00
68 | Er | Erbium | Lanthanide | Metal | Solid | 14 | 6 | f | 4f |  |  |  | Edgbaston Reservoir parkrun | 2024-01-01 00:00:00
69 | Tm | Thulium | Lanthanide | Metal | Solid | 15 | 6 | f | 4f |  |  |  | [NAME] parkrun | 2023-07-29 00:00:00
70 | Yb | Ytterbium | Lanthanide | Metal | Solid | 16 | 6 | f | 4f |  |  |  | Yarborough Leisure Centre parkrun | 2023-06-17 00:00:00
71 | [NAME] | Lutetium | Lanthanide | Metal | Solid | 17 | 6 | f | 4f |  |  |  | Longrun Meadow parkrun | 2022-05-21 00:00:00
72 | Hf | Hafnium | Transition Metal | Metal | Solid | 4 | 6 | d | 5d |  |  |  | Haldon Forest parkrun | 2023-09-02 00:00:00
73 | Ta | Tantalum | Transition Metal | Metal | Solid | 5 | 6 | d | 5d |  |  |  | Trelai Park parkrun | 2021-09-25 00:00:00
74 | W | Tungsten | Transition Metal | Metal | Solid | 6 | 6 | d | 5d |  |  |  | Woolacombe Dunes parkrun | 2019-08-17 00:00:00
75 | Re | Rhenium | Transition Metal | Metal | Solid | 7 | 6 | d | 5d |  |  |  | Riverside Walk parkrun | 2023-10-28 00:00:00
76 | Os | Osmium | Transition Metal | Metal | Solid | 8 | 6 | d | 5d |  |  |  | Oaklands parkrun | 2024-01-06 00:00:00
77 | Ir | Iridium | Transition Metal | Metal | Solid | 9 | 6 | d | 5d |  |  |  | Isabel Trail parkrun | 2022-03-12 00:00:00
78 | Pt | Platinum | Transition Metal | Metal | Solid | 10 | 6 | d | 5d |  |  |  | Pontypool parkrun | 2018-08-25 00:00:00
79 | Au | Gold | Transition Metal | Metal | Solid | 11 | 6 | d | 5d |  |  |  | Ashton Court parkrun | 2019-05-25 00:00:00
80 | Hg | Mercury | Transition Metal | Metal | Liquid | 12 | 6 | d | 5d |  |  |  | Henstridge [NAME] parkrun | 2023-04-15 00:00:00
81 | Tl | Thallium | Post-Transition Metal | Metal | Solid | 13 | 6 | p | 6p |  |  |  | The Old [NAME] parkrun | 2022-04-02 00:00:00
82 | Pb | Lead | Post-Transition Metal | Metal | Solid | 14 | 6 | p | 6p |  |  |  | Pont y [NAME] parkrun | 2023-07-08 00:00:00
83 | Bi | Bismuth | Post-Transition Metal | Metal | Solid | 15 | 6 | p | 6p |  |  |  | Barry Island parkrun | 2021-12-04 00:00:00
84 | Po | Polonium | Metalloid | Metalloid | Solid | 16 | 6 | p | 6p |  |  |  | Porthcawl parkrun | 2021-10-16 00:00:00
85 | At | Astatine | Halogen | Non-Metal | Solid | 17 | 6 | p | 6p |  |  |  | Aberystwyth parkrun | 2022-10-22 00:00:00
86 | Rn | Radon | Noble Gas | Non-Metal | Gas | 18 | 6 | p | 6p |  |  |  | [NAME]-on-Wye parkrun | 2019-08-03 00:00:00
87 | Fr | Francium | Alkali Metal | Metal | Solid | 1 | 7 | s | 7s |  |  |  | Forest of [NAME] parkrun | 2019-09-07 00:00:00
88 | Ra | Radium | Alkaline Earth Metal | Metal | Solid | 2 | 7 | s | 7s |  |  |  | Reading parkrun | 2022-10-08 00:00:00
89 | Ac | Actinium | Actinide | Metal | Solid | 3 | 7 | d | 6d
90 | Th | Thorium | Actinide | Metal | Solid | 4 | 7 | f | 5f |  |  |  | Tetbury Goods Shed parkrun | 2021-11-20 00:00:00
91 | Pa | Protactinium | Actinide | Metal | Solid | 5 | 7 | f | 5f |  |  |  | Pontefract parkrun | 2023-06-10 00:00:00
92 | U | Uranium | Actinide | Metal | Solid | 6 | 7 | f | 5f |  |  |  | University [NAME] parkrun | 2022-04-23 00:00:00
93 | Np | Neptunium | Actinide | Metal | Solid | 7 | 7 | f | 5f |  |  |  | Newport parkrun | 2011-04-09 00:00:00
94 | Pu | Plutonium | Actinide | Metal | Solid | 8 | 7 | f | 5f |  |  |  | [NAME] parkrun | 2024-05-18 00:00:00
95 | Am | Americium | Actinide | Metal | Solid | 9 | 7 | f | 5f |  |  |  | Amager Fælled parkrun | 2024-05-09 00:00:00
96 | Cm | Curium | Actinide | Metal | Solid | 10 | 7 | f | 5f |  |  |  | [NAME] parkrun | 2021-09-11 00:00:00
97 | Bk | Berkelium | Actinide | Metal | Solid | 11 | 7 | f | 5f |  |  |  | Berkeley Green parkrun | 2021-08-07 00:00:00
98 | Cf | Californium | Actinide | Metal | Solid | 12 | 7 | f | 5f |  |  |  | Chippenham Playing Fields parkrun, Monmouth | 2022-09-24 00:00:00
99 | Es | Einsteinium | Actinide | Metal | Solid | 13 | 7 | f | 5f |  |  |  | Eastville parkrun | 2019-06-22 00:00:00
100 | Fm | Fermium | Actinide | Metal | Solid | 14 | 7 | f | 5f |  |  |  | Frogmary Green Farm parkrun | 2022-12-03 00:00:00
101 | [NAME] | Mendelevium | Actinide | Metal | Solid | 15 | 7 | f | 5f
102 | No | Nobelium | Actinide | Metal | Solid | 16 | 7 | f | 5f |  |  |  | Newtown parkrun | 2023-07-01 00:00:00
103 | [NAME] | Lawrencium | Actinide | Metal | Solid | 17 | 7 | f | 5f |  |  |  | Lydiard parkrun | 2020-01-01 00:00:00
104 | Rf | Rutherfordium | Transition Metal | Metal | Solid | 4 | 7 | d | 6d |  |  |  | Riverfront parkrun | 2017-10-21 00:00:00
105 | Db | Dubnium | Transition Metal | Metal | Solid | 5 | 7 | d | 6d |  |  |  | Dallas Burston Polo Club parkrun | 2022-10-29 00:00:00
106 | [NAME] | Seaborgium | Transition Metal | Metal | Solid | 6 | 7 | d | 6d |  |  |  | Sharpham Road Playing Fields parkrun | 2022-09-03 00:00:00
107 | Bh | Bohrium | Transition Metal | Metal | Solid | 7 | 7 | d | 6d |  |  |  | Bath Skyline parkrun | 2022-02-19 00:00:00
108 | Hs | Hassium | Transition Metal | Metal | Solid | 8 | 7 | d | 6d |  |  |  | Horspath parkrun | 2022-08-20 00:00:00
109 | Mt | Meitnerium | Transition Metal | Metal | Solid | 9 | 7 | d | 6d |  |  |  | Merthyr parkrun | 2019-11-30 00:00:00
110 | Ds | Darmstadtium | Transition Metal | Metal | Solid | 10 | 7 | d | 6d |  |  |  | [NAME] parkrun | 2022-07-02 00:00:00
111 | Rg | Roentgenium | Transition Metal | Metal | Solid | 11 | 7 | d | 6d |  |  |  | Rogiet parkrun | 2020-01-25 00:00:00
112 | Cn | Copernicium | Transition Metal | Metal | Solid | 12 | 7 | d | 6d |  |  |  | Cheltenham parkrun | 2021-12-25 00:00:00
113 | Nh | Nihonium | Post-Transition Metal | Metal | Solid | 13 | 7 | p | 7p
114 | Fl | Flerovium | Post-Transition Metal | Metal | Solid | 14 | 7 | p | 7p
115 | Mc | Moscovium | Post-Transition Metal | Metal | Solid | 15 | 7 | p | 7p |  |  |  | Marlborough Common parkrun | 2022-04-16 00:00:00
116 | Lv | Livermorium | Post-Transition Metal | Metal | Solid | 16 | 7 | p | 7p
117 | Ts | Tennessine | Halogen | Non-Metal | Solid | 17 | 7 | p | 7p |  |  |  | Tewkesbury parkrun | 2022-01-22 00:00:00
118 | Og | Oganesson | Noble Gas | Non-Metal | Gas | 18 | 7 | p | 7p