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

[David S Eldridge]

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