<!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>Advanced Spreadsheet Overview</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">Advanced Spreadsheet Overview</div>
      <hr noshade="true">
      <p class="para_topic">When you start creating a Standard Part, you have to consider how the part is structured and what its specific configurations are. In the following figure, you can see that there are several possible configurations for a Standard Part. In order to make it possible to create multiple options or a configuration with sub-options, it is necessary to have more data sheets in the spreadsheet than just one main sheet.</p>
      <table cellspacing="0" width="100%" align="center">
         <tr valign="top">
            <td colspan="1" rowspan="1" width="25%">
               <p class="para_td">No Option</p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p class="para_td">Single Option</p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p class="para_td">Multiple Option</p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p class="para_td">Single or Multi-Option with Sub-Options</p>
            </td>
         </tr>
         <tr valign="top">
            <td colspan="1" rowspan="1" width="25%">
               <p class="para_td">Singular configuration with parametric control of dimensions by option menu or parameter field editing.</p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p class="para_td">Same as No Option plus one options with multiple configurations and dimensional control parameters.</p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p class="para_td">Same as Single Option with multiple options to control multiple configurations.</p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p class="para_td">Same as Single or Multi-Option with additional sub-option configurations.</p>
            </td>
         </tr>
         <tr valign="top">
            <td colspan="1" rowspan="1" width="25%">
               <p align="center"><img align="bottom" src="graphics/standard_spreadsheet_01.gif"></p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p align="center"><img align="bottom" src="graphics/standard_spreadsheet_02.gif"></p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p align="center"><img align="bottom" src="graphics/standard_spreadsheet_03.gif"></p>
            </td>
            <td colspan="1" rowspan="1" width="25%">
               <p align="center"><img align="bottom" src="graphics/standard_spreadsheet_04.gif"></p>
            </td>
         </tr>
      </table><br></body>
</html>