[nfc-l] Austin, Tx - Part 2. semi-automating a night flight station using OLDBIRD software and Excel
Subject: [nfc-l] Austin, Tx - Part 2. semi-automating a night flight station using OLDBIRD software and Excel
From: Mike Farmer
Date: Mon, Jan 9, 2012, 1:32 PM
So let’s go over the daily routine,,,,,run software Tseep and Thrush on last night’s recording file. Run GlassOFire to throw away the noise clips. Move the resulting Thrush and Tseep bird clips into their day folders. Run GlassOFire to sort the obvious birds from the day folders into the species folders. Rinse and repeat each day.
After you record for a number of days, you now have a lot of little wav files in a bunch of folders. This is what computers are for....to take the drudgery out of counting and displaying this type of suff.
So create an Excel worksheet with the Sorted Birds folder names, Unkown, SOSP, FISP, etc, across the top row of your spreadsheet. Then, down the left-most column put the day’s dates that you recorded in the YYYY-MM-DD format. So across the top, you have the bird species that correspond exactly to the folder names in the Sorted Birds folder. And down the left side of the spreadsheet, you have the date of each day you have recorded and these dates exactly correspond to the names on the day folders in Tseep and Thrush folders and to the date that you put on the front of each clip of the form YYYY-MM-DD.
We presently use three macros to do the work in our Excel worksheet. The first is CountFilesIf. In the first cell under the column Unknown, use CountFilesIf to count the number of birds in the day folder named to the left of the cell. Copy the cell and paste it down through the column below. Now you will always know how many unknowns for each day that you have to work on or that you have given up on! In all the other cells of the worksheet, use CountFilesIf to find the count for the species at the top of each column for the days at the left. Get one cell right and all you have to do is copy and paste in one motion all the rest. Bam....you are done.
No opening and closing folders to count bird clips to see what you have. Excel now just shows you what new birds came in last night in relationship with all the previous days. You can put in graphs and they will update automatically too.
Later you can make another table in the worksheet to display the percentages that each bird made up of each night’s flight. Or to display the hourly count for each species or .......
Life is good. Go birding.
-Mike Farmer
equipment
Mic – Oldbird 21c
Software – Oldbird tseep, thrush, GlassOFire, Raven Pro
--
NFC-L List Info:
http://www.NortheastBirding.com/NFC_WELCOME
http://www.NortheastBirding.com/NFC_RULES
http://www.NortheastBirding.com/NFC-L_SubscribeConfigurationLeave.htm
ARCHIVES:
1) http:(email address filtered)/maillist.html
2) http://www.surfbirds.com/birdingmail/Group/NFC-L
3) http://birdingonthe.net/mailinglists/NFCL.html
Please submit your observations to eBird:
http://ebird.org/content/ebird/
--
\r
