I recommend having an experienced Geotechnical engineer come out to look at the situation. This may not be as bad as you might think, but a geotechnical proffessional will be able to help you with the extent and nature of this problem. Good luck.
Ryan R. Smith
Geotechnical Engineer
FixedEarth,
I totally agree, noone should ever use spreadsheets without a thorough review. We as professionals should take every precaution when dealing with information provided by others or the web. Good comments.
Ryan R. Smith
Geotechnical Engineer
Hello tre5205...
I have used a P-Y excel spreadsheet from the following source:
https://newtonexcelbach.wordpress.com/2010/07/17/lateral-pile-analyis-with-py-curves/
You can download the zipped file and extract to open.
VTengineer
Geotechnical
Ryan R. Smith
Geotechnical Engineer