Is it possible to change the output variables results order in CSV? [closed]

asked 2019-05-21 17:08:23 -0500

kc8301s gravatar image

updated 2019-05-21 20:07:28 -0500

Hello, so currently I have an excel sheet where I can just insert new simulation results (CSV) from EnergyPlus IDF file and it will generate graphs for me to examine. The equations for the graph are linked directly to the data in the simulation results sheet in the excel file, where I always insert new results when I do new simulations. Now, I just realized that I needed to add more output variables and now that I added more output variables, when I insert the new simulation results into my excel sheet it messed up with the equations that I have set up for the graphs because of the positions of the new simulation data have been shifted (new results appeared in the middle of the old results).

I wonder if there is a way to change the order of the IDF results? So that the new output variable results columns will appear to the end of the existing variable results columns, so they won't mess up with my graph equations. Is this possible? Or should I just change the equations again manually? I have made an overview picture in the attachment for better understanding of the situation. Thank you for your time.

Overview picture: C:\fakepath\fullsizeoutput_17aa.jpeg

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by kc8301s
close date 2019-05-22 16:57:51.716130



I've never tried it myself, but I believe you can create an *.rvi file to accomplish this. See for example.

shorowit gravatar imageshorowit ( 2019-05-21 17:42:11 -0500 )edit

I agree with @shorowit. Maybe this question should be closed as a duplicate.

JasonGlazer gravatar imageJasonGlazer ( 2019-05-22 07:26:38 -0500 )edit

Thank you @shorowit for the lead. I have solved my problem with your suggestion. It is the same process as the other question like what you said. @JasonGlazer yes, I will close this question due to it being a duplicate.

kc8301s gravatar imagekc8301s ( 2019-05-22 16:57:26 -0500 )edit