Feeds

Making sense of spreadsheet madness

QTier-Rapor

Top 5 reasons to deploy VMware with Tegile

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

Providing a secure and efficient Helpdesk

More from The Register

next story
Google+ goes TITSUP. But WHO knew? How long? Anyone ... Hello ...
Wobbly Gmail, Contacts, Calendar on the other hand ...
Preview redux: Microsoft ships new Windows 10 build with 7,000 changes
Latest bleeding-edge bits borrow Action Center from Windows Phone
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
Google opens Inbox – email for people too stupid to use email
Print this article out and give it to someone techy if you get stuck
UNIX greybeards threaten Debian fork over systemd plan
'Veteran Unix Admins' fear desktop emphasis is betraying open source
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Redmond top man Satya Nadella: 'Microsoft LOVES Linux'
Open-source 'love' fairly runneth over at cloud event
prev story

Whitepapers

Cloud and hybrid-cloud data protection for VMware
Learn how quick and easy it is to configure backups and perform restores for VMware environments.
A strategic approach to identity relationship management
ForgeRock commissioned Forrester to evaluate companies’ IAM practices and requirements when it comes to customer-facing scenarios versus employee-facing ones.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Three 1TB solid state scorchers up for grabs
Big SSDs can be expensive but think big and think free because you could be the lucky winner of one of three 1TB Samsung SSD 840 EVO drives that we’re giving away worth over £300 apiece.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.