The setup table of premade formulas is much what I was thinking as the next
logical step towards automation. I was thinking that a macro can perform a
COUNTA of one column in the source data that represents the key field. From
there have a Setup Worksheet be read with some premade formulas, and then
have a VBA script use a FOR-NEXT loop to calculate a row at a time using the
formulas, then increment 1 for the next row to change the references back to
the source data sheet that one row. Each row lays down until there is
nothing less to copy / calculate over.

I'll be chewing on this one for a while.