Supported formats for period column headers

Each planning frequency requires a specific format for the period column header. The delimiter for the data is always a semicolon.

The abbreviations DD, MM, Q, and YYYY that are used for the supported period formats have these meanings:

• DD – day with the leading zero

  Example: 01

• MM – month with the leading zero

  Example: 01

• M – month without the leading zero

  Example: 1

• YYYY – year
• Q – quarter

  Example: Q1

These period formats for different planning frequencies are supported.

Weekly, Bi-weekly

For weekly and bi-weekly planning, the start date of the weekly or bi-weekly period is used. The configuration set is divided into weekly or bi-weekly periods. Weekly and bi-weekly periods start on Monday and end on Sunday.

• DD.MM.YYYY
• DD-MM-YYYY
• DD_MM_YYYY

Monthly

For monthly planning, the period format is the year followed by the month without the leading zero character.

• YYYY-M
• YYYY_M
• YYYY/M

Quarterly

For quarterly planning, the period format is the year followed by the quarter Q1, Q2, Q3, or Q4.

• YYYY-Q
• YYYY_Q
• YYYY/Q

Yearly

For yearly planning, the period format is the four-digit year, YYYY.