[TRNSYS-users] excel question

Nicholas LaHam ndlaham at gmail.com
Fri Aug 12 09:59:11 PDT 2011


Thank you guys. I will try this. I also realize you can output to a new
excel file, but I am more interested in outputting to a specific column or
row in an existing excel file with existing data. Not sure this can be done.

With type 70 and some macros I should be able to pull inputs from an
existing excel file and at least accomplish that task.

Thanks all.
Nick

On Fri, Aug 12, 2011 at 12:53 PM, Aaron Danenberg <ajdanenberg at gmail.com>wrote:

> Nick,****
>
> ** **
>
> You can output to excel.  All you have to do is use a Type 65c online
> printer.  Create a blank xls file.  Go into the type 65c, select the
> external files tab, select browse, and go to the directory of the file you
> created.****
>
> ** **
>
> I have not called data from excel, I have called data from a txt file.  For
> example to save on simulation time of a geo thermal system, I simulated the
> building loads first and saved them to a txt file formatted with each hourly
> load in a single column.  Then I used a Data reader to call that data.  My
> advice is to play with the data reader, in my opinion the options are not
> all that intuitive, but without too much time, you should be able to figure
> out how to extract the data you want and use it in TRNSYS.****
>
> ** **
>
> -Aaron****
>
> ** **
>
> *From:* Nicholas LaHam [mailto:ndlaham at gmail.com]
> *Sent:* Thursday, August 11, 2011 1:00 PM
> *To:* TRNSYS-users at cae.wisc.edu
> *Subject:* [TRNSYS-users] excel question****
>
> ** **
>
> 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****
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20110812/4ba96c6f/attachment-0005.htm>


More information about the TRNSYS-users mailing list