Spreadsheet errors are hard to fix and errors are easily replicated because the "logic" is not transparent -- the formulas are contained within the cell. Only the creator of the spreadsheet has a prayer of understanding the intent of the document, not to mention the function of each cell. While the spreadsheet might be ubiquitous, serious number crunchers need a better application. There are a lot of enterprise financial modeling apps, but they don't help desktop users. A company in Portland, Maine has developed something called Quantrix Modeler. It's multidimensional, formulas are contained outside the cell, and use natural language. There's a 30-day trial version at http://www.quantrix.com./
Spreadsheet errors are hard to fix and errors are easily replicated because the "logic" is not transparent -- the formulas are contained within the cell. Only the creator of the spreadsheet has a prayer of understanding the intent of the document, not to mention the function of each cell. While the spreadsheet might be ubiquitous, serious number crunchers need a better application. There are a lot of enterprise financial modeling apps, but they don't help desktop users. A company in Portland, Maine has developed something called Quantrix Modeler. It's multidimensional, formulas are contained outside the cell, and use natural language. There's a 30-day trial version at http://www.quantrix.com./