# NavList:

## A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Message:αβγ
Message:abc
 Add Images & Files Posting Code: Name: Email:
Formatting in spreadsheets (was: learning sight reduction)
From: UNK
Date: 2006 May 4, 09:43 -0500

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?
>
> I have to allocate 3 cells for each number:
> for whole degrees, minutes with decimals, and for fractional degrees,

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

How have others handled this?

-- Peter

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

Drop Files

### Join NavList

 Name: (please, no nicknames or handles) Email:
 Do you want to receive all group messages by email? Yes No
You can also join by posting. Your first on-topic post automatically makes you a member.

### Posting Code

Enter the email address associated with your NavList messages. Your posting code will be emailed to you immediately.
 Email:

### Email Settings

 Posting Code:

### Custom Index

 Subject: Author: Start date: (yyyymm dd) End date: (yyyymm dd)