[LOGic] DXCC- Band & Mode Totals Spreadsheet

[aluscre]

Bob and rest of mailing list--

First, I have a newer version that I  uploaded just an hour ago with 
better instructions and one fix, so you may want to download it.

Pasting problem-

Excel will not let you paste data into a group of cells if you have 
copied the data by highlighting the entire columns or rows. I suspect 
that might be your problem.
There are a few ways to correct this:

1. A. First, in your exported data spreadsheet, make sure that you 
delete all data and columns other than: call, qso_date, mode, band, 
state, dxcc and userfields and have the             columns in that 
exact order. So you should only have data in columns A, B, C, D, E, F & G
   B. Delete the entire top row (the one with the column labels. )
   C. Then instead of highlighting by column or row, click you mouse 
anywhere in the middle of data, then press Ctrl-* to select all the 
cells and no extra rows or columns.
   D. You should then be able to click in cell J2 of my spreadsheet and 
paste should work.

or

2. A. First make sure that you delete all data and columns other than: 
call, qso_date, mode, band, state, dxcc and userfields and have the 
columns in that exact order.
       You should only have data in columns A, B, C, D, E, F & G
   B. Leave the column labels in first row of the of data (call, 
qso_date, mode, band, state, dxcc and userfields)
   C. Highlight the entire columns by highlighting the A, B, C, D, E, F 
& G at top of column
   D. Copy data and then go to my spreadsheet and highlight columns J 
through N.
   E. Excel should now allow you to paste in data

****** In either case it is very important that you do not have any 
extra columns that would paste over the mode conversion lookup table in 
columns Q & R *****

Let me know if this works or if you need additional assistance.

Anthony


> I have tried to paste my edited log into cell J2.  I get a paste error since
> the size of the cells (just J2)selected differs from what I am trying to
> paste. My log has over 40K qso's!  Is there an easier way to do this.  I
> wanted to try the MS Query approach, but I don’t have this function and have
> not been able to install it.
>
> Thanks for the utility es Happy New Year!
>
> Bob
>
> -----Original Message-----
> From: logic-bounces at mailman.qth.net [mailto:logic-bounces at mailman.qth.net]
> On Behalf Of aluscre
> Sent: Monday, December 31, 2007 11:17 PM
> To: aluscre at neo.rr.com; LOGic is open to all radio amateurs for discussion
> of LOGic logging program
> Subject: Re: [LOGic] DXCC- Band & Mode Totals Spreadsheet
>
>
> Sorry first copy of my email had my old website address, the one below 
> is correct
> 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.k8zt.com/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	  
|--------------------------|