Subject: [Tweeters] Updated version of (excel) WA County Checklists
Date: Nov 24 11:24:00 2010
From: mattxyz at earthlink.net - mattxyz at earthlink.net


Hi Tweeters & Inland NW Birders -

I've just completed the latest update to the excel version of the WA
County Checklist , based on the latest county checklist updates at WA
Birder and on the new taxonomic decisions of the AOU in their 51st
checklist supplement.

The checklist is available at:
<http://www.wabirder.com/bartel_co_checklist.html>http://www.wabirder.com/bartel_co_checklist.html

Important note for regular users: If you downloaded the most recent
version [released in August, with the AOU 51 sort order], there is a
sort-order correction that you need to adjust for to avoid screwing
up your lists. Please read the notes on the website for instructions
on how to correct for this.

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 November 2010 [see email
from last week to the lists]. It includes:

1. Additions of two new species for Washington: Lesser Sand-Plover &
Canada Warbler.


2. County Firsts through November..


3. An error correction in the new AOU 51 sort-order -- Originally I
had missed the 'migration' of the gnatchater up to just below the
wrens [instead of its previous placement after the kinglets]. 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. As
needed, the list can be sorted back & forth between older checklist
arrangements, Avisys's Clements ordering, or the newest taxonomic
list decision from the AOU.

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).

Instructions for transferring data:
Short version: Use the same tax order to sort both your old file and
the new one. Add blank rows the where new species will be inserted.
(For this update, that would mean inserting a row below Pacific
Golden-Plover and below Wilson's Warbler). 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 and 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 update,
that would mean inserting a row below Pacific Golden-Plover and below
Wilson's Warbler.

Those changes will leave your data ready for transfer.

6. On your [old] file, highlight all of the cells in the region with
the color coding 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 AS502.

7. Click on the G4 cell in 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 'county first' like
the Adams County Willet to confirm the square is now colored red
instead of blank (white)].

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




Matt Bartels
Seattle, WA