Creating a spreadsheet template for generating an end user spreadsheet with dynamic cell dimensions retrieved from a remote application

Abstract

A method for creating a spreadsheet template to facilitate creation of a spreadsheet is disclosed. The method comprises determining at least one dimension for the spreadsheet; creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run and saving said logic in a memory device; and creating logic to map each cell within each dimension range to a remote application object.

1 . A computer-implemented method for creating a spreadsheet template to facilitate creation of a spreadsheet, comprising:
 determining at least one dimension for the spreadsheet;   creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run, and saving said logic in a memory device; and   creating logic to map each cell within each dimension range to a remote application object.   
     
     
         2 . The method of  claim 1 , wherein the logic to dynamically determine the dimension range for each dimension is configured to filter the remote application based on a user-input value for each dimension. 
     
     
         3 . The method of  claim 1 , wherein the logic to dynamically determine the dimension range for each dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat. 
     
     
         4 . The method of  claim 1 , further comprising creating logic to generate at least one menu command for insertion into the spreadsheet, the at least one menu command to perform an action. 
     
     
         5 . The method of  claim 4 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template. 
     
     
         6 . The method of  claim 4 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension. 
     
     
         7 . A computer-readable medium having stored thereon a sequence of instruction which when executed by a system causes the system to perform a method, comprising:
 determining at least one dimension for the spreadsheet;   creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run, and saving said logic in a memory device; and   creating logic to map each cell within each dimension range to a remote application object.   
     
     
         8 . The computer-readable medium of  claim 7 , wherein the logic to dynamically determine the dimension range for each dimension is configured to filter the remote application based on a user-input value for each dimension. 
     
     
         9 . The computer-readable medium of  claim 7 , wherein the logic to dynamically determine the dimension range for each dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat. 
     
     
         10 . The computer-readable medium of  claim 7 , wherein the method further comprises creating logic to generate at least one menu command for insertion into the spreadsheet, the at least one menu command to perform an action. 
     
     
         11 . The computer-readable medium of  claim 10 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template. 
     
     
         12 . The computer-readable medium of  claim 10 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension. 
     
     
         13 . A system, comprising:
 a processor; and   a memory coupled to the processor, the memory storing instruction which when executed by the system causes the system to perform a method for creating a spreadsheet template to facilitate creation of a spreadsheet, comprising:
 determining at least one dimension for the spreadsheet; 
 creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run, and saving said logic in a memory device; and 
 creating logic to map each cell within each dimension range to a remote application object. 
   
     
     
         14 . The system of  claim 13 , wherein the logic to dynamically determine the dimension range for each dimension is configured to filter the remote application based on a user-input value for each dimension. 
     
     
         15 . The system of  claim 13 , wherein the logic to dynamically determine the dimension range for each dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat. 
     
     
         16 . The system of  claim 13 , wherein the method further comprises creating logic to generate at least one menu command for insertion into the spreadsheet, the at least one menu command to perform an action. 
     
     
         17 . The system of  claim 16 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template. 
     
     
         18 . The system of  claim 16 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension.