<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Nick,<br>
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:<br>
<br>
EQUATIONS 1<br>
V_Tank = 0.5<br>
<br>
You could then swap in one include file or another (or rewrite the
include file from Excel using a macro) before you ran TRNSYS.<br>
Best,<br>
David<br>
<br>
<br>
On 8/11/2011 12:00, Nicholas LaHam wrote:
<blockquote
cite="mid:CA+tQc8k3mk8hquN9tW1V0OXHdQw+hbGUPatz2mCyOCxtsX-fEA@mail.gmail.com"
type="cite">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.
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>Also, it is possible to go in reverse? Can I have outputs of
TRNSYS go to excel?</div>
<div><br>
</div>
<div>I tried a few things and can't seem to get the component to
work.</div>
<div><br>
</div>
<div>
Thanks,</div>
<div>Nick</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
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>