[BLDG-SIM] eQuest / DOE2.2 output questions - looking for VBAcode...

Varkie Thomas Varkie.Thomas at som.com
Thu Apr 1 07:49:57 PST 2004


We do this by deleting all the non-tabular data in the ".SIM" output
file, saving it as a ".txt" file, and then opening the text file with
Excel.  Some of the many uses here are to generate charts from the ".FT"
weather data and to analyze the hourly data of specific Fortran
variables in the DOE2 program such as the condensate at cooling coils in
hot and humid climates.  The latter involves stripping the header and
the footer (daily summaries) on each page. 

Varkie Thomas
Skidmore, Owings & Merrill

-----Original Message-----
From: David S Eldridge [mailto:DSE at grummanbutkus.com] 
Sent: Wednesday, March 31, 2004 4:46 PM
To: BLDG-SIM at gard.com
Subject: [BLDG-SIM] eQuest / DOE2.2 output questions - looking for
VBAcode...

Does anyone have any MS word macros that they would share for selecting
different output reports and printing them, or exporting some of the
tabular data to MS Excel?  Or opening some of the output directly in
excel? 

For instance you can get the monthly and annual summaries of the
electric and fuel in the CSV file, but for complex rate structures you
can't immediately turn that into dollar amounts, you'd have to import
something like the ES-F report to get at each electric block. 

The default graphs are nice, but let's say that you wanted to compare
your simulation results with some data that you had paper bills for an
SDG&E rate AT-TOU. 

Energy/billing comparisons seem to be the main reason I'd want to use
these things, although another possibility would be to construct tables
of SV-A data or to refresh the value of some other parameter that
changes based on modifications to your simulation - without opening and
formatting a 4 MB *.sim file.  I see 14 different output files in my
directory, but don't how I would get any information out of them except
for the *.sim, *.csv, and of course the text files. 

If anyone can point me in the direction of tools that might be out
there, or give me some strategy tips on how I might accomplish these
things in VBA I would really appreciate it. 

Thanks!

David

==================
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



More information about the Bldg-sim mailing list