[Logic] Updated-- DXCC/Band/Mode Totals Spreadsheet

Sat Sep 4 14:37:00 EDT 2004

Updated version with bug fixes and new lite version.
I have also moved it to a site with much faster download capability.
> 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.
>