Comment by okennedy

Apple's Numbers has a relatively clever way to pull this off. If a cell (e.g., B:$2) is in a table with a column (or row) header, all formulas will use the header field value in the variable. e.g.,

  = floor( [Strength:$Value] / 2 - 5, 1)

These labels are purely descriptive. The underlying reference is still B:$2, but it makes formulas infinitely more readable without needing to manually define named ranges for everything.

(Among many other nice features Numbers has... one of the few things I miss since my switch to Linux)