<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Thank you all for the suggestions...</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span></span><span>I am going through it..<br></span></div><div> </div><div>----------------------------------------------------------------------------------------------------------------------------------------------------------------</div><div><span style="font-weight:bold;font-size:13px;">SUSHANT DAS,</span></div><div><span style="font-weight:bold;font-size:small;">CSIR Research Fellow,</span></div><div><span style="font-weight:bold;font-size:small;">Centre for Atmospheric Sciences,Block VI</span></div><div><span style="font-weight:bold;font-size:small;">Indian Institute of Technology,
Delhi</span></div><div><span style="font-weight:bold;font-size:small;">New Delhi-110016,</span></div><div><span style="font-weight:bold;font-size:small;">INDIA</span></div><div>----------------------------------------------------------------------------------------------------------------------------------------------------------------</div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> "gradsusr-request@gradsusr.org" <gradsusr-request@gradsusr.org><br> <b><span style="font-weight: bold;">To:</span></b> gradsusr@gradsusr.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Sunday, August 4, 2013 9:30 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> gradsusr Digest, Vol 42,
Issue 4<br> </font> </div> <div class="y_msg_container"><br>Send gradsusr mailing list submissions to<br> <a ymailto="mailto:gradsusr@gradsusr.org" href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://gradsusr.org/mailman/listinfo/gradsusr" target="_blank">http://gradsusr.org/mailman/listinfo/gradsusr</a><br>or, via email, send a message with subject or body 'help' to<br> <a ymailto="mailto:gradsusr-request@gradsusr.org" href="mailto:gradsusr-request@gradsusr.org">gradsusr-request@gradsusr.org</a><br><br>You can reach the person managing the list at<br> <a ymailto="mailto:gradsusr-owner@gradsusr.org" href="mailto:gradsusr-owner@gradsusr.org">gradsusr-owner@gradsusr.org</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of gradsusr
digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Gradstoexcel (Stephen McMillan)<br> 2. Re: Gradstoexcel (Rupak Rajbhandari)<br> 3. Re: Gradstoexcel (Jayakrishnan P.R)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Sat, 3 Aug 2013 14:03:25 -0400<br>From: Stephen McMillan <<a ymailto="mailto:smcmillan@planalytics.com" href="mailto:smcmillan@planalytics.com">smcmillan@planalytics.com</a>><br>Subject: Re: [gradsusr] Gradstoexcel<br>To: Sushant Das <<a ymailto="mailto:sushant_models@yahoo.com" href="mailto:sushant_models@yahoo.com">sushant_models@yahoo.com</a>>, GrADS Users Forum<br> <<a ymailto="mailto:gradsusr@gradsusr.org" href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a>><br>Message-ID:<br> <CA+<a ymailto="mailto:exxN3Jt6ga9Z8bOKwtJHT4xEwijiGjzhUNjOYV6sA4jtOpUQ@mail.gmail.com"
href="mailto:exxN3Jt6ga9Z8bOKwtJHT4xEwijiGjzhUNjOYV6sA4jtOpUQ@mail.gmail.com">exxN3Jt6ga9Z8bOKwtJHT4xEwijiGjzhUNjOYV6sA4jtOpUQ@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Sushant,<br><br>You might find useful this "cookbook" document on opengrads.org:<br><a href="http://cookbooks.opengrads.org/index.php?title=Recipe-002:_Saving_GrADS_variable_data_to_a_text_file" target="_blank">http://cookbooks.opengrads.org/index.php?title=Recipe-002:_Saving_GrADS_variable_data_to_a_text_file</a><br><br>In it, there is a section on writing data to CSV files suitable for import<br>into Excel. Hope this helps.<br><br>Stephen McMillan<br><br><br>On Sat, Aug 3, 2013 at 11:01 AM, Sushant Das <<a ymailto="mailto:sushant_models@yahoo.com" href="mailto:sushant_models@yahoo.com">sushant_models@yahoo.com</a>>wrote:<br><br>><br>> Dear GrADS Users,<br>><br>> I need to know how to extract data from .nc format and write it
in excel<br>> gridded format file?<br>> For eg.<br>> I have a netcdf file consisting of 180 by 360 data. Now i have to extract<br>> for the Indian domain say 60-100E and 5-40N<br>> so total grids would would be 40*35.<br>> After extracting the data it has to be written in excel sheet having<br>> format with varying lat in y axis and varying lon in x axis containing<br>> 40*35 data cells.<br>><br>> Thanks in advance,<br>><br>> Regards,<br>><br>> ----------------------------------------------------------------------------------------------------------------------------------------------------------------<br>> SUSHANT DAS,<br>> CSIR Research Fellow,<br>> Centre for Atmospheric Sciences,Block VI<br>> Indian Institute of Technology, Delhi<br>> New Delhi-110016,<br>> INDIA<br>><br>>
----------------------------------------------------------------------------------------------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> gradsusr mailing list<br>> <a ymailto="mailto:gradsusr@gradsusr.org" href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a><br>> <a href="http://gradsusr.org/mailman/listinfo/gradsusr" target="_blank">http://gradsusr.org/mailman/listinfo/gradsusr</a><br>><br>><br><br>***************************************************<br>The information contained in this e-mail message is intended only for the use of the recipient(s) named above and may contain information that is privileged, confidential, and/or proprietary. <br><br>If you are not the intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the sender immediately by e-mail,
and delete the original message.<br>***************************************************<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://gradsusr.org/pipermail/gradsusr/attachments/20130803/9bea3661/attachment-0001.html" target="_blank">http://gradsusr.org/pipermail/gradsusr/attachments/20130803/9bea3661/attachment-0001.html </a><br><br>------------------------------<br><br>Message: 2<br>Date: Sun, 4 Aug 2013 07:54:00 +0545<br>From: Rupak Rajbhandari <<a ymailto="mailto:rupak.rajbhandari@gmail.com" href="mailto:rupak.rajbhandari@gmail.com">rupak.rajbhandari@gmail.com</a>><br>Subject: Re: [gradsusr] Gradstoexcel<br>To: Sushant Das <<a ymailto="mailto:sushant_models@yahoo.com" href="mailto:sushant_models@yahoo.com">sushant_models@yahoo.com</a>>, GrADS Users Forum<br> <<a ymailto="mailto:gradsusr@gradsusr.org"
href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a>><br>Message-ID:<br> <CAPUBxUQSyEFV2sP=yGuRAbpkRSZi13s2fX9iP+E=<a ymailto="mailto:TLaNoFVPTA@mail.gmail.com" href="mailto:TLaNoFVPTA@mail.gmail.com">TLaNoFVPTA@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Hi,<br><br>Attached is the GrADS script which extract information from 360x180 per<br>record file (exactly your file size) and writes ASCII file which you can<br>import into excel very easily.<br><br>In the file "ifp" is the input file path where your .nc file is located.<br>"ofp" is the output file path where you want to put the newly written ASCII<br>file.<br>The script writes variable 'tmin' (minimum temperature) and creates a daily<br>file. The naming convention is "tminYYYYDDMM.dat"<br><br>Edit x1 and x2 to 60 & 100 and y1, y2 to 5 & 40, ncol=41 (in your case).<br>My nc file is "tmin_daily_1965-1965.nc"<br>I have replaced
1965 or whatever year it is by variable "i' through the<br>script.<br><br>In short, "fprintf" function does what you are looking for. All you have to<br>do is manage accordingly to your needs.<br><br>Hope the script solves your problem and useful to you.<br><br>-rupak<br><br>++++++++++++++++++++++++++++++++++<br>Rupak Rajbhandari<br>Department of Meteorology<br>TriChandra College<br>Kathmandu<br><br><br><br><br><br>On Sat, Aug 3, 2013 at 8:46 PM, Sushant Das <<a ymailto="mailto:sushant_models@yahoo.com" href="mailto:sushant_models@yahoo.com">sushant_models@yahoo.com</a>>wrote:<br><br>><br>> Dear GrADS Users,<br>><br>> I need to know how to extract data from .nc format and write it in excel<br>> gridded format file?<br>> For eg.<br>> I have a netcdf file consisting of 180 by 360 data. Now i have to extract<br>> for the Indian domain say 60-100E and 5-40N<br>> so total grids would would be 40*35.<br>> After extracting
the data it has to be written in excel sheet having<br>> format with varying lat in y axis and varying lon in x axis containing<br>> 40*35 data cells.<br>><br>> Thanks in advance,<br>><br>> Regards,<br>><br>> ----------------------------------------------------------------------------------------------------------------------------------------------------------------<br>> SUSHANT DAS,<br>> CSIR Research Fellow,<br>> Centre for Atmospheric Sciences,Block VI<br>> Indian Institute of Technology, Delhi<br>> New Delhi-110016,<br>> INDIA<br>><br>> ----------------------------------------------------------------------------------------------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> gradsusr mailing list<br>> <a ymailto="mailto:gradsusr@gradsusr.org"
href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a><br>> <a href="http://gradsusr.org/mailman/listinfo/gradsusr" target="_blank">http://gradsusr.org/mailman/listinfo/gradsusr</a><br>><br>><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://gradsusr.org/pipermail/gradsusr/attachments/20130804/ac52eda3/attachment-0001.html" target="_blank">http://gradsusr.org/pipermail/gradsusr/attachments/20130804/ac52eda3/attachment-0001.html </a><br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: nc2ascDD.gs<br>Type: application/octet-stream<br>Size: 1238 bytes<br>Desc: not available<br>Url : <a href="http://gradsusr.org/pipermail/gradsusr/attachments/20130804/ac52eda3/attachment-0001.obj" target="_blank">http://gradsusr.org/pipermail/gradsusr/attachments/20130804/ac52eda3/attachment-0001.obj </a><br><br>------------------------------<br><br>Message:
3<br>Date: Sun, 4 Aug 2013 20:40:59 +0530<br>From: "Jayakrishnan P.R" <<a ymailto="mailto:prjayakrishnan@gmail.com" href="mailto:prjayakrishnan@gmail.com">prjayakrishnan@gmail.com</a>><br>Subject: Re: [gradsusr] Gradstoexcel<br>To: Sushant Das <<a ymailto="mailto:sushant_models@yahoo.com" href="mailto:sushant_models@yahoo.com">sushant_models@yahoo.com</a>>, GrADS Users Forum<br> <<a ymailto="mailto:gradsusr@gradsusr.org" href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a>><br>Message-ID:<br> <CA+P5ZEGzvhQBnfUO-V78d0y1crgV6rch2KVdBtk=<a ymailto="mailto:hROTiANEkQ@mail.gmail.com" href="mailto:hROTiANEkQ@mail.gmail.com">hROTiANEkQ@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Use the commands fwrite or subwrd.<br><br>-- <br>Sincerely<br>***********************************************<br>Jayakrishnan.P.R<br>Teaching Associate (Atmospheric
Science)<br>Academy of Climate Change Education and Research<br>Kerala Agricultural University<br>Vellanikkara-680 656<br><br>and also<br><br>Research Fellow (Part Time)<br>Department of Atmospheric Sciences<br>CUSAT, Cochin-682 016<br>Kerala, India.<br>Mob: 09496026547<br><br>***********************************************<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://gradsusr.org/pipermail/gradsusr/attachments/20130804/5a0e2663/attachment-0001.html" target="_blank">http://gradsusr.org/pipermail/gradsusr/attachments/20130804/5a0e2663/attachment-0001.html </a><br><br>------------------------------<br><br>_______________________________________________<br>gradsusr mailing list<br><a ymailto="mailto:gradsusr@gradsusr.org" href="mailto:gradsusr@gradsusr.org">gradsusr@gradsusr.org</a><br><a href="http://gradsusr.org/mailman/listinfo/gradsusr"
target="_blank">http://gradsusr.org/mailman/listinfo/gradsusr</a><br><br><br>End of gradsusr Digest, Vol 42, Issue 4<br>***************************************<br><br><br></div> </div> </div> </div></body></html>