S
sevil_gp
I need an Excel macro to find clusters within a list of 6 figure eastin
and northing co-ordinates. I can readily export a three column sprea
sheet with the column headings:
'crime number'
'easting'
'northing'
What I'm after is a Macro to produce additional columns with th
headings:
'crimes within 10 metres'
'crimes within 50 metres'
'crimes within 100 metres'
'crimes within 1 kilometre'
These can obviously be calculated from the easting and northin
columns. I've had a go myself with no success. I've also looked on th
web at some epidemiology sites and similar but can find nothing o
use.
Does anyone have any tips on how to go about this or know where such
macro exist
and northing co-ordinates. I can readily export a three column sprea
sheet with the column headings:
'crime number'
'easting'
'northing'
What I'm after is a Macro to produce additional columns with th
headings:
'crimes within 10 metres'
'crimes within 50 metres'
'crimes within 100 metres'
'crimes within 1 kilometre'
These can obviously be calculated from the easting and northin
columns. I've had a go myself with no success. I've also looked on th
web at some epidemiology sites and similar but can find nothing o
use.
Does anyone have any tips on how to go about this or know where such
macro exist