用excel完成gps坐标转换的简易方法（Simple method of converting GPS coordinate by Excel）.docVIP

用excel完成gps坐标转换的简易方法（Simple method of converting GPS coordinate by Excel） A simple method of using EXCEL to complete GPS coordinate conversion - Hebei economic net, 2011, 06, 30 As a cutting-edge technology, GPS can conveniently and quickly measure point coordinates. It has obvious advantages both in operation and precision, as compared with other routine measuring equipment such as total station. With our country GPS differential stations continue to establish and cancel the SA policy, the single positioning precision is greatly improved, some have reached submeter accuracy, can satisfy the application of land resources survey, land use change, remote monitoring, inventory of the right to use sea areas such as the work of the. In general, we are using the Beijing coordinate system 1954 or 1980 Xian coordinate system (hereinafter referred to as the 54 and 80 Series), and the coordinates of GPS measurement is WGS-84 coordinate system coordinates, coordinate conversion needs. For the measurement of non professional staff, although the GPS positioning operation is very easy, but it is difficult to grasp the coordinate transformation, EXCEL is more popular in electronic form software, able to handle more complex mathematical operation, which is used for GPS coordinate transformation, area calculation will be very relaxed freely. To coordinate system transformation, can not be separated from the Gauss projection conversion, the following are introduced using EXCEL conversion methods and GPS coordinate conversion method. First, using EXCEL for Gauss projection conversion From the latitude and longitude of the BL conversion to XY (Gauss Gauss plane coordinate projection is considered), or a BL from the XY conversion (Gauss Inverse Projection), generally require special computer software, in the conversion of popular software, there is a common shortcoming, flexibility is poor, mostly to a point a little, not quantity, the actual work to bring a lot of inconvenience. I have