[Tweeters] WA Birder county excel sheet and one page checklists updated for the new yea

Matt Bartels mattxyz at earthlink.net
Sat Jan 22 17:59:18 PST 2022

Hello all!

Michael Hobbs and I have updated the WA Birder Excel spreadsheet and the one page county checklists for the new year.

The Excel checklist combines all the county codes in a sheet that allows you to tally your county totals [and do a bunch of other fun things]. Both the ‘enhanced’ version and the plain version are available at the Washington Birder website at:

http://wabirder.com/combined_county_list.html <https://urldefense.com/v3/__http://wabirder.com/combined_county_list.html__;!!JYXjzlvb!3F18_qp-uWbs5sgihdMteCAz_hNn0UX8aGAiAqyxyDdaikiifk1y2ptUV50hJsE1ST86ewnrwQ$>

Worth noting: Two years ago, we added a feature that allows you to generate a one page pdf of any county list with all your species checked off automatically. This is a really cool addition Michael coded up and I think it makes entering your ’ticks’ into the spreadsheet even more worthwhile.

Also new this year, in addition to a state first and many county firsts, several counties had their codes updated.

Every year since 2003 I've updated this checklist, adding new species and county firsts, and revising it to comply with the latest taxonomic updates produced by the AOU & ABA. This year, the taxonomic sequence changed a bit again —there were a bunch of little shuffles, especially in the passerines. In addition, the checkist can be sorted by the eBird sort order.

If you are looking for a color-coded way to track your county lists and/or see how abundant any species is in a given county, give the list a try.

With the 'enhanced' spreadsheet, you can generate county needs lists, see which counties you've seen or need any given species, and more. Instructions on using the spreadsheet are on the same page <https://urldefense.com/v3/__http://wabirder.com/combined_county_list.html__;!!JYXjzlvb!3F18_qp-uWbs5sgihdMteCAz_hNn0UX8aGAiAqyxyDdaikiifk1y2ptUV50hJsE1ST86ewnrwQ$> linked above.

Instructions on transferring your data from an older copy of your spreadsheet to the new one are included at the website as well.

The one page pdf blank county checklists are available at the following link: http://wabirder.com/county_map.html <https://urldefense.com/v3/__http://wabirder.com/county_map.html__;!!JYXjzlvb!3F18_qp-uWbs5sgihdMteCAz_hNn0UX8aGAiAqyxyDdaikiifk1y2ptUV50hJsE1ST8EQcpJOw$>
If you want to move away from the screen and enjoy some time filling in checks on a list, print out a few county lists and start marking it up.

A summary of all the new “County Firsts” is available at this link: http://www.wabirder.com/county_firsts.html <http://www.wabirder.com/county_firsts.html>

Finally, a reminder that your 2021 totals are due by the end of January— I’d encourage everyone to take some time and fill out the portions you track. It is always a great community event to pull this info together into one annual report we can share.
List Report (and Big Day) forms are available on the Washington Birder website: http://www.wabirder.com/forms.html <http://www.wabirder.com/forms.html>.

We look forward to feedback or suggestions, and would be happy to help troubleshoot problems if you run across them.

Matt Bartels
Seattle, WA
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman11.u.washington.edu/pipermail/tweeters/attachments/20220122/ed9e47be/attachment.html>

More information about the Tweeters mailing list