Feeds

Making sense of spreadsheet madness

QTier-Rapor

Combat fraud and increase customer satisfaction

Comment I have written in the last year or so about a number of vendors offering spreadsheet management and compliance capabilities. However, one that I had not previously come across is QTier, whose QTier-Rapor product combines spreadsheet management with spreadsheet automation. Indeed, the latter was the original focus of the product, which is perhaps why I had not previously heard of it, or perhaps because it is a relatively small British company that focuses on technology rather than marketing. I only heard about it because one of its partners, Insight Management and System Consultants, which is a specialist in the public sector, gave me a heads up.

The most impressive thing about QTier-Rapor is that it has been designed to support the process of developing (and automating) spreadsheets. Moreover, I mean process in the sense of business process improvement with workflow-like diagrams that you create using drag-and-drop techniques, so that the creation process is formalised, including the various steps that owners, editors and auditors should undertake both during development and testing and prior to formal release to production.

As far as users are concerned, they simply use Excel (any version that supports .NET) but the spreadsheet can be automatically populated from, say, ERP applications and, indeed, a single spreadsheet can be dependent on a number of heterogeneous front-end sources. Spreadsheets are instantiated at run-time and are dynamically populated. You can also write-back to the source systems (if you have permission) or, if the spreadsheet generates information for which there is no relevant data field in the source, you can use Rapor's own database (Oracle or SQL Server) to store this information.

Other automated facilities include data validation (checking for reasonableness), dependency checking (you can't run a forecast review, for example, before forecast entry), disconnected processing support, a task scheduler and the ability to track the completion of spreadsheets using, say, traffic light indicators. One feature I would like to see is impact analysis and where-used capabilities: QTier says that you could design a spreadsheet for this purpose but it would be for a specific requirement rather than a generic facility. Also, you can't include a release date as a part of a process though you could use the task scheduler for this purpose.

On the management and compliance side, there are audit trails for security (monitoring role changes), process version history (Rapor includes full change and version management capabilities) and end user and event-based (including subversion events) auditing. There is also an anti-tampering facility as well as locking down to cell level, the ability to assign compliance rules to some spreadsheets but not others, an authentication/registration number that is system generated for all printed versions of a spreadsheet, and the automatic generation of relevant documentation (QTier estimates around 60 per cent of the total).

All of this (and I have only scratched the surface) should make QTier of serious interest for anyone interested in getting a handle on their spreadsheet issues. Despite being only a small company, QTier has been around since 1999 and has worked closely with PwC on the development of Rapor. It has now established distributorships in the United States, Australia, Ireland, and the UK. Some of its partners have built applications such as expense or timesheet management on top of Rapor but mostly it is marketed as a generic proposition.

Copyright © 2006, IT-Analysis.com

Combat fraud and increase customer satisfaction

More from The Register

next story
OpenBSD founder wants to bin buggy OpenSSL library, launches fork
One Heartbleed vuln was too many for Theo de Raadt
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Ubuntu 14.04 LTS: Great changes, but sssh don't mention the...
Why HELLO Amazon! You weren't here last time
Got Windows 8.1 Update yet? Get ready for YET ANOTHER ONE – rumor
Leaker claims big release due this fall as Microsoft herds us into the CLOUD
Patch iOS, OS X now: PDFs, JPEGs, URLs, web pages can pwn your kit
Plus: iThings and desktops at risk of NEW SSL attack flaw
Next Windows obsolescence panic is 450 days from … NOW!
The clock is ticking louder for Windows Server 2003 R2 users
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
Red Hat to ship RHEL 7 release candidate with a taste of container tech
Grab 'near-final' version of next Enterprise Linux next week
Apple inaugurates free OS X beta program for world+dog
Prerelease software now open to anyone, not just developers – as long as you keep quiet
prev story

Whitepapers

Mobile application security study
Download this report to see the alarming realities regarding the sheer number of applications vulnerable to attack, as well as the most common and easily addressable vulnerability errors.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.