Search
Search Results
-
Analyzing Induced Functional Dependencies from Spreadsheets in the GF Framework for Ontology-Based Data Access
Expressing information from spreadsheets as relational databases is crucial in the context of ontology-based data access as it facilitates structured...
-
Using Power BI to Find Inconsistent Data Between Excel Spreadsheets
This example solves a challenge that confronted my wife, Sue, in her job in human resources. She had to reconcile large spreadsheets taken from...
-
TabbyLD: A Tool for Semantic Interpretation of Spreadsheets Data
Spreadsheets are one of the most convenient ways to structure and represent statistical and other data. In this connection, automatic processing and...
-
SpLyCI: Integrating Spreadsheets by Recognising and Solving Layout Constraints
Valuable data are often spread out over different similar spreadsheets. Consolidating this data for further analysis can take considerable effort for...
-
Spreadsheet quality assurance: a literature review
Spreadsheets are very common for information processing to support decision making by both professional developers and non-technical end users....
-
Higher-Order Spreadsheets with Spilled Arrays
We develop a theory for two recently-proposed spreadsheet mechanisms: gridlets allow for abstraction and reuse in spreadsheets, and build on spilled...
-
VisualSynth: Democratizing Data Science in Spreadsheets
We introduce VisualSynth, a framework that wants to democratize data science by enabling naive end-users to specify the data science tasks that match...
-
Specification of the Schema of Spreadsheets for the Materialization of Ontologies from Integrated Data Sources
In Ontology-Based Data Access (OBDA), a knowledge base known as an ontology models both the problem domain and the underlying data sources. We are...
-
Puncalc: task-based parallelism and speculative reevaluation in spreadsheets
Spreadsheets are commonly declarative, first-order functional programs and are used as organizational tools, for end-user development and for...
-
Extracting from Data Sources
In the dynamic landscape of data-driven decision-making, information resides in diverse corners of the digital world. Whether it's buried in...
-
FLINK: An Educator’s Tool for Linking Inaccurate Student Records
Although many areas within the education sector have been subjected to digitalization, including electronic storage and processing of student...
-
Working with Excel Files
This chapter introduces the openpyxl module that can be used when working with Excel files. Excel is a software application developed by Microsoft...
-
Mixed Synchronous/Asynchronous Control Structures
This Chapter investigates some paradigms of MIXED SYNCHRONOUS/ASYNCHRONOUS COMPUTATIONS: bulk synchronous parallel and streaming control at various...
-
Getting Input from the User
All programs, such as word processors, spreadsheets, and databases, must accept input from the user. In video games, players commonly control a game...
-
Development of the Polyglot Asian Medicine Knowledge Graph System
The Polyglot Asian Medicine system hosts a research database of Asian traditional and herbal medicines, represented as a knowledge graph and...
-
Principles of Communication-Effective Use of Color
The guidelines discussed in this chapter will apply not only to graphs, plots, and charts but also to tabular reports, spreadsheets, web pages, maps,...
-
What’s an Array, Anyway?
Good question. That term – array – has secured a foothold in all sorts of computing vocabularies and has made a series of guest appearances in the...
-
Cell Classification for Layout Recognition in Spreadsheets
Spreadsheets compose a notably large and valuable dataset of documents within the enterprise settings and on the Web. Although spreadsheets are...
-
Static Partitioning of Spreadsheets for Parallel Execution
Spreadsheets are popular tools for end-user development and complex modelling but can suffer from poor performance. While end-users are usually...