Client side calculations

Abstract

A computer-implemented method can include creating an adhoc grid responsive to a user request, adding an extra row to the adhoc grid responsive to another user request, entering into the extra row a cell formula specified by the user, and saving the adhoc grid as a SmartForm.

What is claimed is: 
     
         1 . A computer-implemented method, comprising:
 creating a first adhoc grid responsive to receiving from a first user a request to create the first adhoc grid;   adding an extra row to the first adhoc grid responsive to receiving from the first user a request to add the extra row to the first adhoc grid;   entering a cell formula into the extra row responsive to first user input specifying the cell formula; and   saving the first adhoc grid as a SmartForm.   
     
     
         2 . The computer-implemented method of  claim 1 , wherein creating the first adhoc grid includes opening a Planning form for adhoc analysis. 
     
     
         3 . The computer-implemented method of  claim 1 , wherein creating the first adhoc grid includes starting an analysis at a Plan type level. 
     
     
         4 . The computer-implemented method of  claim 1 , wherein adding the extra row to the first adhoc grid includes entering a value for an Entity dimension. 
     
     
         5 . The computer-implemented method of  claim 4 , wherein adding the extra row to the first adhoc grid further includes entering a value for an account dimension. 
     
     
         6 . The computer-implemented method of  claim 1 , wherein entering the cell formula into the extra row includes using an Excel formula provided by the first user. 
     
     
         7 . The computer-implemented method of  claim 1 , wherein entering the cell formula into the extra row includes automatically applying a formula for calculated cells reflected dynamically in the other. 
     
     
         8 . One or more tangible, non-transitory computer-readable media containing computer-executable instructions that, when executed by a processor, cause the processor to perform the computer-implemented method of  claim 1 . 
     
     
         9 . A computer-implemented method, comprising:
 populating a first cell in an Excel spreadsheet with first data from a repository;   populating a first cell in a Web spreadsheet with the first data from the repository;   a first user applying a first formula to the first cell in either the Excel spreadsheet or the Web spreadsheet;   updating the first data in the repository based on the applying of the first formula to the first cell in either the Excel spreadsheet or the Web spreadsheet; and   dynamically populating the first cell in the other of the Excel spreadsheet and the Web spreadsheet with the updated first data from the repository.   
     
     
         10 . The computer-implemented method of  claim 9 , further comprising the first user accessing the Excel spreadsheet on a first device. 
     
     
         11 . The computer-implemented method of  claim 10 , further comprising a second user accessing the Web spreadsheet on a second device. 
     
     
         12 . The computer-implemented method of  claim 9 , further comprising:
 the first user applying a second formula to the first cell in either the Excel spreadsheet or the Web spreadsheet;   updating the first data in the repository based on the applying of the second formula to the first cell in either the Excel spreadsheet or the Web spreadsheet; and   dynamically populating the first cell in the other of the Excel spreadsheet and the Web spreadsheet with the updated first data from the repository.   
     
     
         13 . The computer-implemented method of  claim 9 , further comprising a second user applying a second formula to the first cell in the other of the Excel spreadsheet and the Web spreadsheet. 
     
     
         14 . The computer-implemented method of  claim 13 , further comprising:
 updating the first data in the repository based on the applying of the second formula to the first cell in the other of the Excel spreadsheet and the Web spreadsheet; and   dynamically populating the first cell in the Excel spreadsheet or the Web spreadsheet with the updated first data from the repository.   
     
     
         15 . The computer-implemented method of  claim 14 , further comprising:
 the first user applying a third formula to the first cell in either the Excel spreadsheet or the Web spreadsheet;   updating the first data in the repository based on the applying of the third formula to the first cell in either the Excel spreadsheet or the Web spreadsheet; and   dynamically populating the first cell in the other of the Excel spreadsheet and the Web spreadsheet with the updated first data from the repository.   
     
     
         16 . The computer-implemented method of  claim 9 , further comprising:
 populating a second cell in an Excel spreadsheet with second data from a repository;   populating a second cell in a Web spreadsheet with the second data from the repository;   the first user applying a second formula to the second cell in either the Excel spreadsheet or the Web spreadsheet;   updating the second data in the repository based on the applying of the second formula to the second cell in either the Excel spreadsheet or the Web spreadsheet; and   dynamically populating the second cell in the other of the Excel spreadsheet and the Web spreadsheet with the updated second data from the repository.   
     
     
         17 . One or more tangible, non-transitory computer-readable media containing computer-executable instructions that, when executed by a processor, cause the processor to perform the computer-implemented method of  claim 9 . 
     
     
         18 . A computer-implemented method, comprising:
 visually presenting a spreadsheet to a user;   populating a first row in the spreadsheet with data pertaining to a first type;   populating a second row in the spreadsheet with data pertaining to a second type;   suppressing the populating of a third row in the spreadsheet with data pertaining to a third type, the suppressing based on a role of the user; and   populating the third row in the spreadsheet with data pertaining to a fourth type that, absent the suppressing, would be populated in a fourth row of the spreadsheet.   
     
     
         19 . The computer-implemented method of  claim 18 , wherein at least the data pertaining to the first type and the data pertaining to the second type include financial data. 
     
     
         20 . The computer-implemented method of  claim 18 , wherein the information includes a result of a calculation based on the data pertaining to the first type and the data pertaining to the second type. 
     
     
         21 . The computer-implemented method of  claim 18 , further comprising:
 visually presenting another copy of the spreadsheet to another user;   populating the first row in the other spreadsheet with the data pertaining to the first type;   populating the second row in the other spreadsheet with the data pertaining to the second type; and   based on another role of the other user, populating the third row in the other spreadsheet with data pertaining to a third type.   
     
     
         22 . The computer-implemented method of  claim 18 , further comprising dynamically populating the third row in the spreadsheet with data pertaining to the third type responsive to a change in the role of the user. 
     
     
         23 . The computer-implemented method of  claim 22 , further comprising dynamically populating the fourth row in the spreadsheet with the data pertaining to the fourth type responsive to the change in the role of the user. 
     
     
         24 . One or more tangible, non-transitory computer-readable media containing computer-executable instructions that, when executed by a processor, cause the processor to perform the computer-implemented method of  claim 18 .