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.
Extra documentation for the native sort functions and comparers. It also gives some background information to a custom function I will introduce in the next post.
Column types in Power Query easily disappear i.e. change from type number to type any. Here are some code snippets and functions so that your column types stay intact.
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.