<!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>Creating a Basic Modeling Spreadsheet</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_topic3" id="xps10_pagetitle">Creating a Basic Modeling Spreadsheet</div>
      <hr noshade="true">
      <p class="para_topic">This section presents a set of basic steps you can use to create a Modeling spreadsheet. The spreadsheet used to illustrate this section has been cropped down to show just the relevant data areas.</p>
      <table border="0">
         <tr>
            <td valign="top" align="left"><img align="left" src="../graphics/note.gif" alt="Note" title="Note"></td>
            <td valign="bottom" align="left" width="100%">
               <div class="para_note">
                  <p class="para_note_body">  Some spreadsheet programs (such as  <a class="links" href="javascript:void(0)" onclick="top.openFile('shared_func/tls_spd_mod_gs_ov_r.html');return(false);">Goalseek</a>) may not fully support the use of Interpart Expressions within the Modeling Spreadsheet extended functionality. See  <a class="links" href="javascript:void(0)" onclick="top.openFile('shared_func/tls_spd_mod_ass_interpart_r.html');return(false);">Interpart Expressions</a>.
                  </p>
               </div>
            </td>
         </tr>
      </table>
      <p class="para_topic">The basic steps in creating a Modeling spreadsheet are shown below.</p>
      <table cellspacing="3" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Step 1. Rename Expressions with Meaningful Names</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The first step, if it has not already been done, is to rename the NX expressions so that the names are meaningful. You don't need to rename all of the expressions, just those that will be used in the spreadsheet. You can perform this with the Rename function in Tools&rarr;Expression&rarr;Rename.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Step 2. Extract Expression into the Spreadsheet</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">While you are still in the Modeling application, start the spreadsheet using Tools&rarr;Spreadsheet. After a few moments, the spreadsheet will display. If this is a new part or new spreadsheet, the contents will be blank.</p>
               <p class="para_td">Place the cursor in cell A3 and click (we are using A3 instead of A1 or A2 in order to leave some room for titles). Now select Tools&rarr;Extract Expr from the spreadsheet menu bar. What you will end up with could look something like what is shown below in the Extract Expressions figure.</p>
            </td>
         </tr>
      </table><br><div class="figure">
         <p align="center"><img align="bottom" src="graphics/tls_6ssheet1fr35.gif"></p>
      </div>
      <div class="title_figure">Extract Expressions</div>
      <table cellspacing="3" width="100%" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Step 3. Edit, Move and Delete Cells, and Organize the Expressions</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Use the spreadsheet Edit functions to reorganize the extracted list of expressions, so that the spreadsheet only contains the necessary expressions. The new spreadsheet now looks like this:</p>
            </td>
         </tr>
      </table><br><div class="figure">
         <p align="center"><img align="bottom" src="graphics/tls_6ssheet1fr34.gif"></p>
      </div>
      <div class="title_figure">Edited Spreadsheet</div>
      <p class="para_topic">After you have reorganized the expressions, you need to establish the Expression Range. Start by clicking in cell A4 and dragging to cell B7. Now select the spreadsheet menu option Edit&rarr;Define Expr Rng to set the Expression Range. The Expression Range determines which cells contain NX expressions that should be sent to the part when you request an Update.</p>
      <table cellspacing="3" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">Step 4. Create a Third Column for Values</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top">
               <p class="para_td">By default, the first column of expressions is the expression name, and the second column contains the formula for the expression. The display mode for the second column has been set to &quot;TEXT&quot; by the extraction routine. What we need to do now is create a third column that will display the values of the expressions.</p>
               <p class="para_td">Place the cursor in cell C4, enter the text &quot;=B4&quot; and press &lt;Return&gt;. The cell C4 now displays the value of the expression in cell B4. You can copy the formula to the remaining expressions by pressing &lt;Ctrl&gt;&lt;F&gt;, and then clicking in the next cell to place the copy.</p>
               <p class="para_td">Now add a few headers and the spreadsheet will look something like what is shown below in the Adding Headers and a Values Column figure.</p>
            </td>
         </tr>
      </table><br><div class="figure">
         <p align="center"><img align="bottom" src="graphics/tls_6ssheet1fr33.gif"></p>
      </div>
      <div class="title_figure">Adding Headers and a Values Column</div>
      <p class="para_topic">You can make the two new titles bold and italic either with the toolbar B and I option.</p>
      <div class="figure">
         <p align="center"><img align="bottom" src="graphics/tls_tools_spd_xess_toolbar.gif"></p>
      </div>
      <div class="title_figure">Xess Spreadsheet Toolbar</div>
      <p class="para_topic">You can also add bold and Italics by selecting Bold-Italic from the spreadsheet Format&rarr;Font Style option.</p>
      <div class="title_division">Enable Spreadsheet Protection</div>
      <p class="para_division">In many cases, you will have cells either as expressions or design data that are not supposed to be changed. To avoid inadvertent changes to those cells, you can enable protection of cells. By default, when protection is enabled, all cells can still be modified. To enable protection:</p>
      <ol type="1" start="1">
         <li>
            <p class="para_item">Select Options&rarr;Sheet Defaults and toggle ON Check Protection and press OK. At this point, the entire spreadsheet will turn green.</p>
         </li>
         <li>
            <p class="para_item">If you would like to change from an all-green spreadsheet, select Options&rarr;Cell Defaults and change the UnProtect BG color to white, and press OK.</p>
         </li>
         <li>
            <p class="para_item">Click in a cell you want to protect, or drag a range of cells that should be protected, and select Tools&rarr;Cell Protection&rarr;Protect from the menu. Nothing visually will change, but protected cells can no longer be modified</p>
         </li>
      </ol>
      <p class="para_division">This protection technique is also useful if you want to use the automatic refresh options when the spreadsheet is loaded and you want to prevent some expressions from being refreshed.</p>
      <div class="title_division">Use Color to Enhance Readability</div>
      <p class="para_division">To improve readability of your spreadsheet, you can add some titles and change some of the background colors.</p>
      <p class="para_division">To change a color, select a cell or range of cells and select Format&rarr;Cell Color from the menu bar. This menu option displays a dialog that allows you to change foreground or background colors.</p>
      <p class="para_division">In our sample spreadsheets we chose a pink color for expressions that can be modified, tan for values related to expressions, cyan for titles, and salmon for cells that are protected. The new spreadsheet is shown below in the Sample Spreadsheet with Expressions and Values figure.</p>
      <div class="figure">
         <p align="center"><img align="bottom" src="graphics/tls_6ssheet1fr31.gif"></p>
      </div>
      <div class="title_figure">Sample Spreadsheet with Expressions and Values</div>
      <p class="para_division">The size of the title, &quot;Basic Design Spreadsheet&quot;, was modified using the Format&rarr;Font Size option and clicking on 18pt.</p>
      <div class="title_division">Update the NX Part</div>
      <p class="para_division">To update the NX part with the expressions from the spreadsheet, select the menu option Tools&rarr;Update NX Part. If everything is set up correctly, you will see a message in the status line at the bottom of the spreadsheet stating that the update was successful. </p>
   </body>
</html>