<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<!--
Copyright (c) 2006 UGS Corp.

All Rights Reserved.

This software and related documentation are proprietary to UGS Corp.
-->
<html>
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <title>Function/Constant Conversions</title>
      <script language="javaScript">
        abridged="false";
        displayConditions=new Array();
      </script>
      <link type="text/css" href="../css/main_styles.css" rel="stylesheet">
   </head>
   <body class="bodydocs" onload="top.pageLoader()" bgcolor="#FFFFFF">
      <div class="title_topic2" id="xps10_pagetitle"> Function/Constant Conversions</div>
      <hr noshade="true">
      <p class="para_topic"> The tables below list the conversions between internal NX function names and equivalent functions in the spreadsheet when used from NX. Functions listed in this table are automatically converted during expression extraction and part update.</p>
      <p class="para_topic"> When editing expressions in the spreadsheet, you will need to use the spreadsheet's equivalent function in your expression. For example, to take the sine of an angle and use that in an expression you would enter:</p>
      <p class="para_topic"> =@SIND( 30 )</p>
      <p class="para_topic"> for your expression. This would then translate to:</p>
      <p class="para_topic"> sin(30)</p>
      <p class="para_topic"> When NX is updated. The same is true for cosine and tangent functions.</p>
      <p class="para_topic"> For the IF and ATAN2 functions, the way the function is entered in the spreadsheet is different from the way it is entered in the NX expressions dialog. In both of these cases, there is no difference between the XESS and Excel spreadsheets. When you create an expression using either of these functions in the expression dialog in NX and then request the expression spreadsheet or extract expressions from the part in the Modeling spreadsheet, NX will automatically make the adjustments as the expressions are moved to and from the spreadsheet. If, however, you enter the function while in the spreadsheet, you must be aware that the syntax is different there than in NX.</p>
      <table border="0" cellpadding="2" cellspacing="3" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> in NX</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> in spreadsheets ( XESS or Excel)</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> if(expr) (value_if_true) else (value_if_false)</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> IF(logical_test, value_if_true, value_if_false)</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> atan2(y,x)</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> ATAN2(x,y)</p>
            </td>
         </tr>
      </table><br><p class="para_topic"> For the FLOOR and IN functions, there is no difference in the functions between NX and XESS, but Excel is different.</p>
      <table border="0" cellpadding="2" cellspacing="3" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> in NX and XESS</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> in Excel</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> FLOOR(x)</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> FLOOR(x,1)</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> IN(x)</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td"> INCHES(x)</p>
            </td>
         </tr>
      </table><br><p class="para_topic"> Again, NX will automatically make adjustments as the expressions are moved to and from the spreadsheet, but if you are entering the function while in Excel, it is important to be aware that the syntax is different.</p>
      <div class="title_division"> NX Functions</div>
      <table border="0" cellpadding="2" cellspacing="3" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> NX Functions</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> Excel Functions</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> XESS Functions</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> abs</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ABS</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @ABS</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> acos</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ACOS</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @ACOS</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> asin</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ASIN</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @ASIN</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> atan</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ATAN</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @ATAN</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> atan2</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ATAN2</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @ATAN2</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ceil</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> CEIL</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @CEIL</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> cos</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> COSD</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @COSD</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> cosh</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> COSH</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @COSH</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> deg</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> DEGREES</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @DEGREES</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> exp</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> EXP</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @EXP</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> fact</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> FACT</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @FACT</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> floor</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> FLOOR</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @FLOOR</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> hypot</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> HYPOT</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @HYPOT</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> if</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> IF</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @IF</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> log</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> LN</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @LN</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> log10</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> LOG10</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @LOG10</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> rad</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> RADIANS</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @RADIANS</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> sin</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> SIND</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @SIND</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> sinh</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> SINH</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @SINH</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> sqrt</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> SQRT</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @SQRT</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> tan</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> TAND</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @TAND</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> tanh</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> TANH</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @TANH</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> trnc</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> TRNC</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @TRNC</p>
            </td>
         </tr>
      </table><br><div class="title_division"> NX Constants</div>
      <table border="0" cellpadding="2" cellspacing="3" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> NX Constants</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> Excel Constants</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> XESS Constants</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> degra</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> DEGRA</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @DEGRA</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> pi</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> PI</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @PI</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> radeg</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> RADEG</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @RADEG</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> twopi</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> TWOPI</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @TWOPI</p>
            </td>
         </tr>
      </table><br><div class="title_division"> NX Unit Conversions</div>
      <table border="0" cellpadding="2" cellspacing="3" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> NX Unit Conversions</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> Excel Unit Conversions</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> XESS Unit Conversions</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> cm</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> CM</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @CM</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ft</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> FT</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @FT</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> grd</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> GRD</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @GRD</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> in</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> IN</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @IN</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> km</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> KM</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @KM</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> mc</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> MC</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @MC</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> min</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> MINT</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @MINT</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ml</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ML</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @ML</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> mm</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> MM</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @MM</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> mtr</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> MTR</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @MTR</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> sec</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> SEC</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @SEC</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> ud</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> YD</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="middle">
               <p class="para_td"> @YD</p>
            </td>
         </tr>
      </table><br></body>
</html>