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

Re: [TRNSYS-users] excel question



Nick,
  There are two ways that you can get parameter information into a simulation from an external source; neither one is ideal and neither one uses Excel. First is to use Type70; it replaces whatever parameter values you specified in the Studio project with the values that it finds in a text file (the text file name is specified by Type70). If you can write your parameters such as tank volume to a text file then you can have Type70 read them in. Second, you can put all of the values into an include file. Your include file has to respect TRNSYS input file syntax. For example, you'd have to write:

EQUATIONS 1
V_Tank = 0.5

You could then swap in one include file or another (or rewrite the include file from Excel using a macro) before you ran TRNSYS.
Best,
 David


On 8/11/2011 12:00, Nicholas LaHam wrote:
I looked at the examples for calling excel but I think what I am trying to achieve is different, maybe someone can help or tell me if it's possible.

Is it possible to have TRNSYS actually use inputs or parameters (as strings) from an excel spreadsheet. For instance, say I set a parameter in TRNSYS for volume to a string, V_Tank. Then I have a certain cell in my spreadsheet with the number I want to use in my simulation. Is it possible to use the excel component to set V_Tank to whatever my cell in excel is set at?

Also, it is possible to go in reverse? Can I have outputs of TRNSYS go to excel?

I tried a few things and can't seem to get the component to work.

Thanks,
Nick
_______________________________________________ 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