how can I perform trig. functions usings grads 400deg per circle

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 here:
http://www.cpearson.com/excel/latlong.htm

It may help!
Andy.

"davystuff" <davystuff@discussions.microsoft.com> wrote in message
news:8C380A27-3CEA-4DA0-9957-294715C151A9@microsoft.com...
>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" <davystuff@discussions.microsoft.com> wrote in message
news:8C380A27-3CEA-4DA0-9957-294715C151A9@microsoft.com...
>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