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 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.
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.
-
Citations
36 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36)
-
-
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.
-
Specification