<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Nick,<br>
<br>
Very nice tutorial - learned something new. <br>
<br>
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. <br>
<br>
In general, the data table "ReportVariableDataWithTime" is a better
one to look at, because it includes the date/time data.<br>
<br>
And, by the way, by browsing the file this way, I noticed that the
TimestepType fields are wrong.<br>
<a href="https://github.com/NREL/EnergyPlus/issues/7342">https://github.com/NREL/EnergyPlus/issues/7342</a><br>
<br>
Mike<br>
<br>
<br>
<div class="moz-cite-prefix">On 6/17/2019 1:35 PM, Jim Dirkes via
Bldg-sim wrote:<br>
</div>
<blockquote type="cite"
cite="mid:SN6PR12MB2704DD5361B56B84C2729720B0EB0@SN6PR12MB2704.namprd12.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
<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 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)"
moz-do-not-send="true">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>
</div>
</div>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt"
face="Calibri, sans-serif" color="#000000"><b>From:</b>
Nicholas Caton <a class="moz-txt-link-rfc2396E" href="mailto:Nicholas.Caton@se.com"><Nicholas.Caton@se.com></a><br>
<b>Sent:</b> Monday, June 17, 2019 1:38 PM<br>
<b>To:</b> Gurneet Singh; Karol Bandurski<br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:bldg-sim@onebuilding.org">bldg-sim@onebuilding.org</a>; 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 link="blue" vlink="purple" lang="EN-US">
<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"
moz-do-not-send="true">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 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:part4.953ABCE9.B8085362@gard.com" class=""
width="726" height="9" border="0"></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" style="width:543.0pt;
border-collapse:collapse" width="724" cellspacing="0"
cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:172.3pt; padding:0in 0in 0in 0in"
width="230" valign="top">
<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 style="width:11.8pt; padding:0in 0in 0in 0in"
width="16" valign="top">
<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 style="width:206.5pt; padding:0in 0in 0in 0in"
width="275" valign="top">
<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"
moz-do-not-send="true"><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 style="width:152.4pt; padding:0in 0in 0in 0in"
width="203" valign="top">
<p class="x_MsoNormal" style="text-align:right"
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 colspan="4" style="width:543.0pt; padding:0in 0in
0in 0in; height:4.0pt" width="724" valign="top">
<p class="x_MsoNormal" style=""><span
style="color:#3A7A46"><img 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:part6.058527BE.5CEF5EE7@gard.com"
class="" width="722" height="49" border="0"></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 <a class="moz-txt-link-rfc2396E" href="mailto:gurneet@edsglobal.com"><gurneet@edsglobal.com></a>;
Karol Bandurski <a class="moz-txt-link-rfc2396E" href="mailto:karol.bandurski@put.poznan.pl"><karol.bandurski@put.poznan.pl></a><br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:bldg-sim@onebuilding.org">bldg-sim@onebuilding.org</a>; Jim Dirkes
<a class="moz-txt-link-rfc2396E" href="mailto:Jim@fsmgmt.co"><Jim@fsmgmt.co></a><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/"
moz-do-not-send="true">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 style="margin-top:0in" type="disc">
<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/"
moz-do-not-send="true">http://www.ch-werner.de/sqliteodbc/</a></li>
</ul>
<p class="x_MsoNormal"><b>Step 1:</b></p>
<ul style="margin-top:0in" type="disc">
<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 id="x_Picture_x0020_4"
style="width:5.4166in; height:8.4479in"
data-outlook-trace="F:1|T:1"
src="cid:part9.BE43A7BD.BF0775CC@gard.com" class=""
width="520" height="811" border="0"></p>
<p class="x_MsoNormal"><b>Step 2</b></p>
<ul style="margin-top:0in" type="disc">
<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
id="x_Picture_x0020_5" style="width:7.302in;
height:5.5312in" data-outlook-trace="F:1|T:1"
src="cid:part10.3D9368D6.6482A0DB@gard.com" class=""
width="701" height="531" border="0"></p>
<p class="x_MsoNormal"><b>Step 3</b></p>
<ul style="margin-top:0in" type="disc">
<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 id="x_Picture_x0020_6"
style="width:7.375in; height:3.6666in"
data-outlook-trace="F:1|T:1"
src="cid:part11.1E6D11A1.E4DCF1F2@gard.com" class=""
width="708" height="352" border="0"></p>
<p class="x_MsoNormal"><b>Step 4</b></p>
<ul style="margin-top:0in" type="disc">
<li class="x_MsoListParagraph" style="margin-left:0in">… and
we’re in! </li>
</ul>
<p class="x_MsoNormal" style="margin-left:.25in"><img
id="x_Picture_x0020_8" style="width:12.7812in;
height:7.3333in" data-outlook-trace="F:1|T:1"
src="cid:part12.67435279.375BF76E@gard.com" class=""
width="1227" height="704" border="0"></p>
<ul style="margin-top:0in" type="disc">
<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 style="margin-top:0in" type="disc">
<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 style="margin-top:0in" type="circle">
<li class="x_MsoListParagraph" style="margin-left:0in">An
overlay of “district” heating and cooling energies.
</li>
<ul style="margin-top:0in" type="square">
<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
id="x_Picture_x0020_10" style="width:13.1041in;
height:6.9895in" data-outlook-trace="F:1|T:1"
src="cid:part13.A9CF5623.0855375D@gard.com" class=""
width="1258" height="671" border="0"></p>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<li class="x_MsoListParagraph" style="margin-left:0in">Digging
into Zone temps:</li>
<ul style="margin-top:0in" type="square">
<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 style="margin-top:0in" type="disc">
<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
id="x_Picture_x0020_11" style="width:9.5625in;
height:6.7291in" data-outlook-trace="F:1|T:1"
src="cid:part14.40742754.61D6E143@gard.com" class=""
width="918" height="646" border="0"></p>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<li class="x_MsoListParagraph" style="margin-left:0in">How
about the weather?</li>
<ul style="margin-top:0in" type="square">
<li class="x_MsoListParagraph" style="margin-left:0in">Checking
out Drybulb and Wetbulb (both in C),
</li>
<ul style="margin-top:0in" type="disc">
<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
id="x_Picture_x0020_13" style="width:13.0833in;
height:6.9375in" data-outlook-trace="F:1|T:1"
src="cid:part15.4995C31B.7732FB52@gard.com" class=""
width="1256" height="666" border="0"></p>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<ul style="margin-top:0in" type="square">
<ul style="margin-top:0in" type="disc">
<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
id="x_Picture_x0020_12" style="width:9.2812in;
height:5.9062in" data-outlook-trace="F:1|T:1"
src="cid:part16.E70C68E0.6AF21B96@gard.com" class=""
width="891" height="567" border="0"></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 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:part4.953ABCE9.B8085362@gard.com" class=""
width="726" height="9" border="0"></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" style="width:543.0pt;
border-collapse:collapse" width="724" cellspacing="0"
cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:172.3pt; padding:0in 0in 0in 0in"
width="230" valign="top">
<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 style="width:11.8pt; padding:0in 0in 0in 0in"
width="16" valign="top">
<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 style="width:206.5pt; padding:0in 0in 0in 0in"
width="275" valign="top">
<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 style="width:152.4pt; padding:0in 0in 0in 0in"
width="203" valign="top">
<p class="x_MsoNormal" style="text-align:right"
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 colspan="4" style="width:543.0pt; padding:0in 0in
0in 0in; height:4.0pt" width="724" valign="top">
<p class="x_MsoNormal" style=""><span
style="color:#3A7A46"><img
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:part6.058527BE.5CEF5EE7@gard.com"
class="" width="722" height="49" border="0"></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"
moz-do-not-send="true">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"
moz-do-not-send="true">karol.bandurski@put.poznan.pl</a>><br>
<b>Cc:</b> bldg-sim <<a
href="mailto:bldg-sim@lists.onebuilding.org"
moz-do-not-send="true">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" style="text-align:center"
align="center">
<hr width="100%" size="2" 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"
moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true"><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" moz-do-not-send="true"><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"
moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">https://www.researchgate.net/profile/Karol_Bandurski</a><span
lang="PL"></span></p>
<p class="x_MsoNormal" style=""><span
style="color:#1F497D" lang="PL"><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" moz-do-not-send="true"><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" moz-do-not-send="true">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" moz-do-not-send="true">
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Bldg-sim mailing list
<a class="moz-txt-link-freetext" href="http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org">http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org</a>
To unsubscribe from this mailing list send a blank message to <a class="moz-txt-link-abbreviated" href="mailto:BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG">BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG</a>
</pre>
</blockquote>
<br>
</body>
</html>