If you’re a Mac user (once a Mac, never back), you probably share my incredible frustration that although Macs have crept up steadily to more than 10% market share, there still isn’t a native Mac application for butterfly life listing. We Macophiles have resorted to keeping our data on the very clunky NABA Butterflies I’ve Seen List (and some of us watched in horror as those data disappeared during the recent makeover — thankfully, it was quickly restored!) , or the even more problematic Audubon Guides life list function.
Harry LeGrand, working off a template developed by Jeff Pippen, announced on CarolinaLeps last week an Excel spreadsheet lifelist with pretty darn good functionality, and is making it freely available to interested folks. Click the link to download your copy: LeGrand-Pippen master butterfly-lifelist
Of course, what we *really* need is the butterfly version of eBird. Surely some of our tech-savvy readers can help out with that??
Here’s Harry’s original post:
>>Some folks were discussing software for using for one’s butterfly lifelists.
There was discussion about using AviSys to produce a format for your lifelist.
I have AviSys 6, and I tried to use directions provide by David Trently, and/or
others about 1-2 years ago, and I simply could not download the AviSys file —
So, if you are a klutz like me in terms of downloading, zipping and unzipping,
etc., Jeff Pippen developed an Excel file for personal use. I have edited that
for my own use — such as changing some scientific names and common names, or
moving species around. So, I stripped the file down to basics — a number
column on the left (needs editing), the Common Name in the 2nd column, and the
Scientific Name in the 3rd column. The 4th column I put Date, for use for the
first date you see the species in your NABA list, the 5th column for Location
(where you first saw it), then “NC” for checking off if you have seen it in NC
(or SC if you wish), and put NABA in the 7th column, for checking if you have
seen it north of Mexico. Then, you can use the additional columns (H-the end)
for each triplist outside of the Carolinas, such as a 5-day trip to s. Florida
(where I put numbers rather than X in cells).
Of course, one can edit the file as you wish, especially columns D and beyond.
Also, you can easily edit name changes, etc. The list has a few subspecies.
There is a way to add a formula to the file that automatically adds up the
columns for list totals (NC, NABA, each field trip, etc.). You likely will need
an Excel book to help you with that! You really don’t want to have to add up
your checkmarks by hand!
Anyway, contact me if you want me send you the Excel file, as an attachment. It
has about 790 species listed, essentially everything recorded north of The
Border as of about 3 years ago. I don’t want to hear any more complaining about
not having a butterfly checklist for keeping your totals and life lists!! Too
bad I just can’t put the attachment on this message, but the listserve doesn’t
allow that. 😦
NC Natural Heritage Program
DENR Office of Planning, Conservation, and Community Affairs
Raleigh, NC 27699-1601
(919) 715-8697 (work)