WA2HIP_Log_System/Suite
{Based on Using MS Excel and VBScript} { by WA2HIP } {Version 2.2.17}
Overview
This is a system that I built using Microsoft Excel for QSO data entry and VB Script to process, report, reformat and maintain the data.
Output is available is 2 different styles of ADIF format.
One output ADIF file is the basic content that can be used to upload to eQSL and LOTW.
The second format of ADIF file contains extemded content. This extended content consists of information (dates sent and received) for Paper, eQSL, and LOTW.
Further, for the extended content ADIF file there is also included DXCC, ITU Zone, CQ Zone, Beam Heading, Distance, Country, State or Province, Lattitude, Longitude.
One Excel file of particular interest contains the Latitude, Longitude of all DXCC entities. It also has the Latitude and Longitude of all capitals cities of both U.S. States and Canadian Provinces.
A separate column indicates the Beam Heading and Distance based on the Lattitude and Longitude of the user's QTH. The QTH data (Lattitude & Longitude) may be entered into the worksheet for the particular user.
The worksheet containg Latitude, Longitude, DXCC, CQ Zone, and ITU Zone may also be updated from the XML file available with Ham Radio Deluxe. This is documented in the my application package. A VB script is provided to facilitate the reformatting of the XML data for import into the BEARINGS worksheet.
The package is fairly well documented and can be fairly easily configured for almost any user. There is a PDF file of the documentation contained in the ZIP file. The VB Scripts are well documented with extensive use of in-line comments.
Acknowledgments
The various progams (Excel, VBScript, Ham Radio Deluxe, eQSL, LOTW) used and/or referenced are copyright by their respective owners.
I also wish to acknowledge the work of K7NO for developing the Heading and Distance worksheet. The worksheet in the package is a derivative work of K7NO's work. I have updated it and further augmented it to include the Capital Cities of U.S. States and Canadian Provinces.
