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

David Bradley bradley at tess-inc.com
Mon Nov 10 08:08:26 PST 2008


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 at ilkdresden.de 
> <mailto:carsten.heinrich at 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 at ilkdresden.de <mailto:gf at ilkdresden.de> ? Web: 
> http://www.ilkdresden.de <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 at 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 at tess-inc.com 
Web Pages:  http://www.tess-inc.com    and      http://www.trnsys.com

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20081110/c5e2ae7a/attachment-0005.htm>


More information about the TRNSYS-users mailing list