Hello all!

I am currently picking up on the research of another colleague and am trying to map out, from excel data, what is meant to be a grid (of equal sized rectangles) on ArcMap 10.4. I've attached the data-set here but am at odds on which projection system to choose. Clearly, the overlapping points represent the UTM boundaries of Ontario, but my different attempts at using the UTM zones in each doesn't seem to display correctly.

The second part of my question would be on how to construct the actual grid in ArcMap. Given that the points displayed represent the center of each grid cell, would tessellate be the most appropriate tool in this place? The actual dimensions of the cells are unknown and therefore have to be deduced geo-spatially.

Thanks in advance to everyone who comes upon this post.

When converting the Excel to points, you could choose the Coordinate System as

GCS_WGS_1984. Although I should have reprojected the shapefile before going ahead with the workflow, but I didn't. The coordinate system for all the data and the data-frame is GCS_WGS_1984.Now coming to the creation of "Grid-like" polygons, a portion of which looks like this

Steps followed

1. Creation of Thiessen Polygons using the point layer.

Create Thiessen Polygons2. Now we needed to cut the polygons appropriately. First I used

Aggregate Pointswith the points as input to create envelope polygon(s). AGGREGATION_DISTANCE =0.5 Decimal Degrees3. We used

Bufferof0.1 Dec. Degreeson the polygon(s) resulted from Step 2 so that all the points reside inside the polygons (instead of the edges).4.

Clipthe Thiessen Polygon Boundary with the Buffer Boundary.5. To check if there are any polygons which don't intersect with Points, you can Select By Location with appropriate parameters. (I did not find any.)

The resulting Grid-ish Polygon shapefile is attached for your reference.

Hope it helps!!!