PRZOOM - /newswire/ -
New Malden, Surrey, United Kingdom, 2009/09/07 - Lyquidity Solutions innovators in enterprise spreadsheet management and developers of ComplyXL, announce the availability of the Find Combinations add-in.
This add-in will work standalone or in conjunction with ComplyXL and helps to extend the enterprise spreadsheet controls provided by ComplyXL.
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 online.
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 online.
About Lyquidity Solutions
Lyquidity Solutions (lyquidity.com) is a privately held, leading worldwide spreadsheet management software company providing corporations 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 insurance through to airlines, consultants and healthcare, mining spanning all continents.
US inquiries please call 1-800 401 0289, and for European enquiries please call or E: info[.]lyquidity. Excel is a trademarks of Microsoft Inc.