PRZOOM - /newswire/ -
New Malden, Surrey, United Kingdom, 2008/06/07 - Lyquidity Solutions, providers of ComplyXL for enterprise spreadsheet management, releases Workbook Statistics and spreadsheet inter-dependency analyzer to help organizations report and visualize the risk characteristics of spreadsheets.
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 from our site.
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 or contact Sarah.hothersall[.]lyquidity.com to arrange a web demo.
Lyquidity has made available full presentations showing all aspects of ComplyXL to give users a deeper understanding of the software and how it can be used and deployed. Full presentations of ComplyXL and its capabilities are available. Pricing is also shown on the website. Enterprise solutions available for under $10,000
About Lyquidity Solutions
Lyquidity Solutions (lyquidity.com) 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.
US inquiries please call 1-800 401 0289, and for European enquiries please call: +44 (0)207 043 2777 or email Media contacts.
Excel and SharePoint are trademarks of Microsoft Inc.