Spreadsheet: 219210d1362684682-excel-formula-to-locate-place-names-with-defined-radii-place-name-radius-worksheet-jacc
Sheet: Sheet1

 |  |  |  | 0.4 |  |  |  |  | 2
 |  |  |  | 2 |  |  |  |  | 4
PLACE-NAME | LATITUDE | LONGITUDE | Distance | PLACE NAME #1 in 0,5 - 2km RADIUS | PLACE NAME #2 in 0,5 - 2km RADIUS | PLACE NAME #3 in 0,5 - 2km RADIUS | PLACE NAME #4 in 0,5 - 2km RADIUS | PLACE NAME #5 in 0,5 - 2km RADIUS | PLACE NAME #1 in 2,1 - 4km RADIUS | PLACE NAME #2 in 2,1 - 4km RADIUS | PLACE NAME #3 in 2,1 - 4km RADIUS | PLACE NAME #4 in 2,1 - 4km RADIUS | PLACE NAME #5 in 2,1 - 4km RADIUS | PLACE NAME #6 in 2,1 - 4km RADIUS | PLACE NAME #7 in 2,1 - 4km RADIUS | PLACE NAME #8 in 2,1 - 4km RADIUS | PLACE NAME #9 in 2,1 - 4km RADIUS | PLACE NAME #10 in 2,1 - 4km RADIUS
[NAME] | -26.075 | 28.09472
Buccleuch | -26.05528 | 28.11083
Alexandra South | -26.12472 | 28.07889
Alexandra Suid | -26.12472 | 28.07889
[NAME] | -26.12472 | 28.07889
Far East Park | -26.12472 | 28.07889
River Park | -26.12472 | 28.07889
Tsotsomani | -26.12472 | 28.07889
Tsutsumani Village | -26.12472 | 28.07889
Wendywood | -26.07944 | 28.08361
Wendywood | -26.07944 | 28.08361
Wendywood | -26.07944 | 28.08361
Buccleuch | -26.05528 | 28.11083
[NAME] | -26.075 | 28.09472
Wendywood | -26.07944 | 28.08361
Boskruin | -26.08667 | 27.95139
Boskruin | -26.08667 | 27.95139
Broadacres | -25.9925 | 27.99056
Douglasdale | -26.03889 | 27.995
Simba | -26.05139 | 28.02806
Strathavon | -26.095 | 28.07
[NAME] | -26.06417 | 28.07806
Chartwell | -25.97611 | 27.96556
Douglasdale | -26.03889 | 27.995
Kildrummy | -26.05139 | 28.02806
Littlefillan | -26.05139 | 28.02806
Moodiehill | -26.05139 | 28.02806
[NAME] | -26.05139 | 28.02806
Country Life Park | -26.05139 | 28.02806
Cowdray Park | -26.05139 | 28.02806
Cramerview | -26.05139 | 28.02806
Douglasdale | -26.03889 | 27.995
Gleniffer | -26.05139 | 28.02806
Lyme Park | -26.07833 | 28.01944
[NAME] | -26.05139 | 28.02806
Solridge | -26.05139 | 28.02806
Diepsloot | -26.05139 | 28.02806
Sunninghill West | -26.05139 | 28.02806
Alexandra East | -26.05139 | 28.02806
Winston | -26.05139 | 28.02806
Douglasdale | -26.03889 | 27.995
Douglasdale | -26.03889 | 27.995
Douglasdale | -26.03889 | 27.995
[NAME] | -26.06417 | 28.07806
Little Four Ways | -26.05139 | 28.02806
Magaliesig | -26.05139 | 28.02806
[NAME] | -26.05139 | 28.02806
Woodmead | -26.04333 | 28.06444
Woodmead East | -26.04583 | 28.08639
Strathavon | -26.095 | 28.07
Winston | -26.05139 | 28.02806
Diepsloot | -26.05139 | 28.02806
[NAME] | -26.05139 | 28.02806
Chartwell | -25.97611 | 27.96556
Cramerview | -26.05139 | 28.02806
Douglasdale | -26.03889 | 27.995
[NAME] | -26.06417 | 28.07806
Gleniffer | -26.05139 | 28.02806
Lyme Park | -26.07833 | 28.01944
[NAME] | -26.05139 | 28.02806
Solridge | -26.05139 | 28.02806
Sunninghill West | -26.05139 | 28.02806
Littlefillan | -26.05139 | 28.02806
Simba | -26.05139 | 28.02806
Strathavon | -26.095 | 28.07
 | -26.24083 | 27.99444
 | -26.24083 | 27.99444
 | -26.24083 | 27.99444
 | -26.2075 | 28.10028
 | -26.2075 | 28.10028
 | -26.2075 | 28.10028
Diepkloof [NAME] | -26.24194 | 27.95028
 | -26.24194 | 27.95028
[NAME] | -26.24194 | 27.95028
[NAME] 10 | -26.24194 | 27.95028
[NAME] 11 | -26.24194 | 27.95028
[NAME] | -26.24194 | 27.95028
[NAME] 3 | -26.24194 | 27.95028
[NAME] | -26.24194 | 27.95028
[NAME] | -26.24194 | 27.95028
[NAME] 6 | -26.24194 | 27.95028
[NAME] 7 | -26.24194 | 27.95028
[NAME] 8 | -26.24194 | 27.95028
Diepkloof Zone 9 | -26.24194 | 27.95028
 | -26.24194 | 27.95028
 | -26.24194 | 27.95028
