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 -- [email protected] ______________________________________________________________ Elecraft mailing list Home: http://mailman.qth.net/mailman/listinfo/elecraft Help: http://mailman.qth.net/mmfaq.htm Post: mailto:[email protected] This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
