Lyquidity Solutions Releases Find Combinations Add-in for Spreadsheet Users in Finance and Audit Teams

Share Article

Help to easily track down combinations of numbers in spreadsheets with free add-in. 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 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.    
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 http://www.lyquidity.com/demonstrations

About Lyquidity Solutions

Lyquidity Solutions 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.
For more information, please visit our main website at http://www.lyquidity.com    
US inquiries please call 1-800 401 0289, and for European enquiries please call: +44 (0)207 043 2777 or email info(at)lyquidity.com Media contacts should be addressed to sarah.seddon(at)lyquidity.com. Excel and SharePoint are trademarks of Microsoft Inc.

###

Share article on social media or email:

View article via:

Pdf Print

Contact Author

SARAH SEDDON
Lyquidity
1-800 401 0289
Email >
Visit website