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.
and 26 Related for: Logical spreadsheet information
A logicalspreadsheet is a spreadsheet in which formulas take the form of logical constraints rather than function definitions. In traditional spreadsheet...
A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized...
"Community Edition" is available under the AGPL Simple Spreadsheet Tiki Wiki CMS Groupware includes a spreadsheet since 2004 and migrated to jQuery.sheet in 2010...
ISO 13584–35, Implementation resources: Spreadsheet interface for parts library. This part specifies a spreadsheet based exchange structure of ISO 13584-25...
representation and software engineering, as an enhancement to spreadsheets known as a Logicalspreadsheet, and for optimizing queries in a deductive database system...
example, if spreadsheet software is used often, the software will be moved to the flash storage for faster user access. In software, this logical volume speeds...
1.0 in May 1987 to 3.5 in 1993). Seen as the successor technology to spreadsheet software in reviews of the time, and rival to the then-dominant Lotus...
flickering interlace made reading text in word processor, database, or spreadsheet software difficult. (Modern game consoles solve this problem by pre-filtering...
expression or a condition. Relational operators can be seen as special cases of logical predicates. Equality is used in many programming language constructs and...
this case, to the mydict dictionary. Circular references also occur in spreadsheets when two cells require each other's result. For example, if the value...
Logical Machine Corporation (LOMAC), originally John Peers and Company, later Logical Business Machines, Inc., was a computer company active from the...
Office documents, spreadsheets and presentations (.docx/.doc, .xlsx/.xls and .pptx/.ppt respectively) and OpenDocument documents, spreadsheets and presentations...
through trial and improvement or more logical means. Basic goal seeking functionality is built into most modern spreadsheet packages such as Microsoft Excel...
such as. Degrees Celsius = (5/9)*(Degrees Fahrenheit - 32) In computer spreadsheet software, a formula indicating how to compute the value of a cell, say...
is often used to refer to any collection of related data (such as a spreadsheet or a card index) as size and usage requirements typically necessitate...
below. Boundary of system represents logical line that separates users from a system. It is used to determine logical transactions such as inputs and exits...
"Siemens contractor pleads guilty to planting logic bomb in company spreadsheets". ZDNet. Retrieved 9 September 2019. List, Jenny (6 December 2023). "The...
as reactive programming with spreadsheets. As a user enters new values, they are instantly transmitted to the next logical "actor" or formula for calculation...
activities Logical end points such as milestones or deliverable items Using these values, CPM calculates the longest path of planned activities to logical end...
occurs when one or more business analysts develop a system of linked spreadsheets to perform a business analysis, then grow it to a size and degree of...
can be programmed to automatically carry out sequences of arithmetic or logical operations (computation). Modern digital electronic computers can perform...
programming languages, notably Microsoft Excel, PlanMaker (and other spreadsheet applications) and the programming language bc, unary operations have...
under a database management system or other software such as electronic spreadsheets. In many smaller organizations, data administration is performed occasionally...
Logical Conjunction ("and"). The comma-separated values (CSV) format is very commonly used in exchanging text data between database and spreadsheet formats...
FOM, and with additional filtering options. Services for coordinating logical (simulation) time and time-stamped data exchange. Management services for...