<div dir="ltr">Ah, that's pretty easy..<div style>Here's what you should do.</div><div style>1. Open an empty Excel Worksheet</div><div style>2. On the menu bar, click Data</div><div style>3.There are three options to import the data from the csv file (ouput of grads)</div><div style> a. From Access</div><div style> b.From Web</div><div style> c.From Text</div><div style>You can see these from the leftmost side of the menu bar</div><div style>4. click "From text"</div><div style>5. Import the csv file </div><div style>6.Select the location where you want to display it</div><div style>7.To view other files, you can click the "Refresh All" and import the next file so you dont have to delete the previous imported values.</div><div style><br></div><div style><br></div><div style><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><font face="comic sans ms, sans-serif"><i><b><u>Lyndon Mark P. Olaguera</u></b></i></font><div><font face="comic sans ms, sans-serif">Assistant Instructor</font></div><div><font face="comic sans ms, sans-serif">Ateneo de Manila University</font></div><div><font face="comic sans ms, sans-serif">426 6001</font></div><div><font face="comic sans ms, sans-serif">loc 5695</font></div></div></div></div>
<br><div class="gmail_quote">On Wed, Dec 17, 2014 at 7:28 PM, PHILBERT LUHUNGA <span dir="ltr"><<a href="mailto:philuhunga@yahoo.com" target="_blank">philuhunga@yahoo.com</a>></span> wrote:<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="color:#000;background-color:#fff;font-family:garamond,new york,times,serif;font-size:16px"><div><span></span></div><div></div><div dir="ltr">Thank you very much, I know my problem, the problem I am facing is to import space delimited data into single column in excel. I think I need to find out how to overcome this problem. I did as you instructed but still when I open in excel I get many columns</div><div dir="ltr"><br></div><div><div>AS EVER
<br>LUHUNGA
<br>
<br>--------------------
<br>Philbert Modest Luhunga
<br>University of Pretoria
<br>Department of Geography,Geoinformatics and Meteorology
<br>Private Bag X20 Hatfield 0028 South Africa
<br>Tel <a value="+27124205164">+27 (0) 12 420 5164</a>
<br>Fax <a value="+27124206385">+27 (0) 12 420 6385</a>
<br>Mobile:<a value="+27826228060">+ 27826228060</a>
<br>Email address: <a href="mailto:philuhunga@yahoo.com">philuhunga@yahoo.com</a></div></div><br> <div style="font-family:garamond,new york,times,serif;font-size:16px"> <div style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:16px"> <div dir="ltr"> <hr size="1"> <font face="Arial"> <b><span style="font-weight:bold">From:</span></b> Lyndon Mark Olaguera <<a href="mailto:olagueralyndonmark429@gmail.com">olagueralyndonmark429@gmail.com</a>><br> <b><span style="font-weight:bold">To:</span></b> GrADS Users Forum <<a href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a>> <br> <b><span style="font-weight:bold">Sent:</span></b> Tuesday, December 16, 2014 10:01 AM<br> <b><span style="font-weight:bold">Subject:</span></b> Re: [gradsusr] Extract values from all grid points in a domain<br> </font> </div><div><div class="h5"> <div><br><div><div><div dir="ltr">Hi,<div><br clear="none"></div><div>It is possible to output it in one column.</div><div>Try using the following command.</div><div>'<a rel="nofollow" shape="rect">fprintf.gs</a> [variable to be extracted][you can add a date string here].csv%g 0'</div><div><br clear="none"></div><div>In my case, I read a txtfile containing the names of the stations and the grads script read the txt file line by line.</div><div>So the output of the <a rel="nofollow" shape="rect">fprintf.gs</a> will have the station name (look at the example belew: 'stn'). You can also use a datestring if you want to separate the outputs per day or per month etc.</div><div><br clear="none"></div><div>Example:</div><div>'<a rel="nofollow" shape="rect">fprintf.gs</a> rainc+rainnc hourlyrain_5days/Thompson/'stn'_WSM6.csv %g 0'<br clear="none"></div></div><div><br clear="all"><div><div><div dir="ltr"><font face="comic sans ms, sans-serif"><i><b><u>Lyndon Mark P. Olaguera</u></b></i></font><div><font face="comic sans ms, sans-serif">Assistant Instructor</font></div><div><font face="comic sans ms, sans-serif">Ateneo de Manila University</font></div><div><font face="comic sans ms, sans-serif">426 6001</font></div><div><font face="comic sans ms, sans-serif">loc 5695</font></div></div></div></div>
<br clear="none"><div>On Mon, Dec 15, 2014 at 6:04 PM, PHILBERT LUHUNGA <span dir="ltr"><<a rel="nofollow" shape="rect">philuhunga@yahoo.com</a>></span> wrote:<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"><br clear="none">
<br clear="none">
Hi thank you very much, if <a rel="nofollow" shape="rect">fprintf.gs</a>,prec prec.txt, I get text file, when this file opened in excel, it open in several column, say column A, B,C, D, E, F, G, H........<br clear="none">
so to make it one column I cut all other column and paste on column A, is it fine to do this or do you know any method when I fprintf. Variable I can get file when opened in excel open in one column??. Thank you for your help<br clear="none">
<br clear="none">
<br clear="none">
------------------------------<br clear="none">
<span>On Sun, Dec 14, 2014 4:34 PM PST Lyndon Mark Olaguera wrote:<br clear="none">
<br clear="none">
>Hello,<br clear="none">
>I did not print the time variable. If you know the time step of your data<br clear="none">
>as well as the starting and end times, you can manually put the time<br clear="none">
>variable in the output of the <a rel="nofollow" shape="rect">fprintf.gs</a>.<br clear="none">
><br clear="none">
><br clear="none">
</span>>*Lyndon Mark P. Olaguera*<br clear="none">
<div><div>>Assistant Instructor<br clear="none">
>Ateneo de Manila University<br clear="none">
>426 6001<br clear="none">
>loc 5695<br clear="none">
><br clear="none">
>On Sun, Dec 14, 2014 at 4:32 AM, PHILBERT LUHUNGA <<a rel="nofollow" shape="rect">philuhunga@yahoo.com</a>><br clear="none">
>wrote:<br clear="none">
>><br clear="none">
>><br clear="none">
>><br clear="none">
>> hi Lyndon did you manage to <a rel="nofollow" shape="rect">fprintf.gs</a> time variable?? , how did you do it<br clear="none">
>><br clear="none">
>><br clear="none">
>> ------------------------------<br clear="none">
>> On Fri, Dec 12, 2014 8:20 PM PST Lyndon Mark Olaguera wrote:<br clear="none">
>><br clear="none">
>> >Hi All,<br clear="none">
>> ><br clear="none">
>> >I'd like to extract data values from all the gridpoints in a domain. How<br clear="none">
>> >can I do this in GRADS?<br clear="none">
>> >Before I used the <a rel="nofollow" shape="rect">fprintf.gs</a> to extrac values from specific gridpoints.<br clear="none">
>> >Any suggestion?<br clear="none">
>> ><br clear="none">
>> ><br clear="none">
>> ><br clear="none">
>> >*Lyndon*<br clear="none">
>><br clear="none">
>> _______________________________________________<br clear="none">
>> gradsusr mailing list<br clear="none">
>> <a rel="nofollow" shape="rect">gradsusr@gradsusr.org</a><br clear="none">
>> <a rel="nofollow" shape="rect">http://gradsusr.org/mailman/listinfo/gradsusr</a><div><br><br></div><div><br clear="none">
>><br clear="none">
<br clear="none">
_______________________________________________<br clear="none">
gradsusr mailing list<br clear="none">
<a rel="nofollow" shape="rect">gradsusr@gradsusr.org</a><br clear="none">
<a rel="nofollow" shape="rect">http://gradsusr.org/mailman/listinfo/gradsusr</a><br clear="none">
</div></div></div></blockquote></div></div></div></div><br><div>_______________________________________________<br clear="none">gradsusr mailing list<br clear="none"><a shape="rect">gradsusr@gradsusr.org</a><br clear="none"><a shape="rect">http://gradsusr.org/mailman/listinfo/gradsusr</a><br clear="none"></div><br><br></div> </div></div></div> </div> </div></div><br>_______________________________________________<br>
gradsusr mailing list<br>
<a href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a><br>
<a href="http://gradsusr.org/mailman/listinfo/gradsusr">http://gradsusr.org/mailman/listinfo/gradsusr</a><br>
<br></blockquote></div></div>