I am developing an application to calculate navigation data from Sun & Star
sights (interesting for sailors, boring for everyone else).

The problem is that I appear to be getting small inaccuracies when
calculating angles. I have used Double as the data type. Looking through
the help files I note that there should be a 'Decimal' data type that uses
many more digits so potentially improving accuracy. However, a line such
as:

Dim dLat as Decimal

results in a message: 'Compile error: Expected: New or type name'

I understand that this is saying it doesn't recognise the Decimal data type.
Do I have to add a library to use this? if so which one?

Any ideas gratefully received.

Peter Morris

Peter,

From a Myrna Larson post:
'-----------------------------------
The decimal data type is a subtype of a variant. You must Dim the variable as a
variant, then put the data into it with the CDec function. Since Decimals can
have up to 28 significant figures, and doubles are limited to 15 or 16, how do
you assign a literal value to one? From a string representation of the number,
i.e.
Dim Dec As Variant
Dec = CDec("1234567890123456789012345678")
Debug.Print Dec, TypeName(Dec)
'------------------------------------
From a Chip Pearson post:
To display these values on a worksheet, you'll have to change them to
strings to prevent Excel from rounding them ...
Range("C2").Value = " ' " & CStr(Dec)
'-----------------------------------

Regards,
Jim Cone
San Francisco, CA

"Peter M" wrote in message
...
I am developing an application to calculate navigation data from Sun & Star
sights (interesting for sailors, boring for everyone else).
The problem is that I appear to be getting small inaccuracies when
calculating angles. I have used Double as the data type. Looking through
the help files I note that there should be a 'Decimal' data type that uses
many more digits so potentially improving accuracy. However, a line such
as:
Dim dLat as Decimal
results in a message: 'Compile error: Expected: New or type name'
I understand that this is saying it doesn't recognise the Decimal data type.
Do I have to add a library to use this? if so which one?
Any ideas gratefully received.
Peter Morris

Jim,

Does this mean that I could get greater accuracy simply by declaring
variables as Variant rather than Double?

ie use: Dim x, y, z
rather than Dim x as double, y as double, z as double.

Peter Morris

"Jim Cone" wrote in message
...
Peter,

From a Myrna Larson post:
'-----------------------------------
The decimal data type is a subtype of a variant. You must Dim the variable
as a
variant, then put the data into it with the CDec function. Since Decimals
can
have up to 28 significant figures, and doubles are limited to 15 or 16,
how do
you assign a literal value to one? From a string representation of the
number,
i.e.
Dim Dec As Variant
Dec = CDec("1234567890123456789012345678")
Debug.Print Dec, TypeName(Dec)
'------------------------------------
From a Chip Pearson post:
To display these values on a worksheet, you'll have to change them to
strings to prevent Excel from rounding them ...
Range("C2").Value = " ' " & CStr(Dec)
'-----------------------------------

Regards,
Jim Cone
San Francisco, CA

"Peter M" wrote in message
...
I am developing an application to calculate navigation data from Sun &
Star
sights (interesting for sailors, boring for everyone else).
The problem is that I appear to be getting small inaccuracies when
calculating angles. I have used Double as the data type. Looking
through
the help files I note that there should be a 'Decimal' data type that
uses
many more digits so potentially improving accuracy. However, a line
such
as:
Dim dLat as Decimal
results in a message: 'Compile error: Expected: New or type name'
I understand that this is saying it doesn't recognise the Decimal data
type.
Do I have to add a library to use this? if so which one?
Any ideas gratefully received.
Peter Morris

No. And you really can't get more accuracy unless you write your own
functions. If you passed a Variant of type Decimal to a built in function,
it would be converted to double or whatever the function normally works in.

I know someone has written an addin that does basic math with numbers of
creater precision than double, but I don't recall the name of it or the
author. You could try a google search on Excel, Addin, Precision or
something like that. Anyway, as I recall, this person was adding standard
functions to the addin to do more complex math at higher pecision. Note
that Excel works at the IEEE standard for double precision which is about 15
digits.

Also, Chip Pearson has a page on working with Latitudes and Longitudes-
maybe this has some bearing on your problem.
http://www.cpearson.com/excel/latlong.htm

Anyway, just declaring a variable as Variant will not make it a decimal
value if you assign it a number. It will retain whatever precision it had.
You would have to assign it to the variant with the cdec conversion function

Dim vVariant as Variant
vVariant = cdec(123.456567)

--
Regards,
Tom Ogilvy

"Peter M" wrote in message
...
Jim,

Does this mean that I could get greater accuracy simply by declaring
variables as Variant rather than Double?

