I'm trying to find the angle from coord. And which direction to the turns right or left.
Thank you in advance
I'm trying to find the angle from coord. And which direction to the turns right or left.
Thank you in advance
Last edited by sanju2323; 01-05-2016 at 12:20 AM.
How much of this is a trigonometry question, and how much of it is an Excel question? It seems like it should be relatively simple trigonometry at each point. If you understand the trig and can explain it to us, then we should be able to help you program that into Excel. If you need help with the trig, I will have to look at this closer.
It seems to me that the heart of the solution will be the ATAN2() function (https://support.office.com/en-us/art...8-c96b3a565033 ). Perhaps a "translation and rotation" step so that each point can be seen as the center of a "unit circle" with the previous segment along the x axis. In keeping with standard trig convention, left turns will be positive angles and right turns will be negative angles.
Is there a specific part of this that you need help with?
Originally Posted by shg
This looks more like you want somebody to help you with your schoolwork.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks