Extracting hourly time step data from SQL file - Unmet Hours

First time here? Check out the Help page!

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 6 years ago

ParticleSwarm
389 ●6

updated 5 years ago

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.

1 Answer

Sort by » oldest newest most voted

2

answered 6 years ago

flag of United States of America

10692 ●34 ●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'.

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: 6 years ago

Seen: 270 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