the home for user uploads of any freeware software or data file related
Excel and other data files by e-mail attachment to Pietro.org.
Offsite books can be found on the Science
Checkout Sky & Telescope magazine listings of BASIC
programs that have appeared on its pages. Many an amateur celestial
mechanist started by typing these listings into their computers.
They can still be of use if you have access to the equation reference in
the original magazine article that accompanied them.
Below is the write-up on an
Excel spreadsheet dedicated to calculating solar (and some lunar)
phenomena.It is based on the
work of Jean
Meeus as documented in his well-known Astronomical
spreadsheet contains notes to allow users to match the columns of
calculations to the equations in the book.
DAILY SUN TABLEThe DAILY SUN TABLE is an Excel
2000 spreadsheet that will determine daily solar phenomena at
a location for a whole month.For
each day the local time of the Sun's rise, transit, set and time
above the horizon is displayed in the Results Table.Distributed as FREEWARE, this file can be
distributed freely as long as no modifications are made.
Fig #1: Input/Output Section Overview
(Version 1.0.2 and up)
instructions with references and web-links are included to assist the user
in inputting the correct data for their location. Comments and
book/web references are included for those interested in how the
calculations were done.
The self-extracting file can easily be downloaded at any connection
Requirements: a computer running Microsoft Windows 95 or better with Excel 2000
or better installed.
download, e-mail, broken links, missing graphics and other related problems to webmaster.
Post comments on this page in the Message Board.