<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
{font-family:"Times New Roman \,serif";
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
p.xmsolistparagraph, li.xmsolistparagraph, div.xmsolistparagraph
{mso-style-name: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;
color:black;}
p.xmsonormal0, li.xmsonormal0, div.xmsonormal0
{mso-style-name:x_msonormal0;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
p.xgmail-m2907845280526664084msolistparagraph, li.xgmail-m2907845280526664084msolistparagraph, div.xgmail-m2907845280526664084msolistparagraph
{mso-style-name:x_gmail-m2907845280526664084msolistparagraph;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
p.xmsochpdefault, li.xmsochpdefault, div.xmsochpdefault
{mso-style-name:x_msochpdefault;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:10.0pt;
font-family:"Calibri",sans-serif;
color:black;}
span.xmsohyperlink
{mso-style-name:x_msohyperlink;
color:blue;
text-decoration:underline;}
span.xmsohyperlinkfollowed
{mso-style-name:x_msohyperlinkfollowed;
color:purple;
text-decoration:underline;}
span.xemailstyle20
{mso-style-name:x_emailstyle20;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.xemailstyle23
{mso-style-name:x_emailstyle23;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle30
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:347757276;
mso-list-template-ids:-112185506;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:439224995;
mso-list-template-ids:1710765128;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:479616320;
mso-list-template-ids:2060756380;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3
{mso-list-id:654453859;
mso-list-template-ids:133315346;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4
{mso-list-id:993338820;
mso-list-template-ids:420921594;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l4:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5
{mso-list-id:1028988176;
mso-list-template-ids:1754703236;}
@list l5:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6
{mso-list-id:1126005743;
mso-list-template-ids:-945227898;}
@list l6:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7
{mso-list-id:1441337155;
mso-list-template-ids:1221492478;}
@list l7:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l7:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l8
{mso-list-id:1581019376;
mso-list-type:hybrid;
mso-list-template-ids:685173984 1313221424 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l8:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
@list l8:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l8:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l8:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l8:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l8:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l8:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l8:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l8:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l9
{mso-list-id:1638535686;
mso-list-template-ids:1453374828;}
@list l9:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l10
{mso-list-id:1791195721;
mso-list-template-ids:130686144;}
@list l10:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l10:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l10:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l10:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l10:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l10:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l10:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l10:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l10:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:windowtext">I sincerely appreciate the spirit of building bridges in 2 directions, thanks so much Mike!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">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?”<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">With your input, I might suggest some additional steps for anyone following along:<o:p></o:p></span></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoListParagraph" style="color:windowtext;margin-left:0in;mso-list:l8 level1 lfo11">
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.<o:p></o:p></li><li class="MsoListParagraph" style="color:windowtext;margin-left:0in;mso-list:l8 level1 lfo11">
By using ReportVariableWithTime, it <i><u>sounds like</u></i> you can avoid the extra steps I suggested to convert the interval count (the x-axes in the visuals below) into DateTime format.
<o:p></o:p></li><li class="MsoListParagraph" style="color:windowtext;margin-left:0in;mso-list:l8 level1 lfo11">
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.<o:p></o:p></li></ul>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">~Nick<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#3A7A46"><img width="726" height="9" style="width:7.5625in;height:.0937in" id="Picture_x0020_1" src="cid:image001.png@01D52683.9C843920" alt="cid:image005.png@01D515A3.47EDD880"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="color:#3A7A46"><o:p></o:p></span></p>
<table class="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="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<o:p></o:p></span></p>
<p class="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"><o:p></o:p></span></p>
</td>
<td width="16" valign="top" style="width:11.8pt;padding:0in 0in 0in 0in">
<p class="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">
<o:p></o:p></span></p>
</td>
<td width="275" valign="top" style="width:206.5pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">913 . 564 . 6361<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">785 . 410 . 3317<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">913 . 564 . 6380<o:p></o:p></span></p>
<p class="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"><o:p></o:p></span></p>
</td>
<td width="203" valign="top" style="width:152.4pt;padding:0in 0in 0in 0in">
<p class="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"><o:p></o:p></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="MsoNormal" style="mso-line-height-alt:4.0pt"><span style="color:#3A7A46"><img border="0" width="722" height="49" style="width:7.5208in;height:.5104in" id="Picture_x0020_2" src="cid:image002.png@01D52683.9C843920" alt="cid:image006.png@01D515A3.47EDD880"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span style="color:windowtext"> Bldg-sim <bldg-sim-bounces@lists.onebuilding.org>
<b>On Behalf Of </b>Michael J Witte via Bldg-sim<br>
<b>Sent:</b> Tuesday, June 18, 2019 5:03 PM<br>
<b>To:</b> bldg-sim@lists.onebuilding.org<br>
<b>Subject:</b> Re: [Bldg-sim] energy plus/open studio hourly results (DView)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p><span style="color:red">[External email: Use caution with links and attachments]</span><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">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://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">https://github.com/NREL/EnergyPlus/issues/7342</a><br>
<br>
Mike<br>
<br>
<o:p></o:p></p>
<div>
<p class="MsoNormal">On 6/17/2019 1:35 PM, Jim Dirkes via Bldg-sim wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span style="font-size:12.0pt">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><span style="font-size:12.0pt;font-family:"Tahoma",sans-serif">��</span><span style="font-size:12.0pt">.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
</div>
<div id="Signature">
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:11.5pt;color:#212121">James V Dirkes II, PE, BEMP, BCxP<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:11.5pt;color:#212121">Team Lead - Building Performance<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:11.5pt;color:#212121;background:white">616 450 8653</span><span style="font-size:11.5pt;color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:11.5pt;color:#212121">Foresight Management<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><u><span style="font-size:12.0pt;color:blue;background:white"><a href="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" target="_blank"><span style="color:#954F72">https://fsmgmt.co/</span></a></span></u><span style="font-size:11.5pt;color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:11.5pt;color:#212121"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><b><span style="color:#212121">Coffee Conversation:</span></b><span style="font-size:11.5pt;color:#212121"><o:p></o:p></span></p>
</div>
<div>
<p style="margin-bottom:6.0pt;background:white;text-autospace:none"><span style="font-size:10.0pt;color:#333333;background:white">But to handle human lives with no agreement as to
<b><i>what human beings are</i></b> or <b><i>what the purpose of life is</i> </b>
- that is a formula for chaos.</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#212121"><o:p></o:p></span></p>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b>From:</b> Nicholas Caton <a 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 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) <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal">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).<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"><a href="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">https://1drv.ms/f/s!ApiLEhvYf5QZgrIYNhCVb7TszGKpjw</a><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">~Nick<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<div>
<p class="xmsonormal"><span style="font-family:"Arial",sans-serif;color:#3A7A46"><img border="0" width="726" height="9" style="width:7.5625in;height:.0937in" id="x__x005f_x0000_i1037" src="cid:image001.png@01D52683.9C843920" alt="cid:image005.png@01D515A3.47EDD880"></span><o:p></o:p></p>
<p class="xmsonormal"><b><span style="font-family:"Arial",sans-serif;color:#3A7A46">Nick Caton, P.E., BEMP</span></b><o:p></o:p></p>
<table class="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="xmsonormal"><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><o:p></o:p></p>
<p class="xmsonormal"><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><o:p></o:p></p>
</td>
<td width="16" valign="top" style="width:11.8pt;padding:0in 0in 0in 0in">
<p class="xmsonormal"><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><o:p></o:p></p>
</td>
<td width="275" valign="top" style="width:206.5pt;padding:0in 0in 0in 0in">
<p class="xmsonormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">913 . 564 . 6361</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">785 . 410 . 3317</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">913 . 564 . 6380</span><o:p></o:p></p>
<p class="xmsonormal"><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><o:p></o:p></p>
</td>
<td width="203" valign="top" style="width:152.4pt;padding:0in 0in 0in 0in">
<p class="xmsonormal" 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><o:p></o:p></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="xmsonormal"><span style="color:#3A7A46"><img border="0" width="722" height="49" style="width:7.5208in;height:.5104in" id="x__x005f_x0000_i1036" src="cid:image002.png@01D52683.9C843920" alt="cid:image006.png@01D515A3.47EDD880"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="xmsonormal"><b>From:</b> Nicholas Caton <br>
<b>Sent:</b> Monday, June 17, 2019 12:34 PM<br>
<b>To:</b> Gurneet Singh <a href="mailto:gurneet@edsglobal.com"><gurneet@edsglobal.com></a>; Karol Bandurski
<a href="mailto:karol.bandurski@put.poznan.pl"><karol.bandurski@put.poznan.pl></a><br>
<b>Cc:</b> <a href="mailto:bldg-sim@onebuilding.org">bldg-sim@onebuilding.org</a>; Jim Dirkes
<a href="mailto:Jim@fsmgmt.co"><Jim@fsmgmt.co></a><br>
<b>Subject:</b> RE: [Bldg-sim] energy plus/open studio hourly results (DView)<o:p></o:p></p>
</div>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"><b>BIG SHOUTOUT TO JIM DIRKES! </b>He helped me with making this a potentially useful contribution for the e+ folks out there.
<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">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.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">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.<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">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.
<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">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.
<o:p></o:p></p>
<p class="xmsonormal"><a href="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">https://www.biinsight.com/visualise-sqlite-data-in-power-bi/</a><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"><b>Step 0 (required only the first time you do this)</b><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l1 level1 lfo1">Install SQLite ODBC driver: Install 32 vs 64 bit version to match your version of Excel/PowerBI desktop.<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l1 level1 lfo1"><a href="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">http://www.ch-werner.de/sqliteodbc/</a><o:p></o:p></li></ul>
<p class="xmsonormal"><b>Step 1:</b><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l0 level1 lfo2">Open a new Excel worksheet<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l0 level1 lfo2">Data tab, Get Data, From Other Sources, From ODBC<o:p></o:p></li></ul>
<p class="xmsonormal"><img border="0" width="520" height="811" style="width:5.4166in;height:8.4479in" id="x_Picture_x0020_4" src="cid:image003.png@01D52683.9C843920"><o:p></o:p></p>
<p class="xmsonormal"><b>Step 2</b><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l6 level1 lfo3">Select “SQLite3 Datasource”<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l6 level1 lfo3">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)
<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l6 level1 lfo3">Click OK<o:p></o:p></li></ul>
<p class="xmsonormal" style="margin-left:.25in"><img border="0" width="701" height="531" style="width:7.302in;height:5.5312in" id="x_Picture_x0020_5" src="cid:image004.png@01D52683.9C843920"><o:p></o:p></p>
<p class="xmsonormal"><b>Step 3</b><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l5 level1 lfo4">In the next dialog, click “Default or Custom”
<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l5 level1 lfo4">Click Connect<o:p></o:p></li></ul>
<p class="xmsolistparagraph"><img border="0" width="708" height="352" style="width:7.375in;height:3.6666in" id="x_Picture_x0020_6" src="cid:image005.png@01D52683.9C843920"><o:p></o:p></p>
<p class="xmsonormal"><b>Step 4</b><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l2 level1 lfo5">… and we’re in!
<o:p></o:p></li></ul>
<p class="xmsonormal" style="margin-left:.25in"><img border="0" width="1227" height="704" style="width:12.7812in;height:7.3333in" id="x_Picture_x0020_8" src="cid:image006.png@01D52683.9C843920"><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l9 level1 lfo6">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.<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l9 level1 lfo6">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.<o:p></o:p></li></ul>
<p class="xmsonormal"><b>Steps 5+</b><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l4 level1 lfo7">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.<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l4 level1 lfo7">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.<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l4 level1 lfo7">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).<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l4 level1 lfo7">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.<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l4 level1 lfo7">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>. <o:p></o:p></li></ul>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l4 level2 lfo7">An overlay of “district” heating and cooling energies.
<o:p></o:p></li></ul>
</ul>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<ul style="margin-top:0in" type="square">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l4 level3 lfo7">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!<o:p></o:p></li></ul>
</ul>
</ul>
<p class="xmsonormal" style="margin-left:1.0in"><img border="0" width="1258" height="671" style="width:13.1041in;height:6.9895in" id="x_Picture_x0020_10" src="cid:image007.png@01D52683.9C843920"><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l10 level2 lfo8">Digging into Zone temps:<o:p></o:p></li></ul>
</ul>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<ul style="margin-top:0in" type="square">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l10 level3 lfo8">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.<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l10 level3 lfo8">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.<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l10 level3 lfo8">In any case, we can observe a couple interesting points:
<o:p></o:p></li></ul>
</ul>
</ul>
<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="xmsolistparagraph" style="margin-left:0in;mso-list:l10 level4 lfo8">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!<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l10 level4 lfo8">The rest of this looks like fairly regular setback behavior, although…
<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l10 level4 lfo8">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).<o:p></o:p></li></ul>
</ul>
</ul>
</ul>
<p class="xmsolistparagraph" style="margin-left:1.5in"><img border="0" width="918" height="646" style="width:9.5625in;height:6.7291in" id="x_Picture_x0020_11" src="cid:image008.png@01D52683.9C843920"><o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l3 level2 lfo9">How about the weather?<o:p></o:p></li></ul>
</ul>
<ul style="margin-top:0in" type="disc">
<ul style="margin-top:0in" type="circle">
<ul style="margin-top:0in" type="square">
<li class="xmsolistparagraph" style="margin-left:0in;mso-list:l3 level3 lfo9">Checking out Drybulb and Wetbulb (both in C),
<o:p></o:p></li></ul>
</ul>
</ul>
<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="xmsolistparagraph" style="margin-left:0in;mso-list:l3 level4 lfo9">Overlaying both:<o:p></o:p></li></ul>
</ul>
</ul>
</ul>
<p class="xmsolistparagraph" style="margin-left:2.0in"><img border="0" width="1256" height="666" style="width:13.0833in;height:6.9375in" id="x_Picture_x0020_13" src="cid:image009.png@01D52683.9C843920"><o:p></o:p></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="xmsolistparagraph" style="margin-left:0in;mso-list:l7 level4 lfo10">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!<o:p></o:p></li><li class="xmsolistparagraph" style="margin-left:0in;mso-list:l7 level4 lfo10">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:<o:p></o:p></li></ul>
</ul>
</ul>
</ul>
<p class="xmsolistparagraph" style="margin-left:2.0in"><img border="0" width="891" height="567" style="width:9.2812in;height:5.9062in" id="x_Picture_x0020_12" src="cid:image010.png@01D52683.9C843920"><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">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>!<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Best regards,<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">~Nick<o:p></o:p></p>
<div>
<p class="xmsonormal"><span style="font-family:"Arial",sans-serif;color:#3A7A46"><img border="0" width="726" height="9" style="width:7.5625in;height:.0937in" id="x_Picture_x0020_1" src="cid:image001.png@01D52683.9C843920" alt="cid:image005.png@01D515A3.47EDD880"></span><o:p></o:p></p>
<p class="xmsonormal"><b><span style="font-family:"Arial",sans-serif;color:#3A7A46">Nick Caton, P.E., BEMP</span></b><o:p></o:p></p>
<table class="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="xmsonormal"><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><o:p></o:p></p>
<p class="xmsonormal"><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><o:p></o:p></p>
</td>
<td width="16" valign="top" style="width:11.8pt;padding:0in 0in 0in 0in">
<p class="xmsonormal"><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><o:p></o:p></p>
</td>
<td width="275" valign="top" style="width:206.5pt;padding:0in 0in 0in 0in">
<p class="xmsonormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">913 . 564 . 6361</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">785 . 410 . 3317</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#626469">913 . 564 . 6380</span><o:p></o:p></p>
</td>
<td width="203" valign="top" style="width:152.4pt;padding:0in 0in 0in 0in">
<p class="xmsonormal" 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><o:p></o:p></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="xmsonormal"><span style="color:#3A7A46"><img border="0" width="722" height="49" style="width:7.5208in;height:.5104in" id="x_Picture_x0020_2" src="cid:image002.png@01D52683.9C843920" alt="cid:image006.png@01D515A3.47EDD880"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="xmsonormal"><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)<o:p></o:p></p>
</div>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
<p><span style="color:red">[External email: Use caution with links and attachments]</span><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p> <o:p></o:p></p>
<div>
<div>
<p class="xmsonormal">Hi Karol, <o:p></o:p></p>
<div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
<div>
<p class="xmsonormal">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. <o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
<div>
<p class="xmsonormal">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%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807229110&sdata=Pa1BTUnFzZrcHA6XlaSGqBpxBwrpRdT8DYkzJnz%2FlYg%3D&reserved=0">https://bcl.nrel.gov/node/37843</a><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal">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%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807239105&sdata=rwoAcY2oWSh5KIit%2FALBIKunG7SCCldLv%2BNH%2F5CNjDA%3D&reserved=0">https://bcl.nrel.gov/node/83268</a> <o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
<div>
<p class="xmsonormal">I hope it helps.<o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
<div>
<p class="xmsonormal">Regards<o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"> <br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<p class="xmsonormal"><span style="font-size:10.0pt;font-family:"Georgia",serif;color:#006600;background:white">Gurneet Singh</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:10.0pt;font-family:"Georgia",serif;color:#006600">Director</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#888888"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:10.0pt;font-family:"Georgia",serif;color:#006600">Environmental Design Solutions Pvt. Ltd.</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:10.0pt;font-family:"Georgia",serif;color:#006600">D-1/25, Vasant Vihar, New Delhi 110057</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#888888"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" 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><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><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%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807249098&sdata=yzAiM8fRV7%2FluiajYAs5%2B8VN6r2xIgvS6RyZpjzQ4DM%3D&reserved=0" target="_blank"><span style="color:#006600;background:white">www.edsglobal.com</span></a></span><o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
<div>
<div>
<p class="xmsonormal">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:<o:p></o:p></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="xmsonormal">Dear Experts,<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">We start work with student in OpenStudio. Now we would like to explore hourly results.<o:p></o:p></p>
<p class="xgmail-m2907845280526664084msolistparagraph" style="margin:0in;margin-bottom:.0001pt">
1)<span style="font-size:7.0pt;font-family:"Times New Roman ,serif",serif"> </span>
Is some simple way to export all hourly results to *.csv / *.xls format?<o:p></o:p></p>
<p class="xgmail-m2907845280526664084msolistparagraph" style="margin:0in;margin-bottom:.0001pt">
2)<span style="font-size:7.0pt;font-family:"Times New Roman ,serif",serif"> </span>
We try to use DView. But it is not manage to open file, it close itself. What could be wrong…<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Our file:<o:p></o:p></p>
<p class="xmsonormal"><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%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807249098&sdata=tr9blNscI4TwTVDtkXE0JNzGeZp5NwzcXmkAI1ZyCco%3D&reserved=0" target="_blank">https://www.dropbox.com/s/7c87etxszrlwbiz/eplusout.sql?dl=0</a><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">Kind regards,<br>
Karol<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">--------------------------------------------------------------------<o:p></o:p></p>
<p class="xmsonormal">Karol BANDURSKI M. Sc.<o:p></o:p></p>
<p class="xmsonormal">Faculty of Civil and Environemntal Engeneering<o:p></o:p></p>
<p class="xmsonormal">Division of Heating, Air Conditioning and Air Protection<o:p></o:p></p>
<p class="xmsonormal">Poznan University of Technology<o:p></o:p></p>
<p class="xmsonormal"><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%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807259093&sdata=AzvfOuI%2BgN88KSxtPNbTvhvnkMDpY0MhkBzNwuWfc0w%3D&reserved=0" target="_blank">https://www.researchgate.net/profile/Karol_Bandurski</a><o:p></o:p></p>
<p class="xmsonormal"><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%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807259093&sdata=QGKPTy%2BYeZpNn7sE9uKugXecZV2pyPYtIa88UXFACJQ%3D&reserved=0" target="_blank"><span lang="EN-US">www.put.poznan.pl/~karol.bandurski</span></a></span><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
<p class="xmsonormal">_______________________________________________<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%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807269087&sdata=Nlr0x7SrJyBhD0AUC5ipr%2BIlFuCq8CuNBvUHnYb9rqY%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><o:p></o:p></p>
</blockquote>
</div>
<p class="xmsonormal"><br>
______________________________________________________________________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________________________________________________<o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Bldg-sim mailing list<o:p></o:p></pre>
<pre><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%7C2b0a19f5939d46a8be6308d6f4bf4d07%7C6e51e1adc54b4b39b5980ffe9ae68fef%7C0%7C0%7C636965499807269087&sdata=Nlr0x7SrJyBhD0AUC5ipr%2BIlFuCq8CuNBvUHnYb9rqY%3D&reserved=0">http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org</a><o:p></o:p></pre>
<pre>To unsubscribe from this mailing list send a blank message to <a href="mailto:BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG">BLDG-SIM-UNSUBSCRIBE@ONEBUILDING.ORG</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>