ie use: Dim x, y, z
rather than Dim x as double, y as double, z as double.

Peter Morris

"Jim Cone" wrote in message
...
Peter,

From a Myrna Larson post:
'-----------------------------------
The decimal data type is a subtype of a variant. You must Dim the
variable
as a
variant, then put the data into it with the CDec function. Since
Decimals
can
have up to 28 significant figures, and doubles are limited to 15 or 16,
how do
you assign a literal value to one? From a string representation of the
number,
i.e.
Dim Dec As Variant
Dec = CDec("1234567890123456789012345678")
Debug.Print Dec, TypeName(Dec)
'------------------------------------
From a Chip Pearson post:
To display these values on a worksheet, you'll have to change them to
strings to prevent Excel from rounding them ...
Range("C2").Value = " ' " & CStr(Dec)
'-----------------------------------

Regards,
Jim Cone
San Francisco, CA

"Peter M" wrote in message
...
I am developing an application to calculate navigation data from Sun &
Star
sights (interesting for sailors, boring for everyone else).
The problem is that I appear to be getting small inaccuracies when
calculating angles. I have used Double as the data type. Looking
through
the help files I note that there should be a 'Decimal' data type that
uses
many more digits so potentially improving accuracy. However, a line
such
as:
Dim dLat as Decimal
results in a message: 'Compile error: Expected: New or type name'
I understand that this is saying it doesn't recognise the Decimal data
type.
Do I have to add a library to use this? if so which one?
Any ideas gratefully received.
Peter Morris

Hi Tom,
I think this is the site. http://precisioncalc.com/
I don't see any trig functions. May be able to code them the hard way.


--
John
johnf 202 at hotmail dot com


"Tom Ogilvy" wrote in message
...
| No. And you really can't get more accuracy unless you write your own
| functions. If you passed a Variant of type Decimal to a built in
function,
| it would be converted to double or whatever the function normally works
in.
|
| I know someone has written an addin that does basic math with numbers of
| creater precision than double, but I don't recall the name of it or the
| author. You could try a google search on Excel, Addin, Precision or
| something like that. Anyway, as I recall, this person was adding
standard
| functions to the addin to do more complex math at higher pecision. Note
| that Excel works at the IEEE standard for double precision which is about
15
| digits.
|
| Also, Chip Pearson has a page on working with Latitudes and Longitudes-
| maybe this has some bearing on your problem.
| http://www.cpearson.com/excel/latlong.htm
|
| Anyway, just declaring a variable as Variant will not make it a decimal
| value if you assign it a number. It will retain whatever precision it
had.
| You would have to assign it to the variant with the cdec conversion
function
|
| Dim vVariant as Variant
| vVariant = cdec(123.456567)
|
| --
| Regards,
| Tom Ogilvy
|
| "Peter M" wrote in message
| ...
| Jim,
|
| Does this mean that I could get greater accuracy simply by declaring
| variables as Variant rather than Double?
|
| ie use: Dim x, y, z
| rather than Dim x as double, y as double, z as double.
|
| Peter Morris
|
| "Jim Cone" wrote in message
| ...
| Peter,
|
| From a Myrna Larson post:
| '-----------------------------------
| The decimal data type is a subtype of a variant. You must Dim the
| variable
| as a
| variant, then put the data into it with the CDec function. Since
| Decimals
| can
| have up to 28 significant figures, and doubles are limited to 15 or
16,
| how do
| you assign a literal value to one? From a string representation of the
| number,
| i.e.
| Dim Dec As Variant
| Dec = CDec("1234567890123456789012345678")
| Debug.Print Dec, TypeName(Dec)
| '------------------------------------
| From a Chip Pearson post:
| To display these values on a worksheet, you'll have to change them to
| strings to prevent Excel from rounding them ...
| Range("C2").Value = " ' " & CStr(Dec)
| '-----------------------------------
|
| Regards,
| Jim Cone
| San Francisco, CA
|
| "Peter M" wrote in message
| ...
| I am developing an application to calculate navigation data from Sun
&
| Star
| sights (interesting for sailors, boring for everyone else).
| The problem is that I appear to be getting small inaccuracies when
| calculating angles. I have used Double as the data type. Looking
| through
| the help files I note that there should be a 'Decimal' data type
that
| uses
| many more digits so potentially improving accuracy. However, a line
| such
| as:
| Dim dLat as Decimal
| results in a message: 'Compile error: Expected: New or type name'
| I understand that this is saying it doesn't recognise the Decimal
data
| type.
| Do I have to add a library to use this? if so which one?
| Any ideas gratefully received.
| Peter Morris
|
|
|
|
|
|
|