Cash Flow WorkSheets are used in conjunction with the Cash Flow log to define and manage cash flow detail and rollup curves. The Cash Flow WorkSheet opens automatically after you define properties for a new cash flow curve.
Unifier collects data from various managers, including cost, portfolio, resource and schedule, and displays it in cash flow curves. Curve options (for example, data sources, and distribution selections), determine the appearance of a curve in a Cash Flow WorkSheet. The Cash Flow WorkSheet window displays a graph on the top portion of the window, and a list of included curves on the bottom portion. Each curve listed has its own data set, which you can view in the Details window. Depending on the curve set up, the Details window is where you manage the curve data.
To open a Cash Flow WorkSheet for an existing curve
- Navigate to the Cost Manager and select Cash Flow to open the Cash Flow log window.
- Select a curve from the log and click Open, or double-click the curve to open the Cash Flow WorkSheet window.
The Cash Flow WorkSheet is divided into two parts:
- The Graph view simultaneously displays incremental and cumulative cash flow data. You can filter data in the graph sections. The Cash Flow WorkSheet for a new curve does not display graphs because no curve data has been entered or spends values (Actuals) generated. After graphs are displayed, the zoom level can be switched from monthly to yearly.
- The Table view displays the names of the individual curves that you defined in the Properties window as well as incremental data values (by default). You can split the table for easier viewing of the information.
Incremental curve: An incremental curve displays the cash flow for a certain period.
Cumulative curve: A Cumulative curve displays the net of all cash flows over a period of time.
The other parts of the Cash Flow WorkSheet are:
- The View option (on the menu bar) enables you to toggle between incremental (default) and cumulative table values.
- The sliders (located between the graph and the table views) enable you to limit the graph to specific time periods.
Each part of the Cash Flow WorkSheet can be individually maximized. Additional options enable you to filter the information on the Cash Flow WorkSheet to display selected curves and to print the worksheet, or both.
To set curves for viewing in the Cash Flow WorkSheet
- Navigate to the Cost Manager and select Cash Flow to open the Cash Flow log window.
- Select a log and click Properties.
- On the General tab, check the data sources that have the curve types you want to view.
- Click OK. The Properties window opens and the selected worksheet opens with a graphic of the curves.