+- jeplus.org forums (http://jeplus.org/mybb)
+-- Forum: Building simulation tools (http://jeplus.org/mybb/forumdisplay.php?fid=1)
+--- Forum: jEPlus (http://jeplus.org/mybb/forumdisplay.php?fid=2)
+--- Thread: Problem in extracting results from .e+ table .csv (/showthread.php?tid=405)
Problem in extracting results from .e+ table .csv - Marcrow - 12-26-2015
Dear all,
I'm a new user of jeplus for E+ parametric analysis. I'm trying to obtain the energy consuption of a building for various orientations.
According the user guide I'm trying to extract the value of Energy Per Conditioned Building Area [MJ/m2] from the Annual Building Utility Performance Summary - Site and Source Energy table generated by E+ in the output file eplustbl.csv.
Even if the parametric simulation are correctly performed and html/tabular csv results are generated for each run, I can't understand why results are not extracted from the tables and they are not collected in the SimResults.csv file.
At the moment I'm using the following .rvi file. The version of my idf file is 8.1.009.
"csvs" : [
{
"sourceCsv" : "eplustbl.csv",
"fromReport" : "Annual Building Utility Performance Summary",
"fromTable" : "Site and Source Energy",
"fromColumn" : "Energy Per Conditioned Building Area [MJ/m2]",
"fromRow" : "Total Source Energy",
"tableName" : "TABLENAME",
"columnHeaders" : "COLUMNTITLE",
"usedInCalc" : true
}
],
I upload my files.
Thanks for your help.
Marcrow
RE: Problem in extracting results from .e+ table .csv - Yi - 01-01-2016
Hi Marcrow,
You need to make two changes:
1. Add a pair of { } to enclose the "csvs" block and remove the last ','
2. Rename my.rvi to my.rvx
The content of my.rvx should be like this:
{
"csvs" : [
{
"sourceCsv" : "eplustbl.csv",
"fromReport" : "Annual Building Utility Performance Summary",
"fromTable" : "Site and Source Energy",
"fromColumn" : "Energy Per Conditioned Building Area [MJ/m2]",
"fromRow" : "Total Source Energy",
"tableName" : "TABLENAME",
"columnHeaders" : "COLUMNTITLE",
"usedInCalc" : true
}
]
}
For optimisation, you can add constraints and objectives later to the rvx file.
Yi
RE: Problem in extracting results from .e+ table .csv - Marcrow - 01-03-2016
Thank you very much for you help Yi!
All the best,
Marco