几何尺寸与公差论坛------致力于产品几何量公差标准GD&T (GDT:ASME)|New GPS(ISO)研究/CAD设计/CAM加工/CMM测量

几何尺寸与公差论坛------致力于产品几何量公差标准GD&T (GDT:ASME)|New GPS(ISO)研究/CAD设计/CAM加工/CMM测量 (http://www.dimcax.com/hust/index.php)
-   产品功能分析 (http://www.dimcax.com/hust/forumdisplay.php?f=10)
-   -   calculating moment on excel spreadshee (http://www.dimcax.com/hust/showthread.php?t=22426)

huangyhg 2009-09-07 10:02 PM

calculating moment on excel spreadshee
 
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


所有的时间均为北京时间。 现在的时间是 12:21 PM.