3 ms·
As someone that spent many countable (billable) hours doing Excel audits--yes there is. You build them yourself. The fallacy that you're bringing to Excel is
by skylanh 7y ago
As someone that spent many countable (billable) hours doing Excel audits--yes there is.
You build them yourself.
The fallacy that you're bringing to Excel is pretending that it's a "all-and-be-all" in a package.
It's a tool with an embedded programming environment. Much like you'd take a basic Python install, and add on additional tools, the same applies to Excel.
The embedded programming language (VBA) is a fantastic language--it has absolutely no libraries out of the box which makes it a poor development /environment/.
To directly address your question:
- include a "version" cell on a "Config" worksheet (optionally include values for "audited by", "audited date", "audit version", "audit type", note this could be a multirow, so you could actually specify "full" audits, and mini audits)
- build a function that maps all formulas to an "Audit" worksheet
- build a function to export to CSV with the date and version tagged
- build a function to export all code modules to text files
- create whatever release-versioning you want around this: zip of exports + "deployment" XLS, GIT repo with tagged version and exports and a binary blob of the XLS, etc, etc.
(Edit: workbook vs worksheet; each tab in a workbook is a worksheet.)