As far as the handle goes, we can always aspire, can't we?
Thanks for your reply. I understand that the process is tedious by hand, and I do use the programs you mentioned. I just enjoy programming, learn a lot from it, and wanted to make my own program to both learn the process and have...
The question of how much seismic force will be exerted on the wall still remains. Kramer, in his book "Geotechnical Earthquake Engineering" has a section on retaining walls and presents some equations that are commonly used for your situation.
If you don't have access to Kramer...
Thanks for the response. I agree with what you are saying, however, I am just trying to find out where this 1.5 times the area of the pier comes from. The senior engineers at my firm are kind of old school. They just say they learned from their mentors that this is the case. I have also read...
In numerous geotechnical reports that address the lateral capacity of relatively short (5-15 ft) drilled piers I have seen a statement indicating that lateral resistance can be calculated by assuming the passive earth pressure acts against the projected area of the pier times 1.5. Can anyone...
When the eccentricity is outside the middle 1/3, the following equation should be used:
qmax = (4/3)*(V/(B-2e))
where v is the total vertical force and B is the width of your footing.
The length of the area in compression is:
(3/2)(B-2e)
Reference is Army Corps of Engineers manual for...
I know this is a spread sheet forum, but I really think you need to use a data base to efficiently do what you want. Once the data is in a table, you can run a query and select all of the non-null values in any given record (row in excel lingo). Access is a pretty easy database to work with...
Are you talking about linear interpolation? Even if you are not, why not just come up with the equation of the line that describes your data points. You can then plug in any x or whatever and get your desired results at any point?
I sometimes plot the data on a chart, find the best trend...
I would like to allow a user to click on a blank chart to input a series of data points. For example, if the user is outlining the stratigraphy of site, instead of entering a bunch of x,y coordinates in cells, I would like to use VBA to read the clicked points and use those points to perform...
Does anyone have a copy of the FHWA publication called, "Advanced Course on Slope Stability?" The FHWA pub. number is SA-94-006 & SA-94-005. NTIS# is PB95-249553A & PB95-225819. If so, is it worth getting a copy?
I am interested in writing my own software for in house use. I want...
