exporting to Excel...

[Cottet, Loic (IFPRI)]

Thank you everyone for your help,
 
I am glad I understood better the script, their function and use thanks
to you (Diane particularly).
I have written one script then to export data and make them readable in
Excel.
Hereunder the script:
 
 
'sdfopen data\mrso1.nc'
'set lat 20'
'set lon 55'
'set z 1'
'set t 1 12'
filename='youyou'
'set gxout print'
'd mrso'
rc=write(filename,result)
 
 
The youyou file does not create. It does though when I want the average
(see my attached excel results):
 
 
 
'sdfopen data\mrso1.nc'
'set lat 20 25'
'set lon 52 55'
'set z 1'
'set t 1 12'
'define m1 = ave(mrso.1,t=1,t=601)'
filename='testbis.xls'
'set gxout print'
'd m1'
rc=write(filename,result)
 
 
So, I have 2 questions:
*1st one related to the first script: why can't I have a file created
when I ask to export for each step of time. Indeed, I would like to have
for each grid, a monthly value during my period of time mentionned, do
you know what I mean?
*2nd question: why in Excel the numbers are so big (x*e25, or so small
x*e-17). What are those numbers?
 
 
Thanks a lot for your cooperation,
 
Loic.
 
 
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gradsusr.org/pipermail/gradsusr/attachments/20060609/d5596105/attachment.html