Doornkop | -26.24361 | 27.80694
 | -26.22389 | 27.86667
Dobsonville North | -26.22389 | 27.86667
Snake Park | -26.22389 | 27.86667
Dobsonville Gardens | -26.23111 | 27.81194
Greenvillage | -26.22389 | 27.86667
Silvertown | -26.22389 | 27.86667
Doornkop | -26.24361 | 27.80694
Thubelisha | -26.22389 | 27.86667
Braamfischer | -26.22389 | 27.86667
 | -26.22389 | 27.86667
Dobsonville Gardens | -26.23111 | 27.81194
Greenvillage | -26.22389 | 27.86667
Silvertown | -26.22389 | 27.86667
Doornkop | -26.24361 | 27.80694
 | -26.23861 | 27.89278
[NAME] | -26.23861 | 27.89278
Mofolo Central | -26.23861 | 27.89278
Mofolo North | -26.22556 | 27.87694
Mofolo South | -26.25306 | 27.88917
Mofolo Village | -26.23861 | 27.89278
Mshenguville | -26.23861 | 27.89278
 | -26.23861 | 27.89278
 | -26.295 | 27.90278
Bushkoppies | -26.295 | 27.90278
[NAME] | -26.295 | 27.90278
Klipspruit West | -26.295 | 27.90278
Kliptown | -26.27222 | 27.88861
Nancefield | -26.295 | 27.90278
[NAME] | -26.295 | 27.90278
Nancefield Industrial Sites | -26.295 | 27.90278
Kliptown | -26.27222 | 27.88861
 | -26.295 | 27.90278
Zakariyya Park | -26.36889 | 27.89556
Devland | -26.28194 | 27.935
Zakariyya Park | -26.36889 | 27.89556
Devland | -26.28194 | 27.935
 | -26.295 | 27.90278
Devland | -26.28194 | 27.935
Kliptown | -26.27222 | 27.88861
Nancefield | -26.295 | 27.90278
Bushkoppies | -26.295 | 27.90278
Devland | -26.28194 | 27.935
Zakariyya Park | -26.36889 | 27.89556
 | -26.14722 | 27.99583
 | -26.14722 | 27.99583
 | -26.14722 | 27.99583
Lawley | -26.39167 | 27.81278
Odin Park | -26.40194 | 27.8575
 | -26.40194 | 27.8575
 | -26.40194 | 27.8575
Odin Park | -26.40194 | 27.8575
 | -26.40194 | 27.8575
Lawley | -26.39167 | 27.81278
Odin Park | -26.40194 | 27.8575
Maraisburg | -26.175 | 27.94056
Ridgeview | -26.17528 | 27.92333
Florida Glen | -26.16278 | 27.94056
 | -26.17528 | 27.92333
[NAME] | -26.1625 | 27.95278
Consolidated Main Reef | -26.17528 | 27.92333
[NAME] | -26.14472 | 27.90972
[NAME] | -26.175 | 27.95083
Discovery | -26.16056 | 27.8925
Fleurhof | -26.19861 | 27.91583
[NAME] | -26.15639 | 27.92083
Floracliffe | -26.15639 | 27.92083
Florex | -26.17528 | 27.92333
Florida Hills | -26.16056 | 27.9275
Florida Lake | -26.17361 | 27.89639
Florida North | -26.16694 | 27.93389
Florida Park | -26.15861 | 27.90472
Florida View | -26.17528 | 27.92333
Floridameer | -26.17528 | 27.92333
[NAME] | -26.18111 | 27.95111
Kloofendal | -26.13667 | 27.89056
Leaglen | -26.17528 | 27.92333
[NAME] | -26.17528 | 27.92333
Northcliff | -26.13111 | 27.96222
Ontdekkerspark | -26.14778 | 27.88778
Quellerina | -26.1575 | 27.93583
Rand Leases Mine | -26.17528 | 27.92333
Robertville | -26.19 | 27.92194
Selwyn | -26.16333 | 27.90194
Stormmill | -26.17528 | 27.92333
Unified | -26.17889 | 27.9275
Weltevredenpark | -26.12361 | 27.93306
White Ridge | -26.17528 | 27.92333
 | -26.17528 | 27.92333
Ansfrere | -26.17528 | 27.92333
[NAME] | -26.1625 | 27.95278
[NAME] | -26.17528 | 27.92333
Palm Court | -26.17528 | 27.92333
Weltevredenpark | -26.12361 | 27.93306
Florida Hills | -26.16056 | 27.9275
[NAME] | -26.175 | 27.95083
 | -26.17528 | 27.92333
Ansfrere | -26.17528 | 27.92333
[NAME] | -26.1625 | 27.95278
[NAME] | -26.175 | 27.95083
Florida Glen | -26.16278 | 27.94056
Florida Hills | -26.16056 | 27.9275
Maraisburg | -26.175 | 27.94056
Weltevredenpark | -26.12361 | 27.93306