Matt Bartels County Checklist
Below is a Microsoft Excel spreadsheet showing county occurrence of Washington birds. The spreadsheet is designed to allow you to maintain your own county lists, by simply typing a 1 into each appropriate cell.
You will need Excel version 5.0/95 or newer on your computer. Just click on the link to open the file, then save the file on your computer.
Any questions or comments should be addressed to Matt Bartels, mattxyz@earthlink.net.
Notes on January 2012 update:(Tweeters email)
What better way to start 2012 than with a brand new checklist?
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 the taxonomic updates published by the AOU in 2011.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 December 2011.
It includes:
1. Addition of two new species for Washington: Wood Sandpiper & Lawrence's Goldfinch
2. The taxonomic updates published by the AOU's 52nd checklist supplement. This update included a major revision of the warbler organization and a few other tweaks.
3. County Firsts through December 2011, and a few updated county codes.
4. I also added a couple tweaks to the basics of the checklist -- Bird Records Committee review species are listed in italics and I've included 'county average' calculations on the right side of the sheet.
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 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 Lesser Yellowlegs and anther row below Lesser Goldfinch. 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 between Lesser Yellowlegs and Upland Sandpiper, and another row between Lesser Goldfinch & American Goldfinch.Those changes will leave your data ready for transfer.
5. 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 this version (once you've added the blank rows for the new state species) this would be all the cells from G4 to AT511.
6. Click on the F4 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.
7. 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 Skamania County Eurasian Collared-Dove 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.
Contact 
: info@wabirder.com
| Contact the web master at Green Pastures Enterprises |  |