[Tweeters] Updated WA County checklist available on line

Matt Bartels mattxyz at earthlink.net
Sat Apr 2 05:29:31 PST 2005

Hi Tweeters & Inland-NW Birders-

The Knittle's have passed on word that the newest edition of 
Washington Birder is due to arrive in our mailboxes soon. Along with 
it, I've updated the county checklist for downloading again.

The newest version of the excel-based county-by-county checklist of 
Washington birds is available online.  The excel file can be found 
at: <http://www.wos.org/CountyList.htm>www.wos.org/CountyList.htm 
(thanks WOS & Michael Hobbs for hosting).
NOTE: As of last night[1April2005], the WOS website appeared to be 
temporarily off-line. Once it is up again the excel file should be 
available for download.

This version is based on the latest issue of Washington Birder [vol. 
13 #1]. Changes include the addition of Baikal Teal to the 
state-list, more county firsts, and an updated list for Wahkiakum 

If you are looking for a quick reference for how common a given 
species is in any county, this excel file can be handy. Further, if 
you are interested in keeping track of your county lists, this file 
works as a checklist for each county and the state as a whole.

Thanks again to the Knittle's for making this data available in 
Washington Birder, and thanks to those who have sent questions, 
comments or suggestions. Let me know if you have any problems working 
with the sheet or ideas for changes.

Finally, for anyone already using the old file who wants instructions 
on how to transfer your information from that one to this new one, 
read on (for everyone else, I'd recommend skipping the dry 
instructions that follow):

Short version: Use the "New AOU order" to sort your old file. Add  a 
blank line  the where new species will be inserted. Copy color-coded 
cells portion of old file, and paste "values" only into the new file 
[using paste-special].

Longer Step-by-step Explanation:

1. Download newest file from webpage [save under a different name 
than your own file]

2. Open both the new file and your old one.

3. Make sure old and new files are sorted according to column D 
"newer AOU ordering." To do this, select the entire file and click 
'sort' from the 'Data' menu. Check the box for Header Row, then 
select 'newer AOU order' in the top box, with the default setting of 
Ascending selected.

4. On your[old] file, insert a blank row where a new species will be 
added. For example, to make space for Baikal Teal, insert a row 
beneath Gargany and above Green-winged Teal.

5. On your [old] file, highlight all of the cells that have the color 
coding in them and press control-C to copy this section. In the 
present file (once you've added the blank rows for the new state 
species) this would be all the cells from E4 to AR489.

6. Click on the E4 box of the new file, and then choose 'paste 
special' from the edit menu.  In the dialogue box that opens, select 
'values' under the paste section [instead of 'all']. It is important 
to paste only the values -- otherwise you will bring over all the old 
color codes too!

7. All your data should be pasted into the new file. Do some double 
checking to ensure the formulas are adding up to the same numbers 
they did in the old file. Also check to be sure you haven't brought 
over the old color codes [check a county first like the Cowlitz Co., 
Long-tailed Duck].

That should do it.

Matt Bartels
Seattle, WA
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mailman1.u.washington.edu/mailman/private/tweeters/attachments/20050402/b2c8f969/attachment.htm

More information about the Tweeters mailing list