Administrators can edit existing code template files starting in Assembly Planner's Template Manager. First go to Admin Tools>Template Manager. Select TimeEstimation from the drop down menu at the top, select the template you wish to edit, and right-click to select Export. This will allow you to save the file and open in Microsoft Excel. Note: When editing, it is important to follow the format of existing template files. All colors and styles should be replicated. In addition to loading the new code file, the existing "lookup" file needs to contain the new code.
Continue through this section to learn how to add and edit code. Refer to Loading Templates to learn how to import the modified templates back into Assembly Planner (this should not be done through the Template Manager).
The lookup spreadsheet file has a different format for each predetermined standard type. As a result, it is important to edit this existing file, instead of creating a new lookup file. A lookup file for MTM-UAS is shown below. In this example, the code lookup text string is in column A (typical for all standards), and the MU value is in column C. The value Add percentage is in column G, and the default code description is shown in column H. Note that it is important that all codes that appear in your template XLS code table files, also have a corresponding entry in the designated code Lookup file for that time standard.
Lookup File for MTM-UAS
We will walk through an example of adding a new MODAPTS code.
1.Open Assembly Planner and go to Admin Tools>Template Manager.
2.Fine the MODAPTS files - MODAPTS-Cognitive.xls, MODAPTS-MoveGet.xls, MODAPTS-MovePut.xls, MODAPTS-Use_Juggle_Press_Crank.xls, MODAPTS-Walk_Sit_Bend.xls and MODAPTSLookup.xls.
3.Select the MODAPTSLookup.xls, right-click and click Export. This will allow you to save the file and open it in Microsoft Excel.
Exported Excel MPDAPTS Lookup File
4.In the file you will find the following columns-
•Code - Type in the new code to be added in this column. Say we add a new code M2P3
•Freq - Provide the frequency for this move. Our frequency is 1.
•Desc - Provide a description for this code - Our description is - Test Code
•Time - Provide the time in MODS - Our time is - 5
•VA - Provide the Value Added content of this code - Our value added content is - 90
Value Added Content
5.If you add a "combined code" as we have in the example (M2+P3), make sure that the individual codes also exist in the lookup file. If M2 or P3 did not exist, we would add a line with each code's details.
6.Once you have finished editing, save the file as a .xls and close it.
7.Next we will add this code to the Move Put file. Open the MODAPTS-MovePut.xls file.
8.Go back to the Assembly Planner Template Manager, select the file and Export. Once the file is open, create a column called test at the very end. In order to put in the new code, you MUST copy an existing code into the desired cell and edit the same. Note that the look up capability will not work if an existing code is not copied and edited. In our case we will copy any of the codes and paste it in the test column. Change the value to M2P3.
Copy and Pasted Code
9. Next save this file as an .xls and close it.
10. Continue to the next section to load the templates.
Note: It is important to note that the different time standards will have different fields that need to be populated.