I am building a spread sheet to calculate the triangles for the setting out
stations for various sites and wish to work in grads i.e. 400degrees per
circle 100minutes per degree and 100seconds per minute. I don't have a
problem with the formulae for the lengths of the tringle sides i.e.the
distance between two stations but cannot seem to get excel to work in grads
or display results in degrees, minutes, seconds.
Is there a way around this please?
Regards
Davystuff

Hi

Have a look he
http://www.cpearson.com/excel/latlong.htm

It may help!
Andy.

"davystuff" wrote in message
...
I am building a spread sheet to calculate the triangles for the setting out
stations for various sites and wish to work in grads i.e. 400degrees per
circle 100minutes per degree and 100seconds per minute. I don't have a
problem with the formulae for the lengths of the tringle sides i.e.the
distance between two stations but cannot seem to get excel to work in
grads
or display results in degrees, minutes, seconds.
Is there a way around this please?
Regards
Davystuff

You will need to do the conversions.
Suppose A1 has grad value (say 50) and you want tit SIN of this
Use =SIN(RADIANS(A1*0.9))

If B1 has a value and you want its ASIN in grads use =DEGREES(ASIN(B1))/0.9

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"davystuff" wrote in message
...
I am building a spread sheet to calculate the triangles for the setting out
stations for various sites and wish to work in grads i.e. 400degrees per
circle 100minutes per degree and 100seconds per minute. I don't have a
problem with the formulae for the lengths of the tringle sides i.e.the
distance between two stations but cannot seem to get excel to work in
grads
or display results in degrees, minutes, seconds.
Is there a way around this please?
Regards
Davystuff