Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

asked 2015-08-07 08:56:00 -0500

Xandrika's avatar

Jeplus+EA does not find objective funcion in RVI files

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:

image description

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

!-objectives
Heating Electriciy;kWh,c1
Cooling Electriciy;kWh,c2
!-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" : "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]",
        "scaling" : true,
        "min" : 0,
        "max" : 10000,
        "weight" : 1.0
    },
    {
        "identifier" : "t2",
        "formula" : "v2",
        "caption" : "Cooling Electricity [kWh]",
        "scaling" : false,
        "min" : 0,
        "max" : 10000,
        "weight" : 1.0
    }
]

}

Jeplus+EA does not find objective funcion in RVI files

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:

image description

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,c1
Electriciy; kWh; c0
Cooling Electriciy;kWh,c2
Electriciy; kWh; c1
!-end objectives

my rvx RVX file:

{

"notes" : {
    "notes": "Some notes about this RVX",

"rvis" : [ 
    { 
        "fileName" :     "rvis": [
        {
            "fileName": "my_LCCA.rvi",
        "tableName" :     "tableName": "SimResults"
     }
 ],

"sqls" :     "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" : "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" :     "caption": "Heating Electricity [kWh]",
        "scaling" :     "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" :     "min": 0,
        "max" :     "max": 10000,
        "weight" : 1.0
    "weight": 1
        },
     {
        "identifier" :     "identifier": "t2",
        "formula" :     "formula": "v2",
        "caption" :     "caption": "Cooling Electricity [kWh]",
        "scaling" :     "scaling": false,
        "min" :     "min": 0,
        "max" :     "max": 10000,
        "weight" : 1.0
    "weight": 1
        }
 ]
}

}

click to hide/show revision 3
retagged

updated 2015-11-13 11:41:44 -0500

__AmirRoth__'s avatar

Jeplus+EA does not find objective funcion in RVI files

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:

image description

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
        }
    ]
}
click to hide/show revision 4
No.4 Revision

updated 2015-11-13 11:42:16 -0500

__AmirRoth__'s avatar

Jeplus+EA does not find objective funcion in RVI files

Hi all,

I was running successfully Jeplis+EA 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:

image description

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
        }
    ]
}
About | Help | Privacy | Legal | Contact
Site design and logo: Copyright © 2015 Big Ladder Software LLC. All rights reserved.
The Unmet Hours and Big Ladder names and logos are trademarks of Big Ladder Software LLC.
User contributions licensed under the Creative Commons Attribution Share Alike 3.0 License.
Powered by