SCHEDULEPROJECTS

In Rollforward & time series

The SCHEDULEPROJECTS function combines project KPI blueprints over time with timing information that defines when projects start.

Use this function when you want to place reusable project blueprints onto actual start periods based on a timing node.

For a worked example, see the training model T02 Hochlaufkurven in Trainingsmodelle - Modelle.

Parameters

ProjectKPINode referenceRequired

Contains the project KPI data over time (e.g. revenue).

TimingNodeNode referenceRequired

Contains data for the starting points of projects. This node is typically a simulation node used to simulate different starting points for projects.

TimeLevelLevel nameOptional

Specifies the time level ("Month", "Quarter", "Year") in which the offset is given in the ProjectsNode. If this parameter is omitted, ProjectKPI is assumed to be on the lowest time level in the TimingNode.

Example

Scheduling project blueprints by start period

This example shows how reusable project KPI blueprints are placed onto actual years based on a timing node. A small and a large project each span two years and start in different periods.

Input node: 'ProjectKPI'

The Sequence column shows that the Small Project generates 500 of revenue in the first year and 700 in the second year. Instead of year, month or quarter can also be used by changing the time column in the TimingNode or by specifying the TimeLevel parameter.

Input node: 'TimingNode'

Here we specify how many projects start when. Two Small Project items start in 2025, while five Small Project and ten Large Project items start in 2026.

Formula: SCHEDULEPROJECTS('ProjectKPI', 'TimingNode')

See also

SHIFT

When you already have values and only need to move them along a time level by a defined offset.

EXPAND

When you first need to create the target shape or add missing level combinations before applying further time logic.