Tue, May 29, 2007 13:19 EDT

Error-checking our lives

Topic: Applications

Blog: CIO Research Update

Current Rating: 5 Comments: 0

You know that curvy red line that some programs (like Word) draw under the words it thinks you have misspelled?

Imagine how cool it would be to have
a similar sort of error-checking for all the other areas of our life. Every time we got a name wrong, or forgot a birthday, or gave a chafing dish to a couple that never cooks, a wavy line would pop up in our field of vision, warning us that we just fumbled the ball.

One sphere of life that needs error-checking in the worst way is spreadsheets. It is very easy to make mistakes in spreadsheets since almost any value (in theory) can be entered into almost any cell, and almost any formula (again, in theory) could be associated with that or any other cell. The structure of a spreadsheet looks much the same everywhere. Thus it is very hard to pick out implausible entries at a glance. 

The result is that spreadsheets are rife with errors.  Indeed, some experts have claimed never to have seen a moderately complex spreadsheet without one or more, often many more, errors in it.

Given how important spreadsheets are to society this is obviously a situation crying out for redress.  But computers are even worse at perceiving deviations from patterns than humans are.  With all these degrees of freedom, how do you begin teaching an error checker the difference between right and wrong?

Recently a group of computer scientists at Oregon State University found an ingenious and possibly quite generalizable approach to the problem.  While the program (called GoalDebug; for "Goal Directed Debugging of Spreadsheets") cannot pick up raw errors -- we still have to rely on humans to do that -- it optimizes correction of those errors. 

GoalDebug is what is called an inference system -- in this case you flag an entry as an error and it infers how the error was made and therefore what the right value probably is. 

More specifically, suppose you spot an entry in a spreadsheet you think looks weird. You feed the entry to GoalDebug and enter the kind of value you would have expected to see. The program then lists the kinds of human errors that would have yielded this particular mistake (not the corrections, the categories of errors).

 You pick the

You do not have flash or javascript support.
Average (5 votes)
5
 

Post new comment

* Subject:
* Username:
* E-mail:
The content of this field is kept private and will not be shown publicly.
Homepage:
* Body:
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <strike> <p> <br>
  • Lines and paragraphs break automatically.
More information about formatting options

* Denotes required field.

About this Blog

Exclusive CIO magazine survey findings and links to other interesting research

Start a Conversation
Click to post

Got something to say? We want to hear it! Click the Post button to get started. GO»

EXPERT ADVICE
See our roster of experts.

Advice & Opinion from more than 117 of IT's most insightful thinkers.

  PARTNERS       WEBCASTS    
 

Register for more Windows Enterprise Webcasts today

Each month, Microsoft features a different customer or analyst discussing how Windows 7 and the Windows Optimized Desktop can impact your organization in positive ways, including helping IT to streamline management and manage risk while helping your employees increase productivity.

Sponsored by Microsoft  Listen to on-demand Recordings »

 

A Framework for Better Application Delivery

The complexity of application delivery is driven in part by the evolving applications environment. Instead of approaching application delivery from a siloed fashion, this handbook looks at end-to-end guidance and discusses the impact of ignoring the WAN, Web apps that are chatty, data center consolidation, SaaS, Web 2.0 and virtualization.

Sponsored by Riverbed  Read this White Paper »

 

Microsoft® Exchange 2010 includes archiving - but is it enough?

Microsoft® Exchange 2010 includes basic email archiving. But many organizations will find that it does not meet their requirements. This paper describes why organizations need to archive, what capabilities Exchange 2010 includes and why 3rd party archiving solutions will be necessary for most organizations.

Sponsored by Google, Inc.   Read this White Paper »

CIO's Virtualization Newsletter

Receive virtualization news on the latest technologies and developments, expert opinions on managing your data center and practical case studies for your next implementation.

CIO's Virtualization Newsletter

Receive virtualization news on the latest technologies and developments, expert opinions on managing your data center and practical case studies for your next implementation.

Enterprise Capture: Your Onramp to Business Process Automation

