SCHEDULEPROJECTS

Overview

Description	Combines project KPI blueprints over time with timing information that defines when projects start. Use when you want to place reusable project blueprints onto actual start periods based on a timing node.
Syntax	`SCHEDULEPROJECTS('ProjectKPI', 'TimingNode' [, "TimeLevel"])`
Parameter	ProjectKPI: Contains the project KPI data over time (e.g. revenue). TimingNode: Contains data for the starting points of projects. This node is typically a simulation node used to simulate different starting points for projects. TimeLevel: 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.
Training Model	T02 Hochlaufkurven in Trainingsmodelle - Modelle

Examples

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

Project	Sequence	Value (Revenue)
Small Project	1	500
Small Project	2	700
Large Project	1	8,000
Large Project	2	9,000

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

Project	Year	Value (Number of projects)
Small Project	2025	2
Small Project	2026	5
Large Project	2025	0
Large Project	2026	10

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')

Project/Year	2025	2026	2027	2028
Small Project	1,000₍₂₎	3,900₍₂₊₅₎	3,500₍₅₎	0
Large Project	0	80,000₍₁₀₎	90,000₍₁₀₎	0

Related Functions

Function	When to use instead
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.