摘要 |
The system takes a formula in single line form in spreadsheets and other programming environments and converts it into two dimensional mathematical notation (86). The conversion takes place at the level of a single line as entered in the programming environment or at the level of multiple lines by recursively substituting variables to build up a formula which has been sub-divided. Symbolic names are assigned to formulas (84) and input values used by formulas to give formulas more meaning when the formulas are being debugged. Complicated formulas that are too complex for the programming environment to handle, too difficult to maintain or extend in the programming environment, or too time-consuming for the programming environment to execute are solved in an independent module (94) capable of solving the complicated formulas and the solution is linked to the programming environment. |