English
Related papers

Related papers: How do you know your spreadsheet is right?

200 papers

Version information plays an important role in spreadsheet understanding, maintaining and quality improving. However, end users rarely use version control tools to document spreadsheet version information. Thus, the spreadsheet version…

Software Engineering · Computer Science 2017-04-28 Liang Xu , Wensheng Dou , Chushu Gao , Jie Wang , Jun Wei , Hua Zhong , Tao Huang

Model checking real-time systems is complex, and requires a careful trade-off between including enough detail to be useful and not too much detail to avoid state explosion. This work exploits variability of the formal model being analysed…

Software Engineering · Computer Science 2023-11-01 José Proença , David Pereira , Giann Spilere Nandi , Sina Borrami , Jonas Melchert

The spreadsheet paradigm has some unique risks and challenges that are not present in more traditional development technologies. Many of the recent advances in other branches of software development have bypassed spreadsheets and…

Software Engineering · Computer Science 2024-12-31 Simon Murphy

The difficulties of automatic extraction of definitions and methods from scientific documents lie in two aspects: (1) the complexity and diversity of natural language texts, which requests an analysis method to support the discovery of…

Computation and Language · Computer Science 2023-07-06 Yutian Sun , Hai Zhuge

Document coherence describes how much sense text makes in terms of its logical organisation and discourse flow. Even though coherence is a relatively difficult notion to quantify precisely, it can be approximated automatically. This type of…

Information Retrieval · Computer Science 2016-08-03 Christina Lioma , Fabien Tarissan , Jakob Grue Simonsen , Casper Petersen , Birger Larsen

Although experts diverge on how best to improve spreadsheet quality, it is generally agreed that more time needs to be spent testing spreadsheets. Ideally, experienced and trained spreadsheet engineers would carry this out, but quite often…

Software Engineering · Computer Science 2010-09-16 Ruth McKeever , Kevin McDaid

Knowing the printer model used to print a given document may provide a crucial lead towards identifying counterfeits or conversely verifying the validity of a real document. Inkjet printers produce probabilistic droplet patterns that appear…

Computer Vision and Pattern Recognition · Computer Science 2024-07-16 Patrick Takenaka , Manuel Eberhardinger , Daniel Grießhaber , Johannes Maucher

Students learning how to apply spreadsheets to accounting problems are not always well served by the built-in financial functions. Problems can arise because of differences between UK and US practice, through anomalies in the functions…

Software Engineering · Computer Science 2008-05-29 Andrew Hawker

In this paper, we propose a novel one-shot template-matching algorithm to automatically capture data from business documents with an aim to minimize manual data entry. Given one annotated document, our algorithm can automatically extract…

Information Retrieval · Computer Science 2019-10-23 Pranjal Dhakal , Manish Munikar , Bikram Dahal

Textbooks on statistics emphasize care and precision, via concepts such as reliability and validity in measurement, random sampling and treatment assignment in data collection, and causal identification and bias in estimation. But how do…

Methodology · Statistics 2013-07-24 Andrew Gelman , Keith O'Rourke

Much of what EuSpRIG discusses is concerned with the integrity of individual spreadsheets. In businesses, interlocking spreadsheets are regularly used to fill functional gaps in core administrative systems. The growth and deployment of such…

Other Computer Science · Computer Science 2008-03-10 Keith Bishop

This paper describes a new type of spreadsheet which mitigates the errors caused by incorrect range referencing in formulae. This spreadsheet is composed of structured worksheets called tables which contain a hierarchical organization of…

Software Engineering · Computer Science 2014-01-31 Ted Hawkins , Andrew Lemon , Alec Gibson

Several complexity metrics are described which are related to logic structure, data structure and size of spreadsheet models. They primarily concentrate on the dispersion of cell references and cell paths. Most metrics are newly defined,…

Software Engineering · Computer Science 2008-02-28 Andrej Bregar

All users of spreadsheets struggle with the problem of errors. Errors are thought to be prevalent in spreadsheets, and in some instances they have cost organizations millions of dollars. In a previous study of 50 operational spreadsheets we…

Computers and Society · Computer Science 2024-12-31 Stephen G. Powell , Barry Lawson , Kenneth R. Baker

The problem of change detection in images finds application in different domains like diagnosis of diseases in the medical field, detecting growth patterns of cities through remote sensing, and finding changes in legal documents and…

Computer Vision and Pattern Recognition · Computer Science 2023-07-18 Abhinandan Kumar Pun , Mohammed Javed , David S. Doermann

Spreadsheet tables are often labeled, and these labels effectively constitute types for the data in the table. In such cases tables can be considered to be built from typed data where the placement of values within the table is controlled…

Software Engineering · Computer Science 2018-09-11 Martin Erwig

Writing formulas on spreadsheets, such as Microsoft Excel and Google Sheets, is a widespread practice among users performing data analysis. However, crafting formulas on spreadsheets remains a tedious and error-prone task for many…

Computation and Language · Computer Science 2024-02-26 Wei Zhao , Zhitao Hou , Siyuan Wu , Yan Gao , Haoyu Dong , Yao Wan , Hongyu Zhang , Yulei Sui , Haidong Zhang

This thesis advances the computational understanding and manipulation of text styles through three interconnected pillars: (1) Text Style Transfer (TST), which alters stylistic properties (e.g., sentiment, formality) while preserving…

Computation and Language · Computer Science 2025-07-23 Zhiqiang Hu

When designing circuits, engineers obtain the information of electronic devices by browsing a large number of documents, which is low efficiency and heavy workload. The use of artificial intelligence technology to automatically parse…

Computer Vision and Pattern Recognition · Computer Science 2025-02-25 Hong Cai Chen , Longchang Wu , Yang Zhang

Document-level models for information extraction tasks like slot-filling are flexible: they can be applied to settings where information is not necessarily localized in a single sentence. For example, key features of a diagnosis in a…

Computation and Language · Computer Science 2022-05-19 Liyan Tang , Dhruv Rajan , Suyash Mohan , Abhijeet Pradhan , R. Nick Bryan , Greg Durrett