|
|
|---|
|
Old Version Catching Page for Peter Edwards' Stud BookIn order to catch the situation where someone has bookmarked an old version or is using an old Email that contains a link, there is .xls or .doc file that has the same filename as the old version and will link to this catching page, the original old files have been re-filed in the directory 'old' and accessible from the menu at left. |
|---|
Revision history:-
Ver. Action 1.0 Created 12/11/2006 1.1 Added column to compare Productivity/Apiary 1.2 Corrected validation limits and increased row heights in Last Visit sheet 1.3 Suppressed zeroes from Queen Record Sheets to make Stud Book easier to interpret; made all fonts black; made all number in Stud Book integers; added apiary and hive columns to Stud Book to help with filtering and interpretation. 1.4 Fixed problem with initializing program related to BIG menu on computers without Adobe. 1.5 Protected workbook for headers and formulae. 1.6 Added 'traffic light' colour coding to Stud Book sheet to give quick visual indication of good/fair/bad scores. 1.7 Added procedure to 'BIG' menu to allow users to choose whether to update the 'Stud Book' with data for either live or dead queens and added appropriate columns to 'Stud Book' sheet. Some minor tidying. 1.8 Corrected error in 1.6 (above) caused by lack of rounding of scores and added borders to the cells. 1.9 Tidied formatting of all cells. 2.0 Corrected error in sorting of data for dead queens. 2.1 Improved navigation to Queen Assessment Records by adding a macro accessed using 'BIG' menu or Ctrl+t. Removed redundant 'Control Form'. 2.2 12/06/2007. Added two macros to populate the Stud Book with queens from a specific breeder, or of a specific origin. Added keyboard shortcuts for all macros. Modified 'Stud Book' page header to show which records are currently being displayed. 2.3 16/07/2007. Increased decimal places for Ci and DsA fields from 1 to 2. 2.4 29/07/2007. Added macro to populate the Stud Book with all queens. 2.5 26/09/2007. Added menu item for the above macro. Made all Ci and DsA fields 2 decimal places. Added field to Queen Assessment Record and column to Stud Book to record A.m.m. %. 2.52 23/05/2008. The main page now scrolls back to the left-hand columns after an update (cosmetic) validation has been added to the Last Visit Update macro so that it is now impossible to update record cards unless a hive number and date is entered for the assessment (previously only the queen number was required).
In addition to the above, there is a version 2a as a result of a delay in my implementation of some changes, it is thought unlikely that a problem occurred due to the delay, but the version 2.1 and 2.1a are both included for completeness sake.
From version 2.5 all downloaders are pointed at this page, in order that the user can select the latest version or refresh their download of a previous one.
