<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV></DIV>
<DIV>On Thu, Jul 10, 2008 at 8:49 AM, wilfredo burgoa <<A href="mailto:anwibuma@yahoo.com" target=_blank rel=nofollow ymailto="mailto:anwibuma@yahoo.com">anwibuma@yahoo.com</A>> wrote:<BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV class=gmail_quote>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<P>Dear Arlindo,</P>
<P> Please, with the option Set gxout fwrite manages to extract data in binary (GrADS) and now would want to turn those data to a format for example to be visualized in a spreadsheet (Excel).</P></TD></TR></TBODY></TABLE></BLOCKQUOTE>
<DIV><BR></DIV>
<DIV>Off hand the only thing I think of right now is to write a program to convert this binary file into ASCII. In this case, skip the fwrite altogether and use "set gxout print" to create ASCII directly from GrADS; look at the user guide for instructions.</DIV>
<DIV><BR></DIV>
<DIV>If you are an experienced C programmer, another possibility is look for a C library that writes in Excel binary format and write a conversion utility. This can also be done in Python using PyGrADS and the python excel tools. However, I've never done it myself (I do not use excel).</DIV>
<DIV><BR></DIV>
<DIV> <FONT color=#0000bf>Hello Wilfred,</FONT></DIV>
<DIV><FONT color=#0000bf></FONT> </DIV>
<DIV><FONT color=#0000bf>Arlindo is right with both options.However,the first option is the simplest and the second option is not necessary for your case. You can write FORTRAN program to convert your binary file into ASCII then open the excel worksheet and load the ASCII file. Text imort wizard will appear,choose the file type that best describe your data,set the delimiters your data contains and finally set column data format. Otherwise if you use the "set gxout print" to create ASCII directly from GrADS then you can copy and paste the data into excell worksheet. In short,excel supports ASCII fomart.</FONT></DIV>
<DIV><FONT color=#0000bf></FONT> </DIV>
<DIV><FONT color=#0000bf>I hope that helps</FONT></DIV>
<DIV><FONT color=#0000bf></FONT> </DIV>
<DIV><FONT color=#0000bf>Mashingia</FONT></DIV></DIV></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV>------------------------------------------------------</DIV>
<DIV><FONT color=#0000ff>MASHINGIA, Fredrick A. J. <BR><EM>B.Sc., M.Sc. Eng.</EM> (UDSM) </FONT></DIV>
<DIV><FONT color=#0000ff>Republic Of Tanzania. <BR>Phone: <?XML:NAMESPACE PREFIX = SKYPE /><SKYPE:SPAN onmouseup="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');return skype_tb_stopEvents();" class=skype_tb_injection onmousedown="javascript:skype_tb_imgOnOff(this,2,'0',true,16,'');return skype_tb_stopEvents();" id=softomate_highlight_0 onmouseover="javascript:skype_tb_imgOnOff(this,1,'0',true,16,'');" title="Call this phone number in Tanzania with Skype: +255713619561" onclick="javascript:skype_tb_doRunCMD('call','0',null,0);return skype_tb_stopEvents();" onmouseout="javascript:skype_tb_imgOnOff(this,0,'0',true,16,'');" durex="0" context="+255 713 619 561" IamRTL="0"><SKYPE:SPAN onmouseup="javascript:doSkypeFlag(this,'0',1,1,16);return skype_tb_stopEvents();" class=skype_tb_imgA onmousedown="javascript:doSkypeFlag(this,'0',2,1,16);return skype_tb_stopEvents();" id=skype_tb_droppart_0 onmouseover="javascript:doSkypeFlag(this,'0',1,1,16);"
title="Skype actions" style="BACKGROUND-IMAGE: url(file://C:/Users/Eng.Faj/AppData/Local/Temp/Low/__SkypeIEToolbar_Cache/e70d95847a8f5723cfca6b3fd9946506/static/inactive_a.compat.flex.w16.gif)" onclick="javascript:skype_tb_SwitchDrop(this,'0','sms=1');return skype_tb_stopEvents();" onmouseout="javascript:doSkypeFlag(this,'0',0,1,16);"><SKYPE:SPAN class=skype_tb_imgFlag id=skype_tb_img_f0 style="BACKGROUND-IMAGE: url(file://C:/Users/Eng.Faj/AppData/Local/Temp/Low/__SkypeIEToolbar_Cache/e70d95847a8f5723cfca6b3fd9946506/static/famfamfam/TZ.gif)"></SKYPE:SPAN></SKYPE:SPAN><SKYPE:SPAN class=skype_tb_imgS id=skype_tb_img_s0></SKYPE:SPAN><SKYPE:SPAN class=skype_tb_injectionIn id=skype_tb_text0><SKYPE:SPAN class=skype_tb_innerText id=skype_tb_innerText0> +255 713 619 561 </SKYPE:SPAN></SKYPE:SPAN><SKYPE:SPAN class=skype_tb_imgR id=skype_tb_img_r0></SKYPE:SPAN></SKYPE:SPAN> <BR>E-mail: fmashingia@yahoo.com <BR><FONT
color=#000000>------------------------------------------------------</FONT><BR></FONT></DIV></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV></DIV></div><br>
</body></html>