×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Question - Spread Footing Design Chart

Excel Question - Spread Footing Design Chart

Excel Question - Spread Footing Design Chart

(OP)
I am working through my first spread footing design and have prepared a spread footing design chart, which plots the strength limit state curve and various settlement curves on a graph (factored net bearing resistance against footing width). The beauty of this graph is that to the left of the strength limit state controls left of the strength limit state line and the service limit state controls to the right of it. I have seen these charts in various textbooks and they only show the settlement curves in the region where the service limit state controls.

I'd like to add this graph to my geotechnical report. I cannot figure out how to only show the settlement curves to the right of the strength limit state line. Is there a way to tell excel to only plot a series to the right of an intersection with another line?

RE: Excel Question - Spread Footing Design Chart

Change the range of the 'source data' such that it will show only the portion you would like to present.

RE: Excel Question - Spread Footing Design Chart

(OP)
Thanks for the input Jalthi. This is a straightforwad, but effective method.

I should clarify that I was hoping for a "cleaner" solution...if anyone knows of one.

RE: Excel Question - Spread Footing Design Chart

It is a decade I made things in excel but maybe you may rework your dataset wanted plotted to only contain the values to the right side of the limit line; a comparison with the corresponding limit value would exterminate the nonwanted values from the data set, then plot. May work or not...

RE: Excel Question - Spread Footing Design Chart

Can you advise of the soil strata encountered? Borehole log?  Just interested.  Compared to Bowles - you should have a SPT value in the order of a bit less than 40.

RE: Excel Question - Spread Footing Design Chart

(OP)
The soil layering is:
Embankment Fill  SM - 74
Tephra           SM - 24
Fine Alluvium    SM - 40
Flow Breccia     GM - 53

Pretty consistant with your prediction.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources