First time here? Check our help page!
3

Extracting hourly time step data from SQL file

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.

ParticleSwarm's avatar
389
ParticleSwarm
asked 2018-07-02 09:08:01 -0500
__AmirRoth__'s avatar
4.4k
__AmirRoth__
updated 2020-01-27 18:44:55 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

2

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'.

ericringold's avatar
10.6k
ericringold
answered 2018-07-02 09:28:59 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments