US Patent 7779431 Networked spreadsheet template designer

A networked spreadsheet template designer allows administrators to easily create and deploy robust reporting and input applications that leverage existing spreadsheet templates and knowledge in an easy to use user interface. Templates are created to operate directly in the particular spreadsheet program environment and can be created using existing templates and modeling workbooks of that spreadsheet program without the need for any code to be written. The template designer uses dynamic link library (DLL) worksheet functions directly on template worksheets to perform specified actions. The DLL functions enable a user to create an interactive, custom application by automating/encapsulating complex tasks. The DLL functions are managed across a computer network through an administrator interface to create the functions and a viewer interface that combines an Explorer® window to select the functions and a spreadsheet window for the actual spreadsheet program that implements the DLL functions.