ComplyXL simplifies deployment of spreadsheet controls across multiple locations without the need to install local client software.

Thursday, November 5th, 2009

New York, London: Lyquidity, international innovators in the development of enterprise spreadsheet management tools for multinational organizations, announce the availability of ComplyXL using Microsoft's Silverlight. The inclusion of Silverlight technology allows ComplyXL to present a rich user interface for users to review changes to spreadsheets over the intranet and internet. Silverlight includes comprehensive security which allows remote users to gain controlled access to specified spreadsheets. Like all web-based applications there is no need to install any client software locally with control maintained using enterprise security protocols.

This enhancement has been developed as part of Lyquidity's ongoing strategy in the field of spreadsheet compliance and provides:

• Reduced deployment requirements, no client install necessary
• Same version of the software used throughout the organization
• Updates easily applied
• More intuitive interface
• No specific technology required for the server

This enhancement is part of a wide range of benefits which ComplyXL offers, such as:

• Version control for spreadsheets
• Continuous monitoring
• Controlled user defined actions - what can be changed, who by, who can view the spreadsheets
• Full comparison of versions
• Audit reports stored for future access for compliance
• Full, easy generated reporting of activities carried out, whether by department, users, or predefined criteria

Lyquidity has full presentations showing all aspects of ComplyXL. These give users a deeper understanding of the softwareand how it can be used and deployed. Full presentations are available at www.lyquidity.com/demonstrations

Help to easily track down combinations of numbers in spreadsheets with free add-in

Wednesday, September 2nd, 2009

ComplyXL provides the key framework used by organizations for version and audit controls as well as continuous monitoring of critical spreadsheets with instant notification of changes. The Find Combinations utility gives the added ability to analyze the information within the spreadsheets and is available for free general download from the Lyquidity website, simply log in and download.

Said Steve Bruckner, lead software designer: "Imagine you are an auditor or cash accountant and need to reconcile, say, bank statement cash balances back to payment or receipt batches. In a huge spreadsheet finding a discrepancy between two numbers can be an overwhelming task but using Lyquidity's Find Combinations enables you to analyze ranges of numbers to find the total to a selected value, saving valuable time. Not surprisingly, it's been popular with the audit firms." A video which shows how the software is used can be viewed at http://www.lyquidity.com/findcombinations

Key benefits of Find Combinations include the ability to:

• Enter or select a target value. Combinations of cell values will be computed and tested against this number for a match
• Specify or select a maximum group size of combinations to try
• See the addresses of the cells which total to the target value
• Select a range of values, with the ability to select multiple areas
• Find the combination of values in a specified cell range that total to a given value

The group size value allows you to control the maximum size of groups that will be tested. For example, although you are looking for combinations of numbers in a list of 100 values, you may know that the number of values to be added together never exceeds, say, 5. You can then specify 5 as the maximum group size and then no groups of 6 or higher will be tested.

This is important, especially in large lists, because the number of potential combinations can be vast. There are 627 combinations of 2, 3, 4 and 5 numbers in a list 10. There are 2,369,885 combinations of the same groups in a list of 50 numbers and 7,937,339 combinations in a list of 100. On a 1.8Mz laptop working through these 7+ million numbers takes about 5 minutes - or about 20,000 tests per second.

Lyquidity has full presentations showing all aspects of ComplyXL and well as Find Combinations. These give users a deeper understanding of the software and how it can be used and deployed. Full presentations are available at: www.lyquidity.com/demonstrations

Monday, April 27th, 2009

SEGRO (SGRO) is Europe's leading property investment and development company providing business space across Europe, and is one of the largest REITs in the world.  With headquarters in the UK, Segro has locations across Europe in Belgium, the Czech Republic, France, Germany, Hungary, Italy, the Netherlands, Poland and Spain.  With assets of £5.1 billion and 5 million sqm of business space, and an annual rental income of approximately £314 million SEGRO needed to find a way to manage and streamline the information and reporting of both financial and property information held in spreadsheets.

ISSUES

SEGRO was about to launch a new MRI finance group applicaiton so it was vital all data feeding in was controlled with changes approved and with a full audit trail of changes.  This information was both financial and property, and included such information as area, how much was let, how much was vacant etc.  With the information being checked manually the time taken was significant and had the potential for errors.

As the spreadsheets were being updated on a daily basis, with no real way to check the spreadsheets or control and changes except manually, it became imperative that spreadsheet controls were put in place in a non intrusive way that could be rolled out easily throughout Europe with minimal disruption.

Rob Healey, Service Delivery Manager for Europe was tasked with finding a solution that would link into the new initiative to analyze the information, both the financial and perperty details, held in spreadsheets across Europe, to be able to report on the changes all the way to cell level and then to send notifications to the owners of the spreadsheets that the document had changed, all in a fast and verifiable way.

The project was initiated in France with 45 users spread across 9 different countries in Europe.  These users included the Finance Accountants, Property Managers and Country Managers with the information feeding into the central store, the changed spreadsheets saved, with their full verison history then analyzed every day.

BENEFITS OF COMPLYXL

"Once ComplyXL was installed, it saved us enormous amounts of time in the analysis of spreadsheet changes.  With the property information when it changes it causes a ripple effect, now with the changes being easy to track down and easy to see and approve, we have confidence in the information.  For instance in Germany we have 110 properties, so any changes to information in our spreadsheets, we can now easily filter and understand, we know and trust the quality of information" said Rob Healey.

