I encountered oil wells essentially controlled by post-it notes passed around an office.
I encountered oil wells essentially controlled by post-it notes passed around an office.
It doesn't really make sense as I think about it now, because the 747 design predates Excel by many years so maybe it was BS.
Because you can't define a named custom formula by composing the built-ins. So every cell is just the same copy-pasted formula string. When you need to change something, you have to change it everywhere and pray that you didn't miss one usage.
I can't count how many times I found a bug in a spreadsheet because someone (who might be me) missed one or two instances.
I prefer to do it with VBA code because I find it easier to manage, but it's also possible without VBA using just the built-ins in the spreadsheet directly.