Question-and-Answer Resource for the Building Energy Modeling Community

Get started with the Help page

3

Extracting hourly time step data from SQL file

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

ParticleSwarm
389 ●6

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

flag of United States of America

4446 ●5 ●17 http://bleedinggreenna...

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

2

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

flag of United States of America

10672 ●33 ●8 https://www.nrel.gov/b...

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

Your Answer

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

Training Workshops

Careers

Question Tools

1 follower

Stats

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

Seen: 243 times

Last updated: Jul 02 '18

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