Created by elements5
Powered by TweetFeed
ScanXLS assists you in IT audit compliance projects related to internal controls on risks in end user development of spreadsheet models. This inventory/catalog utility has now been enhanced with complexity metrics to address concerns in Sarbanes-Oxley (SOX) 404 audits.
Purpose ScanXLS gives you data for these fundamental questions you need to answer in your Sarbox project: - What spreadsheets do we have where on the network? - Who is the responsible owner/user/developer? - How big are they, how complex, have they errors? - What dependencies/links exist between them? - Has a spreadsheet changed from an authorized/validated version?
It scans any given directory and below and obtains a list of all the .XLS files. You then select some or all of these, and it opens each one in turn read-only and reports on some file properties, attributes, the presence of unusual features or settings that may represent a risk or are prone to human error, Excel's error checking summaries, a list of other workbooks that it depends on through links, and a scoring on how 'problematic' it might be. SCANXLS can also compare two workbooks to check whether their formulas and/or values are identical.