[bldg-sim] tools/software for extracting specific data/info from DOE-2.2output file

[Graham & Megan]

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.
Regards,
Graham
----- Original Message ----- 
  From: David Eldridge 
  To: bldg-sim at gard.com 
  Cc: perickson at aeieng.com 
  Sent: Saturday, October 08, 2005 4:28 AM
  Subject: [bldg-sim] tools/software for extracting specific data/info from DOE-2.2output file


  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.

            StoreResults_HVAC_Summary=1

  This will create a CSV file with the information in it.

  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.

  If anyone has some good VBA I'd be interested in seeing it, if it's public.

  Lastly, I don't know if everyone knew this or not...but you can copy and paste items out of the "spreadsheet view".

  David




----------------------------------------------------------------------------
    From: "Paul Erickson" <perickson at aeieng.com>
    Reply-To: perickson at aeieng.com
    To: <bldg-sim at gard.com>
    Subject: [bldg-sim] tools/software for extracting specific data/info from DOE-2.2output file
    Date: Fri, 07 Oct 2005 12:52:22 -0500


    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.

    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.

    Regards,

    Paul Erickson

=====================================================You received this e-mail because you are subscribed
to the BLDG-SIM at GARD.COM mailing list.  To unsubscribe
from this mailing list send a blank message to
BLDG-SIM-UNSUBSCRIBE at GARD.COM



======================================================
You received this e-mail because you are subscribed 
to the BLDG-SIM at GARD.COM mailing list.  To unsubscribe 
from this mailing list send a blank message to 
BLDG-SIM-UNSUBSCRIBE at GARD.COM


===========================
You received this e-mail because you are subscribed 
to the BLDG-SIM at GARD.COM mailing list.  To unsubscribe 
from this mailing list send a blank message to 
BLDG-SIM-UNSUBSCRIBE at GARD.COM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20051008/56f9f35d/attachment-0002.htm>