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

Extracting hourly time step data from SQL file

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

ParticleSwarm's avatar

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

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 -0500

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

Careers

Question Tools

1 follower

Stats

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

Seen: 215 times

Last updated: Jul 02 '18