Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
downloads [2023/04/28 10:02] – ["SWOT Analysis" template in Word (11/19)] rrandalldownloads [2024/01/23 20:03] (current) – ["Competency Matrix" template in Excel] rrandall
Line 19: Line 19:
 </WRAP> </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> <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 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%> <WRAP center round info 80%>
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. 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)}} {{ :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> <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 159: Line 159:
  
 <WRAP center round info 80%> <WRAP center round info 80%>
-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. This is a __much__ more realistic approach than "corrective action".+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. 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.
Line 194: Line 194:
 ===== "DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080) ===== ===== "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> <WRAP clear></WRAP>
 {{:dpmo-sigma_conversion_wallpaper.png?linkonly |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}} \\ {{:dpmo-sigma_conversion_wallpaper.png?linkonly |"DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080)}} \\