[TRNSYS-users] Output-format for Type65c and Type25f

[Adrien JEZEQUEL - ITF]

Dear Igor,

You may use Type 25c (Printer - Unformatted - No Units) and define 
output file directly with xls extension. EXCEL file will be created with 
output data you want to observe.

To deal with your current data text file :

 1. open EXCEL,
 2. open your text file with EXCEL (File/Open/select all files extension)
 3. the Convert Text to Columns Wizardis then launched to convert your
    data in columns with desired separated caracters.


You can dot it directly in EXCEL :

 1. Select cells that contain the text-formatted times
 2. Choose "Text to Columns" from the Data menu. (In Excel 2007, select
    "Text to Columns" from the "Data" tab of the ribbon.) Excel launches
    the Convert Text to Columns Wizard
 3. Your data will then be converted

Best regards
------------------------------------------------------------------------
Je serai absent du 1er au 28 Août 2011
www.itf.biz <http://www.itf.biz>
www.itf.biz <http://www.itf.biz>

	Adrien JEZEQUEL
Simulations Thermiques Dynamiques
*ITF*
	62, Rue du Bolliet
73230 St Alban Leysse
FRANCE
Phone :
Fax :
Mail:
	+33(0) 479 750 029
+33(0) 479 852 122
a.jezequel at itf.biz ou aj at itf.biz

/Afin de contribuer au respect de l'environnement, merci de n'imprimer 
cet e-mail que si nécessaire
Please, consider our environmental responsability before printing this email
/

Le 21/07/2011 12:23, Igor Grujic a écrit :
> Dear TRNSYS-users,
>
> Two Questions about the output format of Type65c and Type25f
>
> Type25f:
> Does anybody know how to delimit two columns with a tab?
> I have to print 14 values in 1hr-steps, some like this
>
> TIME	X1	X2	X3	…	X14
> 1	14.0	12.47	24.14	…	47.27
>
> I tried Type 25f and set the „delimiter to 0”.
> I set the format in Special Card to:
> F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X
> ,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2
>
> The problem is that in the .txt-file the columns are separated with spaces instead of tabs.
> When I try to copy it to a .xls-file, excel don’t recognized the singly columns and wrote it in one line, for example:
> Excel cell A1: 1   14.0   12.47   24.14   ….   47.27
> The Cells B2 (where I want to have the X2-items) or C2 and so on are all empty.
>
> Does someone have I idea?
>
> Type65c:
> Is it possible to change the output-format, for example instead of "7.9536548752145686E+01" to "79,54"??
>
> Thanks in advance
>
> Kind regards,
> Igor
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20110721/d83bc6dc/attachment-0005.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logo_itf_2010.jpg
Type: image/jpeg
Size: 17526 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20110721/d83bc6dc/attachment-0005.jpg>