Calculating how deep to drive timber pilings (Gulf Coast Area)

[TexastoTexas123]

I am an engineering intern assigned the task of creating a spreadsheet that calculates how deep to drive timber pilings for deep foundations and I was looking for some help on the best way to go about doing this. My goal is the spreadsheet spits out the depth after several variable inputs. The company is in the Galveston, TX area, and typically works with loose, medium dense, and dense silts and sands. We are a windstorm and structural engineering company, so these piling foundations must withstand hurriance and windstorm conditions typically found along the Gulf Coast region. I was working from the Meyerhof method for calculating piling depth using [URL unfurl="true"]http://www.geotechnicalinfo.com/bearing_capacity_technical_guidance.html#deepfoundations[/url]

But I want to make sure I am headed in the right direction. This is my first post of course, and I hope that this is appropriate relative to the forum rules. Thanks in advance for your input.

 

[jayrod12]

I think your equation for rounded piles is incorrect then. I believe the 0.5 should be included in the dia brackets meaning your equation should be I=pi*(d^4)/64