I am pleased to see that Fred Sawyer has included in the June NASS Compendium the "Analemmatic Spreadsheets" that Helmut Sonderregger and I have collaborated on. Look at the "letters, Notes, Email, Internet section. When I opened the version of the spreadsheet in the Compendium I noticed an error as it opens in Chart 1. The plot area containing the text boxes is shifted with respect to hour points, analemma and season markers. Someone inadvertently clicked and dragged the plot area before this version was saved. Unfortunately this is the first thing you see when you open the file.
This is a minor cosmetic problem that easy to fix, but first you have to unprotect the sheet by going to tools, protection and unprotect sheet. Then click on the grey area of the chart to activate the "Plot Area". Click and drag the plot area until the noon point beside the 12 is exactly on the North South axis. While you are there on Chart 1, click and drag the text boxes on the sunrise and sunset markers. The sunrise marker should be on the west side and the sunset on the east. These spreadsheets are works in progress. We appreciate your suggestions and feedback. An example is the AnalemmaB version also in the Compendium that includes the suggestions on a tilted gnomon. The inclined plane calculations will follow. Expect a version soon that includes the suggested table with distances to the hour points from the center and the noon point. Also coming is a special pie chart showing the seasonal markers correction epicycle for periodic error giving the date circle diameter and centerpoint as functions of date, latitude and size. Roger Bailey Walking Shadow Designs N 51 W 115 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sonderegger Helmut Sent: April 27, 2002 4:08 AM To: [email protected] Cc: Roger Bailey; [EMAIL PROTECTED] Subject: Re: Sloping Analemmatics Hi all, first of all many thanks for all your comments an suggestions to the Excel-spreadsheet "Analemmatc Sundial". There is now a new test version of the spreadsheet on my homepage. The main change is Anselmo's idea of introducing an inclining gnomon for generating different types of dials. The gnomon inclination for a "usual" analemmatic sundial is 90 deg. Graphics in Excel are very easy to generate, but here you can see some problems or limits, because the different sundial types look very different too, and I do not now how to fix the text positions with the changing values of the points. For a better adaption in the graphic charts a more complex software language would be useful.Yet, it is funny to see the different dials generated. Have fun Helmut PS: At the moment I am away rather often, so please excuse my late response! Helmut Sonderegger, A-6800 Feldkirch Email: [EMAIL PROTECTED] URL: http://webland.lion.cc/vorarlberg/280000/sonne.htm ----- Original Message ----- From: "Anselmo Pérez Serrada" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, April 15, 2002 10:42 PM Subject: Re: Sloping Analemmatics > Hi all, > > First of all, my congratulations to Helmut and Roger for the > spreadsheet... and for releasing it > as freeware in these mean ;-) times where everything is under patent laws. > > Now, I would even dare to make a small suggestion for next versions: why > not including inclined > gnomons in order to create Foster-Lambert or Parent Dials or any other > arbitrarily inclined projection dial, > like the one that John asked about? I sketched it in a rudimentary > spreadsheet and it is very easy. > > Concerning this topic, I strongly recommend you all the article on > Projection Sundials written by Bruno > Ernst, which you can find in Fer de Vries' web. It's just fan-tas-tic! > > Greetings, > > > Anselmo - -
