Replace confusing cell references with global constants, local variables, and reusable custom functions.

In Excel, unnamed things work, though nobody knows why. But as soon as you give all elements of a workbook identifiable labels, you suddenly become a developer, not a mere user. Proper naming reduces ...