Invention Grant
- Patent Title: Automated structured cloud datatester
-
Application No.: US14918887Application Date: 2015-10-21
-
Publication No.: US10664653B2Publication Date: 2020-05-26
- Inventor: Bruce E. Villard, Jr. , Henry C. Will, IV
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Daugherty & Del Zoppo Co., LPA
- Agent Patrick J. Daugherty
- Main IPC: G06F40/18
- IPC: G06F40/18 ; G06F40/103 ; H04L29/08

Abstract:
Data in different, respective ranges of spreadsheet file cells is compared, and a scope of a formula determined with respect to selected cells of the ranges of cells, wherein the formula pulls input data from selected cells of one range of cells and either pulls input data or generates output data to selected cells of the other range of cells. A review flag is automatically generated in association with data in a flagged cell in response to determining: that the flagged cell is omitted from a consecutive plurality of input data rows or columns; that the selected formula input cells are not consecutive within one of the ranges of cells; and that a high percentage of data values in corresponding cell rows or columns match but that and a location of the flagged cell is shifted from a corresponding cell within the other range.
Public/Granted literature
- US20170116171A1 AUTOMATED STRUCTURED CLOUD DATATESTER Public/Granted day:2017-04-27
Information query