Systems and methods for implementing formulas

• US 8,091,024 B2
• Filed: 10/09/2008
• Issued: 01/03/2012
• Est. Priority Date: 10/30/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Graeber, Astrid
• Primary Examiner(s): Ries, Laurie
• Application Number:
  US12/285,625
• Publication Number:
  US 20090055733A1
• Time in Patent Office: 1,181 Days
• Field of Search: 715/271, 715/267, 715/256, 715/212, 715/214, 705/50, 708/100
• US Class Current: 715/267
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: 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
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/06315 Needs-based resource requirements planning or analysis

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

1. 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.

2. A method according to claim 1, 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.

3. A method according to claim 1, 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.

4. A method according to claim 1, 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.

5. A method according to claim 1, 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.

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

7. A method according to claim 1, 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.

8. 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 data.

9. A system according to claim 8, 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.

10. A system according to claim 8, 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.

11. A system according to claim 8, 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.

12. A system according to claim 8, 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.

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

14. A system according to claim 8, 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.

15. A memory with a residing computer program product for executing a formula having operands and an operator in an application program, comprising code residing in the memory 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.

16. The memory with computer program product according to claim 15, 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.

17. The memory with computer program product according to claim 15, 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.

18. The memory with computer program product according to claim 15, 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.

19. The memory with computer program product according to claim 15, 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.

20. The memory with computer program product according to claim 19, wherein the fixed conversion factor comes from a predetermined unit conversion table.

21. The memory with computer program product according to claim 15, 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.

22. 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.