[LOGic] DXCC- Band & Mode Totals Spreadsheet
Robert Devine
rtdevine at pacbell.net
Thu Jan 3 20:42:02 EST 2008
Got it working now but 4w6 not importing
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 Robert Devine
Sent: Thursday, January 03, 2008 5:27 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
Now I get ph instead of PH for phone contacts?
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: Thursday, January 03, 2008 4: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
_______________________________________________
LOGic mailing list
LOGic at mailman.qth.net
http://mailman.qth.net/mailman/listinfo/logic
More information about the LOGic
mailing list