Spreadsheets based on interval constraint satisfaction

Eero Hyvönen

Research output: Contribution to journalArticleScientificpeer-review

1 Citation (Scopus)

Abstract

Spreadsheets are difficult to use in applications, where only incomplete or inexact data (e.g., intervals) are available-a typical situation in various design and planning tasks. It can be argued that this is due to two fundamental shortcomings of the computational paradigm underlying spreadsheets. First, the distinction between input and output cells has to be fixed before computations. Second, cells may have only exact values. As a result, spread-sheets support the user only with primitive iterative problem solving schemes based on trial-and-error methods. A constraint-based computational paradigm for next generation interval spreadsheets is presented. The scheme makes it possible to exploit incomplete/inexact data (intervals), and it can support problem solving in a top-down fashion. Current spreadsheets constitute a special case of the more general interval constraint spreadsheets proposed.
Original languageEnglish
Pages (from-to)27-34
Number of pages8
JournalArtificial Intelligence for Engineering Design, Analysis and Manufacturing: AI EDAM
Volume8
Issue number1
DOIs
Publication statusPublished - 1994
MoE publication typeA1 Journal article-refereed

Fingerprint

Spreadsheets
Planning

Cite this

@article{30d1bf3b73b2459480630678f8aa7bcf,
title = "Spreadsheets based on interval constraint satisfaction",
abstract = "Spreadsheets are difficult to use in applications, where only incomplete or inexact data (e.g., intervals) are available-a typical situation in various design and planning tasks. It can be argued that this is due to two fundamental shortcomings of the computational paradigm underlying spreadsheets. First, the distinction between input and output cells has to be fixed before computations. Second, cells may have only exact values. As a result, spread-sheets support the user only with primitive iterative problem solving schemes based on trial-and-error methods. A constraint-based computational paradigm for next generation interval spreadsheets is presented. The scheme makes it possible to exploit incomplete/inexact data (intervals), and it can support problem solving in a top-down fashion. Current spreadsheets constitute a special case of the more general interval constraint spreadsheets proposed.",
author = "Eero Hyv{\"o}nen",
note = "Project code: TTE2103",
year = "1994",
doi = "10.1017/S0890060400000433",
language = "English",
volume = "8",
pages = "27--34",
journal = "Artificial Intelligence for Engineering Design, Analysis and Manufacturing: AI EDAM",
issn = "0890-0604",
publisher = "Academic Press",
number = "1",

}

Spreadsheets based on interval constraint satisfaction. / Hyvönen, Eero.

In: Artificial Intelligence for Engineering Design, Analysis and Manufacturing: AI EDAM, Vol. 8, No. 1, 1994, p. 27-34.

Research output: Contribution to journalArticleScientificpeer-review

TY - JOUR

T1 - Spreadsheets based on interval constraint satisfaction

AU - Hyvönen, Eero

N1 - Project code: TTE2103

PY - 1994

Y1 - 1994

N2 - Spreadsheets are difficult to use in applications, where only incomplete or inexact data (e.g., intervals) are available-a typical situation in various design and planning tasks. It can be argued that this is due to two fundamental shortcomings of the computational paradigm underlying spreadsheets. First, the distinction between input and output cells has to be fixed before computations. Second, cells may have only exact values. As a result, spread-sheets support the user only with primitive iterative problem solving schemes based on trial-and-error methods. A constraint-based computational paradigm for next generation interval spreadsheets is presented. The scheme makes it possible to exploit incomplete/inexact data (intervals), and it can support problem solving in a top-down fashion. Current spreadsheets constitute a special case of the more general interval constraint spreadsheets proposed.

AB - Spreadsheets are difficult to use in applications, where only incomplete or inexact data (e.g., intervals) are available-a typical situation in various design and planning tasks. It can be argued that this is due to two fundamental shortcomings of the computational paradigm underlying spreadsheets. First, the distinction between input and output cells has to be fixed before computations. Second, cells may have only exact values. As a result, spread-sheets support the user only with primitive iterative problem solving schemes based on trial-and-error methods. A constraint-based computational paradigm for next generation interval spreadsheets is presented. The scheme makes it possible to exploit incomplete/inexact data (intervals), and it can support problem solving in a top-down fashion. Current spreadsheets constitute a special case of the more general interval constraint spreadsheets proposed.

U2 - 10.1017/S0890060400000433

DO - 10.1017/S0890060400000433

M3 - Article

VL - 8

SP - 27

EP - 34

JO - Artificial Intelligence for Engineering Design, Analysis and Manufacturing: AI EDAM

JF - Artificial Intelligence for Engineering Design, Analysis and Manufacturing: AI EDAM

SN - 0890-0604

IS - 1

ER -