System and method for calculation using multi-field columns with hidden fields

• US 20020143809A1
• Filed: 03/28/2001
• Published: 10/03/2002
• Est. Priority Date: 03/28/2001
• Status: Abandoned Application

• Current Assignee: Paul W. Bennett
• Original Assignee: Paul W. Bennett
• Inventors: Bennett, Paul W.
• Application Number:
  US09/820,442
• Publication Number:
  US 20020143809A1
• Time in Patent Office: Days
• US Class Current: 715/503
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Systems and methods for computer-based numerical calculation using a calcsheet are provided. A calcsheet may provide one or more columns for vertical calculation, each column having a plurality of fields including operation fields, number fields, and optional comment fields. The calcsheet may include multiple columns of vertical calculations. A user may type in calculations in a manner similar to the entry of calculations on a hand held calculator, and the calculations may be displayed in a vertical format in substantially any column. Number fields in a calcsheet may include mathematical formulas or references to other fields. A set of fields (such as all operation fields in a column, for example) may be hidden. The display order of fields may be altered. Parentheses spanning multiple rows may be used to alter the order of operations. Spreadsheet lines and vertical calculations may be used in a single document or display screen. Mathematical formulas may include a subtotal function which calculates a subtotal of the numeric values from preceding number fields.

Claims

1. A method comprising:

displaying a plurality of rows and at least one column in a matrix on a display screen, wherein the at least one column comprises a first set of fields and a second set of fields, wherein the first set of fields and the second set of fields comprise one or more mathematical operators and one or more numeric values, wherein each set of fields is displayed in columnar format down the plurality of rows in the at least one column, and wherein the at least one column comprises a single column label which spans the width of one of the first set of fields and one of the second set of fields;

automatically calculating a result by applying the mathematical operators to the numeric values;

displaying the result on the display screen;

entering user input to hide one of the sets of fields; and

redisplaying the at least one column by displaying the plurality of fields except for the hidden set of fields.

2. The method of claim 1, further comprising:

receiving user input to show the hidden set of fields; and

redisplaying the at least one column by displaying all of the sets of fields.

3. The method of claim 1,

wherein the at least one of the columns which comprises the first set of fields and a second set of fields further comprises a third set of fields.

4. The method of claim 1,

wherein the single column label is displayed at the top of the at least one column.

5. The method of claim 4,

wherein a first field label is displayed for the first set of fields below the single column label;

and

wherein a second field label is displayed for the second set of fields in a same row as the first field label below the single column label.

6. The method of claim 1,

wherein the first set of fields comprises one or more operation fields which display one or more mathematical operators.

7. The method of claim 1,

wherein the second set of fields comprises one or more operation fields which display one or more mathematical operators.

8. The method of claim 1,

wherein the first set of fields comprises one or more number fields which display one or more numeric values.

9. The method of claim 1,

wherein the second set of fields comprises one or more number fields which display one or more numeric values.

10. The method of claim 1,

wherein the first set of fields comprises one or more comment fields which display one or more comment strings.

11. The method of claim 1,

wherein the second set of fields comprises one or more comment fields which display one or more comment strings.

12. The method of claim 1,

wherein the displaying the plurality of rows and the at least one column comprises displaying a plurality of rows and at least two columns comprising a second column, wherein the second column comprises a third set of fields and a fourth set of fields, wherein the third set of fields and the fourth set of fields comprise a second set of one or more mathematical operators and a second set of one or more numeric values, and wherein the third set of fields and fourth set of fields are displayed in columnar format down the plurality of rows in the second column;

and

wherein the method further comprises;

automatically calculating a second result by applying the second set of mathematical operators to the second set of numeric values; and

displaying the second result on the display screen.

14. The system of claim 13, wherein the program instructions are further executable by the CPU to:

receive user input to show the hidden set of fields; and

redisplay the at least one column by displaying all of the sets of fields.

15. The system of claim 13,

wherein the at least one of the columns which comprises the first set of fields and a second set of fields further comprises a third set of fields.

16. The system of claim 13,

wherein the single column label is displayed at the top of the at least one column.

17. The system of claim 16,

wherein a first field label is displayed for the first set of fields below the single column label;

and

wherein a second field label is displayed for the second set of fields in a same row as the first field label below the single column label.

18. The system of claim 13,

wherein the first set of fields comprises one or more operation fields which display one or more mathematical operators.

19. The system of claim 13,

wherein the second set of fields comprises one or more operation fields which display one or more mathematical operators.

