PDA

View Full Version : Listing Headaches


sue-o
April 28th, 2009, 05:52 PM
Hi,
I have finally finished organizing my life list. I’m still missing some dates, but it’s good enough for government work and I have posted a link to it on my blog.
I formatted my list with Excel on my laptop. I made six columns:
Common Name, Scientific Name, Date, Location, Detailed Location and a box for whether I had a photo or not. My previous bird accounting consisted of check marks in field guides so I went through my guides and transferred the ‘checks/ticks’ to the spreadsheet (all but my Indonesian book which I gave to a student on the Kumai River in Borneo; that was before I envisioned a Life List :eek:.)
I started this spreadsheet some time ago (years?:laugh:). I have been good about entering data in all columns the last year or so, but my laziness about filling in past bird data came back to bite me. Yesterday, I worked like a fiend to fill in all the blanks and get this thing done! When I typed in scientific names, I was alerted that that name had been typed before and I found I had several duplicates. My life list is now seven birds less than it was before I finalized it. I had Jacana listed under Jacana and again under Waders (I can’ tell you how many times I rearranged where I put species.). I had White-breasted Wood-swallow listed by that name (Fiji) and again under Wood-swallows—White-breasted Wood-swallow(Australia). When I typed in the scientific name Podiceps nigricollis, I found that Black-necked Grebe (Turkey) was Eared Grebe (California), and the same problem occurred with Hen Harrier (Germany) and Northern Harrier (California). A more experienced birder would have said, “Hum, that Eared Grebe looks just like a Black-necked Grebe.”, and might not have just looked in whatever guide book he had for whatever country he was in and ticked off the new ‘lifer’. I find that one of the biggest obstacles I’ve had with birding during this sailing circumnavigation is that I left before I had developed birding skills at home. I was not familiar with plumage changes and it seemed I was most often in places during non-breeding seasons and identifying could often be frustrating.
I have configured my list to make things easy for me but I have no doubt that it is probably not the way it should be formatted. I listed alphabetically for several reasons. It will be easy for me to find the group I need and to add a new group when I reach a new area of avi-fauna I won’t have to try and figure out where to put what in a Taxonomic order. It’s one thing to follow Collins Bird Guide for Europe or a North American Guide and start with the Loons and end with Buntings, but where would I put Australo-Papuan Robins or some other such thing? I would then have to get into another column listing scientific family names and even superfamily names. I’m sure this issue would be a piece of cake for many of you, but I’m a rank amateur. Until I get home and have access to better reference material, I need to keep things simple. I listed the Australo-Papuan Robins as Robins. The American Robin and the European Robin went under T for thrushes. My Wader section is a bit of a mess though. Should I break it up and put Sandpipers under S or leave it as: Waders- -Sandpipers- -Curlew Sandpiper? I have Vultures under V, but should they be with the Raptors? Ex: Raptors- -Vultures- -Turkey Vulture.
Here is my Life List:
http://spreadsheets.google.com/pub?key=ryrvZLANMdpxHwejL7DSKgQ


Does anyone have any suggestions for improvement? (Other than telling me to put the list in Taxonomic order.;))
Thanks for reading this long thing.
Sue

michael23
April 28th, 2009, 07:07 PM
Hi sue, very impressive list! I think the way you have done the list is quite good, I would leave the sandpipers as they are. With regards vultures, i would put them as Raptors-Vultures- etc etc.
The only thing I would do, would be to do 1 family in bold and the next bold italic and so on. Would be easier to differntiate between different groups.

:beer: michael

sue-o
April 28th, 2009, 08:43 PM
Hi Michael,
Thanks for your in-put. I did change the vultures. Can't think why I didn't have them with the Raptors. I only noticed I had them separated after I posted the list. Your idea of differentiating the lines is a good one. I experimented a bit today but left it the old way for now. I will do it, but to tell you the truth I'm kinda sick of that list right now. It really was tedious.
Thanks again,
Sue
Edit: Done. I tried color highlights first but color wouldn't transfer to the web site for some reason. Thanks again for the suggestion Michael.

mikeprince
May 6th, 2009, 07:52 AM
Hi Sue

An impressive level of detail you've managed. You could also add your list to BUBO Listing www.bubo.org, a site I run which allows users to record all sorts of lists (life, year etc.) and compare them with other listers.

sue-o
May 14th, 2009, 12:28 AM
Hi Mike,
I hope you didn't view the list when it was all messed up! I don't know what happened; somehow the first line that says: Common Name etc went to the middle of the list and I lost about 40 species. I deleted the old link and did a new one. I am terrible with computers and weird things are always happening. I will check out your site.
Sue