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

EnergyPlus End Uses By Subcategory Table from eplusout.sql

asked 2017-11-21 18:39:43 -0600

gmehta75 gravatar image

updated 2017-11-24 08:51:42 -0600

I am using DB Browser for SQLite to read the eplusout.sql. I am having trouble with End Uses By Subcategory table. It does not appear as I would like it to appear.

Here is what I have tried:

Select ColumnName as "Utility", Rowname as "End Use", Value as "Subcategory",   Units
from TabularDataWithStrings WHERE ReportName = "AnnualBuildingUtilityPerformanceSummary"
and TableName = "End Uses By Subcategory"

Can anyone suggest any edits to the above query or if the information exists elsewhere and two tables need to be joined.

edit retag flag offensive close merge delete


Can you provide examples of how it appears and how you would like it to appear?

shorowit gravatar imageshorowit ( 2017-11-22 10:31:08 -0600 )edit

I would like it to appear as Electricity, Natural Gas, District Heating....etc under column titled Utility, end uses under column titled End Use, Subcategories such as Fans, zone exhaust fans, etc under column titled Subcategory, energy consumption under column titled Value and GJ, m3, etc. under column titled Units.

When I run the above query, the Utility column includes the text Subcategory repeated and after a number of rows Electricity, Natural Gas, etc. appear. All the information is there but its not organized the way I would like it to be.

gmehta75 gravatar imagegmehta75 ( 2017-11-22 15:58:29 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2017-11-23 08:48:56 -0600

updated 2017-11-23 08:49:13 -0600

The problem is the structure of the underlying SQL, it doesn't really has a subcategory column so it ends up being positional...

Try this query:

SELECT ColumnName as "Utility", Rowname as "End Use", Value,   Units
FROM TabularDataWithStrings 
WHERE ReportName = "AnnualBuildingUtilityPerformanceSummary"
AND ReportForString='Entire Facility'
AND TableName = "End Uses By Subcategory"
// Optional: AND ColumnName != "Subcategory"

If you just pivot the Utility column it should look like the HTML report I think. There is no pivot in SQLite, so I'd just do it somewhere else (python is my goto for that), but you could write a verbose JOIN query to do that in SQLite

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer


Question Tools

1 follower


Asked: 2017-11-21 18:39:43 -0600

Seen: 103 times

Last updated: Nov 23 '17