20. The system of claim 13,

wherein the first set of fields comprises one or more number fields which display one or more numeric values.

21. The system of claim 13,

wherein the second set of fields comprises one or more number fields which display one or more numeric values.

22. The system of claim 13,

wherein the first set of fields comprises one or more comment fields which display one or more comment strings.

23. The system of claim 13,

wherein the second set of fields comprises one or more comment fields which display one or more comment strings.

24. The system of claim 13,

wherein the displaying the plurality of rows and the at least one column comprises displaying a plurality of rows and at least two columns comprising a second column, wherein the second column comprises a third set of fields and a fourth set of fields, wherein the third set of fields and the fourth set of fields comprise a second set of one or more mathematical operators and a second set of one or more numeric values, and wherein the third set of fields and fourth set of fields are displayed in columnar format down the plurality of rows in the second column;

and

wherein the program instructions are further executable by the CPU to;

automatically calculate a second result by applying the second set of mathematical operators to the second set of numeric values; and

display the second result on the display screen.

26. The carrier medium of claim 25, wherein the program instructions are further executable by the computer to implement:

receiving user input to show the hidden set of fields; and

redisplaying the at least one column by displaying all of the sets of fields.

27. The carrier medium of claim 25,

wherein the at least one of the columns which comprises the first set of fields and a second set of fields further comprises a third set of fields.

28. The carrier medium of claim 25,

wherein the single column label is displayed at the top of the at least one column.

29. The carrier medium of claim 28,

wherein a first field label is displayed for the first set of fields below the single column label;

and

wherein a second field label is displayed for the second set of fields in a same row as the first field label below the single column label.

30. The carrier medium of claim 25,

wherein the first set of fields comprises one or more operation fields which display one or more mathematical operators.

31. The carrier medium of claim 25,

wherein the second set of fields comprises one or more operation fields which display one or more mathematical operators.

32. The carrier medium of claim 25,

wherein the first set of fields comprises one or more number fields which display one or more numeric values.

33. The carrier medium of claim 25,

wherein the second set of fields comprises one or more number fields which display one or more numeric values.

34. The carrier medium of claim 25,

wherein the first set of fields comprises one or more comment fields which display one or more comment strings.

35. The carrier medium of claim 25,

wherein the second set of fields comprises one or more comment fields which display one or more comment strings.

36. The carrier medium of claim 25,

wherein the displaying the plurality of rows and the at least one column comprises displaying a plurality of rows and at least two columns comprising a second column,

wherein the second column comprises a third set of fields and a fourth set of fields, wherein the third set of fields and the fourth set of fields comprise a second set of one or more mathematical operators and a second set of one or more numeric values, and wherein the third set of fields and fourth set of fields are displayed in columnar format down the plurality of rows in the second column;

and

wherein the program instructions are further executable by the computer to implement;

automatically calculating a second result by applying the second set of mathematical operators to the second set of numeric values; and

displaying the second result on the display screen.

13. A system comprising:

a CPU;

a display screen coupled to the CPU;

a memory coupled to the CPU, wherein the memory stores program instructions which are executable by the CPU to;

display a plurality of rows and at least one column in a matrix on the display screen, wherein the at least one column comprises a first set of fields and a second set of fields, wherein the first set of fields and the second set of fields comprise one or more mathematical operators and one or more numeric values, wherein each set of fields is displayed in columnar format down the plurality of rows in the at least one column, and wherein the at least one column comprises a single column label which spans the width of one of the first set of fields and one of the second set of fields;

automatically calculate a result by applying the mathematical operators to the numeric values;

display the result on the display screen;

receive user input to hide one of the sets of fields; and

redisplay the at least one column by displaying the plurality of fields except for the hidden set of fields.

25. A carrier medium comprising program instructions, wherein the program instructions are executable by a computer to implement:

displaying a plurality of rows and at least one column in a matrix on a display screen, wherein the at least one column comprises a first set of fields and a second set of fields, wherein the first set of fields and the second set of fields comprise one or more mathematical operators and one or more numeric values, wherein each set of fields is displayed in columnar format down the plurality of rows in the at least one column, and wherein the at least one column comprises a single column label which spans the width of one of the first set of fields and one of the second set of fields;

automatically calculating a result by applying the mathematical operators to the numeric values;

displaying the result on the display screen;

receiving user input to hide one of the sets of fields; and

redisplaying the at least one column by displaying the plurality of fields except for the hidden set of fields.