[Bldg-sim] energy plus/open studio hourly results (DView)

Thu Jun 20 12:03:57 PDT 2019

I sincerely appreciate the spirit of building bridges in 2 directions, thanks so much Mike!

Out of curiosity, does energy+ as an engine, or else any of its major interfaces, permit an end-user to tweak this .sql output to always (by default, with all projects) include as an example drybulb and wetbulb at intervals to match the source weather data fed in, or are the contents/structure of this particular output kinda “boxed up?”

With your input, I might suggest some additional steps for anyone following along:

  *   Trimming and/or isolating the first ### rows of data to review regular simulation and design day information separately. Alternatively these are likely tagged in some fashion I haven’t discovered yet in the SQL structure and could be filtered in/out based on that tag.
  *   By using ReportVariableWithTime, it sounds like you can avoid the extra steps I suggested to convert the interval count (the x-axes in the visuals below) into DateTime format.
  *   Once pivot charts/tables have properly formatted DateTime stamps generated (or fed in), they can do a number of new magical things around grouping and displaying min/max/avg/more-complicated calcs with dynamic grouping.  So for example with the same query you could have a visual that lets you start at an annual 12-month view then “zoom” into a specific month/week/day/hour to see the data at its full resolution or any grouping in between.

~Nick

[cid:image005.png at 01D515A3.47EDD880]
Nick Caton, P.E., BEMP
  Senior Energy Engineer
  Regional Energy Engineering Manager
  Energy and Sustainability Services
  Energy Performance Contracting
D
M
F
E
913 . 564 . 6361
785 . 410 . 3317
913 . 564 . 6380
nicholas.caton at se.com<mailto:nicholas.caton at se.com>
15200 Santa Fe Trail Drive
Suite 204
Lenexa, KS 66219
United States
[cid:image006.png at 01D515A3.47EDD880]

From: Bldg-sim <bldg-sim-bounces at lists.onebuilding.org> On Behalf Of Michael J Witte via Bldg-sim
Sent: Tuesday, June 18, 2019 5:03 PM
To: bldg-sim at lists.onebuilding.org
Subject: Re: [Bldg-sim] energy plus/open studio hourly results (DView)

[External email: Use caution with links and attachments]

________________________________

Nick,

Very nice tutorial - learned something new.

Just to clear up the anomalies that you noticed. The outdoor dry bulb temperature in this sql output is reported as monthly average, while the wet bulb is reported hourly. Also, the data starts with the summer and winter design days followed by the annual simulation, which explains the high chiller use at the beginning of the data.

In general, the data table "ReportVariableDataWithTime" is a better one to look at, because it includes the date/time data.

And, by the way, by browsing the file this way, I noticed that the TimestepType fields are wrong.
https://github.com/NREL/EnergyPlus/issues/7342<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FNREL%2FEnergyPlus%2Fissues%2F7342&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807209123&sdata=zzZDZPZ8puNBkql%2BUy6tQGir2kN54TmbYy%2ByAC2FtdE%3D&reserved=0>

Mike

On 6/17/2019 1:35 PM, Jim Dirkes via Bldg-sim wrote:
As you might expect from Nick, the "big shout out" is really for my 2% contribution to his 98%. I'm inclined to pay his hourly rate just to soak up his insight and energy ��.

James V Dirkes II, PE, BEMP, BCxP
Team Lead - Building Performance
616 450 8653
Foresight Management
https://fsmgmt.co/<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffsmgmt.co%2F&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807219119&sdata=G5NSTyplY%2FOGqqTwsSrGEYfFhazDM%2BdbngoBZdyv32Q%3D&reserved=0>

Coffee Conversation:

But to handle human lives with no agreement as to what human beings are or what the purpose of life is - that is a formula for chaos.

________________________________
From: Nicholas Caton <Nicholas.Caton at se.com><mailto:Nicholas.Caton at se.com>
Sent: Monday, June 17, 2019 1:38 PM
To: Gurneet Singh; Karol Bandurski
Cc: bldg-sim at onebuilding.org<mailto:bldg-sim at onebuilding.org>; Jim Dirkes
Subject: RE: [Bldg-sim] energy plus/open studio hourly results (DView)

Sorry, I meant to attach the working example for others to pull down and explore.  Here is a link (it’s a bit smaller in heft than the source file, clocking ~28MB).

https://1drv.ms/f/s!ApiLEhvYf5QZgrIYNhCVb7TszGKpjw<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2F1drv.ms%2Ff%2Fs!ApiLEhvYf5QZgrIYNhCVb7TszGKpjw&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807219119&sdata=58%2Fq4TO4uwMMVYGA0%2B4RWmQQzDjEa5ZtBowN58ZhY4Q%3D&reserved=0>

