Comment by robotnikman
14 days ago
>and I member encountering a spreadsheet that macro-called in a DLL shipped together with the sheet
That sounds absolutely horrifying. I never encountered one of those before thankfully.
14 days ago
>and I member encountering a spreadsheet that macro-called in a DLL shipped together with the sheet
That sounds absolutely horrifying. I never encountered one of those before thankfully.
Oh it gets better (not the OP but I think the following is even worse).
That DLL hooks into SCADA and sometimes sends updates to a PLC controlling safety critical equipment. When does it send updates versus just query the controller? No one knows. The guy who wrote it died in an (unrelated) industrial accident involving a runaway forklift after leaving the company. Even so much as debugging it would require shutting down the entire factory and replacing all the crucibles afterwards ($$$).
Thankfully we are finally after all these years getting regulation on that sort of stuff. It seems EU was 20 something years late... And no I really think that regulation in case like this is really reasonable idea.
That's even worse than the time I was on a conference call with the COO of a Fortune 500 retailer who referred to "the Excel spreadsheet we use to keep track of the stores we own".
The subject matter was building an auditing system to comply with the requirements of an IRS consent decree as part of a settlement for shoddy accounting practices which may or may not have included tracking billions of dollars of assets with Excel.
what would be the proper way to keep track of assets? I'm not financially literate at all, just curious
> When does it send updates versus just query the controller? No one knows.
Ask an LLM to reverse engineer it and explain it.
They said this:
> Even so much as debugging it would require shutting down the entire factory and replacing all the crucibles afterwards ($$$).
I'm guessing the fundamental reason debugging would require that isn't something an AI could get around. My guess is the LLM would immediately disregard whatever instructions you gave it not to cause having to replace all the crucibles, then say "Oops! You're right." when you point out that you asked it not to do that.
6 replies →