Creating Cash Flow Data Sources
You can add multiple curves to a cash flow worksheet so you can view and compare curves side by side. These curves are based on the data sources you add here.
Each data source is used to identify one of the curves on a worksheet, and therefore can be used once per worksheet. However, you can reuse the data sources on different worksheets. You can create as many data sources as you need to create cash flow curves.
When you create a data source, you associate it with a Curve Type. Each curve type has a built-in logic when creating the curve using the data source. The curve types are:
- Baseline
Choose this to create a Baseline curve. You can choose to manually enter the cost data, or automatically pull the data from a cost column, such as a Budget.
- Forecast
Choose this to create a curve that helps forecast future cash flow based on actual spends records.
- Actuals (Spends)
Choose this to plot spends data over time.
- Portfolio Budget
Choose original or shared option to create a Portfolio Budget curve.
- Derived
Choose to create a Derived curve.
- Custom
You can create Custom curves that you can use to enter data, or to compare against other curves. The setup is similar to the Baseline curves.
To create a Cash Flow data source
- Go to the Company Workspace tab and switch to Admin mode.
- In the left Navigator, click Standards & Libraries > Cash Flow > Data Sources. The Data Sources log opens. By default, there is one Data Sources record displayed in the log. All data sources are stored in this record.
- Select Data Sources in the log and click Open (or double-click Data Sources). The Edit Data Source window opens.
- Click the Add button. This adds a new row to the window.
- Enter a Name for the data source. The name must be unique and not exceed 30 characters.
Press the Tab key to move to the next field.
- Select a Curve Type from the drop-down list: Baseline, Forecast, Actual (or Spends), Portfolio Budget, Derived, or Custom curves.
You can make your selection by clicking the field and selecting from the list, pressing the first letter of your selection on the keyboard (e.g., press the B key to select Baseline), or you can use the arrow keys on your keyboard to browse the list and make your selection.
Press Tab to move to the next field.
- Select a Color.
This color will be used on the cash flow graph at runtime when a curve is generated from the data source. There are 256 colors (including "0" for black) to choose from.
Like the Curve Type field, you can click the field and select from the list; press the arrow keys to browse the colors; or, if you know the number of the color that you want, you can type it directly then press Enter.
- To rearrange the data sources, select on the list and click the Move Up or Move Down buttons. This is the order in which the data sources will be presented when a user creates a curve.
- Click OK to save and exit the window.
Last Published Monday, August 28, 2023