Patent ID: 8584150

Claim:
A non-transitory computer-readable storage medium storing computer-executable instructions to enable one or more computer systems to perform a method of generating and managing templates for a spreadsheet program over a computer network, the non-transitory computer-readable storage medium comprising instructions to enable the one or more computer systems to provide: an administrator interface module operably connected to a server computer to design a plurality of templates for the spreadsheet program based at least in part on existing templates, functions and modeling workbooks of the spreadsheet program without any code being written; a dynamic link library (DLL) worksheet functions corresponding to the plurality of templates available over the computer network; a user interface module executing on a client computer having a first explorer window in which a user views and selects the DLL worksheet functions and a second viewer window in which the user interacts with the spreadsheet program and selectively incorporates one or more of the selected DLL worksheet functions; and further comprising instructions to enable the one or more computer systems to enable the administrator interface module to: create a spreadsheet workbook containing presentation and formatting data; create one or more control files, which are integrated with the spreadsheet workbook into a report application as one of the plurality of templates, the one or more control files defining a source, scope, and structure of data to be returned from a networked database when the report application is executed and deployment information for the report application; and create the report application by integrating the spreadsheet workbook with the one or more control files.