Jumpi’s Notepad

The Excel 2007 Bug

Posted in Math, Programming, english by jumpi on October 3rd, 2007

About the bug that affected Excel 2007, I think that is very hard to work with floating point calculations and approximation is very complex and find a problem in logic of this is a true nightmare!!!!

The summary of problem: Excel 2007 store six floating point numbers using binary representation between 65534.99999999995 and 65535, and dont store six between 65535.99999999995 and 65536 and this numbers are the cause of this problem.

I work with arbitrary precision in my scientific intiation and using libraries for care of this part for me, because of difficulties that involve the manipulation of calculate numbers that need arbitrary precision. IMHO, working with type of development demands very attention and very pacience.

The two links have a good explanation of this problem… Its a good lecture!!!

The Excel Bug Explanation by Good Math, Bad Math Blog
The Excel Bug Explanation for Mathematica Developers Blog

See ya people and have a good fun!!!

In play: Emerson, Lake and Palmer - Works (Black) Vol. 1 - 07: The Enemy God

Tagged with: , ,

4 Responses to 'The Excel 2007 Bug'

Subscribe to comments with RSS or TrackBack to 'The Excel 2007 Bug'.

  1. Anonymous said, on December 9th, 2007 at 4:51 pm

    finalfantasy henta

    Tangent Torrancd Neriah Davis list?! Proper editor as; form girl, overwhelming.

  2. Anonymous said, on January 1st, 2008 at 3:47 am

    Bjkini

    Bjkini

  3. Anonymous said, on January 1st, 2008 at 3:48 am

    Ficking Kissing

    Ficking Kissing

  4. Anonymous said, on April 4th, 2008 at 12:19 am

    blak big boobs

    blak big boobs

Leave a Reply