NEW UPDATED VERSION AVAILABLE!
Use the following URL to download a corrected version of my Purple Martin Prognosticator. It corrects some calculation errors primarily on the Summary Page. My apologies to those who have already downloaded the original version below.
New version can be found at: https://onedrive.live.com/edit.aspx?cid ... &app=Excel
Hope you enjoy it.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
As the purple martin season is approaching I have expanded my Electronic Purple Martin Prognosticator spreadsheet to now include years 2002 - 2030.
It is an Excel spreadsheet that landlords can use to monitor and record critical colony information and statistics from year to year. It has inputs for # of pairs, # of eggs laid and hatched, # fledged, arrival dates from year to year, and several graphs to visually check your colony performance. It also includes a printable colony observation sheet that you can take to the field to record your data. Please read the instruction sheet prior to use for best results.
It is freely available at the following location: https://1drv.ms/x/s!AjAj8HbqHkUPlLJNWBw ... w?e=3VdyEL. You must have MIcrosoft Excel to use it but if you have a Microsoft account it will work with the free Excel Web Version as well.
Please contact me with any bugs, comments, or suggestions for improvement.
Hope you enjoy using it.
New Electronic Purple Martin Prognosticator Spreadsheet
-
C.C.Martins
- Posts: 3368
- Joined: Fri Apr 14, 2017 11:15 am
- Location: Corpus Christi Tx
- Martin Colony History: 2016- Visitors.
2017- 5 pair. 15 fledged
2018- 18 pair. 85 fledged
2019- 17 pair. 81 fledged
2020- 25 pair. 111 fledged
2021- 28 pair. 118 fledged
2022- 33 pair. 151 fledged
2023- 33 pair. 165 fledged
2024- 40 pair. 185 fledged
2025- 40 pair. 181 fledged
HOSP:
Home colony: mix natural, super, Troyer and excluder gourds, enlarged compartment house. All SREH.
Satellite colony: Oso Bay Preserve: 49 PMCA excluder gourds; 16 room Lonestar Goliad with Modified Excluder entrances.
2019: Visitors
2020: 3 pair, 11 fledged
2021: 10 pair, 30 fledged
2022: 11 pair, 35 fledged
2023: 18 pair, 101 fledged
2024: 39 pair, 181 fledged
2025: 51 pair, 216 fledged
PMCA member
Roger,
That is quite nice, wow! I print and use the PMCA form, then put them away. This is a great tool sir! Would have taken me 20 years to do.
Ill input the data from the years past, great help. We had 3 pair of martins at our satellite site last year (2 years trying), they would enjoy the data points.
Thank you!
Tom
That is quite nice, wow! I print and use the PMCA form, then put them away. This is a great tool sir! Would have taken me 20 years to do.
Ill input the data from the years past, great help. We had 3 pair of martins at our satellite site last year (2 years trying), they would enjoy the data points.
Thank you!
Tom
A good house sparrow is a dead house sparrow.
HOSP: 17. Starlings: 23
HOSP: 17. Starlings: 23
Roger,
Thanks for the update ! This makes record keeping of purple martin colonies so easy. I have it on my phone in my OneDrive and makes monitoring
a satellite colony a breeze . The Summary Page, Averages ,Occupancy, Hatching and Fledging rate pages give a landlord so much information .
The auto fill on the Projected Hatch Date and Projected Fledge Date give a landlord a lot of information on each cavity before starting and during nest checks.
Rick
Thanks for the update ! This makes record keeping of purple martin colonies so easy. I have it on my phone in my OneDrive and makes monitoring
a satellite colony a breeze . The Summary Page, Averages ,Occupancy, Hatching and Fledging rate pages give a landlord so much information .
The auto fill on the Projected Hatch Date and Projected Fledge Date give a landlord a lot of information on each cavity before starting and during nest checks.
Rick