[BLDG-SIM] Importing eQUEST Simulation File Reports into Excel/Word etc.

[David S Eldridge]

Two tid-bits (I'm in eQuest mode myself today...)

If you are looking just for the monthly energy end-uses, there will be a
file <filename>_EG_MoEU_ED.csv - I think this is the one John is talking
about.  It's great for importing since the fields are always in the same
location.

Also, if you open your eQuest.ini file in notepad (making a backup copy
beforehand of course...) and insert the lines:

;EDIT BELOW FOR Plant parameter output
StoreResults_HVAC_Summary=1

Then eQuest will produce another CSV file that includes listings of all
your equipment, systems, loops, etc.  This one is hard to work with on
an automated basis sometimes as your alternative runs may not have the
same number of pumps/loops/etc, changing the relative position of the
data.

I've inserted these two lines at the end of the "[preferences]" section.

Andrew, if these don't help you and you still need to import the sim
output, copy the page from the output viewer, paste into excel, and then
use "Text to columns" command with fixed widths or space delimiters.
Not automated, but Excel seems to understand at least once you've made
it into columns and will automatically parse into cells the next time
you paste the same data in the same location.

There is another program out there that can import data based on
keywords but I haven't advanced to that stage yet.  It's called AWK, you
can search the bldg-sim archive for information.  Might be worth it if
you are going to do this hundreds of times instead of tens of times.

Hope this helps!

David



> -----Original Message-----
> From: BLDG-SIM at GARD.COM [mailto:BLDG-SIM at GARD.COM] On Behalf 
> Of Aulbach, John
> Sent: Tuesday, October 24, 2006 6:26 PM
> To: BLDG-SIM at GARD.COM
> Subject: [BLDG-SIM] Importing eQUEST Simulation File Reports 
> into Excel/Word etc.
> 
> Hi Andrew:
>  
> I am going to frighten you a bit.
>  
> Unbeknownst to me until last week, eQuest actually 
> automatically generates a few Excel files with the basic 
> Monthly BEPU information (space cooling area lights, heat 
> rejection, etc), for all end uses, both on a consumption AND 
> demand basis.
>  
> Look at the .SIM file and find the Excel files generated.
>  
> I have NEVER seen this documented nor heard them mentioned in 
> any eQuest class. But it IS possible I missed such information.
> 
> ________________________________
> 
> From: BLDG-SIM at GARD.COM [mailto:BLDG-SIM at GARD.COM] On Behalf 
> Of Andrew Craig
> Sent: Tuesday, October 24, 2006 3:44 PM
> To: BLDG-SIM at GARD.COM
> Subject: [BLDG-SIM] Importing eQUEST Simulation File Reports 
> into Excel/Word etc.
> 
> 
> 
> I was wondering if anyone had any hints or suggestions for an 
> easier way to import the simulation file reports from eQUEST 
> into modern word processing or spreadsheet software.  Right 
> now when I try to copy and paste a report from a standard 
> text editor the spacing gets really screwed up.   I know that 
> the type set or format for the reports is antiquated (dot 
> matrix?) and is the reason for some of the problems, but I 
> don't know how to fix it.  Is there a more advanced text 
> editor or software that can help with this problem or is it a 
> computer code issue?  Any help would be greatly appreciated.
> 
> Andrew Craig | Mechanical Designer, Energy Modeler
> 
> INTERFACE ENGINEERING
> 708 SW Third Avenue | Suite 400 | Portland, OR 97204 
> 
> direct: 503.382.2696
> office: 503.382.2266
> fax: 503.382.2262
> email: Andrew_C at ieice.com
> web: www.ieice.com 
> 
> Consultants of Choice to the Built Environment for over 35 
> years Kirkland, WA | Portland, OR | Sacramento, CA | Salem, 
> OR | SanFrancisco, CA
> 
>  
> 
> 
> ==================
> 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