Sandy Marshall Product Manager for ComplyXL Lyquidity Solutions

Lyquidity Solutions providers of ComplyXL for enterprise spreadsheet management, has released a free Workbook Statistics and spreadsheet inter-dependency analyzer to help organizations report and visualize the risk characteristics of their spreadsheets. Regular use should improve the quality of spreadsheets used across an organization.

The statistics and dependency analyzer is an add-in for Excel that allows an organization to analyze 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 analyze.

"Excel has all the functionality needed to analyze 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. Spreadsheet Statistics can be downloaded.

The add-in is unlocked so user organizations can customize 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
For more information, please visit our website at http://www.lyquidity.com <http://www.lyquidity.com/>  or contact Sarah.hothersall@lyquidity.com to arrange a web demo.

Pricing
Enterprise solutions available for under $10,000

Lyquidity Solutions is a privately held, leading spreadsheet management software company providing corporations worldwide with compliance tools to ensure corporate governance.  With technology for full spreadsheet control and management Lyquidity provides solutions to organizations across market sectors from banks and finance through to airlines, consultants and healthcare around the world.