By setting up several worksheets of three basic categories in a excel workbook, such as the characteristic parameter table of equipment and materials, the calculation table of single facility selection of sinking shaft, and the list of selection calculation (book), the calculation formulas between worksheets and worksheets were set up. The orderly link of the data between the whole workbook was got, the input of the basic parameters of the shaft was given. After the quick completion of the type selection calculation of the shaft sinking and hoisting suspension system the calculation of the suspension system for shaft sinking was faster and more accurate than that of the manual calculator.