Fuzzy spreadsheet data processing system
US5381517A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Sep 21, 1992 |
| Grant date | Jan 10, 1995 |
| Priority date | — |
| Expiry date | Sep 21, 2012 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S706/90
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A data processing system includes a memory with instructions and data stored therein. A fuzzy spreadsheet is stored in memory and has a plurality of cells, preferably arranged in columns and rows. The processor, stored instructions and stored data comprise a controller that receives input data and stores representations in cells. These representations include representations of fuzzy values. Operations, such as arithmetic operations, are performed on the data stored in the cells, including the fuzzy values, to produce derived representations that are stored in the cells and may be fuzzy values or crisp numbers or text. To facilitate a user's appreciation of a particular fuzzy number, the spreadsheet selectively simultaneously displays two representations of a fuzzy value, namely, a centroid and a graph. Also, the processor converts crisp numbers to fuzzy numbers by a procedure whereby a gallery of graphs stored in memory is displayed and, in response to user commands, at least three crisp numbers are associated with the graph. The processor also defuzzifies numbers by replacing a representation of a fuzzy number in a cell of the spreadsheet with a centroid.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.