Updated WA County checklist available on line
----- Original Message -----
From: Nancy
To: Matt Bartels
Sent: Friday, January 14, 2005 8:20 AM
Subject: Re: [Tweeters] Updated WA County checklist available on line


Hi Tweets,
Could someone please explain the "uncommon" status. For instance, I thought Wood Ducks were common in King County but they are rated uncommon. Is this rating merely the numbers compared to other counties? For example it is common to see Belted Kingfishers but not huge numbers of them. Also Rufous Hummingbirds are considered common and Anna's are uncommon.

Was I really lucky to see the Rock Wren down near the lighthouse in Discovery Park? It is considered rare because only 5+ birds have been reported in King County on this list?

The White-breasted Nuthatch is considered common and I have never seen one in King County. Are others seeing them in King County?

Would they not now list the Redwing as Rare with under 5 sightings (RED) now that so many have seen this one bird?

Thanks,
Nancy Lander

----- Original Message -----
From: Matt Bartels
To: tweeters at u.washington.edu ; inland-nw-birders at uidaho.edu
Sent: Friday, January 14, 2005 6:50 AM
Subject: [Tweeters] Updated WA County checklist available on line


Hi Tweeters & Inland-NW Birders-


The newest version of the excel-based county-by-county checklist of Washington birds is available online. The excel file can be found at: www.wos.org/CountyList.htm (thanks WOS & Michael Hobbs for hosting).


This version is based on the latest issue of Washington Birder [vol. 12 #4]. Changes include abundance codes for Cackling Goose in every county and lots of County Firsts. It also adds Redwing to our state list.


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 "Old 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 C "older AOU ordering." To do this, select the entire file and click 'sort' from the 'Data' menu. Check the box for Header Row, then select 'older 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 Redwing, insert a row beneath Dusky Thrush and above American Robin.


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


6. Click on the E4 box of the new file, and then choose Opaste special? from the edit menu. In the dialogue box that opens, select Ovalues? under the paste section [instead of Oall?]. 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 Lewis Co. Red-throated Loon].


That should do it.


Matt Bartels
Seattle, WA
--
--



------------------------------------------------------------------------------


_______________________________________________
Tweeters mailing list
Tweeters at u.washington.edu
http://mailman1.u.washington.edu/mailman/listinfo/tweeters