SPT Log Spreadsheet

[bdbd]

Hey,

I am looking for a efficient borehole log spreadsheet with SPTs (that show values with a graph along the depth), UDs etc.

Do you have one?

Regards.

 

[oldestguy]

Why?

My experience with logs that go with reports (thousands of them) is that no one looks at the logs in the report for the most part. Pretty logs, fancy report binders and the like make no difference as to how it is used. I even found most structural engineers designing foundations only look for a few items and then get on with their work.

 

[bdbd]

This is interesting opinion. But I totally disagree. I have my signature in my report.I do not prepare that for structural engineers to take spring comstant and bearing capacity. Besides, I dont know US procedure, but in my country, there are State controllers, Consultants etc.

But what I was looking for nothing fancy, but fast way to prepare logs for our geological engineers.

 

[oldestguy]

This is an interesting discussion. Reminds me of a call I received from the city engineer of a community near here. He had my report for his lift station, but needed the bearing capacity. I then referred him to the page number and lines in the report. What this report had was very detailed description of the site conditions, including detail as to how the investigation took place. Also, some standard boiler-plate paragraphs describing all the legal aspects and maybe some "weasel" clauses, resulting in many pages in addition to the boring logs and yes my signature as a PE. I had so much extra verbiage there that he couldn't find the sentence he wanted.

It then stuck home to me that I really hadn't done the job he wanted, if he couldn't find his info without having to call me for it.

One way we then changed our approach to our work was to hire an expert in promoting the company. He interviewed many of our regular clients and even some that were not regular. Their guidance for streamlining reports has helped a lot. However, some engineers continued to insist on a lot of verbiage for some reason.

Later I decided to sell my interest in the company and do some consulting on my own. After the n on-compete clause had expired I contacted some of the old clients. I was amazed to hear that the thick reports were not wanted (they figured it raised the cost I suppose). Also, some non-regular clients gladly made the switch to me, complaining about certain engineers at the former company and their "service".

Checking with clients certainly opened our eyes as to what they want.

In direct answer to your request, spreadsheet logs are fine, but why the graph? Do your own as a standard that you bring up and just fill in the new data for each boring.

 

[Warwick Wood]

For SPT's with depth based graphing you can look at ESlog

http://www.esdat.net/ESlog_borelog_presentation_software.aspx

It is not in Excel, it is web based but you can download and upload your logs as needed. It is also free.

Warwick