search
Sign in
  • chevron_right Threads
  • label Discuss
  • label mundane

What's annoying me today

tricky
2 May 2023
chat_bubble_outline 2.0K
first_page chevron_left
chevron_right last_page
first_page chevron_left
chevron_right last_page
  • link
    tricky
    Board 7342 posts
    14 Feb 2024, 5:58 p.m. 14 Feb 2024, 5:58 p.m.
    link

    I don't hate spreadsheets. They are a very useful tool. I use one occasionally (but less so now I've moved my football admin to a database). I strongly dislike when they are used for things they are not well suited for, when they are very large, and when they are shared and used for collaborative tasks. Because in those scenarios they are not often the best tool for the job.

    Something like grist is a better collaborative solution (create the data model using grist-electron, then roll out to a self-hosted instance for collaboration). But people know how to use spreadsheets, so every screw is a nail to their hammer, and they often end up bloated, slow, hard to maintain share and version, and full of errors or the potential for them.

  • link
    Russ
    Squad 6427 posts
    14 Feb 2024, 6:12 p.m. 14 Feb 2024, 6:12 p.m.
    link

    Ah. I will grant you that spreadsheets are often used for purposes that would be better served by a different tool. See also Powerpoint and its analogs.

    I am guilty of both of these offences on a regular basis.

  • link
    JRs_Cigarette
    Squad 2193 posts
    14 Feb 2024, 8:20 p.m. 14 Feb 2024, 8:20 p.m.
    link

    Sometimes if you just want to add a couple of numbers together an old fashioned calculator will do the job. But increasingly that is beneath most people.

  • link
    JimShady
    Squad 3849 posts
    14 Feb 2024, 9:12 p.m. 14 Feb 2024, 9:12 p.m.
    link

    Who's got a calculator anymore?

  • link
    tricky
    Board 7342 posts
    14 Feb 2024, 10:08 p.m. 14 Feb 2024, 10:08 p.m.
    link

    Almost everyone, on their phone?

  • link
    JRs_Cigarette
    Squad 2193 posts
    14 Feb 2024, 11:12 p.m. 14 Feb 2024, 11:12 p.m.
    link

    One on my desk at home and at work.

    Lessred likes this.

    favorite 1

  • link
    Ingo
    Squad 2647 posts
    15 Feb 2024, 5:47 a.m. 15 Feb 2024, 5:47 a.m.
    link

    Me also.

    JRs_Cigarette likes this.

    favorite 1

  • link
    noodle
    Squad 999 posts
    15 Feb 2024, 6:16 a.m. 15 Feb 2024, 6:16 a.m.
    link
    @JRs_Cigarette has written:

    One on my desk at home and at work.

    Same. And proper big button fuckers too.. like every good fat-handed bean-masher.

    JRs_Cigarette and Lessred like this.

    favorite 2

  • link
    Ingo
    Squad 2647 posts
    15 Feb 2024, 6:19 a.m. 15 Feb 2024, 6:19 a.m.
    link

    Does my stance on this give me acceptance by the accountancy community?

  • link
    Lessred
    Squad 2063 posts
    15 Feb 2024, 6:21 a.m. 15 Feb 2024, 6:21 a.m.
    link
    @Ingo has written:

    Does my stance on this give me acceptance by the accountancy community?

    Let's not go mad.

  • link
    Ingo
    Squad 2647 posts
    15 Feb 2024, 6:29 a.m. 15 Feb 2024, 6:29 a.m.
    link
    @Lessred has written:

    Let's not go mad.

    Is that the Accountancy Christmas Party tag line?

    Russ, Dave_Rave, JRs_Cigarette and 2 other users like this.

    favorite 5

  • link
    Charlie
    Squad 1830 posts
    15 Feb 2024, 8:30 a.m. 15 Feb 2024, 8:30 a.m.
    link

    Visiting my accountant later. Will check for calculators and report back.

  • link
    Ingo
    Squad 2647 posts
    15 Feb 2024, 9:16 a.m. 15 Feb 2024, 9:16 a.m.
    link

    Our accountant is from Southwell and is basically Daddy Pig personified.

  • link
    Simon
    Squad 6599 posts
    15 Feb 2024, 9:24 a.m. 15 Feb 2024, 9:24 a.m.
    link
    @Russ has written:
    @Simon has written:
    @Russ has written:

    Why don't you just save and close the one you don't want it to appear in, do your paste, and then reopen it?

    Because that's just a list pasted out of another document and I don't really want to save it.

    That makes no sense. Save to desktop, do the thing you need to do, delete the no longer needed file. Seems way more efficient than trying to find ways to work around the paste issue.

    So here's a thing. I tried that and some experimentation has determined that whichever spreadsheet am I in, excel always puts the screengrap in the other one.

    This may, of course, be because I'm forced to use a macbook.

  • link
    Jake
    Squad 1819 posts
    15 Feb 2024, 9:38 a.m. 15 Feb 2024, 9:38 a.m.
    link

    The problem with databases is that they rely on spreadsheets to import and export data, and then if you want to do anything with the data extracted you're using spreadsheets then uploading a spreadsheet to the database again.

    Also, us teachers are crap with databases.

  • link
    tricky
    Board 7342 posts
    15 Feb 2024, 9:56 a.m. 15 Feb 2024, 9:56 a.m.
    link
    @Jake has written:

    The problem with databases is that they rely on spreadsheets to import and export data,

    No.

    @Jake has written:

    and then if you want to do anything with the data extracted you're using spreadsheets then uploading a spreadsheet to the database again.

    Nope.

    @Jake has written:

    Also, us teachers are crap with databases.

    Affirmative.

    People are used to using spreadsheets. Spreadsheets work. If you always use a spreadsheet, you will only know how to do things with spreadsheets.

    If I want to quickly analyse a set of data, I'm going to use a spreadsheet. If I need to collect and manage large sets of data collaboratively, and periodically analyse elements of it I'm going to use a database (maybe using a spreadsheet an analysis tool). Spreadsheets can do all of this, so it's easier to use one (and only one personal skill set), but with large sets of data, that needs sharing and versioning, you will run into problems with spreadsheets (even if it's only the logistics of managing independent edits of 'current' versions).

    If you want to see what modern database tools, designed to replace the use of spreadsheets (where they are sub-optimal), you can do worse than look at grist, and specifically grist-electron as a stand alone application.

first_page chevron_left
chevron_right last_page
arrow_upward Go to top
  • Return to Home
  • Turnstile
  • Turdle
  • Talkdash
  • Terms of service
The Daily Cut and Thrust at trentend.uk powered by misago