<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I've developed Excel based VBA macros to setup, run
and post process batch mode DOE-2.2 simulations. Once you get the hang of
the key VBA functions it is quite powerful. In terms of extracting
information specific to a system, zone, or piece of plant equipment I have had
these in Excel cells that are then assigned to VBA variables as part of the
macro to enable searching for system/zone/equipment information by report
type. You could probably write a macro to extract all zone names from the
SV-A reports, but I haven't gone this far. While SIM files are highly
predictable there are situations where their format varies and thus you need to
be careful with line counting from a report header etc. Simple things like
dual duct systems have two lines per zone in the SV-A report. There are
other reports that vary in structure vertically but I can't think of them off
the top of my head. Microsoft.com has a lot of excellent knowledge
base information for solving those VBA problems that aren't immediately
obvious.</FONT></DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Graham</FONT></DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=dancingdavide@hotmail.com
href="mailto:dancingdavide@hotmail.com">David Eldridge</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=bldg-sim@gard.com
href="mailto:bldg-sim@gard.com">bldg-sim@gard.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=perickson@aeieng.com
href="mailto:perickson@aeieng.com">perickson@aeieng.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, October 08, 2005 4:28
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [bldg-sim] tools/software for
extracting specific data/info from DOE-2.2output file</DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><FONT
face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR></DIV>
<DIV>
<P>Paul, you can add this line below to your eQuest.ini file (if it's not
there already?) to get a listing of the equipment and AHU parameters.</P>
<P>
StoreResults_HVAC_Summary=1</P>
<P>This will create a CSV file with the information in it.</P>
<P>No help with the extraction of the other reports. I used a simple
approach where I used a macro to format the *.sim so that it's easier to read
(select all, change font size smaller, and landscape pages)...but no
extraction.</P>
<P>If anyone has some good VBA I'd be interested in seeing it, if it's
public.</P>
<P>Lastly, I don't know if everyone knew this or not...but you can copy and
paste items out of the "spreadsheet view".</P>
<P>David<BR><BR></P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px"><FONT
style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif">
<HR color=#a0c6e5 SIZE=1>
From: <I>"Paul Erickson" <perickson@aeieng.com></I><BR>Reply-To:
<I>perickson@aeieng.com</I><BR>To:
<I><bldg-sim@gard.com></I><BR>Subject: <I>[bldg-sim] tools/software
for extracting specific data/info from DOE-2.2output file</I><BR>Date:
<I>Fri, 07 Oct 2005 12:52:22 -0500</I><BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<DIV style="COLOR: #000000">
<P>Is anyone aware of a software tool/product or another means by which to
easily extract/parse information found in the DOE-2 output/sim file?
The e-QUEST-produced reports are helpful for summing up the results, but I
would like to have quicker access to other information for
calibrating/verifying/questioning my models. For instance, it'd be
great to extract # of hours underheated or cooled, or perhaps I'd like to
extract the DOE-2 -sized cfm or capacity values. With a lot of
zones/systems this becomes a tedious task to deal with manually.</P>
<P>Any suggestions for a good method of doing this? I know some
have written VBA to this end, but is that limited in flexibility or easily
adaptable to all models (i.e. changing # of rooms affects line # in output
file)? Any help would be much appreciated.</P>
<P>Regards,</P>
<P>Paul Erickson</P></DIV><PRE>=====================================================You received this e-mail because you are subscribed
to the BLDG-SIM@GARD.COM mailing list. To unsubscribe
from this mailing list send a blank message to
BLDG-SIM-UNSUBSCRIBE@GARD.COM
</PRE><BR></FONT></BLOCKQUOTE></DIV><PRE>
======================================================
You received this e-mail because you are subscribed
to the BLDG-SIM@GARD.COM mailing list. To unsubscribe
from this mailing list send a blank message to
BLDG-SIM-UNSUBSCRIBE@GARD.COM
</PRE></BLOCKQUOTE><PRE>
===========================
You received this e-mail because you are subscribed
to the BLDG-SIM@GARD.COM mailing list. To unsubscribe
from this mailing list send a blank message to
BLDG-SIM-UNSUBSCRIBE@GARD.COM
</PRE></BODY></HTML>