Differences

This shows you the differences between two versions of the page.

--- downloads [2023/03/09 19:23] – ["Unilateral Cp-Cpk Calculator" (9-05-22)] rrandall
+++ downloads [2024/01/23 20:03] (current) – ["Competency Matrix" template in Excel] rrandall
@@ Line 1: / Line 1: @@
 ====== Downloads ======
+{{keywords>ISO 9001,ISO9001,AS9100,AS9120,ISO 9001 Free Downloads,ISO 9001 Free Templates,AS9100 Free Downloads,AS9100 Free Templates,AS9120 Free Downloads,AS9120 Free Templates,AS9100 QMS Awareness,AS9120 QMS Awareness,AS9100 QMS Awareness,ISO 9001 Competency Matrix,AS9100 Competency Matrix,AS9120 Competency Matrix,Competency Matrix,SMART Template,SWOT,Unilateral Cp Cpk}}
 ===== "AS9100-QMS Awareness Training" template in PowerPoint (7/22) =====
@@ Line 19: / Line 19: @@
 </WRAP>
-===== "Competency Matrix" template in Excel (01/17/23) =====
+===== "Competency Matrix" template in Excel =====
-{{ :downloads:competency_matrix-block_rev._01-17-23_.png?direct&600 |"Competency Matrix" template in Excel (01/17/23)}}
+{{ :downloads:competency_matrix-template_11-14-23.png?direct&600 |"Competency Matrix" template in Excel}}
 <WRAP clear></WRAP>
-{{ :downloads:competency_matrix-block_rev._01-17-23_.xlsx |"Competency Matrix" template in Excel (01/17/23)}}
+{{ :downloads:competency_matrix-template_rev._11-14-23_.xlsx |"Competency Matrix" template in Excel (11/14/23)}}
 \\
 This free "Competency Matrix" template (in Excel) utilizes "Conditional Formatting" to produce graphical block quadrants. Simply enter a space (for no training required) or number (associated with competency levels identified in the "Key + Instructions" tab) into the desired cell to produce the appropriate block icon.
-This template provides a simple tool to address ISO 9001/AS9100, section 7.2 "Competency".
+This template provides a simple tool to address ISO 9001/AS9100, section 7.2 "Competency". AND it has been verified by multiple auditors as being compliant with ISO 9001, AS9100 & AS9120.
 <WRAP center round info 80%>
@@ Line 70: / Line 70: @@
 Based on the SMART structure, this free "SMART Tasks" template provides a simple tool for management to address ISO 9001/AS9100, sections 9.3.3a (opportunities for improvement) & b (any need for changes to the quality management system). As the "SMART Tasks" template is utilized, it can also be used to address the requirement of ISO 9001/AS9100, sections 9.3.2a (the status of actions from previous management reviews).
-===== "SWOT Analysis" template in Word (11/19) =====
+===== "SWOT Analysis" template in Word =====
 {{ :downloads:swot_template-2_pages.png?nolink&600 |"SWOT Analysis" template in Word (11/19)}}
@@ Line 96: / Line 96: @@
 To use this template, management should review the issues identified... deleting those that are not applicable, modifying those that are applicable (when needed), and using it as a resource, identify other "quality-related" issues that aren't included in the template.
-===== "Unilateral Cp-Cpk Calculator" (2-07-23) =====
+===== "Unilateral Cp-Cpk Calculator" =====
 {{ :downloads:unilateral_cp-cpk_calculator_02-07-23_w-trend_lines.png?direct&600 |"Unilateral Cp-Cpk Calculator w/trend lines" (Excel)}}
 <WRAP clear></WRAP>
-{{ :downloads:unilateral_cp-cpk_calculator_02-07-23_w-trend_lines.xlsx |"Unilateral Cp-Cpk Calculator w/trend lines" (Excel)}}
+{{ :downloads:unilateral_cp-cpk_calculator_02-07-23_w-trend_lines.xlsx |"Unilateral Cp-Cpk Calculator w/trend lines", 2-07-23 (Excel)}}
  \\
@@ Line 147: / Line 147: @@
-===== "Apollo Root Cause Analysis" Worksheet in Word (08-09-2022) =====
+===== "Apollo Cause & Effect" Chart in Word (03-19-2023) =====
-{{ :downloads:arca_worksheet-2022.png?direct&600 |"Apollo Root Cause Analysis" Worksheet in Word}}
+{{ :downloads:apollo_ace_chart_03-19-23_.png?direct&600 |"Apollo Cause & Effect" (ACE) Chart in Word}}
 <WRAP clear></WRAP>
