About cash flow sheets in Cash Flow (Basic)

A cash flow sheet is used to calculate and maintain detailed cash flow information. You can generate table data showing incremental and cumulative values, and graphs displaying multiple cash flow curves. Cash flow sheets and curves can be created at the project or shell, program, and company level.

You can save generated cash flow curves and refresh them to include newer data. You can refresh cash flow curves manually or schedule automatic refresh. Cash flow curves are also refreshed automatically when certain properties of the curve are modified.

Cash flow data sources are available to store curve data. These data sources can be used to roll up project or shell data to the program and company levels to view cash flow data across multiple project or shells.

Other cash flow features include:

You can generate table data showing incremental and cumulative values, and graphs displaying multiple cash flow curves.
There can be multiple cash flow sheets.
You can set up the cash flow curve by project or shell or by WBS code.
The data displays in project or shell currency.
The cash flow sheet provides the function to export data to Excel, and save it to a local file system in CSV format.
Interpolate data: Interpolation is estimating the cash flow curve based on known start and end values. There is not an equivalent option to interpolate as there is for extrapolate based on data set, but it is possible to interpolate data by specifying end point cost data. For interpolation, the curve will be based on a specified end point. The base curve and interpolated curve will merge together if the end values are the same.
Extrapolate data: You have the option under curve properties to extrapolate the actual cost based on a provided data set. For example, you can estimate, or extrapolate, the cash flow curve for this year based on last year’s data. For this option, you need to specify a data set, meaning data from an existing cash flow sheet from which the extrapolation is based. You can show interpolation and extrapolation by selecting S Curve as a curve properties option, along with selecting the option for “Begin calculation at end of [select existing Cash Flow curve].” For interpolation and extrapolation, the curve is generated from the last point of actual data. For WBS mode, the extrapolated or interpolated data is calculated based on the end point obtained from the curve used for “Begin calculation at end of” and then all of the curve points are summed together to display one curve from the period where the first value appears.

 

 

 

 


Oracle Corporation

Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.

Copyright Information