System and method for calculation using vertical parentheses

• US 20020143810A1
• Filed: 03/28/2001
• Published: 10/03/2002
• Est. Priority Date: 03/28/2001
• Status: Active Grant

• Current Assignee: Paul W. Bennett
• Original Assignee: Paul W. Bennett
• Inventors: Bennett, Paul W.
• Granted Patent: US 6,961,898 B2
• 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:

entering one or more mathematical operators;

entering a plurality of numeric values;

displaying the mathematical operators in one or more operation fields in columnar format down at least one of a plurality of rows on a display screen;

displaying the numeric values in a plurality of number fields in columnar format down the plurality of rows on the display screen;

entering an open parenthesis character in an upper row;

entering a close parenthesis character in a lower row, wherein the lower row is displayed below the upper row on the display screen;

automatically calculating a result by applying the set of mathematical operators to the set of numeric values and by following an order of evaluation which respects the open and close parentheses;

displaying the result on the display screen.

2. The method of claim 1,

wherein the entering the open parenthesis character in the upper row comprises entering the open parenthesis character in one of the number fields in the upper row.

3. The method of claim 1,

wherein the entering the close parenthesis character in the lower row comprises entering the close parenthesis character in one of the number fields in the lower row.

4. The method of claim 1,

wherein the entering the open parenthesis character in the upper row comprises entering the open parenthesis character in one of the operation fields in the upper row.

5. The method of claim 1,

wherein the entering the close parenthesis character in the lower row comprises entering the close parenthesis character in one of the operation fields in the lower row.

6. The method of claim 1, further comprising:

entering one or more comment strings; and

displaying the comment strings in one or more comment fields in columnar format down the at least one of the plurality of rows on the display screen.

7. The method of claim 6,

wherein the entering the open parenthesis character in the upper row comprises entering the open parenthesis character in one of the comment fields in the upper row.

8. The method of claim 6,

wherein the entering the close parenthesis character in the lower row comprises entering the close parenthesis character in one of the comment fields in the lower row.

9. The method of claim 1,

wherein the operation fields and the number fields are comprised in a first column;

and

wherein the method further comprises;

displaying a single column label for the first column, wherein the single column label spans the width of one of the operation fields and one of the number fields.

10. The method of claim 1,

wherein the operation fields and number fields are comprised in a plurality of columns.

11. 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;

receive into the memory one or more mathematical operators;

receive into the memory a plurality of numeric values;

display the mathematical operators in one or more operation fields in columnar format down at least one of a plurality of rows on the display screen;

display the numeric values in a plurality of number fields in columnar format down the plurality of rows on the display screen;

receive into the memory an open parenthesis character in an upper row;

receive into the memory a close parenthesis character in a lower row, wherein the lower row is displayed below the upper row on the display screen;

automatically calculate a result by applying the set of mathematical operators to the set of numeric values and by following an order of evaluation which respects the open and close parentheses;

display the result on the display screen.

12. The system of claim 11,

wherein the receiving into the memory the open parenthesis character in the upper row comprises receiving into the memory the open parenthesis character in one of the number fields in the upper row.

13. The system of claim 11,

wherein the receiving into the memory the close parenthesis character in the lower row comprises receiving into the memory the close parenthesis character in one of the number fields in the lower row.

14. The system of claim 11,

wherein the receiving into the memory the open parenthesis character in the upper row comprises receiving into the memory the open parenthesis character in one of the operation fields in the upper row.

15. The system of claim 11,

wherein the receiving into the memory the close parenthesis character in the lower row comprises receiving into the memory the close parenthesis character in one of the operation fields in the lower row.

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

receive into the memory one or more comment strings; and

display the comment strings in one or more comment fields in columnar format down the at least one of the plurality of rows on the display screen.

17. The system of claim 16,

wherein the receiving into the memory the open parenthesis character in the upper row comprises receiving into the memory the open parenthesis character in one of the comment fields in the upper row.

18. The system of claim 16,

wherein the receiving into the memory the close parenthesis character in the lower row comprises receiving into the memory the close parenthesis character in one of the comment fields in the lower row.

19. The system of claim 11,

wherein the operation fields and the number fields are comprised in a first column;

and

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

display a single column label for the first column, wherein the single column label spans the width of one of the operation fields and one of the number fields.

20. The system of claim 11,

wherein the operation fields and number fields are comprised in a plurality of columns.

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

receiving into a memory one or more mathematical operators;

receiving into the memory a plurality of numeric values;

displaying the mathematical operators in one or more operation fields in columnar format down at least one of a plurality of rows on a display screen;

displaying the numeric values in a plurality of number fields in columnar format down the plurality of rows on the display screen;

receiving into the memory an open parenthesis character in an upper row;

receiving into the memory a close parenthesis character in a lower row, wherein the lower row is displayed below the upper row on the display screen;

automatically calculating a result by applying the set of mathematical operators to the set of numeric values and by following an order of evaluation which respects the open and close parentheses;

displaying the result on the display screen.

22. The carrier medium of claim 21,

wherein the receiving into the memory the open parenthesis character in the upper row comprises receiving into the memory the open parenthesis character in one of the number fields in the upper row.

23. The carrier medium of claim 21,

wherein the receiving into the memory the close parenthesis character in the lower row comprises receiving into the memory the close parenthesis character in one of the number fields in the lower row.

24. The carrier medium of claim 21,

wherein the receiving into the memory the open parenthesis character in the upper row comprises receiving into the memory the open parenthesis character in one of the operation fields in the upper row.

25. The carrier medium of claim 21,

wherein the receiving into the memory the close parenthesis character in the lower row comprises receiving into the memory the close parenthesis character in one of the operation fields in the lower row.

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

receiving into the memory one or more comment strings; and

displaying the comment strings in one or more comment fields in columnar format down the at least one of the plurality of rows on the display screen.

27. The carrier medium of claim 26,

wherein the receiving into the memory the open parenthesis character in the upper row comprises receiving into the memory the open parenthesis character in one of the comment fields in the upper row.

28. The carrier medium of claim 26,

wherein the receiving into the memory the close parenthesis character in the lower row comprises receiving into the memory the close parenthesis character in one of the comment fields in the lower row.

29. The carrier medium of claim 21,

wherein the operation fields and the number fields are comprised in a first column;

and

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

displaying a single column label for the first column, wherein the single column label spans the width of one of the operation fields and one of the number fields.

30. The carrier medium of claim 21,

wherein the operation fields and number fields are comprised in a plurality of columns.