Hi Tweeters -
With the new issue of Washington Birder finding its way to our
mailboxes last week, I wanted to pass along word that I've updated
the Washington County-by-county checklist/abundance excel file. I've
added: the new 'county firsts', the revised Clallam county list, and
a couple other error corrections from the previous version.

The excel file can be found at:
<http://www.wos.org/CountyList.htm>www.wos.org/CountyList.htm (thanks
WOS & Michael Hobbs for hosting).

Thanks to everyone who has sent questions, comments and/or
corrections already, and feel free to pass more along. Biggest
thanks, of course, to the Ken & Laurie Knittle for all the
information in Washington Birder that forms the basis of this list.

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 suggest skipping the rest of this
message or risking extreme-glazed-eye syndrome):

Short version: Insert a row to old file where new species is added,
copy color-coded cells portion of old file, and paste values only
into the new file [using paste-special].

Step-by-step:
1. Download newest file from webpage [save as 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 in the same AOU order.
4. On your file, insert a blank row where any new state species have
been added. For example, to make space for Great Black-backed Gull,
insert a blank row below the row for Glaucous Gull.
5. On your 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, this would be all the cells from E4 to AR483.
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'].
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 GBBG].

Matt Bartels
Seattle, WA
--