Jumpi’s Notepad

My annotations about the life, universe and everything!!! ;)

The Excel 2007 Bug

with 4 comments

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

Written by jumpi

October 3, 2007 at 8:54 pm

Posted in english, Math, Programming

Tagged with , ,

4 Responses

Subscribe to comments with RSS.

  1. finalfantasy henta

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

    Anonymous

    December 9, 2007 at 4:51 pm

  2. Bjkini

    Bjkini

    Anonymous

    January 1, 2008 at 3:47 am

  3. Ficking Kissing

    Ficking Kissing

    Anonymous

    January 1, 2008 at 3:48 am

  4. blak big boobs

    blak big boobs

    Anonymous

    April 4, 2008 at 12:19 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: