Levey Jennings Template in Excel

Healthcare labs use the Levey Jennings charts to monitor key measures of health like cholesterol and glucose.

Example of a QI Macros Levey Jennings Control Chart Template in Excel

Example of QI Macros Levey Jennings Chart Excel template

The template opens to the standard Levey Jennings chart. However, there are several other template options including percent, target and fixed standard deviation charts.

levey-jennings-template-tabs

Here is how each Levey Jennings Control Chart Template works

Chart Center Line Sigma Lines Input Area
Levey Jennings 1-Chg Calculated from the data

Calculated from the data and drawn at 1, 2 and 3 standard deviations

process change
Levey Jennings Percent Calculated from the data

Default draws sigma lines at 10, 20, and 30% from the center line.

Percentages can be changed using the drop down menu.

Levey Jennings Target

Calculated from the data but can be overridden by inputting a different value in the Target cell

Default draws sigma lines at 5, 10 and 15% from the center line.

Percentages can be changed using the drop down menu.

Levey Jennings Fixed Stdev

Calculated from the data but can be overridden by inputting a different value in the Center Line cell

Calculated from the data but can be overridden by inputting a different value in the Stdev cell


 

Note: According to SOFT / AAFS FORENSIC TOXICOLOGY LABORATORY GUIDELINES 9.1.12, standard deviation may represent an unacceptably large percentage deviation from the mean. Therefore, a realistic percentage deviation should be used, such as ±20% or ±30%. This option is available in the Levey Jennings Percent template and the Percent Macro.

 

Learn More...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $279 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free