Apologies if this doesn't make sense, English is not my first language.
I'm working on an application where workflow is split into 'rules' that are defined on several pages of an Excel spreadsheet, a VB script strips out the descriptions of the states etc and leaves only numbers, then exports this configuration as MySQL that is then imported into the database from which the application works.
We have 2-3 developers working on the spreadsheet. Often the spreadsheet is opened from it’s location on a shared network drive, minor changes made and sometimes the version number is not incremented.
This makes it very hard to track changes and also who made them and why. Ideally we would pull the spreadsheet to a working directory, do a diff and commit changes then push them to a master repository. It seems like there are no viable tools to do such a thing with Excel.
So my question is what would be a better way to support a very large configuration, make it version controllable and still human readable?