Logical Spreadsheets

Stanford Reference:

04-076

Abstract

Applications

• Managing, editing and manipulating numerical and symbolic data
• Design programs, particularly for system configurations (including customer designed cars or computers)
• Smart forms capable of checking that entered data is within correct parameters and formatting. An HTML front end can be used for the logical spreadsheet to put the form online
• Manipulating and organizing more complex data sets
• Interactive documents capable of evaluating data and changes in circumstances and providing feedback to the user
• Simulations where the user can experiment by varying inputs or setup variables, which will cause the effects of the changes to propagate through the spreadsheet to give the resulting outcome or situation

Advantages

• Adds significant capabilities and power compared to standard spreadsheets while maintaining the ease of use spreadsheets are known for
• Allows value propagation in multiple directions through the spreadsheet, unlike the unidirectional value propagation in standard spreadsheets
• Allows the specification of many to many constraints, rather than the simple function constraints in traditional spreadsheets
• Permits manipulation of non-numeric data
• Provides easier data entry and checking
• Makes data analysis tasks easier and less time consuming

Publications

• Logic Group Publication

Innovators & Portfolio

• Michael Genesereth   more technologies from Michael Genesereth »
• Michael Kassoff   
• Nathaniel Love   

Patent Status

• Published Application: 20060048044
• Issued : 7,707,486 (USA)

Date Released

Licensing Contact

02-215   Population Clustering for Analyzing Flow Cytometry and Other Large Data Sets 02-263   An Improved Method for Visualization of Multidimensional Data ("Logicle") 03-334A   Virtual Machines for Administering Computers-Patent more technologies »