However, this methodology clearly sucks and there are several problems with it including:
- Inability for multiple users to open the spreadsheet without copying and creating another spreadsheet on their local machine. Now we have a multiple version problem. - Inability to really keep track of change (coworkers usually just highlight the cell of an item that has an issue yellow, or red, or whatever whenever there is a problem and then write up the issue in yet another column) - Inability to keep track of who asked for the change (who marked this item yellow?) or who fixed it, or when did they fix it. - It is easy to make mistakes. The current spreadsheet we have for a project is easily 80 columns by 20k rows. Let's hope you don't have an off by one row error when you're entering in something. - Along with the above, nobody can tell what has been deleted, or added (other than color) because the spreadsheet is huge and even removing five items is hard to see. - The idiot who started this mess is clearly trying to use excel as a database.
So is anyone aware of a tool that can behave similar to excel, tracks historical user changes and see differences between revision (pretty much what git does) and generally make my coworkers significantly less miserable?
