[Dxbase] [ARRL-LOTW] Re: ARRL Diamond DXCC Award

Tue Jan 10 17:43:19 EST 2012

Thanks to all who have replied. The suggestion below from Jim N6VH at the DXBase reflector works. As a matter of fact "Find All" found I had made a mistake in assigning YB8EL to Sumatra, which is only for YB4, 5, or 6. Turns out YB8 actually goes to Celebes and Molucca Islands with a 1937 prefix of PK6. I've corrected my error, but would never have caught it without using "Find All" to produce the entire list of hits on Indonesia.
Unfortunately, as Jim mentions, it isn't possible to jump directly to any of the line items in the list produced by "Find All". Rather you must scroll up or down to get to the various lines to see which one is the correct one for your entry. Fortunately the list of finds can be kept open for reference while scrolling about checking the various possibilities.
73,
Gary AL9A
----- Original Message ----- 
From: "Jim Preston" <jpreston1 at cox.net>
To: <dxbase at mailman.qth.net>
Sent: January 10, 2012 6:26 AM
Subject: Re: [Dxbase] ARRL Diamond DXCC Award
> Gary,
>> Here is one work-around. Instead of using "Find Next", use "Find All". 
> This will list the cell where the item is. Scroll down to the cell 
> number. This isn't very elegant, but it works.
>> Using F2 to edit the cell worked for me, as did doing the edit in the 
> formula bar at the top of the sheet.
>> Incidentally, I use Excel 2003.
>> 73,
>> Jim N6VH

 ----- Original Message ----- 
 From: Joe K2UF 
 To: ARRL-LOTW at yahoogroups.com 
 Sent: January 10, 2012 9:20 AM
 Subject: RE: [ARRL-LOTW] Re: ARRL Diamond DXCC Award
 
 Gary,
 I am using (antique) EXCEL 2000 The FIND command works but you can not leave
 it up and do anything on the ss. I must close the FIND window to edit the
 page. If I make a mistake on a box I just go back to the box and hit delete
 and enter every thing for that box again. Works similar to the CQ marathon
 submittal form.
 Joe K2UF
 No trees were harmed in the sending of this e-mail; however, many electrons
 were inconvenienced.
 -----Original Message-----
 From: ARRL-LOTW at yahoogroups.com [mailto:ARRL-LOTW at yahoogroups.com] On Behalf
 Of Mike
 Sent: Tuesday, January 10, 2012 1:09 PM
 To: ARRL-LOTW at yahoogroups.com
 Subject: [ARRL-LOTW] Re: ARRL Diamond DXCC Award
 Gary,
 I'm using OpenOffice Calc also. The sheet is protected in OpenOffice, but
 the Find works anyway. I haven't been using Excel much lately, so I don't
 know if there is a way around your problem (without unprotecting the cell),
 but it seems like a nice feature on the part of OO.
 Mike N2NW
 --- In ARRL-LOTW at yahoogroups.com, "Gary AL9A" <al9a at ...> wrote:
 >
 > I'm using Excel 2007. Just discovered what is probably causing the
 problem. 
 > The worksheet is protected. Many of the drop down menu items are grayed
 out 
 > as are many of the tool icons in the various tabs at the the top of the 
 > spreadsheet. There is an unprotect icon, but clicking on that opens a 
 > window that asks for a password necessary to unprotect the sheet. I'm
 sure 
 > ARRL did this to "dummy" proof the thing so they wouldn't be getting a ton
 > of phone calls and emails asking for help in restoring a damaged 
 > spreadsheet.
 > 
 > Apparently the protection scheme doesn't work when opened with OpenOffice.
 > I have that package on a Netbook running XP so maybe I'll give it a try
 just 
 > to see what happens.
 > 
 > 73,
 > Gary AL9A
 > 
 > ----- Original Message ----- 
 > From: "iain macdonnell - N6ML" <ar at ...>
 > To: <ARRL-LOTW at yahoogroups.com>
 > Cc: "DXbase Reflector" <dxbase at ...>
 > Sent: January 09, 2012 8:55 PM
 > Subject: Re: [ARRL-LOTW] ARRL Diamond DXCC Award
 > 
 > 
 > >I opened the spreadsheet using OpenOffice.org Calc 3.3.0, and the Find
 > > function seems to work. I don't have Excel, but I'd be kindof
 > > surprised if its Find doesn't work too.......
 > >
 > > ~iain / N6ML
 > >
 > >
 > > On Mon, Jan 9, 2012 at 9:34 PM, Gary AL9A <al9a at ...> wrote:
 > >>
 > >>
 > >>
 > >> Here's a gotcha for anyone using the Excel spreadsheet from the ARRL
 web
 > >> site to track your Diamond DXCC progress. Unless I'm missing something,
 I
 > >> cannot get Find to work in the spreadsheet. Using Find makes it easier 
 > >> and
 > >> faster to get to the country you want, but without Find working you
 must 
 > >> use
 > >> the mouse to repeatedly scroll up and down the list. Then there is a
 > >> problem in finding some countries as they are not alphabetically listed
 > >> by
 > >> current country, but historical country. I had a problem trying to find
 > >> Indonesia today. The former name is Sumatra, so unless you're a
 geography
 > >> wiz...
 > >>
 > >> Absent getting Find to work in the Excel spreadsheet my work around is
 to
 > >> also download the Diamond DXCC country list in pdf format. Find does
 work
 > >> in the pdf file so if I get stuck looking for a country that had a 
 > >> previous
 > >> name I can search the pdf file to find the present day name in the row
 of
 > >> its' former name, then jump over the the Excel spreadsheet and scroll
 to 
 > >> the
 > >> correct former name. A bit of a pain unless someone can figure out how
 to
 > >> make Find work in the spreadsheet.
 > >>
 > >> Oh, another gotcha. In making an entry in the Date/Time field I messed
 up
 > >> and tabbed to the next field after entering just the date and not the 
 > >> time.
 > >> When I saw my mistake I went back, hit F2 to edit the cell entry and 
 > >> added
 > >> the time to the field. When I hit Enter only the Date still displayed, 
 > >> not
 > >> the Date and Time. In checking the cell entry line at the top of the
 > >> spreadsheet I could see the time was now there along with the date, but
 > >> it
 > >> would not display in the cell. I tried to go to Format the cell, but it
 > >> is
 > >> grayed out in the selection menu.
 > >>
 > >> Fortunately I am working on a copy of the original spreadsheet as 
 > >> suggested
 > >> in the ARRL instructions. I opened the original empty spreadsheet and
 > >> copied the empty cell from the Date/Time column and pasted it into my
 > >> spreadsheet. That restored the cell formatting and let me enter date
 and
 > >> time so it displayed correctly.
 > >>
 > >> 73,
 > >> Gary AL9A
 > >>
 > >>
 > >
 > >
 > > ------------------------------------
 > >
 > > Yahoo! Groups Links
 > >
 > >
 > >
 >
 ------------------------------------
 Yahoo! Groups Links
 __._,_.___
 Reply to sender | Reply to group | Reply via web post | Start a New Topic 
 Messages in this topic (5) 
 Recent Activity: 
 Visit Your Group 
 MARKETPLACE
 Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.
 Switch to: Text-Only, Daily Digest . Unsubscribe . Terms of Use.
 
 __,_._,___