Can Excel calcluate miles between zip codes?
 

Can Excel calcluate miles between zip codes?
 

Not without entering some sort of position data. What are you using?

In article ,
kcobb wrote:

Can Excel calcluate miles between zip codes?
 

Firstly, please ask your question in the body of the message, not just in
the subject line. Blank messages are often rejected or ignored.
Secondly: No.
--
David Biddulph

"kcobb" wrote in message
...

Can Excel calcluate miles between zip codes?
 

David wrote on Wed, 26 Sep 2007 15:48:34 +0100:

DB Firstly, please ask your question in the body of the
DB message, not just in the subject line. Blank messages are
DB often rejected or ignored. Secondly: No.
DB --
DB David Biddulph

I agree with your comment on posting but it's a surprisingly
common mistake :-)

Data Bases with geographical coordinates can be bought very
cheaply for Zip Codes and I suppose one might be able to
incorporate a look up. Google will find them/

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

Can Excel calcluate miles between zip codes?
 

By whom or what?

Just curious.

In article ,
"David Biddulph" <groups [at] biddulph.org.uk wrote:

Blank messages are often rejected

Can Excel calcluate miles between zip codes?
 

Hi~For some reason, I am unable to reply directly to kcobb-I get an error
message-so I am posting my message here.

I don't know if you can do it in Excel, but here is a very good website that
I use when I have to have that calculation, and it's free:

http://www.zip-codes.com/zip-code-radius-finder.asp

--
smither fan


"JE McGimpsey" wrote:

Not without entering some sort of position data. What are you using?

In article ,
kcobb wrote:

Can Excel calcluate miles between zip codes?
 

Some web interfaces don't let you reply to a blank message, some don't even
show messages with no body. This is anecdotal information I've heard from
others; I don't have firsthand experience with web interfaces for NNTP,
other than not liking any.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JE McGimpsey" wrote in message
...
By whom or what?

Just curious.

In article ,
"David Biddulph" <groups [at] biddulph.org.uk wrote:

Blank messages are often rejected

Can Excel calcluate miles between zip codes?
 

On Sep 27, 5:02 am, "Jon Peltier"
wrote:
"JE McGimpsey" wrote:
"David Biddulph" <groups [at] biddulph.org.uk wrote:

Blank messages are often rejected- Hide quoted text -

By whom or what?

Some web interfaces don't let you reply to a blank message,
some don't even show messages with no body. This is anecdotal
information I've heard from others; I don't have firsthand experience

I access these newsgroups by using IE6 to go to either
groups.google.com or
http://www.microsoft.com/communities...s/default.aspx .

When I use www.microsoft.com/communities/newsgroups, I cannot reply to
messages with an empty body. Moreover, that lame interface fails to
display the entire subject line unless I open a reply window. Given
that, I wish the www.microsoft.com news servers would reject (not
store) such messages in the first place, whether they originate with
those news servers or they come in from elsewhere.

Some messages that are posted to these newsgroups by some means (TBD)
do not seem to find their way to the Google Groups news servers. No
way to tell if they are rejected by the Google Groups news servers, or
if they simply never leave the originating news server. I do see them
when I go to www.microsoft.com/communities/newsgroups -- but that
might be the originating news server.

In any case, I do not remember if those messages that fail to be seen
in Google Groups follow a specific pattern -- for example, an empty
body. I suspect not. I believe that even some of my postings to
www.microsoft.com/communities/newsgroups have failed to appear in
Google Groups.

Can Excel calcluate miles between zip codes?
 

In article .com,
joeu2004 wrote:

I wish the www.microsoft.com news servers would reject (not
store) such messages in the first place, whether they originate with
those news servers or they come in from elsewhere.

That would violate the NNTP standards (see RFC977 and RFC3977) that have
been in place for more than 20 years.

While not optimal, there's nothing *inherently* wrong with posting a
message with a blank body. Just because some poorly implemented web
portals aren't designed to handle them properly is no reason to start
violating standards.

Though it *would* be much the Microsoft way...

Can Excel calcluate miles between zip codes?
 

Provided you've got the lat & lon for the zip code centroids and you're happy to work with the assumption that the earth is a
perfect sphere (it isn't), you could use:
=ACOS(SIN(RADIANS(Lat1))*SIN(RADIANS(Lat2))+COS(RA DIANS(Lat1))*COS(RADIANS(Lat2))*COS(RADIANS(Long1-Long2)))*RadiusEarth
or
=2*ASIN(SQRT((SIN(RADIANS(Lat1-Lat2)/2))^2+COS(RADIANS(Lat1))*COS(RADIANS(Lat2))*(SIN(R ADIANS(Long1-Long2)/2))^2))*RadiusEarth
where your lat/lon cells are named as indicated and RadiusEarth = 6367.465km or 3956.559mi. In either case, you'll get very good
great-circle distance calculations.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"kcobb" wrote in message ...

Can Excel calcluate miles between zip codes?
 

Use an NNTP client. Outlook Express for example. Create a new news account,
point it at the server msnews.microsoft.com, and subscribe directly to the
groups of interest. Even the worst NNTP client is better than the best
web-based NNTP interface.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"joeu2004" wrote in message
oups.com...
On Sep 27, 5:02 am, "Jon Peltier"
wrote:
"JE McGimpsey" wrote:
"David Biddulph" <groups [at] biddulph.org.uk wrote:

Blank messages are often rejected- Hide quoted text -

By whom or what?

Some web interfaces don't let you reply to a blank message,
some don't even show messages with no body. This is anecdotal
information I've heard from others; I don't have firsthand experience

I access these newsgroups by using IE6 to go to either
groups.google.com or
http://www.microsoft.com/communities...s/default.aspx .

When I use www.microsoft.com/communities/newsgroups, I cannot reply to
messages with an empty body. Moreover, that lame interface fails to
display the entire subject line unless I open a reply window. Given
that, I wish the www.microsoft.com news servers would reject (not
store) such messages in the first place, whether they originate with
those news servers or they come in from elsewhere.

Some messages that are posted to these newsgroups by some means (TBD)
do not seem to find their way to the Google Groups news servers. No
way to tell if they are rejected by the Google Groups news servers, or
if they simply never leave the originating news server. I do see them
when I go to www.microsoft.com/communities/newsgroups -- but that
might be the originating news server.

In any case, I do not remember if those messages that fail to be seen
in Google Groups follow a specific pattern -- for example, an empty
body. I suspect not. I believe that even some of my postings to
www.microsoft.com/communities/newsgroups have failed to appear in
Google Groups.

Can Excel calcluate miles between zip codes?
 

In article ,
"Jon Peltier" wrote:

Even the worst NNTP client is better than the best
web-based NNTP interface.

Amen to that!

I'd rather go back to using rn or pine (which I have loaded on my
machine, and have used for news on occasion) than a web-interface.