<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Good Afternoon All,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I am trying to use a formula to convert some data in GrADS v2.2.1.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<b>Excel Formula:</b></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
=10*LOG10(200*RainfallRate^1.6)<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<b>GrADS Formula (Broken down step-by-step for troubleshooting):</b></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
'define pratemmhr = (PRATEsfc.1*3600.0)' *converting mm/sec to mm/hour
<div>'define step1 = pow(pratemmhr,1.6)'</div>
<div>'define step2 = (200.0*step1)'</div>
<div>'define step3 = log10(const(step2,0,-u))'</div>
<div>'define step4 = (10.0*step3)'</div>
'define prate2dbz = step4'<br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I am receiving the following error in my Linux terminal:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<i>Warning from LOG10: Data has 182085 values <= zero</i></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<i>These were set to the undefined value</i><br>
</div>
<div id="Signature">
<div>
<meta content="text/html; charset=UTF-8">
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255); font-family:Calibri,Arial,Helvetica,sans-serif">
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size:12pt"><br>
</span></font></font></div>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size: 12pt; color: rgb(0, 0, 0);">What's going wrong
here?</span></font></font></div>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></font></font></div>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size: 12pt; color: rgb(200, 38, 19);">*Note, in Step
3, I have attempted to convert all undefined values to zeroes while log10() is called upon.</span></font></font></div>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size:12pt"><br>
</span></font></font></div>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size: 12pt; color: rgb(0, 0, 0);">Best,</span></font></font></div>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size:12pt"><br>
</span></font></font></div>
<span style="font-size:12pt; font-size:12pt"></span>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9" style=""><span style="font-size:11pt"><b><span style="font-size:14pt">Aaron
Perry</span></b></span></font></font></div>
<div style="color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif" style=""><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9" style="font-size:13px"><span style="font-size:11pt"><span style="font-size:14pt"></span></span></font><font face="Calibri,Arial,Helvetica,sans-serif" color="#006FC9" style=""><span style="font-size:12pt">Meteorologist<br>
</span><span style="font-size:12pt"></span></font><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9" style="font-size:13px"><span style="font-size:12pt">Class of '16</span></font><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9" style="font-size:13px"><span style="font-size:12pt"><br>
</span></font><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9" style="font-size:13px"><span style="font-size:12pt">Northern Vermont University-Lyndon</span></font></font></div>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size:12pt"><span style="font-size:10pt">(formerly </span><span style="font-size:10pt">Lyndon
State College)</span></span></font><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size:12pt"><br>
<span style="font-size:12pt"></span><span style="font-size:12pt">Boston, Mass.</span></span></font></font></div>
<span style="font-size:12pt"></span>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font size="2" color="#006FC9"><span style="font-size:12pt"><span style="font-size:12pt">Twitter:
</span><a href="https://twitter.com/AaronPerryWx" class="OWAAutoLink"><span style="font-size:12pt">@AaronPerryWx</span></a></span></font><font size="2"><span style="font-size:11pt"><span style="font-size:12pt"><a href="https://twitter.com/arnpry" target="_blank" id="LPNoLP"></a><a href="https://twitter.com/AaronPerryWx" class="OWAAutoLink"></a></span></span></font></font></div>
<span style="font-size:12pt"></span>
<div style="font-size:13px; color:rgb(0,0,0); font-family:Tahoma"><font face="Calibri,Arial,Helvetica,sans-serif"><font face="Calibri,Arial,Helvetica,sans-serif" size="2" color="#006FC9"><span style="font-size:12pt">Email: </span></font><a href="http://Aaron.Perry@lyndonstate.edu/" target="_blank" id="LPNoLP"><font face="Calibri,Arial,Helvetica,sans-serif" size="2"><span style="font-size:12pt">Aaron.Perry@lyndonstate.edu</span></font></a></font></div>
</div>
</div>
</div>
</div>
</body>
</html>