• 25 Posts
  • 435 Comments
Joined 1 year ago
cake
Cake day: June 2nd, 2024

help-circle








  • On a more serious note: If anyone can just claim anything in a conversation, that would be detrimental to any discussion. Either everybody makes up their own “facts” because no-one bothers proving everyone else’s version of a story (which is just everybody lying in everybody’s face); or everybody is constantly fact-checking everyone else, which makes the conversation take much longer than necessary.

    You already have the source, or at least an idea in which context you got the information and how to find it again. It’s just common courtesy to share it the others rather than making them do the work, too.

    Also: https://en.wikipedia.org/wiki/Burden_of_proof_(philosophy)






  • The reason for this is simply because you include the base note when you start counting, so if you stop midway and stack another interval on top, you have to account for that stop because it decreases the total travel distance by one.

    I’m arguing that ‘counting the base note’ is necessary because there is no zero. If you travel 1 unit of your favorite unit of length, stop, and move one unit more, you have moved 2 units, not 3 as it is in music. Stops don’t add to or reduce travel distance.



  • Why do you assume I’m doing this inside Excel? I was importing a data sheet into other software. By the time I got my hands on the data, it was an object of the sort {A: [/*data*/], AA: [/*data*/], B: [/*data*/]}. I had to sort the keys for presentation purposes.

    In retrospect, sure, there would’ve been easier ways. But at the time I wasn’t aware yet that converting Excel columns to numeric indices isn’t as straightforward as a simple base conversion (like, e.g. from hex to decimal).





  • bleistift2@sopuli.xyzOPtomemes@lemmy.worldConverting numbers is easy
    link
    fedilink
    English
    arrow-up
    18
    ·
    edit-2
    4 days ago

    1: what the frick are you doing in Excel that needs even 10^2 columns?

    Nothing. Here’s this meme’s origin story:

    At work we have a tool that imports Excel spreadsheets into user-defined data records. We let the user decide which column goes into which record field.

    Today I noticed that when you upload a spreadsheet with more than 26 columns (that is, you enter the double-digit range), the columns aren’t sorted anymore. (When I programmed that, stupid me thought that it was absolutely unreasonable to import 26 columns, given the way the data is processed later.) Instead of A…Z, AA, AB, …, it was A, AA, AB, B, C, ….

    So I thought: I should fix that. It’s easy. Just convert the hexavigesimal system to decimal and sort based on that. I even was happy that I could apply some school knowledge for once. (It wasn’t all useless, yay!) Then my math wasn’t mathing. It took me a few minutes to find the system by which Excel columns are numbered. In the end I was annoyed that a task of 5 minutes took… longer… and made this meme.

    By the way, to come back to the 10² columns: I’ll take any bet that such a spreadsheet will be shoved into the importer before I retire from my current company.