Lyquidity Solutions Releases Find Combinations

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 should help 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 ability to analyze the information within the spreadsheets and is available for free general download. 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. http://www.lyquidity.com/