0

Problem with spreadsheets in EnergyPlus

Hello. I am using the EnergyPlus for energy simulation of a building. The problem I have is with the format of the outpouted files and especially with spreadsheets. I am running E+ and at the end I am unable to process the data. An example of what my excel outputs seem like is the following image. https://imgur.com/BxEMbaQ I don't know what to do please help me, I have to finish my diploma thesis. Thanks

Telis's avatar
33
Telis
asked 2019-05-06 16:31:36 -0500
__AmirRoth__'s avatar
4.4k
__AmirRoth__
updated 2020-01-25 18:23:32 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

1

Try importing it as a CSV file into excel

santoshphilip's avatar
961
santoshphilip
answered 2019-05-06 18:15:26 -0500
edit flag offensive 0 remove flag delete link

Comments

It worked! Thank you. I imported the csv file via the data tab ''from text'' and the problem was fixed

Telis's avatar Telis (2019-05-06 18:38:24 -0500) edit
add a comment see more comments
1

you also can split the data in excel

  1. Select the data range in column A
  2. Start from [Data] menu > >[Data tools] tab >[Tex to Columns] button> choose "Delimited" , next >choose "comma" as delimiters, finish.

refer to https://www.laptopmag.com/articles/us...

Binghang's avatar
61
Binghang
answered 2019-05-07 10:44:54 -0500, updated 2019-05-07 10:47:55 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments