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

[Gary AL9A]

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 dseven.org>
To: <ARRL-LOTW at yahoogroups.com>
Cc: "DXbase Reflector" <dxbase at mailman.qth.net>
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 mtaonline.net> 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
>
> <*> To visit your group on the web, go to:
>    http://groups.yahoo.com/group/ARRL-LOTW/
>
> <*> Your email settings:
>    Individual Email | Traditional
>
> <*> To change settings online go to:
>    http://groups.yahoo.com/group/ARRL-LOTW/join
>    (Yahoo! ID required)
>
> <*> To change settings via email:
>    ARRL-LOTW-digest at yahoogroups.com
>    ARRL-LOTW-fullfeatured at yahoogroups.com
>
> <*> To unsubscribe from this group, send an email to:
>    ARRL-LOTW-unsubscribe at yahoogroups.com
>
> <*> Your use of Yahoo! Groups is subject to:
>    http://docs.yahoo.com/info/terms/
>