A spreadsheet cell-meaning model for testing – Daniel Kulesz

Daniel starts with explaining what exactly he means with errors, defects and problems. According to IEEE the situation is like this: A user makes an error, which results in a fault in the spreadsheet, leading to a failure. For instance, if you enter a wrong number (error) there is a fault. But if no formulas Read more about A spreadsheet cell-meaning model for testing – Daniel Kulesz[…]

Overconfidence and Error Blindness Blindness – Ray Panko

The great spreadsheet paradox Ray call this ‘The great spreadsheet paradox’: People know that spreadsheets are error prone, but still companies do not see it. This is very much like the Gorilla Experiment, if you aren’t focusing on something, you literally do not see it. Furthermore, people really suffer from error blindness. When a study Read more about Overconfidence and Error Blindness Blindness – Ray Panko[…]

Spreadsheets are models too – Richard Paige

Rich’s idea is that spreadsheets are models too. The benefits of this could be: Use of generic tools (validation, transformation, merging) on spreadsheets People’s view of models will be broader than just EMF Support for large legacy models that will never be re-engineered (this is more common than you think, says RIch) Synergy with existing Read more about Spreadsheets are models too – Richard Paige[…]

Anonymizing Spreadsheet Data and Metadata with AnonymousXL – Joeri van Veen

Sometimes, people want to have their spreadsheet analyzed for errors or metrics, but they do not want to share their confidential data and formulas. This is where AnonymousXL comes in. With this tool you can remove all confidential stuff from your spreadsheet. First, AnonymousXL removes all meta data. That is an easy step. Then, numerical values are Read more about Anonymizing Spreadsheet Data and Metadata with AnonymousXL – Joeri van Veen[…]

Dependence tracing techniques for spreadsheets: an investigation – Sohon Roy

If you look at a spreadsheet, you do not see all the underlying dependencies. This is problematic, as users often have the need to see them, to fully understand the spreadsheet model. Sohon researches existing approaches for dependency tracing, but still work is still not used in practice. In practice people still use Excel, whose Read more about Dependence tracing techniques for spreadsheets: an investigation – Sohon Roy[…]