[LOGic] DXCC- Band & Mode Totals Spreadsheet
Ken Goetz
kgoetz at mhcable.com
Thu Jan 3 22:26:44 EST 2008
Anthony:
Thank you! This is a great addition to use with Logic! I too have to do some
editing and corrections as Bob stated, but that can be done over time. I
also found some strange characters when making the CSV file. One additional
quirk I am seeing is that a QSO logged in the FM mode is being listed as CW
when the calculations are done. This probably will not mean much since the
majority of these here are on 2M, with only a few on 6 and 10M.
Again, thanks for a great utility.
Ken N2SQW
-----Original Message-----
From: logic-bounces at mailman.qth.net [mailto:logic-bounces at mailman.qth.net]
On Behalf Of Bob Mattaliano
Sent: Thursday, January 03, 2008 9:49 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
Hi Anthony and the group,
Yeah!! Now it is working for me tool! This is really super. Thanks so
much.
Some notes;
Many of my stateside contacts do not have State or zone information, and
fix_stuff has no way of figuring this out. May be further complicated
if those hams moved (like me) to new QTH's (I'm back in warm, sunny New
England now HI). Nice rainy day task.
When converting to a CSV file using the LOGic 8 report log export
function, my file (40K plus Q's) containing about 40 rows starting with
"strange characters". Easily edited out. Will have to look closer at
LOG.DBF file to see if these are real for some reason.
The Top 50 DX ranking may need some tweaking. In my DXCC spreadsheet, I
have 2414 Q's with DL and 1806 Q's with UA. But, the STATS ranking
lists UA as #1 and DL is not listed at all.
Now to enjoy all the new data!
Hope this helps.
Anthony, Thanks again es 73.
Bob
-----Original Message-----
From: logic-bounces at mailman.qth.net
[mailto:logic-bounces at mailman.qth.net] On Behalf Of aluscre
Sent: Thursday, January 03, 2008 7:56 PM
To: LOGic is open to all radio amateurs for discussion of LOGic logging
program; rtdevine at pacbell.net
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.
>>>>
>>>>
>>>>
>>> --
>>> |--------------------------|
>>> Anthony A. Luscre
>>> K8ZT
>>> Stow, Ohio
>>> |--------------------------|
>>>
>>>
>>> _______________________________________________
>>> LOGic mailing list
>>> LOGic at mailman.qth.net <mailto: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
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1207 - Release Date:
1/2/2008 11:29 AM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1207 - Release Date:
1/2/2008 11:29 AM
_______________________________________________
LOGic mailing list
LOGic at mailman.qth.net
http://mailman.qth.net/mailman/listinfo/logic
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1208 - Release Date: 1/3/2008
3:52 PM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1208 - Release Date: 1/3/2008
3:52 PM
More information about the LOGic
mailing list