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 727-937-8834 NASFT 30210 K3 #1605 CCA 98 00827 W9DVM -----Original Message----- From: elecraft-boun...@mailman.qth.net [mailto:elecraft-boun...@mailman.qth.net] 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 -- bw...@fastmail.net ______________________________________________________________ Elecraft mailing list Home: http://mailman.qth.net/mailman/listinfo/elecraft Help: http://mailman.qth.net/mmfaq.htm Post: mailto:Elecraft@mailman.qth.net 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:Elecraft@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html