• Shanmugha@lemmy.world
    link
    fedilink
    English
    arrow-up
    2
    ·
    edit-2
    1 day ago

    Why not use database, actually. I am yet to see anything related to money that is not a rabbit hole of wildly different things interacting by wildly unexpected logic. Ffs, is writing esoteric formulae in a spreadsheet really easier than learning some SQL dialect with a few pretty advanced and specific features?

      • Shanmugha@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        ·
        16 hours ago

        Nice catch, I am annoyed as fuck with access approval even as a dev. But, since I am advocating for moving financial analysis to using databases instead of spreadsheets, it becomes my problem, so: me makes a separate db for this very purpose, and the access is given to any and all accountants. Security guys are welcome to join the dev process of preparing the db and data flows that write from other sources into it, so that financial guys have up-to-date state of data: want restrictions - go ahead and tell them they don’t need this and that