[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [TRNSYS-users] coupling Excel



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@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

 


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




_______________________________________________
TRNSYS-users mailing list
TRNSYS-users@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@tess-inc.com

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