[LOGic] DXCC- Band & Mode Totals Spreadsheet
aluscre
aluscre at neo.rr.com
Sun Jan 6 09:49:32 EST 2008
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
|--------------------------|
More information about the LOGic
mailing list