System and method for calculation using formulas in number fields
First Claim
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 plurality of numeric values comprise a mathematical formula entered into a formula number field of the plurality of number fields;
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;
automatically calculating a first result of the mathematical formula;
automatically calculating a second result applying the mathematical operators to the first result and the numeric values other than the mathematical formula; and
displaying the second result on the display screen.
0 Assignments
0 Petitions
Accused Products
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.
52 Citations
42 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 plurality of numeric values comprise a mathematical formula entered into a formula number field of the plurality of number fields;
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;
automatically calculating a first result of the mathematical formula;
automatically calculating a second result applying the mathematical operators to the first result and the numeric values other than the mathematical formula; and
displaying the second result on the display screen. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
displaying the first result on the display screen in the formula 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,
wherein the number fields and the operation fields are displayed in adjacent columns which share a first single column label. -
5. 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.
-
-
6. 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.
-
-
7. 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.
-
-
8. 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.
-
9. The method of claim 8, 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.
-
-
10. 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.
- and
-
11. The method of claim 1,
wherein the 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 formula number field to the numeric values preceding the formula number field.
-
12. 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 plurality of numeric values comprise a mathematical formula entered into a formula number field of the plurality of number fields;
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;
automatically calculate a first result of the mathematical formula;
automatically calculate a second result by applying the mathematical operators to the first result and the numeric values other than the mathematical formula; and
display the second result on the display screen. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
display the first result on the display screen in the formula number field in which the mathematical formula was entered.
-
-
14. The system of claim 13,
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. -
15. The system of claim 12,
wherein the number fields and the operation fields are displayed in adjacent columns which share a first single column label. -
16. The system of claim 12, 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.
-
-
17. The system of claim 12,
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.
-
-
18. The system of claim 12, 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.
-
-
19. The system of claim 12, 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.
-
20. The system of claim 19, 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.
-
-
21. The system of claim 12,
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.
- and
-
22. The system of claim 12,
wherein the 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 formula number field to the numeric values preceding the formula number field.
-
23. 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 plurality of numeric values comprise mathematical formula entered into a formula number field of the plurality of number fields;
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;
automatically calculating a first result of the mathematical formula;
automatically calculating a second result by applying the mathematical operators to the first result and the numeric values other than the mathematical formula; and
displaying the second result on the display screen. - View Dependent Claims (24, 25, 26, 27, 28, 29, 30, 31, 32, 33)
displaying the first result on the display screen in the formula number field in which the mathematical formula was entered.
-
-
25. The carrier medium of claim 24,
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. -
26. The carrier medium of claim 23,
wherein the number fields and the operation fields are displayed in adjacent columns which share a first single column label. -
27. The carrier medium of claim 23, 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.
-
-
28. The carrier medium of claim 23,
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.
-
-
29. The carrier medium of claim 23, 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.
-
-
30. The carrier medium of claim 23, 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.
-
31. The carrier medium of claim 30, 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.
-
-
32. The carrier medium of claim 23,
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.
- and
-
33. The carrier medium of claim 23,
wherein the 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 formula number field to the numeric values preceding the formula number field.
-
34. 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 plurality of numeric values comprise a mathematical formula;
entering an equality character after entering the mathematical formula;
automatically calculating a first result of the mathematical formula;
displaying the mathematical formula and the first result of the mathematical formula in one of the number fields after the entering the equality character;
automatically calculating a second result, wherein the second result is based on the first result and the numeric values other than the mathematical formula; and
displaying the second result on the display screen.
-
-
35. 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 in at least a first column and a second column on a display screen, wherein the plurality of numeric values comprise a mathematical formula;
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 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 mathematical formula;
displaying the second result 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. 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 plurality of numeric values comprise a mathematical formula entered into a formula number field of the plurality of number fields, wherein the mathematical formula comprises a subtotal function;
automatically calculating a first result of the mathematical formula by substituting a subtotal result for the subtotal function, and wherein the subtotal result is calculated by applying the mathematical operators preceding the formula number field to the numeric values preceding the formula number field;
automatically calculating a second result, wherein the second result is based on the first result and the numeric values other than the mathematical formula; and
displaying the second result on the display screen.
-
-
37. 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 plurality of numeric values comprise a mathematical formula;
receive into the memory an equality character after the mathematical formula is received into the memory;
automatically calculate a first result of the mathematical formula;
display the mathematical formula and the first result of the mathematical formula in one of the number fields after the equality character is received into the memory;
automatically calculate a second result, wherein the second result is based on the first result and the numeric values other than the mathematical formula; and
display the second result on the display screen.
-
-
38. 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 in at least a first column and a second column on the display screen, wherein the plurality of numeric values comprise a mathematical formula;
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 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 mathematical formula;
display the second result 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.
-
-
39. 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 plurality of numeric values comprise a mathematical formula entered into a formula number field of the plurality of number fields, wherein the mathematical formula comprises a subtotal function;
automatically calculate a first result of the mathematical formula by substituting a subtotal result for the subtotal function, wherein the subtotal result is calculated by applying the mathematical operators preceding the formula number field to the numeric values preceding the formula number field;
automatically calculate a second result, wherein the second result is based on the first result and the numeric values other than the mathematical formula; and
display the second result on the display screen.
-
-
40. 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 plurality of numeric values comprise a mathematical formula;
receiving into the memory an equality character after the receiving into the memory the mathematical formula;
automatically calculating a first result of the mathematical formula;
displaying the mathematical formula and the first result of the mathematical formula in one of the number fields after the receiving into the memory the equality character;
automatically calculating a second result, wherein the second result is based on the first result and the numeric values other than the mathematical formula; and
displaying the second result on the display screen.
-
-
41. 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 in at least a first column and a second column on a display screen, wherein the plurality of numeric values comprise a mathematical formula;
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 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 mathematical formula;
displaying the second result 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.
-
-
42. 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 plurality of numeric values comprise a mathematical formula entered into a formula number field of the plurality of number fields, wherein the mathematical formula comprises a subtotal function;
automatically calculating a first result of the mathematical formula by substituting a subtotal result for the subtotal function, and wherein the subtotal result is calculated by applying the mathematical operators preceding the formula number field to the numeric values preceding the formula number field;
automatically calculating a second result, wherein the second result is based on the first result and the numeric values other than the mathematical formula; and
displaying the second result on the display screen.
-
Specification