He goes on to say "the support from Lyquidity has been tremendous, from the initial contact with the demonstration of ComplyXL, all the way through to loading license files, they have helped us at very short notice,  It's alway nice to get good service from a software vendor, as some just sell you the produce and you have to struggle to get the right resource to help.  Lyquidity have been tremendous and I would recommend them".

Provides ediscovery, reporting and corporate wide spreadsheet compliance

Tuesday, March 24th, 2009

ComplyXL the innovative solution for enterprises to manage and control the information held in spreadsheets, now addresses the need for corporations to set retention policies for information held in spreadsheets.  With ComplyXL spreadsheets can now be included in the corporate retention policies, and can be applied across divisions and business units.

ComplyXL also addresses other key areas of information retention, such as:

• an index of spreadsheets
• the locations where these spreadsheets are held
• the ability to search for activie and inactive spreadsheets
• classification of spreadsheets, whether critical, medium or low risk
• determins retention periods
• continuous monitoring of spreadsheets

Please contact us at info@lyquidity.com to arrange a presentation

Lyquidity Solutions, providers of ComplyXL for enterprise spreadsheet compliance and risk management today announce a faster way to ensure immediate access to critical spreadsheet management information.

Wednesday, February 25th, 2009

ComplyXL, the innovative solution for enterprises to manage and control the information held in spreadsheets, now continuously monitors and reports on the activity within critical spreadsheets as a desktop utility.  Managers can see and be notified immediately from the ComplyXL systems tray when critical spreadsheets have been changed, wherever they are, which acts as an additional safeguard, protecting data.

The ComplyXL system tray utility is instantly available with one click and acts as a continous monitor so managers can be confident they are immediately aware of changes to spreadsheets, who changed them, what changed and why.  ComplyXL can be scheduled to check for changes at whatever interval the manager chooses, whether every minute, through to every four hours, with a note popping up as soon as changes are made.  This system tray capability also provides the added benefits of:

Managers can view critical spreadsheets in a way that has been previously chosen, so they can quickly access the information about spreadsheets in a view that is familiar

Managers can also control what will happen when a workbook is selected.  The ComplyXL system tray utility can creat an email contrining a reference to the selected file of have it open the original spreadsheet in Excel so that Managers can choose what further actions, if any, to take Collaboration by different areas of the business can be controlled in a way that doesn't interfere with the user experience.  Managers can send a web link to users not on the local network so they are able to download, change and upload a set of spreadsheet changes as a once-only action and without having ComplyXL installed locally.  This helps organization with numerous offices upload changes in a clearly defined way which complements their business processes, such as monthly figures needed by head office.  As standard, these changes can go through the Manager Approval Process in a secure, traceable controlled way.

Said Sandy Marshall, Product Manager for ComplyXL "at a time when access to information and an understand of what is happening to data is vital, ComplyXL provides a real level of reassurance, with full audit trails of changes all the way to cell level.  ComplyXL is proving itself as a key tool for corporations who need to show spreadsheets are managed within a compliance framework.  The new ComplyXL system tray utility helps our customers who have offices in remote locations transfer spreadsheet information in the same controlled way, wherever the information comes from.  By allowing the link to upload the information as a once only action with a time limit, organizations can pull the information they need in the same controlled way as if ComplyXL were installed locally".

ComplyXL delivers compliance solution for multiple group companies whilst allowing centralized compliance.

Monday, September 29th, 2008

The latest enhancements to ComplyXL provide the flexibility of different options to suit customer deployments, whether its auditors or compliance teams who access spreadsheets in different repositories or different locations.  Some organizations use different repositories as another layer of protection against unauthorized access.  ComplyXL allows for this by providing the compliance team with a solution to monitor spreadsheet use, access and changes across different repositories, with the ability to report on changes, user actions and version history.  "Our customers have come to expect real benefits from ComplyXL and with this latest version we have ensured ComplyXL works with company policy to provide this." said Sandy Marshall, Product Manager for ComplyXL.  "We provide our customers with software that is easy to deploy, easy to use, and as a cost justification, at around $10,000 for an enterprise solution, is proving popular in this economic climate".

Other key enhancements include:

• Multiple repositories - spreadsheets controlled and managed, even in different repositories
• Manager Approval Process streamlined - users can display approved and approval pending workbooks for reporting and auditing purposes without locking the spreadsheets
• Macro (VBA) comparisons in the main comparison so people who work extensively with macros can compare and report more easily
• Spreadsheet discovery - time checking, adding only those changes which occurred after the last run, even if ComplyXL isn't installed as well as instant notification of changes, via IM or email, or scheduled notifications, whether hourly or daily.
• Unlike document management systems, there's no need to change dependencies within your spreadsheets, so saving time and preventing possible errors being introduced.

Organizations can trial ComplyXL Enterprise on remote servers so they can get a feel for the software without it interfering with the day to day business processes.  Once comfortable with the software, ComplyXL Enterprise easily transfers internally with users and IT staff already familiar with the capabilities of the software, installation normally takes a couple of hours.

For large installations ComplyXL is installed automatically on user PCs using the MSI install package which ensures speed of deployment with large user rollouts, so saving time and effort.