<!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 Description</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 Description</div>
      <hr noshade="true">
      <p class="para_topic">There are several areas on the spreadsheet that make multiple configurations possible:</p>
      <ul>
         <li>
            <p class="para_item">Multiple Data Sheet</p>
         </li>
         <li>
            <p class="para_item">Order Number</p>
         </li>
         <li>
            <p class="para_item">Formula</p>
         </li>
         <li>
            <p class="para_item">Initial Value</p>
         </li>
         <li>
            <p class="para_item">Increment</p>
         </li>
      </ul>
      <div class="title_division">Multiple Data Sheet</div>
      <p class="para_division">In order to be able to handle very complicated data for flexible Standard Parts (multiple options or sub-options), you can separate this data into a Main sheet, Extra_Data_Sheets, and Inter Sub_Sheets.</p>
      <p class="para_division">The MISUMI Straight ejector pin EPJLFor catalog page contains an example of the Main sheet and the Extra_Data_Sheet.</p>
      <p class="para_division">On this catalog page, the straight ejector pin EPJL can be ordered with 8 Head Cut alterations, 1 Head Diameter alteration, 1 Head Thickness alteration, 2 Dowel Hole Boring alterations, 2 Engraving alterations and 1 Head Tapping alteration. These different types of alterations can be combined with each other, which ends up in a complicated order number.</p>
      <p class="para_division">Since you cannot put all this information in a single sheet, lets create 1 Main sheet and 4 Extra_Data_Sheets. The information in the different sheets needs to follow a number of rules. Those are explained under each sheet type.</p>
      <div class="title_division">Main Sheet</div>
      <p class="para_division">The Main spreadsheet has fields for Parent, Position, Attributes, Expressions, etc.</p>
      <div class="title_division">Attributes</div>
      <p class="para_division">You can define a Standard Part's attributes in this area exactly the same way as in the general Standard Parts Spreadsheet.</p>
      <p class="para_division">In order to create the exact order number, Mold Wizard combines the catalog attribute of the Main data sheet with the extra data sheets. Therefore, the catalog attribute EPJL&lt;L&gt;-&lt;P&gt; creates only the first part of the order number. The rest of the number is created in combination with the extra data sheets according to the following sequence:</p>
      <p class="para_division">Catalog + Catalog2 + Catalog3 + Catalog4 + ...</p>
      <div class="title_division">EXTRA_DATA_SHEET</div>
      <p class="para_division">The Extra Spread Sheet key word EXTRA_DATA_SHEET is used to register the extra sheets added to the database file. The names of the different sheets need to be added in exactly the same case-sensitive format with :: in front of it, in order for Mold Wizard to detect these strings as extra_data_sheets.</p>
      <p class="para_division">If you compare these names with the sheet tabs at the bottom, the text is exactly the same.</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">NOTE: Only the Main spreadsheet can own Extra_Data_Sheets!</p>
               </div>
            </td>
         </tr>
      </table>
      <div class="title_division">PARAMETERS</div>
      <p class="para_division">You define Standard Part parameters in this area. However, since Mold Wizard reads the cells sequentially from left to right, in the instances where there is a child-parent dependency of the cells, ensure that the parent parameters are placed to the left of the child parameter.</p>
      <p class="para_division">For instance, if the length (L) of an ejector pin is dependent on the diameter (D) of the pin, it's necessary to put D to the left of L, to ensure Mold Wizard can find the value of L by using the value of D.</p>
      <div class="title_division">Extra Data Sheet</div>
      <p class="para_division">An Extra_Data_Sheet has 5 columns in which the alteration data is stored. The sequence of these columns is fixed, so it's necessary to always use the exact sequence:</p>
      <ol type="1" start="1">
         <li>
            <p class="para_item">Alteration Type</p>
         </li>
         <li>
            <p class="para_item">Sub-Alteration</p>
         </li>
         <li>
            <p class="para_item">Condition</p>
         </li>
         <li>
            <p class="para_item">Sub-Catalog</p>
         </li>
         <li>
            <p class="para_item">Bitmap</p>
         </li>
      </ol>
      <p class="para_division">Although the sequence is fixed, the naming of the first 3 columns can be altered as long as you don't give them the same name. The other 2 columns have naming restrictions.</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">NOTE: There must be a PARAMETER and END cell before data rows and after data rows.</p>
               </div>
            </td>
         </tr>
      </table>
      <div class="title_division">Alteration Type</div>
      <p class="para_division">The Alteration Type column lists the different alteration names. In the example of the EPJL ejector pin, the different alterations for the Head Cut of the ejector pin are: KC, WKC, KAC-KBC, RKC, DKC, SKC, KGC, and KTC. These options appear as a pull-down menu in the Standard Part dialog box. </p>
      <div class="title_division">Sub-Alteration</div>
      <p class="para_division">If there are additional sub-alterations for each alteration type, these can be added to the Sub-Alteration column.</p>
      <p class="para_division">In the case of the ejector pin, there are no sub-alterations, therefore you will need to enter none.</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">NOTE: If you leave a row empty, the previous row will be taken as the value, so when you enter none in the first row of the Sub-Alteration column, all the following rows in this column can be left empty and will automatically have the none string.</p>
               </div>
            </td>
         </tr>
      </table>
      <div class="title_division">Condition</div>
      <p class="para_division">In the Condition area you can put numerate and range data types, formulas, or expressions as long as you make sure the formulas can be solved by the previous given data in the Main sheet.</p>
      <div class="title_division">Sub-Catalog</div>
      <p class="para_division">The sub-catalog column can only be named Catalog2, Catalog3, Catalog4, etc.,. because this name is used by Mold Wizard to create the combined order number in the BOM, following the logical sequence of Catalog (from the Main Sheet) + Catalog2 + Catalog3 + Catalog4 + .....</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">NOTE: A column name (e.g., Catalog2) can only be used once, and there is a maximum of 10 names for this column, which means an order number can be made out of a maximum of 1 Main Sheet and 9 Extra_Data_Sheets.</p>
               </div>
            </td>
         </tr>
      </table>
      <div class="title_division">Bitmap</div>
      <p class="para_division">The last column contains the bitmap information. The naming for this column can either be Bitmap or Bitmap2. If it's named Bitmap, it's put in the first Bitmap area of the Standard Parts dialog box.  If it's named Bitmap2, it's placed in the second Bitmap area. </p>
      <div class="title_division">Inter sub-Sheet</div>
      <p class="para_division">INTER_SHEET - inter sub-sheet keyword. There are some names of inter sub-sheet and searching index following it. They must occupy the first and second columns.</p>
      <ul>
         <li>
            <p class="para_item">Put some other information related to Extra Spread Sheet into inter sub-sheet.</p>
         </li>
         <li>
            <p class="para_item">Only numerate data is allowable in this kind of sheet.</p>
         </li>
      </ul>
      <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">NOTE: Only the EXTRA_DATA_SHEET can own Inter Sub-Sheets.</p>
               </div>
            </td>
         </tr>
      </table>
      <div class="title_division">Order Number</div>
      <p class="para_division">A complicated order number can be created due to the catalog number that can be added to each sheet. These numbers are combined to create the order number as indicated in the catalog.</p>
      <p class="para_division">In order to be able to create a correct order number in the Bill of Materials, it's necessary to understand how the spreadsheet collects the information and makes the combination for the order number.</p>
      <p class="para_division">In the MISUMI EPJL part example, the catalog number is formed as a combination of the catalog attribute created in the Main sheet + Catalog2 information in Head_Cut sheet + Catalog3 information in Head_Dia sheet + Catalog4 information in Head_Th sheet + Catalog5 information in Number sheet. </p>
      <p class="para_division">If, for instance, we want to create an EPJL ejector pin with specific alterations set as shown in the following table, Mold Wizard creates the order number by combining all the sheets.</p>
      <table align="center">
         <tr valign="top">
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="46%">
               <p class="para_td">P</p>
            </td>
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="53%">
               <p class="para_td">6</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="46%">
               <p class="para_td">Increment</p>
            </td>
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="53%">
               <p class="para_td">Increment[0.1]</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="46%">
               <p class="para_td">Head_Cut</p>
            </td>
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="53%">
               <p class="para_td">KC</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="46%">
               <p class="para_td">Head_Dia</p>
            </td>
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="53%">
               <p class="para_td">HC</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="46%">
               <p class="para_td">Head_Th</p>
            </td>
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="53%">
               <p class="para_td">Tc</p>
            </td>
         </tr>
         <tr valign="top">
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="46%">
               <p class="para_td">Number</p>
            </td>
            <td bgcolor="#f7f7f7" colspan="1" rowspan="1" width="53%">
               <p class="para_td">NHN</p>
            </td>
         </tr>
      </table><br></body>
</html>