<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Arial, sans-serif" size="2">
<div>Dear users.</div>
<div>I need to export some data reconrd from grads to excel file but i'm not able to do this.</div>
<div>I have written this command line but doesn't work.</div>
<div>Say that there is a problems on this command:</div>
<div> </div>
<div><font face="Courier New">'display rh2m'</font></div>
<div><font face="Courier New">filename='test.xls'</font></div>
<div><font face="Courier New">'set gxout print'</font></div>
<div><font face="Courier New">'d rh2m'</font></div>
<div><font face="Courier New">'rc=(test.xls,rh2m)'</font></div>
<div><font face="Courier New"> </font></div>
<div>That i've written to export.</div>
<div>Some of you can suggest to me how can i export the value of this variable rh2m.</div>
<div>Another question it's about the command IF that in my programme doesn't work.</div>
<div>I write some like this but says that it is not correct unknow command: </div>
<div> </div>
<div><font face="Courier New">'if (t2m>273.15)'</font></div>
<div><font face="Courier New"> 'define eps1=exp((-6763.6/t2m)-4.9283*log(t2m)+54.23)'</font></div>
<div><font face="Courier New">'else'</font></div>
<div><font face="Courier New"> 'define eps1=exp((-6141/t2m)+24.3)'</font></div>
<div><font face="Courier New">'endif'</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New">Thank you so much</font></div>
<div><font face="Courier New">davide</font></div>
<div><font face="Courier New"> </font></div>
<div> </div>
<div><font face="Courier New">* Statistics on 2m air temperature and relative humidity in Europe from</font></div>
<div><font face="Courier New">* 1/1/1999 to 31/12/2008</font></div>
<div><font face="Courier New">* The source data are ECMWF ERA Interim Reanalysis, provided by the European</font></div>
<div><font face="Courier New">* Centre for Medium-Range Weather Forecast, in grib format, with spatial</font></div>
<div><font face="Courier New">* resolution of 1,5deg x 1,5deg lat/lon, and temporal resolution of 6h (data</font></div>
<div><font face="Courier New">* at 00, 06, 12, 18 UTC)</font></div>
<div><font face="Courier New">* There are 49x28 grid points (LON from -27 to 45, LAT from 33 to 73.5), and</font></div>
<div><font face="Courier New">* 14612 time steps</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New">'reinit'</font></div>
<div><font face="Courier New">'open temperature_Europe_10y.ctl'</font></div>
<div><font face="Courier New">'set grads off'</font></div>
<div><font face="Courier New">'set t 1 14612'</font></div>
<div><font face="Courier New">'define t2m=no2tsfc.1'</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New">'set t 1 1461'</font></div>
<div><font face="Courier New">'set lat 45'</font></div>
<div><font face="Courier New">'set lon 23'</font></div>
<div><font face="Courier New">'draw title 2mT at lat45 lon23'</font></div>
<div><font face="Courier New">'draw ylab 2m Temperature'</font></div>
<div><font face="Courier New">'set ccolor 2'</font></div>
<div><font face="Courier New">'set cmark 0'</font></div>
<div><font face="Courier New">*'display (t2m-273.15)'</font></div>
<div><font face="Courier New">*'set fwrite t2m_lat45_lon23.gif'</font></div>
<div><font face="Courier New">*'printim t2m_lat45_lon23.gif white gif'</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New">'open dptemperature_Europe_10y.ctl'</font></div>
<div><font face="Courier New">'set t 1 1461'</font></div>
<div><font face="Courier New">'define tdp2m=no2dsfc.2'</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New">*Calculation of saturated pressure of water vapour</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New"> 'define eps1=exp((-6763.6/t2m)-4.9283*log(t2m)+54.23)'</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New">*Calculation of water vapour pressure</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New"> 'define eps2=exp((-6763.6/tdp2m)-4.9283*log(tdp2m)+54.23)'</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New">*Calculation of relative humidity</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New">'define rh2m=eps2/eps1'</font></div>
<div><font face="Courier New">'display rh2m'</font></div>
<div><font face="Courier New">filename='test.xls'</font></div>
<div><font face="Courier New">'set gxout print'</font></div>
<div><font face="Courier New">'d rh2m'</font></div>
<div><font face="Courier New">'rc=(test.xls,rh2m)'</font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New"> </font></div>
<div> </div>
</font>
</body>
</html>