Navigation Title FMEA - Failure Mode and Effects Analysis
FMEA data Content Failure Modes and Effects Analysis (FMEA) is a
FMEA standards
When to Use FMEA? When a process, product or service is being desi
When an existing process, product or service is b
Before developing control plans for a new or mod
When improvement goals are planned for an exis
When analyzing failures of an existing process, p
Periodically throughout the life of the process, pr
Failure modes Tthe ways, or modes, in which something might f
Effective analysis Refers to studying the consequences of those fa
Potential failure What is the failure function that may happen
Potential effect Diercet effect for the failure and potential conseq
Severity "sev" Rate the severity of each failure rate on a scale o
Potential cause The main root cause for this issue
Occurance "Occ" The likelihood of each failure rate on a scale of 1
Detection "Det" Examine the current design and then on a scale
RPN "Risk Priority Number" is the combined weighing
Customization difficulty (1-3) 1
Explanation of sheets FMEA data This sheet for recording FMEA details and failure
FMEA standards Is a refernce of each severity, occurance and det
How to customize 1) Starting from FMEA data sheet in above side rec
2) In below table sort your failure modes functions,
3) For severity, occurance and detection numbers c
4) Record Sev, Occ and Det then RPN will be calcu
5) In right side of data you will start to record require
6) Record person or team in charged to solve this fa
7) Record actual action taken
8) After action taken you should recalculate RPN ag
9) To add new function it's easy to insert new colum
10) Merge function cell to match related failure mode
Related To Online Templates Our templates is compatible with online service b
Here is some hints that replace our macros in ca
Referesh / Update Data Some of our templates include Referesh/Update
Full Screen Some of our templates have Full Screen
Other Macros / Buttons Other macros is applied on less than ~15% of ou
Open in Desktop App To open online template using Desktop App be s
All content is Copyright material of Simple Sheet
http://www.simplesheets.co
© 2020 Simple Sheets LLC
All rights reserved. The contents of this publicati
No part of this publication may be modified, man
and Effects Analysis
ects Analysis (FMEA) is a step-by-step approach for identifying all possible failures in a design, manufacturing or assembly process, or a pr
uct or service is being designed or redesigned, after quality function deployment.
ess, product or service is being applied in a new way.
trol plans for a new or modified process.
als are planned for an existing process, product or service.
es of an existing process, product or service.
t the life of the process, product or service
in which something might fail. Failures are any errors or defects, especially ones that affect the customer.
consequences of those failures.
ction that may happen
ailure and potential consequence
ch failure rate on a scale of 1-10
or this issue
failure rate on a scale of 1 - 10
esign and then on a scale of 1-10 rate the detecability of each failur
is the combined weighing of severity, Occurance and detection = Sev*Occ*Det
g FMEA details and failures data
everity, occurance and detection on a scale of 1-10 according to failure effect degree
ata sheet in above side recording related failure modes details.
r failure modes functions, potential failure and potential effect
e and detection numbers check standard reference from FMEA standards according to your failures degree
Det then RPN will be calculated
u will start to record required actions to solve this failure
m in charged to solve this failure with due date
should recalculate RPN again to measure how many improvement you have achieved
s easy to insert new column and only drill down RPN cell function.
match related failure modes
atible with online service but some templates that including macros feature is still not supported with Excel Online
t replace our macros in case of using Online Template
s include Referesh/Update data macro button that can be replaced with Referesh All tool in Excel Online ribbon
s have Full Screen macro button that can be replaced with the itself web browser full screen tool
d on less than ~15% of our templats can be overcome by transferring to Desktop App "Open in Desktop App" button
te using Desktop App be sure that you signed in to your Microsoft account / Onedrive account
t material of Simple Sheets LLC.
e contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected und
ion may be modified, manipulated, reproduced, distributed, or transmitted without prior written permission of the publisher, except in the cas
ssembly process, or a product or service.
code, are protected under international copyright and trademark laws.
blisher, except in the case of certain noncommercial uses permitted by copyright law.
FAILURE MODE AND EFFECTS ANALYSIS
Item: Responsibility: FMEA number:
Model: Prepared by: Page :
Core Team: FMEA Date (Orig):
Potential
S O Current D R Responsibility
Potential Effect(s) of Cause(s)/ Recommended
Function Potential Failure Mode e c Process e P and Target
Failure Mechanism(s) of Action(s)
v c Controls t N Completion Date
Failure
customer very Internal low cash Improve cash Security center
Doesn't dispense cash 8 Out of cash 3 5 120
dissatissfied alert alret system 03/02/2019
Dispense amount Loading
Bills stuck Maintane Maintenance
of cash Dispense too much cash Bank loss money 6 3 procedure (riffle 6 108
together counting mahine team 15/02/2019
requested by ends if stock)
customer Improve
Takes too long to Customer somewhat Heavy computer IT team
3 7 None 10 210 computer
dispense cash annoyed network 05/03/2019
processing..
-
-
Function B
-
-
-
-
Function C
-
-
-
Function D
123456
1 of 1
1/1/2019 Rev: 1
Action Results
S O D R
Actions Taken e c e P
v c t N
Cash alarm
3 2 1 6
improved
Machine
maintenance 2 2 1 4
scheduled
New advanced
computer 2 3 2 12
purchased
-
-
-
-
-
-
-
-
-
Effect
Hazardous without warning
Hazardous with warning
Very High
High
Moderate
Low
Very Low
Minor
Very Minor
None
PROBABILITY of Failure
Very High: Failure is almost inevitable
High: Repeated failures
Moderate: Occasional failures
Low: Relatively few failures
Remote: Failure is unlikely
Detection
Absolute Uncertainty
Very Remote
Remote
Very Low
Low
Moderate
Moderately High
High
Very High
Almost Certain
Severity
Very high severity ranking when a potential failure mode affects safe system operation without warning
Very high severity ranking when a potential failure mode affects safe system operation with warning
System inoperable with destructive failure without compromising safety
System inoperable with equipment damage
System inoperable with minor damage
System inoperable without damage
System operable with significant degradation of performance
System operable with some degradation of performance
System operable with minimal interference
No effect
Occurance
>1 in 2
1 in 3
1 in 8
1 in 20
1 in 80
1 in 400
1 in 2,000
1 in 15,000
1 in 150,000
<1 in 1,500,000
Detection
Design control cannot detect potential cause/mechanism and subsequent failure mode
Very remote chance the design control will detect potential cause/mechanism and subsequent failure mode
Remote chance the design control will detect potential cause/mechanism and subsequent failure mode
Very low chance the design control will detect potential cause/mechanism and subsequent failure mode
Low chance the design control will detect potential cause/mechanism and subsequent failure mode
Moderate chance the design control will detect potential cause/mechanism and subsequent failure mode
Moderately High chance the design control will detect potential cause/mechanism and subsequent failure mod
High chance the design control will detect potential cause/mechanism and subsequent failure mode
Very high chance the design control will detect potential cause/mechanism and subsequent failure mode
Design control will detect potential cause/mechanism and subsequent failure mode
Ranking
10
9
8
7
6
5
4
3
2
1
Ranking
10
9
8
7
6
5
4
3
2
1
Ranking
10
9
8
7
6
5
4
3
2
1
