Lists can be easily sorted using comparer functions, but sorting table column(s) with comparer functions is much more difficult. This post introduces a function that allows you to do this. One major reason to use this function is for sorting according to the rules of a specific language or locality.

This is about how to the reference a table and its columns in VBA (where it is known as a ListObject) in a multitude of scenarios. The aim is to make your VBA code robust for the situations where a table name, column name or column position is liable to change.

The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be, estimating the trough width parameter (K). A link to the spreadsheet can be found at the top of the blog post.