<!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>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">Spreadsheet</div>
      <hr noshade="true">
      <p class="para_topic">When you use the Spreadsheet to view the results (by choosing <b class="uiTerm">Spreadsheet</b> on the <a class="links" href="javascript:void(0)" onclick="top.openFile('quickstack/results.html');return(false);"><b class="uiTerm">Results</b></a> dialog box), the spreadsheet has two pages, <b class="uiTerm">Variations</b> and <a class="links" href="javascript:void(0)" onclick="top.openFile('quickstack/spreadsheet.html#simulate_spreadsheet_contributors');return(false);"><b class="uiTerm">Contributors</b></a>.
      </p>
      <p class="para_topic">See the <em>Common Tools Help</em> for information about the <a class="links" href="javascript:void(0)" onclick="top.popUpPage('shared_func/index.html?goto=shared_func/tls_spd_ov_r.html&vars=-aux,-home','linkInter','menubar=yes,status=yes,resizable=yes,toolbar=yes,scrollbars=yes,location=no,directories=no');return(false);">spreadsheet</a> options.
      </p>
      <div class="title_division">Variations page</div>
      <p class="para_division">The <b class="uiTerm">Variations</b> page provides detailed information for each measurement.
      </p>
      <table cellspacing="3" width="100%" align="center">
         <tr valign="top">
            <th bgcolor="#c0c0c0" colspan="2" rowspan="1" valign="top">
               <p class="para_th">Variations page columns</p>
            </th>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Measurement</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The measurements that have been analyzed.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Units</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The units (degrees, millimeters or inches) of the measurement.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Nominal</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The nominal value of the measurement.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Minimum</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The minimum value of the measurement.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Maximum</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The maximum value of the measurement.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Variation</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The total variation for the measurement.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Contributor 1</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The top contributor to the measurement's results.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Contributor 2</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The second-greatest contributor to the measurement's results.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Contributor 3</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The third-greatest contributor to the measurement's results.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><img align="bottom" src="graphics/qs_rel_importance.gif" border="0"></p>
               <p class="para_td"><b class="uiTerm">Relative Importance</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">A graphical indicator that compares how much each of the top three contributors influenced the measurement's results.</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Description</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The optional, user-defined description of each measurement.</p>
            </td>
         </tr>
      </table><br><a name="simulate_spreadsheet_contributors"></a><div class="title_division">Contributors page</div>
      <p class="para_division">The <b class="uiTerm">Contributors</b> page provides detailed information for each of the tolerances. You can modify the tolerance values on this page, and run another simulation to see the effects of the modified values.
      </p>
      <table cellspacing="3" width="100%" align="center">
         <tr valign="top">
            <th bgcolor="#c0c0c0" colspan="2" rowspan="1" valign="top">
               <p class="para_th">Contributors Page Columns</p>
            </th>
         </tr>
         <tr>
            <td bgcolor="#F9F9F9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Measurement Name</b></p>
            </td>
            <td bgcolor="#F9F9F9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The name of each measurement used in the simulation.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#F9F9F9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Contributor Name</b></p>
            </td>
            <td bgcolor="#F9F9F9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The contributors for each measurement.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#F9F9F9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Size</b></p>
            </td>
            <td bgcolor="#F9F9F9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The tolerance size (if applicable).</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Callout</b></p>
            </td>
            <td bgcolor="#f9f9f9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The callout for each tolerance.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#F9F9F9" colspan="1" rowspan="1" valign="top">
               <p class="para_td"><b class="uiTerm">Contribution</b></p>
            </td>
            <td bgcolor="#F9F9F9" colspan="1" rowspan="1" valign="top">
               <p class="para_td">The percentage effect that each contributor has on the measurement.</p>
            </td>
         </tr>
      </table><br><p class="para_division">To run another simulation, choose <b class="uiTerm">Options</b>&rarr;<b class="uiTerm">Re-run Simulation</b> from the spreadsheet's main menu.
      </p>
   </body>
</html>
