Abstract: A computer implemented method of graphically defining a formula comprises the steps of: providing a graphically defined formula including one or more objects that graphically define the formula; selecting one or more of the objects to be grouped into a new component object; determining the number of connections that provide an input to the selected objects; determining the number of connections that provide an output to the selected objects; determining a graphical definition of the formula, where the selected objects are replaced with a representation of the new component object having the determined number of inputs and the determined number of outputs, connection(s) inputting to the selected objects from other objects are replaced with connection(s) connecting to the input(s) of the new component object and connection(s) outputting from the selected objects to the other objects are replaced with connection(s) connecting from the output(s) of the new component object; and determining a logical definition of

Abstract: 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.