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.
CheckCell is licensed under the GPLv2, Copyright (C) 2011-2015 The University of Massachusetts Amherst.
You will need Microsoft Excel 2010 and Windows 7 or newer. CheckCell now supports Excel 2013!
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.
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.
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.
CheckCell can be uninstalled in the Windows Add/Remove Programs dialog.
"CheckCell: Data-Debugging for Spreadsheets." D. Barowy, D. Gochev, E. Berger. OOPSLA 2014, Portland, OR.