Detecting and visualizing inter-worksheet smells in spreadsheets

No abstract is available for this paper.

• Publication year

  2011

• Venue

  International Conference on Software Engineering

• Publication date

  2011-06-02

• Fields of study

  Business, Computer Science

• Identifiers
  DOI 10.1109/ICSE.2012.6227171
• External record

  Open on Semantic Scholar

• Source metadata

  Semantic Scholar

• No claims are published for this paper.

• No concepts are published for this paper.

• Deriving metric thresholds from benchmark data

  2010influential reference
• Supporting professional spreadsheet users by generating leveled dataflow diagrams

  2010influential reference
• Automatically Extracting Class Diagrams from Spreadsheets

  2010cited by this paper
• Discovery-based edit assistance for spreadsheets

  2009cited by this paper
• The evolution and impact of code smells: A case study of two open source systems

  2009cited by this paper
• Errors in Operational Spreadsheets: A Review of the State of the Art

  2009cited by this paper
• Mining Spreadsheet Complexity Data to Classify End User Developers

  2009cited by this paper
• Complexity Metrics for Spreadsheet Models

  2008cited by this paper
• Detecting Errors in Spreadsheets

  2008cited by this paper
• Metrics-Based Spreadsheet Visualization: Support for Focused Maintenance

  2008cited by this paper
• The State of the Art in End-User Software Engineering

  2008cited by this paper
• Inferring templates from spreadsheets

  2006cited by this paper
• The EUSES spreadsheet corpus: a shared resource for supporting experimentation with spreadsheet dependability mechanisms

  2005cited by this paper
• Object-Oriented Metrics in Practice

  2005influential reference
• Detecting design flaws via metrics in object-oriented systems

  2001cited by this paper
• Using a structured design approach to reduce risks in end user spreadsheet development

  2000cited by this paper
• What we know about spreadsheet errors

  1998cited by this paper
• Modeling Optimization Problems in the Unstructured World of Spreadsheets

  1997cited by this paper
• Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model

  1994cited by this paper
• The spreadsheet interface: A basis for end user programming

  1990cited by this paper
• Organizational Factors Affecting the Success of End-User Computing

  1986cited by this paper

• Enhanced neighborhood metric for spreadsheet fault prediction

  2025cites this paper
• To Abstract or Not to Abstract? A Comparative Study Evaluating the User Experience of Spreadsheet Programming with Sheet-Defined Functional Abstractions

  2024cites this paper
• Spreadsheet quality assurance: a literature review

  2024cites this paper
• Spreadsheets in Secondary School Statistics Education: Using Authentic Data for Computational Thinking

  2023cites this paper
• Usability Smells: A Systematic Review

  2021cites this paper
• SpreadsheetCoder: Formula Prediction from Semi-structured Context

  2021cites this paper
• Metric-Based Fault Prediction for Spreadsheets

  2021influential citation
• Semantic table structure identification in spreadsheets

  2021cites this paper
• WARDER: Towards E ective Spreadsheet Defect Detection by Validity-based Cell Cluster Re nements

  2020cites this paper
• WARDER: Towards effective spreadsheet defect detection by validity-based cell cluster refinements

  2020cites this paper
• Learning to detect table clones in spreadsheets

  2020cites this paper
• XLBlocks: a Block-based Formula Editor for Spreadsheet Formulas

  2019cites this paper
• Automated Reporting of Anti-Patterns and Decay in Continuous Integration

  2019cites this paper
• The Robot Operating System: Package reuse and community dynamics

  2019cites this paper
• Spreadsheet Smells: A Systematic Mapping Study

  2019influential citation
• WARDER: Refining Cell Clustering for Effective Spreadsheet Defect Detection via Validity Properties

  2019cites this paper
• Expandable Group Identification in Spreadsheets

  2018cites this paper
• Detecting faulty empty cells in spreadsheets

  2018cites this paper
• Second Order Interactive End User Development Appropriation in the Public Sector: Application Development Using Spreadsheet Programs

  2018cites this paper
• Model-based simulation of legal policies: framework, tool support, and validation

  2018cites this paper
• No half-measures: A study of manual and tool-assisted end-user programming tasks in Excel

  2018cites this paper
• ExceLint: automatically finding spreadsheet formula errors

  2018cites this paper
• How are spreadsheet templates used in practice: a case study on Enron

  2018cites this paper
• Now You're Thinking With Structures: A Concept for Structure-based Interactions with Spreadsheets

  2018cites this paper
• Fritz: A Tool for Spreadsheet Quality Assurance

  2018cites this paper
• Calculation View: multiple-representation editing in spreadsheets

  2018cites this paper
• On the Refinement of Spreadsheet Smells by means of Structure Information

  2018cites this paper
• Code smells

  2018cites this paper
• Combining Spreadsheet Smells for Improved Fault Prediction

  2018influential citation
• SpreadCluster: Recovering Versioned Spreadsheets through Similarity-Based Clustering

  2017cites this paper
• Parsing Excel formulas: A grammar and its application on 4 large datasets

  2017influential citation
• The Effect of Delocalized Plans on Spreadsheet Comprehension: A Controlled Experiment

  2017cites this paper
• How effectively can spreadsheet anomalies be detected: An empirical study

  2017cites this paper
• When and Why Your Code Starts to Smell Bad

  2017cites this paper
• Which Smell-based Metrics Affect Spreadsheet Performance? An Analysis of Four Datasets

  2017cites this paper
• CACheck: Detecting and Repairing Cell Arrays in Spreadsheets

  2017cites this paper
• Automated refactoring of nested-IF formulae in spreadsheets

  2017cites this paper
