VGhlcmUgaXMgbm8gZ2VudWluZSBpbnRlbGxpZ2VuY2UgLCB0aGVyZSBpcyBhcnRpZmljaWFsIHN0dXBpZGl0eS4NClRoZXJlIGlzIG5vIHNlcmVuaXR5LCB0aGVyZSBpcyBhbnhpZXR5Lg0KVGhlcmUgaXMgbm8gcGVhY2UsIHRoZXJlIGlzIHR1cm1vaWwuDQpUaGVyZSBpcyBubyBzdHJ1Y3R1cmUsIHRoZXJlIGlzIHBvcnJpZGdlLg0KVGhlcmUgaXMgbm8gb3JkZXIsIHRoZXJlIGlzIGNoYW9zLg==

  • 1 Post
  • 117 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.






  • Well what if you need to keep on producing more common metals in the meantime, and REEs are a byproduct. You would need to keep the REE factories running too.

    If you end up with 100 tons of terbium and yttrium oxide sitting in bags out in the rain, it’s going to lead to some serious quality issues further down the line. Well, just shove them in a warehouse then?

    You’ll need a big warehouse, and you need to keep building more of them every year as the stockpiles grow. Needless to say, there are some serious logistical problems with a total export ban. A partial restriction is more viable, because it gives China some time to figure out how to adapt.

    In any case, the rest of the world needs these metals, and they are willing to bend to knee long before China runs out of mitigation strategies. It’s going to be a problem in China as well, but at least they’re not totally screwed.



  • Previously it was thought that non-coding sequences were junk, and enormous numbers like 99% were thrown around at the time. Later, we found out that more and more of the non-coding regions actually do various other things, and the scope of junk DNA got narrower as years went by. Nowadays, you don’t really hear that term much, because future scientists have a tendency of discovering new functions for sequences that were previously thought of as non-functional. There’s also debate as to where do we draw the line.

    As usual, biochemistry is a fast moving target, and people have gotten cautious about these things. As more and more is discovered, older notions are updated or even thrown away.





  • chaosCruiser@futurology.todaytoAsk Lemmy@lemmy.worldWhat's your superpower?
    link
    fedilink
    English
    arrow-up
    14
    arrow-down
    1
    ·
    edit-2
    17 days ago

    Well, not really superpowers since they are common in humans. However, they are pretty interesting abilities nonetheless.

    • Advanced speech recognition. I can filter out speech of one person while ignoring other background noise and even other speech.

    • Advanced face recognition. I can see faces in clouds, floors, and other inanimate objects. Also helps when looking at real faces of people in a crowd. See also: pareidolia

    • Auditory hallucinations during hypnagogia. Look it up. It’s weird and trippy.

    • Desensitization and habituation to capsaicin. I can eat spicy foods.