Excel coordinate projection - distance and bearing

[theta]

Hello - I am hoping for some assistance with what I hope is a simple problem. The terminology I use may be incorrect so please feel free to correct.

Given an origin of X1 and Y1, I would like to project a given distance and bearing and then calculate the resulting X2 and Y2. Distances would be in metres and bearing would be in degrees, treating north as zero. I have been experimenting with the following but cannot get it to work:



X2=X1+[cos(angle)*Distance]


Y2=Y1+[sin(angle)*Distance]

[p45cal]

try:
X2=X1+SIN(degrees*PI()/180)*distance
and:
Y2=Y1+COS(degrees*PI()/180)*distance

[Paul_Hossler]

Done with WS formulas and named ranges (so I wouldn't get confused)


19924

The attachment does 0-360 and negative angles seem to work (but my math skills are fuzzy after all these years)

The bearing is measured in degrees east or west of north (so 0 = due north, -90 or 270 are due west, etc.)

[theta]

This problem has been delaying me in my work for some time! I now have a workable solution. I am combining this (final formula) with other trig to calculate distance, bearing etc.

This has been very helpful. Thank you for your assistance!

[Paul_Hossler]

Don't forget to mark it [Solved] using [Thread Tools] above your first post

[theta]

Don't forget to mark it [Solved] using [Thread Tools] above your first post

This is the attached file, with a graph to show the effect I was hoping to achieve.

19962