# US 2005/0097464 A1 · Systems and methods for implementing formulas

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2005/0097464 A1
- Document ID: US20050097464A1
- Status: Published application
- Kind: A1
- Application number: 10/898,921
- Filed: 2004-07-27
- Published: 2005-05-05
- Earliest claimed: 2003-10-30
- Assignees: Sap SE
- Inventors: Astrid Graeber
- Web page: https://patentgrep.com/patent/US20050097464A1

## CPC

- G06Q 10/06315: {Needs-based resource requirements planning or analysis}
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06Q 10/04: Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem" (market predictions or forecasting for commercial activities G06Q30/0202)
- G06Q 10/06: Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Systems and methods are provided for building and implementing formulas. The systems and methods may treat operands in a formula as having a value and a unit type or dimension and may recognize the compatibility of unit types among operands. One embodiment performs automatic error checking of a formula based on the value and dimension of the operands and the expected result. The automatic error checking may be performed to assist a user in defining and building a formula. Another embodiment performs automatic unit conversion based on the value and unit type of the formula's operands. The automatic unit conversion may be performed when applying data to the formula during runtime or execution of an application program.

## Claims

### Claim 1

A method performed by a processor for building a formula, the formula including an operator and operands with associated dimensions, the method comprising:
receiving a first operand of the formula;
identifying a first dimension associated with the first operand;
receiving an operator of the formula;
determining at least one compatible dimension for the first dimension associated with the first operand;
receiving a second operand of the formula;
identifying a second dimension associated with the second operand; and
flagging an error if the second dimension is not at least one of the compatible dimensions for the first dimension.

### Claim 2 (depends on 1)

The method of claim 1, further comprising:
proposing a compatible dimension if the second dimension is determined not to be compatible, wherein proposing the compatible dimension comprises:
presenting the compatible dimension to a user; and
prompting a user to enter a second operand having the compatible dimension.

### Claim 3 (depends on 1)

The method of claim 1, wherein the at least one compatible dimension is the first dimension.

### Claim 4 (depends on 1)

The method of claim 1, further comprising:
evaluating an output of the formula, the output having a third dimension; and
wherein determining at least one compatible dimension for the first dimension comprises:
determining the at least one compatible dimension based upon the third dimension.

### Claim 5 (depends on 1)

The method of claim 1, wherein flagging an error comprises:
notifying a user that the second operand is not compatible with the first operand.

### Claim 6 (depends on 1)

The method of claim 1, wherein determining at least one compatible dimension comprises:
determining at least one compatible dimension based upon a set of rules for the operator.

### Claim 7 (depends on 1)

The method of claim 1, wherein determining at least one compatible dimension comprises:
determining at least one compatible dimension based upon a characteristic of the operator and the first dimension.

### Claim 8

A system for building a formula, the formula including an operator and operands with associated dimensions, comprising:
means for receiving a first operand of the formula;
means for identifying a first dimension associated with the first operand;
means for receiving an operator of the formula;
means for determining at least one compatible dimension for the first dimension associated with the first operand;
means for receiving a second operand of the formula;
means for identifying a second dimension associated with the second operand; and
means for flagging an error if the second dimension is not at least one of the compatible dimensions for the first dimension.

### Claim 9 (depends on 8)

The system of claim 8, further comprising:
means for proposing a compatible dimension if the second dimension is determined not to be compatible,
wherein the means for proposing the compatible dimension comprises:
means for presenting the compatible dimension to a user; and
means for prompting a user to enter a second operand having the compatible dimension.

### Claim 10 (depends on 8)

The system of claim 8, wherein the compatible dimension is the first dimension.

### Claim 11 (depends on 8)

The system of claim 8, further comprising:
means for evaluating an output of the formula, the output having a third dimension; and
wherein the means for determining at least one compatible dimension for the first dimension comprises:
means for determining the compatible dimension based upon the third dimension.

### Claim 12 (depends on 8)

