Differences

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

--- downloads [2019/11/08 11:37] – [Metrological (Calibration) Confirmation / Verification Procedures] 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) =====
+{{ :downloads:as9100-qms_awareness_training_5-22_1st_slide.png?nolink&600 |"AS9100-QMS Awareness Training" template (PowerPoint)}}
+<WRAP clear></WRAP>
+{{ :downloads:as9100-qms_awareness_training_7-22_.pptx |"AS9100-QMS Awareness Training" template (PowerPoint)}}
+\\
+This free "AS9100-QMS Awareness Training" template (PowerPoint) provides a solid basis for training your employees in AS9100 sec. 7.3 "Awareness" along with a brief introduction to AS9100. While only 21 slides, this short presentation also covers the redundant "communication" requirements contained in AS 9100, sec. 5.1.1f, 5.2.2b, 5.3 & 6.2f. Further, this "AS9100-QMS Awareness Training" template also includes an "Ethics Policy"; required to qualify for compliance with the optional [[:articles:pbs_rp_program|AS9100 - The Performance-based Surveillance/Recertification (PBS/RP) Program]]. \\
+The only things that you need to add to this PowerPoint are your:
+  - Company Quality Policy (Slide # 7)
+  - Company Quality Objectives (Slide # 8)
+  - Company High-Level Organization Chart (Slide # 10)
+  - Management Representative (Slide # 11)
+<WRAP center round info 80%>
+Most companies associate their "Quality Objectives" with "KPIs" (Key Performance Indicators) because managers are more familiar and comfortable with that term. However, managers tend to interpret KPIs as broadly encompassing many different aspects of the business (e.g., financial performance, health, safety, environmental). In reality, a more "specific" term would be "__Quality Performance Indicators__". Use of this term would "remind" management that these performance indicators must remain within the scope of the "Quality Management System".
+</WRAP>
+===== "Competency Matrix" template in Excel =====
+{{ :downloads:competency_matrix-template_11-14-23.png?direct&600 |"Competency Matrix" template in Excel}}
+<WRAP clear></WRAP>
+{{ :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". AND it has been verified by multiple auditors as being compliant with ISO 9001, AS9100 & AS9120.
+<WRAP center round info 80%>
+For AS9100 series companies, this "Competency Matrix" is considered equivalent to the IAQG SCMH-7.13.3 "Competency Management Template and Example", Rev-A Dated-27NOV2020.
+</WRAP>
+Aerospace-specific training topics to consider include:
+  * [[https://www.sae.org/standards/content/as9102b/|AS9102B Aerospace First Article Inspection Requirement]]
+  * [[https://www.sae.org/standards/content/as9146/|AS9146 FOD Prevention Program]]
+  * [[https://www.sae.org/standards/content/as5553d/|AS5553 Counterfeit Electrical, Electronic, and Electromechanical (EEE) Parts; Avoidance, Detection, Mitigation, and Disposition]]
+  * [[https://www.sae.org/standards/content/as6081/|AS6081 Fraudulent/Counterfeit Electronic Parts: Avoidance, Detection, Mitigation, and Disposition - Distributors]]
+  * [[https://www.sae.org/standards/content/as13000/|AS13000 Problem Solving Requirements for Suppliers]] (Use of the 8D form)
+  * [[https://www.sae.org/standards/content/as13003/|AS13003 Measurement Systems Analysis Requirements for the Aero-Engine Supply Chain]]
+  * [[https://www.sae.org/standards/content/as13004/|AS13004 Process Failure Mode and Effects Analysis (PFMEA) and Control Plans]]
+In addition, this "Competency Matrix" template includes a different sheet (tab) for tracking recurring certifications (e.g., IPC J-Std-001, AWS Certified Welders) and recording Fork Lift Operator Qualifications (Ref. 29 CFR § 1910.178(L) for specific requirements).
+<WRAP center round important 80%>
+Remember to regularly update your "Competency Matrix" as staff adds to their competency.
+</WRAP>
+===== "SMART Tasks" template in Word (10/21) =====
+{{ :downloads:smart_tasks_-_template_10-01-21_screen_shot.png?direct&600 |"SMART Tasks" template in Word (10/21)}}
+<WRAP clear></WRAP>
+{{ :downloads:smart_tasks-template_10-01-21_.doc |"SMART Tasks" template in Word (10/21)}}
+\\
+S.M.A.R.T. is a mnemonic acronym, that provides criteria to guide in the setting of goals and objectives for better results. The first known use of the term appeared in the November 1981 issue of "//Management Review//" by [[https://www.projectsmart.co.uk/smart-goals/brief-history-of-smart-goals.php|George T. Doran]]. While there are several minor variations on the acronym, Doran's original definition was: \\
+**S**pecific: target a specific area for improvement. \\
+**M**easurable: quantify, or at least suggest, an indicator of progress. \\
+**A**ssignable: specify who will do it. \\
+**R**ealistic: state what results can realistically be achieved given available resources. \\
+**T**ime-related: specify when the result can be achieved. \\
+This template adds clarity to how the S.M.A.R.T. concept is to be applied through the use of a form.  For example, many users struggled with how to answer "Assignable". Some would simply say "Yes" in the form. But, as Dorian explained, the point is to actually assign the task to a person or team. And it is important to obtain the agreement; because "assigning" a task to someone who does not agree (or accept) the task (e.g., due to their lack of confidence in its success) is a certain path to failure. Tasks should only be assigned to personnel who "agree" to accept the task. \\
+Similarly, I've changed **R**ealistic to **R**esourced in the form; because again, some users would simply say "Yes". However, as Doran explained, if a task is not properly resourced, then it is unrealistic to expect success. Using the word **R**esourced instead of **R**ealistic in the form prompts users to ensure that the task is properly "resourced". \\
+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 =====
+{{ :downloads:swot_template-2_pages.png?nolink&600 |"SWOT Analysis" template in Word (11/19)}}
+<WRAP clear></WRAP>
+{{ :downloads:swot_analysis_template.docx |"SWOT Analysis" template in Word (11/19)}}
+\\
+This free "SWOT Analysis" template (in Word) provides a simple tool for management to address ISO 9001/AS9100, sections:
+  * 4.1 (as talking points to describe "//external and internal issues that are relevant to its purpose and its strategic direction and that affect its ability to achieve the intended result(s) of its quality management system.//"), and
+  * 9.3.2b (a "Management Review" record of any "//changes in external and internal issues that are relevant to the quality management system.//")
+<WRAP center round important 80%>
+Remember to update your SWOT Analysis annually... in preparation for, or with results from, Management Review Meetings.
+</WRAP>
+A SWOT (**S**trengths-**W**eaknesses-**O**pportunities-**T**hreats) Analysis presents a four-quadrant representation of both internal and external issues facing an organization. A SWOT Analysis is most often used by management to provide an all-encompassing assessment of a business (inclusive of Marketing, Sales, Production, HR, etc.).
+<WRAP center round info 80%>
+While many of the examples in the provided SWOT template go beyond those external and internal issues that affect the organization's //"ability to achieve the intended result(s) of its __quality management system__"//, the additional examples were provided because managers are most familiar with the "all-inclusive" approach toward a SWOT Analysis... and often struggle with differentiating the broader "business" issues from the more focused "quality-related" issues. If management is able to make that differentiation, then the examples contained in the template can be reduced to only those issues that are truly quality-related. \\
+However, since ISO 9001/AS9100, sec. 4.1 "Understanding the Organization and Its Context" states: "//The __ORGANIZATION shall determine__ external and internal issues...//", as long as management identifies //some// external and internal issues, there are (generally) no wrong answers when responding to this requirement. Recognizing this, most ISO 9001/AS9100 auditors accept virtually ANY answer provided as satisfying this requirement.
+</WRAP>
+The SWOT analysis provided above is different from a basic/traditional SWOT in that it has a column along the left side (in grey) identifying the top two quadrants (**S**trengths & **W**eaknesses) as "internal" issues and the bottom two quadrants (**O**pportunities & **T**hreats) as "external" issues. In addition, it identifies the "**W**eaknesses" & "**T**hreats" quadrants as representing //negative// risks. And the "**O**pportunities" quadrant as representing //positive// risks. The concept of positive and negative risks is prevalent in many business situations (particularly when concerning financial decisions). However, both the quality & safety professions adhere to the etymology of the word "risk" as always being negative (having negative consequences or impacts).
+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" =====
+{{ :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", 2-07-23 (Excel)}}
+ \\
+You're probably wondering "why" you would need a unilateral Cp-Cpk calculator when your company is probably not utilizing any Control Charts.
+Quite simply, this unilateral Cp-Cpk calculator is designed for you to track trends in your KPIs & "Quality Objectives".
+Both ISO 9001 & the AS91xx series require users to identify "Quality Objectives" (6.2) and, during "Management Review" (9.3.2), to "consider": \\
+//c. information on the performance and effectiveness of the quality management system, including __trends__ in: \\
+. the extent to which quality objectives have been met;//
+By entering the data associated with each of your KPIs into this "Process Capability" chart, it will automatically calculate the associated Cp & Cpk. Why should you care? Because IF the process associated with the KPI is NOT capable of achieving the "Quality Objective" determined by management, then the chart will identify this AND provide a basis for management to adjust the "Quality Objective" to one that can actually be achieved!
+While the "objective" is a necessary non-value-added component, the true value of understanding the process capability is that this data allows management to better identify where to focus resources in order to improve each process. In addition, this chart can be used to detect seasonal variations and as an “early detection” tool for identifying unfavorable trends.
+<WRAP center round info 80%>
+Anyone familiar with [[https://deming.org/explore/fourteen-points/|"Demings 14 Points"]] is aware that ISO 9001 and the AS91xx series ignore Demings Point 11b. "//Eliminate management by objective. Eliminate management by numbers, numerical goals. Substitute leadership.//" \\
+The primary reasons that Deming opposed "management by objective" are: \\
+  - The "objectives" are typically driven by emotion rather than data, are often outside of the process's capability... and are therefore unachievable. This results in the workers being blamed rather than management focusing on improving the processes.
+  - When an "objective" is achieved, management celebrates success (e.g., the pizza party), losing sight of the true goal... which is continual improvement.
+During Deming's time, the concept of a "Quality Management System" was in its infancy. Today, we have Lean, Six Sigma, Lean Six Sigma (a combination of the two) & [[https://triz.org/what-is-triz/|TRIZ]]. While these methodologies greatly increase the opportunities for "real" improvements, I remain critical of Deming (and ISO) for not recognizing process "optimization". If the process is consistently satisfying all customer requirements (e.g., at or better than 6 Sigma levels)... and the customer is not willing to pay more for a product exceeding their requirements, then continually "improving" that process "might" yield no further benefit. Granted, the VAST majority of companies are nowhere near "optimization".
+</WRAP>
+<WRAP center round tip 80%>
+For more information on Unilateral Process Capability Index Charts, read: "[[https://sage-answer.com/what-is-cp-and-cpk-for-unilateral-tolerance/|What is Cp and Cpk for unilateral tolerance?"]]
+</WRAP>
+===== "Risk Assessment with Column Chart" template in Excel (6-15-2022) =====
+{{ :downloads:risk_assessment-column_chart-template_excel-06-18-22_screen_shot.png?direct&600 |"Risk Assessment with Column Chart" Template (Excel)}}
+<WRAP clear></WRAP>
+{{ :downloads:risk_assessment-column_chart-template_excel-06-18-22.xlsx |"Risk Assessment - with Column Chart" Template (Excel)}}
+ \\
+This "Risk Assessment with Column Chart" template (Excel) includes a tab for each of your "key" processes. And allows you to identify up to 9 process risks. Then assign a point score (0-5) for the likelihood (probability) and "Consequences" (Impact) of each risk. These two scores ("Likelihood" and "Consequences") will automatically be multiplied to produce a "Risk Level" (between 0 and 25). The "Column" chart will automatically update; reflecting the initial "Risk Level" beside the //new// Risk Level" (If additional risk actions were implemented). IF you don't like the column chart, the light blue tab excludes the column chart... and expands the number of risks that can be identified to 35. This template includes instructions for its use.
+<WRAP center round important 80%>
+Reference the "Instructions" tab in the "Risk Assessment" for information on how to use this form to satisfy the requirements of ISO 9001/AS 9100, sec. 9.3.2e & AS 9100, sec. 9.3.3d through referencing it in your Management Review Meeting Minutes.
+</WRAP>
+<WRAP center round info 80%>
+You may wonder why I didn't use a standard FMEA (Failure Modes and Effects Analysis). I avoided the FMEA structure because "Detection" is not a part of the definition of "risk". "Detection" is actually a measure of the effectiveness of a specific type of risk mitigation control. Therefore, including "Detection" as a part of the RPN (Risk Priority Number) distorts the "actual" risk level. However, if you prefer using a FMEA, ASQ provides a free [[https://asq.org/quality-resources/fmea|FMEA template]].
+</WRAP>
+===== "Apollo Cause & Effect" Chart in Word (03-19-2023) =====
+{{ :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)}}
+ \\
+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 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%>
+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>
+===== "Risk-Based Audit Planning Criteria" template in MS Word (08/22) =====
+{{:downloads:risk-based_audit_planning_criteria_2022_.png?direct&400 |Risk-Based Audit Planning Criteria" template in MS Word (08/22)}}
+{{ :downloads:risk-based_audit_planning_criteria_2022_.docx |"Risk-Based Audit Planning Criteria" template in MS Word (08/22)}}
+This free "Risk-Based Audit Planning Criteria" form (in MS Word) provides a series of basic questions to determine the "risks" that should be "considered" when scheduling an internal audit.
+This form provides a way to address one of the new [[articles:ocap|AS9104/1A, OCAP requirements]] (reducing your organizational risk as determined by your CB). The criteria for having a "low risk" internal audit program includes:
+  * Properly resourced audit program
+  * Multi-event audit program, audit full QMS annually
+  * __Audit program driven by risk and data__
+  * Effective corrective action program
+For a more detailed discussion on risk-based auditing, read my article [[articles:risk-based_audits|"Risk-Based Internal Audits"]].
+<WRAP clear></WRAP>
+===== "Calibration Recall" template Excel (5-5-2018) =====
+{{:calibration_recall_screenshot.png?direct&600 |Calibration Recall template screenshot}}
+<WRAP clear></WRAP>
+{{ :calibration_recall_template-excel-5-5-2018.xls |"Calibration Recall" template Excel (5-5-2018)}} \\
+This simple Excel-based "Calibration Recall" template is designed for small companies (with under 150 instruments under calibration control) to comply with ISO 9001:2015 & AS9100D. It uses Color-coded "Conditional Cell Formatting" for visual management.
+===== "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)}} \\
+This is a "DPMO-Sigma-Yield-Cpk Conversion Table" with a black background, suitable for use as computer desktop wallpaper. The PNG image provides a quick reference to convert Yields to DPMOs to Sigma levels (Short Term & Long Term) as well as Cpk. This chart covers a range of 3.50 to 6.00 Sigma Short Term (Z<sub>ST</sub>). And the row at 4.00 Sigma Short Term (Z<sub>ST</sub>) is highlighted in light green to indicate a minimum acceptable process capability of 1.33 Cpk.
+----
 ===== Metrological (Calibration) Confirmation / Verification Procedures =====
@@ Line 12: / Line 213: @@
 {{ :metrology:t.o._33k6-4-2930-1-calibration_procedure_for_manually_operated_torque_wrenches-general.pdf|T.O. 33k6-4-2930-1, Calibration Procedure for Manually Operated Torque Wrenches 6% to 20% - General (30 September 2002 with Change 4, 30 May 2005) Size=99k}}
+{{ :metrology:to_33k6-4-3014-1_calibration_procedure_for_torque_screwdrivers.pdf |T.O. 33K6-4-3014-1, "Calibration Procedure for Torque Screwdrivers - General" (30 July 2005) Size=94k}}
+<WRAP center round info 80%>
+Torque tool users may also find {{ :metrology:to_32b14-3-1-101_operation_and_service_instructions_torque_indicating_devices.pdf |TO 32B14-3-1-101 "Technical Manual - Operation and Service Instructions Torque Indicating Devices"}} to be beneficial.
+</WRAP>
 {{ :metrology:t.o._33k6-4-427-1_calibration_procedure_for_pressure-gauge.pdf |T.O. 33k6-4-427-1, Calibration Procedure for Pressure Gauge (30 May 2012) Size=101k}}
 {{ :metrology:t.o._33k5-4-42-1-calibration_procedure_for_thermometers.pdf |T.O. 33k5-4-42-1, Calibration Procedure for Thermometers (30 January 2006) Size=60k}}
+----
 Federal Specifications, section 4, "Quality Assurance Provisions", addresses methodologies for calibration:
@@ Line 30: / Line 239: @@
 {{ :metrology:ggg-r-791h-measuring_rules.pdf |GGG-R-791H, Federal Specification: Measuring Rules (19 July 1994) Size=993k}}
-===== "SWOT & Strategic Risk Assessment Bubble Chart" template in Excel (8-12-2018) =====
-[{{:swot_and_strategic_risk_analysis-template-excel-8-12-2018_screenshot.png?nolink&600|SWOT & Strategic Risk Assessment Bubble Chart (Excel)}}]
-<WRAP clear></WRAP>
+{{ :metrology:ggg-t-106f-federal_specification-tape_measuring_general_use_.pdf |GGG-T-106F, Federal Specification: Tape, Measuring (General Use) (April 12, 1993) Size=3.2M}}
-{{ :swot_and_strategic_risk_analysis-template-excel-8-12-2018.xlsx |SWOT & Strategic Risk Assessment Bubble Chart (Excel)}} \\
-The "SWOT & Strategic Risk Assessment Bubble Chart" template (Excel)" is based on the guidance provided from ISO 31000:2018, "Risk management — Principles and guidelines". Use the SWOT to help identify up to 9 strategic risks. Then assign a point score (0-10) for the likelihood (probability) and "Consequences" (Impact) of each risk. These two scores ("Likelihood" and "Consequences") will automatically be added to produce a "Risk Level" (between 1 and 10). And the "Bubble" chart will automatically update; reflecting the "Risk Level" both in location and size of the bubbles. The template also includes a "Risk Treatment Plan" (as per ISO 31000:2009, section 6.4). This template includes instructions for its use.
-===== "Process Risk Assessment Bubble Chart" template in Excel (8-12-2018) =====
+----
-[{{:process_risk_management-bubble_chart_template-excel-8-12-2018_screenshot.png?nolink&600 |Process Strategic Risk Assessment Bubble Chart (Excel)}}]
-<WRAP clear></WRAP>
+The [[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/rockmanual.html#9300|"Technical Service Center"]] for the "U.S. Department of the Interior Bureau of Reclamation" also has several publically available calibration procedures. Some of their most popular calibration procedures are:
-[{{ :process_risk_management-bubble_chart_template-excel-8-12-2018.xlsx?linkonly |Process Risk Assessment Bubble Chart (Excel)}} \\
-The "Process Risk Assessment Bubble Chart" template (Excel)" is based on the guidance provided from ISO 31000:2018, "Risk management — Principles and guidelines". Identify up to 9 risks in a process. Then assign a point score (0-5) for the likelihood (probability) and "Consequences" (Impact) of each risk. These two scores ("Likelihood" and "Consequences") will automatically be added to produce a "Risk Level" (between 1 and 10). And the "Bubble" chart will automatically update; reflecting the "Risk Level" both in location and size of the bubbles. The template also includes a "Risk Treatment Plan" (as per ISO 31000:2018, section 6.4). This template includes instructions for its use.
-===== "Calibration Recall" template Excel (5-5-2018) =====
+[[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/tan_earthmanualUSBR/USBR1000.pdf |USBR 1000-89, "Procedure for Standards for Linear Measurement Devices"]]
-{{:calibration_recall_screenshot.png?direct&600 |Calibration Recall template screenshot}}
+[[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/tan_earthmanualUSBR/USBR1007.pdf|USBR 1007-89, "Procedure for Calibrating Dial Indicators"]]
-<WRAP clear></WRAP>
-{{ :calibration_recall_template-excel-5-5-2018.xls |"Calibration Recall" template Excel (5-5-2018)}} \\
-This simple Excel-based "Calibration Recall" template is designed for small companies (with under 150 instruments under calibration control) to comply with ISO 9001:2015 & AS9100D. It uses Color-coded "Conditional Cell Formatting" for visual management.
-===== "DPMO-Sigma-Yield-Cpk Conversion Table Wallpaper" (1920x1080) =====
+[[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/tan_earthmanualUSBR/USBR1012.pdf|USBR 1012-89, "Procedure for Calibrating Balances or Scales"]]
+[[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/tan_earthmanualUSBR/USBR1020.pdf |USBR 1020-89, "Procedure for Calibrating Ovens"]]
+[[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/tan_earthmanualUSBR/USBR1040.pdf |USBR 1040-89, "Procedure for Calibrating Pressure Gauges"]]
+[[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/tan_earthmanualUSBR/USBR1045.pdf |USBR 1045-89, "Procedure for Calibrating Force Transducers (Load Cells)"]]
+[[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/tan_earthmanualUSBR/USBR1050.pdf |USBR 1050-89, "Procedure for Calibrating Pressure Transducers"]]
+[[https://www.usbr.gov/tsc/techreferences/mands/rockmanual/tan_earthmanualUSBR/USBR1055.pdf |USBR 1055-89, "Procedure for Calibrating Differential Pressure Transducers"]]
+----
+For calibrating most weighing scales, refer to [[https://www.nist.gov/pml/weights-and-measures/publications/nist-handbooks/other-nist-handbooks/other-nist-handbooks-0|NIST Handbook 44]], section 2.20, subsection N.1.1, "Test Procedures".
+For calibrating Stopwatches & Timers, refer to "NIST Special Publication 960-12", sec. 5; available online at: [[https://tsapps.nist.gov/publication/get_pdf.cfm?pub_id=50659|Stopwatch and
+Timer Calibrations (2009 edition)]]
+For calibrating (verifying) hydrometers, refer to: [[https://www.astm.org/Standards/E126.htm|ASTM E 126, "Standard Method for Inspection and Verification of Hydrometers"]].
+For calibrating volumetric glassware, refer to [[https://www.astm.org/Standards/E456.htm|ASTM E 456, "Standard Practice for Calibration of Laboratory Volumetric Apparatus"]].
+For calibrating (verifying) Rockwell Hardness Testers, refer to: [[https://www.astm.org/Standards/E18.htm|ASTM E 18, "Standard Test Methods for Rockwell Hardness of Metallic Materials"]].
+For calibrating (verifying) Wire Cloth Sieves, refer to: [[https://www.astm.org/Standards/E11.htm|ASTM E 11, "Standard Specification for Wire-Cloth Sieves for Testing Purposes"]], Appendix X1, "Methods of Checking Wire Cloth Sieves to Determine Whether they Conform to Specifications".
-[{{: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)}} \\
-This is a "DPMO-Sigma-Yield-Cpk Conversion Table" with a black background, suitable for use as computer desktop wallpaper. The PNG image provides a quick reference to convert Yields to DPMOs to Sigma levels (Short Term & Long Term) as well as Cpk. This chart covers a range of 3.50 to 6.00 Sigma Short Term (Z<sub>ST</sub>). And the row at 4.00 Sigma Short Term (Z<sub>ST</sub>) is highlighted in light green to indicate a minimum acceptable process capability of 1.33 Cpk.