Can Excel calcluate miles between zip codes?

  • Thread starter Thread starter Guest
  • Start date Start date
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 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
 
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
 
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
Click to expand...

I access these newsgroups by using IE6 to go to either
groups.google.com or
www.microsoft.com/communities/newsgroups/en-us/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.
 
joeu2004 said:
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.
Click to expand...

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...
 
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(RADIANS(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(RADIANS(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
 
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 said:
JE McGimpsey said:
"David Biddulph" <groups [at] biddulph.org.uk> wrote:

Blank messages are often rejected- Hide quoted text -

By whom or what?
Click to expand...

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
Click to expand...

I access these newsgroups by using IE6 to go to either
groups.google.com or
www.microsoft.com/communities/newsgroups/en-us/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.
Click to expand...
 
Jon Peltier said:
Even the worst NNTP client is better than the best
web-based NNTP interface.
Click to expand...

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.
 
Back
Top