<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Hi Marcos Falcon,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>I did some similar things
with solar radiation and shading (overhang and wingwalls). The user is able to
use Excel for the input of the geometry and the selection of the weather data
file. Afterwards the VBA Program modifies a predefined deck file to satisfy the
user input values and starts the simulation. The output data are imported and
evaluated automatically in Excel.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Actually, a lot of ugly
programming in VBA is necessary, but it works. In my opinion it should be much
easier for you, if you use a TRNSED. For this topic look at the documentation “07.
TRNEdit: Editing the Input File and Creating TRNSED Applications”.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Good luck and best
regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Hermann Schranzhofer.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><o:p> </o:p></span></font></p>
<p><font size=2 color=navy face="Times New Roman"><span style='font-size:10.0pt;
color:navy'>_______________________________________________________________<br>
<br>
DI Dr. mont. Hermann Schranzhofer<br>
Institut fuer Waermetechnik / Institute of Thermal Engineering<br>
TU Graz / Graz University of Technology
<br>
Inffeldgasse 25 / B, A-8010 Graz <br>
<br>
Tel.: +43 316 873 7314<br>
Fax : +43 316 873 7305<br>
<a href="http://www.iwt.tugraz.at/">http://www.iwt.tugraz.at/</a><br>
_______________________________________________________________<br>
<br>
</span></font><font color=navy><span style='color:navy'> </span></font><o:p></o:p></p>
</div>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>Von:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Marcos Falcon
[mailto:marcos.falcon@ibersolar.com] <br>
<b><span style='font-weight:bold'>Gesendet:</span></b> Montag, 21. Januar 2008
11:44<br>
<b><span style='font-weight:bold'>An:</span></b> trnsys-users@engr.wisc.edu<br>
<b><span style='font-weight:bold'>Betreff:</span></b> [TRNSYS-users] TRNSYS
interacts with Excel</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoAutoSig style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:0cm'><a name="OLE_LINK1"></a><a name="OLE_LINK2"></a><font
size=2 face=Verdana><span lang=ES style='font-size:10.0pt;font-family:Verdana'>Hello,
good morning. <br>
<br>
</span></font><font size=2 face=Verdana><span lang=EN-GB style='font-size:10.0pt;
font-family:Verdana'>My name is Marcos Falcon, a member of the technical team
IBERSOLAR ENERGIA S.A. in <st1:place w:st="on"><st1:City w:st="on">Barcelona</st1:City>,
<st1:country-region w:st="on">Spain</st1:country-region></st1:place>. <br>
<br>
</span></font><font size=2 face=Verdana><span lang=ES style='font-size:10.0pt;
font-family:Verdana'>We have gained TRNSYS to perform simulations energy with
solar thermal applications. <br>
<br>
I am trying to make an application on TRNSYS that interacts with Excel. <br>
<br>
</span></font><font size=2 face=Verdana><span lang=EN-GB style='font-size:10.0pt;
font-family:Verdana'>Within the application, I want to create a drop-down menu,
where you will get the collector model we have in IBERSOLAR, and according to
the collector chosen, we send some parameters specific collector from the Excel
sheet. </span></font><font size=2 face=Verdana><span lang=ES style='font-size:
10.0pt;font-family:Verdana'>But I find the problem that is not done. <br>
<br>
The route of the information would be as follows: <br>
<br>
Select a collector since TRNSYS. The collector chosen as put in a cell in
particular the Excel sheet. According to the collector chosen, I will prepare
the data collector on the Excel sheet to carry them TRNSYS and take these data
as input parameters for the collector. <br>
<br>
How can I do it? <br>
<br>
<br>
Thank you in advance. <br>
<br>
</span></font><font size=2 face=Verdana><span lang=EN-GB style='font-size:10.0pt;
font-family:Verdana'><o:p></o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=2
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=2
face=Verdana><span lang=ES style='font-size:10.0pt;font-family:Verdana'>Marcos
Falcón</span></font><span lang=ES><o:p></o:p></span></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=2
face=Verdana><span lang=ES style='font-size:10.0pt;font-family:Verdana'>Dpt.
Técnico</span></font><span lang=ES><o:p></o:p></span></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=2
face=Verdana><span lang=ES style='font-size:10.0pt;font-family:Verdana'>FV
Aislada</span></font><span lang=ES><o:p></o:p></span></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=2
face=Verdana><span lang=ES style='font-size:10.0pt;font-family:Verdana'>IBERSOLAR
Energía S.A.<o:p></o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=2
face=Verdana><span lang=ES style='font-size:10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=2
face=Arial><span lang=ES style='font-size:10.0pt;font-family:Arial'><img
border=0 width=227 height=45 id="_x0000_i1025"
src="cid:image001.jpg@01C85C32.B724C6A0"></span></font><span lang=ES><o:p></o:p></span></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Arial><span lang=ES style='font-size:9.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:9.0pt;font-family:Verdana'>T. +34
936 350 440<o:p></o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:9.0pt;font-family:Verdana'>F. +34
936 654 510<o:p></o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:9.0pt;font-family:Verdana'>E. </span></font><span
lang=ES><a href="mailto:marcos.falcon@ibersolar.com"><font size=1 face=Verdana><span
style='font-size:9.0pt;font-family:Verdana'>marcos.falcon@ibersolar.com</span></font></a></span><font
size=1 face=Verdana><span lang=ES style='font-size:9.0pt;font-family:Verdana'> <o:p></o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=EN-GB style='font-size:9.0pt;font-family:Verdana'>W. </span></font><span
lang=ES><a href="http://www.ibersolar.com/"><font size=1 face=Verdana><span
lang=EN-GB style='font-size:9.0pt;font-family:Verdana'>www.ibersolar.com</span></font></a></span><font
size=1 face=Verdana><span lang=EN-GB style='font-size:9.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=2
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=1
face=Verdana><span lang=EN-GB style='font-size:8.0pt;font-family:Verdana'>Pol.</span></font></st1:City><font
size=1 face=Verdana><span lang=EN-GB style='font-size:8.0pt;font-family:Verdana'>
<st1:State w:st="on">Ind.</st1:State></span></font></st1:place><font size=1
face=Verdana><span lang=EN-GB style='font-size:8.0pt;font-family:Verdana'> </span></font><font
size=1 face=Verdana><span lang=ES style='font-size:8.0pt;font-family:Verdana'>Cami
Ral, C/ Isaac Peral 13 Nave 9, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 face=Verdana><span lang=ES style='font-size:
8.0pt;font-family:Verdana'>08850 Gavà (Barcelona), Spain<o:p></o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:7.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><b><i><font
size=1 face=Verdana><span lang=ES style='font-size:7.0pt;font-family:Verdana;
font-weight:bold;font-style:italic'>Antes de imprimir este mensaje, asegúrase
de que es necesario. El medio ambiente está en nuestra mano.<o:p></o:p></span></font></i></b></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:7.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:7.0pt;font-family:Verdana'>El
contenido de este mensaje, incluidos los ficheros que pudiera llevar anexos,
puede contener información confidencial y está estrictamente reservado a las
personas a las que va dirigido. Si usted lo ha recibido por error, le rogamos
lo borre completamente de su sistema (incluidas posibles copias), lo notifique
al remitente, y se abstenga de usar, difundir o copiar ninguna de las partes
del mismo. <o:p></o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=ES style='font-size:7.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig style='margin:0cm;margin-bottom:.0001pt'><font size=1
face=Verdana><span lang=EN-GB style='font-size:7.0pt;font-family:Verdana'>This
e-mail may contain confidential and/or privileged information. If you are not
the intended recipient (or have received this e-mail in error) please notify
the sender immediately and destroy it.. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=1 face=Verdana><span lang=EN-GB
style='font-size:8.0pt;font-family:Verdana'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
</div>
</body>
</html>