Re: [TRNSYS-users] Type 62 Excel - Initial Procedure in VBA

[David Bradley <bradley@tess-inc.com>]

Carsten,
  I am not sure that Type62 is going to be much help. I wonder if you could write an Excel macro that saves your results in a tab delimited text file which could be read by Type9. Of course Type9 will read the file every time step but the data read doesn't take much time. If you need the results of your Excel sheet as parameters to other TRNSYS components in your simulation, then you can look at using Type70, which reads a text file of parameter values, then replaced those values that are already set in the proformas.
Kind regards,
 David


Heinrich Carsten wrote:

Dear all,

 

I have a question about the type 62 for coupling TRNSYS with Excel. I use some user defined Visual Basic functions in my Excel sheet, which have a high number of parameter input. The parameters are defined in the worksheet. To speed up I would like to declare those parameters a static variables in the vba – modul.

 

And now my question: Is there a procedure call from TRNSYS, which is only called once in the beginning of the simulation? Because I want to read the parameters from the worksheet into the static variables only once and not for each time step and iteration call.

 

Best regards

Carsten Heinrich 

Department Refrigeration and Cryogenics
Phone   (0351) 40 81 637
Fax        (0351) 40 81 635
E-Mail    carsten.heinrich@ilkdresden.de

Institut für Luft- und Kältetechnik Dresden gGmbH ● Bertolt-Brecht-Allee 20, 01309 Dresden
Geschäftsführer Dr. rer. nat. habil. Ralf Herzog ● Prokurist Prof. Dr.-Ing. Uwe Franzke
Phone.: 0351/40 81-520 ● Fax: 0351/40 81-525 ● E-Mail: gf@ilkdresden.de ● Web: http://www.ilkdresden.de
Commerzbank Dresden ● Kto. 8 000 135 ● BLZ 850 400 00 ● Amtsgericht Dresden HRB 6118 ● UID-Nr. DE 140 12 88 98

 

_______________________________________________
TRNSYS-users mailing list
TRNSYS-users@cae.wisc.edu
https://www-old.cae.wisc.edu/mailman/listinfo/trnsys-users
  

-- 
***********************************************************************
Thermal Energy System Specialists (TESS), LLC 
David BRADLEY                      22 N. Carroll Street - Suite 370 
Partner                            Madison, WI 53703 
                                   USA
P: +1.608.274.2577 
F: +1.608.278.1475
E-mail: bradley@tess-inc.com 
Web Pages:  http://www.tess-inc.com    and      http://www.trnsys.com

***********************************************************************