<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">As others have pointed out, eQUEST runs
DOE-2.2 which outputs a text file originally renamed *.OUT in
DOE-2 but now renamed *.SIM in eQUEST. As a long-time DOE-2
user, I've written lots of awk scripts to extract out the
variables of interest from the *.OUT/*.SIM files. In fact, I only
look at the *.OUT/*.SIM file during the debugging phase of a
project, or when some results look suspicious. <br>
<br>
I don't know how many people still use awk, but I've found it
absolutely indispensible in my work (no exaggeration). Basically,
awk is a scripting language with C-like syntax, but more
contextual than formal languages like C or Fortran, i.e., you
don't have to define variable types, set array sizes, etc. <br>
<br>
When I use awk to extract data from a *.OUT/*.SIM file, I
basically do a pattern search for the title of the report (SS-A,
SS-H, etc.), and when I find it, I start counting lines. Then,
when I get to the correct line number, I pull out the variables of
interest, which in awk are simply the strings with a blank as the
"field separator". I've done this so many times that it takes me
only a few minutes to write an awk script for what you're trying
to do. For your info, I'm attaching a sample awk script that I
use to pull out the heating and cooling loads and peak loads from
an SS-H file.<br>
<br>
Awk has been around since the 1980's. I'm sure you can do the
same with Ppython, Perl, VB, etc., but I've never felt the need
because awk worked so well for me.<br>
<br>
Joe<br>
<br>
On 5/21/2013 6:48 PM, Yf Sun wrote:<br>
</div>
<blockquote
cite="mid:CAPz2vbNXM1UfL2njsX1RV6D9oRZ0n0L-yv5pxGupZ1sAMj=g2A@mail.gmail.com"
type="cite">
<meta http-equiv="Context-Type" content="text/html;
charset=ISO-8859-1">
<div dir="ltr">Hi,dear Equesters!<br>
<div>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?</div>
<div><br>
</div>
<div>-- </div>
<div dir="ltr">
<div>Best regards<br>
</div>
<div>Ivan</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Equest-users mailing list
<a class="moz-txt-link-freetext" href="http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org">http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org</a>
To unsubscribe from this mailing list send a blank message to <a class="moz-txt-link-abbreviated" href="mailto:EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG">EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG</a>
</pre>
</blockquote>
<br>
</body>
</html>