Hi Troy, thanks for doing that. I'm in the middle of pier design at the moment using mostly wild plucks for dimensions (well, actually based on what appear to be other people's successful examples).
Similar to Rally, I get #NAME? in the output fields ... that's using Excel 2010 in Windows.
I assume the section size given is for "plain" CHS welded to a base plate. How would this change for a pier that includes full-height, fully-welded fins?