Seeing as I have sod all to do right now I'm ringing the individual sites and asking, this will be as accurate as possible, I'm also doing the co ordinates for each site and adding them to the xls file, I know that someone can figure out how to make them clickable with hyperlinks (not me) so you get directions on Google maps
Go to Streetmap (
http://www.streetmap.co.uk/) put in the postcode. Get the map up.
Bottom of the map is a link "convert coordinates". This opens up a new window with the cooridantes in a million different formats including OSGB36 Lat/Long - 7th entry down - (to a million decimal places (!)).
Then put the next postcode into the window beneath the table and it computes the conversion without re-loading the map.
I did the last 10 on the spreadsheet (seeing as you were going top-down
) just to see...
ME10 3ET | ///seated.darker.unfair |
B10 0XA | ///limp.asks.goals |
WA9 3DH | ///ages.instilled.applauded |
ME2 2AA | ///park.bought.duty |
SA1 7DF | ///stole.level.goals |
TW14 9AE | postcode not found |
BD3 7HZ | ///mining.eagle.vague |
NN8 4LL | ///mash.dates.script |
PE14 0DG | ///wheat.galaxies.amplified |
LL13 7TU | ///slips.cards.bared |
Ah
That wasn't quite what I expected...
Lets try this one :/
ME10 3ET 51.34393066270711,0.7322119776213797
B10 0XA 52.47429523183065,-1.8662786245124026
WA9 3DH 53.440979973711634,-2.713566556962546
ME2 2AA 51.392989903212005,0.4932344566718507
SA1 7DF 51.64353733314074,-3.926591336267315
TW14 9AE postcode not found
BD3 7HZ 53.802814067013536,-1.7105496207694075
NN8 4LL 52.30099942221961,-0.6957405847348906
PE14 0DG 52.651844277033376,0.17080539769243105
LL13 7TU 53.04333584922998,-3.004505458062534