Consolidation settlement due to embankment load and additional external load

This excel calculate consolidation settlement due to embankment load and additional external load e.g. railway construction on fill. Addional stresses  in each depth increment  due to both loads are calculated based on stress on elastic foundation theory. Consolidation settlement then estiamated based on coefficeint compressibility. The program calculates additional stress due to embankent and external load.  It also estimates the settlement at the middle of the embankment. Finally the program gives preliminarly design of vertical drain. Output  graphs can be seen on graph sheets.Change only yellow cells!'@MYUSA 2016