Interval computations on the spreadsheet

Eero Hyvönen; Stefano De Pascale

doi:10.1007/978-1-4613-3440-8_8

Interval computations on the spreadsheet

Eero Hyvönen, Stefano De Pascale

VTT Technical Research Centre of Finland

Research output: Chapter in Book/Report/Conference proceeding › Chapter or book article › Scientific › peer-review

Abstract

This paper reviews work on using interval arithmetic as the basis for next generation spreadsheet programs capable of dealing with rounding errors, imprecise data, and numerical constraints. A series of ever more versatile computational models for spreadsheets are presented beginning with classical interval arithmetic and ending with interval constraint satisfaction. In order to demonstrate the ideas, an actual implementation of each model as a class library is presented and its integration with a commercial spreadsheet program is explained.

Original language	English
Title of host publication	Applications of Interval Computations
Editors	R. Baker Kearfott, Vladik Kreinovich
Place of Publication	Dordrecht
Publisher	Kluwer Academic Publishers
Pages	169-209
ISBN (Electronic)	978-1-4613-3440-8
ISBN (Print)	978-1-4613-3442-2
DOIs	https://doi.org/10.1007/978-1-4613-3440-8_8
Publication status	Published - 1996
MoE publication type	A3 Part of a book or another research book

Access to Document

10.1007/978-1-4613-3440-8_8

Cite this

@inbook{4559d97b289640209ee56dfecd196427,

title = "Interval computations on the spreadsheet",

abstract = "This paper reviews work on using interval arithmetic as the basis for next generation spreadsheet programs capable of dealing with rounding errors, imprecise data, and numerical constraints. A series of ever more versatile computational models for spreadsheets are presented beginning with classical interval arithmetic and ending with interval constraint satisfaction. In order to demonstrate the ideas, an actual implementation of each model as a class library is presented and its integration with a commercial spreadsheet program is explained.",

author = "Eero Hyv{\"o}nen and {De Pascale}, Stefano",

year = "1996",

doi = "10.1007/978-1-4613-3440-8_8",

language = "English",

isbn = "978-1-4613-3442-2",

pages = "169--209",

editor = "Kearfott, {R. Baker} and Vladik Kreinovich",

booktitle = "Applications of Interval Computations",

publisher = "Kluwer Academic Publishers",

address = "Netherlands",

}

TY - CHAP

T1 - Interval computations on the spreadsheet

AU - Hyvönen, Eero

AU - De Pascale, Stefano

PY - 1996

Y1 - 1996

N2 - This paper reviews work on using interval arithmetic as the basis for next generation spreadsheet programs capable of dealing with rounding errors, imprecise data, and numerical constraints. A series of ever more versatile computational models for spreadsheets are presented beginning with classical interval arithmetic and ending with interval constraint satisfaction. In order to demonstrate the ideas, an actual implementation of each model as a class library is presented and its integration with a commercial spreadsheet program is explained.

AB - This paper reviews work on using interval arithmetic as the basis for next generation spreadsheet programs capable of dealing with rounding errors, imprecise data, and numerical constraints. A series of ever more versatile computational models for spreadsheets are presented beginning with classical interval arithmetic and ending with interval constraint satisfaction. In order to demonstrate the ideas, an actual implementation of each model as a class library is presented and its integration with a commercial spreadsheet program is explained.

U2 - 10.1007/978-1-4613-3440-8_8

DO - 10.1007/978-1-4613-3440-8_8

M3 - Chapter or book article

SN - 978-1-4613-3442-2

SP - 169

EP - 209

BT - Applications of Interval Computations

A2 - Kearfott, R. Baker

A2 - Kreinovich, Vladik

PB - Kluwer Academic Publishers

CY - Dordrecht

ER -

Interval computations on the spreadsheet

Abstract

Access to Document

Fingerprint

Cite this