• 5 Posts
  • 230 Comments
Joined 2 years ago
cake
Cake day: July 21st, 2024

help-circle




  • Resonosity@lemmy.dbzer0.comtoMemes@sopuli.xyzReal Struggle 😔
    link
    fedilink
    English
    arrow-up
    6
    ·
    edit-2
    10 days ago

    As soon as you convert from an .XLS file to a .CSV file, the data and sig figs used to display that data are saved while the math formulas used to calculate that data are erased.

    This means that when you try to go from .CSV to .XLS, Excel doesn’t know the original formula that created the data to then be able to display more decimal points. The formula is absolutely necessary to change sig figs of displayed data.

    The only other way I can think of that would allow one to change sig figs in .CSV data is if the .XLS file was converted with like the maximum number of sig figs displayed, or let’s say 10-20. Then in a .CSV, you can modify the sig figs to something less, like 0-20.

    But I want to say that if you save that .CSV file after the sig fig change, where you original converted it with 10-20 sig figs but then changed them to 0-20, the .CSV overwrites the data and you lose the sig figs that you concatenated.

    Result: adding decimal points in a .CSV isn’t possible.








  • The use of the word “explode” is misleading. It’s definitely misinformation.

    Here’s an arborist talking about it, but basically:

    Trees move sap and other liquids up and down their trunk from the soil underneath regularly. For trees like maples, this is where maple syrup comes from, except you have to collect a lot of sap and reduce it down to syrup.

    The arborist claims that these liquids present in the tree when the temperature swings faster than the tree can respond expand due to freezing, which buckles tree trunks causing the outer bark to crack open and separate. The cracks can be from the ground up, or they can look like gashes in the side of the tree. There’s moisture in the soil too, which can shift tree roots and cause similar cracking.

    People say “explode” because there’s usually a popping sound when this happens.

    In other contexts, people call this frost upheave. Engineers know about this phenomenon, and try to bury equipment like pipes and cable and conduit below the frost line so frost upheave doesn’t crack and break that stuff. With trees, this frost upheave just takes place inside the trees themselves.