<div>Numan,</div><div> </div><div>in excel do a CTRL A (select all) and use a right mouse click to go to 'format cell' and opt for number.</div><div>That should solve it</div><div> </div><div>Also, check the settings of your printer (I assume you have one in your model, if not: go to 'output' select 'printer' and pick one out), . in the parameter tab of your printer, you can select the delimiter and stuff ... <br>
</div><div>leen<br></div><div class="gmail_quote">On Tue, Apr 17, 2012 at 10:41 AM, Numan Kaya <span dir="ltr"><<a href="mailto:numankaya001@hotmail.com">numankaya001@hotmail.com</a>></span> wrote:<br><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
<div><div dir="ltr">
Hello,<div><br></div><div>I have simulated a wind energy production prediction system in TRNSYS. I can see hourly energy production amounts in graphic. I need <span style="font-size:10pt"> </span><span style="font-size:10pt">numerical</span><span style="font-size:10pt"> </span><span style="font-size:10pt">total <span>lannual</span> energy production amount, mean energy production values. If <span>i</span> open <span>outfile text file</span> after simulation (calculate-open-external files<span>,</span>xxx.dat), the results are there shown as XXXX</span><span style="font-size:10pt"> +E0x (<span>exmp</span>. </span><span style="color:rgb(34,34,34);line-height:16px;font-family:arial,sans-serif;font-size:10pt">2.21064</span><em style="line-height:16px;font-family:arial,sans-serif;font-size:small;font-style:normal;font-weight:bold">E</em><span style="color:rgb(34,34,34);line-height:16px;font-family:arial,sans-serif;font-size:10pt">+</span><em style="line-height:16px;font-family:arial,sans-serif;font-size:small;font-style:normal;font-weight:bold">05,1.23</em><span style="color:rgb(34,34,34);line-height:16px;font-family:arial,sans-serif;font-size:10pt">064</span><em style="line-height:16px;font-family:arial,sans-serif;font-size:small;font-style:normal;font-weight:bold">E<font color="#222222">+04) so <span>i</span> can't <span>coppy</span> them to excel too. How can <span>i</span> make it to show results as normal numbers </font></em><em style="line-height:16px;font-family:arial,sans-serif;font-size:small;font-style:normal;font-weight:bold"><font color="#222222">(<span>examp</span>. 22222.235, 56456465465,89</font></em><span style="font-size:10pt"> )</span><em style="line-height:16px;font-family:arial,sans-serif;font-size:small;font-style:normal;font-weight:bold"><font color="#222222"> without +-EX . And is there any other way to transfer results to excel?.</font></em></div>
<div><em style="line-height:16px;font-family:arial,sans-serif;font-size:small;font-style:normal;font-weight:bold"><font color="#222222"><br></font></em></div><div><em style="line-height:16px;font-family:arial,sans-serif;font-size:small;font-style:normal;font-weight:bold"><font color="#222222">Regards.</font></em></div>
</div></div>
<br>_______________________________________________<br>
TRNSYS-users mailing list<br>
<a href="mailto:TRNSYS-users@cae.wisc.edu">TRNSYS-users@cae.wisc.edu</a><br>
<a href="https://mailman.cae.wisc.edu/listinfo/trnsys-users" target="_blank">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a><br>
<br></blockquote></div><br>