RE: EXCEL Query

2008-08-25 Thread Anne Bruvold
Sorry, I was in a hurry yesterday morning so I sent this only to Tony. And as it turned out, there were some problems when I tried to send it to the list. Trying again today. I am not enclosing the file as I do not have time to follow up if the file don't get through the mailing system. These a

Re: equal and unequal hours

2008-08-25 Thread Mario Arnaldi
Sorry, I think that my poor English made me misunderstood. When I wrote «Dear Willi and Roger, that sundial is not the one that Severino means. It is older.» I actually mean that Severino was speaking about other two sundials on the dome, older that the one shown in the photographs that you got

Re: equal and unequal hours

2008-08-25 Thread Frank King
Dear Mario, Many thanks for your kind explanation... > Censorinus and Gellius citing Varro say that > in Rome the day was intended in two ways: natural > and civil. I am slowly gaining some understanding of time in ancient Rome. Gianni Ferrari has pointed us at: http://penelope.uchicago.edu/

Re: EXCEL Query

2008-08-25 Thread Th. Taudin Chabot
Tony, I didn't see the solution of Anne Bruvold on this list. Could you let us know what his solution was? Thibaud At 14:15 25-08-2008, Tony Moss wrote: Hi All, Many Thanks for the prompt responses to my query. Anne Bruvold in Tromsø wins this gold medal with a simple and elegant

Re: Transfer to EXCEL

2008-08-25 Thread Simon [illustratingshadows
Page 8 of "Calculating-Shadows.pdf" on my website www.illustratingshadows.com goes into this issue. Watch out for how Excel handles the INT function. I can't remember if I left Calculating-Shadows.pdf in the booklet section, if not then do:- http://www.illustratingshadows.com/Calculating-Shad

EXCEL Query

2008-08-25 Thread Tony Moss
Hi All, Many Thanks for the prompt responses to my query. Anne Bruvold in Tromsø wins this gold medal with a simple and elegant solution. Our W O N D E R F U L SML does its job once again. Tony Moss. --- https://lists.uni-koeln.de

Re: Transfer to EXCEL

2008-08-25 Thread Th. Taudin Chabot
Tony, if you note the degrees in your spreadsheet as if they are a time value you can do a lot in Excel. e.g. 52:36:12 can be displayed as is typed here using the format "Time 37:30:55" otherwise it will be intrepreted as 2 days 4hrs 36 minutes 12 seconds. you can easyly add and substract. The

Re: Transfer to EXCEL

2008-08-25 Thread Chris Lusby Taylor
Hi Tony, I'm not 100% clear what you want to display. For instance, for -0.75 minutes do you want -0 and -45 or -0 and 45 or 0 and -45? Or, doesn't it matter much so long as any non-zero figure has the correct sign? Also, for -4.483 do you want -4 and -28.98 or do you want the seconds rounded to,

Transfer to EXCEL

2008-08-25 Thread Tony Moss
Fellow Shadow Watchers, For many years now all my dialling calculations have been done using spreadsheets in an ancient version of MicroSoft 'Works'. A recent change of Mac operating system has me painfully transferring everything to EXCEL version 12.1.1