Welcome!

.NET Authors: Liz McMillan, Peter Silva, Yakov Werde, Matthew Pollicove , Corey Roth

Related Topics: .NET, AJAX & REA

.NET: Press Release

Find Combinations Add-in For Spreadsheet Users

Lyquidity Solutions releases Find Combinations add-in for spreadsheet users in finance and audit teams

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

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 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@lyquidity.comMedia contacts should be addressed to sarah.seddon@lyquidity.com. Excel is a trademarks of Microsoft Inc.

More Stories By Sarah Seddon

I am the Marketing/PR Manager for Lyquidity and as such my focus is on the controls organizations put around spreadsheets.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.