Abstract: A system and methods for defining spreadsheet worksheet functions capable of returning more than one output value to a worksheet with the layout of the returned values being customizable through the use of named ranges on the worksheet. The mapping of an output value to a destination cell (or range) is achieved by using a naming convention, wherein the name of the output parameter as defined in the worksheet function or in an interactive coding environment is automatically mapped to a worksheet range having the same name.

Abstract: A system and methods for defining spreadsheet worksheet functions capable of returning more than one output value to a worksheet with the layout of the returned values being customizable through the use of named ranges on the worksheet. The mapping of an output value to a destination cell (or range) is achieved by using a naming convention, wherein the name of the output parameter as defined in the worksheet function is automatically mapped to a worksheet range having the same name.

Abstract: A system and methods for dynamically creating spreadsheet workbooks at runtime on a computing device from a set of pre-defined spreadsheet modules. Each spreadsheet module has an associated interface definition, allowing users more easily to combine multiple modules into more complex spreadsheet applications. Interfaces are defined using a Spreadsheet Interface Definition Language (SIDL) which enables spreadsheet models to be defined independent of their implementation. Modules can be either pre-constructed as spreadsheet workbooks, or dynamically created at run time from module definitions.

Abstract: Apparatus for the position sensing of a remote target. A preferred embodiment is used to control the position of a graphical pointer on a computer screen. A light emitting diode illuminates the head of the computer operator and an array of detectors detect radiation returned by a retroreflector attached to the head of the operator. Signal processing means is included to derive information about the position of the operator's head from the detector outputs and convert it to a form suitable for input to computer.