[gradsusr] Extract values from all grid points in a domain

[Lyndon Mark Olaguera]

Ah, that's pretty easy..
Here's what you should do.
1. Open an empty Excel Worksheet
2. On the menu bar, click Data
3.There are three options to import the data from the csv file (ouput of
grads)
     a. From Access
     b.From Web
     c.From Text
You can see these from the leftmost side of the menu bar
4. click "From text"
5. Import the csv file
6.Select the location where you want to display it
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.




*Lyndon Mark P. Olaguera*
Assistant Instructor
Ateneo de Manila University
426 6001
loc 5695

On Wed, Dec 17, 2014 at 7:28 PM, PHILBERT LUHUNGA <philuhunga at yahoo.com>
wrote:
>
> 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
>
> AS EVER
> LUHUNGA
>
> --------------------
> Philbert Modest Luhunga
> University of Pretoria
> Department of Geography,Geoinformatics and Meteorology
> Private Bag X20 Hatfield 0028 South Africa
> Tel +27 (0) 12 420 5164
> Fax +27 (0) 12 420 6385
> Mobile:+ 27826228060
> Email address: philuhunga at yahoo.com
>
>   ------------------------------
>  *From:* Lyndon Mark Olaguera <olagueralyndonmark429 at gmail.com>
> *To:* GrADS Users Forum <gradsusr at gradsusr.org>
> *Sent:* Tuesday, December 16, 2014 10:01 AM
> *Subject:* Re: [gradsusr] Extract values from all grid points in a domain
>
> Hi,
>
> It is possible to output it in one column.
> Try using the following command.
> 'fprintf.gs [variable to be extracted][you can add a date string
> here].csv%g 0'
>
> In my case, I read a txtfile containing the names of the stations and the
> grads script read the txt file line by line.
> So the output of the fprintf.gs 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.
>
> Example:
> 'fprintf.gs rainc+rainnc hourlyrain_5days/Thompson/'stn'_WSM6.csv %g 0'
>
> *Lyndon Mark P. Olaguera*
> Assistant Instructor
> Ateneo de Manila University
> 426 6001
> loc 5695
>
> On Mon, Dec 15, 2014 at 6:04 PM, PHILBERT LUHUNGA <philuhunga at yahoo.com>
> wrote:
>
>
>
> Hi thank you very much, if fprintf.gs,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........
> 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
>
>
> ------------------------------
> On Sun, Dec 14, 2014 4:34 PM PST Lyndon Mark Olaguera wrote:
>
> >Hello,
> >I did not print the time variable. If you know the time step of your data
> >as well as the starting and end times, you can manually put the time
> >variable in the output of the fprintf.gs.
> >
> >
> >*Lyndon Mark P. Olaguera*
> >Assistant Instructor
> >Ateneo de Manila University
> >426 6001
> >loc 5695
> >
> >On Sun, Dec 14, 2014 at 4:32 AM, PHILBERT LUHUNGA <philuhunga at yahoo.com>
> >wrote:
> >>
> >>
> >>
> >> hi Lyndon did you manage to fprintf.gs time variable?? , how did you
> do it
> >>
> >>
> >> ------------------------------
> >> On Fri, Dec 12, 2014 8:20 PM PST Lyndon Mark Olaguera wrote:
> >>
> >> >Hi All,
> >> >
> >> >I'd like to extract data values from all the gridpoints in a domain.
> How
> >> >can I do this in GRADS?
> >> >Before I used the fprintf.gs to extrac values from specific
> gridpoints.
> >> >Any suggestion?
> >> >
> >> >
> >> >
> >> >*Lyndon*
> >>
> >> _______________________________________________
> >> gradsusr mailing list
> >> gradsusr at gradsusr.org
> >> http://gradsusr.org/mailman/listinfo/gradsusr
>
>
>
> >>
>
> _______________________________________________
> gradsusr mailing list
> gradsusr at gradsusr.org
> http://gradsusr.org/mailman/listinfo/gradsusr
>
>
> _______________________________________________
> gradsusr mailing list
> gradsusr at gradsusr.org
> http://gradsusr.org/mailman/listinfo/gradsusr
>
>
>
> _______________________________________________
> gradsusr mailing list
> gradsusr at gradsusr.org
> http://gradsusr.org/mailman/listinfo/gradsusr
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20141218/fa1966fb/attachment.html