Browse Prior Art Database

SPREADSHEET CORRELATOR SOFMARE

IP.com Disclosure Number: IPCOM000006878D
Original Publication Date: 1993-Jun-01
Included in the Prior Art Database: 2002-Feb-08
Document File: 1 page(s) / 54K

Publishing Venue

Motorola

Related People

Eyal Katz: AUTHOR

Abstract

When analyzing multiple sets of data and where each set consists of different types of data, such as the four blocks of tests A, B, C and D within the three sets of tests 1.2 and 3 in the diagram below:- -t- case Window-Size-tests) and the arrangement com- pares these windows to determine which ones are valid windows. Then each test row of a valid window is checked to see ifit complies with the required test results. Finally a check is made to see if all test rows within the window are valid. If so, the set has conformed to the test.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 86% of the total text.

Page 1 of 1

MOTOROLA INC. Technical Developments Volume 19 June 1993

SPREADSHEET CORRELATOR SOFMARE

by Eyal Katz

  When analyzing multiple sets of data and where each set consists of different types of data, such as the four blocks of tests A, B, C and D within the three sets of tests 1.2 and 3 in the diagram below:-

-t-

case Window-Size-tests) and the arrangement com- pares these windows to determine which ones are valid windows. Then each test row of a valid window is checked to see ifit complies with the required test results. Finally a check is made to see if all test rows within the window are valid. If so, the set has conformed to the test.

1

A

B C D

it would be most efficient if one were to process all the A's together, then all the B's and so on, and then find whether all of the tests in each set have passed at the end A three dimensional spreadsheet arrangement could perform this global processing of the data blocks, but many platforms do not support a 3D arrangement and when the set size is very large, 3D arrangements become impractical. This invention allows a similar process to be possible for conventional two dimensional spread- sheets, such as Lotus l-2-3 and Microsoft Excel.

  The arrangement systematically applies a single fonc- tion to each row of data. This function synchronizes itself on blocks of rows in a correlation manner, ana- lyzing the data and processing the results only once per block.

  The flow diagram below shows an exemplary oper- ation of the inven...