[Elecraft] cool software Idea

dw bw_dw at fastmail.fm
Wed Jun 10 10:44:23 EDT 2009


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_dw at fastmail.net



More information about the Elecraft mailing list