Using the cell-based workbook

This chapter describes how advanced Excel users can insert and change data to create highly customized budgeting plans and reports using the cell-based workbook.

With this specialized workbook, you can:

• Define multiple datasets based on different models. These datasets are retrieved and stored locally within the workbook and can be refreshed upon demand. Data is then retrieved from a dataset into a worksheet by individual cell formulas.
• Insert an entire block of data at a time or insert data on a cell-by-cell basis.
• Show multiple data slices from multiple data sources on a single worksheet. S
• Test various scenarios by specifying values at a consolidated level and proportionally spreading those values to leaf levels. See "Top Down Spreading" for details. These new values can be saved to a model.
• Additionally, insert view-based data on the same worksheet as cell-based data by using the Excel Services view-based model. See the Infor CPM Excel Services - View Based User Guide.
• Cut and paste formulas into other areas of the worksheet while retaining their references to other cells.
• Analyze formulas to locate source components.
• Generate a formula map to graphically view a formula, generate variances between columns, or top down spread directly from the map.
• Change member selection while working offline.
• Modify the structure directly from the workbook.