[LOGic] DXCC Record Sheet Excel Speadsheet

Hank Phillips aa4hp at titustek.com
Sat Jun 11 20:10:12 EDT 2005


Any of you are so fossilized as to remember my first attempt at a 
Macro-based DXCC Record Sheet a few years ago you were probably disappointed.

You might still be, but anyway, here is what my new attempt will do (when 
it works):

Pull in multiple *.csv outputs from Logic 7's Awards reports -- you spin em 
out to a directory, this will pull them in via selections from a Windows 
file dialog box,

Allows several VB scripted sorts and QSO deletes that make a DXCC Record 
Sheet easy to produce, including grouping multiple QSOs on a card at the 
end of the record sheet, and deleting those QSOs that are already recorded 
in LOTW.

It needs more work, but rather than spend more time here, I'll throw it out 
to you to critique.  It is all open code that you can modify.

A major credit due here is to Dennis, who provided the export function to 
.csv files.  Again "Way to Go Dennis!!"

I am not sure how to upload something to the Logc7 FTP and I am also having 
some DNS resolution problems locally, so:

If you can give me upload instructions to the Logic 7 FTP site please 
do.  Until the DNS stuff settles out, e-mail me directly and I will 
send  you the files.  It is one Excel spreasheet and a Word Document.

73,

Hank
AA4HP





More information about the LOGic mailing list