I had the same thought -- it seems like many of these ideas overlap heavily with R1C1 mode, which is already how Excel internally manages formula copy-paste.

Joel Spolsky explaining how it works: https://youtu.be/0nbkaYsR94c?t=567