topic Re: Can an Excel spreadsheet with x,y,z mine grid be updated to another grid? in Mining Questions

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

GaryChedore — Wed, 29 Apr 2015 11:39:15 GMT

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

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

SepheFox — Wed, 29 Apr 2015 13:56:11 GMT

Hi Gary, while it's not "one click", you can certainly do this in ArcMap, by importing the xyz coordinates to features in the mine grid coordinate system, as described in the link, then reprojecting your data to the new projection, adding fields for your new xyz values, and then calculating these using the Calculate Geometry tool. You can then export the table back in to Excel if you wish.

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

NeilAyres — Wed, 29 Apr 2015 14:16:37 GMT

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

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

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

GaryChedore — Wed, 29 Apr 2015 16:26:18 GMT

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

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

NeilAyres — Thu, 30 Apr 2015 06:24:17 GMT

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.