Abstract: Using the Excel computation ability and Excel VBA macro language increase automatic function in spreadsheet, in order to solve the problem of borehole wave velocity test results analysis, and make the achievement information quick and easy, verified in engineering practice.We introduced the characteristics and attentions of the developing series through many aspect, the working table of software engineering design,data flow design,module design,the operation command design, system running environment results of graphic design principles and skills and so on.