Logical spreadsheet

Uses your system voice; voice and rate in settings.

Q6667508Snapshot

≈ 4 min read

Names in other languages

  • Українськалогічна електронна таблиця
  • EnglishLogical spreadsheet

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

A logical spreadsheet is a spreadsheet in which formulas take the form of logical constraints rather than function definitions. In traditional spreadsheet systems, such as Excel, cells are partitioned into "directly specified" cells and "computed" cells and the formulas used to specify the values of computed cells are "functional", i.e. for every combination of values of the directly specified cells, the formulas specify unique values for the computed cells. Logical Spreadsheets relax these restrictions by dispensing with the distinction between directly specified cells and computed cells and generalizing from functional definitions to logical constraints. As an illustration of the difference between traditional spreadsheets and logical spreadsheets, consider a simple numerical spreadsheet with three cells a, b, and c. Each cell accepts a single integer as value; and there is a formula stating that the value of the third cell is the sum of the values of the other two cells. Implemented as a traditional spreadsheet, this spreadsheet would allow the user to enter values into cells a and b, and it would automatically compute cell c. For example, if the user were to type 1 into a and 2 into b, it would compute the value 3 for c. Implemented as a logical spreadsheet, the user would be able to enter values into any of the cells.…

A logical spreadsheet is a spreadsheet in which formulas take the form of logical constraints rather than function definitions. In traditional spreadsheet systems, such as Excel, cells are partitioned into "directly specified" cells and "computed" cells and the formulas used to specify the values of computed cells are "functional", i.e. for every combination of values of the directly specified cells, the formulas specify unique values for the computed cells. Logical Spreadsheets relax these restrictions by dispensing with the distinction between directly specified cells and computed cells and generalizing from functional definitions to logical constraints. As an illustration of the difference between traditional spreadsheets and logical spreadsheets, consider a simple numerical spreadsheet with three cells a, b, and c. Each cell accepts a single integer as value; and there is a formula stating that the value of the third cell is the sum of the values of the other two cells. Implemented as a traditional spreadsheet, this spreadsheet would allow the user to enter values into cells a and b, and it would automatically compute cell c. For example, if the user were to type 1 into a and 2 into b, it would compute the value 3 for c. Implemented as a logical spreadsheet, the user would be able to enter values into any of the cells. The user could type 1 into a and 2 into b, and the spreadsheet would compute the value 3 for c. Alternatively, the user could type 2 into b and 3 into c, and the spreadsheet would compute the value 1 for a. And so forth. In this case, the formula is functional, and the function is invertible. In general, the formulas need not be functional and the functions need not be invertible. For example, in this case, we could write formulas involving inequalities and non-invertible functions (such as square root). More generally, we could build spreadsheets with symbolic, rather than numeric data, and write arbitrary logical constraints on this data. https://dbgroup.ncsu.edu/?p=9 http://logic.stanford.edu/spreadsheet/

Text derived from https://en.wikipedia.org/w/index.php?oldid=1377716214 under CC BY-SA 4.0; modifications have been made.

Provenance

snapshot logical-spreadsheet-754954-949627453832b80e · hash 949627453832b80e2e8b886210c8d46e4f4fbe4f4df0964547e415a1ab6d6f90 · captured 1790788961.0 · version history

Cite this page as: encyclopegia.org, “Logical spreadsheet”, snapshot logical-spreadsheet-754954-949627453832b80e. https://encyclopegia.org/a/logical-spreadsheet

Sources cited in this revision

No external citation was extracted for this revision. That is a statement about the source, not a claim that none exists.