search

plasma-umass / DataDebug

Excel 2010/2013 add-in that automatically finds errors in spreadsheets
http://checkcell.org
GNU General Public License v2.0
48 stars 6 forks source link

Address the concerns brought up by John Slankas #58

Closed dbarowy closed 9 years ago

dbarowy commented 10 years ago

Good morning,

I am part of a group that's putting together a larger corpus of Excel Spreadsheet documents. We are trying to use CheckCell to see how random samples of our corpus compared to the execution times you reported for your random sampling of 30 documents from EUSES.

I have installed the add-in onto a virtual machine running Windows 7 and Office 2010 with 16gb RAM.

I am running into a couple of issues with the plug-in, though. 1) For some files, Excel uses over 7gb of RAM with the add-in installed for a spreadsheet file with 4400 cells. Is this normal? 2) While the add-appears to be installed, I'm not seeing any cells highlighted after clicking "Analyze". I've tried multiple files from our corpus, manually entered the Georgia school system file based upon Figure 1 in your paper, and inject errors into other spreadsheets. Can you send me a test file with a known set of errors that should appear so I can validate my install.

Thank you -

John Slankas Senior Research Scholar Laboratory for Analytic Sciences North Carolina State University Centennial Campus | 1021 Main Campus Drive, Raleigh, NC 27606 Poulton Innovation Center | Room 200 | Campus Box 7007 704-650-1069

dbarowy commented 9 years ago

Issue #1 fixed by 35fad9b61bc255fa9504cfe2129d1f6a396e158b. CheckCell uses substantially less memory now and highlights an error in the spreadsheet John is referring to (chris_germany__1729__2000ces07.xls, sent via private email).

Will open additional issues for #2 if I can reproduce them.