[Tweeters] [inland-NW-birders] WA Birder county excel sheet and one page checklists updated for 2023

[Bob Flores]

We owe these two more than we will ever be able to return. Thanks guys.

Bob Flores
Duluth, WA

On Jan 22, 2023, at 07:10, Tom Mansfield <birds at t-mansfield.com> wrote:


Hats off to Matt and Michael for making this historic resource available and user-friendly!  WA Birder co-founders Laurie and the late Ken Knittle are proud I’m certain of your dedication and as grateful as the rest of us.  Tom Mansfield in Seattle.

From: Inland-nw-birders <inland-nw-birders-bounces at uidaho.edu> On Behalf Of Matt Bartels
Sent: Saturday, January 21, 2023 7:38 AM
To: Tweeters (E-mail) <tweeters at u.washington.edu>; Inland-NW-Birders - To Post <inland-nw-birders at uidaho.edu>
Subject: [inland-NW-birders] WA Birder county excel sheet and one page checklists updated for 2023

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!iXVwS1O0N4cUavIV7D3VWkTQa5k30gtASQ7pLecjv90IXUav_n_fGu4XUBRH32ULTxB_IUs12I25IX6szIgRjPLmJZPr$>

Worth noting: Three 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.

In addition to a state first and many county firsts ,Franklin Kittitas and Klickitat  counties had their codes updated.

Background:
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. [I guess this is year #21 for this effort!] This year, the taxonomic sequence changed a bit again —the only notable change was in the Wren order. 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!iXVwS1O0N4cUavIV7D3VWkTQa5k30gtASQ7pLecjv90IXUav_n_fGu4XUBRH32ULTxB_IUs12I25IX6szIgRjPLmJZPr$> 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!iXVwS1O0N4cUavIV7D3VWkTQa5k30gtASQ7pLecjv90IXUav_n_fGu4XUBRH32ULTxB_IUs12I25IX6szIgRjORM5Vwr$>
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<https://urldefense.com/v3/__http:/www.wabirder.com/county_firsts.html__;!!JYXjzlvb!iXVwS1O0N4cUavIV7D3VWkTQa5k30gtASQ7pLecjv90IXUav_n_fGu4XUBRH32ULTxB_IUs12I25IX6szIgRjAvkrUSM$>

Finally, a reminder that your 2022 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<https://urldefense.com/v3/__http:/www.wabirder.com/forms.html__;!!JYXjzlvb!iXVwS1O0N4cUavIV7D3VWkTQa5k30gtASQ7pLecjv90IXUav_n_fGu4XUBRH32ULTxB_IUs12I25IX6szIgRjASXBbeO$>.


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



Matt Bartels
Seattle, WA
_______________________________________________
Inland-nw-birders mailing list
send email to: Inland-nw-birders at uidaho.edu
manage subscription: https://lists.uidaho.edu/mailman/listinfo/inland-nw-birders
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman11.u.washington.edu/pipermail/tweeters/attachments/20230122/4b0714a7/attachment.html>