[Logic] Updated--

Sat Sep 4 14:30:33 EDT 2004

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 file self extracting zipped version of 
DXCC_Band_Mode_Totals_v0.90.xls from my web site:
http://www.qsl.net/k8zt/FTP/
right click on the file and choose save. Extract file and save the file 
to your LOGic folder in the subfolder Logdata.
There is also a text file copy of the instructions (they are included in 
the spreadsheet also)
If you have trouble please e-mail me and I can send you the file as an 
attachment directly.
This is version 0.9 and definitely a beta version. 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.
P.S. - There are two macros included in the file but if you are leery of 
downloaded macros you can disable them and manually force the two sorts 
need on the STATs worksheet. Here are the instructions:
Click on column label to highlight Y & Z then go Data...Sort choose 
header and decending order sort on #. Repeat the same for columns AB & 
AC for states.
-- 
|--------------------------|
 Anthony A. Luscre 
 K8ZT 
 Stow, Ohio	 
|--------------------------|
 Visit My Website at
 http://www.k8zt.com
|--------------------------|