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

problem in extracting results from table.csv

asked 2020-11-01 02:18:39 -0500

kimiya's avatar

updated 2020-11-01 02:20:22 -0500

Hi, I'm trying to obtain the heating and cooling demand of a building for different variables. rvi rvx I tried these codes by deleting the "rvis" part, but I got the same result. Sometimes I got zero value for heating and cooling and sometimes there was not any value for them. I can not understand why the results are not extracted. Could you please help me with extracting results using rvx file?`

edit retag flag offensive close merge delete


Did you intend to use RVI or CSV to get the results? It is unclear because if you have removed the RVIs section, why do you show the contents of the rvi file.

Yi Zhang's avatar Yi Zhang  ( 2020-11-01 04:05:11 -0500 )edit

@Yi Zhang, I want to extract data from CSV, but I did not get any result by using the RVX file alone. I was wondering if you could help me with the correct RVX code for extracting data from CSV file?

kimiya's avatar kimiya  ( 2020-11-01 07:47:37 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2020-11-01 09:35:07 -0500

Yi Zhang's avatar

If you intend to extract results from E+ tabular reports in CSV format (eplustbl.csv), you should first make sure that the output is requested in your model, by adding the following lines:

  CommaAndHTML;            !- Column Separator

It is easier to do in jEPlus v2.1 rather than v1.7. Here is the manual:

And here the video showing the process:

edit flag offensive delete link more


@Yi ZhangThank you so much . I ran my project using CSV file in v1.7 and I added OutputControl:Table:Style,to the Energyplus file as you said.In this situation the variables were selected but their value cells were empty and I guess it was due to this error"<root>[OutputControl:Table:Style] - Object should have no more than 1 properties.".I was wondering If you could help me with this error.

kimiya's avatar kimiya  ( 2020-11-03 14:03:32 -0500 )edit

There must be a typo in your "OutputControl:Table:Style" object. Check if there is an extra comma (,) there or not, or if you have another "OutputControl:Table:Style" object in the IDF model. Also, beware that in v1.7.2, you need an extra field called "fromFor" in the CSV item. Copy the example from the manual link in the main answer. The v1.7 manual is incorrect.

Yi Zhang's avatar Yi Zhang  ( 2020-11-03 16:03:15 -0500 )edit

@Yi Zhang, thanks a lot for your help.jEplus gave me some outputs without showing any error, but I got a Converge error in EnergyPlus. Are these outputs valid?

kimiya's avatar kimiya  ( 2020-11-04 11:03:20 -0500 )edit

Not all of the convergence errors are critical, but as a rule, you should always check the causes of them.

Yi Zhang's avatar Yi Zhang  ( 2020-11-04 15:47:36 -0500 )edit

Thanks a lot,@Yi Zhang,I really appreciate your help.

kimiya's avatar kimiya  ( 2020-11-05 01:13:26 -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


Asked: 2020-11-01 02:18:39 -0500

Seen: 345 times

Last updated: Nov 01 '20