traverse spreadsheet

[Guest]

Trying to put togeter a spreadsheet to calculate an open/closed traverse, any ideas? especially about working with radians and converting them to a bearing

 

[Bernard Liengme]

Need more info - few of us are surveyors
Excel does trig in radians. If A1 has angle in degrees and you want sin use
=SIN(RADIANS(A1))
If A2 has value and you need its Asin in degrees use =DEGREES(ASIN(A2))

For more on displaying angles in deg:min:sec format visit www.cpearson.com

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

Trying to put togeter a spreadsheet to calculate an open/closed traverse,

any ideas? especially about working with radians and converting them to a
bearing

 

[Guest]

Thanks for the tip Bernard, What my problem is that Ive created a spreadsheet that will adjustbearing and distance entered using Bowditch correction but the problem im having is adjusting the bearing , don't know what im doing wrong?