[TRNSYS-users] coupling Excel

David BRADLEY d.bradley at tess-inc.com
Tue Sep 11 10:58:15 PDT 2012


Leen and Louis,
   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.

   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.
Best,
  David


On 9/7/2012 07:02, leen peeters wrote:
> Louis,
> 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 ...
> But it works fine now with 3 times calling excell where the output of 
> one can be used as input for the next one...
> Leen
>
> On Fri, Sep 7, 2012 at 8:42 AM, STEPHAN Louis 231500 
> <Louis.STEPHAN at cea.fr <mailto:Louis.STEPHAN at cea.fr>> wrote:
>
>     Dear All,
>
>     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?
>
>     Best regards,
>
>     Louis Stephan
>
>     Ingénieur Chercheur / Docteur
>
>     ----------------------------------------------------------------------------
>
>     Laboratoire d'Energétique du Bâtiment (LEB)
>
>     INES / CEA
>
>     Recherche, Développement, Innovation Industrielle
>
>     50, avenue du Lac Leman
>
>     73377 LE BOURGET DU LAC, France
>
>     Tel: +33 (4) 79 60 19 42 <tel:%2B33%20%284%29%2079%2060%2019%2042>
>
>
>     _______________________________________________
>     TRNSYS-users mailing list
>     TRNSYS-users at cae.wisc.edu <mailto:TRNSYS-users at cae.wisc.edu>
>     https://mailman.cae.wisc.edu/listinfo/trnsys-users
>
>
>
>
> _______________________________________________
> TRNSYS-users mailing list
> TRNSYS-users at cae.wisc.edu
> https://mailman.cae.wisc.edu/listinfo/trnsys-users

-- 
***************************
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
d.bradley at tess-inc.com

http://www.tess-inc.com
http://www.trnsys.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20120911/20886d49/attachment-0001.htm>


More information about the TRNSYS-users mailing list