We all know that computers can “crash”.
But can anyone provide a really good explanation of why memory corruption occurs? And are computer calculations infallible?
Allow me to share with you a little story. When I was studying thermodynamics at university, a very strange thing happened: a relatively old computer essentially made a mistake!
What happened was this. We were in the laboratory, measuring a quantity for an experiment and then tabulating the results in an excel spreadsheet with the aid of an old computer.
But one of those cells refused to play nicely. It didn’t produce the appropriate result. It was way off. Not just a little off. It was way, way off. It was so far off we couldn’t help but notice it.
The excel spreadsheet has failed. Either the software or the hardware had failed. Something had clearly failed. How can the same mathematical algorithm generate one inconsisent result among many rows of similar cells?
We investigated further. We looked at the individual cells but the equations in each one were all identical. We looked at the references to the other cells and they were all correct.
I remember looking at conditional formatting, number format and a load of other things. Nothing. Everything should have worked. And none of us were excel juniors. We were advanced users! [Read more…]