VN:F [1.9.22_1171]
Rating: 4.4/5 (5 votes cast)
Add Comment

Author: © Eric Dayal

Download Now: FMEA-Template.xlsx


This FMEA Template (Failure mode and effects analysis) is built in Excel and automatically calculates the RPN score for you.  The FMEA is intended to help mitigate risk with a process, product or project. 

To begin using the FMEA template, identify all of the process steps or functions associated with your process or project.  Enter all of these into Column B of the template.  Next, identify potential failures (or problems) that can occur at each of these steps and enter them into Column C.  Also, identify the effects or impacts of each failure occurring and enter that into Column D.  Try to identify causes of the potential failures and enter them into Column F.  In Column H, enter any existing controls that are in place to address each of the potential failures you have identified. 

To complete the blue section of the FMEA template, you will need to assign Severity (Column E), Probability (Column G) and Detectability (Column I) scores for each potential failure.  Use a scale from 1-10 for each of these scores.  For Severity, 1 is not at all severe and 10 is extremely severe.  For Probability, 1 indicates not at all likely to occur, and 10 indicates certainty that it will occur.  For Detectability, 1 indicates it is very easy to detect and 10 indicates it is very difficult to detect (note this one may be opposite of what you expect). 

Once you enter all of these scores, the Risk Priority Number (RPN) will be calculated for you.  The RPN is calculated by multiplying the Severity times the Probability times the Detectability.  Items with the highest RPN should be addressed first.

To complete the green section, enter recommended actions to address the cause of the potential failure and assign an Owner to carry them out.  Once the actions are completed, enter them into Column M.  After actions have been completed, enter the new Severity, Probability and Detectability into Columns N, O and P.  A New RPN score will be calculated for you in Column Q. If you have properly addressed the cause of the potential failure, the New RPN should be much lower than the original RPN.

Related Docs:

  • 5W2H-ppt-Template.pptx
  • Simple-Pareto-Chart-IT-Operation.xls
  • One-Page-Project-Charter.pptx
  • SIPOC.doc
  • 5w2h.docx

  • Tags: ,,

    Was this document helpful? Rate it Now

    FMEA-Template.xlsx, 4.4 out of 5 based on 5 ratings

    Date Posted: 2015-05-22 14:55:16

    One thought on “FMEA-Template.xlsx

    1. The problem when using these template is you have to merge cells over and over again to show the relationship between columns in FMEA. Example each process step/function has one or many failure modes. To solve this problem, you can use TreeTABLE addin to work with any relation structure table as FMEA or Control Plan, it also provide template if you need one.

      VA:F [1.9.22_1171]
      Rating: 0 (from 0 votes)

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    Your Documents & Templates Belong Here

    Upload Now