nPro
Navigation

Time series upload

On this page you learn how to upload time series in nPro.

Upload with copy / paste

In the nPro tool, time series can be uploaded very easily by copy / paste. The time series can be copied from an Excel spreadsheet or a text editor and pasted into the text field in the upload window.

Explanation video
Figure 1: Explanation video: Copy and paste time series from Excel.
Explanation video
Figure 2: Explanation video: Copy and paste time series from a text editor.

Valid formats

Different time-series lengths are accepted. A complete overview of valid time-series lengths is provided below. Both decimal commas and decimal points can be used. Each line must contain exactly one value, with no additional characters at the end of the line. When using decimal points, multiple values can also be entered consecutively on a single line. In this case, the values must be separated by commas.

Table 1: Supported time series lengths
Number of valuesInterpreted data format
8760Hourly values for one year
365Daily values for one year
24Daily profile (repeated for all days of the year)
12Monthly values for one year
7Weekday values (Monday - Sunday). The profile is distributed across the year based on the first weekday of the year.
4One constant value per season: 1st value: Winter, 2nd value: Spring, 3rd value: Summer, 4th value: Autumn
1One constant value for the entire year
8784Hourly values for a leap year. February 29 is removed from the time series.
366Daily values for a leap year. February 29 is removed and the series is reduced to 365 days.
8759Hourly values for one year with one missing value. The last value is duplicated and appended.
9615-minute daily profile. Aggregated to hourly values and repeated for all days of the year.
35040 (=4 × 8760)15-minute values for a full year. Aggregated to hourly values (average for power, sum for energy) and converted into a yearly profile (8760 values).
52560 (=6 × 8760)10-minute values for a full year. Aggregated to hourly values (average for power, sum for energy) and converted into a yearly profile (8760 values).
105120 (=12 × 8760)5-minute values for a full year. Aggregated to hourly values (average for power, sum for energy) and converted into a yearly profile (8760 values).
525600 (=60 × 8760)1-minute values for a full year. Aggregated to hourly values (average for power, sum for energy) and converted into a yearly profile (8760 values).