Graphically defining a formula for use within a spreadsheet program

摘要

A graphically defined formula is used within a spreadsheet implemented by a spreadsheet computer program by placing a reference to the graphically defined formula created by a tool. The reference is used to interface the spreadsheet computer program to an engine for evaluating the graphically defined formula. The graphically defined formula is evaluated by the engine by passing input data from the spreadsheet to the engine to produce a result by evaluating the graphically defined formula using the input data and passing the result from the engine to the spreadsheet computer program for entry into the spreadsheet.