When I was a little late with the upgrade

A finance guy that worked with me would ship around these spreadsheets that would take forever to load and constantly hammer the CPU.

I was asked (I'm a dev) to see if I could help figure if things could run faster. What I found were hidden tabs where he was computing and storing things like DayOfMonth, and WeekOfYear, along with other things that can be easily computed and also storing data in tabs.

We moved as much as we could to use the database server and switched to populating the report using views and and moved a lot of what he was storing into SQL expressions. He then went off using this as a template. The report went from taking minutes to seconds to run and ran smoothly moving around within.

He was there for 3 years and was ultimately he was let go. I heard through the grapevine, it was for creating overly complex reports that were too slow. Many of the people who were consumers of these reports were higher up within the company and were complaining to his VP.

/r/pcmasterrace Thread Parent Link - i.redd.it