Lateral Earth Pressure Spreadsheet
Lateral Earth Pressure Spreadsheet
(OP)
I was just curious if anyone out there has one or knows where to download a spreadsheet that computes lateral stresses from earth pressure and surcharge loadings?
Thanks
Tre
Thanks
Tre





RE: Lateral Earth Pressure Spreadsheet
"Substructure Analysis & Design" 2nd edition by Paul Andersen has a worked out example of strip load plus the equations. You need to be careful with radians. Azizi & Budhu have the other line load and point load equations. For seismic equations, you need to look for the Seed & Whitman paper of 1971.
RE: Lateral Earth Pressure Spreadsheet
I think it would be much better for you to write your own spreadsheet for this per FixedEarth's recommendation.
Doing this really helps one to better know the process and methods, limitations, etc. I've written one some time ago based upon some load charts. I'm never very comfortable using someone else's downloaded spreadsheet.
Almost as much work (if not more) to verify it - working through someone's spreadsheet logic can be a form of self-abuse.
RE: Lateral Earth Pressure Spreadsheet
EIT
RE: Lateral Earth Pressure Spreadsheet
RE: Lateral Earth Pressure Spreadsheet
I was referring to using only the unmodified boussinesq equation for a point load and applying to line strip and area loads.
Question - in your attached sheet for strip do you know what the modifications are to it. I always thought it was just an integrated form of the boussinesq for a point load, but I'm not sure if that is right.
EIT
RE: Lateral Earth Pressure Spreadsheet
Equations are different for all 3 cases - point, line and strip. However, you can get close values between strip and line load. For example, a strip load of 4 ksf and strip width of 4 ft, would yield similar results as line load of 1 kip/ft for the same setback distance.
RE: Lateral Earth Pressure Spreadsheet
RE: Lateral Earth Pressure Spreadsheet
Carry on. . .
f-d
¡papá gordo ain't no madre flaca!
RE: Lateral Earth Pressure Spreadsheet
Dik
RE: Lateral Earth Pressure Spreadsheet
You would design the wall for either at-rest or active earth pressures. The calculated line loads are in addition to either of these states of stress.
f-d
¡papá gordo ain't no madre flaca!
RE: Lateral Earth Pressure Spreadsheet
Dik
RE: Lateral Earth Pressure Spreadsheet
RE: Lateral Earth Pressure Spreadsheet
First thanks Yakpol for posting as I was able to validate my bousinessq spreadsheet. Mine is much more messy as I need to take the time to learn macros/VBA. So great job. Our results match for area loads. However I tried to expand the calculation so that you can do strip, point and line. It also sums the pressures and returns a force resultant and location. The problem is that for a strip load the length (not the width) should be 1ft right (as you are working on a per foot basis)? The problem with this is that it yields very low values even doubling them does not come close to that of the modified equations.
Let me know if you have any questions/comments. I will also upload the bowels chapter which is what I used to derive the first sheet.
EIT