Import data from a spread sheet to a time series

To import data from a spreadsheet into a time series it is important to use a date and time format used in energyPRO .

To secure that, the recommended way of doing this is to copy a line from an energyPRO time series into a spreadsheet. Start creating a time series for e.g. the ambient temperature in the External conditions folder. Type values for date and time in the first line. Press the Copy all button and the line is copied to the clipboard.

Copying a single line from the energyPRO time series window

Open the spreadsheet to be used. In this example is used a spreadsheet with month, day and ambient temperature specified.

Spreadsheet containing the time series data

Paste the date and time from clipboard into the spreadsheet.

Pasting the single line into the spreadsheet

Use this format for date and time to create new columns for the ambient temperature.

Spreadsheet with the complete timeseries data in the required, pasted format

Now you can copy the columns into the time series in energyPRO.

Completed time series energyPRO window