<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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
<span id="��" title=":slight_smile:">��.</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div></div>
<div></div>
<div></div>
<div></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<div style="margin:0px; font-size:15px; color:rgb(33,33,33); text-align:start; background-color:rgb(255,255,255)">
James V Dirkes II, PE, BEMP, BCxP</div>
<div style="margin:0px; font-size:15px; color:rgb(33,33,33); text-align:start; background-color:rgb(255,255,255)">
Team Lead - Building Performance</div>
<div style="margin:0px; font-size:15px; color:rgb(33,33,33); text-align:start; background-color:rgb(255,255,255)">
<span style="font-family:Calibri,Helvetica,sans-serif; background-color:rgb(255,255,255); display:inline!important">616 450 8653</span></div>
<div style="margin:0px; font-size:15px; color:rgb(33,33,33); text-align:start; background-color:rgb(255,255,255)">
Foresight Management</div>
<div style="margin:0px; font-size:15px; color:rgb(33,33,33); text-align:start; background-color:rgb(255,255,255)">
<span style="margin:0px; font-size:16px; font-family:Calibri,sans-serif; color:blue; text-decoration:underline; background-color:rgb(255,255,255)"><a href="https://fsmgmt.co/" target="_blank" rel="noopener noreferrer" style="margin:0px; font-size:16px; font-family:Calibri,sans-serif; color:rgb(149,79,114); text-decoration:underline; background-color:rgb(255,255,255)">https://fsmgmt.co/</a></span></div>
<div style="margin:0px; font-size:15px; color:rgb(33,33,33); text-align:start; background-color:rgb(255,255,255)">
<br>
</div>
<div style="margin:0px; font-size:15px; color:rgb(33,33,33); text-align:start; background-color:rgb(255,255,255)">
<span style="font-family:Calibri,Helvetica,sans-serif; font-size:11pt"><b>Coffee Conversation:</b></span></div>
<div style="margin:0px; font-size:15px; color:rgb(33,33,33); text-align:start; background-color:rgb(255,255,255)">
<span style="font-family:Calibri,Helvetica,sans-serif; font-size:11pt">
<p style="margin:0in 0in 6pt; font-size:12pt; font-family:"Times New Roman",serif">
<span style="font-size:10pt; font-family:Calibri,sans-serif; color:rgb(51,51,51); background:white"></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:"Times New Roman",serif; margin-bottom:6.0pt; text-autospace:none">
<span style="font-size:10.0pt; font-family:"Calibri",sans-serif; color:#333333; background:white"></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:"Times New Roman",serif; margin-bottom:6.0pt; text-autospace:none">
<span style="font-size:10.0pt; font-family:"Calibri",sans-serif; color:#333333; background:white">But to handle human lives with no agreement as to
<i><b>what human beings are</b></i> or <b><i>what the purpose of life is</i> </b>
- that is a formula for chaos.</span></p>
</span>
<p></p>
<p></p>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Nicholas Caton <Nicholas.Caton@se.com><br>
<b>Sent:</b> Monday, June 17, 2019 1:38 PM<br>
<b>To:</b> Gurneet Singh; Karol Bandurski<br>
<b>Cc:</b> bldg-sim@onebuilding.org; Jim Dirkes<br>
<b>Subject:</b> RE: [Bldg-sim] energy plus/open studio hourly results (DView)</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:Wingdings}
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:"Segoe UI Emoji"}
@font-face
{font-family:Georgia}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.x_MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p.x_MsoListParagraph, li.x_MsoListParagraph, div.x_MsoListParagraph
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
p.x_msonormal0, li.x_msonormal0, div.x_msonormal0
{margin-right:0in;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
p.x_gmail-m2907845280526664084msolistparagraph, li.x_gmail-m2907845280526664084msolistparagraph, div.x_gmail-m2907845280526664084msolistparagraph
{margin-right:0in;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.x_EmailStyle20
{font-family:"Calibri",sans-serif;
color:windowtext}
span.x_EmailStyle23
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
ol
{margin-bottom:0in}
ul
{margin-bottom:0in}
-->
</style>
<div lang="EN-US" link="blue" vlink="purple">
<div class="x_WordSection1">
<p class="x_MsoNormal">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).</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><a href="https://1drv.ms/f/s!ApiLEhvYf5QZgrIYNhCVb7TszGKpjw">https://1drv.ms/f/s!ApiLEhvYf5QZgrIYNhCVb7TszGKpjw</a></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">~Nick</p>
<p class="x_MsoNormal"> </p>
<div>
<p class="x_MsoNormal"><span style="font-family:"Arial",sans-serif; color:#3A7A46"><img border="0" width="726" height="9" id="x__x0000_i1037" alt="cid:image005.png@01D515A3.47EDD880" style="width:7.5625in; height:.0937in" data-outlook-trace="F:1|T:1" src="cid:image002.png@01D52509.9351C280"></span></p>
<p class="x_MsoNormal"><b><span style="font-family:"Arial",sans-serif; color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="color:#3A7A46"></span></p>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="724" style="width:543.0pt; border-collapse:collapse">
<tbody>
<tr>
<td width="230" valign="top" style="width:172.3pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"> Senior Energy Engineer</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"> Regional Energy Engineering Manager</span></p>
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"> Energy and Sustainability Services</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"> Energy Performance Contracting
</span><span style="font-size:9.0pt; color:#1F497D"></span></p>
</td>
<td width="16" valign="top" style="width:11.8pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#57B069">D </span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#57B069">M </span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#57B069">F </span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#57B069">E </span><span style="font-size:9.0pt; color:#1F497D">
</span></p>
</td>
<td width="275" valign="top" style="width:206.5pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">913 . 564 . 6361</span></p>
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">785 . 410 . 3317</span></p>
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">913 . 564 . 6380</span></p>
<p class="x_MsoNormal"><u><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"><a href="mailto:nicholas.caton@se.com"><span style="font-family:"Calibri",sans-serif; color:#626469">nicholas.caton@se.com</span></a></span></u><span style="font-size:9.0pt; color:#1F497D"></span></p>
</td>
<td width="203" valign="top" style="width:152.4pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal" align="right" style="text-align:right"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">15200 Santa Fe Trail Drive<br>
Suite 204<br>
Lenexa, KS 66219<br>
United States</span><span style="font-size:9.0pt; color:#1F497D"></span></p>
</td>
</tr>
<tr style="height:4.0pt">
<td width="724" colspan="4" valign="top" style="width:543.0pt; padding:0in 0in 0in 0in; height:4.0pt">
<p class="x_MsoNormal" style=""><span style="color:#3A7A46"><img border="0" width="722" height="49" id="x__x0000_i1036" alt="cid:image006.png@01D515A3.47EDD880" style="width:7.5208in; height:.5104in" data-outlook-trace="F:1|T:1" src="cid:image003.png@01D52509.9351C280"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal"> </p>
</div>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> Nicholas Caton <br>
<b>Sent:</b> Monday, June 17, 2019 12:34 PM<br>
<b>To:</b> Gurneet Singh <gurneet@edsglobal.com>; Karol Bandurski <karol.bandurski@put.poznan.pl><br>
<b>Cc:</b> bldg-sim@onebuilding.org; Jim Dirkes <Jim@fsmgmt.co><br>
<b>Subject:</b> RE: [Bldg-sim] energy plus/open studio hourly results (DView)</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><b>BIG SHOUTOUT TO JIM DIRKES! </b>He helped me with making this a potentially useful contribution for the e+ folks out there.
</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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.
</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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.
</p>
<p class="x_MsoNormal"><a href="https://www.biinsight.com/visualise-sqlite-data-in-power-bi/">https://www.biinsight.com/visualise-sqlite-data-in-power-bi/</a></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><b>Step 0 (required only the first time you do this)</b></p>
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">Install SQLite ODBC driver: Install 32 vs 64 bit version to match your version of Excel/PowerBI desktop.</li><li class="x_MsoListParagraph" style="margin-left:0in"><a href="http://www.ch-werner.de/sqliteodbc/">http://www.ch-werner.de/sqliteodbc/</a></li></ul>
<p class="x_MsoNormal"><b>Step 1:</b></p>
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">Open a new Excel worksheet</li><li class="x_MsoListParagraph" style="margin-left:0in">Data tab, Get Data, From Other Sources, From ODBC</li></ul>
<p class="x_MsoNormal"><img border="0" width="520" height="811" id="x_Picture_x0020_4" style="width:5.4166in; height:8.4479in" data-outlook-trace="F:1|T:1" src="cid:image004.png@01D52509.9351C280"></p>
<p class="x_MsoNormal"><b>Step 2</b></p>
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">Select “SQLite3 Datasource”</li><li class="x_MsoListParagraph" style="margin-left:0in">Click Advanced, and in the first field type “<span style="background:yellow">database=</span>” followed by the SQLite file path (to your energyplus export SQL file)
</li><li class="x_MsoListParagraph" style="margin-left:0in">Click OK</li></ul>
<p class="x_MsoNormal" style="margin-left:.25in"><img border="0" width="701" height="531" id="x_Picture_x0020_5" style="width:7.302in; height:5.5312in" data-outlook-trace="F:1|T:1" src="cid:image011.png@01D52509.9351C280"></p>
<p class="x_MsoNormal"><b>Step 3</b></p>
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">In the next dialog, click “Default or Custom”
</li><li class="x_MsoListParagraph" style="margin-left:0in">Click Connect</li></ul>
<p class="x_MsoListParagraph"><img border="0" width="708" height="352" id="x_Picture_x0020_6" style="width:7.375in; height:3.6666in" data-outlook-trace="F:1|T:1" src="cid:image012.png@01D52509.9351C280"></p>
<p class="x_MsoNormal"><b>Step 4</b></p>
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">… and we’re in! </li></ul>
<p class="x_MsoNormal" style="margin-left:.25in"><img border="0" width="1227" height="704" id="x_Picture_x0020_8" style="width:12.7812in; height:7.3333in" data-outlook-trace="F:1|T:1" src="cid:image013.png@01D52509.9351C280"></p>
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">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.</li><li class="x_MsoListParagraph" style="margin-left:0in">Of note, everything we just stepped through (and visualization/export options to follow) could be
<u>fully</u> 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.</li></ul>
<p class="x_MsoNormal"><b>Steps 5+</b></p>
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">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.</li><li class="x_MsoListParagraph" style="margin-left:0in">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.</li><li class="x_MsoListParagraph" style="margin-left:0in">I first married the <b>ReportVariableData</b> and
<b>ReportVariableDataDictionary</b> 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).</li><li class="x_MsoListParagraph" style="margin-left:0in">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.</li><li class="x_MsoListParagraph" style="margin-left:0in">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
<span style="font-family:"Segoe UI Emoji",sans-serif">😉</span>. </li><ul type="circle" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">An overlay of “district” heating and cooling energies.
</li><ul type="square" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">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!</li></ul>
</ul>
</ul>
<p class="x_MsoNormal" style="margin-left:1.0in"><img border="0" width="1258" height="671" id="x_Picture_x0020_10" style="width:13.1041in; height:6.9895in" data-outlook-trace="F:1|T:1" src="cid:image014.png@01D52509.9351C280"></p>
<ul type="disc" style="margin-top:0in">
<ul type="circle" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">Digging into Zone temps:</li><ul type="square" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">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.</li><li class="x_MsoListParagraph" style="margin-left:0in">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.</li><li class="x_MsoListParagraph" style="margin-left:0in">In any case, we can observe a couple interesting points:
</li><ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">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!</li><li class="x_MsoListParagraph" style="margin-left:0in">The rest of this looks like fairly regular setback behavior, although…
</li><li class="x_MsoListParagraph" style="margin-left:0in">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).</li></ul>
</ul>
</ul>
</ul>
<p class="x_MsoListParagraph" style="margin-left:1.5in"><img border="0" width="918" height="646" id="x_Picture_x0020_11" style="width:9.5625in; height:6.7291in" data-outlook-trace="F:1|T:1" src="cid:image015.png@01D52509.9351C280"></p>
<ul type="disc" style="margin-top:0in">
<ul type="circle" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">How about the weather?</li><ul type="square" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">Checking out Drybulb and Wetbulb (both in C),
</li><ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">Overlaying both:</li></ul>
</ul>
</ul>
</ul>
<p class="x_MsoListParagraph" style="margin-left:2.0in"><img border="0" width="1256" height="666" id="x_Picture_x0020_13" style="width:13.0833in; height:6.9375in" data-outlook-trace="F:1|T:1" src="cid:image016.png@01D52509.9351C280"></p>
<ul type="disc" style="margin-top:0in">
<ul type="circle" style="margin-top:0in">
<ul type="square" style="margin-top:0in">
<ul type="disc" style="margin-top:0in">
<li class="x_MsoListParagraph" style="margin-left:0in">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!</li><li class="x_MsoListParagraph" style="margin-left:0in">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:</li></ul>
</ul>
</ul>
</ul>
<p class="x_MsoListParagraph" style="margin-left:2.0in"><img border="0" width="891" height="567" id="x_Picture_x0020_12" style="width:9.2812in; height:5.9062in" data-outlook-trace="F:1|T:1" src="cid:image017.png@01D52509.9351C280"></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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 <span style="font-family:"Segoe UI Emoji",sans-serif">
😉</span>!</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Best regards,</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">~Nick</p>
<div>
<p class="x_MsoNormal"><span style="font-family:"Arial",sans-serif; color:#3A7A46"><img border="0" width="726" height="9" id="x_Picture_x0020_1" alt="cid:image005.png@01D515A3.47EDD880" style="width:7.5625in; height:.0937in" data-outlook-trace="F:1|T:1" src="cid:image002.png@01D52509.9351C280"></span></p>
<p class="x_MsoNormal"><b><span style="font-family:"Arial",sans-serif; color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="color:#3A7A46"></span></p>
<table class="x_MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="724" style="width:543.0pt; border-collapse:collapse">
<tbody>
<tr>
<td width="230" valign="top" style="width:172.3pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"> Senior Energy Engineer</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"> Regional Energy Engineering Manager</span></p>
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"> Energy and Sustainability Services</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469"> Energy Performance Contracting
</span><span style="font-size:9.0pt; color:#1F497D"></span></p>
</td>
<td width="16" valign="top" style="width:11.8pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#57B069">D </span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#57B069">M </span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#57B069">F </span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#1F497D"><br>
</span><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#57B069">E </span><span style="font-size:9.0pt; color:#1F497D">
</span></p>
</td>
<td width="275" valign="top" style="width:206.5pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">913 . 564 . 6361</span></p>
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">785 . 410 . 3317</span></p>
<p class="x_MsoNormal"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">913 . 564 . 6380</span></p>
</td>
<td width="203" valign="top" style="width:152.4pt; padding:0in 0in 0in 0in">
<p class="x_MsoNormal" align="right" style="text-align:right"><span style="font-size:9.0pt; font-family:"Arial",sans-serif; color:#626469">15200 Santa Fe Trail Drive<br>
Suite 204<br>
Lenexa, KS 66219<br>
United States</span><span style="font-size:9.0pt; color:#1F497D"></span></p>
</td>
</tr>
<tr style="height:4.0pt">
<td width="724" colspan="4" valign="top" style="width:543.0pt; padding:0in 0in 0in 0in; height:4.0pt">
<p class="x_MsoNormal" style=""><span style="color:#3A7A46"><img border="0" width="722" height="49" id="x_Picture_x0020_2" alt="cid:image006.png@01D515A3.47EDD880" style="width:7.5208in; height:.5104in" data-outlook-trace="F:1|T:1" src="cid:image003.png@01D52509.9351C280"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="x_MsoNormal"> </p>
</div>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> Bldg-sim <<a href="mailto:bldg-sim-bounces@lists.onebuilding.org">bldg-sim-bounces@lists.onebuilding.org</a>>
<b>On Behalf Of </b>Gurneet Singh via Bldg-sim<br>
<b>Sent:</b> Monday, June 17, 2019 9:04 AM<br>
<b>To:</b> Karol Bandurski <<a href="mailto:karol.bandurski@put.poznan.pl">karol.bandurski@put.poznan.pl</a>><br>
<b>Cc:</b> bldg-sim <<a href="mailto:bldg-sim@lists.onebuilding.org">bldg-sim@lists.onebuilding.org</a>><br>
<b>Subject:</b> Re: [Bldg-sim] energy plus/open studio hourly results (DView)</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p><span style="color:red">[External email: Use caution with links and attachments]</span></p>
<div class="x_MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p> </p>
<div>
<div>
<p class="x_MsoNormal">Hi Karol, </p>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal">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. </p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal">Add Output Variable: <a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbcl.nrel.gov%2Fnode%2F37843&data=02%7C01%7CNicholas.Caton%40se.com%7C6b08d0320e3d462b7aa008d6f32cb703%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636963770707416622&sdata=csBNIY1Y%2BogYfVeefpe9DasUUfU1ydHojmDfnMufkTo%3D&reserved=0">https://bcl.nrel.gov/node/37843</a></p>
</div>
<div>
<p class="x_MsoNormal">Export Output Variable : <a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbcl.nrel.gov%2Fnode%2F83268&data=02%7C01%7CNicholas.Caton%40se.com%7C6b08d0320e3d462b7aa008d6f32cb703%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636963770707426617&sdata=WlLFvKkxwhpPm3sRs9t21reBA7lKJmJpFoov%2Fh4u7YY%3D&reserved=0">https://bcl.nrel.gov/node/83268</a> </p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal">I hope it helps.</p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal">Regards</p>
</div>
<div>
<p class="x_MsoNormal"> <br clear="all">
</p>
<div>
<div>
<div>
<p class="x_MsoNormal"><span style="font-size:10.0pt; font-family:"Georgia",serif; color:#006600; background:white">Gurneet Singh</span></p>
</div>
<div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Georgia",serif; color:#006600">Director</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:#888888"></span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:#888888"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Georgia",serif; color:#006600">Environmental Design Solutions Pvt. Ltd.</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:#888888"></span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Georgia",serif; color:#006600">D-1/25, Vasant Vihar, New Delhi 110057</span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:#888888"></span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:#888888"> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Georgia",serif; color:#006600">[m] +91 9899240140 [t] +91 11 2614 7085 [f] </span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:#888888">+91
11 4056 8633</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:10.0pt; font-family:"Georgia",serif; color:#888888"><a href="mailto:gurneet@edsglobal.com" target="_blank"><span style="color:#222222; background:white">gurneet</span><span style="color:#006600; background:white">@edsglobal.com</span></a></span><span style="font-size:10.0pt; font-family:"Georgia",serif; color:#006600; background:white"> | </span><span style="font-size:10.0pt; font-family:"Georgia",serif; color:#888888"><a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.edsglobal.com%2F&data=02%7C01%7CNicholas.Caton%40se.com%7C6b08d0320e3d462b7aa008d6f32cb703%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636963770707426617&sdata=OeEp529%2FNMuAmWTKSdvS7gw%2FtGjne88XU1d1rgurfXQ%3D&reserved=0" target="_blank"><span style="color:#006600; background:white">www.edsglobal.com</span></a></span><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:#888888"></span></p>
</div>
</div>
</div>
</div>
<p class="x_MsoNormal"> </p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<div>
<div>
<p class="x_MsoNormal">On Mon, Jun 17, 2019 at 4:18 PM Karol Bandurski via Bldg-sim <<a href="mailto:bldg-sim@lists.onebuilding.org">bldg-sim@lists.onebuilding.org</a>> wrote:</p>
</div>
<blockquote style="border:none; border-left:solid #CCCCCC 1.0pt; padding:0in 0in 0in 6.0pt; margin-left:4.8pt; margin-top:5.0pt; margin-right:0in; margin-bottom:5.0pt">
<div>
<div>
<p class="x_MsoNormal" style="">Dear Experts,<span lang="PL"></span></p>
<p class="x_MsoNormal" style=""> <span lang="PL"></span></p>
<p class="x_MsoNormal" style="">We start work with student in OpenStudio. Now we would like to explore hourly results.<span lang="PL"></span></p>
<p class="x_gmail-m2907845280526664084msolistparagraph">1)<span style="font-size:7.0pt; font-family:"Times New Roman",serif">
</span>Is some simple way to export all hourly results to *.csv / *.xls format?<span lang="PL"></span></p>
<p class="x_gmail-m2907845280526664084msolistparagraph">2)<span style="font-size:7.0pt; font-family:"Times New Roman",serif">
</span>We try to use DView. But it is not manage to open file, it close itself. What could be wrong…<span lang="PL"></span></p>
<p class="x_MsoNormal" style=""> <span lang="PL"></span></p>
<p class="x_MsoNormal" style="">Our file:<span lang="PL"></span></p>
<p class="x_MsoNormal" style=""><a href="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%7C6b08d0320e3d462b7aa008d6f32cb703%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636963770707436609&sdata=cNzD19E8Gs3DjN6GG54xmK7J9wB8T%2FXYqfXvPCwhDGU%3D&reserved=0" target="_blank">https://www.dropbox.com/s/7c87etxszrlwbiz/eplusout.sql?dl=0</a><span lang="PL"></span></p>
<p class="x_MsoNormal" style=""> <span lang="PL"></span></p>
<p class="x_MsoNormal" style="">Kind regards,<br>
Karol<span lang="PL"></span></p>
<p class="x_MsoNormal" style=""> <span lang="PL"></span></p>
<p class="x_MsoNormal" style=""> <span lang="PL"></span></p>
<p class="x_MsoNormal" style=""> <span lang="PL"></span></p>
<p class="x_MsoNormal" style="">--------------------------------------------------------------------<span lang="PL"></span></p>
<p class="x_MsoNormal" style="">Karol BANDURSKI M. Sc.<span lang="PL"></span></p>
<p class="x_MsoNormal" style="">Faculty of Civil and Environemntal Engeneering<span lang="PL"></span></p>
<p class="x_MsoNormal" style="">Division of Heating, Air Conditioning and Air Protection<span lang="PL"></span></p>
<p class="x_MsoNormal" style="">Poznan University of Technology<span lang="PL"></span></p>
<p class="x_MsoNormal" style=""><a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.researchgate.net%2Fprofile%2FKarol_Bandurski&data=02%7C01%7CNicholas.Caton%40se.com%7C6b08d0320e3d462b7aa008d6f32cb703%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636963770707436609&sdata=QU%2B2cWmHn7kuJp3ZjYrYEkNQPqDKm3JHthuAYOGu108%3D&reserved=0" target="_blank">https://www.researchgate.net/profile/Karol_Bandurski</a><span lang="PL"></span></p>
<p class="x_MsoNormal" style=""><span lang="PL" style="color:#1F497D"><a href="https://eur02.safelinks.protection.outlook.com/?url=http:%2F%2Fwww.put.poznan.pl%2F~karol.bandurski&data=02%7C01%7CNicholas.Caton%40se.com%7C6b08d0320e3d462b7aa008d6f32cb703%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636963770707436609&sdata=LgwSO78uxDsRVAuMJhHZPCLhI5djtTYpBGJFP5sEruc%3D&reserved=0" target="_blank"><span lang="EN-US">www.put.poznan.pl/~karol.bandurski</span></a></span><span lang="PL"></span></p>
<p class="x_MsoNormal" style=""> <span lang="PL"></span></p>
</div>
</div>
<p class="x_MsoNormal">_______________________________________________<br>
Bldg-sim mailing list<br>
<a href="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%7C6b08d0320e3d462b7aa008d6f32cb703%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636963770707446599&sdata=lrtuNkZCx2KeUvi0HlSCY4TLxqwQ5i3dt%2B8C3DpD97g%3D&reserved=0" target="_blank">http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org</a><br>
To unsubscribe from this mailing list send a blank message to <a href="mailto:BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG" target="_blank">
BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG</a></p>
</blockquote>
</div>
<p class="x_MsoNormal"><br>
______________________________________________________________________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________________________________________________</p>
</div>
</div>
</div>
</body>
</html>