Game grid map, distance between two points

**potatoebob** · 01-03-2014, 01:55 AM

I play games that have grid maps and I would like to know how to enter these points on an excel spreed sheet and find the distince between the two points.

Screenshot_301.png

I'm not sure if you can see this example of what i want to do. So if you have a grid box map with 500 boxes across and down and you want to know the distance between to two points how do I enter them on the spread sheet. If the top row is called "Y" and down is called "X" and my base was at y125, x325 and the base I want to go to is y325, x425. What is the distance between the two point and how do I enter the points?

Thanks,

Potatoebob

**rishikrsaw** · 01-03-2014, 03:42 AM

kindly upload excel file....

**AndyLitch** · 01-03-2014, 04:39 AM

Bet you wish you'd paid attention to Pythagoras now

**MrShorty** · 01-03-2014, 10:05 AM

Agreed, AndyLitch. I find this sort of thing much easier to program into Excel (or other programming language) if I first understand the math. As noted, the distance formula is derived from the Pythagorean theorem and is fairly simple. Here's a quick refresher with the distance formula and its derivation http://www.purplemath.com/modules/distform.htm From there, putting it in Excel should be straightforward.