If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
how can I perform trig. functions usings grads 400deg per circle
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 |
#3
|
|||
|
|||
how can I perform trig. functions usings grads 400deg per circle
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ability to perform trignometric functions in Access | Jack | General Discussion | 1 | February 20th, 2006 07:41 PM |
Trig and Excel Functions | Jim Mayo | Worksheet Functions | 2 | August 6th, 2004 04:30 AM |