Yes,Â
What I do is generate an SQlite file, then setup your sql queries and use them with a python script in jE+ to process the queried data.Â
 Below is an example script that I use in my projects, and you can find out more about using jE+ with SQlite here: http://www.jeplus.org/wiki/doku.php?id=docs:videos:3_sqlite
{
"notes" : "Some notes about this RVX",
"rvis" : [Â
{Â
"fileName" : "null.rvi",
"tableName" : "SimResults"
}
],
"sqls" : [
{Â
"tableName" : "TotalEnergy",
"columnHeaders" : "Total Energy [kWh]",
"sqlcommand" : "SELECT Value FROM TabularDataWithStrings WHERE (ReportName= 'AnnualBuildingUtilityPerformanceSummary' AND TableName='Site and Source Energy' AND RowName= 'Total Site Energy' AND ColumnName= 'Total Energy')"
},
{Â
"tableName" : "IdealHeatingEnergy",
"columnHeaders" : "Ideal Heating Energy [kWh]",
"sqlcommand" : "SELECT Value FROM TabularDataWithStrings WHERE (ReportName= 'AnnualBuildingUtilityPerformanceSummary' AND TableName ='End Uses' AND RowName ='Heating' AND ColumnName = 'District Heating')"
},
{Â
"tableName" : "IdealCoolingEnergy",
"columnHeaders" : "Ideal Cooling Energy [kWh]",
"sqlcommand" : "SELECT Value FROM TabularDataWithStrings WHERE (ReportName= 'AnnualBuildingUtilityPerformanceSummary' AND TableName ='End Uses' AND RowName ='Cooling' AND ColumnName = 'District Cooling')"
},
{Â
"tableName" : "TotalCoolingLoad",
"columnHeaders" : "Calculated Design Cooling Load [W]",
"sqlcommand" : "SELECT SUM(DesLoad) FROM ZoneSizes WHERE LoadType='Cooling'"
},
{Â
"tableName" : "TotalHeatingLoad",
"columnHeaders" : "Calculated Design Heating Load [W]",
"sqlcommand" : "SELECT SUM(DesLoad) FROM ZoneSizes WHERE LoadType='Heating'"
},
{Â
"tableName" : "AdaptiveComfortReport",
"columnHeaders" : "Time Outside ASHRAE55 80% Acceptability Limits []",
"sqlcommand" : "SELECT SUM (Value) FROM TabularDataWithStrings WHERE (ReportName= 'AdaptiveComfortReport' AND TableName ='People Summary' AND ColumnName= 'ASHRAE55 80% Acceptability Limits')"
},
{Â
"tableName" : "ConsCost",
"columnHeaders" : "Construction Cost [$]",
"sqlcommand" : "Select Value from TabularDataWithStrings WHERE (RowName ='Line Item SubTotal' AND ColumnName = 'SubTotal ~~$~~')"
}
],
"userVars" : [
{
"identifier" : "v1",
"formula" : "c1",
"caption" : "Heating Energy Demand [kWh]",
"report" : true
},
{
"identifier" : "v2",
"formula" : "c2",
"caption" : "Cooling Energy Demand [kWh]",
"report" : true
},
{
"identifier" : "v3",
"formula" : "c1*0.60",
"caption" : "Heating Energy [kWh]",
"report" : true
},
{
"identifier" : "v4",
"formula" : "c2*0.76",
"caption" : "Cooling Energy [kWh]",
"report" : true
}
],
"constraints" : [
{
"identifier" : "s1",
"formula" : "v1/1000",
"caption" : "This is an example [kW]",
"scaling" : true,
"lb" : 0,
"ub" : 200,
"min" : 0,
"max" : 300,
"weight" : 1.0
}
],
"objectives" : [
{
"identifier" : "t1",
"formula" : "v3+v4",
"caption" : "HVAC Energy [kWh]",
"scaling" : false,
"min" : 0,
"max" : 100000,
"weight" : 1.0
},
{
"identifier" : "t2",
"formula" : "c3/1000",
"caption" : "Cooling Load [kW]",
"scaling" : false,
"min" : 0,
"max" : 100000,
"weight" : 1.0
},
{
"identifier" : "t3",
"formula" : "c4/1000",
"caption" : "Heating Load [kW]",
"scaling" : false,
"min" : 0,
"max" : 100000,
"weight" : 1.0
},
{
"identifier" : "t4",
"formula" : "c5",
"caption" : "Discomfort Hours [hr]",
"scaling" : false,
"min" : 0,
"max" : 100000,
"weight" : 1.0
},
{
"identifier" : "t5",
"formula" : "c6",
"caption" : "Construction Cost [$]",
"scaling" : false,
"min" : 0,
"max" : 100000,
"weight" : 1.0
}
]
}
â??â??
Jeremiah D. Crossett  | Applications Engineer  | LEED Green Associate   ![]()
On Wed, Dec 3, 2014 at 10:39 PM, m.waseemahmad@xxxxxxxxxxx [EnergyPlus_Support] <EnergyPlus_Support@xxxxxxxxxxxxxxx> wrote:
ÂHello Jeremiah and Jean,
Thanks for your help. But, this gives results in HTML format? I want something so that I can easily read that data into a computer program where I have to do other things with it. e.g. getting this data and then running some control algorithm based on percentage of people dissatisfied etc.An Excel output may be easy for me to handle, any ideas?ThanksKindest RegardsWaseem
__._,_.___
Posted by: Jeremiah Crossett <jcrossett@xxxxxxxxxxxxxxx>
Primary EnergyPlus support is found at:
http://energyplus.helpserve.com or send a message to energyplus-support@xxxxxxxx
The primary EnergyPlus web site is found at:
http://www.energyplus.gov
The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/
Attachments are currently allowed but be mindful that not everyone has a high speed connection. Limit attachments to small files.
EnergyPlus Documentation is searchable. Open EPlusMainMenu.pdf under the Documentation link and press the "search" button.