Today more than ever companies are seeking to reduce costs and...  View Now »

 

The True Cost of Legacy Systems

How well are you maximizing existing software assets? This webcast reveals the results of a commissioned study on top migration and modernization priorities for IT leaders.   View Now »

 

How To Maximize Your Virtualization Strategy and Deployment

Join award-winning technology journalist Stan Gibson in this webcast as he discusses how to enhance your virtualization strategy with the ROI, planning, implementation and platform advice. Exploit the business benefits of virtualization and successfully expand your current deployment.   View Now »

CIO's Virtualization Newsletter

Receive virtualization news on the latest technologies and developments, expert opinions on managing your data center and practical case studies for your next implementation.

 
Newsletter Sign-Up »

Receive the latest news test, reviews and trends on your favorite technology topics

Sponsored Links

Getting ready to upgrade to Windows 7? Attend Microsoft's Virtual Event on 4/22 for all the tools you'll need. Register Now!

Ready to create safe, business class social networking tools? View Now

Let Progress Software help your business make progress.

HP pays back. Trade in your old printer and get up to $1000

Read report on how to improve decision making with business analytics.

Dynamic Virtual Client: Whats in store for client technology going forward?

The ISP that focuses exclusively on information security? SecureWorks.

Supercharge Your End Users with Desktop Virtualization

Manage limitless content todayread EMCs 15-minute guide to ECM.

HP Exstream. Get a Free Document Assessment for Financial Services.

Take the Netezza TwinFin TestDrive!

Webinar: Jump-start your in-house e-discovery with Ringtail QuickCull from FTI Technology

See why ShoreTel is named best overall VoIP provider by Nemertes Research

Trend Micro ranked #1 against real-world malware. Read more.

Turn your desk phone and mobile phone into one with Sprint Mobile Integration.

Maximizing efficiencies with unified communications.

Stay informed with custom newsletters from Tech Dispenser

Attend Microsoft's Windows 7 Virutal Event for a change to win a Microsoft Zune HD. Register Now!

Register for more Windows Enterprise Webcasts today.

Build a smart, practical path to the internal cloud.

Selecting the Right Reporting Technology

An IT Leadership Action Plan for the Economic Recovery

Consolidate data centers and lower IT service costs. Learn How.

WAN optimization techniques significantly improve application performance. Read More.

The Revolution and Evolution of Private Cloud Computing

March 31st Webcast: "Product Development and the Cross-Functional Team"

Get to know Supermicro. Business-optimized server solutions.

Google Webinar: Why Cloud-Based Security and Archiving Make Sense

Midsized company CIOs and experts connect at infoBOOM!

Core" i5 vPro" Processor: Control meets cost savings in the most intelligent PC processors ever!

Article: The Dynamic Virtual Client offers thin client advantages with rich client user experience & mobility.

Counting Up the End User Benefits of Desktop Virtualization

Simplifying Risk Management: Is Your Company Measuring Up?

Does your IDS really work? Find out with a free Endace Audit

CA ARCserve r12.5 is More Than Backup! Download Trial Version Today

Verint Systems. Discover the Power of Intelligence in Action"

Enterprise search helps employees get more done. Get the facts from Google.

Best Practices to Reduce IT Operational Costs

Real-world testing ranks Trend Micro #1 against malware. See results.

Efficiency goes up. Costs come down.

Dark Fiber from Sunesys Save on Unlimited Bandwidth with Fixed Costs.

Trend Micro ranked #1 against real-world malware. Read more.

Get ready for your Windows 7 upgrade at this live, virtual event. Register Now!

Entrust IdentityGuard  Strong Authentication for your Enterprise

How Healthcare CIOs Achieve a High-Performance Emergency Department

Webcast: Solve Your Data Visualization Needs with Open Source BI

Webcast: Delivering the Enterprise-Ready Cloud

Ensure cost effective application delivery. Learn More.

Cloud Computing: The Impact CIOs See

What's New in SOA Suite 11g?