|
| Register for our Free Newsletters |
|
 |
|
|
|
|
|
|
|
|
| Other Carouselweb publications |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
Full compliance and risk analysis for spread sheet users
|
|
Lyquidity Solutions
: 04 June, 2008 (New Product) |
|
|
ComplyXL enables spreadsheet users to perform interdependency analysis for the assessment of risk as well as performing other compliance oriented tasks |
|
Lyquidity Solutions releases free Workbook Statistics and spreadsheet inter-dependency analyser to help organizations report and visualize the risk characteristics of their spreadsheets. Regular use should improve the quality of spreadsheets used across an organisation.
The statistics and dependency analyser is an add-in for Excel that allows an organization to analyse workbooks, to collect statistics, calculate risk weightings and to generate dependency diagrams for all spreadsheets. The add-in produces a comprehensive report that is very quick to generate, even workbooks containing millions of cells take only a few seconds to analyse.
'Excel has all the functionality needed to analyse its own workbooks' said Sandy Marshall, Product Manager at Lyquidity Solutions, 'it just needed to be presented in a useful way. We are aware that companies using spreadsheets are being charged significant sums for software claiming to provide the type of analyses that Excel is able provide. As it took us just a couple of days to produce this tool for a client and because it will be of benefit to all organizations, we felt that it would be great to offer it as a free download. We have used Excel's VBA and the rich functions Excel provides to create the add-in.'
The Workbook Statistics add-in takes advantage of the VBA facilities Excel provides to make it easy to present details such as the number of formulas, cell types, errors, hidden information and external links. The add-in uses these and Excel's ability to create rich reports and diagrams.
The add-in is unlocked so user organisations can customise it to meet their requirements. The add-in provides: Cell use and error review, the ability to assign a risk weighting to each cell, dependency analysis and diagram, highlight potentially broken and invalid links such as circular relationships.
Lyquidity's main product, ComplyXL Enterprise, adds value to Excel by offering spreadsheet management and control to aid the compliance process for organizations. ComplyXL provides:.
* Version control - what changes have been made to the spreadsheets and what were they.
* Change control - who made the changes, when.
* Access controls for spreadsheets â€" user rights for spreadsheets defined, from simple compare rights, through to full manager rights.
* BI style reporting for Sarbanes Oxley compliance â€" strengthening the transparency for the audit process, documentation easily produced.
* Full history of spreadsheets â€" available as an audit trail, available for reporting purposes.
* Snapshot facility â€" what comparisons were carried out, using which criteria, etc formulas, arrays, macros.
* Spreadsheet discovery â€" automated to find spreadsheets wherever they are, as often as you specify.
* Instant notification of changes to spreadsheets â€" whether via email, or IM.
* ComplyXL seamlessly links in to SharePoint.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
