Since you’re a mix of CS type and science type, you might enjoy my detailed analysis of the Excel 2007 bug.
I posted a detailed analysis based on disassembling Excel at http://www.lomont.org/Math/Papers/2007/Excel2007/Excel2007Bug.pdf
I show why precisely the 12 values format incorrectly, what changed from earlier versions, and how the hotfix corrects the bug.
Since you’re a mix of CS type and science type, you might enjoy my detailed analysis of the Excel 2007 bug.
I posted a detailed analysis based on disassembling Excel at
http://www.lomont.org/Math/Papers/2007/Excel2007/Excel2007Bug.pdf
I show why precisely the 12 values format incorrectly, what changed from earlier versions, and how the hotfix corrects the bug.