<div dir="ltr">Dear Amirreza<div>In excel, Formula tab you will find define Name in Defined Names section</div><div>By clicking Define name you can enter the name and select cell</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div style="text-align:left"><font size="2"><b>Yours sincerely;</b></font></div><font size="2"><b><div style="text-align:left"><br></div><div style="text-align:left">Eng: Ahmed Mohamed Awad</div></b></font><div style="text-align:left"><b>Ph.D student</b></div><div style="text-align:left"><b>Energy Resources Engineering Department(ERE)</b></div><div style="text-align:left"><b>Egypt-Japan University of Science and Technology(EJUST)</b></div><div style="text-align:left"><b>Mob:+2010-65078029</b></div><div style="text-align:left"><strong style="font-size:12.8000001907349px"><font size="2">Email: <font color="#00ffff"><font color="#3d85c6"><font color="#0b5394"><a href="mailto:heba_abadi@hotmail.com" style="color:rgb(17,85,204)" target="_blank">ahmedawadserageldin@gmail.com</a> - </font></font></font></font></strong><strong style="font-size:12.8000001907349px"><font size="2"><font color="#00ffff"><font color="#3d85c6"><font color="#0b5394"><a href="mailto:heba.abbadi@ejust.edu.eg" style="color:rgb(17,85,204)" target="_blank">ahmed.serageldin@ejust.edu.eg</a></font></font></font></font></strong></div><div style="text-align:left"><strong style="font-size:12.8000001907349px"><font size="2">Website: </font></strong><strong style="font-size:12.8000001907349px;color:rgb(17,85,204)"><font size="2"><a href="mailto:heba.abbadi@ejust.edu.eg" style="font-size:12.8000001907349px;color:rgb(17,85,204)" target="_blank">www.ejust.edu.eg</a></font></strong></div><div style="text-align:left"><strong style="color:green;font-family:Webdings;line-height:27px;font-size:12.8000001907349px"><font color="#222222" face="Arial"><font size="2"><font color="#cc0000">P.O. Box 179, New Borg El-Arab City, Postal Code 21934, Alexandria, Egypt</font></font></font></strong></div><div style="text-align:left"><p style="font-size:12.8000001907349px"><span style="color:green;line-height:27px;font-family:Webdings"></span><font size="2"><span style="color:green;line-height:27px;font-family:Webdings">P</span><span style="color:blue;line-height:11px;font-family:Arial,sans-serif"> </span><b><span style="color:green;line-height:12px;font-family:Arial,sans-serif">Please consider the environment and don't print this e-mail unless you really need to.</span></b></font></p></div><div style="text-align:left"><br></div></div></div></div></div></div>
<br><div class="gmail_quote">On Tue, Nov 8, 2016 at 9:42 AM, Amirreza Heidary via TRNSYS-users <span dir="ltr"><<a href="mailto:trnsys-users@lists.onebuilding.org" target="_blank">trnsys-users@lists.onebuilding.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><h4>Dear all</h4><h4> 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: <br></h4><h4>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 , .... ?</h4><h4> 2- after completing the excel file using my equations, How I should link my excel file to type 62?
</h4><p>Thank you<br></p><div><div class="m_-8671936476949909983gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div><div style="text-align:right"><div style="text-align:left"><br></div><div style="text-align:left">------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>--------------------------<br><img src="https://docs.google.com/uc?id=0B56a_joPrCZuYUg5aFkzTlR2dTg&export=download" width="96" height="96"><br></div><div style="text-align:left;font-size:12.8px"><b><font face="georgia, serif">amirrezaheidary</font></b></div><div style="text-align:left;font-size:12.8px"><i><font color="#444444" face="trebuchet ms, sans-serif">master student of energy systems Engineering</font></i></div><div style="text-align:left;font-size:12.8px"><font color="#444444" face="trebuchet ms, sans-serif"><i>Sharif university of technology</i></font></div><div style="text-align:left;font-size:12.8px"><font color="#444444" face="trebuchet ms, sans-serif"><i>Tehran-Iran</i></font></div><div style="text-align:left;font-size:12.8px"><font face="georgia, serif"><i>E-mail address</i></font><font face="comic sans ms, sans-serif">:</font></div><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;font-size:12.8px;border-left:1px solid rgb(204,204,204)"><p style="text-align:left"><font color="#1155cc" face="tahoma, sans-serif"><a href="mailto:heidari@energy.sharif.edu" target="_blank">heidari@energy.sharif.edu</a></font></p></blockquote><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;font-size:12.8px;border-left:1px solid rgb(204,204,204)"><p style="text-align:left"><font style="color:rgb(17,85,204)" face="tahoma, sans-serif"><a style="color:rgb(17,85,204)" href="mailto:sm_mousavi@pwut.ac.ir" target="_blank">a</a><a href="mailto:mirrezaheidarysbu@gmail.com" target="_blank">mirrezaheidarysbu@gmail.com</a></font></p></blockquote><div style="text-align:left"><b style="color:rgb(0,0,0);font-family:"times new roman","new york",times,serif;font-size:small"><span style="color:green;font-family:webdings" lang="EN-GB">P</span></b><i style="color:rgb(0,0,0);font-family:"times new roman","new york",times,serif;font-size:small"><span style="color:navy" lang="EN-GB"> </span></i><b style="color:rgb(0,0,0);font-family:"times new roman","new york",times,serif;font-size:small"><i><span style="color:green" lang="EN-GB">Save a tree... Please don't print this E-mail unless you really need to.</span></i></b><b><font color="#0000ff"><font size="1"> </font></font></b><br></div><br></div><font color="#0000ff"><font size="1"><br></font></font></div><div><font color="#0000ff"><font size="1"><br></font></font><div><div><font color="#0000ff"><font size="1"><br></font></font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
TRNSYS-users mailing list<br>
<a href="mailto:TRNSYS-users@lists.onebuilding.org">TRNSYS-users@lists.<wbr>onebuilding.org</a><br>
<a href="http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org" rel="noreferrer" target="_blank">http://lists.onebuilding.org/<wbr>listinfo.cgi/trnsys-users-<wbr>onebuilding.org</a><br>
<br></blockquote></div><br></div>