| By Sarah Seddon | Article Rating: |
|
| September 4, 2009 11:45 AM EDT | Reads: |
1,770 |
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.
Published September 4, 2009 Reads 1,770
Copyright © 2009 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
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.
- Kindle 2 vs Nook
- Confessions of a Ulitzer Addict
- IBM Hardware Chief, Intel VC Exec Arrested in Insider Trading Scam
- Tactical Cloud Computing Panel at 1st Annual GovIT Expo
- Ulitzer.com Named Exclusive "New Media" Sponsor of Cloud Computing Conference & Expo
- Infrastructure-as-a-Service Will Mature in 2010: Microsoft's David Chou
- Windows 7 – Microsoft’s First Step to the Cloud
- Cloud Expo and the End of Tech Recession
- Jill Tummler Singer, Deputy CIO of CIA, Keynotes at GovIT Expo
- Reality Check at the Cloud Computing Expo
- Visual Studio 2010 Is Cloud Friendly
- Fired SCO CEO Fires Back
- Kindle 2 vs Nook
- The Difference Between Web Hosting and Cloud Computing
- Ajax in RichFaces 3.3, JSF 2 and RichFaces 4
- Confessions of a Ulitzer Addict
- Wave on Ulitzer: Confessions of a Google Wave Fanboy
- IBM Hardware Chief, Intel VC Exec Arrested in Insider Trading Scam
- Cloud Computing Best Practices
- Tactical Cloud Computing Panel at 1st Annual GovIT Expo
- Ulitzer.com Named Exclusive "New Media" Sponsor of Cloud Computing Conference & Expo
- Infrastructure-as-a-Service Will Mature in 2010: Microsoft's David Chou
- Eval JavaScript in a Global Context
- Windows 7 – Microsoft’s First Step to the Cloud
- Google Maps and ASP.NET
- Crystal Reports XI & How It Has Changed
- Converting VB6 to VB.NET, Part I
- Creating Controls for.NET Compact Framework in Visual Studio 2005
- Where Are RIA Technologies Headed in 2008?
- How to Write High-Performance C# Code
- AJAX World RIA Conference & Expo Kicks Off in New York City
- Implementing Tab Navigation with ASP.NET 2.0
- i-Technology Photo Exclusive: Bill Gates & Steve Jobs In "Nerds"
- .NET Archives: Getting Reacquainted with the Father of C#
- i-Technology Viewpoint: "SOA Sucks"
- Programmatically Posting Data to ASP .NET Web Applications



























