Subject: [Tweeters] Updated version of WA County Checklist available
Date: Sep 11 20:09:58 2009
From: mattxyz at earthlink.net - mattxyz at earthlink.net


Hi again Tweeters & Inland NW Birders -

different topic this time, but still on the county-birding side of things....



I've just completed the latest update to the excel version of the WA
County Checklist , based on the Fall 2009 update to WA Birder. It has
been a long time since the last update went up, so a bunch of
changes are included.

This newest version of the excel-based county-by-county checklist of
Washington birds is available online, at a new location. The excel
file can be found at: http://www.wabirder.com/bartel_co_checklist.html
Thanks to Washington Birder not only for generating the data the
spreadsheet is based on but also now for hosting the checklist on
their site.


By the way, the WA Birder website is full of interesting info,
including the 2007 list report for us county & state listers, info on
each county, and other things. I'd highly recommend checking out
other parts of the site if & when you go to grab the checklist update.

This version of the checklist is based on the latest updates of
county-firsts compiled by Ken & Laurie Knittle for Washington Birder,
and covering information gleaned through August 2009. It includes:

1. a revised county checklist for Spokane Co.,

2. many many county firsts,

3. a re-coding of the status of Eurasian Collared-Doves for every
county [in an attempt to catch up to the continuing expansion -- bets
on when another update will be necessary?]

4. Various updates to bring the list in accordance w/ the latest AOU
checklist update [#50] as well as some corrections of little errors
from old version [sorry].


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. There
are now 3 different sort orders available - the 'old order' [the way
most books are still organized], '2006 order' [with some of the
bigger taxonomic order changes from AOU47], and now a 2009 ordering,
based on the 50th AOU supplement, where Tanagers moved, finches were
regrouped, and the "sharp-tailed" was dropped from one of our rare
sparrow names. As needed, the list can be sorted back & forth between
any of these.

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 the same tax order to sort both your old file
and the new one. Add blank lines the where new species will be
inserted. (none for this update), but check to be sure you've got 501
species in the last version you used. 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 both old and new files are sorted according to the same
taxonomic order . To do this, select the entire file and click
'sort' from the 'Data' menu. Check the box for Header Row, then
select the desired sort order in the top box, with the default
setting of Ascending selected.

4. On your[old] file, insert blank rows [using the 'rows' option on
the Insert menu] where new species will be added. For this Fall 2009
update, there are no new species to add lines for, but check to be
sure you've got 501 species in the last version you used. ( The most
recent additions were the Variegated Flycatcher & Hawaiian Petrel, so
check for those first)

Those changes will leave your data ready for transfer.

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

7. Click on the F4 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!

All your data should be pasted into the new file.


8. 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 new 'county first'
like the Ferry County Eurasian Wigeon to ensure you have the color
codes from the newest version in place]

That should do it. Let me know if you have any questions or suggestions --

Matt Bartels
Seattle, WA