[LOGic] DXCC- Band & Mode Totals Spreadsheet
aluscre
aluscre at neo.rr.com
Mon Dec 31 23:14:13 EST 2007
This message is a repeat of one of my post from a few years ago. I
thought new LOGic users or veteran users that have not tried it might be
interested:
Many of you probably have run the "All band and mode progress" report
and remember the following part of Dennis's description: "It DOES NOT
show progress for all band-mode combinations. This would require a
3-dimensional piece of paper!"
Well I have not been able to create an easy to use piece of 3-d paper
yet, but I was able to build a spreadsheet that will take your LOGic
data and give you a print out showing band and mode combination
progress for each DXCC entity. It also includes a similar report for WAS
band mode combination and CQ Zone band mode combination report. I have
also added a few fun statistics top 50 DXCC entities you have worked
arranged in descending order. A similar table gives rankings for number
of contacts you have with all 50 states. There are break down of
percentages for modes operated, continents worked and CQ Zones worked.
The spreadsheet was built with MS Excel 2000 so you will need that or
later version of program installed on your computer.. You can download
the zipped version of DXCC_Band_Mode_Totals_k8zt.xls.zip from my web site:
http://www.qsl.net/k8zt/FTP/
right click on the file and choose save. Extract file (if you need a
free unzipping program you can use the free JustZipIt
(http://free-backup.info/justzipit.html) and save the file to your LOGic
folder in the subfolder Logdata.
The first sheet of the spreadsheet has instructions for two ways of
using this spreadsheet.
If you have trouble please e-mail me and I can send you the file as an
attachment directly.
It may be very slow to calculate or even freeze Excel so some patience
may be required. Let me know what you think and errors/bugs you find.
--
|--------------------------|
Anthony A. Luscre
K8ZT
Stow, Ohio
|--------------------------|
More information about the LOGic
mailing list