[TRNSYS-users] linking excel to TRNSYS

ahmed serageldin via TRNSYS-users trnsys-users at lists.onebuilding.org
Tue Nov 8 00:01:53 PST 2016


Dear Amirreza
In excel, Formula tab you will find define Name in Defined Names section
By clicking Define name you can enter the name and select cell

*Yours sincerely;*

*Eng: Ahmed Mohamed Awad*
*Ph.D student*
*Energy Resources Engineering Department(ERE)*
*Egypt-Japan University of Science and Technology(EJUST)*
*Mob:+2010-65078029*
*Email: ahmedawadserageldin at gmail.com <heba_abadi at hotmail.com> -
**ahmed.serageldin at ejust.edu.eg
<heba.abbadi at ejust.edu.eg>*
*Website: **www.ejust.edu.eg <heba.abbadi at ejust.edu.eg>*
*P.O. Box 179, New Borg El-Arab City, Postal Code 21934, Alexandria, Egypt*

P *Please consider the environment and don't print this e-mail unless you
really need to.*


On Tue, Nov 8, 2016 at 9:42 AM, Amirreza Heidary via TRNSYS-users <
trnsys-users at lists.onebuilding.org> wrote:

> Dear all I'm going to create an evaporative rigid media as a new
> component in TRNSYS using excel.Inlet temperature and mass flow rate for
> air and water are as inputs and it should calculate outlet conditions
> useing heat and mass transfer equations . I couldn't find any instructions
> about linking excel to TRNSYS. I have used type 62 and I set the number of
> inputs and outputs. Also I have enabled macro in excel. Now, I have two
> questions:
> 1- according to example, I should rename some cells to Inp1 , Inp2 ...
> Out1, Out2,.... there is a column in any excel spreadsheet named INP, so
> when I want to rename a cell to Inp1 , this will go to first cell of INP
> column after pressing enter without renaming the cell. how I should rename
> cells to Inp1 , .... ? 2- after completing the excel file using my
> equations, How I should link my excel file to type 62?
>
> Thank you
>
> ------------------------------------------------------------
> ------------------------------------------------------------
> --------------------------
>
> *amirrezaheidary*
> *master student of energy systems Engineering*
> *Sharif university of technology*
> *Tehran-Iran*
> *E-mail address*:
>
> heidari at energy.sharif.edu
>
> a <sm_mousavi at pwut.ac.ir>mirrezaheidarysbu at gmail.com
>
> *P* *Save a tree... Please don't print this E-mail unless you really need
> to.*
>
>
>
>
>
>
> _______________________________________________
> TRNSYS-users mailing list
> TRNSYS-users at lists.onebuilding.org
> http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20161108/da9988fd/attachment-0003.htm>


More information about the TRNSYS-users mailing list