The system of claim 8, wherein the means for flagging an error comprises:
means for notifying a user that the second operand is not compatible with the first operand.

### Claim 13 (depends on 8)

The system of claim 8, wherein the means for determining at least one compatible dimension comprises:
means for determining at least one compatible dimension based upon a set of rules for the operator.

### Claim 14 (depends on 8)

The system of claim 8, wherein the means for determining at least one compatible dimension comprises:
means for determining at least one compatible dimension based upon a characteristic of the operator and the first dimension.

### Claim 15

A computer program product for building a formula, the formula including an operator and operands with associated dimensions, comprising code for causing a processor to perform the steps of:
receiving a first operand of the formula;
identifying a first dimension associated with the first operand;
receiving an operator of the formula;
determining at least one compatible dimension for the first dimension associated with the first operand;
receiving a second operand of the formula;
identifying a second dimension associated with the second operand; and
flagging an error if the second dimension is not at least one of the compatible dimensions for the first dimension.

### Claim 16 (depends on 15)

The computer program product of claim 15, further comprising code for causing a processor to perform the step of:
proposing a compatible dimension if the second dimension is determined not to be compatible, wherein proposing the compatible dimension comprises:
presenting the compatible dimension to a user; and
prompting a user to enter a second operand having the compatible dimension.

### Claim 17 (depends on 15)

The computer program product of claim 15, wherein the at least one compatible dimension is the same as the first dimension.

### Claim 18 (depends on 15)

The computer program product of claim 15, further comprising code for causing a processor to perform the step of:
evaluating an output of the formula, the output having a third dimension; and
wherein determining at least one compatible dimension for the first dimension comprises:
determining the compatible dimension based upon the third dimension.

### Claim 19 (depends on 15)

The computer program product of claim 15, wherein flagging an error comprises:
notifying a user that the second operand is not compatible with the first operand.

### Claim 20 (depends on 15)

The computer program product of claim 15, wherein determining at least one compatible dimension comprises:
determining at least one compatible dimension based upon a set of rules for the operator.

### Claim 21 (depends on 15)

The computer program product of claim 15, wherein determining at least one compatible dimension comprises:
determining at least one compatible dimension based upon a characteristic of the operator and the first dimension.

### Claim 22

A method performed by a processor for executing a formula having operands and an operator in an application program, comprising:
retrieving data corresponding to a first operand for the operator of the formula;
identifying a first dimension associated with the first operand;
retrieving data corresponding to a second operand for the operator of the formula;
identifying a second unit type associated with the second operand;
determining whether the second unit type is compatible with the first unit type;
if the second unit type is not compatible with the first unit type, converting the data corresponding to the second operand into a compatible value in terms of the first unit type; and
producing a result of the formula using the converted data.

### Claim 23 (depends on 22)

A method according to claim 22, wherein the second unit type is determined to be compatible with the first unit type if the first unit type and the second unit type are equivalent.

### Claim 24 (depends on 22)

A method according to claim 22, further comprising:
analyzing a unit type of an expected result of the formula to determine whether the second unit type is compatible with the first unit type.

### Claim 25 (depends on 22)

A method according to claim 22, wherein determining whether the second unit type is compatible with the first unit type further comprises:
analyzing compatibility based upon a predetermined rule for the operator.

### Claim 26 (depends on 22)

A method according to claim 22, wherein converting the data corresponding to the second operand into a compatible value in terms of the first unit type further comprises:
obtaining a fixed conversion factor; and
using the fixed conversion factor to convert the data corresponding to the second operand.

### Claim 27 (depends on 26)

A method according to claim 26, wherein the fixed conversion factor comes from a predetermined unit conversion table.

### Claim 28 (depends on 22)

A method according to claim 22, wherein converting the data corresponding to the second operand into a compatible value in terms of the first unit type further comprises:
obtaining a variable conversion factor from an updatable data source; and
using the variable conversion factor to convert the data corresponding to the second operand.

### Claim 29

