[TRNSYS-users] excel question

[David BRADLEY]

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 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/20110812/8644db9f/attachment-0005.htm>