The code tables in Assembly Planner are simple 2003 MS Excel files (XLS extension), that contain text in fields that are color-coded dark blue and are formatted as BOLD. When you select such a field, the application will take the value in that cell and reference it against a lookup table, which will then enter the code's TMU/MOD value, description and Value Add percentage in the element table below.
1.Go to Modules>Time Study and open the Calculated Time tab. The Basic MOST time standard (called BMOST) is shown below, with a list of template files (XLS) shown on the left. In this example, a template file was selected that also contained multiple spreadsheet tabs which each contain code tables.
Code Lookup Dropdown Edit BMOST
If you right-click in the list box of code template files, you can add, remove, or change the sequence of template files. It is important to note that the lookup file which is referenced by the templates must be loaded and must be tagged as the lookup file. See the next step for details.
Add and Open Lookup File
2.Once the template spreadsheets are uploaded, select the Lookup.xls sheet (called BMostLookup in this example) and select the 'Set Lookup' button.
BMOST Lookup
3.Next close this window and restart the application for your changes to take effect. When you return to the standard you edited, you should see the new codes in the element tables.