Got a fair whack of the control locations in; that's assuming mapquest got the ones it identified as being in the UK right
it's also assuming the ones I did manually in google maps I've picked up the co-ordinates right (i just tested Land's end and had the co-ords for the north channel...)
There are some in the "controls missing mappings" list that I've been unable to identify even by working out a route around the other controls on routes it appears in; see "Victoria"
There's also cases such as Richmond, where there are multiple places; it's possibly that it could be Richmond North Yorks, Richmond London or some other Richmond.
I don't know for sure that they've been made distinct in all uses of them; so if you spot a ride in North Yorks that has a spike down to London or somewhere else improbable for the distance, it can be fixed by adjusting the control list (you may need to either identify the correct place from the list or add a new control to the list).
I've cleaned a few up as some were being entered but I'm away now until I get back from the Borders of Fife
Keep the control list to controls separated by commas, if there's also useful text around the control list on the website put that into the extra info column.
Fictional example:
Website Description: Cracking route in the borders from Gala, Controls at Glen Cafe St Mary's loch, Moffat or Johnstone bridge and Langholm
Extra info - Cracking route in the borders from Gala, Controls at Glen Cafe St Mary's loch, Moffat or Johnstone bridge and Langholm
Control List - Gala, Glen Cafe St Mary's loch, Moffat, Johnstone Bridge, Langholm, Gala
Also, avoid trailing commas or full stops on the last entry in the control list as that won't then match the controls that are already entered.
To add a control from the missing list (unless it's the first in the missing list)
Copy the text from the column B of the Controls Extract
Drop it into Column A of the Control Mapping sheet and put the GPS co-ordinates in Column B
That control should then automatically disappear from column B of the Controls Extract
Beats sitting reading my colleagues code all day since they hung onto the reviews until the end of the project they're doing...