RE: EXCEL Query
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 are the formulas for second row, first row contains heading. Just copy and paste for 3rd end 4th row and so on. Column A: Decimal minutes, ie original numbers Column B: Minutes, formula: =TRUNC(A2), truncates the value in A2 Column C: Decimal seconds, formula: =(A2-B2)*60, multiplies the decimal part of A2 by 60, converting to seconds. Column D: Seconds, formula: =TRUNC((A2-B2)*60), this could of course also be =TRUNC(C2) This gives Decimal minutes Minutes Decimal seconds Seconds 3.263 15.615 -4.483 -4 -28.98 -28 -0.816 0 -48.96 -48 TRUNC (truncate) returns the integer part by plainly removing the fractional part. Both 3.2 and 3.9 makes 3. Best AnneB Tromsø, Norway --- https://lists.uni-koeln.de/mailman/listinfo/sundial
Re: equal and unequal hours
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 in Internet». Mario --- https://lists.uni-koeln.de/mailman/listinfo/sundial
Re: equal and unequal hours
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/Thayer/E/Roman/Texts/secondary/SMIGRA*/Dies.html This confirms what you say and refers to: dies naturalis and dies civilis Can you tell me how the common people knew what the time was? If the Circus Maximus announced a good chariot race next Friday, or the Colosseum announced a big fight next Saturday, how would people arrive at the right time? Did a Praeter go through the streets ringing a bell? Were there public klepshydras? Were there sundials on many buildings? It is hard to understand how a big city could work unless the citizens knew the time! Best wishes Frank --- https://lists.uni-koeln.de/mailman/listinfo/sundial
Re: EXCEL Query
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 solution. Our W O N D E R F U L SML does its job once again. Tony Moss. --- https://lists.uni-koeln.de/mailman/listinfo/sundial -- Th. Taudin Chabot, . [EMAIL PROTECTED] --- https://lists.uni-koeln.de/mailman/listinfo/sundial
Re: Transfer to EXCEL
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-Shadows.pdf and note that the C and the S of the file name are in upper case. Simon --- On Mon, 8/25/08, Chris Lusby Taylor <[EMAIL PROTECTED]> wrote: > From: Chris Lusby Taylor <[EMAIL PROTECTED]> > Subject: Re: Transfer to EXCEL > To: "Tony Moss" <[EMAIL PROTECTED]>, "Sundial Mailing List" > > Date: Monday, August 25, 2008, 4:56 AM > 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, say, the nearest second? The following assumes > you do want > rounding to the nearest second. Omit the ROUND functions if > you don't. > > I don't use Excel, I use Open Office, but am pretty > sure the following works > in both: > > Assuming cell A1 has the number you want to convert, then > to get whole > minutes use: > =ROUNDDOWN(ROUND(A1*60)/60) > > (Note that ROUNDDOWN rounds towards zero, which is what you > want.) > > Assuming you put the whole minutes in cell B1, then seconds > are: > =ROUND(60*(A1-B1)) > > For -0.75 minutes this will give 0 and -45 > For -1.25 minutes it will give -1 and -15 > For 2.999 minutes it will give 3 minutes 0 seconds. > For -4.483 minutes it will give -4 and -29 > > I don't know any simple way to display -0. It's > much easier to show 0. > > Hope this helps > Best wishes > Chris > > > > > - Original Message - > From: "Tony Moss" > <[EMAIL PROTECTED]> > To: "Sundial Mailing List" > > Sent: Monday, August 25, 2008 10:35 AM > Subject: Transfer to EXCEL > > > > 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 > > Data cells COPY/PASTE directly but some of the > 'Works' formulae no > > longer function and 'Help' is pretty > convoluted. > > > > I need to take positive and negative decimal times > e.g. 3.26 minutes and > > -4.483 minutes and convert them into two columns of > whole minutes and > > whole seconds. As I recall negative values of less > than 1 minute e.g > > -0.816 mins. were a particular problem. > > > > As one who has to take his shoes off for numbers > greater than 10 :-) > > any assistance would be much appreciated. > > > > Tony Moss > > --- > > https://lists.uni-koeln.de/mailman/listinfo/sundial > > > > --- > https://lists.uni-koeln.de/mailman/listinfo/sundial --- https://lists.uni-koeln.de/mailman/listinfo/sundial
EXCEL Query
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/mailman/listinfo/sundial
Re: Transfer to EXCEL
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. There are functions like minute() to extract the number of minutes etc. Excel doesn't see the difference between coordinates and time. Thibaud At 11:35 25-08-2008, Tony Moss wrote: 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 Data cells COPY/PASTE directly but some of the 'Works' formulae no longer function and 'Help' is pretty convoluted. I need to take positive and negative decimal times e.g. 3.26 minutes and -4.483 minutes and convert them into two columns of whole minutes and whole seconds. As I recall negative values of less than 1 minute e.g -0.816 mins. were a particular problem. As one who has to take his shoes off for numbers greater than 10 :-) any assistance would be much appreciated. Tony Moss --- https://lists.uni-koeln.de/mailman/listinfo/sundial -- Th. Taudin Chabot, . [EMAIL PROTECTED] --- https://lists.uni-koeln.de/mailman/listinfo/sundial
Re: Transfer to EXCEL
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, say, the nearest second? The following assumes you do want rounding to the nearest second. Omit the ROUND functions if you don't. I don't use Excel, I use Open Office, but am pretty sure the following works in both: Assuming cell A1 has the number you want to convert, then to get whole minutes use: =ROUNDDOWN(ROUND(A1*60)/60) (Note that ROUNDDOWN rounds towards zero, which is what you want.) Assuming you put the whole minutes in cell B1, then seconds are: =ROUND(60*(A1-B1)) For -0.75 minutes this will give 0 and -45 For -1.25 minutes it will give -1 and -15 For 2.999 minutes it will give 3 minutes 0 seconds. For -4.483 minutes it will give -4 and -29 I don't know any simple way to display -0. It's much easier to show 0. Hope this helps Best wishes Chris - Original Message - From: "Tony Moss" <[EMAIL PROTECTED]> To: "Sundial Mailing List" Sent: Monday, August 25, 2008 10:35 AM Subject: Transfer to EXCEL > 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 > Data cells COPY/PASTE directly but some of the 'Works' formulae no > longer function and 'Help' is pretty convoluted. > > I need to take positive and negative decimal times e.g. 3.26 minutes and > -4.483 minutes and convert them into two columns of whole minutes and > whole seconds. As I recall negative values of less than 1 minute e.g > -0.816 mins. were a particular problem. > > As one who has to take his shoes off for numbers greater than 10 :-) > any assistance would be much appreciated. > > Tony Moss > --- > https://lists.uni-koeln.de/mailman/listinfo/sundial > --- https://lists.uni-koeln.de/mailman/listinfo/sundial
Transfer to EXCEL
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 Data cells COPY/PASTE directly but some of the 'Works' formulae no longer function and 'Help' is pretty convoluted. I need to take positive and negative decimal times e.g. 3.26 minutes and -4.483 minutes and convert them into two columns of whole minutes and whole seconds. As I recall negative values of less than 1 minute e.g -0.816 mins. were a particular problem. As one who has to take his shoes off for numbers greater than 10 :-) any assistance would be much appreciated. Tony Moss --- https://lists.uni-koeln.de/mailman/listinfo/sundial