calculating moment on excel spreadshee

huangyhg

calculating moment on excel spreadsheet
i am trying develop an excel spreadsheet that calculates the maximum moment in a steel pile used for excavation shorings. i am only considering lateral earth pressures.
i would like to learn how to calculate moment on excel. does anybody have a spreadsheet that calculates moment from nonuniform loads? any direction will help.

this should be a triangular load of 0 psf at the top of the excavation to soil density x coeffiecent of active earth pressure at the bottom of the excavation.
try doing a search here using the "search posts (keyword" option to find related posts.
thanks for the tips.
if you know the loads and boundary conditions you should be able to find equations in books.  then just key in the equation.  if you can't calculate it by hand, a spreadsheet may not really help you.
search the engineering spreadsheet forum for a program by yakov polyakov.  it's an excellent program and i use it often.
dik