Well, this is the first computer program that I made! It was originally written in BASIC programming language (via QuickBASIC) and created as a supporting program for my BSc thesis. Later on, it was written with Excel-VBA.
This is an illustration of using Excel for civil engineering application. The layout may vary for the same problem.
Notes:
- Pile constants are referred to those stated in Bowles' "Foundation Analysis and Design", which derived by relating pile head forces and displacements in the following matrix.
- For creating piling layout of a large number of piles, there is no better method than using a macro to automate chart. The basics of VBA coding for inserting and modifying Excel charts are described in the book "An Introduction to Excel for Civil Engineers".
