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

[Sheila Sagerer]

Hi David-

You may want to try to import the ES-F report into excel using the
following:

1.  In the .sim file, highlight the portions of the ES-F report that you
want and copy it to the clipboard
2.  In excel, paste it as normal
3.  Highlight the first column of cells of the pasted material
4.  Go to "DATA" in the toolbar
5.  Choose "Text to columns" which opens a wizard that allows you to
separate that data into individual cells so that the info can be used in
formulas etc.  You will probably have to do some formatting of cells to make
the table easier to read.

I've used this method on some of the other reports, i.e. PS-E, BEPU, etc.

Good luck.

Sheila Sagerer
Energy Engineer
Energy Opportunities, Inc.
717-880-9069

-----Original Message-----
From: postman at gard.com [mailto:postman at gard.com]On Behalf Of David S
Eldridge
Sent: Wednesday, March 31, 2004 5:46 PM
To: BLDG-SIM at gard.com
Subject: [BLDG-SIM] eQuest / DOE2.2 output questions - looking for VBA
code...


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