B
brutonparish
Hi,
I posted the following in the generic EXCEL forum -- perhaps this is
the right forum:
I am a Health care researcher with the following problem.
I have a EXCEL spread sheet that has zip codes of various hospitals and
the number of beds in each of them. I am interested to find out how many
beds there are within say a ten mile radius of any zip code in that
list. So for every zip code in the data, I have to (a) find the zip
codes within a 10-mile radius and (b) sum the number of beds in each of
these zip codes.
Is there an easy way to do this? I have EXCEL Map point (old version on
CD) but I cannot seem to automate the process with it.
Thanks a ton!
PS: I am aware of an add-in from Sharesoft that calculates the distance
between Zip codes -- is there a way to use that efficiently? My
spreadsheet has over 7000 records
I posted the following in the generic EXCEL forum -- perhaps this is
the right forum:
I am a Health care researcher with the following problem.
I have a EXCEL spread sheet that has zip codes of various hospitals and
the number of beds in each of them. I am interested to find out how many
beds there are within say a ten mile radius of any zip code in that
list. So for every zip code in the data, I have to (a) find the zip
codes within a 10-mile radius and (b) sum the number of beds in each of
these zip codes.
Is there an easy way to do this? I have EXCEL Map point (old version on
CD) but I cannot seem to automate the process with it.
Thanks a ton!
PS: I am aware of an add-in from Sharesoft that calculates the distance
between Zip codes -- is there a way to use that efficiently? My
spreadsheet has over 7000 records