Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can Excel calcluate miles between zip codes?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Can Excel calcluate miles between zip codes?

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

In article ,
kcobb wrote:
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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
...



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 115
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 152
Default 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:

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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



  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default 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.

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default 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...
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 329
Default 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 ...




  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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.



  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Miles Per Hour WalkerDude999 Excel Worksheet Functions 1 May 7th 06 09:42 AM
convert 1.2 miles to meters crlathem Excel Discussion (Misc queries) 4 August 4th 05 10:47 AM
need form to calc EG :13:13 to 14:01 = td x 12 = miles-- multiple. waynehc Excel Discussion (Misc queries) 1 February 14th 05 03:28 AM
excel to figure miles per gallon Terri New Users to Excel 5 January 9th 05 06:59 PM
Subtracting based on number of miles Ms Chewie Excel Discussion (Misc queries) 3 December 21st 04 05:35 AM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"