DATA - The best hidden wild swimming spots in the UK.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		Weight								0.3				0.3		0.4	1
2	Rank	Swimming Spot	Latitude	Longitude	Car Park Distance (km)	Public Transport Distance (km)	Nearest Major Road Distance (km)	Nearest Major City	City Distance (km)	Average Temperature (°C)	Rating (/5)	N_reviews	Rating * N_reviews	Weighted Rating (/10)	Seclusion Score	Seclusion Score min-max normalized (/10)	Score (/10)
3	1	Llyn Cau, Cadair Idris	52.6993814	-3.9080548	15.9	4.7	8	Wrecsam	100.0	14.7544	5	3	15.00	2.71	32.15	8.52	8.57
4	2	Cuckmere Meanders	50.83767984	0.21544364	6.3	2.8	8.2	Hastings	32.3	16.1205	4	3	12.00	2.08	12.40	2.89	8.52
5	3	Long Pool, Watersmeet	51.220326	-3.787054	5.7	8.4	8.3	Taunton	64.0	15.7148	4.5	2	9.00	1.46	21.60	5.52	8.45
6	4	Coastal – Tanners Lane, Lymington	50.7594172	-1.4857266	4.3	4.1	13.8	Southampton	31.5	16.2533	5	2	10.00	1.67	13.43	3.19	8.44
7	5	Watkins path Waterfall or Gorge	53.0533989	-4.0671003	11.8	3.4	10.3	Rhyl	72.0	14.7544	5	3	15.00	2.71	24.38	6.31	8.42
8	6	Blue Pool, Golwern Quarry	50.6496836	-2.0937092	5.3	1.7	3.7	Bournemouth	27.8	16.0213	5	5	25.00	4.79	9.63	2.10	8.32
9	7	River Chelmer near Ulting	51.7507671	0.6121086	6.3	4.5	6.9	Chelmsford	15.4	17.0041	5	10	50.00	10.00	8.28	1.72	8.19
10	8	Frensham Great Pond	51.1552136	-0.7917955	7.2	1.4	8.7	Fleet	16.8	16.1680	3.5	7	24.50	4.69	8.53	1.79	8.14
11	9	Santon, Little Ouse	52.36124186	0.984246578	3.8	4.2	4.4	Norwich	45.2	15.9197	3.5	2	7.00	1.04	14.40	3.46	7.99
12	10	Gill Force, Eskdale	54.4885462	-3.1902523	0.3	6.1	9.5	Kendal	62.8	14.7066	5	3	15.00	2.71	19.68	4.97	7.91
13	11	Rockford Pools	51.21801	-3.786975	5.6	8.1	8	Taunton	65.5	15.7148	5	1	5.00	0.63	21.80	5.57	7.90
14	12	Minster Lovell, Windrush	51.798368	-1.538407	7.1	0.5	7.7	Oxford	28.1	15.9426	5	2	10.00	1.67	10.85	2.45	7.87
15	13	Carding Mill Valley Reservoir	52.5458333	-2.8225	3.6	1.4	4.3	Wellington	37.1	14.7672	4	5	20.00	3.75	11.60	2.67	7.82
16	14	Colliford Lake and Dozmary	50.5261917	-4.5738386	2.7	6	5	Plymouth	44.4	15.1705	4.5	2	9.00	1.46	14.53	3.50	7.76
17	15	Colber Bridge	50.9277711	-2.3106198	0.4	0.4	11.4	Yeovil	27.8	15.7123	4	3	12.00	2.08	10.00	2.21	7.74
18	16	Chagford Lido, Teign	50.673066	-3.840265	0.2	0.4	5.3	Exeter	32.6	15.9484	5	2	10.00	1.67	9.63	2.10	7.66
19	17	Achmelvich	58.168197	-5.303322	0.3	1.1	5.9	Inverness	142.0	12.0943	5	2	10.00	1.67	37.33	10.00	7.61
20	18	Symonds Yat	51.8463095	-2.6462794	7.2	1.8	10.7	Gloucester	39.8	15.7796	5	1	5.00	0.63	14.88	3.60	7.59
21	19	Tarr Steps, Barle	51.077136	-3.6176739	7.9	5.4	10.6	Taunton	46.3	15.7148	5	1	5.00	0.63	17.55	4.36	7.59
22	20	Rhaeadr Du	52.80343331	-3.901918139	3.9	4.7	10.8	Wrecsam	89.6	14.7544	5	1	5.00	0.63	27.25	7.13	7.49
23	21	Wash Pool, Irfon	52.136578	-3.668148	0.9	4.8	4.8	Merthyr Tudful	67.0	14.3303	5	2	10.00	1.67	19.38	4.88	7.39
24	22	Linhope Spout, Breamish	55.4478166	-2.0671024	7.4	15.2	10.6	Ashington	58.1	13.9115	4	2	8.00	1.25	22.83	5.87	7.34
25	23	Blue Lagoon, Moel-y-Faen	53.0219444	-3.2149653	1	5.6	8.6	Wrecsam	21.4	15.0902	2.5	7	17.50	3.23	9.15	1.97	7.28
26	24	Spitchwick Common	50.526586	-3.8155652	0.5	0.5	5.4	Paignton	27.5	15.6861	3.5	3	10.50	1.77	8.48	1.77	7.13
27	25	Fairy Glen	53.07458	-3.793992	2.2	2.1	2.3	Rhyl	48.7	14.6254	5	2	10.00	1.67	13.83	3.30	7.13
28	26	Pamphill	50.800007	-2.016893	2.2	4.7	8.1	Bournemouth	19.4	16.0213	4	2	8.00	1.25	8.60	1.81	7.13
29	27	Stainforth Force	54.1001082	-2.2792852	0.5	2.5	5.6	Burnley	43.1	13.9098	4	3	12.00	2.08	12.93	3.04	7.08
30	28	Llyn Dinas	53.0256944	-4.0628135	3.6	1.5	10.4	Rhyl	70.4	14.7544	5	1	5.00	0.63	21.48	5.48	7.07
31	29	Hatchmere	53.242854	-2.668127	1.2	0.023	6.8	Ellesmere Port	19.8	15.0902	4	8	32.00	6.25	6.96	1.34	7.04
32	30	Farleigh Hungerford, Frome	51.3165461	-2.286885	2.4	2	5.3	Trowbridge	6.6	15.3221	4	10	40.00	7.92	4.08	0.52	7.03
33	31	Warleigh Weir, Claverton	51.3770909	-2.3006406	7.2	5.5	5.3	Bath	7.3	15.3189	4	5	20.00	3.75	6.33	1.16	7.02
34	32	Rhaeadr Mawddach	52.8301099	-3.878087	4.7	3.7	8.1	Wrecsam	85.1	14.7544	4	1	4.00	0.42	25.40	6.60	6.99
35	33	Blackmoss Pot	54.4918029	-3.1328319	2.4	3.3	20.8	Kendal	60.1	14.7066	5	1	5.00	0.63	21.65	5.53	6.96
36	34	Pen-y-Fan, Nant Sere	51.8840481	-3.4364427	3.9	3.8	8.7	Merthyr Tudful	32.7	15.6025	5	1	5.00	0.63	12.28	2.86	6.96
37	35	Loughrigg Tarn	54.430556	-3.011667	7	1.6	2.2	Kendal	27.6	14.7066	4.5	4	18.00	3.33	9.60	2.10	6.95
38	36	Thomason Foss	54.4077354	-0.7301149	1.3	1.3	1.9	Scarborough	38.6	13.6762	4	5	20.00	3.75	10.78	2.43	6.88
39	37	Soldier’s Leap	56.7422238	-3.774712	2.1	0.3	6.1	Dunfermline	96.1	13.5590	5	1	5.00	0.63	26.15	6.81	6.87
40	38	Double Waters, river Walkham and Tavy	50.509063	-4.150791	11.6	7.3	6.9	Plymouth	19.9	15.6861	5	1	5.00	0.63	11.43	2.62	6.86
41	39	Sheriff Muir Paradise Pools	56.1871009	-3.9042214	3.4	7.5	7.1	Falkirk	26.6	13.7426	3	5	15.00	2.71	11.15	2.54	6.84
42	40	Mermaid’s Pool	53.3947802	-1.8892924	2.1	7.2	9.7	Stockport	21.1	14.9352	4	2	8.00	1.25	10.03	2.22	6.70
43	41	Clifton Hampden, Thames	51.658025	-1.2075419	2.5	2.1	8.9	Abingdon	7.5	15.8230	5	2	10.00	1.67	5.25	0.86	6.68
44	42	Hampstead Ponds	51.5556461	-0.1761749	3	5.4	1.9	Hampstead	0.4	16.4025	4	2	8.00	1.25	2.68	0.12	6.61
45	43	Llyn Gwynant	53.0493367	-4.0203139	6.1	0.8	6.2	Rhyl	66.3	14.7544	4	1	4.00	0.42	19.85	5.02	6.59
46	44	White Mill, Sturminster Marshall	50.8050506	-2.0610635	10.5	1.2	5.9	Bournemouth	21.4	16.0213	4	1	4.00	0.42	9.75	2.14	6.58
47	45	Tongue Pot, Eskdale	54.3896469	-3.324212	0.081	3.7	4.5	Barrow in Furness	43.5	14.7066	5	1	5.00	0.63	12.95	3.05	6.26
48	46	Lettermay Burn – Lochgoilhead – Argyll Forest Park	56.170641	-4.9003651	0.1	0.9	21.2	Paisley	75.2	13.4516	4	1	4.00	0.42	24.35	6.30	6.24
49	47	Buckstones Jum	54.4610928	-2.9788024	2.5	1.7	6.2	Kendal	24.3	14.7066	5	2	10.00	1.67	8.68	1.83	6.16
50	48	Horseshoe Falls	51.77213	-3.595124	4.4	3.9	4.5	Neath	23.9	15.2603	5	1	5.00	0.63	9.18	1.97	6.09
51	49	Strathmashie	56.994919	-4.329715	1	0.1	5.7	Inverness	89.1	12.9721	4	1	4.00	0.42	23.98	6.19	6.08
52	50	Lugg Meadows	52.0632929	-2.6860623	2.8	2.1	2.6	Worcester	40.7	14.6934	5	1	5.00	0.63	12.05	2.79	5.99
53	51	Little Canyon	51.767131	-3.59612	1.6	2.1	2.6	Neath	21.3	15.2603	4	2	8.00	1.25	6.90	1.33	5.96
54	52	Peel Island, Lake Coniston	54.3176861	-3.0851522	10.5	7.2	5.6	Barrow in Furness	31.9	14.7066	4	1	4.00	0.42	13.80	3.29	5.87
55	53	Sgwd Gwladys / Lady Falls	51.7561771	-3.5943301	0.2	0.006	1.3	Neath	20.3	15.2603	4	2	8.00	1.25	5.45	0.91	5.80
56	54	Holne Pool	50.510903	-3.821508	3.5	0.3	6.2	Paignton	26.0	15.6861	4	1	4.00	0.42	9.00	1.92	5.75
57	55	Outney Common	52.4581661	1.4290136	1.5	0.7	3.2	Norwich	25.3	15.9197	1	2	2.00	0.00	7.68	1.55	5.68
58	56	Port Meadow, Thames	51.7717456	-1.2850855	11.2	3.1	3.2	Oxford	11.5	15.8852	4	1	4.00	0.42	7.25	1.43	5.63
59	57	Feshiebridge	57.113728	-3.894488	1.1	0.5	9.9	Inverness	62.7	12.9721	4	1	4.00	0.42	18.55	4.65	5.60
60	58	Loch an Eilein	57.1467842	-3.8238527	0.7	5.4	5.4	Inverness	58.1	12.9721	4	1	4.00	0.42	17.40	4.32	5.49
61	59	Gaddings dam	53.6979105	-2.0786072	3.4	6.8	6.8	Rochdale	17.0	13.9098	4	2	8.00	1.25	8.50	1.78	5.28
62	60	Ulpha Bridge, Duddon	53.177622	-2.7332591	5.1	0.1	6.3	Chester	11.7	15.0902	5	1	5.00	0.63	5.80	1.01	5.10
63	61	Grassington Weir	54.069208	-1.999407	1.9	0.6	4.8	Harrogate	37.5	13.9098	4	1	4.00	0.42	11.20	2.55	5.02
64	62	The Old Mill,Harnham.	51.0638889	-1.8083333	2.7	2	1.4	Salisbury	2.9	15.5533	4	1	4.00	0.42	2.25	0.00	4.52
65	63	Chesters, North Tyne	55.0093712	-1.5893695	6.4	1.2	6	Newcastle Upon Tyne	7.0	13.6811	4	2	8.00	1.25	5.15	0.83	4.42
66	64	Crickhowell, Usk	51.856479	-3.13551	5.2	0.5	0.5	Merthyr Tudful	27.1	14.6934	4	1	4.00	0.42	8.33	1.73	4.11
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