Method and system for treating data

• US 7,814,407 B1
• Filed: 10/26/2006
• Issued: 10/12/2010
• Est. Priority Date: 10/26/2006
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: MacQueen, John D., Danner, Matthew P.
• Primary Examiner(s): HUYNH, CONG LAC T
• Application Number:
  US11/553,138
• Time in Patent Office: 1,447 Days
• Field of Search: 715/212, 715/219, 715/220, 715/216, 715/213
• US Class Current: 715/213
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A method for displaying and employing data includes: (a) Defining an array of data sites in a first domain. The defining includes establishing procedures for manipulating the data located at the data sites. (b) Importing the data from a data source in a second domain to the array. (c) Installing the data in selected the data sites according to predetermined installation criteria. The employing is effected according to the procedures for manipulating.

Claims

1. A method for treating data comprising:

(a) establishing an array in a first domain with a plurality of cells arranged in a plurality of rows and a plurality of columns;

said establishing being effected according to a defining protocol establishing criteria regarding selected cells of said plurality of cells;

(b) selecting said data from a data source in a second domain;

(c) entering said data in said array in respective cells of said plurality of cells according to predetermined placement criteria; and

(d) substantially as entered data arrives in said array, validating said entered data to impose conformance with predetermined characteristics in said first domain, wherein validating includes removing non-numeric characters from said data and truncating numerical data to a predetermined decimal place.

2. A method for treating data as recited in claim 1 wherein said first domain is a web-configured domain.

3. A method for treating data as recited in claim 2 wherein particular cells of said plurality of cells are totaling cells;

a respective totaling cell being filled with calculated data indicating a total of selected cells within a respective row of said plurality of rows containing said respective totaling cell, or a total of selected cells within a respective column of said plurality of columns containing said respective totaling cell;

said predetermined placement criteria precluding entering said data in a respective totaling cell.

4. A method for treating data as recited in claim 2 wherein manipulation of said data in said array is effected according to functions associated with said array.

5. A method for treating data as recited in claim 1 wherein particular cells of said plurality of cells are totaling cells;

a respective totaling cell being filled with calculated data indicating a total of selected cells within a respective row of said plurality of rows containing said respective totaling cell, or a total of selected cells within a respective column of said plurality of columns containing said respective totaling cell;

said predetermined placement criteria precluding entering said data in a respective totaling cell.

6. A method for treating data as recited in claim 1 wherein manipulation of said data in said array is effected according to functions associated with said array.

7. A method for displaying and employing data;

the method comprising;

(a) defining an array of data sites in a first domain;

said defining including establishing procedures for manipulating said data located at said data sites;

(b) importing said data from a data source in a second domain to selected said data sites according to predetermined installation criteria;

(c) employing said imported data according to said procedures for manipulating; and

(d) validating said data to impose conformance with predetermined characteristics in said first domain, wherein said validating includes removing non-numeric characters from said data and truncating numeric data to a predetermined decimal place.

8. A method for displaying and employing data as recited in claim 7 wherein said first domain is a web-configured domain.

9. A method for displaying and employing data as recited in claim 8 wherein said array of data sites includes a plurality of cells arranged in a plurality of rows and a plurality of columns;

particular cells of said plurality of cells being totaling cells;

a respective totaling cell being filled with calculated data indicating a total of selected cells within a respective row of said plurality of rows containing said respective totaling cell, or a total of selected cells within a respective column of said plurality of columns containing said respective totaling cell;

said installation criteria precluding entering said data in a respective totaling cell.

10. A computer program product including a medium with computer program code for treating data embodied therein, the computer program code comprising:

(a) instructions for establishing an array in a first domain with a plurality of cells arranged in a plurality of rows and a plurality of columns;

said establishing being effected according to a defining protocol establishing criteria regarding selected cells of said plurality of cells;

(b) instructions for selecting said data from a data source in a second domain;

(c) instructions for entering said data in said array in respective cells of said plurality of cells according to predetermined placement criteria; and

(d) instructions for substantially as entered data arrives in said array, validating said entered data to impose conformance with predetermined characteristics in said first domain, wherein validating includes removing non-numeric characters from said data and truncating numeric data to a predetermined decimal place.

11. A computer program product as recited in claim 10 wherein said first domain is a web-configured domain.

12. A computer program product as recited in claim 11 wherein particular cells of said plurality of cells are totaling cells;

a respective totaling cell being filled with calculated data indicating a total of selected cells within a respective row of said plurality of rows containing said respective totaling cell, or a total of selected cells within a respective column of said plurality of columns containing said respective totaling cell;

said predetermined placement criteria precluding entering said data in a respective totaling cell.

13. A computer program product as recited in claim 11 wherein manipulation of said data in said array is effected according to functions associated with said array.

14. A computer program product as recited in claim 10 wherein particular cells of said plurality of cells are totaling cells;

a respective totaling cell being filled with calculated data indicating a total of selected cells within a respective row of said plurality of rows containing said respective totaling cell, or a total of selected cells within a respective column of said plurality of columns containing said respective totaling cell;

said predetermined placement criteria precluding entering said data in a respective totaling cell.

15. A computer program product as recited in claim 10 wherein manipulation of said data in said array is effected according to functions associated with said array.