Spreadsheets Versus Compliance

Michael Vizard

One of the core issues that plagues most companies is their over reliance on spreadsheets to run the business. The spreadsheet is probably one of the greatest applications ever invented. But like most things, too much of any one thing is invariably a bad thing.

In the case of the spreadsheet, so much business activity is tracked on spreadsheets that it becomes almost impossible to do any meaningful analysis. And from a compliance perspective, trying to audit conflicting spreadsheet data that is wrapped up in all kinds of undocumented macro code can be a nightmare.

For these reasons, providers of business intelligence applications have been arguing that companies should rely less on spreadsheets. But end users are deeply attached to their spreadsheet applications and resist any effort to move them away from their spreadsheets. This will be doubly true as Microsoft contines to embedd more BI capabilities into its Excel spreadsheet.

But ActionBase, in partnership with ClusterSeven, announced today a way to bridge the spreadsheet divide when it comes to compliance. ActionBase, which provides workflow management software, and ClusterSeven, which provides spreadsheet management software, are creating a joint offering that provides a way to overlay a compliance framework on a plethora of Microsoft Excel spreadsheet applications.

According to ActionBase's Jacob Ukelson, the real challenge is to create a framework for compliance that doesn't get in the way of how people want to work. Requiring them to first, pay for, and then master a new application will always be met with a high degree of resistance. Instead, Ukelson argues that the IT department must come up with ways to meet compliance requirements without imposing unnatural ways of accomplishing tasks.

That doesn't mean that IT organizations shouldn't use other tools such as business intelligence applications, adds ClusterSeven director Henry Umney. But it does mean that IT organizations need to recognize that spreadsheets will always be part of the workflow process, he notes.

The tension between compliance requirements and productivity has always been a corporate issue. But time and again, it seems like productivity always trumps compliance. So rather than fight a losing battle, the better part valor is to find a way to do what needs to be done from a compliance perspective in the most unobtrusive way possible.

Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.


Add Comment      Leave a comment on this blog post
Dec 1, 2010 10:08 AM Allie Gentry Allie Gentry  says:

Being a co-founder and CTO of a business intelligence software product the biggest piece that companies miss when supply front end solution is the performance on the back-end. Up until recently, companies had to build their own patented technologies for performance gains because the cube processing took alot of time  in addition increase in services is needed in an OLAP model.  There is a company in the industry called Fuzzy Logix that I believe is going to really hit a home run on the DB side of things. There is nothing in the market that will beat their performance. They use what they call Artificial Intelligence with over 800 algorithms on the core database and these algorithms get smarter as the data gets used. If that does not get you interested, what made me interested along with this is the system will provide you analytics, predictive modeling and data mining within your database. With no deterioration on your hardware.  So if you get a chance check them out http://www.fuzzyl.com. 


Post a comment





(Maximum characters: 1200). You have 1200 characters left.




Subscribe Daily Edge Newsletters

Sign up now and get the best business technology insights direct to your inbox.

Subscribe Daily Edge Newsletters

Sign up now and get the best business technology insights direct to your inbox.