|
FlexiSheet - Basics |
|
|
|
|
FlexiSheet is an innovative multi-dimensional spreadsheet designed to facilitate the creation and editing of spreadsheets and financial models.
Using a multi-dimensional spreadsheet is different and significantly more powerful than the simple rows and columns found in traditional spreadsheets.
Deficiencies of the traditional approach
We're all familiar with the traditional rows and columns approach to spreadsheet analysis. The deficiencies of this approach include:
 |
Formulas define one and only one cell at a time. |
|
Formulas that use row/column references are cryptic. |
|
Users have to select a cell to see the formula that defines it. |
|
Rearranging data is too hard without disturbing the integrity of your spreadsheet. |
|
Spreadsheets are difficult to decompose into neatly organized models. |
What's the same with FlexiSheet?
Before we look at what the multi-dimensional approach changes to make spreadsheet analysis easier, let's first look at what will not change.
|
You'll enter data in cells just as you did in the traditional world. To edit cells, double-click, add or change data, and press Enter. |
|
You'll still use your spreadsheet to solve and present solutions to business problems. FlexiSheet presents the same data, and provides standard tools for modifying font, color, borders... |
|
You'll write formulas in the same range = definition format. |
What's different?
FlexiSheet presents several innovations to spreadsheet analysis.
|
FlexiSheet allows you to describe data in terms of categories such as "Territory," "Month," or "Product" and items of those categories such as "Europe," "January" or "Leather Gloves". |
|
Data is easily reorganized. Categories are listed on tiles that you simply drag and drop to rearrange your data. Just pick up a category tile and move it to another axis, or rearrange it with respect to the tiles currently on its axis. Because data is associated with categories and items, rearranging the data has no effect on the validity of formulas.
| |
Formulas are written and stored in a separate formula area, which can be viewed simultaneously with the spreadsheet itself. |
|
Formulas are written in plain English, making it easier to read and write them. |
|
You can include comments with the formulas, so that those who view your work later can understand what you've done. |
|
FlexiSheet allows you to quickly and easily decompose the analysis of business problems into one organized model.
|
|
|
|
|
