<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=gb2312"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@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:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 6 6 2 2 2 3 2 4;}
@font-face
{font-family:"\@SimSun";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:SimSun;}
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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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 lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>You can also open the .sim file in a text editor program and use a macro to search for a string then select/copy/cut sections of the results file, and them paste into an excel sheet (this last step is probably a manual task). If you don’t know how to create a macro in a text editor, it is probably worth the hour or two it takes to learn the format and commands, as it is a very useful skill to have in the future. We use text editor macros all the time in my office for our eQUEST work. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#632423'>Nathan Miller </span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#1F497D'>-</span></b><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#632423'> </span></b><b><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:#632423'>PE, LEED<sup>®</sup>AP BD+C, CEM<o:p></o:p></span></b></p><p class=MsoNormal style='margin-bottom:4.0pt'><i><span style='font-size:8.0pt;font-family:"Verdana","sans-serif";color:black'>Mechanical Engineer/Senior Energy Analyst <o:p></o:p></span></i></p><p class=MsoNormal style='line-height:115%'><b><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#632423'>RUSHING</span></b><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#BFAB7F'> </span><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:black'>| </span><b><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#632423'>D</span></b><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#BFAB7F'> </span><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:black'>206-788-4577 |</span><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#BFAB7F'> </span><b><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#632423'>O</span></b><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#A50021'> </span><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:black'>206-285-7100</span><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#BFAB7F'><o:p></o:p></span></p><p class=MsoNormal style='line-height:115%'><b><span style='font-size:9.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#4C9595'>Our new web site:</span></b><b><span style='font-size:9.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#D9541E'> </span></b><b><span style='font-size:8.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#6F1200'><a href="http://www.rushingco.com/"><span style='line-height:115%;color:#6F1200'>www.rushingco.com</span></a></span></b><b><span style='font-size:9.0pt;line-height:115%;font-family:"Verdana","sans-serif";color:#632423'><o:p></o:p></span></b></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> equest-users-bounces@lists.onebuilding.org [mailto:equest-users-bounces@lists.onebuilding.org] <b>On Behalf Of </b>Yf Sun<br><b>Sent:</b> Tuesday, May 21, 2013 7:54 PM<br><b>To:</b> </span><span lang=ZH-CN style='font-size:10.0pt'>冷面寒枪</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><br><b>Cc:</b> equest-users@lists.onebuilding.org<br><b>Subject:</b> Re: [Equest-users] </span><span lang=ZH-CN style='font-size:10.0pt'>回复：</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Is there a way to extract specific data from simresult?<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span lang=ZH-CN>非常感谢！</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Wed, May 22, 2013 at 10:44 AM, <span lang=ZH-CN>冷面寒枪</span> <<a href="mailto:503271081@qq.com" target="_blank">503271081@qq.com</a>> wrote:<o:p></o:p></p><div><p class=MsoNormal>As we all konwn,The computer engine of eQuest software is DOE2.2. you can program your computer to accomplish this function using C or VB program language.Blow is the specification for calling DOE2.2.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal> (c) Copyright 1999, Scott A. Criswell. All Rights Reserved.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>This file describes how to interface with the D2Result DLL in<o:p></o:p></p></div><div><p class=MsoNormal>order to retrieve simulation results from the DOE-2.2 binary<o:p></o:p></p></div><div><p class=MsoNormal>results files. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>----------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal>UPDATES:<o:p></o:p></p></div><div><p class=MsoNormal>----------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal> 8/31/99 - SAC - VisualBasic Users - We have added VB-compatible versions<o:p></o:p></p></div><div><p class=MsoNormal> of each of the rest of the functions exported from the<o:p></o:p></p></div><div><p class=MsoNormal> D2Result.dll. Your VB code should use the same arguments,<o:p></o:p></p></div><div><p class=MsoNormal> but the function names should be *_VB*(). For example,<o:p></o:p></p></div><div><p class=MsoNormal> instead of calling D2R_GetMultipleResult(...), you<o:p></o:p></p></div><div><p class=MsoNormal> should call D2R_VBGetMultipleResult(...).<o:p></o:p></p></div><div><p class=MsoNormal> 8/22/99 - SAC - VisualBasic Users - We have added a function call<o:p></o:p></p></div><div><p class=MsoNormal> which is equivalent to D2R_GetSingleResult() but uses<o:p></o:p></p></div><div><p class=MsoNormal> a calling convention compatible with VisualBasic.<o:p></o:p></p></div><div><p class=MsoNormal> This new function is called D2R_VBGetSingleResult()<o:p></o:p></p></div><div><p class=MsoNormal> and takes the exact same arguments as its counterpart.<o:p></o:p></p></div><div><p class=MsoNormal> No such VB-compatible D2R_GetMultipleResult() counter-<o:p></o:p></p></div><div><p class=MsoNormal> part exists. Please contact us if you would like one<o:p></o:p></p></div><div><p class=MsoNormal> added.<o:p></o:p></p></div><div><p class=MsoNormal>----------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Results retrieval is current available only from the Non-Hourly<o:p></o:p></p></div><div><p class=MsoNormal>results files for Loads, HVAC and Economics.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>The D2Result.DLL library is based on MFC (Microsoft Foundation<o:p></o:p></p></div><div><p class=MsoNormal>Classes) and therefore requires that the following files be<o:p></o:p></p></div><div><p class=MsoNormal>installed into your Windows\System directory:<o:p></o:p></p></div><div><p class=MsoNormal> MFC42.DLL (~975 kb)<o:p></o:p></p></div><div><p class=MsoNormal> MSVCRT.DLL (~250 kb)<o:p></o:p></p></div><div><p class=MsoNormal>You can find these files located in the \System directory of<o:p></o:p></p></div><div><p class=MsoNormal>this distribution.<o:p></o:p></p></div><div><p class=MsoNormal>These files are the latest updates that are reported to be<o:p></o:p></p></div><div><p class=MsoNormal>fully compatible with previous versions. However, we do<o:p></o:p></p></div><div><p class=MsoNormal>recommend that you save older versions of these files in the<o:p></o:p></p></div><div><p class=MsoNormal>event these new files are incompatible with other software<o:p></o:p></p></div><div><p class=MsoNormal>running on your machine.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Unlike interfacing with the BDLCIO32 and SimCIO32 DLLs, the<o:p></o:p></p></div><div><p class=MsoNormal>D2Result DLL does not interface directly with any other <o:p></o:p></p></div><div><p class=MsoNormal>executable code. As a result, there are no DLL initialization<o:p></o:p></p></div><div><p class=MsoNormal>or clean-up routines. The only things you need do are to load<o:p></o:p></p></div><div><p class=MsoNormal>and unload the DLL using whatever mechanism is available to<o:p></o:p></p></div><div><p class=MsoNormal>your in your development environment and to call the various<o:p></o:p></p></div><div><p class=MsoNormal>exported functions much like you would any other DLL you<o:p></o:p></p></div><div><p class=MsoNormal>interface with.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>The following is a description of the functions exported from<o:p></o:p></p></div><div><p class=MsoNormal>D2Result.DLL:<o:p></o:p></p></div><div><p class=MsoNormal>(for more details, refer to the D2ResX.h header file and the<o:p></o:p></p></div><div><p class=MsoNormal> top portion ofthe NHRList.txt file)<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>1) Retrieval of a single value or array of values:<o:p></o:p></p></div><div><p class=MsoNormal> long D2R_GetSingleResult( const char* pszDOE2Dir,<o:p></o:p></p></div><div><p class=MsoNormal> const char* pszFileName,<o:p></o:p></p></div><div><p class=MsoNormal> int iEntryID,<o:p></o:p></p></div><div><p class=MsoNormal> float* pfData,<o:p></o:p></p></div><div><p class=MsoNormal> int iMaxValues,<o:p></o:p></p></div><div><p class=MsoNormal> const char* pszReportKey,<o:p></o:p></p></div><div><p class=MsoNormal> const char* pszRowKey );<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> Return Value:<o:p></o:p></p></div><div><p class=MsoNormal> >= 0 => successful - # of values retrieved<o:p></o:p></p></div><div><p class=MsoNormal> < 0 => failed - refer to the D2ResX.h header file for<o:p></o:p></p></div><div><p class=MsoNormal> descriptions of the various return values.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> Where:<o:p></o:p></p></div><div><p class=MsoNormal> pszDOE2Dir => Directory where DOE-2 system files (such as<o:p></o:p></p></div><div><p class=MsoNormal> BDLKey.bin, BDLLib.dat, etc.) are stored<o:p></o:p></p></div><div><p class=MsoNormal> (including a trailing '\').<o:p></o:p></p></div><div><p class=MsoNormal> pszFileName => The full path and filename of the BDL input<o:p></o:p></p></div><div><p class=MsoNormal> file without the trailing dot or file<o:p></o:p></p></div><div><p class=MsoNormal> extension.<o:p></o:p></p></div><div><p class=MsoNormal> (i.e. if your DOE-2 input filename is:<o:p></o:p></p></div><div><p class=MsoNormal> "C:\My Dir\Projects\Wall Mart\Wall Mart.inp"<o:p></o:p></p></div><div><p class=MsoNormal> then pszFileName should be:<o:p></o:p></p></div><div><p class=MsoNormal> "C:\My Dir\Projects\Wall Mart\Wall Mart")<o:p></o:p></p></div><div><p class=MsoNormal> iEntryID => Integer value identifying the value or series<o:p></o:p></p></div><div><p class=MsoNormal> to be retrieved. These values are defined in<o:p></o:p></p></div><div><p class=MsoNormal> the first column of DOE-2\NHRList.txt file.<o:p></o:p></p></div><div><p class=MsoNormal> pfData => Address of an array of 32-bit floating point<o:p></o:p></p></div><div><p class=MsoNormal> numbers to be populated with results.<o:p></o:p></p></div><div><p class=MsoNormal> iMaxValues => Number of floats defined in above array.<o:p></o:p></p></div><div><p class=MsoNormal> (this value should correspond to the value<o:p></o:p></p></div><div><p class=MsoNormal> in the "NI" column of the NHRList.txt entry<o:p></o:p></p></div><div><p class=MsoNormal> describing the result(s) you are retrieving)<o:p></o:p></p></div><div><p class=MsoNormal> pszReportKey => Used only when retrieving results from a<o:p></o:p></p></div><div><p class=MsoNormal> non-hourly report which is repeated over<o:p></o:p></p></div><div><p class=MsoNormal> multiple components of a particular type.<o:p></o:p></p></div><div><p class=MsoNormal> This argument contains a NULL-terminated<o:p></o:p></p></div><div><p class=MsoNormal> character string identifying the building<o:p></o:p></p></div><div><p class=MsoNormal> component for which you are retrieving the<o:p></o:p></p></div><div><p class=MsoNormal> results.<o:p></o:p></p></div><div><p class=MsoNormal> This argument must contain a valid string<o:p></o:p></p></div><div><p class=MsoNormal> whenever the "RI" column of the selected<o:p></o:p></p></div><div><p class=MsoNormal> NHRList.txt data contains a value > 0.<o:p></o:p></p></div><div><p class=MsoNormal> pszRowKey => Used only when retrieving results from a<o:p></o:p></p></div><div><p class=MsoNormal> report which contains multiple rows of data<o:p></o:p></p></div><div><p class=MsoNormal> where each row provides results for a separate<o:p></o:p></p></div><div><p class=MsoNormal> building component or month of the year.<o:p></o:p></p></div><div><p class=MsoNormal> This argument contains a NULL-terminated<o:p></o:p></p></div><div><p class=MsoNormal> character string identifying the row of data<o:p></o:p></p></div><div><p class=MsoNormal> which you are retrieving the results for.<o:p></o:p></p></div><div><p class=MsoNormal> This argument must contain a valid string<o:p></o:p></p></div><div><p class=MsoNormal> whenever the "KT" column of the selected<o:p></o:p></p></div><div><p class=MsoNormal> NHRList.txt data contains a value > 0.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> Example:<o:p></o:p></p></div><div><p class=MsoNormal> To retrieve the total site energy use for a building (from the<o:p></o:p></p></div><div><p class=MsoNormal> BEPS report):<o:p></o:p></p></div><div><p class=MsoNormal> To determine iEntry, open the NHRList.txt file and search<o:p></o:p></p></div><div><p class=MsoNormal> for "BEPS" to find: "2001 BEPS Building Energy..."<o:p></o:p></p></div><div><p class=MsoNormal> The "2001" is the first four digits of the iEntryID, then<o:p></o:p></p></div><div><p class=MsoNormal> we do another search for "2001 BEPS" to get down to the<o:p></o:p></p></div><div><p class=MsoNormal> area where the BEPS report entries are defined. Once there<o:p></o:p></p></div><div><p class=MsoNormal> we examine the text to the far right of each entry which<o:p></o:p></p></div><div><p class=MsoNormal> provides a description of the results which that entry<o:p></o:p></p></div><div><p class=MsoNormal> retrieves data for. We find that the entry ID 2001001<o:p></o:p></p></div><div><p class=MsoNormal> retrieves "Total Site Energy (BTU)".<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> Here's what the call looks like (in 'C'):<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> float fResult;<o:p></o:p></p></div><div><p class=MsoNormal> long lRetVal = D2R_GetSingleResult(<o:p></o:p></p></div><div><p class=MsoNormal> "E:\\WinDOE2\\doe-2\\",<o:p></o:p></p></div><div><p class=MsoNormal> "E:\\WinDOE2\\Projects\\Proj1\\Proj1",<o:p></o:p></p></div><div><p class=MsoNormal> 2001001, &fResult, 1, NULL, NULL );<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>2) When retrieving mutliple single values or arrays of results from the<o:p></o:p></p></div><div><p class=MsoNormal> same Non-Hourly results file, it is most efficient to use a different<o:p></o:p></p></div><div><p class=MsoNormal> function in order to retrieve all the results at once:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> long D2R_GetMultipleResult( const char* pszDOE2Dir,<o:p></o:p></p></div><div><p class=MsoNormal> const char* pszInpFileName,<o:p></o:p></p></div><div><p class=MsoNormal> int iFileType,<o:p></o:p></p></div><div><p class=MsoNormal> float* pfData,<o:p></o:p></p></div><div><p class=MsoNormal> int iMaxValues,<o:p></o:p></p></div><div><p class=MsoNormal> int iNumMRTs,<o:p></o:p></p></div><div><p class=MsoNormal> MultResultsType* pMRTs );<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> Return Value:<o:p></o:p></p></div><div><p class=MsoNormal> >= 0 => successful - # of values retrieved<o:p></o:p></p></div><div><p class=MsoNormal> < 0 => failed - refer to the D2ResX.h header file for<o:p></o:p></p></div><div><p class=MsoNormal> descriptions of the various return values.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> Where:<o:p></o:p></p></div><div><p class=MsoNormal> pszDOE2Dir => Directory where DOE-2 system files (such as<o:p></o:p></p></div><div><p class=MsoNormal> BDLKey.bin, BDLLib.dat, etc.) are stored<o:p></o:p></p></div><div><p class=MsoNormal> (including a trailing '\').<o:p></o:p></p></div><div><p class=MsoNormal> pszFileName => The full path and filename of the BDL input<o:p></o:p></p></div><div><p class=MsoNormal> file without the trailing dot or file<o:p></o:p></p></div><div><p class=MsoNormal> extension.<o:p></o:p></p></div><div><p class=MsoNormal> (i.e. if your DOE-2 input filename is:<o:p></o:p></p></div><div><p class=MsoNormal> "C:\My Dir\Projects\Wall Mart\Wall Mart.inp"<o:p></o:p></p></div><div><p class=MsoNormal> then pszFileName should be:<o:p></o:p></p></div><div><p class=MsoNormal> "C:\My Dir\Projects\Wall Mart\Wall Mart")<o:p></o:p></p></div><div><p class=MsoNormal> iFileType => 0 for Loads results, 1 for HVAC and simulated<o:p></o:p></p></div><div><p class=MsoNormal> Energy Use results and 2 for Utility Rate and<o:p></o:p></p></div><div><p class=MsoNormal> Economics results. This value should also<o:p></o:p></p></div><div><p class=MsoNormal> correspond to the first digit of each NHRList<o:p></o:p></p></div><div><p class=MsoNormal> entry ID minus 1.<o:p></o:p></p></div><div><p class=MsoNormal> pfData => Address of an array of 32-bit floating point<o:p></o:p></p></div><div><p class=MsoNormal> numbers to be populated with ALL single or<o:p></o:p></p></div><div><p class=MsoNormal> arrays of results.<o:p></o:p></p></div><div><p class=MsoNormal> iMaxValues => Number of floats defined in above array.<o:p></o:p></p></div><div><p class=MsoNormal> iNumMRTs => Number of MultResultsType structures pointed<o:p></o:p></p></div><div><p class=MsoNormal> to by the following argument. Only the first<o:p></o:p></p></div><div><p class=MsoNormal> 12 will be used, each one must retrieve results<o:p></o:p></p></div><div><p class=MsoNormal> from the same file and the number of items<o:p></o:p></p></div><div><p class=MsoNormal> retrieved for each element should be equal.<o:p></o:p></p></div><div><p class=MsoNormal> pMRTs => Pointer to an array of MultResultsType<o:p></o:p></p></div><div><p class=MsoNormal> structures:<o:p></o:p></p></div><div><p class=MsoNormal> struct MultResultsType<o:p></o:p></p></div><div><p class=MsoNormal> {<o:p></o:p></p></div><div><p class=MsoNormal> int iEntryID; // from NHRList.txt<o:p></o:p></p></div><div><p class=MsoNormal> int iReturnValue; // success/failure<o:p></o:p></p></div><div><p class=MsoNormal> char pszReportKey[ 34 ];<o:p></o:p></p></div><div><p class=MsoNormal> char pszRowKey[ 34 ];<o:p></o:p></p></div><div><p class=MsoNormal> };<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> Example:<o:p></o:p></p></div><div><p class=MsoNormal> To retrieve the energy use by end-use and the end-use sum for<o:p></o:p></p></div><div><p class=MsoNormal> a series of electric meters (EM1 and EM2) from the PS-F reports<o:p></o:p></p></div><div><p class=MsoNormal> followed by the sum across all electric meters by end-use from<o:p></o:p></p></div><div><p class=MsoNormal> the PS-E reports:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> MultResultsType MRTs[4];<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> MRTs[0].iEntryID = 2309007; // EM1 array from PS-F<o:p></o:p></p></div><div><p class=MsoNormal> MRTs[0].pszReportKey = "EM1";<o:p></o:p></p></div><div><p class=MsoNormal> MRTs[0].pszRowKey[0] = '\0';<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> MRTs[1].iEntryID = 2309007; // EM2 array from PS-F<o:p></o:p></p></div><div><p class=MsoNormal> MRTs[1].pszReportKey = "EM2";<o:p></o:p></p></div><div><p class=MsoNormal> MRTs[1].pszRowKey[0] = '\0';<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> MRTs[2].iEntryID = 2305005; // Elec Mtr Totals from PS-E<o:p></o:p></p></div><div><p class=MsoNormal> MRTs[2].pszReportKey[0] = '\0';<o:p></o:p></p></div><div><p class=MsoNormal> MRTs[2].pszRowKey[0] = '\0';<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> float fResults[39]; // 3 MRTs x 13 values per MRT<o:p></o:p></p></div><div><p class=MsoNormal> long lRetVal = D2R_GetMultipleResult(<o:p></o:p></p></div><div><p class=MsoNormal> "E:\\WinDOE2\\doe-2\\",<o:p></o:p></p></div><div><p class=MsoNormal> "E:\\WinDOE2\\Projects\\Proj1\\Proj1",<o:p></o:p></p></div><div><p class=MsoNormal> 1, fResults, 39, 3, MRTs );<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>3) Additional functions exist enabling you to determine how many<o:p></o:p></p></div><div><p class=MsoNormal> building components of a particular type were defined in the<o:p></o:p></p></div><div><p class=MsoNormal> input file corresponding to the results you are retrieving as<o:p></o:p></p></div><div><p class=MsoNormal> well as the name of each of those components. These functions<o:p></o:p></p></div><div><p class=MsoNormal> enable you to retrieve results for particular building components<o:p></o:p></p></div><div><p class=MsoNormal> when you are not sure what the component names were in the<o:p></o:p></p></div><div><p class=MsoNormal> original BDl input.<o:p></o:p></p></div><div><p class=MsoNormal> Refer to the function definitions in the D2ResX.h header file for<o:p></o:p></p></div><div><p class=MsoNormal> more details.<o:p></o:p></p></div></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Best regard<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span lang=ZH-CN>赵永青</span><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span lang=ZH-CN>长沙绿建节能科技有限公司</span><o:p></o:p></p></div><div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial Narrow","sans-serif"'>------------------ </span><span lang=ZH-CN style='font-size:9.0pt'>原始邮件</span><span style='font-size:9.0pt;font-family:"Arial Narrow","sans-serif"'> ------------------<o:p></o:p></span></p></div><div><div><p class=MsoNormal style='background:#EFEFEF'><b><span lang=ZH-CN style='font-size:9.0pt'>发件人</span></b><b><span style='font-size:9.0pt'>:</span></b><span style='font-size:9.0pt'> "Yf Sun"<<a href="mailto:caselysun@gmail.com" target="_blank">caselysun@gmail.com</a>>;<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#EFEFEF'><b><span lang=ZH-CN style='font-size:9.0pt'>发送时间</span></b><b><span style='font-size:9.0pt'>:</span></b><span style='font-size:9.0pt'> 2013<span lang=ZH-CN>年</span>5<span lang=ZH-CN>月</span>22<span lang=ZH-CN>日</span>(<span lang=ZH-CN>星期三</span>) <span lang=ZH-CN>上午</span>10:07<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#EFEFEF'><b><span lang=ZH-CN style='font-size:9.0pt'>收件人</span></b><b><span style='font-size:9.0pt'>:</span></b><span style='font-size:9.0pt'> "tiejun hu"<<a href="mailto:hutiejun1223@126.com" target="_blank">hutiejun1223@126.com</a>>; <o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#EFEFEF'><b><span lang=ZH-CN style='font-size:9.0pt'>抄送</span></b><b><span style='font-size:9.0pt'>:</span></b><span style='font-size:9.0pt'> "equest-users"<<a href="mailto:equest-users@lists.onebuilding.org" target="_blank">equest-users@lists.onebuilding.org</a>>; <o:p></o:p></span></p></div><div><p class=MsoNormal style='background:#EFEFEF'><b><span lang=ZH-CN style='font-size:9.0pt'>主题</span></b><b><span style='font-size:9.0pt'>:</span></b><span style='font-size:9.0pt'> Re: [Equest-users] Is there a way to extract specific data from simresult?<o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Hi, tiejun!</span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Thanks for your reply but I dont need the hourly data, i need annual system peak loads, cooling and heating system loads for example, do you have a idea how to automate the data extraction?<o:p></o:p></span></p></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Wed, May 22, 2013 at 10:05 AM, Yf Sun <<a href="mailto:caselysun@gmail.com" target="_blank">caselysun@gmail.com</a>> wrote:<o:p></o:p></p><div><p class=MsoNormal>Hi, tiejun!<o:p></o:p></p><div><p class=MsoNormal>Thanks for your reply but I dont need the hourly data, i need annual system peak loads, cooling and heating system loads for example, do you have a idea how to automate the data extraction?<o:p></o:p></p></div></div><div><div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Wed, May 22, 2013 at 9:51 AM, tiejun hu <<a href="mailto:hutiejun1223@126.com" target="_blank">hutiejun1223@126.com</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'>Hi,Yf<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'> You can creat hourly reports in detail mode, then run it, open hourly reports in sim file.<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'> Best regards<br><br><br><br><o:p></o:p></span></p></div><div><div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p></div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'>At 2013-05-22 09:48:23,"Yf Sun" <<a href="mailto:caselysun@gmail.com" target="_blank">caselysun@gmail.com</a>> wrote:<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'>Hi,dear Equesters!<br clear=all><o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'>Im currently doing my ph.d research using equest to analyse building energy performance, i found its time consuming to find the data i need from sim result, as the data i need almost the same for every simulation, do you know a way to extract the specific text data(for importing to excel) quickly by using some third party program maybe?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'>-- <o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'>Best regards<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Arial","sans-serif"'>Ivan<o:p></o:p></span></p></div></div></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p></div><p class=MsoNormal><br><br clear=all><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div></div></div><p class=MsoNormal><span style='color:#888888'>-- <o:p></o:p></span></p><div><div><p class=MsoNormal><span style='color:#888888'>Best regards<o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=ZH-CN style='color:#888888'>孙一峰</span><span style='color:#888888'><o:p></o:p></span></p></div></div></div></div><p class=MsoNormal><br><br clear=all><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>-- <o:p></o:p></p><div><div><p class=MsoNormal>Best regards<o:p></o:p></p></div><div><p class=MsoNormal><span lang=ZH-CN>孙一峰</span><o:p></o:p></p></div></div></div></div></div></div><p class=MsoNormal><br><br clear=all><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>-- <o:p></o:p></p><div><div><p class=MsoNormal>Best regards<o:p></o:p></p></div><div><p class=MsoNormal><span lang=ZH-CN>孙一峰</span><o:p></o:p></p></div></div></div></div></body></html>