Use Excel''s strong functions of data looking for, data calculation and data processing, carry out the estimation of vertical bearing capacity of single-pile comply with the common formula, large diameter pile formula, socket-pile formula, anti-pull up pile formula, later inject mortar formula etc. only need to set up its function, formula and simple macro order, enter the stratum data and the parameter of pile foundation calculation. Specially fit for the pile foundation scheme selection for the large and complicated project with different location, different device, different pile type, different pile diameter and different pile end bearing layer, largely enhance the work efficiency.