Skip to main content

Eggen Card Database: Photometric Observations Spreadsheet Status

1 post / 0 new
jcrast's picture
Eggen Card Database: Photometric Observations Spreadsheet Status

Version 3.5 of the Eggen Card Database spreadsheet Eggen Card Database: Photometric Observations is now online replacing version 3.4. The Reference document for this version has also replaced the 3.4 version. You can access these files by way of the "website" link in web page  Questions and comments should be sent to

This update includes modifications to the Eggen-tasks "New Star Sheet" and "Create AID Records" and the removal of Eggen-task "Remove Unused Rows".

"New Star Sheet" now creates the "SIMBAD Name" hyperlink used in index sheets INDEX1 and STATISTICS automatically, eliminating the need for manual creation of the link.

"Create AID Records" has been modified to use arrays for star sheet I/O rather than the much slower use of the spreadsheet .getValue() and .setValue() instructions. This method was first used in the Eggen-task "Create WebObs Data" in a previous version. The modification was done to fix a performance problem which caused "Create AID Records" to abnormally end (ABEND) because the maximum execution time of 6 minutes was exceeded when a star sheet contained more than 20 photometric observations. The abnormally long run time was caused by the spreadsheet's compulsion to refresh related cells every time a .setValue() instruction was executed.

Finally task "Remove Unused Rows" was removed because its design was poor and its results were unpredictable at times. It will return in a future release.

AAVSO 49 Bay State Rd. Cambridge, MA 02138 617-354-0484