~Nick

[cid:image005.png at 01D515A3.47EDD880]

Nick Caton, P.E., BEMP

  Senior Energy Engineer
  Regional Energy Engineering Manager

  Energy and Sustainability Services
  Energy Performance Contracting

D
M
F
E

913 . 564 . 6361

785 . 410 . 3317

913 . 564 . 6380

nicholas.caton at se.com<mailto:nicholas.caton at se.com>

15200 Santa Fe Trail Drive
Suite 204
Lenexa, KS 66219
United States

[cid:image006.png at 01D515A3.47EDD880]

From: Nicholas Caton
Sent: Monday, June 17, 2019 12:34 PM
To: Gurneet Singh <gurneet at edsglobal.com><mailto:gurneet at edsglobal.com>; Karol Bandurski <karol.bandurski at put.poznan.pl><mailto:karol.bandurski at put.poznan.pl>
Cc: bldg-sim at onebuilding.org<mailto:bldg-sim at onebuilding.org>; Jim Dirkes <Jim at fsmgmt.co><mailto:Jim at fsmgmt.co>
Subject: RE: [Bldg-sim] energy plus/open studio hourly results (DView)

BIG SHOUTOUT TO JIM DIRKES!  He helped me with making this a potentially useful contribution for the e+ folks out there.

I’ll also preface that what I’m covering is an intro to a skillset ANY simulation engine/platform practicioner might want to learn more about.  I make extremely regular use of power queries for input/output handling, manipulation/processing, QC, and effective visualization of my findings.

I can see a way to manipulate this example file into automated CSV exports, Excel tables, and/or to go a step further and create your own automated & dynamic output visualizations.  Very similar in endgame results to DView but with a lot more potential to create a suite custom-tailored to your own individual needs.

Noting the extension of the output file is .sql, I decided to give something a try, with positive results!  This approach requires either PowerBI Desktop (free download from MS), or else a version of Excel newer than 2013.

My provided example if you want to follow along is using O365 (most current version of Excel that my IT team has rolled out), so if you’re using PowerBI, or Excel 2013/2016 you might find things are named/organized slightly differently.

https://www.biinsight.com/visualise-sqlite-data-in-power-bi/<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.biinsight.com%2Fvisualise-sqlite-data-in-power-bi%2F&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807229110&sdata=uy4HO%2B4ncWBwSu0nIGH0HR39l4jBlWJH%2F%2BzydxHFyGw%3D&reserved=0>

Step 0 (required only the first time you do this)

  *   Install SQLite ODBC driver: Install 32 vs 64 bit version to match your version of Excel/PowerBI desktop.
  *   http://www.ch-werner.de/sqliteodbc/<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ch-werner.de%2Fsqliteodbc%2F&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807229110&sdata=Gp6sKQqERhod4YpmqQXrk8ugTw5fJNjH5Jf8uncjnPA%3D&reserved=0>

Step 1:

  *   Open a new Excel worksheet
  *   Data tab, Get Data, From Other Sources, From ODBC

[cid:image003.png at 01D52683.9C843920]

Step 2

  *   Select “SQLite3 Datasource”
  *   Click Advanced, and in the first field type “database=” followed by the SQLite file path (to your energyplus export SQL file)
  *   Click OK

[cid:image004.png at 01D52683.9C843920]

Step 3

  *   In the next dialog, click “Default or Custom”
  *   Click Connect

[cid:image005.png at 01D52683.9C843920]

Step 4

  *   … and we’re in!

[cid:image006.png at 01D52683.9C843920]

  *   At this point, if you have some familiarity with Excel power queries and/or SQL databases, you can probably fly on your own and begin automating visualizations, QC measures, and/or simple table/CSV exports for manipulation/review in other workbooks.
  *   Of note, everything we just stepped through (and visualization/export options to follow) could be fully automated, to the extent you could define consistently needed data/visualations of the contents of a typical sql output.  This would allow you to, for example immediately create/refresh results once you have a set of outputs/visuals that you like.

