Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question
0

Problem with spreadsheets in EnergyPlus

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

Telis gravatar image

updated 2019-05-06 18:51:41 -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

2 Answers

Sort by ยป oldest newest most voted
1

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

Binghang gravatar image

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

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...

edit flag offensive delete link more
1

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

santoshphilip gravatar image

Try importing it as a CSV file into excel

edit flag offensive delete link more

Comments

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

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

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

 



Question Tools

1 follower

Stats

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

Seen: 88 times

Last updated: May 07