Mohr-Coulomb Envelope and Friction Angle
Mohr-Coulomb Envelope and Friction Angle
(OP)
Hi All,
I have a series of data (residual direct shear results - normal stress vs. shear stress), and have plotted the data in Excel. I'm trying to find a way to automate the process of determining the friction angle based on the data, bouning it by the 95 percentile lower bound. I can do it manually, but this requires updating it whenever I update the data set. Does anyone have a spreadsheet that does this automatically, or have an idea of how to do this?
Thanks...
I have a series of data (residual direct shear results - normal stress vs. shear stress), and have plotted the data in Excel. I'm trying to find a way to automate the process of determining the friction angle based on the data, bouning it by the 95 percentile lower bound. I can do it manually, but this requires updating it whenever I update the data set. Does anyone have a spreadsheet that does this automatically, or have an idea of how to do this?
Thanks...





RE: Mohr-Coulomb Envelope and Friction Angle
Just the opinion of a pre-computer professional, slowly getting up to the modern times, that is. . .
f-d
¡papá gordo ain't no madre flaca!
RE: Mohr-Coulomb Envelope and Friction Angle
The pencil approach is fine (and what I am currently doing), however, I have alot of data, and I would like to automate the process, then review it. Don't get me wrong - I understand the importance of the 'pencil approach'.
RE: Mohr-Coulomb Envelope and Friction Angle
RE: Mohr-Coulomb Envelope and Friction Angle
Hope these words make sense. . .
f-d
¡papá gordo ain't no madre flaca!
RE: Mohr-Coulomb Envelope and Friction Angle
do you mean to build a 95° confidence level to the linear regression (as the Eurocode literature suggests)?