System and method for operating a computer application with spreadsheet functionality

1. A method of operating a computer application with a spreadsheet functionality, the method comprising:

a. receiving an input in one or more input cells of a spreadsheet application;

b. parsing the one or more input cells, wherein the one or more input cells comprises one of a value, a formula, and a function;

c. constructing a dynamic dependency graph for the one or more input cells in the spreadsheet application;

d. evaluating at least one of the one or more input cells based on at least one criteria derived from the dynamic dependency graph, wherein the evaluation results in one of addition of new cells and deletion of existing cells; and

e. returning an output to one or more output cells in the spreadsheet application.

2. The method of claim 1 , wherein the at least one criteria comprises determination of effective weights for each of the one or more input cells.

3. The method of claim 1 , wherein the output is returned to one or more new cells in the spreadsheet application.

4. The method of claim 1 , wherein the one or more input cells comprises a user defined function that is compiled and stored in a spreadsheet application library.

5. The method of claim 1 , wherein the one or more input cells comprises labels of one or more functions and parameters to call the one or more functions.

6. The method of claim 5 , wherein the one or more functions in the one or more input cells are one of user-defined functions and built-in functions.

7. A system for operating a computer application with spreadsheet functionality, the system comprising:

a. a display device; and

b. one or more programming modules configured to:

receive an input in one or more input cells of a spreadsheet application;

parse the one or more input cells;

construct a dynamic dependency graph for the one or more input cells;

evaluate at least one of the one or more input cells based on at least one criteria derived from the dynamic dependency graph;

reconstruct the dependency graph until each of the one or more input cells are evaluated; and

return an output to one or more output cells in the spreadsheet application.

8. The system of claim 7 , wherein the system further comprises a system memory for storing the output of the spreadsheet application.

9. The system of claim 8 , wherein the system memory further stores one or more user defined functions.

10. A method of operating a computer application with a spreadsheet functionality, the method comprising:

a. receiving an input in one or more input cells of a spreadsheet application;

b. parsing the one or more input cells, wherein the one or more input cells comprises one of a value, a formula, and a function;

c. constructing a dynamic dependency graph for the one or more input cells in the spreadsheet application;

d. evaluating at least one of the one or more input cells based on effective weights being derived for each of the one or more input cells from the dynamic dependency graph, wherein the evaluation results in one of addition of new cells and deletion of existing cells; and

e. returning an output to one or more output cells in the spreadsheet application.

11. The method of claim 10 , wherein the one or more input cells comprises a user defined function that is compiled and stored in a spreadsheet application library.

12. The method of claim 10 , wherein the one or more input cells comprises labels of one or more functions and parameters to call the one or more functions.

13. The method of claim 12 , wherein the one or more functions in the one or more input cells are one of user-defined functions and built-in functions.