Steps 5+

  *   For those still unfamiliar with power queries and similar, I’m providing a couple a couple “proof of concept” examples you might be interested to review and explore.  This workbook includes the examples illustrated, for perusal.
  *   From here, I’ll emphasis that I as an individual am NOT savvy to e+ output conventions (doe2 is still my daily workhorse engine).  I am however trying to give a sense of what’s possible for those of you with an e+ interest to get your feet wet.
  *   I first married the ReportVariableData and ReportVariableDataDictionary tables within the SQL source.  This combines the raw timestep and numerical values with human-legible/interpretable descriptions of what those values/timesteps represent.  The result is the query titled ReportData+Dictionary in the provided example workbook.  (One could substantially streamline this source pull into a single query, but I left it in this stepped-out form to help new folks pick up the example).
  *   I also did some minimal housekeeping to trim unnecessary (Assumptions made!) columns for the final output, and to combine stuff like units into the variable name text strings.
  *   Then, on creating a pivot table/chart pointing at this new query, I can add 1+ slicers and immediately allow for dynamically investigate any combination of variables at the resolution of their native timestep (determined way back at the e+ model).  Again, I see substantial potential for streamlining this to automate the sum/averaging/max/min operations of variable values, to reduce the amount of data being loaded up here for visualization.  Someone further invested in the e+ ecosystem would likely see the value in that and be driven to cut the fluff in the standard outputs further – leaving this as a strong suggestion if you’re still reading 😉.

     *   An overlay of “district” heating and cooling energies.

        *   A simple observation – If I’m correct in assuming the first time intervals of this simulation are at/around January 1, then someone may want to look into the peak cooling draws in the dead of winter here!

[cid:image007.png at 01D52683.9C843920]

     *   Digging into Zone temps:

        *   Looks like the variable KeyValue from the ReportDictionary query is necessary for distinguishing between different zones you might want to report on.  I’ve added that as a secondary slicer.
        *   Note you can overlay one or more different zones by playing with the slicer on the right, or switch over to other zonal variables options using the slicer on the left.
        *   In any case, we can observe a couple interesting points:

           *   All of the 4 zones have temperatures in the ballpark of 27C for the same period you see the preceding monster cooling load spike… discomfort follows that energy jump!
           *   The rest of this looks like fairly regular setback behavior, although…
           *   It appears your systems’ as specified are struggling to keep up with the zonal temperature setpoint for portions of the summer (where we see little humps rising above the flatline).

[cid:image008.png at 01D52683.9C843920]

     *   How about the weather?

        *   Checking out Drybulb and Wetbulb (both in C),

           *   Overlaying both:

[cid:image009.png at 01D52683.9C843920]

           *   Wetbulb generally appears fairly normal – although hey!  It looks like part of the reason for your simulation’s cooling jump at the beginning is due to it being pretty hot outside (jumping higher even than your summertime peak) for those first 1000 or so intervals!
           *   Drybulb is a little funny… This may be more intuitive to e+ veterans for some quirk/feature I haven’t learned yet, but it appears your simulation only has ~19 distinct values at disparate time intervals for outside drybulb… confirmed this isn’t an artifact of Excel’s visualization limitations by diving back into the source query:

[cid:image010.png at 01D52683.9C843920]

I sincerely hope this example is instructive and provides someone out there with the motivation/interest to build a new skillset!  If after this anyone grows “query-savvy…” be sure to touch base with me so I’m personally aware – I might someday want to poach you (back?) into the doe2 world 😉!

Best regards,

~Nick

[cid:image005.png at 01D515A3.47EDD880]

Nick Caton, P.E., BEMP

  Senior Energy Engineer
  Regional Energy Engineering Manager

  Energy and Sustainability Services
  Energy Performance Contracting

D
M
F
E

913 . 564 . 6361

785 . 410 . 3317

913 . 564 . 6380

15200 Santa Fe Trail Drive
Suite 204
Lenexa, KS 66219
United States

[cid:image006.png at 01D515A3.47EDD880]

From: Bldg-sim <bldg-sim-bounces at lists.onebuilding.org<mailto:bldg-sim-bounces at lists.onebuilding.org>> On Behalf Of Gurneet Singh via Bldg-sim
Sent: Monday, June 17, 2019 9:04 AM
To: Karol Bandurski <karol.bandurski at put.poznan.pl<mailto:karol.bandurski at put.poznan.pl>>
Cc: bldg-sim <bldg-sim at lists.onebuilding.org<mailto:bldg-sim at lists.onebuilding.org>>
Subject: Re: [Bldg-sim] energy plus/open studio hourly results (DView)

[External email: Use caution with links and attachments]

________________________________

Hi Karol,

You can use the openstudio measure to export an output variable in csv or xls file format. You have to use this in conjunction with Add Output Variable measure.

Add Output Variable: https://bcl.nrel.gov/node/37843<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbcl.nrel.gov%2Fnode%2F37843&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807229110&sdata=Pa1BTUnFzZrcHA6XlaSGqBpxBwrpRdT8DYkzJnz%2FlYg%3D&reserved=0>

