How to calculate distance between coordinates

**madelingirly** · 10-01-2015, 04:44 AM

Dear guys,
If I have the x and Y coordinates for the centroids of a moving polygonal, and I want to find the distance travelled by this polygonal on a flat surface.
How I can calculate it using excel
please check the attached pic, this represents the path travelled by my polygonal, each point composed of the x and y coordinates for each centroid, numbers should be true, so I am looking for how to calculate the distance between each 2 points from these numbers on graph

please can you help me

Presentation1.jpg
Madelin

**zbor** · 10-01-2015, 04:51 AM

Do you want total distance or final distance?

For final distance use distance math formula

Formula:

Please Login or Register  to view this content.

Where B2 and B3 are X values
and C2 and C3 are Y values of first and last point

**zbor** · 10-01-2015, 04:53 AM

For total distance use distance of each set of points and then SUM them.

**newdoverman** · 10-01-2015, 11:12 AM

Just for the "fun of it", I guessed at the values in the picture and created a table out of approximately half of your graph. I used zbor's formula using my guessed values and then created a scatter plot.

The result, I think, is interesting as an exercise.