Share via

(Pol formula)

Anonymous
2010-07-01T14:31:22+00:00

(Pol formula) which used for measuring bearing in leveling with help of quardinates

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-07-04T15:36:27+00:00

Are you looking for formulas for polar co-ordinate conversions for calculating bearings?

Assuming X in A1 and Y in B1:

Distance:  =SQRT(A1^2+B1^2)

Bearing (radians):  =ATAN(B1/A1)

Bearing (degrees):  =DEGREES(ATAN(B1/A1))

If you need to find X and Y from the distance (in A2) and radian bearing (in B2):

X:  =A2*COS(B2)

Y:  =A2*SIN(B2)

and if the bearing is in degrees:

X:  =A2*COS(RADIANS(B2))

Y:  =A2*COS(RADIANS(B2))

HTH

Steve D. Demonstration file available on request.

Was this answer helpful?

3 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-07-01T14:55:43+00:00

    What is your question?  Here is my best guess:

    http://onjava.com/pub/a/onjava/2003/04/16/poi_excel.html

    If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2010-07-01T14:32:37+00:00

    (Pol formula) which used for measuring bearing in leveling with help of quardinates

    *** Email address is removed for privacy ***

    Was this answer helpful?

    0 comments