News for hackers. Stuff that matters.
Re:Technical error with Excel.swapped names.Andreas Babler e... by jimnotgym on Tuesday June 06, 2023 @03:28AM (#36209403)
Well it depends on your data. I'm an accountant and it is very normal for accountants spreadsheets to be full of 'check digits'. Checks and balances are well ingrained into accounts!

In its basic form you perform the same calculation on the totals as you did on the roots and subtract it from the result. The answer must be zero. I know it is harder on some kinds of data, but it can prevent a huge amount of every day errors.

Re:Technical error with Excel.swapped names.Andreas Babler e... by samrus on Tuesday June 06, 2023 @04:43AM (#36209937)
Makes perfect sense. The testing being discussed is to create platform where generic tests can be coded and rerun. So tests that aren't specific to totals and subtotals