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?
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
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?
Queue a 6 month approval process to access data for s’curity
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
counter question: Do you want the people that butcher Excel spreadsheets into abominations to be let loose on your database?
The key advantage of a database ti have everything in one place is also its greatest danger.
You make forms that talk to the dBASE, you don’t give them actual dBASE access