Excel 2010/2013 add-in that automatically finds errors in spreadsheets
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
CheckCell
CheckCellSetup
CheckCellTests
DataDebugMethods
LongestCommonSubsequence
MTurkParser
Properties
Resources
UserSimulation
packages
parcel @ cfd0f4c
.gitignore
.gitmodules
COPYING
DataDebug.sln
DataDebug.vsmdi
DataDebug_2_TemporaryKey.pfx
README.md

README.md

CheckCell

Testing and static analysis can help root out bugs in programs, but not in data. We introduce data debugging, an approach that combines program analysis and statistical analysis to automatically find potential data errors. Since it is impossible to know a priori whether data are erroneous, data debugging instead locates data that has a disproportionate impact on the computation. Such data is either very important or wrong. Data debugging is especially useful in the context of data-intensive programming environments that intertwine data with programs in the form of queries or formulas.

CheckCell is an implementation of data debugging for Excel spreadsheets. CheckCell highlights suspected errors in red, one cell at a time. After inspecting a cell, the user can correct the data or marked the cell as 'OK'. CheckCell is efficient; its algorithms are asymptotically optimal, and the current prototype runs in seconds for most spreadsheets.

License

CheckCell is licensed under the GPLv2, Copyright (C) 2011-2015 The University of Massachusetts Amherst.

Prerequisites

You will need Microsoft Excel 2010 and Windows 7 or newer. CheckCell now supports Excel 2013!

Installing CheckCell

Download the CheckCell installer. Double-click on the file CheckCellInstaller.exe to install. The installer should install all prerequisites for you (namely Microsoft .NET 4.0 and Visual Studio Tools for Office 2010).

You will find CheckCell installed in Excel, under the "CheckCell" tab in the ribbon.

Getting CheckCell Source

CheckCell depends on an Excel parsing library called "Parcel", also available on GitHub. Parcel is a git submodule for CheckCell. This means that you should recursively clone the CheckCell repository if you plan to work with the source:

git clone --recursive https://github.com/plasma-umass/DataDebug.git

You will need Visual Studio 2013 in order to build the CheckCell plugin.

Using CheckCell

To use CheckCell, open the spreadsheet you would like to audit, and click CheckCell's "Analyze" button (look for the "CheckCell" tab in the ribbon.) CheckCell will perform its analysis, and if any potential errors are found, they will be highlighted one at a time in decreasing order of importance. For each highlighted cell, you will have to decide if it is actually an error. If so, click on the "Fix Error" button and enter the correct value in the box that comes up. Otherwise, click the "Mark as OK" button. After each correction, CheckCell will re-run its analysis using the corrected value.

CheckCell's sensitivity level is adjustable. By default it is set to display the top 5% most unusual values, but you may change it by entering a different value in the box labeled "% Most Unusual to Show". Note that CheckCell may report that no values warrant special attention.

Uninstalling CheckCell

CheckCell can be uninstalled in the Windows Add/Remove Programs dialog.

Read the Paper

"CheckCell: Data-Debugging for Spreadsheets." D. Barowy, D. Gochev, E. Berger. OOPSLA 2014, Portland, OR.