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.
|Title of host publication||Applications of Interval Computations|
|Editors||R. Baker Kearfott, Vladik Kreinovich|
|Place of Publication||Dordrecht|
|Publisher||Kluwer Academic Publishers|
|Publication status||Published - 1996|
|MoE publication type||A3 Part of a book or another research book|