Generate internal grid points from 4 corner points

Hi,

I want to generate a list of coordinate points at xm internals from a known set of four corner points.

Example is I have a start coordinate being
1000 (East), 1000 (North) - {all measurements are in metres}

I want to create grid points at 10m intervals from that start point ending at the opposite corner of the polygon at 2000 (E), 2000 (N)

My spreadsheet should finish like this;

East	North
1000	1000
1000	1010
1000	1020
1000	1030
1000	1040
1000	1050
1000	1060
1000	1070

....and so on until North hits the upper limit of 2000, then East will increment by 10m and North begins again at 1000 incrementing by 10m. This continues until the result reaches 2000, 2000.

This is just an example and I want flexibility to be able to change the start and end points as well as the increment size in integers.

Any tips please?

Thankyou

i do not think this issue is for excel
it is just a math, smth about the Pythagorean theorem or geodesic lines

Hi
Try using this approach
where $D$2 as the increment, $E$2 is Start East, $F$2 is End East, $G$2 is Start North, $H$2 is End Norh
In A3 =$E$2 and in B3 =$G$2
In A4 use the following formula

Formula:

Please Login or Register  to view this content.

and in B4 use

Formula:

Please Login or Register  to view this content.

Copy a4 and B4 down.

See the file

Perfect. Exactly what I'm after. Thank you.

You are welcome and thanks for the feedback.

Don't forget to mark this thread as SOLVED.

sorry but your solution is not correct,

Worked for me.

your calculated coordinates is not Cartesian, you only calculate a points, with fixing North axes which is not correct.

but is not correct, if you work in Cartesian coordinates, his calculation is worng

the both east and north coordinates must be change

but if your moving only on east with same north coordinate is will be correct!

Hi


See if the fix I propose solves your problem, whether the problem is a WGS 84 based coordinate system, and then @ tim201110 (post #2) is right.

See the file