[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