NavList:

In NavList 115, on Thursday, May 04, 2006 10:10 AM, Alex said:
>> I do like the ability to enter dd/mm.m in the Casio.
>
> Seems to be a unique feature that is lost on modern calculators.
> Does your Excel have the ability to store a number is such format?
>
> My spreadshit does not:-)
> I have to allocate 3 cells for each number:
> for whole degrees, minutes with decimals, and for fractional degrees,
> converted (or radians).

In Excel, I've handled this in two cells as follows:

In the working cell -- from which calculations will be done or results
stored -- I enter degrees using fractions. Thus, 12° 34.5' would be
entered as: =12+34.5/60. This displays as 12.575 . Likewise 12° 34' 56"
can be entered as: =12+34/60+56/3600.

Next to each such decimal-degrees cell, I set up a display cell, which
displays the adjacent value formatted naturally. To display the value
from cell A1 as degrees, minutes, and tenths, the formula would be:

=CONCATENATE(TEXT(INT(A1),"0"),"° ",TEXT(60*(A1-INT(A1)),"00.0'"))

One can take that one step farther if the value is signed and should be
labeled: for a latitude where + implies North and - implies South:

=CONCATENATE( TEXT(INT(ABS(A1)),"0"), "° ",
              TEXT(60*(ABS(A1)-INT(ABS(A1))),"00.0'"),
              IF(A1>0," N"," S") )

So, each of my worksheets tends to have two columns: one for working
values and one to format those values readably. That makes the sheet
both readable and debuggable.

How have others handled this?

-- Peter

--~--~---------~--~----~------------~-------~--~----~
To post to this group, send email to NavList@fer3.com
To from this group, send email to NavList-@fer3.com
-~----------~----~----~----~------~----~------~--~---