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.