Implementation of Excel program for automatic processing of one well orientation data based on VBA
In the process of urban rail transit construction,the method of one-well directional contact triangle measurement is generally used to the coordinate system of ground and underground in order to ensure the accurate connection of different excavation faces.An Excel program for automatically process-ing the data of one well based on VBA is proposed in this paper to solve the complex calculation steps of the directional contact triangle of one well,and the calculation principles,graphic form of the contact triangle,program design are described in details.The example shows that the program can be used to reduce the calculation errors caused by manual works,improve the efficiency,and provide an idea and technical support for the calculation of one well directional contact triangle.
contact measurementone well orientationcontact triangle methodVBA
NETL
NSTL
万方数据
维普
