NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Formatting in spreadsheets (was: learning sight reduction)
From: Jim Hickey
Date: 2006 May 4, 10:41 -0500
-----Original Message-----
From: Alexandre E Eremenko <eremenko@math.purdue.edu>
To: NavList@fer3.com
Sent: Thu, 4 May 2006 11:09:18 -0400 (EDT)
Subject: [NavList 117] Re: Formatting in spreadsheets (was: learning sight reduction)
--~--~---------~--~----~------------~-------~--~----~
To post to this group, send email to NavList@fer3.com
To from this group, send email to NavList-@fer3.com
-~----------~----~----~----~------~----~------~--~---
From: Jim Hickey
Date: 2006 May 4, 10:41 -0500
A slick way to handle this is to format the input cell with a custom input mask. Go to format, cells, custom.
Try 000 00' 00''. Note I have used two ' symbols back to back as opposed to a single " for seconds as Excel will not take the " in a mask. Now you can simply enter into that cell 1041623 and it will display as 104 16' 23''. Then use a formula to pick out the parts to convert to decimal degrees as Peter pointed out.
There is a RADIANS and DEGREES function for conversion although using the PI/180 factor is probably just as easy.
Jim
-----Original Message-----
From: Alexandre E Eremenko <eremenko@math.purdue.edu>
To: NavList@fer3.com
Sent: Thu, 4 May 2006 11:09:18 -0400 (EDT)
Subject: [NavList 117] Re: Formatting in spreadsheets (was: learning sight reduction)
Peter, On Thu, 4 May 2006 Smith_Peter@emc.com wrote: >How have others handled this? More or less the same way you did. My spreadsheet consists essentially of three columns: one for whole degrees, second for minutes with fractions, third for radians. Exception in the row where I enter time it has an extra cell for time seconds. The rows are of two types: input rows and output rows. In the input rows I enter degrees and minutes of my input, and the formula in the radian cell transfers them to radians. The output rows act in the opposite direction. The radian cell contains some formula for computing some quanity, like azimuth, altitude, or a distance, it is computed in radians. Then the result is translated into degrees and minutes by a formula in each correspoinding cell of the same row. I have several spreadsheets for varioius tasks. (Sun altitudes, stars, planets, star distances and Lunar distances). The idea to CONCATENATE degrees and minutes in one output cell did not occure to me:-) Thanks for suggesting it. Alex.
--~--~---------~--~----~------------~-------~--~----~
To post to this group, send email to NavList@fer3.com
To from this group, send email to NavList-@fer3.com
-~----------~----~----~----~------~----~------~--~---