Jeplus+EA does not find objective function in RVI files
Hi all,
I was running successfully Jeplus+EA project with rvi-files. However, I wanted to get uservars defined and plotted. So I am trying to use the RVX files. But it gives me some strange error although rvi has defined the objective function:
my rvi file:
eplusout.eso
eplusout.csv
Heating:Electricity
Cooling:Electricity
0
!-sqlite
! Output file name; Column headers; SQL command
HVAC_Electricity;HVAC Electricity Intensity [kWh/m2];SELECT Value FROM TabularDataWithStrings WHERE (TableName='Utility Use Per Conditioned Floor Area' AND RowName='HVAC' AND ColumnName='Electricity Intensity')
!-end sqlite
!-objectives
! Name of the objective; unit; formula (c0,c1, c2... are columns in the result table generated from the statements above)
Heating Electriciy; kWh; c0
Cooling Electriciy; kWh; c1
!-end objectives
my RVX file:
{
"notes": "Some notes about this RVX",
"rvis": [
{
"fileName": "my_LCCA.rvi",
"tableName": "SimResults"
}
],
"sqls": [
{
"tableName": "Heating_Electricity",
"columnHeaders": "Heating Electricity [kWh]",
"sqlcommand": "SELECT Value FROM TabularDataWithStrings WHERE (TableName='End Uses' AND RowName='Heating' AND ColumnName='Electricity')"
},
{
"tableName": "Cooling_Electricity",
"columnHeaders": "Cooling Electricity [kWh]",
"sqlcommand": "SELECT Value FROM TabularDataWithStrings WHERE (TableName='End Uses' AND RowName='Cooling' AND ColumnName='Electricity')"
},
{
"tableName": "HVAC_Electricity_Intensity",
"columnHeaders": "HVAC Electricity Intensity [kWh/m2]",
"sqlcommand": "SELECT Value FROM TabularDataWithStrings WHERE (TableName='Utility Use Per Conditioned Floor Area' AND RowName='HVAC' AND ColumnName='Electricity Intensity')"
}
],
"scripts": [
{}
],
"userVars": [
{
"identifier": "v0",
"formula": "c0",
"caption": "Heating Electricity [kWh]",
"report": true
},
{
"identifier": "v1",
"formula": "c1",
"caption": "Cooling_Electricity [kWh]",
"report": true
},
{
"identifier": "v2",
"formula": "c2",
"caption": "HVAC Electricity Intensity [kWh/m2]",
"report": true
}
],
"constraints": [
{}
],
"objectives": [
{
"identifier": "t1",
"formula": "v1",
"caption": "Heating Electricity [kWh]",
"scaling": true,
"min": 0,
"max": 10000,
"weight": 1
},
{
"identifier": "t2",
"formula": "v2",
"caption": "Cooling Electricity [kWh]",
"scaling": false,
"min": 0,
"max": 10000,
"weight": 1
}
]
}
@Ivan Korolija: could you please have a look on my coding and try to find out why my RVX/RVI files are not working. Thanks a lot.