Look for the duct tape

Re:Look for the duct tape by beagle3 on Saturday March 24, 2018 @12:50PM (#16667509)

When they became effectively impossible to audit. That is, at their inception.

I've once worked with a trader whose magic sauce was encoded a spreadsheet he had been developing and carrying around for 10 years. It had tens of thousands of formulas and references cross ~50 sheets.

He suspected he had introduced an error somewhere, but gave up after a couple of months of trying to, you know, verify the whole thing.

[ Parent | on HN ]

Re:Look for the duct tape by antoineMoPa on Saturday March 24, 2018 @12:59PM (#16667541)

Yeah I'd say that If you have a hundred formulas and more than 10 sheets, it is time to change to another tool. But when someone is this far, they'll have accumulated so much technical dept that they will probably have to hire a programmer because the typical SASS won't solve all of their needs.

[ Parent | on HN ]