Re: cool software Idea

[dw-4]

It turns out I was able to accomplish a little of this myself in Excel.
I found a web-site that offered free downloads of U.S. zip codes with
City, State and Long/Lat values.
I imported this into excel and applied the distance formula.
I can now type in a U.S. zip code into a field and the sheet will
display the city, state and the distance in miles/kilometers from my
station.

I played with it a little last night listening to various cw QSOs on 80m
and 40m just to see what the typical distance and sig-strenghts were.  
Plug the call into a zip code search based on callsign.
Then plug the derived zip code into the sheet.
Perhaps if I buy a Ham Call data CD I can get excel to read the CD and
automate the process.
I know there is a way to incorporate a U.S. Map into Excel, and I may be
able to add that as a feature.
It would be cool to be able to do the whole thing in excel with a little
VB in the background!!  :^D
--
 [hidden email]

______________________________________________________________
Elecraft mailing list
Home: http://mailman.qth.net/mailman/listinfo/elecraft
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:[hidden email]

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html

[Phil LaMarche-2]

To make this even easier, seeing the station you wish to work, with miles,
short and long path, location and beam heading etc, order Comm Cat and
really enjoy ham radio.  When I see the station I would like to work, I
click on that station and it changes the K3 to that freq and all the
setting.  Also logs for you and many other features.  Google Comm Cat and
down load a free demo.  If you buy it, it's cheap and worth every penny.

Phil


Philip LaMarche
LaMarche Enterprises, Inc.
www.instantgourmetspices.com

www.w9dvm.com
800-395-7795 pin 02
727-944-3226
FAX [phone]
NASFT 30210

K3  #1605

CCA 98  00827
W9DVM



-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of dw
Sent: Wednesday, June 10, 2009 10:44 AM
To: Elecraft_List
Subject: Re: [Elecraft] cool software Idea

It turns out I was able to accomplish a little of this myself in Excel.
I found a web-site that offered free downloads of U.S. zip codes with City,
State and Long/Lat values.
I imported this into excel and applied the distance formula.
I can now type in a U.S. zip code into a field and the sheet will display
the city, state and the distance in miles/kilometers from my station.

I played with it a little last night listening to various cw QSOs on 80m and
40m just to see what the typical distance and sig-strenghts were.  
Plug the call into a zip code search based on callsign.
Then plug the derived zip code into the sheet.
Perhaps if I buy a Ham Call data CD I can get excel to read the CD and
automate the process.
I know there is a way to incorporate a U.S. Map into Excel, and I may be
able to add that as a feature.
It would be cool to be able to do the whole thing in excel with a little VB
in the background!!  :^D
--
 [hidden email]

______________________________________________________________
Elecraft mailing list
Home: http://mailman.qth.net/mailman/listinfo/elecraft
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:[hidden email]

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html

______________________________________________________________
Elecraft mailing list
Home: http://mailman.qth.net/mailman/listinfo/elecraft
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:[hidden email]

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html

[n7ws]

Although I still "really enjoy ham radio", I guess I'm really missing something.

The directional readout on my HAMM has been broken (again) for months so if I really need to know where the beam is pointed, I have to go into another room and look out the window.  I do this occasionally and make a mental note of where it's pointed.

Band conditions and experience tell me the general beam heading I need and about how long I need to actuate the rotor to get it pointed correctly.  (This is 20M only, on the other bands I have a fixed wire dipole)


When I tune around and hear a station I'd like to work knowing the distance is useless information and I've already tuned him in, so what more do I need?

Wes Stewart, N7WS
DXCC Honor Roll, 5BDXCC, etc.



--- On Wed, 6/10/09, Phil LaMarche <[hidden email]> wrote:

From: Phil LaMarche <[hidden email]>
Subject: Re: [Elecraft] cool software Idea
To: "'dw'" <[hidden email]>, "'Elecraft_List'" <[hidden email]>
Cc: [hidden email]
Date: Wednesday, June 10, 2009, 10:13 AM


To make this even easier, seeing the station you wish to work, with miles,
short and long path, location and beam heading etc, order Comm Cat and
really enjoy ham radio.  When I see the station I would like to work, I
click on that station and it changes the K3 to that freq and all the
setting.  Also logs for you and many other features.  Google Comm Cat and
down load a free demo.  If you buy it, it's cheap and worth every penny.

Phil





     
______________________________________________________________
Elecraft mailing list
Home: http://mailman.qth.net/mailman/listinfo/elecraft
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:[hidden email]

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html