Re: Creating plot images

["Werner Keilholz" <werner@xxxxxxx>]

Hi Lyndon,

you don't need a macro for this. Just use .xls as an extension for any output file
created by any type 25 (printer), for example out.xls. Then you can just
double-click on it in the Explorer to open it in Excel. Select All and hit the
'graph' button in Excel. (If you're really lazy and want a macro for these
two actions ;-), you can easily make it yourself by doing it once and
recording it with "Tools/Macro" under Excel).

You can also set the 'Spreadsheet' to Excel ("Codes" Icon in IISiBat 2,
"File/Settings/Directories" in IISiBat 3) and then open the file with a right
mouse-click and selecting "Open in Spreadsheet". IISiBat (2 and 3) comes
with a nice build-in Spreadsheet, if you don't have Excel.

TRANSSOLAR also has some fancy propretary spreadsheet which is said to work
particularly well for simulation. (See http://www.transsolar.com if you understand
German, else you can mail them at mailto:feedback@transsolar.com).

Hope this helps,

Werner

LyndonZimmermann wrote:

> Greetings all,
>
> how does the TRNSYS community develop graphical output plots?  I've used
> TRNSHELL 32, screen dumped and edited with a graphical editor, ugly!  Has
> anyone written a macro for, say, importing into Excel?
>
> Lyndon Zimmermann
> Adelaide
>
> Lyndon Zimmermann
> BE (Mech Adel) Grad Dip Bus Admin (UniSA)
> 24 Waverley St, Mitcham, South Australia, 5062
> tel +61-8-8272 9262 mobile 0414 91 4577 fax +61-8-8172 1494
> email lyndonz@senet.com.au URL http://users.senet.com.au/~lyndonz

--
  /    \____ Werner Keilholz, Project Manager
  \____/     CSTB Sophia Antipolis, EVL Division
  /    \____ s-mail: BP 209, 06904 SOPHIA ANTIPOLIS,  F R A N C E
  \____/     phone: +33 (0)4 93 95 67 46 -- fax: +33 (0)4 93 95 67 33
  /    \____ Mailto:werner@cstb.fr
  \____/     http://evl.cstb.fr/english/team/WK/werner.htm

* 3rd French TRNSYS meeting - Sophia Antipolis France, Oct. 23-25 *
                 http://evl.cstb.fr/flash/trnsys_anim.html