<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Carsten,<br>
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.<br>
Kind regards,<br>
David<br>
<br>
<br>
Heinrich Carsten wrote:
<blockquote
cite="mid:3B1F65F98667CB4E9310C11219AB1091026AEDED@saturn.ilknetz.local"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal">Dear all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">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. <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: navy;"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Best regards<o:p></o:p></span></p>
<p class="MsoNormal" style=""><span lang="EN-US">Carsten Heinrich <o:p></o:p></span></p>
<p class="MsoNormal" style=""><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;"
lang="EN-US">Department
Refrigeration and Cryogenics<br>
Phone (0351) 40 81 637</span><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;"
lang="EN-US"> <br>
</span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;"
lang="EN-US">Fax (0351) 40 81 635</span><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;"
lang="EN-US"> <br>
</span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;"
lang="EN-US">E-Mail </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;"><a
moz-do-not-send="true" href="mailto:carsten.heinrich@ilkdresden.de"><span
style="color: blue;" lang="EN-US">carsten.heinrich@ilkdresden.de</span></a></span><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: black;">
</span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;"
lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 7.5pt; color: black;">Institut
für Luft-
und Kältetechnik Dresden gGmbH </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> Bertolt-Brecht-Allee 20,
01309 Dresden </span><span style="font-size: 10pt; color: black;"><br>
</span><span style="font-size: 7.5pt; color: black;">Geschäftsführer
Dr. rer. nat.
habil. Ralf Herzog</span><span style="font-size: 10pt; color: black;"> </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> Prokurist Prof. Dr.-Ing. Uwe
Franzke</span><span style="font-size: 10pt; color: black;"> <br>
</span><span style="font-size: 7.5pt; color: black;">Phone.: 0351/40
81-520</span><span style="font-size: 10pt; color: black;"> </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> Fax: 0351/40 81-525</span><span
style="font-size: 10pt; color: black;"> </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> E-Mail: <a
moz-do-not-send="true" href="mailto:gf@ilkdresden.de"><span
style="color: blue;">gf@ilkdresden.de</span></a></span><span
style="font-size: 10pt; color: black;"> </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> Web: </span><span
style="color: black;"><a moz-do-not-send="true"
href="http://www.ilkdresden.de/" title="http://www.ilkdresden.de/"><span
style="font-size: 7.5pt; color: black;">http://www.ilkdresden.de</span></a></span><span
style="font-size: 10pt; color: black;"> <br>
</span><span style="font-size: 7.5pt; color: black;">Commerzbank
Dresden</span><span style="font-size: 10pt; color: black;"> </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> Kto. 8 000 135</span><span
style="font-size: 10pt; color: black;"> </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> BLZ 850 400 00</span><span
style="font-size: 10pt; color: black;"> </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> Amtsgericht Dresden HRB 6118 </span><span
style="font-size: 7.5pt; font-family: "Arial","sans-serif"; color: black;">●</span><span
style="font-size: 7.5pt; color: black;"> UID-Nr. DE 140 12 88 98</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
TRNSYS-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:TRNSYS-users@cae.wisc.edu">TRNSYS-users@cae.wisc.edu</a>
<a class="moz-txt-link-freetext" href="https://www-old.cae.wisc.edu/mailman/listinfo/trnsys-users">https://www-old.cae.wisc.edu/mailman/listinfo/trnsys-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
***********************************************************************
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: <a class="moz-txt-link-abbreviated" href="mailto:bradley@tess-inc.com">bradley@tess-inc.com</a>
Web Pages: <a class="moz-txt-link-freetext" href="http://www.tess-inc.com">http://www.tess-inc.com</a> and <a class="moz-txt-link-freetext" href="http://www.trnsys.com">http://www.trnsys.com</a>
***********************************************************************</pre>
</body>
</html>