VGhlcmUgaXMgbm8gZ2VudWluZSBpbnRlbGxpZ2VuY2UgLCB0aGVyZSBpcyBhcnRpZmljaWFsIHN0dXBpZGl0eS4NClRoZXJlIGlzIG5vIHNlcmVuaXR5LCB0aGVyZSBpcyBhbnhpZXR5Lg0KVGhlcmUgaXMgbm8gcGVhY2UsIHRoZXJlIGlzIHR1cm1vaWwuDQpUaGVyZSBpcyBubyBzdHJ1Y3R1cmUsIHRoZXJlIGlzIHBvcnJpZGdlLg0KVGhlcmUgaXMgbm8gb3JkZXIsIHRoZXJlIGlzIGNoYW9zLg==

  • 1 Post
  • 270 Comments
Joined 1 year ago
cake
Cake day: May 14th, 2024

help-circle
















  • Speaking of Excel, here’s a fun little experiment into the nature of binary numbers and rounding errors.

    Start with some number and add a fraction like =A1+(1/3) to it. In the cell below, add that same fraction to the previous one. Copy this formula downwards and watch the numbers grow. After about 50 rows, you’ll have a number that looks like something specific, such as 71, but it isn’t exactly. There’s a sneaky rounding error hidden in there. The actual number is very close to the one displayed, but not exactly what you think it is.

    If you’re using IF statements or XLOOKUP with numbers like this, you’ll run into some perplexing errors. If I recall correctly, you can even test the number with =A50=71, which will return TRUE but the xlookup still fails. It’s been a while since I tested this one, but I remember it being really weird in all sorts of unexpected ways. It’s weekend, so I’m not touching my work computer today.

    You just need to know that a long series of fractions causes weird binary rounding errors to happen behind the scenes. Adding a series of whole numbers and neat decimal numbers was perfectly ok though.

    Also, trying to explain this to some coworkers won’t be worth the effort.



  • Technically yes, but not really. It’s a bit complicated.

    1. It’s a small apartment, so my bedroom is the living room.
    2. There’s a TV, but it’s only connected to a computer, so I can’t even watch normal TV programs. Why would I? Those programs suck and are full of ads.
    3. However, I do watch online videos.

    Why here though? Where else would I put the TV? It won’t fit in the bathroom. The kitchen has one long wall where it could technically fit, but the watch distance would be like 30 cm at most, and there’s nowhere to sit. Not exactly a premium popcorn experience.

    Why even have a TV? I got this one for free. A large display would have been fine as well.

    Why even have display of any kind? I kinda like watching YT and other videos on a large display. It’s also ad-free, so why not. Sort of like a smart TV, but without the downsides.

    I tried to stay away from dispalys and lights for a while, but I didn’t notice any difference in my sleep quality. I guess the difference is very subtle, so why bother. I don’t think it’s worth the hassle.