News for hackers. Stuff that matters.
Re:The worst of the two worlds: Excel meets Outlook by HuwFulcher on Saturday February 13, 2021 @10:08PM (#26129294)
The backbone of many statistical institutions such as the Office for National Statistics is Excel. I worked on porting a lot of complex Excel systems to Python that had been around for 5+ years.

There were teams of people whose job it was to produce one report over a timeframe and they had the process to a fine art.

The main problem came when members of said teams left. Macros locked behind passwords, magic numbers in formulas, the wheels could come off very fast.

If Excel had a more robust functionality for versioning and documentation it could be even more of a powerhouse than it already is.

There are no comments on this comment yet.