A system for executing a formula having operands and an operator in an application program, comprising:
means for retrieving data corresponding to a first operand for the operator of the formula;
means for identifying a first unit type associated with the first operand;
means for retrieving data corresponding to a second operand for the operator of the formula;
means for identifying a second unit type associated with the second operand;
means for determining whether the second unit type is compatible with the first unit type;
means for converting the data corresponding to the second operand into a compatible value in terms of the first unit type, if the second unit type is not compatible with the first unit type; and
means for producing a result of the formula using the converted dat.

### Claim 30 (depends on 29)

A system according to claim 29, wherein the second unit type is determined to be compatible with the first unit type if the first unit type and the second unit type are equivalent.

### Claim 31 (depends on 29)

A system according to claim 29, further comprising:
means for analyzing a unit type of an expected result of the formula to determine whether the second unit type is compatible with the first unit type.

### Claim 32 (depends on 29)

A system according to claim 29, wherein the means for determining whether the second unit type is compatible with the first unit type further comprises:
means for analyzing compatibility based upon a predetermined rule for the operator.

### Claim 33 (depends on 29)

A system according to claim 29, wherein the means for converting the data corresponding to the second operand into a compatible value in terms of the first unit type further comprises:
means for obtaining a fixed conversion factor; and
means for using the fixed conversion factor to convert the data corresponding to the second operand.

### Claim 34 (depends on 33)

A system according to claim 33, wherein the fixed conversion factor comes from a predetermined unit conversion table.

### Claim 35 (depends on 29)

A system according to claim 29, wherein the means for converting the data corresponding to the second operand into a compatible value in terms of the first unit type further comprises:
means for obtaining a variable conversion factor from an updatable data source; and
means for using the variable conversion factor to convert the data corresponding to the second operand.

### Claim 36

A computer program product for executing a formula having operands and an operator in an application program, comprising code for causing a processor to perform the steps of:
retrieving data corresponding to a first operand for the operator of the formula;
identifying a first unit type associated with the first operand;
retrieving data corresponding to a second operand for the operator of the formula;
identifying a second unit type associated with the second operand;
determining whether the second unit type is compatible with the first unit type;
if the second unit type is not compatible with the first unit type, converting the data corresponding to the second operand into a compatible value in terms of the first unit type; and
producing a result of the formula using the converted data.

### Claim 37 (depends on 36)

A computer program product according to claim 36, wherein the second unit type is determined to be compatible with the first unit type if the first unit type and the second unit type are equivalent.

### Claim 38 (depends on 36)

A computer program product according to claim 36, further comprising the step:
analyzing a unit type of an expected result of the formula to determine whether the second unit type is compatible with the first unit type.

### Claim 39 (depends on 36)

A computer program product according to claim 36, wherein determining whether the second unit type is compatible with the first unit type further comprises:
analyzing compatibility based upon a predetermined rule for the operator.

### Claim 40 (depends on 36)

A computer program product according to claim 36, wherein converting the data corresponding to the second operand into a compatible value in terms of the first unit type further comprises:
obtaining a fixed conversion factor; and
using the fixed conversion factor to convert the data corresponding to the second operand.

### Claim 41 (depends on 40)

A computer program product according to claim 40, wherein the fixed conversion factor comes from a predetermined unit conversion table.

### Claim 42 (depends on 36)

A computer program product according to claim 36, wherein converting the data corresponding to the second operand into a compatible value in terms of the first unit type further comprises:
obtaining a variable conversion factor from an updatable data source; and
using the variable conversion factor to convert the data corresponding to the second operand.

### Claim 43

A method for executing a formula including operands and an operator, the method comprising:
retrieving data corresponding to at least one operand for the operator of the formula;
identifying a unit type associated with the at least one operand;
determining whether the unit type of the at least one operand is consistent with an expected unit type to that operand; and
if the unit type is not consistent with the expected unit type, converting the data corresponding to the operand into a value having a unit type that is compatible with the expected unit type.
