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

problem in extracting results from table.csv

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

kimiya gravatar image

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

Comments

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 gravatar image 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 gravatar image kimiya  ( 2020-11-01 07:47:37 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

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

Yi Zhang gravatar image

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:

OutputControl:Table:Style,
  CommaAndHTML;            !- Column Separator

It is easier to do in jEPlus v2.1 rather than v1.7. Here is the manual: https://www.jeplus.org/wiki/doku.php?...

And here the video showing the process: https://youtu.be/HkGXophS_kg

edit flag offensive delete link more

Comments

@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 gravatar image 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 gravatar image 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 gravatar image 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 gravatar image Yi Zhang  ( 2020-11-04 15:47:36 -0500 )edit

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

kimiya gravatar image 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

Stats

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

Seen: 144 times

Last updated: Nov 01 '20