News for hackers. Stuff that matters.
Re:Spreadsheets: Functional Programming for the Masses (2014... by dmaevsky on Tuesday November 10, 2020 @10:43AM (#25047179)
I hear you. It's probably the same situation everywhere apart the IT industry itself :) if that....

What kind of tools are you currently using to manage the nightmare?

Re:Spreadsheets: Functional Programming for the Masses (2014... by achr2 on Tuesday November 10, 2020 @10:56AM (#25047354)
Different approaches for different aspects. For discipline calculation sheets, there is not much other than having a basic file-level version control and validation engines for importing the data. For other areas, I have built pipelines that maintain diff-able JSON in a repo and handle converting to-from a spreadsheet for their 'UI'. We are also always using or building integrated solutions for data and calculation capturing. My personal push is to introduce discipline engineers to things like Jupyter notebook for "hand" calculations.