Spreadsheets are cool. Where they fall apart they fall apart spectacularly from people insisting on using them as an alternative to a database solution, in my experience. It doesn’t generally matter for normal user centric use cases but I’ve also had to perform a post bankruptcy audit on more than one company that trying to over leverage spreadsheets of duplicate, inconsistent, over saturated, and unreliable data was at the very least a significant contributing factor for the doors being shut.
Over ten contract managers all with their own version of a spreadsheet that tracks reportable items for their contracts and gets rolled up to a master spreadsheet via formulas that financial business decisions gets made from is the first immediate example that comes to mind.
Spreadsheets are cool. Where they fall apart they fall apart spectacularly from people insisting on using them as an alternative to a database solution, in my experience. It doesn’t generally matter for normal user centric use cases but I’ve also had to perform a post bankruptcy audit on more than one company that trying to over leverage spreadsheets of duplicate, inconsistent, over saturated, and unreliable data was at the very least a significant contributing factor for the doors being shut.
Over ten contract managers all with their own version of a spreadsheet that tracks reportable items for their contracts and gets rolled up to a master spreadsheet via formulas that financial business decisions gets made from is the first immediate example that comes to mind.