Following the the
Brinch Hansen's Method, I share similar spreadsheet using Brom's method. Major disadvantage of this method is, it can not handle c-phi soil.
This spreadsheet is set to calculate lateral pile capacity using Brom's method for short piles. The procedure for calculation is straight forward and is explained in detailed manner in
"Pile foundations in engineering practice" book by Shamsher Prakash. Brom's method is also available for long pile and will share it in a later post.
This method is applicable to either purely cohesive soils or purely cohesionless soils and hence soil properties to be entered accordingly.
Download
broms_shortpile
[Update: The link was broken, it has been updated]