problem in extracting results from table.csv

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

kimiya
283 ●1 ●2 ●9

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

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?`

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 ( 2020-11-01 04:05:11 -0600 )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 ( 2020-11-01 07:47:37 -0600 )edit

add a comment

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

Yi Zhang
1250 ●11 ●6

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

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 ( 2020-11-03 14:03:32 -0600 )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 ( 2020-11-03 16:03:15 -0600 )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 ( 2020-11-04 11:03:20 -0600 )edit

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

Yi Zhang ( 2020-11-04 15:47:36 -0600 )edit

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

kimiya ( 2020-11-05 01:13:26 -0600 )edit

add a comment

Your Answer

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