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

Extracting hourly time step data from SQL file

asked 2018-07-02 09:08:01 -0600

ParticleSwarm's avatar

updated 2020-01-27 18:44:55 -0600

Hello all!

I am writing a custom reporting measure to collect all of the hourly time step data for Electricity:Facility. I am attempting to construct something similar to the Data Viewer representation. Going through the SQL documentation on OpenStudio, I was not able to find a specific function to accomplish this, and a query to the E+ table would not give me the hourly step. I am wondering if there is a way to leverage the SQL file to grab hourly data around Electricity:Facility.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-07-02 09:28:59 -0600

I believe the SqlFile class method timeSeries is what you want, shown here, also here.

For an example of how it can be used, look into the BCL measure 'unmet load hours troubleshooting'.

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

Training Workshops

Question Tools

1 follower


Asked: 2018-07-02 09:08:01 -0600

Seen: 190 times

Last updated: Jul 02 '18