Excel is easy to use but not specialized for FMEA, you have to spend time trying to work-around with Excel’s alternative functions. TreeTABLE comes into play and introduces the fastest way to create professional FMEA right inside Excel. This instruction shows you how it can help you create FMEA in Excel quickly.
1. Quickly Edit FMEA in Excel
1.1. Quickly Insert New Item
In the below FMEA, there are 1 or many Potential Failure Mode for each Requirement. Potential Failure Modes should be separated from each other but still aligned with their common Requirement.
Excel worksheet is a flat table. One Potential Failure Mode corresponds with one Requirement. How do you add one new item in Potential Failure Mode but still keep it align with the current item of Requirements?
- With Excel: insert a new row below the current one for the new item, but this action also creates new items that we don’t need. To fix this problem, you may work around with by merging cells in other columns.
- With TreeTABLE: TreeTABLE provides a rapid way to insert new item FMEA in Excel. Just select the current item and press Enter.
#1 FMEA Creator for Excel
1.2. Quickly Delete Item
If we want to remove an item in Causes column without effect to other content, deleting its row is not a suitable solution because it may delete other items. What should you do?
- With Excel: Unmerge some items, delete the unnecessary item and then merge again. This method requires a lot of tasks.
- With TreeTABLE Add-in: TreeTABLE provides a quick way to delete. Press the Delete button or right click and select Delete Item.
1.3. Fit & AutoFit
Excel does not allow autofit for merged cell. In the example FMEA below, if you add more text for the pink item, its row height does not shrink to fit addintional text.
- Excel Way: you have to resize row height to fit content manually.
- TreeTABLE Way: Turn Auto Fit in TreeTABLE ribbon, and TreeTABLE will automatically change row height to make the cell content fit.
2. Quickly create Formula of RPN in Excel
Creating the the formula for one RPN is simple, but it isn’t easy to create formulas for all RPN cells of FMEA in Excel quickly. So how should you do it?
- With Excel: You have to create RPN fomulas one by one since formulas of RPN items are different.
- With TreeTABLE: You also have to enter the formula for the first one, then click Copy Formula. It will implement RPN formula for all below RPN items.