Friday, January 28, 2011
Monday, January 24, 2011
ComplyXL now supports Rights Protected and Encrypted files in line with corporate spreadsheet management policies
New York, London: January 22, 2011: Lyquidity, an international developer of spreadsheet enterprise risk management controls, announce the availability of support for IRM (rights) protected and encrypted files to be managed and controlled by ComplyXL.
Microsoft has granted a license to Lyquidity which allows for the control of encrypted and rights protected (IRM) spreadsheets so organizations that have tightened their security management are now able to continuously control and monitor all spreadsheets using ComplyXL. These security aware organizations will be able to ensure full control and management, as well as analysis, of all spreadsheets and their usage patterns as well as defined segregation of roles, version and change control.
Increased use of IRM for additional security
Organizations using IRM can specify access permissions to workbooks not just simple password protection. Using IRM organizations can prevent sensitive information from being printed, forwarded, or copied by unauthorized people. Once permission has been restricted using IRM the access and usage restrictions are enforced no matter where the information is, as permission to a file is stored in the document file itself which helps organizations enforce corporate guidelines governing the control and dissemination of information.
Although IRM protected documents are encrypted, no passwords are required because they are encrypted using a certificate based key issued by Active Directory, which provided login control to Windows domains. As a result, only authorized users are able to access the files.
About Lyquidity Solutions
Lyquidity Solutions is a leading worldwide spreadsheet management software company providing corporations with compliance tools to ensure corporate governance. With ComplyXL, Lyquidity provides solutions to international organizations across market sectors from banks and insurance organizations through to airlines, consultants, healthcare and mining for full spreadsheet control and management. See www.lyquidity.com/quotes for customer stories.
For more information, please visit our main website at www.lyquidity.comUS inquiries please call 1-800 401 0289, and for European enquiries please call: +44 (0)207 043 2777 or email info@lyquidity.com Media contacts should be addressed to sarah.seddon@lyquidity.com.
Microsoft has granted a license to Lyquidity which allows for the control of encrypted and rights protected (IRM) spreadsheets so organizations that have tightened their security management are now able to continuously control and monitor all spreadsheets using ComplyXL. These security aware organizations will be able to ensure full control and management, as well as analysis, of all spreadsheets and their usage patterns as well as defined segregation of roles, version and change control.
Increased use of IRM for additional security
Organizations using IRM can specify access permissions to workbooks not just simple password protection. Using IRM organizations can prevent sensitive information from being printed, forwarded, or copied by unauthorized people. Once permission has been restricted using IRM the access and usage restrictions are enforced no matter where the information is, as permission to a file is stored in the document file itself which helps organizations enforce corporate guidelines governing the control and dissemination of information.
Although IRM protected documents are encrypted, no passwords are required because they are encrypted using a certificate based key issued by Active Directory, which provided login control to Windows domains. As a result, only authorized users are able to access the files.
About Lyquidity Solutions
Lyquidity Solutions is a leading worldwide spreadsheet management software company providing corporations with compliance tools to ensure corporate governance. With ComplyXL, Lyquidity provides solutions to international organizations across market sectors from banks and insurance organizations through to airlines, consultants, healthcare and mining for full spreadsheet control and management. See www.lyquidity.com/quotes for customer stories.
For more information, please visit our main website at www.lyquidity.comUS inquiries please call 1-800 401 0289, and for European enquiries please call: +44 (0)207 043 2777 or email info@lyquidity.com Media contacts should be addressed to sarah.seddon@lyquidity.com.
Thursday, September 16, 2010
Enterprise spreadsheet management with ComplyXL now FIPS compliant
ComplyXL delivers spreadsheet management controls within the Federal Information Processing Standard (FIPS) protocols
Lyquidity (London and New York), an international provider of enterprise spreadsheet management solutions, announce the availability of ComplyXL Enterprise FIPS compliant. At the request of a US Federal Agency, ComplyXL is now enhanced to comply with guidelines set by the US government and other regulated industries, such as financial and healthcare institutions that collect, store, transfer, share and disseminate sensitive but unclassified information.
ComplyXL is used internationally to:
• Find and monitor spreadsheets throughout the organization on a continuous basis
• Notify when key changes happen, with user defined parameters
• Keep spreadsheets where they are without the need to move them and possibly introduce errors
• Carry out full comparison of changes, all the way to cell level, with full audit trails of changes
• Provide a Manager Approval Process without tying up vital spreadsheets
• Ensure full version control
Lyquidity has full presentations showing all aspects of ComplyXL. 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 spreadsheet compliance tools to ensure corporate governance. With technology for full spreadsheet control and management Lyquidity provides solutions to international organizations across market sectors from banks and insurance through to airlines, consultants, healthcare and mining.
For more information, please visit our main website at www.lyquidity.com
US inquiries please call 1-800 401 0289, European enquiries please call: +44 (0)207 043 2777 or email info@lyquidity.com Media contacts should be addressed to sarah.seddon@lyquidity.com.
About Federal Information Processing Standards Publications (FIPS)
FIPS (Federal Information Processing Standards) are issued by NIST and are a set of standards that describe document processing, encryption algorithms and other information technology standards for use within non-military government agencies and by government vendors who work with the agencies. For more information please visit www.itl.nist.gov
Lyquidity (London and New York), an international provider of enterprise spreadsheet management solutions, announce the availability of ComplyXL Enterprise FIPS compliant. At the request of a US Federal Agency, ComplyXL is now enhanced to comply with guidelines set by the US government and other regulated industries, such as financial and healthcare institutions that collect, store, transfer, share and disseminate sensitive but unclassified information.
ComplyXL is used internationally to:
• Find and monitor spreadsheets throughout the organization on a continuous basis
• Notify when key changes happen, with user defined parameters
• Keep spreadsheets where they are without the need to move them and possibly introduce errors
• Carry out full comparison of changes, all the way to cell level, with full audit trails of changes
• Provide a Manager Approval Process without tying up vital spreadsheets
• Ensure full version control
Lyquidity has full presentations showing all aspects of ComplyXL. 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 spreadsheet compliance tools to ensure corporate governance. With technology for full spreadsheet control and management Lyquidity provides solutions to international organizations across market sectors from banks and insurance through to airlines, consultants, healthcare and mining.
For more information, please visit our main website at www.lyquidity.com
US inquiries please call 1-800 401 0289, European enquiries please call: +44 (0)207 043 2777 or email info@lyquidity.com Media contacts should be addressed to sarah.seddon@lyquidity.com.
About Federal Information Processing Standards Publications (FIPS)
FIPS (Federal Information Processing Standards) are issued by NIST and are a set of standards that describe document processing, encryption algorithms and other information technology standards for use within non-military government agencies and by government vendors who work with the agencies. For more information please visit www.itl.nist.gov
Tuesday, January 16, 2007
Formula viewer in Excel spreadsheets
I wanted to let everyone know about a really useful utility that is now in the current version of ComplyXL.
http://www.lyquidity.com/mambo/images/SWF/Formula%20Viewer.htm
I’m excited about this development because it is the first step on our journey to make the day-to-day use of Excel more intuitive. It can sit on your desktop and will be updated as you move from cell-to-cell or as you edit a formula.
Where this will go next is to add type information to Excel and goes to the point I made about the new version of Excel not really adding much to help create better more reliable workbooks. As developers our tools have strong typing built into them. If we try to add a thing of type apples to a thing of type oranges the tool will point out the error of our ways. By contrast, Excel will allow you to add apples to anything. Add numbers to strings of characters, strings of characters to dates and so on. This makes it easy to use because there’s no cumbersome definition phase to endure in which users tell Excel that cell A1 is of type apples. The corollary of “easy to use” is “easy to make a mistake”. But by letting the user add types to cells they can specify which cell is “Revenue”, which is “Cost of sales” and which is “Gross Profit” so that the types can be checked to make sure formulas make sense. “Gross Profit=Revenue-Cost of Sales” would make sense. “Current Liabilities-Gross Profit” would not.
Anyway, back to the formula viewer. Take the formula:
=IF(SUM(CK10:CK11)
Unless you are a hardened Excel meister even this relatively simple formula is difficult to understand at first glance. Once you have worked out what part is the condition and which parts are the TRUE and FALSE results you have no idea what values are being used and how the result is computed. Yes, you can use the formula evaluator but it's hidden away and does not show you the values your formula will work with as you write the formula.
Formula Viewer (see the image) changes the presentation to make the structure of the formula clearer and shows the values used by each part of the formula so that you can see how the formula will work. For example, you can see that the condition's result in this formula is FALSE because the sum of the cells in the range CK10:CK11 (10) are not greater than the value of cell CK12. OK you still have to know that that “<” means less than but we could make it say “is less than”.
Also you can see how by adding an extra column called “Type” we can show the user whether or not their formulas are logical.
All this really adds benefits to our auditing users.
http://www.lyquidity.com/mambo/images/SWF/Formula%20Viewer.htm
I’m excited about this development because it is the first step on our journey to make the day-to-day use of Excel more intuitive. It can sit on your desktop and will be updated as you move from cell-to-cell or as you edit a formula.
Where this will go next is to add type information to Excel and goes to the point I made about the new version of Excel not really adding much to help create better more reliable workbooks. As developers our tools have strong typing built into them. If we try to add a thing of type apples to a thing of type oranges the tool will point out the error of our ways. By contrast, Excel will allow you to add apples to anything. Add numbers to strings of characters, strings of characters to dates and so on. This makes it easy to use because there’s no cumbersome definition phase to endure in which users tell Excel that cell A1 is of type apples. The corollary of “easy to use” is “easy to make a mistake”. But by letting the user add types to cells they can specify which cell is “Revenue”, which is “Cost of sales” and which is “Gross Profit” so that the types can be checked to make sure formulas make sense. “Gross Profit=Revenue-Cost of Sales” would make sense. “Current Liabilities-Gross Profit” would not.
Anyway, back to the formula viewer. Take the formula:
=IF(SUM(CK10:CK11)
Unless you are a hardened Excel meister even this relatively simple formula is difficult to understand at first glance. Once you have worked out what part is the condition and which parts are the TRUE and FALSE results you have no idea what values are being used and how the result is computed. Yes, you can use the formula evaluator but it's hidden away and does not show you the values your formula will work with as you write the formula.
Formula Viewer (see the image) changes the presentation to make the structure of the formula clearer and shows the values used by each part of the formula so that you can see how the formula will work. For example, you can see that the condition's result in this formula is FALSE because the sum of the cells in the range CK10:CK11 (10) are not greater than the value of cell CK12. OK you still have to know that that “<” means less than but we could make it say “is less than”.
Also you can see how by adding an extra column called “Type” we can show the user whether or not their formulas are logical.
All this really adds benefits to our auditing users.
Thursday, December 14, 2006
Detail Reviews in ComplyXL for spreadsheets
ComplyXL detail comparison reviews provide very detailed text-based reviews of the differences found between workbooks and worksheet.
Workbook review
The workbook review is designed to provide the reviewer with an overview of any differences found within and between workbooks and the ability to drill down into the details.
The workbook review covers more than changes to cell values. It includes a review of changes to documents and macro changes as well.
The ComplyXL workbook review is able to detect whether any change has been made to a workbook though it may not necessarily be able to to show you the specific change.
Worksheet review
A review of any worksheet differences can be accessed either from the detailed workbook review or directly from one of the worksheet comparison options. The screen shot below shows an example of a link provided from the workbook details review when ComplyXL identifies changes to a contained worksheet.
Sometimes ComplyXL will identify changes to a worksheet but changes that do not affect cell value, formulas, formats, names or merged cell ranges. An example is a change to a chart. That a change has been made will be detected, however ComplyXL is unable to determine the specific change made to a chart.
The worksheet review details the differences detected between two worksheets row-by-row and cell-by-cell. The worksheet review lists all rows that contain changed cells and then the individual cells containing changes. Although the most common features of a cell are its value and formula, cells are described by many other properties such as the font and color used to display the value, whether it is locked, part of a merged cell group and so on.
For cells that ComplyXL detects are different it will list the the properties that have changed and include the current values. If available, the current formulas will also be included.
What is the "Raw cell value"?
Workbook review
The workbook review is designed to provide the reviewer with an overview of any differences found within and between workbooks and the ability to drill down into the details.
The workbook review covers more than changes to cell values. It includes a review of changes to documents and macro changes as well.
The ComplyXL workbook review is able to detect whether any change has been made to a workbook though it may not necessarily be able to to show you the specific change.
Worksheet review
A review of any worksheet differences can be accessed either from the detailed workbook review or directly from one of the worksheet comparison options. The screen shot below shows an example of a link provided from the workbook details review when ComplyXL identifies changes to a contained worksheet.
Sometimes ComplyXL will identify changes to a worksheet but changes that do not affect cell value, formulas, formats, names or merged cell ranges. An example is a change to a chart. That a change has been made will be detected, however ComplyXL is unable to determine the specific change made to a chart.
The worksheet review details the differences detected between two worksheets row-by-row and cell-by-cell. The worksheet review lists all rows that contain changed cells and then the individual cells containing changes. Although the most common features of a cell are its value and formula, cells are described by many other properties such as the font and color used to display the value, whether it is locked, part of a merged cell group and so on.
For cells that ComplyXL detects are different it will list the the properties that have changed and include the current values. If available, the current formulas will also be included.
What is the "Raw cell value"?
Tuesday, December 12, 2006
Controlling the display colors in ComplyXL graphics - spreadsheet comparison
While in the graphical view you can change the colors used to highlight differences in the worksheet. To change colors click on the link in shown in the following two screen shots and which are circled in red.
Clicking on the link brings up the display properties editor. The editor shows two groups of properties: the colors for the main display and the colors for the scroll bar.
To change a color select the color you want to change and then select the color from the drop down that appears in right hand list (circled in red in the following screen shot).
Changes are displayed in the main window straight away so you can see which set of colors are the most appropriate for you.
Changes to any of the properties are saved when the Close button is pressed. The Reset properties button can be used to set all colors back to their default values.
While in the graphical view you can change the colors used to highlight differences in the worksheet. To change colors click on the link in shown in the following two screen shots and which are circled in red.
Clicking on the link brings up the display properties editor. The editor shows two groups of properties: the colors for the main display and the colors for the scroll bar.
To change a color select the color you want to change and then select the color from the drop down that appears in right hand list (circled in red in the following screen shot).
Changes are displayed in the main window straight away so you can see which set of colors are the most appropriate for you.
Changes to any of the properties are saved when the Close button is pressed. The Reset properties button can be used to set all colors back to their default values.
Tuesday, December 05, 2006
Lyquidity announces its spreadsheet compliance and control tool, ComplyXL version 1.5
New York, London December 2006 – Lyquidity Solutions, specialists in the control, management and compliance of Excel spreadsheets, and providers of business critical solutions for regulatory and accounting issues, today announced the availability of its latest release, ComplyXL 1.5. ComplyXL is a key component for business critical information because it ensures a logical solution to the need to track cell changes, ensuring tighter controls, all without the losing Excel’s usability and flexibility.
ComplyXL provides change tracking down to cell level so reducing spreadsheet risk arising from unintended change. Because cell changes to cell values, formulas and formats can be reviewed, ComplyXL ensures that stringent regulatory and compliance issues such as Sarbanes Oxley are met without affecting business productivity. Packaged as a standalone application, an add-in to Excel and as a web server, ComplyXL is able to provide all organisations with the ability to monitor every spreadsheet, regardless of size..
With version 1.5 Lyquidity has responded to user requests, particularly from the banking and audit sectors, to allow users the ability to focus on any type of change and ComplyXL provides a comprehensive range of change filtering options. Change type filtering allows the user to select or de-select exactly which differences and changes to highlight, whether it’s macro changes, formula changes, locked or unlocked cells, blank or locked cells etc. The user is able to see a graphical overview of changes to a worksheet and ‘zoom’ into their key information, dramatically speeding up the time taken to highlight critical spreadsheet changes, and so enables the user to focus on their key area of interest
Lyquidity has shown its commitment to providing cost effective solutions for organisations facing ever tightening compliance issues. “Compliance is only one part of the story. We have found that making it easy for users to see changes is key so in 1.5 we have provided a graphical overview of worksheet changes.” said Sandy Marshall, Product Manager for ComplyXL. “ComplyXL v1.5 has been developed directly in response to help users address the pitfalls of spreadsheet use. We have listened to our users and feel that v1.5 adds a whole new dimension to understanding exactly what changes have been made to key information, and pinpointing them quickly”. ComplyXL v1.5 is being shipped as of today and, for ease of use, is available to customers to download. Trial downloads of the software are available from our website at http://www.lyquidity.com.
About Lyquidity
Lyquidity Solutions is an innovative specialist in the control, management and compliance of Excel spreadsheets.. More information can be found from our website at www.lyquidity.com. For US inquiries please either email info@lyquidity.com or call 1-800 401 0289, and for European enquiries call +44 (0)208 241 0500 or email info@lyquidity.com 12/06/bl
ComplyXL provides change tracking down to cell level so reducing spreadsheet risk arising from unintended change. Because cell changes to cell values, formulas and formats can be reviewed, ComplyXL ensures that stringent regulatory and compliance issues such as Sarbanes Oxley are met without affecting business productivity. Packaged as a standalone application, an add-in to Excel and as a web server, ComplyXL is able to provide all organisations with the ability to monitor every spreadsheet, regardless of size..
With version 1.5 Lyquidity has responded to user requests, particularly from the banking and audit sectors, to allow users the ability to focus on any type of change and ComplyXL provides a comprehensive range of change filtering options. Change type filtering allows the user to select or de-select exactly which differences and changes to highlight, whether it’s macro changes, formula changes, locked or unlocked cells, blank or locked cells etc. The user is able to see a graphical overview of changes to a worksheet and ‘zoom’ into their key information, dramatically speeding up the time taken to highlight critical spreadsheet changes, and so enables the user to focus on their key area of interest
Lyquidity has shown its commitment to providing cost effective solutions for organisations facing ever tightening compliance issues. “Compliance is only one part of the story. We have found that making it easy for users to see changes is key so in 1.5 we have provided a graphical overview of worksheet changes.” said Sandy Marshall, Product Manager for ComplyXL. “ComplyXL v1.5 has been developed directly in response to help users address the pitfalls of spreadsheet use. We have listened to our users and feel that v1.5 adds a whole new dimension to understanding exactly what changes have been made to key information, and pinpointing them quickly”. ComplyXL v1.5 is being shipped as of today and, for ease of use, is available to customers to download. Trial downloads of the software are available from our website at http://www.lyquidity.com.
About Lyquidity
Lyquidity Solutions is an innovative specialist in the control, management and compliance of Excel spreadsheets.. More information can be found from our website at www.lyquidity.com. For US inquiries please either email info@lyquidity.com or call 1-800 401 0289, and for European enquiries call +44 (0)208 241 0500 or email info@lyquidity.com 12/06/bl
Subscribe to:
Posts (Atom)