Soil Retention Curve Spreadsheet

• Aug 16, 2017

• #2

BigH

Geotechnical

Dec 1, 2002

6,012

TJ

You are not likely to find anyone who will help insofar as you have not indicated any attempt on your part to research and try to develop your own spreadsheet. If you had done so and had a problem, then you could ask for specific comments . . . but unless you show that you have tried, I doubt others pass on their hard work.

 

Upvote 0 Downvote

• Aug 16, 2017

• Thread starter
• #3

geohec

Geotechnical

Apr 12, 2007

19

US

Hello there:

I did my homework sir. I've been studying the Lu and Likos book (Unsat soils) for the past 6 months, please see attached. The problem I have in the spreadsheet with the solver is fixing the square mean error to zero to generate the correct coefficients. Have you done this before...?
Thanks

 

 http://files.engineering.com/getfile.aspx?folder=06174588-430c-4b28-ab47-69fb895ec86e&file=EXAMPLE_12.1_BC_Fit_Lu_Likos_BOOK.xlsx

Upvote 0 Downvote

• Aug 16, 2017

• #4

BigH

Geotechnical

Dec 1, 2002

6,012

TJ

I've not and am not that well versed with excel . . . hopefully, now, someone may be able to help.

 

Upvote 0 Downvote

• Aug 17, 2017

• #5

oldestguy

Geotechnical

Jun 6, 2006

5,183

US

Hey BigH: I'll bet there won't be many takers. Us old guys managed to grind out the jobs without the computers. I'd suspect the problem is not with the spreadsheet, but with the input and the set up of calculations. That can be tricky.

 

Upvote 0 Downvote

• Aug 18, 2017

• #6

fattdad

Geotechnical

Sep 7, 2006

2,790

US

what's the end game?

In general, I'm not drawn to unsaturated soil mechanics, 'cause I design earthworks to be weatherproof.

I would like to know how this exercise in unsaturated soil mechanics is addressing a practical design problem.

f-d

ípapß gordo ainÆt no madre flaca!

 

Upvote 0 Downvote