<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Leen and Louis,<br>
With the release of Trnsys17, we recoded Type62 so that it can
have however many inputs and outputs you want. By default the
component is compiled to allow 15 of each but by changing a few
(hopefully obvious) variable values in the Fortran code and then
recompiling the TRNDll.dll, you can increase those limits.<br>
<br>
If you are running into a 10 input limit, check to make sure that
there is not an arbitrary maximum number of inputs allowed in the
Type62 proforma. If there is, try and Edit: Replace with the Type62
from the direct access tool. Check also in your Excel spreadsheet to
make sure that the VBA script that is in there is able to
accommodate more than 10 inputs. If you started from the "schedules"
excel spreadsheet, the VBA script is set up for 10 inputs; you can
copy and past lines in that script to increase the limit but you
also have to make sure that you name the cells as well (press
ctrl-f3 when you're in the spreadsheet to name cells). The Type62
documentation in the 04-MathematicalDescriptions manual has some
additional hints as well.<br>
Best,<br>
David<br>
<br>
<br>
<div class="moz-cite-prefix">On 9/7/2012 07:02, leen peeters wrote:<br>
</div>
<blockquote
cite="mid:CAB_-mWN-ahAFS4C8RtFL9sN3OHkMoG8oyeKOdsUx8PXc9B8deQ@mail.gmail.com"
type="cite">
<div>Louis,</div>
<div> </div>
<div>I dd recently post a question about it. The way I solved it
is to call excell multiple times. Of course you can only do that
when a given amount of your excell calculations is to be
excecuted sequentially ...</div>
<div>But it works fine now with 3 times calling excell where the
output of one can be used as input for the next one...</div>
<div> </div>
<div>Leen<br>
<br>
</div>
<div class="gmail_quote">On Fri, Sep 7, 2012 at 8:42 AM, STEPHAN
Louis 231500 <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:Louis.STEPHAN@cea.fr" target="_blank">Louis.STEPHAN@cea.fr</a>></span>
wrote:<br>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote">
<div vlink="purple" link="blue" lang="EN-US">
<div>
<p class="MsoNormal">Dear All,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I am writing to ask about a problem
when coupling Excel to TRNSYS, in fact if the number of
Input is <= 8, everything works fine but for 9 or 10
Inputs excel is executed however it seems like the
calculations inside Excel are not done because the
reported variable doesn’t change. I have seen in the
forum that a question about this problem was already
asked but I didn’t find an answer. Anyone have an idea
about this problem?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Best regards, </p>
<p class="MsoNormal"> </p>
<p
style="margin-right:0cm;margin-bottom:6pt;margin-left:0cm"
class="MsoNormal">
<span style="font-size:10pt" lang="FR">Louis Stephan</span></p>
<p
style="margin-right:0cm;margin-bottom:6pt;margin-left:0cm"
class="MsoNormal">
<span style="font-size:10pt" lang="FR">Ingénieur
Chercheur / Docteur</span></p>
<p
style="margin-right:0cm;margin-bottom:6pt;margin-left:0cm"
class="MsoNormal">
<span
style="font-family:"Arial","sans-serif";font-size:10pt"
lang="FR">----------------------------------------------------------------------------</span></p>
<p
style="margin-right:0cm;margin-bottom:6pt;margin-left:0cm"
class="MsoNormal">
<span style="color:rgb(79,98,40);font-size:10pt"
lang="FR">Laboratoire d'Energétique du Bâtiment (LEB)</span></p>
<p
style="margin-right:0cm;margin-bottom:6pt;margin-left:0cm"
class="MsoNormal">
<span style="color:rgb(79,98,40);font-size:10pt"
lang="FR">INES / CEA
</span></p>
<p
style="margin-right:0cm;margin-bottom:6pt;margin-left:0cm"
class="MsoNormal">
<span style="color:rgb(79,98,40);font-size:10pt"
lang="FR">Recherche, Développement, Innovation
Industrielle</span></p>
<p
style="margin-right:0cm;margin-bottom:6pt;margin-left:0cm"
class="MsoNormal">
<span style="color:rgb(79,98,40);font-size:10pt"
lang="FR">50, avenue du Lac Leman</span></p>
<p
style="margin-right:0cm;margin-bottom:6pt;margin-left:0cm"
class="MsoNormal">
<span style="color:rgb(79,98,40);font-size:9pt"
lang="FR">73377 LE BOURGET DU LAC, France</span></p>
<p class="MsoNormal"><span
style="color:rgb(79,98,40);font-size:10pt">Tel: <a
moz-do-not-send="true"
href="tel:%2B33%20%284%29%2079%2060%2019%2042"
target="_blank" value="+33479601942">+33 (4) 79 60
19 42</a></span></p>
<p class="MsoNormal"> </p>
</div>
</div>
<br>
_______________________________________________<br>
TRNSYS-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:TRNSYS-users@cae.wisc.edu">TRNSYS-users@cae.wisc.edu</a><br>
<a moz-do-not-send="true"
href="https://mailman.cae.wisc.edu/listinfo/trnsys-users"
target="_blank">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a><br>
<br>
</blockquote>
</div>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
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://mailman.cae.wisc.edu/listinfo/trnsys-users">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
***************************
David BRADLEY
Principal
Thermal Energy Systems Specialists, LLC
22 North Carroll Street - suite 370
Madison, WI 53703 USA
P:+1.608.274.2577
F:+1.608.278.1475
<a class="moz-txt-link-abbreviated" href="mailto:d.bradley@tess-inc.com">d.bradley@tess-inc.com</a>
<a class="moz-txt-link-freetext" href="http://www.tess-inc.com">http://www.tess-inc.com</a>
<a class="moz-txt-link-freetext" href="http://www.trnsys.com">http://www.trnsys.com</a></pre>
</body>
</html>