I heavily use Excel and CSV at my workplace.
File 0 Excel File
The initial file is an Excel file. Let's call this File 0. This may or may not change with time depending upon the requirement of the project and input of the client.
File 1 CSV Data Sheet
By observing the notes in File 0, a CSV file is created. Let's call this File 1. This is a data sheet, and changes are made in it from time to time. The change in data sometimes comes over email or has to be pooled in from a database that outputs CSV files. These new files are joined to File 1 as a part of changes in File 1.
File 2 Excel File
Based on notes in File 0 and variable names in File 1, multiple instances of File 2 are created, and each instance is changed from time to time with changes in File 1 and client input and requirements.
File 3 Excel File
For multiple instances and changes in every instance, one File 3 every time.
Now, I want to keep a track of all the changes made into these files along with the files.
All the changes are important as at any point in time the client can go back to some old version of any of the above mentioned files. Please provide a naming convention and also a way to keep the change log efficiently.
There are multiple people working on the same project. Also, the Excel files have multiple sheets.
- I cannot use any external software like SVN, git, or any other paid or free software.
- If any part is unclear, comment, and I'll explain it.