+{{ :downloads:apollo_ace_chart_03-19-23_.docx |"Apollo Cause & Effect" (ACE) Chart (Word)}}
-{{ :downloads:arca_worksheet-2022.docx |"Apollo Root Cause Analysis" Worksheet (Word)}}
  \\
-The "[[https://www.apollorootcause.com/page/about/apollo-root-cause-analysis-method|Apollo Root Cause Analysis (ARCA)]]” methodology focuses on the concept that both a “//Condition//” and an “//Action//” must exist and come together to create (cause) an “//Event//”. A "Apollo Root Cause Analysis" Worksheet (aka "//[[https://www.apollorootcause.com/icms_docs/292146_example-realitychart.pdf|Reality Charts]]//") typically differentiates “//Conditions//” from “//Actions//” by color-coding the boxes describing each. While there are several commercial software applications for creating "Apollo Root Cause Analysis" charts, these can be expensive... and their limited use doesn't justify the cost.
+The "[[https://www.youtube.com/watch?v=kmQEClQ16ec|Apollo Root Cause Analysis (ARCA)]]" methodology (described in the book [[https://www.amazon.com/Apollo-Root-Cause-Analysis-Thinking/dp/1883677114/ref=sr_1_2 |"Apollo Root Cause Analysis: A New Way of Thinking"]] by Dean L. Gano) focuses on the concept that both a “//Condition//” and an “//Action//” must exist and come together to create (cause) an “//Event//”. An "Apollo Cause and Effect" Chart (aka "//[[https://www.apollorootcause.com/icms_docs/292146_example-realitychart.pdf|Reality Chart]]//") typically differentiates “//Conditions//” from “//Actions//” by color-coding the boxes describing each. While there are several commercial software applications for creating "Apollo Cause and Effect" charts, these can be expensive... and their limited use doesn't justify the cost.
-This "Apollo Root Cause Analysis" Worksheet was created using the SmartArt feature within Microsoft Word, thus providing an inexpensive (and likely readily available) tool for creating your own ARCA charts.
+This "Apollo Cause and Effect" (ACE) Chart template was created using the SmartArt feature within Microsoft Word, thus providing an inexpensive (and likely readily available) tool for creating your own ACE charts.
 <WRAP center round info 80%>
-Unfortunately, like many legacy quality management tools, "Apollo Root Cause Analysis" assumes that if a problem is well enough defined, the solution is obvious. As more sophisticated quality professionals understand, this is only true of simple problems. Actual problem-solving should involve TRIZ. However, I do find the ARCA methodology a useful tool for defining the "Cause and Effect Chain (CEC)... which can then be used for "causal analysis". While it is certainly superior to the "5 Whys", I find the ARCA tool appropriate for focusing on a single or very few issues. And a "Fishbone Chart" more appropriate for broader issues. Of course, the ARCA & Fishbone chart concepts can be combined.
+Unlike other legacy quality management tools (e.g., "5 Whys"), "Apollo Root Cause Analysis" recognizes that the term "root cause" is a misnomer. While its creator (Dean L. Gano) claims that there are an infinite number of causes... thus prohibiting a "root cause" from ever being identified, I would posit that identifying a "root cause" is possible, but extraordinarily rare. One of the core concepts of "Apollo Root Cause Analysis" is to identify as many causes as possible and try to develop ways to eliminate or mitigate as many of them as possible. Ultimately, the purpose of "corrective action" is to prevent the "recurrence" of a nonconformity... not to identify the //mythical// "root cause".
+While I like this approach, it still falls short in the area of actual problem-solving because it assumes that if enough "causes" are eliminated, the problem will eventually reach a point of acceptability. And this is logical. However, "Apollo Root Cause Analysis" becomes significantly more effective when used in conjunction with TRIZ. However, I do find the ARCA methodology a highly useful tool for "Cause and Effect" Analysis. While it is certainly superior to other methodologies.
+</WRAP>
+<WRAP center round tip 80%>
+If you're considering a class in Root Cause Analysis, don't waste your money on learning flawed concepts. Instead, check out the [[https://www.apollorootcause.com/page/about/apollo-root-cause-analysis-method|Apollo Root Cause Analysis Training Courses]] (available in-person OR online).
 </WRAP>
@@ Line 190: / Line 194: @@
 ===== "DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080) =====
-[{{:dpmo-sigma_conversion_wallpaper.png?direct&600 |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}}]
+{{:dpmo-sigma_conversion_wallpaper.png?direct&600 |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}}
 <WRAP clear></WRAP>
 {{:dpmo-sigma_conversion_wallpaper.png?linkonly |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}} \\