[LOGic] DXCC- Band & Mode Totals Spreadsheet

Thu Jan 3 20:27:11 EST 2008

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