Hi all,

I was running successfully Jeplus+EA Jeplis+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
        }
    ]
}

Hi all,

I was running successfully Jeplis+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
        }
    ]
}

Hi all,

I was running successfully Jeplis+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
Electricity:HVAC
Heating:Electricity
Cooling:Electricity
Zone Ventilation Total Heat Loss Energy
Zone Ventilation Total Heat Gain Energy
Zone Infiltration Total Heat Loss Energy
Zone Infiltration Total Heat Gain Energy]
Zone Windows Total Heat Gain Energy
Zone Windows Total Heat Loss Energy
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
Electriciy;kWh,c1
Cooling Electriciy; kWh; c1
Electriciy;kWh,c2
!-end objectives

my RVX rvx file:

{

{
    "notes": "notes" : "Some notes about this RVX",
    "rvis": 
"rvis" : [ 
    { 
        "fileName" : "my_LCCA.rvi",
        "tableName" : "SimResults"
    }
],

"sqls" : [
        {
            "fileName": "my_LCCA.rvi",
            "tableName": "SimResults"
        }
    ],
    "sqls": [
        {
            "tableName": { 
        "tableName" : "Heating_Electricity",
            "columnHeaders": "columnHeaders" : "Heating Electricity [kWh]",
            "sqlcommand": "sqlcommand" : "SELECT Value FROM TabularDataWithStrings WHERE (TableName='End Uses' AND RowName='Heating' AND ColumnName='Electricity')"
     },
        {
            "tableName": { 
        "tableName" : "Cooling_Electricity",
            "columnHeaders": "columnHeaders" : "Cooling Electricity [kWh]",
            "sqlcommand": "sqlcommand" : "SELECT Value FROM TabularDataWithStrings WHERE (TableName='End Uses' AND RowName='Cooling' AND ColumnName='Electricity')"
        },
        {
            "tableName": }
    { 
        "tableName" : "HVAC_Electricity_Intensity",
            "columnHeaders": "columnHeaders" : "HVAC Electricity Intensity [kWh/m2]",
            "sqlcommand": "sqlcommand" : "SELECT Value FROM TabularDataWithStrings WHERE (TableName='Utility Use Per Conditioned Floor Area' AND RowName='HVAC' AND ColumnName='Electricity Intensity')"
     }
 ],
    "scripts": 
"scripts" : [
        {}
    {

    }
],
    "userVars": 
"userVars" : [
     {
            "identifier": "identifier" : "v0",
            "formula": "formula" : "c0",
            "caption": "caption" : "Variable 0 []",
        "report" : true
    },
    {
        "identifier" : "v1",
        "formula" : "c1",
        "caption" : "Variable 9 []",
        "report" : false
    },
            {
        "identifier" : "v2",
        "formula" : "c10",
        "caption" : "Variable 10 []",
        "report" : true
    }
    {
        "identifier" : "v3",
        "formula" : "c2",
        "caption" : "Variable 11 []",
        "report" : false
    }
],

"constraints" : [
    {
    }
],

"objectives" : [
    {
        "identifier" : "t1",
        "formula" : "v1",
        "caption" : "Heating Electricity [kWh]",
            "report": true
    "scaling" : true,
        "min" : 0,
        "max" : 10000,
        "weight" : 1.0
    },
     {
            "identifier": "v1",
            "formula": "c1",
            "caption": "Cooling_Electricity [kWh]",
            "report": true
        },
        {
            "identifier": "identifier" : "t2",
        "formula" : "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": "caption" : "Cooling Electricity [kWh]",
            "scaling": "scaling" : false,
            "min": "min" : 0,
            "max": "max" : 10000,
            "weight": 1
    "weight" : 1.0
    }
 ]
}