Can an Excel spreadsheet with x,y,z mine grid be updated to another grid?

Question

My boss asked me to look into the possibility of using an excel spreadsheet with x,y,z in mine grid and updating the sheet from ArcView 10.0 , in NewBrunswick Double Strereo NAD83. Preferably with one click... need to know is it possible??

I looked at this discussion and thought I could perhaps use this approach, although I do not use GPS.Importing GPS Coordinates from Excel into ArcMap

gchedore@veng.ca  if you can help. Thanks

NeilAyres · Answer

That just looks like FromCoord ToCoord for 2 control points.

If we just look at the differences in X & Y for both points :

For X :

13460.909 - 12203.844 = 1257.07

2547042.49 - 2545777.15 = 1265.34

For Y :

24402.85 - 23260.347 = 1142.50

7609270.91 - 7608137.67 = 1133.24

So only 8 or 9m difference on either axis. So we might assume that there is no swing (angular difference),

between the 2 coordinate systems.

So if you are prepared to accept that slight error, you could just do this is your spreadsheet.

TargetX = (X - LocalOrigX) + ProjOrigX and similarly for Y.

You have 2 control points, so just make an average of the 2.

larogers_0-1767890075409.png

200x200_Michelle Mathias_Circular Image_With Buffer.png

GaryChedore · Answer

Thanks for the rapid reply Neil and Sephe:

currently to look at and load into GIS from CAD we are using a world projection file

with the following info:

13460.909,23260.347 2547042.49,7608137.67

12203.844,24402.850 2545777.15,7609270.91

as far as I understand the grid assumed was just that a grid, elevations +2436.5 m

when I load a CAD Drawing I export it from the layer to create a shapefile in the proper location in the world. This works but we do virtually all our work using excel. That is why the original question about updating the excel table... Any and all suggestions welcome

NeilAyres · Answer

But do you have the correct description / parameters for your mine grid projection?

If so, then this is very easy as Sephe said.