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
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,
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.
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.
---
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:-
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
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:
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