Application of Excel VBA in compiling batch processing program for borehole deviation in coalfield

Correction computation of borehole deviation in coalfield is an important basic work for determination of stratigraphic boundaries and coal seam coordinates, plan drawing of exploration line section and reserves, affect directly the calculation of reserves. The traditional hole deviation correction has been made with the aid of Excel, manual input is time and efforts demanding and error-prone. Based on geological practice, the authors developed a batch processing program for borehole deviation by applying VBA embedded in Excel from the basic heoretical knowledges of calculation method for borehole deviation correction and applied it well in the coal exploration project of Qingshan coal mine in Jiangzhou, Duyun City, Guizhou Province.