• A Model-Based Framework for Legal Policy Simulation and Compliance Checking

  2017cites this paper
• An arc-based approach for visualization of code smells

  2017cites this paper
• Smelly Relations: Measuring and Understanding Database Schema Quality

  2017cites this paper
• Combining Models for Improved Fault Localization in Spreadsheets

  2017cites this paper
• Spectrum-based Diagnosis for Run-time Systems

  2016cites this paper
• A Survey on Software Fault Localization

  2016cites this paper
• Spreadsheets are Code: An Overview of Software Engineering Approaches Applied to Spreadsheets

  2016cites this paper
• Metamodels and Feature Models: Complementary Approaches to Formalize Product Comparison Matrices. (Méta-modèles et modèles de caractéristiques: deux approches complémentaires pour formaliser les matrices de comparaison de produits)

  2016cites this paper
• CUSTODES: Automatic Spreadsheet Cell Clustering and Smell Detection Using Strong and Weak Features

  2016cites this paper
• Perquimans: A Tool for Visualizing Patterns of Spreadsheet Function Combinations

  2016cites this paper
• EXACT: A tool for comprehending VBA‐based Excel spreadsheet applications

  2016cites this paper
• Detecting table clones and smells in spreadsheets

  2016cites this paper
• Bad smell refactor removable detection of audit spreadsheet

  2016cites this paper
• Do code smells hamper novice programming? A controlled experiment on Scratch programs

  2016cites this paper
• Smells in block-based programming languages

  2016cites this paper
• Combining Smells and Fault Localization in Spreadsheets

  2016cites this paper
• Static Spreadsheet Analysis

  2016cites this paper
• The Effect of Delocalized Plans on the Maintainability of Spreadsheets A Controlled Experiment

  2016cites this paper
• Automatic detection of bad smells from excel sheets and refactor for performance improvement

  2016cites this paper
• Model-based diagnosis of spreadsheet programs: a constraint-based debugging approach

  2016cites this paper
• A Literature Review of Spreadsheet Technology

  2016influential citation
• Evaluating refactorings for spreadsheet models

  2016cites this paper
• VEnron: A Versioned Spreadsheet Corpus and Related Evolution Analysis

  2016cites this paper
• Detecting problematic lookup functions in spreadsheets

  2015cites this paper
• Static Analysis of Spreadsheet Applications for Type-Unsafe Operations Detection

  2015cites this paper
• Enron versus EUSES: A Comparison of Two Spreadsheet Corpora

  2015cites this paper
• Embedding, Evolution, and Validation of Model-Driven Spreadsheets

  2015cites this paper
• Towards a catalog of usability smells

  2015cites this paper
• Code smells in spreadsheet formulas revisited on an industrial dataset

  2015cites this paper
• Using Calculation Fragments for Spreadsheet Testing and Debugging

  2015cites this paper
• Fault Localization in the Light of Faulty User Input

  2015cites this paper
• A grammar for spreadsheet formulas evaluated on two large datasets

  2015cites this paper
• When and Why Your Code Starts to Smell Bad (and Whether the Smells Go Away)

  2015cites this paper
• Tool-assisted Spreadsheet Refactoring and Parsing Spreadsheet Formulas

  2015cites this paper
• A model-based framework for probabilistic simulation of legal policies

  2015cites this paper
• Refactoring Smelly Spreadsheet Models

  2014cites this paper
• Streamlining Code Smells: Using Collective Intelligence and Visualization

  2014cites this paper
• Spreadsheets are Models Too [ Position Statement ]

  2014cites this paper
• Streamlining Code Smells: Using Collective Intelligence and Visualization

  2014cites this paper
• Avoiding, finding and fixing spreadsheet errors - A survey of automated approaches for spreadsheet QA

  2014cites this paper
• Comparing or configuring products: are we getting the right ones?

  2014cites this paper
• BumbleBee: a refactoring environment for spreadsheet formulas

  2014cites this paper
• On the empirical evaluation of similarity coefficients for spreadsheets fault localization

  2014cites this paper
• Measuring and visualizing energy consumption within software code

  2014cites this paper
• Tool-supported fault localization in spreadsheets: Limitations of current evaluation practice

  2014cites this paper
• Repatterning: Improving the Reliability of Android Applications with an Adaptation of Refactoring

  2014cites this paper
• FaultySheet Detective: When Smells Meet Fault Localization

  2014cites this paper
• Smelling Faults in Spreadsheets

  2014cites this paper
• Why Does my Spreadsheet Compute Wrong Values?

  2014cites this paper
• Financial Analysis of Mining Investments Employing FAST Modeling Standard

  2014cites this paper
• On the Usage of Dependency-based Models for Spreadsheet Debugging

  2014cites this paper
• Anonymizing spreadsheet data and metadata with anonymousXL

  2014cites this paper
• A Maintainability Checklist for Spreadsheets

  2014cites this paper
• Refactoring Meets Model-Driven Spreadsheet Evolution

  2014influential citation
• Automating the formalization of product comparison matrices

  2014cites this paper
• Is spreadsheet ambiguity harmful? detecting and repairing spreadsheet smells due to ambiguous computation

  2014cites this paper
• Enron's Spreadsheets and Related Emails: A Dataset and Analysis

  2014cites this paper
• Generation of Relevant Spreadsheet Repair Candidates

  2014cites this paper
• Spreadsheet Engineering

  2013cites this paper
• Copy-Paste Detection in Spreadsheets

  2013cites this paper
• The Right Choice Matters! SMT Solving Substantially Improves Model-Based Debugging of Spreadsheets

  2013cites this paper
• Data clone detection and visualization in spreadsheets

  2013cites this paper
• Central European Functional Programming School

  2013cites this paper