Category Archives:

Computers&Tech

Little calculation imprecision of 53%

Update: Im Excel-Team-Blog wurde eine kleine Erklärung veröffentlicht (englisch), es beträfe “nur” die Anzeige, nicht das zwischengespeicherte Ergebnis. Dumm also “nur” für die, die auch mal Werte anzeigen lassen und nicht nur damit rechnen…

Update 2: Ein Hotfix ist mittlerweile verfügbar.

Microsoft Excel 2007, a spreadsheet calculation program for which the correctness of calculations is not quite unimportant, messes up some multiplications that should result in 65,535, e.g.

850 * 77.1 = 100,000

How it gets the idea to turn a result that has the lowest 16 bits (integer representation) all set to 1 into 100,000 (decimal) – and only with some pairs of numbers, not all – I have no idea. Maybe they wanted to hide another bug or flaw this way… anyway, that’s become a complete flop. They want to release a patch as soon as possible…

:hammer:

Maybe it was just a test to see if people are actually using Excel 2007 already and not stick with older versions (which probably many companies do)…?

(via Golem.de)

Update: The Excel Team Blog published a little explanation, according to which “only” the display is affected, not the stored result. So it’s “only” bad for those who have results displayed and don’t just calculate…

Update 2: A hotfix is now available.

Music Robot

Okay, it’s apparently available for about a year, but I just read about it in the new issue of the Bild der Wissenschaft¹, and it was new to me: miuro, the iPod dock and WLAN client that can dance and follow his master!

Official site: miuro.com (Japanese)

Without further investigation: I suppose the name results from “music robot”, or rather the re-transfer of its pronunciation from Japanese to Latin letters.

:rocks:

Oh, and I should mention a little disadvantage: the price of about 1000 € (e.g. at arktis.de)…

¹ Strangely, they spell it “Miouru” – did they get that from a French source?

Assembly is…

:kissm: What can be done with the Linux shell can also be done with x86 Assembly language – maybe a little less safe ;) but with direct access^^ (note that “BH” is German for “bra”):

        enter 0xCafe,0xC
        not [0xbadFace]
        monitor
        lahf
   lock leave
        sysenter
        push bh
        test ah,0xDD
        pop bh
   lock enter 0xBed,2
        into
        call si
    rep mov ah,0h
        aaa
        leave
        sysexit
times 9 mwait
        call 0xDad

Even when reading several times (hint!), even with the help that pops up when hovering over the dashed underlined items – probably no-one except me will understand that. But, well, I don’t care…. :mrgreen: