[LOGic] DXCC- Band & Mode Totals Spreadsheet
K0DAN
k0dan at comcast.net
Sun Jan 6 13:53:57 EST 2008
Cool! Very nice of you Anothony! I might take you up on your offer, but your
last tips (plus some from another list member) have some suggestions I have
not tried, so will give them a shot first...just been too busy to get back
to LOGIC!
Will let you know how it goes!
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>
Sent: Sunday, January 06, 2008 8:49 AM
Subject: Re: [LOGic] DXCC- Band & Mode Totals Spreadsheet
> Dan
>
> If you are willing to send me a zipped copy of your log.dbf file I would
> be glad to get it into the spreadsheet and return completed spreadsheet to
> you.
> Anthony
>
>
> K0DAN wrote:
>> 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.
>>>>>>>
>>>>>>>
>>
>> _______________________________________________
>> LOGic mailing list
>> LOGic at mailman.qth.net
>> http://mailman.qth.net/mailman/listinfo/logic
>>
>
>
> --
> |--------------------------|
> Anthony A. Luscre K8ZT Stow, Ohio
> |--------------------------|
>
>
> _______________________________________________
> LOGic mailing list
> LOGic at mailman.qth.net
> http://mailman.qth.net/mailman/listinfo/logic
>
More information about the LOGic
mailing list