I’ve worked at some banks quite a few years ago and Excel was basically a cheap application space for them. The cells were inputs/outputs, they used VBA, and COM+ which talked to SQL to perform calculations and all that. It was really weird but every iteration that they wrote to replace Excel (they needed to because of banking auditing regulations) had failed simply due to the features they would get from it. It was wild to see at the time.
I’ve worked at some banks quite a few years ago and Excel was basically a cheap application space for them. The cells were inputs/outputs, they used VBA, and COM+ which talked to SQL to perform calculations and all that. It was really weird but every iteration that they wrote to replace Excel (they needed to because of banking auditing regulations) had failed simply due to the features they would get from it. It was wild to see at the time.
I did some pretty amazing things with Excel and VBA in the day.
I made a whole CRM in Google sheets once, with appscript and an animated dancing badger Easter egg