The first sheet of BIRDLIST is a general comment page that list the species, followed by a comment column that usually contains the first date I ever saw the bird in my yard and any other significant sightings. The last 12 columns represent the months of the year, with the months that the species has been seen in my yard highlighted in yellow.
Sheet two of BIRDLIST is a narrowed version of the first sheet minus the comment column. Its purpose is to allow me to fit 150 species on to one sheet printed in landscape format, that I can fold in thirds and leave in field guide that I use primarily in my yard. Here is a zoomed in view of sheet2.
The third sheet of BIRDLIST is the meat and potatoes, the dog that herds the sheep, the trashcan that catches the puke in the data gathering process. It lists the species, followed by the numbers 1 thru 0 three times followed by a fourth 1. Any guesses to what these numbers represent? Answer : the days of the month, the first 1-0 represent the days of the 1st-10th, the second group of numbers represent the days 11th-20th and so on. The dates were abbreviated due to space restrictions. I print one out each month and mark with a pen the days that I see each bird. At the end of the month I total all the days I saw each species.
Here are 3 photos of the sheet I used in September with explanations of the marks I made on it.
The data gathered monthly is totaled and entered into another Excel worksheet I call "BIRD SURVEY", that totals the number of days a species is seen for the year and compared to previous years.
|8||RING BILLED GULL||20||14||29||30||21||28||21||18||22||16||24||243||203||179||164||139|