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

[Chris Jones]

I use UltraEdit.  http://www.ultraedit.com/ This text editor is fully 
customizable, you can set the line length to any amount to avoid word 
wrapping.  It has a macro recording facility which is very good for 
extracting specific information such as the SV-A system and zone listings, 
hourly channels, etc.  It reads and searches huge sim files instantly.  It 
has a great file compare function if you need to compare two input files to 
see what might be different.




>If you're using the eQUEST parametric runs function, eQUEST generates the 
>following spreadsheet file which I've found to be particularly useful:
>
>[FileName] - Parms.csv
>
>This file lists the parametric run case description, the peak cooling coil 
>load, energy by end use, demand by end use, and total cost by energy type, 
>all in spreadsheet format.  If you've run the parametric run multiple 
>times, this spreadsheet also lists results from earlier runs.
>
>Best Regards,
>Gail Stranske
>CTG Energetics, Inc.
>
>On 10/24/06, Michael Rosenberg 
><<mailto:Michael.Rosenberg at state.or.us>Michael.Rosenberg at state.or.us > wrote:
>Andrew,
>
>If you are using MS Word, try this. Open the *.sim file in Word, Select
>the entire document, change the font to "Courier New", set font size to
>7, and set left and right page margins to 0.25". That should do the
>trick. Try creating a macro to automate this task.
>
>Mike
>
>Michael Rosenberg
>Oregon Department of Energy
>625 Marion St. N.E.
>Salem, OR 97301-3742
>Phone : (503) 373-7809
>Fax: (503) 373-7806
>
> >>> "Andrew Craig" <<mailto:andrew_c at ieice.com> andrew_c at ieice.com> 
> 10/24/06 03:44PM >>>
>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: <mailto:Andrew_C at ieice.com>Andrew_C at ieice.com
>web: <http://www.ieice.com/>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 <mailto:BLDG-SIM at GARD.COM>BLDG-SIM at GARD.COM mailing list.  To 
>unsubscribe
>from this mailing list send a blank message to
><mailto:BLDG-SIM-UNSUBSCRIBE at GARD.COM>BLDG-SIM-UNSUBSCRIBE at GARD.COM
>
>======================================================
>You received this e-mail because you are subscribed
>to the <mailto:BLDG-SIM at GARD.COM>BLDG-SIM at GARD.COM mailing list.  To 
>unsubscribe
>from this mailing list send a blank message to
><mailto:BLDG-SIM-UNSUBSCRIBE at GARD.COM>BLDG-SIM-UNSUBSCRIBE at GARD.COM
>
>
>ASPAM=antispamwpk42


Chris Jones, P.Eng.
14 Oneida Avenue
Toronto, ON M5J2E3
Tel. 416 203-7465
Fax. 416 946-1005 

======================================================
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/20061027/3cc5a4e7/attachment-0002.htm>