Export Output Variable : https://bcl.nrel.gov/node/83268<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbcl.nrel.gov%2Fnode%2F83268&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807239105&sdata=rwoAcY2oWSh5KIit%2FALBIKunG7SCCldLv%2BNH%2F5CNjDA%3D&reserved=0>

I hope it helps.

Regards

Gurneet Singh

Director

Environmental Design Solutions Pvt. Ltd.

D-1/25, Vasant Vihar, New Delhi 110057

[m] +91 9899240140    [t] +91 11 2614 7085    [f] +91 11 4056 8633

gurneet at edsglobal.com<mailto:gurneet at edsglobal.com> | www.edsglobal.com<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.edsglobal.com%2F&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807249098&sdata=yzAiM8fRV7%2FluiajYAs5%2B8VN6r2xIgvS6RyZpjzQ4DM%3D&reserved=0>

On Mon, Jun 17, 2019 at 4:18 PM Karol Bandurski via Bldg-sim <bldg-sim at lists.onebuilding.org<mailto:bldg-sim at lists.onebuilding.org>> wrote:

Dear Experts,

We start work with student in OpenStudio. Now we would like to explore hourly results.

1)      Is some simple way to export all hourly results to *.csv / *.xls format?

2)      We try to use DView. But it is not manage to open file, it close itself. What could be wrong…

Our file:

https://www.dropbox.com/s/7c87etxszrlwbiz/eplusout.sql?dl=0<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dropbox.com%2Fs%2F7c87etxszrlwbiz%2Feplusout.sql%3Fdl%3D0&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807249098&sdata=tr9blNscI4TwTVDtkXE0JNzGeZp5NwzcXmkAI1ZyCco%3D&reserved=0>

Kind regards,
Karol

--------------------------------------------------------------------

Karol BANDURSKI M. Sc.

Faculty of Civil and Environemntal Engeneering

Division of Heating, Air Conditioning and Air Protection

Poznan University of Technology

https://www.researchgate.net/profile/Karol_Bandurski<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.researchgate.net%2Fprofile%2FKarol_Bandurski&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807259093&sdata=AzvfOuI%2BgN88KSxtPNbTvhvnkMDpY0MhkBzNwuWfc0w%3D&reserved=0>

www.put.poznan.pl/~karol.bandurski<https://eur02.safelinks.protection.outlook.com/?url=http:%2F%2Fwww.put.poznan.pl%2F~karol.bandurski&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807259093&sdata=QGKPTy%2BYeZpNn7sE9uKugXecZV2pyPYtIa88UXFACJQ%3D&reserved=0>

_______________________________________________
Bldg-sim mailing list
http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.onebuilding.org%2Flistinfo.cgi%2Fbldg-sim-onebuilding.org&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807269087&sdata=Nlr0x7SrJyBhD0AUC5ipr%2BIlFuCq8CuNBvUHnYb9rqY%3D&reserved=0>
To unsubscribe from this mailing list send  a blank message to BLDG-SIM-UNSUBSCRIBE at ONEBUILDING.ORG<mailto:BLDG-SIM-UNSUBSCRIBE at ONEBUILDING.ORG>

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
______________________________________________________________________

_______________________________________________

Bldg-sim mailing list

http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.onebuilding.org%2Flistinfo.cgi%2Fbldg-sim-onebuilding.org&data=02%7C01%7CNicholas.Caton%40se.com%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807269087&sdata=Nlr0x7SrJyBhD0AUC5ipr%2BIlFuCq8CuNBvUHnYb9rqY%3D&reserved=0>

To unsubscribe from this mailing list send  a blank message to BLDG-SIM-UNSUBSCRIBE at ONEBUILDING.ORG<mailto:BLDG-SIM-UNSUBSCRIBE at ONEBUILDING.ORG>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 255 bytes
Desc: image001.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0020.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 8477 bytes
Desc: image002.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0021.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 57402 bytes
Desc: image003.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0022.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 21638 bytes
Desc: image004.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0023.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 20646 bytes
Desc: image005.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0024.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 43030 bytes
Desc: image006.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0025.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 70445 bytes
Desc: image007.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0026.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image008.png
Type: image/png
Size: 46181 bytes
Desc: image008.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0027.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.png
Type: image/png
Size: 87251 bytes
Desc: image009.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0028.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image010.png
Type: image/png
Size: 44383 bytes
Desc: image010.png
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20190620/c4af84b9/attachment-0029.png>