BOM Lookup Tab

The BOM Lookup Tab has two primary functions. First, it determines what static BOM should be used for the given compressor number. For these two input fields are provided: part # and MO (Manufacturing Order). The part number or compressor unit number is used in determining which static BOM should be used for planning aftermarket production. The MO simply follows the compressor down the line and is attached to the final BOM. Once the part number is entered by the user, the app determines the group, group \#, and Static BOM that should be used for this compressor repair. These three fields are then displayed for the user in edit fields. The secondary functionality of the BOM Lookup Tab is the upload feature. Now that the static BOM is known, the upload feature is used to upload the appropriate static BOM to the app. This static BOM will be used in future features within the app.

Decision Matrix Tab

The Decision matrix panel is comprised of a panel you can input the component number of the four major parts: IGBT, CAP, PWM, SCR. In addition to the input fields, there are good and bad check boxes that determine the structural integrity of the part. To the right of the input panel there is an action text box that lets the user now what the app is doing with those four main components. Finally, there is an OK button that activates all the functionality. Based on the weather the 4 main components are on the static BOM, and the structural integrity, the part enters 4 possible cases.

Repair List Tab

The Repair List has two main functionalities: a manual repair list and upload file feature. The manual repair list allows the user to input component numbers and their associated quantities. From the component numbers entered, the component number's description is generated using the BOM Lookup.xlsx file. For each component number added the application will determine if the component number exists within this file, and if it exists it will be added to the repair list. Each entry contains four components row number, component number, description, and quantity. If two of the same component numbers are entered, then the row will be highlighted red and an error dialog box will be displayed to the user saying "Please delete repeated component." There is also a deletion feature which allows the user to delete rows they do not want to be contained within the repair list. The second functionality is an upload feature. This feature can serve to replace or supplement the manual repair list. Its functionality is the same as that of the first upload feature, see the BOM Lookup tab for more details.

Review Tab

The Review Tab is a sum of the revised static BOM and the repair list. This information is displayed in a UITable. The table is updated by passing the final results from each tab as global variables to the final tab. The two tables, the revised static BOM and the repair list, are concatenated into one final table. Then some functions were made within the app to get rid of duplicate items on the final BOM. In addition, there is a sheet on the BOM Lookup file called Comments that contains an obsolescence list. The app cross-references the component numbers on the final BOM with the components on the obsolescence file. Within the obsolescence file is the correct replacement for each associated part. The app deletes the obsolete part off of the final BOM and adds the correct replacement on the end of the final BOM. After these changes are applied, the final BOM can be exported to an excel file.