Free Newsletter
Register for our Free Newsletters
Access Control
Deutsche Zone (German Zone)
Education, Training and Professional Services
Government Programmes
Guarding, Equipment and Enforcement
Industrial Computing Security
IT Security
Physical Security
View All
Other Carouselweb publications
Carousel Web
Defense File
New Materials
Pro Health Zone
Pro Manufacturing Zone
Pro Security Zone
Web Lec
ProSecurityZone Sponsor
ProSecurityZone Sponsor
ProSecurityZone Sponsor
ProSecurityZone Sponsor
ProSecurityZone Sponsor
ProSecurityZone Sponsor

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.
Bookmark and Share
Home I Editor's Blog I News by Zone I News by Date I News by Category I Special Reports I Directory I Events I Advertise I Submit Your News I About Us I Guides
   © 2012
Netgains Logo