[LOGic] DXCC- Band & Mode Totals Spreadsheet

Thu Jan 3 14:40:44 EST 2008

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