<!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>Goal Analysis</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_topic4" id="xps10_pagetitle">Goal Analysis</div>
      <hr noshade="true">
      <p class="para_topic"> Goal Analysis is used to create a graph of the output of a function. This graph can then be used to determine a good initial guess or bracket values for the actual goal seek process. This is especially valuable for functions that have multiple solutions, such as the y = sin(x) function, which can have a value of 0.5 for y at various values of x.</p>
      <p class="para_topic"> Choose Tools&rarr;Goal Analysis to display the Goal Analysis dialog. The following information is required by the Goal Analysis function.</p>
      <table border="0" cellpadding="2" cellspacing="3" align="center">
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="25%">
               <p class="para_td"> Variable Cell</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="75%">
               <p class="para_td"> The cell to change.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="25%">
               <p class="para_td"> Target Cell</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="75%">
               <p class="para_td"> The output value to graph.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="25%">
               <p class="para_td"> Lower Bracket</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="75%">
               <p class="para_td"> The lower range limit for the graph.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="25%">
               <p class="para_td"> Upper Bracket</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="75%">
               <p class="para_td"> The upper range limit for the graph.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="25%">
               <p class="para_td"> Number of Steps</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="75%">
               <p class="para_td"> The resolution of the graph.</p>
            </td>
         </tr>
         <tr>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="25%">
               <p class="para_td"> Results Cell</p>
            </td>
            <td bgcolor="#f4f4f4" colspan="1" rowspan="1" valign="top" width="75%">
               <p class="para_td"> Where to put the results.</p>
            </td>
         </tr>
      </table><br><p class="para_topic"> The variable cell will be initialized with the lower bracket value, and then increased (or decreased) to the upper bracket value in the specified number of steps. The results cell should be set to an open area on the spreadsheet so that intermediate values can be saved for graphical output. The intermediate results use two columns and &quot;Number of Steps&quot; rows to save the data. The goal analysis function will automatically create a line graph of the results.</p>
      <p class="para_topic"> When the function completes, the variable cell is set back to its original value before the goal analysis started.</p>
   </body>
</html>