Note: In order to use the spreadsheet examples, you need to download Business Functions
|UniSpreadAdj (Time, Base, Start, Finish, Total, [ActualsToDate], [DayCount], [Periods], [ProjMode])|
|UniSpread that uses an ActualsToDate figure to continually reforecast so that the overall budget stays at Total.|
|UniSpreadAdj does a standard UniSpread between the times of Start and Finish, except that each time it generates a payment it first checks to see if the ActualsToDate are running ahead or behind the budgeted Total, and adjusts Total accordingly. This fun|
One technique is really handy when using this function. For the ActualsToDate, you can sum all the previous payments using something like "SUM($A$1...A2)" (note the selective use of the dollar signs to fix the position of the first payment). If you do this, you can simply overwrite the contents of a cell with the actuals, and your overall budget will automatically adjust. There"s an example in the Worked Examples about this.