Problem with spreadsheets in EnergyPlus

asked 2019-05-06 16:31:36 -0500

Telis
33 ●2

updated 2020-01-25 18:23:32 -0500

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

edit retag flag offensive close merge delete

add a comment

2 Answers

Sort by » oldest newest most voted

answered 2019-05-06 18:15:26 -0500

santoshphilip
961 ●2 ●4

Try importing it as a CSV file into excel

edit flag offensive delete link

Comments

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

Telis ( 2019-05-06 18:38:24 -0500 )edit

add a comment

answered 2019-05-07 10:44:54 -0500

Binghang
61 ●2

updated 2019-05-07 10:47:55 -0500

you also can split the data in excel

Select the data range in column A
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...