Electronic Purple Martin Prognosticator (EPMP)- Current Excel Version 2.0.8  & Open Office Version 12 (released 7/12/11)

Download Prognosticator 2.0.8  (Microsoft Excel Spreadsheet format - file size about 3287 kb)

 

Download OpenOffice Prognosticator v12 (OpenOffice Spreadsheet format - file size about 883 kb)    

Version 2.0.8 corrects some minor statistical errors, some minor formula errors, and now tracks number of pairs at the colony each year plus enhanced the email instructions when reporting to martin organizations.  You can now designate up to 3 email addresses and the spreadsheet will automatically email the worksheet for the selected year (not the whole spreadsheet) to those you chose such as PMCA or Purple Martin Society for end of the year reporting.

 

The OpenOffice formatted  version does NOT have the automatic email capability but you can select the worksheet and email it manually through the software.  Best of all this option is FREE, OpenOffice does not cost anything to use.

1. Download the file in the format of your choice. 
2. The spreadsheet comes populated with data for the years 2002 and 2003 to give you an idea of how to enter data and to see some of the reports and tables.  You should delete the data or replace it with your own after reviewing it.  Critical areas of the spreadsheet are protected and cannot be erased accidentally.  In general, cells in white are for data entry and are unprotected.  Colored cells usually contain formulas and cannot be erased or modified.
3. When you open the spreadsheet in your program you will arrive at the Summary Page.  From there you can go to the Instructions Page, the Graph Averages Per Year, and Individual Years by clicking on the blue hyperlinks in the Year column of the table or by clicking on the appropriate tabs at the bottom of the page.  Years 2002 thru 2015 can be accommodated at the present time.  Any letters in blue with a line underneath them are hyperlinks to other areas of the spreadsheet.  More detailed instructions are present on the 'Instructions' page.
4. This software is provided free of charge.  If you find any bugs or would like to request new features or have ideas for improving it please .  I hope you enjoy the spreadsheet and find it useful.
   
   Roger Lee