z

 

Minutes Member Colonies
Downloads
 Menu

About Us
What's New
Downloads
Martin Monitor
Bluebirds
Mary Jo
Links
Contact Us

 

 

Tip

Look for an Open Office compatible spreadsheet coming soon.

 

 

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.

Background
The Electronic Purple Martin Prognosticator was developed by me as an additional method for martin landlords to maintain accurate records of their colonies from year to year and to monitor trends in the colony.  It was originally developed in Excel 97 spreadsheet format so it should be upward compatible with newer versions of Excel but now it was developed using Excel 2003.   I have now developed the spreadsheet in OpenOffice format so everyone can use the program free of charge without paying for the expensive Excel software. The format is patterned after the original Prognosticator developed by Mr. Ed Donath and is dedicated on his behalf.
Instructions for 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

Hit Counter

 
   
 

 Back Home Next

Property of CIPMA
For problems or questions regarding this web site contact