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
No, I will give them a separate one, and when they make a mess out of it, I’ll make it known, then fix it without any hurry, then they make another kind of mess, I make it known, fix it with no hurry, then… at some point either they learn (because they make efforts or because get told to by superior management), or I reach the conclusion that working here isn’t worth it and move on
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
No, I will give them a separate one, and when they make a mess out of it, I’ll make it known, then fix it without any hurry, then they make another kind of mess, I make it known, fix it with no hurry, then… at some point either they learn (because they make efforts or because get told to by superior management), or I reach the conclusion that working here isn’t worth it and move on