System and method for calculation using formulas in number fields

• US 20020140734A1
• 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,742,162 B2
• Time in Patent Office: Days
• US Class Current: 345/764
• 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 a plurality of numeric values in a plurality of number fields, wherein the plurality of number fields are displayed in columnar format on a display screen, wherein the numeric values comprise at least one mathematical formula;

automatically calculating a first result of the mathematical formula;

automatically calculating a second result, wherein the second result is based on the first result and the numeric values other than the at least one mathematical formula; and

displaying the second result on the display screen.

2. The method of claim 1, further comprising:

displaying the first result on the display screen in the number field in which the mathematical formula was entered.

3. The method of claim 2,

wherein the displaying the second result on the display screen comprises displaying the second result in a same column as the plurality of numeric values.

4. The method of claim 1, further comprising:

entering a set of one or more mathematical operators in one or more operation fields, wherein the operation fields are displayed in columnar format on the display screen; and

wherein the automatically calculating the second result comprises applying the mathematical operators to the first result and the numeric values other than the at least one mathematical formula.

5. The method of claim 4,

wherein the number fields and the operation fields are displayed in adjacent columns which share a first single column label.

6. The method of claim 1, further comprising:

entering a first character string which is associated with one of the numeric values; and

displaying the first character string in a comment field adjacent to the numeric value.

7. The method of claim 1,

wherein the entering the numeric values comprises:

entering a first numeric value in a number field in an upper line;

automatically shifting an entry point to a number field in a lower line; and

entering a next numeric value in the number field in the lower line.

8. The method of claim 1, further comprising:

determining a first set of output character strings based on the numeric values; and

displaying the first set of output character strings in the number fields.

9. The method of claim 1, further comprising:

displaying the mathematical formula and the first result of the mathematical formula in one of the number fields.

10. The method of claim 9, further comprising:

entering an equality character after entering the mathematical formula; and

wherein the displaying the first result of the mathematical formula comprises displaying the first result after the entering the equality character.

11. The method of claim 1,

wherein the plurality of number fields are displayed in at least a first column and a second column on the display screen;

and

wherein the method further comprises;

entering a set of one or more mathematical operators in one or more operation fields, wherein the operation fields are displayed in columnar format in at least the first column and the second column on the display screen;

automatically calculating a third result by applying the mathematical operators in the operation fields in the second column to the numeric values in the number fields in the second column; and

displaying the third result on the display screen.

12. The method of claim 1,

wherein the at least one mathematical formula comprises a subtotal function, wherein the automatically calculating the first result comprises substituting a subtotal result for the subtotal function, and wherein the subtotal result is calculated by applying the mathematical operators preceding the number field with the mathematical formula to the numeric values preceding the number field with the mathematical formula.

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

display the first result on the display screen in the number field in which the mathematical formula was entered.

15. The system of claim 14,

wherein the displaying the second result on the display screen comprises displaying the second result in a same column as the plurality of numeric values.

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

receive into the memory a set of one or more mathematical operators in one or more operation fields, wherein the operation fields are displayed in columnar format on the display screen; and

wherein the automatically calculating the second result comprises applying the mathematical operators to the first result and the numeric values other than the at least one mathematical formula.

17. The system of claim 16,

wherein the number fields and the operation fields are displayed in adjacent columns which share a first single column label.

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

receive into the memory a first character string which is associated with one of the numeric values; and

display the first character string in a comment field adjacent to the numeric value.

19. The system of claim 13,

wherein in the receiving into the memory the numeric values, the program instructions are further executable by the CPU to:

receive into the memory a first numeric value in a number field in an upper line;

automatically shift an entry point to a number field in a lower line; and

receive into the memory a next numeric value in the number field in the lower line.

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

determine a first set of output character strings based on the numeric values; and

display the first set of output character strings in the number fields.

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

display the mathematical formula and the first result of the mathematical formula in one of the number fields.

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

receive into the memory an equality character after the receiving into the memory the mathematical formula; and

wherein the displaying the first result of the mathematical formula comprises displaying the first result after the receiving into the memory the equality character.

23. The system of claim 13,

wherein the plurality of number fields are displayed in at least a first column and a second column on the display screen;

and

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

receive into the memory a set of one or more mathematical operators in one or more operation fields, wherein the operation fields are displayed in columnar format in at least the first column and the second column on the display screen;

automatically calculate a third result by applying the mathematical operators in the operation fields in the second column to the numeric values in the number fields in the second column; and

display the third result on the display screen.

24. The system of claim 13,

wherein the at least one mathematical formula comprises a subtotal function, wherein the automatically calculating the first result comprises substituting a subtotal result for the subtotal function, and wherein the subtotal result is calculated by applying the mathematical operators preceding the number field with the mathematical formula to the numeric values preceding the number field with the mathematical formula.

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

displaying the first result on the display screen in the number field in which the mathematical formula was entered.

27. The carrier medium of claim 26,

wherein the displaying the second result on the display screen comprises displaying the second result in a same column as the plurality of numeric values.

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

receiving into the memory a set of one or more mathematical operators in one or more operation fields, wherein the operation fields are displayed in columnar format on the display screen; and

wherein the automatically calculating the second result comprises applying the mathematical operators to the first result and the numeric values other than the at least one mathematical formula.

29. The carrier medium of claim 28,

wherein the number fields and the operation fields are displayed in adjacent columns which share a first single column label.

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

receiving into the memory a first character string which is associated with one of the numeric values; and

displaying the first character string in a comment field adjacent to the numeric value.

31. The carrier medium of claim 25,

wherein the receiving into the memory the numeric values comprises:

receiving into the memory a first numeric value in a number field in an upper line;

automatically shifting an entry point to a number field in a lower line; and

receiving into the memory a next numeric value in the number field in the lower line.

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

determining a first set of output character strings based on the numeric values; and

displaying the first set of output character strings in the number fields.

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

displaying the mathematical formula and the first result of the mathematical formula in one of the number fields.

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

receiving into the memory an equality character after the receiving into the memory the mathematical formula; and

wherein the displaying the first result of the mathematical formula comprises displaying the first result after the receiving into the memory the equality character.

35. The carrier medium of claim 25,

wherein the plurality of number fields are displayed in at least a first column and a second column on the display screen;

and

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

receiving into the memory a set of one or more mathematical operators in one or more operation fields, wherein the operation fields are displayed in columnar format in at least the first column and the second column on the display screen;

automatically calculating a third result by applying the mathematical operators in the operation fields in the second column to the numeric values in the number fields in the second column; and

displaying the third result on the display screen.

36. The carrier medium of claim 25,

wherein the at least one mathematical formula comprises a subtotal function, wherein the automatically calculating the first result comprises substituting a subtotal result for the subtotal function, and wherein the subtotal result is calculated by applying the mathematical operators preceding the number field with the mathematical formula to the numeric values preceding the number field with the mathematical formula.

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;

receive into the memory a plurality of numeric values in a plurality of number fields, wherein the plurality of number fields are displayed in columnar format on the display screen, wherein the numeric values comprise at least one mathematical formula;

automatically calculate a first result of the mathematical formula;

automatically calculate a second result, wherein the second result is based on the first result and the numeric values other than the at least one mathematical formula; and

display the second result on the display screen.

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

receiving into a memory a plurality of numeric values in a plurality of number fields, wherein the plurality of number fields are displayed in columnar format on a display screen, wherein the numeric values comprise at least one mathematical formula;

automatically calculating a first result of the mathematical formula;

automatically calculating a second result, wherein the second result is based on the first result and the numeric values other than the at least one mathematical formula; and

displaying the second result on the display screen.