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. Different lengths of time series are accepted:

8760 values are interpreted as hourly data for a full year,
365 values as daily values,
96 values as a 15-minute daily profile,
24 values as a daily profile (repeated for all days of the year),
12 values as monthly values,
7 values as a weekday profile (Monday–Sunday),
4 values as one value for each season, and
1 value as a constant value for the entire year.

A complete overview of valid time series lengths is given in Table 1. Decimal points or decimal commas can be used. Each line must contain exactly one value (no additional character at the end of the line). When decimal points are used, values can also be entered consecutively in a line. In this case, a comma must be used to separate the values.

Explanation video: Copy and paste time series from Excel.

Table 1: Supported Time Series Lengths

Number of values	Interpreted data format
8760	Hourly values for one year
365	Daily values for one year
24	Daily profile (repeated for all days of the year)
12	Monthly values for one year
7	Weekday values (Monday–Sunday). The profile is distributed across the year based on the first weekday of the year.
4	One constant value per season: 1st value: Winter, 2nd value: Spring, 3rd value: Summer, 4th value: Autumn
1	One constant value for the entire year
8784	Hourly values for a leap year. February 29 is removed from the time series.
366	Daily values for a leap year. February 29 is removed and the series is reduced to 365 days.
8759	Hourly values for one year with one missing value. The last value is duplicated and appended.
96	15-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).

Explanation video: Copy and paste time series from a text editor.

When uploading a time series, the unit of the time series (for example, watts, kilowatts or megawatts for powers) can be selected.

Upload files (alternatively)

As an alternative to inserting time series into the text field, time series can also be uploaded as a simple text file (file extension ".txt"). The same formatting rules apply as for inserting time series into the text field. Time series files can be created by simply copying them from Excel into a text editor. This is done by selecting all 8760 cells, copying them and pasting them into a text editor. The file is then saved as a text file (.txt). For orientation, an example file with decimal point and decimal comma can be downloaded here: