Zip codes and Distances
 

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


--
brutonparish
------------------------------------------------------------------------
brutonparish's Profile: http://www.excelforum.com/member.php...o&userid=35987
View this thread: http://www.excelforum.com/showthread...hreadid=557941

Zip codes and Distances
 

You have the latitude and longitude of each zip code ? Once you have that:
http://www.thescripts.com/forum/thread14394.html
And see which other zip codes fall within the area.
finally sum the number of bed in these areas/

NickHK

"brutonparish"
wrote in message
news:brutonparish.2ae69z_1151967603.4932@excelforu m-nospam.com...

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


--
brutonparish
------------------------------------------------------------------------
brutonparish's Profile:
http://www.excelforum.com/member.php...o&userid=35987
View this thread: http://www.excelforum.com/showthread...hreadid=557941

Zip codes and Distances
 

NickHK: Thanks for the reply. Unfortunately I dont have the lat and
long. I can read it off a map but the intent to automate the process
will be lost. Anyways great link for future use.


--
brutonparish
------------------------------------------------------------------------
brutonparish's Profile: http://www.excelforum.com/member.php...o&userid=35987
View this thread: http://www.excelforum.com/showthread...hreadid=557941

Zip codes and Distances
 

I've not used Map Point before, so I can't advise you about automating this
step.
Will see what I can do.

NickHK

"brutonparish"
wrote in message
news:brutonparish.2aehuo_1151982604.4684@excelforu m-nospam.com...

NickHK: Thanks for the reply. Unfortunately I dont have the lat and
long. I can read it off a map but the intent to automate the process
will be lost. Anyways great link for future use.


--
brutonparish
------------------------------------------------------------------------
brutonparish's Profile:
http://www.excelforum.com/member.php...o&userid=35987
View this thread: http://www.excelforum.com/showthread...hreadid=557941

Zip codes and Distances
 

Solved the first part. Download free listing of 33K zip codes with long/lat
data:
http://sourceforge.net/projects/zips/

Can't vouch how accurate it is.

NickHK

"brutonparish"
wrote in message
news:brutonparish.2aehuo_1151982604.4684@excelforu m-nospam.com...

NickHK: Thanks for the reply. Unfortunately I dont have the lat and
long. I can read it off a map but the intent to automate the process
will be lost. Anyways great link for future use.


--
brutonparish
------------------------------------------------------------------------
brutonparish's Profile:
http://www.excelforum.com/member.php...o&userid=35987
View this thread: http://www.excelforum.com/showthread...hreadid=557941