[LOGic] DXCC- Band & Mode Totals Spreadsheet

Fri Jan 4 21:00:44 EST 2008

Still having trouble here...

D/L'd latest version, make it thru step 18 of your (excellent!) 
instructions.

When I go to  DXCC_BAND_MODE_TOTALS_K8ZT-3.XLS, the instructions are still 
there, so cell J2 is no longer relevant, but if I move to cell H2 and try to 
paste the 7 columns (call, qso_date, mode, band, state, dxcc, userfields) 
into either H2 (or H2 thru N2), Excel pukes with the error "CANNOT PASTE CUZ 
COPY & PASTE AREAS ARE NOT SAME". I could, theoretically, drag down 
thousands of cells, but did not try it cuz this is a real hit & miss 
proposition when you have 1000's of QSO's!

I think I'm missing something basic, even maybe an Excel tidbit.

Can you assist?

Tnx
es 73

Dan
K0DAN

----- Original Message ----- 
From: "aluscre" <aluscre at neo.rr.com>
To: "LOGic is open to all radio amateurs for discussion of LOGic logging 
program" <logic at mailman.qth.net>; <rtdevine at pacbell.net>
Sent: Thursday, January 03, 2008 6:55 PM
Subject: Re: [LOGic] DXCC- Band & Mode Totals Spreadsheet

> Bob and others out there.
> Well when I fixed items in version 2, I broke the modes table.
> I have fixed the problem and reloaded the file to my site.
> Download the new one and I think it will finally work properly.
> Let me know if you have any problems
>
> Anthony K8ZT
>
>
>
> Robert Devine wrote:
>> I got my data to paste etc but when I calculate everything goes to 
>> digital
>> (DIG) What am I ng wrong?
>>
>> Robert T. Devine, KC6AWX
>> Manager, ARRL 6th District Incoming QSL Bureau
>> PO BOX 970
>> Fairfax, CA 94978-0970 -----Original Message-----
>> From: logic-bounces at mailman.qth.net 
>> [mailto:logic-bounces at mailman.qth.net]
>> On Behalf Of aluscre
>> Sent: Wednesday, January 02, 2008 7:03 PM
>> To: K0DAN; logic at mailman.qth.net >> "LOGic is open to all radio amateurs 
>> for
>> discussion of LOGic logging program."
>> Subject: Re: [LOGic] DXCC- Band & Mode Totals Spreadsheet
>>
>> I have posted a revised version of the spreadsheet dated 1-2-2008. It 
>> fixes a major problem that prevented proper calculations.
>> Please download the new file and then paste your data into the 
>> spreadsheet.
>>
>> Let me know if you have any problems
>>
>> Anthony K8ZT
>>
>> K0DAN wrote:
>>
>>> Hi Anthony...
>>>  Still trying to get your 3D report working.
>>>  I D/L'd the latest version.
>>>  Created the XLS sheet per instructions on the earlier spreadsheet. 
>>> 3dlog.xls DOES exist in the \LOGIC8\LOGDATA directory, but 
>>> DXCC_BAND_MODE_TOTALS is an earlier vintage...your instrctions STEP #16 
>>> says to open that file, but LOGIC cannot find it, and if I open it in 
>>> Excel, it is the olde data (yours, not mine).
>>>  I assume I am following the wrong (old?) instructions???
>>>
>>> Dan
>>> K0DAN
>>>  ----- Original Message -----
>>> From: "aluscre" <aluscre at neo.rr.com <mailto:aluscre at neo.rr.com>>
>>> To: "Bob Mattaliano" <n6rfm at charter.net <mailto:n6rfm at charter.net>>; 
>>> <logic at mailman.qth.net <mailto:logic at mailman.qth.net>>
>>> Sent: Tuesday, January 01, 2008 2:07 PM
>>> Subject: Re: [LOGic] DXCC- Band & Mode Totals Spreadsheet
>>>
>>>
>>>> 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> 
>>> [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 <mailto: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.
>>>>>
>>>>>